No post data.
To view Cookies, add CookieComponent to Controller
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Page`.`id`, `Page`.`slug`, `Page`.`caption`, `Page`.`caption_2`, `Page`.`content`, `Page`.`caption_3`, `Page`.`content_2`, `Page`.`caption_4`, `Page`.`content_3`, `Page`.`content_4`, `Page`.`caption_5`, `Page`.`content_5`, `Page`.`image`, `Page`.`image_2`, `Page`.`image_3`, `Page`.`image_api`, `Page`.`video`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`modified`, `Page`.`disabled`, (`I18n__caption`.`content`) AS `Page__i18n_caption`, (`I18n__content`.`content`) AS `Page__i18n_content`, (`I18n__content_2`.`content`) AS `Page__i18n_content_2`, (`I18n__content_3`.`content`) AS `Page__i18n_content_3`, (`I18n__content_4`.`content`) AS `Page__i18n_content_4`, (`I18n__disabled`.`content`) AS `Page__i18n_disabled`, (`I18n__meta_title`.`content`) AS `Page__i18n_meta_title`, (`I18n__meta_description`.`content`) AS `Page__i18n_meta_description`, (`I18n__caption_2`.`content`) AS `Page__i18n_caption_2`, (`I18n__caption_3`.`content`) AS `Page__i18n_caption_3`, (`I18n__caption_4`.`content`) AS `Page__i18n_caption_4`, (`I18n__caption_5`.`content`) AS `Page__i18n_caption_5`, (`I18n__content_5`.`content`) AS `Page__i18n_content_5` FROM `petersburg24`.`pages` AS `Page` LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`Page`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'Page' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content` ON (`Page`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Page' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_2` ON (`Page`.`id` = `I18n__content_2`.`foreign_key` AND `I18n__content_2`.`model` = 'Page' AND `I18n__content_2`.`field` = 'content_2' AND `I18n__content_2`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_3` ON (`Page`.`id` = `I18n__content_3`.`foreign_key` AND `I18n__content_3`.`model` = 'Page' AND `I18n__content_3`.`field` = 'content_3' AND `I18n__content_3`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_4` ON (`Page`.`id` = `I18n__content_4`.`foreign_key` AND `I18n__content_4`.`model` = 'Page' AND `I18n__content_4`.`field` = 'content_4' AND `I18n__content_4`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`Page`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Page' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__meta_title` ON (`Page`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'Page' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__meta_description` ON (`Page`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Page' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption_2` ON (`Page`.`id` = `I18n__caption_2`.`foreign_key` AND `I18n__caption_2`.`model` = 'Page' AND `I18n__caption_2`.`field` = 'caption_2' AND `I18n__caption_2`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption_3` ON (`Page`.`id` = `I18n__caption_3`.`foreign_key` AND `I18n__caption_3`.`model` = 'Page' AND `I18n__caption_3`.`field` = 'caption_3' AND `I18n__caption_3`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption_4` ON (`Page`.`id` = `I18n__caption_4`.`foreign_key` AND `I18n__caption_4`.`model` = 'Page' AND `I18n__caption_4`.`field` = 'caption_4' AND `I18n__caption_4`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption_5` ON (`Page`.`id` = `I18n__caption_5`.`foreign_key` AND `I18n__caption_5`.`model` = 'Page' AND `I18n__caption_5`.`field` = 'caption_5' AND `I18n__caption_5`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_5` ON (`Page`.`id` = `I18n__content_5`.`foreign_key` AND `I18n__content_5`.`model` = 'Page' AND `I18n__content_5`.`field` = 'content_5' AND `I18n__content_5`.`locale` = 'rus') WHERE `I18n__disabled`.`content` = '0' AND `Page`.`id` = 12 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Page`.`id`, (`I18n__caption`.`content`) AS `Page__i18n_caption`, (`I18n__disabled`.`content`) AS `Page__i18n_disabled` FROM `petersburg24`.`pages` AS `Page` LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`Page`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'Page' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`Page`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Page' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') WHERE `I18n__disabled`.`content` = '0' AND `Page`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
SELECT `PagePost`.`id`, `PagePost`.`page_id`, `PagePost`.`post_id`, `PagePost`.`x`, `PagePost`.`y` FROM `petersburg24`.`page_posts` AS `PagePost` WHERE `PagePost`.`page_id` = (3) | 0 | 0 | 0 | |
SELECT `ArticleRubric`.`id`, `ArticleRubric`.`parent_id`, `ArticleRubric`.`lft`, `ArticleRubric`.`rght`, `ArticleRubric`.`level`, `ArticleRubric`.`slug`, `ArticleRubric`.`caption`, `ArticleRubric`.`caption_api`, `ArticleRubric`.`caption_2`, `ArticleRubric`.`type`, `ArticleRubric`.`content`, `ArticleRubric`.`image`, `ArticleRubric`.`thumbnail`, `ArticleRubric`.`svg`, `ArticleRubric`.`meta_title`, `ArticleRubric`.`meta_description`, `ArticleRubric`.`position`, `ArticleRubric`.`hidden`, `ArticleRubric`.`api_main`, `ArticleRubric`.`api_nearby_disabled`, `ArticleRubric`.`disabled`, `ArticleRubric`.`created`, `ArticleRubric`.`modified`, (`I18n__type`.`content`) AS `ArticleRubric__i18n_type`, (`I18n__caption`.`content`) AS `ArticleRubric__i18n_caption`, (`I18n__caption_api`.`content`) AS `ArticleRubric__i18n_caption_api`, (`I18n__caption_2`.`content`) AS `ArticleRubric__i18n_caption_2`, (`I18n__meta_title`.`content`) AS `ArticleRubric__i18n_meta_title`, (`I18n__meta_description`.`content`) AS `ArticleRubric__i18n_meta_description`, (`I18n__disabled`.`content`) AS `ArticleRubric__i18n_disabled` FROM `petersburg24`.`article_rubrics` AS `ArticleRubric` left JOIN `petersburg24`.`i18n` AS `I18n__type` ON (`ArticleRubric`.`id` = `I18n__type`.`foreign_key` AND `I18n__type`.`model` = 'ArticleRubric' AND `I18n__type`.`field` = 'type' AND `I18n__type`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`ArticleRubric`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'ArticleRubric' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__caption_api` ON (`ArticleRubric`.`id` = `I18n__caption_api`.`foreign_key` AND `I18n__caption_api`.`model` = 'ArticleRubric' AND `I18n__caption_api`.`field` = 'caption_api' AND `I18n__caption_api`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__caption_2` ON (`ArticleRubric`.`id` = `I18n__caption_2`.`foreign_key` AND `I18n__caption_2`.`model` = 'ArticleRubric' AND `I18n__caption_2`.`field` = 'caption_2' AND `I18n__caption_2`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__meta_title` ON (`ArticleRubric`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'ArticleRubric' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__meta_description` ON (`ArticleRubric`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'ArticleRubric' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`ArticleRubric`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'ArticleRubric' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') WHERE `ArticleRubric`.`hidden` = '0' AND `I18n__disabled`.`content` = '0' AND `ArticleRubric`.`slug` = 'hramy' ORDER BY `ArticleRubric`.`position` DESC, `ArticleRubric`.`id` DESC LIMIT 1 | 1 | 1 | 6 | maybe slow |
SELECT `Article`.`id`, `Article`.`cloned_id`, `Article`.`account_id`, `Article`.`article_rubric_id`, `Article`.`slug`, `Article`.`type`, `Article`.`caption`, `Article`.`caption_a`, `Article`.`address`, `Article`.`brief`, `Article`.`content`, `Article`.`times`, `Article`.`itype`, `Article`.`image`, `Article`.`thumbnail`, `Article`.`thumbnail_1`, `Article`.`thumbnail_2`, `Article`.`_thumbnail`, `Article`.`video`, `Article`.`map_caption`, `Article`.`map_n`, `Article`.`map_e`, `Article`.`meta_title`, `Article`.`meta_description`, `Article`.`position`, `Article`.`pay`, `Article`.`supplier_id`, `Article`.`price`, `Article`.`supplier_price`, `Article`.`active`, `Article`.`checked`, `Article`.`m_reason`, `Article`.`show_han`, `Article`.`night`, `Article`.`nearby`, `Article`.`main_adv`, `Article`.`views`, `Article`.`disabled`, `Article`.`created`, `Article`.`modified` FROM `petersburg24`.`articles` AS `Article` WHERE `Article`.`article_rubric_id` = (30) ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC | 140 | 140 | 8 | maybe slow |
SELECT `Apropose`.`id`, `Apropose`.`excursion_id`, `Apropose`.`caption`, `Apropose`.`content`, `Apropose`.`link`, `Apropose`.`image`, `Apropose`.`position`, `Apropose`.`disabled`, `AproposesArticleRubric`.`id`, `AproposesArticleRubric`.`apropose_id`, `AproposesArticleRubric`.`article_rubric_id` FROM `petersburg24`.`aproposes` AS `Apropose` JOIN `petersburg24`.`aproposes_article_rubrics` AS `AproposesArticleRubric` ON (`AproposesArticleRubric`.`article_rubric_id` = 30 AND `AproposesArticleRubric`.`apropose_id` = `Apropose`.`id`) | 2 | 2 | 1 | maybe slow |
SELECT `ParamRubric`.`id`, `ParamRubric`.`caption`, `ParamRubric`.`unit`, `ParamRubric`.`position`, `ParamRubric`.`disabled`, `ArticleRubricsParamRubric`.`id`, `ArticleRubricsParamRubric`.`article_rubric_id`, `ArticleRubricsParamRubric`.`param_rubric_id`, I18n__caption.content AS ParamRubric__i18n_caption, I18n__unit.content AS ParamRubric__i18n_unit, I18n__disabled.content AS ParamRubric__i18n_disabled FROM `petersburg24`.`param_rubrics` AS `ParamRubric` LEFT JOIN `petersburg24`.`article_rubrics_param_rubrics` AS `ArticleRubricsParamRubric` ON (`ParamRubric`.`id` = `ArticleRubricsParamRubric`.`param_rubric_id`) LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`ParamRubric`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'ParamRubric' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__unit` ON (`ParamRubric`.`id` = `I18n__unit`.`foreign_key` AND `I18n__unit`.`model` = 'ParamRubric' AND `I18n__unit`.`field` = 'unit' AND `I18n__unit`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`ParamRubric`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'ParamRubric' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') WHERE `ArticleRubricsParamRubric`.`article_rubric_id` = ('30') AND `I18n__disabled`.`content` = '0' ORDER BY `ParamRubric`.`position` DESC, `ParamRubric`.`id` DESC | 1 | 1 | 5 | maybe slow |
SELECT `ArsArticle`.`id`, `ArsArticle`.`article_rubric_id`, `ArsArticle`.`article_id` FROM `petersburg24`.`ars_articles` AS `ArsArticle` JOIN `petersburg24`.`articles` AS `A` ON (`ArsArticle`.`article_id` = `A`.`id`) JOIN `petersburg24`.`article_rubrics` AS `AR` ON (`A`.`article_rubric_id` = `AR`.`id`) WHERE `ArsArticle`.`article_rubric_id` = 30 | 9 | 9 | 1 | maybe slow |
SELECT `ArticleRubric`.`id`, `ArticleRubric`.`slug`, (`I18n__caption`.`content`) AS `ArticleRubric__i18n_caption`, (`I18n__disabled`.`content`) AS `ArticleRubric__i18n_disabled` FROM `petersburg24`.`article_rubrics` AS `ArticleRubric` left JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`ArticleRubric`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'ArticleRubric' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`ArticleRubric`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'ArticleRubric' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') WHERE `ArticleRubric`.`hidden` = '0' AND `I18n__disabled`.`content` = '0' AND `parent_id` = 133 ORDER BY `ArticleRubric`.`position` DESC, `ArticleRubric`.`id` DESC | 6 | 6 | 0 | |
SELECT `Article`.`id` FROM `petersburg24`.`articles` AS `Article` WHERE ((`Article`.`article_rubric_id` = 30) OR (`Article`.`id` IN (209, 210, 211, 341, 384, 2574, 3658, 3883, 4583))) AND `Article`.`active` = '0' ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC | 0 | 0 | 2 | maybe slow |
SELECT `Article`.`id`, `Article`.`cloned_id`, `Article`.`account_id`, `Article`.`article_rubric_id`, `Article`.`slug`, `Article`.`type`, `Article`.`caption`, `Article`.`caption_a`, `Article`.`address`, `Article`.`brief`, `Article`.`content`, `Article`.`times`, `Article`.`itype`, `Article`.`image`, `Article`.`thumbnail`, `Article`.`thumbnail_1`, `Article`.`thumbnail_2`, `Article`.`_thumbnail`, `Article`.`video`, `Article`.`map_caption`, `Article`.`map_n`, `Article`.`map_e`, `Article`.`meta_title`, `Article`.`meta_description`, `Article`.`position`, `Article`.`pay`, `Article`.`supplier_id`, `Article`.`price`, `Article`.`supplier_price`, `Article`.`active`, `Article`.`checked`, `Article`.`m_reason`, `Article`.`show_han`, `Article`.`night`, `Article`.`nearby`, `Article`.`main_adv`, `Article`.`views`, `Article`.`disabled`, `Article`.`created`, `Article`.`modified`, (`I18n__caption`.`content`) AS `Article__i18n_caption`, (`I18n__caption_a`.`content`) AS `Article__i18n_caption_a`, (`I18n__address`.`content`) AS `Article__i18n_address`, (`I18n__brief`.`content`) AS `Article__i18n_brief`, (`I18n__content`.`content`) AS `Article__i18n_content`, (`I18n__times`.`content`) AS `Article__i18n_times`, (`I18n__meta_title`.`content`) AS `Article__i18n_meta_title`, (`I18n__meta_description`.`content`) AS `Article__i18n_meta_description`, (`I18n__disabled`.`content`) AS `Article__i18n_disabled`, (`I18n__active`.`content`) AS `Article__i18n_active` FROM `petersburg24`.`articles` AS `Article` left JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`Article`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'Article' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__caption_a` ON (`Article`.`id` = `I18n__caption_a`.`foreign_key` AND `I18n__caption_a`.`model` = 'Article' AND `I18n__caption_a`.`field` = 'caption_a' AND `I18n__caption_a`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__address` ON (`Article`.`id` = `I18n__address`.`foreign_key` AND `I18n__address`.`model` = 'Article' AND `I18n__address`.`field` = 'address' AND `I18n__address`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__brief` ON (`Article`.`id` = `I18n__brief`.`foreign_key` AND `I18n__brief`.`model` = 'Article' AND `I18n__brief`.`field` = 'brief' AND `I18n__brief`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__content` ON (`Article`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Article' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__times` ON (`Article`.`id` = `I18n__times`.`foreign_key` AND `I18n__times`.`model` = 'Article' AND `I18n__times`.`field` = 'times' AND `I18n__times`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__meta_title` ON (`Article`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'Article' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__meta_description` ON (`Article`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Article' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`Article`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Article' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__active` ON (`Article`.`id` = `I18n__active`.`foreign_key` AND `I18n__active`.`model` = 'Article' AND `I18n__active`.`field` = 'active' AND `I18n__active`.`locale` = 'rus') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND ((`Article`.`cloned_id` IS NULL) OR (`Article`.`cloned_id` IS NULL)) AND ((`Article`.`article_rubric_id` = 30) OR (`Article`.`id` IN (209, 210, 211, 341, 384, 2574, 3658, 3883, 4583))) ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC LIMIT 20, 20 | 20 | 20 | 95 | maybe slow |
SELECT COUNT(DISTINCT Article.id) AS count, (`I18n__disabled`.`content`) AS `Article__i18n_disabled`, (`I18n__active`.`content`) AS `Article__i18n_active`, `Article`.`id` FROM `petersburg24`.`articles` AS `Article` LEFT JOIN `petersburg24`.`article_rubrics` AS `ArticleRubric` ON (`Article`.`article_rubric_id` = `ArticleRubric`.`id`) LEFT JOIN `petersburg24`.`accounts` AS `Account` ON (`Article`.`account_id` = `Account`.`id`) LEFT JOIN `petersburg24`.`suppliers` AS `Supplier` ON (`Article`.`supplier_id` = `Supplier`.`id`) left JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`Article`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Article' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__active` ON (`Article`.`id` = `I18n__active`.`foreign_key` AND `I18n__active`.`model` = 'Article' AND `I18n__active`.`field` = 'active' AND `I18n__active`.`locale` = 'rus') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND ((`Article`.`cloned_id` IS NULL) OR (`Article`.`cloned_id` IS NULL)) AND ((`Article`.`article_rubric_id` = 30) OR (`Article`.`id` IN (209, 210, 211, 341, 384, 2574, 3658, 3883, 4583))) | 1 | 1 | 33 | maybe slow |
SELECT `AttachmentImage`.`id`, `AttachmentImage`.`model`, `AttachmentImage`.`foreign_key`, `AttachmentImage`.`caption`, `AttachmentImage`.`image`, `AttachmentImage`.`thumbnail`, `AttachmentImage`.`_thumbnail`, `AttachmentImage`.`position`, `AttachmentImage`.`disabled` FROM `petersburg24`.`attachment_images` AS `AttachmentImage` WHERE `model` = 'Article' AND `AttachmentImage`.`foreign_key` = (69) ORDER BY `AttachmentImage`.`position` DESC, `AttachmentImage`.`id` DESC | 4 | 4 | 3 | maybe slow |
SELECT `ArticlesTime`.`id`, `ArticlesTime`.`article_id`, `ArticlesTime`.`day`, `ArticlesTime`.`time_from`, `ArticlesTime`.`time_to`, `ArticlesTime`.`type` FROM `petersburg24`.`articles_times` AS `ArticlesTime` WHERE `ArticlesTime`.`article_id` = (69) ORDER BY `ArticlesTime`.`article_id` DESC, `ArticlesTime`.`day` ASC | 7 | 7 | 0 | |
SELECT `ArticleRubric`.`id`, `ArticleRubric`.`slug`, `ArticleRubric`.`svg`, `ArticleRubric`.`hidden`, (`I18n__caption`.`content`) AS `ArticleRubric__i18n_caption`, (`I18n__disabled`.`content`) AS `ArticleRubric__i18n_disabled` FROM `petersburg24`.`article_rubrics` AS `ArticleRubric` left JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`ArticleRubric`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'ArticleRubric' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`ArticleRubric`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'ArticleRubric' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') WHERE `I18n__disabled`.`content` = '0' AND `ArticleRubric`.`id` = (30) ORDER BY `ArticleRubric`.`position` DESC, `ArticleRubric`.`id` DESC | 1 | 1 | 3 | maybe slow |
SELECT `ArticleRubric`.`lft`, `ArticleRubric`.`rght`, (`I18n__disabled`.`content`) AS `ArticleRubric__i18n_disabled` FROM `petersburg24`.`article_rubrics` AS `ArticleRubric` left JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`ArticleRubric`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'ArticleRubric' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') WHERE `ArticleRubric`.`hidden` = '0' AND `I18n__disabled`.`content` = '0' AND `ArticleRubric`.`id` = 30 LIMIT 1 | 1 | 1 | 1 | |
SELECT `ArticleRubric`.`id`, `ArticleRubric`.`parent_id`, `ArticleRubric`.`slug`, (`I18n__caption`.`content`) AS `ArticleRubric__i18n_caption`, (`I18n__disabled`.`content`) AS `ArticleRubric__i18n_disabled` FROM `petersburg24`.`article_rubrics` AS `ArticleRubric` left JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`ArticleRubric`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'ArticleRubric' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`ArticleRubric`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'ArticleRubric' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') WHERE `ArticleRubric`.`hidden` = '0' AND `I18n__disabled`.`content` = '0' AND 1 = 1 AND `ArticleRubric`.`lft` <= 252 AND `ArticleRubric`.`rght` >= 253 ORDER BY `ArticleRubric`.`lft` asc | 2 | 2 | 3 | maybe slow |
Peak Memory Use 19.86 MB
Message | Memory use |
---|---|
Component initialization | 1.75 MB |
Controller action start | 3.64 MB |
Controller render start | 8.99 MB |
View render complete | 9.57 MB |
Total Request Time: 991 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 7.58 | |
Event: Controller.initialize | 18.16 | |
Event: Controller.startup | 60.48 | |
Controller action | 852.12 | |
Event: Controller.beforeRender | 36.81 | |
» Processing toolbar data | 36.42 | |
Rendering View | 9.95 | |
» Event: View.beforeRender | 0.04 | |
» Rendering APP/View/Articles/index.ctp | 2.29 | |
» » Rendering APP/View/Elements/layouts/bc.ctp | 0.12 | |
» » Rendering APP/View/Elements/layouts/paginator.ctp | 1.26 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering APP/View/Layouts/default.ctp | 6.59 | |
» » Rendering APP/View/Elements/layouts/header.ctp | 2.37 | |
» » Rendering APP/View/Elements/layouts/footer.ctp | 2.84 | |
Event: View.afterLayout | 0.00 |