"Back"

SQL Explain

Executed SQL
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 (3, 15, 29, 30, 34, 37, 38, 39, 57, 60, 66, 67, 69, 70, 71, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 111, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 150, 151, 152, 153, 154, 155, 156, 157, 158, 161, 162, 163, 211, 213, 214, 215, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 257, 258)) 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 ref 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 2 const 869 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