To view Cookies, add CookieComponent to Controller
| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|---|
| SHOW FULL COLUMNS FROM `images` | 5 | 5 | 1 | maybe slow | |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci'; | 1 | 1 | 1 | ||
| SHOW FULL COLUMNS FROM `options` | 5 | 5 | 3 | maybe slow | |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci'; | 1 | 1 | 17 | maybe slow | |
| SHOW FULL COLUMNS FROM `administrators` | 4 | 4 | 1 | maybe slow | |
| SELECT COUNT(*) AS `count` FROM `images` AS `Image` WHERE `Image`.`language` = 'bg' | 1 | 1 | 2 | maybe slow | |
| SELECT `Image`.`id`, `Image`.`dir`, `Image`.`filename`, `Image`.`description`, `Image`.`language` FROM `images` AS `Image` WHERE `Image`.`language` = 'bg' LIMIT 30 | 11 | 11 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `sites` | 2 | 2 | 1 | maybe slow | |
| UPDATE `sites` AS `Site` SET `Site`.`view_count` = Site.view_count + 1 WHERE `Site`.`id` = 1 | 1 | 2 | maybe slow | ||
| SELECT `Site`.`view_count` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | ||
| SHOW FULL COLUMNS FROM `links` | 10 | 10 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `navigations` | 3 | 3 | 1 | maybe slow | |
| SELECT `Link`.`id`, `Link`.`title`, `Link`.`type`, `Link`.`object_id`, `Link`.`subject`, `Link`.`lft`, `Link`.`rght`, `Link`.`language`, `Link`.`navigation_id`, `Link`.`parent_id`, `Navigation`.`id`, `Navigation`.`name`, `Navigation`.`key` FROM `links` AS `Link` LEFT JOIN `navigations` AS `Navigation` ON (`Link`.`navigation_id` = `Navigation`.`id`) WHERE `Link`.`language` = 'bg' AND `Navigation`.`key` = 'main' AND `Link`.`language` = 'bg' ORDER BY `Link`.`lft` ASC | 7 | 7 | 0 | ||
| SHOW FULL COLUMNS FROM `types` | 5 | 5 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `products` | 19 | 19 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `criteria` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `products_criteria` | 2 | 2 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `products_types` | 2 | 2 | 1 | maybe slow | |
| SELECT `Type`.`id`, `Type`.`title`, `Type`.`filename`, `Type`.`dir`, `Type`.`language` FROM `types` AS `Type` WHERE `Type`.`language` = 'bg' ORDER BY `title` ASC | 26 | 26 | 2 | maybe slow | |
| SHOW FULL COLUMNS FROM `posts` | 10 | 10 | 1 | maybe slow | |
| SELECT `Post`.`id`, `Post`.`title`, `Post`.`slug`, `Post`.`summary`, `Post`.`content`, `Post`.`type`, `Post`.`filename`, `Post`.`dir`, `Post`.`language`, `Post`.`created` FROM `posts` AS `Post` WHERE `Post`.`type` = 'news' AND `Post`.`language` = 'bg' ORDER BY `Post`.`id` DESC LIMIT 5 | 5 | 5 | 0 | ||
| SELECT `Post`.`id`, `Post`.`title`, `Post`.`slug`, `Post`.`summary`, `Post`.`content`, `Post`.`type`, `Post`.`filename`, `Post`.`dir`, `Post`.`language`, `Post`.`created` FROM `posts` AS `Post` WHERE `Post`.`type` = 'curious' AND `Post`.`language` = 'bg' ORDER BY `Post`.`id` DESC LIMIT 5 | 5 | 5 | 0 | ||
| SHOW FULL COLUMNS FROM `blocks` | 3 | 3 | 1 | maybe slow | |
| SHOW FULL COLUMNS FROM `block_contents` | 4 | 4 | 1 | maybe slow | |
| SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'partners' AND `BlockContent`.`language` = 'bg' LIMIT 1 | 1 | 1 | 0 | ||
| SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'right_sidebar' AND `BlockContent`.`language` = 'bg' LIMIT 1 | 1 | 1 | 0 | ||
| SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'bottom' AND `BlockContent`.`language` = 'bg' LIMIT 1 | 1 | 1 | 0 | ||
| SELECT `Link`.`id`, `Link`.`title`, `Link`.`type`, `Link`.`object_id`, `Link`.`subject`, `Link`.`lft`, `Link`.`rght`, `Link`.`language`, `Link`.`navigation_id`, `Link`.`parent_id`, `Navigation`.`id`, `Navigation`.`name`, `Navigation`.`key` FROM `links` AS `Link` LEFT JOIN `navigations` AS `Navigation` ON (`Link`.`navigation_id` = `Navigation`.`id`) WHERE `Link`.`language` = 'bg' AND `Navigation`.`key` = 'footer' AND `Link`.`language` = 'bg' ORDER BY `Link`.`lft` ASC | 6 | 6 | 0 | ||
| SELECT `BlockContent`.`content`, `Block`.`name` FROM `block_contents` AS `BlockContent` LEFT JOIN `blocks` AS `Block` ON (`BlockContent`.`block_id` = `Block`.`id`) WHERE `Block`.`key` = 'footer' AND `BlockContent`.`language` = 'bg' LIMIT 1 | 1 | 1 | 1 |
Peak Memory Use 17.20 MB
| Message | Memory use |
|---|---|
| Component initialization | 9.80 MB |
| Controller action start | 10.16 MB |
| Controller render start | 10.29 MB |
| Component initialization #2 | 14.03 MB |
| Controller action start #2 | 14.04 MB |
| Component initialization #3 | 15.26 MB |
| Controller action start #3 | 15.28 MB |
| Component initialization #4 | 15.17 MB |
| Controller action start #4 | 15.18 MB |
| Component initialization #5 | 15.22 MB |
| Controller action start #5 | 15.24 MB |
| Component initialization #6 | 15.28 MB |
| Controller action start #6 | 15.29 MB |
| Component initialization #7 | 15.36 MB |
| Controller action start #7 | 15.37 MB |
| View render complete | 15.25 MB |
Total Request Time: 710 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 132.55 | |
| Component initialization and startup | 76.35 | |
| Controller action | 32.51 | |
| Render Controller Action | 380.50 | |
| » Rendering View | 378.73 | |
| » » Rendering APP/views/images/index.ctp | 73.43 | |
| » » » Rendering APP/views/elements/pagination.ctp | 0.30 | |
| » » Rendering APP/views/layouts/default.ctp | 275.09 | |
| » » » Rendering APP/views/elements/navigation.ctp | 58.85 | |
| » » » » Component initialization and startup #2 | 2.39 | |
| Controller action #2 | 0.00 | |
| » » » » » Rendering APP/views/elements/link.ctp | 0.51 | |
| » » » » » Rendering APP/views/elements/link.ctp #2 | 0.52 | |
| » » » » » Rendering APP/views/elements/link.ctp #3 | 0.53 | |
| » » » » » Rendering APP/views/elements/link.ctp #4 | 1.19 | |
| » » » » » Rendering APP/views/elements/link.ctp #5 | 1.21 | |
| » » » » » Rendering APP/views/elements/link.ctp #6 | 0.51 | |
| » » » » » Rendering APP/views/elements/link.ctp #7 | 0.42 | |
| » » » Rendering APP/views/elements/sidebars/default.ctp #2 | 245.07 | |
| » » » » » Rendering APP/views/elements/block.ctp | 48.86 | |
| » » » » » » Component initialization and startup #3 | 2.36 | |
| Controller action #3 | 0.00 | |
| » » » » » Rendering APP/views/elements/block.ctp #2 | 5.94 | |
| » » » » » » Component initialization and startup #4 | 2.49 | |
| Controller action #4 | 0.00 | |
| » » » » » » Rendering APP/views/elements/block.ctp #3 | 5.96 | |
| » » » » » » » Component initialization and startup #5 | 2.35 | |
| Controller action #5 | 0.00 | |
| » » » » » » » Rendering APP/views/elements/navigation.ctp #2 | 10.65 | |
| » » » » » » » » Component initialization and startup #6 | 2.30 | |
| Controller action #6 | 0.00 | |
| » » » » » » » » » Rendering APP/views/elements/link.ctp #8 | 0.48 | |
| » » » » » » » » » Rendering APP/views/elements/link.ctp #9 | 0.64 | |
| » » » » » » » » » Rendering APP/views/elements/link.ctp #10 | 0.55 | |
| » » » » » » » » » Rendering APP/views/elements/link.ctp #11 | 0.50 | |
| » » » » » » » » » Rendering APP/views/elements/link.ctp #12 | 0.39 | |
| » » » » » » » » » Rendering APP/views/elements/link.ctp #13 | 0.37 | |
| » » » » » » » » Rendering APP/views/elements/block.ctp #4 | 6.14 | |
| » » » » » » » » » Component initialization and startup #7 | 2.28 | |
| Controller action #7 | 0.00 |