Query Metrics
6
Database Queries
4
Different statements
1118.07 ms
Query time
4
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 5.23 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.nom_utilisateur AS nom_utilisateur_6, t0.prenoms_utilisateur AS prenoms_utilisateur_7, t0.photo AS photo_8, t0.statut AS statut_9, t0.agent_sodef AS agent_sodef_10, t0.actif AS actif_11, t0.nouveau AS nouveau_12, t0.mobile AS mobile_13, t0.profile_user AS profile_user_14, t0.numero_exploitant AS numero_exploitant_15, t0.log_code AS log_code_16, t0.created_at AS created_at_17, t0.created_by AS created_by_18, t0.updated_at AS updated_at_19, t0.updated_by AS updated_by_20, t0.is_responsable AS is_responsable_21, t0.code_sms AS code_sms_22, t0.locale AS locale_23, t0.fonction AS fonction_24, t0.superviseur_groupe AS superviseur_groupe_25, t0.code_groupe_id AS code_groupe_id_26, t0.codeexploitant_id AS codeexploitant_id_27, t0.code_service_id AS code_service_id_28, t0.code_direction_id AS code_direction_id_29, t0.codeindustriel_id AS codeindustriel_id_30, t0.code_dr_id AS code_dr_id_31, t0.code_cantonnement_id AS code_cantonnement_id_32, t0.code_operateur_id AS code_operateur_id_33, t0.code_ddef_id AS code_ddef_id_34, t0.code_poste_controle_id AS code_poste_controle_id_35, t0.code_exportateur_id AS code_exportateur_id_36, t0.titre_id AS titre_id_37, t0.code_commercant_id AS code_commercant_id_38, t0.code_oi_id AS code_oi_id_39 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
542
]
|
2 | 1.17 ms |
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.cloture AS cloture_3, t0.date_expiration_rallonge AS date_expiration_rallonge_4, t0.rallonge AS rallonge_5, t0.nb_mois AS nb_mois_6, t0.date_debut AS date_debut_7, t0.datefin AS datefin_8 FROM admin.exercice t0 WHERE t0.cloture = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
0
]
|
3 | 961.09 ms |
SELECT t0.id_performance AS id_performance_1, t0.created_by AS created_by_2, t0.created_at AS created_at_3, t0.nb_ligne AS nb_ligne_4, t0.volume AS volume_5, t0.nb_brh AS nb_brh_6 FROM metier.performance_brh t0 WHERE t0.created_at = ?
Parameters:
[
"2025-10-17"
]
|
4 | 48.84 ms |
SELECT t0.id AS id_1, t0.numero_lignepagebrh AS numero_lignepagebrh_2, t0.x_lignepagebrh AS x_lignepagebrh_3, t0.y_lignepagebrh AS y_lignepagebrh_4, t0.lettre_lignepagebrh AS lettre_lignepagebrh_5, t0.longeur_lignepagebrh AS longeur_lignepagebrh_6, t0.diametre_lignepagebrh AS diametre_lignepagebrh_7, t0.cubage_lignepagebrh AS cubage_lignepagebrh_8, t0.observationbrh AS observationbrh_9, t0.created_at AS created_at_10, t0.created_by AS created_by_11, t0.updated_at AS updated_at_12, t0.updated_by AS updated_by_13, t0.entre_lje AS entre_lje_14, t0.transformation AS transformation_15, t0.nom_essencebrh_id AS nom_essencebrh_id_16, t0.zh_lignepagebrh_id AS zh_lignepagebrh_id_17, t0.code_pagebrh_id AS code_pagebrh_id_18, t0.exercice_id AS exercice_id_19, t0.code_ligne_cp_id AS code_ligne_cp_id_20 FROM metier.lignepagebrh t0 WHERE t0.exercice_id = ? AND t0.created_by = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[ 7 "ALIMI FADEL ISMAEL" ] |
5 | 55.05 ms |
SELECT t0.id AS id_1, t0.numero_lignepagebrh AS numero_lignepagebrh_2, t0.x_lignepagebrh AS x_lignepagebrh_3, t0.y_lignepagebrh AS y_lignepagebrh_4, t0.lettre_lignepagebrh AS lettre_lignepagebrh_5, t0.longeur_lignepagebrh AS longeur_lignepagebrh_6, t0.diametre_lignepagebrh AS diametre_lignepagebrh_7, t0.cubage_lignepagebrh AS cubage_lignepagebrh_8, t0.observationbrh AS observationbrh_9, t0.created_at AS created_at_10, t0.created_by AS created_by_11, t0.updated_at AS updated_at_12, t0.updated_by AS updated_by_13, t0.entre_lje AS entre_lje_14, t0.transformation AS transformation_15, t0.nom_essencebrh_id AS nom_essencebrh_id_16, t0.zh_lignepagebrh_id AS zh_lignepagebrh_id_17, t0.code_pagebrh_id AS code_pagebrh_id_18, t0.exercice_id AS exercice_id_19, t0.code_ligne_cp_id AS code_ligne_cp_id_20 FROM metier.lignepagebrh t0 WHERE t0.exercice_id = ? AND t0.created_by = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[ 7 "DIGBO BLE MARIE" ] |
6 | 46.68 ms |
SELECT t0.id AS id_1, t0.numero_lignepagebrh AS numero_lignepagebrh_2, t0.x_lignepagebrh AS x_lignepagebrh_3, t0.y_lignepagebrh AS y_lignepagebrh_4, t0.lettre_lignepagebrh AS lettre_lignepagebrh_5, t0.longeur_lignepagebrh AS longeur_lignepagebrh_6, t0.diametre_lignepagebrh AS diametre_lignepagebrh_7, t0.cubage_lignepagebrh AS cubage_lignepagebrh_8, t0.observationbrh AS observationbrh_9, t0.created_at AS created_at_10, t0.created_by AS created_by_11, t0.updated_at AS updated_at_12, t0.updated_by AS updated_by_13, t0.entre_lje AS entre_lje_14, t0.transformation AS transformation_15, t0.nom_essencebrh_id AS nom_essencebrh_id_16, t0.zh_lignepagebrh_id AS zh_lignepagebrh_id_17, t0.code_pagebrh_id AS code_pagebrh_id_18, t0.exercice_id AS exercice_id_19, t0.code_ligne_cp_id AS code_ligne_cp_id_20 FROM metier.lignepagebrh t0 WHERE t0.exercice_id = ? AND t0.created_by = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[ 7 "DJOMAN Kossoboua" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
alt | doctrine.dbal.alt_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.