Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Nouvelle`.`id`, `Nouvelle`.`titre_fre`, `Nouvelle`.`content_id`, `Nouvelle`.`titre_eng`, `Nouvelle`.`texte_fre`, `Nouvelle`.`texte_eng`, `Nouvelle`.`auteur`, `Nouvelle`.`date`, `Nouvelle`.`photo`, `Nouvelle`.`slug_fre`, `Nouvelle`.`slug_eng`, `Nouvelle`.`modified`, `Content`.`id`, `Content`.`page_id`, `Content`.`page_link_id`, `Content`.`external_link`, `Content`.`template`, `Content`.`titre_fre`, `Content`.`titre_eng`, `Content`.`menu_fre`, `Content`.`menu_eng`, `Content`.`texte_fre`, `Content`.`texte_eng`, `Content`.`seo_slug_fre`, `Content`.`seo_slug_eng`, `Content`.`seo_title_fre`, `Content`.`seo_title_eng`, `Content`.`seo_description_fre`, `Content`.`seo_description_eng`, `Content`.`is_draft`, `Content`.`edited`, `Content`.`created`, `Content`.`modified` FROM `bernardl_cms`.`nouvelles` AS `Nouvelle` LEFT JOIN `bernardl_cms`.`contents` AS `Content` ON (`Nouvelle`.`content_id` = `Content`.`id`) WHERE 1 = 1 ORDER BY `Nouvelle`.`date` DESC | 3 | 3 | 0 | |
SELECT `Page`.`id`, `Page`.`titre_fre`, `Page`.`titre_eng`, `Page`.`slug_fre`, `Page`.`slug_eng`, `Page`.`texte_fre`, `Page`.`texte_eng`, `Page`.`menu_fre`, `Page`.`menu_eng`, `Page`.`template`, `Page`.`image`, `Page`.`page_id`, `Page`.`lien_page_id`, `Page`.`seo_title_fre`, `Page`.`seo_title_eng`, `Page`.`seo_description_fre`, `Page`.`seo_description_eng`, `Page`.`cache`, `Page`.`ordre`, `Page`.`deletable`, `Page`.`created`, `Page`.`modified`, `Parent`.`id`, `Parent`.`titre_fre`, `Parent`.`titre_eng`, `Parent`.`slug_fre`, `Parent`.`slug_eng`, `Parent`.`texte_fre`, `Parent`.`texte_eng`, `Parent`.`menu_fre`, `Parent`.`menu_eng`, `Parent`.`template`, `Parent`.`image`, `Parent`.`page_id`, `Parent`.`lien_page_id`, `Parent`.`seo_title_fre`, `Parent`.`seo_title_eng`, `Parent`.`seo_description_fre`, `Parent`.`seo_description_eng`, `Parent`.`cache`, `Parent`.`ordre`, `Parent`.`deletable`, `Parent`.`created`, `Parent`.`modified`, `Link`.`id`, `Link`.`titre_fre`, `Link`.`titre_eng`, `Link`.`slug_fre`, `Link`.`slug_eng`, `Link`.`texte_fre`, `Link`.`texte_eng`, `Link`.`menu_fre`, `Link`.`menu_eng`, `Link`.`template`, `Link`.`image`, `Link`.`page_id`, `Link`.`lien_page_id`, `Link`.`seo_title_fre`, `Link`.`seo_title_eng`, `Link`.`seo_description_fre`, `Link`.`seo_description_eng`, `Link`.`cache`, `Link`.`ordre`, `Link`.`deletable`, `Link`.`created`, `Link`.`modified` FROM `bernardl_cms`.`pages` AS `Page` LEFT JOIN `bernardl_cms`.`pages` AS `Parent` ON (`Page`.`page_id` = `Parent`.`id`) LEFT JOIN `bernardl_cms`.`pages` AS `Link` ON (`Page`.`lien_page_id` = `Link`.`id`) WHERE `Page`.`cache` = '0' AND `Page`.`page_id` = '' ORDER BY `Page`.`ordre` ASC | 8 | 8 | 1 | maybe slow |
SELECT `Child`.`id`, `Child`.`titre_fre`, `Child`.`titre_eng`, `Child`.`slug_fre`, `Child`.`slug_eng`, `Child`.`texte_fre`, `Child`.`texte_eng`, `Child`.`menu_fre`, `Child`.`menu_eng`, `Child`.`template`, `Child`.`image`, `Child`.`page_id`, `Child`.`lien_page_id`, `Child`.`seo_title_fre`, `Child`.`seo_title_eng`, `Child`.`seo_description_fre`, `Child`.`seo_description_eng`, `Child`.`cache`, `Child`.`ordre`, `Child`.`deletable`, `Child`.`created`, `Child`.`modified` FROM `bernardl_cms`.`pages` AS `Child` WHERE `Child`.`page_id` IN (2, 18, 19, 16, 12, 14, 13, 17) ORDER BY `Child`.`ordre` ASC | 0 | 0 | 0 | |
SELECT `SubChild`.`id`, `SubChild`.`titre_fre`, `SubChild`.`titre_eng`, `SubChild`.`slug_fre`, `SubChild`.`slug_eng`, `SubChild`.`texte_fre`, `SubChild`.`texte_eng`, `SubChild`.`menu_fre`, `SubChild`.`menu_eng`, `SubChild`.`template`, `SubChild`.`image`, `SubChild`.`page_id`, `SubChild`.`lien_page_id`, `SubChild`.`seo_title_fre`, `SubChild`.`seo_title_eng`, `SubChild`.`seo_description_fre`, `SubChild`.`seo_description_eng`, `SubChild`.`cache`, `SubChild`.`ordre`, `SubChild`.`deletable`, `SubChild`.`created`, `SubChild`.`modified` FROM `bernardl_cms`.`pages` AS `SubChild` WHERE `SubChild`.`page_id` IN (2, 18, 19, 16, 12, 14, 13, 17) ORDER BY `SubChild`.`ordre` ASC | 0 | 0 | 0 | |
SELECT `Plugin`.`id`, `Plugin`.`model`, `PagesPlugin`.`id`, `PagesPlugin`.`page_id`, `PagesPlugin`.`plugin_id`, `PagesPlugin`.`created`, `PagesPlugin`.`modified` FROM `bernardl_cms`.`plugins` AS `Plugin` JOIN `bernardl_cms`.`pages_plugins` AS `PagesPlugin` ON (`PagesPlugin`.`page_id` IN (2, 18, 19, 16, 12, 14, 13, 17) AND `PagesPlugin`.`plugin_id` = `Plugin`.`id`) | 0 | 0 | 0 | |
SELECT `Nouvelle`.`id`, `Nouvelle`.`titre_fre`, `Nouvelle`.`content_id`, `Nouvelle`.`titre_eng`, `Nouvelle`.`texte_fre`, `Nouvelle`.`texte_eng`, `Nouvelle`.`auteur`, `Nouvelle`.`date`, `Nouvelle`.`photo`, `Nouvelle`.`slug_fre`, `Nouvelle`.`slug_eng`, `Nouvelle`.`modified`, `Content`.`id`, `Content`.`page_id`, `Content`.`page_link_id`, `Content`.`external_link`, `Content`.`template`, `Content`.`titre_fre`, `Content`.`titre_eng`, `Content`.`menu_fre`, `Content`.`menu_eng`, `Content`.`texte_fre`, `Content`.`texte_eng`, `Content`.`seo_slug_fre`, `Content`.`seo_slug_eng`, `Content`.`seo_title_fre`, `Content`.`seo_title_eng`, `Content`.`seo_description_fre`, `Content`.`seo_description_eng`, `Content`.`is_draft`, `Content`.`edited`, `Content`.`created`, `Content`.`modified` FROM `bernardl_cms`.`nouvelles` AS `Nouvelle` LEFT JOIN `bernardl_cms`.`contents` AS `Content` ON (`Nouvelle`.`content_id` = `Content`.`id`) WHERE `Nouvelle`.`date` <= '2019-12-12 11:56:41' ORDER BY `date` DESC | 3 | 3 | 0 | |
SELECT `Nouvelle`.`id`, `Nouvelle`.`titre_fre`, `Nouvelle`.`content_id`, `Nouvelle`.`titre_eng`, `Nouvelle`.`texte_fre`, `Nouvelle`.`texte_eng`, `Nouvelle`.`auteur`, `Nouvelle`.`date`, `Nouvelle`.`photo`, `Nouvelle`.`slug_fre`, `Nouvelle`.`slug_eng`, `Nouvelle`.`modified`, `Content`.`id`, `Content`.`page_id`, `Content`.`page_link_id`, `Content`.`external_link`, `Content`.`template`, `Content`.`titre_fre`, `Content`.`titre_eng`, `Content`.`menu_fre`, `Content`.`menu_eng`, `Content`.`texte_fre`, `Content`.`texte_eng`, `Content`.`seo_slug_fre`, `Content`.`seo_slug_eng`, `Content`.`seo_title_fre`, `Content`.`seo_title_eng`, `Content`.`seo_description_fre`, `Content`.`seo_description_eng`, `Content`.`is_draft`, `Content`.`edited`, `Content`.`created`, `Content`.`modified` FROM `bernardl_cms`.`nouvelles` AS `Nouvelle` LEFT JOIN `bernardl_cms`.`contents` AS `Content` ON (`Nouvelle`.`content_id` = `Content`.`id`) WHERE `Nouvelle`.`date` <= '2019-12-12 11:56:41' ORDER BY `date` DESC LIMIT 3 | 3 | 3 | 0 | |