Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom_sejour AS nom_sejour_2,
  t0.age_min AS age_min_3,
  t0.age_max AS age_max_4,
  t0.date_debut AS date_debut_5,
  t0.date_fin AS date_fin_6,
  t0.description AS description_7,
  t0.nbplace AS nbplace_8,
  t0.montant_acompte AS montant_acompte_9,
  t0.hebergement AS hebergement_10,
  t0.justificatif_suplementaire AS justificatif_suplementaire_11,
  t0.nom_image_principale AS nom_image_principale_12,
  t0.updated_at AS updated_at_13,
  t0.type_activite AS type_activite_14,
  t0.nb_places_prises AS nb_places_prises_15,
  t0.date_delai_reservation AS date_delai_reservation_16,
  t0.date_delai_annulation AS date_delai_annulation_17,
  t0.statut AS statut_18,
  t0.total_liste_attente AS total_liste_attente_19,
  t0.recurrence AS recurrence_20,
  t0.type_recurrence AS type_recurrence_21,
  t0.numero_declaration_sdjes AS numero_declaration_sdjes_22,
  t0.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_23,
  t0.categorie_id AS categorie_id_24,
  t0.coordonnees_id AS coordonnees_id_25,
  t0.semaine_recurrence_id AS semaine_recurrence_id_26
FROM
  sejour t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_sejour AS nom_sejour_2, t0.age_min AS age_min_3, t0.age_max AS age_max_4, t0.date_debut AS date_debut_5, t0.date_fin AS date_fin_6, t0.description AS description_7, t0.nbplace AS nbplace_8, t0.montant_acompte AS montant_acompte_9, t0.hebergement AS hebergement_10, t0.justificatif_suplementaire AS justificatif_suplementaire_11, t0.nom_image_principale AS nom_image_principale_12, t0.updated_at AS updated_at_13, t0.type_activite AS type_activite_14, t0.nb_places_prises AS nb_places_prises_15, t0.date_delai_reservation AS date_delai_reservation_16, t0.date_delai_annulation AS date_delai_annulation_17, t0.statut AS statut_18, t0.total_liste_attente AS total_liste_attente_19, t0.recurrence AS recurrence_20, t0.type_recurrence AS type_recurrence_21, t0.numero_declaration_sdjes AS numero_declaration_sdjes_22, t0.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_23, t0.categorie_id AS categorie_id_24, t0.coordonnees_id AS coordonnees_id_25, t0.semaine_recurrence_id AS semaine_recurrence_id_26 FROM sejour t0 WHERE t0.id = '78';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.num_tel AS num_tel_3,
  t0.adresse1 AS adresse1_4,
  t0.adresse2 AS adresse2_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.nom_adresse AS nom_adresse_8,
  t0.tel_pro AS tel_pro_9,
  t0.code_insee AS code_insee_10,
  t0.creation_admin AS creation_admin_11,
  t12.id AS id_13,
  t12.roles AS roles_14,
  t12.password AS password_15,
  t12.is_verified AS is_verified_16,
  t12.nom AS nom_17,
  t12.prenom AS prenom_18,
  t12.username AS username_19,
  t12.token AS token_20,
  t12.token_mdp AS token_mdp_21,
  t12.desactivation_compte AS desactivation_compte_22,
  t12.created_at AS created_at_23,
  t12.refus_campagne AS refus_campagne_24,
  t12.compte_finalise AS compte_finalise_25,
  t12.coordonnees_id AS coordonnees_id_26,
  t12.info_allocataire_id AS info_allocataire_id_27
