EXPLAIN SELECT DISTINCT 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 -> INNER 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: pt type: system possible_keys: PRIMARY key: NULL key_len: NULL ref: NULL rows: 1 Extra: *************************** 2. row *************************** id: 1 select_type: SIMPLE table: habari__posts type: const possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: const rows: 1 Extra: 2 rows in set (0.00 sec)