"Back"

SQL Explain

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