Query Metrics
6
Database Queries
5
Different statements
7.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.27 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.mdp AS mdp_5, t0.etat AS etat_6, t0.date_creation AS date_creation_7, t0.token AS token_8, t0.email AS email_9, t0.niveau_id AS niveau_id_10 FROM utilisateurs t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 2 | 1.02 ms |
SELECT a0_.id AS id_0, a0_.date_affectation AS date_affectation_1, a0_.device_id AS device_id_2, a0_.utilisateur_id AS utilisateur_id_3 FROM affectation_devices a0_ WHERE 1 = 1 AND a0_.utilisateur_id = 21
Parameters:
[] |
| 3 | 1.23 ms |
SELECT g0_.id AS id_0 FROM graph g0_ INNER JOIN devices d1_ ON g0_.device_id = d1_.id WHERE 1 = 1 AND d1_.id IN (2) AND d1_.id = 2
Parameters:
[] |
| 4 | 1.33 ms |
SELECT g0_.id AS id_0, g0_.nom_graph AS nom_graph_1, g0_.idx AS idx_2, g0_.seuil_min AS seuil_min_3, g0_.seuil_max AS seuil_max_4, g0_.device_id AS device_id_5, g0_.vanne_id AS vanne_id_6, g0_.categorie_id AS categorie_id_7 FROM graph g0_ INNER JOIN devices d1_ ON g0_.device_id = d1_.id WHERE 1 = 1 AND d1_.id IN (2) AND d1_.id = 2 ORDER BY g0_.id ASC LIMIT 10
Parameters:
[] |
| 5 | 1.54 ms |
SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.device_id AS device_id_3 FROM categorie_graph t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 6 | 0.98 ms |
SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.device_id AS device_id_3 FROM categorie_graph t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\Devices | No errors. |
| App\Entity\AffectationDevices | No errors. |
| App\Entity\Utilisateurs | No errors. |
| App\Entity\NiveauUtilisateur | No errors. |
| App\Entity\Graph | No errors. |
| App\Entity\Vannes | No errors. |
| App\Entity\CategorieGraph | No errors. |