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

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 '%JR1%'
  AND d0_.date_formation > '20260419'
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 '%JR1%' AND d0_.date_formation > '20260419' 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 '%JR1%'
  AND d0_.date_formation > '20260419'
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 '%JR1%' AND d0_.date_formation > '20260419' 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 = 7
  AND d1_.date_formation > '20260419'
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 = 7 AND d1_.date_formation > '20260419' 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 = 'JR2'
  AND (
    f0_.mode = 'publique'
    AND f0_.type_formation = 'formation'
  )
  AND d1_.date_formation > '20260421'
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 = 'JR2' AND (f0_.mode = 'publique' AND f0_.type_formation = 'formation') AND d1_.date_formation > '20260421' 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 = 'JR3'
  AND (
    f0_.mode = 'publique'
    AND f0_.type_formation = 'formation'
  )
  AND d1_.date_formation > '20260421'
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 = 'JR3' AND (f0_.mode = 'publique' AND f0_.type_formation = 'formation') AND d1_.date_formation > '20260421' 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';

SELECT
  t0_.id_translation AS id_translation_0,
  t0_.md5_fr AS md5_fr_1,
  t0_.texte_fr AS texte_fr_2,
  t0_.contexte_fr AS contexte_fr_3,
  t0_.md5_en AS md5_en_4,
  t0_.texte_en AS texte_en_5,
  t0_.contexte_en AS contexte_en_6,
  t0_.md5_fr_ca AS md5_fr_ca_7,
  t0_.texte_fr_ca AS texte_fr_ca_8,
  t0_.contexte_fr_ca AS contexte_fr_ca_9,
  t0_.md5_generique AS md5_generique_10,
  t0_.texte_generique AS texte_generique_11,
  t0_.contexte_generique AS contexte_generique_12,
  t0_.md5_es AS md5_es_13,
  t0_.texte_es AS texte_es_14,
  t0_.contexte_es AS contexte_es_15,
  t0_.md5_de AS md5_de_16,
  t0_.texte_de AS texte_de_17,
  t0_.contexte_de AS contexte_de_18,
  t0_.md5_nl AS md5_nl_19,
  t0_.texte_nl AS texte_nl_20,
  t0_.contexte_nl AS contexte_nl_21,
  t0_.md5_it AS md5_it_22,
  t0_.texte_it AS texte_it_23,
  t0_.contexte_it AS contexte_it_24,
  t0_.etat_en AS etat_en_25,
  t0_.etat_es AS etat_es_26,
  t0_.etat_de AS etat_de_27,
  t0_.etat_nl AS etat_nl_28,
  t0_.etat_it AS etat_it_29,
  t0_.etat_fr_ca AS etat_fr_ca_30,
  t0_.traduit_deepl AS traduit_deepl_31,
  t0_.created_at AS created_at_32,
  t0_.page_url AS page_url_33,
  t0_.etat_fr_ch AS etat_fr_ch_34,
  t0_.md5_fr_ch AS md5_fr_ch_35,
  t0_.texte_fr_ch AS texte_fr_ch_36,
  t0_.contexte_fr_ch AS contexte_fr_ch_37
FROM
  partage_dbo.translation t1_,
  partage_dbo.translation t0_
WHERE
  t0_.md5_generique = ?

SELECT t0_.id_translation AS id_translation_0, t0_.md5_fr AS md5_fr_1, t0_.texte_fr AS texte_fr_2, t0_.contexte_fr AS contexte_fr_3, t0_.md5_en AS md5_en_4, t0_.texte_en AS texte_en_5, t0_.contexte_en AS contexte_en_6, t0_.md5_fr_ca AS md5_fr_ca_7, t0_.texte_fr_ca AS texte_fr_ca_8, t0_.contexte_fr_ca AS contexte_fr_ca_9, t0_.md5_generique AS md5_generique_10, t0_.texte_generique AS texte_generique_11, t0_.contexte_generique AS contexte_generique_12, t0_.md5_es AS md5_es_13, t0_.texte_es AS texte_es_14, t0_.contexte_es AS contexte_es_15, t0_.md5_de AS md5_de_16, t0_.texte_de AS texte_de_17, t0_.contexte_de AS contexte_de_18, t0_.md5_nl AS md5_nl_19, t0_.texte_nl AS texte_nl_20, t0_.contexte_nl AS contexte_nl_21, t0_.md5_it AS md5_it_22, t0_.texte_it AS texte_it_23, t0_.contexte_it AS contexte_it_24, t0_.etat_en AS etat_en_25, t0_.etat_es AS etat_es_26, t0_.etat_de AS etat_de_27, t0_.etat_nl AS etat_nl_28, t0_.etat_it AS etat_it_29, t0_.etat_fr_ca AS etat_fr_ca_30, t0_.traduit_deepl AS traduit_deepl_31, t0_.created_at AS created_at_32, t0_.page_url AS page_url_33, t0_.etat_fr_ch AS etat_fr_ch_34, t0_.md5_fr_ch AS md5_fr_ch_35, t0_.texte_fr_ch AS texte_fr_ch_36, t0_.contexte_fr_ch AS contexte_fr_ch_37 FROM partage_dbo.translation t1_, partage_dbo.translation t0_ WHERE t0_.md5_generique = '1d1248cedb62f0c6875056ddca1ab820';