Query Metrics
10
Database Queries
10
Different statements
12.59 ms
Query time
2
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
2.56 ms (20.33%) |
1 |
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 4 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC
Parameters:
[
"2025-09-29 13:59:56"
]
|
2.03 ms (16.13%) |
1 |
SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.code_departement_interne AS code_departement_interne_3, t0_.code_academie_interne AS code_academie_interne_4, t0_.arpec_code_arpec AS arpec_code_arpec_5, t0_.code_departement AS code_departement_6, t0_.libelle_court AS libelle_court_7, t0_.libelle_long AS libelle_long_8, t0_.libelle_edition AS libelle_edition_9, t0_.date_ouverture AS date_ouverture_10, t0_.date_fermeture AS date_fermeture_11, t0_.date_creation AS date_creation_12, t0_.date_intervention AS date_intervention_13, t0_.commentaires AS commentaires_14, t0_.statut AS statut_15, t0_.code_region_interne AS code_region_interne_16 FROM annuaire._n_departement t0_ WHERE t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL ORDER BY t0_.libelle_edition ASC
Parameters:
[
"2025-09-29 13:59:56"
]
|
1.79 ms (14.23%) |
1 |
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC
Parameters:
[
"2025-09-29 13:59:56"
]
|
1.43 ms (11.35%) |
1 |
SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecole AS id_ecole_3, t0_.id_men AS id_men_4, t0_.libelle_dispositif AS libelle_dispositif_5, t0_.date_ouverture AS date_ouverture_6, t0_.date_fermeture AS date_fermeture_7, t0_.date_creation AS date_creation_8, t0_.date_intervention AS date_intervention_9 FROM annuaire._n_dispositif t0_ INNER JOIN annuaire._a_dispositif_up t1_ ON t0_.id_gabriel = t1_.dispositif_id
Parameters:
[] |
1.27 ms (10.10%) |
1 |
SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecol AS id_ecol_3, t0_.id_indice AS id_indice_4, t0_.id_men AS id_men_5, t0_.type_up AS type_up_6, t0_.libelle_court AS libelle_court_7, t0_.libelle_long AS libelle_long_8, t0_.niveau_up AS niveau_up_9, t0_.date_ouverture AS date_ouverture_10, t0_.date_fermeture AS date_fermeture_11, t0_.date_creation AS date_creation_12, t0_.date_intervention AS date_intervention_13, t0_.commentaires AS commentaires_14, t0_.statut AS statut_15 FROM annuaire._n_type_up t0_ WHERE t0_.id_gabriel IN (?)
Parameters:
[
"7"
]
|
1.20 ms (9.56%) |
1 |
SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecol AS id_ecol_3, t0_.id_indices AS id_indices_4, t0_.id_men AS id_men_5, t0_.libelle_court AS libelle_court_6, t0_.libelle_long AS libelle_long_7, t0_.libelle_edition AS libelle_edition_8, t0_.date_ouverture AS date_ouverture_9, t0_.date_fermeture AS date_fermeture_10, t0_.date_creation AS date_creation_11, t0_.date_intervention AS date_intervention_12, t0_.commentaires AS commentaires_13, t0_.statut AS statut_14 FROM annuaire._n_region t0_ WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t0_.id_gabriel <> 98 ORDER BY t0_.libelle_edition ASC
Parameters:
[
"2025-09-29 13:59:56"
]
|
0.66 ms (5.23%) |
1 |
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0
Parameters:
[] |
0.64 ms (5.05%) |
1 |
SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecole AS id_ecole_3, t0_.id_men AS id_men_4, t0_.filiere AS filiere_5, t0_.type AS type_6, t0_.famille AS famille_7, t0_.date_ouverture AS date_ouverture_8, t0_.date_fermeture AS date_fermeture_9, t0_.date_creation AS date_creation_10, t0_.date_intervention AS date_intervention_11, t0_.commentaires AS commentaires_12 FROM annuaire._n_option_matiere t0_ LIMIT 0
Parameters:
[] |
0.54 ms (4.27%) |
1 |
SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecole AS id_ecole_3, t0_.id_men AS id_men_4, t0_.libelle_langue AS libelle_langue_5, t0_.niveau AS niveau_6, t0_.date_ouverture AS date_ouverture_7, t0_.date_fermeture AS date_fermeture_8, t0_.date_creation AS date_creation_9, t0_.date_intervention AS date_intervention_10, t0_.commentaires AS commentaires_11 FROM annuaire._n_langues t0_ LIMIT 0
Parameters:
[] |
0.47 ms (3.75%) |
1 |
SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecol AS id_ecol_3, t0_.id_men AS id_men_4, t0_.formation AS formation_5, t0_.niveau AS niveau_6, t0_.type AS type_7, t0_.famille AS famille_8, t0_.source AS source_9, t0_.date_ouverture AS date_ouverture_10, t0_.date_fermeture AS date_fermeture_11, t0_.date_creation AS date_creation_12, t0_.date_intervention AS date_intervention_13, t0_.commentaires AS commentaires_14 FROM annuaire._n_formations t0_ LIMIT 0
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
ange1d | doctrine.dbal.ange1d_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
ange1d | doctrine.orm.ange1d_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
ange1d entity manager
No loaded entities.