"Back"

SQL Explain

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '42') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '42') AND (`at_is_active`.`store_id` = 1) INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '67') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '67') AND (`at_include_in_menu`.`store_id` = 1) LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='1' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('66', '67', '161', '69', '164', '167', '168', '169', '170', '70', '71', '173', '171', '201', '223', '224', '230', '231', '238', '174', '202', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '204', '205', '206', '212', '216', '217', '218', '219', '220', '221', '222', '225', '226', '227', '228', '229', '237', '239', '240', '211', '15', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '3', '57', '60', '214', '213', '215', '58', '59', '61', '62', '29', '30', '38', '37', '34', '39', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '117', '118', '121', '122', '123', '124', '125', '126', '127', '128', '119', '129', '130', '131', '120', '132', '133', '134', '111', '113', '114', '116', '115', '112', '135', '136', '138', '139', '137', '140', '141', '142', '143', '144', '145', '244', '245', '248', '249', '250', '246', '251', '252', '247', '253', '254', '255', '257', '258', '146', '147', '150', '189', '190', '191', '233', '234', '151', '192', '193', '194', '232', '235', '236', '260', '148', '152', '153', '195', '196', '197', '162', '154', '155', '157', '198', '199', '156', '200', '158', '163')) AND (`e`.`entity_id` NOT IN('58', '59', '61', '62', '112', '175', '199', '255')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1')
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE at_is_active_default ref IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID 2 const 176 Using where
1 SIMPLE e eq_ref PRIMARY PRIMARY 4 lalacurio_magn.at_is_active_default.entity_id 1 Using where
1 SIMPLE at_is_active index_merge IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID 2,2 1 Using intersect(IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID); Using where; Using join buffer (Block Nested Loop)
1 SIMPLE at_include_in_menu index_merge IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID 2,2 1 Using intersect(IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID); Using where; Using join buffer (Block Nested Loop)
1 SIMPLE at_include_in_menu_default ref IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID 4 lalacurio_magn.at_is_active_default.entity_id 3 Using where
1 SIMPLE core_url_rewrite ref UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID,IDX_CORE_URL_REWRITE_ID_PATH,IDX_CORE_URL_REWRITE_STORE_ID,FK_CORE_URL_REWRITE_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID FK_CORE_URL_REWRITE_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID 5 lalacurio_magn.at_is_active_default.entity_id 29 Using where