Query Metrics
6
Database Queries
6
Different statements
0.93 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.18 ms (19.05%) |
1 |
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
]
|
0.18 ms (18.94%) |
1 |
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
]
|
0.17 ms (18.84%) |
1 |
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
]
|
0.15 ms (16.68%) |
1 |
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" ] |
0.14 ms (14.96%) |
1 |
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" ] |
0.11 ms (11.52%) |
1 |
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 |
|
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. |