http://aep-beta.onpc.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CVideoController%253A%253AblocVideosALaUne

Method
GET
HTTP Status
200
IP
216.73.217.94
Profiled on
Token
be3582

Query Metrics

64 Database Queries
23 Different statements
286.92 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 5.91 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.77 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.84 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.61 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.32 ms 
SELECT e0_.type AS type_0, e0_.nombre_eleves AS nombre_eleves_1, e0_.url AS url_2, e0_.video AS video_3, e0_.mots_cles AS mots_cles_4, e0_.denomination AS denomination_5, e0_.denomination_sigle AS denomination_sigle_6, e0_.denomination_extension AS denomination_extension_7, e0_.denomination_abregee AS denomination_abregee_8, e0_.droit_page_web AS droit_page_web_9, e0_.droit_actualite AS droit_actualite_10, e0_.adresse1 AS adresse1_11, e0_.adresse2 AS adresse2_12, e0_.adresse3 AS adresse3_13, e0_.code_postal AS code_postal_14, e0_.cedex AS cedex_15, e0_.latitude AS latitude_16, e0_.longitude AS longitude_17, e0_.telephone_principal AS telephone_principal_18, e0_.fax AS fax_19, e0_.email_principal AS email_principal_20, e0_.logo_liste AS logo_liste_21, e0_.logo_fiche AS logo_fiche_22, e0_.diaporama_actif AS diaporama_actif_23, e0_.images_diaporama AS images_diaporama_24, e0_.participant AS participant_25, e0_.catholique AS catholique_26, e0_.age_admission AS age_admission_27, e0_.actif AS actif_28, e0_.internat AS internat_29, e0_.has_internat AS has_internat_30, e0_.types_internat AS types_internat_31, e0_.sous_contrat AS sous_contrat_32, e0_.alternance AS alternance_33, e0_.type_client AS type_client_34, e0_.bloque_txt_ref AS bloque_txt_ref_35, e0_.facebook AS facebook_36, e0_.bloque_bac2021 AS bloque_bac2021_37, e0_.presence_web AS presence_web_38, e0_.video_plus AS video_plus_39, e0_.diapo_plus AS diapo_plus_40, e0_.jpo_plus AS jpo_plus_41, e0_.doc_plus AS doc_plus_42, e0_.diplome_plus AS diplome_plus_43, e0_.refus AS refus_44, e0_.path AS path_45, e0_.composition_ensemble_scolaire AS composition_ensemble_scolaire_46, e0_.lva AS lva_47, e0_.lvb AS lvb_48, e0_.numero_administratif_uai AS numero_administratif_uai_49, e0_.siret AS siret_50, e0_.chiffres AS chiffres_51, e0_.id AS id_52, e0_.maj AS maj_53, 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"
  ]
]
View formatted query    View runnable query    Explain query    View query backtrace
6 197.49 ms 
SELECT i0_.identifiant AS identifiant_0, i0_.onglet AS onglet_1, i0_.libelle AS libelle_2, i0_.options AS options_3, i0_.niveau AS niveau_4, i0_.pere AS pere_5, i0_.libelle_specifique AS libelle_specifique_6, i0_.options_specifique AS options_specifique_7, i0_.texte AS texte_8, i0_.tri AS tri_9, i0_.complement_texte AS complement_texte_10, i0_.complement_url_libelle AS complement_url_libelle_11, i0_.complement_url AS complement_url_12, i0_.complement_updated_at AS complement_updated_at_13, i0_.libelle_mep AS libelle_mep_14, i0_.slug AS slug_15, i0_.formation AS formation_16, i0_.ligne_secours AS ligne_secours_17, i0_.updated_at AS updated_at_18, i0_.diplome_plus AS diplome_plus_19, i0_.valeur AS valeur_20, i0_.id AS id_21, i0_.etablissement_id AS etablissement_id_22 FROM items_insertion i0_ WHERE i0_.diplome_plus = 1 ORDER BY RAND() ASC LIMIT 12
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.33 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.38 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.43 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.32 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.34 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.65 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET013-100"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.43 ms 
SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = ?
Parameters: 
[
  "GE013-37"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.29 ms 
SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "13001"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.49 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET033-152"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.28 ms 
SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = ?
Parameters: 
[
  "GE033-30"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.35 ms 
SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "33063"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.29 ms 
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.updated_at AS updated_at_4, t0.file_name_source AS file_name_source_5, t0.file_size_source AS file_size_source_6, t0.date_crea AS date_crea_7, t0.date_maj AS date_maj_8 FROM logo t0 WHERE t0.id = ?
Parameters: 
[
  1227
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.68 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET082-1"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.29 ms 
SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = ?
Parameters: 
[
  "GE082-16"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.26 ms 
SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "82121"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.44 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET013-494"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.21 ms 
SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = ?
Parameters: 
[
  "GE013-96"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.47 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET013-491"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.34 ms 
SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "13201"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.44 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET033-171"
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.25 ms 
SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = ?
Parameters: 
[
  "GE033-28"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.22 ms 
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.updated_at AS updated_at_4, t0.file_name_source AS file_name_source_5, t0.file_size_source AS file_size_source_6, t0.date_crea AS date_crea_7, t0.date_maj AS date_maj_8 FROM logo t0 WHERE t0.id = ?
Parameters: 
[
  1234
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.44 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET082-54"
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.56 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET013-80"
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.31 ms 
SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = ?
Parameters: 
[
  "GE013-25"
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.27 ms 
SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "13206"
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.37 ms 
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.updated_at AS updated_at_4, t0.file_name_source AS file_name_source_5, t0.file_size_source AS file_size_source_6, t0.date_crea AS date_crea_7, t0.date_maj AS date_maj_8 FROM logo t0 WHERE t0.id = ?
Parameters: 
[
  507
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.63 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET040-38"
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.27 ms 
SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = ?
Parameters: 
[
  "GE040-4"
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.22 ms 
SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "40102"
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.28 ms 
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.updated_at AS updated_at_4, t0.file_name_source AS file_name_source_5, t0.file_size_source AS file_size_source_6, t0.date_crea AS date_crea_7, t0.date_maj AS date_maj_8 FROM logo t0 WHERE t0.id = ?
Parameters: 
[
  1671
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.50 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET064-99"
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.44 ms 
SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = ?
Parameters: 
[
  "GE064-10"
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.29 ms 
SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "64513"
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.37 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET033-52"
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.30 ms 
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.updated_at AS updated_at_4, t0.file_name_source AS file_name_source_5, t0.file_size_source AS file_size_source_6, t0.date_crea AS date_crea_7, t0.date_maj AS date_maj_8 FROM logo t0 WHERE t0.id = ?
Parameters: 
[
  1292
]
View formatted query    View runnable query    Explain query    View query backtrace
43 3.57 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
44 3.04 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.64 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "ET056-89"
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.42 ms 
SELECT t0.actif AS actif_1, t0.contenu AS contenu_2, t0.id AS id_3, t0.etablissement_id AS etablissement_id_4, t0.template_id AS template_id_5 FROM texte_referencement t0 WHERE t0.etablissement_id = ?
Parameters: 
[
  "GE056-14"
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.34 ms 
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.updated_at AS updated_at_4, t0.file_name_source AS file_name_source_5, t0.file_size_source AS file_size_source_6, t0.date_crea AS date_crea_7, t0.date_maj AS date_maj_8 FROM logo t0 WHERE t0.id = ?
Parameters: 
[
  2354
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.38 ms 
SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "56263"
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.48 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
50 3.98 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "aep"
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.33 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
52 4.51 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "aep"
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.34 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
54 1.84 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.37 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
56 3.48 ms 
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'aep' */ ORDER BY k.ORDINAL_POSITION
Parameters: 
[
  "aep"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query    View query backtrace
57 5.47 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.31 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.58 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.40 ms 
SELECT * FROM doctrine_migration_versions
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.38 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
62 33.44 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
63 1.57 ms 
SELECT t0.type AS type_1, t0.nombre_eleves AS nombre_eleves_2, t0.url AS url_3, t0.video AS video_4, t0.mots_cles AS mots_cles_5, t0.denomination AS denomination_6, t0.denomination_sigle AS denomination_sigle_7, t0.denomination_extension AS denomination_extension_8, t0.denomination_abregee AS denomination_abregee_9, t0.droit_page_web AS droit_page_web_10, t0.droit_actualite AS droit_actualite_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.adresse3 AS adresse3_14, t0.code_postal AS code_postal_15, t0.cedex AS cedex_16, t0.latitude AS latitude_17, t0.longitude AS longitude_18, t0.telephone_principal AS telephone_principal_19, t0.fax AS fax_20, t0.email_principal AS email_principal_21, t0.logo_liste AS logo_liste_22, t0.logo_fiche AS logo_fiche_23, t0.diaporama_actif AS diaporama_actif_24, t0.images_diaporama AS images_diaporama_25, t0.participant AS participant_26, t0.catholique AS catholique_27, t0.age_admission AS age_admission_28, t0.actif AS actif_29, t0.internat AS internat_30, t0.has_internat AS has_internat_31, t0.types_internat AS types_internat_32, t0.sous_contrat AS sous_contrat_33, t0.alternance AS alternance_34, t0.type_client AS type_client_35, t0.bloque_txt_ref AS bloque_txt_ref_36, t0.facebook AS facebook_37, t0.bloque_bac2021 AS bloque_bac2021_38, t0.presence_web AS presence_web_39, t0.video_plus AS video_plus_40, t0.diapo_plus AS diapo_plus_41, t0.jpo_plus AS jpo_plus_42, t0.doc_plus AS doc_plus_43, t0.diplome_plus AS diplome_plus_44, t0.refus AS refus_45, t0.path AS path_46, t0.composition_ensemble_scolaire AS composition_ensemble_scolaire_47, t0.lva AS lva_48, t0.lvb AS lvb_49, t0.numero_administratif_uai AS numero_administratif_uai_50, t0.siret AS siret_51, t0.chiffres AS chiffres_52, t0.id AS id_53, t0.maj AS maj_54, t0.gestionnaire_id AS gestionnaire_id_55, t56.type AS type_57, t56.nombre_eleves AS nombre_eleves_58, t56.url AS url_59, t56.video AS video_60, t56.mots_cles AS mots_cles_61, t56.denomination AS denomination_62, t56.denomination_sigle AS denomination_sigle_63, t56.denomination_extension AS denomination_extension_64, t56.denomination_abregee AS denomination_abregee_65, t56.droit_page_web AS droit_page_web_66, t56.droit_actualite AS droit_actualite_67, t56.adresse1 AS adresse1_68, t56.adresse2 AS adresse2_69, t56.adresse3 AS adresse3_70, t56.code_postal AS code_postal_71, t56.cedex AS cedex_72, t56.latitude AS latitude_73, t56.longitude AS longitude_74, t56.telephone_principal AS telephone_principal_75, t56.fax AS fax_76, t56.email_principal AS email_principal_77, t56.logo_liste AS logo_liste_78, t56.logo_fiche AS logo_fiche_79, t56.diaporama_actif AS diaporama_actif_80, t56.images_diaporama AS images_diaporama_81, t56.participant AS participant_82, t56.catholique AS catholique_83, t56.age_admission AS age_admission_84, t56.actif AS actif_85, t56.internat AS internat_86, t56.has_internat AS has_internat_87, t56.types_internat AS types_internat_88, t56.sous_contrat AS sous_contrat_89, t56.alternance AS alternance_90, t56.type_client AS type_client_91, t56.bloque_txt_ref AS bloque_txt_ref_92, t56.facebook AS facebook_93, t56.bloque_bac2021 AS bloque_bac2021_94, t56.presence_web AS presence_web_95, t56.video_plus AS video_plus_96, t56.diapo_plus AS diapo_plus_97, t56.jpo_plus AS jpo_plus_98, t56.doc_plus AS doc_plus_99, t56.diplome_plus AS diplome_plus_100, t56.refus AS refus_101, t56.path AS path_102, t56.composition_ensemble_scolaire AS composition_ensemble_scolaire_103, t56.lva AS lva_104, t56.lvb AS lvb_105, t56.numero_administratif_uai AS numero_administratif_uai_106, t56.siret AS siret_107, t56.chiffres AS chiffres_108, t56.id AS id_109, t56.maj AS maj_110, t56.gestionnaire_id AS gestionnaire_id_111, t56.ville_id AS ville_id_112, t56.categorie_primaire_id AS categorie_primaire_id_113, t56.region_id AS region_id_114, t56.departement_id AS departement_id_115, t56.categorie_organisme_id AS categorie_organisme_id_116, t56.rubrique AS rubrique_117, t56.internat2_id AS internat2_id_118, t56.etablissement_lie_id AS etablissement_lie_id_119, t56.logo_id AS logo_id_120, t56.diapo_principal_id AS diapo_principal_id_121, t0.ville_id AS ville_id_122, t123.actif AS actif_124, t123.contenu AS contenu_125, t123.id AS id_126, t123.etablissement_id AS etablissement_id_127, t123.template_id AS template_id_128, t0.categorie_primaire_id AS categorie_primaire_id_129, t0.region_id AS region_id_130, t0.departement_id AS departement_id_131, t0.categorie_organisme_id AS categorie_organisme_id_132, t0.rubrique AS rubrique_133, t0.internat2_id AS internat2_id_134, t0.etablissement_lie_id AS etablissement_lie_id_135, t0.logo_id AS logo_id_136, t0.diapo_principal_id AS diapo_principal_id_137 FROM etablissement t0 LEFT JOIN etablissement t56 ON t0.gestionnaire_id = t56.id LEFT JOIN texte_referencement t123 ON t123.etablissement_id = t0.id WHERE t0.id IN (?)
Parameters: 
[
  [
    "GE033-13"
    "GE033-11"
  ]
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.63 ms 
SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.code_postal AS code_postal_3, t0.email_delegue AS email_delegue_4, t0.onglets AS onglets_5, t0.id AS id_6, t0.maj AS maj_7, t0.departement_id AS departement_id_8, t9.latitude AS latitude_10, t9.longitude AS longitude_11, t9.id AS id_12, t9.ville_id AS ville_id_13 FROM ville t0 LEFT JOIN ville_coordonnees t9 ON t9.ville_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "75120"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
Vich\UploaderBundle\Entity\File No errors.
App\Entity\JPO No errors.
App\Entity\Etablissement No errors.
App\Entity\Actualite No errors.
App\Entity\TexteReferencement No errors.
App\Entity\Ville No errors.
App\Entity\VilleCoordonnees No errors.
App\Entity\Departement No errors.
App\Entity\DepartementCoordonnees No errors.
App\Entity\AncienneRegion No errors.
App\Entity\Region No errors.
App\Entity\Pays No errors.
App\Entity\Categorie No errors.
App\Entity\CategorieOrganisme No errors.
App\Entity\RubriqueFournisseur No errors.
App\Entity\Logo No errors.
App\Entity\Diaporama No errors.
App\Entity\TexteReferencementTemplate No errors.
App\Entity\Insertion No errors.
App\Entity\ItemsInsertion No errors.
App\Entity\OffreEmploi No errors.
App\Entity\SousTypesEtablissement No errors.
App\Entity\Document No errors.
App\Entity\Video No errors.
App\Entity\Produit No errors.
App\Entity\EtablissementData No errors.
App\Entity\VideoOnpc No errors.
App\Entity\ActualiteOnpc No errors.
App\Entity\OffreEmploiProfil No errors.
App\Entity\OffreEmploiContrat No errors.
App\Entity\OffreEmploiCandidature No errors.
App\Entity\Page No errors.
App\Entity\PageCategorie No errors.
App\Entity\DiaporamaPhoto No errors.
App\Entity\AuteurActuOnpc No errors.
App\Entity\PlaceDisponible No errors.
App\Entity\Banniere No errors.
App\Entity\Trace No errors.
App\Entity\Items No errors.
App\Entity\Utilisateur No errors.
App\Entity\Partenaire No errors.
App\Entity\OffreService No errors.
App\Entity\ClientApiTheme No errors.
App\Entity\ZonesInternat No errors.
App\Entity\Devis No errors.
App\Entity\SeoTexteReferencementDiplome No errors.
App\Entity\Faq No errors.
App\Entity\Stats No errors.
App\Entity\DevisClasseDecouverte No errors.
App\Entity\DemandeRapport No errors.
App\Entity\ClientApi No errors.
App\Entity\DonneeComplementaire No errors.
App\Entity\DecideurCivilite No errors.
App\Entity\DemandeInformationBlacklist No errors.
App\Entity\DemandeInformation No errors.
App\Entity\FicheProspect No errors.
App\Entity\ReinitialisationMdp No errors.
App\Entity\Journal No errors.
App\Entity\ParagrapheQuoiLieu No errors.
App\Entity\ParagrapheAnnuaire No errors.
App\Entity\TraceAdmin No errors.
App\Entity\TypesEtablissements No errors.
App\Entity\NewsletterInscription No errors.