Symfony Profiler

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 'saint-amand-les-eaux-59230%' OR i0_.slug LIKE 'saint-amand-les-eaux-59230%' LIMIT 1;

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-LANG-LV1-%' AND i0_.id IN ('LYC-LANG-LV1-ANG', 'LYC-LANG-LV1-ALL', 'LYC-LANG-LV1-ESP') 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 = 'saint-amand-les-eaux-59230' LIMIT 1;

SELECT
  t0.type AS type_1,
  t0.nombre_eleves AS nombre_eleves_2,
  t0.url AS url_3,
  t0.video AS video_4,
  t0.mots_cles AS mots_cles_5,
  t0.denomination AS denomination_6,
  t0.denomination_sigle AS denomination_sigle_7,
  t0.denomination_extension AS denomination_extension_8,
  t0.denomination_abregee AS denomination_abregee_9,
  t0.droit_page_web AS droit_page_web_10,
  t0.droit_actualite AS droit_actualite_11,
  t0.adresse1 AS adresse1_12,
  t0.adresse2 AS adresse2_13,
  t0.adresse3 AS adresse3_14,
  t0.code_postal AS code_postal_15,
  t0.cedex AS cedex_16,
  t0.latitude AS latitude_17,
  t0.longitude AS longitude_18,
  t0.telephone_principal AS telephone_principal_19,
  t0.fax AS fax_20,
  t0.email_principal AS email_principal_21,
  t0.logo_liste AS logo_liste_22,
  t0.logo_fiche AS logo_fiche_23,
  t0.diaporama_actif AS diaporama_actif_24,
  t0.images_diaporama AS images_diaporama_25,
  t0.participant AS participant_26,
  t0.catholique AS catholique_27,
  t0.age_admission AS age_admission_28,
  t0.actif AS actif_29,
  t0.internat AS internat_30,
  t0.has_internat AS has_internat_31,
  t0.types_internat AS types_internat_32,
  t0.sous_contrat AS sous_contrat_33,
  t0.alternance AS alternance_34,
  t0.type_client AS type_client_35,
  t0.bloque_txt_ref AS bloque_txt_ref_36,
  t0.facebook AS facebook_37,
  t0.bloque_bac2021 AS bloque_bac2021_38,
  t0.presence_web AS presence_web_39,
  t0.video_plus AS video_plus_40,
  t0.diapo_plus AS diapo_plus_41,
  t0.jpo_plus AS jpo_plus_42,
  t0.doc_plus AS doc_plus_43,
  t0.diplome_plus AS diplome_plus_44,
  t0.refus AS refus_45,
  t0.path AS path_46,
  t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47,
  t0.lva AS lva_48,
  t0.lvb AS lvb_49,
  t0.numero_administratif_uai AS numero_administratif_uai_50,
  t0.siret AS siret_51,
  t0.chiffres AS chiffres_52,
  t0.id AS id_53,
  t0.maj AS maj_54,
  t0.gestionnaire_id AS gestionnaire_id_55,
  t56.type AS type_57,
  t56.nombre_eleves AS nombre_eleves_58,
  t56.url AS url_59,
  t56.video AS video_60,
  t56.mots_cles AS mots_cles_61,
  t56.denomination AS denomination_62,
  t56.denomination_sigle AS denomination_sigle_63,
  t56.denomination_extension AS denomination_extension_64,
  t56.denomination_abregee AS denomination_abregee_65,
  t56.droit_page_web AS droit_page_web_66,
  t56.droit_actualite AS droit_actualite_67,
  t56.adresse1 AS adresse1_68,
  t56.adresse2 AS adresse2_69,
  t56.adresse3 AS adresse3_70,
  t56.code_postal AS code_postal_71,
  t56.cedex AS cedex_72,
  t56.latitude AS latitude_73,
  t56.longitude AS longitude_74,
  t56.telephone_principal AS telephone_principal_75,
  t56.fax AS fax_76,
  t56.email_principal AS email_principal_77,
  t56.logo_liste AS logo_liste_78,
  t56.logo_fiche AS logo_fiche_79,
  t56.diaporama_actif AS diaporama_actif_80,
  t56.images_diaporama AS images_diaporama_81,
  t56.participant AS participant_82,
  t56.catholique AS catholique_83,
  t56.age_admission AS age_admission_84,
  t56.actif AS actif_85,
  t56.internat AS internat_86,
  t56.has_internat AS has_internat_87,
  t56.types_internat AS types_internat_88,
  t56.sous_contrat AS sous_contrat_89,
  t56.alternance AS alternance_90,
  t56.type_client AS type_client_91,
  t56.bloque_txt_ref AS bloque_txt_ref_92,
  t56.facebook AS facebook_93,
  t56.bloque_bac2021 AS bloque_bac2021_94,
  t56.presence_web AS presence_web_95,
  t56.video_plus AS video_plus_96,
  t56.diapo_plus AS diapo_plus_97,
  t56.jpo_plus AS jpo_plus_98,
  t56.doc_plus AS doc_plus_99,
  t56.diplome_plus AS diplome_plus_100,
  t56.refus AS refus_101,
  t56.path AS path_102,
  t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103,
  t56.lva AS lva_104,
  t56.lvb AS lvb_105,
  t56.numero_administratif_uai AS numero_administratif_uai_106,
  t56.siret AS siret_107,
  t56.chiffres AS chiffres_108,
  t56.id AS id_109,
  t56.maj AS maj_110,
  t56.gestionnaire_id AS gestionnaire_id_111,
  t56.ville_id AS ville_id_112,
  t56.categorie_primaire_id AS categorie_primaire_id_113,
  t56.region_id AS region_id_114,
  t56.departement_id AS departement_id_115,
  t56.categorie_organisme_id AS categorie_organisme_id_116,
  t56.rubrique AS rubrique_117,
  t56.internat2_id AS internat2_id_118,
  t56.etablissement_lie_id AS etablissement_lie_id_119,
  t56.logo_id AS logo_id_120,
  t56.diapo_principal_id AS diapo_principal_id_121,
  t0.ville_id AS ville_id_122,
  t123.actif AS actif_124,
  t123.contenu AS contenu_125,
  t123.id AS id_126,
  t123.etablissement_id AS etablissement_id_127,
  t123.template_id AS template_id_128,
  t0.categorie_primaire_id AS categorie_primaire_id_129,
  t0.region_id AS region_id_130,
  t0.departement_id AS departement_id_131,
  t0.categorie_organisme_id AS categorie_organisme_id_132,
  t0.rubrique AS rubrique_133,
  t0.internat2_id AS internat2_id_134,
  t0.etablissement_lie_id AS etablissement_lie_id_135,
  t0.logo_id AS logo_id_136,
  t0.diapo_principal_id AS diapo_principal_id_137
