Query Metrics
35
Database Queries
7
Different statements
26.43 ms
Query time
0
Invalid entities
28
Managed entities
Queries
| #▲ | 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. |