Дата
11 ноября 2018, 19:30 – 22:00
Цена
500 р. — 1 000 р.
Афиша /
Денисс Пашкевич — выдающийся рижский саксофонист и флейтист, известный в джазовом мире далеко за пределами Балтии. Его справедливо считают продолжателем традиций Джона Колтрейна и Майлза Дэвиса, а его имя украшает европейское джазовое дерево. Автор собственных композиций в самых разных стилях и жанрах в диапазоне от фанка и хард-бопа до смелых авангардных экспериментов, Пашкевич — это музыкант, который трогает душу и сердце уникальным звучанием. Aльбом «Yours Faithfully» получил латвийский GRAMMY как лучший альбом 2017 года в категории «Jazz&blues».
Денис Пашкевич сотрудничал с такими музыкантами, как Seamus Blake, Christian Frank, Paul Bollenback, Christian Howes, Arkady Gotesman, Vjacheslav Ganelin, Brian Melvin, Neff Irizarry, Ryo Kawasaki, Peter Eldredge (NY Voices), Janet Lawson, Bill Harper, Ted Curson, Stenley Jordan, Victor Fonarev, Brian Linch, Tim Miller, James Tomas Werts, Jill Scot Heron, Ray Blue (Spirit of Life), Bob Ferrel, Vincent Coutro, David Kikoski, Rick Margitza, Aaron Parks, Randy Brecker и многими другими.
На сцене клуба JFC Deniss выступит совместно с Intuitive Project. Концерт состоится при участии Йоеля Гонсалеса.
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` = 'deniss-pashkevich-and-intuitive-project' 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` = ('2021') AND `I18n__disabled`.`content` = '0' ORDER BY `Article`.`cloned_id` ASC, `Article`.`position` ASC, `Article`.`id` DESC | 1 | 1 | 13 | 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` = ('2021') 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` = 2021 ORDER BY `Event`.`cloned_id` ASC, `Event`.`position` DESC, `Event`.`id` DESC, `Type`.`caption` ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
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` = (2021) 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` = (2021) ORDER BY `EventDate`.`date` ASC | 0 | 0 | 0 | |
SELECT `Article`.`id`, `Article`.`cloned_id`, `Article`.`account_id`, `Article`.`article_rubric_id`, `Article`.`slug`, `Article`.`type`, `Article`.`caption`, `Article`.`caption_a`, `Article`.`address`, `Article`.`brief`, `Article`.`content`, `Article`.`content_2`, `Article`.`times`, `Article`.`itype`, `Article`.`image_main`, `Article`.`image`, `Article`.`image_mobile`, `Article`.`thumbnail`, `Article`.`thumbnail_1`, `Article`.`thumbnail_2`, `Article`.`_thumbnail`, `Article`.`video`, `Article`.`map_caption`, `Article`.`map_n`, `Article`.`map_e`, `Article`.`meta_title`, `Article`.`meta_description`, `Article`.`position`, `Article`.`pay`, `Article`.`supplier_id`, `Article`.`price`, `Article`.`supplier_price`, `Article`.`active`, `Article`.`checked`, `Article`.`m_reason`, `Article`.`show_han`, `Article`.`night`, `Article`.`nearby`, `Article`.`main_adv`, `Article`.`views`, `Article`.`disabled`, `Article`.`created`, `Article`.`modified`, `Article`.`image_author`, `Article`.`image_source`, `ArticlesEvent`.`id`, `ArticlesEvent`.`article_id`, `ArticlesEvent`.`event_id`, I18n__caption.content AS Article__i18n_caption, I18n__caption_a.content AS Article__i18n_caption_a, I18n__address.content AS Article__i18n_address, I18n__brief.content AS Article__i18n_brief, I18n__content.content AS Article__i18n_content, I18n__content_2.content AS Article__i18n_content_2, I18n__times.content AS Article__i18n_times, I18n__meta_title.content AS Article__i18n_meta_title, I18n__meta_description.content AS Article__i18n_meta_description, I18n__disabled.content AS Article__i18n_disabled, I18n__active.content AS Article__i18n_active FROM `petersburg24`.`articles` AS `Article` LEFT JOIN `petersburg24`.`articles_events` AS `ArticlesEvent` ON (`Article`.`id` = `ArticlesEvent`.`article_id`) LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption` ON (`Article`.`id` = `I18n__caption`.`foreign_key` AND `I18n__caption`.`model` = 'Article' AND `I18n__caption`.`field` = 'caption' AND `I18n__caption`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__caption_a` ON (`Article`.`id` = `I18n__caption_a`.`foreign_key` AND `I18n__caption_a`.`model` = 'Article' AND `I18n__caption_a`.`field` = 'caption_a' AND `I18n__caption_a`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__address` ON (`Article`.`id` = `I18n__address`.`foreign_key` AND `I18n__address`.`model` = 'Article' AND `I18n__address`.`field` = 'address' AND `I18n__address`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__brief` ON (`Article`.`id` = `I18n__brief`.`foreign_key` AND `I18n__brief`.`model` = 'Article' AND `I18n__brief`.`field` = 'brief' AND `I18n__brief`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content` ON (`Article`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Article' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__content_2` ON (`Article`.`id` = `I18n__content_2`.`foreign_key` AND `I18n__content_2`.`model` = 'Article' AND `I18n__content_2`.`field` = 'content_2' AND `I18n__content_2`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__times` ON (`Article`.`id` = `I18n__times`.`foreign_key` AND `I18n__times`.`model` = 'Article' AND `I18n__times`.`field` = 'times' AND `I18n__times`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__meta_title` ON (`Article`.`id` = `I18n__meta_title`.`foreign_key` AND `I18n__meta_title`.`model` = 'Article' AND `I18n__meta_title`.`field` = 'meta_title' AND `I18n__meta_title`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__meta_description` ON (`Article`.`id` = `I18n__meta_description`.`foreign_key` AND `I18n__meta_description`.`model` = 'Article' AND `I18n__meta_description`.`field` = 'meta_description' AND `I18n__meta_description`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__disabled` ON (`Article`.`id` = `I18n__disabled`.`foreign_key` AND `I18n__disabled`.`model` = 'Article' AND `I18n__disabled`.`field` = 'disabled' AND `I18n__disabled`.`locale` = 'rus') LEFT JOIN `petersburg24`.`i18n` AS `I18n__active` ON (`Article`.`id` = `I18n__active`.`foreign_key` AND `I18n__active`.`model` = 'Article' AND `I18n__active`.`field` = 'active' AND `I18n__active`.`locale` = 'rus') WHERE `ArticlesEvent`.`event_id` = ('2021') 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` = ('2021') 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` = 2021 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` = (2021) 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` = (2021) 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` = 2021 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` = 2021 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` <> 2021 AND `Event`.`cloned_id` > NULL ORDER BY `Event`.`cloned_id` ASC, `Event`.`position` DESC, `Event`.`id` DESC LIMIT 1 | 0 | 0 | 177 | 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` <> 2021 AND `Event`.`cloned_id` < NULL ORDER BY `Event`.`cloned_id` DESC, `Event`.`position` ASC, `Event`.`id` ASC LIMIT 1 | 0 | 0 | 182 | 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` = 'deniss-pashkevich-and-intuitive-project' 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` = ('2021') 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` = ('2021') 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`=2021 AND `field`='disabled' AND `content`=0 | 2 | 2 | 1 | maybe slow |
Peak Memory Use 16.17 MB
Message | Memory use |
---|---|
Component initialization | 1.91 MB |
Controller action start | 2.15 MB |
Controller render start | 8.08 MB |
View render complete | 8.67 MB |
Total Request Time: 733 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 7.26 | |
Event: Controller.initialize | 1.02 | |
Event: Controller.startup | 117.10 | |
Controller action | 598.46 | |
Event: Controller.beforeRender | 42.74 | |
» Processing toolbar data | 41.08 | |
Rendering View | 15.49 | |
» Event: View.beforeRender | 0.08 | |
» Rendering APP/View/Events/view.ctp | 1.95 | |
» » 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 | 12.08 | |
» » Rendering APP/View/Elements/layouts/hreflink.ctp | 0.86 | |
» » Rendering APP/View/Elements/layouts/header.ctp | 4.56 | |
» » Rendering APP/View/Elements/layouts/footer.ctp | 5.05 | |
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 | 60793 |
Redirect Url | /webroot/event/deniss-pashkevich-and-intuitive-project |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.0 |
Request Method | GET |
Query String | |
Request Uri | /event/deniss-pashkevich-and-intuitive-project |
Script Name | /webroot/index.php |
Php Self | /webroot/index.php |
Request Time Float | 1701839272.477 |
Request Time | 1701839272 |