Query Metrics
10
Database Queries
10
Different statements
10.46 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.76 ms (16.85%) |
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:54"
]
|
|
1.54 ms (14.76%) |
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:54"
]
|
|
1.42 ms (13.54%) |
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:54"
]
|
|
1.33 ms (12.76%) |
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.26 ms (12.03%) |
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:
[ "16" "17" "23" "21" ] |
|
0.94 ms (9.00%) |
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:54"
]
|
|
0.64 ms (6.17%) |
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.59 ms (5.68%) |
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.48 ms (4.63%) |
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.48 ms (4.58%) |
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
| Class | Mapping errors |
|---|---|
| App\Entity\NTypeUp | No errors. |
| App\Entity\Up | No errors. |
| App\Entity\NDepartement | No errors. |
| App\Entity\NRegion | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\NTypeOrganisme | No errors. |
| App\Entity\AdresseCommunication | No errors. |
| App\Entity\Individu | No errors. |
| App\Entity\NLangues | No errors. |
| App\Entity\NDispositif | No errors. |
| App\Entity\ADispositifUp | No errors. |
| App\Entity\NOptionMatiere | No errors. |
| App\Entity\NFormations | No errors. |
| App\Entity\AIndividuUp | No errors. |
| App\Entity\AIndividuUpFonction | No errors. |
| App\Entity\WsUser | No errors. |
ange1d entity manager
No loaded entities.