"Back"

SQL Explain

Executed SQL
SELECT `main_table`.`entity_type_id`, `main_table`.`attribute_code`, `main_table`.`attribute_model`, `main_table`.`backend_model`, `main_table`.`backend_type`, `main_table`.`backend_table`, `main_table`.`frontend_model`, `main_table`.`frontend_input`, `main_table`.`frontend_label`, `main_table`.`frontend_class`, `main_table`.`source_model`, `main_table`.`is_required`, `main_table`.`is_user_defined`, `main_table`.`default_value`, `main_table`.`is_unique`, `main_table`.`note`, `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 = 4) AND (entity_attribute.attribute_set_id = '4') 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 61 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