Pastey.net - paste bin

Language:

SQL/MySQL Change language:

Pastebin:

Author:

Kynlem

Subject:

Untitled

Created:

2007-07-09 22:17:00

	#2: EXPLAIN SELECT `Visit`.`id`, `Block`.`start_ip`, `Block`.`end_ip`, `Block`.`location_id` FROM `blocks` AS `Block` INNER JOIN `visits` AS `Visit` ON (`Visit`.`ip` BETWEEN `Block`.`start_ip` AND `Block`.`end_ip`) WHERE `Visit`.`user_id` = 5 AND `Visit`.`vtime` > 1184033067

	id select_type table type possible_keys key key_len ref rows Extra
	1 SIMPLE Visit ALL 411 Using where
	1 SIMPLE Block ALL block_ip 2961005 Range checked for each record (index map: 0x2)

	#2: DESC visits

	Field Type Null Key Default Extra
	id bigint(20) NO PRI auto_increment
	ip int(11) NO
	user_id int(11) NO
	vtime int(11) NO

	#3: DESC blocks

	Field Type Null Key Default Extra
	id bigint(20) NO PRI auto_increment
	start_ip bigint(20) NO MUL
	end_ip bigint(20) NO
	location_id int(11) NO


1	SELECT `Visit`.`id`, `Block`.`start_ip`, `Block`.`end_ip`, `Block`.`location_id`
2	FROM `blocks` AS `Block`
3	INNER JOIN `visits` AS `Visit`
4	ON (`Visit`.`ip` BETWEEN `Block`.`start_ip` AND `Block`.`end_ip`)
5	WHERE `Visit`.`user_id` = 5 AND `Visit`.`vtime` > 1184033067

Thread:

[70579] Untitled by Kynlem at 2007-07-09 22:17:00

[70580] Re: Untitled by Kynlem at 2007-07-09 22:21:44 (diff)

[82474] ayxmjqwb zcfdlmy by xhcfe sencjapgh at 2008-02-17 06:45:34 (diff)

Tip: Click the line numbers to toggle highliting on that line.

Language:
Author:
Subject:
Secure the url for this pastey.

Tabstop: bigger biggest

Note: You can prefix a line with "@@@" to highlight it.