http://aep-beta.onpc.fr/organismes/departement/haut-rhin/68/SYNI/1

Query Metrics

5 Database Queries
5 Different statements
48.53 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.30 ms
SELECT t0.libelle AS libelle_1, t0.id AS id_2, t0.maj AS maj_3 FROM categorie_organisme t0 WHERE t0.id = ?
Parameters:
[
  "SYNI"
]
2 0.81 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, e0_.gestionnaire_id AS gestionnaire_id_54, e0_.ville_id AS ville_id_55, e0_.categorie_primaire_id AS categorie_primaire_id_56, e0_.region_id AS region_id_57, e0_.departement_id AS departement_id_58, e0_.categorie_organisme_id AS categorie_organisme_id_59, e0_.rubrique AS rubrique_60, e0_.internat2_id AS internat2_id_61, e0_.etablissement_lie_id AS etablissement_lie_id_62, e0_.logo_id AS logo_id_63, e0_.diapo_principal_id AS diapo_principal_id_64 FROM etablissement e0_ WHERE e0_.id LIKE 'OR%' AND e0_.catholique = 1 AND e0_.presence_web = 1 AND e0_.categorie_organisme_id = 'SYNI' AND e0_.departement_id = '68'
Parameters:
[]
3 13.53 ms
SELECT t0.slug AS slug_1, t0.libelle AS libelle_2, t0.onglets AS onglets_3, t0.id AS id_4, t0.maj AS maj_5, t0.ancienne_region_id AS ancienne_region_id_6, t7.latitude AS latitude_8, t7.longitude AS longitude_9, t7.id AS id_10, t7.departement_id AS departement_id_11, t0.region_id AS region_id_12 FROM departement t0 LEFT JOIN departement_coordonnees t7 ON t7.departement_id = t0.id WHERE t0.id = ?
Parameters:
[
  "68"
]
4 17.44 ms
SELECT d0_.slug AS slug_0, d0_.libelle AS libelle_1, d0_.onglets AS onglets_2, d0_.id AS id_3, d0_.maj AS maj_4, d1_.latitude AS latitude_5, d1_.longitude AS longitude_6, d1_.id AS id_7, d0_.ancienne_region_id AS ancienne_region_id_8, d0_.region_id AS region_id_9, d1_.departement_id AS departement_id_10 FROM departement d0_ LEFT JOIN departement_coordonnees d1_ ON d0_.id = d1_.departement_id
Parameters:
[]
5 16.46 ms
SELECT r0_.libelle AS libelle_0, r0_.slug AS slug_1, r0_.region_adm AS region_adm_2, r0_.ancienne AS ancienne_3, r0_.onglets AS onglets_4, r0_.id AS id_5, r0_.maj AS maj_6, r0_.pays_id AS pays_id_7 FROM region r0_
Parameters:
[]

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
App\Entity\CategorieOrganisme No errors.
App\Entity\Etablissement No errors.
App\Entity\Ville No errors.
App\Entity\Categorie No errors.
App\Entity\Region No errors.
App\Entity\Departement No errors.
App\Entity\RubriqueFournisseur No errors.
App\Entity\Logo No errors.
App\Entity\Diaporama No errors.
App\Entity\AncienneRegion No errors.
App\Entity\DepartementCoordonnees No errors.
App\Entity\Pays No errors.