"Back"

SQL Explain

Executed SQL
SELECT `main_table`.`attribute_id`, `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_input`, `main_table`.`source_model` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id=3) AND (attribute_code IN('name', 'url_key', 'is_active'))
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE main_table range PRIMARY,UNQ_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE,IDX_EAV_ATTRIBUTE_ENTITY_TYPE_ID UNQ_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE 770 3 Using index condition
1 SIMPLE additional_table eq_ref PRIMARY PRIMARY 2 lalacurio_magn.main_table.attribute_id 1 Using index