GET https://osm-labo.cipherbliss.com/admin/stats/77288/followup-graph/advertising_board

Query Metrics

267 Database Queries
9 Different statements
1351.49 ms Query time
0 Invalid entities
404 Managed entities

Queries

Group similar statements

# Time Info
1 0.35 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:
[
  "77288"
]
2 0.33 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:
[
  8109
]
3 142.36 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:
[
  "77288"
]
4 0.23 ms
"START TRANSACTION"
Parameters:
[]
5 0.52 ms
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"advertising_board","tagKey":null,"tagValue":null,"main_tags":["shop=doityourself","amenity=cafe","amenity=cinema","amenity=cafe","amenity=bar","shop=convenience","office=company","amenity=restaurant","amenity=fast_food","shop=hairdresser","amenity=cafe","amenity=bank","shop=hairdresser","shop=hairdresser","shop=shoes","shop=florist","shop=hairdresser","amenity=cafe","amenity=cafe","office=lawyer","shop=bicycle","shop=clothes","amenity=bank","shop=bakery","amenity=bank","amenity=bank","office=estate_agent","shop=optician","amenity=bank","healthcare=pharmacy","shop=alcohol","shop=chocolate","shop=convenience","shop=optician","shop=bakery","office=estate_agent","amenity=personal_service","amenity=personal_service","amenity=fast_food","shop=tattoo","office=government","shop=stationery","amenity=bank","shop=bakery","amenity=bank","shop=bakery","amenity=restaurant","amenity=cafe","shop=supermarket","amenity=bank","healthcare=pharmacy","amenity=bank","amenity=restaurant","shop=bakery","office=newspaper","office=government","shop=beauty","amenity=restaurant","amenity=restaurant","amenity=bank","healthcare=pharmacy","shop=alcohol","amenity=restaurant","amenity=fast_food","office=insurance","shop=clothes","shop=gas","amenity=veterinary","amenity=driving_school","healthcare=pharmacy","shop=optician","shop=convenience","shop=newsagent","amenity=cafe","shop=funeral_directors","amenity=bank","shop=hairdresser","office=insurance","office=employment_agency","shop=mobile_phone","shop=mobile_phone","shop=newsagent","shop=optician","amenity=fast_food","amenity=bar","shop=butcher","amenity=fast_food","office=financial","amenity=fast_food","office=estate_agent","office=estate_agent","amenity=cafe","amenity=fast_food","shop=jewelry","healthcare=laboratory","shop=seafood","amenity=restaurant","amenity=restaurant","amenity=restaurant","amenity=restaurant","amenity=fast_food","amenity=bar","shop=hairdresser","office=employment_agency","amenity=fast_food","amenity=bank","amenity=bank","amenity=cafe","amenity=fast_food","shop=bakery","amenity=fast_food","healthcare=pharmacy","healthcare=pharmacy","office=estate_agent","amenity=restaurant","shop=convenience","amenity=bar","office=employment_agency","amenity=restaurant","healthcare=laboratory","office=estate_agent","office=estate_agent","shop=convenience;gas","amenity=car_wash","shop=hairdresser","shop=hairdresser","shop=motorcycle","shop=weapons","amenity=pub","shop=general","shop=bakery","amenity=pub","shop=coffee","shop=games","shop=ticket","office=vacant","office=financial","amenity=fast_food","shop=yes","amenity=restaurant","shop=butcher","amenity=restaurant","amenity=restaurant","amenity=fast_food","office=employment_agency","amenity=restaurant","shop=cheese","shop=deli","amenity=fast_food","amenity=restaurant","shop=hairdresser","shop=yes","shop=yes","shop=travel_agency","office=insurance","shop=hairdresser","shop=beauty","shop=perfumery","shop=beauty","shop=butcher","shop=yes","shop=chocolate","shop=deli","amenity=restaurant","amenity=restaurant","amenity=restaurant","amenity=restaurant","shop=yes","shop=jewelry","amenity=fast_food","shop=hairdresser","amenity=restaurant","amenity=fast_food","amenity=fast_food","amenity=fast_food","shop=tattoo","amenity=restaurant","amenity=fast_food","shop=bakery","amenity=fast_food","shop=hairdresser","shop=bakery","shop=shoes","shop=yes","shop=beauty","amenity=restaurant","shop=cosmetics","shop=convenience","shop=hairdresser","amenity=fast_food","amenity=pharmacy","shop=computer","shop=medical_supply","office=accountant","office=estate_agent","amenity=restaurant","office=employment_agency","shop=hairdresser","amenity=fast_food","amenity=fast_food","office=insurance","shop=hairdresser","shop=hairdresser","shop=convenience","shop=kitchen","shop=furniture","shop=kitchen","shop=pawnbroker","shop=bed","shop=clothes","shop=furniture","shop=bed","shop=kitchen","shop=furniture","shop=supermarket","shop=variety_store","office=financial","office=financial","amenity=library","office=company","shop=car_repair","shop=butcher","shop=clothes","shop=bakery","shop=supermarket","amenity=restaurant","shop=hairdresser","office=property_management","office=company","office=insurance","office=estate_agent","shop=beauty","office=company","shop=optician","healthcare=pharmacy","healthcare=hospital","amenity=car_rental","amenity=fast_food","amenity=fast_food","amenity=car_rental","amenity=bank","amenity=driving_school","amenity=fast_food","amenity=veterinary","amenity=restaurant","tourism=hotel","amenity=library","amenity=car_rental","office=government","amenity=restaurant","shop=variety_store","shop=furniture","office=government","shop=ticket","shop=newsagent","healthcare=hospital","healthcare=hospital","office=government","amenity=hospital"],"places_count":259,"filtered_count":0,"filtered_main_tags":[]}"
  "2026-02-03 18:25:16"
  null
  null
]
6 0.27 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "387666700"
  1404928
]
7 0.22 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "670083967"
  1404929
]
8 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "670107167"
  1404930
]
9 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1518649338"
  1404931
]
10 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1554858769"
  1404932
]
11 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1563526196"
  1404933
]
12 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1579683801"
  1404934
]
13 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584175215"
  1404936
]
14 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584179973"
  1404937
]
15 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584179980"
  1404938
]
16 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584183370"
  1404939
]
17 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584188484"
  1404943
]
18 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584188485"
  1404944
]
19 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584191296"
  1404945
]
20 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584191299"
  1404946
]
21 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584191300"
  1404947
]
22 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1731592032"
  1404948
]
23 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1817788497"
  1404952
]
24 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1839007959"
  1404953
]
25 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1857556721"
  1404954
]
26 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2108085179"
  1404955
]
27 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2366254749"
  1404959
]
28 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238412"
  1404960
]
29 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238413"
  1404961
]
30 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238414"
  1404962
]
31 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238415"
  1404963
]
32 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238416"
  1404964
]
33 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238417"
  1404965
]
34 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238419"
  1404966
]
35 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238421"
  1404967
]
36 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238422"
  1404968
]
37 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238423"
  1404969
]
38 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238424"
  1404970
]
39 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238428"
  1404971
]
40 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238429"
  1404972
]
41 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238431"
  1404974
]
42 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2874440602"
  1404976
]
43 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2965501133"
  1404977
]
44 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2966629273"
  1404978
]
45 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2966654826"
  1404979
]
46 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2966664259"
  1404981
]
47 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989034182"
  1404982
]
48 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989034255"
  1404983
]
49 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989036212"
  1404985
]
50 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989036213"
  1404986
]
51 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989040070"
  1404987
]
52 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989040071"
  1404988
]
53 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989040072"
  1404989
]
54 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2995406603"
  1404990
]
55 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3017685297"
  1404991
]
56 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3017685298"
  1404992
]
57 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3017685299"
  1404993
]
58 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3017685301"
  1404994
]
59 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3017685302"
  1404995
]
60 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3049591924"
  1404996
]
61 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3252963713"
  1404998
]
62 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3615154336"
  1404999
]
63 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3656855134"
  1405002
]
64 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3686594392"
  1405004
]
65 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3686594395"
  1405006
]
66 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3686594396"
  1405007
]
67 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3687915939"
  1405008
]
68 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3695975936"
  1405009
]
69 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3695981052"
  1405010
]
70 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3696042828"
  1405011
]
71 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3696042830"
  1405012
]
72 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3697289466"
  1405013
]
73 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3697289467"
  1405014
]
74 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3697312188"
  1405015
]
75 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707255"
  1405016
]
76 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707256"
  1405017
]
77 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707257"
  1405018
]
78 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707258"
  1405019
]
79 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707259"
  1405020
]
80 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707260"
  1405021
]
81 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698748990"
  1405023
]
82 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698748991"
  1405024
]
83 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698748992"
  1405025
]
84 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698787768"
  1405026
]
85 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603475"
  1405027
]
86 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603476"
  1405028
]
87 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603478"
  1405029
]
88 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603479"
  1405030
]
89 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603480"
  1405031
]
90 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603481"
  1405032
]
91 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603482"
  1405033
]
92 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3707175715"
  1405034
]
93 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3707175716"
  1405035
]
94 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3708424113"
  1405036
]
95 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3708630538"
  1405037
]
96 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3708630539"
  1405038
]
97 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3904397479"
  1405044
]
98 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4017572027"
  1405050
]
99 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4023432190"
  1405052
]
100 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4045531647"
  1405055
]
101 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4278117175"
  1405057
]
102 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4359854943"
  1405059
]
103 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4369540984"
  1405060
]
104 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4369540986"
  1405061
]
105 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4369540987"
  1405062
]
106 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4404074769"
  1405063
]
107 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4404216259"
  1405064
]
108 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4404220261"
  1405066
]
109 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4618547189"
  1405073
]
110 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4741624603"
  1405074
]
111 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5238518363"
  1405076
]
112 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5268452786"
  1405077
]
113 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5327532430"
  1405078
]
114 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5327892277"
  1405079
]
115 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5327892278"
  1405080
]
116 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5327892279"
  1405081
]
117 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5408185494"
  1405082
]
118 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5408185495"
  1405083
]
119 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5637694021"
  1405084
]
120 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5656024541"
  1405085
]
121 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5816324476"
  1405086
]
122 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6297528286"
  1405087
]
123 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6337932585"
  1405090
]
124 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6632342548"
  1405091
]
125 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7043851735"
  1405102
]
126 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7156592185"
  1405103
]
127 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7156611185"
  1405104
]
128 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7398636477"
  1405106
]
129 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7398644993"
  1405107
]
130 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7515129685"
  1405110
]
131 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243243737"
  1405112
]
132 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243243738"
  1405113
]
133 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243243739"
  1405114
]
134 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8830045604"
  1405118
]
135 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8830045605"
  1405119
]
136 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8830045606"
  1405120
]
137 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8830045608"
  1405121
]
138 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9040882302"
  1405122
]
139 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9040987263"
  1405123
]
140 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9152673378"
  1405124
]
141 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9487115417"
  1405125
]
142 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9819357417"
  1405126
]
143 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950595174"
  1405127
]
144 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950607487"
  1405128
]
145 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950621572"
  1405129
]
146 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950666699"
  1405131
]
147 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950666700"
  1405132
]
148 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950669666"
  1405133
]
149 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950672764"
  1405134
]
150 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950672765"
  1405135
]
151 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950680430"
  1405136
]
152 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950688638"
  1405137
]
153 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950688639"
  1405138
]
154 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9953282164"
  1405139
]
155 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955053670"
  1405140
]
156 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955085354"
  1405141
]
157 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955097803"
  1405142
]
158 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955113991"
  1405143
]
159 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955132504"
  1405144
]
160 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955132505"
  1405145
]
161 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955132506"
  1405146
]
162 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955132507"
  1405147
]
163 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955132508"
  1405148
]
164 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955137270"
  1405149
]
165 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955140010"
  1405150
]
166 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512803"
  1405151
]
167 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512804"
  1405152
]
168 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512805"
  1405153
]
169 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512806"
  1405154
]
170 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512808"
  1405155
]
171 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512809"
  1405156
]
172 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512810"
  1405157
]
173 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512811"
  1405158
]
174 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959513829"
  1405159
]
175 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959513830"
  1405160
]
176 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959513831"
  1405161
]
177 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959525138"
  1405162
]
178 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959525139"
  1405163
]
179 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959525140"
  1405164
]
180 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959527465"
  1405165
]
181 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959532413"
  1405166
]
182 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959533060"
  1405167
]
183 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959533061"
  1405168
]
184 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959546418"
  1405169
]
185 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959546419"
  1405170
]
186 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959558318"
  1405171
]
187 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959562415"
  1405172
]
188 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130888"
  1405173
]
189 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130889"
  1405174
]
190 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130890"
  1405175
]
191 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130891"
  1405176
]
192 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130892"
  1405177
]
193 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130893"
  1405178
]
194 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962150145"
  1405179
]
195 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962156919"
  1405180
]
196 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10537625166"
  1405181
]
197 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10665051947"
  1405185
]
198 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10665051948"
  1405186
]
199 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10665051949"
  1405187
]
200 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10665051950"
  1405188
]
201 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10669716385"
  1405189
]
202 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164651"
  1405190
]
203 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164653"
  1405191
]
204 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164654"
  1405192
]
205 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164657"
  1405193
]
206 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164658"
  1405194
]
207 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164659"
  1405195
]
208 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164660"
  1405196
]
209 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164661"
  1405197
]
210 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830947"
  1405198
]
211 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830948"
  1405199
]
212 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830949"
  1405200
]
213 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830950"
  1405201
]
214 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830951"
  1405202
]
215 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830952"
  1405203
]
216 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830953"
  1405204
]
217 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830954"
  1405205
]
218 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830955"
  1405206
]
219 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830956"
  1405207
]
220 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830957"
  1405208
]
221 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830958"
  1405209
]
222 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10792430206"
  1405210
]
223 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10963325905"
  1405211
]
224 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11127471852"
  1405213
]
225 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12041634570"
  1405216
]
226 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579448091"
  1405221
]
227 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474511"
  1405222
]
228 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474512"
  1405223
]
229 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474513"
  1405224
]
230 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474515"
  1405225
]
231 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474516"
  1405226
]
232 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474518"
  1405227
]
233 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12598524901"
  1405228
]
234 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12871271701"
  1405229
]
235 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12887168320"
  1405230
]
236 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12921149401"
  1405231
]
237 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13083957701"
  1405232
]
238 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13089117801"
  1405233
]
239 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13337975807"
  1405237
]
240 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112354337"
  1405238
]
241 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112355252"
  1405241
]
242 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112355665"
  1405242
]
243 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112356596"
  1405244
]
244 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112358137"
  1405245
]
245 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112358482"
  1405246
]
246 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112359465"
  1405247
]
247 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112359477"
  1405248
]
248 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112360400"
  1405251
]
249 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112360403"
  1405252
]
250 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112362383"
  1405257
]
251 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112362932"
  1405258
]
252 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112363320"
  1405259
]
253 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112363425"
  1405260
]
254 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112363734"
  1405261
]
255 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112363819"
  1405262
]
256 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112364031"
  1405264
]
257 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112364378"
  1405266
]
258 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "144929608"
  1405268
]
259 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "417024302"
  1405269
]
260 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "417024306"
  1405270
]
261 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "624240717"
  1405271
]
262 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "624240718"
  1405272
]
263 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "866068087"
  1405273
]
264 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1338327376"
  1405274
]
265 1176.14 ms
"COMMIT"
Parameters:
[]
266 3.12 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:
[
  8109
]
267 0.76 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:
[
  8109
  "advertising_board"
]

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 347
App\Entity\CityFollowUp 54
App\Entity\Stats 1
App\Entity\ActionLog 1
App\Entity\ZonePlaces 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.