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` = '205-magazine' 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` = 41 AND `CategoriesContenus`.`contenu_id` = `Contenu`.`id`) | 19 | 19 | 1 | 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 `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 (1314, 1316, 1318, 1322, 1329, 1335, 1346, 1349, 1371, 1375, 1378, 1387, 1393, 1397, 1404, 1416, 1421, 1427, 1430) AND `Contenu`.`date` <= '2025-04-25 11:49:47' ORDER BY `Contenu`.`created` DESC, `Client`.`nom` ASC LIMIT 30 | 19 | 19 | 1 | maybe slow |
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 (1430, 1427, 1421, 1416, 1404, 1397, 1393, 1387, 1378, 1375, 1371, 1349, 1346, 1335, 1329, 1322, 1318, 1316, 1314) AND `CategoriesContenus`.`categorie_id` = `Categorie`.`id`) | 19 | 19 | 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 (1314, 1316, 1318, 1322, 1329, 1335, 1346, 1349, 1371, 1375, 1378, 1387, 1393, 1397, 1404, 1416, 1421, 1427, 1430) AND `Contenu`.`date` <= '2025-04-25 11:49:47' ORDER BY `Contenu`.`nom` ASC, `Client`.`nom` ASC | 19 | 19 | 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 (1318, 1393, 1416, 1329, 1371, 1314, 1397, 1421, 1335, 1375, 1316, 1404, 1427, 1378, 1430, 1346, 1387, 1322, 1349) AND `CategoriesContenus`.`categorie_id` = `Categorie`.`id`) | 19 | 19 | 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 | |