To view Cookies, add CookieComponent to Controller
| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|---|
| SHOW FULL COLUMNS FROM `news_items` | 8 | 8 | 1 | maybe slow | |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; -- libs/model/model.php - 780 , [Model] NewsItem->schema -- libs/model/model.php - 474 , [Model] NewsItem->setSource -- app/models/news_item.php - 44 , [Model] NewsItem->__construct -- cake/libs/class_registry.php - 141 , [NewsItem] NewsItem->__construct -- libs/controller/controller.php - 637 , [ClassRegistry] PagesController->init -- libs/controller/controller.php - 502 , [Controller] PagesController->loadModel | 1 | 1 | 1 | ||
| SHOW FULL COLUMNS FROM `photos` | 9 | 9 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `whos_whos` | 8 | 8 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `services` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `employment` | 12 | 12 | 4 | maybe slow | |
| SHOW FULL COLUMNS FROM `users` | 10 | 10 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `announcements` | 11 | 11 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `announcements_user` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `residential_homes` | 12 | 12 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `residential_homes_users` | 3 | 3 | 4 | maybe slow | |
| SHOW FULL COLUMNS FROM `residential_homes_whos_whos` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `services_users` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `services_whos_whos` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `snippet_refs` | 4 | 4 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `snippets` | 7 | 7 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `gallery_refs` | 4 | 4 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `galleries` | 6 | 6 | 1 | maybe slow | |
| SELECT `WhosWho`.`name`, `WhosWho`.`role`, `WhosWho`.`id` FROM `whos_whos` AS `WhosWho` WHERE 1 = 1 ORDER BY RAND() ASC LIMIT 3 -- app/controllers/pages_controller.php - 18 , [Model] WhosWho->find('all') -- libs/controller/controller.php - 863 , [PagesController] PagesController->beforeRender -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 3 | 3 | 1 | maybe slow | |
| SELECT `Photo`.`id`, `Photo`.`owner_type`, `Photo`.`owner_id`, `Photo`.`owner_sort`, `Photo`.`filename`, `Photo`.`caption`, `Photo`.`type`, `Photo`.`width`, `Photo`.`height` FROM `photos` AS `Photo` WHERE `Photo`.`owner_type` = 'team_member' AND `Photo`.`owner_id` IN (2, 5, 3) ORDER BY `Photo`.`owner_sort` ASC -- app/controllers/pages_controller.php - 18 , [Model] WhosWho->find('all') -- libs/controller/controller.php - 863 , [PagesController] PagesController->beforeRender -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 5 | 5 | 1 | maybe slow | |
| SELECT `Service`.`id`, `Service`.`key`, `Service`.`title`, `ServicesWhosWho`.`id`, `ServicesWhosWho`.`service_id`, `ServicesWhosWho`.`whos_who_id` FROM `services` AS `Service` JOIN `services_whos_whos` AS `ServicesWhosWho` ON (`ServicesWhosWho`.`whos_who_id` IN (2, 5, 3) AND `ServicesWhosWho`.`service_id` = `Service`.`id`) -- app/controllers/pages_controller.php - 18 , [Model] WhosWho->find('all') -- libs/controller/controller.php - 863 , [PagesController] PagesController->beforeRender -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 4 | 4 | 1 | maybe slow | |
| SELECT `ResidentialHome`.`id`, `ResidentialHome`.`ORDER`, `ResidentialHome`.`name`, `ResidentialHome`.`description`, `ResidentialHome`.`services`, `ResidentialHome`.`address`, `ResidentialHome`.`telephone`, `ResidentialHome`.`email`, `ResidentialHome`.`longitude`, `ResidentialHome`.`latitude`, `ResidentialHome`.`vacancies`, `ResidentialHome`.`modified`, `ResidentialHomesWhosWho`.`id`, `ResidentialHomesWhosWho`.`residential_home_id`, `ResidentialHomesWhosWho`.`whos_who_id` FROM `residential_homes` AS `ResidentialHome` JOIN `residential_homes_whos_whos` AS `ResidentialHomesWhosWho` ON (`ResidentialHomesWhosWho`.`whos_who_id` IN (2, 5, 3) AND `ResidentialHomesWhosWho`.`residential_home_id` = `ResidentialHome`.`id`) -- app/controllers/pages_controller.php - 18 , [Model] WhosWho->find('all') -- libs/controller/controller.php - 863 , [PagesController] PagesController->beforeRender -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 2 | 2 | 2 | ||
| SELECT `NewsItem`.`id`, `NewsItem`.`published`, `NewsItem`.`DATE_FORMAT`, `NewsItem`.`title`, `NewsItem`.`content`, `NewsItem`.`filename`, `NewsItem`.`extension`, `NewsItem`.`modified` FROM `news_items` AS `NewsItem` WHERE `NewsItem`.`published` <= NOW() ORDER BY `published` DESC, `id` DESC LIMIT 1 -- app/controllers/app_controller.php - 92 , [Model] NewsItem->find('first') -- app/controllers/pages_controller.php - 20 , [AppController] PagesController->beforeRender -- libs/controller/controller.php - 863 , [PagesController] PagesController->beforeRender -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 0 | 0 | 0 | ||
| SELECT `SnippetRef`.`id`, `SnippetRef`.`snippet_id`, `SnippetRef`.`controller`, `SnippetRef`.`action`, `Snippet`.`id`, `Snippet`.`key`, `Snippet`.`title`, `Snippet`.`content`, `Snippet`.`modified`, `Snippet`.`pdf_folder`, `Snippet`.`pdf_filename` FROM `snippet_refs` AS `SnippetRef` LEFT JOIN `snippets` AS `Snippet` ON (`SnippetRef`.`snippet_id` = `Snippet`.`id`) WHERE ((`SnippetRef`.`controller` = '*') OR (((`SnippetRef`.`controller` = 'pages') AND (`SnippetRef`.`action` IN ('*', 'sitemap'))))) -- controllers/components/snippets_manager.php - 32 , [Model] SnippetRef->find('all') -- libs/controller/component.php - 186 , [SnippetsManagerComponent] SnippetsManagerComponent->beforeRender -- libs/controller/controller.php - 864 , [Component] Component->triggerCallback -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 0 | 0 | 1 | maybe slow | |
| SELECT `GalleryRef`.`id`, `GalleryRef`.`gallery_id`, `GalleryRef`.`controller`, `GalleryRef`.`action`, `Gallery`.`id`, `Gallery`.`key`, `Gallery`.`title`, `Gallery`.`type`, `Gallery`.`size`, `Gallery`.`panes` FROM `gallery_refs` AS `GalleryRef` LEFT JOIN `galleries` AS `Gallery` ON (`GalleryRef`.`gallery_id` = `Gallery`.`id`) WHERE ((`GalleryRef`.`controller` = '*') OR (((`GalleryRef`.`controller` = 'pages') AND (`GalleryRef`.`action` IN ('*', 'sitemap'))))) -- controllers/components/snippets_manager.php - 50 , [Model] GalleryRef->find('all') -- libs/controller/component.php - 186 , [SnippetsManagerComponent] SnippetsManagerComponent->beforeRender -- libs/controller/controller.php - 864 , [Component] Component->triggerCallback -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 4 | 4 | 1 | maybe slow | |
| SELECT `Gallery`.`id`, `Gallery`.`key`, `Gallery`.`title`, `Gallery`.`type`, `Gallery`.`size`, `Gallery`.`panes` FROM `galleries` AS `Gallery` WHERE `Gallery`.`id` = 2 -- controllers/components/snippets_manager.php - 50 , [Model] GalleryRef->find('all') -- libs/controller/component.php - 186 , [SnippetsManagerComponent] SnippetsManagerComponent->beforeRender -- libs/controller/controller.php - 864 , [Component] Component->triggerCallback -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 1 | 1 | 0 | ||
| SELECT `Photo`.`id`, `Photo`.`owner_type`, `Photo`.`owner_id`, `Photo`.`owner_sort`, `Photo`.`filename`, `Photo`.`caption`, `Photo`.`type`, `Photo`.`width`, `Photo`.`height` FROM `photos` AS `Photo` WHERE `Photo`.`owner_type` = 'gallery' AND `Photo`.`owner_id` = (2) ORDER BY `Photo`.`owner_sort` ASC -- controllers/components/snippets_manager.php - 50 , [Model] GalleryRef->find('all') -- libs/controller/component.php - 186 , [SnippetsManagerComponent] SnippetsManagerComponent->beforeRender -- libs/controller/controller.php - 864 , [Component] Component->triggerCallback -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 2 | 2 | 1 | maybe slow | |
| SELECT `Gallery`.`id`, `Gallery`.`key`, `Gallery`.`title`, `Gallery`.`type`, `Gallery`.`size`, `Gallery`.`panes` FROM `galleries` AS `Gallery` WHERE `Gallery`.`id` = 3 -- controllers/components/snippets_manager.php - 50 , [Model] GalleryRef->find('all') -- libs/controller/component.php - 186 , [SnippetsManagerComponent] SnippetsManagerComponent->beforeRender -- libs/controller/controller.php - 864 , [Component] Component->triggerCallback -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 1 | 1 | 0 | ||
| SELECT `Photo`.`id`, `Photo`.`owner_type`, `Photo`.`owner_id`, `Photo`.`owner_sort`, `Photo`.`filename`, `Photo`.`caption`, `Photo`.`type`, `Photo`.`width`, `Photo`.`height` FROM `photos` AS `Photo` WHERE `Photo`.`owner_type` = 'gallery' AND `Photo`.`owner_id` = (3) ORDER BY `Photo`.`owner_sort` ASC -- controllers/components/snippets_manager.php - 50 , [Model] GalleryRef->find('all') -- libs/controller/component.php - 186 , [SnippetsManagerComponent] SnippetsManagerComponent->beforeRender -- libs/controller/controller.php - 864 , [Component] Component->triggerCallback -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 2 | 2 | 1 | maybe slow | |
| SELECT `Gallery`.`id`, `Gallery`.`key`, `Gallery`.`title`, `Gallery`.`type`, `Gallery`.`size`, `Gallery`.`panes` FROM `galleries` AS `Gallery` WHERE `Gallery`.`id` = 4 -- controllers/components/snippets_manager.php - 50 , [Model] GalleryRef->find('all') -- libs/controller/component.php - 186 , [SnippetsManagerComponent] SnippetsManagerComponent->beforeRender -- libs/controller/controller.php - 864 , [Component] Component->triggerCallback -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 1 | 1 | 0 | ||
| SELECT `Photo`.`id`, `Photo`.`owner_type`, `Photo`.`owner_id`, `Photo`.`owner_sort`, `Photo`.`filename`, `Photo`.`caption`, `Photo`.`type`, `Photo`.`width`, `Photo`.`height` FROM `photos` AS `Photo` WHERE `Photo`.`owner_type` = 'gallery' AND `Photo`.`owner_id` = (4) ORDER BY `Photo`.`owner_sort` ASC -- controllers/components/snippets_manager.php - 50 , [Model] GalleryRef->find('all') -- libs/controller/component.php - 186 , [SnippetsManagerComponent] SnippetsManagerComponent->beforeRender -- libs/controller/controller.php - 864 , [Component] Component->triggerCallback -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 2 | 2 | 1 | maybe slow | |
| SELECT `Gallery`.`id`, `Gallery`.`key`, `Gallery`.`title`, `Gallery`.`type`, `Gallery`.`size`, `Gallery`.`panes` FROM `galleries` AS `Gallery` WHERE `Gallery`.`id` = 5 -- controllers/components/snippets_manager.php - 50 , [Model] GalleryRef->find('all') -- libs/controller/component.php - 186 , [SnippetsManagerComponent] SnippetsManagerComponent->beforeRender -- libs/controller/controller.php - 864 , [Component] Component->triggerCallback -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 1 | 1 | 0 | ||
| SELECT `Photo`.`id`, `Photo`.`owner_type`, `Photo`.`owner_id`, `Photo`.`owner_sort`, `Photo`.`filename`, `Photo`.`caption`, `Photo`.`type`, `Photo`.`width`, `Photo`.`height` FROM `photos` AS `Photo` WHERE `Photo`.`owner_type` = 'gallery' AND `Photo`.`owner_id` = (5) ORDER BY `Photo`.`owner_sort` ASC -- controllers/components/snippets_manager.php - 50 , [Model] GalleryRef->find('all') -- libs/controller/component.php - 186 , [SnippetsManagerComponent] SnippetsManagerComponent->beforeRender -- libs/controller/controller.php - 864 , [Component] Component->triggerCallback -- app/controllers/pages_controller.php - 49 , [Controller] PagesController->render | 2 | 2 | 1 | maybe slow |
Peak Memory Use 14.91 MB
| Message | Memory use |
|---|---|
| Component intitailization | 10.94 MB |
| Controller action start | 11.01 MB |
| Controller render start | 11.17 MB |
| View render complete | 13.10 MB |
Total Request Time: 487 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 208.01 | |
| Component initialization and startup | 6.13 | |
| Controller action | 32.86 | |
| Render Controller Action | 68.52 | |
| » Rendering View | 65.44 | |
| » » Rendering APP/views/pages/sitemap.ctp | 35.40 | |
| » » Rendering APP/views/layouts/default.ctp | 29.46 | |
| » » » Rendering APP/views/elements/userinfo.ctp | 0.31 | |
| » » » Rendering APP/views/elements/header.ctp | 10.47 | |
| » » » » Rendering APP/views/elements/menu-items-2.ctp | 8.76 | |
| » » » Rendering APP/views/elements/footer.ctp | 0.99 |