Symfony Profiler

SELECT
  d0_.date_formation AS date_formation_0,
  d0_.type_lieu_session AS type_lieu_session_1,
  d0_.nb_places_limit_atteint AS nb_places_limit_atteint_2,
  f1_.titre AS titre_3,
  f1_.nom_cabinet AS nom_cabinet_4,
  f1_.nb_heures AS nb_heures_5,
  f1_.type_lieu_formation AS type_lieu_formation_6,
  f1_.reference AS reference_7,
  f1_.tarif AS tarif_8,
  f1_.horaire AS horaire_9,
  f1_.logo AS logo_10,
  f1_.formateur AS formateur_11,
  f1_.fonction AS fonction_12,
  f1_.id_formation AS id_formation_13,
  f1_.message_si_pas_date AS message_si_pas_date_14
FROM
  fusacq_dbo.formations f1_
  LEFT JOIN fusacq_dbo.dates_formation d0_ ON (
    d0_.id_formation = f1_.id_formation
  )
WHERE
  (
    f1_.reference NOT LIKE 'JR%'
    AND f1_.reference NOT LIKE 'CE%'
    AND f1_.reference NOT LIKE 'PDC%'
  )
  AND (
    f1_.mode = 'publique'
    AND f1_.type_formation = 'formation'
  )
  AND (
    d0_.afficher_dans_fusacq IS NULL
    OR d0_.afficher_dans_fusacq = 1
  )
  AND (
    d0_.date_formation >= ?
    OR (
      (
        d0_.date_formation IS NULL
        OR d0_.date_formation = ''
        OR d0_.date_formation < ?
      )
      AND NOT EXISTS (
        SELECT
          1 AS sclr_15
        FROM
          fusacq_dbo.dates_formation d2_
        WHERE
          d2_.id_formation = f1_.id_formation
          AND d2_.date_formation >= ?
      )
    )
  )
ORDER BY
  d0_.date_formation ASC

SELECT d0_.date_formation AS date_formation_0, d0_.type_lieu_session AS type_lieu_session_1, d0_.nb_places_limit_atteint AS nb_places_limit_atteint_2, f1_.titre AS titre_3, f1_.nom_cabinet AS nom_cabinet_4, f1_.nb_heures AS nb_heures_5, f1_.type_lieu_formation AS type_lieu_formation_6, f1_.reference AS reference_7, f1_.tarif AS tarif_8, f1_.horaire AS horaire_9, f1_.logo AS logo_10, f1_.formateur AS formateur_11, f1_.fonction AS fonction_12, f1_.id_formation AS id_formation_13, f1_.message_si_pas_date AS message_si_pas_date_14 FROM fusacq_dbo.formations f1_ LEFT JOIN fusacq_dbo.dates_formation d0_ ON (d0_.id_formation = f1_.id_formation) WHERE (f1_.reference NOT LIKE 'JR%' AND f1_.reference NOT LIKE 'CE%' AND f1_.reference NOT LIKE 'PDC%') AND (f1_.mode = 'publique' AND f1_.type_formation = 'formation') AND (d0_.afficher_dans_fusacq IS NULL OR d0_.afficher_dans_fusacq = 1) AND (d0_.date_formation >= '20260420' OR ((d0_.date_formation IS NULL OR d0_.date_formation = '' OR d0_.date_formation < '20260420') AND NOT EXISTS (SELECT 1 AS sclr_15 FROM fusacq_dbo.dates_formation d2_ WHERE d2_.id_formation = f1_.id_formation AND d2_.date_formation >= '20260420'))) ORDER BY d0_.date_formation ASC;

SELECT
  d0_.date_formation AS date_formation_0,
  d0_.type_lieu_session AS type_lieu_session_1,
  d0_.nb_places_limit_atteint AS nb_places_limit_atteint_2,
  f1_.titre AS titre_3,
  f1_.nb_heures AS nb_heures_4,
  f1_.type_lieu_formation AS type_lieu_formation_5,
  f1_.reference AS reference_6,
  f1_.tarif AS tarif_7,
  f1_.horaire AS horaire_8,
  f1_.logo AS logo_9,
  f1_.formateur AS formateur_10,
  f1_.fonction AS fonction_11,
  f1_.id_formation AS id_formation_12,
  f1_.message_si_pas_date AS message_si_pas_date_13
FROM
  fusacq_dbo.formations f1_
  INNER JOIN fusacq_dbo.dates_formation d0_ ON (
    d0_.id_formation = f1_.id_formation
  )
WHERE
  f1_.reference IN ('JR1', 'JR2', 'JR3')
  AND (
    d0_.date_formation > '20260420'
    OR d0_.date_formation = '20260420'
  )
ORDER BY
  d0_.date_formation ASC
LIMIT
  10

SELECT d0_.date_formation AS date_formation_0, d0_.type_lieu_session AS type_lieu_session_1, d0_.nb_places_limit_atteint AS nb_places_limit_atteint_2, f1_.titre AS titre_3, f1_.nb_heures AS nb_heures_4, f1_.type_lieu_formation AS type_lieu_formation_5, f1_.reference AS reference_6, f1_.tarif AS tarif_7, f1_.horaire AS horaire_8, f1_.logo AS logo_9, f1_.formateur AS formateur_10, f1_.fonction AS fonction_11, f1_.id_formation AS id_formation_12, f1_.message_si_pas_date AS message_si_pas_date_13 FROM fusacq_dbo.formations f1_ INNER JOIN fusacq_dbo.dates_formation d0_ ON (d0_.id_formation = f1_.id_formation) WHERE f1_.reference IN ('JR1', 'JR2', 'JR3') AND (d0_.date_formation > '20260420' OR d0_.date_formation = '20260420') ORDER BY d0_.date_formation ASC LIMIT 10;

