Symfony Profiler

SELECT
  t0.IDGalerieSejour AS IDGalerieSejour_1,
  t0.TitrePhoto AS TitrePhoto_2,
  t0.photo AS photo_3,
  t0.RangPhoto AS RangPhoto_4,
  t0.IDSejour AS IDSejour_5
FROM
  GalerieSejour t0
WHERE
  t0.IDSejour = ?
ORDER BY
  t0.RangPhoto ASC

SELECT t0.IDGalerieSejour AS IDGalerieSejour_1, t0.TitrePhoto AS TitrePhoto_2, t0.photo AS photo_3, t0.RangPhoto AS RangPhoto_4, t0.IDSejour AS IDSejour_5 FROM GalerieSejour t0 WHERE t0.IDSejour = '3' ORDER BY t0.RangPhoto ASC;

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

SELECT t0.IDRegion AS IDRegion_1, t0.LibelleRegion AS LibelleRegion_2, t0.AncienNom AS AncienNom_3 FROM Region t0 WHERE t0.IDRegion = '11';

SELECT
  t0.IDHebergement AS IDHebergement_1,
  t0.Destination AS Destination_2,
  t0.NomEtablissement AS NomEtablissement_3,
  t0.Classification AS Classification_4,
  t0.Adresse AS Adresse_5,
  t0.CP AS CP_6,
  t0.Ville AS Ville_7,
  t0.Longitude AS Longitude_8,
  t0.Latitude AS Latitude_9,
  t0.Tel AS Tel_10,
  t0.Fax AS Fax_11,
  t0.Email AS Email_12,
  t0.Siteweb AS Siteweb_13,
  t0.InformationComplement AS InformationComplement_14,
  t0.DescriptioCourte AS DescriptioCourte_15,
  t0.DescriptionLongue AS DescriptionLongue_16,
  t0.DescriptionFormule AS DescriptionFormule_17,
  t0.FaxReservation AS FaxReservation_18,
  t0.EmailReservation AS EmailReservation_19,
  t0.SitewebReservation AS SitewebReservation_20,
  t0.DateContact AS DateContact_21,
  t0.MontantCommission AS MontantCommission_22,
  t0.numCpteBQ AS numCpteBQ_23,
  t0.TitulaireCpte AS TitulaireCpte_24,
  t0.NomBanque AS NomBanque_25,
  t0.Resume AS Resume_26,
  t0.Observation AS Observation_27,
  t0.CommentaireIncr AS CommentaireIncr_28,
  t0.ImageMiseEnAvant AS ImageMiseEnAvant_29,
  t0.IDTypeChaine AS IDTypeChaine_30,
  t0.IDCategorieOffre AS IDCategorieOffre_31,
  t0.IDEtatHebergement AS IDEtatHebergement_32,
  t0.IDMaisonMere AS IDMaisonMere_33,
  t0.IDPays AS IDPays_34,
  t0.IDGuide AS IDGuide_35,
  t0.IDOrigineAdhesion AS IDOrigineAdhesion_36
FROM
  Hebergement t0
WHERE
  t0.IDHebergement = ?

SELECT t0.IDHebergement AS IDHebergement_1, t0.Destination AS Destination_2, t0.NomEtablissement AS NomEtablissement_3, t0.Classification AS Classification_4, t0.Adresse AS Adresse_5, t0.CP AS CP_6, t0.Ville AS Ville_7, t0.Longitude AS Longitude_8, t0.Latitude AS Latitude_9, t0.Tel AS Tel_10, t0.Fax AS Fax_11, t0.Email AS Email_12, t0.Siteweb AS Siteweb_13, t0.InformationComplement AS InformationComplement_14, t0.DescriptioCourte AS DescriptioCourte_15, t0.DescriptionLongue AS DescriptionLongue_16, t0.DescriptionFormule AS DescriptionFormule_17, t0.FaxReservation AS FaxReservation_18, t0.EmailReservation AS EmailReservation_19, t0.SitewebReservation AS SitewebReservation_20, t0.DateContact AS DateContact_21, t0.MontantCommission AS MontantCommission_22, t0.numCpteBQ AS numCpteBQ_23, t0.TitulaireCpte AS TitulaireCpte_24, t0.NomBanque AS NomBanque_25, t0.Resume AS Resume_26, t0.Observation AS Observation_27, t0.CommentaireIncr AS CommentaireIncr_28, t0.ImageMiseEnAvant AS ImageMiseEnAvant_29, t0.IDTypeChaine AS IDTypeChaine_30, t0.IDCategorieOffre AS IDCategorieOffre_31, t0.IDEtatHebergement AS IDEtatHebergement_32, t0.IDMaisonMere AS IDMaisonMere_33, t0.IDPays AS IDPays_34, t0.IDGuide AS IDGuide_35, t0.IDOrigineAdhesion AS IDOrigineAdhesion_36 FROM Hebergement t0 WHERE t0.IDHebergement = '3';

