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` = 'gastronomie' 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` = 1 AND `CategoriesContenus`.`contenu_id` = `Contenu`.`id`) | 26 | 26 | 1 | |
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 (31, 23, 22, 19, 14, 13, 12, 11, 10, 120, 124, 27, 136, 192, 221, 224, 225, 266, 321, 332, 362, 487, 495, 638, 639, 687) AND `Contenu`.`date` <= '2025-04-25 12:21:34' ORDER BY `Contenu`.`created` DESC, `Client`.`nom` ASC LIMIT 30 | 26 | 26 | 1 | |
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 (687, 639, 638, 495, 487, 362, 332, 321, 266, 225, 224, 221, 192, 136, 124, 120, 31, 27, 23, 22, 19, 14, 13, 12, 11, 10) AND `CategoriesContenus`.`categorie_id` = `Categorie`.`id`) | 54 | 54 | 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 (31, 23, 22, 19, 14, 13, 12, 11, 10, 120, 124, 27, 136, 192, 221, 224, 225, 266, 321, 332, 362, 487, 495, 638, 639, 687) AND `Contenu`.`date` <= '2025-04-25 12:21:34' ORDER BY `Contenu`.`nom` ASC, `Client`.`nom` ASC | 26 | 26 | 1 | |
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 (495, 638, 10, 12, 13, 19, 27, 224, 11, 22, 687, 321, 225, 639, 192, 362, 120, 124, 136, 332, 221, 487, 14, 266, 23, 31) AND `CategoriesContenus`.`categorie_id` = `Categorie`.`id`) | 54 | 54 | 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 | |