Symfony Profiler

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,
  r0_.pays_id AS pays_id_7
FROM
  region r0_

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, r0_.pays_id AS pays_id_7 FROM region r0_;

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_.identifiant)
WHERE
  i0_.formation = 'oui'
  AND i0_.niveau = 4
  AND i0_.id IN (?)
  AND i0_.id LIKE 'PBAC-BAC2-BAI%'
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_.identifiant) WHERE i0_.formation = 'oui' AND i0_.niveau = 4 AND i0_.id IN ('PBAC-BAC2-BAI', 'PBAC-BAC2-BAI-BTSPRI', 'PBAC-BAC2-CDV', 'PBAC-BAC2-CDV-BTSCO', 'PBAC-BAC2-CDV-BTSMA', 'PBAC-BAC2-CDV-BTSNE', 'LYC-ACCU', 'LYC-ACCU-ACCE', 'LYC-ACCU-CANT', 'LYC-ACCU-INTA', 'LYC-ACCU-MIXT', 'LYC-BACTEC-ELEC', 'LYC-BACTEC-ELEC-STI2D', 'LYC-BACTEC-ENEX', 'LYC-BACTEC-ENEX-STI2D', 'LYC-COORD', 'LYC-COORD-ADR', 'LYC-COORD-MAIL', 'LYC-COORD-TEL', 'LYC-COORD-WEB', 'LYC-LANG', 'LYC-LANG-LV1', 'LYC-LANG-LV1-ANG', 'LYC-LANG-LV2', 'LYC-LANG-LV2-ESP', 'LYC-PRES', 'LYC-PRES-DTEUR', 'LYC-PRES-NID', 'LYC-SPEC', 'LYC-SPEC-ART', 'LYC-SPEC-ASPO', 'LYC-SPEC-CDI', 'LYC-SPEC-EDU', 'LYC-SPEC-MULT', 'LYC-SPEC-TXTS31', 'LYC-SPEC-VOY', 'PBAC-COORD', 'PBAC-COORD-ADR', 'PBAC-COORD-MAIL', 'PBAC-COORD-TEL', 'PBAC-COORD-WEB') AND i0_.id LIKE 'PBAC-BAC2-BAI%' ORDER BY i0_.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,
  v0_.departement_id AS departement_id_10,
  v1_.ville_id AS ville_id_11
FROM
  ville v0_
  LEFT JOIN ville_coordonnees v1_ ON v0_.id = v1_.ville_id
WHERE
  v0_.slug = ?
LIMIT
  1

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, v0_.departement_id AS departement_id_10, v1_.ville_id AS ville_id_11 FROM ville v0_ LEFT JOIN ville_coordonnees v1_ ON v0_.id = v1_.ville_id WHERE v0_.slug = 'castelnau-le-lez-34170' LIMIT 1;

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
  t0.slug AS slug_1,
  t0.libelle AS libelle_2,
  t0.code_postal AS code_postal_3,
  t0.email_delegue AS email_delegue_4,
  t0.onglets AS onglets_5,
  t0.id AS id_6,
  t0.maj AS maj_7,
  t0.departement_id AS departement_id_8,
  t9.latitude AS latitude_10,
  t9.longitude AS longitude_11,
  t9.id AS id_12,
  t9.ville_id AS ville_id_13
FROM
  ville t0
  LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id
WHERE
  t0.id IN (?)
ORDER BY
  t0.libelle ASC

SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id IN ('34032') ORDER BY t0.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 'bac-2-bts%' OR i0_.slug LIKE 'bac-2-bts%' LIMIT 1;

SELECT
  a0_.slug AS slug_0,
  a0_.libelle AS libelle_1,
  a0_.id AS id_2,
  a0_.maj AS maj_3,
  a0_.region_id AS region_id_4
FROM
  ancienne_region a0_

SELECT a0_.slug AS slug_0, a0_.libelle AS libelle_1, a0_.id AS id_2, a0_.maj AS maj_3, a0_.region_id AS region_id_4 FROM ancienne_region a0_;

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-BAC2-%' AND i0_.id IN ('PBAC-BAC2-BAI', 'PBAC-BAC2-BAI-BTSPRI', 'PBAC-BAC2-CDV', 'PBAC-BAC2-CDV-BTSCO', 'PBAC-BAC2-CDV-BTSMA', 'PBAC-BAC2-CDV-BTSNE', 'LYC-ACCU', 'LYC-ACCU-ACCE', 'LYC-ACCU-CANT', 'LYC-ACCU-INTA', 'LYC-ACCU-MIXT', 'LYC-BACTEC-ELEC', 'LYC-BACTEC-ELEC-STI2D', 'LYC-BACTEC-ENEX', 'LYC-BACTEC-ENEX-STI2D', 'LYC-COORD', 'LYC-COORD-ADR', 'LYC-COORD-MAIL', 'LYC-COORD-TEL', 'LYC-COORD-WEB', 'LYC-LANG', 'LYC-LANG-LV1', 'LYC-LANG-LV1-ANG', 'LYC-LANG-LV2', 'LYC-LANG-LV2-ESP', 'LYC-PRES', 'LYC-PRES-DTEUR', 'LYC-PRES-NID', 'LYC-SPEC', 'LYC-SPEC-ART', 'LYC-SPEC-ASPO', 'LYC-SPEC-CDI', 'LYC-SPEC-EDU', 'LYC-SPEC-MULT', 'LYC-SPEC-TXTS31', 'LYC-SPEC-VOY', 'PBAC-COORD', 'PBAC-COORD-ADR', 'PBAC-COORD-MAIL', 'PBAC-COORD-TEL', 'PBAC-COORD-WEB') GROUP BY i0_.id ORDER BY i0_.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 = '34' AND v0_.onglets LIKE '%superieur%' AND v0_.id IN ('34032') 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_
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
  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
  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 = 'OCCI' AND d0_.onglets LIKE '%superieur%' AND d0_.id <> 'BE' ORDER BY d0_.libelle ASC;