Query Metrics

13 Database Queries
5 Different statements
2.69 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
1.19 ms
(44.19%)
8
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.site_id AS site_id_3, t0.client_id AS client_id_4, t0.centredetri_id AS centredetri_id_5 FROM hall t0 WHERE t0.centredetri_id = ?
Parameters:
[
  34
]
0.59 ms
(21.86%)
1
SELECT DISTINCT c0_.id AS id_0 FROM centredetri c0_ LIMIT 20 OFFSET 20
Parameters:
[]
0.34 ms
(12.69%)
1
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.taille AS taille_2, c0_.barrierages AS barrierages_3, c0_.marquageausol AS marquageausol_4, c0_.tonnelle AS tonnelle_5, c0_.signaletiques AS signaletiques_6, c0_.supportsachs AS supportsachs_7, c0_.balances AS balances_8, c0_.compacteur AS compacteur_9, c0_.tabledetri AS tabledetri_10, c0_.vidoirliquide AS vidoirliquide_11, c0_.troussedesecours AS troussedesecours_12, c0_.epi AS epi_13, c0_.materielsdenettoyage AS materielsdenettoyage_14, c0_.phase AS phase_15, c0_.bacdr660 AS bacdr660_16, c0_.bacdr240 AS bacdr240_17, c0_.bacrecycle240 AS bacrecycle240_18, c0_.bacrecycle660 AS bacrecycle660_19, c0_.bacbiodechet120 AS bacbiodechet120_20, c0_.bennebois AS bennebois_21, c0_.bennecarton AS bennecarton_22, c0_.benneplastiques AS benneplastiques_23, c0_.bachenoires AS bachenoires_24, c0_.site_id AS site_id_25 FROM centredetri c0_ WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  34
  35
  36
  37
  38
  39
  40
  41
]
0.32 ms
(11.84%)
2
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM site t0 WHERE t0.id = ?
Parameters:
[
  13
]
0.25 ms
(9.42%)
1
SELECT COUNT(c0_.id) AS sclr_0 FROM centredetri c0_
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\Centredetri No errors.
App\Entity\Site No errors.
App\Entity\Hall No errors.
App\Entity\Suivicentredetri No errors.
App\Entity\Suivi No errors.
App\Entity\Photosarchives No errors.
App\Entity\Client No errors.
App\Entity\Evenement No errors.
App\Entity\Inventaire No errors.
App\Entity\Suivijournalierstand No errors.