Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      datedebut_8
    FROM
      (
        SELECT
          f0_.id AS id_0,
          f0_.code AS code_1,
          f0_.lieu AS lieu_2,
          f0_.nombre AS nombre_3,
          f0_.tarif AS tarif_4,
          f0_.tarifpromotion AS tarifpromotion_5,
          f0_.promotion AS promotion_6,
          f0_.priorite AS priorite_7,
          f0_.datedebut AS datedebut_8,
          f0_.datefin AS datefin_9,
          f0_.datecrea AS datecrea_10,
          f0_.descriptif AS descriptif_11,
          f0_.doc_name AS doc_name_12,
          f0_.doc_name1 AS doc_name1_13,
          f0_.doc_name2 AS doc_name2_14,
          f0_.doc_name3 AS doc_name3_15,
          f0_.updated_at AS updated_at_16,
          f0_.habilitation AS habilitation_17,
          f0_.coordonnees AS coordonnees_18,
          f0_.horaires AS horaires_19,
          t1_.id AS id_20,
          t1_.nom AS nom_21,
          r2_.id AS id_22,
          r2_.nom AS nom_23,
          t3_.id AS id_24,
          t3_.nom AS nom_25,
          s4_.id AS id_26,
          s4_.nom AS nom_27,
          e5_.id AS id_28,
          e5_.nom AS nom_29,
          t6_.id AS id_30,
          t6_.nom AS nom_31,
          t6_.descriptif AS descriptif_32
        FROM
          formation f0_
          INNER JOIN type t1_ ON f0_.type_id = t1_.id
          INNER JOIN region r2_ ON f0_.region_id = r2_.id
          INNER JOIN theme t3_ ON f0_.theme_id = t3_.id
          INNER JOIN saison s4_ ON f0_.saison_id = s4_.id
          LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id
          LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id
        WHERE
          f0_.datedebut > ?
          AND f0_.actif_id = ?
      ) dctrn_result_inner
    ORDER BY
      datedebut_8 ASC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datedebut_8 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > '2024-12-27' AND f0_.actif_id = 1) dctrn_result_inner ORDER BY datedebut_8 ASC) dctrn_result LIMIT 12;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          f0_.id AS id_0,
          f0_.code AS code_1,
          f0_.lieu AS lieu_2,
          f0_.nombre AS nombre_3,
          f0_.tarif AS tarif_4,
          f0_.tarifpromotion AS tarifpromotion_5,
          f0_.promotion AS promotion_6,
          f0_.priorite AS priorite_7,
          f0_.datedebut AS datedebut_8,
          f0_.datefin AS datefin_9,
          f0_.datecrea AS datecrea_10,
          f0_.descriptif AS descriptif_11,
          f0_.doc_name AS doc_name_12,
          f0_.doc_name1 AS doc_name1_13,
          f0_.doc_name2 AS doc_name2_14,
          f0_.doc_name3 AS doc_name3_15,
          f0_.updated_at AS updated_at_16,
          f0_.habilitation AS habilitation_17,
          f0_.coordonnees AS coordonnees_18,
          f0_.horaires AS horaires_19,
          t1_.id AS id_20,
          t1_.nom AS nom_21,
          r2_.id AS id_22,
          r2_.nom AS nom_23,
          t3_.id AS id_24,
          t3_.nom AS nom_25,
          s4_.id AS id_26,
          s4_.nom AS nom_27,
          e5_.id AS id_28,
          e5_.nom AS nom_29,
          t6_.id AS id_30,
          t6_.nom AS nom_31,
          t6_.descriptif AS descriptif_32
        FROM
          formation f0_
          INNER JOIN type t1_ ON f0_.type_id = t1_.id
          INNER JOIN region r2_ ON f0_.region_id = r2_.id
          INNER JOIN theme t3_ ON f0_.theme_id = t3_.id
          INNER JOIN saison s4_ ON f0_.saison_id = s4_.id
          LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id
          LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id
        WHERE
          f0_.datedebut > ?
          AND f0_.actif_id = ?
        ORDER BY
          f0_.datedebut ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > '2024-12-27' AND f0_.actif_id = 1 ORDER BY f0_.datedebut ASC) dctrn_result) dctrn_table;

SELECT
  f0_.id AS id_0,
  f0_.code AS code_1,
  f0_.lieu AS lieu_2,
  f0_.nombre AS nombre_3,
  f0_.tarif AS tarif_4,
  f0_.tarifpromotion AS tarifpromotion_5,
  f0_.promotion AS promotion_6,
  f0_.priorite AS priorite_7,
  f0_.datedebut AS datedebut_8,
  f0_.datefin AS datefin_9,
  f0_.datecrea AS datecrea_10,
  f0_.descriptif AS descriptif_11,
  f0_.doc_name AS doc_name_12,
  f0_.doc_name1 AS doc_name1_13,
  f0_.doc_name2 AS doc_name2_14,
  f0_.doc_name3 AS doc_name3_15,
  f0_.updated_at AS updated_at_16,
  f0_.habilitation AS habilitation_17,
  f0_.coordonnees AS coordonnees_18,
  f0_.horaires AS horaires_19,
  t1_.id AS id_20,
  t1_.nom AS nom_21,
  r2_.id AS id_22,
  r2_.nom AS nom_23,
  t3_.id AS id_24,
  t3_.nom AS nom_25,
  s4_.id AS id_26,
  s4_.nom AS nom_27,
  e5_.id AS id_28,
  e5_.nom AS nom_29,
  t6_.id AS id_30,
  t6_.nom AS nom_31,
  t6_.descriptif AS descriptif_32,
  f0_.zone_id AS zone_id_33,
  f0_.type_id AS type_id_34,
  f0_.theme_id AS theme_id_35,
  f0_.themebafa_id AS themebafa_id_36,
  f0_.saison_id AS saison_id_37,
  f0_.region_id AS region_id_38,
  f0_.hebergement_id AS hebergement_id_39,
  f0_.externat_id AS externat_id_40,
  f0_.actif_id AS actif_id_41,
  f0_.disponibilite_id AS disponibilite_id_42,
  t3_.type_id AS type_id_43,
  t6_.zone_id AS zone_id_44
FROM
  formation f0_
  INNER JOIN type t1_ ON f0_.type_id = t1_.id
  INNER JOIN region r2_ ON f0_.region_id = r2_.id
  INNER JOIN theme t3_ ON f0_.theme_id = t3_.id
  INNER JOIN saison s4_ ON f0_.saison_id = s4_.id
  LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id
  LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id
WHERE
  f0_.datedebut > ?
  AND f0_.actif_id = ?
  AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  f0_.datedebut ASC

SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > '2024-12-27' AND f0_.actif_id = 1 AND f0_.id IN (2303, 2302, 2410, 2411, 2278, 2477, 2476, 2418, 2417, 0, 2482, 2483) ORDER BY f0_.datedebut ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  hebergement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM hebergement t0 WHERE t0.id = 2;