1
4.46 ms
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 ;
Copy
2
3.15 ms
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_ ;
Copy
3
6.62 ms
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_ ;
Copy
4
6.26 ms
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
Parameters :
[
"bac-pro "
]
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 = 'bac-pro' LIMIT 1 ;
Copy
5
11.14 ms
SELECT e0_ . type AS type_0 , e0_ . nombre_eleves AS nombre_eleves_1 , e0_ . url AS url_2 , e0_ . video AS video_3 , e0_ . mots_cles AS mots_cles_4 , e0_ . denomination AS denomination_5 , e0_ . denomination_sigle AS denomination_sigle_6 , e0_ . denomination_extension AS denomination_extension_7 , e0_ . denomination_abregee AS denomination_abregee_8 , e0_ . droit_page_web AS droit_page_web_9 , e0_ . droit_actualite AS droit_actualite_10 , e0_ . adresse1 AS adresse1_11 , e0_ . adresse2 AS adresse2_12 , e0_ . adresse3 AS adresse3_13 , e0_ . code_postal AS code_postal_14 , e0_ . cedex AS cedex_15 , e0_ . latitude AS latitude_16 , e0_ . longitude AS longitude_17 , e0_ . telephone_principal AS telephone_principal_18 , e0_ . fax AS fax_19 , e0_ . email_principal AS email_principal_20 , e0_ . logo_liste AS logo_liste_21 , e0_ . logo_fiche AS logo_fiche_22 , e0_ . diaporama_actif AS diaporama_actif_23 , e0_ . images_diaporama AS images_diaporama_24 , e0_ . participant AS participant_25 , e0_ . catholique AS catholique_26 , e0_ . age_admission AS age_admission_27 , e0_ . actif AS actif_28 , e0_ . internat AS internat_29 , e0_ . has_internat AS has_internat_30 , e0_ . types_internat AS types_internat_31 , e0_ . sous_contrat AS sous_contrat_32 , e0_ . alternance AS alternance_33 , e0_ . type_client AS type_client_34 , e0_ . bloque_txt_ref AS bloque_txt_ref_35 , e0_ . facebook AS facebook_36 , e0_ . bloque_bac2021 AS bloque_bac2021_37 , e0_ . presence_web AS presence_web_38 , e0_ . video_plus AS video_plus_39 , e0_ . diapo_plus AS diapo_plus_40 , e0_ . jpo_plus AS jpo_plus_41 , e0_ . doc_plus AS doc_plus_42 , e0_ . diplome_plus AS diplome_plus_43 , e0_ . refus AS refus_44 , e0_ . path AS path_45 , e0_ . composition_ensemble_scolaire AS composition_ensemble_scolaire_46 , e0_ . lva AS lva_47 , e0_ . lvb AS lvb_48 , e0_ . numero_administratif_uai AS numero_administratif_uai_49 , e0_ . siret AS siret_50 , e0_ . chiffres AS chiffres_51 , e0_ . id AS id_52 , e0_ . maj AS maj_53 , v1_ . slug AS slug_54 , v1_ . libelle AS libelle_55 , v1_ . code_postal AS code_postal_56 , v1_ . email_delegue AS email_delegue_57 , v1_ . onglets AS onglets_58 , v1_ . id AS id_59 , v1_ . maj AS maj_60 , v2_ . latitude AS latitude_61 , v2_ . longitude AS longitude_62 , v2_ . id AS id_63 , d3_ . slug AS slug_64 , d3_ . libelle AS libelle_65 , d3_ . onglets AS onglets_66 , d3_ . id AS id_67 , d3_ . maj AS maj_68 , d4_ . latitude AS latitude_69 , d4_ . longitude AS longitude_70 , d4_ . id AS id_71 , a5_ . slug AS slug_72 , a5_ . libelle AS libelle_73 , a5_ . id AS id_74 , a5_ . maj AS maj_75 , r6_ . libelle AS libelle_76 , r6_ . slug AS slug_77 , r6_ . region_adm AS region_adm_78 , r6_ . ancienne AS ancienne_79 , r6_ . onglets AS onglets_80 , r6_ . id AS id_81 , r6_ . maj AS maj_82 , p7_ . libelle AS libelle_83 , p7_ . id AS id_84 , p7_ . maj AS maj_85 , c8_ . libelle AS libelle_86 , c8_ . id AS id_87 , c8_ . maj AS maj_88 , t9_ . actif AS actif_89 , t9_ . contenu AS contenu_90 , t9_ . id AS id_91 , d10_ . id AS id_92 , d10_ . titre AS titre_93 , d10_ . texte AS texte_94 , d10_ . actif AS actif_95 , d10_ . position AS position_96 , d10_ . principal AS principal_97 , d10_ . date_crea AS date_crea_98 , d10_ . date_maj AS date_maj_99 , d11_ . id AS id_100 , d11_ . titre AS titre_101 , d11_ . legende AS legende_102 , d11_ . actif AS actif_103 , d11_ . position AS position_104 , d11_ . file_name AS file_name_105 , d11_ . file_size AS file_size_106 , d11_ . updated_at AS updated_at_107 , d11_ . file_name_source AS file_name_source_108 , d11_ . file_size_source AS file_size_source_109 , v12_ . id AS id_110 , v12_ . titre AS titre_111 , v12_ . url AS url_112 , v12_ . actif AS actif_113 , v12_ . position AS position_114 , v12_ . texte AS texte_115 , v12_ . file_name AS file_name_116 , v12_ . file_size AS file_size_117 , v12_ . updated_at AS updated_at_118 , v12_ . file_name_source AS file_name_source_119 , v12_ . file_size_source AS file_size_source_120 , v12_ . date_crea AS date_crea_121 , v12_ . date_maj AS date_maj_122 , l13_ . id AS id_123 , l13_ . file_name AS file_name_124 , l13_ . file_size AS file_size_125 , l13_ . updated_at AS updated_at_126 , l13_ . file_name_source AS file_name_source_127 , l13_ . file_size_source AS file_size_source_128 , l13_ . date_crea AS date_crea_129 , l13_ . date_maj AS date_maj_130 , e0_ . gestionnaire_id AS gestionnaire_id_131 , e0_ . ville_id AS ville_id_132 , e0_ . categorie_primaire_id AS categorie_primaire_id_133 , e0_ . region_id AS region_id_134 , e0_ . departement_id AS departement_id_135 , e0_ . categorie_organisme_id AS categorie_organisme_id_136 , e0_ . rubrique AS rubrique_137 , e0_ . internat2_id AS internat2_id_138 , e0_ . etablissement_lie_id AS etablissement_lie_id_139 , e0_ . logo_id AS logo_id_140 , e0_ . diapo_principal_id AS diapo_principal_id_141 , v1_ . departement_id AS departement_id_142 , v2_ . ville_id AS ville_id_143 , d3_ . ancienne_region_id AS ancienne_region_id_144 , d3_ . region_id AS region_id_145 , d4_ . departement_id AS departement_id_146 , a5_ . region_id AS region_id_147 , r6_ . pays_id AS pays_id_148 , t9_ . etablissement_id AS etablissement_id_149 , t9_ . template_id AS template_id_150 , d11_ . diaporama_id AS diaporama_id_151 FROM etablissement e0_ LEFT JOIN ville v1_ ON e0_ . ville_id = v1_ . id LEFT JOIN ville_coordonnees v2_ ON v1_ . id = v2_ . ville_id LEFT JOIN departement d3_ ON v1_ . departement_id = d3_ . id LEFT JOIN departement_coordonnees d4_ ON d3_ . id = d4_ . departement_id LEFT JOIN ancienne_region a5_ ON d3_ . ancienne_region_id = a5_ . id LEFT JOIN region r6_ ON a5_ . region_id = r6_ . id LEFT JOIN pays p7_ ON r6_ . pays_id = p7_ . id LEFT JOIN categorie c8_ ON e0_ . categorie_primaire_id = c8_ . id LEFT JOIN texte_referencement t9_ ON e0_ . id = t9_ . etablissement_id LEFT JOIN diaporama_etablissement d14_ ON e0_ . id = d14_ . etablissement_id LEFT JOIN diaporama d10_ ON d10_ . id = d14_ . diaporama_id LEFT JOIN diaporama_photo d11_ ON d10_ . id = d11_ . diaporama_id LEFT JOIN video_etablissement v15_ ON e0_ . id = v15_ . etablissement_id LEFT JOIN video v12_ ON v12_ . id = v15_ . video_id LEFT JOIN logo l13_ ON e0_ . logo_id = l13_ . id WHERE e0_ . id IN (? ) ORDER BY d11_ . position ASC
Parameters :
[
[
"ET030-62 "
"ET030-78 "
"ET033-52 "
"ET042-198 "
"ET092-48 "
"ET042-191 "
"ET010-14 "
"ET051-62 "
"ET030-79 "
"ET059-22 "
"ET075-233 "
"ET059-33 "
"ET081-2 "
"ET044-163 "
"ET025-55 "
"ET059-222 "
"ET002-3 "
"ET065-12 "
"ET088-44 "
"ET094-28 "
"ET007-83 "
"ET035-152 "
"ET069-349 "
"ET048-14 "
"ET987-9 "
"ET085-62 "
"ET062-66 "
]
]
SELECT
e0_ . type AS type_0 ,
e0_ . nombre_eleves AS nombre_eleves_1 ,
e0_ . url AS url_2 ,
e0_ . video AS video_3 ,
e0_ . mots_cles AS mots_cles_4 ,
e0_ . denomination AS denomination_5 ,
e0_ . denomination_sigle AS denomination_sigle_6 ,
e0_ . denomination_extension AS denomination_extension_7 ,
e0_ . denomination_abregee AS denomination_abregee_8 ,
e0_ . droit_page_web AS droit_page_web_9 ,
e0_ . droit_actualite AS droit_actualite_10 ,
e0_ . adresse1 AS adresse1_11 ,
e0_ . adresse2 AS adresse2_12 ,
e0_ . adresse3 AS adresse3_13 ,
e0_ . code_postal AS code_postal_14 ,
e0_ . cedex AS cedex_15 ,
e0_ . latitude AS latitude_16 ,
e0_ . longitude AS longitude_17 ,
e0_ . telephone_principal AS telephone_principal_18 ,
e0_ . fax AS fax_19 ,
e0_ . email_principal AS email_principal_20 ,
e0_ . logo_liste AS logo_liste_21 ,
e0_ . logo_fiche AS logo_fiche_22 ,
e0_ . diaporama_actif AS diaporama_actif_23 ,
e0_ . images_diaporama AS images_diaporama_24 ,
e0_ . participant AS participant_25 ,
e0_ . catholique AS catholique_26 ,
e0_ . age_admission AS age_admission_27 ,
e0_ . actif AS actif_28 ,
e0_ . internat AS internat_29 ,
e0_ . has_internat AS has_internat_30 ,
e0_ . types_internat AS types_internat_31 ,
e0_ . sous_contrat AS sous_contrat_32 ,
e0_ . alternance AS alternance_33 ,
e0_ . type_client AS type_client_34 ,
e0_ . bloque_txt_ref AS bloque_txt_ref_35 ,
e0_ . facebook AS facebook_36 ,
e0_ . bloque_bac2021 AS bloque_bac2021_37 ,
e0_ . presence_web AS presence_web_38 ,
e0_ . video_plus AS video_plus_39 ,
e0_ . diapo_plus AS diapo_plus_40 ,
e0_ . jpo_plus AS jpo_plus_41 ,
e0_ . doc_plus AS doc_plus_42 ,
e0_ . diplome_plus AS diplome_plus_43 ,
e0_ . refus AS refus_44 ,
e0_ . path AS path_45 ,
e0_ . composition_ensemble_scolaire AS composition_ensemble_scolaire_46 ,
e0_ . lva AS lva_47 ,
e0_ . lvb AS lvb_48 ,
e0_ . numero_administratif_uai AS numero_administratif_uai_49 ,
e0_ . siret AS siret_50 ,
e0_ . chiffres AS chiffres_51 ,
e0_ . id AS id_52 ,
e0_ . maj AS maj_53 ,
v1_ . slug AS slug_54 ,
v1_ . libelle AS libelle_55 ,
v1_ . code_postal AS code_postal_56 ,
v1_ . email_delegue AS email_delegue_57 ,
v1_ . onglets AS onglets_58 ,
v1_ . id AS id_59 ,
v1_ . maj AS maj_60 ,
v2_ . latitude AS latitude_61 ,
v2_ . longitude AS longitude_62 ,
v2_ . id AS id_63 ,
d3_ . slug AS slug_64 ,
d3_ . libelle AS libelle_65 ,
d3_ . onglets AS onglets_66 ,
d3_ . id AS id_67 ,
d3_ . maj AS maj_68 ,
d4_ . latitude AS latitude_69 ,
d4_ . longitude AS longitude_70 ,
d4_ . id AS id_71 ,
a5_ . slug AS slug_72 ,
a5_ . libelle AS libelle_73 ,
a5_ . id AS id_74 ,
a5_ . maj AS maj_75 ,
r6_ . libelle AS libelle_76 ,
r6_ . slug AS slug_77 ,
r6_ . region_adm AS region_adm_78 ,
r6_ . ancienne AS ancienne_79 ,
r6_ . onglets AS onglets_80 ,
r6_ . id AS id_81 ,
r6_ . maj AS maj_82 ,
p7_ . libelle AS libelle_83 ,
p7_ . id AS id_84 ,
p7_ . maj AS maj_85 ,
c8_ . libelle AS libelle_86 ,
c8_ . id AS id_87 ,
c8_ . maj AS maj_88 ,
t9_ . actif AS actif_89 ,
t9_ . contenu AS contenu_90 ,
t9_ . id AS id_91 ,
d10_ . id AS id_92 ,
d10_ . titre AS titre_93 ,
d10_ . texte AS texte_94 ,
d10_ . actif AS actif_95 ,
d10_ . position AS position_96 ,
d10_ . principal AS principal_97 ,
d10_ . date_crea AS date_crea_98 ,
d10_ . date_maj AS date_maj_99 ,
d11_ . id AS id_100 ,
d11_ . titre AS titre_101 ,
d11_ . legende AS legende_102 ,
d11_ . actif AS actif_103 ,
d11_ . position AS position_104 ,
d11_ . file_name AS file_name_105 ,
d11_ . file_size AS file_size_106 ,
d11_ . updated_at AS updated_at_107 ,
d11_ . file_name_source AS file_name_source_108 ,
d11_ . file_size_source AS file_size_source_109 ,
v12_ . id AS id_110 ,
v12_ . titre AS titre_111 ,
v12_ . url AS url_112 ,
v12_ . actif AS actif_113 ,
v12_ . position AS position_114 ,
v12_ . texte AS texte_115 ,
v12_ . file_name AS file_name_116 ,
v12_ . file_size AS file_size_117 ,
v12_ . updated_at AS updated_at_118 ,
v12_ . file_name_source AS file_name_source_119 ,
v12_ . file_size_source AS file_size_source_120 ,
v12_ . date_crea AS date_crea_121 ,
v12_ . date_maj AS date_maj_122 ,
l13_ . id AS id_123 ,
l13_ . file_name AS file_name_124 ,
l13_ . file_size AS file_size_125 ,
l13_ . updated_at AS updated_at_126 ,
l13_ . file_name_source AS file_name_source_127 ,
l13_ . file_size_source AS file_size_source_128 ,
l13_ . date_crea AS date_crea_129 ,
l13_ . date_maj AS date_maj_130 ,
e0_ . gestionnaire_id AS gestionnaire_id_131 ,
e0_ . ville_id AS ville_id_132 ,
e0_ . categorie_primaire_id AS categorie_primaire_id_133 ,
e0_ . region_id AS region_id_134 ,
e0_ . departement_id AS departement_id_135 ,
e0_ . categorie_organisme_id AS categorie_organisme_id_136 ,
e0_ . rubrique AS rubrique_137 ,
e0_ . internat2_id AS internat2_id_138 ,
e0_ . etablissement_lie_id AS etablissement_lie_id_139 ,
e0_ . logo_id AS logo_id_140 ,
e0_ . diapo_principal_id AS diapo_principal_id_141 ,
v1_ . departement_id AS departement_id_142 ,
v2_ . ville_id AS ville_id_143 ,
d3_ . ancienne_region_id AS ancienne_region_id_144 ,
d3_ . region_id AS region_id_145 ,
d4_ . departement_id AS departement_id_146 ,
a5_ . region_id AS region_id_147 ,
r6_ . pays_id AS pays_id_148 ,
t9_ . etablissement_id AS etablissement_id_149 ,
t9_ . template_id AS template_id_150 ,
d11_ . diaporama_id AS diaporama_id_151
FROM
etablissement e0_
LEFT JOIN ville v1_ ON e0_ . ville_id = v1_ . id
LEFT JOIN ville_coordonnees v2_ ON v1_ . id = v2_ . ville_id
LEFT JOIN departement d3_ ON v1_ . departement_id = d3_ . id
LEFT JOIN departement_coordonnees d4_ ON d3_ . id = d4_ . departement_id
LEFT JOIN ancienne_region a5_ ON d3_ . ancienne_region_id = a5_ . id
LEFT JOIN region r6_ ON a5_ . region_id = r6_ . id
LEFT JOIN pays p7_ ON r6_ . pays_id = p7_ . id
LEFT JOIN categorie c8_ ON e0_ . categorie_primaire_id = c8_ . id
LEFT JOIN texte_referencement t9_ ON e0_ . id = t9_ . etablissement_id
LEFT JOIN diaporama_etablissement d14_ ON e0_ . id = d14_ . etablissement_id
LEFT JOIN diaporama d10_ ON d10_ . id = d14_ . diaporama_id
LEFT JOIN diaporama_photo d11_ ON d10_ . id = d11_ . diaporama_id
LEFT JOIN video_etablissement v15_ ON e0_ . id = v15_ . etablissement_id
LEFT JOIN video v12_ ON v12_ . id = v15_ . video_id
LEFT JOIN logo l13_ ON e0_ . logo_id = l13_ . id
WHERE
e0_ . id IN (? )
ORDER BY
d11_ . position ASC
Copy
SELECT e0_ . type AS type_0 , e0_ . nombre_eleves AS nombre_eleves_1 , e0_ . url AS url_2 , e0_ . video AS video_3 , e0_ . mots_cles AS mots_cles_4 , e0_ . denomination AS denomination_5 , e0_ . denomination_sigle AS denomination_sigle_6 , e0_ . denomination_extension AS denomination_extension_7 , e0_ . denomination_abregee AS denomination_abregee_8 , e0_ . droit_page_web AS droit_page_web_9 , e0_ . droit_actualite AS droit_actualite_10 , e0_ . adresse1 AS adresse1_11 , e0_ . adresse2 AS adresse2_12 , e0_ . adresse3 AS adresse3_13 , e0_ . code_postal AS code_postal_14 , e0_ . cedex AS cedex_15 , e0_ . latitude AS latitude_16 , e0_ . longitude AS longitude_17 , e0_ . telephone_principal AS telephone_principal_18 , e0_ . fax AS fax_19 , e0_ . email_principal AS email_principal_20 , e0_ . logo_liste AS logo_liste_21 , e0_ . logo_fiche AS logo_fiche_22 , e0_ . diaporama_actif AS diaporama_actif_23 , e0_ . images_diaporama AS images_diaporama_24 , e0_ . participant AS participant_25 , e0_ . catholique AS catholique_26 , e0_ . age_admission AS age_admission_27 , e0_ . actif AS actif_28 , e0_ . internat AS internat_29 , e0_ . has_internat AS has_internat_30 , e0_ . types_internat AS types_internat_31 , e0_ . sous_contrat AS sous_contrat_32 , e0_ . alternance AS alternance_33 , e0_ . type_client AS type_client_34 , e0_ . bloque_txt_ref AS bloque_txt_ref_35 , e0_ . facebook AS facebook_36 , e0_ . bloque_bac2021 AS bloque_bac2021_37 , e0_ . presence_web AS presence_web_38 , e0_ . video_plus AS video_plus_39 , e0_ . diapo_plus AS diapo_plus_40 , e0_ . jpo_plus AS jpo_plus_41 , e0_ . doc_plus AS doc_plus_42 , e0_ . diplome_plus AS diplome_plus_43 , e0_ . refus AS refus_44 , e0_ . path AS path_45 , e0_ . composition_ensemble_scolaire AS composition_ensemble_scolaire_46 , e0_ . lva AS lva_47 , e0_ . lvb AS lvb_48 , e0_ . numero_administratif_uai AS numero_administratif_uai_49 , e0_ . siret AS siret_50 , e0_ . chiffres AS chiffres_51 , e0_ . id AS id_52 , e0_ . maj AS maj_53 , v1_ . slug AS slug_54 , v1_ . libelle AS libelle_55 , v1_ . code_postal AS code_postal_56 , v1_ . email_delegue AS email_delegue_57 , v1_ . onglets AS onglets_58 , v1_ . id AS id_59 , v1_ . maj AS maj_60 , v2_ . latitude AS latitude_61 , v2_ . longitude AS longitude_62 , v2_ . id AS id_63 , d3_ . slug AS slug_64 , d3_ . libelle AS libelle_65 , d3_ . onglets AS onglets_66 , d3_ . id AS id_67 , d3_ . maj AS maj_68 , d4_ . latitude AS latitude_69 , d4_ . longitude AS longitude_70 , d4_ . id AS id_71 , a5_ . slug AS slug_72 , a5_ . libelle AS libelle_73 , a5_ . id AS id_74 , a5_ . maj AS maj_75 , r6_ . libelle AS libelle_76 , r6_ . slug AS slug_77 , r6_ . region_adm AS region_adm_78 , r6_ . ancienne AS ancienne_79 , r6_ . onglets AS onglets_80 , r6_ . id AS id_81 , r6_ . maj AS maj_82 , p7_ . libelle AS libelle_83 , p7_ . id AS id_84 , p7_ . maj AS maj_85 , c8_ . libelle AS libelle_86 , c8_ . id AS id_87 , c8_ . maj AS maj_88 , t9_ . actif AS actif_89 , t9_ . contenu AS contenu_90 , t9_ . id AS id_91 , d10_ . id AS id_92 , d10_ . titre AS titre_93 , d10_ . texte AS texte_94 , d10_ . actif AS actif_95 , d10_ . position AS position_96 , d10_ . principal AS principal_97 , d10_ . date_crea AS date_crea_98 , d10_ . date_maj AS date_maj_99 , d11_ . id AS id_100 , d11_ . titre AS titre_101 , d11_ . legende AS legende_102 , d11_ . actif AS actif_103 , d11_ . position AS position_104 , d11_ . file_name AS file_name_105 , d11_ . file_size AS file_size_106 , d11_ . updated_at AS updated_at_107 , d11_ . file_name_source AS file_name_source_108 , d11_ . file_size_source AS file_size_source_109 , v12_ . id AS id_110 , v12_ . titre AS titre_111 , v12_ . url AS url_112 , v12_ . actif AS actif_113 , v12_ . position AS position_114 , v12_ . texte AS texte_115 , v12_ . file_name AS file_name_116 , v12_ . file_size AS file_size_117 , v12_ . updated_at AS updated_at_118 , v12_ . file_name_source AS file_name_source_119 , v12_ . file_size_source AS file_size_source_120 , v12_ . date_crea AS date_crea_121 , v12_ . date_maj AS date_maj_122 , l13_ . id AS id_123 , l13_ . file_name AS file_name_124 , l13_ . file_size AS file_size_125 , l13_ . updated_at AS updated_at_126 , l13_ . file_name_source AS file_name_source_127 , l13_ . file_size_source AS file_size_source_128 , l13_ . date_crea AS date_crea_129 , l13_ . date_maj AS date_maj_130 , e0_ . gestionnaire_id AS gestionnaire_id_131 , e0_ . ville_id AS ville_id_132 , e0_ . categorie_primaire_id AS categorie_primaire_id_133 , e0_ . region_id AS region_id_134 , e0_ . departement_id AS departement_id_135 , e0_ . categorie_organisme_id AS categorie_organisme_id_136 , e0_ . rubrique AS rubrique_137 , e0_ . internat2_id AS internat2_id_138 , e0_ . etablissement_lie_id AS etablissement_lie_id_139 , e0_ . logo_id AS logo_id_140 , e0_ . diapo_principal_id AS diapo_principal_id_141 , v1_ . departement_id AS departement_id_142 , v2_ . ville_id AS ville_id_143 , d3_ . ancienne_region_id AS ancienne_region_id_144 , d3_ . region_id AS region_id_145 , d4_ . departement_id AS departement_id_146 , a5_ . region_id AS region_id_147 , r6_ . pays_id AS pays_id_148 , t9_ . etablissement_id AS etablissement_id_149 , t9_ . template_id AS template_id_150 , d11_ . diaporama_id AS diaporama_id_151 FROM etablissement e0_ LEFT JOIN ville v1_ ON e0_ . ville_id = v1_ . id LEFT JOIN ville_coordonnees v2_ ON v1_ . id = v2_ . ville_id LEFT JOIN departement d3_ ON v1_ . departement_id = d3_ . id LEFT JOIN departement_coordonnees d4_ ON d3_ . id = d4_ . departement_id LEFT JOIN ancienne_region a5_ ON d3_ . ancienne_region_id = a5_ . id LEFT JOIN region r6_ ON a5_ . region_id = r6_ . id LEFT JOIN pays p7_ ON r6_ . pays_id = p7_ . id LEFT JOIN categorie c8_ ON e0_ . categorie_primaire_id = c8_ . id LEFT JOIN texte_referencement t9_ ON e0_ . id = t9_ . etablissement_id LEFT JOIN diaporama_etablissement d14_ ON e0_ . id = d14_ . etablissement_id LEFT JOIN diaporama d10_ ON d10_ . id = d14_ . diaporama_id LEFT JOIN diaporama_photo d11_ ON d10_ . id = d11_ . diaporama_id LEFT JOIN video_etablissement v15_ ON e0_ . id = v15_ . etablissement_id LEFT JOIN video v12_ ON v12_ . id = v15_ . video_id LEFT JOIN logo l13_ ON e0_ . logo_id = l13_ . id WHERE e0_ . id IN ('ET030-62' , 'ET030-78' , 'ET033-52' , 'ET042-198' , 'ET092-48' , 'ET042-191' , 'ET010-14' , 'ET051-62' , 'ET030-79' , 'ET059-22' , 'ET075-233' , 'ET059-33' , 'ET081-2' , 'ET044-163' , 'ET025-55' , 'ET059-222' , 'ET002-3' , 'ET065-12' , 'ET088-44' , 'ET094-28' , 'ET007-83' , 'ET035-152' , 'ET069-349' , 'ET048-14' , 'ET987-9' , 'ET085-62' , 'ET062-66' ) ORDER BY d11_ . position ASC ;
Copy
6
18.61 ms
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 (? )
Parameters :
[
[
"GE025-8 "
"GE002-8 "
"GE007-5 "
"GE010-10 "
"GE030-5 "
"GE030-18 "
"GE035-4 "
"GE042-13 "
"GE042-35 "
"GE044-33 "
"GE048-3 "
"GE051-12 "
"GE059-89 "
"GE059-72 "
"GE062-26 "
"GE065-1 "
"GE069-41 "
"GE075-195 "
"GE081-10 "
"GE085-5 "
"GE088-6 "
"GE092-10 "
"GE987-6 "
]
]
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 (? )
Copy
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 ('GE025-8' , 'GE002-8' , 'GE007-5' , 'GE010-10' , 'GE030-5' , 'GE030-18' , 'GE035-4' , 'GE042-13' , 'GE042-35' , 'GE044-33' , 'GE048-3' , 'GE051-12' , 'GE059-89' , 'GE059-72' , 'GE062-26' , 'GE065-1' , 'GE069-41' , 'GE075-195' , 'GE081-10' , 'GE085-5' , 'GE088-6' , 'GE092-10' , 'GE987-6' );
Copy
7
2.96 ms
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
Parameters :
[
"%professionnel% "
]
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 '%professionnel%' 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 ;
Copy
8
0.87 ms
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
Parameters :
[
"000 "
"%professionnel% "
"BE "
]
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 = '000' AND d0_ . onglets LIKE '%professionnel%' AND d0_ . id < > 'BE' ORDER BY d0_ . libelle ASC ;
Copy
9
2.30 ms
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
Parameters :
[
[
"02173 "
"07319 "
"10387 "
"25462 "
"30032 "
"30132 "
"30189 "
"33063 "
"35115 "
"42187 "
"42218 "
"44190 "
"48095 "
"51108 "
"59017 "
"59172 "
"59512 "
"62364 "
"65440 "
"69202 "
"75114 "
"81163 "
"85238 "
"88078 "
"92040 "
"94016 "
"98738 "
]
]
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 ('02173' , '07319' , '10387' , '25462' , '30032' , '30132' , '30189' , '33063' , '35115' , '42187' , '42218' , '44190' , '48095' , '51108' , '59017' , '59172' , '59512' , '62364' , '65440' , '69202' , '75114' , '81163' , '85238' , '88078' , '92040' , '94016' , '98738' ) ORDER BY t0 . libelle ASC ;
Copy
10
320.48 ms
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
Parameters :
[
"LYCPRO-BACP-% "
[
"LYCPRO-BACP-DEF "
"LYCPRO-BACP-DEF-BACPR "
"LYCPRO-COORD "
"LYCPRO-COORD-ADR "
"LYCPRO-COORD-MAIL "
"LYCPRO-COORD-TEL "
"LYCPRO-COORD-WEB "
"LYCPRO-PRES "
"LYCPRO-LANG "
"LYCPRO-SPEC "
"LYCPRO-ACCU "
"LYCPRO-LANG-LV1 "
"LYCPRO-LANG-LV1-ANG "
"LYCPRO-LANG-LV2 "
"LYCPRO-PRES-CHE "
"LYCPRO-ACCU-INTA "
"LYCPRO-LANG-LV2-ESP "
"LYCPRO-PRES-SCO "
"LYCPRO-BACP-SANT "
"LYCPRO-CAP-DEF "
"LYCPRO-CAP-DEF-AGS "
"LYCPRO-ACCU-BOUR "
"LYCPRO-ACCU-ACCE "
"LYCPRO-ACCU-MIXT "
"LYCPRO-ACCU-CANT "
"LYCPRO-BACP-DISTRI "
"LYCPRO-COORD-FAX "
"LYCPRO-PRESLIBRE-TXTS_IS "
"LYCPRO-PRESLIBRE_IS "
"LYCPRO-SPEC-ASPO "
"LYCPRO-BACP-GADF "
"LYCPRO-BACP-GADF-BACPR1 "
"LYCPRO-BACP-DISTRI-BACPR2 "
"LYCPRO-BACP-DISTRI-BACPR3 "
"LYCPRO-BACP-ELEC "
"LYCPRO-BACP-ELEC-BACPR1 "
"LYCPRO-LANG-LV2-ALL "
"LYCPRO-PRES-NBE "
"LYCPRO-PRES-TUT "
"LYCPRO-SPEC-PMET "
"LYCPRO-SPEC-TXTS41 "
"LYCPRO-ACCU-EXT "
"LYCPRO-CAP-SANT "
"LYCPRO-SPEC-EDU "
"LYCPRO-SPEC-SLIN "
"LYCPRO-BACP-MAINT "
"LYCPRO-BACP-SANT-BACPR "
"LYCPRO-PRES-NBC "
"LYCPRO-PRES-NID "
"LYCPRO-SPEC-ACC "
"LYCPRO-SPEC-ACC-ULIS "
"LYCPRO-SPEC-CDI "
"LYCPRO-SPEC-TXTS "
"LYCPRO-SPEC-VOY "
"LYCPRO "
"LYCPRO-BACP-INF "
"LYCPRO-BACP-MAINT-BACPR "
"LYCPRO-CAP-BTP "
"LYCPRO-CAP-MET "
"LYCPRO-CAP-SANT-CAPAC "
"LYCPRO-PRES-TEUR "
"LYCPRO-SPEC-PRE "
"LYCPRO-SPEC-TXTS50 "
"LYCPRO-ACCU-APP "
"LYCPRO-ACCU-HAND_MT "
"LYCPRO-BACP-BTPARC "
"LYCPRO-BACP-DEF-BPPRV "
"LYCPRO-BACP-MEC "
"LYCPRO-CAP-COM "
"LYCPRO-PRES-AUTR1_MT "
"LYCPRO-SPEC-ART "
"LYCPRO-SPEC-MULT "
"LYCPRO-SPEC-STA_MT "
"LYCPRO-SPEC-TICE "
"LYCPRO-ACCU-CAF "
"LYCPRO-ACCU-HORA_MT "
"LYCPRO-BACP-ENERG "
"LYCPRO-BACP-INF-BACPR0 "
"LYCPRO-BACP-MAINT-BACPR4 "
"LYCPRO-BACP-SANT-BPROPT "
"LYCPRO-BACP-SANT-BPRSAPS "
"LYCPRO-BACP-TRAN "
"LYCPRO-BACP-TRAN-BPRLOG "
"LYCPRO-CAP-COM-CAPEQ "
"LYCPRO-CAP-ELE "
"LYCPRO-CAP-ELE-CAPEL "
"LYCPRO-CAP-HOT "
"LYCPRO-CAP-HOT-CAPPR "
"LYCPRO-CAP-MAE "
"LYCPRO-CAP-MET-CAPMA "
"LYCPRO-LANG-LV2-ANG "
"LYCPRO-PRES-TRICE "
"LYCPRO-SPEC-CERT "
"LYCPRO-SPEC-EUR "
"LYCPRO-SPEC-SPOR "
"LYCPRO-SPEC-TXTS01 "
"LYCPRO-SPEC-TXTS42 "
"LYCPRO-SPEC-TXTS47 "
"LYCPRO-ACCU-TXTS "
"LYCPRO-BACP-AERO "
"LYCPRO-BACP-AERO-BPAOSY "
"LYCPRO-BACP-AGRI "
"LYCPRO-BACP-BTPARC-BPFIB "
"LYCPRO-BACP-ENERG-BACPR0 "
"LYCPRO-BACP-INF-BACPR "
"LYCPRO-BACP-MEC-BPRCHA "
"LYCPRO-BACP-SANT-BACPR6 "
"LYCPRO-BACP-SANT-SPT "
"LYCPRO-BACP-SPOR "
"LYCPRO-BACP-TEXT "
"LYCPRO-BACP-TEXT-BPRCOS "
"LYCPRO-CAP-BTP-MAC "
"LYCPRO-CAP-MAE-CAPIN "
"LYCPRO-CAP-MET-CIP "
"LYCPRO-CAP-SANT-CAPAG0 "
"LYCPRO-CAP-SANT-DEAES "
"LYCPRO-FORMA-PREP "
"LYCPRO-LANG-LV2-ITA "
"LYCPRO-LANG-TXTS "
"LYCPRO-LOGOG "
"LYCPRO-PHOG "
"LYCPRO-SPEC-B2I "
"LYCPRO-SPEC-BDI "
"LYCPRO-SPEC-BIA "
"LYCPRO-SPEC-CUL "
"LYCPRO-SPEC-EFF "
"LYCPRO-SPEC-LSF "
"LYCPRO-SPEC-PAST "
"LYCPRO-SPEC-PERI "
"LYCPRO-SPEC-PREP "
"LYCPRO-SPEC-REPA "
"LYCPRO-SPEC-TXTS46 "
"LYCPRO-TEXTC1_MT "
"LYCPRO-BACP-AERO-BPAOAV "
"LYCPRO-BACP-AGRI-BACPR3 "
"LYCPRO-BACP-AGRI-BACPR5 "
"LYCPRO-BACP-AGRI-BPRGHIP "
"LYCPRO-BACP-AGRI-CERTI0 "
"LYCPRO-BACP-ART "
"LYCPRO-BACP-ART-BACPR "
"LYCPRO-BACP-BTPARC-BACPR "
"LYCPRO-BACP-BTPARC-BACPR0 "
"LYCPRO-BACP-BTPARC-BPOBM "
"LYCPRO-BACP-BTPARC-TB2E "
"LYCPRO-BACP-CULT "
"LYCPRO-BACP-CULT-BPRTAP "
"LYCPRO-BACP-DEF-BACPR0 "
"LYCPRO-BACP-DISTRI-BACPR "
"LYCPRO-BACP-DISTRI-BACPR6 "
"LYCPRO-BACP-DISTRI-BPRBOU "
"LYCPRO-BACP-ENERG-BACPR "
"LYCPRO-BACP-ENERG-BACPR1 "
"LYCPRO-BACP-ENERG-CERTI "
"LYCPRO-BACP-ENV "
"LYCPRO-BACP-ENV-BPRPAY "
"LYCPRO-BACP-INF-CERTI0 "
"LYCPRO-BACP-INF-CERTI1 "
"LYCPRO-BACP-MAINT-BACPR1 "
"LYCPRO-BACP-MAINT-BPREQI "
"LYCPRO-BACP-MEC-BACPR0 "
"LYCPRO-BACP-MEC-BACPR1 "
"LYCPRO-BACP-MEC-BACPR3 "
"LYCPRO-BACP-MEC-BPRMIC "
"LYCPRO-BACP-MEC-CQPCA "
"LYCPRO-BACP-MEC-CQPTE0 "
"LYCPRO-BACP-PUB "
"LYCPRO-BACP-PUB-BPRCOV "
"LYCPRO-BACP-SANT-BACPR8 "
"LYCPRO-BACP-SANT-BEPSAP "
"LYCPRO-BACP-SANT-BPJEPS "
"LYCPRO-BACP-SANT-BPRSAPD "
"LYCPRO-BACP-SANT-TITRE "
"LYCPRO-BACP-SPOR-BREVE "
"LYCPRO-BACP-SPOR-CERTI0 "
"LYCPRO-BACP-TEXT-BPCOS "
"LYCPRO-CAP-AGRI "
"LYCPRO-CAP-AGRI-CAPAP "
"LYCPRO-CAP-BTP-CAPME "
"LYCPRO-CAP-BTP-CAR "
"LYCPRO-CAP-BTP-CHA "
"LYCPRO-CAP-BTP-CONCAR "
"LYCPRO-CAP-BTP-COUV "
"LYCPRO-CAP-BTP-PEIN "
"LYCPRO-CAP-COM-PAT "
"LYCPRO-CAP-COM-POIS "
"LYCPRO-CAP-CUL "
"LYCPRO-CAP-CUL-JOA "
"LYCPRO-CAP-DEF-AVE "
"LYCPRO-CAP-HOT-CAPCO "
"LYCPRO-CAP-HOT-COMMI "
"LYCPRO-CAP-HOT-TITRE0 "
"LYCPRO-CAP-MAE-TITRE "
"LYCPRO-CAP-MET-CAPCA "
"LYCPRO-CAP-MET-CAPMA1 "
"LYCPRO-CAP-MET-CAPME0 "
"LYCPRO-CAP-MET-CAPPE "
"LYCPRO-CAP-MET-CAPRE0 "
"LYCPRO-CAP-MET-RCA "
"LYCPRO-CAP-MOD "
"LYCPRO-CAP-MOD-EST "
"LYCPRO-CAP-SANT-CAPAG "
"LYCPRO-CAP-SANT-CPJEP "
"LYCPRO-CAP-SANT-MFC "
"LYCPRO-CAP-SANT-TITRE "
"LYCPRO-CAP-SPOR "
"LYCPRO-CAP-SPOR-CERTI "
"LYCPRO-CAP-TRAN "
"LYCPRO-CAP-TRAN-CAPOP "
"LYCPRO-FPC-DEF "
"LYCPRO-FPC-DEF-BTSMO "
"LYCPRO-FPC-MEC "
"LYCPRO-FPC-MEC-CQPCA "
"LYCPRO-FPC-MEC-CQPCO "
"LYCPRO-FPC-MEC-CQPTE "
"LYCPRO-FPC-MEC-CQPTE0 "
"LYCPRO-FPC-MEC-CQPTE1 "
"LYCPRO-FPC-MEC-CQPTE2 "
"LYCPRO-LANG-LV1-ALL "
"LYCPRO-LOGO "
"LYCPRO-PRES-TXTS "
"LYCPRO-SPEC-JUM "
"LYCPRO-SPEC-JUM_MT "
"LYCPRO-SPEC-OPTAS "
"LYCPRO-SPEC-PASS_MT "
"LYCPRO-SPEC-PIX "
"LYCPRO-SPEC-PSC1 "
"LYCPRO-SPEC-REG_MT "
"LYCPRO-SPEC-REG_MT-TAH "
"LYCPRO-SPEC-TXTS43 "
"LYCPRO-SPEC-TXTS45 "
"LYCPRO-SPEC-TXTS49 "
]
]
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 'LYCPRO-BACP-%' AND i0_ . id IN ('LYCPRO-BACP-DEF' , 'LYCPRO-BACP-DEF-BACPR' , 'LYCPRO-COORD' , 'LYCPRO-COORD-ADR' , 'LYCPRO-COORD-MAIL' , 'LYCPRO-COORD-TEL' , 'LYCPRO-COORD-WEB' , 'LYCPRO-PRES' , 'LYCPRO-LANG' , 'LYCPRO-SPEC' , 'LYCPRO-ACCU' , 'LYCPRO-LANG-LV1' , 'LYCPRO-LANG-LV1-ANG' , 'LYCPRO-LANG-LV2' , 'LYCPRO-PRES-CHE' , 'LYCPRO-ACCU-INTA' , 'LYCPRO-LANG-LV2-ESP' , 'LYCPRO-PRES-SCO' , 'LYCPRO-BACP-SANT' , 'LYCPRO-CAP-DEF' , 'LYCPRO-CAP-DEF-AGS' , 'LYCPRO-ACCU-BOUR' , 'LYCPRO-ACCU-ACCE' , 'LYCPRO-ACCU-MIXT' , 'LYCPRO-ACCU-CANT' , 'LYCPRO-BACP-DISTRI' , 'LYCPRO-COORD-FAX' , 'LYCPRO-PRESLIBRE-TXTS_IS' , 'LYCPRO-PRESLIBRE_IS' , 'LYCPRO-SPEC-ASPO' , 'LYCPRO-BACP-GADF' , 'LYCPRO-BACP-GADF-BACPR1' , 'LYCPRO-BACP-DISTRI-BACPR2' , 'LYCPRO-BACP-DISTRI-BACPR3' , 'LYCPRO-BACP-ELEC' , 'LYCPRO-BACP-ELEC-BACPR1' , 'LYCPRO-LANG-LV2-ALL' , 'LYCPRO-PRES-NBE' , 'LYCPRO-PRES-TUT' , 'LYCPRO-SPEC-PMET' , 'LYCPRO-SPEC-TXTS41' , 'LYCPRO-ACCU-EXT' , 'LYCPRO-CAP-SANT' , 'LYCPRO-SPEC-EDU' , 'LYCPRO-SPEC-SLIN' , 'LYCPRO-BACP-MAINT' , 'LYCPRO-BACP-SANT-BACPR' , 'LYCPRO-PRES-NBC' , 'LYCPRO-PRES-NID' , 'LYCPRO-SPEC-ACC' , 'LYCPRO-SPEC-ACC-ULIS' , 'LYCPRO-SPEC-CDI' , 'LYCPRO-SPEC-TXTS' , 'LYCPRO-SPEC-VOY' , 'LYCPRO' , 'LYCPRO-BACP-INF' , 'LYCPRO-BACP-MAINT-BACPR' , 'LYCPRO-CAP-BTP' , 'LYCPRO-CAP-MET' , 'LYCPRO-CAP-SANT-CAPAC' , 'LYCPRO-PRES-TEUR' , 'LYCPRO-SPEC-PRE' , 'LYCPRO-SPEC-TXTS50' , 'LYCPRO-ACCU-APP' , 'LYCPRO-ACCU-HAND_MT' , 'LYCPRO-BACP-BTPARC' , 'LYCPRO-BACP-DEF-BPPRV' , 'LYCPRO-BACP-MEC' , 'LYCPRO-CAP-COM' , 'LYCPRO-PRES-AUTR1_MT' , 'LYCPRO-SPEC-ART' , 'LYCPRO-SPEC-MULT' , 'LYCPRO-SPEC-STA_MT' , 'LYCPRO-SPEC-TICE' , 'LYCPRO-ACCU-CAF' , 'LYCPRO-ACCU-HORA_MT' , 'LYCPRO-BACP-ENERG' , 'LYCPRO-BACP-INF-BACPR0' , 'LYCPRO-BACP-MAINT-BACPR4' , 'LYCPRO-BACP-SANT-BPROPT' , 'LYCPRO-BACP-SANT-BPRSAPS' , 'LYCPRO-BACP-TRAN' , 'LYCPRO-BACP-TRAN-BPRLOG' , 'LYCPRO-CAP-COM-CAPEQ' , 'LYCPRO-CAP-ELE' , 'LYCPRO-CAP-ELE-CAPEL' , 'LYCPRO-CAP-HOT' , 'LYCPRO-CAP-HOT-CAPPR' , 'LYCPRO-CAP-MAE' , 'LYCPRO-CAP-MET-CAPMA' , 'LYCPRO-LANG-LV2-ANG' , 'LYCPRO-PRES-TRICE' , 'LYCPRO-SPEC-CERT' , 'LYCPRO-SPEC-EUR' , 'LYCPRO-SPEC-SPOR' , 'LYCPRO-SPEC-TXTS01' , 'LYCPRO-SPEC-TXTS42' , 'LYCPRO-SPEC-TXTS47' , 'LYCPRO-ACCU-TXTS' , 'LYCPRO-BACP-AERO' , 'LYCPRO-BACP-AERO-BPAOSY' , 'LYCPRO-BACP-AGRI' , 'LYCPRO-BACP-BTPARC-BPFIB' , 'LYCPRO-BACP-ENERG-BACPR0' , 'LYCPRO-BACP-INF-BACPR' , 'LYCPRO-BACP-MEC-BPRCHA' , 'LYCPRO-BACP-SANT-BACPR6' , 'LYCPRO-BACP-SANT-SPT' , 'LYCPRO-BACP-SPOR' , 'LYCPRO-BACP-TEXT' , 'LYCPRO-BACP-TEXT-BPRCOS' , 'LYCPRO-CAP-BTP-MAC' , 'LYCPRO-CAP-MAE-CAPIN' , 'LYCPRO-CAP-MET-CIP' , 'LYCPRO-CAP-SANT-CAPAG0' , 'LYCPRO-CAP-SANT-DEAES' , 'LYCPRO-FORMA-PREP' , 'LYCPRO-LANG-LV2-ITA' , 'LYCPRO-LANG-TXTS' , 'LYCPRO-LOGOG' , 'LYCPRO-PHOG' , 'LYCPRO-SPEC-B2I' , 'LYCPRO-SPEC-BDI' , 'LYCPRO-SPEC-BIA' , 'LYCPRO-SPEC-CUL' , 'LYCPRO-SPEC-EFF' , 'LYCPRO-SPEC-LSF' , 'LYCPRO-SPEC-PAST' , 'LYCPRO-SPEC-PERI' , 'LYCPRO-SPEC-PREP' , 'LYCPRO-SPEC-REPA' , 'LYCPRO-SPEC-TXTS46' , 'LYCPRO-TEXTC1_MT' , 'LYCPRO-BACP-AERO-BPAOAV' , 'LYCPRO-BACP-AGRI-BACPR3' , 'LYCPRO-BACP-AGRI-BACPR5' , 'LYCPRO-BACP-AGRI-BPRGHIP' , 'LYCPRO-BACP-AGRI-CERTI0' , 'LYCPRO-BACP-ART' , 'LYCPRO-BACP-ART-BACPR' , 'LYCPRO-BACP-BTPARC-BACPR' , 'LYCPRO-BACP-BTPARC-BACPR0' , 'LYCPRO-BACP-BTPARC-BPOBM' , 'LYCPRO-BACP-BTPARC-TB2E' , 'LYCPRO-BACP-CULT' , 'LYCPRO-BACP-CULT-BPRTAP' , 'LYCPRO-BACP-DEF-BACPR0' , 'LYCPRO-BACP-DISTRI-BACPR' , 'LYCPRO-BACP-DISTRI-BACPR6' , 'LYCPRO-BACP-DISTRI-BPRBOU' , 'LYCPRO-BACP-ENERG-BACPR' , 'LYCPRO-BACP-ENERG-BACPR1' , 'LYCPRO-BACP-ENERG-CERTI' , 'LYCPRO-BACP-ENV' , 'LYCPRO-BACP-ENV-BPRPAY' , 'LYCPRO-BACP-INF-CERTI0' , 'LYCPRO-BACP-INF-CERTI1' , 'LYCPRO-BACP-MAINT-BACPR1' , 'LYCPRO-BACP-MAINT-BPREQI' , 'LYCPRO-BACP-MEC-BACPR0' , 'LYCPRO-BACP-MEC-BACPR1' , 'LYCPRO-BACP-MEC-BACPR3' , 'LYCPRO-BACP-MEC-BPRMIC' , 'LYCPRO-BACP-MEC-CQPCA' , 'LYCPRO-BACP-MEC-CQPTE0' , 'LYCPRO-BACP-PUB' , 'LYCPRO-BACP-PUB-BPRCOV' , 'LYCPRO-BACP-SANT-BACPR8' , 'LYCPRO-BACP-SANT-BEPSAP' , 'LYCPRO-BACP-SANT-BPJEPS' , 'LYCPRO-BACP-SANT-BPRSAPD' , 'LYCPRO-BACP-SANT-TITRE' , 'LYCPRO-BACP-SPOR-BREVE' , 'LYCPRO-BACP-SPOR-CERTI0' , 'LYCPRO-BACP-TEXT-BPCOS' , 'LYCPRO-CAP-AGRI' , 'LYCPRO-CAP-AGRI-CAPAP' , 'LYCPRO-CAP-BTP-CAPME' , 'LYCPRO-CAP-BTP-CAR' , 'LYCPRO-CAP-BTP-CHA' , 'LYCPRO-CAP-BTP-CONCAR' , 'LYCPRO-CAP-BTP-COUV' , 'LYCPRO-CAP-BTP-PEIN' , 'LYCPRO-CAP-COM-PAT' , 'LYCPRO-CAP-COM-POIS' , 'LYCPRO-CAP-CUL' , 'LYCPRO-CAP-CUL-JOA' , 'LYCPRO-CAP-DEF-AVE' , 'LYCPRO-CAP-HOT-CAPCO' , 'LYCPRO-CAP-HOT-COMMI' , 'LYCPRO-CAP-HOT-TITRE0' , 'LYCPRO-CAP-MAE-TITRE' , 'LYCPRO-CAP-MET-CAPCA' , 'LYCPRO-CAP-MET-CAPMA1' , 'LYCPRO-CAP-MET-CAPME0' , 'LYCPRO-CAP-MET-CAPPE' , 'LYCPRO-CAP-MET-CAPRE0' , 'LYCPRO-CAP-MET-RCA' , 'LYCPRO-CAP-MOD' , 'LYCPRO-CAP-MOD-EST' , 'LYCPRO-CAP-SANT-CAPAG' , 'LYCPRO-CAP-SANT-CPJEP' , 'LYCPRO-CAP-SANT-MFC' , 'LYCPRO-CAP-SANT-TITRE' , 'LYCPRO-CAP-SPOR' , 'LYCPRO-CAP-SPOR-CERTI' , 'LYCPRO-CAP-TRAN' , 'LYCPRO-CAP-TRAN-CAPOP' , 'LYCPRO-FPC-DEF' , 'LYCPRO-FPC-DEF-BTSMO' , 'LYCPRO-FPC-MEC' , 'LYCPRO-FPC-MEC-CQPCA' , 'LYCPRO-FPC-MEC-CQPCO' , 'LYCPRO-FPC-MEC-CQPTE' , 'LYCPRO-FPC-MEC-CQPTE0' , 'LYCPRO-FPC-MEC-CQPTE1' , 'LYCPRO-FPC-MEC-CQPTE2' , 'LYCPRO-LANG-LV1-ALL' , 'LYCPRO-LOGO' , 'LYCPRO-PRES-TXTS' , 'LYCPRO-SPEC-JUM' , 'LYCPRO-SPEC-JUM_MT' , 'LYCPRO-SPEC-OPTAS' , 'LYCPRO-SPEC-PASS_MT' , 'LYCPRO-SPEC-PIX' , 'LYCPRO-SPEC-PSC1' , 'LYCPRO-SPEC-REG_MT' , 'LYCPRO-SPEC-REG_MT-TAH' , 'LYCPRO-SPEC-TXTS43' , 'LYCPRO-SPEC-TXTS45' , 'LYCPRO-SPEC-TXTS49' ) GROUP BY i0_ . id ORDER BY i0_ . libelle ASC ;
Copy
11
485.77 ms
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 'LYCPRO-BACP-DEF%' ORDER BY i0_ . libelle ASC
Parameters :
[
[
"LYCPRO-BACP-DEF "
"LYCPRO-BACP-DEF-BACPR "
"LYCPRO-COORD "
"LYCPRO-COORD-ADR "
"LYCPRO-COORD-MAIL "
"LYCPRO-COORD-TEL "
"LYCPRO-COORD-WEB "
"LYCPRO-PRES "
"LYCPRO-LANG "
"LYCPRO-SPEC "
"LYCPRO-ACCU "
"LYCPRO-LANG-LV1 "
"LYCPRO-LANG-LV1-ANG "
"LYCPRO-LANG-LV2 "
"LYCPRO-PRES-CHE "
"LYCPRO-ACCU-INTA "
"LYCPRO-LANG-LV2-ESP "
"LYCPRO-PRES-SCO "
"LYCPRO-BACP-SANT "
"LYCPRO-CAP-DEF "
"LYCPRO-CAP-DEF-AGS "
"LYCPRO-ACCU-BOUR "
"LYCPRO-ACCU-ACCE "
"LYCPRO-ACCU-MIXT "
"LYCPRO-ACCU-CANT "
"LYCPRO-BACP-DISTRI "
"LYCPRO-COORD-FAX "
"LYCPRO-PRESLIBRE-TXTS_IS "
"LYCPRO-PRESLIBRE_IS "
"LYCPRO-SPEC-ASPO "
"LYCPRO-BACP-GADF "
"LYCPRO-BACP-GADF-BACPR1 "
"LYCPRO-BACP-DISTRI-BACPR2 "
"LYCPRO-BACP-DISTRI-BACPR3 "
"LYCPRO-BACP-ELEC "
"LYCPRO-BACP-ELEC-BACPR1 "
"LYCPRO-LANG-LV2-ALL "
"LYCPRO-PRES-NBE "
"LYCPRO-PRES-TUT "
"LYCPRO-SPEC-PMET "
"LYCPRO-SPEC-TXTS41 "
"LYCPRO-ACCU-EXT "
"LYCPRO-CAP-SANT "
"LYCPRO-SPEC-EDU "
"LYCPRO-SPEC-SLIN "
"LYCPRO-BACP-MAINT "
"LYCPRO-BACP-SANT-BACPR "
"LYCPRO-PRES-NBC "
"LYCPRO-PRES-NID "
"LYCPRO-SPEC-ACC "
"LYCPRO-SPEC-ACC-ULIS "
"LYCPRO-SPEC-CDI "
"LYCPRO-SPEC-TXTS "
"LYCPRO-SPEC-VOY "
"LYCPRO "
"LYCPRO-BACP-INF "
"LYCPRO-BACP-MAINT-BACPR "
"LYCPRO-CAP-BTP "
"LYCPRO-CAP-MET "
"LYCPRO-CAP-SANT-CAPAC "
"LYCPRO-PRES-TEUR "
"LYCPRO-SPEC-PRE "
"LYCPRO-SPEC-TXTS50 "
"LYCPRO-ACCU-APP "
"LYCPRO-ACCU-HAND_MT "
"LYCPRO-BACP-BTPARC "
"LYCPRO-BACP-DEF-BPPRV "
"LYCPRO-BACP-MEC "
"LYCPRO-CAP-COM "
"LYCPRO-PRES-AUTR1_MT "
"LYCPRO-SPEC-ART "
"LYCPRO-SPEC-MULT "
"LYCPRO-SPEC-STA_MT "
"LYCPRO-SPEC-TICE "
"LYCPRO-ACCU-CAF "
"LYCPRO-ACCU-HORA_MT "
"LYCPRO-BACP-ENERG "
"LYCPRO-BACP-INF-BACPR0 "
"LYCPRO-BACP-MAINT-BACPR4 "
"LYCPRO-BACP-SANT-BPROPT "
"LYCPRO-BACP-SANT-BPRSAPS "
"LYCPRO-BACP-TRAN "
"LYCPRO-BACP-TRAN-BPRLOG "
"LYCPRO-CAP-COM-CAPEQ "
"LYCPRO-CAP-ELE "
"LYCPRO-CAP-ELE-CAPEL "
"LYCPRO-CAP-HOT "
"LYCPRO-CAP-HOT-CAPPR "
"LYCPRO-CAP-MAE "
"LYCPRO-CAP-MET-CAPMA "
"LYCPRO-LANG-LV2-ANG "
"LYCPRO-PRES-TRICE "
"LYCPRO-SPEC-CERT "
"LYCPRO-SPEC-EUR "
"LYCPRO-SPEC-SPOR "
"LYCPRO-SPEC-TXTS01 "
"LYCPRO-SPEC-TXTS42 "
"LYCPRO-SPEC-TXTS47 "
"LYCPRO-ACCU-TXTS "
"LYCPRO-BACP-AERO "
"LYCPRO-BACP-AERO-BPAOSY "
"LYCPRO-BACP-AGRI "
"LYCPRO-BACP-BTPARC-BPFIB "
"LYCPRO-BACP-ENERG-BACPR0 "
"LYCPRO-BACP-INF-BACPR "
"LYCPRO-BACP-MEC-BPRCHA "
"LYCPRO-BACP-SANT-BACPR6 "
"LYCPRO-BACP-SANT-SPT "
"LYCPRO-BACP-SPOR "
"LYCPRO-BACP-TEXT "
"LYCPRO-BACP-TEXT-BPRCOS "
"LYCPRO-CAP-BTP-MAC "
"LYCPRO-CAP-MAE-CAPIN "
"LYCPRO-CAP-MET-CIP "
"LYCPRO-CAP-SANT-CAPAG0 "
"LYCPRO-CAP-SANT-DEAES "
"LYCPRO-FORMA-PREP "
"LYCPRO-LANG-LV2-ITA "
"LYCPRO-LANG-TXTS "
"LYCPRO-LOGOG "
"LYCPRO-PHOG "
"LYCPRO-SPEC-B2I "
"LYCPRO-SPEC-BDI "
"LYCPRO-SPEC-BIA "
"LYCPRO-SPEC-CUL "
"LYCPRO-SPEC-EFF "
"LYCPRO-SPEC-LSF "
"LYCPRO-SPEC-PAST "
"LYCPRO-SPEC-PERI "
"LYCPRO-SPEC-PREP "
"LYCPRO-SPEC-REPA "
"LYCPRO-SPEC-TXTS46 "
"LYCPRO-TEXTC1_MT "
"LYCPRO-BACP-AERO-BPAOAV "
"LYCPRO-BACP-AGRI-BACPR3 "
"LYCPRO-BACP-AGRI-BACPR5 "
"LYCPRO-BACP-AGRI-BPRGHIP "
"LYCPRO-BACP-AGRI-CERTI0 "
"LYCPRO-BACP-ART "
"LYCPRO-BACP-ART-BACPR "
"LYCPRO-BACP-BTPARC-BACPR "
"LYCPRO-BACP-BTPARC-BACPR0 "
"LYCPRO-BACP-BTPARC-BPOBM "
"LYCPRO-BACP-BTPARC-TB2E "
"LYCPRO-BACP-CULT "
"LYCPRO-BACP-CULT-BPRTAP "
"LYCPRO-BACP-DEF-BACPR0 "
"LYCPRO-BACP-DISTRI-BACPR "
"LYCPRO-BACP-DISTRI-BACPR6 "
"LYCPRO-BACP-DISTRI-BPRBOU "
"LYCPRO-BACP-ENERG-BACPR "
"LYCPRO-BACP-ENERG-BACPR1 "
"LYCPRO-BACP-ENERG-CERTI "
"LYCPRO-BACP-ENV "
"LYCPRO-BACP-ENV-BPRPAY "
"LYCPRO-BACP-INF-CERTI0 "
"LYCPRO-BACP-INF-CERTI1 "
"LYCPRO-BACP-MAINT-BACPR1 "
"LYCPRO-BACP-MAINT-BPREQI "
"LYCPRO-BACP-MEC-BACPR0 "
"LYCPRO-BACP-MEC-BACPR1 "
"LYCPRO-BACP-MEC-BACPR3 "
"LYCPRO-BACP-MEC-BPRMIC "
"LYCPRO-BACP-MEC-CQPCA "
"LYCPRO-BACP-MEC-CQPTE0 "
"LYCPRO-BACP-PUB "
"LYCPRO-BACP-PUB-BPRCOV "
"LYCPRO-BACP-SANT-BACPR8 "
"LYCPRO-BACP-SANT-BEPSAP "
"LYCPRO-BACP-SANT-BPJEPS "
"LYCPRO-BACP-SANT-BPRSAPD "
"LYCPRO-BACP-SANT-TITRE "
"LYCPRO-BACP-SPOR-BREVE "
"LYCPRO-BACP-SPOR-CERTI0 "
"LYCPRO-BACP-TEXT-BPCOS "
"LYCPRO-CAP-AGRI "
"LYCPRO-CAP-AGRI-CAPAP "
"LYCPRO-CAP-BTP-CAPME "
"LYCPRO-CAP-BTP-CAR "
"LYCPRO-CAP-BTP-CHA "
"LYCPRO-CAP-BTP-CONCAR "
"LYCPRO-CAP-BTP-COUV "
"LYCPRO-CAP-BTP-PEIN "
"LYCPRO-CAP-COM-PAT "
"LYCPRO-CAP-COM-POIS "
"LYCPRO-CAP-CUL "
"LYCPRO-CAP-CUL-JOA "
"LYCPRO-CAP-DEF-AVE "
"LYCPRO-CAP-HOT-CAPCO "
"LYCPRO-CAP-HOT-COMMI "
"LYCPRO-CAP-HOT-TITRE0 "
"LYCPRO-CAP-MAE-TITRE "
"LYCPRO-CAP-MET-CAPCA "
"LYCPRO-CAP-MET-CAPMA1 "
"LYCPRO-CAP-MET-CAPME0 "
"LYCPRO-CAP-MET-CAPPE "
"LYCPRO-CAP-MET-CAPRE0 "
"LYCPRO-CAP-MET-RCA "
"LYCPRO-CAP-MOD "
"LYCPRO-CAP-MOD-EST "
"LYCPRO-CAP-SANT-CAPAG "
"LYCPRO-CAP-SANT-CPJEP "
"LYCPRO-CAP-SANT-MFC "
"LYCPRO-CAP-SANT-TITRE "
"LYCPRO-CAP-SPOR "
"LYCPRO-CAP-SPOR-CERTI "
"LYCPRO-CAP-TRAN "
"LYCPRO-CAP-TRAN-CAPOP "
"LYCPRO-FPC-DEF "
"LYCPRO-FPC-DEF-BTSMO "
"LYCPRO-FPC-MEC "
"LYCPRO-FPC-MEC-CQPCA "
"LYCPRO-FPC-MEC-CQPCO "
"LYCPRO-FPC-MEC-CQPTE "
"LYCPRO-FPC-MEC-CQPTE0 "
"LYCPRO-FPC-MEC-CQPTE1 "
"LYCPRO-FPC-MEC-CQPTE2 "
"LYCPRO-LANG-LV1-ALL "
"LYCPRO-LOGO "
"LYCPRO-PRES-TXTS "
"LYCPRO-SPEC-JUM "
"LYCPRO-SPEC-JUM_MT "
"LYCPRO-SPEC-OPTAS "
"LYCPRO-SPEC-PASS_MT "
"LYCPRO-SPEC-PIX "
"LYCPRO-SPEC-PSC1 "
"LYCPRO-SPEC-REG_MT "
"LYCPRO-SPEC-REG_MT-TAH "
"LYCPRO-SPEC-TXTS43 "
"LYCPRO-SPEC-TXTS45 "
"LYCPRO-SPEC-TXTS49 "
]
]
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 ('LYCPRO-BACP-DEF' , 'LYCPRO-BACP-DEF-BACPR' , 'LYCPRO-COORD' , 'LYCPRO-COORD-ADR' , 'LYCPRO-COORD-MAIL' , 'LYCPRO-COORD-TEL' , 'LYCPRO-COORD-WEB' , 'LYCPRO-PRES' , 'LYCPRO-LANG' , 'LYCPRO-SPEC' , 'LYCPRO-ACCU' , 'LYCPRO-LANG-LV1' , 'LYCPRO-LANG-LV1-ANG' , 'LYCPRO-LANG-LV2' , 'LYCPRO-PRES-CHE' , 'LYCPRO-ACCU-INTA' , 'LYCPRO-LANG-LV2-ESP' , 'LYCPRO-PRES-SCO' , 'LYCPRO-BACP-SANT' , 'LYCPRO-CAP-DEF' , 'LYCPRO-CAP-DEF-AGS' , 'LYCPRO-ACCU-BOUR' , 'LYCPRO-ACCU-ACCE' , 'LYCPRO-ACCU-MIXT' , 'LYCPRO-ACCU-CANT' , 'LYCPRO-BACP-DISTRI' , 'LYCPRO-COORD-FAX' , 'LYCPRO-PRESLIBRE-TXTS_IS' , 'LYCPRO-PRESLIBRE_IS' , 'LYCPRO-SPEC-ASPO' , 'LYCPRO-BACP-GADF' , 'LYCPRO-BACP-GADF-BACPR1' , 'LYCPRO-BACP-DISTRI-BACPR2' , 'LYCPRO-BACP-DISTRI-BACPR3' , 'LYCPRO-BACP-ELEC' , 'LYCPRO-BACP-ELEC-BACPR1' , 'LYCPRO-LANG-LV2-ALL' , 'LYCPRO-PRES-NBE' , 'LYCPRO-PRES-TUT' , 'LYCPRO-SPEC-PMET' , 'LYCPRO-SPEC-TXTS41' , 'LYCPRO-ACCU-EXT' , 'LYCPRO-CAP-SANT' , 'LYCPRO-SPEC-EDU' , 'LYCPRO-SPEC-SLIN' , 'LYCPRO-BACP-MAINT' , 'LYCPRO-BACP-SANT-BACPR' , 'LYCPRO-PRES-NBC' , 'LYCPRO-PRES-NID' , 'LYCPRO-SPEC-ACC' , 'LYCPRO-SPEC-ACC-ULIS' , 'LYCPRO-SPEC-CDI' , 'LYCPRO-SPEC-TXTS' , 'LYCPRO-SPEC-VOY' , 'LYCPRO' , 'LYCPRO-BACP-INF' , 'LYCPRO-BACP-MAINT-BACPR' , 'LYCPRO-CAP-BTP' , 'LYCPRO-CAP-MET' , 'LYCPRO-CAP-SANT-CAPAC' , 'LYCPRO-PRES-TEUR' , 'LYCPRO-SPEC-PRE' , 'LYCPRO-SPEC-TXTS50' , 'LYCPRO-ACCU-APP' , 'LYCPRO-ACCU-HAND_MT' , 'LYCPRO-BACP-BTPARC' , 'LYCPRO-BACP-DEF-BPPRV' , 'LYCPRO-BACP-MEC' , 'LYCPRO-CAP-COM' , 'LYCPRO-PRES-AUTR1_MT' , 'LYCPRO-SPEC-ART' , 'LYCPRO-SPEC-MULT' , 'LYCPRO-SPEC-STA_MT' , 'LYCPRO-SPEC-TICE' , 'LYCPRO-ACCU-CAF' , 'LYCPRO-ACCU-HORA_MT' , 'LYCPRO-BACP-ENERG' , 'LYCPRO-BACP-INF-BACPR0' , 'LYCPRO-BACP-MAINT-BACPR4' , 'LYCPRO-BACP-SANT-BPROPT' , 'LYCPRO-BACP-SANT-BPRSAPS' , 'LYCPRO-BACP-TRAN' , 'LYCPRO-BACP-TRAN-BPRLOG' , 'LYCPRO-CAP-COM-CAPEQ' , 'LYCPRO-CAP-ELE' , 'LYCPRO-CAP-ELE-CAPEL' , 'LYCPRO-CAP-HOT' , 'LYCPRO-CAP-HOT-CAPPR' , 'LYCPRO-CAP-MAE' , 'LYCPRO-CAP-MET-CAPMA' , 'LYCPRO-LANG-LV2-ANG' , 'LYCPRO-PRES-TRICE' , 'LYCPRO-SPEC-CERT' , 'LYCPRO-SPEC-EUR' , 'LYCPRO-SPEC-SPOR' , 'LYCPRO-SPEC-TXTS01' , 'LYCPRO-SPEC-TXTS42' , 'LYCPRO-SPEC-TXTS47' , 'LYCPRO-ACCU-TXTS' , 'LYCPRO-BACP-AERO' , 'LYCPRO-BACP-AERO-BPAOSY' , 'LYCPRO-BACP-AGRI' , 'LYCPRO-BACP-BTPARC-BPFIB' , 'LYCPRO-BACP-ENERG-BACPR0' , 'LYCPRO-BACP-INF-BACPR' , 'LYCPRO-BACP-MEC-BPRCHA' , 'LYCPRO-BACP-SANT-BACPR6' , 'LYCPRO-BACP-SANT-SPT' , 'LYCPRO-BACP-SPOR' , 'LYCPRO-BACP-TEXT' , 'LYCPRO-BACP-TEXT-BPRCOS' , 'LYCPRO-CAP-BTP-MAC' , 'LYCPRO-CAP-MAE-CAPIN' , 'LYCPRO-CAP-MET-CIP' , 'LYCPRO-CAP-SANT-CAPAG0' , 'LYCPRO-CAP-SANT-DEAES' , 'LYCPRO-FORMA-PREP' , 'LYCPRO-LANG-LV2-ITA' , 'LYCPRO-LANG-TXTS' , 'LYCPRO-LOGOG' , 'LYCPRO-PHOG' , 'LYCPRO-SPEC-B2I' , 'LYCPRO-SPEC-BDI' , 'LYCPRO-SPEC-BIA' , 'LYCPRO-SPEC-CUL' , 'LYCPRO-SPEC-EFF' , 'LYCPRO-SPEC-LSF' , 'LYCPRO-SPEC-PAST' , 'LYCPRO-SPEC-PERI' , 'LYCPRO-SPEC-PREP' , 'LYCPRO-SPEC-REPA' , 'LYCPRO-SPEC-TXTS46' , 'LYCPRO-TEXTC1_MT' , 'LYCPRO-BACP-AERO-BPAOAV' , 'LYCPRO-BACP-AGRI-BACPR3' , 'LYCPRO-BACP-AGRI-BACPR5' , 'LYCPRO-BACP-AGRI-BPRGHIP' , 'LYCPRO-BACP-AGRI-CERTI0' , 'LYCPRO-BACP-ART' , 'LYCPRO-BACP-ART-BACPR' , 'LYCPRO-BACP-BTPARC-BACPR' , 'LYCPRO-BACP-BTPARC-BACPR0' , 'LYCPRO-BACP-BTPARC-BPOBM' , 'LYCPRO-BACP-BTPARC-TB2E' , 'LYCPRO-BACP-CULT' , 'LYCPRO-BACP-CULT-BPRTAP' , 'LYCPRO-BACP-DEF-BACPR0' , 'LYCPRO-BACP-DISTRI-BACPR' , 'LYCPRO-BACP-DISTRI-BACPR6' , 'LYCPRO-BACP-DISTRI-BPRBOU' , 'LYCPRO-BACP-ENERG-BACPR' , 'LYCPRO-BACP-ENERG-BACPR1' , 'LYCPRO-BACP-ENERG-CERTI' , 'LYCPRO-BACP-ENV' , 'LYCPRO-BACP-ENV-BPRPAY' , 'LYCPRO-BACP-INF-CERTI0' , 'LYCPRO-BACP-INF-CERTI1' , 'LYCPRO-BACP-MAINT-BACPR1' , 'LYCPRO-BACP-MAINT-BPREQI' , 'LYCPRO-BACP-MEC-BACPR0' , 'LYCPRO-BACP-MEC-BACPR1' , 'LYCPRO-BACP-MEC-BACPR3' , 'LYCPRO-BACP-MEC-BPRMIC' , 'LYCPRO-BACP-MEC-CQPCA' , 'LYCPRO-BACP-MEC-CQPTE0' , 'LYCPRO-BACP-PUB' , 'LYCPRO-BACP-PUB-BPRCOV' , 'LYCPRO-BACP-SANT-BACPR8' , 'LYCPRO-BACP-SANT-BEPSAP' , 'LYCPRO-BACP-SANT-BPJEPS' , 'LYCPRO-BACP-SANT-BPRSAPD' , 'LYCPRO-BACP-SANT-TITRE' , 'LYCPRO-BACP-SPOR-BREVE' , 'LYCPRO-BACP-SPOR-CERTI0' , 'LYCPRO-BACP-TEXT-BPCOS' , 'LYCPRO-CAP-AGRI' , 'LYCPRO-CAP-AGRI-CAPAP' , 'LYCPRO-CAP-BTP-CAPME' , 'LYCPRO-CAP-BTP-CAR' , 'LYCPRO-CAP-BTP-CHA' , 'LYCPRO-CAP-BTP-CONCAR' , 'LYCPRO-CAP-BTP-COUV' , 'LYCPRO-CAP-BTP-PEIN' , 'LYCPRO-CAP-COM-PAT' , 'LYCPRO-CAP-COM-POIS' , 'LYCPRO-CAP-CUL' , 'LYCPRO-CAP-CUL-JOA' , 'LYCPRO-CAP-DEF-AVE' , 'LYCPRO-CAP-HOT-CAPCO' , 'LYCPRO-CAP-HOT-COMMI' , 'LYCPRO-CAP-HOT-TITRE0' , 'LYCPRO-CAP-MAE-TITRE' , 'LYCPRO-CAP-MET-CAPCA' , 'LYCPRO-CAP-MET-CAPMA1' , 'LYCPRO-CAP-MET-CAPME0' , 'LYCPRO-CAP-MET-CAPPE' , 'LYCPRO-CAP-MET-CAPRE0' , 'LYCPRO-CAP-MET-RCA' , 'LYCPRO-CAP-MOD' , 'LYCPRO-CAP-MOD-EST' , 'LYCPRO-CAP-SANT-CAPAG' , 'LYCPRO-CAP-SANT-CPJEP' , 'LYCPRO-CAP-SANT-MFC' , 'LYCPRO-CAP-SANT-TITRE' , 'LYCPRO-CAP-SPOR' , 'LYCPRO-CAP-SPOR-CERTI' , 'LYCPRO-CAP-TRAN' , 'LYCPRO-CAP-TRAN-CAPOP' , 'LYCPRO-FPC-DEF' , 'LYCPRO-FPC-DEF-BTSMO' , 'LYCPRO-FPC-MEC' , 'LYCPRO-FPC-MEC-CQPCA' , 'LYCPRO-FPC-MEC-CQPCO' , 'LYCPRO-FPC-MEC-CQPTE' , 'LYCPRO-FPC-MEC-CQPTE0' , 'LYCPRO-FPC-MEC-CQPTE1' , 'LYCPRO-FPC-MEC-CQPTE2' , 'LYCPRO-LANG-LV1-ALL' , 'LYCPRO-LOGO' , 'LYCPRO-PRES-TXTS' , 'LYCPRO-SPEC-JUM' , 'LYCPRO-SPEC-JUM_MT' , 'LYCPRO-SPEC-OPTAS' , 'LYCPRO-SPEC-PASS_MT' , 'LYCPRO-SPEC-PIX' , 'LYCPRO-SPEC-PSC1' , 'LYCPRO-SPEC-REG_MT' , 'LYCPRO-SPEC-REG_MT-TAH' , 'LYCPRO-SPEC-TXTS43' , 'LYCPRO-SPEC-TXTS45' , 'LYCPRO-SPEC-TXTS49' ) AND i0_ . id LIKE 'LYCPRO-BACP-DEF%' ORDER BY i0_ . libelle ASC ;
Copy
12
0.44 ms
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
Parameters :
[
"LYCPRO-LANG-LV1-% "
[
"LYCPRO-LANG-LV1-ANG "
"LYCPRO-LANG-LV1-ALL "
]
]
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 'LYCPRO-LANG-LV1-%' AND i0_ . id IN ('LYCPRO-LANG-LV1-ANG' , 'LYCPRO-LANG-LV1-ALL' ) ORDER BY i0_ . libelle ASC ;
Copy
13
0.18 ms
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
Parameters :
[
"LYCPRO-LANG-LV2-% "
[
"LYCPRO-LANG-LV2-ESP "
"LYCPRO-LANG-LV2-ALL "
"LYCPRO-LANG-LV2-ANG "
"LYCPRO-LANG-LV2-ITA "
]
]
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 'LYCPRO-LANG-LV2-%' AND i0_ . id IN ('LYCPRO-LANG-LV2-ESP' , 'LYCPRO-LANG-LV2-ALL' , 'LYCPRO-LANG-LV2-ANG' , 'LYCPRO-LANG-LV2-ITA' ) ORDER BY i0_ . libelle ASC ;
Copy
14
1.13 ms
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
Parameters :
[
"LYC-FORMA2021-SPEC-% "
[]
]
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 ;
Copy
15
2.68 ms
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
Parameters :
[
"bac-pro% "
"bac-pro% "
]
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-pro%' OR i0_ . slug LIKE 'bac-pro%' LIMIT 1 ;
Copy
16
1.43 ms
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = ? LIMIT 1
Parameters :
[
"LYCPRO-BACP-DEF-BACPR "
]
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = 'LYCPRO-BACP-DEF-BACPR' LIMIT 1 ;
Copy
17
0.36 ms
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = ? LIMIT 1
Parameters :
[
"LYCPRO-BACP-DEF "
]
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = 'LYCPRO-BACP-DEF' LIMIT 1 ;
Copy
18
4.84 ms
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_ . diplome = ?
Parameters :
[
"LYCPRO-BACP-DEF-BACPR "
]
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_ . diplome = 'LYCPRO-BACP-DEF-BACPR' ;
Copy
19
6.72 ms
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_ . etablissement_id IN (? ) AND i0_ . diplome_plus = 1 ORDER BY RAND () ASC
Parameters :
[
[
"ET030-62 "
"ET030-78 "
"ET033-52 "
"ET042-198 "
"ET092-48 "
"ET042-191 "
"ET010-14 "
"ET051-62 "
"ET030-79 "
"ET059-22 "
"ET075-233 "
"ET059-33 "
"ET081-2 "
"ET044-163 "
"ET025-55 "
"ET059-222 "
"ET002-3 "
"ET065-12 "
"ET088-44 "
"ET094-28 "
"ET007-83 "
"ET035-152 "
"ET069-349 "
"ET048-14 "
"ET987-9 "
"ET085-62 "
"ET062-66 "
]
]
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_ . etablissement_id IN ('ET030-62' , 'ET030-78' , 'ET033-52' , 'ET042-198' , 'ET092-48' , 'ET042-191' , 'ET010-14' , 'ET051-62' , 'ET030-79' , 'ET059-22' , 'ET075-233' , 'ET059-33' , 'ET081-2' , 'ET044-163' , 'ET025-55' , 'ET059-222' , 'ET002-3' , 'ET065-12' , 'ET088-44' , 'ET094-28' , 'ET007-83' , 'ET035-152' , 'ET069-349' , 'ET048-14' , 'ET987-9' , 'ET085-62' , 'ET062-66' ) AND i0_ . diplome_plus = 1 ORDER BY RAND () ASC ;
Copy
20
2.06 ms
SELECT t0 . id AS id_1 , t0 . onglet AS onglet_2 , t0 . niveau AS niveau_3 , t0 . tag AS tag_4 , t0 . filiere AS filiere_5 , t0 . diplome AS diplome_6 , t0 . question AS question_7 , t0 . ordre AS ordre_8 , t0 . reponse AS reponse_9 , t0 . visible AS visible_10 , t0 . updated_at AS updated_at_11 FROM faq t0 WHERE t0 . onglet = ? AND t0 . niveau = ? AND t0 . filiere = ? AND t0 . diplome = ? AND t0 . visible = ? ORDER BY t0 . ordre ASC , t0 . updated_at DESC
Parameters :
[
"professionnel "
"bac-pro "
"LYCPRO-BACP-DEF "
"LYCPRO-BACP-DEF-BACPR "
1
]
SELECT t0 . id AS id_1 , t0 . onglet AS onglet_2 , t0 . niveau AS niveau_3 , t0 . tag AS tag_4 , t0 . filiere AS filiere_5 , t0 . diplome AS diplome_6 , t0 . question AS question_7 , t0 . ordre AS ordre_8 , t0 . reponse AS reponse_9 , t0 . visible AS visible_10 , t0 . updated_at AS updated_at_11 FROM faq t0 WHERE t0 . onglet = 'professionnel' AND t0 . niveau = 'bac-pro' AND t0 . filiere = 'LYCPRO-BACP-DEF' AND t0 . diplome = 'LYCPRO-BACP-DEF-BACPR' AND t0 . visible = 1 ORDER BY t0 . ordre ASC , t0 . updated_at DESC ;
Copy
21
5.27 ms
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = ? LIMIT 1
Parameters :
[
"LYCPRO-BACP-DEF-BACPR "
]
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = 'LYCPRO-BACP-DEF-BACPR' LIMIT 1 ;
Copy
22
2.56 ms
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = ? LIMIT 1
Parameters :
[
"LYCPRO-BACP-DEF-BACPR "
]
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = 'LYCPRO-BACP-DEF-BACPR' LIMIT 1 ;
Copy
23
13.92 ms
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = ? LIMIT 1
Parameters :
[
"LYCPRO-BACP-DEF-BACPR "
]
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = 'LYCPRO-BACP-DEF-BACPR' LIMIT 1 ;
Copy
24
1.63 ms
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = ? LIMIT 1
Parameters :
[
"LYCPRO-BACP-DEF "
]
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = 'LYCPRO-BACP-DEF' LIMIT 1 ;
Copy
25
0.12 ms
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = ? LIMIT 1
Parameters :
[
"LYCPRO-BACP-DEF-BACPR "
]
SELECT t0 . libelle AS libelle_1 , t0 . libelle_mep AS libelle_mep_2 , t0 . texte_defaut AS texte_defaut_3 , t0 . onglet AS onglet_4 , t0 . niveau AS niveau_5 , t0 . formation AS formation_6 , t0 . options AS options_7 , t0 . libelle_web AS libelle_web_8 , t0 . id AS id_9 , t0 . maj AS maj_10 FROM items t0 WHERE t0 . id = 'LYCPRO-BACP-DEF-BACPR' LIMIT 1 ;
Copy
26
2.49 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET030-62 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET030-62' ORDER BY t0 . diplome_plus ASC ;
Copy
27
9.78 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET030-78 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET030-78' ORDER BY t0 . diplome_plus ASC ;
Copy
28
6.10 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET033-52 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET033-52' ORDER BY t0 . diplome_plus ASC ;
Copy
29
2.56 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET042-198 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET042-198' ORDER BY t0 . diplome_plus ASC ;
Copy
30
4.96 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET092-48 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET092-48' ORDER BY t0 . diplome_plus ASC ;
Copy
31
6.11 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET042-191 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET042-191' ORDER BY t0 . diplome_plus ASC ;
Copy
32
2.89 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET010-14 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET010-14' ORDER BY t0 . diplome_plus ASC ;
Copy
33
5.68 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET051-62 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET051-62' ORDER BY t0 . diplome_plus ASC ;
Copy
34
7.20 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET030-79 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET030-79' ORDER BY t0 . diplome_plus ASC ;
Copy
35
7.90 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET059-22 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET059-22' ORDER BY t0 . diplome_plus ASC ;
Copy
36
0.74 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET075-233 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET075-233' ORDER BY t0 . diplome_plus ASC ;
Copy
37
5.46 ms
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = ? ORDER BY t0 . diplome_plus ASC
Parameters :
[
"ET059-33 "
]
SELECT t0 . identifiant AS identifiant_1 , t0 . onglet AS onglet_2 , t0 . libelle AS libelle_3 , t0 . options AS options_4 , t0 . niveau AS niveau_5 , t0 . pere AS pere_6 , t0 . libelle_specifique AS libelle_specifique_7 , t0 . options_specifique AS options_specifique_8 , t0 . texte AS texte_9 , t0 . tri AS tri_10 , t0 . complement_texte AS complement_texte_11 , t0 . complement_url_libelle AS complement_url_libelle_12 , t0 . complement_url AS complement_url_13 , t0 . complement_updated_at AS complement_updated_at_14 , t0 . libelle_mep AS libelle_mep_15 , t0 . slug AS slug_16 , t0 . formation AS formation_17 , t0 . ligne_secours AS ligne_secours_18 , t0 . updated_at AS updated_at_19 , t0 . diplome_plus AS diplome_plus_20 , t0 . valeur AS valeur_21 , t0 . id AS id_22 , t0 . etablissement_id AS etablissement_id_23 FROM items_insertion t0 WHERE t0 . etablissement_id = 'ET059-33' ORDER BY t0 . diplome_plus ASC ;
Copy
38
9.93 ms
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 (? )
Parameters :
[
[
"ET038-99 "
"IN032-19 "
"ET069-563 "
"ET056-364 "
"ET074-110 "
]
]
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 (? )
Copy
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 ('ET038-99' , 'IN032-19' , 'ET069-563' , 'ET056-364' , 'ET074-110' );
Copy
39
3.14 ms
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 = ?
Parameters :
[
"GE038-34 "
]
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 = 'GE038-34' ;
Copy
40
20.68 ms
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 = ?
Parameters :
[
"GE003-13 "
]
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 = 'GE003-13' ;
Copy
41
7.55 ms
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 = ?
Parameters :
[
"GE074-7 "
]
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 = 'GE074-7' ;
Copy
42
0.12 ms
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 = ?
Parameters :
[
"GE032-4 "
]
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 = 'GE032-4' ;
Copy
43
1.41 ms
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 = '38315' ;
Copy
44
0.16 ms
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . file_size AS file_size_3 , t0 . updated_at AS updated_at_4 , t0 . file_name_source AS file_name_source_5 , t0 . file_size_source AS file_size_source_6 , t0 . date_crea AS date_crea_7 , t0 . date_maj AS date_maj_8 FROM logo t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . file_size AS file_size_3 , t0 . updated_at AS updated_at_4 , t0 . file_name_source AS file_name_source_5 , t0 . file_size_source AS file_size_source_6 , t0 . date_crea AS date_crea_7 , t0 . date_maj AS date_maj_8 FROM logo t0 WHERE t0 . id = 1635 ;
Copy
45
0.13 ms
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 = '32013' ;
Copy
46
0.66 ms
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 = '69044' ;
Copy
47
0.13 ms
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . file_size AS file_size_3 , t0 . updated_at AS updated_at_4 , t0 . file_name_source AS file_name_source_5 , t0 . file_size_source AS file_size_source_6 , t0 . date_crea AS date_crea_7 , t0 . date_maj AS date_maj_8 FROM logo t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . file_size AS file_size_3 , t0 . updated_at AS updated_at_4 , t0 . file_name_source AS file_name_source_5 , t0 . file_size_source AS file_size_source_6 , t0 . date_crea AS date_crea_7 , t0 . date_maj AS date_maj_8 FROM logo t0 WHERE t0 . id = 84 ;
Copy
48
4.17 ms
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 = '56260' ;
Copy
49
0.16 ms
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 = '74305' ;
Copy
50
0.14 ms
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . file_size AS file_size_3 , t0 . updated_at AS updated_at_4 , t0 . file_name_source AS file_name_source_5 , t0 . file_size_source AS file_size_source_6 , t0 . date_crea AS date_crea_7 , t0 . date_maj AS date_maj_8 FROM logo t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . file_size AS file_size_3 , t0 . updated_at AS updated_at_4 , t0 . file_name_source AS file_name_source_5 , t0 . file_size_source AS file_size_source_6 , t0 . date_crea AS date_crea_7 , t0 . date_maj AS date_maj_8 FROM logo t0 WHERE t0 . id = 3347 ;
Copy