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_.adresse AS adresse_4,
  f1_.reference AS reference_5,
  f1_.nom_cabinet AS nom_cabinet_6,
  f1_.horaire AS horaire_7,
  f1_.tarif AS tarif_8,
  f1_.logo AS logo_9,
  f1_.programme AS programme_10,
  f1_.logo2 AS logo2_11,
  f1_.logo3 AS logo3_12,
  NULLIF(f1_.formateur, '') AS sclr_13,
  NULLIF(f1_.formateur2, '') AS sclr_14,
  NULLIF(f1_.formateur3, '') AS sclr_15,
  f1_.fonction AS fonction_16,
  f1_.fonction2 AS fonction2_17,
  f1_.fonction3 AS fonction3_18,
  f1_.id_formation AS id_formation_19,
  f1_.message_si_pas_date AS message_si_pas_date_20,
  f1_.effectif_maximum AS effectif_maximum_21,
  f1_.effectif_minimum AS effectif_minimum_22
FROM
  fusacq_dbo.formations f1_
  LEFT JOIN fusacq_dbo.dates_formation d0_ ON (
    f1_.id_formation = d0_.id_formation
  )
WHERE
  f1_.id_formation = ?

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_.adresse AS adresse_4, f1_.reference AS reference_5, f1_.nom_cabinet AS nom_cabinet_6, f1_.horaire AS horaire_7, f1_.tarif AS tarif_8, f1_.logo AS logo_9, f1_.programme AS programme_10, f1_.logo2 AS logo2_11, f1_.logo3 AS logo3_12, NULLIF(f1_.formateur, '') AS sclr_13, NULLIF(f1_.formateur2, '') AS sclr_14, NULLIF(f1_.formateur3, '') AS sclr_15, f1_.fonction AS fonction_16, f1_.fonction2 AS fonction2_17, f1_.fonction3 AS fonction3_18, f1_.id_formation AS id_formation_19, f1_.message_si_pas_date AS message_si_pas_date_20, f1_.effectif_maximum AS effectif_maximum_21, f1_.effectif_minimum AS effectif_minimum_22 FROM fusacq_dbo.formations f1_ LEFT JOIN fusacq_dbo.dates_formation d0_ ON (f1_.id_formation = d0_.id_formation) WHERE f1_.id_formation = 24;

SELECT
  d0_.date_formation AS date_formation_0,
  f1_.titre AS titre_1,
  d0_.type_lieu_session AS type_lieu_session_2
FROM
  fusacq_dbo.formations f1_
  LEFT JOIN fusacq_dbo.dates_formation d0_ ON (
    d0_.id_formation = f1_.id_formation
  )
WHERE
  f1_.reference LIKE '%CE1%'
  AND d0_.date_formation > '20260501'
ORDER BY
  d0_.date_formation ASC

SELECT d0_.date_formation AS date_formation_0, f1_.titre AS titre_1, d0_.type_lieu_session AS type_lieu_session_2 FROM fusacq_dbo.formations f1_ LEFT JOIN fusacq_dbo.dates_formation d0_ ON (d0_.id_formation = f1_.id_formation) WHERE f1_.reference LIKE '%CE1%' AND d0_.date_formation > '20260501' ORDER BY d0_.date_formation ASC;

SELECT
  d0_.date_formation AS date_formation_0,
  f1_.titre AS titre_1,
  d0_.type_lieu_session AS type_lieu_session_2
FROM
  fusacq_dbo.formations f1_
  LEFT JOIN fusacq_dbo.dates_formation d0_ ON (
    d0_.id_formation = f1_.id_formation
  )
WHERE
  f1_.reference LIKE '%CE1%'
  AND d0_.date_formation > '20260501'
ORDER BY
  d0_.date_formation ASC

SELECT d0_.date_formation AS date_formation_0, f1_.titre AS titre_1, d0_.type_lieu_session AS type_lieu_session_2 FROM fusacq_dbo.formations f1_ LEFT JOIN fusacq_dbo.dates_formation d0_ ON (d0_.id_formation = f1_.id_formation) WHERE f1_.reference LIKE '%CE1%' AND d0_.date_formation > '20260501' ORDER BY d0_.date_formation ASC;

SELECT
  f0_.id_formation AS id_formation_0,
  d1_.id_date_formation AS id_date_formation_1,
  d1_.date_formation AS date_formation_2,
  f0_.reference AS reference_3,
  f0_.titre AS titre_4
FROM
  fusacq_dbo.formations f0_
  LEFT JOIN fusacq_dbo.dates_formation d1_ ON (
    d1_.id_formation = f0_.id_formation
  )
