All pastes #917943 Raw Edit

Untitled

public text v1 · immutable
#917943 ·published 2008-02-25 20:04 UTC
rendered paste body
mysql> explain SELECT  items.title, link, date, item_date, author, source, comment, guid, items.id, merge_source, source_id, site, media_type, item_md5, content_md5, enclosure_md5, aggregate_md5, items_text.content, enclosures.enclosure FROM items LEFT JOIN feeds USING (feed_id) LEFT JOIN items_text USING (item_id) LEFT JOIN enclosures USING (item_id) WHERE  url_md5_fk IN ('099a720d33301ba510559d6ccc44acd7','a462034cf3109a724e7a3459f32c804c','a9ad665f96ed9fa2246327ad870380d4','6b9621435e5087ea766013ae4c79be76','9b63dd4e207b4d442f3f9e3e6a0c7455','39da4e7f58623d3d6e951fa2577e349a','93bbdc58bc12524d18f7755d9ea88b1c','d067ad645ca7e208b692087b7233b058','69123f1a8aa76bbceb4ecb0b437384dd','3ef018a5a2339e4e42e3c94b98c9a839','d14b494118056ff907e3e2bdbd518213') AND (item_id >= first_item_id )  ORDER BY item_date desc;
+----+-------------+------------+--------+-----------------------------+------------+---------+---------------------+------+----------------------------------------------+
| id | select_type | table      | type   | possible_keys               | key        | key_len | ref                 | rows | Extra                                        |
+----+-------------+------------+--------+-----------------------------+------------+---------+---------------------+------+----------------------------------------------+
|  1 | SIMPLE      | feeds      | range  | PRIMARY,url_md5_fk          | url_md5_fk | 96      | NULL                |   11 | Using where; Using temporary; Using filesort |
|  1 | SIMPLE      | items      | ref    | PRIMARY,item_unq,feed_id_fk | feed_id_fk | 8       | grazr.feeds.feed_id |   67 | Using where                                  |
|  1 | SIMPLE      | items_text | eq_ref | PRIMARY                     | PRIMARY    | 8       | grazr.items.item_id |    1 |                                              |
|  1 | SIMPLE      | enclosures | ref    | item_id                     | item_id    | 8       | grazr.items.item_id |    1 |                                              |
+----+-------------+------------+--------+-----------------------------+------------+---------+---------------------+------+----------------------------------------------+