Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT COUNT(*) AS `count` FROM `sezamintldcms3`.`events` AS `Event` WHERE `Event`.`id` = 238 | 1 | 1 | 1 | |
SELECT `Event`.`id`, `Event`.`slug`, `Event`.`online_date`, `Event`.`online_date_end`, `Event`.`parallele_id`, `Event`.`partner_id`, `Event`.`picture_id`, `Event`.`media_id`, `Event`.`active`, `Event`.`created`, `Event`.`modified`, (`I18n__titleTranslations`.`content`) AS `Event__i18n_titleTranslations`, (`I18n__editorialTranslations`.`content`) AS `Event__i18n_editorialTranslations`, (`I18n__contentTranslations`.`content`) AS `Event__i18n_contentTranslations`, (`I18n__metaTitleTranslations`.`content`) AS `Event__i18n_metaTitleTranslations`, (`I18n__metaDescriptionTranslations`.`content`) AS `Event__i18n_metaDescriptionTranslations` FROM `sezamintldcms3`.`events` AS `Event` INNER JOIN `sezamintldcms3`.`i18n` AS `I18n__titleTranslations` ON (`Event`.`id` = `I18n__titleTranslations`.`foreign_key` AND `I18n__titleTranslations`.`model` = 'Event' AND `I18n__titleTranslations`.`field` = 'title' AND `I18n__titleTranslations`.`locale` = 'fra') INNER JOIN `sezamintldcms3`.`i18n` AS `I18n__editorialTranslations` ON (`Event`.`id` = `I18n__editorialTranslations`.`foreign_key` AND `I18n__editorialTranslations`.`model` = 'Event' AND `I18n__editorialTranslations`.`field` = 'editorial' AND `I18n__editorialTranslations`.`locale` = 'fra') INNER JOIN `sezamintldcms3`.`i18n` AS `I18n__contentTranslations` ON (`Event`.`id` = `I18n__contentTranslations`.`foreign_key` AND `I18n__contentTranslations`.`model` = 'Event' AND `I18n__contentTranslations`.`field` = 'content' AND `I18n__contentTranslations`.`locale` = 'fra') INNER JOIN `sezamintldcms3`.`i18n` AS `I18n__metaTitleTranslations` ON (`Event`.`id` = `I18n__metaTitleTranslations`.`foreign_key` AND `I18n__metaTitleTranslations`.`model` = 'Event' AND `I18n__metaTitleTranslations`.`field` = 'meta_title' AND `I18n__metaTitleTranslations`.`locale` = 'fra') INNER JOIN `sezamintldcms3`.`i18n` AS `I18n__metaDescriptionTranslations` ON (`Event`.`id` = `I18n__metaDescriptionTranslations`.`foreign_key` AND `I18n__metaDescriptionTranslations`.`model` = 'Event' AND `I18n__metaDescriptionTranslations`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslations`.`locale` = 'fra') WHERE `Event`.`id` = 238 ORDER BY `Event`.`online_date` DESC, `Event`.`id` DESC LIMIT 1 | 1 | 1 | 4 | maybe slow |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position` FROM `sezamintldcms3`.`medias` AS `Media` WHERE ref = "Event" AND `Media`.`ref_id` = (238) ORDER BY `Media`.`position` ASC | 0 | 0 | 1 | maybe slow |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position`, (`I18n__altTranslation`.`content`) AS `Media__i18n_altTranslation`, (`I18n__titleTranslation`.`content`) AS `Media__i18n_titleTranslation`, (`I18n__figcaptionTranslation`.`content`) AS `Media__i18n_figcaptionTranslation` FROM `sezamintldcms3`.`medias` AS `Media` INNER JOIN `sezamintldcms3`.`media_translations` AS `I18n__altTranslation` ON (`Media`.`id` = `I18n__altTranslation`.`foreign_key` AND `I18n__altTranslation`.`model` = 'Media' AND `I18n__altTranslation`.`field` = 'alt' AND `I18n__altTranslation`.`locale` = 'fra') INNER JOIN `sezamintldcms3`.`media_translations` AS `I18n__titleTranslation` ON (`Media`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Media' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'fra') INNER JOIN `sezamintldcms3`.`media_translations` AS `I18n__figcaptionTranslation` ON (`Media`.`id` = `I18n__figcaptionTranslation`.`foreign_key` AND `I18n__figcaptionTranslation`.`model` = 'Media' AND `I18n__figcaptionTranslation`.`field` = 'figcaption' AND `I18n__figcaptionTranslation`.`locale` = 'fra') WHERE `ref` = 'Event' AND `ref_id` = 238 ORDER BY `position` ASC | 0 | 0 | 4 | maybe slow |
SELECT `Partner`.`id`, `Partner`.`name`, `Partner`.`adress`, `Partner`.`city`, `Partner`.`phone`, `Partner`.`transport`, `Partner`.`website`, `Partner`.`active`, `Partner`.`picture_url`, `Partner`.`media_id`, `Partner`.`category_partner_id`, `Partner`.`platform_id`, `Partner`.`index`, `Partner`.`orderable`, `Partner`.`created`, `Partner`.`modified` FROM `sezamintldcms3`.`partners` AS `Partner` WHERE `orderable` IS NULL ORDER BY `created` DESC | 0 | 0 | 1 | maybe slow |
SELECT `Event`.`id`, `Event`.`slug`, `Event`.`online_date`, `Event`.`online_date_end`, `Event`.`parallele_id`, `Event`.`partner_id`, `Event`.`picture_id`, `Event`.`media_id`, `Event`.`active`, `Event`.`created`, `Event`.`modified`, (`I18n__titleTranslations`.`content`) AS `Event__i18n_titleTranslations`, (`I18n__editorialTranslations`.`content`) AS `Event__i18n_editorialTranslations`, (`I18n__contentTranslations`.`content`) AS `Event__i18n_contentTranslations`, (`I18n__metaTitleTranslations`.`content`) AS `Event__i18n_metaTitleTranslations`, (`I18n__metaDescriptionTranslations`.`content`) AS `Event__i18n_metaDescriptionTranslations`, `Partner`.`id`, `Partner`.`name`, `Partner`.`adress`, `Partner`.`city`, `Partner`.`phone`, `Partner`.`transport`, `Partner`.`website`, `Partner`.`active`, `Partner`.`picture_url`, `Partner`.`media_id`, `Partner`.`category_partner_id`, `Partner`.`platform_id`, `Partner`.`index`, `Partner`.`orderable`, `Partner`.`created`, `Partner`.`modified`, `Parallele`.`id`, `Parallele`.`name`, `Parallele`.`edition`, `Parallele`.`fullname`, `Parallele`.`slug`, `Parallele`.`parallele_category_id`, `Parallele`.`picture_id`, `Parallele`.`media_id`, `Parallele`.`forward`, `Parallele`.`year`, `Parallele`.`p1_country`, `Parallele`.`p1_town`, `Parallele`.`p1_starting`, `Parallele`.`p1_ending`, `Parallele`.`p2_country`, `Parallele`.`p2_town`, `Parallele`.`p2_starting`, `Parallele`.`p2_ending`, `Parallele`.`active`, `Parallele`.`created`, `Parallele`.`modified`, `Parallele`.`is_main`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position` FROM `sezamintldcms3`.`events` AS `Event` LEFT JOIN `sezamintldcms3`.`partners` AS `Partner` ON (`Event`.`partner_id` = `Partner`.`id`) LEFT JOIN `sezamintldcms3`.`paralleles` AS `Parallele` ON (`Event`.`parallele_id` = `Parallele`.`id`) LEFT JOIN `sezamintldcms3`.`medias` AS `Thumb` ON (`Event`.`media_id` = `Thumb`.`id`) INNER JOIN `sezamintldcms3`.`i18n` AS `I18n__titleTranslations` ON (`Event`.`id` = `I18n__titleTranslations`.`foreign_key` AND `I18n__titleTranslations`.`model` = 'Event' AND `I18n__titleTranslations`.`field` = 'title' AND `I18n__titleTranslations`.`locale` = 'fra') INNER JOIN `sezamintldcms3`.`i18n` AS `I18n__editorialTranslations` ON (`Event`.`id` = `I18n__editorialTranslations`.`foreign_key` AND `I18n__editorialTranslations`.`model` = 'Event' AND `I18n__editorialTranslations`.`field` = 'editorial' AND `I18n__editorialTranslations`.`locale` = 'fra') INNER JOIN `sezamintldcms3`.`i18n` AS `I18n__contentTranslations` ON (`Event`.`id` = `I18n__contentTranslations`.`foreign_key` AND `I18n__contentTranslations`.`model` = 'Event' AND `I18n__contentTranslations`.`field` = 'content' AND `I18n__contentTranslations`.`locale` = 'fra') INNER JOIN `sezamintldcms3`.`i18n` AS `I18n__metaTitleTranslations` ON (`Event`.`id` = `I18n__metaTitleTranslations`.`foreign_key` AND `I18n__metaTitleTranslations`.`model` = 'Event' AND `I18n__metaTitleTranslations`.`field` = 'meta_title' AND `I18n__metaTitleTranslations`.`locale` = 'fra') INNER JOIN `sezamintldcms3`.`i18n` AS `I18n__metaDescriptionTranslations` ON (`Event`.`id` = `I18n__metaDescriptionTranslations`.`foreign_key` AND `I18n__metaDescriptionTranslations`.`model` = 'Event' AND `I18n__metaDescriptionTranslations`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslations`.`locale` = 'fra') WHERE `Event`.`id` = 238 ORDER BY `Event`.`online_date` DESC, `Event`.`id` DESC LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Picture`.`id`, `Picture`.`model`, `Picture`.`foreign_key`, `Picture`.`main`, `Picture`.`name`, `Picture`.`alt`, `Picture`.`title`, `Picture`.`url`, `Picture`.`url_original`, `Picture`.`url_minified`, `Picture`.`url_thumb`, `Picture`.`created`, `Picture`.`modified` FROM `sezamintldcms3`.`pictures` AS `Picture` WHERE `Picture`.`model` = 'Event' AND `Picture`.`foreign_key` = (238) | 0 | 0 | 1 | maybe slow |
SELECT `ProgramDate`.`id`, `ProgramDate`.`model`, `ProgramDate`.`model_id`, `ProgramDate`.`program_name_override`, `ProgramDate`.`parallele_id`, `ProgramDate`.`place`, `ProgramDate`.`address`, `ProgramDate`.`city`, `ProgramDate`.`phone`, `ProgramDate`.`website`, `ProgramDate`.`date_start`, `ProgramDate`.`date_end`, `ProgramDate`.`schedule`, `ProgramDate`.`duration`, `ProgramDate`.`partner_id`, `ProgramDate`.`active`, `ProgramDate`.`room`, `ProgramDate`.`created`, `ProgramDate`.`modified` FROM `sezamintldcms3`.`program_dates` AS `ProgramDate` WHERE `ProgramDate`.`model` = 'Event' AND `ProgramDate`.`model_id` = (238) | 0 | 0 | 1 | maybe slow |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position` FROM `sezamintldcms3`.`medias` AS `Media` WHERE ref = "Event" AND `Media`.`ref_id` = (238) ORDER BY `Media`.`position` ASC | 0 | 0 | 1 | maybe slow |
SELECT `titleTranslations`.`id`, `titleTranslations`.`locale`, `titleTranslations`.`model`, `titleTranslations`.`foreign_key`, `titleTranslations`.`field`, `titleTranslations`.`content` FROM `sezamintldcms3`.`i18n` AS `titleTranslations` WHERE `model` = 'Event' AND `field` = 'title' AND `titleTranslations`.`foreign_key` = (238) ORDER BY `id` ASC | 2 | 2 | 42 | maybe slow |
SELECT `editorialTranslations`.`id`, `editorialTranslations`.`locale`, `editorialTranslations`.`model`, `editorialTranslations`.`foreign_key`, `editorialTranslations`.`field`, `editorialTranslations`.`content` FROM `sezamintldcms3`.`i18n` AS `editorialTranslations` WHERE `model` = 'Event' AND `field` = 'editorial' AND `editorialTranslations`.`foreign_key` = (238) ORDER BY `id` ASC | 2 | 2 | 25 | maybe slow |
SELECT `contentTranslations`.`id`, `contentTranslations`.`locale`, `contentTranslations`.`model`, `contentTranslations`.`foreign_key`, `contentTranslations`.`field`, `contentTranslations`.`content` FROM `sezamintldcms3`.`i18n` AS `contentTranslations` WHERE `model` = 'Event' AND `field` = 'content' AND `contentTranslations`.`foreign_key` = (238) ORDER BY `id` ASC | 2 | 2 | 21 | maybe slow |
SELECT `metaTitleTranslations`.`id`, `metaTitleTranslations`.`locale`, `metaTitleTranslations`.`model`, `metaTitleTranslations`.`foreign_key`, `metaTitleTranslations`.`field`, `metaTitleTranslations`.`content` FROM `sezamintldcms3`.`i18n` AS `metaTitleTranslations` WHERE `model` = 'Event' AND `field` = 'meta_title' AND `metaTitleTranslations`.`foreign_key` = (238) ORDER BY `id` ASC | 2 | 2 | 19 | maybe slow |
SELECT `metaDescriptionTranslations`.`id`, `metaDescriptionTranslations`.`locale`, `metaDescriptionTranslations`.`model`, `metaDescriptionTranslations`.`foreign_key`, `metaDescriptionTranslations`.`field`, `metaDescriptionTranslations`.`content` FROM `sezamintldcms3`.`i18n` AS `metaDescriptionTranslations` WHERE `model` = 'Event' AND `field` = 'meta_description' AND `metaDescriptionTranslations`.`foreign_key` = (238) ORDER BY `id` ASC | 2 | 2 | 26 | maybe slow |
SELECT `Artist`.`id`, `Artist`.`is_group`, `Artist`.`name`, `Artist`.`slug`, `Artist`.`firstname`, `Artist`.`lastname`, `Artist`.`website`, `Artist`.`platform_id`, `Artist`.`media_id`, `Artist`.`ba_program_id`, `Artist`.`active`, `Artist`.`created`, `Artist`.`modified`, `Artist`.`is_production`, `Artist`.`is_archive`, `ArtistsEvents`.`id`, `ArtistsEvents`.`artist_id`, `ArtistsEvents`.`event_id` FROM `sezamintldcms3`.`artists` AS `Artist` JOIN `sezamintldcms3`.`artists_events` AS `ArtistsEvents` ON (`ArtistsEvents`.`event_id` = 238 AND `ArtistsEvents`.`artist_id` = `Artist`.`id`) | 0 | 0 | 1 | maybe slow |
SELECT `Event`.`id` FROM `sezamintldcms3`.`events` AS `Event` WHERE `Event`.`active` = '1' AND `Event`.`online_date` <= '2025-03-12' AND ((`Event`.`online_date_end` > '2025-03-12') OR (`Event`.`online_date_end` IS NULL)) AND `Event`.`id` < 238 ORDER BY `Event`.`id` DESC LIMIT 1 | 1 | 1 | 1 | |
SELECT `Event`.`id` FROM `sezamintldcms3`.`events` AS `Event` WHERE `Event`.`active` = '1' AND `Event`.`online_date` <= '2025-03-12' AND ((`Event`.`online_date_end` > '2025-03-12') OR (`Event`.`online_date_end` IS NULL)) AND `Event`.`id` >= 237 AND `Event`.`id` != 238 ORDER BY `Event`.`id` ASC LIMIT 2 | 2 | 2 | 0 | |
SELECT `Event`.`id`, `Event`.`slug`, `Event`.`online_date` FROM `sezamintldcms3`.`events` AS `Event` WHERE `Event`.`active` = '1' AND `Event`.`id` = 237 ORDER BY `Event`.`online_date` DESC, `Event`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`id`, `Event`.`slug`, `Event`.`online_date` FROM `sezamintldcms3`.`events` AS `Event` WHERE `Event`.`active` = '1' AND `Event`.`id` = 239 ORDER BY `Event`.`online_date` DESC, `Event`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(DISTINCT(`Parallele`.`id`)) AS count FROM `sezamintldcms3`.`paralleles` AS `Parallele` LEFT JOIN `sezamintldcms3`.`parallele_categories` AS `ParalleleCategory` ON (`Parallele`.`parallele_category_id` = `ParalleleCategory`.`id`) LEFT JOIN `sezamintldcms3`.`pictures` AS `Picture` ON (`Parallele`.`picture_id` = `Picture`.`id`) LEFT JOIN `sezamintldcms3`.`medias` AS `Thumb` ON (`Parallele`.`media_id` = `Thumb`.`id`) INNER JOIN `sezamintldcms3`.`i18n` AS `I18nModel` ON (`Parallele`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'Parallele' AND `I18nModel`.`locale` = 'fra') WHERE `Parallele`.`is_main` = '1' AND `Parallele`.`active` = '1' AND `Parallele`.`forward` = '1' | 1 | 1 | 4 | maybe slow |
SELECT COUNT(DISTINCT(`Parallele`.`id`)) AS count FROM `sezamintldcms3`.`paralleles` AS `Parallele` LEFT JOIN `sezamintldcms3`.`parallele_categories` AS `ParalleleCategory` ON (`Parallele`.`parallele_category_id` = `ParalleleCategory`.`id`) LEFT JOIN `sezamintldcms3`.`pictures` AS `Picture` ON (`Parallele`.`picture_id` = `Picture`.`id`) LEFT JOIN `sezamintldcms3`.`medias` AS `Thumb` ON (`Parallele`.`media_id` = `Thumb`.`id`) INNER JOIN `sezamintldcms3`.`i18n` AS `I18nModel` ON (`Parallele`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'Parallele' AND `I18nModel`.`locale` = 'fra') WHERE `Parallele`.`is_main` = '0' AND `Parallele`.`active` = '1' AND `Parallele`.`forward` = '1' | 1 | 1 | 3 | maybe slow |
SELECT `SeoTitle`.`title`, `SeoUri`.`uri`, `SeoUri`.`id` FROM `sezamintldcms3`.`seo_titles` AS `SeoTitle` LEFT JOIN `sezamintldcms3`.`seo_uris` AS `SeoUri` ON (`SeoTitle`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/actualites/238-appelaprojetslareleve5' AND `SeoUri`.`is_approved` = '1' LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `SeoMetaTag`.`id`, `SeoMetaTag`.`seo_uri_id`, `SeoMetaTag`.`name`, `SeoMetaTag`.`content`, `SeoMetaTag`.`is_http_equiv`, `SeoMetaTag`.`created`, `SeoMetaTag`.`modified`, `SeoUri`.`uri` FROM `sezamintldcms3`.`seo_meta_tags` AS `SeoMetaTag` LEFT JOIN `sezamintldcms3`.`seo_uris` AS `SeoUri` ON (`SeoMetaTag`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/actualites/238-appelaprojetslareleve5' AND `SeoUri`.`is_approved` = '1' | 0 | 0 | 2 | maybe slow |
SELECT `SeoUri`.`id`, `SeoUri`.`uri` FROM `sezamintldcms3`.`seo_uris` AS `SeoUri` WHERE ((`SeoUri`.`uri` LIKE '#%') OR (`SeoUri`.`uri` LIKE '%*')) AND `SeoUri`.`is_approved` = '1' | 0 | 0 | 1 | maybe slow |
1 duplicate queries run.