GET https://nfid-ppd-astrid02.dedie.ate.info/odm

Query Metrics

5 Database Queries
5 Different statements
0.69 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.16 ms
SELECT t0.id AS id_1, t0.mail AS mail_2, t0.roles AS roles_3, t0.password AS password_4, t0.cree_le AS cree_le_5, t0.maj_le AS maj_le_6, t0.date_activation AS date_activation_7, t0.date_expiration AS date_expiration_8, t0.rgpd_validation AS rgpd_validation_9, t0.date_validation_rgpd AS date_validation_rgpd_10, t0.date_derniere_connexion AS date_derniere_connexion_11, t0.organisation AS organisation_12, t0.is_verified AS is_verified_13, t0.raison_demande_compte AS raison_demande_compte_14, t0.cree_par_id AS cree_par_id_15, t0.maj_par_id AS maj_par_id_16, t0.statut_utilisateur_id AS statut_utilisateur_id_17, t0.contact_id AS contact_id_18, t0.role_user_id AS role_user_id_19 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
  130
]
2 0.11 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.display_order AS display_order_3, t0.is_displayed AS is_displayed_4 FROM role_user t0 WHERE t0.id = ?
Parameters:
[
  8
]
3 0.11 ms
SELECT t0.id AS id_1, t0.can_reading AS can_reading_2, t0.can_writing AS can_writing_3, t0.role_user_id AS role_user_id_4, t0.role_section_id AS role_section_id_5 FROM role_access t0 WHERE t0.role_user_id = ?
Parameters:
[
  8
]
4 0.19 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.couleur AS couleur_2, c0_.code_couleur AS code_couleur_3, c0_.categorie_active AS categorie_active_4, c0_.reporting_service_entreprise AS reporting_service_entreprise_5, c0_.annee AS annee_6 FROM crm_type_imputation c0_ ORDER BY c0_.id ASC
Parameters:
[]
5 0.11 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1 FROM crm_type_odm_statut c0_ ORDER BY c0_.id ASC
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\Utilisateur No errors.
App\Entity\ParcoursUtilisateur No errors.
App\Entity\StatutUtilisateur No errors.
App\Entity\Contact No errors.
App\Entity\RoleUser No errors.
App\Entity\Liste No errors.
App\Entity\RoleAccess No errors.
App\Entity\RoleSection No errors.
App\Entity\Crm\Imputation
  • The field 'App\Entity\Crm\Imputation#isActive' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Crm\Imputation#isBusinessServiceReporting' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Crm\Odm\Status No errors.