FROM
  coordonnees t0
  LEFT JOIN user t12 ON t12.coordonnees_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.num_tel AS num_tel_3, t0.adresse1 AS adresse1_4, t0.adresse2 AS adresse2_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.nom_adresse AS nom_adresse_8, t0.tel_pro AS tel_pro_9, t0.code_insee AS code_insee_10, t0.creation_admin AS creation_admin_11, t12.id AS id_13, t12.roles AS roles_14, t12.password AS password_15, t12.is_verified AS is_verified_16, t12.nom AS nom_17, t12.prenom AS prenom_18, t12.username AS username_19, t12.token AS token_20, t12.token_mdp AS token_mdp_21, t12.desactivation_compte AS desactivation_compte_22, t12.created_at AS created_at_23, t12.refus_campagne AS refus_campagne_24, t12.compte_finalise AS compte_finalise_25, t12.coordonnees_id AS coordonnees_id_26, t12.info_allocataire_id AS info_allocataire_id_27 FROM coordonnees t0 LEFT JOIN user t12 ON t12.coordonnees_id = t0.id WHERE t0.id = 102;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.commune AS commune_3,
  t0.plein_tarif AS plein_tarif_4,
  t0.nom AS nom_5,
  t0.type_duree_id AS type_duree_id_6
FROM
  tarif t0
  INNER JOIN tarif_sejour ON t0.id = tarif_sejour.tarif_id
WHERE
  tarif_sejour.sejour_id = ?

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.commune AS commune_3, t0.plein_tarif AS plein_tarif_4, t0.nom AS nom_5, t0.type_duree_id AS type_duree_id_6 FROM tarif t0 INNER JOIN tarif_sejour ON t0.id = tarif_sejour.tarif_id WHERE tarif_sejour.sejour_id = 78;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.nom_periode AS nom_periode_3,
  t0.nb_places_prises AS nb_places_prises_4,
  t0.num_semaine AS num_semaine_5,
  t0.en_liste_attente AS en_liste_attente_6,
  t0.activite_id AS activite_id_7
FROM
  creneau_activite t0
WHERE
  t0.activite_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.nom_periode AS nom_periode_3, t0.nb_places_prises AS nb_places_prises_4, t0.num_semaine AS num_semaine_5, t0.en_liste_attente AS en_liste_attente_6, t0.activite_id AS activite_id_7 FROM creneau_activite t0 WHERE t0.activite_id = 78;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.type AS type_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.concerne AS concerne_6,
  t0.age_min AS age_min_7,
  t0.age_max AS age_max_8,
  t0.tarif AS tarif_9,
  t0.obligatoire AS obligatoire_10,
  t0.archive AS archive_11
FROM
  adhesion t0
  INNER JOIN adhesion_sejour ON t0.id = adhesion_sejour.adhesion_id
WHERE
  adhesion_sejour.sejour_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.concerne AS concerne_6, t0.age_min AS age_min_7, t0.age_max AS age_max_8, t0.tarif AS tarif_9, t0.obligatoire AS obligatoire_10, t0.archive AS archive_11 FROM adhesion t0 INNER JOIN adhesion_sejour ON t0.id = adhesion_sejour.adhesion_id WHERE adhesion_sejour.sejour_id = 78;

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.nom AS nom_1,
  t0_.duree AS duree_2,
  t0_.h_debut AS h_debut_3,
  t0_.h_fin AS h_fin_4,
  t0_.jour_dispo AS jour_dispo_5,
  t0_.demi_journees_dispo AS demi_journees_dispo_6,
  t0_.h_debut_aprem AS h_debut_aprem_7,
  t0_.h_fin_aprem AS h_fin_aprem_8,
  t0_.matin_aprem AS matin_aprem_9
FROM
  type_duree t0_
  INNER JOIN tarif t1_ ON t0_.id = t1_.type_duree_id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      tarif_sejour t2_
    WHERE
      t2_.tarif_id = t1_.id
      AND t2_.sejour_id IN (?)
  )
ORDER BY
  t0_.duree ASC

SELECT DISTINCT t0_.id AS id_0, t0_.nom AS nom_1, t0_.duree AS duree_2, t0_.h_debut AS h_debut_3, t0_.h_fin AS h_fin_4, t0_.jour_dispo AS jour_dispo_5, t0_.demi_journees_dispo AS demi_journees_dispo_6, t0_.h_debut_aprem AS h_debut_aprem_7, t0_.h_fin_aprem AS h_fin_aprem_8, t0_.matin_aprem AS matin_aprem_9 FROM type_duree t0_ INNER JOIN tarif t1_ ON t0_.id = t1_.type_duree_id WHERE EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t1_.id AND t2_.sejour_id IN (78)) ORDER BY t0_.duree ASC;

