Дата
24 января 2019, 19:00 – 20:30
Цена
100 р. — 200 р.
Афиша /
Видеоигры — территория неестественного. Тела персонажей искажены, гигантские доспехи воинов или облачения девушек равно не натуральны. Однако образы, повторенные в компьютерных играх тысячекратно, давно не вызывают удивления аудитории. Молодые женщины выполняют немыслимые акробатические трюки, пожилые мужчины раскидывают толпы врагов двуручными мечами, превышающими их рост. Спаситель вселенной одинаково легко обращается с ножом, вертолётным пулемётом или пушкой.
Миры после катастроф изобилуют монстрами, облучённые радиацией химеры бродят по пустошам. Постлавкрафтианская плоть чудовищ сочится из тёмных готических сводов.
Являясь частью массовой культуры, видеоигры чутко реагируют на изменения в обществе и новые тенденции и иногда отражают эти перемены гротескно. Повинуясь импульсу, разработчики игр переписывают историю: так полководцами римских войск становятся женщины и эфиопы. В играх, посвященных войнам XX века, руки героев превращаются в протезы, на лицах проступают синие узоры кельтских воинов, винтовки заменяются катанами.
Гротеск проступает в различных обличьях, которые будут рассмотрены в лекции.
Ведущий Евгений Кузьмичев — сотрудник образовательного центра МИСП.
Стоимость лекции — 200 руб.
Льготный билет — 100 руб.
Билет приобретается в кассе музея.
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` = 'grotesk-i-videoigry-telesnost-i-narrativ' 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` = ('3610') AND `I18n__disabled`.`content` = '0' ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC | 1 | 1 | 7 | 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` = ('3610') 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` = 3610 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` = (3610) 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` = (3610) 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` = ('3610') 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` = ('3610') 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` = 3610 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` = (3610) 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` = (3610) 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` = 3610 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` = 3610 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` <> 3610 AND `Event`.`cloned_id` > NULL ORDER BY `Event`.`cloned_id` ASC, `Event`.`position` DESC, `Event`.`id` DESC LIMIT 1 | 0 | 0 | 155 | 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` <> 3610 AND `Event`.`cloned_id` < NULL ORDER BY `Event`.`cloned_id` DESC, `Event`.`position` ASC, `Event`.`id` ASC LIMIT 1 | 0 | 0 | 136 | 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` = 14 ORDER BY `Type`.`caption` ASC LIMIT 1 | 0 | 0 | 3 | 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 `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` = 'grotesk-i-videoigry-telesnost-i-narrativ' 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` = ('3610') 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` = ('3610') 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`=3610 AND `field`='disabled' AND `content`=0 | 1 | 1 | 1 |
Peak Memory Use 21.37 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: 615 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 5.51 | |
Event: Controller.initialize | 0.70 | |
Event: Controller.startup | 94.05 | |
Controller action | 480.29 | |
Event: Controller.beforeRender | 49.79 | |
» Processing toolbar data | 48.60 | |
Rendering View | 10.11 | |
» Event: View.beforeRender | 0.04 | |
» Rendering APP/View/Events/view.ctp | 1.58 | |
» » Rendering APP/View/Elements/layouts/bc.ctp | 0.07 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering APP/View/Layouts/default.ctp | 7.41 | |
» » Rendering APP/View/Elements/layouts/hreflink.ctp | 0.05 | |
» » Rendering APP/View/Elements/layouts/header.ctp | 2.95 | |
» » Rendering APP/View/Elements/layouts/footer.ctp | 3.44 | |
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 | 59494 |
Redirect Url | /webroot/event/grotesk-i-videoigry-telesnost-i-narrativ |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.0 |
Request Method | GET |
Query String | |
Request Uri | /event/grotesk-i-videoigry-telesnost-i-narrativ |
Script Name | /webroot/index.php |
Php Self | /webroot/index.php |
Request Time Float | 1701834366.456 |
Request Time | 1701834366 |