SELECT
  d0_.IDDateSejour AS IDDateSejour_0,
  d0_.DatDebut AS DatDebut_1,
  d0_.DatDepart AS DatDepart_2,
  d0_.CoutNuitee AS CoutNuitee_3,
  d0_.DureeSejour AS DureeSejour_4,
  d0_.CoutSejour AS CoutSejour_5,
  d0_.IDSejour AS IDSejour_6
FROM
  DateSejour d0_
WHERE
  d0_.IDSejour = ?
  AND d0_.DatDebut >= ?
ORDER BY
  d0_.DatDebut ASC

SELECT d0_.IDDateSejour AS IDDateSejour_0, d0_.DatDebut AS DatDebut_1, d0_.DatDepart AS DatDepart_2, d0_.CoutNuitee AS CoutNuitee_3, d0_.DureeSejour AS DureeSejour_4, d0_.CoutSejour AS CoutSejour_5, d0_.IDSejour AS IDSejour_6 FROM DateSejour d0_ WHERE d0_.IDSejour = '3' AND d0_.DatDebut >= '2026-04-11 00:00:00' ORDER BY d0_.DatDebut ASC;

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 = '4';

SELECT
  t0.IDContenuPage AS IDContenuPage_1,
  t0.NomPage AS NomPage_2,
  t0.TitreSection AS TitreSection_3,
  t0.CodeSection AS CodeSection_4,
  t0.ContenuSection AS ContenuSection_5
FROM
  ContenuPage t0
WHERE
  t0.CodeSection = ?
LIMIT
  1

SELECT t0.IDContenuPage AS IDContenuPage_1, t0.NomPage AS NomPage_2, t0.TitreSection AS TitreSection_3, t0.CodeSection AS CodeSection_4, t0.ContenuSection AS ContenuSection_5 FROM ContenuPage t0 WHERE t0.CodeSection = 'CCM' LIMIT 1;

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.lienaafficher = ?
LIMIT
  1

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.lienaafficher = '3' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.lienimage AS lienimage_2,
  t0.codeimage AS codeimage_3,
  t0.altimage AS altimage_4,
  t0.descriptionimage AS descriptionimage_5,
  t0.pathimage AS pathimage_6
FROM
  image t0
WHERE
  t0.codeimage = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lienimage AS lienimage_2, t0.codeimage AS codeimage_3, t0.altimage AS altimage_4, t0.descriptionimage AS descriptionimage_5, t0.pathimage AS pathimage_6 FROM image t0 WHERE t0.codeimage = 'CCM' 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 = ?
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.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 = 3 ORDER BY t0.DatDebut DESC;

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 = '1';

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.IDSejour = ?

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.IDSejour = '3';

SELECT
  d0_.IDDateSejour AS IDDateSejour_0,
  d0_.DatDebut AS DatDebut_1,
  d0_.DatDepart AS DatDepart_2,
  d0_.CoutNuitee AS CoutNuitee_3,
  d0_.DureeSejour AS DureeSejour_4,
  d0_.CoutSejour AS CoutSejour_5,
  d0_.IDSejour AS IDSejour_6
FROM
  DateSejour d0_
WHERE
  d0_.IDSejour = ?
  AND d0_.DatDebut >= ?
ORDER BY
  d0_.DatDebut ASC,
  d0_.CoutSejour ASC

SELECT d0_.IDDateSejour AS IDDateSejour_0, d0_.DatDebut AS DatDebut_1, d0_.DatDepart AS DatDepart_2, d0_.CoutNuitee AS CoutNuitee_3, d0_.DureeSejour AS DureeSejour_4, d0_.CoutSejour AS CoutSejour_5, d0_.IDSejour AS IDSejour_6 FROM DateSejour d0_ WHERE d0_.IDSejour = '3' AND d0_.DatDebut >= '2026-04-11 00:00:00' ORDER BY d0_.DatDebut ASC, d0_.CoutSejour ASC;

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 = 'detailssejour' LIMIT 1;