SELECT
  DISTINCT q0_.qfmin AS qfmin_0,
  q0_.qfmax AS qfmax_1,
  q0_.nom AS nom_2
FROM
  quotient_familial q0_
  INNER JOIN tarif t1_ ON q0_.tarif_id = t1_.id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      tarif_sejour t2_
    WHERE
      t2_.tarif_id = t1_.id
      AND t2_.sejour_id IN (?)
  )
  AND t1_.type_duree_id = ?

SELECT DISTINCT q0_.qfmin AS qfmin_0, q0_.qfmax AS qfmax_1, q0_.nom AS nom_2 FROM quotient_familial q0_ INNER JOIN tarif t1_ ON q0_.tarif_id = t1_.id WHERE EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t1_.id AND t2_.sejour_id IN (78)) AND t1_.type_duree_id = 10;

SELECT
  t0_.id AS id_0,
  t0_.prix AS prix_1,
  t0_.commune AS commune_2,
  t0_.plein_tarif AS plein_tarif_3,
  t0_.nom AS nom_4,
  t0_.type_duree_id AS type_duree_id_5
FROM
  tarif t0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      tarif_sejour t1_
    WHERE
      t1_.tarif_id = t0_.id
      AND t1_.sejour_id IN (?)
  )
  AND t0_.type_duree_id = ?

SELECT t0_.id AS id_0, t0_.prix AS prix_1, t0_.commune AS commune_2, t0_.plein_tarif AS plein_tarif_3, t0_.nom AS nom_4, t0_.type_duree_id AS type_duree_id_5 FROM tarif t0_ WHERE EXISTS (SELECT 1 FROM tarif_sejour t1_ WHERE t1_.tarif_id = t0_.id AND t1_.sejour_id IN (78)) AND t0_.type_duree_id = 10;

SELECT
  o0_.id AS id_0,
  o0_.label AS label_1,
  o0_.valeur_defaut AS valeur_defaut_2,
  o0_.slug AS slug_3
FROM
  `option` o0_
  INNER JOIN option_tarif o1_ ON o0_.id = o1_.option_t_id
  INNER JOIN tarif t2_ ON o1_.tarif_id = t2_.id
WHERE
  t2_.id IN (?, ?)
  AND o1_.en_fonction IS NOT NULL

SELECT o0_.id AS id_0, o0_.label AS label_1, o0_.valeur_defaut AS valeur_defaut_2, o0_.slug AS slug_3 FROM `option` o0_ INNER JOIN option_tarif o1_ ON o0_.id = o1_.option_t_id INNER JOIN tarif t2_ ON o1_.tarif_id = t2_.id WHERE t2_.id IN (39, 40) AND o1_.en_fonction IS NOT NULL;

SELECT
  t0_.id AS id_0
FROM
  tarif t0_
  INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id
  INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id
WHERE
  o1_.en_fonction = ?
  AND o2_.id = ?

SELECT t0_.id AS id_0 FROM tarif t0_ INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id WHERE o1_.en_fonction = 1 AND o2_.id = 1;

SELECT
  t0_.id AS id_0,
  t0_.prix AS prix_1,
  t0_.commune AS commune_2,
  t0_.plein_tarif AS plein_tarif_3,
  t0_.nom AS nom_4,
  t0_.type_duree_id AS type_duree_id_5
FROM
  tarif t0_
  INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id
WHERE
  t0_.plein_tarif = ?
  AND EXISTS (
    SELECT
      1
    FROM
      tarif_sejour t2_
    WHERE
      t2_.tarif_id = t0_.id
      AND t2_.sejour_id IN (?)
  )
  AND t0_.commune IS NULL
  AND t1_.nom = ?
  AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
