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` = 'espagnol-pour-voyager-2018-2019' 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` = 24 AND `CategoriesContenus`.`contenu_id` = `Contenu`.`id`) | 16 | 16 | 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 (645, 647, 650, 654, 659, 665, 669, 673, 683, 693, 695, 697, 700, 703, 704, 705) AND `Contenu`.`date` <= '2025-04-25 10:36:06' ORDER BY `Contenu`.`created` DESC, `Client`.`nom` ASC LIMIT 30 | 16 | 16 | 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 (705, 704, 703, 700, 697, 695, 693, 683, 673, 669, 665, 659, 654, 650, 647, 645) AND `CategoriesContenus`.`categorie_id` = `Categorie`.`id`) | 16 | 16 | 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 (645, 647, 650, 654, 659, 665, 669, 673, 683, 693, 695, 697, 700, 703, 704, 705) AND `Contenu`.`date` <= '2025-04-25 10:36:06' ORDER BY `Contenu`.`nom` ASC, `Client`.`nom` ASC | 16 | 16 | 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 (645, 695, 697, 700, 703, 704, 705, 647, 650, 659, 665, 669, 673, 683, 693, 654) AND `CategoriesContenus`.`categorie_id` = `Categorie`.`id`) | 16 | 16 | 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 | |