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-comparative-table-in-the-gorges-du-verdon' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Fiche`.`name`, `Fiche`.`infotecs`, `Fiche`.`tarif`, `Fiche`.`displayMarker`, `Fiche`.`lat`, `Fiche`.`lng`, `Fiche`.`marker`, `Fiche`.`lieux`, `Fiche`.`id` FROM `canyoninogv2eng`.`fiches` AS `Fiche` LEFT JOIN `canyoninogv2eng`.`users` AS `User` ON (`Fiche`.`user_id` = `User`.`id`) WHERE `Fiche`.`active` = '1' AND `Fiche`.`type` = 'canyoning' ORDER BY `Fiche`.`tarif` asc | 13 | 13 | 4 | 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` FROM `canyoninogv2eng`.`contents` AS `Content` WHERE `Content`.`fiche_id` IN (16, 17, 47, 18, 19, 48, 26, 25, 22, 23, 24, 20, 21) | 14 | 14 | 2 | maybe slow |
SELECT `Reservation`.`id`, `Reservation`.`name`, `Reservation`.`adresse1`, `Reservation`.`adresse2`, `Reservation`.`cp`, `Reservation`.`ville`, `Reservation`.`tel1`, `Reservation`.`tel2`, `Reservation`.`email`, `Reservation`.`nameCb`, `Reservation`.`emailCb`, `Reservation`.`fiche_id`, `Reservation`.`dateActi`, `Reservation`.`nbPers`, `Reservation`.`infoPers`, `Reservation`.`montantAccompte`, `Reservation`.`orderId`, `Reservation`.`transId`, `Reservation`.`statut`, `Reservation`.`active`, `Reservation`.`created`, `Reservation`.`modified` FROM `canyoninogv2eng`.`reservations` AS `Reservation` WHERE `Reservation`.`fiche_id` IN (16, 17, 47, 18, 19, 48, 26, 25, 22, 23, 24, 20, 21) | 0 | 0 | 1 | maybe slow |
SELECT `Infotec`.`id`, `Infotec`.`name` FROM `canyoninogv2eng`.`infotecs` AS `Infotec` WHERE `Infotec`.`active` = '1' AND `Infotec`.`useForCanyon` = '1' ORDER BY `lft` asc | 3 | 3 | 1 | maybe slow |
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 | 41 | 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 | 1 | 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 | 4 | maybe slow |