LIMIT
  1

SELECT t0_.id AS id_0, t0_.prix AS prix_1, t0_.commune AS commune_2, t0_.plein_tarif AS plein_tarif_3, t0_.nom AS nom_4, t0_.type_duree_id AS type_duree_id_5 FROM tarif t0_ INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id WHERE t0_.plein_tarif = 0 AND EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t0_.id AND t2_.sejour_id IN (78)) AND t0_.commune IS NULL AND t1_.nom = 'Demi-journée mercredi' AND t0_.id IN (9, 12, 13, 14, 15, 18, 39, 42) LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.qfmin AS qfmin_1,
  q0_.qfmax AS qfmax_2,
  q0_.nom AS nom_3,
  q0_.prix_qf AS prix_qf_4,
  q0_.tarif_id AS tarif_id_5,
  q0_.variables_id AS variables_id_6
FROM
  quotient_familial q0_
WHERE
  q0_.tarif_id = ?
  AND q0_.qfmin = ?
  AND q0_.qfmax = ?
LIMIT
  1

SELECT q0_.id AS id_0, q0_.qfmin AS qfmin_1, q0_.qfmax AS qfmax_2, q0_.nom AS nom_3, q0_.prix_qf AS prix_qf_4, q0_.tarif_id AS tarif_id_5, q0_.variables_id AS variables_id_6 FROM quotient_familial q0_ WHERE q0_.tarif_id = 39 AND q0_.qfmin = 0 AND q0_.qfmax = 600 LIMIT 1;

SELECT
  t0_.id AS id_0
FROM
  tarif t0_
  INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id
  INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id
WHERE
  o1_.en_fonction = ?
  AND o2_.id = ?

SELECT t0_.id AS id_0 FROM tarif t0_ INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id WHERE o1_.en_fonction = 0 AND o2_.id = 1;

SELECT
  t0_.id AS id_0,
  t0_.prix AS prix_1,
  t0_.commune AS commune_2,
  t0_.plein_tarif AS plein_tarif_3,
  t0_.nom AS nom_4,
  t0_.type_duree_id AS type_duree_id_5
FROM
  tarif t0_
  INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id
WHERE
  t0_.plein_tarif = ?
  AND EXISTS (
    SELECT
      1
    FROM
      tarif_sejour t2_
    WHERE
      t2_.tarif_id = t0_.id
      AND t2_.sejour_id IN (?)
  )
  AND t0_.commune IS NULL
  AND t1_.nom = ?
  AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
LIMIT
  1

SELECT t0_.id AS id_0, t0_.prix AS prix_1, t0_.commune AS commune_2, t0_.plein_tarif AS plein_tarif_3, t0_.nom AS nom_4, t0_.type_duree_id AS type_duree_id_5 FROM tarif t0_ INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id WHERE t0_.plein_tarif = 0 AND EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t0_.id AND t2_.sejour_id IN (78)) AND t0_.commune IS NULL AND t1_.nom = 'Demi-journée mercredi' AND t0_.id IN (1, 2, 3, 6, 7, 8, 40, 41) LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.qfmin AS qfmin_1,
  q0_.qfmax AS qfmax_2,
  q0_.nom AS nom_3,
  q0_.prix_qf AS prix_qf_4,
  q0_.tarif_id AS tarif_id_5,
  q0_.variables_id AS variables_id_6
FROM
  quotient_familial q0_
WHERE
  q0_.tarif_id = ?
  AND q0_.qfmin = ?
  AND q0_.qfmax = ?
LIMIT
  1

SELECT q0_.id AS id_0, q0_.qfmin AS qfmin_1, q0_.qfmax AS qfmax_2, q0_.nom AS nom_3, q0_.prix_qf AS prix_qf_4, q0_.tarif_id AS tarif_id_5, q0_.variables_id AS variables_id_6 FROM quotient_familial q0_ WHERE q0_.tarif_id = 40 AND q0_.qfmin = 0 AND q0_.qfmax = 600 LIMIT 1;

