Symfony Profiler

SELECT
  s0_.IDSejour AS IDSejour_0,
  s0_.NomSejour AS NomSejour_1,
  s0_.DescriptionCourte AS DescriptionCourte_2,
  s0_.Ville AS Ville_3,
  s0_.CP AS CP_4,
  s0_.DescriptionLongue AS DescriptionLongue_5,
  s0_.DescriptionRegion AS DescriptionRegion_6,
  s0_.ConseilsVisites AS ConseilsVisites_7,
  s0_.DureeSejour AS DureeSejour_8,
  s0_.NbreJour AS NbreJour_9,
  s0_.NbreNuit AS NbreNuit_10,
  s0_.motCle AS motCle_11,
  s0_.EstCoupDeCoeur AS EstCoupDeCoeur_12,
  s0_.RangCoupDeCoeur AS RangCoupDeCoeur_13,
  s0_.EstNouveaute AS EstNouveaute_14,
  s0_.ImageMiseEnAvant AS ImageMiseEnAvant_15,
  s0_.TarifSejour AS TarifSejour_16,
  s0_.NoteGenerale AS NoteGenerale_17,
  s0_.Metatitle AS Metatitle_18,
  s0_.Metadescription AS Metadescription_19,
  s0_.Metakeywords AS Metakeywords_20,
  s0_.lienaafficher AS lienaafficher_21,
  s0_.EstVisible AS EstVisible_22,
  s0_.DateCreation AS DateCreation_23,
  s0_.DateModification AS DateModification_24,
  s0_.IDRegion AS IDRegion_25,
  s0_.IDTheme AS IDTheme_26,
  s0_.IDCategorieOffre AS IDCategorieOffre_27,
  s0_.IDHebergement AS IDHebergement_28,
  s0_.IDTypeFormule AS IDTypeFormule_29,
  s0_.IDTypePrestation AS IDTypePrestation_30,
  s0_.IDTypeEtatsejour AS IDTypeEtatsejour_31,
  s0_.IDTypeLogement AS IDTypeLogement_32
FROM
  Sejour s0_
  LEFT JOIN Avis a1_ ON s0_.IDSejour = a1_.IDSejour
WHERE
  s0_.EstVisible = ?
GROUP BY
  s0_.IDSejour,
  s0_.NomSejour,
  s0_.DescriptionCourte,
  s0_.Ville,
  s0_.CP,
  s0_.DescriptionLongue,
  s0_.DescriptionRegion,
  s0_.ConseilsVisites,
  s0_.DureeSejour,
  s0_.NbreJour,
  s0_.NbreNuit,
  s0_.motCle,
  s0_.EstCoupDeCoeur,
  s0_.RangCoupDeCoeur,
  s0_.EstNouveaute,
  s0_.ImageMiseEnAvant,
  s0_.TarifSejour,
  s0_.NoteGenerale,
  s0_.Metatitle,
  s0_.Metadescription,
  s0_.Metakeywords,
  s0_.lienaafficher,
  s0_.EstVisible,
  s0_.DateCreation,
  s0_.DateModification,
  s0_.IDRegion,
  s0_.IDTheme,
  s0_.IDCategorieOffre,
  s0_.IDHebergement,
  s0_.IDTypeFormule,
  s0_.IDTypePrestation,
  s0_.IDTypeEtatsejour,
  s0_.IDTypeLogement
ORDER BY
  s0_.NomSejour ASC

