Create a new bin
Language:
SQL/MySQL     Change language:
Pastebin: 70580
Author: Kynlem
Subject: Re: Untitled
Created: 2007-07-09 22:21:44
Download and save
Toggle line numbers
1#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 
2 
3id  select_type table   type    possible_keys   key key_len ref rows    Extra 
41   SIMPLE  Visit   ALL                 411 Using where 
51   SIMPLE  Block   ALL block_ip                2961005 Range checked for each record (index map: 0x2) 
6 
7#2: DESC visits 
8 
9Field   Type    Null    Key Default Extra 
10id  bigint(20)  NO  PRI     auto_increment 
11ip  int(11) NO 
12user_id int(11) NO 
13vtime   int(11) NO 
14 
15#3: DESC blocks 
16 
17Field   Type    Null    Key Default Extra 
18id  bigint(20)  NO  PRI     auto_increment 
19start_ip    bigint(20)  NO  MUL 
20end_ip  bigint(20)  NO 
21location_id int(11) NO 
22 
23 
Thread:
[70579] Untitled by Kynlem at 2007-07-09 22:17:00 (diff)
  [70580] Re: Untitled by Kynlem at 2007-07-09 22:21:44
    [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.

Paste followup:

Language:
Author:
Subject:


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