| 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 `Category`.`id`, `Category`.`cat_code_not_used`, `Category`.`name`, `Category`.`url_key`, `Category`.`first_letter`, `Category`.`deleted`, `Category`.`created`, `Category`.`modified` FROM `rogerdw_murraybridge_test`.`categories` AS `Category` WHERE `Category`.`url_key` = 'resources-resource-management' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Business`.`id`, `Business`.`user_id`, `Business`.`category_id_not_used`, `Business`.`name`, `Business`.`first_letter`, `Business`.`url_key`, `Business`.`address1`, `Business`.`address2`, `Business`.`city`, `Business`.`state`, `Business`.`postcode`, `Business`.`contact_name1`, `Business`.`contact_number1`, `Business`.`contact_name2`, `Business`.`contact_number2`, `Business`.`fax`, `Business`.`mobile_name1`, `Business`.`mobile1`, `Business`.`mobile_name2`, `Business`.`mobile2`, `Business`.`email1`, `Business`.`email2`, `Business`.`website`, `Business`.`mon_open`, `Business`.`mon_close`, `Business`.`mon_status`, `Business`.`tue_open`, `Business`.`tue_close`, `Business`.`tue_status`, `Business`.`wed_open`, `Business`.`wed_close`, `Business`.`wed_status`, `Business`.`thu_open`, `Business`.`thu_close`, `Business`.`thu_status`, `Business`.`fri_open`, `Business`.`fri_close`, `Business`.`fri_status`, `Business`.`sat_open`, `Business`.`sat_close`, `Business`.`sat_status`, `Business`.`sun_open`, `Business`.`sun_close`, `Business`.`sun_status`, `Business`.`business_activity`, `Business`.`keyword`, `Business`.`path`, `Business`.`image`, `Business`.`video`, `Business`.`latitude`, `Business`.`longitude`, `Business`.`deleted`, `Business`.`created`, `Business`.`modified`, `Business`.`is_in_mb` FROM `rogerdw_murraybridge_test`.`businesses` AS `Business` LEFT JOIN `rogerdw_murraybridge_test`.`businesses_categories` AS `BusinessCategory` ON (`BusinessCategory`.`business_id` = `Business`.`id`) WHERE `Business`.`deleted` = 0 AND `BusinessCategory`.`category_id` = '350' ORDER BY `Business`.`name` ASC LIMIT 15 | 2 | 2 | 2 | |
| SELECT `Communication`.`id`, `Communication`.`business_id`, `Communication`.`type`, `Communication`.`name`, `Communication`.`detail`, `Communication`.`created`, `Communication`.`modified` FROM `rogerdw_murraybridge_test`.`communications` AS `Communication` WHERE `Communication`.`business_id` IN (797, 1106) | 7 | 7 | 0 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`url_key`, `Category`.`first_letter` FROM `rogerdw_murraybridge_test`.`categories` AS `Category` WHERE `Category`.`deleted` = 0 ORDER BY `Category`.`first_letter` ASC, `Category`.`name` ASC | 534 | 534 | 3 | |
| SELECT `Advertisement`.`id`, `Advertisement`.`path`, `Advertisement`.`image`, `Advertisement`.`link` FROM `rogerdw_murraybridge_test`.`advertisements` AS `Advertisement` LEFT JOIN `rogerdw_murraybridge_test`.`advertisements_categories` AS `AdvertisementCategory` ON (`AdvertisementCategory`.`advertisement_id` = `Advertisement`.`id`) WHERE `Advertisement`.`deleted` = 0 AND `Advertisement`.`type` = 'category' AND ((`Advertisement`.`start_date` <= '2025-01-19') AND (`Advertisement`.`end_date` >= '2025-01-19')) AND `AdvertisementCategory`.`category_id` = '350' ORDER BY rand() ASC LIMIT 12 | 0 | 0 | 1 | maybe slow |
| 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`.`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 | 0 | |
| 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 `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 | 1 | maybe slow |
| 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 | 0 | |