SELECT
  t0_.id AS id_0
FROM
  tarif t0_
  INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id
  INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id
WHERE
  o1_.en_fonction = ?
  AND o2_.id = ?

SELECT t0_.id AS id_0 FROM tarif t0_ INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id WHERE o1_.en_fonction = 1 AND o2_.id = 1;

SELECT
  t0_.id AS id_0,
  t0_.prix AS prix_1,
  t0_.commune AS commune_2,
  t0_.plein_tarif AS plein_tarif_3,
  t0_.nom AS nom_4,
  t0_.type_duree_id AS type_duree_id_5
FROM
  tarif t0_
  INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id
WHERE
  t0_.plein_tarif = ?
  AND EXISTS (
    SELECT
      1
    FROM
      tarif_sejour t2_
    WHERE
      t2_.tarif_id = t0_.id
      AND t2_.sejour_id IN (?)
  )
  AND t0_.commune IS NULL
  AND t1_.nom = ?
  AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
LIMIT
  1

SELECT t0_.id AS id_0, t0_.prix AS prix_1, t0_.commune AS commune_2, t0_.plein_tarif AS plein_tarif_3, t0_.nom AS nom_4, t0_.type_duree_id AS type_duree_id_5 FROM tarif t0_ INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id WHERE t0_.plein_tarif = 0 AND EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t0_.id AND t2_.sejour_id IN (78)) AND t0_.commune IS NULL AND t1_.nom = 'Demi-journée mercredi' AND t0_.id IN (9, 12, 13, 14, 15, 18, 39, 42) LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.qfmin AS qfmin_1,
  q0_.qfmax AS qfmax_2,
  q0_.nom AS nom_3,
  q0_.prix_qf AS prix_qf_4,
  q0_.tarif_id AS tarif_id_5,
  q0_.variables_id AS variables_id_6
FROM
  quotient_familial q0_
WHERE
  q0_.tarif_id = ?
  AND q0_.qfmin = ?
  AND q0_.qfmax = ?
LIMIT
  1

SELECT q0_.id AS id_0, q0_.qfmin AS qfmin_1, q0_.qfmax AS qfmax_2, q0_.nom AS nom_3, q0_.prix_qf AS prix_qf_4, q0_.tarif_id AS tarif_id_5, q0_.variables_id AS variables_id_6 FROM quotient_familial q0_ WHERE q0_.tarif_id = 39 AND q0_.qfmin = 601 AND q0_.qfmax = 1200 LIMIT 1;

SELECT
  t0_.id AS id_0
FROM
  tarif t0_
  INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id
  INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id
WHERE
  o1_.en_fonction = ?
  AND o2_.id = ?

SELECT t0_.id AS id_0 FROM tarif t0_ INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id WHERE o1_.en_fonction = 0 AND o2_.id = 1;

SELECT
  t0_.id AS id_0,
  t0_.prix AS prix_1,
  t0_.commune AS commune_2,
  t0_.plein_tarif AS plein_tarif_3,
  t0_.nom AS nom_4,
  t0_.type_duree_id AS type_duree_id_5
FROM
  tarif t0_
  INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id
WHERE
  t0_.plein_tarif = ?
  AND EXISTS (
    SELECT
      1
    FROM
      tarif_sejour t2_
    WHERE
      t2_.tarif_id = t0_.id
      AND t2_.sejour_id IN (?)
  )
  AND t0_.commune IS NULL
  AND t1_.nom = ?
  AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
LIMIT
  1

