"Back"

SQL Explain

Executed SQL
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block` INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='slide') AND (is_active = 1) AND (cbs.store_id in (1, 0) ) ORDER BY `store_id` DESC LIMIT 1
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cbs range PRIMARY,IDX_CMS_BLOCK_STORE_STORE_ID IDX_CMS_BLOCK_STORE_STORE_ID 2 140 Using where; Using index
1 SIMPLE cms_block eq_ref PRIMARY PRIMARY 2 lalacurio_magn.cbs.block_id 1 Using where