{{{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 (73, 15, 2)) AND (t_d.attribute_id IN ('58', '61')) AND (t_d.store_id = 0) UNION ALL 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_datetime` AS `t_d` LEFT JOIN `catalog_category_entity_datetime` 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 (73, 15, 2)) AND (t_d.attribute_id IN ('59', '60')) AND (t_d.store_id = 0) UNION ALL 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_text` AS `t_d` LEFT JOIN `catalog_category_entity_text` 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 (73, 15, 2)) AND (t_d.attribute_id IN ('62')) AND (t_d.store_id = 0) UNION ALL 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_int` AS `t_d` LEFT JOIN `catalog_category_entity_int` 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 (73, 15, 2)) AND (t_d.attribute_id IN ('69')) AND (t_d.store_id = 0)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	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	PRIMARY	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
2	UNION	t_d	range	UNQ_CAT_CTGR_ENTT_DTIME_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID	IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID	4		6	Using index condition; Using where
2	UNION	t_s	ref	IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID	IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID	4	lalacurio_magn.t_d.entity_id	1	Using where
3	UNION	t_d	range	UNQ_CAT_CTGR_ENTT_TEXT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_TEXT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_TEXT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_TEXT_STORE_ID	UNQ_CAT_CTGR_ENTT_TEXT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID	10		3	Using index condition
3	UNION	t_s	ref	IDX_CATALOG_CATEGORY_ENTITY_TEXT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_TEXT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_TEXT_STORE_ID	IDX_CATALOG_CATEGORY_ENTITY_TEXT_ENTITY_ID	4	lalacurio_magn.t_d.entity_id	2	Using where
4	UNION	t_d	range	UNQ_CAT_CTGR_ENTT_INT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID	UNQ_CAT_CTGR_ENTT_INT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID	10		3	Using index condition
4	UNION	t_s	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.t_d.entity_id	3	Using where
	UNION RESULT	<union1,2,3,4>	ALL						Using temporary