Дата
10 октября 2018, 19:00 – 21:00
Цена
1 000 р. — 5 000 р.
Афиша /
10 октября в Президентской библиотеке состоится очередной концерт музыкально-просветительского проекта «Музыка российской государственности», посвящённый эпохе царя-реформатора Александра II.
Александром II, правившим 26 лет, была реализована модернизация всех сфер жизни государства и общества, в том числе и культуры. Создание Большого театра в Москве и Мариинского театра в Петербурге (назван в честь супруги Александра II императрицы Марии Александровны) дало огромный толчок в развитии музыкальной культуры.
Вечер в Президентской библиотеке воплотит наиболее значительные страницы музыкальной культуры той поры. Прозвучат отрывки из оперы М. И. Глинки «Жизнь за царя», музыка из великих балетов, поставленных при участии Мариуса Ивановича Петипа, опер П. И. Чайковского, М. П. Мусоргского, Дж. Верди, И. Штрауса и другие значительные сочинения русских и зарубежных композиторов, творивших в эпоху Александра II.
В рамках вечера публику поприветствует народный артист России Николай Цискаридзе, ректор Академии Русского балета имени А. Я. Вагановой. Танец от учащихся Академии А. Я. Вагановой осветит зарождение балета.
Вечер украсят блистательное сопрано выдающейся итальянской дивы, любимой певицы Ватикана и примы театра Ла Скала Кьяры Таиджи, проникновенный и глубокий бас солиста Ереванского оперного театра Ованеса Нерсесяна, блистательное исполнение победителя международных конкурсов пианиста Станислава Соловьёва, выступления солистов Мариинского театра, Международного симфонического оркестра Ленинградской области «Таврический».
No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Event`.`id`, (`I18n__disabled`.`content`) AS `Event__i18n_disabled`, (`I18n__active`.`content`) AS `Event__i18n_active` FROM `petersburg24`.`events` AS `Event` left JOIN `petersburg24`.`event_translations` AS `I18n__disabled` ON (`Event`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Event' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__active` ON (`Event`.`id` = `I18n__active`.`foreign_key` AND `I18n__active`.`model` = 'Event' AND `I18n__active`.`field` = 'active' AND `I18n__active`.`locale` = 'rus') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND `slug` = 'muzyka-rossijskoj-gosudarstvennosti-epoha-aleksandra' ORDER BY `Event`.`cloned_id` ASC, `Event`.`position` DESC, `Event`.`id` DESC LIMIT 1 | 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`.`content_2`, `Article`.`times`, `Article`.`itype`, `Article`.`image_main`, `Article`.`image`, `Article`.`image_mobile`, `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`, `Article`.`image_author`, `Article`.`image_source`, `ArticlesEvent`.`id`, `ArticlesEvent`.`article_id`, `ArticlesEvent`.`event_id`, 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__content_2.content AS Article__i18n_content_2, 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`.`articles_events` AS `ArticlesEvent` ON (`Article`.`id` = `ArticlesEvent`.`article_id`) 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__content_2` ON (`Article`.`id` = `I18n__content_2`.`foreign_key` AND `I18n__content_2`.`model` = 'Article' AND `I18n__content_2`.`field` = 'content_2' AND `I18n__content_2`.`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 `ArticlesEvent`.`event_id` = ('1434') AND `I18n__disabled`.`content` = '0' ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC | 1 | 1 | 8 | maybe slow |
SELECT `Banner`.`id`, `Banner`.`caption`, `Banner`.`sub_caption`, `Banner`.`number`, `Banner`.`image`, `Banner`.`url`, `Banner`.`button_text`, `Banner`.`disabled`, `BannersEvent`.`id`, `BannersEvent`.`event_id`, `BannersEvent`.`banner_id` FROM `petersburg24`.`banners` AS `Banner` LEFT JOIN `petersburg24`.`banners_events` AS `BannersEvent` ON (`Banner`.`id` = `BannersEvent`.`banner_id`) WHERE `BannersEvent`.`event_id` = ('1434') AND `Banner`.`disabled` = '0' | 0 | 0 | 0 | |
SELECT `Event`.`id`, `Event`.`cloned_id`, `Event`.`account_id`, `Event`.`slug`, `Event`.`type_id`, `Event`.`article_id`, `Event`.`itype`, `Event`.`caption`, `Event`.`price_type`, `Event`.`price`, `Event`.`price_from`, `Event`.`price_to`, `Event`.`burl`, `Event`.`burl_text`, `Event`.`eurl`, `Event`.`eurl_text`, `Event`.`brief`, `Event`.`content`, `Event`.`content_2`, `Event`.`image_main`, `Event`.`image`, `Event`.`image_mobile`, `Event`.`thumbnail`, `Event`.`thumbnail_1`, `Event`.`thumbnail_2`, `Event`.`thumbnail_3`, `Event`.`_thumbnail`, `Event`.`date_from`, `Event`.`date_to`, `Event`.`use_period`, `Event`.`priority`, `Event`.`meta_title`, `Event`.`meta_description`, `Event`.`position`, `Event`.`archive`, `Event`.`active`, `Event`.`checked`, `Event`.`m_reason`, `Event`.`show_han`, `Event`.`advertising`, `Event`.`views`, `Event`.`disabled`, `Event`.`created`, `Event`.`modified`, `Event`.`image_author`, `Event`.`image_source`, (`I18n__caption`.`content`) AS `Event__i18n_caption`, (`I18n__content`.`content`) AS `Event__i18n_content`, (`I18n__content_2`.`content`) AS `Event__i18n_content_2`, (`I18n__brief`.`content`) AS `Event__i18n_brief`, (`I18n__eurl_text`.`content`) AS `Event__i18n_eurl_text`, (`I18n__burl_text`.`content`) AS `Event__i18n_burl_text`, (`I18n__meta_title`.`content`) AS `Event__i18n_meta_title`, (`I18n__meta_description`.`content`) AS `Event__i18n_meta_description`, (`I18n__disabled`.`content`) AS `Event__i18n_disabled`, (`I18n__active`.`content`) AS `Event__i18n_active`, `Type`.`id`, `Type`.`caption`, `Type`.`caption_p`, `Type`.`position`, `Type`.`disabled`, `Type`.`created`, `Type`.`modified` FROM `petersburg24`.`events` AS `Event` LEFT JOIN `petersburg24`.`types` AS `Type` ON (`Event`.`type_id` = `Type`.`id`) left JOIN `petersburg24`.`event_translations` AS `I18n__caption` ON (`Event`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'Event' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__content` ON (`Event`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Event' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__content_2` ON (`Event`.`id` = `I18n__content_2`.`foreign_key` AND `I18n__content_2`.`model` = 'Event' AND `I18n__content_2`.`field` = 'content_2' AND `I18n__content_2`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__brief` ON (`Event`.`id` = `I18n__brief`.`foreign_key` AND `I18n__brief`.`model` = 'Event' AND `I18n__brief`.`field` = 'brief' AND `I18n__brief`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__eurl_text` ON (`Event`.`id` = `I18n__eurl_text`.`foreign_key` AND `I18n__eurl_text`.`model` = 'Event' AND `I18n__eurl_text`.`field` = 'eurl_text' AND `I18n__eurl_text`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__burl_text` ON (`Event`.`id` = `I18n__burl_text`.`foreign_key` AND `I18n__burl_text`.`model` = 'Event' AND `I18n__burl_text`.`field` = 'burl_text' AND `I18n__burl_text`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__meta_title` ON (`Event`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'Event' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__meta_description` ON (`Event`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Event' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__disabled` ON (`Event`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Event' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__active` ON (`Event`.`id` = `I18n__active`.`foreign_key` AND `I18n__active`.`model` = 'Event' AND `I18n__active`.`field` = 'active' AND `I18n__active`.`locale` = 'rus') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND `Event`.`id` = 1434 ORDER BY `Event`.`cloned_id` ASC, `Event`.`position` DESC, `Event`.`id` DESC, `Type`.`caption` ASC LIMIT 1 | 1 | 1 | 1 | |
SELECT `AttachmentImage`.`id`, `AttachmentImage`.`model`, `AttachmentImage`.`foreign_key`, `AttachmentImage`.`caption`, `AttachmentImage`.`image`, `AttachmentImage`.`thumbnail`, `AttachmentImage`.`_thumbnail`, `AttachmentImage`.`thumbnail_2`, `AttachmentImage`.`position`, `AttachmentImage`.`disabled`, `AttachmentImage`.`author`, `AttachmentImage`.`source` FROM `petersburg24`.`attachment_images` AS `AttachmentImage` WHERE `model` = 'Event' AND `AttachmentImage`.`disabled` = '0' AND `AttachmentImage`.`foreign_key` = (1434) ORDER BY `AttachmentImage`.`position` DESC, `AttachmentImage`.`id` DESC | 0 | 0 | 0 | |
SELECT `EventDate`.`id`, `EventDate`.`event_id`, `EventDate`.`date`, `EventDate`.`time_from`, `EventDate`.`time_to` FROM `petersburg24`.`event_dates` AS `EventDate` WHERE `EventDate`.`event_id` = (1434) ORDER BY `EventDate`.`date` ASC | 0 | 0 | 0 | |
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`.`content_2`, `Article`.`times`, `Article`.`itype`, `Article`.`image_main`, `Article`.`image`, `Article`.`image_mobile`, `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`, `Article`.`image_author`, `Article`.`image_source`, `ArticlesEvent`.`id`, `ArticlesEvent`.`article_id`, `ArticlesEvent`.`event_id`, 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__content_2.content AS Article__i18n_content_2, 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`.`articles_events` AS `ArticlesEvent` ON (`Article`.`id` = `ArticlesEvent`.`article_id`) 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__content_2` ON (`Article`.`id` = `I18n__content_2`.`foreign_key` AND `I18n__content_2`.`model` = 'Article' AND `I18n__content_2`.`field` = 'content_2' AND `I18n__content_2`.`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 `ArticlesEvent`.`event_id` = ('1434') AND `I18n__disabled`.`content` = '0' ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC | 1 | 1 | 0 | |
SELECT `Banner`.`id`, `Banner`.`caption`, `Banner`.`sub_caption`, `Banner`.`number`, `Banner`.`image`, `Banner`.`url`, `Banner`.`button_text`, `Banner`.`disabled`, `BannersEvent`.`id`, `BannersEvent`.`event_id`, `BannersEvent`.`banner_id` FROM `petersburg24`.`banners` AS `Banner` LEFT JOIN `petersburg24`.`banners_events` AS `BannersEvent` ON (`Banner`.`id` = `BannersEvent`.`banner_id`) WHERE `BannersEvent`.`event_id` = ('1434') AND `Banner`.`disabled` = '0' | 0 | 0 | 0 | |
SELECT `Event`.`cloned_id`, `Event`.`position`, `Event`.`id` FROM `petersburg24`.`events` AS `Event` LEFT JOIN `petersburg24`.`types` AS `Type` ON (`Event`.`type_id` = `Type`.`id`) LEFT JOIN `petersburg24`.`accounts` AS `Account` ON (`Event`.`account_id` = `Account`.`id`) WHERE `Event`.`id` = 1434 ORDER BY `Event`.`cloned_id` ASC, `Event`.`position` DESC, `Event`.`id` DESC, `Type`.`caption` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `AttachmentImage`.`id`, `AttachmentImage`.`model`, `AttachmentImage`.`foreign_key`, `AttachmentImage`.`caption`, `AttachmentImage`.`image`, `AttachmentImage`.`thumbnail`, `AttachmentImage`.`_thumbnail`, `AttachmentImage`.`thumbnail_2`, `AttachmentImage`.`position`, `AttachmentImage`.`disabled`, `AttachmentImage`.`author`, `AttachmentImage`.`source` FROM `petersburg24`.`attachment_images` AS `AttachmentImage` WHERE `model` = 'Event' AND `AttachmentImage`.`foreign_key` = (1434) ORDER BY `AttachmentImage`.`position` DESC, `AttachmentImage`.`id` DESC | 0 | 0 | 1 | maybe slow |
SELECT `EventDate`.`id`, `EventDate`.`event_id`, `EventDate`.`date`, `EventDate`.`time_from`, `EventDate`.`time_to` FROM `petersburg24`.`event_dates` AS `EventDate` WHERE `EventDate`.`event_id` = (1434) ORDER BY `EventDate`.`date` ASC | 0 | 0 | 0 | |
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`.`content_2`, `Article`.`times`, `Article`.`itype`, `Article`.`image_main`, `Article`.`image`, `Article`.`image_mobile`, `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`, `Article`.`image_author`, `Article`.`image_source`, `ArticlesEvent`.`id`, `ArticlesEvent`.`article_id`, `ArticlesEvent`.`event_id` FROM `petersburg24`.`articles` AS `Article` JOIN `petersburg24`.`articles_events` AS `ArticlesEvent` ON (`ArticlesEvent`.`event_id` = 1434 AND `ArticlesEvent`.`article_id` = `Article`.`id`) | 1 | 1 | 0 | |
SELECT `Banner`.`id`, `Banner`.`caption`, `Banner`.`sub_caption`, `Banner`.`number`, `Banner`.`image`, `Banner`.`url`, `Banner`.`button_text`, `Banner`.`disabled`, `BannersEvent`.`id`, `BannersEvent`.`event_id`, `BannersEvent`.`banner_id` FROM `petersburg24`.`banners` AS `Banner` JOIN `petersburg24`.`banners_events` AS `BannersEvent` ON (`BannersEvent`.`event_id` = 1434 AND `BannersEvent`.`banner_id` = `Banner`.`id`) | 0 | 0 | 0 | |
SELECT `Event`.`id`, `Event`.`slug`, (`I18n__disabled`.`content`) AS `Event__i18n_disabled`, (`I18n__active`.`content`) AS `Event__i18n_active` FROM `petersburg24`.`events` AS `Event` left JOIN `petersburg24`.`event_translations` AS `I18n__disabled` ON (`Event`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Event' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__active` ON (`Event`.`id` = `I18n__active`.`foreign_key` AND `I18n__active`.`model` = 'Event' AND `I18n__active`.`field` = 'active' AND `I18n__active`.`locale` = 'rus') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND `Event`.`id` <> 1434 AND `Event`.`cloned_id` > NULL ORDER BY `Event`.`cloned_id` ASC, `Event`.`position` DESC, `Event`.`id` DESC LIMIT 1 | 0 | 0 | 130 | maybe slow |
SELECT `Event`.`id`, `Event`.`slug`, (`I18n__disabled`.`content`) AS `Event__i18n_disabled`, (`I18n__active`.`content`) AS `Event__i18n_active` FROM `petersburg24`.`events` AS `Event` left JOIN `petersburg24`.`event_translations` AS `I18n__disabled` ON (`Event`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Event' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__active` ON (`Event`.`id` = `I18n__active`.`foreign_key` AND `I18n__active`.`model` = 'Event' AND `I18n__active`.`field` = 'active' AND `I18n__active`.`locale` = 'rus') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND `Event`.`id` <> 1434 AND `Event`.`cloned_id` < NULL ORDER BY `Event`.`cloned_id` DESC, `Event`.`position` ASC, `Event`.`id` ASC LIMIT 1 | 0 | 0 | 137 | maybe slow |
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`.`content_banner_left`, `Page`.`url_banner_left`, `Page`.`image_banner_left`, `Page`.`content_banner_right`, `Page`.`url_banner_right`, `Page`.`image_banner_right`, `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`, (`I18n__content_banner_left`.`content`) AS `Page__i18n_content_banner_left`, (`I18n__content_banner_right`.`content`) AS `Page__i18n_content_banner_right`, (`I18n__url_banner_left`.`content`) AS `Page__i18n_url_banner_left`, (`I18n__url_banner_right`.`content`) AS `Page__i18n_url_banner_right` 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') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_banner_left` ON (`Page`.`id` = `I18n__content_banner_left`.`foreign_key` AND `I18n__content_banner_left`.`model` = 'Page' AND `I18n__content_banner_left`.`field` = 'content_banner_left' AND `I18n__content_banner_left`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_banner_right` ON (`Page`.`id` = `I18n__content_banner_right`.`foreign_key` AND `I18n__content_banner_right`.`model` = 'Page' AND `I18n__content_banner_right`.`field` = 'content_banner_right' AND `I18n__content_banner_right`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__url_banner_left` ON (`Page`.`id` = `I18n__url_banner_left`.`foreign_key` AND `I18n__url_banner_left`.`model` = 'Page' AND `I18n__url_banner_left`.`field` = 'url_banner_left' AND `I18n__url_banner_left`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__url_banner_right` ON (`Page`.`id` = `I18n__url_banner_right`.`foreign_key` AND `I18n__url_banner_right`.`model` = 'Page' AND `I18n__url_banner_right`.`field` = 'url_banner_right' AND `I18n__url_banner_right`.`locale` = 'rus') WHERE `I18n__disabled`.`content` = '0' AND `Page`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Banner`.`id`, `Banner`.`caption`, `Banner`.`sub_caption`, `Banner`.`number`, `Banner`.`image`, `Banner`.`url`, `Banner`.`button_text`, `Banner`.`disabled`, `BannersPage`.`id`, `BannersPage`.`page_id`, `BannersPage`.`banner_id` FROM `petersburg24`.`banners` AS `Banner` LEFT JOIN `petersburg24`.`banners_pages` AS `BannersPage` ON (`Banner`.`id` = `BannersPage`.`banner_id`) WHERE `BannersPage`.`page_id` = ('4') AND `Banner`.`disabled` = '0' | 0 | 0 | 0 | |
SELECT `Excursion`.`id`, `Excursion`.`excursion_rubric_id`, `Excursion`.`order_type`, `Excursion`.`slug`, `Excursion`.`order_btn_text`, `Excursion`.`caption`, `Excursion`.`caption_sub`, `Excursion`.`price`, `Excursion`.`supplier_price`, `Excursion`.`active`, `Excursion`.`old_price`, `Excursion`.`basetype`, `Excursion`.`typeof`, `Excursion`.`persons`, `Excursion`.`duration`, `Excursion`.`working_days`, `Excursion`.`opening_hours`, `Excursion`.`price_note`, `Excursion`.`image_main`, `Excursion`.`image`, `Excursion`.`image_big_mobile`, `Excursion`.`image_big`, `Excursion`.`content_excursion`, `Excursion`.`phone`, `Excursion`.`content_await`, `Excursion`.`content_attentions`, `Excursion`.`map_caption`, `Excursion`.`map_n`, `Excursion`.`map_e`, `Excursion`.`times`, `Excursion`.`checked`, `Excursion`.`online`, `Excursion`.`link_online_excursion`, `Excursion`.`date_from`, `Excursion`.`time_to`, `Excursion`.`views`, `Excursion`.`pay`, `Excursion`.`supplier_id`, `Excursion`.`meta_title`, `Excursion`.`meta_description`, `Excursion`.`content_external`, `Excursion`.`is_template`, `Excursion`.`intickets_widget`, `Excursion`.`params`, `Excursion`.`disabled`, `Excursion`.`position`, `Excursion`.`created`, `Excursion`.`modified`, `Excursion`.`image_author`, `Excursion`.`image_source`, `ExcursionsPage`.`id`, `ExcursionsPage`.`excursion_id`, `ExcursionsPage`.`page_id`, I18n__caption.content AS Excursion__i18n_caption, I18n__caption_sub.content AS Excursion__i18n_caption_sub, I18n__typeof.content AS Excursion__i18n_typeof, I18n__persons.content AS Excursion__i18n_persons, I18n__duration.content AS Excursion__i18n_duration, I18n__working_days.content AS Excursion__i18n_working_days, I18n__opening_hours.content AS Excursion__i18n_opening_hours, I18n__price_note.content AS Excursion__i18n_price_note, I18n__content_excursion.content AS Excursion__i18n_content_excursion, I18n__content_await.content AS Excursion__i18n_content_await, I18n__content_attentions.content AS Excursion__i18n_content_attentions, I18n__map_caption.content AS Excursion__i18n_map_caption, I18n__meta_title.content AS Excursion__i18n_meta_title, I18n__meta_description.content AS Excursion__i18n_meta_description, I18n__content_external.content AS Excursion__i18n_content_external, I18n__intickets_widget.content AS Excursion__i18n_intickets_widget, I18n__disabled.content AS Excursion__i18n_disabled, I18n__order_btn_text.content AS Excursion__i18n_order_btn_text FROM `petersburg24`.`excursions` AS `Excursion` LEFT JOIN `petersburg24`.`excursions_pages` AS `ExcursionsPage` ON (`Excursion`.`id` = `ExcursionsPage`.`excursion_id`) LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`Excursion`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'Excursion' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption_sub` ON (`Excursion`.`id` = `I18n__caption_sub`.`foreign_key` AND `I18n__caption_sub`.`model` = 'Excursion' AND `I18n__caption_sub`.`field` = 'caption_sub' AND `I18n__caption_sub`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__typeof` ON (`Excursion`.`id` = `I18n__typeof`.`foreign_key` AND `I18n__typeof`.`model` = 'Excursion' AND `I18n__typeof`.`field` = 'typeof' AND `I18n__typeof`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__persons` ON (`Excursion`.`id` = `I18n__persons`.`foreign_key` AND `I18n__persons`.`model` = 'Excursion' AND `I18n__persons`.`field` = 'persons' AND `I18n__persons`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__duration` ON (`Excursion`.`id` = `I18n__duration`.`foreign_key` AND `I18n__duration`.`model` = 'Excursion' AND `I18n__duration`.`field` = 'duration' AND `I18n__duration`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__working_days` ON (`Excursion`.`id` = `I18n__working_days`.`foreign_key` AND `I18n__working_days`.`model` = 'Excursion' AND `I18n__working_days`.`field` = 'working_days' AND `I18n__working_days`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__opening_hours` ON (`Excursion`.`id` = `I18n__opening_hours`.`foreign_key` AND `I18n__opening_hours`.`model` = 'Excursion' AND `I18n__opening_hours`.`field` = 'opening_hours' AND `I18n__opening_hours`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__price_note` ON (`Excursion`.`id` = `I18n__price_note`.`foreign_key` AND `I18n__price_note`.`model` = 'Excursion' AND `I18n__price_note`.`field` = 'price_note' AND `I18n__price_note`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_excursion` ON (`Excursion`.`id` = `I18n__content_excursion`.`foreign_key` AND `I18n__content_excursion`.`model` = 'Excursion' AND `I18n__content_excursion`.`field` = 'content_excursion' AND `I18n__content_excursion`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_await` ON (`Excursion`.`id` = `I18n__content_await`.`foreign_key` AND `I18n__content_await`.`model` = 'Excursion' AND `I18n__content_await`.`field` = 'content_await' AND `I18n__content_await`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_attentions` ON (`Excursion`.`id` = `I18n__content_attentions`.`foreign_key` AND `I18n__content_attentions`.`model` = 'Excursion' AND `I18n__content_attentions`.`field` = 'content_attentions' AND `I18n__content_attentions`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__map_caption` ON (`Excursion`.`id` = `I18n__map_caption`.`foreign_key` AND `I18n__map_caption`.`model` = 'Excursion' AND `I18n__map_caption`.`field` = 'map_caption' AND `I18n__map_caption`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__meta_title` ON (`Excursion`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'Excursion' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__meta_description` ON (`Excursion`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Excursion' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_external` ON (`Excursion`.`id` = `I18n__content_external`.`foreign_key` AND `I18n__content_external`.`model` = 'Excursion' AND `I18n__content_external`.`field` = 'content_external' AND `I18n__content_external`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__intickets_widget` ON (`Excursion`.`id` = `I18n__intickets_widget`.`foreign_key` AND `I18n__intickets_widget`.`model` = 'Excursion' AND `I18n__intickets_widget`.`field` = 'intickets_widget' AND `I18n__intickets_widget`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`Excursion`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Excursion' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__order_btn_text` ON (`Excursion`.`id` = `I18n__order_btn_text`.`foreign_key` AND `I18n__order_btn_text`.`model` = 'Excursion' AND `I18n__order_btn_text`.`field` = 'order_btn_text' AND `I18n__order_btn_text`.`locale` = 'rus') WHERE `ExcursionsPage`.`page_id` = ('4') AND `I18n__disabled`.`content` = '0' ORDER BY `Excursion`.`is_template` DESC, `Excursion`.`position` DESC, `Excursion`.`id` DESC | 0 | 0 | 0 | |
SELECT `Type`.`id`, `Type`.`caption`, `Type`.`caption_p`, `Type`.`position`, `Type`.`disabled`, `Type`.`created`, `Type`.`modified`, (`I18n__caption`.`content`) AS `Type__i18n_caption`, (`I18n__caption_p`.`content`) AS `Type__i18n_caption_p`, (`I18n__disabled`.`content`) AS `Type__i18n_disabled` FROM `petersburg24`.`types` AS `Type` left JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`Type`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'Type' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__caption_p` ON (`Type`.`id` = `I18n__caption_p`.`foreign_key` AND `I18n__caption_p`.`model` = 'Type' AND `I18n__caption_p`.`field` = 'caption_p' AND `I18n__caption_p`.`locale` = 'rus') left JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`Type`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Type' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') WHERE `I18n__disabled`.`content` = 0 AND `Type`.`id` = 2 ORDER BY `Type`.`caption` ASC LIMIT 1 | 0 | 0 | 0 | |
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`.`content_banner_left`, `Page`.`url_banner_left`, `Page`.`image_banner_left`, `Page`.`content_banner_right`, `Page`.`url_banner_right`, `Page`.`image_banner_right`, `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`, (`I18n__content_banner_left`.`content`) AS `Page__i18n_content_banner_left`, (`I18n__content_banner_right`.`content`) AS `Page__i18n_content_banner_right`, (`I18n__url_banner_left`.`content`) AS `Page__i18n_url_banner_left`, (`I18n__url_banner_right`.`content`) AS `Page__i18n_url_banner_right` 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') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_banner_left` ON (`Page`.`id` = `I18n__content_banner_left`.`foreign_key` AND `I18n__content_banner_left`.`model` = 'Page' AND `I18n__content_banner_left`.`field` = 'content_banner_left' AND `I18n__content_banner_left`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_banner_right` ON (`Page`.`id` = `I18n__content_banner_right`.`foreign_key` AND `I18n__content_banner_right`.`model` = 'Page' AND `I18n__content_banner_right`.`field` = 'content_banner_right' AND `I18n__content_banner_right`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__url_banner_left` ON (`Page`.`id` = `I18n__url_banner_left`.`foreign_key` AND `I18n__url_banner_left`.`model` = 'Page' AND `I18n__url_banner_left`.`field` = 'url_banner_left' AND `I18n__url_banner_left`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__url_banner_right` ON (`Page`.`id` = `I18n__url_banner_right`.`foreign_key` AND `I18n__url_banner_right`.`model` = 'Page' AND `I18n__url_banner_right`.`field` = 'url_banner_right' AND `I18n__url_banner_right`.`locale` = 'rus') WHERE `I18n__disabled`.`content` = '0' AND `Page`.`id` = 4 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` = (4) | 0 | 0 | 0 | |
SELECT `Banner`.`id`, `Banner`.`caption`, `Banner`.`sub_caption`, `Banner`.`number`, `Banner`.`image`, `Banner`.`url`, `Banner`.`button_text`, `Banner`.`disabled`, `BannersPage`.`id`, `BannersPage`.`page_id`, `BannersPage`.`banner_id` FROM `petersburg24`.`banners` AS `Banner` LEFT JOIN `petersburg24`.`banners_pages` AS `BannersPage` ON (`Banner`.`id` = `BannersPage`.`banner_id`) WHERE `BannersPage`.`page_id` = ('4') AND `Banner`.`disabled` = '0' | 0 | 0 | 0 | |
SELECT `Excursion`.`id`, `Excursion`.`excursion_rubric_id`, `Excursion`.`order_type`, `Excursion`.`slug`, `Excursion`.`order_btn_text`, `Excursion`.`caption`, `Excursion`.`caption_sub`, `Excursion`.`price`, `Excursion`.`supplier_price`, `Excursion`.`active`, `Excursion`.`old_price`, `Excursion`.`basetype`, `Excursion`.`typeof`, `Excursion`.`persons`, `Excursion`.`duration`, `Excursion`.`working_days`, `Excursion`.`opening_hours`, `Excursion`.`price_note`, `Excursion`.`image_main`, `Excursion`.`image`, `Excursion`.`image_big_mobile`, `Excursion`.`image_big`, `Excursion`.`content_excursion`, `Excursion`.`phone`, `Excursion`.`content_await`, `Excursion`.`content_attentions`, `Excursion`.`map_caption`, `Excursion`.`map_n`, `Excursion`.`map_e`, `Excursion`.`times`, `Excursion`.`checked`, `Excursion`.`online`, `Excursion`.`link_online_excursion`, `Excursion`.`date_from`, `Excursion`.`time_to`, `Excursion`.`views`, `Excursion`.`pay`, `Excursion`.`supplier_id`, `Excursion`.`meta_title`, `Excursion`.`meta_description`, `Excursion`.`content_external`, `Excursion`.`is_template`, `Excursion`.`intickets_widget`, `Excursion`.`params`, `Excursion`.`disabled`, `Excursion`.`position`, `Excursion`.`created`, `Excursion`.`modified`, `Excursion`.`image_author`, `Excursion`.`image_source`, `ExcursionsPage`.`id`, `ExcursionsPage`.`excursion_id`, `ExcursionsPage`.`page_id`, I18n__caption.content AS Excursion__i18n_caption, I18n__caption_sub.content AS Excursion__i18n_caption_sub, I18n__typeof.content AS Excursion__i18n_typeof, I18n__persons.content AS Excursion__i18n_persons, I18n__duration.content AS Excursion__i18n_duration, I18n__working_days.content AS Excursion__i18n_working_days, I18n__opening_hours.content AS Excursion__i18n_opening_hours, I18n__price_note.content AS Excursion__i18n_price_note, I18n__content_excursion.content AS Excursion__i18n_content_excursion, I18n__content_await.content AS Excursion__i18n_content_await, I18n__content_attentions.content AS Excursion__i18n_content_attentions, I18n__map_caption.content AS Excursion__i18n_map_caption, I18n__meta_title.content AS Excursion__i18n_meta_title, I18n__meta_description.content AS Excursion__i18n_meta_description, I18n__content_external.content AS Excursion__i18n_content_external, I18n__intickets_widget.content AS Excursion__i18n_intickets_widget, I18n__disabled.content AS Excursion__i18n_disabled, I18n__order_btn_text.content AS Excursion__i18n_order_btn_text FROM `petersburg24`.`excursions` AS `Excursion` LEFT JOIN `petersburg24`.`excursions_pages` AS `ExcursionsPage` ON (`Excursion`.`id` = `ExcursionsPage`.`excursion_id`) LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`Excursion`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'Excursion' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption_sub` ON (`Excursion`.`id` = `I18n__caption_sub`.`foreign_key` AND `I18n__caption_sub`.`model` = 'Excursion' AND `I18n__caption_sub`.`field` = 'caption_sub' AND `I18n__caption_sub`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__typeof` ON (`Excursion`.`id` = `I18n__typeof`.`foreign_key` AND `I18n__typeof`.`model` = 'Excursion' AND `I18n__typeof`.`field` = 'typeof' AND `I18n__typeof`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__persons` ON (`Excursion`.`id` = `I18n__persons`.`foreign_key` AND `I18n__persons`.`model` = 'Excursion' AND `I18n__persons`.`field` = 'persons' AND `I18n__persons`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__duration` ON (`Excursion`.`id` = `I18n__duration`.`foreign_key` AND `I18n__duration`.`model` = 'Excursion' AND `I18n__duration`.`field` = 'duration' AND `I18n__duration`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__working_days` ON (`Excursion`.`id` = `I18n__working_days`.`foreign_key` AND `I18n__working_days`.`model` = 'Excursion' AND `I18n__working_days`.`field` = 'working_days' AND `I18n__working_days`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__opening_hours` ON (`Excursion`.`id` = `I18n__opening_hours`.`foreign_key` AND `I18n__opening_hours`.`model` = 'Excursion' AND `I18n__opening_hours`.`field` = 'opening_hours' AND `I18n__opening_hours`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__price_note` ON (`Excursion`.`id` = `I18n__price_note`.`foreign_key` AND `I18n__price_note`.`model` = 'Excursion' AND `I18n__price_note`.`field` = 'price_note' AND `I18n__price_note`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_excursion` ON (`Excursion`.`id` = `I18n__content_excursion`.`foreign_key` AND `I18n__content_excursion`.`model` = 'Excursion' AND `I18n__content_excursion`.`field` = 'content_excursion' AND `I18n__content_excursion`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_await` ON (`Excursion`.`id` = `I18n__content_await`.`foreign_key` AND `I18n__content_await`.`model` = 'Excursion' AND `I18n__content_await`.`field` = 'content_await' AND `I18n__content_await`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_attentions` ON (`Excursion`.`id` = `I18n__content_attentions`.`foreign_key` AND `I18n__content_attentions`.`model` = 'Excursion' AND `I18n__content_attentions`.`field` = 'content_attentions' AND `I18n__content_attentions`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__map_caption` ON (`Excursion`.`id` = `I18n__map_caption`.`foreign_key` AND `I18n__map_caption`.`model` = 'Excursion' AND `I18n__map_caption`.`field` = 'map_caption' AND `I18n__map_caption`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__meta_title` ON (`Excursion`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'Excursion' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__meta_description` ON (`Excursion`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Excursion' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_external` ON (`Excursion`.`id` = `I18n__content_external`.`foreign_key` AND `I18n__content_external`.`model` = 'Excursion' AND `I18n__content_external`.`field` = 'content_external' AND `I18n__content_external`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__intickets_widget` ON (`Excursion`.`id` = `I18n__intickets_widget`.`foreign_key` AND `I18n__intickets_widget`.`model` = 'Excursion' AND `I18n__intickets_widget`.`field` = 'intickets_widget' AND `I18n__intickets_widget`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`Excursion`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Excursion' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__order_btn_text` ON (`Excursion`.`id` = `I18n__order_btn_text`.`foreign_key` AND `I18n__order_btn_text`.`model` = 'Excursion' AND `I18n__order_btn_text`.`field` = 'order_btn_text' AND `I18n__order_btn_text`.`locale` = 'rus') WHERE `ExcursionsPage`.`page_id` = ('4') AND `I18n__disabled`.`content` = '0' ORDER BY `Excursion`.`is_template` DESC, `Excursion`.`position` DESC, `Excursion`.`id` DESC | 0 | 0 | 0 | |
SELECT `Event`.`id`, `Event`.`cloned_id`, `Event`.`account_id`, `Event`.`slug`, `Event`.`type_id`, `Event`.`article_id`, `Event`.`itype`, `Event`.`caption`, `Event`.`price_type`, `Event`.`price`, `Event`.`price_from`, `Event`.`price_to`, `Event`.`burl`, `Event`.`burl_text`, `Event`.`eurl`, `Event`.`eurl_text`, `Event`.`brief`, `Event`.`content`, `Event`.`content_2`, `Event`.`image_main`, `Event`.`image`, `Event`.`image_mobile`, `Event`.`thumbnail`, `Event`.`thumbnail_1`, `Event`.`thumbnail_2`, `Event`.`thumbnail_3`, `Event`.`_thumbnail`, `Event`.`date_from`, `Event`.`date_to`, `Event`.`use_period`, `Event`.`priority`, `Event`.`meta_title`, `Event`.`meta_description`, `Event`.`position`, `Event`.`archive`, `Event`.`active`, `Event`.`checked`, `Event`.`m_reason`, `Event`.`show_han`, `Event`.`advertising`, `Event`.`views`, `Event`.`disabled`, `Event`.`created`, `Event`.`modified`, `Event`.`image_author`, `Event`.`image_source`, (`I18n__caption`.`content`) AS `Event__i18n_caption`, (`I18n__content`.`content`) AS `Event__i18n_content`, (`I18n__content_2`.`content`) AS `Event__i18n_content_2`, (`I18n__brief`.`content`) AS `Event__i18n_brief`, (`I18n__eurl_text`.`content`) AS `Event__i18n_eurl_text`, (`I18n__burl_text`.`content`) AS `Event__i18n_burl_text`, (`I18n__meta_title`.`content`) AS `Event__i18n_meta_title`, (`I18n__meta_description`.`content`) AS `Event__i18n_meta_description`, (`I18n__disabled`.`content`) AS `Event__i18n_disabled`, (`I18n__active`.`content`) AS `Event__i18n_active` FROM `petersburg24`.`events` AS `Event` left JOIN `petersburg24`.`event_translations` AS `I18n__caption` ON (`Event`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'Event' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__content` ON (`Event`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Event' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__content_2` ON (`Event`.`id` = `I18n__content_2`.`foreign_key` AND `I18n__content_2`.`model` = 'Event' AND `I18n__content_2`.`field` = 'content_2' AND `I18n__content_2`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__brief` ON (`Event`.`id` = `I18n__brief`.`foreign_key` AND `I18n__brief`.`model` = 'Event' AND `I18n__brief`.`field` = 'brief' AND `I18n__brief`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__eurl_text` ON (`Event`.`id` = `I18n__eurl_text`.`foreign_key` AND `I18n__eurl_text`.`model` = 'Event' AND `I18n__eurl_text`.`field` = 'eurl_text' AND `I18n__eurl_text`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__burl_text` ON (`Event`.`id` = `I18n__burl_text`.`foreign_key` AND `I18n__burl_text`.`model` = 'Event' AND `I18n__burl_text`.`field` = 'burl_text' AND `I18n__burl_text`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__meta_title` ON (`Event`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'Event' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__meta_description` ON (`Event`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Event' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__disabled` ON (`Event`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Event' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') left JOIN `petersburg24`.`event_translations` AS `I18n__active` ON (`Event`.`id` = `I18n__active`.`foreign_key` AND `I18n__active`.`model` = 'Event' AND `I18n__active`.`field` = 'active' AND `I18n__active`.`locale` = 'rus') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND `Event`.`slug` = 'muzyka-rossijskoj-gosudarstvennosti-epoha-aleksandra' ORDER BY `Event`.`cloned_id` ASC, `Event`.`position` DESC, `Event`.`id` DESC LIMIT 1 | 1 | 1 | 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`.`content_2`, `Article`.`times`, `Article`.`itype`, `Article`.`image_main`, `Article`.`image`, `Article`.`image_mobile`, `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`, `Article`.`image_author`, `Article`.`image_source`, `ArticlesEvent`.`id`, `ArticlesEvent`.`article_id`, `ArticlesEvent`.`event_id`, 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__content_2.content AS Article__i18n_content_2, 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`.`articles_events` AS `ArticlesEvent` ON (`Article`.`id` = `ArticlesEvent`.`article_id`) 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__content_2` ON (`Article`.`id` = `I18n__content_2`.`foreign_key` AND `I18n__content_2`.`model` = 'Article' AND `I18n__content_2`.`field` = 'content_2' AND `I18n__content_2`.`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 `ArticlesEvent`.`event_id` = ('1434') AND `I18n__disabled`.`content` = '0' ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC | 1 | 1 | 0 | |
SELECT `Banner`.`id`, `Banner`.`caption`, `Banner`.`sub_caption`, `Banner`.`number`, `Banner`.`image`, `Banner`.`url`, `Banner`.`button_text`, `Banner`.`disabled`, `BannersEvent`.`id`, `BannersEvent`.`event_id`, `BannersEvent`.`banner_id` FROM `petersburg24`.`banners` AS `Banner` LEFT JOIN `petersburg24`.`banners_events` AS `BannersEvent` ON (`Banner`.`id` = `BannersEvent`.`banner_id`) WHERE `BannersEvent`.`event_id` = ('1434') AND `Banner`.`disabled` = '0' | 0 | 0 | 0 | |
SELECT `Settings`.`project_title` FROM `petersburg24`.`settings` AS `Settings` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT * FROM i18n WHERE `model`='Event' AND `foreign_key`=1434 AND `field`='disabled' AND `content`=0 | 2 | 2 | 1 | maybe slow |
Peak Memory Use 14.41 MB
Message | Memory use |
---|---|
Component initialization | 1.91 MB |
Controller action start | 2.15 MB |
Controller render start | 8.08 MB |
View render complete | 8.66 MB |
Total Request Time: 536 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 5.83 | |
Event: Controller.initialize | 0.78 | |
Event: Controller.startup | 87.06 | |
Controller action | 442.14 | |
Event: Controller.beforeRender | 27.13 | |
» Processing toolbar data | 25.55 | |
Rendering View | 10.50 | |
» Event: View.beforeRender | 0.05 | |
» Rendering APP/View/Events/view.ctp | 1.95 | |
» » Rendering APP/View/Elements/layouts/bc.ctp | 0.15 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering APP/View/Layouts/default.ctp | 7.20 | |
» » Rendering APP/View/Elements/layouts/hreflink.ctp | 0.45 | |
» » Rendering APP/View/Elements/layouts/header.ctp | 2.53 | |
» » Rendering APP/View/Elements/layouts/footer.ctp | 3.06 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
CONFIG | /var/www/petersburg24.ru/Config/ |
Constant | Value |
---|---|
APP | /var/www/petersburg24.ru/ |
APP_DIR | petersburg24.ru |
APPLIBS | /var/www/petersburg24.ru/Lib/ |
CACHE | /var/www/petersburg24.ru/tmp/cache/ |
CAKE | /var/www/petersburg24.ru/Cake/ |
CAKE_CORE_INCLUDE_PATH | /var/www/petersburg24.ru |
CORE_PATH | /var/www/petersburg24.ru/ |
CAKE_VERSION | 2.10.4 |
CSS | /var/www/petersburg24.ru/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | https://petersburg24.ru |
IMAGES | /var/www/petersburg24.ru/webroot/img/ |
IMAGES_URL | img/ |
JS | /var/www/petersburg24.ru/webroot/js/ |
JS_URL | js/ |
LOGS | /var/www/petersburg24.ru/tmp/logs/ |
ROOT | /var/www |
TESTS | /var/www/petersburg24.ru/Test/ |
TMP | /var/www/petersburg24.ru/tmp/ |
VENDORS | /var/www/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /var/www/petersburg24.ru/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 5.6.36-0+deb8u1 |
Redirect Redirect Https | 1 |
Redirect Redirect Status | 200 |
Redirect Https | 1 |
Redirect Status | 200 |
Https | 1 |
Http X Real Ip | 3.235.60.197 |
Http Host | petersburg24.ru |
Http X Forwarded Port | 443 |
Http Connection | close |
Http User Agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
Http Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
Http Accept Language | en-US,en;q=0.5 |
Http Accept Encoding | br,gzip |
Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin |
Server Signature | <address>Apache Server at petersburg24.ru Port 81</address> |
Server Software | Apache |
Server Name | petersburg24.ru |
Server Addr | 127.0.0.1 |
Server Port | 81 |
Remote Addr | 3.235.60.197 |
Document Root | /var/www/petersburg24.ru |
Request Scheme | http |
Context Prefix | |
Context Document Root | /var/www/petersburg24.ru |
Server Admin | webmaster@localhost |
Script Filename | /var/www/petersburg24.ru/webroot/index.php |
Remote Port | 60949 |
Redirect Url | /webroot/event/muzyka-rossijskoj-gosudarstvennosti-epoha-aleksandra |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.0 |
Request Method | GET |
Query String | |
Request Uri | /event/muzyka-rossijskoj-gosudarstvennosti-epoha-aleksandra |
Script Name | /webroot/index.php |
Php Self | /webroot/index.php |
Request Time Float | 1701839875.973 |
Request Time | 1701839875 |