SELECT items.id FROM `items` FORCE INDEX(index_items_on_parent_category_id, index_items_on_recommended_in_category_at) WHERE (items.parent_category_id=10000) ORDER BY items.recommended_in_category_at DESC, items.id DESC LIMIT 0, 20;
SELECT items.id FROM `items` FORCE INDEX(index_items_on_parent_category_id, index_items_on_recommended_in_category_at) WHERE (items.parent_category_id=10000) ORDER BY items.recommended_in_category_at DESC, items.id DESC LIMIT 0, 20;