"Back"

SQL Explain

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
SELECT `a`.`attribute_id`, `t`.* FROM `eav_attribute` AS `a` INNER JOIN `eav_entity_type` AS `t` ON a.entity_type_id = t.entity_type_id WHERE (entity_type_code = :catalog_category) AND (attribute_code = :is_active)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t ref PRIMARY,IDX_EAV_ENTITY_TYPE_ENTITY_TYPE_CODE IDX_EAV_ENTITY_TYPE_ENTITY_TYPE_CODE 152 const 1 Using index condition
1 SIMPLE a ref UNQ_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE,IDX_EAV_ATTRIBUTE_ENTITY_TYPE_ID UNQ_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE 770 lalacurio_magn.t.entity_type_id,const 1 Using where; Using index