Symfony Profiler

SELECT
  d0_.slug AS slug_0,
  d0_.libelle AS libelle_1,
  d0_.onglets AS onglets_2,
  d0_.id AS id_3,
  d0_.maj AS maj_4,
  d1_.latitude AS latitude_5,
  d1_.longitude AS longitude_6,
  d1_.id AS id_7,
  d0_.ancienne_region_id AS ancienne_region_id_8,
  d0_.region_id AS region_id_9,
  d1_.departement_id AS departement_id_10
FROM
  departement d0_
  LEFT JOIN departement_coordonnees d1_ ON d0_.id = d1_.departement_id

SELECT d0_.slug AS slug_0, d0_.libelle AS libelle_1, d0_.onglets AS onglets_2, d0_.id AS id_3, d0_.maj AS maj_4, d1_.latitude AS latitude_5, d1_.longitude AS longitude_6, d1_.id AS id_7, d0_.ancienne_region_id AS ancienne_region_id_8, d0_.region_id AS region_id_9, d1_.departement_id AS departement_id_10 FROM departement d0_ LEFT JOIN departement_coordonnees d1_ ON d0_.id = d1_.departement_id;

SELECT
  r0_.libelle AS libelle_0,
  r0_.slug AS slug_1,
  r0_.region_adm AS region_adm_2,
  r0_.ancienne AS ancienne_3,
  r0_.onglets AS onglets_4,
  r0_.id AS id_5,
  r0_.maj AS maj_6
FROM
  region r0_
WHERE
  r0_.ancienne IS NULL
  AND r0_.libelle IS NOT NULL
  AND r0_.slug IS NOT NULL
  AND r0_.libelle <> 'DEFAULT'
  AND r0_.region_adm IS NOT NULL
ORDER BY
  r0_.libelle ASC

SELECT r0_.libelle AS libelle_0, r0_.slug AS slug_1, r0_.region_adm AS region_adm_2, r0_.ancienne AS ancienne_3, r0_.onglets AS onglets_4, r0_.id AS id_5, r0_.maj AS maj_6 FROM region r0_ WHERE r0_.ancienne IS NULL AND r0_.libelle IS NOT NULL AND r0_.slug IS NOT NULL AND r0_.libelle <> 'DEFAULT' AND r0_.region_adm IS NOT NULL ORDER BY r0_.libelle ASC;

SELECT
  t0.slug AS slug_1,
  t0.libelle AS libelle_2,
  t0.id AS id_3,
  t0.maj AS maj_4,
  t0.region_id AS region_id_5
FROM
  ancienne_region t0
WHERE
  t0.id = ?

SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.id AS id_3, t0.maj AS maj_4, t0.region_id AS region_id_5 FROM ancienne_region t0 WHERE t0.id = 'AUVE';

SELECT
  d0_.slug AS slug_0,
  d0_.libelle AS libelle_1,
  d0_.onglets AS onglets_2,
  d0_.id AS id_3,
  d0_.maj AS maj_4,
  d1_.latitude AS latitude_5,
  d1_.longitude AS longitude_6,
  d1_.id AS id_7
FROM
  departement d0_
  LEFT JOIN departement_coordonnees d1_ ON d0_.id = d1_.departement_id
WHERE
  d0_.region_id = ?
  AND d0_.id <> ?
ORDER BY
  d0_.libelle ASC

SELECT d0_.slug AS slug_0, d0_.libelle AS libelle_1, d0_.onglets AS onglets_2, d0_.id AS id_3, d0_.maj AS maj_4, d1_.latitude AS latitude_5, d1_.longitude AS longitude_6, d1_.id AS id_7 FROM departement d0_ LEFT JOIN departement_coordonnees d1_ ON d0_.id = d1_.departement_id WHERE d0_.region_id = 'AUVE' AND d0_.id <> 'BE' ORDER BY d0_.libelle ASC;

SELECT
  j0_.date_publidation AS date_publidation_0,
  j0_.date_actualisation AS date_actualisation_1,
  j0_.lieu AS lieu_2,
  j0_.contenu AS contenu_3,
  j0_.updated AS updated_4,
  j0_.date AS date_5,
  j0_.heure_debut AS heure_debut_6,
  j0_.heure_fin AS heure_fin_7,
  j0_.file_name AS file_name_8,
  j0_.file_size AS file_size_9,
  j0_.legende AS legende_10,
  j0_.id AS id_11,
  j0_.image1_name AS image1_name_12,
  j0_.image1_original_name AS image1_original_name_13,
  j0_.image1_mime_type AS image1_mime_type_14,
  j0_.image1_size AS image1_size_15,
  j0_.image1_dimensions AS image1_dimensions_16,
  j0_.image2_name AS image2_name_17,
  j0_.image2_original_name AS image2_original_name_18,
  j0_.image2_mime_type AS image2_mime_type_19,
  j0_.image2_size AS image2_size_20,
  j0_.image2_dimensions AS image2_dimensions_21,
  j0_.image3_name AS image3_name_22,
  j0_.image3_original_name AS image3_original_name_23,
  j0_.image3_mime_type AS image3_mime_type_24,
  j0_.image3_size AS image3_size_25,
  j0_.image3_dimensions AS image3_dimensions_26,
  j0_.etablissement_id AS etablissement_id_27
