| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| SHOW FULL COLUMNS FROM `training` | | 12 | 12 | 26 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';
-- libs/model/model.php - 780 , [Model] Training->schema
-- libs/model/model.php - 474 , [Model] Training->setSource
-- app/models/training.php - 54 , [Model] Training->__construct
-- cake/libs/class_registry.php - 141 , [Training] Training->__construct
-- libs/controller/controller.php - 637 , [ClassRegistry] TrainingController->init
-- libs/controller/controller.php - 502 , [Controller] TrainingController->loadModel | | 1 | 1 | 1 | |
| SHOW FULL COLUMNS FROM `photos` | | 9 | 9 | 1 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';
-- libs/model/model.php - 780 , [Model] Photo->schema
-- libs/model/model.php - 474 , [Model] Photo->setSource
-- cake/libs/class_registry.php - 141 , [Model] Photo->__construct
-- libs/model/model.php - 658 , [ClassRegistry] Training->init
-- libs/model/model.php - 629 , [Model] Training->__constructLinkedModel
-- libs/model/model.php - 482 , [Model] Training->__createLinks
-- app/models/training.php - 54 , [Model] Training->__construct
-- cake/libs/class_registry.php - 141 , [Training] Training->__construct
-- libs/controller/controller.php - 637 , [ClassRegistry] TrainingController->init
-- libs/controller/controller.php - 502 , [Controller] TrainingController->loadModel | | 1 | 1 | 1 | |
| SHOW FULL COLUMNS FROM `news_items` | | 8 | 8 | 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 | 3 | |
| 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 `Training`.`id`, `Training`.`title`, `Training`.`description`, `Training`.`location`, `Training`.`filename`, `Training`.`extension`, `Training`.`start_date`, `Training`.`end_date`, `Training`.`cancelled`, `Training`.`visible`, `Training`.`created`, `Training`.`modified` FROM `training` AS `Training` WHERE `Training`.`visible` = 1 AND `Training`.`start_date` >= CURDATE() ORDER BY `start_date` ASC
-- app/controllers/training_controller.php - 35 , [Model] Training->find('all') | | 0 | 0 | 7 | 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] TrainingController->beforeRender | | 0 | 0 | 1 | maybe slow |
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` = 'training') 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` = 'training') 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 | 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 | | 1 | 1 | 1 | |
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 | 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 | | 1 | 1 | 1 | |
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 | 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 | | 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 | 1 | maybe slow |