Pastoid

EXPLAIN SELECT of example query

The page you are looking at now is at this URL: http://pastoid.com/bnu

This paste was last updated on January 29, 2009 at 5:21 pm.

Pasted Coderaw

mysql> EXPLAIN SELECT habari__posts.id AS id, habari__posts.slug AS slug, habari__posts.title AS title, habari__posts.guid AS guid, habari__posts.content AS content, habari__posts.cached_content AS cached_content, habari__posts.user_id AS user_id, habari__posts.STATUS AS STATUS, habari__posts.pubdate AS pubdate, habari__posts.updated AS updated, habari__posts.modified AS modified, habari__posts.content_type AS content_type FROM habari__posts LEFT JOIN habari__post_tokens pt ON habari__posts.id= pt.post_id AND pt.token_id IN (35)\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        TABLE: habari__posts
         type: ALL
possible_keys: NULL
          KEY: NULL
      key_len: NULL
          ref: NULL
         rows: 5
        Extra: 
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        TABLE: pt
         type: eq_ref
possible_keys: PRIMARY
          KEY: PRIMARY
      key_len: 8
          ref: habari.habari__posts.id,const
         rows: 1
        Extra: USING INDEX
2 rows IN SET (0.00 sec)
 
 

Toggle wordwrap

Referring DomainHits
Unknown Referer 127
pastoid.com 6
Is this paste spam?
<Hide