rendered paste bodymysql> 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 | |
+----+-------------+------------+--------+-----------------------------+------------+---------+---------------------+------+----------------------------------------------+