Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Page`.`id`, `Page`.`titre`, `Page`.`slug`, `Page`.`contenu`, `Page`.`tags`, `Page`.`url`, `Page`.`une`, `Page`.`created`, `Page`.`updated`, (`I18n__titreTraduction`.`content`) AS `Page__i18n_titreTraduction`, (`I18n__contenuTraduction`.`content`) AS `Page__i18n_contenuTraduction` FROM `orangeveowtrail`.`pages` AS `Page` INNER JOIN `orangeveowtrail`.`i18n` AS `I18n__titreTraduction` ON (`Page`.`id` = `I18n__titreTraduction`.`foreign_key` AND `I18n__titreTraduction`.`model` = 'Page' AND `I18n__titreTraduction`.`field` = 'titre' AND `I18n__titreTraduction`.`locale` = 'fra') INNER JOIN `orangeveowtrail`.`i18n` AS `I18n__contenuTraduction` ON (`Page`.`id` = `I18n__contenuTraduction`.`foreign_key` AND `I18n__contenuTraduction`.`model` = 'Page' AND `I18n__contenuTraduction`.`field` = 'contenu' AND `I18n__contenuTraduction`.`locale` = 'fra') WHERE ((`Page`.`slug` LIKE '%partenaires%') OR (LOWER(`Page`.`slug`) LIKE '%partenaires%') OR (`Page`.`id` = 'partenaires')) LIMIT 1 | 1 | 1 | 4 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`titre`, `Gallery`.`texte`, `Gallery`.`type`, `Gallery`.`page_id`, `Gallery`.`statut`, `Gallery`.`ordre`, `Gallery`.`created`, `Gallery`.`updated` FROM `orangeveowtrail`.`galleries` AS `Gallery` WHERE `Gallery`.`page_id` = (74) | 0 | 0 | 1 | maybe slow |
SELECT `titreTraduction`.`id`, `titreTraduction`.`locale`, `titreTraduction`.`model`, `titreTraduction`.`foreign_key`, `titreTraduction`.`field`, `titreTraduction`.`content` FROM `orangeveowtrail`.`i18n` AS `titreTraduction` WHERE `model` = 'Page' AND `field` = 'titre' AND `titreTraduction`.`foreign_key` = (74) ORDER BY `id` ASC | 4 | 4 | 1 | maybe slow |
SELECT `contenuTraduction`.`id`, `contenuTraduction`.`locale`, `contenuTraduction`.`model`, `contenuTraduction`.`foreign_key`, `contenuTraduction`.`field`, `contenuTraduction`.`content` FROM `orangeveowtrail`.`i18n` AS `contenuTraduction` WHERE `model` = 'Page' AND `field` = 'contenu' AND `contenuTraduction`.`foreign_key` = (74) ORDER BY `id` ASC | 4 | 4 | 2 | maybe slow |
SELECT `Config`.`nom`, `Config`.`valeur` FROM `orangeveowtrail`.`configs` AS `Config` WHERE 1 = 1 | 117 | 117 | 1 | |
SELECT `Config`.`nom`, `Config`.`valeur` FROM `orangeveowtrail`.`configs` AS `Config` WHERE 1 = 1 | 117 | 117 | 1 | |
SELECT `Item`.`id`, `Item`.`nom`, `Item`.`parent_id`, `Item`.`page_id`, `Item`.`url`, `Item`.`ordre`, `Item`.`icone`, `Item`.`created`, `Item`.`updated`, (`I18n__nomTraduction`.`content`) AS `Item__i18n_nomTraduction`, `Parent`.`id`, `Parent`.`nom`, `Parent`.`parent_id`, `Parent`.`page_id`, `Parent`.`url`, `Parent`.`ordre`, `Parent`.`icone`, `Parent`.`created`, `Parent`.`updated`, `Page`.`id`, `Page`.`titre`, `Page`.`slug`, `Page`.`contenu`, `Page`.`tags`, `Page`.`url`, `Page`.`une`, `Page`.`created`, `Page`.`updated` FROM `orangeveowtrail`.`items` AS `Item` LEFT JOIN `orangeveowtrail`.`items` AS `Parent` ON (`Item`.`parent_id` = `Parent`.`id`) LEFT JOIN `orangeveowtrail`.`pages` AS `Page` ON (`Item`.`page_id` = `Page`.`id`) INNER JOIN `orangeveowtrail`.`i18n` AS `I18n__nomTraduction` ON (`Item`.`id` = `I18n__nomTraduction`.`foreign_key` AND `I18n__nomTraduction`.`model` = 'Item' AND `I18n__nomTraduction`.`field` = 'nom' AND `I18n__nomTraduction`.`locale` = 'fra') WHERE `Item`.`id` != 1 ORDER BY `Item`.`ordre` ASC | 23 | 23 | 1 | |
SELECT `Fils`.`id`, `Fils`.`nom`, `Fils`.`parent_id`, `Fils`.`page_id`, `Fils`.`url`, `Fils`.`ordre`, `Fils`.`icone`, `Fils`.`created`, `Fils`.`updated` FROM `orangeveowtrail`.`items` AS `Fils` WHERE `Fils`.`parent_id` IN (111, 147, 114, 107, 158, 148, 104, 109, 160, 162, 149, 110, 108, 163, 120, 112, 115, 150, 167, 161, 134, 171, 146) | 15 | 15 | 1 | maybe slow |
SELECT `nomTraduction`.`id`, `nomTraduction`.`locale`, `nomTraduction`.`model`, `nomTraduction`.`foreign_key`, `nomTraduction`.`field`, `nomTraduction`.`content` FROM `orangeveowtrail`.`i18n` AS `nomTraduction` WHERE `model` = 'Item' AND `field` = 'nom' AND `nomTraduction`.`foreign_key` IN (111, 147, 114, 107, 158, 148, 104, 109, 160, 162, 149, 110, 108, 163, 120, 112, 115, 150, 167, 161, 134, 171, 146) ORDER BY `id` ASC | 69 | 69 | 1 | |
SELECT `Socialnetwork`.`id`, `Socialnetwork`.`reseau`, `Socialnetwork`.`balise`, `Socialnetwork`.`couleur`, `Socialnetwork`.`lien`, `Socialnetwork`.`ordre` FROM `orangeveowtrail`.`socialnetworks` AS `Socialnetwork` WHERE 1 = 1 ORDER BY `Socialnetwork`.`ordre` ASC | 3 | 3 | 1 | maybe slow |
SELECT `Item`.`id`, `Item`.`nom`, `Item`.`parent_id`, `Item`.`page_id`, `Item`.`url`, `Item`.`ordre`, `Item`.`icone`, `Item`.`created`, `Item`.`updated`, (`I18n__nomTraduction`.`content`) AS `Item__i18n_nomTraduction`, `Parent`.`id`, `Parent`.`nom`, `Parent`.`parent_id`, `Parent`.`page_id`, `Parent`.`url`, `Parent`.`ordre`, `Parent`.`icone`, `Parent`.`created`, `Parent`.`updated`, `Page`.`id`, `Page`.`titre`, `Page`.`slug`, `Page`.`contenu`, `Page`.`tags`, `Page`.`url`, `Page`.`une`, `Page`.`created`, `Page`.`updated` FROM `orangeveowtrail`.`items` AS `Item` LEFT JOIN `orangeveowtrail`.`items` AS `Parent` ON (`Item`.`parent_id` = `Parent`.`id`) LEFT JOIN `orangeveowtrail`.`pages` AS `Page` ON (`Item`.`page_id` = `Page`.`id`) INNER JOIN `orangeveowtrail`.`i18n` AS `I18n__nomTraduction` ON (`Item`.`id` = `I18n__nomTraduction`.`foreign_key` AND `I18n__nomTraduction`.`model` = 'Item' AND `I18n__nomTraduction`.`field` = 'nom' AND `I18n__nomTraduction`.`locale` = 'fra') WHERE `Item`.`id` != 1 ORDER BY `Item`.`ordre` ASC | 23 | 23 | 1 | |
SELECT `Fils`.`id`, `Fils`.`nom`, `Fils`.`parent_id`, `Fils`.`page_id`, `Fils`.`url`, `Fils`.`ordre`, `Fils`.`icone`, `Fils`.`created`, `Fils`.`updated` FROM `orangeveowtrail`.`items` AS `Fils` WHERE `Fils`.`parent_id` IN (111, 147, 114, 107, 158, 148, 104, 109, 160, 162, 149, 110, 108, 163, 120, 112, 115, 150, 167, 161, 134, 171, 146) | 15 | 15 | 1 | maybe slow |
SELECT `nomTraduction`.`id`, `nomTraduction`.`locale`, `nomTraduction`.`model`, `nomTraduction`.`foreign_key`, `nomTraduction`.`field`, `nomTraduction`.`content` FROM `orangeveowtrail`.`i18n` AS `nomTraduction` WHERE `model` = 'Item' AND `field` = 'nom' AND `nomTraduction`.`foreign_key` IN (111, 147, 114, 107, 158, 148, 104, 109, 160, 162, 149, 110, 108, 163, 120, 112, 115, 150, 167, 161, 134, 171, 146) ORDER BY `id` ASC | 69 | 69 | 1 | |
SELECT `Partenaire`.`id`, `Partenaire`.`image`, `Partenaire`.`lien`, `Partenaire`.`statut`, `Partenaire`.`ordre` FROM `orangeveowtrail`.`partenaires` AS `Partenaire` WHERE `Partenaire`.`statut` = '1' ORDER BY `Partenaire`.`ordre` ASC | 4 | 4 | 1 | maybe slow |
SELECT `Lien`.`id`, `Lien`.`titre`, `Lien`.`lien`, `Lien`.`statut`, `Lien`.`ordre`, `Lien`.`place` FROM `orangeveowtrail`.`liens` AS `Lien` WHERE `Lien`.`statut` = '1' AND `Lien`.`place` = 'footer' ORDER BY `Lien`.`ordre` ASC | 0 | 0 | 1 | maybe slow |