Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Settings`.`id`, `Settings`.`title`, `Settings`.`description`, `Settings`.`actions`, `Settings`.`ckeditorConfigAdmin`, `Settings`.`ckeditorConfigSuperAdmin`, `Settings`.`ckeditorCss`, `Settings`.`ckeditorStyle`, `Settings`.`email_contact`, `Settings`.`email_paiement`, `Settings`.`taux_accompte`, `Settings`.`created`, `Settings`.`modified` FROM `canyoninogv2eng`.`settings` AS `Settings` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Content`.`id`, `Content`.`name`, `Content`.`slug`, `Content`.`classCss`, `Content`.`idCss`, `Content`.`title`, `Content`.`description`, `Content`.`displayH1`, `Content`.`content`, `Content`.`active`, `Content`.`home`, `Content`.`illustration0`, `Content`.`illustration1`, `Content`.`illustration2`, `Content`.`illustration3`, `Content`.`texte0`, `Content`.`texte1`, `Content`.`texte2`, `Content`.`texte3`, `Content`.`imageAlt0`, `Content`.`imageAlt1`, `Content`.`imageAlt2`, `Content`.`imageAlt3`, `Content`.`displayNews`, `Content`.`displayStages`, `Content`.`displayContact`, `Content`.`displayFiche`, `Content`.`displayLink`, `Content`.`displayMap`, `Content`.`fiche_id`, `Content`.`link_id`, `Content`.`map_id`, `Content`.`user_id`, `Content`.`lastUserId`, `Content`.`created`, `Content`.`modified` FROM `canyoninogv2eng`.`contents` AS `Content` WHERE `slug` = 'canyoning-in-the-canyon-of-ferne-alpes-de-haute-provence' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Fiche`.`id`, `Fiche`.`name`, `Fiche`.`type`, `Fiche`.`sousType`, `Fiche`.`lieux`, `Fiche`.`ilustration0`, `Fiche`.`ilustration1`, `Fiche`.`ilustration2`, `Fiche`.`ilustration3`, `Fiche`.`dossier`, `Fiche`.`content`, `Fiche`.`content1`, `Fiche`.`tarif`, `Fiche`.`useForPaiement`, `Fiche`.`infotecs`, `Fiche`.`displayMap`, `Fiche`.`latCenter`, `Fiche`.`lngCenter`, `Fiche`.`zoom`, `Fiche`.`displayMarker`, `Fiche`.`marker`, `Fiche`.`lat`, `Fiche`.`lng`, `Fiche`.`displayVideo`, `Fiche`.`video`, `Fiche`.`user_id`, `Fiche`.`active`, `Fiche`.`lastUserId`, `Fiche`.`parent_id`, `Fiche`.`lft`, `Fiche`.`rght`, `Fiche`.`created`, `Fiche`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`active`, `User`.`role`, `User`.`created`, `User`.`modified` FROM `canyoninogv2eng`.`fiches` AS `Fiche` LEFT JOIN `canyoninogv2eng`.`users` AS `User` ON (`Fiche`.`user_id` = `User`.`id`) WHERE `Fiche`.`id` = 23 AND `Fiche`.`active` = '1' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Infotec`.`id`, `Infotec`.`name` FROM `canyoninogv2eng`.`infotecs` AS `Infotec` WHERE `Infotec`.`active` = '1' ORDER BY `lft` asc | 26 | 26 | 1 | |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`name`, `Menu`.`position`, `Menu`.`classCss`, `Menu`.`idCss`, `Menu`.`active`, `Menu`.`cible`, `Menu`.`blank`, `Menu`.`noFollow`, `Menu`.`lienExterne`, `Menu`.`lienInterne`, `Content`.`id`, `Content`.`title`, `Content`.`slug` FROM `canyoninogv2eng`.`menus` AS `Menu` LEFT JOIN `canyoninogv2eng`.`contents` AS `Content` ON (`Menu`.`content_id` = `Content`.`id`) LEFT JOIN `canyoninogv2eng`.`users` AS `User` ON (`Menu`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `lft` ASC | 59 | 59 | 4 | maybe slow |
SELECT `Module`.`id`, `Module`.`position`, `Module`.`active`, `Module`.`classCss`, `Module`.`idCss`, `Module`.`content` FROM `canyoninogv2eng`.`modules` AS `Module` WHERE `Module`.`position` = 'description_acti' AND `Module`.`active` = '1' LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `Module`.`id`, `Module`.`position`, `Module`.`active`, `Module`.`classCss`, `Module`.`idCss`, `Module`.`content` FROM `canyoninogv2eng`.`modules` AS `Module` WHERE `Module`.`position` = 'aside' AND `Module`.`active` = '1' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Module`.`id`, `Module`.`name`, `Module`.`classCss`, `Module`.`idCss`, `Module`.`position`, `Module`.`content`, `Module`.`active`, `Module`.`lft`, `Module`.`rght`, `Module`.`parent_id`, `Module`.`user_id`, `Module`.`lastUserId`, `Module`.`created`, `Module`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`active`, `User`.`role`, `User`.`created`, `User`.`modified` FROM `canyoninogv2eng`.`modules` AS `Module` LEFT JOIN `canyoninogv2eng`.`users` AS `User` ON (`Module`.`user_id` = `User`.`id`) WHERE `Module`.`parent_id` = 50 AND `Module`.`active` = '1' ORDER BY `lft` ASC | 7 | 7 | 2 | maybe slow |
SELECT `Content`.`id`, `Content`.`name`, `Content`.`slug`, `Content`.`classCss`, `Content`.`idCss`, `Content`.`title`, `Content`.`description`, `Content`.`displayH1`, `Content`.`content`, `Content`.`active`, `Content`.`home`, `Content`.`illustration0`, `Content`.`illustration1`, `Content`.`illustration2`, `Content`.`illustration3`, `Content`.`texte0`, `Content`.`texte1`, `Content`.`texte2`, `Content`.`texte3`, `Content`.`imageAlt0`, `Content`.`imageAlt1`, `Content`.`imageAlt2`, `Content`.`imageAlt3`, `Content`.`displayNews`, `Content`.`displayStages`, `Content`.`displayContact`, `Content`.`displayFiche`, `Content`.`displayLink`, `Content`.`displayMap`, `Content`.`fiche_id`, `Content`.`link_id`, `Content`.`map_id`, `Content`.`user_id`, `Content`.`lastUserId`, `Content`.`created`, `Content`.`modified`, `ContentsModule`.`id`, `ContentsModule`.`module_id`, `ContentsModule`.`content_id` FROM `canyoninogv2eng`.`contents` AS `Content` JOIN `canyoninogv2eng`.`contents_modules` AS `ContentsModule` ON (`ContentsModule`.`module_id` IN (45, 42, 43, 69, 67, 71, 54) AND `ContentsModule`.`content_id` = `Content`.`id`) | 58 | 58 | 3 | maybe slow |