GET https://osm-labo.cipherbliss.com/admin/stats/02138

Response
200 OK
IP
216.73.216.119
Profiled on
Token
f8fffe

Query Metrics

102 Database Queries
13 Different statements
343.32 ms Query time
0 Invalid entities
196 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: 
[
  "02138"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.40 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: 
[
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1.65 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: 
[
  5486
  "fire_hydrant"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.34 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: 
[
  5486
  "charging_station"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 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: 
[
  5486
  "toilets"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 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: 
[
  5486
  "bus_stop"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 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: 
[
  5486
  "defibrillator"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  5486
  "camera"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 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: 
[
  5486
  "recycling"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  5486
  "substation"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 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: 
[
  5486
  "laboratory"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  5486
  "school"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 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: 
[
  5486
  "police"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 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: 
[
  5486
  "healthcare"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  5486
  "bicycle_parking"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  5486
  "advertising_board"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.35 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: 
[
  5486
  "building"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.35 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: 
[
  5486
  "rnb"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.31 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: 
[
  5486
  "email"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 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: 
[
  5486
  "bench"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  5486
  "waste_basket"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 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: 
[
  5486
  "street_lamp"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 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: 
[
  5486
  "drinking_water"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 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: 
[
  5486
  "tree"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 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: 
[
  5486
  "power_pole"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  5486
  "manhole"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  5486
  "little_free_library"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  5486
  "playground"
]
View formatted query    View runnable query    Explain query    View query backtrace
29 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: 
[
  5486
  "restaurant"
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.25 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "fire_hydrant_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.20 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "fire_hydrant_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.19 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "charging_station_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.21 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "charging_station_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.18 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "toilets_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.17 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "toilets_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.17 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "bus_stop_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.15 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "bus_stop_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.14 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "defibrillator_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.14 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "defibrillator_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "camera_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "camera_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.19 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "recycling_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "recycling_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "substation_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "substation_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "laboratory_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.17 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "laboratory_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "school_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "school_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "police_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "police_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "healthcare_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.17 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "healthcare_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "bicycle_parking_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "bicycle_parking_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.14 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "advertising_board_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "advertising_board_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "building_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "building_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "rnb_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.14 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "rnb_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "email_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "email_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "bench_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "bench_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.15 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "waste_basket_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "waste_basket_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "street_lamp_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "street_lamp_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "drinking_water_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.14 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "drinking_water_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
73 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "tree_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "tree_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "places_count"
  1.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
76 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "places_completion"
  67.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
77 0.14 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "power_pole_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
78 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "power_pole_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
79 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "manhole_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "manhole_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
81 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "little_free_library_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
82 0.14 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "little_free_library_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
83 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "playground_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
84 0.16 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "playground_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
85 0.13 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "restaurant_count"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
86 0.17 ms 
INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "restaurant_completion"
  0.0
  "2026-01-30 19:00:07"
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
87 1.56 ms 
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters: 
[
  "[{"type":"way","id":337603537,"user":"nlehuby","timestamp":"2025-05-08T17:19:35Z","changeset":165994924,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603538,"user":"Potion_magix","timestamp":"2015-04-09T14:10:16Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603539,"user":"Potion_magix","timestamp":"2015-04-09T14:10:16Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603540,"user":"Potion_magix","timestamp":"2015-04-09T14:10:17Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603541,"user":"Potion_magix","timestamp":"2015-04-09T14:10:17Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603542,"user":"Potion_magix","timestamp":"2015-04-09T14:10:17Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603543,"user":"Potion_magix","timestamp":"2015-04-09T14:10:17Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603544,"user":"Potion_magix","timestamp":"2015-04-09T14:10:17Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603545,"user":"Potion_magix","timestamp":"2015-04-09T14:10:17Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603546,"user":"Potion_magix","timestamp":"2015-04-09T14:10:17Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603547,"user":"Potion_magix","timestamp":"2015-04-09T14:10:17Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603548,"user":"Potion_magix","timestamp":"2015-04-09T14:10:17Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603549,"user":"Potion_magix","timestamp":"2015-04-09T14:10:17Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603550,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603551,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603552,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603553,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603554,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603555,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603556,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603557,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603558,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603559,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603560,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603561,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603562,"user":"Potion_magix","timestamp":"2015-04-09T14:10:18Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603564,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603565,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603566,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603567,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603568,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603569,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603570,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603571,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603572,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603573,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603574,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603575,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603576,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603577,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603578,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603579,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603580,"user":"Potion_magix","timestamp":"2015-04-09T14:10:19Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603581,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603582,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603583,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603584,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603585,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603586,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603587,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603588,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603589,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603590,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603591,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603592,"user":"Potion_magix","timestamp":"2015-04-09T14:10:20Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603593,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603594,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603595,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603596,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603597,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603598,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603599,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603600,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603601,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603602,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603603,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603604,"user":"Potion_magix","timestamp":"2015-04-09T14:10:21Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603605,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603606,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603607,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603608,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603609,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603610,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603611,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603612,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603613,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603614,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603615,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603616,"user":"Potion_magix","timestamp":"2015-04-09T14:10:22Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603617,"user":"Potion_magix","timestamp":"2015-04-09T14:10:23Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603618,"user":"Potion_magix","timestamp":"2015-04-09T14:10:23Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603619,"user":"Potion_magix","timestamp":"2015-04-09T14:10:23Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603620,"user":"Potion_magix","timestamp":"2015-04-09T14:10:23Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603621,"user":"Potion_magix","timestamp":"2015-04-09T14:10:23Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603622,"user":"Potion_magix","timestamp":"2015-04-09T14:10:23Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603623,"user":"Potion_magix","timestamp":"2015-04-09T14:10:23Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603624,"user":"Potion_magix","timestamp":"2015-04-09T14:10:23Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603625,"user":"Potion_magix","timestamp":"2015-04-09T14:10:23Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603626,"user":"Potion_magix","timestamp":"2015-04-09T14:10:23Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603627,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603628,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603629,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603630,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603631,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603632,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603633,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603634,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603635,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603636,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603637,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603638,"user":"Potion_magix","timestamp":"2015-04-09T14:10:24Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603639,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603640,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603641,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603642,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603643,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603644,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603645,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603646,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603647,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603648,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603649,"user":"Potion_magix","timestamp":"2015-04-09T14:10:25Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603650,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603651,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603652,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603653,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603654,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603655,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603656,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603657,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603658,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603659,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603660,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603661,"user":"Potion_magix","timestamp":"2015-04-09T14:10:26Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603662,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603663,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603664,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603665,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603666,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603667,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603668,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603669,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603670,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603671,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603672,"user":"Potion_magix","timestamp":"2015-04-09T14:10:27Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603673,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603675,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603677,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603679,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603681,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603682,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603683,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603684,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603685,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603686,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603687,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603688,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603689,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603690,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603691,"user":"Potion_magix","timestamp":"2015-04-09T14:10:28Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603692,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603693,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603694,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603695,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603696,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603697,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603698,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603699,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603700,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603701,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603702,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603703,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603704,"user":"Potion_magix","timestamp":"2015-04-09T14:10:29Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603705,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603706,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603707,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603708,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603709,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603710,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603711,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603712,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603713,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603714,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603715,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603716,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603717,"user":"Potion_magix","timestamp":"2015-04-09T14:10:30Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603718,"user":"Potion_magix","timestamp":"2015-04-09T14:10:31Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603719,"user":"Potion_magix","timestamp":"2015-04-09T14:10:31Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603720,"user":"Potion_magix","timestamp":"2015-04-09T14:10:31Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603721,"user":"Olyon","timestamp":"2024-01-11T19:13:46Z","changeset":146155500,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603722,"user":"Potion_magix","timestamp":"2015-04-09T14:10:31Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603723,"user":"Potion_magix","timestamp":"2015-04-09T14:10:31Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603724,"user":"Potion_magix","timestamp":"2015-04-09T14:10:31Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603725,"user":"Potion_magix","timestamp":"2015-04-09T14:10:31Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603726,"user":"Potion_magix","timestamp":"2015-04-09T14:10:31Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603727,"user":"Potion_magix","timestamp":"2015-04-09T14:10:31Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603728,"user":"Potion_magix","timestamp":"2015-04-09T14:10:32Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603729,"user":"Potion_magix","timestamp":"2015-04-09T14:10:32Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603730,"user":"Potion_magix","timestamp":"2015-04-09T14:10:32Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603731,"user":"Potion_magix","timestamp":"2015-04-09T14:10:32Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603732,"user":"Potion_magix","timestamp":"2015-04-09T14:10:32Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"},{"type":"way","id":337603733,"user":"Potion_magix","timestamp":"2015-04-09T14:10:32Z","changeset":30094676,"noticed_deleted_date":"2026-01-30 19:00:07"}]"
  "[]"
  124080
]
View formatted query    View runnable query    Explain query    View query backtrace
88 0.21 ms 
UPDATE zone_places SET disappeared_list = ?, current_list = ? WHERE id = ?
Parameters: 
[
  "[{"type":"way","id":337603537,"user":"nlehuby","timestamp":"2025-05-08T17:19:35Z","changeset":165994924,"noticed_deleted_date":"2026-01-30 19:00:07"}]"
  "[]"
  124082
]
View formatted query    View runnable query    Explain query    View query backtrace
89 4.82 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
90 0.31 ms 
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.stats_id = ?
Parameters: 
[
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
91 0.28 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: 
[
  "02138"
]
View formatted query    View runnable query    Explain query    View query backtrace
92 0.20 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
93 0.29 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "337603537"
  1064235
]
View formatted query    View runnable query    Explain query    View query backtrace
94 0.14 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
95 0.15 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
96 0.25 ms 
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "stats_de_ville"
  "{"insee_code":"02138","nom":"02138"}"
  "2026-01-30 19:00:11"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
97 314.69 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
98 0.39 ms 
SELECT s0_.id AS id_0, s0_.places_count AS places_count_1, s0_.emails_count AS emails_count_2, s0_.completion_percent AS completion_percent_3, s0_.emails_sent AS emails_sent_4, s0_.date AS date_5, s0_.names_count AS names_count_6, s0_.opening_hours_count AS opening_hours_count_7, s0_.website_count AS website_count_8, s0_.address_count AS address_count_9, s0_.siret_count AS siret_count_10, s0_.stats_id AS stats_id_11 FROM stats_history s0_ WHERE s0_.stats_id = ? ORDER BY s0_.id DESC LIMIT 100
Parameters: 
[
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
99 0.30 ms 
SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.stats_id = ?
Parameters: 
[
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
100 0.36 ms 
SELECT p0_.osm_user AS osm_user_0, COUNT(p0_.id) AS sclr_1, AVG((CASE WHEN p0_.has_opening_hours = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_address = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_website = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_wheelchair = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_note = 1 THEN 1 ELSE 0 END)) / 5 * 100 AS sclr_2 FROM place p0_ WHERE p0_.osm_user IS NOT NULL AND p0_.osm_user <> '' AND p0_.stats_id = ? GROUP BY p0_.osm_user ORDER BY sclr_1 DESC LIMIT 100
Parameters: 
[
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
101 0.45 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: 
[
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace
102 0.47 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: 
[
  5486
]
View formatted query    View runnable query    Explain query    View query backtrace

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 166
App\Entity\ZonePlaces 27
App\Entity\Place 1
App\Entity\Stats 1
App\Entity\ActionLog 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.
App\Entity\History No errors.
App\Entity\ActionLog No errors.