Query Metrics
59
Database Queries
8
Different statements
34.13 ms
Query time
0
Invalid entities
28
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.35 ms |
SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.osm_data_date_min AS osm_data_date_min_19, t0.osm_data_date_avg AS osm_data_date_avg_20, t0.osm_data_date_max AS osm_data_date_max_21, t0.budget_annuel AS budget_annuel_22, t0.lat AS lat_23, t0.lon AS lon_24, t0.date_labourage_requested AS date_labourage_requested_25, t0.date_labourage_done AS date_labourage_done_26, t0.kind AS kind_27 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters:
[
"29232"
]
|
||||||||||||||||||||||||||||||||
| 2 | 2.01 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "fire_hydrant" ]
|
||||||||||||||||||||||||||||||||
| 3 | 1.11 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "charging_station" ]
|
||||||||||||||||||||||||||||||||
| 4 | 1.08 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "toilets" ]
|
||||||||||||||||||||||||||||||||
| 5 | 1.15 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "bus_stop" ]
|
||||||||||||||||||||||||||||||||
| 6 | 1.10 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "defibrillator" ]
|
||||||||||||||||||||||||||||||||
| 7 | 1.07 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "camera" ]
|
||||||||||||||||||||||||||||||||
| 8 | 1.08 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "recycling" ]
|
||||||||||||||||||||||||||||||||
| 9 | 0.79 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "substation" ]
|
||||||||||||||||||||||||||||||||
| 10 | 0.76 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "laboratory" ]
|
||||||||||||||||||||||||||||||||
| 11 | 0.75 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "school" ]
|
||||||||||||||||||||||||||||||||
| 12 | 0.84 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "police" ]
|
||||||||||||||||||||||||||||||||
| 13 | 0.74 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "healthcare" ]
|
||||||||||||||||||||||||||||||||
| 14 | 0.62 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "bicycle_parking" ]
|
||||||||||||||||||||||||||||||||
| 15 | 0.61 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "advertising_board" ]
|
||||||||||||||||||||||||||||||||
| 16 | 0.48 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "building" ]
|
||||||||||||||||||||||||||||||||
| 17 | 0.47 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "rnb" ]
|
||||||||||||||||||||||||||||||||
| 18 | 0.48 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "email" ]
|
||||||||||||||||||||||||||||||||
| 19 | 0.47 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "bench" ]
|
||||||||||||||||||||||||||||||||
| 20 | 0.48 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "waste_basket" ]
|
||||||||||||||||||||||||||||||||
| 21 | 0.48 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "street_lamp" ]
|
||||||||||||||||||||||||||||||||
| 22 | 0.43 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "drinking_water" ]
|
||||||||||||||||||||||||||||||||
| 23 | 0.39 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "tree" ]
|
||||||||||||||||||||||||||||||||
| 24 | 0.39 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "power_pole" ]
|
||||||||||||||||||||||||||||||||
| 25 | 0.38 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "manhole" ]
|
||||||||||||||||||||||||||||||||
| 26 | 0.41 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "little_free_library" ]
|
||||||||||||||||||||||||||||||||
| 27 | 0.39 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "playground" ]
|
||||||||||||||||||||||||||||||||
| 28 | 0.39 ms |
SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = ? AND z0_.theme = ?
Parameters:
[ 9083 "restaurant" ]
|
||||||||||||||||||||||||||||||||
| 29 | 0.21 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 30 | 0.37 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "fire_hydrant" 9083 ]
|
||||||||||||||||||||||||||||||||
| 31 | 0.30 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "charging_station" 9083 ]
|
||||||||||||||||||||||||||||||||
| 32 | 0.30 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "toilets" 9083 ]
|
||||||||||||||||||||||||||||||||
| 33 | 0.30 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bus_stop" 9083 ]
|
||||||||||||||||||||||||||||||||
| 34 | 0.29 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "defibrillator" 9083 ]
|
||||||||||||||||||||||||||||||||
| 35 | 0.27 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "camera" 9083 ]
|
||||||||||||||||||||||||||||||||
| 36 | 0.27 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "recycling" 9083 ]
|
||||||||||||||||||||||||||||||||
| 37 | 0.25 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "substation" 9083 ]
|
||||||||||||||||||||||||||||||||
| 38 | 0.26 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "laboratory" 9083 ]
|
||||||||||||||||||||||||||||||||
| 39 | 0.26 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "school" 9083 ]
|
||||||||||||||||||||||||||||||||
| 40 | 0.26 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "police" 9083 ]
|
||||||||||||||||||||||||||||||||
| 41 | 0.26 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bicycle_parking" 9083 ]
|
||||||||||||||||||||||||||||||||
| 42 | 0.26 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "advertising_board" 9083 ]
|
||||||||||||||||||||||||||||||||
| 43 | 0.24 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "building" 9083 ]
|
||||||||||||||||||||||||||||||||
| 44 | 0.23 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "rnb" 9083 ]
|
||||||||||||||||||||||||||||||||
| 45 | 0.23 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "email" 9083 ]
|
||||||||||||||||||||||||||||||||
| 46 | 0.23 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "bench" 9083 ]
|
||||||||||||||||||||||||||||||||
| 47 | 0.25 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "waste_basket" 9083 ]
|
||||||||||||||||||||||||||||||||
| 48 | 0.24 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "street_lamp" 9083 ]
|
||||||||||||||||||||||||||||||||
| 49 | 0.23 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "drinking_water" 9083 ]
|
||||||||||||||||||||||||||||||||
| 50 | 0.23 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "tree" 9083 ]
|
||||||||||||||||||||||||||||||||
| 51 | 0.23 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "power_pole" 9083 ]
|
||||||||||||||||||||||||||||||||
| 52 | 0.22 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "manhole" 9083 ]
|
||||||||||||||||||||||||||||||||
| 53 | 0.22 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "playground" 9083 ]
|
||||||||||||||||||||||||||||||||
| 54 | 0.23 ms |
INSERT INTO zone_places (disappeared_list, current_list, theme, stats_id) VALUES (?, ?, ?, ?)
Parameters:
[ "[]" "[]" "restaurant" 9083 ]
|
||||||||||||||||||||||||||||||||
| 55 | 1.70 ms |
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"node","id":318237313,"user":"DiaouligRu","timestamp":"2025-12-22T19:13:03Z","changeset":176278462,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":330137984,"user":"Herv\u00e9 TUC","timestamp":"2025-09-22T20:05:55Z","changeset":172313714,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":330137985,"user":"Lisapple","timestamp":"2026-01-16T19:06:46Z","changeset":177312651,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":330137991,"user":"Lisapple","timestamp":"2025-08-08T15:43:17Z","changeset":170162805,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":330344427,"user":"Lisapple","timestamp":"2025-07-23T17:48:41Z","changeset":169358978,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":330728891,"user":"GrandK","timestamp":"2023-06-12T09:33:22Z","changeset":137236145,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":335605486,"user":"KlubAnDouarSantel","timestamp":"2022-01-01T13:58:32Z","changeset":115637199,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":355022694,"user":"ChRogel","timestamp":"2025-11-11T22:32:57Z","changeset":174533614,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":371814275,"user":"Herv\u00e9 TUC","timestamp":"2025-09-22T20:05:55Z","changeset":172313714,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":391457835,"user":"AmiFritz","timestamp":"2023-09-23T13:32:32Z","changeset":141645374,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":430352213,"user":"ChRogel","timestamp":"2026-01-03T16:33:58Z","changeset":176789175,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":464747232,"user":"Kalepom","timestamp":"2020-11-07T18:26:17Z","changeset":93716685,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":573943813,"user":"Lisapple","timestamp":"2025-08-08T15:39:46Z","changeset":170162585,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":1466127197,"user":"ChRogel","timestamp":"2020-04-04T22:10:13Z","changeset":83084322,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":1823920197,"user":"Delarte030","timestamp":"2025-05-28T15:22:07Z","changeset":166881240,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":1998658008,"user":"Lisapple","timestamp":"2026-01-16T19:06:42Z","changeset":177312651,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":2071503075,"user":"tyr_asd","timestamp":"2020-03-26T10:51:43Z","changeset":82656028,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":2072559817,"user":"KlubAnDouarSantel","timestamp":"2022-01-02T12:49:59Z","changeset":115668139,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":2146533949,"user":"Herv\u00e9 TUC","timestamp":"2025-09-22T20:05:55Z","changeset":172313714,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":2290171187,"user":"Lisapple","timestamp":"2025-07-16T16:22:52Z","changeset":169022516,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":2290178030,"user":"Kalepom","timestamp":"2020-11-08T22:54:54Z","changeset":93759610,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":2499364285,"user":"ChRogel","timestamp":"2026-01-05T23:07:19Z","changeset":176882060,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":3117257013,"user":"KlubAnDouarSantel","timestamp":"2021-12-30T22:55:20Z","changeset":115585731,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":3708647977,"user":"Rom1","timestamp":"2021-05-26T20:52:11Z","changeset":105379459,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":3764679493,"user":"detoxify9964","timestamp":"2025-04-14T10:53:47Z","changeset":164933149,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":3976257870,"user":"Herv\u00e9 TUC","timestamp":"2025-09-22T20:05:55Z","changeset":172313714,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":4941252658,"user":"Lisapple","timestamp":"2026-01-16T19:06:20Z","changeset":177312651,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":5041261424,"user":"Lisapple","timestamp":"2025-07-10T15:50:33Z","changeset":168750193,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":5230412801,"user":"Rom1","timestamp":"2021-05-26T20:52:11Z","changeset":105379459,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":5800405253,"user":"codll","timestamp":"2025-04-12T15:34:04Z","changeset":164861216,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":6423255928,"user":"Lisapple","timestamp":"2025-08-08T15:43:04Z","changeset":170162805,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":6544801327,"user":"Lisapple","timestamp":"2025-08-08T15:35:34Z","changeset":170162443,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":6910672313,"user":"Rom1","timestamp":"2021-05-27T15:13:21Z","changeset":105434455,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":7324955007,"user":"Herv\u00e9 TUC","timestamp":"2025-09-22T20:05:55Z","changeset":172313714,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":7367621583,"user":"ChRogel","timestamp":"2025-11-09T22:48:49Z","changeset":174438928,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":7496908725,"user":"chabe01","timestamp":"2022-08-18T20:48:58Z","changeset":125080620,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":7496908730,"user":"KlubAnDouarSantel","timestamp":"2022-01-01T13:27:02Z","changeset":115636221,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":7511525446,"user":"Delarte030","timestamp":"2025-05-28T14:52:47Z","changeset":166879979,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":8204800207,"user":"Mateusz Konieczny - bot account","timestamp":"2023-08-09T09:34:26Z","changeset":139650042,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":8770137307,"user":"Rom1","timestamp":"2021-05-26T20:52:11Z","changeset":105379459,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":8772853708,"user":"Rom1","timestamp":"2021-05-27T15:13:21Z","changeset":105434455,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":9408419569,"user":"RaphAstronome","timestamp":"2022-01-10T20:15:59Z","changeset":115996785,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":10004016200,"user":"lovelyfurball88","timestamp":"2022-09-30T21:14:56Z","changeset":126840809,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":10251110413,"user":"Lisapple","timestamp":"2025-08-08T15:35:28Z","changeset":170162443,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":10307528596,"user":"ChRogel","timestamp":"2023-05-22T22:49:50Z","changeset":136432407,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":11063748965,"user":"Lisapple","timestamp":"2026-01-16T19:06:11Z","changeset":177312651,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":11067215480,"user":"ChRogel","timestamp":"2023-07-25T15:20:28Z","changeset":138995059,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":11476328724,"user":"VLD528","timestamp":"2024-02-14T14:10:10Z","changeset":147452822,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":11950844156,"user":"ChRogel","timestamp":"2024-06-01T21:55:18Z","changeset":152139644,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12170459822,"user":"Everteal","timestamp":"2025-10-26T23:36:56Z","changeset":173815808,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12601709620,"user":"codll","timestamp":"2025-02-19T19:44:00Z","changeset":162715075,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12601709627,"user":"codll","timestamp":"2025-02-19T19:44:00Z","changeset":162715075,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12601724789,"user":"Lisapple","timestamp":"2025-07-10T15:48:23Z","changeset":168750118,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12623929885,"user":"codll","timestamp":"2025-02-27T20:38:07Z","changeset":163028052,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12742086438,"user":"foehn","timestamp":"2025-04-09T18:01:55Z","changeset":164736909,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12742086439,"user":"foehn","timestamp":"2025-04-09T18:01:55Z","changeset":164736909,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12742086440,"user":"foehn","timestamp":"2025-04-09T18:01:55Z","changeset":164736909,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12779097001,"user":"Everteal","timestamp":"2025-10-26T23:36:56Z","changeset":173815808,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12951654561,"user":"31w_","timestamp":"2025-06-26T18:34:31Z","changeset":168153152,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":13049631552,"user":"2PiihR","timestamp":"2025-08-24T19:35:04Z","changeset":170942530,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":13055844101,"user":"votre_solution_de_visibilite_digitale_locale","timestamp":"2025-10-06T06:42:51Z","changeset":172896513,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":13336333864,"user":"Psychologue Quimper Antoine Cl\u00e9net","timestamp":"2025-11-28T16:21:26Z","changeset":175245386,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":13423687561,"user":"CelianGdfrd","timestamp":"2026-01-01T14:13:13Z","changeset":176704865,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":23994710,"user":"foehn","timestamp":"2025-08-01T09:04:28Z","changeset":169806238,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":38496996,"user":"jcnl44","timestamp":"2025-11-04T12:40:01Z","changeset":174191636,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94264372,"user":"baleineaux","timestamp":"2018-08-14T21:23:22Z","changeset":61670507,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94268916,"user":"KlubAnDouarSantel","timestamp":"2022-01-01T13:27:02Z","changeset":115636221,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94269520,"user":"Kl\u00e8sos","timestamp":"2024-08-21T21:03:17Z","changeset":155578594,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94276109,"user":"Yunan973","timestamp":"2024-07-12T13:33:28Z","changeset":153856444,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94278155,"user":"ChRogel","timestamp":"2023-01-30T21:12:02Z","changeset":131896995,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94284983,"user":"KlubAnDouarSantel","timestamp":"2022-01-01T13:58:32Z","changeset":115637199,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94285714,"user":"ChRogel","timestamp":"2015-10-06T17:31:49Z","changeset":34473796,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94286197,"user":"KlubAnDouarSantel","timestamp":"2021-12-31T12:50:05Z","changeset":115607878,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94287358,"user":"Lisapple","timestamp":"2025-08-01T18:32:22Z","changeset":169832898,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94288661,"user":"gendy54","timestamp":"2019-09-20T13:12:21Z","changeset":74718229,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94289332,"user":"KlubAnDouarSantel","timestamp":"2021-12-31T10:43:00Z","changeset":115602985,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94290473,"user":"ChRogel","timestamp":"2023-07-25T15:20:28Z","changeset":138995059,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94299286,"user":"thetornado76","timestamp":"2024-05-26T16:18:02Z","changeset":151859617,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94302484,"user":"ChRogel","timestamp":"2026-01-23T21:28:00Z","changeset":177626966,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94305991,"user":"FrShaft","timestamp":"2017-08-27T14:55:21Z","changeset":51484088,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":94306329,"user":"Luque","timestamp":"2020-11-26T17:59:21Z","changeset":94854620,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":109530799,"user":"codll","timestamp":"2025-02-17T15:56:45Z","changeset":162619588,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":205332543,"user":"Lisapple","timestamp":"2025-07-11T16:04:15Z","changeset":168804260,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":231101482,"user":"Ydel","timestamp":"2022-11-07T22:19:45Z","changeset":128615837,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":336450206,"user":"KlubAnDouarSantel","timestamp":"2022-01-02T12:49:59Z","changeset":115668139,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":355343972,"user":"Syl","timestamp":"2019-11-05T14:04:10Z","changeset":76651438,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":370502147,"user":"zorglubu","timestamp":"2020-04-20T21:23:21Z","changeset":83841157,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":626236762,"user":"ChRogel","timestamp":"2025-12-14T18:34:22Z","changeset":175930139,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":629032315,"user":"chabe01","timestamp":"2022-08-18T20:49:41Z","changeset":125080620,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":702112974,"user":"KlubAnDouarSantel","timestamp":"2022-01-02T12:49:59Z","changeset":115668139,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":703134998,"user":"ChRogel","timestamp":"2019-07-10T15:29:14Z","changeset":72100546,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":746142737,"user":"ChRogel","timestamp":"2025-12-02T17:53:56Z","changeset":175413749,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":801532631,"user":"chabe01","timestamp":"2022-08-18T20:49:48Z","changeset":125080620,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":1121935592,"user":"Ydel","timestamp":"2023-01-10T01:55:49Z","changeset":131087939,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":1124223088,"user":"Bzh-99","timestamp":"2024-04-11T13:04:33Z","changeset":149864116,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":1175191244,"user":"ChRogel","timestamp":"2025-12-04T23:16:38Z","changeset":175524564,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":1175191245,"user":"Bzh-99","timestamp":"2024-04-11T13:02:38Z","changeset":149864051,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":1342707729,"user":"ChRogel","timestamp":"2025-12-17T23:14:08Z","changeset":176070576,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"way","id":1464575177,"user":"Gwen_ch","timestamp":"2026-01-19T15:59:58Z","changeset":177436692,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"relation","id":1376105,"user":"AmiFritz","timestamp":"2020-06-24T19:26:52Z","changeset":87100726,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"relation","id":1392569,"user":"baleineaux","timestamp":"2019-02-09T21:48:30Z","changeset":67059840,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"relation","id":11079516,"user":"PowerGeoMapping","timestamp":"2025-01-26T14:55:30Z","changeset":161783277,"noticed_deleted_date":"2026-02-04 12:25:53"}]" "[]" 206824 ]
|
||||||||||||||||||||||||||||||||
| 56 | 0.51 ms |
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters:
[ "[{"type":"node","id":6943832180,"user":"ChRogel","timestamp":"2024-11-15T17:32:39Z","changeset":159180644,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":7276516632,"user":"AKD","timestamp":"2020-03-08T12:45:41Z","changeset":81922184,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":7276516633,"user":"AKD","timestamp":"2020-03-08T12:45:41Z","changeset":81922184,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":7276516634,"user":"codll","timestamp":"2025-02-28T06:08:20Z","changeset":163037689,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":7276516635,"user":"31w_","timestamp":"2025-11-17T14:17:16Z","changeset":174774150,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":7830117992,"user":"symac","timestamp":"2025-09-17T04:12:00Z","changeset":172042561,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":9291154556,"user":"ChRogel","timestamp":"2021-11-28T18:58:13Z","changeset":114334315,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":11233642564,"user":"codll","timestamp":"2024-10-11T05:45:55Z","changeset":157741427,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12054395751,"user":"symac","timestamp":"2024-08-26T04:00:17Z","changeset":155762113,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12073942828,"user":"symac","timestamp":"2024-08-26T04:00:17Z","changeset":155762113,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12143474876,"user":"symac","timestamp":"2024-08-29T04:49:15Z","changeset":155908995,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12235736352,"user":"codll","timestamp":"2025-02-28T06:24:48Z","changeset":163038016,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":12596064967,"user":"codll","timestamp":"2025-02-17T16:07:33Z","changeset":162620149,"noticed_deleted_date":"2026-02-04 12:25:53"},{"type":"node","id":13088430924,"user":"symac","timestamp":"2025-08-22T03:45:13Z","changeset":170807985,"noticed_deleted_date":"2026-02-04 12:25:53"}]" "[]" 207771 ]
|
||||||||||||||||||||||||||||||||
| 57 | 4.88 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 58 | 0.45 ms |
SELECT t0.id AS id_1, t0.disappeared_list AS disappeared_list_2, t0.current_list AS current_list_3, t0.theme AS theme_4, t0.stats_id AS stats_id_5 FROM zone_places t0 WHERE t0.stats_id = ?
Parameters:
[
9083
]
|
||||||||||||||||||||||||||||||||
| 59 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?
Parameters:
[
9083
]
|
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\ZonePlaces | 27 |
| App\Entity\Stats | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Stats | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\StatsHistory | No errors. |
| App\Entity\CityFollowUp | No errors. |
| App\Entity\ZonePlaces | No errors. |