Query Metrics
36
Database Queries
7
Different statements
50.76 ms
Query time
0
Invalid entities
1006
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 39.15 ms |
SELECT m0_.id AS id_0, m0_.identifiant_ml AS identifiant_ml_1, m0_.code_ml AS code_ml_2, m0_.nom_ml AS nom_ml_3, m0_.latitude AS latitude_4, m0_.longitude AS longitude_5, m0_.bbox_north AS bbox_north_6, m0_.bbox_south AS bbox_south_7, m0_.bbox_east AS bbox_east_8, m0_.bbox_west AS bbox_west_9, m0_.geometry AS geometry_10 FROM mission_local_ref m0_ WHERE m0_.geometry IS NOT NULL
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 0.82 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 3 | 0.54 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
| 4 | 0.48 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||
| 5 | 0.26 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||||||||
| 6 | 0.24 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||||
| 7 | 0.24 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
6
]
|
||||||||||||||||||||||||||||
| 8 | 0.19 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
7
]
|
||||||||||||||||||||||||||||
| 9 | 0.25 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
8
]
|
||||||||||||||||||||||||||||
| 10 | 0.23 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
9
]
|
||||||||||||||||||||||||||||
| 11 | 0.24 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
10
]
|
||||||||||||||||||||||||||||
| 12 | 0.23 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
11
]
|
||||||||||||||||||||||||||||
| 13 | 0.20 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
12
]
|
||||||||||||||||||||||||||||
| 14 | 0.20 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
13
]
|
||||||||||||||||||||||||||||
| 15 | 0.20 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
14
]
|
||||||||||||||||||||||||||||
| 16 | 0.20 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
15
]
|
||||||||||||||||||||||||||||
| 17 | 0.21 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||
| 18 | 0.22 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
17
]
|
||||||||||||||||||||||||||||
| 19 | 0.30 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
18
]
|
||||||||||||||||||||||||||||
| 20 | 0.26 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
19
]
|
||||||||||||||||||||||||||||
| 21 | 0.21 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
20
]
|
||||||||||||||||||||||||||||
| 22 | 0.22 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
21
]
|
||||||||||||||||||||||||||||
| 23 | 0.22 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
22
]
|
||||||||||||||||||||||||||||
| 24 | 0.22 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
23
]
|
||||||||||||||||||||||||||||
| 25 | 0.18 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
24
]
|
||||||||||||||||||||||||||||
| 26 | 0.26 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
25
]
|
||||||||||||||||||||||||||||
| 27 | 0.32 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
26
]
|
||||||||||||||||||||||||||||
| 28 | 0.21 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
27
]
|
||||||||||||||||||||||||||||
| 29 | 0.26 ms |
SELECT t0.id AS id_1, t0.identifiant_commune AS identifiant_commune_2, t0.insee_commune AS insee_commune_3, t0.nom_commune AS nom_commune_4, t0.departement_commune AS departement_commune_5, t0.region_commune AS region_commune_6, t0.insee_region_commune AS insee_region_commune_7, t0.region_ml AS region_ml_8, t0.insee_region_ml AS insee_region_ml_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.commune_sur_plusieurs_ml AS commune_sur_plusieurs_ml_12, t0.bbox_north AS bbox_north_13, t0.bbox_south AS bbox_south_14, t0.bbox_east AS bbox_east_15, t0.bbox_west AS bbox_west_16, t0.mission_local_ref_id AS mission_local_ref_id_17 FROM mission_local t0 WHERE t0.mission_local_ref_id = ?
Parameters:
[
28
]
|
||||||||||||||||||||||||||||
| 30 | 0.28 ms |
SELECT COUNT(*) FROM mission_local t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 31 | 0.29 ms |
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.title AS title_2, a0_.date AS date_3, a0_.content AS content_4, a0_.published AS published_5, a0_.position AS position_6, a0_.image AS image_7 FROM article a0_ WHERE a0_.published = ? ORDER BY CASE WHEN a0_.position = 0 THEN 1 ELSE 0 END ASC, a0_.position ASC, a0_.date DESC LIMIT 3
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 32 | 0.28 ms |
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.position AS position_4, m0_.enabled AS enabled_5, m0_.page_id AS page_id_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id IS NULL AND m0_.enabled = ? ORDER BY m0_.position ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 33 | 0.20 ms |
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.position AS position_4, m0_.enabled AS enabled_5, m0_.page_id AS page_id_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id = ? AND m0_.enabled = ? ORDER BY m0_.position ASC
Parameters:
[ 3 1 ] |
||||||||||||||||||||||||||||
| 34 | 0.18 ms |
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.position AS position_4, m0_.enabled AS enabled_5, m0_.page_id AS page_id_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id = ? AND m0_.enabled = ? ORDER BY m0_.position ASC
Parameters:
[ 7 1 ] |
||||||||||||||||||||||||||||
| 35 | 0.19 ms |
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.position AS position_4, m0_.enabled AS enabled_5, m0_.page_id AS page_id_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id = ? AND m0_.enabled = ? ORDER BY m0_.position ASC
Parameters:
[ 1 1 ] |
||||||||||||||||||||||||||||
| 36 | 2.58 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.content AS content_4, t0.image AS image_5, t0.attachments AS attachments_6 FROM page t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\MissionLocal | 968 |
| App\Entity\MissionLocalRef | 28 |
| App\Entity\MenuItem | 6 |
| App\Entity\Article | 3 |
| App\Entity\Page | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\MissionLocalRef | No errors. |
| App\Entity\MissionLocal | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\MenuItem | No errors. |
| App\Entity\Page | No errors. |