"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 = 144 OR category_id IS NULL) AND (product_id IN('464', '465', '466', '467', '474')) 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 70 Using index condition; Using where; Using filesort