{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}

SELECT COUNT(m.entity_id) FROM `catalog_category_entity` AS `m` LEFT JOIN `catalog_category_entity_int` AS `d` ON d.attribute_id = :attribute_id AND d.store_id = 0 AND d.entity_id = m.entity_id LEFT JOIN `catalog_category_entity_int` AS `c` ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.entity_id = m.entity_id WHERE (m.path LIKE :c_path) AND (IF(c.value_id > 0, c.value, d.value) = :active_flag)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	IDX_CATALOG_CATEGORY_ENTITY_PATH_ENTITY_ID	IDX_CATALOG_CATEGORY_ENTITY_PATH_ENTITY_ID	767		4	Using where; Using index
1	SIMPLE	d	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.m.entity_id	3	Using where
1	SIMPLE	c	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)