SELECT t0_.id AS id_0, t0_.prix AS prix_1, t0_.commune AS commune_2, t0_.plein_tarif AS plein_tarif_3, t0_.nom AS nom_4, t0_.type_duree_id AS type_duree_id_5 FROM tarif t0_ INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id WHERE t0_.plein_tarif = 0 AND EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t0_.id AND t2_.sejour_id IN (78)) AND t0_.commune IS NULL AND t1_.nom = 'Demi-journée mercredi' AND t0_.id IN (1, 2, 3, 6, 7, 8, 40, 41) LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.qfmin AS qfmin_1,
  q0_.qfmax AS qfmax_2,
  q0_.nom AS nom_3,
  q0_.prix_qf AS prix_qf_4,
  q0_.tarif_id AS tarif_id_5,
  q0_.variables_id AS variables_id_6
FROM
  quotient_familial q0_
WHERE
  q0_.tarif_id = ?
  AND q0_.qfmin = ?
  AND q0_.qfmax = ?
LIMIT
  1

SELECT q0_.id AS id_0, q0_.qfmin AS qfmin_1, q0_.qfmax AS qfmax_2, q0_.nom AS nom_3, q0_.prix_qf AS prix_qf_4, q0_.tarif_id AS tarif_id_5, q0_.variables_id AS variables_id_6 FROM quotient_familial q0_ WHERE q0_.tarif_id = 40 AND q0_.qfmin = 601 AND q0_.qfmax = 1200 LIMIT 1;

SELECT
  t0_.id AS id_0
FROM
  tarif t0_
  INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id
  INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id
WHERE
  o1_.en_fonction = ?
  AND o2_.id = ?

SELECT t0_.id AS id_0 FROM tarif t0_ INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id WHERE o1_.en_fonction = 1 AND o2_.id = 1;

SELECT
  t0_.id AS id_0,
  t0_.prix AS prix_1,
  t0_.commune AS commune_2,
  t0_.plein_tarif AS plein_tarif_3,
  t0_.nom AS nom_4,
  t0_.type_duree_id AS type_duree_id_5
FROM
  tarif t0_
  INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id
WHERE
  t0_.plein_tarif = ?
  AND EXISTS (
    SELECT
      1
    FROM
      tarif_sejour t2_
    WHERE
      t2_.tarif_id = t0_.id
      AND t2_.sejour_id IN (?)
  )
  AND t0_.commune IS NULL
  AND t1_.nom = ?
  AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
LIMIT
  1

SELECT t0_.id AS id_0, t0_.prix AS prix_1, t0_.commune AS commune_2, t0_.plein_tarif AS plein_tarif_3, t0_.nom AS nom_4, t0_.type_duree_id AS type_duree_id_5 FROM tarif t0_ INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id WHERE t0_.plein_tarif = 0 AND EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t0_.id AND t2_.sejour_id IN (78)) AND t0_.commune IS NULL AND t1_.nom = 'Demi-journée mercredi' AND t0_.id IN (9, 12, 13, 14, 15, 18, 39, 42) LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.qfmin AS qfmin_1,
  q0_.qfmax AS qfmax_2,
  q0_.nom AS nom_3,
  q0_.prix_qf AS prix_qf_4,
  q0_.tarif_id AS tarif_id_5,
  q0_.variables_id AS variables_id_6
FROM
  quotient_familial q0_
WHERE
  q0_.tarif_id = ?
  AND q0_.qfmin = ?
  AND q0_.qfmax = ?
LIMIT
  1

SELECT q0_.id AS id_0, q0_.qfmin AS qfmin_1, q0_.qfmax AS qfmax_2, q0_.nom AS nom_3, q0_.prix_qf AS prix_qf_4, q0_.tarif_id AS tarif_id_5, q0_.variables_id AS variables_id_6 FROM quotient_familial q0_ WHERE q0_.tarif_id = 39 AND q0_.qfmin = 1201 AND q0_.qfmax = 1500 LIMIT 1;

SELECT
  t0_.id AS id_0
FROM
  tarif t0_
  INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id
  INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id
WHERE
  o1_.en_fonction = ?
  AND o2_.id = ?

SELECT t0_.id AS id_0 FROM tarif t0_ INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id WHERE o1_.en_fonction = 0 AND o2_.id = 1;