FROM
  jpo j0_
  INNER JOIN etablissement e1_ ON j0_.etablissement_id = e1_.id
  INNER JOIN ville v2_ ON e1_.ville_id = v2_.id
  INNER JOIN departement d3_ ON v2_.departement_id = d3_.id
  INNER JOIN ancienne_region a4_ ON d3_.ancienne_region_id = a4_.id
  INNER JOIN region r5_ ON a4_.region_id = r5_.id
WHERE
  j0_.date >= ?
  AND d3_.id = ?
ORDER BY
  j0_.date ASC
LIMIT
  900

SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ INNER JOIN etablissement e1_ ON j0_.etablissement_id = e1_.id INNER JOIN ville v2_ ON e1_.ville_id = v2_.id INNER JOIN departement d3_ ON v2_.departement_id = d3_.id INNER JOIN ancienne_region a4_ ON d3_.ancienne_region_id = a4_.id INNER JOIN region r5_ ON a4_.region_id = r5_.id WHERE j0_.date >= '2026-09-10' AND d3_.id = '69' ORDER BY j0_.date ASC LIMIT 900;

SELECT
  s0_.id AS id_0,
  s0_.formation AS formation_1,
  s0_.secteur AS secteur_2,
  s0_.diplome AS diplome_3,
  s0_.titre_national AS titre_national_4,
  s0_.texte_national AS texte_national_5,
  s0_.titre_regional AS titre_regional_6,
  s0_.texte_regional AS texte_regional_7,
  s0_.titre_departemental AS titre_departemental_8,
  s0_.texte_departemental AS texte_departemental_9,
  s0_.titre_ville AS titre_ville_10,
  s0_.texte_ville AS texte_ville_11
FROM
  seo_texte_referencement_diplome s0_
WHERE
  s0_.formation = ?
  AND s0_.diplome IS NULL
  AND s0_.secteur IS NULL

SELECT s0_.id AS id_0, s0_.formation AS formation_1, s0_.secteur AS secteur_2, s0_.diplome AS diplome_3, s0_.titre_national AS titre_national_4, s0_.texte_national AS texte_national_5, s0_.titre_regional AS titre_regional_6, s0_.texte_regional AS texte_regional_7, s0_.titre_departemental AS titre_departemental_8, s0_.texte_departemental AS texte_departemental_9, s0_.titre_ville AS titre_ville_10, s0_.texte_ville AS texte_ville_11 FROM seo_texte_referencement_diplome s0_ WHERE s0_.formation = 'jpo' AND s0_.diplome IS NULL AND s0_.secteur IS NULL;

SELECT
  j0_.date_publidation AS date_publidation_0,
  j0_.date_actualisation AS date_actualisation_1,
  j0_.lieu AS lieu_2,
  j0_.contenu AS contenu_3,
  j0_.updated AS updated_4,
  j0_.date AS date_5,
  j0_.heure_debut AS heure_debut_6,
  j0_.heure_fin AS heure_fin_7,
  j0_.file_name AS file_name_8,
  j0_.file_size AS file_size_9,
  j0_.legende AS legende_10,
  j0_.id AS id_11,
  j0_.image1_name AS image1_name_12,
  j0_.image1_original_name AS image1_original_name_13,
  j0_.image1_mime_type AS image1_mime_type_14,
  j0_.image1_size AS image1_size_15,
  j0_.image1_dimensions AS image1_dimensions_16,
  j0_.image2_name AS image2_name_17,
  j0_.image2_original_name AS image2_original_name_18,
  j0_.image2_mime_type AS image2_mime_type_19,
  j0_.image2_size AS image2_size_20,
  j0_.image2_dimensions AS image2_dimensions_21,
  j0_.image3_name AS image3_name_22,
  j0_.image3_original_name AS image3_original_name_23,
  j0_.image3_mime_type AS image3_mime_type_24,
  j0_.image3_size AS image3_size_25,
  j0_.image3_dimensions AS image3_dimensions_26,
  j0_.etablissement_id AS etablissement_id_27
FROM
  jpo j0_
  INNER JOIN etablissement e1_ ON j0_.etablissement_id = e1_.id
WHERE
  e1_.jpo_plus = 1
  AND j0_.date >= ?
ORDER BY
  j0_.date ASC
LIMIT
  35

SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ INNER JOIN etablissement e1_ ON j0_.etablissement_id = e1_.id WHERE e1_.jpo_plus = 1 AND j0_.date >= '2026-09-10' ORDER BY j0_.date ASC LIMIT 35;