SELECT s0_.IDSejour AS IDSejour_0, s0_.NomSejour AS NomSejour_1, s0_.DescriptionCourte AS DescriptionCourte_2, s0_.Ville AS Ville_3, s0_.CP AS CP_4, s0_.DescriptionLongue AS DescriptionLongue_5, s0_.DescriptionRegion AS DescriptionRegion_6, s0_.ConseilsVisites AS ConseilsVisites_7, s0_.DureeSejour AS DureeSejour_8, s0_.NbreJour AS NbreJour_9, s0_.NbreNuit AS NbreNuit_10, s0_.motCle AS motCle_11, s0_.EstCoupDeCoeur AS EstCoupDeCoeur_12, s0_.RangCoupDeCoeur AS RangCoupDeCoeur_13, s0_.EstNouveaute AS EstNouveaute_14, s0_.ImageMiseEnAvant AS ImageMiseEnAvant_15, s0_.TarifSejour AS TarifSejour_16, s0_.NoteGenerale AS NoteGenerale_17, s0_.Metatitle AS Metatitle_18, s0_.Metadescription AS Metadescription_19, s0_.Metakeywords AS Metakeywords_20, s0_.lienaafficher AS lienaafficher_21, s0_.EstVisible AS EstVisible_22, s0_.DateCreation AS DateCreation_23, s0_.DateModification AS DateModification_24, s0_.IDRegion AS IDRegion_25, s0_.IDTheme AS IDTheme_26, s0_.IDCategorieOffre AS IDCategorieOffre_27, s0_.IDHebergement AS IDHebergement_28, s0_.IDTypeFormule AS IDTypeFormule_29, s0_.IDTypePrestation AS IDTypePrestation_30, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_31, s0_.IDTypeLogement AS IDTypeLogement_32 FROM Sejour s0_ LEFT JOIN Avis a1_ ON s0_.IDSejour = a1_.IDSejour WHERE s0_.EstVisible = 1 GROUP BY s0_.IDSejour, s0_.NomSejour, s0_.DescriptionCourte, s0_.Ville, s0_.CP, s0_.DescriptionLongue, s0_.DescriptionRegion, s0_.ConseilsVisites, s0_.DureeSejour, s0_.NbreJour, s0_.NbreNuit, s0_.motCle, s0_.EstCoupDeCoeur, s0_.RangCoupDeCoeur, s0_.EstNouveaute, s0_.ImageMiseEnAvant, s0_.TarifSejour, s0_.NoteGenerale, s0_.Metatitle, s0_.Metadescription, s0_.Metakeywords, s0_.lienaafficher, s0_.EstVisible, s0_.DateCreation, s0_.DateModification, s0_.IDRegion, s0_.IDTheme, s0_.IDCategorieOffre, s0_.IDHebergement, s0_.IDTypeFormule, s0_.IDTypePrestation, s0_.IDTypeEtatsejour, s0_.IDTypeLogement ORDER BY s0_.NomSejour ASC;

SELECT
  t0.IDDateSejour AS IDDateSejour_1,
  t0.DatDebut AS DatDebut_2,
  t0.DatDepart AS DatDepart_3,
  t0.CoutNuitee AS CoutNuitee_4,
  t0.DureeSejour AS DureeSejour_5,
  t0.CoutSejour AS CoutSejour_6,
  t0.IDSejour AS IDSejour_7
FROM
  DateSejour t0
WHERE
  t0.IDSejour = ?
ORDER BY
  t0.DatDebut DESC

SELECT t0.IDDateSejour AS IDDateSejour_1, t0.DatDebut AS DatDebut_2, t0.DatDepart AS DatDepart_3, t0.CoutNuitee AS CoutNuitee_4, t0.DureeSejour AS DureeSejour_5, t0.CoutSejour AS CoutSejour_6, t0.IDSejour AS IDSejour_7 FROM DateSejour t0 WHERE t0.IDSejour = 2 ORDER BY t0.DatDebut DESC;

