GET https://osm-commerces.cipherbliss.com/admin/stats/76259/followup-graph/fire_hydrant

Response
200 OK
IP
216.73.216.169
Profiled on
Token
70ac7b

Query Metrics

181 Database Queries
8 Different statements
134.42 ms Query time
0 Invalid entities
377 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.45 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: 
[
  "76259"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.52 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: 
[
  943
]
View formatted query    View runnable query    Explain query    View query backtrace
3 98.59 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.zip_code = ?
Parameters: 
[
  "76259"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.16 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.40 ms 
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"fire_hydrant","tagKey":null,"tagValue":null,"main_tags":["shop=car_repair","shop=deli","shop=variety_store","shop=gas","tourism=museum","amenity=studio","amenity=bank","amenity=cafe","shop=deli","amenity=restaurant","shop=seafood","office=insurance","amenity=restaurant","shop=boat","shop=tobacco","shop=beauty","shop=hairdresser","office=estate_agent","office=accountant","office=insurance","shop=tobacco","amenity=restaurant","amenity=restaurant","amenity=restaurant","amenity=restaurant","amenity=restaurant","amenity=restaurant","office=yes","amenity=restaurant","amenity=restaurant","tourism=hotel","amenity=restaurant","amenity=pub","shop=interior_decoration","shop=art","office=insurance","shop=art","amenity=bank","amenity=bank","tourism=guest_house","shop=shoes","shop=car_repair","amenity=restaurant","shop=clothes","amenity=bank","office=insurance","healthcare=pharmacy","shop=florist","shop=clothes","office=estate_agent","amenity=restaurant","shop=convenience","amenity=car_wash","shop=newsagent","shop=bakery","office=government","shop=bicycle","amenity=ice_cream","amenity=ice_cream","amenity=fast_food","shop=laundry","office=estate_agent","healthcare=hospital","healthcare=clinic","healthcare=dialysis","healthcare=pharmacy","healthcare=laboratory","healthcare=laboratory","healthcare=pharmacy","healthcare=pharmacy","amenity=fast_food","shop=farm","office=government","office=government","office=government","office=government","shop=bakery","shop=supermarket","shop=beauty","shop=greengrocer","amenity=fast_food","amenity=veterinary","amenity=bar","office=company","shop=beauty","shop=clothes","office=insurance","shop=clothes","shop=hairdresser","shop=shoes","shop=clothes","shop=gift","shop=clothes","shop=mobile_phone","shop=cosmetics","shop=clothes","amenity=fast_food","amenity=cafe","amenity=fast_food","shop=beauty","office=telecommunication","shop=butcher","shop=beauty","shop=hairdresser","shop=butcher","amenity=restaurant","shop=bakery","shop=newsagent","amenity=bank","shop=bakery","shop=convenience","shop=optician","shop=travel_agency","shop=mobile_phone","shop=e-cigarette","shop=computer","tourism=apartment","shop=hairdresser","amenity=restaurant","shop=clothes","amenity=fast_food","shop=greengrocer","shop=newsagent","amenity=driving_school","office=yes","shop=gas","shop=laundry","tourism=guest_house","shop=cheese","shop=convenience","shop=coffee","tourism=guest_house","shop=hairdresser","office=architect","shop=clothes","shop=hifi","tourism=hotel","shop=beauty","office=association","tourism=guest_house","shop=car_repair","office=employment_agency","shop=cannabis","amenity=fuel","shop=alcohol","amenity=bar","amenity=fast_food","shop=wine","shop=laundry","office=government","shop=furniture","shop=optician","shop=greengrocer","shop=bakery","shop=fishing","shop=florist","shop=supermarket","shop=supermarket","tourism=guest_house","tourism=hotel","amenity=fuel","healthcare=pharmacy","tourism=guest_house","shop=car_repair","tourism=hotel","amenity=car_rental","shop=outpost","healthcare=hospice","tourism=information","amenity=vehicle_inspection","office=government","amenity=theatre","tourism=museum","amenity=library"],"places_count":174,"filtered_count":0,"filtered_main_tags":[]}"
  "2025-09-19 15:15:57"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.28 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "493876526"
  560126
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "493975939"
  560128
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "494006130"
  560131
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.22 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "494006135"
  560132
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "494008268"
  560133
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "1492213639"
  560134
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2151677394"
  560136
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2546693304"
  560137
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2546693306"
  560138
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2760756405"
  560139
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2761147410"
  560140
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.29 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830392302"
  560141
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830393801"
  560142
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830395101"
  560143
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830405401"
  560150
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830414701"
  560152
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830415201"
  560153
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830415701"
  560154
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.24 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830420101"
  560155
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830422201"
  560156
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830424301"
  560158
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830430301"
  560161
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830432501"
  560163
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830436801"
  560166
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830440801"
  560168
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830452601"
  560169
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830457401"
  560170
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830466405"
  560172
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830484701"
  560174
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830486001"
  560175
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830497101"
  560176
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830513401"
  560177
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2830515401"
  560178
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2833193602"
  560180
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2833206401"
  560184
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2833216601"
  560187
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2903903702"
  560188
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2913281076"
  560189
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2913281077"
  560190
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2913281085"
  560191
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2913281092"
  560192
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2913281096"
  560193
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2913282409"
  560195
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2913282429"
  560197
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2913282440"
  560198
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2913286112"
  560199
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2992053448"
  560200
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2992069533"
  560202
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2992070533"
  560203
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3735600533"
  560204
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "4415600533"
  560206
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5001418355"
  560207
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5001418356"
  560208
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5224745180"
  560212
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5224745187"
  560213
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5248485486"
  560215
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6699610383"
  560217
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6958048894"
  560218
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6958048895"
  560219
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6958048896"
  560220
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7058396099"
  560221
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7153721485"
  560222
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7515896356"
  560223
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.22 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7515896357"
  560224
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7515896358"
  560225
]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7515896375"
  560226
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7515896380"
  560227
]
View formatted query    View runnable query    Explain query    View query backtrace
73 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7515896383"
  560228
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.22 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7515939485"
  560229
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.22 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7515939491"
  560230
]
View formatted query    View runnable query    Explain query    View query backtrace
76 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7770593172"
  560231
]
View formatted query    View runnable query    Explain query    View query backtrace
77 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7942159513"
  560232
]
View formatted query    View runnable query    Explain query    View query backtrace
78 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8555273158"
  560237
]
View formatted query    View runnable query    Explain query    View query backtrace
79 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8555273164"
  560238
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8555273193"
  560239
]
View formatted query    View runnable query    Explain query    View query backtrace
81 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8555273196"
  560240
]
View formatted query    View runnable query    Explain query    View query backtrace
82 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9015381217"
  560241
]
View formatted query    View runnable query    Explain query    View query backtrace
83 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9015381317"
  560242
]
View formatted query    View runnable query    Explain query    View query backtrace
84 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016239718"
  560243
]
View formatted query    View runnable query    Explain query    View query backtrace
85 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016240318"
  560244
]
View formatted query    View runnable query    Explain query    View query backtrace
86 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016246817"
  560245
]
View formatted query    View runnable query    Explain query    View query backtrace
87 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016246818"
  560246
]
View formatted query    View runnable query    Explain query    View query backtrace
88 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016246917"
  560247
]
View formatted query    View runnable query    Explain query    View query backtrace
89 0.91 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016264217"
  560248
]
View formatted query    View runnable query    Explain query    View query backtrace
90 0.30 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016277618"
  560249
]
View formatted query    View runnable query    Explain query    View query backtrace
91 0.26 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016278217"
  560250
]
View formatted query    View runnable query    Explain query    View query backtrace
92 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016278218"
  560251
]
View formatted query    View runnable query    Explain query    View query backtrace
93 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016281217"
  560252
]
View formatted query    View runnable query    Explain query    View query backtrace
94 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016287217"
  560253
]
View formatted query    View runnable query    Explain query    View query backtrace
95 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016290017"
  560254
]
View formatted query    View runnable query    Explain query    View query backtrace
96 0.22 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016299018"
  560255
]
View formatted query    View runnable query    Explain query    View query backtrace
97 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016305317"
  560256
]
View formatted query    View runnable query    Explain query    View query backtrace
98 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016308217"
  560257
]
View formatted query    View runnable query    Explain query    View query backtrace
99 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016308218"
  560258
]
View formatted query    View runnable query    Explain query    View query backtrace
100 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016308317"
  560259
]
View formatted query    View runnable query    Explain query    View query backtrace
101 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016312317"
  560260
]
View formatted query    View runnable query    Explain query    View query backtrace
102 0.23 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016375017"
  560261
]
View formatted query    View runnable query    Explain query    View query backtrace
103 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016375019"
  560262
]
View formatted query    View runnable query    Explain query    View query backtrace
104 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016378219"
  560263
]
View formatted query    View runnable query    Explain query    View query backtrace
105 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016388417"
  560264
]
View formatted query    View runnable query    Explain query    View query backtrace
106 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016388420"
  560265
]
View formatted query    View runnable query    Explain query    View query backtrace
107 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016388421"
  560266
]
View formatted query    View runnable query    Explain query    View query backtrace
108 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016419717"
  560267
]
View formatted query    View runnable query    Explain query    View query backtrace
109 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016423017"
  560269
]
View formatted query    View runnable query    Explain query    View query backtrace
110 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016423020"
  560270
]
View formatted query    View runnable query    Explain query    View query backtrace
111 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016423025"
  560271
]
View formatted query    View runnable query    Explain query    View query backtrace
112 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016423326"
  560272
]
View formatted query    View runnable query    Explain query    View query backtrace
113 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016426024"
  560274
]
View formatted query    View runnable query    Explain query    View query backtrace
114 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016427333"
  560275
]
View formatted query    View runnable query    Explain query    View query backtrace
115 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016496320"
  560277
]
View formatted query    View runnable query    Explain query    View query backtrace
116 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016496321"
  560278
]
View formatted query    View runnable query    Explain query    View query backtrace
117 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016496518"
  560279
]
View formatted query    View runnable query    Explain query    View query backtrace
118 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016615739"
  560280
]
View formatted query    View runnable query    Explain query    View query backtrace
119 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016615934"
  560281
]
View formatted query    View runnable query    Explain query    View query backtrace
120 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016654944"
  560282
]
View formatted query    View runnable query    Explain query    View query backtrace
121 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016655326"
  560283
]
View formatted query    View runnable query    Explain query    View query backtrace
122 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016655417"
  560284
]
View formatted query    View runnable query    Explain query    View query backtrace
123 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016655936"
  560285
]
View formatted query    View runnable query    Explain query    View query backtrace
124 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016659684"
  560286
]
View formatted query    View runnable query    Explain query    View query backtrace
125 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016674153"
  560287
]
View formatted query    View runnable query    Explain query    View query backtrace
126 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016674192"
  560288
]
View formatted query    View runnable query    Explain query    View query backtrace
127 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016674235"
  560289
]
View formatted query    View runnable query    Explain query    View query backtrace
128 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016686932"
  560290
]
View formatted query    View runnable query    Explain query    View query backtrace
129 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9016686956"
  560291
]
View formatted query    View runnable query    Explain query    View query backtrace
130 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9238950685"
  560292
]
View formatted query    View runnable query    Explain query    View query backtrace
131 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9739971802"
  560293
]
View formatted query    View runnable query    Explain query    View query backtrace
132 0.23 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9983518990"
  560294
]
View formatted query    View runnable query    Explain query    View query backtrace
133 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10250833161"
  560297
]
View formatted query    View runnable query    Explain query    View query backtrace
134 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10250833163"
  560298
]
View formatted query    View runnable query    Explain query    View query backtrace
135 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10250833165"
  560299
]
View formatted query    View runnable query    Explain query    View query backtrace
136 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10250833166"
  560300
]
View formatted query    View runnable query    Explain query    View query backtrace
137 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10250833177"
  560301
]
View formatted query    View runnable query    Explain query    View query backtrace
138 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10601496205"
  560303
]
View formatted query    View runnable query    Explain query    View query backtrace
139 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10652329828"
  560304
]
View formatted query    View runnable query    Explain query    View query backtrace
140 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10652329830"
  560305
]
View formatted query    View runnable query    Explain query    View query backtrace
141 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10652329831"
  560306
]
View formatted query    View runnable query    Explain query    View query backtrace
142 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10652329838"
  560307
]
View formatted query    View runnable query    Explain query    View query backtrace
143 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10889209409"
  560308
]
View formatted query    View runnable query    Explain query    View query backtrace
144 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10903073994"
  560309
]
View formatted query    View runnable query    Explain query    View query backtrace
145 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11013744206"
  560310
]
View formatted query    View runnable query    Explain query    View query backtrace
146 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11069098105"
  560311
]
View formatted query    View runnable query    Explain query    View query backtrace
147 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11099102009"
  560312
]
View formatted query    View runnable query    Explain query    View query backtrace
148 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11159964381"
  560314
]
View formatted query    View runnable query    Explain query    View query backtrace
149 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11780559021"
  560317
]
View formatted query    View runnable query    Explain query    View query backtrace
150 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "12441827260"
  560319
]
View formatted query    View runnable query    Explain query    View query backtrace
151 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "12441827261"
  560320
]
View formatted query    View runnable query    Explain query    View query backtrace
152 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "12791651459"
  560323
]
View formatted query    View runnable query    Explain query    View query backtrace
153 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "13002487301"
  560330
]
View formatted query    View runnable query    Explain query    View query backtrace
154 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "13063982401"
  560334
]
View formatted query    View runnable query    Explain query    View query backtrace
155 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "13070459002"
  560340
]
View formatted query    View runnable query    Explain query    View query backtrace
156 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "13140414462"
  560341
]
View formatted query    View runnable query    Explain query    View query backtrace
157 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "13140414463"
  560342
]
View formatted query    View runnable query    Explain query    View query backtrace
158 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "13140414464"
  560343
]
View formatted query    View runnable query    Explain query    View query backtrace
159 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "13140414465"
  560344
]
View formatted query    View runnable query    Explain query    View query backtrace
160 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135937712"
  560346
]
View formatted query    View runnable query    Explain query    View query backtrace
161 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135937820"
  560347
]
View formatted query    View runnable query    Explain query    View query backtrace
162 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135938097"
  560349
]
View formatted query    View runnable query    Explain query    View query backtrace
163 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135938254"
  560350
]
View formatted query    View runnable query    Explain query    View query backtrace
164 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135940695"
  560352
]
View formatted query    View runnable query    Explain query    View query backtrace
165 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135940753"
  560353
]
View formatted query    View runnable query    Explain query    View query backtrace
166 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135942313"
  560355
]
View formatted query    View runnable query    Explain query    View query backtrace
167 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135943977"
  560357
]
View formatted query    View runnable query    Explain query    View query backtrace
168 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135944835"
  560359
]
View formatted query    View runnable query    Explain query    View query backtrace
169 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135945358"
  560360
]
View formatted query    View runnable query    Explain query    View query backtrace
170 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135948039"
  560367
]
View formatted query    View runnable query    Explain query    View query backtrace
171 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135948322"
  560369
]
View formatted query    View runnable query    Explain query    View query backtrace
172 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135948420"
  560370
]
View formatted query    View runnable query    Explain query    View query backtrace
173 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135948657"
  560373
]
View formatted query    View runnable query    Explain query    View query backtrace
174 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135949153"
  560375
]
View formatted query    View runnable query    Explain query    View query backtrace
175 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135949709"
  560378
]
View formatted query    View runnable query    Explain query    View query backtrace
176 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135949720"
  560379
]
View formatted query    View runnable query    Explain query    View query backtrace
177 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135950049"
  560380
]
View formatted query    View runnable query    Explain query    View query backtrace
178 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "135950056"
  560381
]
View formatted query    View runnable query    Explain query    View query backtrace
179 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "1204051566"
  560386
]
View formatted query    View runnable query    Explain query    View query backtrace
180 1.69 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
181 1.47 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: 
[
  943
]
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\Place 263
App\Entity\CityFollowUp 112
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\History No errors.
App\Entity\ActionLog No errors.