"Back"

SQL Explain

Executed SQL
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (attribute_id = '81') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE main_table ref PRIMARY,IDX_EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID IDX_EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID 2 const 6 Using temporary; Using filesort
1 SIMPLE tdv ref IDX_EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID,IDX_EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID IDX_EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID 4 lalacurio_magn.main_table.option_id 1 Using where
1 SIMPLE tsv ref IDX_EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID,IDX_EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID IDX_EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID 4 lalacurio_magn.main_table.option_id 1 Using where