Fair site
Category
Fair siteDate
22 december 2018, 12:00 — 07 january 2019, 21:00
Price
Free of charge
Сайт
vk.com/nyfairspbEvents / Fair site
Is it possible to imagine New Year and Christmas without festivities and the traditional Christmas fair?
The Pioneer Square will house 158 pavilions with exclusive products from manufacturers and craftsmen from 12 countries and 17 regions of our country.
Austrians and Karelians, Cubans and Novgorodians, Israelis and Rostov will acquaint the guests of the fair with their national cuisine and traditions of celebrating Christmas and the New Year.
You will be able to meet the living symbol of the New Year in the evening on December 22.
The concept of this year's Fair is “Christmas Theater”, and it is dedicated to the upcoming “Year of Theater”. Anyone can take part in Christmas musicals, staged mass "flash mobs" and mini-performances on the New Year theme - the entertainment program will be interactive.
From the traditional fair entertainment to the delight of guests - an ice skating rink, carousels and a petting zoo.
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` = 'eng') 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` = 'eng') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND `slug` = 'bolshaya-rozhdestvenskaya-yarmarka' 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_eng` 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') WHERE `ArticlesEvent`.`event_id` = ('3249') 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` = ('3249') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND `Event`.`id` = 3249 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` = (3249) ORDER BY `AttachmentImage`.`position` DESC, `AttachmentImage`.`id` DESC | 0 | 0 | 1 | maybe slow |
SELECT `EventDate`.`id`, `EventDate`.`event_id`, `EventDate`.`date`, `EventDate`.`time_from`, `EventDate`.`time_to` FROM `petersburg24`.`event_dates` AS `EventDate` WHERE `EventDate`.`event_id` = (3249) 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_eng` 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') WHERE `ArticlesEvent`.`event_id` = ('3249') 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` = ('3249') 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` = 3249 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`.`foreign_key` = (3249) ORDER BY `AttachmentImage`.`position` DESC, `AttachmentImage`.`id` DESC | 0 | 0 | 1 | maybe slow |
SELECT `EventDate`.`id`, `EventDate`.`event_id`, `EventDate`.`date`, `EventDate`.`time_from`, `EventDate`.`time_to` FROM `petersburg24`.`event_dates` AS `EventDate` WHERE `EventDate`.`event_id` = (3249) 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` = 3249 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` = 3249 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` = 'eng') 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` = 'eng') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND `Event`.`id` <> 3249 AND `Event`.`cloned_id` > NULL ORDER BY `Event`.`cloned_id` ASC, `Event`.`position` DESC, `Event`.`id` DESC LIMIT 1 | 0 | 0 | 66 | 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` = 'eng') 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` = 'eng') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND `Event`.`id` <> 3249 AND `Event`.`cloned_id` < NULL ORDER BY `Event`.`cloned_id` DESC, `Event`.`position` ASC, `Event`.`id` ASC LIMIT 1 | 0 | 0 | 72 | 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') WHERE `I18n__disabled`.`content` = 0 AND `Type`.`id` = 8 ORDER BY `Type`.`caption` ASC LIMIT 1 | 1 | 1 | 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') WHERE `I18n__active`.`content` = '1' AND `I18n__disabled`.`content` = '0' AND `Event`.`slug` = 'bolshaya-rozhdestvenskaya-yarmarka' 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_eng` 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') 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` = 'eng') WHERE `ArticlesEvent`.`event_id` = ('3249') 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` = ('3249') 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`=3249 AND `field`='disabled' AND `content`=0 | 2 | 2 | 1 | maybe slow |
Peak Memory Use 13.41 MB
Message | Memory use |
---|---|
Component initialization | 1.87 MB |
Controller action start | 2.13 MB |
Controller render start | 7.73 MB |
View render complete | 8.26 MB |
Total Request Time: 481 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 6.67 | |
Event: Controller.initialize | 0.65 | |
Event: Controller.startup | 140.29 | |
Controller action | 392.29 | |
Event: Controller.beforeRender | 18.48 | |
» Processing toolbar data | 17.17 | |
Rendering View | 13.80 | |
» Event: View.beforeRender | 0.04 | |
» Rendering APP/View/Events/view.ctp | 1.78 | |
» » Rendering APP/View/Elements/layouts/bc.ctp | 0.12 | |
» Event: View.afterRender | 0.03 | |
» Event: View.beforeLayout | 0.03 | |
» Rendering APP/View/Layouts/default.ctp | 10.82 | |
» » Rendering APP/View/Elements/layouts/hreflink.ctp | 0.87 | |
» » Rendering APP/View/Elements/layouts/header.ctp | 4.15 | |
» » Rendering APP/View/Elements/layouts/footer.ctp | 3.85 | |
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 | 59734 |
Redirect Url | /webroot/eng/event/bolshaya-rozhdestvenskaya-yarmarka |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.0 |
Request Method | GET |
Query String | |
Request Uri | /eng/event/bolshaya-rozhdestvenskaya-yarmarka |
Script Name | /webroot/index.php |
Php Self | /webroot/index.php |
Request Time Float | 1701836020.606 |
Request Time | 1701836020 |