GET http://pndl.org:9000/arbre

Query Metrics

81 Database Queries
8 Different statements
13.28 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.87 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 ORDER BY t0.secteur ASC
Parameters:
[]
2 0.19 ms
SELECT t0.id AS id_1, t0.pole AS pole_2 FROM pole t0 ORDER BY t0.pole ASC
Parameters:
[]
3 0.19 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 ORDER BY t0.region ASC
Parameters:
[]
4 0.18 ms
SELECT t0.id AS id_1, t0.projet AS projet_2, t0.sigle AS sigle_3 FROM projet t0 ORDER BY t0.projet ASC
Parameters:
[]
5 0.23 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 WHERE t0.pole_id = ?
Parameters:
[
  3
]
6 0.15 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  3
]
7 0.17 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  43
]
8 0.19 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  45
]
9 0.16 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  46
]
10 0.16 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  4
]
11 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  74
]
12 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  75
]
13 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  76
]
14 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  77
]
15 0.14 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  5
]
16 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  68
]
17 0.16 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  69
]
18 0.23 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  70
]
19 0.14 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 WHERE t0.pole_id = ?
Parameters:
[
  1
]
20 0.16 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  1
]
21 0.17 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  64
]
22 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  65
]
23 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  66
]
24 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  67
]
25 0.15 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 WHERE t0.pole_id = ?
Parameters:
[
  7
]
26 0.14 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  2
]
27 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  26
]
28 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  51
]
29 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  52
]
30 0.13 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  8
]
31 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  10
]
32 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  11
]
33 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  12
]
34 0.12 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 WHERE t0.pole_id = ?
Parameters:
[
  6
]
35 0.14 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  10
]
36 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  71
]
37 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  72
]
38 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  78
]
39 0.11 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 WHERE t0.pole_id = ?
Parameters:
[
  5
]
40 0.13 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  9
]
41 0.19 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  48
]
42 0.16 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  49
]
43 0.17 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  50
]
44 0.15 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 WHERE t0.pole_id = ?
Parameters:
[
  8
]
45 0.12 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  7
]
46 0.16 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  30
]
47 0.16 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  35
]
48 0.24 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  59
]
49 0.13 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  11
]
50 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  16
]
51 0.19 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  17
]
52 0.20 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  18
]
53 0.14 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  14
]
54 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  28
]
55 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  33
]
56 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  37
]
57 0.13 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 WHERE t0.pole_id = ?
Parameters:
[
  4
]
58 0.11 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  6
]
59 0.13 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  24
]
60 0.13 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  29
]
61 0.13 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  36
]
62 0.11 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  12
]
63 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  60
]
64 0.13 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  61
]
65 0.15 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  62
]
66 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  63
]
67 0.12 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.pole_id AS pole_id_5 FROM region t0 WHERE t0.pole_id = ?
Parameters:
[
  2
]
68 0.12 ms
SELECT t0.id AS id_1, t0.departement AS departement_2, t0.region_id AS region_id_3 FROM departement t0 WHERE t0.region_id = ?
Parameters:
[
  13
]
69 0.13 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  13
]
70 0.12 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  14
]
71 0.14 ms
SELECT t0.id AS id_1, t0.commune AS commune_2, t0.type AS type_3, t0.region_id AS region_id_4, t0.departement_id AS departement_id_5 FROM commune t0 WHERE t0.departement_id = ?
Parameters:
[
  15
]
72 0.25 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nature AS nature_3, t0.secteur_id AS secteur_id_4 FROM libellemicroprojet t0 WHERE t0.secteur_id = ?
Parameters:
[
  1
]
73 0.29 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nature AS nature_3, t0.secteur_id AS secteur_id_4 FROM libellemicroprojet t0 WHERE t0.secteur_id = ?
Parameters:
[
  2
]
74 0.17 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nature AS nature_3, t0.secteur_id AS secteur_id_4 FROM libellemicroprojet t0 WHERE t0.secteur_id = ?
Parameters:
[
  3
]
75 0.15 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nature AS nature_3, t0.secteur_id AS secteur_id_4 FROM libellemicroprojet t0 WHERE t0.secteur_id = ?
Parameters:
[
  4
]
76 0.17 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nature AS nature_3, t0.secteur_id AS secteur_id_4 FROM libellemicroprojet t0 WHERE t0.secteur_id = ?
Parameters:
[
  5
]
77 0.15 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nature AS nature_3, t0.secteur_id AS secteur_id_4 FROM libellemicroprojet t0 WHERE t0.secteur_id = ?
Parameters:
[
  6
]
78 0.17 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nature AS nature_3, t0.secteur_id AS secteur_id_4 FROM libellemicroprojet t0 WHERE t0.secteur_id = ?
Parameters:
[
  7
]
79 0.13 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nature AS nature_3, t0.secteur_id AS secteur_id_4 FROM libellemicroprojet t0 WHERE t0.secteur_id = ?
Parameters:
[
  8
]
80 0.14 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nature AS nature_3, t0.secteur_id AS secteur_id_4 FROM libellemicroprojet t0 WHERE t0.secteur_id = ?
Parameters:
[
  9
]
81 0.22 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nature AS nature_3, t0.secteur_id AS secteur_id_4 FROM libellemicroprojet t0 WHERE t0.secteur_id = ?
Parameters:
[
  10
]

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.