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,
  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
  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
  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 = 'noisiel-77186' LIMIT 1;

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 = 'ILED' 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 = '77' AND v0_.onglets LIKE '%superieur%' AND v0_.id IN ('77288') ORDER BY v0_.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 ('77288') ORDER BY t0.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-BAC3-%' AND i0_.id IN ('PBAC-BAC2-CDV', 'PBAC-BAC2-CDV-BTSMA', 'PBAC-BAC2-CDV-BTSNE', 'PBAC-BAC2-GADF', 'PBAC-BAC2-GADF-BTSCO', 'PBAC-BAC2-GADF-BTSGE', 'PBAC-BAC2-GADF-BTSSU', 'PBAC-BAC2-WEB', 'PBAC-BAC2-WEB-BTSINFR', 'PBAC-BAC2-WEB-BTSSLAM', 'PBAC-BAC3-CDV', 'PBAC-BAC3-CDV-BACHE16', 'PBAC-BAC3-CDV-LICEN2', 'PBAC-BAC3-GADF', 'PBAC-BAC3-GADF-BACHE', 'PBAC-BAC3-GADF-GESTEN', 'PBAC-BAC3-GADF-LP35', 'PBAC-BAC3-WEB', 'PBAC-BAC3-WEB-BACHE4', 'PBAC-BAC3-WEB-INF', 'PBAC-BAC45-CDV', 'PBAC-BAC45-CDV-MASTE2', 'PBAC-BAC45-GADF', 'PBAC-BAC45-GADF-CONTR', 'PBAC-BAC45-GADF-MANAG0', 'PBAC-BAC45-INF', 'PBAC-BAC45-INF-MASTE3', 'LYC-ACCU', 'LYC-ACCU-ACCE', 'LYC-ACCU-BOUR', 'LYC-ACCU-CAF', 'LYC-ACCU-CANT', 'LYC-ACCU-EXT', 'LYC-ACCU-MIXT', 'LYC-BACTEC', 'LYC-BACTEC-CDV', 'LYC-BACTEC-CDV-STMG', 'LYC-BACTEC-GADF', 'LYC-BACTEC-GADF-STMGGF', 'LYC-BACTEC-GADF-STMGRHC', 'LYC-BACTEC-TFACU', 'LYC-BACTEC-TFACU-ARTS', 'LYC-BACTEC-TFACU-LV3', 'LYC-BACTEC-WEB', 'LYC-BACTEC-WEB-STMGSIG', 'LYC-COORD', 'LYC-COORD-ADR', 'LYC-COORD-MAIL', 'LYC-COORD-TEL', 'LYC-COORD-WEB', 'LYC-FORMA2021', 'LYC-FORMA2021-GFACU', 'LYC-FORMA2021-GFACU-GFACUARTS', 'LYC-FORMA2021-GFACU-GFACUDROI', 'LYC-FORMA2021-GFACU-GFACUEPS', 'LYC-FORMA2021-GFACU-GFACULANG', 'LYC-FORMA2021-GFACU-GFACULV3', 'LYC-FORMA2021-GFACU-GFACUMATC', 'LYC-FORMA2021-GFACU-GFACUMATE', 'LYC-FORMA2021-SPEC', 'LYC-FORMA2021-SPEC-SPECHIST', 'LYC-FORMA2021-SPEC-SPECHUM', 'LYC-FORMA2021-SPEC-SPECLANG', 'LYC-FORMA2021-SPEC-SPECMAT', 'LYC-FORMA2021-SPEC-SPECNUM', 'LYC-FORMA2021-SPEC-SPECPHY', 'LYC-FORMA2021-SPEC-SPECSES', 'LYC-FORMA2021-SPEC-SPECSVT', 'LYC-LANG', 'LYC-LANG-ANC_MT', 'LYC-LANG-ANC_MT-LAT', 'LYC-LANG-CERT', 'LYC-LANG-EUR', 'LYC-LANG-LV1', 'LYC-LANG-LV1-ANG', 'LYC-LANG-LV2', 'LYC-LANG-LV2-ALL', 'LYC-LANG-LV2-ESP', 'LYC-LANG-LV2-ITA', 'LYC-LANG-LV3', 'LYC-LANG-LV3-CHI', 'LYC-LANG-LV3-ITA', 'LYC-PRES', 'LYC-PRES-CHE', 'LYC-PRES-NBE', 'LYC-PRES-NID', 'LYC-PRES-SCO', 'LYC-PRES-TUT', 'LYC-SPEC', 'LYC-SPEC-2SGT', 'LYC-SPEC-ACC', 'LYC-SPEC-ACC-ULIS', 'LYC-SPEC-ART', 'LYC-SPEC-ASPO', 'LYC-SPEC-BDI', 'LYC-SPEC-BIA', 'LYC-SPEC-CDI', 'LYC-SPEC-EXP', 'LYC-SPEC-JUM', 'LYC-SPEC-PIX', 'LYC-SPEC-PREP', 'LYC-SPEC-PSC1', 'LYC-SPEC-REPA', 'LYC-SPEC-SCI', 'LYC-SPEC-SLIN', 'LYC-SPEC-SPOR', 'LYC-SPEC-TXTS32', 'LYC-SPEC-TXTS33', 'LYC-SPEC-TXTS40', 'LYC-SPEC-VOY', 'LYCPRO-ACCU', 'LYCPRO-ACCU-ACCE', 'LYCPRO-ACCU-BOUR', 'LYCPRO-ACCU-CAF', 'LYCPRO-ACCU-CANT', 'LYCPRO-ACCU-EXT', 'LYCPRO-ACCU-MIXT', 'LYCPRO-BACP-DISTRI', 'LYCPRO-BACP-DISTRI-BACPR2', 'LYCPRO-BACP-DISTRI-BACPR3', 'LYCPRO-BACP-INF', 'LYCPRO-BACP-INF-BACPR0', 'LYCPRO-BACP-TEXT', 'LYCPRO-BACP-TEXT-BPRCOS', 'LYCPRO-COORD', 'LYCPRO-COORD-ADR', 'LYCPRO-COORD-FAX', 'LYCPRO-COORD-MAIL', 'LYCPRO-COORD-TEL', 'LYCPRO-COORD-WEB', 'LYCPRO-LANG', 'LYCPRO-LANG-LV1', 'LYCPRO-LANG-LV1-ANG', 'LYCPRO-LANG-LV2', 'LYCPRO-LANG-LV2-ALL', 'LYCPRO-LANG-LV2-ESP', 'LYCPRO-LANG-LV2-ITA', 'LYCPRO-PRES', 'LYCPRO-PRES-CHE', 'LYCPRO-PRES-NBE', 'LYCPRO-PRES-NID', 'LYCPRO-PRES-SCO', 'LYCPRO-PRES-TUT', 'LYCPRO-SPEC', 'LYCPRO-SPEC-ACC', 'LYCPRO-SPEC-ACC-ULIS', 'LYCPRO-SPEC-ASPO', 'LYCPRO-SPEC-BDI', 'LYCPRO-SPEC-BIA', 'LYCPRO-SPEC-CDI', 'LYCPRO-SPEC-CUL', 'LYCPRO-SPEC-EUR', 'LYCPRO-SPEC-PIX', 'LYCPRO-SPEC-PMET', 'LYCPRO-SPEC-SLIN', 'LYCPRO-SPEC-TXTS50', 'LYCPRO-SPEC-VOY', 'PBAC-ACCU', 'PBAC-ACCU-ACCE', 'PBAC-ACCU-BOUR', 'PBAC-ACCU-CAF', 'PBAC-ACCU-CANT', 'PBAC-ACCU-EXT', 'PBAC-BAC2', 'PBAC-BAC2-TXTS0', 'PBAC-BAC3', 'PBAC-BAC3-TXTS0', 'PBAC-BAC45', 'PBAC-BAC45-TXTS0', 'PBAC-COORD', 'PBAC-COORD-ADR', 'PBAC-COORD-MAIL', 'PBAC-COORD-TEL', 'PBAC-COORD-WEB', 'PBAC-PRES', 'PBAC-PRES-CHE', 'PBAC-PRES-NBE', 'PBAC-PRES-NID', 'PBAC-PRES-SCO', 'PBAC-SPEC', 'PBAC-SPEC-ADMI') 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_.identifiant)
WHERE
  i0_.formation = 'oui'
  AND i0_.niveau = 4
  AND i0_.id IN (?)
  AND i0_.id LIKE 'PBAC-BAC3-WEB%'
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-CDV', 'PBAC-BAC2-CDV-BTSMA', 'PBAC-BAC2-CDV-BTSNE', 'PBAC-BAC2-GADF', 'PBAC-BAC2-GADF-BTSCO', 'PBAC-BAC2-GADF-BTSGE', 'PBAC-BAC2-GADF-BTSSU', 'PBAC-BAC2-WEB', 'PBAC-BAC2-WEB-BTSINFR', 'PBAC-BAC2-WEB-BTSSLAM', 'PBAC-BAC3-CDV', 'PBAC-BAC3-CDV-BACHE16', 'PBAC-BAC3-CDV-LICEN2', 'PBAC-BAC3-GADF', 'PBAC-BAC3-GADF-BACHE', 'PBAC-BAC3-GADF-GESTEN', 'PBAC-BAC3-GADF-LP35', 'PBAC-BAC3-WEB', 'PBAC-BAC3-WEB-BACHE4', 'PBAC-BAC3-WEB-INF', 'PBAC-BAC45-CDV', 'PBAC-BAC45-CDV-MASTE2', 'PBAC-BAC45-GADF', 'PBAC-BAC45-GADF-CONTR', 'PBAC-BAC45-GADF-MANAG0', 'PBAC-BAC45-INF', 'PBAC-BAC45-INF-MASTE3', 'LYC-ACCU', 'LYC-ACCU-ACCE', 'LYC-ACCU-BOUR', 'LYC-ACCU-CAF', 'LYC-ACCU-CANT', 'LYC-ACCU-EXT', 'LYC-ACCU-MIXT', 'LYC-BACTEC', 'LYC-BACTEC-CDV', 'LYC-BACTEC-CDV-STMG', 'LYC-BACTEC-GADF', 'LYC-BACTEC-GADF-STMGGF', 'LYC-BACTEC-GADF-STMGRHC', 'LYC-BACTEC-TFACU', 'LYC-BACTEC-TFACU-ARTS', 'LYC-BACTEC-TFACU-LV3', 'LYC-BACTEC-WEB', 'LYC-BACTEC-WEB-STMGSIG', 'LYC-COORD', 'LYC-COORD-ADR', 'LYC-COORD-MAIL', 'LYC-COORD-TEL', 'LYC-COORD-WEB', 'LYC-FORMA2021', 'LYC-FORMA2021-GFACU', 'LYC-FORMA2021-GFACU-GFACUARTS', 'LYC-FORMA2021-GFACU-GFACUDROI', 'LYC-FORMA2021-GFACU-GFACUEPS', 'LYC-FORMA2021-GFACU-GFACULANG', 'LYC-FORMA2021-GFACU-GFACULV3', 'LYC-FORMA2021-GFACU-GFACUMATC', 'LYC-FORMA2021-GFACU-GFACUMATE', 'LYC-FORMA2021-SPEC', 'LYC-FORMA2021-SPEC-SPECHIST', 'LYC-FORMA2021-SPEC-SPECHUM', 'LYC-FORMA2021-SPEC-SPECLANG', 'LYC-FORMA2021-SPEC-SPECMAT', 'LYC-FORMA2021-SPEC-SPECNUM', 'LYC-FORMA2021-SPEC-SPECPHY', 'LYC-FORMA2021-SPEC-SPECSES', 'LYC-FORMA2021-SPEC-SPECSVT', 'LYC-LANG', 'LYC-LANG-ANC_MT', 'LYC-LANG-ANC_MT-LAT', 'LYC-LANG-CERT', 'LYC-LANG-EUR', 'LYC-LANG-LV1', 'LYC-LANG-LV1-ANG', 'LYC-LANG-LV2', 'LYC-LANG-LV2-ALL', 'LYC-LANG-LV2-ESP', 'LYC-LANG-LV2-ITA', 'LYC-LANG-LV3', 'LYC-LANG-LV3-CHI', 'LYC-LANG-LV3-ITA', 'LYC-PRES', 'LYC-PRES-CHE', 'LYC-PRES-NBE', 'LYC-PRES-NID', 'LYC-PRES-SCO', 'LYC-PRES-TUT', 'LYC-SPEC', 'LYC-SPEC-2SGT', 'LYC-SPEC-ACC', 'LYC-SPEC-ACC-ULIS', 'LYC-SPEC-ART', 'LYC-SPEC-ASPO', 'LYC-SPEC-BDI', 'LYC-SPEC-BIA', 'LYC-SPEC-CDI', 'LYC-SPEC-EXP', 'LYC-SPEC-JUM', 'LYC-SPEC-PIX', 'LYC-SPEC-PREP', 'LYC-SPEC-PSC1', 'LYC-SPEC-REPA', 'LYC-SPEC-SCI', 'LYC-SPEC-SLIN', 'LYC-SPEC-SPOR', 'LYC-SPEC-TXTS32', 'LYC-SPEC-TXTS33', 'LYC-SPEC-TXTS40', 'LYC-SPEC-VOY', 'LYCPRO-ACCU', 'LYCPRO-ACCU-ACCE', 'LYCPRO-ACCU-BOUR', 'LYCPRO-ACCU-CAF', 'LYCPRO-ACCU-CANT', 'LYCPRO-ACCU-EXT', 'LYCPRO-ACCU-MIXT', 'LYCPRO-BACP-DISTRI', 'LYCPRO-BACP-DISTRI-BACPR2', 'LYCPRO-BACP-DISTRI-BACPR3', 'LYCPRO-BACP-INF', 'LYCPRO-BACP-INF-BACPR0', 'LYCPRO-BACP-TEXT', 'LYCPRO-BACP-TEXT-BPRCOS', 'LYCPRO-COORD', 'LYCPRO-COORD-ADR', 'LYCPRO-COORD-FAX', 'LYCPRO-COORD-MAIL', 'LYCPRO-COORD-TEL', 'LYCPRO-COORD-WEB', 'LYCPRO-LANG', 'LYCPRO-LANG-LV1', 'LYCPRO-LANG-LV1-ANG', 'LYCPRO-LANG-LV2', 'LYCPRO-LANG-LV2-ALL', 'LYCPRO-LANG-LV2-ESP', 'LYCPRO-LANG-LV2-ITA', 'LYCPRO-PRES', 'LYCPRO-PRES-CHE', 'LYCPRO-PRES-NBE', 'LYCPRO-PRES-NID', 'LYCPRO-PRES-SCO', 'LYCPRO-PRES-TUT', 'LYCPRO-SPEC', 'LYCPRO-SPEC-ACC', 'LYCPRO-SPEC-ACC-ULIS', 'LYCPRO-SPEC-ASPO', 'LYCPRO-SPEC-BDI', 'LYCPRO-SPEC-BIA', 'LYCPRO-SPEC-CDI', 'LYCPRO-SPEC-CUL', 'LYCPRO-SPEC-EUR', 'LYCPRO-SPEC-PIX', 'LYCPRO-SPEC-PMET', 'LYCPRO-SPEC-SLIN', 'LYCPRO-SPEC-TXTS50', 'LYCPRO-SPEC-VOY', 'PBAC-ACCU', 'PBAC-ACCU-ACCE', 'PBAC-ACCU-BOUR', 'PBAC-ACCU-CAF', 'PBAC-ACCU-CANT', 'PBAC-ACCU-EXT', 'PBAC-BAC2', 'PBAC-BAC2-TXTS0', 'PBAC-BAC3', 'PBAC-BAC3-TXTS0', 'PBAC-BAC45', 'PBAC-BAC45-TXTS0', 'PBAC-COORD', 'PBAC-COORD-ADR', 'PBAC-COORD-MAIL', 'PBAC-COORD-TEL', 'PBAC-COORD-WEB', 'PBAC-PRES', 'PBAC-PRES-CHE', 'PBAC-PRES-NBE', 'PBAC-PRES-NID', 'PBAC-PRES-SCO', 'PBAC-SPEC', 'PBAC-SPEC-ADMI') AND i0_.id LIKE 'PBAC-BAC3-WEB%' 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 ('LYC-FORMA2021-SPEC-SPECHIST', 'LYC-FORMA2021-SPEC-SPECHUM', 'LYC-FORMA2021-SPEC-SPECLANG', 'LYC-FORMA2021-SPEC-SPECMAT', 'LYC-FORMA2021-SPEC-SPECNUM', 'LYC-FORMA2021-SPEC-SPECPHY', 'LYC-FORMA2021-SPEC-SPECSES', 'LYC-FORMA2021-SPEC-SPECSVT') 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-3-licence%' OR i0_.slug LIKE 'bac-3-licence%' LIMIT 1;