Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Contenu`.`id`, `Contenu`.`categorie_id`, `Contenu`.`client_id`, `Contenu`.`type_id`, `Contenu`.`modele_id`, `Contenu`.`nom`, `Contenu`.`date`, `Contenu`.`texte`, `Contenu`.`miniature`, `Contenu`.`banniere`, `Contenu`.`banniere_xxl`, `Contenu`.`banniere_xl`, `Contenu`.`banniere_l`, `Contenu`.`banniere_m`, `Contenu`.`equipements`, `Contenu`.`description_techniques`, `Contenu`.`afficher_portfolio`, `Contenu`.`seo_slug`, `Contenu`.`seo_title`, `Contenu`.`seo_description`, `Contenu`.`created`, `Contenu`.`modified`, `Client`.`id`, `Client`.`nom`, `Client`.`texte`, `Client`.`logo`, `Client`.`banniere`, `Client`.`adresse`, `Client`.`telephone`, `Client`.`site_web`, `Client`.`latitude`, `Client`.`longitude`, `Client`.`seo_slug`, `Client`.`seo_title`, `Client`.`seo_description`, `Client`.`created`, `Client`.`modified`, `Type`.`id`, `Type`.`nom`, `Type`.`slug`, `Type`.`seo_description`, `Type`.`seo_title`, `Type`.`seo_slug` FROM `tele_charlevoix_com`.`contenus` AS `Contenu` LEFT JOIN `tele_charlevoix_com`.`clients` AS `Client` ON (`Contenu`.`client_id` = `Client`.`id`) LEFT JOIN `tele_charlevoix_com`.`types` AS `Type` ON (`Contenu`.`type_id` = `Type`.`id`) WHERE `Contenu`.`seo_slug` = '205-centre-ville-1-mars-2019-442' ORDER BY `Contenu`.`created` DESC, `Client`.`nom` ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Photo`.`id`, `Photo`.`rel`, `Photo`.`contenu_id`, `Photo`.`legende`, `Photo`.`path`, `Photo`.`dimension`, `Photo`.`ordre`, `Photo`.`created`, `Photo`.`modified` FROM `tele_charlevoix_com`.`photos` AS `Photo` WHERE `Photo`.`contenu_id` = (442) ORDER BY `Photo`.`ordre` ASC | 11 | 11 | 2 | maybe slow |
SELECT `Video`.`id`, `Video`.`rel`, `Video`.`contenu_id`, `Video`.`legende`, `Video`.`url`, `Video`.`ordre`, `Video`.`created`, `Video`.`modified` FROM `tele_charlevoix_com`.`videos` AS `Video` WHERE `Video`.`contenu_id` = (442) ORDER BY `Video`.`ordre` ASC | 4 | 4 | 0 | |
SELECT `Tag`.`id`, `Tag`.`nom`, `Tag`.`seo_slug`, `Tag`.`created`, `Tag`.`modified`, `ContenusTag`.`id`, `ContenusTag`.`contenu_id`, `ContenusTag`.`tag_id`, `ContenusTag`.`created`, `ContenusTag`.`modified` FROM `tele_charlevoix_com`.`tags` AS `Tag` JOIN `tele_charlevoix_com`.`contenus_tags` AS `ContenusTag` ON (`ContenusTag`.`contenu_id` = 442 AND `ContenusTag`.`tag_id` = `Tag`.`id`) | 0 | 0 | 0 | |
SELECT `Categorie`.`id`, `Categorie`.`titre`, `Categorie`.`texte`, `Categorie`.`miniature`, `Categorie`.`banniere`, `Categorie`.`seo_slug`, `Categorie`.`seo_title`, `Categorie`.`seo_description`, `Categorie`.`ordre`, `Categorie`.`accueil`, `Categorie`.`active`, `Categorie`.`created`, `Categorie`.`modified`, `CategoriesContenus`.`id`, `CategoriesContenus`.`categorie_id`, `CategoriesContenus`.`contenu_id` FROM `tele_charlevoix_com`.`categories` AS `Categorie` JOIN `tele_charlevoix_com`.`categories_contenus` AS `CategoriesContenus` ON (`CategoriesContenus`.`contenu_id` = 442 AND `CategoriesContenus`.`categorie_id` = `Categorie`.`id`) | 1 | 1 | 0 | |
SELECT `Contenu`.`id`, `Contenu`.`categorie_id`, `Contenu`.`client_id`, `Contenu`.`type_id`, `Contenu`.`modele_id`, `Contenu`.`nom`, `Contenu`.`date`, `Contenu`.`texte`, `Contenu`.`miniature`, `Contenu`.`banniere`, `Contenu`.`banniere_xxl`, `Contenu`.`banniere_xl`, `Contenu`.`banniere_l`, `Contenu`.`banniere_m`, `Contenu`.`equipements`, `Contenu`.`description_techniques`, `Contenu`.`afficher_portfolio`, `Contenu`.`seo_slug`, `Contenu`.`seo_title`, `Contenu`.`seo_description`, `Contenu`.`created`, `Contenu`.`modified`, `Client`.`id`, `Client`.`nom`, `Client`.`texte`, `Client`.`logo`, `Client`.`banniere`, `Client`.`adresse`, `Client`.`telephone`, `Client`.`site_web`, `Client`.`latitude`, `Client`.`longitude`, `Client`.`seo_slug`, `Client`.`seo_title`, `Client`.`seo_description`, `Client`.`created`, `Client`.`modified`, `Type`.`id`, `Type`.`nom`, `Type`.`slug`, `Type`.`seo_description`, `Type`.`seo_title`, `Type`.`seo_slug` FROM `tele_charlevoix_com`.`contenus` AS `Contenu` LEFT JOIN `tele_charlevoix_com`.`clients` AS `Client` ON (`Contenu`.`client_id` = `Client`.`id`) LEFT JOIN `tele_charlevoix_com`.`types` AS `Type` ON (`Contenu`.`type_id` = `Type`.`id`) WHERE `Contenu`.`categorie_id` IS NULL AND `Contenu`.`id` <> 442 AND `Contenu`.`date` <= '2025-04-19 09:28:20' ORDER BY `Contenu`.`created` DESC, `Client`.`nom` ASC LIMIT 30 | 30 | 30 | 5 | maybe slow |
SELECT `Contenu`.`id`, `Contenu`.`categorie_id`, `Contenu`.`client_id`, `Contenu`.`type_id`, `Contenu`.`modele_id`, `Contenu`.`nom`, `Contenu`.`date`, `Contenu`.`texte`, `Contenu`.`miniature`, `Contenu`.`banniere`, `Contenu`.`banniere_xxl`, `Contenu`.`banniere_xl`, `Contenu`.`banniere_l`, `Contenu`.`banniere_m`, `Contenu`.`equipements`, `Contenu`.`description_techniques`, `Contenu`.`afficher_portfolio`, `Contenu`.`seo_slug`, `Contenu`.`seo_title`, `Contenu`.`seo_description`, `Contenu`.`created`, `Contenu`.`modified`, `Client`.`id`, `Client`.`nom`, `Client`.`texte`, `Client`.`logo`, `Client`.`banniere`, `Client`.`adresse`, `Client`.`telephone`, `Client`.`site_web`, `Client`.`latitude`, `Client`.`longitude`, `Client`.`seo_slug`, `Client`.`seo_title`, `Client`.`seo_description`, `Client`.`created`, `Client`.`modified`, `Type`.`id`, `Type`.`nom`, `Type`.`slug`, `Type`.`seo_description`, `Type`.`seo_title`, `Type`.`seo_slug` FROM `tele_charlevoix_com`.`contenus` AS `Contenu` LEFT JOIN `tele_charlevoix_com`.`clients` AS `Client` ON (`Contenu`.`client_id` = `Client`.`id`) LEFT JOIN `tele_charlevoix_com`.`types` AS `Type` ON (`Contenu`.`type_id` = `Type`.`id`) WHERE `Contenu`.`client_id` = 24 AND `Contenu`.`id` <> 442 AND `Contenu`.`date` <= '2025-04-19 09:28:20' ORDER BY `Contenu`.`created` DESC, `Client`.`nom` ASC LIMIT 30 | 30 | 30 | 4 | maybe slow |
SELECT `Pub`.`id`, `Pub`.`nom`, `Pub`.`debut`, `Pub`.`fin`, `Pub`.`mp4`, `Pub`.`created`, `Pub`.`modified` FROM `tele_charlevoix_com`.`pubs` AS `Pub` WHERE `debut` <= '2025-04-19 09:28:20' AND `fin` > '2025-04-19 09:28:20' ORDER BY RAND() ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT `Pub`.`id`, `Pub`.`nom`, `Pub`.`debut`, `Pub`.`fin`, `Pub`.`mp4`, `Pub`.`created`, `Pub`.`modified` FROM `tele_charlevoix_com`.`pubs` AS `Pub` WHERE `debut` <= '2025-04-19 09:28:20' AND `fin` > '2025-04-19 09:28:20' ORDER BY RAND() ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT `Pub`.`id`, `Pub`.`nom`, `Pub`.`debut`, `Pub`.`fin`, `Pub`.`mp4`, `Pub`.`created`, `Pub`.`modified` FROM `tele_charlevoix_com`.`pubs` AS `Pub` WHERE `debut` <= '2025-04-19 09:28:20' AND `fin` > '2025-04-19 09:28:20' ORDER BY RAND() ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT `Pub`.`id`, `Pub`.`nom`, `Pub`.`debut`, `Pub`.`fin`, `Pub`.`mp4`, `Pub`.`created`, `Pub`.`modified` FROM `tele_charlevoix_com`.`pubs` AS `Pub` WHERE `debut` <= '2025-04-19 09:28:20' AND `fin` > '2025-04-19 09:28:20' ORDER BY RAND() ASC LIMIT 1 | 0 | 0 | 0 | |
SELECT `Categorie`.`id`, `Categorie`.`titre`, `Categorie`.`texte`, `Categorie`.`miniature`, `Categorie`.`banniere`, `Categorie`.`seo_slug`, `Categorie`.`seo_title`, `Categorie`.`seo_description`, `Categorie`.`ordre`, `Categorie`.`accueil`, `Categorie`.`active`, `Categorie`.`created`, `Categorie`.`modified` FROM `tele_charlevoix_com`.`categories` AS `Categorie` WHERE `accueil` IN ('0', '1') AND `active` = '1' ORDER BY `Categorie`.`ordre` ASC | 37 | 37 | 0 | |
SELECT `Categorie`.`id`, `Categorie`.`titre`, `Categorie`.`texte`, `Categorie`.`miniature`, `Categorie`.`banniere`, `Categorie`.`seo_slug`, `Categorie`.`seo_title`, `Categorie`.`seo_description`, `Categorie`.`ordre`, `Categorie`.`accueil`, `Categorie`.`active`, `Categorie`.`created`, `Categorie`.`modified` FROM `tele_charlevoix_com`.`categories` AS `Categorie` WHERE `accueil` IN ('0', '1') AND `active` = '1' ORDER BY `Categorie`.`ordre` ASC | 37 | 37 | 0 | |