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
  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.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 ('13028', '13206', '13210', '13212', '13216') ORDER BY t0.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 = '13' AND v0_.onglets LIKE '%superieur%' AND v0_.id IN ('13028', '13206', '13210', '13212', '13216') 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_.identifiant)
WHERE
  i0_.formation = 'oui'
  AND i0_.niveau = 4
  AND i0_.id IN (?)
  AND i0_.id LIKE 'PBAC-BAC2-SASO%'
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-SASO', 'PBAC-COORD', 'PBAC-COORD-ADR', 'PBAC-COORD-MAIL', 'PBAC-COORD-TEL', 'PBAC-COORD-WEB', 'PBAC-PRES', 'PBAC-BAC2-CDV', 'PBAC', 'PBAC-ACCU', 'PBAC-BAC2-GADF', 'PBAC-BAC3-CDV', 'PBAC-COORD-FAX', 'PBAC-PRES-DTEUR', 'PBAC-ACCU-HAND_MT', 'PBAC-BAC2-CDV-BTSNE', 'PBAC-BAC2-GADF-BTSGE', 'PBAC-BAC2-SPOR', 'PBAC-BAC2-SPOR-BTSTOU', 'PBAC-BAC3-GADF', 'PBAC-BAC3-SASO', 'PBAC-BAC45-GADF', 'PBAC-LOGO', 'PBAC-PRES-DTRICE', 'PBAC-PRES-NID', 'PBAC-PRES-SCO', 'PBAC-PRES-TXTS', 'PBAC-TARIFS', 'PBAC-TARIFS-INSC', 'PBAC-TARIFS-MODAL', 'PBAC-TARIFS-RCOMPL', 'PBAC-ACCU-ACCE', 'PBAC-ACCU-BOUR', 'PBAC-ACCU-CAF', 'PBAC-ACCU-CANT', 'PBAC-ACCU-HEB', 'PBAC-ACCU-INTA', 'PBAC-ACCU-TXTS53', 'PBAC-BAC2', 'PBAC-BAC2-CDV-BTSCO', 'PBAC-BAC2-CDV-BTSCOMI', 'PBAC-BAC2-CDV-BTSMA', 'PBAC-BAC2-CDV-TITRE2', 'PBAC-BAC2-CHI', 'PBAC-BAC2-CHI-BTSME0', 'PBAC-BAC2-ENS', 'PBAC-BAC2-ENS-TPFOR', 'PBAC-BAC2-GADF-BTSCO', 'PBAC-BAC2-GADF-TITRE', 'PBAC-BAC2-GADF-TITRE0', 'PBAC-BAC2-GADF-TITRE1', 'PBAC-BAC2-GADF-TITRE6', 'PBAC-BAC2-SASO-BTSDIE', 'PBAC-BAC2-SASO-BTSDTS', 'PBAC-BAC2-SASO-BTSESF', 'PBAC-BAC2-SASO-BTSOPT', 'PBAC-BAC2-SASO-BTSSASO', 'PBAC-BAC2-SASO-TITRE0', 'PBAC-BAC2-TRAN', 'PBAC-BAC2-TRAN-BTSGE', 'PBAC-BAC2-TXTS0', 'PBAC-BAC3', 'PBAC-BAC3-CDV-BGB', 'PBAC-BAC3-CDV-BGMC', 'PBAC-BAC3-CDV-RESPO10', 'PBAC-BAC3-CDV-RESPO7', 'PBAC-BAC3-CDV-RESPO8', 'PBAC-BAC3-CDV-RESPO9', 'PBAC-BAC3-CDV-TITRE4', 'PBAC-BAC3-CULT', 'PBAC-BAC3-CULT-IHTM', 'PBAC-BAC3-GADF-CERTI0', 'PBAC-BAC3-GADF-DCG', 'PBAC-BAC3-PUB', 'PBAC-BAC3-PUB-BACHE2', 'PBAC-BAC3-SASO-CESF', 'PBAC-BAC3-SASO-LICEN', 'PBAC-BAC3-TXTS0', 'PBAC-BAC45', 'PBAC-BAC45-GADF-DSCG', 'PBAC-BAC45-GADF-MANAG0', 'PBAC-BAC45-TXTS0', 'PBAC-PREPA-COM', 'PBAC-PREPA-COM-CGPEECE', 'PBAC-SPEC', 'PBAC-SPEC-IGEN', 'PBAC-TARIFS-INSC-BAC+2', 'PBAC-TARIFS-INSC-BAC+3', 'PBAC-TEXTC1_MT') AND i0_.id LIKE 'PBAC-BAC2-SASO%' 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 = 'aix-en-provence-13090' 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
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 = 'PROV' AND d0_.onglets LIKE '%superieur%' AND d0_.id <> 'BE' ORDER BY d0_.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
  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
  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-SASO', 'PBAC-COORD', 'PBAC-COORD-ADR', 'PBAC-COORD-MAIL', 'PBAC-COORD-TEL', 'PBAC-COORD-WEB', 'PBAC-PRES', 'PBAC-BAC2-CDV', 'PBAC', 'PBAC-ACCU', 'PBAC-BAC2-GADF', 'PBAC-BAC3-CDV', 'PBAC-COORD-FAX', 'PBAC-PRES-DTEUR', 'PBAC-ACCU-HAND_MT', 'PBAC-BAC2-CDV-BTSNE', 'PBAC-BAC2-GADF-BTSGE', 'PBAC-BAC2-SPOR', 'PBAC-BAC2-SPOR-BTSTOU', 'PBAC-BAC3-GADF', 'PBAC-BAC3-SASO', 'PBAC-BAC45-GADF', 'PBAC-LOGO', 'PBAC-PRES-DTRICE', 'PBAC-PRES-NID', 'PBAC-PRES-SCO', 'PBAC-PRES-TXTS', 'PBAC-TARIFS', 'PBAC-TARIFS-INSC', 'PBAC-TARIFS-MODAL', 'PBAC-TARIFS-RCOMPL', 'PBAC-ACCU-ACCE', 'PBAC-ACCU-BOUR', 'PBAC-ACCU-CAF', 'PBAC-ACCU-CANT', 'PBAC-ACCU-HEB', 'PBAC-ACCU-INTA', 'PBAC-ACCU-TXTS53', 'PBAC-BAC2', 'PBAC-BAC2-CDV-BTSCO', 'PBAC-BAC2-CDV-BTSCOMI', 'PBAC-BAC2-CDV-BTSMA', 'PBAC-BAC2-CDV-TITRE2', 'PBAC-BAC2-CHI', 'PBAC-BAC2-CHI-BTSME0', 'PBAC-BAC2-ENS', 'PBAC-BAC2-ENS-TPFOR', 'PBAC-BAC2-GADF-BTSCO', 'PBAC-BAC2-GADF-TITRE', 'PBAC-BAC2-GADF-TITRE0', 'PBAC-BAC2-GADF-TITRE1', 'PBAC-BAC2-GADF-TITRE6', 'PBAC-BAC2-SASO-BTSDIE', 'PBAC-BAC2-SASO-BTSDTS', 'PBAC-BAC2-SASO-BTSESF', 'PBAC-BAC2-SASO-BTSOPT', 'PBAC-BAC2-SASO-BTSSASO', 'PBAC-BAC2-SASO-TITRE0', 'PBAC-BAC2-TRAN', 'PBAC-BAC2-TRAN-BTSGE', 'PBAC-BAC2-TXTS0', 'PBAC-BAC3', 'PBAC-BAC3-CDV-BGB', 'PBAC-BAC3-CDV-BGMC', 'PBAC-BAC3-CDV-RESPO10', 'PBAC-BAC3-CDV-RESPO7', 'PBAC-BAC3-CDV-RESPO8', 'PBAC-BAC3-CDV-RESPO9', 'PBAC-BAC3-CDV-TITRE4', 'PBAC-BAC3-CULT', 'PBAC-BAC3-CULT-IHTM', 'PBAC-BAC3-GADF-CERTI0', 'PBAC-BAC3-GADF-DCG', 'PBAC-BAC3-PUB', 'PBAC-BAC3-PUB-BACHE2', 'PBAC-BAC3-SASO-CESF', 'PBAC-BAC3-SASO-LICEN', 'PBAC-BAC3-TXTS0', 'PBAC-BAC45', 'PBAC-BAC45-GADF-DSCG', 'PBAC-BAC45-GADF-MANAG0', 'PBAC-BAC45-TXTS0', 'PBAC-PREPA-COM', 'PBAC-PREPA-COM-CGPEECE', 'PBAC-SPEC', 'PBAC-SPEC-IGEN', 'PBAC-TARIFS-INSC-BAC+2', 'PBAC-TARIFS-INSC-BAC+3', 'PBAC-TEXTC1_MT') GROUP BY i0_.id 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 '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_;