| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `CmsPages`.`id`, `CmsPages`.`url`, `CmsPages`.`title`, `CmsPages`.`content`, `CmsPages`.`additional_content`, `CmsPages`.`created`, `CmsPages`.`modified`, `CmsPages`.`draft`, `CmsPages`.`empty_action`, `CmsPages`.`menu`, `CmsPages`.`position`, `CmsPages`.`parent`, `CmsPages`.`meta_title`, `CmsPages`.`meta_description`, `CmsPages`.`meta_keywords` FROM `m1056_salazabaw14`.`cms_pages` AS `CmsPages` WHERE 1 = 1 ORDER BY `url` DESC | 1 | 1 | 1 | |
| SELECT `CmsPage`.`id`, `CmsPage`.`url`, `CmsPage`.`title`, `CmsPage`.`content`, `CmsPage`.`additional_content`, `CmsPage`.`created`, `CmsPage`.`modified`, `CmsPage`.`draft`, `CmsPage`.`empty_action`, `CmsPage`.`menu`, `CmsPage`.`position`, `CmsPage`.`parent`, `CmsPage`.`meta_title`, `CmsPage`.`meta_description`, `CmsPage`.`meta_keywords` FROM `m1056_salazabaw14`.`cms_pages` AS `CmsPage` WHERE `CmsPage`.`menu` = '1' | 1 | 1 | 0 | |
| SELECT `Place`.`id`, `Place`.`name`, `Place`.`url`, `Place`.`meta_title`, `Place`.`meta_description`, `Place`.`meta_keywords`, `Place`.`description`, `Place`.`province_id`, `Place`.`menu`, `Place`.`thumb` FROM `m1056_salazabaw14`.`places` AS `Place` WHERE `Place`.`menu` = '1' | 53 | 53 | 1 | |
| SELECT `Facility`.`id`, `Facility`.`icon`, `Facility`.`name`, `Facility`.`url`, `Facility`.`meta_title`, `Facility`.`meta_description`, `Facility`.`meta_keywords`, `Facility`.`description`, `Facility`.`menu` FROM `m1056_salazabaw14`.`facilities` AS `Facility` WHERE `Facility`.`menu` = '1' | 0 | 0 | 1 | maybe slow |
| SELECT `Province`.`id`, `Province`.`name`, `Province`.`url`, `Province`.`meta_title`, `Province`.`meta_description`, `Province`.`meta_keywords` FROM `m1056_salazabaw14`.`provinces` AS `Province` WHERE 1 = 1 ORDER BY `Province`.`name` ASC | 16 | 16 | 1 | maybe slow |
| SELECT `Place`.*, Count(`Room`.`id`) as rooms FROM `m1056_salazabaw14`.`places` AS `Place` LEFT JOIN `m1056_salazabaw14`.`rooms` AS `Room` ON (`Room`.`place_id` = `Place`.`id`) WHERE 1 = 1 GROUP BY `Place`.`id` LIMIT 12 | 12 | 12 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `m1056_salazabaw14`.`places` AS `Place` LEFT JOIN `m1056_salazabaw14`.`rooms` AS `Room` ON (`Room`.`place_id` = `Place`.`id`) WHERE 1 = 1 GROUP BY `Place`.`id` | 57 | 57 | 0 | |
| SELECT `CmsPage`.`id`, `CmsPage`.`url`, `CmsPage`.`title`, `CmsPage`.`content`, `CmsPage`.`additional_content`, `CmsPage`.`created`, `CmsPage`.`modified`, `CmsPage`.`draft`, `CmsPage`.`empty_action`, `CmsPage`.`menu`, `CmsPage`.`position`, `CmsPage`.`parent`, `CmsPage`.`meta_title`, `CmsPage`.`meta_description`, `CmsPage`.`meta_keywords` FROM `m1056_salazabaw14`.`cms_pages` AS `CmsPage` WHERE `url` = 'places/all' LIMIT 1 | 0 | 0 | 0 | |
