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

Query Metrics

34 Database Queries
7 Different statements
33.58 ms Query time
0 Invalid entities
139 Managed entities

Queries

Group similar statements

# Time Info
1 0.32 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:
[
  "02125"
]
2 0.46 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:
[
  5567
  "fire_hydrant"
]
3 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:
[
  5567
  "charging_station"
]
4 0.26 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:
[
  5567
  "toilets"
]
5 0.33 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:
[
  5567
  "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:
[
  5567
  "defibrillator"
]
7 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:
[
  5567
  "camera"
]
8 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:
[
  5567
  "recycling"
]
9 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:
[
  5567
  "substation"
]
10 0.26 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:
[
  5567
  "laboratory"
]
11 0.26 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:
[
  5567
  "school"
]
12 0.26 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:
[
  5567
  "police"
]
13 0.26 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:
[
  5567
  "healthcare"
]
14 0.26 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:
[
  5567
  "bicycle_parking"
]
15 0.26 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:
[
  5567
  "advertising_board"
]
16 0.26 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:
[
  5567
  "building"
]
17 0.26 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:
[
  5567
  "rnb"
]
18 0.25 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:
[
  5567
  "email"
]
19 0.24 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:
[
  5567
  "bench"
]
20 0.24 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:
[
  5567
  "waste_basket"
]
21 0.24 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:
[
  5567
  "street_lamp"
]
22 0.25 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:
[
  5567
  "drinking_water"
]
23 0.25 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:
[
  5567
  "tree"
]
24 0.25 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:
[
  5567
  "power_pole"
]
25 0.25 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:
[
  5567
  "manhole"
]
26 0.26 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:
[
  5567
  "little_free_library"
]
27 0.26 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:
[
  5567
  "playground"
]
28 0.25 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:
[
  5567
  "restaurant"
]
29 0.14 ms
"START TRANSACTION"
Parameters:
[]
30 1.40 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[{"type":"way","id":495233276,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:49Z","changeset":48892158},{"type":"way","id":495233277,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:49Z","changeset":48892158},{"type":"way","id":495233278,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233279,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233280,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233281,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233282,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233284,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233285,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233286,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233287,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233288,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233289,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233290,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233291,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233292,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:50Z","changeset":48892158},{"type":"way","id":495233293,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233294,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233295,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233296,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233297,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233298,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233299,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233300,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233301,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233302,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233303,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233304,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233305,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233306,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233307,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:51Z","changeset":48892158},{"type":"way","id":495233308,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233309,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233310,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233311,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233312,"user":"Aroche","timestamp":"2019-01-19T14:54:37Z","changeset":66455521},{"type":"way","id":495233313,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233314,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233315,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233316,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233317,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233318,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233319,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233320,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233321,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:52Z","changeset":48892158},{"type":"way","id":495233323,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233324,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233325,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233326,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233327,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233328,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233329,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233330,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233331,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233332,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233333,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233334,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:44:03Z","changeset":48892263},{"type":"way","id":495233335,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:53Z","changeset":48892158},{"type":"way","id":495233336,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233337,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233338,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233339,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233340,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233341,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233342,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233343,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233344,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233345,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233346,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233347,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233348,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233349,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233350,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233351,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:54Z","changeset":48892158},{"type":"way","id":495233352,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233353,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233354,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233355,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233356,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233357,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233358,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233359,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233360,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233361,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233362,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233363,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233364,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233365,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233366,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:55Z","changeset":48892158},{"type":"way","id":495233367,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233368,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233369,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233371,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233373,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233375,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233377,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233379,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233381,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233383,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233384,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233386,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233388,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233390,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233392,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:56Z","changeset":48892158},{"type":"way","id":495233394,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233397,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233399,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233402,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233403,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233405,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233407,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233409,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233410,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233412,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233414,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233416,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233417,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233419,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233421,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:57Z","changeset":48892158},{"type":"way","id":495233423,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233426,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233428,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233430,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233433,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233435,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233438,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233439,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233440,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233441,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233442,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233443,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233444,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233445,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:58Z","changeset":48892158},{"type":"way","id":495233446,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233447,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233448,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233449,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233450,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233451,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233452,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233453,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233454,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233455,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233456,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233457,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233458,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233459,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:39:59Z","changeset":48892158},{"type":"way","id":495233460,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233461,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233462,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233463,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233464,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233465,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233466,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233467,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233468,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233469,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233470,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233471,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233472,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233473,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:00Z","changeset":48892158},{"type":"way","id":495233474,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233475,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233476,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233477,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233478,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233479,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233480,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233481,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233482,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233483,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233484,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233485,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233486,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233487,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233488,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:01Z","changeset":48892158},{"type":"way","id":495233489,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233490,"user":"nlehuby","timestamp":"2025-05-08T17:21:11Z","changeset":165994979},{"type":"way","id":495233491,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233492,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233493,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233494,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233495,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233496,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233497,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233498,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233499,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233500,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233501,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233502,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233503,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:02Z","changeset":48892158},{"type":"way","id":495233504,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233505,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233506,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233507,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233508,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233509,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233510,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233511,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233512,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233513,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233514,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233515,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233516,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:03Z","changeset":48892158},{"type":"way","id":495233517,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233518,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233519,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233520,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233521,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233522,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233523,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233524,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233525,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233526,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233527,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233528,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233529,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233530,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233531,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:04Z","changeset":48892158},{"type":"way","id":495233532,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233533,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233534,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233535,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233536,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233537,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233538,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233539,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233540,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233541,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233542,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233543,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233544,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233545,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233546,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:05Z","changeset":48892158},{"type":"way","id":495233547,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233548,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233549,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233550,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233551,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233552,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233553,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233554,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233555,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:44:03Z","changeset":48892263},{"type":"way","id":495233556,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233557,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233558,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158},{"type":"way","id":495233559,"user":"Kalaallit Nunaat","timestamp":"2017-05-22T15:40:06Z","changeset":48892158}]"
  126109
]
31 0.23 ms
UPDATE zone_places SET current_list = ? WHERE id = ?
Parameters:
[
  "[{"type":"way","id":495233490,"user":"nlehuby","timestamp":"2025-05-08T17:21:11Z","changeset":165994979}]"
  126111
]
32 23.27 ms
"COMMIT"
Parameters:
[]
33 0.54 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:
[
  5567
]
34 0.42 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:
[
  5567
]

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\CityFollowUp 111
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.