Symfony Profiler

SELECT
  t0.IDTheme AS IDTheme_1,
  t0.LibelleTheme AS LibelleTheme_2,
  t0.Commentaire AS Commentaire_3,
  t0.ImageFond AS ImageFond_4,
  t0.IconeTheme AS IconeTheme_5,
  t0.couleurTheme AS couleurTheme_6
FROM
  Theme t0

SELECT t0.IDTheme AS IDTheme_1, t0.LibelleTheme AS LibelleTheme_2, t0.Commentaire AS Commentaire_3, t0.ImageFond AS ImageFond_4, t0.IconeTheme AS IconeTheme_5, t0.couleurTheme AS couleurTheme_6 FROM Theme 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 = 'sejourpartheme' LIMIT 1;

SELECT
  count(DISTINCT s0_.IDSejour) AS sclr_0
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?

SELECT count(DISTINCT s0_.IDSejour) AS sclr_0 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '1';

SELECT
  DISTINCT s0_.IDSejour AS IDSejour_0,
  s0_.NomSejour AS NomSejour_1
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?
ORDER BY
  s0_.NomSejour ASC
LIMIT
  12
OFFSET
  12

SELECT DISTINCT s0_.IDSejour AS IDSejour_0, s0_.NomSejour AS NomSejour_1 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '1' ORDER BY s0_.NomSejour ASC LIMIT 12 OFFSET 12;

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_.EstVisible AS EstVisible_18,
  s0_.DateCreation AS DateCreation_19,
  s0_.DateModification AS DateModification_20,
  s0_.IDRegion AS IDRegion_21,
  s0_.IDTheme AS IDTheme_22,
  s0_.IDCategorieOffre AS IDCategorieOffre_23,
  s0_.IDHebergement AS IDHebergement_24,
  s0_.IDTypeFormule AS IDTypeFormule_25,
  s0_.IDTypePrestation AS IDTypePrestation_26,
  s0_.IDTypeEtatsejour AS IDTypeEtatsejour_27,
  s0_.IDTypeLogement AS IDTypeLogement_28
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?
  AND s0_.IDSejour IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
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_.EstVisible AS EstVisible_18, s0_.DateCreation AS DateCreation_19, s0_.DateModification AS DateModification_20, s0_.IDRegion AS IDRegion_21, s0_.IDTheme AS IDTheme_22, s0_.IDCategorieOffre AS IDCategorieOffre_23, s0_.IDHebergement AS IDHebergement_24, s0_.IDTypeFormule AS IDTypeFormule_25, s0_.IDTypePrestation AS IDTypePrestation_26, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_27, s0_.IDTypeLogement AS IDTypeLogement_28 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '1' AND s0_.IDSejour IN ('32', '41', '42', '44', '70', '45', '47', '50', '51', '52', '58', '59') ORDER BY s0_.NomSejour ASC;

SELECT
  count(DISTINCT s0_.IDSejour) AS sclr_0
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?

SELECT count(DISTINCT s0_.IDSejour) AS sclr_0 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '4';

SELECT
  DISTINCT s0_.IDSejour AS IDSejour_0,
  s0_.NomSejour AS NomSejour_1
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?
ORDER BY
  s0_.NomSejour ASC
LIMIT
  12
OFFSET
  24

SELECT DISTINCT s0_.IDSejour AS IDSejour_0, s0_.NomSejour AS NomSejour_1 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '4' ORDER BY s0_.NomSejour ASC LIMIT 12 OFFSET 24;

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_.EstVisible AS EstVisible_18,
  s0_.DateCreation AS DateCreation_19,
  s0_.DateModification AS DateModification_20,
  s0_.IDRegion AS IDRegion_21,
  s0_.IDTheme AS IDTheme_22,
  s0_.IDCategorieOffre AS IDCategorieOffre_23,
  s0_.IDHebergement AS IDHebergement_24,
  s0_.IDTypeFormule AS IDTypeFormule_25,
  s0_.IDTypePrestation AS IDTypePrestation_26,
  s0_.IDTypeEtatsejour AS IDTypeEtatsejour_27,
  s0_.IDTypeLogement AS IDTypeLogement_28
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?
  AND s0_.IDSejour IN (?, ?, ?, ?, ?, ?, ?)
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_.EstVisible AS EstVisible_18, s0_.DateCreation AS DateCreation_19, s0_.DateModification AS DateModification_20, s0_.IDRegion AS IDRegion_21, s0_.IDTheme AS IDTheme_22, s0_.IDCategorieOffre AS IDCategorieOffre_23, s0_.IDHebergement AS IDHebergement_24, s0_.IDTypeFormule AS IDTypeFormule_25, s0_.IDTypePrestation AS IDTypePrestation_26, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_27, s0_.IDTypeLogement AS IDTypeLogement_28 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '4' AND s0_.IDSejour IN ('53', '54', '56', '57', '61', '62', '63') ORDER BY s0_.NomSejour ASC;

SELECT
  count(DISTINCT s0_.IDSejour) AS sclr_0
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?

SELECT count(DISTINCT s0_.IDSejour) AS sclr_0 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '5';

SELECT
  DISTINCT s0_.IDSejour AS IDSejour_0,
  s0_.NomSejour AS NomSejour_1
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?
ORDER BY
  s0_.NomSejour ASC
LIMIT
  12

SELECT DISTINCT s0_.IDSejour AS IDSejour_0, s0_.NomSejour AS NomSejour_1 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '5' ORDER BY s0_.NomSejour ASC LIMIT 12;

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_.EstVisible AS EstVisible_18,
  s0_.DateCreation AS DateCreation_19,
  s0_.DateModification AS DateModification_20,
  s0_.IDRegion AS IDRegion_21,
  s0_.IDTheme AS IDTheme_22,
  s0_.IDCategorieOffre AS IDCategorieOffre_23,
  s0_.IDHebergement AS IDHebergement_24,
  s0_.IDTypeFormule AS IDTypeFormule_25,
  s0_.IDTypePrestation AS IDTypePrestation_26,
  s0_.IDTypeEtatsejour AS IDTypeEtatsejour_27,
  s0_.IDTypeLogement AS IDTypeLogement_28
FROM
  Sejour s0_
WHERE
  s0_.EstVisible = ?
  AND s0_.IDTheme = ?
  AND s0_.IDSejour IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
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_.EstVisible AS EstVisible_18, s0_.DateCreation AS DateCreation_19, s0_.DateModification AS DateModification_20, s0_.IDRegion AS IDRegion_21, s0_.IDTheme AS IDTheme_22, s0_.IDCategorieOffre AS IDCategorieOffre_23, s0_.IDHebergement AS IDHebergement_24, s0_.IDTypeFormule AS IDTypeFormule_25, s0_.IDTypePrestation AS IDTypePrestation_26, s0_.IDTypeEtatsejour AS IDTypeEtatsejour_27, s0_.IDTypeLogement AS IDTypeLogement_28 FROM Sejour s0_ WHERE s0_.EstVisible = 1 AND s0_.IDTheme = '5' AND s0_.IDSejour IN ('68', '10', '14', '27', '40', '49', '55', '71', '64') ORDER BY s0_.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.IDTheme = ?

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

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

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.IDTheme = 5;

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.IDCategorieOffre AS IDCategorieOffre_1,
  t0.LibelleCategorieOffre AS LibelleCategorieOffre_2,
  t0.CouleurEtiquette AS CouleurEtiquette_3,
  t0.Commentaire AS Commentaire_4
FROM
  CategorieOffre t0
WHERE
  t0.IDCategorieOffre = ?

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

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