"Back"

SQL Explain

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
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 = 113 OR category_id IS NULL) AND (product_id IN('332')) ORDER BY `category_id` DESC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE core_url_rewrite index_merge 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,IDX_CORE_URL_REWRITE_STORE_ID 5,2 10 Using intersect(FK_CORE_URL_REWRITE_PRODUCT_ID_CATALOG_CATEGORY_ENTITY_ENTITY_ID,IDX_CORE_URL_REWRITE_STORE_ID); Using where; Using filesort