No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `FrontpageSite`.`id`, `FrontpageSite`.`name`, `FrontpageSite`.`background_id`, `FrontpageSite`.`tagline`, `FrontpageSite`.`email`, `FrontpageSite`.`phone`, `FrontpageSite`.`recipients`, `FrontpageSite`.`signature`, `FrontpageSite`.`meta_title`, `FrontpageSite`.`meta_description`, `FrontpageSite`.`meta_keywords`, `FrontpageSite`.`created`, `FrontpageSite`.`modified`, `FrontpageSite`.`created_by`, `FrontpageSite`.`modified_by`, `FrontpageSite`.`status`, `FrontpageSite`.`google_analytics`, `FrontpageSite`.`ga_username`, `FrontpageSite`.`ga_password`, `FrontpageSite`.`ga_report_id`, `FrontpageSite`.`twitter_oauth_token`, `FrontpageSite`.`twitter_oauth_token_secret`, `FrontpageSite`.`vimeo_oauth_token`, `FrontpageSite`.`vimeo_oauth_token_secret`, `FrontpageSite`.`vimeo_album`, `FrontpageSite`.`aweber_oauth_token`, `FrontpageSite`.`aweber_oauth_token_secret`, `FrontpageSite`.`aweber_list`, `FrontpageSite`.`aweber_ad_tracking`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `snow_be`.`oc_frontpage_sites` AS `FrontpageSite` LEFT JOIN `snow_be`.`oc_users` AS `CreatedBy` ON (`FrontpageSite`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `snow_be`.`oc_users` AS `ModifiedBy` ON (`FrontpageSite`.`modified_by` = `ModifiedBy`.`id`) WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FrontpageRewrite`.`id`, `FrontpageRewrite`.`old`, `FrontpageRewrite`.`frontpage_page_id`, `FrontpageRewrite`.`created`, `FrontpageRewrite`.`created_by`, `FrontpageRewrite`.`modified`, `FrontpageRewrite`.`modified_by`, `FrontpageRewrite`.`status`, `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `CreatedBy`.`id`, `CreatedBy`.`user_group_id`, `CreatedBy`.`uid`, `CreatedBy`.`avatar_id`, `CreatedBy`.`email`, `CreatedBy`.`password`, `CreatedBy`.`first_name`, `CreatedBy`.`last_name`, `CreatedBy`.`locale`, `CreatedBy`.`created`, `CreatedBy`.`created_by`, `CreatedBy`.`modified`, `CreatedBy`.`modified_by`, `CreatedBy`.`status`, (CONCAT(`CreatedBy`.`first_name`, " ", `CreatedBy`.`last_name`)) AS `CreatedBy__name`, `ModifiedBy`.`id`, `ModifiedBy`.`user_group_id`, `ModifiedBy`.`uid`, `ModifiedBy`.`avatar_id`, `ModifiedBy`.`email`, `ModifiedBy`.`password`, `ModifiedBy`.`first_name`, `ModifiedBy`.`last_name`, `ModifiedBy`.`locale`, `ModifiedBy`.`created`, `ModifiedBy`.`created_by`, `ModifiedBy`.`modified`, `ModifiedBy`.`modified_by`, `ModifiedBy`.`status`, (CONCAT(`ModifiedBy`.`first_name`, " ", `ModifiedBy`.`last_name`)) AS `ModifiedBy__name` FROM `snow_be`.`oc_frontpage_rewrites` AS `FrontpageRewrite` LEFT JOIN `snow_be`.`oc_frontpage_pages` AS `FrontpagePage` ON (`FrontpageRewrite`.`frontpage_page_id` = `FrontpagePage`.`id`) LEFT JOIN `snow_be`.`oc_users` AS `CreatedBy` ON (`FrontpageRewrite`.`created_by` = `CreatedBy`.`id`) LEFT JOIN `snow_be`.`oc_users` AS `ModifiedBy` ON (`FrontpageRewrite`.`modified_by` = `ModifiedBy`.`id`) WHERE `FrontpageRewrite`.`old` = '/' AND `FrontpageRewrite`.`status` = 1 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `snow_be`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `snow_be`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`url` = '/' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FrontpagePage`.`nleft`, `FrontpagePage`.`nright` FROM `snow_be`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`id` = 16 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status` FROM `snow_be`.`oc_frontpage_pages` AS `FrontpagePage` WHERE 1 = 1 AND `FrontpagePage`.`nleft` <= 98 AND `FrontpagePage`.`nright` >= 99 ORDER BY `FrontpagePage`.`nleft` asc | 2 | 2 | 0 | |
| SELECT `FrontpageContentCategory`.`id` FROM `snow_be`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` WHERE `FrontpageContentCategory`.`slug` = 'hero' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FrontpageContent`.`id`, `FrontpageContent`.`frontpage_page_id`, `FrontpageContent`.`frontpage_content_category_id`, `FrontpageContent`.`image_id`, `FrontpageContent`.`image_alignment`, `FrontpageContent`.`image_link`, `FrontpageContent`.`document_id`, `FrontpageContent`.`youtube`, `FrontpageContent`.`vimeo`, `FrontpageContent`.`uid`, `FrontpageContent`.`sorting`, `FrontpageContent`.`title`, `FrontpageContent`.`embed`, `FrontpageContent`.`content`, `FrontpageContent`.`style`, `FrontpageContent`.`external_url`, `FrontpageContent`.`created`, `FrontpageContent`.`created_by`, `FrontpageContent`.`modified`, `FrontpageContent`.`modified_by`, `FrontpageContent`.`status`, `FrontpageContentCategory`.`id`, `FrontpageContentCategory`.`name`, `FrontpageContentCategory`.`slug`, `FrontpageContentCategory`.`created`, `FrontpageContentCategory`.`modified`, `Image`.`id`, `Image`.`parent_id`, `Image`.`uid`, `Image`.`name`, `Image`.`caption`, `Image`.`ext`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Image`.`sorting`, `Image`.`status`, `Image`.`path`, `Image`.`tags`, `Image`.`crop_params`, `Image`.`flash_video_ready`, `Image`.`video_thumbnail_ready`, `Image`.`asset_folder_id`, `Image`.`object`, `Image`.`object_id`, `Image`.`object_alias`, `Document`.`id`, `Document`.`parent_id`, `Document`.`uid`, `Document`.`name`, `Document`.`caption`, `Document`.`ext`, `Document`.`size`, `Document`.`width`, `Document`.`height`, `Document`.`created`, `Document`.`created_by`, `Document`.`modified`, `Document`.`modified_by`, `Document`.`sorting`, `Document`.`status`, `Document`.`path`, `Document`.`tags`, `Document`.`crop_params`, `Document`.`flash_video_ready`, `Document`.`video_thumbnail_ready`, `Document`.`asset_folder_id`, `Document`.`object`, `Document`.`object_id`, `Document`.`object_alias` FROM `snow_be`.`oc_frontpage_contents` AS `FrontpageContent` LEFT JOIN `snow_be`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` ON (`FrontpageContent`.`frontpage_content_category_id` = `FrontpageContentCategory`.`id`) LEFT JOIN `snow_be`.`oc_assets` AS `Image` ON (`FrontpageContent`.`image_id` = `Image`.`id`) LEFT JOIN `snow_be`.`oc_assets` AS `Document` ON (`FrontpageContent`.`document_id` = `Document`.`id`) WHERE `FrontpageContent`.`frontpage_page_id` = 16 AND `FrontpageContent`.`status` = 1 AND `FrontpageContent`.`frontpage_content_category_id` = 2 ORDER BY `FrontpageContent`.`sorting` asc | 0 | 0 | 1 | maybe slow |
| SELECT `FrontpageContentCategory`.`id` FROM `snow_be`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` WHERE `FrontpageContentCategory`.`slug` = 'left' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FrontpageContent`.`id`, `FrontpageContent`.`frontpage_page_id`, `FrontpageContent`.`frontpage_content_category_id`, `FrontpageContent`.`image_id`, `FrontpageContent`.`image_alignment`, `FrontpageContent`.`image_link`, `FrontpageContent`.`document_id`, `FrontpageContent`.`youtube`, `FrontpageContent`.`vimeo`, `FrontpageContent`.`uid`, `FrontpageContent`.`sorting`, `FrontpageContent`.`title`, `FrontpageContent`.`embed`, `FrontpageContent`.`content`, `FrontpageContent`.`style`, `FrontpageContent`.`external_url`, `FrontpageContent`.`created`, `FrontpageContent`.`created_by`, `FrontpageContent`.`modified`, `FrontpageContent`.`modified_by`, `FrontpageContent`.`status`, `FrontpageContentCategory`.`id`, `FrontpageContentCategory`.`name`, `FrontpageContentCategory`.`slug`, `FrontpageContentCategory`.`created`, `FrontpageContentCategory`.`modified`, `Image`.`id`, `Image`.`parent_id`, `Image`.`uid`, `Image`.`name`, `Image`.`caption`, `Image`.`ext`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Image`.`sorting`, `Image`.`status`, `Image`.`path`, `Image`.`tags`, `Image`.`crop_params`, `Image`.`flash_video_ready`, `Image`.`video_thumbnail_ready`, `Image`.`asset_folder_id`, `Image`.`object`, `Image`.`object_id`, `Image`.`object_alias`, `Document`.`id`, `Document`.`parent_id`, `Document`.`uid`, `Document`.`name`, `Document`.`caption`, `Document`.`ext`, `Document`.`size`, `Document`.`width`, `Document`.`height`, `Document`.`created`, `Document`.`created_by`, `Document`.`modified`, `Document`.`modified_by`, `Document`.`sorting`, `Document`.`status`, `Document`.`path`, `Document`.`tags`, `Document`.`crop_params`, `Document`.`flash_video_ready`, `Document`.`video_thumbnail_ready`, `Document`.`asset_folder_id`, `Document`.`object`, `Document`.`object_id`, `Document`.`object_alias` FROM `snow_be`.`oc_frontpage_contents` AS `FrontpageContent` LEFT JOIN `snow_be`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` ON (`FrontpageContent`.`frontpage_content_category_id` = `FrontpageContentCategory`.`id`) LEFT JOIN `snow_be`.`oc_assets` AS `Image` ON (`FrontpageContent`.`image_id` = `Image`.`id`) LEFT JOIN `snow_be`.`oc_assets` AS `Document` ON (`FrontpageContent`.`document_id` = `Document`.`id`) WHERE `FrontpageContent`.`frontpage_page_id` = 16 AND `FrontpageContent`.`status` = 1 AND `FrontpageContent`.`frontpage_content_category_id` = 4 ORDER BY `FrontpageContent`.`sorting` asc | 0 | 0 | 0 | |
| SELECT `FrontpageContentCategory`.`id` FROM `snow_be`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` WHERE `FrontpageContentCategory`.`slug` = 'middle' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FrontpageContent`.`id`, `FrontpageContent`.`frontpage_page_id`, `FrontpageContent`.`frontpage_content_category_id`, `FrontpageContent`.`image_id`, `FrontpageContent`.`image_alignment`, `FrontpageContent`.`image_link`, `FrontpageContent`.`document_id`, `FrontpageContent`.`youtube`, `FrontpageContent`.`vimeo`, `FrontpageContent`.`uid`, `FrontpageContent`.`sorting`, `FrontpageContent`.`title`, `FrontpageContent`.`embed`, `FrontpageContent`.`content`, `FrontpageContent`.`style`, `FrontpageContent`.`external_url`, `FrontpageContent`.`created`, `FrontpageContent`.`created_by`, `FrontpageContent`.`modified`, `FrontpageContent`.`modified_by`, `FrontpageContent`.`status`, `FrontpageContentCategory`.`id`, `FrontpageContentCategory`.`name`, `FrontpageContentCategory`.`slug`, `FrontpageContentCategory`.`created`, `FrontpageContentCategory`.`modified`, `Image`.`id`, `Image`.`parent_id`, `Image`.`uid`, `Image`.`name`, `Image`.`caption`, `Image`.`ext`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Image`.`sorting`, `Image`.`status`, `Image`.`path`, `Image`.`tags`, `Image`.`crop_params`, `Image`.`flash_video_ready`, `Image`.`video_thumbnail_ready`, `Image`.`asset_folder_id`, `Image`.`object`, `Image`.`object_id`, `Image`.`object_alias`, `Document`.`id`, `Document`.`parent_id`, `Document`.`uid`, `Document`.`name`, `Document`.`caption`, `Document`.`ext`, `Document`.`size`, `Document`.`width`, `Document`.`height`, `Document`.`created`, `Document`.`created_by`, `Document`.`modified`, `Document`.`modified_by`, `Document`.`sorting`, `Document`.`status`, `Document`.`path`, `Document`.`tags`, `Document`.`crop_params`, `Document`.`flash_video_ready`, `Document`.`video_thumbnail_ready`, `Document`.`asset_folder_id`, `Document`.`object`, `Document`.`object_id`, `Document`.`object_alias` FROM `snow_be`.`oc_frontpage_contents` AS `FrontpageContent` LEFT JOIN `snow_be`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` ON (`FrontpageContent`.`frontpage_content_category_id` = `FrontpageContentCategory`.`id`) LEFT JOIN `snow_be`.`oc_assets` AS `Image` ON (`FrontpageContent`.`image_id` = `Image`.`id`) LEFT JOIN `snow_be`.`oc_assets` AS `Document` ON (`FrontpageContent`.`document_id` = `Document`.`id`) WHERE `FrontpageContent`.`frontpage_page_id` = 16 AND `FrontpageContent`.`status` = 1 AND `FrontpageContent`.`frontpage_content_category_id` = 5 ORDER BY `FrontpageContent`.`sorting` asc | 0 | 0 | 1 | maybe slow |
| SELECT `FrontpageContentCategory`.`id` FROM `snow_be`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` WHERE `FrontpageContentCategory`.`slug` = 'right' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FrontpageContent`.`id`, `FrontpageContent`.`frontpage_page_id`, `FrontpageContent`.`frontpage_content_category_id`, `FrontpageContent`.`image_id`, `FrontpageContent`.`image_alignment`, `FrontpageContent`.`image_link`, `FrontpageContent`.`document_id`, `FrontpageContent`.`youtube`, `FrontpageContent`.`vimeo`, `FrontpageContent`.`uid`, `FrontpageContent`.`sorting`, `FrontpageContent`.`title`, `FrontpageContent`.`embed`, `FrontpageContent`.`content`, `FrontpageContent`.`style`, `FrontpageContent`.`external_url`, `FrontpageContent`.`created`, `FrontpageContent`.`created_by`, `FrontpageContent`.`modified`, `FrontpageContent`.`modified_by`, `FrontpageContent`.`status`, `FrontpageContentCategory`.`id`, `FrontpageContentCategory`.`name`, `FrontpageContentCategory`.`slug`, `FrontpageContentCategory`.`created`, `FrontpageContentCategory`.`modified`, `Image`.`id`, `Image`.`parent_id`, `Image`.`uid`, `Image`.`name`, `Image`.`caption`, `Image`.`ext`, `Image`.`size`, `Image`.`width`, `Image`.`height`, `Image`.`created`, `Image`.`created_by`, `Image`.`modified`, `Image`.`modified_by`, `Image`.`sorting`, `Image`.`status`, `Image`.`path`, `Image`.`tags`, `Image`.`crop_params`, `Image`.`flash_video_ready`, `Image`.`video_thumbnail_ready`, `Image`.`asset_folder_id`, `Image`.`object`, `Image`.`object_id`, `Image`.`object_alias`, `Document`.`id`, `Document`.`parent_id`, `Document`.`uid`, `Document`.`name`, `Document`.`caption`, `Document`.`ext`, `Document`.`size`, `Document`.`width`, `Document`.`height`, `Document`.`created`, `Document`.`created_by`, `Document`.`modified`, `Document`.`modified_by`, `Document`.`sorting`, `Document`.`status`, `Document`.`path`, `Document`.`tags`, `Document`.`crop_params`, `Document`.`flash_video_ready`, `Document`.`video_thumbnail_ready`, `Document`.`asset_folder_id`, `Document`.`object`, `Document`.`object_id`, `Document`.`object_alias` FROM `snow_be`.`oc_frontpage_contents` AS `FrontpageContent` LEFT JOIN `snow_be`.`oc_frontpage_content_categories` AS `FrontpageContentCategory` ON (`FrontpageContent`.`frontpage_content_category_id` = `FrontpageContentCategory`.`id`) LEFT JOIN `snow_be`.`oc_assets` AS `Image` ON (`FrontpageContent`.`image_id` = `Image`.`id`) LEFT JOIN `snow_be`.`oc_assets` AS `Document` ON (`FrontpageContent`.`document_id` = `Document`.`id`) WHERE `FrontpageContent`.`frontpage_page_id` = 16 AND `FrontpageContent`.`status` = 1 AND `FrontpageContent`.`frontpage_content_category_id` = 6 ORDER BY `FrontpageContent`.`sorting` asc | 0 | 0 | 1 | maybe slow |
| SELECT `FrontpagePage`.`id` FROM `snow_be`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'main' AND `FrontpagePage`.`type` = 'folder' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `snow_be`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `snow_be`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 1 AND `FrontpagePage`.`type` = ('page') ORDER BY `FrontpagePage`.`nleft` asc | 0 | 0 | 0 | |
| SELECT `FrontpagePage`.`id` FROM `snow_be`.`oc_frontpage_pages` AS `FrontpagePage` WHERE `FrontpagePage`.`folder_key` = 'footer' AND `FrontpagePage`.`type` = 'folder' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `FrontpagePage`.`id`, `FrontpagePage`.`parent_id`, `FrontpagePage`.`nleft`, `FrontpagePage`.`nright`, `FrontpagePage`.`level`, `FrontpagePage`.`sorting`, `FrontpagePage`.`name`, `FrontpagePage`.`title`, `FrontpagePage`.`slug`, `FrontpagePage`.`type`, `FrontpagePage`.`url`, `FrontpagePage`.`folder_key`, `FrontpagePage`.`alias_id`, `FrontpagePage`.`meta_title`, `FrontpagePage`.`meta_keywords`, `FrontpagePage`.`meta_description`, `FrontpagePage`.`in_sitemap`, `FrontpagePage`.`sitemap_modified`, `FrontpagePage`.`sitemap_changes`, `FrontpagePage`.`sitemap_priority`, `FrontpagePage`.`is_homepage`, `FrontpagePage`.`in_routes`, `FrontpagePage`.`in_navigation`, `FrontpagePage`.`is_404page`, `FrontpagePage`.`layout_file`, `FrontpagePage`.`layout_file_recursive`, `FrontpagePage`.`view_file`, `FrontpagePage`.`view_file_recursive`, `FrontpagePage`.`use_url_as_view`, `FrontpagePage`.`meta_title_template`, `FrontpagePage`.`options`, `FrontpagePage`.`options_local`, `FrontpagePage`.`tags`, `FrontpagePage`.`notes`, `FrontpagePage`.`created`, `FrontpagePage`.`created_by`, `FrontpagePage`.`modified`, `FrontpagePage`.`modified_by`, `FrontpagePage`.`status`, `Alias`.`id`, `Alias`.`parent_id`, `Alias`.`nleft`, `Alias`.`nright`, `Alias`.`level`, `Alias`.`sorting`, `Alias`.`name`, `Alias`.`title`, `Alias`.`slug`, `Alias`.`type`, `Alias`.`url`, `Alias`.`folder_key`, `Alias`.`alias_id`, `Alias`.`meta_title`, `Alias`.`meta_keywords`, `Alias`.`meta_description`, `Alias`.`in_sitemap`, `Alias`.`sitemap_modified`, `Alias`.`sitemap_changes`, `Alias`.`sitemap_priority`, `Alias`.`is_homepage`, `Alias`.`in_routes`, `Alias`.`in_navigation`, `Alias`.`is_404page`, `Alias`.`layout_file`, `Alias`.`layout_file_recursive`, `Alias`.`view_file`, `Alias`.`view_file_recursive`, `Alias`.`use_url_as_view`, `Alias`.`meta_title_template`, `Alias`.`options`, `Alias`.`options_local`, `Alias`.`tags`, `Alias`.`notes`, `Alias`.`created`, `Alias`.`created_by`, `Alias`.`modified`, `Alias`.`modified_by`, `Alias`.`status` FROM `snow_be`.`oc_frontpage_pages` AS `FrontpagePage` LEFT JOIN `snow_be`.`oc_frontpage_pages` AS `Alias` ON (`FrontpagePage`.`alias_id` = `Alias`.`id`) WHERE `FrontpagePage`.`status` = 1 AND `FrontpagePage`.`parent_id` = 29 AND `FrontpagePage`.`type` = ('page') ORDER BY `FrontpagePage`.`nleft` asc | 0 | 0 | 0 |
Peak Memory Use 17.02 MB
| Message | Memory use |
|---|---|
| Component initialization | 6.14 MB |
| Controller action start | 10.94 MB |
| Controller render start | 11.80 MB |
| View render complete | 16.12 MB |
Total Request Time: 207 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 37.61 | |
| Component initialization and startup | 50.23 | |
| Controller action | 5.22 | |
| Render Controller Action | 80.96 | |
| » Rendering View | 79.55 | |
| » » Rendering APP/Plugin/Frontpage/View/FrontpagePages/home.ctp | 47.63 | |
| » » » Rendering APP/Plugin/Frontpage/View/Elements/content.ctp | 34.04 | |
| » » » Rendering APP/Plugin/Frontpage/View/Elements/content.ctp #2 | 3.94 | |
| » » » Rendering APP/Plugin/Frontpage/View/Elements/content.ctp #3 | 4.08 | |
| » » » Rendering APP/Plugin/Frontpage/View/Elements/content.ctp #4 | 3.99 | |
| » » Rendering APP/Plugin/Frontpage/View/Layouts/home.ctp #2 | 11.03 | |
| » » » Rendering APP/Plugin/Frontpage/View/Elements/header.ctp | 1.17 | |
| » » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp | 2.89 | |
| » » » Rendering APP/Plugin/Frontpage/View/Elements/footer.ctp | 5.46 | |
| » » » » Rendering APP/Plugin/Frontpage/View/Elements/navigation.ctp #2 | 2.88 |