A Website Design, Web Hosting and IT Soutions Company based in Farnham, Surrey, UK
To view Cookies, add CookieComponent to Controller
| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|---|
| DESCRIBE `core_routes` | 19 | 19 | 1 | maybe slow | |
| DESCRIBE `core_themes` | 11 | 11 | 1 | maybe slow | |
| DESCRIBE `core_logs` | 10 | 10 | 1 | maybe slow | |
| DESCRIBE `core_users` | 7 | 7 | 1 | maybe slow | |
| SELECT `Route`.`url`, `Route`.`prefix`, `Route`.`plugin`, `Route`.`controller`, `Route`.`action`, `Route`.`values`, `Route`.`pass`, `Route`.`rules`, `Route`.`force_backend`, `Route`.`force_frontend`, `Route`.`theme_id`, `Theme`.`id`, `Theme`.`name` FROM `core_routes` AS `Route` LEFT JOIN `core_themes` AS `Theme` ON (`Route`.`theme_id` = `Theme`.`id`) WHERE `Route`.`active` = 1 ORDER BY `Route`.`ordering` ASC | 14 | 14 | 0 | Explain | |
| DESCRIBE `cms_contents` | 20 | 20 | 1 | maybe slow | |
| DESCRIBE `cms_categories` | 18 | 18 | 1 | maybe slow | |
| DESCRIBE `core_groups` | 8 | 8 | 1 | maybe slow | |
| DESCRIBE `cms_content_layouts` | 13 | 13 | 1 | maybe slow | |
| DESCRIBE `cms_content_configs` | 5 | 5 | 1 | maybe slow | |
| DESCRIBE `cms_features` | 6 | 6 | 1 | maybe slow | |
| DESCRIBE `cms_frontpages` | 8 | 8 | 1 | maybe slow | |
| SELECT `Theme`.`id`, `Theme`.`name`, `Theme`.`description`, `Theme`.`author`, `Theme`.`url`, `Theme`.`update_url`, `Theme`.`licence`, `Theme`.`active`, `Theme`.`core`, `Theme`.`created`, `Theme`.`modified` FROM `core_themes` AS `Theme` WHERE `Theme`.`active` = 1 LIMIT 1 | 1 | 1 | 0 | Explain | |
| SELECT `User`.`id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`active`, `User`.`created`, `User`.`modified` FROM `core_users` AS `User` WHERE `User`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | Explain | |
| SELECT `Content`.`id`, `Content`.`title`, `Content`.`slug`, `Content`.`introduction`, `Content`.`body`, `Content`.`locked`, `Content`.`locked_since`, `Content`.`locked_by`, `Content`.`ordering`, `Content`.`group_id`, `Content`.`views`, `Content`.`active`, `Content`.`start`, `Content`.`end`, `Content`.`created`, `Content`.`modified`, `Content`.`layout_id`, `Content`.`created_by`, `Content`.`modified_by`, `Content`.`category_id`, `Author`.`id`, `Author`.`username`, `Editor`.`id`, `Editor`.`username`, `Category`.`id`, `Category`.`title`, `Group`.`id`, `Group`.`name`, `Locker`.`id`, `Locker`.`username`, `Layout`.`id`, `Layout`.`content_id`, `Layout`.`name`, `Layout`.`css`, `Layout`.`html`, `Layout`.`php`, `Layout`.`locked`, `Layout`.`locked_by`, `Layout`.`locked_since`, `Layout`.`content_count`, `Layout`.`active`, `Layout`.`created`, `Layout`.`modified`, `ContentConfig`.`id`, `ContentConfig`.`content_id`, `ContentConfig`.`author_alias`, `ContentConfig`.`keywords`, `ContentConfig`.`description`, `Feature`.`id`, `Frontpage`.`id` FROM `cms_contents` AS `Content` LEFT JOIN `core_users` AS `Author` ON (`Content`.`created_by` = `Author`.`id`) LEFT JOIN `core_users` AS `Editor` ON (`Content`.`modified_by` = `Editor`.`id`) LEFT JOIN `cms_categories` AS `Category` ON (`Content`.`category_id` = `Category`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`Content`.`group_id` = `Group`.`id`) LEFT JOIN `core_users` AS `Locker` ON (`Content`.`locked_by` = `Locker`.`id`) LEFT JOIN `cms_content_layouts` AS `Layout` ON (`Content`.`layout_id` = `Layout`.`id`) LEFT JOIN `cms_content_configs` AS `ContentConfig` ON (`ContentConfig`.`content_id` = `Content`.`id`) LEFT JOIN `cms_features` AS `Feature` ON (`Feature`.`content_id` = `Content`.`id`) LEFT JOIN `cms_frontpages` AS `Frontpage` ON (`Frontpage`.`content_id` = `Content`.`id`) WHERE `Content`.`slug` = 'sitemap' AND `Content`.`active` = 1 ORDER BY `Content`.`category_id` ASC, `Content`.`ordering` ASC LIMIT 1 | 0 | 0 | 1 | maybe slowExplain | |
| DESCRIBE `core_menu_items` | 20 | 20 | 1 | maybe slow | |
| DESCRIBE `core_menus` | 7 | 7 | 1 | maybe slow | |
| SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`type`, `Menu`.`active`, `MenuItem`.`id`, `MenuItem`.`name`, `MenuItem`.`link`, `MenuItem`.`prefix`, `MenuItem`.`plugin`, `MenuItem`.`controller`, `MenuItem`.`action`, `MenuItem`.`params`, `MenuItem`.`force_backend`, `MenuItem`.`force_frontend`, `MenuItem`.`class`, `MenuItem`.`active`, `MenuItem`.`menu_id`, `MenuItem`.`parent_id`, `MenuItem`.`lft`, `MenuItem`.`rght`, `MenuItem`.`group_id` FROM `core_menu_items` AS `MenuItem` LEFT JOIN `core_menus` AS `Menu` ON (`MenuItem`.`menu_id` = `Menu`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`MenuItem`.`group_id` = `Group`.`id`) WHERE `Menu`.`type` = 'main_menu' AND `Menu`.`active` = 1 AND `MenuItem`.`active` = 1 ORDER BY `MenuItem`.`menu_id` ASC, `MenuItem`.`lft` ASC | 5 | 5 | 0 | Explain | |
| DESCRIBE `core_modules` | 22 | 22 | 1 | ||
| DESCRIBE `core_module_positions` | 4 | 4 | 0 | ||
| DESCRIBE `core_modules_routes` | 3 | 3 | 0 | ||
| SELECT `Module`.`id`, `Module`.`name`, `Module`.`content`, `Module`.`module`, `Module`.`config`, `Module`.`show_heading`, `Position`.`id`, `Position`.`name`, `Theme`.`id`, `Theme`.`name`, `Group`.`id`, `Group`.`name` FROM `core_modules` AS `Module` LEFT JOIN `core_module_positions` AS `Position` ON (`Module`.`position_id` = `Position`.`id`) LEFT JOIN `core_themes` AS `Theme` ON (`Module`.`theme_id` = `Theme`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`Module`.`group_id` = `Group`.`id`) WHERE `Position`.`name` = 'right' AND `Module`.`admin` = 0 AND `Module`.`active` = 1 ORDER BY `Module`.`position_id` ASC, `Module`.`ordering` ASC | 1 | 1 | 0 | Explain | |
| SELECT `Route`.`id`, `Route`.`name`, `Route`.`url`, `CoreModulesRoute`.`id`, `CoreModulesRoute`.`module_id`, `CoreModulesRoute`.`route_id` FROM `core_routes` AS `Route` JOIN `core_modules_routes` AS `CoreModulesRoute` ON (`CoreModulesRoute`.`module_id` = 11 AND `CoreModulesRoute`.`route_id` = `Route`.`id`) | 0 | 0 | 0 | Explain | |
| SELECT `Module`.`id`, `Module`.`name`, `Module`.`content`, `Module`.`module`, `Module`.`config`, `Module`.`show_heading`, `Position`.`id`, `Position`.`name`, `Theme`.`id`, `Theme`.`name`, `Group`.`id`, `Group`.`name` FROM `core_modules` AS `Module` LEFT JOIN `core_module_positions` AS `Position` ON (`Module`.`position_id` = `Position`.`id`) LEFT JOIN `core_themes` AS `Theme` ON (`Module`.`theme_id` = `Theme`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`Module`.`group_id` = `Group`.`id`) WHERE `Position`.`name` = 'search' AND `Module`.`admin` = 0 AND `Module`.`active` = 1 ORDER BY `Module`.`position_id` ASC, `Module`.`ordering` ASC | 1 | 1 | 0 | Explain | |
| SELECT `Route`.`id`, `Route`.`name`, `Route`.`url`, `CoreModulesRoute`.`id`, `CoreModulesRoute`.`module_id`, `CoreModulesRoute`.`route_id` FROM `core_routes` AS `Route` JOIN `core_modules_routes` AS `CoreModulesRoute` ON (`CoreModulesRoute`.`module_id` = 5 AND `CoreModulesRoute`.`route_id` = `Route`.`id`) | 0 | 0 | 0 | Explain | |
| SELECT `Module`.`id`, `Module`.`name`, `Module`.`content`, `Module`.`module`, `Module`.`config`, `Module`.`show_heading`, `Position`.`id`, `Position`.`name`, `Theme`.`id`, `Theme`.`name`, `Group`.`id`, `Group`.`name` FROM `core_modules` AS `Module` LEFT JOIN `core_module_positions` AS `Position` ON (`Module`.`position_id` = `Position`.`id`) LEFT JOIN `core_themes` AS `Theme` ON (`Module`.`theme_id` = `Theme`.`id`) LEFT JOIN `core_groups` AS `Group` ON (`Module`.`group_id` = `Group`.`id`) WHERE `Position`.`name` = 'bottom' AND `Module`.`admin` = 0 AND `Module`.`active` = 1 ORDER BY `Module`.`position_id` ASC, `Module`.`ordering` ASC | 0 | 0 | 0 | Explain |
Peak Memory Use 10.69 MB
| Message | Memory use |
|---|---|
| Component intitailization | 7.72 MB |
| Controller action start | 7.78 MB |
| Controller render start | 7.91 MB |
| View render complete | 9.88 MB |
Total Request Time: 548 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 362.32 | |
| Component initialization and startup | 12.23 | |
| Controller action | 11.39 | |
| Render Controller Action | 95.95 | |
| » Rendering View | 93.19 | |
| » » Rendering APP/infinitas/cms/views/contents/view.ctp | 34.61 | |
| » » Rendering APP/views/themed/earthling_two/layouts/front.ctp | 56.13 | |
| » » » Rendering APP/views/elements/modules/main_menu.ctp | 20.92 | |
| » » » Rendering APP/views/elements/modules/search.ctp | 0.26 |
There were no log entries made this request
There were no log entries made this request