"Back"

SQL Explain

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
SELECT `main_table`.*, `additional_table`.*, IF(al.value IS NOT NULL, al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id LEFT JOIN `eav_attribute_label` AS `al` ON al.attribute_id = main_table.attribute_id AND al.store_id = 1 WHERE (main_table.entity_type_id = 4) AND (additional_table.used_in_product_listing = 1)
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE additional_table ref PRIMARY,IDX_CATALOG_EAV_ATTRIBUTE_USED_IN_PRODUCT_LISTING IDX_CATALOG_EAV_ATTRIBUTE_USED_IN_PRODUCT_LISTING 2 const 28
1 SIMPLE main_table eq_ref PRIMARY,UNQ_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE,IDX_EAV_ATTRIBUTE_ENTITY_TYPE_ID PRIMARY 2 lalacurio_magn.additional_table.attribute_id 1 Using where
1 SIMPLE al ref IDX_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID,IDX_EAV_ATTRIBUTE_LABEL_STORE_ID,IDX_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_STORE_ID IDX_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID 2 lalacurio_magn.additional_table.attribute_id 1 Using where