Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Content`.`id`, `Content`.`page_id`, `Content`.`page_link_id`, `Content`.`external_link`, `Content`.`template`, `Content`.`titre_fre`, `Content`.`titre_eng`, `Content`.`menu_fre`, `Content`.`menu_eng`, `Content`.`texte_fre`, `Content`.`texte_eng`, `Content`.`iframe_url`, `Content`.`seo_slug_fre`, `Content`.`seo_slug_eng`, `Content`.`seo_title_fre`, `Content`.`seo_title_eng`, `Content`.`seo_description_fre`, `Content`.`seo_description_eng`, `Content`.`is_draft`, `Content`.`edited`, `Content`.`created`, `Content`.`modified`, `Link`.`id`, `Link`.`parent_id`, `Link`.`type_id`, `Link`.`cache`, `Link`.`ordre`, `Link`.`deletable`, `Link`.`publie`, `Link`.`created`, `Link`.`modified`, `Page`.`id`, `Page`.`parent_id`, `Page`.`type_id`, `Page`.`cache`, `Page`.`ordre`, `Page`.`deletable`, `Page`.`publie`, `Page`.`created`, `Page`.`modified` FROM `tvcvm_cake`.`contents` AS `Content` LEFT JOIN `tvcvm_cake`.`pages` AS `Link` ON (`Content`.`page_link_id` = `Link`.`id`) LEFT JOIN `tvcvm_cake`.`pages` AS `Page` ON (`Content`.`page_id` = `Page`.`id`) WHERE `Content`.`is_draft` = '0' AND `Page`.`type_id` = 0 AND `Page`.`publie` = '1' AND `Content`.`seo_slug_fre` = 'clients' ORDER BY `Content`.`is_draft` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Plugin`.`id`, `Plugin`.`model`, `PagesPlugin`.`id`, `PagesPlugin`.`page_id`, `PagesPlugin`.`plugin_id`, `PagesPlugin`.`created`, `PagesPlugin`.`modified` FROM `tvcvm_cake`.`plugins` AS `Plugin` JOIN `tvcvm_cake`.`pages_plugins` AS `PagesPlugin` ON (`PagesPlugin`.`page_id` = 26 AND `PagesPlugin`.`plugin_id` = `Plugin`.`id`) | 0 | 0 | 0 | |
SELECT `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` FROM `tvcvm_cake`.`clients` AS `Client` WHERE 1 = 1 ORDER BY `nom` ASC | 77 | 77 | 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` FROM `tvcvm_cake`.`contenus` AS `Contenu` WHERE `Contenu`.`client_id` IN (75, 4, 3, 5, 52, 13, 37, 41, 45, 71, 60, 43, 86, 9, 78, 77, 32, 59, 34, 10, 25, 66, 67, 54, 36, 73, 85, 64, 63, 47, 27, 53, 38, 21, 51, 23, 58, 16, 74, 50, 31, 39, 40, 84, 82, 46, 76, 72, 81, 19, 65, 49, 33, 79, 18, 17, 69, 48, 55, 12, 28, 57, 14, 29, 56, 62, 26, 30, 44, 15, 61, 24, 83, 70, 11, 42, 68) | 1297 | 1297 | 5 | |
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 | |