Query Metrics

26 Database Queries
5 Different statements
6.61 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.47 ms
SELECT DISTINCT c0_.id AS id_0 FROM centredetri c0_ LIMIT 20
Parameters:
[]
2 0.41 ms
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:
[
  13
  14
  15
  16
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
  31
  32
  33
]
3 0.26 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM centredetri c0_
Parameters:
[]
4 0.23 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM site t0 WHERE t0.id = ?
Parameters:
[
  11
]
5 0.32 ms
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:
[
  13
]
6 0.26 ms
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:
[
  14
]
7 0.23 ms
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:
[
  15
]
8 0.23 ms
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:
[
  16
]
9 0.22 ms
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:
[
  18
]
10 0.22 ms
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:
[
  19
]
11 0.22 ms
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:
[
  20
]
12 0.21 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM site t0 WHERE t0.id = ?
Parameters:
[
  12
]
13 0.22 ms
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:
[
  21
]
14 0.22 ms
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:
[
  22
]
15 0.23 ms
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:
[
  23
]
16 0.44 ms
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:
[
  24
]
17 0.23 ms
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:
[
  25
]
18 0.22 ms
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:
[
  26
]
19 0.22 ms
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:
[
  27
]
20 0.23 ms
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:
[
  28
]
21 0.23 ms
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:
[
  29
]
22 0.22 ms
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:
[
  30
]
23 0.22 ms
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:
[
  31
]
24 0.23 ms
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:
[
  32
]
25 0.21 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM site t0 WHERE t0.id = ?
Parameters:
[
  13
]
26 0.22 ms
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:
[
  33
]

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