"Back"

SQL Explain

Executed SQL
SELECT `core_url_rewrite`.`product_id`, `core_url_rewrite`.`request_path` FROM `core_url_rewrite` WHERE (store_id = 1) AND (is_system = 1) AND (category_id = 88 OR category_id IS NULL) AND (product_id IN('522', '399', '398', '397', '396', '395', '394', '393', '392', '391', '400', '401')) ORDER BY `category_id` DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE core_url_rewrite range IDX_CORE_URL_REWRITE_STORE_ID,FK_CORE_URL_REWRITE_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID,FK_CORE_URL_REWRITE_PRODUCT_ID_CATALOG_CATEGORY_ENTITY_ENTITY_ID FK_CORE_URL_REWRITE_PRODUCT_ID_CATALOG_CATEGORY_ENTITY_ENTITY_ID 5 108 Using index condition; Using where; Using filesort