"Back"

SQL Explain

Executed SQL
SELECT `main_table`.*, `additional_table`.*, `entity_attribute`.*, IFNULL(al.value, main_table.frontend_label) AS `store_label` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_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=3) AND (entity_attribute.attribute_set_id = '3') ORDER BY entity_attribute.sort_order ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE entity_attribute ref UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER 2 const 37 Using where
1 SIMPLE additional_table eq_ref PRIMARY PRIMARY 2 lalacurio_magn.entity_attribute.attribute_id 1
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.entity_attribute.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.entity_attribute.attribute_id 1 Using where