GET https://osm-labo.cipherbliss.com/city/02012/zone-places-history

Query Metrics

35 Database Queries
7 Different statements
26.43 ms Query time
0 Invalid entities
28 Managed entities

Queries

Group similar statements

# Time Info
1 0.34 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:
[
  "02012"
]
2 8.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:
[
  8751
  "fire_hydrant"
]
3 0.45 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:
[
  8751
  "charging_station"
]
4 0.32 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:
[
  8751
  "toilets"
]
5 0.29 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:
[
  8751
  "bus_stop"
]
6 0.29 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:
[
  8751
  "defibrillator"
]
7 0.29 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:
[
  8751
  "camera"
]
8 0.29 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:
[
  8751
  "recycling"
]
9 0.28 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:
[
  8751
  "substation"
]
10 0.29 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:
[
  8751
  "laboratory"
]
11 0.29 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:
[
  8751
  "school"
]
12 0.29 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:
[
  8751
  "police"
]
13 0.27 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:
[
  8751
  "healthcare"
]
14 0.27 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:
[
  8751
  "bicycle_parking"
]
15 0.27 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:
[
  8751
  "advertising_board"
]
16 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:
[
  8751
  "building"
]
17 0.29 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:
[
  8751
  "rnb"
]
18 0.30 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:
[
  8751
  "email"
]
19 0.29 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:
[
  8751
  "bench"
]
20 0.29 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:
[
  8751
  "waste_basket"
]
21 0.27 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:
[
  8751
  "street_lamp"
]
22 0.29 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:
[
  8751
  "drinking_water"
]
23 0.30 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:
[
  8751
  "tree"
]
24 0.32 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:
[
  8751
  "power_pole"
]
25 0.29 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:
[
  8751
  "manhole"
]
26 0.27 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:
[
  8751
  "little_free_library"
]
27 0.28 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:
[
  8751
  "playground"
]
28 0.28 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:
[
  8751
  "restaurant"
]
29 0.11 ms
"START TRANSACTION"
Parameters:
[]
30 0.28 ms
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters:
[
  "[{"type":"node","id":5736327576,"user":"vincent_95","timestamp":"2018-07-03T11:24:23Z","changeset":60375651,"noticed_deleted_date":"2026-02-04 10:00:08"}]"
  "[]"
  208279
]
31 2.02 ms
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters:
[
  "[{"type":"way","id":550689234,"user":"Pichasso","timestamp":"2018-01-03T18:00:37Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689597,"user":"Pichasso","timestamp":"2018-01-03T18:03:03Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689598,"user":"Pichasso","timestamp":"2018-01-03T18:03:03Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689599,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689600,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689601,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689602,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689603,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689604,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689605,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689606,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689607,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689608,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689609,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689610,"user":"Pichasso","timestamp":"2018-01-03T18:03:04Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550689611,"user":"Pichasso","timestamp":"2018-01-03T18:03:05Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690405,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690409,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690410,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690412,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690414,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690416,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690418,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690420,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690422,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690424,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690426,"user":"Pichasso","timestamp":"2018-01-03T18:05:38Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690428,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690430,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690432,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690434,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690436,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690438,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690440,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690442,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690444,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690446,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690448,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690450,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690452,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550690454,"user":"Pichasso","timestamp":"2018-01-03T18:05:39Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691125,"user":"Pichasso","timestamp":"2018-01-03T18:08:27Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691126,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691127,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691128,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691129,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691130,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691131,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691132,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691133,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691134,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691135,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691136,"user":"Pichasso","timestamp":"2018-01-03T18:08:28Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691137,"user":"nlehuby","timestamp":"2025-05-08T17:19:35Z","changeset":165994924,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691138,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691139,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691140,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691141,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691142,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691143,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691144,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691145,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691146,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691147,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691148,"user":"Pichasso","timestamp":"2018-01-03T18:08:29Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550691149,"user":"Pichasso","timestamp":"2018-01-03T18:08:30Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692416,"user":"Pichasso","timestamp":"2018-01-03T18:11:45Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692417,"user":"Pichasso","timestamp":"2018-01-03T18:11:45Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692418,"user":"Pichasso","timestamp":"2018-01-03T18:11:45Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692419,"user":"Pichasso","timestamp":"2018-01-03T18:11:45Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692420,"user":"Pichasso","timestamp":"2018-01-03T18:11:45Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692421,"user":"Pichasso","timestamp":"2018-01-03T18:11:45Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692422,"user":"Pichasso","timestamp":"2018-01-03T18:11:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692423,"user":"Pichasso","timestamp":"2018-01-03T18:11:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692424,"user":"Pichasso","timestamp":"2018-01-03T18:11:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692425,"user":"Pichasso","timestamp":"2018-01-03T18:11:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550692426,"user":"Pichasso","timestamp":"2018-01-03T18:11:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693347,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693348,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693349,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693350,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693352,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693353,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693354,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693355,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693356,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693358,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693359,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693360,"user":"Pichasso","timestamp":"2018-01-03T18:19:46Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693361,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693362,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693363,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693364,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693365,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693366,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693367,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693368,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693369,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693370,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693371,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693372,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693373,"user":"Pichasso","timestamp":"2018-01-03T18:19:47Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693374,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693375,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693376,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693377,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693378,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693380,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693381,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693382,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693383,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693384,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693385,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693386,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693387,"user":"Pichasso","timestamp":"2018-01-03T18:19:48Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693388,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693389,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693390,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693391,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693393,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693394,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693395,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693396,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693397,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693398,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693399,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693400,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693401,"user":"Pichasso","timestamp":"2018-01-03T18:19:49Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693402,"user":"Pichasso","timestamp":"2018-01-03T18:19:50Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693403,"user":"Pichasso","timestamp":"2018-01-03T18:19:50Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693405,"user":"Pichasso","timestamp":"2018-01-03T18:19:50Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693406,"user":"Pichasso","timestamp":"2018-01-03T18:19:50Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693407,"user":"Pichasso","timestamp":"2018-01-03T18:19:50Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"},{"type":"way","id":550693408,"user":"Pichasso","timestamp":"2018-01-03T18:19:50Z","changeset":55135606,"noticed_deleted_date":"2026-02-04 10:00:08"}]"
  "[]"
  208293
]
32 0.26 ms
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters:
[
  "[{"type":"way","id":550691137,"user":"nlehuby","timestamp":"2025-05-08T17:19:35Z","changeset":165994924,"noticed_deleted_date":"2026-02-04 10:00:08"}]"
  "[]"
  208295
]
33 6.54 ms
"COMMIT"
Parameters:
[]
34 0.46 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:
[
  8751
]
35 0.23 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:
[
  8751
]

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.