| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`home`, `PageType`.*, `Template`.`name`, (`I18n__alias`.`content`) AS `Page__i18n_alias`, (`I18n__meta_title`.`content`) AS `Page__i18n_meta_title`, (`I18n__meta_description`.`content`) AS `Page__i18n_meta_description` FROM `parnay`.`pages` AS `Page` INNER JOIN `parnay`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') INNER JOIN `parnay`.`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` = 'fra') INNER JOIN `parnay`.`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` = 'fra') LEFT JOIN `parnay`.`templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) LEFT JOIN `parnay`.`page_types` AS `PageType` ON (`Page`.`page_type_id` = `PageType`.`id`) WHERE (`I18n__alias`.`content`) = 'parnay-dans-la-presse' AND `Page`.`active` = '1' AND `Page`.`home` = '0' LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `nameTranslations`.`id`, `nameTranslations`.`locale`, `nameTranslations`.`model`, `nameTranslations`.`foreign_key`, `nameTranslations`.`field`, `nameTranslations`.`content` FROM `parnay`.`i18n` AS `nameTranslations` WHERE `model` = 'Page' AND `field` = 'name' AND `nameTranslations`.`foreign_key` = (86) | 2 | 2 | 0 | |
| SELECT `aliasTranslations`.`id`, `aliasTranslations`.`locale`, `aliasTranslations`.`model`, `aliasTranslations`.`foreign_key`, `aliasTranslations`.`field`, `aliasTranslations`.`content` FROM `parnay`.`i18n` AS `aliasTranslations` WHERE `model` = 'Page' AND `field` = 'alias' AND `aliasTranslations`.`foreign_key` = (86) | 2 | 2 | 0 | |
| SELECT `meta_titleTranslations`.`id`, `meta_titleTranslations`.`locale`, `meta_titleTranslations`.`model`, `meta_titleTranslations`.`foreign_key`, `meta_titleTranslations`.`field`, `meta_titleTranslations`.`content` FROM `parnay`.`i18n` AS `meta_titleTranslations` WHERE `model` = 'Page' AND `field` = 'meta_title' AND `meta_titleTranslations`.`foreign_key` = (86) | 2 | 2 | 0 | |
| SELECT `meta_descriptionTranslations`.`id`, `meta_descriptionTranslations`.`locale`, `meta_descriptionTranslations`.`model`, `meta_descriptionTranslations`.`foreign_key`, `meta_descriptionTranslations`.`field`, `meta_descriptionTranslations`.`content` FROM `parnay`.`i18n` AS `meta_descriptionTranslations` WHERE `model` = 'Page' AND `field` = 'meta_description' AND `meta_descriptionTranslations`.`foreign_key` = (86) | 2 | 2 | 0 | |
| SELECT `Page`.`parent_id`, `Page`.`home`, `PageType`.`slug`, `PageType`.`controller`, `PageType`.`action`, (`I18n__name`.`content`) AS `Page__i18n_name`, (`I18n__alias`.`content`) AS `Page__i18n_alias`, `Page`.`id` FROM `parnay`.`pages` AS `Page` INNER JOIN `parnay`.`i18n` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') LEFT JOIN `parnay`.`templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) LEFT JOIN `parnay`.`page_types` AS `PageType` ON (`Page`.`page_type_id` = `PageType`.`id`) WHERE `Page`.`active` = '1' AND `Page`.`menu` = '1' ORDER BY `Page`.`lft` ASC | 38 | 38 | 0 | |
| SELECT `Page`.`lft`, `Page`.`rght` FROM `parnay`.`pages` AS `Page` WHERE `Page`.`id` = 86 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.`id`, (`I18n__name`.`content`) AS `Page__i18n_name`, (`I18n__alias`.`content`) AS `Page__i18n_alias` FROM `parnay`.`pages` AS `Page` INNER JOIN `parnay`.`i18n` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') WHERE 1 = 1 AND `Page`.`lft` <= 18 AND `Page`.`rght` >= 19 ORDER BY `Page`.`lft` asc | 2 | 2 | 2 | |
| SELECT `PageType`.*, `Page`.`home`, (`I18n__name`.`content`) AS `Page__i18n_name`, (`I18n__alias`.`content`) AS `Page__i18n_alias`, `Page`.`id` FROM `parnay`.`pages` AS `Page` INNER JOIN `parnay`.`i18n` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') LEFT JOIN `parnay`.`templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) LEFT JOIN `parnay`.`page_types` AS `PageType` ON (`Page`.`page_type_id` = `PageType`.`id`) WHERE ((((`Page`.`menu` = '0') AND (`Page`.`active` = '1'))) OR (`Page`.`alias` = 'contact')) ORDER BY `Page`.`lft` ASC | 2 | 2 | 0 | |
| SELECT `Page`.`lft`, `Page`.`rght`, `Page`.`id` FROM `parnay`.`pages` AS `Page` LEFT JOIN `parnay`.`templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) LEFT JOIN `parnay`.`page_types` AS `PageType` ON (`Page`.`page_type_id` = `PageType`.`id`) WHERE `Page`.`id` = 86 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Page`.*, `PageType`.`slug`, `PageType`.`controller`, `PageType`.`action`, (`I18n__name`.`content`) AS `Page__i18n_name`, (`I18n__alias`.`content`) AS `Page__i18n_alias`, (`I18n__meta_title`.`content`) AS `Page__i18n_meta_title`, (`I18n__meta_description`.`content`) AS `Page__i18n_meta_description`, `Page`.`id` FROM `parnay`.`pages` AS `Page` INNER JOIN `parnay`.`i18n` AS `I18n__name` ON (`Page`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Page' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__alias` ON (`Page`.`id` = `I18n__alias`.`foreign_key` AND `I18n__alias`.`model` = 'Page' AND `I18n__alias`.`field` = 'alias' AND `I18n__alias`.`locale` = 'fra') INNER JOIN `parnay`.`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` = 'fra') INNER JOIN `parnay`.`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` = 'fra') LEFT JOIN `parnay`.`templates` AS `Template` ON (`Page`.`template_id` = `Template`.`id`) LEFT JOIN `parnay`.`page_types` AS `PageType` ON (`Page`.`page_type_id` = `PageType`.`id`) WHERE 1 = 1 AND `Page`.`lft` <= 18 AND `Page`.`rght` >= 19 ORDER BY `Page`.`lft` asc | 2 | 2 | 4 | maybe slow |
| SELECT `Content`.`id`, `Content`.`page_id`, `Content`.`model`, `Content`.`zone`, `Content`.`rang` FROM `parnay`.`contents` AS `Content` WHERE `Content`.`page_id` = 86 ORDER BY `Content`.`zone` ASC, `Content`.`rang` ASC | 8 | 8 | 1 | maybe slow |
| SELECT `ModuleGallery`.`id`, `ModuleGallery`.`content_id` FROM `parnay`.`module_galleries` AS `ModuleGallery` WHERE `ModuleGallery`.`content_id` = 219 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Gallery`.`id`, `Gallery`.`module_gallery_id`, `Gallery`.`caption`, `Gallery`.`rang`, `Gallery`.`filename` FROM `parnay`.`galleries` AS `Gallery` WHERE `Gallery`.`module_gallery_id` = 1 ORDER BY `Gallery`.`rang` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `ModuleArticle`.`id`, `ModuleArticle`.`content_id`, `ModuleArticle`.`name`, `ModuleArticle`.`resume`, `ModuleArticle`.`content`, (`I18n__nameTranslations`.`content`) AS `ModuleArticle__i18n_nameTranslations`, (`I18n__resumeTranslations`.`content`) AS `ModuleArticle__i18n_resumeTranslations`, (`I18n__contentTranslations`.`content`) AS `ModuleArticle__i18n_contentTranslations` FROM `parnay`.`module_articles` AS `ModuleArticle` INNER JOIN `parnay`.`i18n` AS `I18n__nameTranslations` ON (`ModuleArticle`.`id` = `I18n__nameTranslations`.`foreign_key` AND `I18n__nameTranslations`.`model` = 'ModuleArticle' AND `I18n__nameTranslations`.`field` = 'name' AND `I18n__nameTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__resumeTranslations` ON (`ModuleArticle`.`id` = `I18n__resumeTranslations`.`foreign_key` AND `I18n__resumeTranslations`.`model` = 'ModuleArticle' AND `I18n__resumeTranslations`.`field` = 'resume' AND `I18n__resumeTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__contentTranslations` ON (`ModuleArticle`.`id` = `I18n__contentTranslations`.`foreign_key` AND `I18n__contentTranslations`.`model` = 'ModuleArticle' AND `I18n__contentTranslations`.`field` = 'content' AND `I18n__contentTranslations`.`locale` = 'fra') WHERE `ModuleArticle`.`content_id` = 218 LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT `ModuleArticle`.`id`, `ModuleArticle`.`content_id`, `ModuleArticle`.`name`, `ModuleArticle`.`resume`, `ModuleArticle`.`content`, (`I18n__nameTranslations`.`content`) AS `ModuleArticle__i18n_nameTranslations`, (`I18n__resumeTranslations`.`content`) AS `ModuleArticle__i18n_resumeTranslations`, (`I18n__contentTranslations`.`content`) AS `ModuleArticle__i18n_contentTranslations` FROM `parnay`.`module_articles` AS `ModuleArticle` INNER JOIN `parnay`.`i18n` AS `I18n__nameTranslations` ON (`ModuleArticle`.`id` = `I18n__nameTranslations`.`foreign_key` AND `I18n__nameTranslations`.`model` = 'ModuleArticle' AND `I18n__nameTranslations`.`field` = 'name' AND `I18n__nameTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__resumeTranslations` ON (`ModuleArticle`.`id` = `I18n__resumeTranslations`.`foreign_key` AND `I18n__resumeTranslations`.`model` = 'ModuleArticle' AND `I18n__resumeTranslations`.`field` = 'resume' AND `I18n__resumeTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__contentTranslations` ON (`ModuleArticle`.`id` = `I18n__contentTranslations`.`foreign_key` AND `I18n__contentTranslations`.`model` = 'ModuleArticle' AND `I18n__contentTranslations`.`field` = 'content' AND `I18n__contentTranslations`.`locale` = 'fra') WHERE `ModuleArticle`.`content_id` = 216 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `ModuleArticle`.`id`, `ModuleArticle`.`content_id`, `ModuleArticle`.`name`, `ModuleArticle`.`resume`, `ModuleArticle`.`content`, (`I18n__nameTranslations`.`content`) AS `ModuleArticle__i18n_nameTranslations`, (`I18n__resumeTranslations`.`content`) AS `ModuleArticle__i18n_resumeTranslations`, (`I18n__contentTranslations`.`content`) AS `ModuleArticle__i18n_contentTranslations` FROM `parnay`.`module_articles` AS `ModuleArticle` INNER JOIN `parnay`.`i18n` AS `I18n__nameTranslations` ON (`ModuleArticle`.`id` = `I18n__nameTranslations`.`foreign_key` AND `I18n__nameTranslations`.`model` = 'ModuleArticle' AND `I18n__nameTranslations`.`field` = 'name' AND `I18n__nameTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__resumeTranslations` ON (`ModuleArticle`.`id` = `I18n__resumeTranslations`.`foreign_key` AND `I18n__resumeTranslations`.`model` = 'ModuleArticle' AND `I18n__resumeTranslations`.`field` = 'resume' AND `I18n__resumeTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__contentTranslations` ON (`ModuleArticle`.`id` = `I18n__contentTranslations`.`foreign_key` AND `I18n__contentTranslations`.`model` = 'ModuleArticle' AND `I18n__contentTranslations`.`field` = 'content' AND `I18n__contentTranslations`.`locale` = 'fra') WHERE `ModuleArticle`.`content_id` = 214 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `ModuleArticle`.`id`, `ModuleArticle`.`content_id`, `ModuleArticle`.`name`, `ModuleArticle`.`resume`, `ModuleArticle`.`content`, (`I18n__nameTranslations`.`content`) AS `ModuleArticle__i18n_nameTranslations`, (`I18n__resumeTranslations`.`content`) AS `ModuleArticle__i18n_resumeTranslations`, (`I18n__contentTranslations`.`content`) AS `ModuleArticle__i18n_contentTranslations` FROM `parnay`.`module_articles` AS `ModuleArticle` INNER JOIN `parnay`.`i18n` AS `I18n__nameTranslations` ON (`ModuleArticle`.`id` = `I18n__nameTranslations`.`foreign_key` AND `I18n__nameTranslations`.`model` = 'ModuleArticle' AND `I18n__nameTranslations`.`field` = 'name' AND `I18n__nameTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__resumeTranslations` ON (`ModuleArticle`.`id` = `I18n__resumeTranslations`.`foreign_key` AND `I18n__resumeTranslations`.`model` = 'ModuleArticle' AND `I18n__resumeTranslations`.`field` = 'resume' AND `I18n__resumeTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__contentTranslations` ON (`ModuleArticle`.`id` = `I18n__contentTranslations`.`foreign_key` AND `I18n__contentTranslations`.`model` = 'ModuleArticle' AND `I18n__contentTranslations`.`field` = 'content' AND `I18n__contentTranslations`.`locale` = 'fra') WHERE `ModuleArticle`.`content_id` = 213 LIMIT 1 | 1 | 1 | 4 | maybe slow |
| SELECT `ModuleArticle`.`id`, `ModuleArticle`.`content_id`, `ModuleArticle`.`name`, `ModuleArticle`.`resume`, `ModuleArticle`.`content`, (`I18n__nameTranslations`.`content`) AS `ModuleArticle__i18n_nameTranslations`, (`I18n__resumeTranslations`.`content`) AS `ModuleArticle__i18n_resumeTranslations`, (`I18n__contentTranslations`.`content`) AS `ModuleArticle__i18n_contentTranslations` FROM `parnay`.`module_articles` AS `ModuleArticle` INNER JOIN `parnay`.`i18n` AS `I18n__nameTranslations` ON (`ModuleArticle`.`id` = `I18n__nameTranslations`.`foreign_key` AND `I18n__nameTranslations`.`model` = 'ModuleArticle' AND `I18n__nameTranslations`.`field` = 'name' AND `I18n__nameTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__resumeTranslations` ON (`ModuleArticle`.`id` = `I18n__resumeTranslations`.`foreign_key` AND `I18n__resumeTranslations`.`model` = 'ModuleArticle' AND `I18n__resumeTranslations`.`field` = 'resume' AND `I18n__resumeTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__contentTranslations` ON (`ModuleArticle`.`id` = `I18n__contentTranslations`.`foreign_key` AND `I18n__contentTranslations`.`model` = 'ModuleArticle' AND `I18n__contentTranslations`.`field` = 'content' AND `I18n__contentTranslations`.`locale` = 'fra') WHERE `ModuleArticle`.`content_id` = 212 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `ModuleArticle`.`id`, `ModuleArticle`.`content_id`, `ModuleArticle`.`name`, `ModuleArticle`.`resume`, `ModuleArticle`.`content`, (`I18n__nameTranslations`.`content`) AS `ModuleArticle__i18n_nameTranslations`, (`I18n__resumeTranslations`.`content`) AS `ModuleArticle__i18n_resumeTranslations`, (`I18n__contentTranslations`.`content`) AS `ModuleArticle__i18n_contentTranslations` FROM `parnay`.`module_articles` AS `ModuleArticle` INNER JOIN `parnay`.`i18n` AS `I18n__nameTranslations` ON (`ModuleArticle`.`id` = `I18n__nameTranslations`.`foreign_key` AND `I18n__nameTranslations`.`model` = 'ModuleArticle' AND `I18n__nameTranslations`.`field` = 'name' AND `I18n__nameTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__resumeTranslations` ON (`ModuleArticle`.`id` = `I18n__resumeTranslations`.`foreign_key` AND `I18n__resumeTranslations`.`model` = 'ModuleArticle' AND `I18n__resumeTranslations`.`field` = 'resume' AND `I18n__resumeTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__contentTranslations` ON (`ModuleArticle`.`id` = `I18n__contentTranslations`.`foreign_key` AND `I18n__contentTranslations`.`model` = 'ModuleArticle' AND `I18n__contentTranslations`.`field` = 'content' AND `I18n__contentTranslations`.`locale` = 'fra') WHERE `ModuleArticle`.`content_id` = 211 LIMIT 1 | 1 | 1 | 4 | maybe slow |
| SELECT `ModuleArticle`.`id`, `ModuleArticle`.`content_id`, `ModuleArticle`.`name`, `ModuleArticle`.`resume`, `ModuleArticle`.`content`, (`I18n__nameTranslations`.`content`) AS `ModuleArticle__i18n_nameTranslations`, (`I18n__resumeTranslations`.`content`) AS `ModuleArticle__i18n_resumeTranslations`, (`I18n__contentTranslations`.`content`) AS `ModuleArticle__i18n_contentTranslations` FROM `parnay`.`module_articles` AS `ModuleArticle` INNER JOIN `parnay`.`i18n` AS `I18n__nameTranslations` ON (`ModuleArticle`.`id` = `I18n__nameTranslations`.`foreign_key` AND `I18n__nameTranslations`.`model` = 'ModuleArticle' AND `I18n__nameTranslations`.`field` = 'name' AND `I18n__nameTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__resumeTranslations` ON (`ModuleArticle`.`id` = `I18n__resumeTranslations`.`foreign_key` AND `I18n__resumeTranslations`.`model` = 'ModuleArticle' AND `I18n__resumeTranslations`.`field` = 'resume' AND `I18n__resumeTranslations`.`locale` = 'fra') INNER JOIN `parnay`.`i18n` AS `I18n__contentTranslations` ON (`ModuleArticle`.`id` = `I18n__contentTranslations`.`foreign_key` AND `I18n__contentTranslations`.`model` = 'ModuleArticle' AND `I18n__contentTranslations`.`field` = 'content' AND `I18n__contentTranslations`.`locale` = 'fra') WHERE `ModuleArticle`.`content_id` = 197 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `Evenement`.`id`, `Evenement`.`content`, `Evenement`.`date_debut`, `Evenement`.`date_fin`, `Evenement`.`created` FROM `parnay`.`evenements` AS `Evenement` WHERE ((((`Evenement`.`date_debut` >= '2024-04-23 23:59:59') AND (`Evenement`.`date_fin` IS NULL))) OR (((NOT (`Evenement`.`date_fin` IS NULL)) AND (`Evenement`.`date_fin` >= '2024-04-23 23:59:59')))) ORDER BY `Evenement`.`date_debut` DESC, `Evenement`.`date_fin` DESC | 0 | 0 | 0 | |
| SELECT `Evenement`.`id`, `Evenement`.`content`, `Evenement`.`date_debut`, `Evenement`.`date_fin`, `Evenement`.`created` FROM `parnay`.`evenements` AS `Evenement` WHERE 1 ORDER BY `Evenement`.`date_debut` asc, `Evenement`.`date_fin` asc | 0 | 0 | 0 | |
