POST http://boislegal.ci/snvlt/p/st/pt_users/17-10-2025

Query Metrics

6 Database Queries
4 Different statements
1118.07 ms Query time
4 Invalid entities

Queries

Group similar statements

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.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The mappings App\Entity\User#code_cantonnement and App\Entity\References\Cantonnement#utilisateurs are inconsistent with each other.
  • The mappings App\Entity\User#mes_messages and App\Entity\Administration\Messagerie#code_utilisateur are inconsistent with each other.
App\Entity\Groupe No errors.
App\Entity\References\Exploitant No errors.
App\Entity\References\ServiceMinef No errors.
App\Entity\References\Direction No errors.
App\Entity\References\Usine No errors.
App\Entity\References\Dr No errors.
App\Entity\References\Cantonnement No errors.
App\Entity\References\TypeOperateur No errors.
App\Entity\References\Ddef No errors.
App\Entity\References\PosteForestier No errors.
App\Entity\References\Exportateur No errors.
App\Entity\References\Titre No errors.
App\Entity\References\Commercant No errors.
App\Entity\References\Oi No errors.
App\Entity\Administration\Notification No errors.
App\Entity\Administration\DemandeOperateur No errors.
App\Entity\Administration\Messagerie
  • The association App\Entity\Administration\Messagerie#code_utilisateur refers to the inverse side field App\Entity\User#code_utilisateur which does not exist.
App\Entity\References\DocumentOperateur No errors.
App\Entity\Admin\LogSnvlt No errors.
App\Entity\Observateur\Ticket No errors.
App\Entity\References\Caroi No errors.
App\Entity\Admin\Exercice
  • The mappings App\Entity\Admin\Exercice#lignepagebcbps and App\Entity\DocStats\Saisie\Lignepagebcbp#exercice are inconsistent with each other.
App\Entity\DocStats\Entetes\Documentlje No errors.
App\Entity\DocStats\Entetes\Documentbtgu No errors.
App\Entity\DocStats\Saisie\Lignepagelje No errors.
App\Entity\DocStats\Saisie\Lignepagebcbp No errors.
App\Entity\DocStats\Saisie\Lignepagebtgu No errors.
App\Entity\DocStats\Entetes\Documentfp No errors.
App\Entity\DocStats\Saisie\Lignepagefp No errors.
App\Entity\DocStats\Entetes\Documentcp No errors.
App\Entity\DocStats\Entetes\Documentbrh No errors.
App\Entity\DocStats\Entetes\Documentbcbp No errors.
App\Entity\DocStats\Entetes\Documentetate
  • The field 'App\Entity\DocStats\Entetes\Documentetate#updated_at' has the property type 'DateTimeInterface' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Entity\DocStats\Entetes\Documentetate2 No errors.
App\Entity\DocStats\Entetes\Documentetatg No errors.
App\Entity\DocStats\Entetes\Documentetath No errors.
App\Entity\DocStats\Entetes\Documentdmp No errors.
App\Entity\DocStats\Entetes\Documentdmv No errors.
App\Entity\DocStats\Entetes\Documentpdtdrv No errors.
App\Entity\Autorisation\AutorisationPs No errors.
App\Entity\Autorisation\AutorisationPv No errors.
App\Entity\Autorisation\AutorisationPdtdrv No errors.
App\Entity\Transformation\Contrat No errors.
App\Entity\DocStats\Entetes\Documentbcburb No errors.
App\Entity\DocStats\Entetes\Documentbrepf No errors.
App\Entity\Autorisation\AutorisationExportateur No errors.
App\Entity\DocStats\Entetes\Documentrsdpf No errors.
App\Entity\DocStats\Entetes\Documentbth No errors.
App\Entity\Transformation\Colis No errors.
App\Entity\DocStats\Saisie\Lignepagebrh No errors.
App\Entity\Autorisation\Attribution No errors.
App\Entity\Autorisation\Reprise No errors.
App\Entity\DocStats\Saisie\Lignepagecp No errors.
App\Entity\DocStats\Entetes\SuiviDoc No errors.
App\Entity\Requetes\PerformanceBrh No errors.
App\Entity\References\Essence No errors.
App\Entity\References\ZoneHemispherique No errors.
App\Entity\DocStats\Pages\Pagebrh No errors.