SELECT
  t0_.id AS id_0,
  t0_.prix AS prix_1,
  t0_.commune AS commune_2,
  t0_.plein_tarif AS plein_tarif_3,
  t0_.nom AS nom_4,
  t0_.type_duree_id AS type_duree_id_5
FROM
  tarif t0_
  INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id
WHERE
  t0_.plein_tarif = ?
  AND EXISTS (
    SELECT
      1
    FROM
      tarif_sejour t2_
    WHERE
      t2_.tarif_id = t0_.id
      AND t2_.sejour_id IN (?)
  )
  AND t0_.commune IS NULL
  AND t1_.nom = ?
  AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
LIMIT
  1

SELECT t0_.id AS id_0, t0_.prix AS prix_1, t0_.commune AS commune_2, t0_.plein_tarif AS plein_tarif_3, t0_.nom AS nom_4, t0_.type_duree_id AS type_duree_id_5 FROM tarif t0_ INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id WHERE t0_.plein_tarif = 0 AND EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t0_.id AND t2_.sejour_id IN (78)) AND t0_.commune IS NULL AND t1_.nom = 'Demi-journée mercredi' AND t0_.id IN (1, 2, 3, 6, 7, 8, 40, 41) LIMIT 1;

SELECT
  q0_.id AS id_0,
  q0_.qfmin AS qfmin_1,
  q0_.qfmax AS qfmax_2,
  q0_.nom AS nom_3,
  q0_.prix_qf AS prix_qf_4,
  q0_.tarif_id AS tarif_id_5,
  q0_.variables_id AS variables_id_6
FROM
  quotient_familial q0_
WHERE
  q0_.tarif_id = ?
  AND q0_.qfmin = ?
  AND q0_.qfmax = ?
LIMIT
  1

SELECT q0_.id AS id_0, q0_.qfmin AS qfmin_1, q0_.qfmax AS qfmax_2, q0_.nom AS nom_3, q0_.prix_qf AS prix_qf_4, q0_.tarif_id AS tarif_id_5, q0_.variables_id AS variables_id_6 FROM quotient_familial q0_ WHERE q0_.tarif_id = 40 AND q0_.qfmin = 1201 AND q0_.qfmax = 1500 LIMIT 1;

SELECT
  t0_.id AS id_0
FROM
  tarif t0_
  INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id
  INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id
WHERE
  o1_.en_fonction = ?
  AND o2_.id = ?

SELECT t0_.id AS id_0 FROM tarif t0_ INNER JOIN option_tarif o1_ ON t0_.id = o1_.tarif_id INNER JOIN `option` o2_ ON o1_.option_t_id = o2_.id WHERE o1_.en_fonction = 1 AND o2_.id = 1;

SELECT
  t0_.id AS id_0,
  t0_.prix AS prix_1,
  t0_.commune AS commune_2,
  t0_.plein_tarif AS plein_tarif_3,
  t0_.nom AS nom_4,
  t0_.type_duree_id AS type_duree_id_5
FROM
  tarif t0_
  INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id
WHERE
  t0_.plein_tarif = ?
  AND EXISTS (
    SELECT
      1
    FROM
      tarif_sejour t2_
    WHERE
      t2_.tarif_id = t0_.id
      AND t2_.sejour_id IN (?)
  )
  AND t0_.commune IS NULL
  AND t1_.nom = ?
  AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
LIMIT
  1

SELECT t0_.id AS id_0, t0_.prix AS prix_1, t0_.commune AS commune_2, t0_.plein_tarif AS plein_tarif_3, t0_.nom AS nom_4, t0_.type_duree_id AS type_duree_id_5 FROM tarif t0_ INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id WHERE t0_.plein_tarif = 0 AND EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t0_.id AND t2_.sejour_id IN (78)) AND t0_.commune IS NULL AND t1_.nom = 'Demi-journée mercredi' AND t0_.id IN (9, 12, 13, 14, 15, 18, 39, 42) LIMIT 1;