Query | Affected | Num. rows | Took (ms) | Actions |
---|
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 `tvcvm_cake`.`categories` AS `Categorie` WHERE `Categorie`.`seo_slug` = 'podcast-charlevoix' ORDER BY `Categorie`.`ordre` ASC LIMIT 1 | 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`, `CategoriesContenus`.`id`, `CategoriesContenus`.`categorie_id`, `CategoriesContenus`.`contenu_id` FROM `tvcvm_cake`.`contenus` AS `Contenu` JOIN `tvcvm_cake`.`categories_contenus` AS `CategoriesContenus` ON (`CategoriesContenus`.`categorie_id` = 42 AND `CategoriesContenus`.`contenu_id` = `Contenu`.`id`) | 18 | 18 | 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 `tvcvm_cake`.`contenus` AS `Contenu` LEFT JOIN `tvcvm_cake`.`clients` AS `Client` ON (`Contenu`.`client_id` = `Client`.`id`) LEFT JOIN `tvcvm_cake`.`types` AS `Type` ON (`Contenu`.`type_id` = `Type`.`id`) WHERE `Contenu`.`id` IN (1315, 1317, 1323, 1327, 1334, 1336, 1344, 1352, 1364, 1369, 1374, 1377, 1382, 1389, 1395, 1400, 1413, 1424) AND `Contenu`.`date` <= '2025-05-19 03:22:22' ORDER BY `Contenu`.`created` DESC, `Client`.`nom` ASC LIMIT 30 | 18 | 18 | 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 `tvcvm_cake`.`categories` AS `Categorie` JOIN `tvcvm_cake`.`categories_contenus` AS `CategoriesContenus` ON (`CategoriesContenus`.`contenu_id` IN (1424, 1413, 1400, 1395, 1389, 1382, 1377, 1374, 1369, 1364, 1352, 1344, 1336, 1334, 1327, 1323, 1317, 1315) AND `CategoriesContenus`.`categorie_id` = `Categorie`.`id`) | 18 | 18 | 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 `tvcvm_cake`.`contenus` AS `Contenu` LEFT JOIN `tvcvm_cake`.`clients` AS `Client` ON (`Contenu`.`client_id` = `Client`.`id`) LEFT JOIN `tvcvm_cake`.`types` AS `Type` ON (`Contenu`.`type_id` = `Type`.`id`) WHERE `Contenu`.`id` IN (1315, 1317, 1323, 1327, 1334, 1336, 1344, 1352, 1364, 1369, 1374, 1377, 1382, 1389, 1395, 1400, 1413, 1424) AND `Contenu`.`date` <= '2025-05-19 03:22:22' ORDER BY `Contenu`.`nom` ASC, `Client`.`nom` ASC | 18 | 18 | 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 `tvcvm_cake`.`categories` AS `Categorie` JOIN `tvcvm_cake`.`categories_contenus` AS `CategoriesContenus` ON (`CategoriesContenus`.`contenu_id` IN (1315, 1344, 1424, 1369, 1374, 1377, 1382, 1389, 1395, 1400, 1413, 1352, 1364, 1317, 1327, 1323, 1334, 1336) AND `CategoriesContenus`.`categorie_id` = `Categorie`.`id`) | 18 | 18 | 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 `tvcvm_cake`.`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 `tvcvm_cake`.`categories` AS `Categorie` WHERE `accueil` IN ('0', '1') AND `active` = '1' ORDER BY `Categorie`.`ordre` ASC | 37 | 37 | 0 | |