| 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] NewsController->init
-- libs/controller/controller.php - 502 , [Controller] NewsController->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 | 1 | 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 | 1 | 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 COUNT(*) AS `count` FROM `news_items` AS `NewsItem` WHERE `NewsItem`.`published` <= NOW()
-- libs/controller/controller.php - 1204 , [Model] NewsItem->find('count')
-- app/controllers/news_controller.php - 21 , [Controller] NewsController->paginate | | 1 | 1 | 0 | |
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 5
-- libs/controller/controller.php - 1224 , [Model] NewsItem->find('all')
-- app/controllers/news_controller.php - 21 , [Controller] NewsController->paginate | | 0 | 0 | 1 | maybe slow |
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')
-- libs/controller/controller.php - 863 , [AppController] NewsController->beforeRender | | 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` = 'news') AND (`SnippetRef`.`action` IN ('*', 'index')))))
-- 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 | | 1 | 1 | 1 | |
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` = 'news') AND (`GalleryRef`.`action` IN ('*', 'index')))))
-- 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 | | 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 | | 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 | | 2 | 2 | 0 | |
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 | | 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 | | 2 | 2 | 0 | |
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 | | 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 | | 2 | 2 | 0 | |
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 | | 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 | | 2 | 2 | 0 | |