SELECT
  t0.IDSejour AS IDSejour_1,
  t0.NomSejour AS NomSejour_2,
  t0.DescriptionCourte AS DescriptionCourte_3,
  t0.Ville AS Ville_4,
  t0.CP AS CP_5,
  t0.DescriptionLongue AS DescriptionLongue_6,
  t0.DescriptionRegion AS DescriptionRegion_7,
  t0.ConseilsVisites AS ConseilsVisites_8,
  t0.DureeSejour AS DureeSejour_9,
  t0.NbreJour AS NbreJour_10,
  t0.NbreNuit AS NbreNuit_11,
  t0.motCle AS motCle_12,
  t0.EstCoupDeCoeur AS EstCoupDeCoeur_13,
  t0.RangCoupDeCoeur AS RangCoupDeCoeur_14,
  t0.EstNouveaute AS EstNouveaute_15,
  t0.ImageMiseEnAvant AS ImageMiseEnAvant_16,
  t0.TarifSejour AS TarifSejour_17,
  t0.NoteGenerale AS NoteGenerale_18,
  t0.Metatitle AS Metatitle_19,
  t0.Metadescription AS Metadescription_20,
  t0.Metakeywords AS Metakeywords_21,
  t0.lienaafficher AS lienaafficher_22,
  t0.EstVisible AS EstVisible_23,
  t0.DateCreation AS DateCreation_24,
  t0.DateModification AS DateModification_25,
  t0.IDRegion AS IDRegion_26,
  t0.IDTheme AS IDTheme_27,
  t0.IDCategorieOffre AS IDCategorieOffre_28,
  t0.IDHebergement AS IDHebergement_29,
  t0.IDTypeFormule AS IDTypeFormule_30,
  t0.IDTypePrestation AS IDTypePrestation_31,
  t0.IDTypeEtatsejour AS IDTypeEtatsejour_32,
  t0.IDTypeLogement AS IDTypeLogement_33
FROM
  Sejour t0
WHERE
  t0.EstVisible = ?
ORDER BY
  t0.NomSejour ASC

SELECT t0.IDSejour AS IDSejour_1, t0.NomSejour AS NomSejour_2, t0.DescriptionCourte AS DescriptionCourte_3, t0.Ville AS Ville_4, t0.CP AS CP_5, t0.DescriptionLongue AS DescriptionLongue_6, t0.DescriptionRegion AS DescriptionRegion_7, t0.ConseilsVisites AS ConseilsVisites_8, t0.DureeSejour AS DureeSejour_9, t0.NbreJour AS NbreJour_10, t0.NbreNuit AS NbreNuit_11, t0.motCle AS motCle_12, t0.EstCoupDeCoeur AS EstCoupDeCoeur_13, t0.RangCoupDeCoeur AS RangCoupDeCoeur_14, t0.EstNouveaute AS EstNouveaute_15, t0.ImageMiseEnAvant AS ImageMiseEnAvant_16, t0.TarifSejour AS TarifSejour_17, t0.NoteGenerale AS NoteGenerale_18, t0.Metatitle AS Metatitle_19, t0.Metadescription AS Metadescription_20, t0.Metakeywords AS Metakeywords_21, t0.lienaafficher AS lienaafficher_22, t0.EstVisible AS EstVisible_23, t0.DateCreation AS DateCreation_24, t0.DateModification AS DateModification_25, t0.IDRegion AS IDRegion_26, t0.IDTheme AS IDTheme_27, t0.IDCategorieOffre AS IDCategorieOffre_28, t0.IDHebergement AS IDHebergement_29, t0.IDTypeFormule AS IDTypeFormule_30, t0.IDTypePrestation AS IDTypePrestation_31, t0.IDTypeEtatsejour AS IDTypeEtatsejour_32, t0.IDTypeLogement AS IDTypeLogement_33 FROM Sejour t0 WHERE t0.EstVisible = 1 ORDER BY t0.NomSejour ASC;

SELECT
  t0.IDTypeFormule AS IDTypeFormule_1,
  t0.NomTypeFormule AS NomTypeFormule_2,
  t0.CouleurEtiquette AS CouleurEtiquette_3,
  t0.EstActif AS EstActif_4
FROM
  Catalogue t0
WHERE
  t0.IDTypeFormule = ?

SELECT t0.IDTypeFormule AS IDTypeFormule_1, t0.NomTypeFormule AS NomTypeFormule_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.EstActif AS EstActif_4 FROM Catalogue t0 WHERE t0.IDTypeFormule = '9';

SELECT
  t0.IDTypeLogement AS IDTypeLogement_1,
  t0.LibelleTypeLogement AS LibelleTypeLogement_2
