"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`.`page_id`='10') 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 const PRIMARY PRIMARY 2 const 1
1 SIMPLE cms_page_store range PRIMARY,IDX_CMS_PAGE_STORE_STORE_ID PRIMARY 4 2 Using where; Using index