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

Query Metrics

267 Database Queries
9 Different statements
2637.25 ms Query time
0 Invalid entities
572 Managed entities

Queries

Group similar statements

# Time Info
1 0.34 ms
SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.osm_data_date_min AS osm_data_date_min_19, t0.osm_data_date_avg AS osm_data_date_avg_20, t0.osm_data_date_max AS osm_data_date_max_21, t0.budget_annuel AS budget_annuel_22, t0.lat AS lat_23, t0.lon AS lon_24, t0.date_labourage_requested AS date_labourage_requested_25, t0.date_labourage_done AS date_labourage_done_26, t0.kind AS kind_27 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters:
[
  "77288"
]
2 0.55 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:
[
  6718
]
3 233.76 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.21 ms
"START TRANSACTION"
Parameters:
[]
5 277.50 ms
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"places","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-02 20:17:39"
  null
  null
]
6 0.39 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "387666700"
  1173579
]
7 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "670083967"
  1173580
]
8 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "670107167"
  1173581
]
9 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1518649338"
  1173582
]
10 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1554858769"
  1173583
]
11 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1563526196"
  1173584
]
12 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1579683801"
  1173585
]
13 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584175215"
  1173587
]
14 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584179973"
  1173588
]
15 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584179980"
  1173589
]
16 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584183370"
  1173590
]
17 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584188484"
  1173594
]
18 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584188485"
  1173595
]
19 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584191296"
  1173596
]
20 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584191299"
  1173597
]
21 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1584191300"
  1173598
]
22 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1731592032"
  1173599
]
23 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1817788497"
  1173603
]
24 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1839007959"
  1173604
]
25 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1857556721"
  1173605
]
26 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2108085179"
  1173606
]
27 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2366254749"
  1173610
]
28 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238412"
  1173611
]
29 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238413"
  1173612
]
30 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238414"
  1173613
]
31 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238415"
  1173614
]
32 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238416"
  1173615
]
33 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238417"
  1173616
]
34 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238419"
  1173617
]
35 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238421"
  1173618
]
36 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238422"
  1173619
]
37 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238423"
  1173620
]
38 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238424"
  1173621
]
39 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238428"
  1173622
]
40 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238429"
  1173623
]
41 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2717238431"
  1173625
]
42 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2874440602"
  1173627
]
43 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2965501133"
  1173628
]
44 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2966629273"
  1173629
]
45 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2966654826"
  1173630
]
46 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2966664259"
  1173632
]
47 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989034182"
  1173633
]
48 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989034255"
  1173634
]
49 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989036212"
  1173636
]
50 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989036213"
  1173637
]
51 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989040070"
  1173638
]
52 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989040071"
  1173639
]
53 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2989040072"
  1173640
]
54 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2995406603"
  1173641
]
55 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3017685297"
  1173642
]
56 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3017685298"
  1173643
]
57 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3017685299"
  1173644
]
58 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3017685301"
  1173645
]
59 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3017685302"
  1173646
]
60 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3049591924"
  1173647
]
61 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3252963713"
  1173649
]
62 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3615154336"
  1173650
]
63 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3656855134"
  1173653
]
64 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3686594392"
  1173655
]
65 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3686594395"
  1173657
]
66 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3686594396"
  1173658
]
67 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3687915939"
  1173659
]
68 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3695975936"
  1173660
]
69 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3695981052"
  1173661
]
70 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3696042828"
  1173662
]
71 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3696042830"
  1173663
]
72 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3697289466"
  1173664
]
73 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3697289467"
  1173665
]
74 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3697312188"
  1173666
]
75 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707255"
  1173667
]
76 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707256"
  1173668
]
77 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707257"
  1173669
]
78 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707258"
  1173670
]
79 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707259"
  1173671
]
80 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698707260"
  1173672
]
81 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698748990"
  1173674
]
82 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698748991"
  1173675
]
83 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698748992"
  1173676
]
84 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3698787768"
  1173677
]
85 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603475"
  1173678
]
86 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603476"
  1173679
]
87 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603478"
  1173680
]
88 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603479"
  1173681
]
89 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603480"
  1173682
]
90 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603481"
  1173683
]
91 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3703603482"
  1173684
]
92 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3707175715"
  1173685
]
93 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3707175716"
  1173686
]
94 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3708424113"
  1173687
]
95 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3708630538"
  1173688
]
96 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3708630539"
  1173689
]
97 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3904397479"
  1173695
]
98 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4017572027"
  1173701
]
99 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4023432190"
  1173703
]
100 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4045531647"
  1173706
]
101 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4278117175"
  1173708
]
102 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4359854943"
  1173710
]
103 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4369540984"
  1173711
]
104 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4369540986"
  1173712
]
105 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4369540987"
  1173713
]
106 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4404074769"
  1173714
]
107 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4404216259"
  1173715
]
108 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4404220261"
  1173717
]
109 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4618547189"
  1173724
]
110 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4741624603"
  1173725
]
111 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5238518363"
  1173727
]
112 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5268452786"
  1173728
]
113 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5327532430"
  1173729
]
114 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5327892277"
  1173730
]
115 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5327892278"
  1173731
]
116 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5327892279"
  1173732
]
117 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5408185494"
  1173733
]
118 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5408185495"
  1173734
]
119 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5637694021"
  1173735
]
120 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5656024541"
  1173736
]
121 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5816324476"
  1173737
]
122 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6297528286"
  1173738
]
123 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6337932585"
  1173741
]
124 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6632342548"
  1173742
]
125 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7043851735"
  1173753
]
126 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7156592185"
  1173754
]
127 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7156611185"
  1173755
]
128 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7398636477"
  1173757
]
129 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7398644993"
  1173758
]
130 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7515129685"
  1173761
]
131 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243243737"
  1173763
]
132 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243243738"
  1173764
]
133 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243243739"
  1173765
]
134 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8830045604"
  1173769
]
135 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8830045605"
  1173770
]
136 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8830045606"
  1173771
]
137 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8830045608"
  1173772
]
138 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9040882302"
  1173773
]
139 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9040987263"
  1173774
]
140 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9152673378"
  1173775
]
141 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9487115417"
  1173776
]
142 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9819357417"
  1173777
]
143 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950595174"
  1173778
]
144 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950607487"
  1173779
]
145 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950621572"
  1173780
]
146 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950666699"
  1173782
]
147 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950666700"
  1173783
]
148 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950669666"
  1173784
]
149 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950672764"
  1173785
]
150 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950672765"
  1173786
]
151 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950680430"
  1173787
]
152 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950688638"
  1173788
]
153 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9950688639"
  1173789
]
154 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9953282164"
  1173790
]
155 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955053670"
  1173791
]
156 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955085354"
  1173792
]
157 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955097803"
  1173793
]
158 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955113991"
  1173794
]
159 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955132504"
  1173795
]
160 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955132505"
  1173796
]
161 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955132506"
  1173797
]
162 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955132507"
  1173798
]
163 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955132508"
  1173799
]
164 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955137270"
  1173800
]
165 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9955140010"
  1173801
]
166 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512803"
  1173802
]
167 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512804"
  1173803
]
168 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512805"
  1173804
]
169 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512806"
  1173805
]
170 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512808"
  1173806
]
171 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512809"
  1173807
]
172 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512810"
  1173808
]
173 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959512811"
  1173809
]
174 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959513829"
  1173810
]
175 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959513830"
  1173811
]
176 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959513831"
  1173812
]
177 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959525138"
  1173813
]
178 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959525139"
  1173814
]
179 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959525140"
  1173815
]
180 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959527465"
  1173816
]
181 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959532413"
  1173817
]
182 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959533060"
  1173818
]
183 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959533061"
  1173819
]
184 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959546418"
  1173820
]
185 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959546419"
  1173821
]
186 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959558318"
  1173822
]
187 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9959562415"
  1173823
]
188 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130888"
  1173824
]
189 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130889"
  1173825
]
190 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130890"
  1173826
]
191 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130891"
  1173827
]
192 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130892"
  1173828
]
193 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962130893"
  1173829
]
194 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962150145"
  1173830
]
195 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9962156919"
  1173831
]
196 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10537625166"
  1173832
]
197 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10665051947"
  1173836
]
198 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10665051948"
  1173837
]
199 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10665051949"
  1173838
]
200 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10665051950"
  1173839
]
201 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10669716385"
  1173840
]
202 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164651"
  1173841
]
203 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164653"
  1173842
]
204 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164654"
  1173843
]
205 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164657"
  1173844
]
206 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164658"
  1173845
]
207 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164659"
  1173846
]
208 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164660"
  1173847
]
209 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10671164661"
  1173848
]
210 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830947"
  1173849
]
211 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830948"
  1173850
]
212 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830949"
  1173851
]
213 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830950"
  1173852
]
214 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830951"
  1173853
]
215 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830952"
  1173854
]
216 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830953"
  1173855
]
217 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830954"
  1173856
]
218 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830955"
  1173857
]
219 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830956"
  1173858
]
220 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830957"
  1173859
]
221 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10691830958"
  1173860
]
222 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10792430206"
  1173861
]
223 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10963325905"
  1173862
]
224 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11127471852"
  1173864
]
225 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12041634570"
  1173867
]
226 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579448091"
  1173872
]
227 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474511"
  1173873
]
228 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474512"
  1173874
]
229 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474513"
  1173875
]
230 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474515"
  1173876
]
231 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474516"
  1173877
]
232 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12579474518"
  1173878
]
233 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12598524901"
  1173879
]
234 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12871271701"
  1173880
]
235 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12887168320"
  1173881
]
236 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12921149401"
  1173882
]
237 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13083957701"
  1173883
]
238 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13089117801"
  1173884
]
239 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13337975807"
  1173888
]
240 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112354337"
  1173889
]
241 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112355252"
  1173892
]
242 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112355665"
  1173893
]
243 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112356596"
  1173895
]
244 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112358137"
  1173896
]
245 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112358482"
  1173897
]
246 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112359465"
  1173898
]
247 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112359477"
  1173899
]
248 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112360400"
  1173902
]
249 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112360403"
  1173903
]
250 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112362383"
  1173908
]
251 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112362932"
  1173909
]
252 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112363320"
  1173910
]
253 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112363425"
  1173911
]
254 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112363734"
  1173912
]
255 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112363819"
  1173913
]
256 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112364031"
  1173915
]
257 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "112364378"
  1173917
]
258 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "144929608"
  1173919
]
259 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "417024302"
  1173920
]
260 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "417024306"
  1173921
]
261 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "624240717"
  1173922
]
262 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "624240718"
  1173923
]
263 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "866068087"
  1173924
]
264 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1338327376"
  1173925
]
265 2092.14 ms
"COMMIT"
Parameters:
[]
266 1.88 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:
[
  6718
]
267 0.62 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:
[
  6718
  "places"
]

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 223
App\Entity\Stats 1
App\Entity\ActionLog 1

Entities Mapping

Class Mapping errors
App\Entity\Stats No errors.
App\Entity\Place No errors.
App\Entity\StatsHistory No errors.
App\Entity\CityFollowUp No errors.
App\Entity\ZonePlaces No errors.
App\Entity\History No errors.
App\Entity\ActionLog No errors.