Даты
13 апреля 2019, 19:00 — 23:00
Цена
400 р. — 600 р.
Афиша /
Большой весенний концерт коллективов “Трипинадва”, Shokalsky Revenge, Starcardigan и других!
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` = 'tripinadva-shokalsky-revenge-starcardigan' 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` = ('4978') AND `I18n__disabled`.`content` = '0' ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC | 1 | 1 | 9 | 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` = ('4978') 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` = 4978 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` = (4978) 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` = (4978) ORDER BY `EventDate`.`date` ASC | 1 | 1 | 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` = ('4978') 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` = ('4978') 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` = 4978 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` = (4978) 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` = (4978) ORDER BY `EventDate`.`date` ASC | 1 | 1 | 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` = 4978 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` = 4978 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` <> 4978 AND `Event`.`cloned_id` > NULL ORDER BY `Event`.`cloned_id` ASC, `Event`.`position` DESC, `Event`.`id` DESC LIMIT 1 | 0 | 0 | 139 | 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` <> 4978 AND `Event`.`cloned_id` < NULL ORDER BY `Event`.`cloned_id` DESC, `Event`.`position` ASC, `Event`.`id` ASC LIMIT 1 | 0 | 0 | 144 | 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` = 'tripinadva-shokalsky-revenge-starcardigan' 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` = ('4978') 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` = ('4978') 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`=4978 AND `field`='disabled' AND `content`=0 | 1 | 1 | 1 |
Peak Memory Use 12.56 MB
| Message | Memory use |
|---|---|
| Component initialization | 1.89 MB |
| Controller action start | 2.14 MB |
| Controller render start | 7.93 MB |
| View render complete | 8.52 MB |
Total Request Time: 648 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 6.10 | |
| Event: Controller.initialize | 0.60 | |
| Event: Controller.startup | 152.05 | |
| Controller action | 545.89 | |
| Event: Controller.beforeRender | 18.44 | |
| » Processing toolbar data | 16.41 | |
| Rendering View | 13.83 | |
| » Event: View.beforeRender | 0.05 | |
| » Rendering APP/View/Events/view.ctp | 2.73 | |
| » » Rendering APP/View/Elements/layouts/bc.ctp | 0.10 | |
| » Event: View.afterRender | 0.02 | |
| » Event: View.beforeLayout | 0.02 | |
| » Rendering APP/View/Layouts/default.ctp | 9.74 | |
| » » Rendering APP/View/Elements/layouts/hreflink.ctp | 0.07 | |
| » » Rendering APP/View/Elements/layouts/header.ctp | 3.05 | |
| » » Rendering APP/View/Elements/layouts/footer.ctp | 5.08 | |
| 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 | 18.207.160.97 |
| 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 | 18.207.160.97 |
| 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 | 53924 |
| Redirect Url | /webroot/event/tripinadva-shokalsky-revenge-starcardigan |
| Gateway Interface | CGI/1.1 |
| Server Protocol | HTTP/1.0 |
| Request Method | GET |
| Query String | |
| Request Uri | /event/tripinadva-shokalsky-revenge-starcardigan |
| Script Name | /webroot/index.php |
| Php Self | /webroot/index.php |
| Request Time Float | 1701791966.962 |
| Request Time | 1701791966 |