GET https://nfid-ppd-astrid02.dedie.ate.info/ajax/odm/manager?page=1

Query Metrics

6 Database Queries
6 Different statements
1.16 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.23 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.cree_le AS cree_le_4, t0.maj_le AS maj_le_5, t0.civilite_id AS civilite_id_6, t0.cree_par_id AS cree_par_id_7, t0.maj_par_id AS maj_par_id_8 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  48136
]
3 0.19 ms
SELECT t0.id AS id_1, t0.mail_parcours AS mail_parcours_2, t0.date_entree AS date_entree_3, t0.date_sortie AS date_sortie_4, t0.fonction AS fonction_5, t0.cree_le AS cree_le_6, t0.maj_le AS maj_le_7, t0.telephone AS telephone_8, t0.telephone_portable AS telephone_portable_9, t0.parcours_principal AS parcours_principal_10, t0.parcours_desactive AS parcours_desactive_11, t0.cree_par_id AS cree_par_id_12, t0.maj_par_id AS maj_par_id_13, t0.contact_id AS contact_id_14, t0.entite_id AS entite_id_15, t0.manager_id AS manager_id_16 FROM parcours_utilisateur t0 WHERE t0.contact_id = ?
Parameters:
[
  48136
]
4 0.25 ms
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM crm_odm c0_ WHERE c0_.responsable_id = ? AND ((YEAR(c0_.date_debut) = ? AND MONTH(c0_.date_debut) = ?) OR (YEAR(c0_.date_fin) = ? AND MONTH(c0_.date_fin) = ?))
Parameters:
[
  60756
  "2024"
  "11"
  "2024"
  "11"
]
5 0.17 ms
SELECT DISTINCT c0_.id AS id_0 FROM crm_odm c0_ WHERE c0_.responsable_id = ? AND ((YEAR(c0_.date_debut) = ? AND MONTH(c0_.date_debut) = ?) OR (YEAR(c0_.date_fin) = ? AND MONTH(c0_.date_fin) = ?)) LIMIT 5
Parameters:
[
  60756
  "2024"
  "11"
  "2024"
  "11"
]
6 0.16 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.actif AS actif_3 FROM crm_api_coupe_circuit t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\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.
App\Entity\Civilite No errors.
App\Entity\Entite No errors.
App\Entity\Accompagnement No errors.
App\Entity\EvenementParticipantParcours No errors.
App\Entity\EvenementInscritParcours No errors.
App\Entity\Crm\Odm\Odm No errors.
App\Entity\Crm\KillSwitch No errors.