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_.onglets LIKE ?
  AND r0_.ancienne IS NULL
  AND r0_.libelle IS NOT NULL
  AND r0_.slug IS NOT NULL
ORDER BY
  r0_.pays_id DESC,
  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_.onglets LIKE '%superieur%' AND r0_.ancienne IS NULL AND r0_.libelle IS NOT NULL AND r0_.slug IS NOT NULL ORDER BY r0_.pays_id DESC, 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 = 'GRAN';

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_.onglets LIKE ?
  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 = 'GRAN' AND d0_.onglets LIKE '%superieur%' AND d0_.id <> 'BE' ORDER BY d0_.libelle ASC;

SELECT
  v0_.slug AS slug_0,
  v0_.libelle AS libelle_1,
  v0_.code_postal AS code_postal_2,
  v0_.email_delegue AS email_delegue_3,
  v0_.onglets AS onglets_4,
  v0_.id AS id_5,
  v0_.maj AS maj_6,
  v1_.latitude AS latitude_7,
  v1_.longitude AS longitude_8,
  v1_.id AS id_9
FROM
  ville v0_
  LEFT JOIN ville_coordonnees v1_ ON v0_.id = v1_.ville_id
WHERE
  v0_.libelle IS NOT NULL
  AND v0_.departement_id = ?
  AND v0_.onglets LIKE ?
  AND v0_.id IN (?)
ORDER BY
  v0_.libelle ASC

SELECT v0_.slug AS slug_0, v0_.libelle AS libelle_1, v0_.code_postal AS code_postal_2, v0_.email_delegue AS email_delegue_3, v0_.onglets AS onglets_4, v0_.id AS id_5, v0_.maj AS maj_6, v1_.latitude AS latitude_7, v1_.longitude AS longitude_8, v1_.id AS id_9 FROM ville v0_ LEFT JOIN ville_coordonnees v1_ ON v0_.id = v1_.ville_id WHERE v0_.libelle IS NOT NULL AND v0_.departement_id = '51' AND v0_.onglets LIKE '%superieur%' AND v0_.id IN (NULL) ORDER BY v0_.libelle ASC;

SELECT
  i0_.libelle AS libelle_0,
  i0_.libelle_mep AS libelle_mep_1,
  i0_.texte_defaut AS texte_defaut_2,
  i0_.onglet AS onglet_3,
  i0_.niveau AS niveau_4,
  i0_.formation AS formation_5,
  i0_.options AS options_6,
  i0_.libelle_web AS libelle_web_7,
  i0_.id AS id_8,
  i0_.maj AS maj_9
FROM
  items i0_
  INNER JOIN items_insertion i1_ ON (i0_.id = i1_.pere)
WHERE
  i0_.formation = 'oui'
  AND i0_.niveau = 3
  AND i0_.id LIKE ?
  AND i0_.id IN (?)
GROUP BY
  i0_.id
ORDER BY
  i0_.libelle ASC

SELECT i0_.libelle AS libelle_0, i0_.libelle_mep AS libelle_mep_1, i0_.texte_defaut AS texte_defaut_2, i0_.onglet AS onglet_3, i0_.niveau AS niveau_4, i0_.formation AS formation_5, i0_.options AS options_6, i0_.libelle_web AS libelle_web_7, i0_.id AS id_8, i0_.maj AS maj_9 FROM items i0_ INNER JOIN items_insertion i1_ ON (i0_.id = i1_.pere) WHERE i0_.formation = 'oui' AND i0_.niveau = 3 AND i0_.id LIKE 'PBAC-FPC-%' AND i0_.id IN (NULL) GROUP BY i0_.id ORDER BY i0_.libelle ASC;

SELECT
  i0_.libelle AS libelle_0,
  i0_.libelle_mep AS libelle_mep_1,
  i0_.texte_defaut AS texte_defaut_2,
  i0_.onglet AS onglet_3,
  i0_.niveau AS niveau_4,
  i0_.formation AS formation_5,
  i0_.options AS options_6,
  i0_.libelle_web AS libelle_web_7,
  i0_.id AS id_8,
  i0_.maj AS maj_9
FROM
  items i0_
WHERE
  i0_.niveau = 4
  AND i0_.id LIKE ?
  AND i0_.id IN (?)
ORDER BY
  i0_.libelle ASC

SELECT i0_.libelle AS libelle_0, i0_.libelle_mep AS libelle_mep_1, i0_.texte_defaut AS texte_defaut_2, i0_.onglet AS onglet_3, i0_.niveau AS niveau_4, i0_.formation AS formation_5, i0_.options AS options_6, i0_.libelle_web AS libelle_web_7, i0_.id AS id_8, i0_.maj AS maj_9 FROM items i0_ WHERE i0_.niveau = 4 AND i0_.id LIKE 'LYC-FORMA2021-SPEC-%' AND i0_.id IN (NULL) ORDER BY i0_.libelle ASC;

SELECT
  i0_.identifiant AS identifiant_0,
  i0_.onglet AS onglet_1,
  i0_.libelle AS libelle_2,
  i0_.options AS options_3,
  i0_.niveau AS niveau_4,
  i0_.pere AS pere_5,
  i0_.libelle_specifique AS libelle_specifique_6,
  i0_.options_specifique AS options_specifique_7,
  i0_.texte AS texte_8,
  i0_.tri AS tri_9,
  i0_.complement_texte AS complement_texte_10,
  i0_.complement_url_libelle AS complement_url_libelle_11,
  i0_.complement_url AS complement_url_12,
  i0_.complement_updated_at AS complement_updated_at_13,
  i0_.libelle_mep AS libelle_mep_14,
  i0_.slug AS slug_15,
  i0_.formation AS formation_16,
  i0_.ligne_secours AS ligne_secours_17,
  i0_.updated_at AS updated_at_18,
  i0_.diplome_plus AS diplome_plus_19,
  i0_.valeur AS valeur_20,
  i0_.id AS id_21,
  i0_.etablissement_id AS etablissement_id_22
FROM
  items_insertion i0_
WHERE
  i0_.identifiant LIKE ?
  OR i0_.slug LIKE ?
LIMIT
  1

SELECT i0_.identifiant AS identifiant_0, i0_.onglet AS onglet_1, i0_.libelle AS libelle_2, i0_.options AS options_3, i0_.niveau AS niveau_4, i0_.pere AS pere_5, i0_.libelle_specifique AS libelle_specifique_6, i0_.options_specifique AS options_specifique_7, i0_.texte AS texte_8, i0_.tri AS tri_9, i0_.complement_texte AS complement_texte_10, i0_.complement_url_libelle AS complement_url_libelle_11, i0_.complement_url AS complement_url_12, i0_.complement_updated_at AS complement_updated_at_13, i0_.libelle_mep AS libelle_mep_14, i0_.slug AS slug_15, i0_.formation AS formation_16, i0_.ligne_secours AS ligne_secours_17, i0_.updated_at AS updated_at_18, i0_.diplome_plus AS diplome_plus_19, i0_.valeur AS valeur_20, i0_.id AS id_21, i0_.etablissement_id AS etablissement_id_22 FROM items_insertion i0_ WHERE i0_.identifiant LIKE 'formation-professionnelle-continue%' OR i0_.slug LIKE 'formation-professionnelle-continue%' LIMIT 1;