197.49 ms
(68.83%)
|
1 |
SELECT i0_.identifiant AS identifiant_0, i0_.onglet AS onglet_1, i0_.libelle AS libelle_2, i0_.options AS options_3, i0_.niveau AS niveau_4, i0_.pere AS pere_5, i0_.libelle_specifique AS libelle_specifique_6, i0_.options_specifique AS options_specifique_7, i0_.texte AS texte_8, i0_.tri AS tri_9, i0_.complement_texte AS complement_texte_10, i0_.complement_url_libelle AS complement_url_libelle_11, i0_.complement_url AS complement_url_12, i0_.complement_updated_at AS complement_updated_at_13, i0_.libelle_mep AS libelle_mep_14, i0_.slug AS slug_15, i0_.formation AS formation_16, i0_.ligne_secours AS ligne_secours_17, i0_.updated_at AS updated_at_18, i0_.diplome_plus AS diplome_plus_19, i0_.valeur AS valeur_20, i0_.id AS id_21, i0_.etablissement_id AS etablissement_id_22 FROM items_insertion i0_ WHERE i0_.diplome_plus = 1 ORDER BY RAND() ASC LIMIT 12
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_.diplome_plus = 1 ORDER BY RAND() ASC LIMIT 12;
|
33.44 ms
(11.65%)
|
1 |
SELECT v0_.id AS id_0, v0_.titre AS titre_1, v0_.url AS url_2, v0_.actif AS actif_3, v0_.position AS position_4, v0_.texte AS texte_5, v0_.file_name AS file_name_6, v0_.file_size AS file_size_7, v0_.updated_at AS updated_at_8, v0_.file_name_source AS file_name_source_9, v0_.file_size_source AS file_size_source_10, v0_.date_crea AS date_crea_11, v0_.date_maj AS date_maj_12, e1_.type AS type_13, e1_.nombre_eleves AS nombre_eleves_14, e1_.url AS url_15, e1_.video AS video_16, e1_.mots_cles AS mots_cles_17, e1_.denomination AS denomination_18, e1_.denomination_sigle AS denomination_sigle_19, e1_.denomination_extension AS denomination_extension_20, e1_.denomination_abregee AS denomination_abregee_21, e1_.droit_page_web AS droit_page_web_22, e1_.droit_actualite AS droit_actualite_23, e1_.adresse1 AS adresse1_24, e1_.adresse2 AS adresse2_25, e1_.adresse3 AS adresse3_26, e1_.code_postal AS code_postal_27, e1_.cedex AS cedex_28, e1_.latitude AS latitude_29, e1_.longitude AS longitude_30, e1_.telephone_principal AS telephone_principal_31, e1_.fax AS fax_32, e1_.email_principal AS email_principal_33, e1_.logo_liste AS logo_liste_34, e1_.logo_fiche AS logo_fiche_35, e1_.diaporama_actif AS diaporama_actif_36, e1_.images_diaporama AS images_diaporama_37, e1_.participant AS participant_38, e1_.catholique AS catholique_39, e1_.age_admission AS age_admission_40, e1_.actif AS actif_41, e1_.internat AS internat_42, e1_.has_internat AS has_internat_43, e1_.types_internat AS types_internat_44, e1_.sous_contrat AS sous_contrat_45, e1_.alternance AS alternance_46, e1_.type_client AS type_client_47, e1_.bloque_txt_ref AS bloque_txt_ref_48, e1_.facebook AS facebook_49, e1_.bloque_bac2021 AS bloque_bac2021_50, e1_.presence_web AS presence_web_51, e1_.video_plus AS video_plus_52, e1_.diapo_plus AS diapo_plus_53, e1_.jpo_plus AS jpo_plus_54, e1_.doc_plus AS doc_plus_55, e1_.diplome_plus AS diplome_plus_56, e1_.refus AS refus_57, e1_.path AS path_58, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_59, e1_.lva AS lva_60, e1_.lvb AS lvb_61, e1_.numero_administratif_uai AS numero_administratif_uai_62, e1_.siret AS siret_63, e1_.chiffres AS chiffres_64, e1_.id AS id_65, e1_.maj AS maj_66, t2_.actif AS actif_67, t2_.contenu AS contenu_68, t2_.id AS id_69, e1_.gestionnaire_id AS gestionnaire_id_70, e1_.ville_id AS ville_id_71, e1_.categorie_primaire_id AS categorie_primaire_id_72, e1_.region_id AS region_id_73, e1_.departement_id AS departement_id_74, e1_.categorie_organisme_id AS categorie_organisme_id_75, e1_.rubrique AS rubrique_76, e1_.internat2_id AS internat2_id_77, e1_.etablissement_lie_id AS etablissement_lie_id_78, e1_.logo_id AS logo_id_79, e1_.diapo_principal_id AS diapo_principal_id_80, t2_.etablissement_id AS etablissement_id_81, t2_.template_id AS template_id_82 FROM video v0_ INNER JOIN video_etablissement v4_ ON v0_.id = v4_.video_id INNER JOIN etablissement e3_ ON e3_.id = v4_.etablissement_id LEFT JOIN video_etablissement v5_ ON v0_.id = v5_.video_id LEFT JOIN etablissement e1_ ON e1_.id = v5_.etablissement_id LEFT JOIN texte_referencement t2_ ON e1_.id = t2_.etablissement_id WHERE e3_.video_plus = 1 ORDER BY RAND() ASC LIMIT 5
SELECT
v0_.id AS id_0,
v0_.titre AS titre_1,
v0_.url AS url_2,
v0_.actif AS actif_3,
v0_.position AS position_4,
v0_.texte AS texte_5,
v0_.file_name AS file_name_6,
v0_.file_size AS file_size_7,
v0_.updated_at AS updated_at_8,
v0_.file_name_source AS file_name_source_9,
v0_.file_size_source AS file_size_source_10,
v0_.date_crea AS date_crea_11,
v0_.date_maj AS date_maj_12,
e1_.type AS type_13,
e1_.nombre_eleves AS nombre_eleves_14,
e1_.url AS url_15,
e1_.video AS video_16,
e1_.mots_cles AS mots_cles_17,
e1_.denomination AS denomination_18,
e1_.denomination_sigle AS denomination_sigle_19,
e1_.denomination_extension AS denomination_extension_20,
e1_.denomination_abregee AS denomination_abregee_21,
e1_.droit_page_web AS droit_page_web_22,
e1_.droit_actualite AS droit_actualite_23,
e1_.adresse1 AS adresse1_24,
e1_.adresse2 AS adresse2_25,
e1_.adresse3 AS adresse3_26,
e1_.code_postal AS code_postal_27,
e1_.cedex AS cedex_28,
e1_.latitude AS latitude_29,
e1_.longitude AS longitude_30,
e1_.telephone_principal AS telephone_principal_31,
e1_.fax AS fax_32,
e1_.email_principal AS email_principal_33,
e1_.logo_liste AS logo_liste_34,
e1_.logo_fiche AS logo_fiche_35,
e1_.diaporama_actif AS diaporama_actif_36,
e1_.images_diaporama AS images_diaporama_37,
e1_.participant AS participant_38,
e1_.catholique AS catholique_39,
e1_.age_admission AS age_admission_40,
e1_.actif AS actif_41,
e1_.internat AS internat_42,
e1_.has_internat AS has_internat_43,
e1_.types_internat AS types_internat_44,
e1_.sous_contrat AS sous_contrat_45,
e1_.alternance AS alternance_46,
e1_.type_client AS type_client_47,
e1_.bloque_txt_ref AS bloque_txt_ref_48,
e1_.facebook AS facebook_49,
e1_.bloque_bac2021 AS bloque_bac2021_50,
e1_.presence_web AS presence_web_51,
e1_.video_plus AS video_plus_52,
e1_.diapo_plus AS diapo_plus_53,
e1_.jpo_plus AS jpo_plus_54,
e1_.doc_plus AS doc_plus_55,
e1_.diplome_plus AS diplome_plus_56,
e1_.refus AS refus_57,
e1_.path AS path_58,
e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_59,
e1_.lva AS lva_60,
e1_.lvb AS lvb_61,
e1_.numero_administratif_uai AS numero_administratif_uai_62,
e1_.siret AS siret_63,
e1_.chiffres AS chiffres_64,
e1_.id AS id_65,
e1_.maj AS maj_66,
t2_.actif AS actif_67,
t2_.contenu AS contenu_68,
t2_.id AS id_69,
e1_.gestionnaire_id AS gestionnaire_id_70,
e1_.ville_id AS ville_id_71,
e1_.categorie_primaire_id AS categorie_primaire_id_72,
e1_.region_id AS region_id_73,
e1_.departement_id AS departement_id_74,
e1_.categorie_organisme_id AS categorie_organisme_id_75,
e1_.rubrique AS rubrique_76,
e1_.internat2_id AS internat2_id_77,
e1_.etablissement_lie_id AS etablissement_lie_id_78,
e1_.logo_id AS logo_id_79,
e1_.diapo_principal_id AS diapo_principal_id_80,
t2_.etablissement_id AS etablissement_id_81,
t2_.template_id AS template_id_82
FROM
video v0_
INNER JOIN video_etablissement v4_ ON v0_.id = v4_.video_id
INNER JOIN etablissement e3_ ON e3_.id = v4_.etablissement_id
LEFT JOIN video_etablissement v5_ ON v0_.id = v5_.video_id
LEFT JOIN etablissement e1_ ON e1_.id = v5_.etablissement_id
LEFT JOIN texte_referencement t2_ ON e1_.id = t2_.etablissement_id
WHERE
e3_.video_plus = 1
ORDER BY
RAND() ASC
LIMIT
5
SELECT v0_.id AS id_0, v0_.titre AS titre_1, v0_.url AS url_2, v0_.actif AS actif_3, v0_.position AS position_4, v0_.texte AS texte_5, v0_.file_name AS file_name_6, v0_.file_size AS file_size_7, v0_.updated_at AS updated_at_8, v0_.file_name_source AS file_name_source_9, v0_.file_size_source AS file_size_source_10, v0_.date_crea AS date_crea_11, v0_.date_maj AS date_maj_12, e1_.type AS type_13, e1_.nombre_eleves AS nombre_eleves_14, e1_.url AS url_15, e1_.video AS video_16, e1_.mots_cles AS mots_cles_17, e1_.denomination AS denomination_18, e1_.denomination_sigle AS denomination_sigle_19, e1_.denomination_extension AS denomination_extension_20, e1_.denomination_abregee AS denomination_abregee_21, e1_.droit_page_web AS droit_page_web_22, e1_.droit_actualite AS droit_actualite_23, e1_.adresse1 AS adresse1_24, e1_.adresse2 AS adresse2_25, e1_.adresse3 AS adresse3_26, e1_.code_postal AS code_postal_27, e1_.cedex AS cedex_28, e1_.latitude AS latitude_29, e1_.longitude AS longitude_30, e1_.telephone_principal AS telephone_principal_31, e1_.fax AS fax_32, e1_.email_principal AS email_principal_33, e1_.logo_liste AS logo_liste_34, e1_.logo_fiche AS logo_fiche_35, e1_.diaporama_actif AS diaporama_actif_36, e1_.images_diaporama AS images_diaporama_37, e1_.participant AS participant_38, e1_.catholique AS catholique_39, e1_.age_admission AS age_admission_40, e1_.actif AS actif_41, e1_.internat AS internat_42, e1_.has_internat AS has_internat_43, e1_.types_internat AS types_internat_44, e1_.sous_contrat AS sous_contrat_45, e1_.alternance AS alternance_46, e1_.type_client AS type_client_47, e1_.bloque_txt_ref AS bloque_txt_ref_48, e1_.facebook AS facebook_49, e1_.bloque_bac2021 AS bloque_bac2021_50, e1_.presence_web AS presence_web_51, e1_.video_plus AS video_plus_52, e1_.diapo_plus AS diapo_plus_53, e1_.jpo_plus AS jpo_plus_54, e1_.doc_plus AS doc_plus_55, e1_.diplome_plus AS diplome_plus_56, e1_.refus AS refus_57, e1_.path AS path_58, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_59, e1_.lva AS lva_60, e1_.lvb AS lvb_61, e1_.numero_administratif_uai AS numero_administratif_uai_62, e1_.siret AS siret_63, e1_.chiffres AS chiffres_64, e1_.id AS id_65, e1_.maj AS maj_66, t2_.actif AS actif_67, t2_.contenu AS contenu_68, t2_.id AS id_69, e1_.gestionnaire_id AS gestionnaire_id_70, e1_.ville_id AS ville_id_71, e1_.categorie_primaire_id AS categorie_primaire_id_72, e1_.region_id AS region_id_73, e1_.departement_id AS departement_id_74, e1_.categorie_organisme_id AS categorie_organisme_id_75, e1_.rubrique AS rubrique_76, e1_.internat2_id AS internat2_id_77, e1_.etablissement_lie_id AS etablissement_lie_id_78, e1_.logo_id AS logo_id_79, e1_.diapo_principal_id AS diapo_principal_id_80, t2_.etablissement_id AS etablissement_id_81, t2_.template_id AS template_id_82 FROM video v0_ INNER JOIN video_etablissement v4_ ON v0_.id = v4_.video_id INNER JOIN etablissement e3_ ON e3_.id = v4_.etablissement_id LEFT JOIN video_etablissement v5_ ON v0_.id = v5_.video_id LEFT JOIN etablissement e1_ ON e1_.id = v5_.etablissement_id LEFT JOIN texte_referencement t2_ ON e1_.id = t2_.etablissement_id WHERE e3_.video_plus = 1 ORDER BY RAND() ASC LIMIT 5;
|
8.50 ms
(2.96%)
|
2 |
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'aep'
AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;
|
6.31 ms
(2.20%)
|
12 |
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 = ?
Parameters: [
"ET013-100"
]
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 = ?
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 = 'ET013-100';
|
5.91 ms
(2.06%)
|
1 |
SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ WHERE j0_.etablissement_id IS NOT NULL AND j0_.date >= CURRENT_TIMESTAMP ORDER BY j0_.date ASC LIMIT 3
SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ WHERE j0_.etablissement_id IS NOT NULL AND j0_.date >= CURRENT_TIMESTAMP ORDER BY j0_.date ASC LIMIT 3;
|
5.47 ms
(1.91%)
|
1 |
SELECT c.COLUMN_NAME AS field,
c.COLUMN_TYPE AS type,
c.IS_NULLABLE AS `null`,
c.COLUMN_KEY AS `key`,
c.COLUMN_DEFAULT AS `default`,
c.EXTRA,
c.COLUMN_COMMENT AS comment,
c.CHARACTER_SET_NAME AS characterset,
c.COLLATION_NAME AS collation
FROM information_schema.COLUMNS c
INNER JOIN information_schema.TABLES t
ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters: [
"aep"
"aep"
"doctrine_migration_versions"
]
SELECT c.COLUMN_NAME AS field,
c.COLUMN_TYPE AS type,
c.IS_NULLABLE AS `null`,
c.COLUMN_KEY AS `key`,
c.COLUMN_DEFAULT AS `default`,
c.EXTRA,
c.COLUMN_COMMENT AS comment,
c.CHARACTER_SET_NAME AS characterset,
c.COLLATION_NAME AS collation
FROM information_schema.COLUMNS c
INNER JOIN information_schema.TABLES t
ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'aep' AND t.TABLE_SCHEMA = 'aep' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
|
3.57 ms
(1.24%)
|
1 |
SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ INNER JOIN etablissement e1_ ON j0_.etablissement_id = e1_.id WHERE e1_.jpo_plus = 1 AND j0_.date >= ? ORDER BY j0_.date ASC LIMIT 35
Parameters: [
"2026-09-10"
]
SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ INNER JOIN etablissement e1_ ON j0_.etablissement_id = e1_.id WHERE e1_.jpo_plus = 1 AND j0_.date >= '2026-09-10' ORDER BY j0_.date ASC LIMIT 35;
|
3.48 ms
(1.21%)
|
1 |
SELECT DISTINCT k.CONSTRAINT_NAME,
k.COLUMN_NAME,
k.REFERENCED_TABLE_NAME,
k.REFERENCED_COLUMN_NAME,
k.ORDINAL_POSITION
FROM information_schema.key_column_usage k WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION
Parameters: [
"aep"
"doctrine_migration_versions"
]
SELECT DISTINCT k.CONSTRAINT_NAME,
k.COLUMN_NAME,
k.REFERENCED_TABLE_NAME,
k.REFERENCED_COLUMN_NAME,
k.ORDINAL_POSITION
FROM information_schema.key_column_usage k WHERE k.TABLE_SCHEMA = 'aep' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION;
|
3.04 ms
(1.06%)
|
9 |
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 = '13001';
|
3.04 ms
(1.06%)
|
1 |
SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ WHERE j0_.etablissement_id IS NOT NULL AND j0_.date >= CURRENT_TIMESTAMP ORDER BY j0_.date ASC LIMIT 6
SELECT j0_.date_publidation AS date_publidation_0, j0_.date_actualisation AS date_actualisation_1, j0_.lieu AS lieu_2, j0_.contenu AS contenu_3, j0_.updated AS updated_4, j0_.date AS date_5, j0_.heure_debut AS heure_debut_6, j0_.heure_fin AS heure_fin_7, j0_.file_name AS file_name_8, j0_.file_size AS file_size_9, j0_.legende AS legende_10, j0_.id AS id_11, j0_.image1_name AS image1_name_12, j0_.image1_original_name AS image1_original_name_13, j0_.image1_mime_type AS image1_mime_type_14, j0_.image1_size AS image1_size_15, j0_.image1_dimensions AS image1_dimensions_16, j0_.image2_name AS image2_name_17, j0_.image2_original_name AS image2_original_name_18, j0_.image2_mime_type AS image2_mime_type_19, j0_.image2_size AS image2_size_20, j0_.image2_dimensions AS image2_dimensions_21, j0_.image3_name AS image3_name_22, j0_.image3_original_name AS image3_original_name_23, j0_.image3_mime_type AS image3_mime_type_24, j0_.image3_size AS image3_size_25, j0_.image3_dimensions AS image3_dimensions_26, j0_.etablissement_id AS etablissement_id_27 FROM jpo j0_ WHERE j0_.etablissement_id IS NOT NULL AND j0_.date >= CURRENT_TIMESTAMP ORDER BY j0_.date ASC LIMIT 6;
|
2.90 ms
(1.01%)
|
9 |
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: [
"GE013-37"
]
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 = 'GE013-37';
|
2.23 ms
(0.78%)
|
6 |
SELECT DATABASE()
|
1.84 ms
(0.64%)
|
1 |
SELECT t.TABLE_NAME,
t.ENGINE,
t.AUTO_INCREMENT,
t.TABLE_COMMENT,
t.CREATE_OPTIONS,
t.TABLE_COLLATION,
ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters: [
"aep"
"doctrine_migration_versions"
]
SELECT t.TABLE_NAME,
t.ENGINE,
t.AUTO_INCREMENT,
t.TABLE_COMMENT,
t.CREATE_OPTIONS,
t.TABLE_COLLATION,
ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'aep' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
|
1.81 ms
(0.63%)
|
6 |
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 = 1227;
|
1.70 ms
(0.59%)
|
4 |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.slug AS slug_2, p0_.texte AS texte_3, p0_.metadesc AS metadesc_4, p0_.date AS date_5, p0_.ordre AS ordre_6, p0_.categorie_id AS categorie_id_7 FROM page p0_ WHERE p0_.slug = ?
Parameters: [
"home-mise-en-avant"
]
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.slug AS slug_2, p0_.texte AS texte_3, p0_.metadesc AS metadesc_4, p0_.date AS date_5, p0_.ordre AS ordre_6, p0_.categorie_id AS categorie_id_7 FROM page p0_ WHERE p0_.slug = 'home-mise-en-avant';
|
1.57 ms
(0.55%)
|
1 |
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id IN (?)
Parameters: [
[
"GE033-13"
"GE033-11"
]
]
SELECT
t0.type AS type_1,
t0.nombre_eleves AS nombre_eleves_2,
t0.url AS url_3,
t0.video AS video_4,
t0.mots_cles AS mots_cles_5,
t0.denomination AS denomination_6,
t0.denomination_sigle AS denomination_sigle_7,
t0.denomination_extension AS denomination_extension_8,
t0.denomination_abregee AS denomination_abregee_9,
t0.droit_page_web AS droit_page_web_10,
t0.droit_actualite AS droit_actualite_11,
t0.adresse1 AS adresse1_12,
t0.adresse2 AS adresse2_13,
t0.adresse3 AS adresse3_14,
t0.code_postal AS code_postal_15,
t0.cedex AS cedex_16,
t0.latitude AS latitude_17,
t0.longitude AS longitude_18,
t0.telephone_principal AS telephone_principal_19,
t0.fax AS fax_20,
t0.email_principal AS email_principal_21,
t0.logo_liste AS logo_liste_22,
t0.logo_fiche AS logo_fiche_23,
t0.diaporama_actif AS diaporama_actif_24,
t0.images_diaporama AS images_diaporama_25,
t0.participant AS participant_26,
t0.catholique AS catholique_27,
t0.age_admission AS age_admission_28,
t0.actif AS actif_29,
t0.internat AS internat_30,
t0.has_internat AS has_internat_31,
t0.types_internat AS types_internat_32,
t0.sous_contrat AS sous_contrat_33,
t0.alternance AS alternance_34,
t0.type_client AS type_client_35,
t0.bloque_txt_ref AS bloque_txt_ref_36,
t0.facebook AS facebook_37,
t0.bloque_bac2021 AS bloque_bac2021_38,
t0.presence_web AS presence_web_39,
t0.video_plus AS video_plus_40,
t0.diapo_plus AS diapo_plus_41,
t0.jpo_plus AS jpo_plus_42,
t0.doc_plus AS doc_plus_43,
t0.diplome_plus AS diplome_plus_44,
t0.refus AS refus_45,
t0.path AS path_46,
t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47,
t0.lva AS lva_48,
t0.lvb AS lvb_49,
t0.numero_administratif_uai AS numero_administratif_uai_50,
t0.siret AS siret_51,
t0.chiffres AS chiffres_52,
t0.id AS id_53,
t0.maj AS maj_54,
t0.gestionnaire_id AS gestionnaire_id_55,
t56.type AS type_57,
t56.nombre_eleves AS nombre_eleves_58,
t56.url AS url_59,
t56.video AS video_60,
t56.mots_cles AS mots_cles_61,
t56.denomination AS denomination_62,
t56.denomination_sigle AS denomination_sigle_63,
t56.denomination_extension AS denomination_extension_64,
t56.denomination_abregee AS denomination_abregee_65,
t56.droit_page_web AS droit_page_web_66,
t56.droit_actualite AS droit_actualite_67,
t56.adresse1 AS adresse1_68,
t56.adresse2 AS adresse2_69,
t56.adresse3 AS adresse3_70,
t56.code_postal AS code_postal_71,
t56.cedex AS cedex_72,
t56.latitude AS latitude_73,
t56.longitude AS longitude_74,
t56.telephone_principal AS telephone_principal_75,
t56.fax AS fax_76,
t56.email_principal AS email_principal_77,
t56.logo_liste AS logo_liste_78,
t56.logo_fiche AS logo_fiche_79,
t56.diaporama_actif AS diaporama_actif_80,
t56.images_diaporama AS images_diaporama_81,
t56.participant AS participant_82,
t56.catholique AS catholique_83,
t56.age_admission AS age_admission_84,
t56.actif AS actif_85,
t56.internat AS internat_86,
t56.has_internat AS has_internat_87,
t56.types_internat AS types_internat_88,
t56.sous_contrat AS sous_contrat_89,
t56.alternance AS alternance_90,
t56.type_client AS type_client_91,
t56.bloque_txt_ref AS bloque_txt_ref_92,
t56.facebook AS facebook_93,
t56.bloque_bac2021 AS bloque_bac2021_94,
t56.presence_web AS presence_web_95,
t56.video_plus AS video_plus_96,
t56.diapo_plus AS diapo_plus_97,
t56.jpo_plus AS jpo_plus_98,
t56.doc_plus AS doc_plus_99,
t56.diplome_plus AS diplome_plus_100,
t56.refus AS refus_101,
t56.path AS path_102,
t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103,
t56.lva AS lva_104,
t56.lvb AS lvb_105,
t56.numero_administratif_uai AS numero_administratif_uai_106,
t56.siret AS siret_107,
t56.chiffres AS chiffres_108,
t56.id AS id_109,
t56.maj AS maj_110,
t56.gestionnaire_id AS gestionnaire_id_111,
t56.ville_id AS ville_id_112,
t56.categorie_primaire_id AS categorie_primaire_id_113,
t56.region_id AS region_id_114,
t56.departement_id AS departement_id_115,
t56.categorie_organisme_id AS categorie_organisme_id_116,
t56.rubrique AS rubrique_117,
t56.internat2_id AS internat2_id_118,
t56.etablissement_lie_id AS etablissement_lie_id_119,
t56.logo_id AS logo_id_120,
t56.diapo_principal_id AS diapo_principal_id_121,
t0.ville_id AS ville_id_122,
t123.actif AS actif_124,
t123.contenu AS contenu_125,
t123.id AS id_126,
t123.etablissement_id AS etablissement_id_127,
t123.template_id AS template_id_128,
t0.categorie_primaire_id AS categorie_primaire_id_129,
t0.region_id AS region_id_130,
t0.departement_id AS departement_id_131,
t0.categorie_organisme_id AS categorie_organisme_id_132,
t0.rubrique AS rubrique_133,
t0.internat2_id AS internat2_id_134,
t0.etablissement_lie_id AS etablissement_lie_id_135,
t0.logo_id AS logo_id_136,
t0.diapo_principal_id AS diapo_principal_id_137
FROM
etablissement t0
LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id
LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id
WHERE
t0.id IN (?)
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id IN ('GE033-13', 'GE033-11');
|
1.32 ms
(0.46%)
|
1 |
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, e1_.type AS type_54, e1_.nombre_eleves AS nombre_eleves_55, e1_.url AS url_56, e1_.video AS video_57, e1_.mots_cles AS mots_cles_58, e1_.denomination AS denomination_59, e1_.denomination_sigle AS denomination_sigle_60, e1_.denomination_extension AS denomination_extension_61, e1_.denomination_abregee AS denomination_abregee_62, e1_.droit_page_web AS droit_page_web_63, e1_.droit_actualite AS droit_actualite_64, e1_.adresse1 AS adresse1_65, e1_.adresse2 AS adresse2_66, e1_.adresse3 AS adresse3_67, e1_.code_postal AS code_postal_68, e1_.cedex AS cedex_69, e1_.latitude AS latitude_70, e1_.longitude AS longitude_71, e1_.telephone_principal AS telephone_principal_72, e1_.fax AS fax_73, e1_.email_principal AS email_principal_74, e1_.logo_liste AS logo_liste_75, e1_.logo_fiche AS logo_fiche_76, e1_.diaporama_actif AS diaporama_actif_77, e1_.images_diaporama AS images_diaporama_78, e1_.participant AS participant_79, e1_.catholique AS catholique_80, e1_.age_admission AS age_admission_81, e1_.actif AS actif_82, e1_.internat AS internat_83, e1_.has_internat AS has_internat_84, e1_.types_internat AS types_internat_85, e1_.sous_contrat AS sous_contrat_86, e1_.alternance AS alternance_87, e1_.type_client AS type_client_88, e1_.bloque_txt_ref AS bloque_txt_ref_89, e1_.facebook AS facebook_90, e1_.bloque_bac2021 AS bloque_bac2021_91, e1_.presence_web AS presence_web_92, e1_.video_plus AS video_plus_93, e1_.diapo_plus AS diapo_plus_94, e1_.jpo_plus AS jpo_plus_95, e1_.doc_plus AS doc_plus_96, e1_.diplome_plus AS diplome_plus_97, e1_.refus AS refus_98, e1_.path AS path_99, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_100, e1_.lva AS lva_101, e1_.lvb AS lvb_102, e1_.numero_administratif_uai AS numero_administratif_uai_103, e1_.siret AS siret_104, e1_.chiffres AS chiffres_105, e1_.id AS id_106, e1_.maj AS maj_107, t2_.actif AS actif_108, t2_.contenu AS contenu_109, t2_.id AS id_110, v3_.slug AS slug_111, v3_.libelle AS libelle_112, v3_.code_postal AS code_postal_113, v3_.email_delegue AS email_delegue_114, v3_.onglets AS onglets_115, v3_.id AS id_116, v3_.maj AS maj_117, v4_.latitude AS latitude_118, v4_.longitude AS longitude_119, v4_.id AS id_120, d5_.slug AS slug_121, d5_.libelle AS libelle_122, d5_.onglets AS onglets_123, d5_.id AS id_124, d5_.maj AS maj_125, d6_.latitude AS latitude_126, d6_.longitude AS longitude_127, d6_.id AS id_128, a7_.slug AS slug_129, a7_.libelle AS libelle_130, a7_.id AS id_131, a7_.maj AS maj_132, r8_.libelle AS libelle_133, r8_.slug AS slug_134, r8_.region_adm AS region_adm_135, r8_.ancienne AS ancienne_136, r8_.onglets AS onglets_137, r8_.id AS id_138, r8_.maj AS maj_139, p9_.libelle AS libelle_140, p9_.id AS id_141, p9_.maj AS maj_142, c10_.libelle AS libelle_143, c10_.id AS id_144, c10_.maj AS maj_145, t11_.actif AS actif_146, t11_.contenu AS contenu_147, t11_.id AS id_148, d12_.id AS id_149, d12_.titre AS titre_150, d12_.texte AS texte_151, d12_.actif AS actif_152, d12_.position AS position_153, d12_.principal AS principal_154, d12_.date_crea AS date_crea_155, d12_.date_maj AS date_maj_156, d13_.id AS id_157, d13_.titre AS titre_158, d13_.legende AS legende_159, d13_.actif AS actif_160, d13_.position AS position_161, d13_.file_name AS file_name_162, d13_.file_size AS file_size_163, d13_.updated_at AS updated_at_164, d13_.file_name_source AS file_name_source_165, d13_.file_size_source AS file_size_source_166, v14_.id AS id_167, v14_.titre AS titre_168, v14_.url AS url_169, v14_.actif AS actif_170, v14_.position AS position_171, v14_.texte AS texte_172, v14_.file_name AS file_name_173, v14_.file_size AS file_size_174, v14_.updated_at AS updated_at_175, v14_.file_name_source AS file_name_source_176, v14_.file_size_source AS file_size_source_177, v14_.date_crea AS date_crea_178, v14_.date_maj AS date_maj_179, l15_.id AS id_180, l15_.file_name AS file_name_181, l15_.file_size AS file_size_182, l15_.updated_at AS updated_at_183, l15_.file_name_source AS file_name_source_184, l15_.file_size_source AS file_size_source_185, l15_.date_crea AS date_crea_186, l15_.date_maj AS date_maj_187, e0_.gestionnaire_id AS gestionnaire_id_188, e0_.ville_id AS ville_id_189, e0_.categorie_primaire_id AS categorie_primaire_id_190, e0_.region_id AS region_id_191, e0_.departement_id AS departement_id_192, e0_.categorie_organisme_id AS categorie_organisme_id_193, e0_.rubrique AS rubrique_194, e0_.internat2_id AS internat2_id_195, e0_.etablissement_lie_id AS etablissement_lie_id_196, e0_.logo_id AS logo_id_197, e0_.diapo_principal_id AS diapo_principal_id_198, e1_.gestionnaire_id AS gestionnaire_id_199, e1_.ville_id AS ville_id_200, e1_.categorie_primaire_id AS categorie_primaire_id_201, e1_.region_id AS region_id_202, e1_.departement_id AS departement_id_203, e1_.categorie_organisme_id AS categorie_organisme_id_204, e1_.rubrique AS rubrique_205, e1_.internat2_id AS internat2_id_206, e1_.etablissement_lie_id AS etablissement_lie_id_207, e1_.logo_id AS logo_id_208, e1_.diapo_principal_id AS diapo_principal_id_209, t2_.etablissement_id AS etablissement_id_210, t2_.template_id AS template_id_211, v3_.departement_id AS departement_id_212, v4_.ville_id AS ville_id_213, d5_.ancienne_region_id AS ancienne_region_id_214, d5_.region_id AS region_id_215, d6_.departement_id AS departement_id_216, a7_.region_id AS region_id_217, r8_.pays_id AS pays_id_218, t11_.etablissement_id AS etablissement_id_219, t11_.template_id AS template_id_220, d13_.diaporama_id AS diaporama_id_221 FROM etablissement e0_ LEFT JOIN etablissement e1_ ON e0_.gestionnaire_id = e1_.id LEFT JOIN texte_referencement t2_ ON e1_.id = t2_.etablissement_id LEFT JOIN ville v3_ ON e0_.ville_id = v3_.id LEFT JOIN ville_coordonnees v4_ ON v3_.id = v4_.ville_id LEFT JOIN departement d5_ ON v3_.departement_id = d5_.id LEFT JOIN departement_coordonnees d6_ ON d5_.id = d6_.departement_id LEFT JOIN ancienne_region a7_ ON d5_.ancienne_region_id = a7_.id LEFT JOIN region r8_ ON a7_.region_id = r8_.id LEFT JOIN pays p9_ ON r8_.pays_id = p9_.id LEFT JOIN categorie c10_ ON e0_.categorie_primaire_id = c10_.id LEFT JOIN texte_referencement t11_ ON e0_.id = t11_.etablissement_id LEFT JOIN diaporama_etablissement d16_ ON e0_.id = d16_.etablissement_id LEFT JOIN diaporama d12_ ON d12_.id = d16_.diaporama_id LEFT JOIN diaporama_photo d13_ ON d12_.id = d13_.diaporama_id LEFT JOIN video_etablissement v17_ ON e0_.id = v17_.etablissement_id LEFT JOIN video v14_ ON v14_.id = v17_.video_id LEFT JOIN logo l15_ ON e0_.logo_id = l15_.id WHERE e0_.id IN (?) ORDER BY d13_.position ASC
Parameters: [
[
"ET059-467"
"ET006-153"
"ET092-47"
"ET003-20"
"ET092-78"
"ET092-48"
"ET095-59"
"ET080-13"
]
]
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,
e1_.type AS type_54,
e1_.nombre_eleves AS nombre_eleves_55,
e1_.url AS url_56,
e1_.video AS video_57,
e1_.mots_cles AS mots_cles_58,
e1_.denomination AS denomination_59,
e1_.denomination_sigle AS denomination_sigle_60,
e1_.denomination_extension AS denomination_extension_61,
e1_.denomination_abregee AS denomination_abregee_62,
e1_.droit_page_web AS droit_page_web_63,
e1_.droit_actualite AS droit_actualite_64,
e1_.adresse1 AS adresse1_65,
e1_.adresse2 AS adresse2_66,
e1_.adresse3 AS adresse3_67,
e1_.code_postal AS code_postal_68,
e1_.cedex AS cedex_69,
e1_.latitude AS latitude_70,
e1_.longitude AS longitude_71,
e1_.telephone_principal AS telephone_principal_72,
e1_.fax AS fax_73,
e1_.email_principal AS email_principal_74,
e1_.logo_liste AS logo_liste_75,
e1_.logo_fiche AS logo_fiche_76,
e1_.diaporama_actif AS diaporama_actif_77,
e1_.images_diaporama AS images_diaporama_78,
e1_.participant AS participant_79,
e1_.catholique AS catholique_80,
e1_.age_admission AS age_admission_81,
e1_.actif AS actif_82,
e1_.internat AS internat_83,
e1_.has_internat AS has_internat_84,
e1_.types_internat AS types_internat_85,
e1_.sous_contrat AS sous_contrat_86,
e1_.alternance AS alternance_87,
e1_.type_client AS type_client_88,
e1_.bloque_txt_ref AS bloque_txt_ref_89,
e1_.facebook AS facebook_90,
e1_.bloque_bac2021 AS bloque_bac2021_91,
e1_.presence_web AS presence_web_92,
e1_.video_plus AS video_plus_93,
e1_.diapo_plus AS diapo_plus_94,
e1_.jpo_plus AS jpo_plus_95,
e1_.doc_plus AS doc_plus_96,
e1_.diplome_plus AS diplome_plus_97,
e1_.refus AS refus_98,
e1_.path AS path_99,
e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_100,
e1_.lva AS lva_101,
e1_.lvb AS lvb_102,
e1_.numero_administratif_uai AS numero_administratif_uai_103,
e1_.siret AS siret_104,
e1_.chiffres AS chiffres_105,
e1_.id AS id_106,
e1_.maj AS maj_107,
t2_.actif AS actif_108,
t2_.contenu AS contenu_109,
t2_.id AS id_110,
v3_.slug AS slug_111,
v3_.libelle AS libelle_112,
v3_.code_postal AS code_postal_113,
v3_.email_delegue AS email_delegue_114,
v3_.onglets AS onglets_115,
v3_.id AS id_116,
v3_.maj AS maj_117,
v4_.latitude AS latitude_118,
v4_.longitude AS longitude_119,
v4_.id AS id_120,
d5_.slug AS slug_121,
d5_.libelle AS libelle_122,
d5_.onglets AS onglets_123,
d5_.id AS id_124,
d5_.maj AS maj_125,
d6_.latitude AS latitude_126,
d6_.longitude AS longitude_127,
d6_.id AS id_128,
a7_.slug AS slug_129,
a7_.libelle AS libelle_130,
a7_.id AS id_131,
a7_.maj AS maj_132,
r8_.libelle AS libelle_133,
r8_.slug AS slug_134,
r8_.region_adm AS region_adm_135,
r8_.ancienne AS ancienne_136,
r8_.onglets AS onglets_137,
r8_.id AS id_138,
r8_.maj AS maj_139,
p9_.libelle AS libelle_140,
p9_.id AS id_141,
p9_.maj AS maj_142,
c10_.libelle AS libelle_143,
c10_.id AS id_144,
c10_.maj AS maj_145,
t11_.actif AS actif_146,
t11_.contenu AS contenu_147,
t11_.id AS id_148,
d12_.id AS id_149,
d12_.titre AS titre_150,
d12_.texte AS texte_151,
d12_.actif AS actif_152,
d12_.position AS position_153,
d12_.principal AS principal_154,
d12_.date_crea AS date_crea_155,
d12_.date_maj AS date_maj_156,
d13_.id AS id_157,
d13_.titre AS titre_158,
d13_.legende AS legende_159,
d13_.actif AS actif_160,
d13_.position AS position_161,
d13_.file_name AS file_name_162,
d13_.file_size AS file_size_163,
d13_.updated_at AS updated_at_164,
d13_.file_name_source AS file_name_source_165,
d13_.file_size_source AS file_size_source_166,
v14_.id AS id_167,
v14_.titre AS titre_168,
v14_.url AS url_169,
v14_.actif AS actif_170,
v14_.position AS position_171,
v14_.texte AS texte_172,
v14_.file_name AS file_name_173,
v14_.file_size AS file_size_174,
v14_.updated_at AS updated_at_175,
v14_.file_name_source AS file_name_source_176,
v14_.file_size_source AS file_size_source_177,
v14_.date_crea AS date_crea_178,
v14_.date_maj AS date_maj_179,
l15_.id AS id_180,
l15_.file_name AS file_name_181,
l15_.file_size AS file_size_182,
l15_.updated_at AS updated_at_183,
l15_.file_name_source AS file_name_source_184,
l15_.file_size_source AS file_size_source_185,
l15_.date_crea AS date_crea_186,
l15_.date_maj AS date_maj_187,
e0_.gestionnaire_id AS gestionnaire_id_188,
e0_.ville_id AS ville_id_189,
e0_.categorie_primaire_id AS categorie_primaire_id_190,
e0_.region_id AS region_id_191,
e0_.departement_id AS departement_id_192,
e0_.categorie_organisme_id AS categorie_organisme_id_193,
e0_.rubrique AS rubrique_194,
e0_.internat2_id AS internat2_id_195,
e0_.etablissement_lie_id AS etablissement_lie_id_196,
e0_.logo_id AS logo_id_197,
e0_.diapo_principal_id AS diapo_principal_id_198,
e1_.gestionnaire_id AS gestionnaire_id_199,
e1_.ville_id AS ville_id_200,
e1_.categorie_primaire_id AS categorie_primaire_id_201,
e1_.region_id AS region_id_202,
e1_.departement_id AS departement_id_203,
e1_.categorie_organisme_id AS categorie_organisme_id_204,
e1_.rubrique AS rubrique_205,
e1_.internat2_id AS internat2_id_206,
e1_.etablissement_lie_id AS etablissement_lie_id_207,
e1_.logo_id AS logo_id_208,
e1_.diapo_principal_id AS diapo_principal_id_209,
t2_.etablissement_id AS etablissement_id_210,
t2_.template_id AS template_id_211,
v3_.departement_id AS departement_id_212,
v4_.ville_id AS ville_id_213,
d5_.ancienne_region_id AS ancienne_region_id_214,
d5_.region_id AS region_id_215,
d6_.departement_id AS departement_id_216,
a7_.region_id AS region_id_217,
r8_.pays_id AS pays_id_218,
t11_.etablissement_id AS etablissement_id_219,
t11_.template_id AS template_id_220,
d13_.diaporama_id AS diaporama_id_221
FROM
etablissement e0_
LEFT JOIN etablissement e1_ ON e0_.gestionnaire_id = e1_.id
LEFT JOIN texte_referencement t2_ ON e1_.id = t2_.etablissement_id
LEFT JOIN ville v3_ ON e0_.ville_id = v3_.id
LEFT JOIN ville_coordonnees v4_ ON v3_.id = v4_.ville_id
LEFT JOIN departement d5_ ON v3_.departement_id = d5_.id
LEFT JOIN departement_coordonnees d6_ ON d5_.id = d6_.departement_id
LEFT JOIN ancienne_region a7_ ON d5_.ancienne_region_id = a7_.id
LEFT JOIN region r8_ ON a7_.region_id = r8_.id
LEFT JOIN pays p9_ ON r8_.pays_id = p9_.id
LEFT JOIN categorie c10_ ON e0_.categorie_primaire_id = c10_.id
LEFT JOIN texte_referencement t11_ ON e0_.id = t11_.etablissement_id
LEFT JOIN diaporama_etablissement d16_ ON e0_.id = d16_.etablissement_id
LEFT JOIN diaporama d12_ ON d12_.id = d16_.diaporama_id
LEFT JOIN diaporama_photo d13_ ON d12_.id = d13_.diaporama_id
LEFT JOIN video_etablissement v17_ ON e0_.id = v17_.etablissement_id
LEFT JOIN video v14_ ON v14_.id = v17_.video_id
LEFT JOIN logo l15_ ON e0_.logo_id = l15_.id
WHERE
e0_.id IN (?)
ORDER BY
d13_.position ASC
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, e1_.type AS type_54, e1_.nombre_eleves AS nombre_eleves_55, e1_.url AS url_56, e1_.video AS video_57, e1_.mots_cles AS mots_cles_58, e1_.denomination AS denomination_59, e1_.denomination_sigle AS denomination_sigle_60, e1_.denomination_extension AS denomination_extension_61, e1_.denomination_abregee AS denomination_abregee_62, e1_.droit_page_web AS droit_page_web_63, e1_.droit_actualite AS droit_actualite_64, e1_.adresse1 AS adresse1_65, e1_.adresse2 AS adresse2_66, e1_.adresse3 AS adresse3_67, e1_.code_postal AS code_postal_68, e1_.cedex AS cedex_69, e1_.latitude AS latitude_70, e1_.longitude AS longitude_71, e1_.telephone_principal AS telephone_principal_72, e1_.fax AS fax_73, e1_.email_principal AS email_principal_74, e1_.logo_liste AS logo_liste_75, e1_.logo_fiche AS logo_fiche_76, e1_.diaporama_actif AS diaporama_actif_77, e1_.images_diaporama AS images_diaporama_78, e1_.participant AS participant_79, e1_.catholique AS catholique_80, e1_.age_admission AS age_admission_81, e1_.actif AS actif_82, e1_.internat AS internat_83, e1_.has_internat AS has_internat_84, e1_.types_internat AS types_internat_85, e1_.sous_contrat AS sous_contrat_86, e1_.alternance AS alternance_87, e1_.type_client AS type_client_88, e1_.bloque_txt_ref AS bloque_txt_ref_89, e1_.facebook AS facebook_90, e1_.bloque_bac2021 AS bloque_bac2021_91, e1_.presence_web AS presence_web_92, e1_.video_plus AS video_plus_93, e1_.diapo_plus AS diapo_plus_94, e1_.jpo_plus AS jpo_plus_95, e1_.doc_plus AS doc_plus_96, e1_.diplome_plus AS diplome_plus_97, e1_.refus AS refus_98, e1_.path AS path_99, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_100, e1_.lva AS lva_101, e1_.lvb AS lvb_102, e1_.numero_administratif_uai AS numero_administratif_uai_103, e1_.siret AS siret_104, e1_.chiffres AS chiffres_105, e1_.id AS id_106, e1_.maj AS maj_107, t2_.actif AS actif_108, t2_.contenu AS contenu_109, t2_.id AS id_110, v3_.slug AS slug_111, v3_.libelle AS libelle_112, v3_.code_postal AS code_postal_113, v3_.email_delegue AS email_delegue_114, v3_.onglets AS onglets_115, v3_.id AS id_116, v3_.maj AS maj_117, v4_.latitude AS latitude_118, v4_.longitude AS longitude_119, v4_.id AS id_120, d5_.slug AS slug_121, d5_.libelle AS libelle_122, d5_.onglets AS onglets_123, d5_.id AS id_124, d5_.maj AS maj_125, d6_.latitude AS latitude_126, d6_.longitude AS longitude_127, d6_.id AS id_128, a7_.slug AS slug_129, a7_.libelle AS libelle_130, a7_.id AS id_131, a7_.maj AS maj_132, r8_.libelle AS libelle_133, r8_.slug AS slug_134, r8_.region_adm AS region_adm_135, r8_.ancienne AS ancienne_136, r8_.onglets AS onglets_137, r8_.id AS id_138, r8_.maj AS maj_139, p9_.libelle AS libelle_140, p9_.id AS id_141, p9_.maj AS maj_142, c10_.libelle AS libelle_143, c10_.id AS id_144, c10_.maj AS maj_145, t11_.actif AS actif_146, t11_.contenu AS contenu_147, t11_.id AS id_148, d12_.id AS id_149, d12_.titre AS titre_150, d12_.texte AS texte_151, d12_.actif AS actif_152, d12_.position AS position_153, d12_.principal AS principal_154, d12_.date_crea AS date_crea_155, d12_.date_maj AS date_maj_156, d13_.id AS id_157, d13_.titre AS titre_158, d13_.legende AS legende_159, d13_.actif AS actif_160, d13_.position AS position_161, d13_.file_name AS file_name_162, d13_.file_size AS file_size_163, d13_.updated_at AS updated_at_164, d13_.file_name_source AS file_name_source_165, d13_.file_size_source AS file_size_source_166, v14_.id AS id_167, v14_.titre AS titre_168, v14_.url AS url_169, v14_.actif AS actif_170, v14_.position AS position_171, v14_.texte AS texte_172, v14_.file_name AS file_name_173, v14_.file_size AS file_size_174, v14_.updated_at AS updated_at_175, v14_.file_name_source AS file_name_source_176, v14_.file_size_source AS file_size_source_177, v14_.date_crea AS date_crea_178, v14_.date_maj AS date_maj_179, l15_.id AS id_180, l15_.file_name AS file_name_181, l15_.file_size AS file_size_182, l15_.updated_at AS updated_at_183, l15_.file_name_source AS file_name_source_184, l15_.file_size_source AS file_size_source_185, l15_.date_crea AS date_crea_186, l15_.date_maj AS date_maj_187, e0_.gestionnaire_id AS gestionnaire_id_188, e0_.ville_id AS ville_id_189, e0_.categorie_primaire_id AS categorie_primaire_id_190, e0_.region_id AS region_id_191, e0_.departement_id AS departement_id_192, e0_.categorie_organisme_id AS categorie_organisme_id_193, e0_.rubrique AS rubrique_194, e0_.internat2_id AS internat2_id_195, e0_.etablissement_lie_id AS etablissement_lie_id_196, e0_.logo_id AS logo_id_197, e0_.diapo_principal_id AS diapo_principal_id_198, e1_.gestionnaire_id AS gestionnaire_id_199, e1_.ville_id AS ville_id_200, e1_.categorie_primaire_id AS categorie_primaire_id_201, e1_.region_id AS region_id_202, e1_.departement_id AS departement_id_203, e1_.categorie_organisme_id AS categorie_organisme_id_204, e1_.rubrique AS rubrique_205, e1_.internat2_id AS internat2_id_206, e1_.etablissement_lie_id AS etablissement_lie_id_207, e1_.logo_id AS logo_id_208, e1_.diapo_principal_id AS diapo_principal_id_209, t2_.etablissement_id AS etablissement_id_210, t2_.template_id AS template_id_211, v3_.departement_id AS departement_id_212, v4_.ville_id AS ville_id_213, d5_.ancienne_region_id AS ancienne_region_id_214, d5_.region_id AS region_id_215, d6_.departement_id AS departement_id_216, a7_.region_id AS region_id_217, r8_.pays_id AS pays_id_218, t11_.etablissement_id AS etablissement_id_219, t11_.template_id AS template_id_220, d13_.diaporama_id AS diaporama_id_221 FROM etablissement e0_ LEFT JOIN etablissement e1_ ON e0_.gestionnaire_id = e1_.id LEFT JOIN texte_referencement t2_ ON e1_.id = t2_.etablissement_id LEFT JOIN ville v3_ ON e0_.ville_id = v3_.id LEFT JOIN ville_coordonnees v4_ ON v3_.id = v4_.ville_id LEFT JOIN departement d5_ ON v3_.departement_id = d5_.id LEFT JOIN departement_coordonnees d6_ ON d5_.id = d6_.departement_id LEFT JOIN ancienne_region a7_ ON d5_.ancienne_region_id = a7_.id LEFT JOIN region r8_ ON a7_.region_id = r8_.id LEFT JOIN pays p9_ ON r8_.pays_id = p9_.id LEFT JOIN categorie c10_ ON e0_.categorie_primaire_id = c10_.id LEFT JOIN texte_referencement t11_ ON e0_.id = t11_.etablissement_id LEFT JOIN diaporama_etablissement d16_ ON e0_.id = d16_.etablissement_id LEFT JOIN diaporama d12_ ON d12_.id = d16_.diaporama_id LEFT JOIN diaporama_photo d13_ ON d12_.id = d13_.diaporama_id LEFT JOIN video_etablissement v17_ ON e0_.id = v17_.etablissement_id LEFT JOIN video v14_ ON v14_.id = v17_.video_id LEFT JOIN logo l15_ ON e0_.logo_id = l15_.id WHERE e0_.id IN ('ET059-467', 'ET006-153', 'ET092-47', 'ET003-20', 'ET092-78', 'ET092-48', 'ET095-59', 'ET080-13') ORDER BY d13_.position ASC;
|
0.84 ms
(0.29%)
|
1 |
SELECT o0_.id_distant AS id_distant_0, o0_.date_creation AS date_creation_1, o0_.date_actualisation AS date_actualisation_2, o0_.date_validite AS date_validite_3, o0_.libelle AS libelle_4, o0_.description AS description_5, o0_.url AS url_6, o0_.url_image AS url_image_7, o0_.json_ld AS json_ld_8, o0_.id AS id_9, e1_.type AS type_10, e1_.nombre_eleves AS nombre_eleves_11, e1_.url AS url_12, e1_.video AS video_13, e1_.mots_cles AS mots_cles_14, e1_.denomination AS denomination_15, e1_.denomination_sigle AS denomination_sigle_16, e1_.denomination_extension AS denomination_extension_17, e1_.denomination_abregee AS denomination_abregee_18, e1_.droit_page_web AS droit_page_web_19, e1_.droit_actualite AS droit_actualite_20, e1_.adresse1 AS adresse1_21, e1_.adresse2 AS adresse2_22, e1_.adresse3 AS adresse3_23, e1_.code_postal AS code_postal_24, e1_.cedex AS cedex_25, e1_.latitude AS latitude_26, e1_.longitude AS longitude_27, e1_.telephone_principal AS telephone_principal_28, e1_.fax AS fax_29, e1_.email_principal AS email_principal_30, e1_.logo_liste AS logo_liste_31, e1_.logo_fiche AS logo_fiche_32, e1_.diaporama_actif AS diaporama_actif_33, e1_.images_diaporama AS images_diaporama_34, e1_.participant AS participant_35, e1_.catholique AS catholique_36, e1_.age_admission AS age_admission_37, e1_.actif AS actif_38, e1_.internat AS internat_39, e1_.has_internat AS has_internat_40, e1_.types_internat AS types_internat_41, e1_.sous_contrat AS sous_contrat_42, e1_.alternance AS alternance_43, e1_.type_client AS type_client_44, e1_.bloque_txt_ref AS bloque_txt_ref_45, e1_.facebook AS facebook_46, e1_.bloque_bac2021 AS bloque_bac2021_47, e1_.presence_web AS presence_web_48, e1_.video_plus AS video_plus_49, e1_.diapo_plus AS diapo_plus_50, e1_.jpo_plus AS jpo_plus_51, e1_.doc_plus AS doc_plus_52, e1_.diplome_plus AS diplome_plus_53, e1_.refus AS refus_54, e1_.path AS path_55, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_56, e1_.lva AS lva_57, e1_.lvb AS lvb_58, e1_.numero_administratif_uai AS numero_administratif_uai_59, e1_.siret AS siret_60, e1_.chiffres AS chiffres_61, e1_.id AS id_62, e1_.maj AS maj_63, e2_.type AS type_64, e2_.nombre_eleves AS nombre_eleves_65, e2_.url AS url_66, e2_.video AS video_67, e2_.mots_cles AS mots_cles_68, e2_.denomination AS denomination_69, e2_.denomination_sigle AS denomination_sigle_70, e2_.denomination_extension AS denomination_extension_71, e2_.denomination_abregee AS denomination_abregee_72, e2_.droit_page_web AS droit_page_web_73, e2_.droit_actualite AS droit_actualite_74, e2_.adresse1 AS adresse1_75, e2_.adresse2 AS adresse2_76, e2_.adresse3 AS adresse3_77, e2_.code_postal AS code_postal_78, e2_.cedex AS cedex_79, e2_.latitude AS latitude_80, e2_.longitude AS longitude_81, e2_.telephone_principal AS telephone_principal_82, e2_.fax AS fax_83, e2_.email_principal AS email_principal_84, e2_.logo_liste AS logo_liste_85, e2_.logo_fiche AS logo_fiche_86, e2_.diaporama_actif AS diaporama_actif_87, e2_.images_diaporama AS images_diaporama_88, e2_.participant AS participant_89, e2_.catholique AS catholique_90, e2_.age_admission AS age_admission_91, e2_.actif AS actif_92, e2_.internat AS internat_93, e2_.has_internat AS has_internat_94, e2_.types_internat AS types_internat_95, e2_.sous_contrat AS sous_contrat_96, e2_.alternance AS alternance_97, e2_.type_client AS type_client_98, e2_.bloque_txt_ref AS bloque_txt_ref_99, e2_.facebook AS facebook_100, e2_.bloque_bac2021 AS bloque_bac2021_101, e2_.presence_web AS presence_web_102, e2_.video_plus AS video_plus_103, e2_.diapo_plus AS diapo_plus_104, e2_.jpo_plus AS jpo_plus_105, e2_.doc_plus AS doc_plus_106, e2_.diplome_plus AS diplome_plus_107, e2_.refus AS refus_108, e2_.path AS path_109, e2_.composition_ensemble_scolaire AS composition_ensemble_scolaire_110, e2_.lva AS lva_111, e2_.lvb AS lvb_112, e2_.numero_administratif_uai AS numero_administratif_uai_113, e2_.siret AS siret_114, e2_.chiffres AS chiffres_115, e2_.id AS id_116, e2_.maj AS maj_117, t3_.actif AS actif_118, t3_.contenu AS contenu_119, t3_.id AS id_120, v4_.slug AS slug_121, v4_.libelle AS libelle_122, v4_.code_postal AS code_postal_123, v4_.email_delegue AS email_delegue_124, v4_.onglets AS onglets_125, v4_.id AS id_126, v4_.maj AS maj_127, v5_.latitude AS latitude_128, v5_.longitude AS longitude_129, v5_.id AS id_130, d6_.slug AS slug_131, d6_.libelle AS libelle_132, d6_.onglets AS onglets_133, d6_.id AS id_134, d6_.maj AS maj_135, d7_.latitude AS latitude_136, d7_.longitude AS longitude_137, d7_.id AS id_138, a8_.slug AS slug_139, a8_.libelle AS libelle_140, a8_.id AS id_141, a8_.maj AS maj_142, r9_.libelle AS libelle_143, r9_.slug AS slug_144, r9_.region_adm AS region_adm_145, r9_.ancienne AS ancienne_146, r9_.onglets AS onglets_147, r9_.id AS id_148, r9_.maj AS maj_149, p10_.libelle AS libelle_150, p10_.id AS id_151, p10_.maj AS maj_152, c11_.libelle AS libelle_153, c11_.id AS id_154, c11_.maj AS maj_155, t12_.actif AS actif_156, t12_.contenu AS contenu_157, t12_.id AS id_158, o0_.etablissement_id AS etablissement_id_159, o0_.profil_id AS profil_id_160, o0_.contrat_id AS contrat_id_161, e1_.gestionnaire_id AS gestionnaire_id_162, e1_.ville_id AS ville_id_163, e1_.categorie_primaire_id AS categorie_primaire_id_164, e1_.region_id AS region_id_165, e1_.departement_id AS departement_id_166, e1_.categorie_organisme_id AS categorie_organisme_id_167, e1_.rubrique AS rubrique_168, e1_.internat2_id AS internat2_id_169, e1_.etablissement_lie_id AS etablissement_lie_id_170, e1_.logo_id AS logo_id_171, e1_.diapo_principal_id AS diapo_principal_id_172, e2_.gestionnaire_id AS gestionnaire_id_173, e2_.ville_id AS ville_id_174, e2_.categorie_primaire_id AS categorie_primaire_id_175, e2_.region_id AS region_id_176, e2_.departement_id AS departement_id_177, e2_.categorie_organisme_id AS categorie_organisme_id_178, e2_.rubrique AS rubrique_179, e2_.internat2_id AS internat2_id_180, e2_.etablissement_lie_id AS etablissement_lie_id_181, e2_.logo_id AS logo_id_182, e2_.diapo_principal_id AS diapo_principal_id_183, t3_.etablissement_id AS etablissement_id_184, t3_.template_id AS template_id_185, v4_.departement_id AS departement_id_186, v5_.ville_id AS ville_id_187, d6_.ancienne_region_id AS ancienne_region_id_188, d6_.region_id AS region_id_189, d7_.departement_id AS departement_id_190, a8_.region_id AS region_id_191, r9_.pays_id AS pays_id_192, t12_.etablissement_id AS etablissement_id_193, t12_.template_id AS template_id_194 FROM offre_emploi o0_ INNER JOIN etablissement e13_ ON o0_.etablissement_id = e13_.id LEFT JOIN etablissement e1_ ON o0_.etablissement_id = e1_.id LEFT JOIN etablissement e2_ ON e1_.gestionnaire_id = e2_.id LEFT JOIN texte_referencement t3_ ON e2_.id = t3_.etablissement_id LEFT JOIN ville v4_ ON e1_.ville_id = v4_.id LEFT JOIN ville_coordonnees v5_ ON v4_.id = v5_.ville_id LEFT JOIN departement d6_ ON v4_.departement_id = d6_.id LEFT JOIN departement_coordonnees d7_ ON d6_.id = d7_.departement_id LEFT JOIN ancienne_region a8_ ON d6_.ancienne_region_id = a8_.id LEFT JOIN region r9_ ON a8_.region_id = r9_.id LEFT JOIN pays p10_ ON r9_.pays_id = p10_.id LEFT JOIN categorie c11_ ON e1_.categorie_primaire_id = c11_.id LEFT JOIN texte_referencement t12_ ON e1_.id = t12_.etablissement_id WHERE o0_.etablissement_id IS NOT NULL ORDER BY o0_.date_creation DESC LIMIT 3
SELECT
o0_.id_distant AS id_distant_0,
o0_.date_creation AS date_creation_1,
o0_.date_actualisation AS date_actualisation_2,
o0_.date_validite AS date_validite_3,
o0_.libelle AS libelle_4,
o0_.description AS description_5,
o0_.url AS url_6,
o0_.url_image AS url_image_7,
o0_.json_ld AS json_ld_8,
o0_.id AS id_9,
e1_.type AS type_10,
e1_.nombre_eleves AS nombre_eleves_11,
e1_.url AS url_12,
e1_.video AS video_13,
e1_.mots_cles AS mots_cles_14,
e1_.denomination AS denomination_15,
e1_.denomination_sigle AS denomination_sigle_16,
e1_.denomination_extension AS denomination_extension_17,
e1_.denomination_abregee AS denomination_abregee_18,
e1_.droit_page_web AS droit_page_web_19,
e1_.droit_actualite AS droit_actualite_20,
e1_.adresse1 AS adresse1_21,
e1_.adresse2 AS adresse2_22,
e1_.adresse3 AS adresse3_23,
e1_.code_postal AS code_postal_24,
e1_.cedex AS cedex_25,
e1_.latitude AS latitude_26,
e1_.longitude AS longitude_27,
e1_.telephone_principal AS telephone_principal_28,
e1_.fax AS fax_29,
e1_.email_principal AS email_principal_30,
e1_.logo_liste AS logo_liste_31,
e1_.logo_fiche AS logo_fiche_32,
e1_.diaporama_actif AS diaporama_actif_33,
e1_.images_diaporama AS images_diaporama_34,
e1_.participant AS participant_35,
e1_.catholique AS catholique_36,
e1_.age_admission AS age_admission_37,
e1_.actif AS actif_38,
e1_.internat AS internat_39,
e1_.has_internat AS has_internat_40,
e1_.types_internat AS types_internat_41,
e1_.sous_contrat AS sous_contrat_42,
e1_.alternance AS alternance_43,
e1_.type_client AS type_client_44,
e1_.bloque_txt_ref AS bloque_txt_ref_45,
e1_.facebook AS facebook_46,
e1_.bloque_bac2021 AS bloque_bac2021_47,
e1_.presence_web AS presence_web_48,
e1_.video_plus AS video_plus_49,
e1_.diapo_plus AS diapo_plus_50,
e1_.jpo_plus AS jpo_plus_51,
e1_.doc_plus AS doc_plus_52,
e1_.diplome_plus AS diplome_plus_53,
e1_.refus AS refus_54,
e1_.path AS path_55,
e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_56,
e1_.lva AS lva_57,
e1_.lvb AS lvb_58,
e1_.numero_administratif_uai AS numero_administratif_uai_59,
e1_.siret AS siret_60,
e1_.chiffres AS chiffres_61,
e1_.id AS id_62,
e1_.maj AS maj_63,
e2_.type AS type_64,
e2_.nombre_eleves AS nombre_eleves_65,
e2_.url AS url_66,
e2_.video AS video_67,
e2_.mots_cles AS mots_cles_68,
e2_.denomination AS denomination_69,
e2_.denomination_sigle AS denomination_sigle_70,
e2_.denomination_extension AS denomination_extension_71,
e2_.denomination_abregee AS denomination_abregee_72,
e2_.droit_page_web AS droit_page_web_73,
e2_.droit_actualite AS droit_actualite_74,
e2_.adresse1 AS adresse1_75,
e2_.adresse2 AS adresse2_76,
e2_.adresse3 AS adresse3_77,
e2_.code_postal AS code_postal_78,
e2_.cedex AS cedex_79,
e2_.latitude AS latitude_80,
e2_.longitude AS longitude_81,
e2_.telephone_principal AS telephone_principal_82,
e2_.fax AS fax_83,
e2_.email_principal AS email_principal_84,
e2_.logo_liste AS logo_liste_85,
e2_.logo_fiche AS logo_fiche_86,
e2_.diaporama_actif AS diaporama_actif_87,
e2_.images_diaporama AS images_diaporama_88,
e2_.participant AS participant_89,
e2_.catholique AS catholique_90,
e2_.age_admission AS age_admission_91,
e2_.actif AS actif_92,
e2_.internat AS internat_93,
e2_.has_internat AS has_internat_94,
e2_.types_internat AS types_internat_95,
e2_.sous_contrat AS sous_contrat_96,
e2_.alternance AS alternance_97,
e2_.type_client AS type_client_98,
e2_.bloque_txt_ref AS bloque_txt_ref_99,
e2_.facebook AS facebook_100,
e2_.bloque_bac2021 AS bloque_bac2021_101,
e2_.presence_web AS presence_web_102,
e2_.video_plus AS video_plus_103,
e2_.diapo_plus AS diapo_plus_104,
e2_.jpo_plus AS jpo_plus_105,
e2_.doc_plus AS doc_plus_106,
e2_.diplome_plus AS diplome_plus_107,
e2_.refus AS refus_108,
e2_.path AS path_109,
e2_.composition_ensemble_scolaire AS composition_ensemble_scolaire_110,
e2_.lva AS lva_111,
e2_.lvb AS lvb_112,
e2_.numero_administratif_uai AS numero_administratif_uai_113,
e2_.siret AS siret_114,
e2_.chiffres AS chiffres_115,
e2_.id AS id_116,
e2_.maj AS maj_117,
t3_.actif AS actif_118,
t3_.contenu AS contenu_119,
t3_.id AS id_120,
v4_.slug AS slug_121,
v4_.libelle AS libelle_122,
v4_.code_postal AS code_postal_123,
v4_.email_delegue AS email_delegue_124,
v4_.onglets AS onglets_125,
v4_.id AS id_126,
v4_.maj AS maj_127,
v5_.latitude AS latitude_128,
v5_.longitude AS longitude_129,
v5_.id AS id_130,
d6_.slug AS slug_131,
d6_.libelle AS libelle_132,
d6_.onglets AS onglets_133,
d6_.id AS id_134,
d6_.maj AS maj_135,
d7_.latitude AS latitude_136,
d7_.longitude AS longitude_137,
d7_.id AS id_138,
a8_.slug AS slug_139,
a8_.libelle AS libelle_140,
a8_.id AS id_141,
a8_.maj AS maj_142,
r9_.libelle AS libelle_143,
r9_.slug AS slug_144,
r9_.region_adm AS region_adm_145,
r9_.ancienne AS ancienne_146,
r9_.onglets AS onglets_147,
r9_.id AS id_148,
r9_.maj AS maj_149,
p10_.libelle AS libelle_150,
p10_.id AS id_151,
p10_.maj AS maj_152,
c11_.libelle AS libelle_153,
c11_.id AS id_154,
c11_.maj AS maj_155,
t12_.actif AS actif_156,
t12_.contenu AS contenu_157,
t12_.id AS id_158,
o0_.etablissement_id AS etablissement_id_159,
o0_.profil_id AS profil_id_160,
o0_.contrat_id AS contrat_id_161,
e1_.gestionnaire_id AS gestionnaire_id_162,
e1_.ville_id AS ville_id_163,
e1_.categorie_primaire_id AS categorie_primaire_id_164,
e1_.region_id AS region_id_165,
e1_.departement_id AS departement_id_166,
e1_.categorie_organisme_id AS categorie_organisme_id_167,
e1_.rubrique AS rubrique_168,
e1_.internat2_id AS internat2_id_169,
e1_.etablissement_lie_id AS etablissement_lie_id_170,
e1_.logo_id AS logo_id_171,
e1_.diapo_principal_id AS diapo_principal_id_172,
e2_.gestionnaire_id AS gestionnaire_id_173,
e2_.ville_id AS ville_id_174,
e2_.categorie_primaire_id AS categorie_primaire_id_175,
e2_.region_id AS region_id_176,
e2_.departement_id AS departement_id_177,
e2_.categorie_organisme_id AS categorie_organisme_id_178,
e2_.rubrique AS rubrique_179,
e2_.internat2_id AS internat2_id_180,
e2_.etablissement_lie_id AS etablissement_lie_id_181,
e2_.logo_id AS logo_id_182,
e2_.diapo_principal_id AS diapo_principal_id_183,
t3_.etablissement_id AS etablissement_id_184,
t3_.template_id AS template_id_185,
v4_.departement_id AS departement_id_186,
v5_.ville_id AS ville_id_187,
d6_.ancienne_region_id AS ancienne_region_id_188,
d6_.region_id AS region_id_189,
d7_.departement_id AS departement_id_190,
a8_.region_id AS region_id_191,
r9_.pays_id AS pays_id_192,
t12_.etablissement_id AS etablissement_id_193,
t12_.template_id AS template_id_194
FROM
offre_emploi o0_
INNER JOIN etablissement e13_ ON o0_.etablissement_id = e13_.id
LEFT JOIN etablissement e1_ ON o0_.etablissement_id = e1_.id
LEFT JOIN etablissement e2_ ON e1_.gestionnaire_id = e2_.id
LEFT JOIN texte_referencement t3_ ON e2_.id = t3_.etablissement_id
LEFT JOIN ville v4_ ON e1_.ville_id = v4_.id
LEFT JOIN ville_coordonnees v5_ ON v4_.id = v5_.ville_id
LEFT JOIN departement d6_ ON v4_.departement_id = d6_.id
LEFT JOIN departement_coordonnees d7_ ON d6_.id = d7_.departement_id
LEFT JOIN ancienne_region a8_ ON d6_.ancienne_region_id = a8_.id
LEFT JOIN region r9_ ON a8_.region_id = r9_.id
LEFT JOIN pays p10_ ON r9_.pays_id = p10_.id
LEFT JOIN categorie c11_ ON e1_.categorie_primaire_id = c11_.id
LEFT JOIN texte_referencement t12_ ON e1_.id = t12_.etablissement_id
WHERE
o0_.etablissement_id IS NOT NULL
ORDER BY
o0_.date_creation DESC
LIMIT
3
SELECT o0_.id_distant AS id_distant_0, o0_.date_creation AS date_creation_1, o0_.date_actualisation AS date_actualisation_2, o0_.date_validite AS date_validite_3, o0_.libelle AS libelle_4, o0_.description AS description_5, o0_.url AS url_6, o0_.url_image AS url_image_7, o0_.json_ld AS json_ld_8, o0_.id AS id_9, e1_.type AS type_10, e1_.nombre_eleves AS nombre_eleves_11, e1_.url AS url_12, e1_.video AS video_13, e1_.mots_cles AS mots_cles_14, e1_.denomination AS denomination_15, e1_.denomination_sigle AS denomination_sigle_16, e1_.denomination_extension AS denomination_extension_17, e1_.denomination_abregee AS denomination_abregee_18, e1_.droit_page_web AS droit_page_web_19, e1_.droit_actualite AS droit_actualite_20, e1_.adresse1 AS adresse1_21, e1_.adresse2 AS adresse2_22, e1_.adresse3 AS adresse3_23, e1_.code_postal AS code_postal_24, e1_.cedex AS cedex_25, e1_.latitude AS latitude_26, e1_.longitude AS longitude_27, e1_.telephone_principal AS telephone_principal_28, e1_.fax AS fax_29, e1_.email_principal AS email_principal_30, e1_.logo_liste AS logo_liste_31, e1_.logo_fiche AS logo_fiche_32, e1_.diaporama_actif AS diaporama_actif_33, e1_.images_diaporama AS images_diaporama_34, e1_.participant AS participant_35, e1_.catholique AS catholique_36, e1_.age_admission AS age_admission_37, e1_.actif AS actif_38, e1_.internat AS internat_39, e1_.has_internat AS has_internat_40, e1_.types_internat AS types_internat_41, e1_.sous_contrat AS sous_contrat_42, e1_.alternance AS alternance_43, e1_.type_client AS type_client_44, e1_.bloque_txt_ref AS bloque_txt_ref_45, e1_.facebook AS facebook_46, e1_.bloque_bac2021 AS bloque_bac2021_47, e1_.presence_web AS presence_web_48, e1_.video_plus AS video_plus_49, e1_.diapo_plus AS diapo_plus_50, e1_.jpo_plus AS jpo_plus_51, e1_.doc_plus AS doc_plus_52, e1_.diplome_plus AS diplome_plus_53, e1_.refus AS refus_54, e1_.path AS path_55, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_56, e1_.lva AS lva_57, e1_.lvb AS lvb_58, e1_.numero_administratif_uai AS numero_administratif_uai_59, e1_.siret AS siret_60, e1_.chiffres AS chiffres_61, e1_.id AS id_62, e1_.maj AS maj_63, e2_.type AS type_64, e2_.nombre_eleves AS nombre_eleves_65, e2_.url AS url_66, e2_.video AS video_67, e2_.mots_cles AS mots_cles_68, e2_.denomination AS denomination_69, e2_.denomination_sigle AS denomination_sigle_70, e2_.denomination_extension AS denomination_extension_71, e2_.denomination_abregee AS denomination_abregee_72, e2_.droit_page_web AS droit_page_web_73, e2_.droit_actualite AS droit_actualite_74, e2_.adresse1 AS adresse1_75, e2_.adresse2 AS adresse2_76, e2_.adresse3 AS adresse3_77, e2_.code_postal AS code_postal_78, e2_.cedex AS cedex_79, e2_.latitude AS latitude_80, e2_.longitude AS longitude_81, e2_.telephone_principal AS telephone_principal_82, e2_.fax AS fax_83, e2_.email_principal AS email_principal_84, e2_.logo_liste AS logo_liste_85, e2_.logo_fiche AS logo_fiche_86, e2_.diaporama_actif AS diaporama_actif_87, e2_.images_diaporama AS images_diaporama_88, e2_.participant AS participant_89, e2_.catholique AS catholique_90, e2_.age_admission AS age_admission_91, e2_.actif AS actif_92, e2_.internat AS internat_93, e2_.has_internat AS has_internat_94, e2_.types_internat AS types_internat_95, e2_.sous_contrat AS sous_contrat_96, e2_.alternance AS alternance_97, e2_.type_client AS type_client_98, e2_.bloque_txt_ref AS bloque_txt_ref_99, e2_.facebook AS facebook_100, e2_.bloque_bac2021 AS bloque_bac2021_101, e2_.presence_web AS presence_web_102, e2_.video_plus AS video_plus_103, e2_.diapo_plus AS diapo_plus_104, e2_.jpo_plus AS jpo_plus_105, e2_.doc_plus AS doc_plus_106, e2_.diplome_plus AS diplome_plus_107, e2_.refus AS refus_108, e2_.path AS path_109, e2_.composition_ensemble_scolaire AS composition_ensemble_scolaire_110, e2_.lva AS lva_111, e2_.lvb AS lvb_112, e2_.numero_administratif_uai AS numero_administratif_uai_113, e2_.siret AS siret_114, e2_.chiffres AS chiffres_115, e2_.id AS id_116, e2_.maj AS maj_117, t3_.actif AS actif_118, t3_.contenu AS contenu_119, t3_.id AS id_120, v4_.slug AS slug_121, v4_.libelle AS libelle_122, v4_.code_postal AS code_postal_123, v4_.email_delegue AS email_delegue_124, v4_.onglets AS onglets_125, v4_.id AS id_126, v4_.maj AS maj_127, v5_.latitude AS latitude_128, v5_.longitude AS longitude_129, v5_.id AS id_130, d6_.slug AS slug_131, d6_.libelle AS libelle_132, d6_.onglets AS onglets_133, d6_.id AS id_134, d6_.maj AS maj_135, d7_.latitude AS latitude_136, d7_.longitude AS longitude_137, d7_.id AS id_138, a8_.slug AS slug_139, a8_.libelle AS libelle_140, a8_.id AS id_141, a8_.maj AS maj_142, r9_.libelle AS libelle_143, r9_.slug AS slug_144, r9_.region_adm AS region_adm_145, r9_.ancienne AS ancienne_146, r9_.onglets AS onglets_147, r9_.id AS id_148, r9_.maj AS maj_149, p10_.libelle AS libelle_150, p10_.id AS id_151, p10_.maj AS maj_152, c11_.libelle AS libelle_153, c11_.id AS id_154, c11_.maj AS maj_155, t12_.actif AS actif_156, t12_.contenu AS contenu_157, t12_.id AS id_158, o0_.etablissement_id AS etablissement_id_159, o0_.profil_id AS profil_id_160, o0_.contrat_id AS contrat_id_161, e1_.gestionnaire_id AS gestionnaire_id_162, e1_.ville_id AS ville_id_163, e1_.categorie_primaire_id AS categorie_primaire_id_164, e1_.region_id AS region_id_165, e1_.departement_id AS departement_id_166, e1_.categorie_organisme_id AS categorie_organisme_id_167, e1_.rubrique AS rubrique_168, e1_.internat2_id AS internat2_id_169, e1_.etablissement_lie_id AS etablissement_lie_id_170, e1_.logo_id AS logo_id_171, e1_.diapo_principal_id AS diapo_principal_id_172, e2_.gestionnaire_id AS gestionnaire_id_173, e2_.ville_id AS ville_id_174, e2_.categorie_primaire_id AS categorie_primaire_id_175, e2_.region_id AS region_id_176, e2_.departement_id AS departement_id_177, e2_.categorie_organisme_id AS categorie_organisme_id_178, e2_.rubrique AS rubrique_179, e2_.internat2_id AS internat2_id_180, e2_.etablissement_lie_id AS etablissement_lie_id_181, e2_.logo_id AS logo_id_182, e2_.diapo_principal_id AS diapo_principal_id_183, t3_.etablissement_id AS etablissement_id_184, t3_.template_id AS template_id_185, v4_.departement_id AS departement_id_186, v5_.ville_id AS ville_id_187, d6_.ancienne_region_id AS ancienne_region_id_188, d6_.region_id AS region_id_189, d7_.departement_id AS departement_id_190, a8_.region_id AS region_id_191, r9_.pays_id AS pays_id_192, t12_.etablissement_id AS etablissement_id_193, t12_.template_id AS template_id_194 FROM offre_emploi o0_ INNER JOIN etablissement e13_ ON o0_.etablissement_id = e13_.id LEFT JOIN etablissement e1_ ON o0_.etablissement_id = e1_.id LEFT JOIN etablissement e2_ ON e1_.gestionnaire_id = e2_.id LEFT JOIN texte_referencement t3_ ON e2_.id = t3_.etablissement_id LEFT JOIN ville v4_ ON e1_.ville_id = v4_.id LEFT JOIN ville_coordonnees v5_ ON v4_.id = v5_.ville_id LEFT JOIN departement d6_ ON v4_.departement_id = d6_.id LEFT JOIN departement_coordonnees d7_ ON d6_.id = d7_.departement_id LEFT JOIN ancienne_region a8_ ON d6_.ancienne_region_id = a8_.id LEFT JOIN region r9_ ON a8_.region_id = r9_.id LEFT JOIN pays p10_ ON r9_.pays_id = p10_.id LEFT JOIN categorie c11_ ON e1_.categorie_primaire_id = c11_.id LEFT JOIN texte_referencement t12_ ON e1_.id = t12_.etablissement_id WHERE o0_.etablissement_id IS NOT NULL ORDER BY o0_.date_creation DESC LIMIT 3;
|
0.77 ms
(0.27%)
|
1 |
SELECT a0_.id_distant AS id_distant_0, a0_.date_importation AS date_importation_1, a0_.date_publication AS date_publication_2, a0_.date_actualisation AS date_actualisation_3, a0_.titre AS titre_4, a0_.resume AS resume_5, a0_.contenu AS contenu_6, a0_.url AS url_7, a0_.url_image AS url_image_8, a0_.id AS id_9, e1_.type AS type_10, e1_.nombre_eleves AS nombre_eleves_11, e1_.url AS url_12, e1_.video AS video_13, e1_.mots_cles AS mots_cles_14, e1_.denomination AS denomination_15, e1_.denomination_sigle AS denomination_sigle_16, e1_.denomination_extension AS denomination_extension_17, e1_.denomination_abregee AS denomination_abregee_18, e1_.droit_page_web AS droit_page_web_19, e1_.droit_actualite AS droit_actualite_20, e1_.adresse1 AS adresse1_21, e1_.adresse2 AS adresse2_22, e1_.adresse3 AS adresse3_23, e1_.code_postal AS code_postal_24, e1_.cedex AS cedex_25, e1_.latitude AS latitude_26, e1_.longitude AS longitude_27, e1_.telephone_principal AS telephone_principal_28, e1_.fax AS fax_29, e1_.email_principal AS email_principal_30, e1_.logo_liste AS logo_liste_31, e1_.logo_fiche AS logo_fiche_32, e1_.diaporama_actif AS diaporama_actif_33, e1_.images_diaporama AS images_diaporama_34, e1_.participant AS participant_35, e1_.catholique AS catholique_36, e1_.age_admission AS age_admission_37, e1_.actif AS actif_38, e1_.internat AS internat_39, e1_.has_internat AS has_internat_40, e1_.types_internat AS types_internat_41, e1_.sous_contrat AS sous_contrat_42, e1_.alternance AS alternance_43, e1_.type_client AS type_client_44, e1_.bloque_txt_ref AS bloque_txt_ref_45, e1_.facebook AS facebook_46, e1_.bloque_bac2021 AS bloque_bac2021_47, e1_.presence_web AS presence_web_48, e1_.video_plus AS video_plus_49, e1_.diapo_plus AS diapo_plus_50, e1_.jpo_plus AS jpo_plus_51, e1_.doc_plus AS doc_plus_52, e1_.diplome_plus AS diplome_plus_53, e1_.refus AS refus_54, e1_.path AS path_55, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_56, e1_.lva AS lva_57, e1_.lvb AS lvb_58, e1_.numero_administratif_uai AS numero_administratif_uai_59, e1_.siret AS siret_60, e1_.chiffres AS chiffres_61, e1_.id AS id_62, e1_.maj AS maj_63, e2_.type AS type_64, e2_.nombre_eleves AS nombre_eleves_65, e2_.url AS url_66, e2_.video AS video_67, e2_.mots_cles AS mots_cles_68, e2_.denomination AS denomination_69, e2_.denomination_sigle AS denomination_sigle_70, e2_.denomination_extension AS denomination_extension_71, e2_.denomination_abregee AS denomination_abregee_72, e2_.droit_page_web AS droit_page_web_73, e2_.droit_actualite AS droit_actualite_74, e2_.adresse1 AS adresse1_75, e2_.adresse2 AS adresse2_76, e2_.adresse3 AS adresse3_77, e2_.code_postal AS code_postal_78, e2_.cedex AS cedex_79, e2_.latitude AS latitude_80, e2_.longitude AS longitude_81, e2_.telephone_principal AS telephone_principal_82, e2_.fax AS fax_83, e2_.email_principal AS email_principal_84, e2_.logo_liste AS logo_liste_85, e2_.logo_fiche AS logo_fiche_86, e2_.diaporama_actif AS diaporama_actif_87, e2_.images_diaporama AS images_diaporama_88, e2_.participant AS participant_89, e2_.catholique AS catholique_90, e2_.age_admission AS age_admission_91, e2_.actif AS actif_92, e2_.internat AS internat_93, e2_.has_internat AS has_internat_94, e2_.types_internat AS types_internat_95, e2_.sous_contrat AS sous_contrat_96, e2_.alternance AS alternance_97, e2_.type_client AS type_client_98, e2_.bloque_txt_ref AS bloque_txt_ref_99, e2_.facebook AS facebook_100, e2_.bloque_bac2021 AS bloque_bac2021_101, e2_.presence_web AS presence_web_102, e2_.video_plus AS video_plus_103, e2_.diapo_plus AS diapo_plus_104, e2_.jpo_plus AS jpo_plus_105, e2_.doc_plus AS doc_plus_106, e2_.diplome_plus AS diplome_plus_107, e2_.refus AS refus_108, e2_.path AS path_109, e2_.composition_ensemble_scolaire AS composition_ensemble_scolaire_110, e2_.lva AS lva_111, e2_.lvb AS lvb_112, e2_.numero_administratif_uai AS numero_administratif_uai_113, e2_.siret AS siret_114, e2_.chiffres AS chiffres_115, e2_.id AS id_116, e2_.maj AS maj_117, t3_.actif AS actif_118, t3_.contenu AS contenu_119, t3_.id AS id_120, v4_.slug AS slug_121, v4_.libelle AS libelle_122, v4_.code_postal AS code_postal_123, v4_.email_delegue AS email_delegue_124, v4_.onglets AS onglets_125, v4_.id AS id_126, v4_.maj AS maj_127, v5_.latitude AS latitude_128, v5_.longitude AS longitude_129, v5_.id AS id_130, d6_.slug AS slug_131, d6_.libelle AS libelle_132, d6_.onglets AS onglets_133, d6_.id AS id_134, d6_.maj AS maj_135, d7_.latitude AS latitude_136, d7_.longitude AS longitude_137, d7_.id AS id_138, a8_.slug AS slug_139, a8_.libelle AS libelle_140, a8_.id AS id_141, a8_.maj AS maj_142, r9_.libelle AS libelle_143, r9_.slug AS slug_144, r9_.region_adm AS region_adm_145, r9_.ancienne AS ancienne_146, r9_.onglets AS onglets_147, r9_.id AS id_148, r9_.maj AS maj_149, p10_.libelle AS libelle_150, p10_.id AS id_151, p10_.maj AS maj_152, c11_.libelle AS libelle_153, c11_.id AS id_154, c11_.maj AS maj_155, t12_.actif AS actif_156, t12_.contenu AS contenu_157, t12_.id AS id_158, a0_.etablissement_id AS etablissement_id_159, e1_.gestionnaire_id AS gestionnaire_id_160, e1_.ville_id AS ville_id_161, e1_.categorie_primaire_id AS categorie_primaire_id_162, e1_.region_id AS region_id_163, e1_.departement_id AS departement_id_164, e1_.categorie_organisme_id AS categorie_organisme_id_165, e1_.rubrique AS rubrique_166, e1_.internat2_id AS internat2_id_167, e1_.etablissement_lie_id AS etablissement_lie_id_168, e1_.logo_id AS logo_id_169, e1_.diapo_principal_id AS diapo_principal_id_170, e2_.gestionnaire_id AS gestionnaire_id_171, e2_.ville_id AS ville_id_172, e2_.categorie_primaire_id AS categorie_primaire_id_173, e2_.region_id AS region_id_174, e2_.departement_id AS departement_id_175, e2_.categorie_organisme_id AS categorie_organisme_id_176, e2_.rubrique AS rubrique_177, e2_.internat2_id AS internat2_id_178, e2_.etablissement_lie_id AS etablissement_lie_id_179, e2_.logo_id AS logo_id_180, e2_.diapo_principal_id AS diapo_principal_id_181, t3_.etablissement_id AS etablissement_id_182, t3_.template_id AS template_id_183, v4_.departement_id AS departement_id_184, v5_.ville_id AS ville_id_185, d6_.ancienne_region_id AS ancienne_region_id_186, d6_.region_id AS region_id_187, d7_.departement_id AS departement_id_188, a8_.region_id AS region_id_189, r9_.pays_id AS pays_id_190, t12_.etablissement_id AS etablissement_id_191, t12_.template_id AS template_id_192 FROM actualite a0_ INNER JOIN etablissement e13_ ON a0_.etablissement_id = e13_.id LEFT JOIN etablissement e1_ ON a0_.etablissement_id = e1_.id LEFT JOIN etablissement e2_ ON e1_.gestionnaire_id = e2_.id LEFT JOIN texte_referencement t3_ ON e2_.id = t3_.etablissement_id LEFT JOIN ville v4_ ON e1_.ville_id = v4_.id LEFT JOIN ville_coordonnees v5_ ON v4_.id = v5_.ville_id LEFT JOIN departement d6_ ON v4_.departement_id = d6_.id LEFT JOIN departement_coordonnees d7_ ON d6_.id = d7_.departement_id LEFT JOIN ancienne_region a8_ ON d6_.ancienne_region_id = a8_.id LEFT JOIN region r9_ ON a8_.region_id = r9_.id LEFT JOIN pays p10_ ON r9_.pays_id = p10_.id LEFT JOIN categorie c11_ ON e1_.categorie_primaire_id = c11_.id LEFT JOIN texte_referencement t12_ ON e1_.id = t12_.etablissement_id WHERE e13_.video_plus = 1 ORDER BY a0_.date_publication DESC LIMIT 3
SELECT
a0_.id_distant AS id_distant_0,
a0_.date_importation AS date_importation_1,
a0_.date_publication AS date_publication_2,
a0_.date_actualisation AS date_actualisation_3,
a0_.titre AS titre_4,
a0_.resume AS resume_5,
a0_.contenu AS contenu_6,
a0_.url AS url_7,
a0_.url_image AS url_image_8,
a0_.id AS id_9,
e1_.type AS type_10,
e1_.nombre_eleves AS nombre_eleves_11,
e1_.url AS url_12,
e1_.video AS video_13,
e1_.mots_cles AS mots_cles_14,
e1_.denomination AS denomination_15,
e1_.denomination_sigle AS denomination_sigle_16,
e1_.denomination_extension AS denomination_extension_17,
e1_.denomination_abregee AS denomination_abregee_18,
e1_.droit_page_web AS droit_page_web_19,
e1_.droit_actualite AS droit_actualite_20,
e1_.adresse1 AS adresse1_21,
e1_.adresse2 AS adresse2_22,
e1_.adresse3 AS adresse3_23,
e1_.code_postal AS code_postal_24,
e1_.cedex AS cedex_25,
e1_.latitude AS latitude_26,
e1_.longitude AS longitude_27,
e1_.telephone_principal AS telephone_principal_28,
e1_.fax AS fax_29,
e1_.email_principal AS email_principal_30,
e1_.logo_liste AS logo_liste_31,
e1_.logo_fiche AS logo_fiche_32,
e1_.diaporama_actif AS diaporama_actif_33,
e1_.images_diaporama AS images_diaporama_34,
e1_.participant AS participant_35,
e1_.catholique AS catholique_36,
e1_.age_admission AS age_admission_37,
e1_.actif AS actif_38,
e1_.internat AS internat_39,
e1_.has_internat AS has_internat_40,
e1_.types_internat AS types_internat_41,
e1_.sous_contrat AS sous_contrat_42,
e1_.alternance AS alternance_43,
e1_.type_client AS type_client_44,
e1_.bloque_txt_ref AS bloque_txt_ref_45,
e1_.facebook AS facebook_46,
e1_.bloque_bac2021 AS bloque_bac2021_47,
e1_.presence_web AS presence_web_48,
e1_.video_plus AS video_plus_49,
e1_.diapo_plus AS diapo_plus_50,
e1_.jpo_plus AS jpo_plus_51,
e1_.doc_plus AS doc_plus_52,
e1_.diplome_plus AS diplome_plus_53,
e1_.refus AS refus_54,
e1_.path AS path_55,
e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_56,
e1_.lva AS lva_57,
e1_.lvb AS lvb_58,
e1_.numero_administratif_uai AS numero_administratif_uai_59,
e1_.siret AS siret_60,
e1_.chiffres AS chiffres_61,
e1_.id AS id_62,
e1_.maj AS maj_63,
e2_.type AS type_64,
e2_.nombre_eleves AS nombre_eleves_65,
e2_.url AS url_66,
e2_.video AS video_67,
e2_.mots_cles AS mots_cles_68,
e2_.denomination AS denomination_69,
e2_.denomination_sigle AS denomination_sigle_70,
e2_.denomination_extension AS denomination_extension_71,
e2_.denomination_abregee AS denomination_abregee_72,
e2_.droit_page_web AS droit_page_web_73,
e2_.droit_actualite AS droit_actualite_74,
e2_.adresse1 AS adresse1_75,
e2_.adresse2 AS adresse2_76,
e2_.adresse3 AS adresse3_77,
e2_.code_postal AS code_postal_78,
e2_.cedex AS cedex_79,
e2_.latitude AS latitude_80,
e2_.longitude AS longitude_81,
e2_.telephone_principal AS telephone_principal_82,
e2_.fax AS fax_83,
e2_.email_principal AS email_principal_84,
e2_.logo_liste AS logo_liste_85,
e2_.logo_fiche AS logo_fiche_86,
e2_.diaporama_actif AS diaporama_actif_87,
e2_.images_diaporama AS images_diaporama_88,
e2_.participant AS participant_89,
e2_.catholique AS catholique_90,
e2_.age_admission AS age_admission_91,
e2_.actif AS actif_92,
e2_.internat AS internat_93,
e2_.has_internat AS has_internat_94,
e2_.types_internat AS types_internat_95,
e2_.sous_contrat AS sous_contrat_96,
e2_.alternance AS alternance_97,
e2_.type_client AS type_client_98,
e2_.bloque_txt_ref AS bloque_txt_ref_99,
e2_.facebook AS facebook_100,
e2_.bloque_bac2021 AS bloque_bac2021_101,
e2_.presence_web AS presence_web_102,
e2_.video_plus AS video_plus_103,
e2_.diapo_plus AS diapo_plus_104,
e2_.jpo_plus AS jpo_plus_105,
e2_.doc_plus AS doc_plus_106,
e2_.diplome_plus AS diplome_plus_107,
e2_.refus AS refus_108,
e2_.path AS path_109,
e2_.composition_ensemble_scolaire AS composition_ensemble_scolaire_110,
e2_.lva AS lva_111,
e2_.lvb AS lvb_112,
e2_.numero_administratif_uai AS numero_administratif_uai_113,
e2_.siret AS siret_114,
e2_.chiffres AS chiffres_115,
e2_.id AS id_116,
e2_.maj AS maj_117,
t3_.actif AS actif_118,
t3_.contenu AS contenu_119,
t3_.id AS id_120,
v4_.slug AS slug_121,
v4_.libelle AS libelle_122,
v4_.code_postal AS code_postal_123,
v4_.email_delegue AS email_delegue_124,
v4_.onglets AS onglets_125,
v4_.id AS id_126,
v4_.maj AS maj_127,
v5_.latitude AS latitude_128,
v5_.longitude AS longitude_129,
v5_.id AS id_130,
d6_.slug AS slug_131,
d6_.libelle AS libelle_132,
d6_.onglets AS onglets_133,
d6_.id AS id_134,
d6_.maj AS maj_135,
d7_.latitude AS latitude_136,
d7_.longitude AS longitude_137,
d7_.id AS id_138,
a8_.slug AS slug_139,
a8_.libelle AS libelle_140,
a8_.id AS id_141,
a8_.maj AS maj_142,
r9_.libelle AS libelle_143,
r9_.slug AS slug_144,
r9_.region_adm AS region_adm_145,
r9_.ancienne AS ancienne_146,
r9_.onglets AS onglets_147,
r9_.id AS id_148,
r9_.maj AS maj_149,
p10_.libelle AS libelle_150,
p10_.id AS id_151,
p10_.maj AS maj_152,
c11_.libelle AS libelle_153,
c11_.id AS id_154,
c11_.maj AS maj_155,
t12_.actif AS actif_156,
t12_.contenu AS contenu_157,
t12_.id AS id_158,
a0_.etablissement_id AS etablissement_id_159,
e1_.gestionnaire_id AS gestionnaire_id_160,
e1_.ville_id AS ville_id_161,
e1_.categorie_primaire_id AS categorie_primaire_id_162,
e1_.region_id AS region_id_163,
e1_.departement_id AS departement_id_164,
e1_.categorie_organisme_id AS categorie_organisme_id_165,
e1_.rubrique AS rubrique_166,
e1_.internat2_id AS internat2_id_167,
e1_.etablissement_lie_id AS etablissement_lie_id_168,
e1_.logo_id AS logo_id_169,
e1_.diapo_principal_id AS diapo_principal_id_170,
e2_.gestionnaire_id AS gestionnaire_id_171,
e2_.ville_id AS ville_id_172,
e2_.categorie_primaire_id AS categorie_primaire_id_173,
e2_.region_id AS region_id_174,
e2_.departement_id AS departement_id_175,
e2_.categorie_organisme_id AS categorie_organisme_id_176,
e2_.rubrique AS rubrique_177,
e2_.internat2_id AS internat2_id_178,
e2_.etablissement_lie_id AS etablissement_lie_id_179,
e2_.logo_id AS logo_id_180,
e2_.diapo_principal_id AS diapo_principal_id_181,
t3_.etablissement_id AS etablissement_id_182,
t3_.template_id AS template_id_183,
v4_.departement_id AS departement_id_184,
v5_.ville_id AS ville_id_185,
d6_.ancienne_region_id AS ancienne_region_id_186,
d6_.region_id AS region_id_187,
d7_.departement_id AS departement_id_188,
a8_.region_id AS region_id_189,
r9_.pays_id AS pays_id_190,
t12_.etablissement_id AS etablissement_id_191,
t12_.template_id AS template_id_192
FROM
actualite a0_
INNER JOIN etablissement e13_ ON a0_.etablissement_id = e13_.id
LEFT JOIN etablissement e1_ ON a0_.etablissement_id = e1_.id
LEFT JOIN etablissement e2_ ON e1_.gestionnaire_id = e2_.id
LEFT JOIN texte_referencement t3_ ON e2_.id = t3_.etablissement_id
LEFT JOIN ville v4_ ON e1_.ville_id = v4_.id
LEFT JOIN ville_coordonnees v5_ ON v4_.id = v5_.ville_id
LEFT JOIN departement d6_ ON v4_.departement_id = d6_.id
LEFT JOIN departement_coordonnees d7_ ON d6_.id = d7_.departement_id
LEFT JOIN ancienne_region a8_ ON d6_.ancienne_region_id = a8_.id
LEFT JOIN region r9_ ON a8_.region_id = r9_.id
LEFT JOIN pays p10_ ON r9_.pays_id = p10_.id
LEFT JOIN categorie c11_ ON e1_.categorie_primaire_id = c11_.id
LEFT JOIN texte_referencement t12_ ON e1_.id = t12_.etablissement_id
WHERE
e13_.video_plus = 1
ORDER BY
a0_.date_publication DESC
LIMIT
3
SELECT a0_.id_distant AS id_distant_0, a0_.date_importation AS date_importation_1, a0_.date_publication AS date_publication_2, a0_.date_actualisation AS date_actualisation_3, a0_.titre AS titre_4, a0_.resume AS resume_5, a0_.contenu AS contenu_6, a0_.url AS url_7, a0_.url_image AS url_image_8, a0_.id AS id_9, e1_.type AS type_10, e1_.nombre_eleves AS nombre_eleves_11, e1_.url AS url_12, e1_.video AS video_13, e1_.mots_cles AS mots_cles_14, e1_.denomination AS denomination_15, e1_.denomination_sigle AS denomination_sigle_16, e1_.denomination_extension AS denomination_extension_17, e1_.denomination_abregee AS denomination_abregee_18, e1_.droit_page_web AS droit_page_web_19, e1_.droit_actualite AS droit_actualite_20, e1_.adresse1 AS adresse1_21, e1_.adresse2 AS adresse2_22, e1_.adresse3 AS adresse3_23, e1_.code_postal AS code_postal_24, e1_.cedex AS cedex_25, e1_.latitude AS latitude_26, e1_.longitude AS longitude_27, e1_.telephone_principal AS telephone_principal_28, e1_.fax AS fax_29, e1_.email_principal AS email_principal_30, e1_.logo_liste AS logo_liste_31, e1_.logo_fiche AS logo_fiche_32, e1_.diaporama_actif AS diaporama_actif_33, e1_.images_diaporama AS images_diaporama_34, e1_.participant AS participant_35, e1_.catholique AS catholique_36, e1_.age_admission AS age_admission_37, e1_.actif AS actif_38, e1_.internat AS internat_39, e1_.has_internat AS has_internat_40, e1_.types_internat AS types_internat_41, e1_.sous_contrat AS sous_contrat_42, e1_.alternance AS alternance_43, e1_.type_client AS type_client_44, e1_.bloque_txt_ref AS bloque_txt_ref_45, e1_.facebook AS facebook_46, e1_.bloque_bac2021 AS bloque_bac2021_47, e1_.presence_web AS presence_web_48, e1_.video_plus AS video_plus_49, e1_.diapo_plus AS diapo_plus_50, e1_.jpo_plus AS jpo_plus_51, e1_.doc_plus AS doc_plus_52, e1_.diplome_plus AS diplome_plus_53, e1_.refus AS refus_54, e1_.path AS path_55, e1_.composition_ensemble_scolaire AS composition_ensemble_scolaire_56, e1_.lva AS lva_57, e1_.lvb AS lvb_58, e1_.numero_administratif_uai AS numero_administratif_uai_59, e1_.siret AS siret_60, e1_.chiffres AS chiffres_61, e1_.id AS id_62, e1_.maj AS maj_63, e2_.type AS type_64, e2_.nombre_eleves AS nombre_eleves_65, e2_.url AS url_66, e2_.video AS video_67, e2_.mots_cles AS mots_cles_68, e2_.denomination AS denomination_69, e2_.denomination_sigle AS denomination_sigle_70, e2_.denomination_extension AS denomination_extension_71, e2_.denomination_abregee AS denomination_abregee_72, e2_.droit_page_web AS droit_page_web_73, e2_.droit_actualite AS droit_actualite_74, e2_.adresse1 AS adresse1_75, e2_.adresse2 AS adresse2_76, e2_.adresse3 AS adresse3_77, e2_.code_postal AS code_postal_78, e2_.cedex AS cedex_79, e2_.latitude AS latitude_80, e2_.longitude AS longitude_81, e2_.telephone_principal AS telephone_principal_82, e2_.fax AS fax_83, e2_.email_principal AS email_principal_84, e2_.logo_liste AS logo_liste_85, e2_.logo_fiche AS logo_fiche_86, e2_.diaporama_actif AS diaporama_actif_87, e2_.images_diaporama AS images_diaporama_88, e2_.participant AS participant_89, e2_.catholique AS catholique_90, e2_.age_admission AS age_admission_91, e2_.actif AS actif_92, e2_.internat AS internat_93, e2_.has_internat AS has_internat_94, e2_.types_internat AS types_internat_95, e2_.sous_contrat AS sous_contrat_96, e2_.alternance AS alternance_97, e2_.type_client AS type_client_98, e2_.bloque_txt_ref AS bloque_txt_ref_99, e2_.facebook AS facebook_100, e2_.bloque_bac2021 AS bloque_bac2021_101, e2_.presence_web AS presence_web_102, e2_.video_plus AS video_plus_103, e2_.diapo_plus AS diapo_plus_104, e2_.jpo_plus AS jpo_plus_105, e2_.doc_plus AS doc_plus_106, e2_.diplome_plus AS diplome_plus_107, e2_.refus AS refus_108, e2_.path AS path_109, e2_.composition_ensemble_scolaire AS composition_ensemble_scolaire_110, e2_.lva AS lva_111, e2_.lvb AS lvb_112, e2_.numero_administratif_uai AS numero_administratif_uai_113, e2_.siret AS siret_114, e2_.chiffres AS chiffres_115, e2_.id AS id_116, e2_.maj AS maj_117, t3_.actif AS actif_118, t3_.contenu AS contenu_119, t3_.id AS id_120, v4_.slug AS slug_121, v4_.libelle AS libelle_122, v4_.code_postal AS code_postal_123, v4_.email_delegue AS email_delegue_124, v4_.onglets AS onglets_125, v4_.id AS id_126, v4_.maj AS maj_127, v5_.latitude AS latitude_128, v5_.longitude AS longitude_129, v5_.id AS id_130, d6_.slug AS slug_131, d6_.libelle AS libelle_132, d6_.onglets AS onglets_133, d6_.id AS id_134, d6_.maj AS maj_135, d7_.latitude AS latitude_136, d7_.longitude AS longitude_137, d7_.id AS id_138, a8_.slug AS slug_139, a8_.libelle AS libelle_140, a8_.id AS id_141, a8_.maj AS maj_142, r9_.libelle AS libelle_143, r9_.slug AS slug_144, r9_.region_adm AS region_adm_145, r9_.ancienne AS ancienne_146, r9_.onglets AS onglets_147, r9_.id AS id_148, r9_.maj AS maj_149, p10_.libelle AS libelle_150, p10_.id AS id_151, p10_.maj AS maj_152, c11_.libelle AS libelle_153, c11_.id AS id_154, c11_.maj AS maj_155, t12_.actif AS actif_156, t12_.contenu AS contenu_157, t12_.id AS id_158, a0_.etablissement_id AS etablissement_id_159, e1_.gestionnaire_id AS gestionnaire_id_160, e1_.ville_id AS ville_id_161, e1_.categorie_primaire_id AS categorie_primaire_id_162, e1_.region_id AS region_id_163, e1_.departement_id AS departement_id_164, e1_.categorie_organisme_id AS categorie_organisme_id_165, e1_.rubrique AS rubrique_166, e1_.internat2_id AS internat2_id_167, e1_.etablissement_lie_id AS etablissement_lie_id_168, e1_.logo_id AS logo_id_169, e1_.diapo_principal_id AS diapo_principal_id_170, e2_.gestionnaire_id AS gestionnaire_id_171, e2_.ville_id AS ville_id_172, e2_.categorie_primaire_id AS categorie_primaire_id_173, e2_.region_id AS region_id_174, e2_.departement_id AS departement_id_175, e2_.categorie_organisme_id AS categorie_organisme_id_176, e2_.rubrique AS rubrique_177, e2_.internat2_id AS internat2_id_178, e2_.etablissement_lie_id AS etablissement_lie_id_179, e2_.logo_id AS logo_id_180, e2_.diapo_principal_id AS diapo_principal_id_181, t3_.etablissement_id AS etablissement_id_182, t3_.template_id AS template_id_183, v4_.departement_id AS departement_id_184, v5_.ville_id AS ville_id_185, d6_.ancienne_region_id AS ancienne_region_id_186, d6_.region_id AS region_id_187, d7_.departement_id AS departement_id_188, a8_.region_id AS region_id_189, r9_.pays_id AS pays_id_190, t12_.etablissement_id AS etablissement_id_191, t12_.template_id AS template_id_192 FROM actualite a0_ INNER JOIN etablissement e13_ ON a0_.etablissement_id = e13_.id LEFT JOIN etablissement e1_ ON a0_.etablissement_id = e1_.id LEFT JOIN etablissement e2_ ON e1_.gestionnaire_id = e2_.id LEFT JOIN texte_referencement t3_ ON e2_.id = t3_.etablissement_id LEFT JOIN ville v4_ ON e1_.ville_id = v4_.id LEFT JOIN ville_coordonnees v5_ ON v4_.id = v5_.ville_id LEFT JOIN departement d6_ ON v4_.departement_id = d6_.id LEFT JOIN departement_coordonnees d7_ ON d6_.id = d7_.departement_id LEFT JOIN ancienne_region a8_ ON d6_.ancienne_region_id = a8_.id LEFT JOIN region r9_ ON a8_.region_id = r9_.id LEFT JOIN pays p10_ ON r9_.pays_id = p10_.id LEFT JOIN categorie c11_ ON e1_.categorie_primaire_id = c11_.id LEFT JOIN texte_referencement t12_ ON e1_.id = t12_.etablissement_id WHERE e13_.video_plus = 1 ORDER BY a0_.date_publication DESC LIMIT 3;
|
0.58 ms
(0.20%)
|
1 |
SELECT NON_UNIQUE AS Non_Unique,
INDEX_NAME AS Key_name,
COLUMN_NAME AS Column_Name,
SUB_PART AS Sub_Part,
INDEX_TYPE AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters: [
"aep"
"doctrine_migration_versions"
]
SELECT NON_UNIQUE AS Non_Unique,
INDEX_NAME AS Key_name,
COLUMN_NAME AS Column_Name,
SUB_PART AS Sub_Part,
INDEX_TYPE AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'aep' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
|
0.40 ms
(0.14%)
|
1 |
SELECT * FROM doctrine_migration_versions
SELECT * FROM doctrine_migration_versions;
|
0.38 ms
(0.13%)
|
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.tag AS tag_4, t0.photo AS photo_5, t0.created_at AS created_at_6, t0.is_carrousel AS is_carrousel_7, t0.ids_annonceur AS ids_annonceur_8, t0.slug AS slug_9, t0.updated_at AS updated_at_10, t0.auteur_id AS auteur_id_11 FROM actualite_onpc t0 ORDER BY t0.created_at DESC LIMIT 3
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.tag AS tag_4, t0.photo AS photo_5, t0.created_at AS created_at_6, t0.is_carrousel AS is_carrousel_7, t0.ids_annonceur AS ids_annonceur_8, t0.slug AS slug_9, t0.updated_at AS updated_at_10, t0.auteur_id AS auteur_id_11 FROM actualite_onpc t0 ORDER BY t0.created_at DESC LIMIT 3;
|
0.33 ms
(0.11%)
|
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.id_vimeo AS id_vimeo_3, t0.description AS description_4, t0.tag AS tag_5, t0.photo AS photo_6, t0.created_at AS created_at_7, t0.duree AS duree_8, t0.is_carrousel AS is_carrousel_9, t0.ids_annonceur AS ids_annonceur_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12 FROM video_onpc t0 ORDER BY t0.created_at DESC LIMIT 3
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.id_vimeo AS id_vimeo_3, t0.description AS description_4, t0.tag AS tag_5, t0.photo AS photo_6, t0.created_at AS created_at_7, t0.duree AS duree_8, t0.is_carrousel AS is_carrousel_9, t0.ids_annonceur AS ids_annonceur_10, t0.slug AS slug_11, t0.updated_at AS updated_at_12 FROM video_onpc t0 ORDER BY t0.created_at DESC LIMIT 3;
|