"Back"

SQL Explain

Executed SQL
SELECT `layout_update`.`xml` FROM `core_layout_update` AS `layout_update` INNER JOIN `core_layout_link` AS `link` ON link.layout_update_id=layout_update.layout_update_id WHERE (link.store_id IN (0, :store_id)) AND (link.area = :area) AND (link.package = :package) AND (link.theme = :theme) AND (layout_update.handle = :layout_update_handle) ORDER BY `layout_update`.`sort_order` ASC
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE layout_update ref PRIMARY,IDX_CORE_LAYOUT_UPDATE_HANDLE IDX_CORE_LAYOUT_UPDATE_HANDLE 768 const 1 Using index condition; Using where; Using filesort
1 SIMPLE link ref UNQ_CORE_LAYOUT_LINK_STORE_ID_PACKAGE_THEME_LAYOUT_UPDATE_ID,IDX_CORE_LAYOUT_LINK_LAYOUT_UPDATE_ID IDX_CORE_LAYOUT_LINK_LAYOUT_UPDATE_ID 4 lalacurio_magn.layout_update.layout_update_id 1 Using where