FROM
  etablissement t0
  LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id
  LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id
WHERE
  t0.id IN (?)

SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id IN ('GE990-3', 'GE059-42', 'GE059-41', 'GE059-7', 'GE059-52', 'GE059-45', 'GE059-9', 'GE059-14', 'GE059-90');

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 = '59' AND v0_.onglets LIKE '%lycee%' AND v0_.id IN ('59350', '59295', '59599', '59606', '59017', '59178', '59183', '59378', '59512', '59009', '59033', '59036', '59056', '59090', '59122', '59249', '59258', '59319', '59324', '59328', '59360', '59392', '59449', '59456', '59526', '59571', '59574') ORDER BY v0_.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 = 'HAUT' AND d0_.onglets LIKE '%lycee%' AND d0_.id <> 'BE' ORDER BY d0_.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 = ?

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 = '75118';

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
  t0.actif AS actif_1,
  t0.contenu AS contenu_2,
  t0.id AS id_3,
  t0.etablissement_id AS etablissement_id_4,
  t0.template_id AS template_id_5
FROM
  texte_referencement t0
WHERE
  t0.etablissement_id = ?

SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = 'GE014-25';

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 '%lycee%' 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
  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 = 'LYC' AND s0_.diplome IS NULL AND s0_.secteur IS NULL;

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 ('59350', '59295', '59599', '59606', '59017', '59178', '59183', '59378', '59512', '59009', '59033', '59036', '59056', '59090', '59122', '59249', '59258', '59319', '59324', '59328', '59360', '59392', '59449', '59456', '59526', '59571', '59574') ORDER BY t0.libelle ASC;