| 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 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`project_title`, `Setting`.`info`, `Setting`.`favicon`, `Setting`.`code_bh`, `Setting`.`code_ab`, `Setting`.`code_bb`, `Setting`.`copyright`, `Setting`.`bf587ceef5`, `Setting`.`vk`, `Setting`.`fb`, `Setting`.`ig`, `Setting`.`app_image`, `Setting`.`app_icon`, `Setting`.`app_ios`, `Setting`.`app_andr`, `Setting`.`ma_acc`, `Setting`.`me_acc`, `Setting`.`api_hn_cnt`, `Setting`.`api_adv_place`, `Setting`.`api_feedback_message`, `Setting`.`api_feedback_vk`, `Setting`.`api_f_to`, `Setting`.`api_f_from`, `Setting`.`api_f_subject`, `Setting`.`b_image`, `Setting`.`b_icon`, `Setting`.`b_text`, `Setting`.`o_to`, `Setting`.`o_from`, `Setting`.`o_subject`, `Setting`.`n_to`, `Setting`.`n_from`, `Setting`.`n_subject`, `Setting`.`order_to`, `Setting`.`order_from`, `Setting`.`order_subject`, `Setting`.`link_from`, `Setting`.`link_subject`, (`I18n__bf587ceef5`.`content`) AS `Setting__i18n_bf587ceef5` FROM `petersburg24`.`settings` AS `Setting` LEFT JOIN `petersburg24`.`i18n` AS `I18n__bf587ceef5` ON (`Setting`.`id` = `I18n__bf587ceef5`.`foreign_key` AND `I18n__bf587ceef5`.`model` = 'Setting' AND `I18n__bf587ceef5`.`field` = 'bf587ceef5' AND `I18n__bf587ceef5`.`locale` = 'rus') WHERE `Setting`.`id` = 1 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` = 'jazz' ORDER BY `ArticleRubric`.`position` DESC, `ArticleRubric`.`id` DESC LIMIT 1 | 1 | 1 | 7 | 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` = (46) ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC | 60 | 60 | 1 | |
| 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` = 46 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` = ('46') AND `I18n__disabled`.`content` = '0' ORDER BY `ParamRubric`.`position` DESC, `ParamRubric`.`id` DESC | 2 | 2 | 6 | 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` = 46 | 11 | 11 | 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` = 22 ORDER BY `ArticleRubric`.`position` DESC, `ArticleRubric`.`id` DESC | 6 | 6 | 8 | maybe slow |
| SELECT `Article`.`id` FROM `petersburg24`.`articles` AS `Article` WHERE ((`Article`.`article_rubric_id` = 46) OR (`Article`.`id` IN (144, 186, 378, 820, 970, 2276, 2288, 2713, 4509, 4619, 5195))) AND `Article`.`active` = '0' ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC | 1 | 1 | 1 | |
| 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` = (2791))) AND ((`Article`.`article_rubric_id` = 46) OR (`Article`.`id` IN (144, 186, 378, 820, 970, 2276, 2288, 2713, 4509, 4619, 5195))) ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC LIMIT 20 | 20 | 20 | 50 | 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` = (2791))) AND ((`Article`.`article_rubric_id` = 46) OR (`Article`.`id` IN (144, 186, 378, 820, 970, 2276, 2288, 2713, 4509, 4619, 5195))) | 1 | 1 | 16 | 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` = (144) ORDER BY `AttachmentImage`.`position` DESC, `AttachmentImage`.`id` DESC | 3 | 3 | 2 | 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` = (144) ORDER BY `ArticlesTime`.`article_id` DESC, `ArticlesTime`.`day` ASC | 7 | 7 | 1 | maybe slow |
| 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` IN (16, 46, 30, 21, 25) ORDER BY `ArticleRubric`.`position` DESC, `ArticleRubric`.`id` DESC | 5 | 5 | 8 | 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` = 46 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` <= 82 AND `ArticleRubric`.`rght` >= 83 ORDER BY `ArticleRubric`.`lft` asc | 2 | 2 | 3 | maybe slow |