SELECT
  d0_.date_formation AS date_formation_0,
  d0_.type_lieu_session AS type_lieu_session_1,
  d0_.nb_places_limit_atteint AS nb_places_limit_atteint_2,
  f1_.titre AS titre_3,
  f1_.nb_heures AS nb_heures_4,
  f1_.type_lieu_formation AS type_lieu_formation_5,
  f1_.reference AS reference_6,
  f1_.tarif AS tarif_7,
  f1_.horaire AS horaire_8,
  f1_.logo AS logo_9,
  f1_.formateur AS formateur_10,
  f1_.fonction AS fonction_11,
  f1_.id_formation AS id_formation_12,
  f1_.message_si_pas_date AS message_si_pas_date_13
FROM
  fusacq_dbo.formations f1_
  INNER JOIN fusacq_dbo.dates_formation d0_ ON (
    d0_.id_formation = f1_.id_formation
  )
WHERE
  f1_.reference IN ('CE1', 'CE2', 'CE3')
  AND (
    d0_.date_formation > '20260420'
    OR d0_.date_formation = '20260420'
  )
ORDER BY
  d0_.date_formation ASC
LIMIT
  10

SELECT d0_.date_formation AS date_formation_0, d0_.type_lieu_session AS type_lieu_session_1, d0_.nb_places_limit_atteint AS nb_places_limit_atteint_2, f1_.titre AS titre_3, f1_.nb_heures AS nb_heures_4, f1_.type_lieu_formation AS type_lieu_formation_5, f1_.reference AS reference_6, f1_.tarif AS tarif_7, f1_.horaire AS horaire_8, f1_.logo AS logo_9, f1_.formateur AS formateur_10, f1_.fonction AS fonction_11, f1_.id_formation AS id_formation_12, f1_.message_si_pas_date AS message_si_pas_date_13 FROM fusacq_dbo.formations f1_ INNER JOIN fusacq_dbo.dates_formation d0_ ON (d0_.id_formation = f1_.id_formation) WHERE f1_.reference IN ('CE1', 'CE2', 'CE3') AND (d0_.date_formation > '20260420' OR d0_.date_formation = '20260420') ORDER BY d0_.date_formation ASC LIMIT 10;

SELECT
  d0_.date_formation AS date_formation_0,
  d0_.type_lieu_session AS type_lieu_session_1,
  d0_.nb_places_limit_atteint AS nb_places_limit_atteint_2,
  f1_.titre AS titre_3,
  f1_.nb_heures AS nb_heures_4,
  f1_.type_lieu_formation AS type_lieu_formation_5,
  f1_.reference AS reference_6,
  f1_.tarif AS tarif_7,
  f1_.horaire AS horaire_8,
  f1_.logo AS logo_9,
  f1_.formateur AS formateur_10,
  f1_.fonction AS fonction_11,
  f1_.id_formation AS id_formation_12,
  f1_.message_si_pas_date AS message_si_pas_date_13
FROM
  fusacq_dbo.formations f1_
  INNER JOIN fusacq_dbo.dates_formation d0_ ON (
    d0_.id_formation = f1_.id_formation
  )
WHERE
  f1_.reference IN ('PDC01', 'PDC02', 'PDC03')
  AND (
    d0_.date_formation > '20260420'
    OR d0_.date_formation = '20260420'
  )
ORDER BY
  d0_.date_formation DESC
LIMIT
  10

SELECT d0_.date_formation AS date_formation_0, d0_.type_lieu_session AS type_lieu_session_1, d0_.nb_places_limit_atteint AS nb_places_limit_atteint_2, f1_.titre AS titre_3, f1_.nb_heures AS nb_heures_4, f1_.type_lieu_formation AS type_lieu_formation_5, f1_.reference AS reference_6, f1_.tarif AS tarif_7, f1_.horaire AS horaire_8, f1_.logo AS logo_9, f1_.formateur AS formateur_10, f1_.fonction AS fonction_11, f1_.id_formation AS id_formation_12, f1_.message_si_pas_date AS message_si_pas_date_13 FROM fusacq_dbo.formations f1_ INNER JOIN fusacq_dbo.dates_formation d0_ ON (d0_.id_formation = f1_.id_formation) WHERE f1_.reference IN ('PDC01', 'PDC02', 'PDC03') AND (d0_.date_formation > '20260420' OR d0_.date_formation = '20260420') ORDER BY d0_.date_formation DESC LIMIT 10;

SELECT
  f0_.titre AS titre_0,
  f0_.id_formation AS id_formation_1,
  f0_.reference AS reference_2
FROM
  fusacq_dbo.formations f0_

SELECT f0_.titre AS titre_0, f0_.id_formation AS id_formation_1, f0_.reference AS reference_2 FROM fusacq_dbo.formations f0_;