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.EstVisible = ?
  AND t0.EstNouveaute = ?
ORDER BY
  t0.NomSejour ASC
LIMIT
  4

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.EstVisible = 1 AND t0.EstNouveaute = 1 ORDER BY t0.NomSejour ASC LIMIT 4;

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.EstVisible = ?
  AND t0.EstNouveaute = ?
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.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.EstVisible = 1 AND t0.EstNouveaute = 0 ORDER BY t0.NomSejour ASC;

SELECT
  t0.IDSlide AS IDSlide_1,
  t0.ImageFond AS ImageFond_2,
  t0.Titre1 AS Titre1_3,
  t0.Titre2 AS Titre2_4,
  t0.Titre3 AS Titre3_5,
  t0.ButtonText AS ButtonText_6,
  t0.ButtonLink AS ButtonLink_7,
  t0.Tarif AS Tarif_8,
  t0.Rangslide AS Rangslide_9
FROM
  Slide t0
ORDER BY
  t0.Rangslide ASC

SELECT t0.IDSlide AS IDSlide_1, t0.ImageFond AS ImageFond_2, t0.Titre1 AS Titre1_3, t0.Titre2 AS Titre2_4, t0.Titre3 AS Titre3_5, t0.ButtonText AS ButtonText_6, t0.ButtonLink AS ButtonLink_7, t0.Tarif AS Tarif_8, t0.Rangslide AS Rangslide_9 FROM Slide t0 ORDER BY t0.Rangslide ASC;

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.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;

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.NomPage = ?
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.NomPage = 'newsletter' 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 = 'RSGN' 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 = 'NVG' 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 = 'DED' LIMIT 1;

SELECT
  b0_.IDBlog AS IDBlog_0,
  b0_.NomPage AS NomPage_1,
  b0_.TitrePage AS TitrePage_2,
  b0_.DateBlog AS DateBlog_3,
  b0_.DescriptionCourte AS DescriptionCourte_4,
  b0_.ContenuPage AS ContenuPage_5,
  b0_.Metatitle AS Metatitle_6,
  b0_.Metadescription AS Metadescription_7,
  b0_.EstActif AS EstActif_8,
  b0_.ImageMiseEnAvant AS ImageMiseEnAvant_9,
  b0_.LienPageAfficher AS LienPageAfficher_10,
  b0_.IDCategorieOffre AS IDCategorieOffre_11,
  b0_.IDSejour AS IDSejour_12
FROM
  Blog b0_
WHERE
  b0_.EstActif = ?
  AND b0_.LienPageAfficher IS NOT NULL
  AND b0_.LienPageAfficher <> ?

SELECT b0_.IDBlog AS IDBlog_0, b0_.NomPage AS NomPage_1, b0_.TitrePage AS TitrePage_2, b0_.DateBlog AS DateBlog_3, b0_.DescriptionCourte AS DescriptionCourte_4, b0_.ContenuPage AS ContenuPage_5, b0_.Metatitle AS Metatitle_6, b0_.Metadescription AS Metadescription_7, b0_.EstActif AS EstActif_8, b0_.ImageMiseEnAvant AS ImageMiseEnAvant_9, b0_.LienPageAfficher AS LienPageAfficher_10, b0_.IDCategorieOffre AS IDCategorieOffre_11, b0_.IDSejour AS IDSejour_12 FROM Blog b0_ WHERE b0_.EstActif = 1 AND b0_.LienPageAfficher IS NOT NULL AND b0_.LienPageAfficher <> '';

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

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.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.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 = 16 ORDER BY t0.DatDebut DESC;

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.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.IDAvis AS IDAvis_1,
  t0.LibelleAvis AS LibelleAvis_2,
  t0.DateAvis AS DateAvis_3,
  t0.Commentaire AS Commentaire_4,
  t0.note AS note_5,
  t0.EstActif AS EstActif_6,
  t0.IDSejour AS IDSejour_7,
  t0.id AS id_8,
  t0.IDDateSejour AS IDDateSejour_9
FROM
  Avis t0
WHERE
  t0.EstActif = ?

SELECT t0.IDAvis AS IDAvis_1, t0.LibelleAvis AS LibelleAvis_2, t0.DateAvis AS DateAvis_3, t0.Commentaire AS Commentaire_4, t0.note AS note_5, t0.EstActif AS EstActif_6, t0.IDSejour AS IDSejour_7, t0.id AS id_8, t0.IDDateSejour AS IDDateSejour_9 FROM Avis t0 WHERE t0.EstActif = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.EstActif AS EstActif_6,
  t0.EstDecouverte AS EstDecouverte_7,
  t0.nomuser AS nomuser_8,
  t0.photo AS photo_9,
  t0.Hidden AS Hidden_10,
  t0.IDTypeUtilisateur AS IDTypeUtilisateur_11,
  t0.IDDistributeur AS IDDistributeur_12,
  t0.IDClient AS IDClient_13,
  t0.IDAdherent AS IDAdherent_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.EstActif AS EstActif_6, t0.EstDecouverte AS EstDecouverte_7, t0.nomuser AS nomuser_8, t0.photo AS photo_9, t0.Hidden AS Hidden_10, t0.IDTypeUtilisateur AS IDTypeUtilisateur_11, t0.IDDistributeur AS IDDistributeur_12, t0.IDClient AS IDClient_13, t0.IDAdherent AS IDAdherent_14 FROM user t0 WHERE t0.id = 13;

SELECT
  t0.IDAdherent AS IDAdherent_1,
  t0.NumAdherent AS NumAdherent_2,
  t0.NomAdherent AS NomAdherent_3,
  t0.PrenomAdherent AS PrenomAdherent_4,
  t0.DateNaiss AS DateNaiss_5,
  t0.Profession AS Profession_6,
  t0.Adresse AS Adresse_7,
  t0.Suite AS Suite_8,
  t0.CP AS CP_9,
  t0.Ville AS Ville_10,
  t0.TelDom AS TelDom_11,
  t0.TelBur AS TelBur_12,
  t0.Fax AS Fax_13,
  t0.Email AS Email_14,
  t0.Observation AS Observation_15,
  t0.EstActif AS EstActif_16,
  t0.GiftReservationCurrentYear AS GiftReservationCurrentYear_17,
  t0.isAdherent1 AS isAdherent1_18,
  t0.DateCreation AS DateCreation_19,
  t0.IDCivilite AS IDCivilite_20,
  t0.IDPays AS IDPays_21
FROM
  Adherent t0
WHERE
  t0.IDAdherent = ?

SELECT t0.IDAdherent AS IDAdherent_1, t0.NumAdherent AS NumAdherent_2, t0.NomAdherent AS NomAdherent_3, t0.PrenomAdherent AS PrenomAdherent_4, t0.DateNaiss AS DateNaiss_5, t0.Profession AS Profession_6, t0.Adresse AS Adresse_7, t0.Suite AS Suite_8, t0.CP AS CP_9, t0.Ville AS Ville_10, t0.TelDom AS TelDom_11, t0.TelBur AS TelBur_12, t0.Fax AS Fax_13, t0.Email AS Email_14, t0.Observation AS Observation_15, t0.EstActif AS EstActif_16, t0.GiftReservationCurrentYear AS GiftReservationCurrentYear_17, t0.isAdherent1 AS isAdherent1_18, t0.DateCreation AS DateCreation_19, t0.IDCivilite AS IDCivilite_20, t0.IDPays AS IDPays_21 FROM Adherent t0 WHERE t0.IDAdherent = '21';