GET https://osm-labo.cipherbliss.com/admin/stats/94016/followup-graph/restaurant

Query Metrics

276 Database Queries
9 Different statements
300.50 ms Query time
0 Invalid entities
1076 Managed entities

Queries

Group similar statements

# Time Info
1 0.31 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:
[
  "94016"
]
2 1.22 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:
[
  4635
]
3 263.90 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:
[
  "94016"
]
4 0.23 ms
"START TRANSACTION"
Parameters:
[]
5 0.57 ms
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"restaurant","tagKey":null,"tagValue":null,"main_tags":["amenity=cafe","shop=butcher","healthcare=pharmacy","shop=doityourself","shop=florist","amenity=restaurant","amenity=fast_food","shop=dry_cleaning;convenience;cosmetics","shop=paint","healthcare=pharmacy","shop=bakery","shop=travel_agency","amenity=restaurant","shop=shoes","office=estate_agent","shop=greengrocer","shop=hairdresser","shop=butcher","shop=hairdresser","shop=optician","shop=bakery","amenity=fast_food","shop=laundry","amenity=restaurant","amenity=fast_food","amenity=fast_food","shop=hearing_aids","office=estate_agent","amenity=fast_food","healthcare=laboratory","amenity=fast_food","shop=beauty","shop=convenience","healthcare=podiatrist","amenity=bank","amenity=bank","amenity=fast_food","amenity=bank","amenity=library","amenity=fast_food","healthcare=pharmacy","amenity=bank","amenity=restaurant","shop=bakery","shop=bakery","healthcare=pharmacy","office=association","amenity=fast_food","amenity=library","amenity=library","healthcare=pharmacy","amenity=fuel","amenity=bar","shop=supermarket","amenity=restaurant","shop=optician","office=government","amenity=restaurant","shop=laundry","shop=bakery","amenity=restaurant","shop=beauty","shop=florist","office=estate_agent","shop=optician","healthcare=pharmacy","amenity=restaurant","shop=frozen_food","shop=jewelry","amenity=kindergarten","office=association","shop=photo","office=estate_agent","office=financial_advisor","amenity=bar","shop=butcher","office=company","shop=ticket","amenity=restaurant","amenity=restaurant","amenity=fast_food","shop=trade","shop=convenience","office=employment_agency","shop=beauty","shop=butcher","amenity=restaurant","healthcare=laboratory","shop=motorcycle","shop=beauty","shop=hairdresser","amenity=fast_food","office=accountant","shop=newsagent","amenity=restaurant","shop=bakery","shop=convenience","amenity=driving_school","shop=copyshop","shop=cheese","shop=butcher","amenity=fast_food","shop=supermarket","office=government","office=estate_agent","amenity=veterinary","shop=hearing_aids","amenity=restaurant","office=government","healthcare=laboratory","amenity=restaurant","shop=car_repair","office=estate_agent","shop=laundry","shop=beauty","office=government","office=company","office=government","shop=wine","healthcare=doctor","shop=convenience","healthcare=dentist","office=association","shop=car_repair","office=notary","office=estate_agent","office=estate_agent","amenity=fast_food","healthcare=rehabilitation","healthcare=speech_therapist","healthcare=physiotherapist","healthcare=podiatrist","office=insurance","shop=car_repair","shop=car_repair","amenity=restaurant","shop=supermarket","office=estate_agent","office=company","office=company","office=company","healthcare=dentist","healthcare=doctor","healthcare=speech_therapist","healthcare=physiotherapist","healthcare=physiotherapist","healthcare=counselling","healthcare=alternative","healthcare=centre","healthcare=doctor","healthcare=podiatrist","office=advertising_agency","office=it","office=construction","amenity=restaurant","healthcare=doctor","healthcare=doctor","healthcare=doctor","shop=gas","healthcare=podiatrist","office=association","healthcare=dentist","healthcare=doctor","shop=gift","healthcare=dentist","shop=butcher","shop=butcher","shop=supermarket","office=association","shop=ticket","healthcare=doctor","healthcare=doctor","amenity=vehicle_inspection","healthcare=podiatrist","shop=car_repair","amenity=restaurant","healthcare=optometrist","office=government","office=government","shop=car_repair","office=company","office=it","amenity=veterinary","amenity=bank","shop=hairdresser","shop=laundry","amenity=fast_food","amenity=fast_food","office=company","office=company","office=research","healthcare=doctor","healthcare=doctor","shop=convenience","office=government","office=government","office=government","office=government","shop=greengrocer","amenity=kindergarten","shop=butcher","amenity=restaurant","healthcare=psychotherapist","office=association","shop=massage","shop=appliance","healthcare=alternative","healthcare=dentist","office=accountant","shop=massage","amenity=kindergarten","amenity=fast_food","shop=optician","healthcare=yes","healthcare=physiotherapist","office=lawyer","shop=car_repair","shop=convenience","office=company","healthcare=dentist","healthcare=dentist","healthcare=alternative","healthcare=psychotherapist","office=company","healthcare=doctor","healthcare=doctor","healthcare=physiotherapist","healthcare=doctor","healthcare=nurse","healthcare=nurse","healthcare=nurse","healthcare=nurse","healthcare=midwife","healthcare=midwife","healthcare=psychotherapist","healthcare=speech_therapist","healthcare=doctor","healthcare=doctor","healthcare=doctor","healthcare=doctor","healthcare=doctor","healthcare=doctor","healthcare=gastroenterological_surgery","healthcare=doctor","office=estate_agent","office=company","healthcare=dentist","healthcare=dentist","healthcare=podiatrist","healthcare=alternative","healthcare=alternative;physiotherapist","healthcare=doctor","amenity=fast_food","amenity=kindergarten","shop=motorcycle","shop=car_repair","amenity=restaurant","healthcare=centre","amenity=bank","shop=vacuum_cleaner","tourism=hotel","amenity=library","shop=supermarket","healthcare=psychotherapist","amenity=kindergarten","amenity=kindergarten","amenity=fast_food","shop=newsagent"],"places_count":268,"filtered_count":0,"filtered_main_tags":[]}"
  "2026-02-01 09:27:55"
  null
  null
]
6 0.25 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "276079530"
  1032689
]
7 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "276079536"
  1032690
]
8 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "473496748"
  1032693
]
9 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1490284318"
  1032696
]
10 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635124541"
  1032697
]
11 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635124546"
  1032698
]
12 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635124549"
  1032699
]
13 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635124550"
  1032700
]
14 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635124551"
  1032701
]
15 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635124554"
  1032703
]
16 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635124578"
  1032704
]
17 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635851247"
  1032706
]
18 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635851254"
  1032707
]
19 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635851256"
  1032708
]
20 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1635851259"
  1032709
]
21 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1639890458"
  1032711
]
22 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1639890475"
  1032712
]
23 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1639890480"
  1032713
]
24 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1640861464"
  1032714
]
25 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1640861480"
  1032716
]
26 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1640861482"
  1032717
]
27 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1685216875"
  1032719
]
28 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1685216885"
  1032720
]
29 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1685218992"
  1032721
]
30 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1685218993"
  1032722
]
31 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1685218994"
  1032723
]
32 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1685661416"
  1032726
]
33 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1685661422"
  1032728
]
34 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1685663908"
  1032729
]
35 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1687443551"
  1032731
]
36 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1687443555"
  1032732
]
37 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1687529874"
  1032733
]
38 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1712789261"
  1032737
]
39 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1712856748"
  1032738
]
40 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1849546520"
  1032739
]
41 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1849546521"
  1032740
]
42 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1849546523"
  1032742
]
43 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1849546524"
  1032743
]
44 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1856005553"
  1032744
]
45 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1864161605"
  1032745
]
46 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1866513227"
  1032746
]
47 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1866516811"
  1032747
]
48 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2431510909"
  1032749
]
49 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2431510910"
  1032750
]
50 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3328624555"
  1032751
]
51 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3557645969"
  1032755
]
52 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3557645971"
  1032756
]
53 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3627312640"
  1032757
]
54 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4193385089"
  1032760
]
55 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4193385092"
  1032761
]
56 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4224510035"
  1032762
]
57 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4228728447"
  1032763
]
58 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4420916695"
  1032764
]
59 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4450511977"
  1032765
]
60 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4533853303"
  1032766
]
61 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4558143979"
  1032767
]
62 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4692140095"
  1032768
]
63 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4693480258"
  1032770
]
64 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4919843986"
  1032771
]
65 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5027035634"
  1032772
]
66 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5066370415"
  1032773
]
67 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5153685366"
  1032775
]
68 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5153685384"
  1032776
]
69 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5153685399"
  1032777
]
70 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5153685400"
  1032778
]
71 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5153685405"
  1032779
]
72 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5153802738"
  1032780
]
73 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5153802739"
  1032781
]
74 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5158005469"
  1032782
]
75 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5166141419"
  1032783
]
76 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5166253473"
  1032784
]
77 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5166550041"
  1032785
]
78 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5166550042"
  1032786
]
79 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5166580045"
  1032787
]
80 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5291652853"
  1032789
]
81 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5301054795"
  1032790
]
82 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5433833790"
  1032792
]
83 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5518900527"
  1032794
]
84 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5571662682"
  1032796
]
85 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5571662683"
  1032797
]
86 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5703273770"
  1032799
]
87 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5744540866"
  1032800
]
88 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5744630822"
  1032801
]
89 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5747720591"
  1032802
]
90 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5929500351"
  1032805
]
91 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5981745085"
  1032806
]
92 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5981745089"
  1032808
]
93 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5999806809"
  1032811
]
94 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6061199872"
  1032812
]
95 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6230929392"
  1032813
]
96 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6230932906"
  1032814
]
97 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6230944322"
  1032815
]
98 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6264813226"
  1032816
]
99 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6264813227"
  1032817
]
100 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6264813228"
  1032818
]
101 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6264813300"
  1032819
]
102 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6264813395"
  1032820
]
103 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6264813396"
  1032821
]
104 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6264813397"
  1032822
]
105 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6358980735"
  1032823
]
106 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6384355969"
  1032824
]
107 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6384356235"
  1032825
]
108 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6384356236"
  1032826
]
109 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6465849676"
  1032827
]
110 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6499488113"
  1032829
]
111 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6499491688"
  1032830
]
112 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6499806019"
  1032831
]
113 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6511845299"
  1032832
]
114 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6565289751"
  1032833
]
115 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6685476822"
  1032834
]
116 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6736006116"
  1032839
]
117 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6736011853"
  1032841
]
118 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6736073734"
  1032842
]
119 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6746011730"
  1032843
]
120 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6761319168"
  1032844
]
121 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6796025918"
  1032845
]
122 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6796054835"
  1032846
]
123 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6796055598"
  1032847
]
124 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6993814246"
  1032848
]
125 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7198815099"
  1032849
]
126 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7209629634"
  1032850
]
127 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7288187671"
  1032851
]
128 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7422088216"
  1032853
]
129 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7545787560"
  1032854
]
130 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7545873734"
  1032856
]
131 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7785697782"
  1032857
]
132 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7788481709"
  1032858
]
133 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8041219574"
  1032859
]
134 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8148962640"
  1032863
]
135 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8149414024"
  1032864
]
136 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8149414025"
  1032865
]
137 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8149414032"
  1032866
]
138 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8149414033"
  1032867
]
139 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8150064064"
  1032868
]
140 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8150961827"
  1032869
]
141 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8156603134"
  1032870
]
142 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8169116359"
  1032871
]
143 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8174345803"
  1032872
]
144 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8174426695"
  1032873
]
145 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8175276542"
  1032874
]
146 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8175276544"
  1032875
]
147 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243636859"
  1032878
]
148 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243636860"
  1032879
]
149 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243636861"
  1032880
]
150 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243636862"
  1032881
]
151 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243636863"
  1032882
]
152 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243636864"
  1032883
]
153 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243636865"
  1032884
]
154 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243636866"
  1032885
]
155 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8243636869"
  1032886
]
156 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8309075583"
  1032888
]
157 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8423069772"
  1032891
]
158 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8423069773"
  1032892
]
159 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8423089785"
  1032893
]
160 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8464890569"
  1032894
]
161 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8482661011"
  1032895
]
162 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8482661012"
  1032896
]
163 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8483931138"
  1032897
]
164 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8484204675"
  1032898
]
165 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8604107293"
  1032899
]
166 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8607133599"
  1032900
]
167 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8691308513"
  1032903
]
168 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9045375319"
  1032905
]
169 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9045381121"
  1032906
]
170 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9233702995"
  1032907
]
171 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9351109905"
  1032908
]
172 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9351109906"
  1032909
]
173 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9558859345"
  1032910
]
174 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9574204055"
  1032911
]
175 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9577513312"
  1032912
]
176 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9609878893"
  1032913
]
177 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9610042369"
  1032914
]
178 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9713207535"
  1032915
]
179 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9713208314"
  1032916
]
180 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9713214474"
  1032917
]
181 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9738325719"
  1032918
]
182 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9862379811"
  1032919
]
183 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9981309215"
  1032920
]
184 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9981316136"
  1032921
]
185 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9982135697"
  1032922
]
186 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9983683566"
  1032923
]
187 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9983683568"
  1032925
]
188 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10159777171"
  1032927
]
189 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10310703458"
  1032928
]
190 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10310743681"
  1032929
]
191 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10310750909"
  1032930
]
192 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10587851642"
  1032933
]
193 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10587851646"
  1032936
]
194 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10798166628"
  1032938
]
195 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10798166629"
  1032939
]
196 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10944278243"
  1032941
]
197 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11147009622"
  1032943
]
198 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11147009623"
  1032944
]
199 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11196060586"
  1032945
]
200 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11390115299"
  1032952
]
201 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11390115300"
  1032953
]
202 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11390115301"
  1032954
]
203 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11390115302"
  1032955
]
204 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11862799605"
  1032958
]
205 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12062161371"
  1032959
]
206 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12063892323"
  1032960
]
207 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12063892324"
  1032961
]
208 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12064487424"
  1032962
]
209 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12113776176"
  1032963
]
210 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12190140290"
  1032964
]
211 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12222548456"
  1032965
]
212 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12222572511"
  1032966
]
213 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12258448883"
  1032967
]
214 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12288883198"
  1032968
]
215 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12412607282"
  1032969
]
216 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12412660604"
  1032970
]
217 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12412667422"
  1032971
]
218 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12486217321"
  1032972
]
219 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12704308986"
  1032973
]
220 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12728654284"
  1032978
]
221 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12862848442"
  1032983
]
222 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12878739039"
  1032984
]
223 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13039814677"
  1032985
]
224 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13043134359"
  1032986
]
225 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13043348040"
  1032987
]
226 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13043348041"
  1032988
]
227 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13043348042"
  1032989
]
228 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13043348043"
  1032990
]
229 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13048495711"
  1032991
]
230 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13048495734"
  1032992
]
231 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13048495735"
  1032993
]
232 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13050504559"
  1032994
]
233 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13050547969"
  1032995
]
234 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051020197"
  1032996
]
235 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051020198"
  1032997
]
236 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051020199"
  1032998
]
237 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051020200"
  1032999
]
238 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026401"
  1033000
]
239 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026402"
  1033001
]
240 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026403"
  1033002
]
241 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026404"
  1033003
]
242 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026405"
  1033004
]
243 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026406"
  1033005
]
244 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026407"
  1033006
]
245 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026408"
  1033007
]
246 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026409"
  1033008
]
247 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026410"
  1033009
]
248 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026411"
  1033010
]
249 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13051026412"
  1033011
]
250 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13056090330"
  1033012
]
251 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13076499842"
  1033013
]
252 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13076608565"
  1033014
]
253 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13076608566"
  1033015
]
254 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13076608567"
  1033016
]
255 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13076608568"
  1033017
]
256 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13076608569"
  1033018
]
257 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13076608571"
  1033019
]
258 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13141353601"
  1033020
]
259 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63652207"
  1033021
]
260 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63652509"
  1033023
]
261 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63652542"
  1033024
]
262 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63652654"
  1033025
]
263 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63652891"
  1033026
]
264 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63653676"
  1033027
]
265 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63653966"
  1033028
]
266 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63654265"
  1033029
]
267 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63654510"
  1033030
]
268 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63656484"
  1033033
]
269 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63657401"
  1033036
]
270 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "63657425"
  1033037
]
271 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "545001783"
  1033038
]
272 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "706907525"
  1033039
]
273 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1218893128"
  1033040
]
274 3.00 ms
"COMMIT"
Parameters:
[]
275 1.67 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:
[
  4635
]
276 0.86 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:
[
  4635
  "restaurant"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CityFollowUp 720
App\Entity\Place 353
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.