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

Query Metrics

259 Database Queries
8 Different statements
207.03 ms Query time
0 Invalid entities
447 Managed entities

Queries

Group similar statements

# Time Info
1 0.40 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 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters:
[
  "77284"
]
2 0.69 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:
[
  2583
]
3 152.41 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:
[
  "77284"
]
4 0.23 ms
"START TRANSACTION"
Parameters:
[]
5 1.54 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=outpost","tourism=hotel","shop=supermarket","amenity=bank","amenity=car_wash","healthcare=pharmacy","amenity=restaurant","amenity=restaurant","amenity=fuel","shop=e-cigarette","amenity=personal_service","shop=bicycle","office=company","office=estate_agent","office=company","amenity=restaurant","healthcare=pharmacy","healthcare=pharmacy","healthcare=pharmacy","healthcare=pharmacy","healthcare=pharmacy","healthcare=pharmacy","healthcare=pharmacy","shop=convenience","healthcare=pharmacy","amenity=fuel","healthcare=pharmacy","healthcare=pharmacy","shop=mall","shop=antiques","office=financial","office=insurance","office=estate_agent","shop=florist","office=insurance","shop=laundry","amenity=bar","office=political_party","amenity=fast_food","amenity=restaurant","amenity=fast_food","shop=bakery","healthcare=pharmacy","healthcare=pharmacy","healthcare=pharmacy","amenity=pharmacy","shop=pastry","amenity=restaurant","amenity=car_wash","office=estate_agent","amenity=restaurant","amenity=cafe","shop=hairdresser","amenity=restaurant","shop=beauty","amenity=restaurant","amenity=fast_food","shop=cheese","shop=bakery","amenity=library","amenity=bar","shop=massage","amenity=fast_food","office=estate_agent","shop=butcher","shop=bakery","amenity=bar","shop=convenience","amenity=car_wash","shop=cheese","shop=butcher","shop=supermarket","shop=hairdresser","shop=convenience","amenity=restaurant","shop=florist","amenity=fast_food","shop=clothes","amenity=cafe","shop=clothes","shop=shoes","healthcare=doctor","shop=clothes","shop=clothes","shop=optician","shop=hairdresser","shop=hearing_aids","healthcare=laboratory","healthcare=laboratory","amenity=restaurant","amenity=restaurant","shop=beauty","shop=deli","shop=clothes","shop=hairdresser","amenity=townhall","amenity=restaurant","shop=cheese","office=construction_company","amenity=driving_school","office=estate_agent","office=estate_agent","amenity=restaurant","amenity=cafe","shop=bakery","shop=travel_agency","amenity=bank","shop=jewelry","shop=hearing_aids","shop=optician","shop=jewelry","shop=beauty","amenity=restaurant","amenity=restaurant","amenity=restaurant","amenity=restaurant","healthcare=doctor","office=government","shop=hairdresser","shop=optician","shop=chocolate","shop=clothes","shop=hearing_aids","shop=mobile_phone","shop=clothes","shop=bakery","shop=florist","amenity=fast_food","shop=optician","shop=bakery","office=insurance","shop=hairdresser","shop=bakery","shop=motorcycle_repair","shop=hairdresser","amenity=fast_food","shop=funeral_directors","shop=supermarket","shop=ticket","amenity=restaurant","shop=ticket","shop=ticket","amenity=coworking_space","shop=hairdresser","office=government","office=employment_agency","amenity=fast_food","office=insurance","office=employment_agency","office=employment_agency","shop=tobacco","shop=car_repair","shop=car","amenity=restaurant","shop=car_repair","amenity=fast_food","shop=car","office=financial","amenity=car_rental","amenity=restaurant","shop=pet","shop=car","amenity=kindergarten","office=employment_agency","shop=car","office=estate_agent","amenity=restaurant","amenity=restaurant","shop=alcohol","shop=supermarket","shop=window_blind","amenity=cafe","amenity=restaurant","office=company","shop=car_repair","shop=hairdresser","office=insurance","healthcare=hospital","shop=car","shop=mall","amenity=fuel","shop=car_repair","shop=car","tourism=hotel","amenity=car_wash","shop=tool_hire","shop=hifi","shop=car","shop=car","office=estate_agent","shop=car","tourism=hotel","shop=car_repair","amenity=funeral_hall","office=accountant","amenity=fuel","amenity=restaurant","shop=gas","shop=supermarket","shop=travel_agency","shop=medical_supply","shop=tiles","amenity=fast_food","amenity=restaurant","shop=car_parts","shop=bathroom_furnishing","shop=car","shop=car_repair","amenity=restaurant","shop=car_repair","amenity=vehicle_inspection","amenity=car_rental","shop=car_repair","tourism=hotel","shop=supermarket","amenity=bank","shop=perfumery","amenity=car_wash","office=insurance","amenity=restaurant","shop=car_repair","amenity=cafe","shop=convenience","shop=doityourself","amenity=fast_food","office=government","office=educational_institution","amenity=car_wash","shop=supermarket","amenity=theatre","tourism=information","healthcare=clinic","amenity=car_wash","shop=electrical","amenity=veterinary","amenity=theatre","healthcare=hospital","healthcare=rehabilitation","shop=bakery","amenity=fast_food","shop=supermarket","amenity=car_rental","amenity=restaurant","shop=variety_store","shop=clothes","shop=convenience","shop=supermarket","shop=clothes","amenity=vehicle_inspection","shop=car_repair","shop=car_repair","shop=car_repair"],"places_count":252,"filtered_count":0,"filtered_main_tags":[]}"
  "2025-07-29 00:26:28"
  null
  null
]
6 0.35 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1745357619"
  3189638
]
7 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1745357703"
  3189639
]
8 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1763582348"
  3189640
]
9 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1770022732"
  3189644
]
10 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2161894451"
  3189645
]
11 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2302769957"
  3189646
]
12 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2304001806"
  3189647
]
13 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2304001811"
  3189648
]
14 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2306261963"
  3189649
]
15 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2486682708"
  3189650
]
16 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2715116861"
  3189651
]
17 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3296992462"
  3189653
]
18 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3302077261"
  3189654
]
19 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3497077693"
  3189658
]
20 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3612799393"
  3189662
]
21 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3791754490"
  3189665
]
22 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3842874870"
  3189666
]
23 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3842874871"
  3189667
]
24 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3842874872"
  3189668
]
25 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3842874873"
  3189669
]
26 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3842874874"
  3189670
]
27 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3842874875"
  3189671
]
28 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3842874876"
  3189672
]
29 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3842874897"
  3189673
]
30 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3842981887"
  3189674
]
31 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3842982353"
  3189675
]
32 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3843014638"
  3189676
]
33 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3843014639"
  3189677
]
34 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3843014644"
  3189678
]
35 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035774531"
  3189679
]
36 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035774532"
  3189680
]
37 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035774533"
  3189681
]
38 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035774534"
  3189682
]
39 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035774537"
  3189683
]
40 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035774539"
  3189684
]
41 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035774540"
  3189685
]
42 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035774541"
  3189686
]
43 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035774542"
  3189687
]
44 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035774545"
  3189688
]
45 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4035783900"
  3189689
]
46 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4248744381"
  3189690
]
47 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4394629178"
  3189691
]
48 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4525282034"
  3189692
]
49 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4525282035"
  3189693
]
50 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4525282036"
  3189694
]
51 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4525282037"
  3189695
]
52 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4862648953"
  3189697
]
53 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4862648954"
  3189698
]
54 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5003246093"
  3189699
]
55 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5437048628"
  3189700
]
56 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5871562337"
  3189701
]
57 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5871562338"
  3189702
]
58 0.93 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5967793668"
  3189703
]
59 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5967793811"
  3189704
]
60 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5967795625"
  3189705
]
61 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5967800417"
  3189706
]
62 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5967800418"
  3189707
]
63 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5967801388"
  3189708
]
64 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5967802727"
  3189709
]
65 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5981509813"
  3189711
]
66 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5981611920"
  3189712
]
67 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6087160545"
  3189713
]
68 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6285626417"
  3189715
]
69 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6306190785"
  3189716
]
70 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6307292985"
  3189717
]
71 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6585253296"
  3189718
]
72 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6699472588"
  3189719
]
73 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6699472591"
  3189720
]
74 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6834409783"
  3189721
]
75 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7346813174"
  3189722
]
76 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7346813175"
  3189723
]
77 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7346813176"
  3189724
]
78 0.41 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7499180787"
  3189725
]
79 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886555085"
  3189727
]
80 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886555185"
  3189728
]
81 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886590385"
  3189729
]
82 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886590386"
  3189730
]
83 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886596486"
  3189731
]
84 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886596487"
  3189732
]
85 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886620285"
  3189733
]
86 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886620286"
  3189734
]
87 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886620287"
  3189735
]
88 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886620385"
  3189736
]
89 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886620386"
  3189737
]
90 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886620485"
  3189738
]
91 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7886620585"
  3189739
]
92 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8405352317"
  3189744
]
93 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8707201122"
  3189745
]
94 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8707201123"
  3189746
]
95 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9044116970"
  3189749
]
96 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9044116971"
  3189750
]
97 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9044116973"
  3189751
]
98 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9044116974"
  3189752
]
99 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9044116975"
  3189753
]
100 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9044116980"
  3189755
]
101 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9309443749"
  3189756
]
102 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9503071818"
  3189757
]
103 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9505298426"
  3189758
]
104 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9582972817"
  3189759
]
105 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708934117"
  3189760
]
106 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708937717"
  3189761
]
107 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708937817"
  3189762
]
108 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708940017"
  3189763
]
109 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708948517"
  3189764
]
110 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708948518"
  3189765
]
111 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708948617"
  3189766
]
112 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708948717"
  3189767
]
113 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708952517"
  3189768
]
114 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708952617"
  3189769
]
115 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708952717"
  3189770
]
116 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708957717"
  3189771
]
117 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708957817"
  3189772
]
118 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9708961317"
  3189773
]
119 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709046317"
  3189774
]
120 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709046517"
  3189775
]
121 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709090917"
  3189776
]
122 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709207285"
  3189777
]
123 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709286778"
  3189778
]
124 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709317403"
  3189779
]
125 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709317404"
  3189780
]
126 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709317405"
  3189781
]
127 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709317406"
  3189782
]
128 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709317407"
  3189783
]
129 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709317408"
  3189784
]
130 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709317409"
  3189785
]
131 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9709317410"
  3189786
]
132 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9725740691"
  3189787
]
133 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9725875646"
  3189788
]
134 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9739707964"
  3189789
]
135 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9739707965"
  3189790
]
136 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9739707969"
  3189791
]
137 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9739707980"
  3189792
]
138 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9739707981"
  3189793
]
139 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9753534444"
  3189794
]
140 0.41 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9756590392"
  3189795
]
141 0.42 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9758635377"
  3189796
]
142 0.27 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9795094440"
  3189797
]
143 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9795313596"
  3189799
]
144 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9893364283"
  3189800
]
145 0.25 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9988523175"
  3189801
]
146 0.24 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10059021193"
  3189802
]
147 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10059021194"
  3189803
]
148 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10069991564"
  3189804
]
149 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10601647805"
  3189805
]
150 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10707390591"
  3189807
]
151 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741060500"
  3189808
]
152 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741060501"
  3189809
]
153 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741060502"
  3189810
]
154 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741060503"
  3189811
]
155 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741060504"
  3189812
]
156 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741103344"
  3189813
]
157 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741103345"
  3189814
]
158 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741103346"
  3189815
]
159 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741103381"
  3189816
]
160 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741136105"
  3189817
]
161 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741136106"
  3189818
]
162 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10741136107"
  3189819
]
163 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10792434305"
  3189820
]
164 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10801901065"
  3189821
]
165 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10801901066"
  3189822
]
166 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10801901067"
  3189823
]
167 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10841693005"
  3189824
]
168 0.29 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10905223423"
  3189825
]
169 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10923592605"
  3189826
]
170 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10996681405"
  3189828
]
171 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11189994837"
  3189829
]
172 0.29 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11536308329"
  3189831
]
173 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11775535169"
  3189833
]
174 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11872036758"
  3189834
]
175 0.25 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12045939462"
  3189835
]
176 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12074855495"
  3189838
]
177 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12142392247"
  3189839
]
178 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12142392248"
  3189840
]
179 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12541184301"
  3189841
]
180 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12754060101"
  3189842
]
181 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12786910196"
  3189843
]
182 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12814616901"
  3189844
]
183 0.24 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "110759735"
  3189845
]
184 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112053032"
  3189846
]
185 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112053151"
  3189847
]
186 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112053275"
  3189848
]
187 0.24 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112053765"
  3189849
]
188 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112053861"
  3189850
]
189 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112054307"
  3189851
]
190 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112054456"
  3189852
]
191 0.24 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112055186"
  3189854
]
192 0.29 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112055255"
  3189855
]
193 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112055401"
  3189856
]
194 0.25 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112055972"
  3189857
]
195 0.24 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112055984"
  3189858
]
196 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112056138"
  3189859
]
197 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112056575"
  3189860
]
198 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112056625"
  3189861
]
199 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112057565"
  3189862
]
200 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112057636"
  3189863
]
201 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112058490"
  3189864
]
202 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112058493"
  3189865
]
203 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112058611"
  3189866
]
204 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112058905"
  3189867
]
205 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112059330"
  3189869
]
206 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112059765"
  3189870
]
207 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112060165"
  3189871
]
208 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112060865"
  3189872
]
209 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112060914"
  3189873
]
210 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112062519"
  3189875
]
211 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112063266"
  3189876
]
212 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112063505"
  3189877
]
213 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112063630"
  3189878
]
214 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112064387"
  3189879
]
215 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112064808"
  3189880
]
216 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112065014"
  3189881
]
217 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112065352"
  3189882
]
218 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112066050"
  3189883
]
219 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112066131"
  3189884
]
220 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112066771"
  3189885
]
221 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112067040"
  3189886
]
222 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112067688"
  3189887
]
223 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112068686"
  3189888
]
224 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112069117"
  3189889
]
225 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112069701"
  3189890
]
226 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112069735"
  3189891
]
227 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "417328443"
  3189894
]
228 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "417328451"
  3189895
]
229 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "688110176"
  3189896
]
230 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "688110179"
  3189897
]
231 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "736666824"
  3189898
]
232 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "806200177"
  3189899
]
233 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "806200184"
  3189900
]
234 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "806200582"
  3189901
]
235 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "806554306"
  3189902
]
236 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "833773720"
  3189903
]
237 0.24 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1058126207"
  3189904
]
238 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1106523802"
  3189905
]
239 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1106523807"
  3189906
]
240 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1251112709"
  3189907
]
241 0.28 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1259746189"
  3189908
]
242 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1314644678"
  3189909
]
243 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1314644681"
  3189910
]
244 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1327865257"
  3189911
]
245 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1327865258"
  3189912
]
246 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1327865259"
  3189913
]
247 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1327865260"
  3189914
]
248 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1327865261"
  3189915
]
249 0.23 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1327870603"
  3189916
]
250 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1327870604"
  3189917
]
251 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1327870605"
  3189918
]
252 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1327870606"
  3189919
]
253 0.24 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1327870607"
  3189920
]
254 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1329577048"
  3189921
]
255 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1329577049"
  3189922
]
256 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1329577050"
  3189923
]
257 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1338596187"
  3189924
]
258 2.60 ms
"COMMIT"
Parameters:
[]
259 2.32 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:
[
  2583
]

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 289
App\Entity\CityFollowUp 156
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.