Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`deleted`, `Setting`.`created`, `Setting`.`modified` FROM `rogerdw_murraybridge_test`.`settings` AS `Setting` WHERE 1 = 1 | 32 | 32 | 0 | |
SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`open_content`, `Content`.`location`, `Content`.`name`, `Content`.`image_not_used`, `Content`.`description`, `Content`.`url_key`, `Content`.`seo_title_not_used`, `Content`.`meta_keyword`, `Content`.`meta_description`, `Content`.`order`, `Content`.`deleted`, `Content`.`created`, `Content`.`modified` FROM `rogerdw_murraybridge_test`.`contents` AS `Content` WHERE `Content`.`url_key` = 'recent-development' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`image_ext`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `type` = 'special' AND `deleted` = 0 AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY rand() ASC LIMIT 12 | 0 | 0 | 0 | |
SELECT `Advertisement`.`id`, `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `Advertisement`.`deleted` = 0 AND `Advertisement`.`type` = 'rhs' AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY rand() ASC LIMIT 12 | 0 | 0 | 0 | |
SELECT `Advertisement`.`id`, `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `Advertisement`.`deleted` = 0 AND `Advertisement`.`type` = 'category' AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY rand() ASC LIMIT 12 | 0 | 0 | 0 | |
SELECT `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `type` = 'footer' AND `deleted` = 0 AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY rand() ASC LIMIT 5 | 0 | 0 | 0 | |
SELECT `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `type` = 'header' AND `deleted` = 0 AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY rand() ASC LIMIT 5 | 0 | 0 | 1 | maybe slow |
SELECT `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `type` = 'promotion' AND `deleted` = 0 AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY `id` DESC LIMIT 1 | 0 | 0 | 0 | |
SELECT `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`image_ext`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` WHERE `type` = 'special' AND `deleted` = 0 AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) ORDER BY rand() ASC LIMIT 2 | 0 | 0 | 1 | maybe slow |
SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`open_content`, `Content`.`name`, `Content`.`order`, `Content`.`url_key` FROM `rogerdw_murraybridge_test`.`contents` AS `Content` WHERE `location` = 'header' AND `deleted` = 0 ORDER BY `order` ASC | 16 | 16 | 0 | |
SELECT `Content`.`id`, `Content`.`parent_id`, `Content`.`name`, `Content`.`order`, `Content`.`url_key` FROM `rogerdw_murraybridge_test`.`contents` AS `Content` WHERE `location` = 'footer' AND `deleted` = 0 ORDER BY `order` ASC | 8 | 8 | 1 | maybe slow |