WHERE
  f0_.id_formation = 24
  AND d1_.date_formation > '20260501'
ORDER BY
  d1_.date_formation ASC
LIMIT
  1

SELECT f0_.id_formation AS id_formation_0, d1_.id_date_formation AS id_date_formation_1, d1_.date_formation AS date_formation_2, f0_.reference AS reference_3, f0_.titre AS titre_4 FROM fusacq_dbo.formations f0_ LEFT JOIN fusacq_dbo.dates_formation d1_ ON (d1_.id_formation = f0_.id_formation) WHERE f0_.id_formation = 24 AND d1_.date_formation > '20260501' ORDER BY d1_.date_formation ASC LIMIT 1;

SELECT
  f0_.id_formation AS id_formation_0,
  d1_.id_date_formation AS id_date_formation_1,
  d1_.date_formation AS date_formation_2,
  f0_.reference AS reference_3,
  f0_.titre AS titre_4
FROM
  fusacq_dbo.formations f0_
  LEFT JOIN fusacq_dbo.dates_formation d1_ ON (
    d1_.id_formation = f0_.id_formation
  )
WHERE
  f0_.reference = 'CE2'
  AND (
    f0_.mode = 'publique'
    AND f0_.type_formation = 'formation'
  )
  AND d1_.date_formation > '20260527'
ORDER BY
  d1_.date_formation ASC
LIMIT
  1

SELECT f0_.id_formation AS id_formation_0, d1_.id_date_formation AS id_date_formation_1, d1_.date_formation AS date_formation_2, f0_.reference AS reference_3, f0_.titre AS titre_4 FROM fusacq_dbo.formations f0_ LEFT JOIN fusacq_dbo.dates_formation d1_ ON (d1_.id_formation = f0_.id_formation) WHERE f0_.reference = 'CE2' AND (f0_.mode = 'publique' AND f0_.type_formation = 'formation') AND d1_.date_formation > '20260527' ORDER BY d1_.date_formation ASC LIMIT 1;

SELECT
  f0_.id_formation AS id_formation_0,
  d1_.id_date_formation AS id_date_formation_1,
  d1_.date_formation AS date_formation_2,
  f0_.reference AS reference_3,
  f0_.titre AS titre_4
FROM
  fusacq_dbo.formations f0_
  LEFT JOIN fusacq_dbo.dates_formation d1_ ON (
    d1_.id_formation = f0_.id_formation
  )
WHERE
  f0_.reference = 'CE3'
  AND (
    f0_.mode = 'publique'
    AND f0_.type_formation = 'formation'
  )
  AND d1_.date_formation > '20260527'
ORDER BY
  d1_.date_formation ASC
LIMIT
  1

SELECT f0_.id_formation AS id_formation_0, d1_.id_date_formation AS id_date_formation_1, d1_.date_formation AS date_formation_2, f0_.reference AS reference_3, f0_.titre AS titre_4 FROM fusacq_dbo.formations f0_ LEFT JOIN fusacq_dbo.dates_formation d1_ ON (d1_.id_formation = f0_.id_formation) WHERE f0_.reference = 'CE3' AND (f0_.mode = 'publique' AND f0_.type_formation = 'formation') AND d1_.date_formation > '20260527' ORDER BY d1_.date_formation ASC LIMIT 1;

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.parametre_site p1_
  LEFT JOIN partage_dbo.data_parametre_site d0_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = 'date_mise_a_jour_formations'
ORDER BY
  d0_.id_parametre_site DESC
LIMIT
  1

SELECT d0_.value AS value_0 FROM partage_dbo.parametre_site p1_ LEFT JOIN partage_dbo.data_parametre_site d0_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'date_mise_a_jour_formations' ORDER BY d0_.id_parametre_site DESC LIMIT 1;

SELECT
  d0_.value AS value_0
FROM
  partage_dbo.data_parametre_site d0_
  LEFT JOIN partage_dbo.parametre_site p1_ ON (
    p1_.id_parametre_site = d0_.id_parametre_site
  )
WHERE
  p1_.nom = ?
  AND p1_.valide = ?
  AND d0_.code_pays = ?
  AND d0_.plateforme = ?

SELECT d0_.value AS value_0 FROM partage_dbo.data_parametre_site d0_ LEFT JOIN partage_dbo.parametre_site p1_ ON (p1_.id_parametre_site = d0_.id_parametre_site) WHERE p1_.nom = 'adresse_entite_locale' AND p1_.valide = 'oui' AND d0_.code_pays = 'fr' AND d0_.plateforme = 'FUSACQ';