Query Metrics

53 Database Queries
2 Different statements
6.71 ms Query time
0 Invalid entities
4531 Managed entities

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.code_postal AS code_postal_2, c0_.lon AS lon_3, c0_.lat AS lat_4, c0_.departement_id AS departement_id_5 FROM commune c0_
Parameters:
[]
2 0.34 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  0
]
3 0.16 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  1
]
4 0.13 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  165
]
5 0.13 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  171
]
6 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  175
]
7 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  181
]
8 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  188
]
9 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  323
]
10 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  192
]
11 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  196
]
12 0.13 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  2
]
13 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  314
]
14 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  352
]
15 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  353
]
16 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  325
]
17 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  38
]
18 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  39
]
19 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  3
]
20 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  40
]
21 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  41
]
22 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  42
]
23 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  5
]
24 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  70
]
25 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  71
]
26 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  7
]
27 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  43
]
28 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  44
]
29 0.13 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  306
]
30 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  258
]
31 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  6
]
32 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  48
]
33 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  246
]
34 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  330
]
35 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  4
]
36 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  236
]
37 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  242
]
38 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  10
]
39 0.12 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  54
]
40 0.13 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  55
]
41 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  56
]
42 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  8
]
43 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  57
]
44 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  58
]
45 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  59
]
46 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  313
]
47 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  9
]
48 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  220
]
49 0.10 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  221
]
50 0.10 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  11
]
51 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  230
]
52 0.13 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  265
]
53 0.11 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  252
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Commune 4314
App\Entity\MenuJeune 205
App\Entity\ContenuQualification\Departement 12

Entities Mapping

Class Mapping errors
App\Entity\Commune No errors.
App\Entity\ContenuQualification\Departement No errors.
App\Entity\User No errors.
App\Entity\Jeune No errors.
App\Entity\Evenement No errors.
App\Entity\Structure No errors.
App\Entity\MenuJeune No errors.