Symfony Profiler

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.EstVisible AS EstVisible_19,
  t0.DateCreation AS DateCreation_20,
  t0.DateModification AS DateModification_21,
  t0.IDRegion AS IDRegion_22,
  t0.IDTheme AS IDTheme_23,
  t0.IDCategorieOffre AS IDCategorieOffre_24,
  t0.IDHebergement AS IDHebergement_25,
  t0.IDTypeFormule AS IDTypeFormule_26,
  t0.IDTypePrestation AS IDTypePrestation_27,
  t0.IDTypeEtatsejour AS IDTypeEtatsejour_28,
  t0.IDTypeLogement AS IDTypeLogement_29
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.EstVisible AS EstVisible_19, t0.DateCreation AS DateCreation_20, t0.DateModification AS DateModification_21, t0.IDRegion AS IDRegion_22, t0.IDTheme AS IDTheme_23, t0.IDCategorieOffre AS IDCategorieOffre_24, t0.IDHebergement AS IDHebergement_25, t0.IDTypeFormule AS IDTypeFormule_26, t0.IDTypePrestation AS IDTypePrestation_27, t0.IDTypeEtatsejour AS IDTypeEtatsejour_28, t0.IDTypeLogement AS IDTypeLogement_29 FROM Sejour t0 WHERE t0.IDSejour = '16';

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
LIMIT
  9

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 = '16' ORDER BY t0.RangPhoto ASC LIMIT 9;

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;

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 = '16' AND d0_.DatDebut >= '2026-01-26 00:00:00' 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 = ?
  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 = '16' AND d0_.DatDebut >= '2026-01-26 00:00:00' ORDER BY d0_.DatDebut ASC, d0_.CoutSejour ASC;

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.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 = 'PA' 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.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 = 'LPA' LIMIT 1;

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

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.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.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.NomBanque AS NomBanque_24,
  t0.Resume AS Resume_25,
  t0.Observation AS Observation_26,
  t0.CommentaireIncr AS CommentaireIncr_27,
  t0.ImageMiseEnAvant AS ImageMiseEnAvant_28,
  t0.IDTypeChaine AS IDTypeChaine_29,
  t0.IDCategorieOffre AS IDCategorieOffre_30,
  t0.IDEtatHebergement AS IDEtatHebergement_31,
  t0.IDMaisonMere AS IDMaisonMere_32,
  t0.IDPays AS IDPays_33,
  t0.IDGuide AS IDGuide_34,
  t0.IDOrigineAdhesion AS IDOrigineAdhesion_35
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.NomBanque AS NomBanque_24, t0.Resume AS Resume_25, t0.Observation AS Observation_26, t0.CommentaireIncr AS CommentaireIncr_27, t0.ImageMiseEnAvant AS ImageMiseEnAvant_28, t0.IDTypeChaine AS IDTypeChaine_29, t0.IDCategorieOffre AS IDCategorieOffre_30, t0.IDEtatHebergement AS IDEtatHebergement_31, t0.IDMaisonMere AS IDMaisonMere_32, t0.IDPays AS IDPays_33, t0.IDGuide AS IDGuide_34, t0.IDOrigineAdhesion AS IDOrigineAdhesion_35 FROM Hebergement t0 WHERE t0.IDHebergement = '15';

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.EstActif AS EstActif_7,
  t0.EstBlog AS EstBlog_8,
  t0.ImageMiseEnAvant AS ImageMiseEnAvant_9,
  t0.LienPageAfficher AS LienPageAfficher_10,
  t0.LibelleBanner AS LibelleBanner_11
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.EstActif AS EstActif_7, t0.EstBlog AS EstBlog_8, t0.ImageMiseEnAvant AS ImageMiseEnAvant_9, t0.LienPageAfficher AS LienPageAfficher_10, t0.LibelleBanner AS LibelleBanner_11 FROM PagePublique t0 WHERE t0.LienPageAfficher = 'faq' LIMIT 1;