Query Metrics

6 Database Queries
5 Different statements
7.38 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.52 ms
(34.21%)
2
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
]
1.33 ms
(18.07%)
1
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:
[]
1.27 ms
(17.18%)
1
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
]
1.23 ms
(16.70%)
1
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:
[]
1.02 ms
(13.84%)
1
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:
[]

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.