FROM
  TypeLogement t0
WHERE
  t0.IDTypeLogement = ?

SELECT t0.IDTypeLogement AS IDTypeLogement_1, t0.LibelleTypeLogement AS LibelleTypeLogement_2 FROM TypeLogement t0 WHERE t0.IDTypeLogement = '1';

SELECT
  t0.IDTypePrestation AS IDTypePrestation_1,
  t0.LibellePrestation AS LibellePrestation_2
FROM
  TypePrestation t0
WHERE
  t0.IDTypePrestation = ?

SELECT t0.IDTypePrestation AS IDTypePrestation_1, t0.LibellePrestation AS LibellePrestation_2 FROM TypePrestation t0 WHERE t0.IDTypePrestation = '2';

SELECT
  t0.IDPagePublique AS IDPagePublique_1,
  t0.NomPage AS NomPage_2,
  t0.TitrePage AS TitrePage_3,
  t0.ContenuPage AS ContenuPage_4,
  t0.Metatitle AS Metatitle_5,
  t0.Metadescription AS Metadescription_6,
  t0.Metakeywords AS Metakeywords_7,
  t0.EstActif AS EstActif_8,
  t0.EstBlog AS EstBlog_9,
  t0.ImageMiseEnAvant AS ImageMiseEnAvant_10,
  t0.LienPageAfficher AS LienPageAfficher_11,
  t0.LibelleBanner AS LibelleBanner_12
FROM
  PagePublique t0
WHERE
  t0.LienPageAfficher = ?
LIMIT
  1

SELECT t0.IDPagePublique AS IDPagePublique_1, t0.NomPage AS NomPage_2, t0.TitrePage AS TitrePage_3, t0.ContenuPage AS ContenuPage_4, t0.Metatitle AS Metatitle_5, t0.Metadescription AS Metadescription_6, t0.Metakeywords AS Metakeywords_7, t0.EstActif AS EstActif_8, t0.EstBlog AS EstBlog_9, t0.ImageMiseEnAvant AS ImageMiseEnAvant_10, t0.LienPageAfficher AS LienPageAfficher_11, t0.LibelleBanner AS LibelleBanner_12 FROM PagePublique t0 WHERE t0.LienPageAfficher = 'faq' LIMIT 1;

SELECT
  t0.IDRegion AS IDRegion_1,
  t0.LibelleRegion AS LibelleRegion_2,
  t0.AncienNom AS AncienNom_3
FROM
  Region t0

SELECT t0.IDRegion AS IDRegion_1, t0.LibelleRegion AS LibelleRegion_2, t0.AncienNom AS AncienNom_3 FROM Region t0;

SELECT
  t0.IDBanner AS IDBanner_1,
  t0.ImageBanner AS ImageBanner_2,
  t0.TitreBanner AS TitreBanner_3,
  t0.SoustitreBanner AS SoustitreBanner_4,
  t0.Libelle AS Libelle_5,
  t0.AltImageBanner AS AltImageBanner_6
FROM
  Banner t0
WHERE
  t0.Libelle = ?
LIMIT
  1

SELECT t0.IDBanner AS IDBanner_1, t0.ImageBanner AS ImageBanner_2, t0.TitreBanner AS TitreBanner_3, t0.SoustitreBanner AS SoustitreBanner_4, t0.Libelle AS Libelle_5, t0.AltImageBanner AS AltImageBanner_6 FROM Banner t0 WHERE t0.Libelle = 'allsejours' LIMIT 1;

SELECT
  t0.IDCategorieOffre AS IDCategorieOffre_1,
  t0.LibelleCategorieOffre AS LibelleCategorieOffre_2,
  t0.CouleurEtiquette AS CouleurEtiquette_3,
  t0.Commentaire AS Commentaire_4
FROM
  CategorieOffre t0

SELECT t0.IDCategorieOffre AS IDCategorieOffre_1, t0.LibelleCategorieOffre AS LibelleCategorieOffre_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.Commentaire AS Commentaire_4 FROM CategorieOffre t0;