"Back"

SQL Explain

Executed SQL
SELECT `cms_page`.* FROM `cms_page` INNER JOIN `cms_page_store` ON cms_page.page_id = cms_page_store.page_id WHERE (`cms_page`.`identifier`='home_1') AND (is_active = 1) AND (cms_page_store.store_id IN (0, 1)) ORDER BY `cms_page_store`.`store_id` DESC LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cms_page ref PRIMARY,IDX_CMS_PAGE_IDENTIFIER IDX_CMS_PAGE_IDENTIFIER 303 const 1 Using index condition; Using where; Using temporary; Using filesort
1 SIMPLE cms_page_store ref PRIMARY,IDX_CMS_PAGE_STORE_STORE_ID PRIMARY 2 lalacurio_magn.cms_page.page_id 1 Using where; Using index