"Back"

SQL Explain

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (29, 83, 92)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = 0)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t_d range UNQ_CAT_CTGR_ENTT_VCHR_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID UNQ_CAT_CTGR_ENTT_VCHR_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID 10 6 Using index condition
1 SIMPLE t_s ref IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY_ID 4 lalacurio_magn.t_d.entity_id 5 Using where