To view Cookies, add CookieComponent to Controller
| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|---|
| SHOW FULL COLUMNS FROM `aros` | 7 | 7 | 0 | ||
| SHOW FULL COLUMNS FROM `acos` | 7 | 7 | 0 | ||
| SHOW FULL COLUMNS FROM `aros_acos` | 7 | 7 | 0 | ||
| SHOW FULL COLUMNS FROM `posts` | 10 | 10 | 0 | ||
| SHOW FULL COLUMNS FROM `i18n` | 6 | 6 | 0 | ||
| SHOW FULL COLUMNS FROM `tags` | 7 | 7 | 0 | ||
| SHOW FULL COLUMNS FROM `tagged` | 8 | 8 | 0 | ||
| SHOW FULL COLUMNS FROM `configurations` | 3 | 3 | 0 | ||
| SELECT `Configuration`.*, `I18n__value`.`content`, `Configuration`.`id` FROM `configurations` AS `Configuration` LEFT JOIN `i18n` AS `I18n__value` ON (`Configuration`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Configuration' AND `I18n__value`.`field` = 'value') WHERE `I18n__value`.`locale` = 'spa' | 15 | 15 | 0 | ||
| SELECT `Values`.`id`, `Values`.`locale`, `Values`.`model`, `Values`.`foreign_key`, `Values`.`field`, `Values`.`content` FROM `i18n` AS `Values` WHERE `model` = 'Configuration' AND `field` = 'value' AND `Values`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 11, 12, 13, 14) | 55 | 55 | 0 | ||
| SHOW FULL COLUMNS FROM `sections` | 13 | 13 | 0 | ||
| SELECT `Section`.*, `ParentSection`.*, `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` IS NULL AND `I18n__title`.`locale` = 'spa' ORDER BY `Section`.`sort` ASC | 3 | 3 | 0 | ||
| SHOW FULL COLUMNS FROM `post_files` | 8 | 8 | 0 | ||
| SHOW FULL COLUMNS FROM `post_links` | 5 | 5 | 0 | ||
| SELECT `Post`.*, `I18n__title`.`content`, `I18n__text`.`content`, `I18n__tags`.`content`, `Post`.`id` FROM `posts` AS `Post` LEFT JOIN `i18n` AS `I18n__title` ON (`Post`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Post' AND `I18n__title`.`field` = 'title') LEFT JOIN `i18n` AS `I18n__text` ON (`Post`.`id` = `I18n__text`.`foreign_key` AND `I18n__text`.`model` = 'Post' AND `I18n__text`.`field` = 'text') LEFT JOIN `i18n` AS `I18n__tags` ON (`Post`.`id` = `I18n__tags`.`foreign_key` AND `I18n__tags`.`model` = 'Post' AND `I18n__tags`.`field` = 'tags') WHERE `I18n__title`.`locale` = 'spa' AND `I18n__text`.`locale` = 'spa' AND `I18n__tags`.`locale` = 'spa' ORDER BY `Post`.`date` DESC | 2 | 2 | 2 | ||
| SELECT `PostFile`.`id`, `PostFile`.`post_id`, `PostFile`.`filename`, `PostFile`.`dir`, `PostFile`.`mimetype`, `PostFile`.`filesize`, `PostFile`.`created`, `PostFile`.`modified` FROM `post_files` AS `PostFile` WHERE `PostFile`.`post_id` IN (1, 2) | 0 | 0 | 0 | ||
| SELECT `PostLink`.`id`, `PostLink`.`post_id`, `PostLink`.`link`, `PostLink`.`created`, `PostLink`.`modified` FROM `post_links` AS `PostLink` WHERE `PostLink`.`post_id` IN (1, 2) | 0 | 0 | 0 | ||
| SELECT `Titles`.`id`, `Titles`.`locale`, `Titles`.`model`, `Titles`.`foreign_key`, `Titles`.`field`, `Titles`.`content` FROM `i18n` AS `Titles` WHERE `model` = 'Post' AND `field` = 'title' AND `Titles`.`foreign_key` IN (1, 2) | 6 | 6 | 0 | ||
| SELECT `Texts`.`id`, `Texts`.`locale`, `Texts`.`model`, `Texts`.`foreign_key`, `Texts`.`field`, `Texts`.`content` FROM `i18n` AS `Texts` WHERE `model` = 'Post' AND `field` = 'text' AND `Texts`.`foreign_key` IN (1, 2) | 6 | 6 | 0 | ||
| SELECT `Tags`.`id`, `Tags`.`locale`, `Tags`.`model`, `Tags`.`foreign_key`, `Tags`.`field`, `Tags`.`content` FROM `i18n` AS `Tags` WHERE `model` = 'Post' AND `field` = 'tags' AND `Tags`.`foreign_key` IN (1, 2) | 6 | 6 | 0 | ||
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `tags` AS `Tag` JOIN `tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (1, 2) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Post' | 0 | 0 | 0 | ||
| SHOW FULL COLUMNS FROM `contents` | 12 | 12 | 0 | ||
| SELECT `Configuration`.*, `I18n__value`.`content`, `Configuration`.`id` FROM `configurations` AS `Configuration` LEFT JOIN `i18n` AS `I18n__value` ON (`Configuration`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Configuration' AND `I18n__value`.`field` = 'value') WHERE `I18n__value`.`locale` = 'spa' | 15 | 15 | 0 | ||
| SELECT `Values`.`id`, `Values`.`locale`, `Values`.`model`, `Values`.`foreign_key`, `Values`.`field`, `Values`.`content` FROM `i18n` AS `Values` WHERE `model` = 'Configuration' AND `field` = 'value' AND `Values`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 11, 12, 13, 14) | 55 | 55 | 0 | ||
| SELECT `Section`.*, `ParentSection`.*, `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` IS NULL AND `I18n__title`.`locale` = 'spa' ORDER BY `Section`.`sort` ASC | 3 | 3 | 0 | ||
| SELECT `Section`.*, `I18n__title`.`content` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') WHERE `Section`.`parent_id` = 12 AND `I18n__title`.`locale` = 'spa' ORDER BY `Section`.`sort` ASC | 2 | 2 | 0 | ||
| SELECT `Configuration`.*, `I18n__value`.`content`, `Configuration`.`id` FROM `configurations` AS `Configuration` LEFT JOIN `i18n` AS `I18n__value` ON (`Configuration`.`id` = `I18n__value`.`foreign_key` AND `I18n__value`.`model` = 'Configuration' AND `I18n__value`.`field` = 'value') WHERE `I18n__value`.`locale` = 'spa' | 15 | 15 | 0 | ||
| SELECT `Values`.`id`, `Values`.`locale`, `Values`.`model`, `Values`.`foreign_key`, `Values`.`field`, `Values`.`content` FROM `i18n` AS `Values` WHERE `model` = 'Configuration' AND `field` = 'value' AND `Values`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 11, 12, 13, 14) | 55 | 55 | 0 | ||
| SELECT `Section`.*, `ParentSection`.*, `I18n__title`.`content`, `Section`.`id` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') LEFT JOIN `sections` AS `ParentSection` ON (`Section`.`parent_id` = `ParentSection`.`id`) WHERE `Section`.`parent_id` IS NULL AND `I18n__title`.`locale` = 'spa' ORDER BY `Section`.`sort` ASC | 3 | 3 | 0 | ||
| SELECT `Section`.*, `I18n__title`.`content` FROM `sections` AS `Section` LEFT JOIN `i18n` AS `I18n__title` ON (`Section`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Section' AND `I18n__title`.`field` = 'title') WHERE `Section`.`parent_id` = 13 AND `I18n__title`.`locale` = 'spa' ORDER BY `Section`.`sort` ASC | 6 | 6 | 0 |
Peak Memory Use 11.01 MB
| Message | Memory use |
|---|---|
| Component intitailization | 7.55 MB |
| Controller action start | 8.02 MB |
| Controller render start | 8.19 MB |
| Component intitailization #2 | 10.24 MB |
| Controller action start #2 | 10.28 MB |
| Component intitailization #3 | 10.31 MB |
| Controller action start #3 | 10.34 MB |
| View render complete | 10.24 MB |
Total Request Time: 581 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived) | 327.91 | |
| Component initialization and startup | 28.61 | |
| Controller action | 23.79 | |
| Render Controller Action | 81.11 | |
| » Rendering View | 77.57 | |
| » » Rendering APP/views/posts/index.ctp | 23.22 | |
| » » Rendering APP/views/layouts/default.ctp | 53.81 | |
| » » » Rendering APP/views/elements/menu.ctp | 41.69 | |
| » » » » Component initialization and startup #2 | 9.71 | |
| Controller action #2 | 0.00 | |
| » » » » » Component initialization and startup #3 | 9.57 | |
| Controller action #3 | 0.00 |