GET https://osm-labo.cipherbliss.com/admin/stats/02168

Query Metrics

247 Database Queries
10 Different statements
1686.81 ms Query time
0 Invalid entities
318 Managed entities

Queries

Group similar statements

# Time Info
1 0.36 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:
[
  "02168"
]
2 0.37 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:
[
  5538
]
3 1.57 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:
[
  5538
]
4 0.21 ms
"START TRANSACTION"
Parameters:
[]
5 0.25 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "721156204"
  1082474
]
6 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "721156209"
  1082475
]
7 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307553334"
  1082476
]
8 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674805"
  1082477
]
9 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674806"
  1082478
]
10 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674807"
  1082479
]
11 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674810"
  1082480
]
12 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674820"
  1082481
]
13 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674824"
  1082482
]
14 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674827"
  1082483
]
15 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674836"
  1082484
]
16 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674839"
  1082485
]
17 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674842"
  1082486
]
18 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674846"
  1082487
]
19 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674847"
  1082488
]
20 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674852"
  1082489
]
21 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674860"
  1082490
]
22 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674864"
  1082491
]
23 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674867"
  1082492
]
24 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674875"
  1082493
]
25 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674878"
  1082494
]
26 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674881"
  1082495
]
27 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674884"
  1082496
]
28 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674892"
  1082497
]
29 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674893"
  1082498
]
30 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674894"
  1082499
]
31 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674899"
  1082500
]
32 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674902"
  1082501
]
33 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307674906"
  1082502
]
34 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307679906"
  1082503
]
35 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307707026"
  1082504
]
36 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307707027"
  1082505
]
37 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307707028"
  1082506
]
38 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307707029"
  1082507
]
39 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307707030"
  1082508
]
40 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307707031"
  1082509
]
41 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307707032"
  1082510
]
42 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307716676"
  1082511
]
43 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307716679"
  1082512
]
44 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307716682"
  1082513
]
45 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307716683"
  1082514
]
46 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307719747"
  1082515
]
47 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307719748"
  1082516
]
48 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307719750"
  1082517
]
49 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307719751"
  1082518
]
50 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307719752"
  1082519
]
51 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307728754"
  1082520
]
52 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307728760"
  1082521
]
53 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307728765"
  1082522
]
54 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307728767"
  1082523
]
55 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307728769"
  1082524
]
56 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307728815"
  1082525
]
57 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307728821"
  1082526
]
58 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307728826"
  1082527
]
59 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307749845"
  1082528
]
60 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307753489"
  1082529
]
61 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307753491"
  1082530
]
62 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307753492"
  1082531
]
63 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307753493"
  1082532
]
64 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307794526"
  1082533
]
65 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307794527"
  1082534
]
66 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307798275"
  1082535
]
67 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813746"
  1082536
]
68 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813747"
  1082537
]
69 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813748"
  1082538
]
70 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813749"
  1082539
]
71 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813750"
  1082540
]
72 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813751"
  1082541
]
73 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813753"
  1082542
]
74 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813754"
  1082543
]
75 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813755"
  1082544
]
76 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813757"
  1082545
]
77 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813759"
  1082546
]
78 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813771"
  1082547
]
79 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813778"
  1082548
]
80 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813779"
  1082549
]
81 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813780"
  1082550
]
82 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813783"
  1082551
]
83 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813793"
  1082552
]
84 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813797"
  1082553
]
85 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307813802"
  1082554
]
86 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1307832067"
  1082555
]
87 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1436799529"
  1082556
]
88 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2606108942"
  1082557
]
89 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2606231526"
  1082558
]
90 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3213332310"
  1082559
]
91 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3617636001"
  1082560
]
92 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3728862328"
  1082561
]
93 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3747183325"
  1082562
]
94 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4025474389"
  1082563
]
95 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4342412690"
  1082564
]
96 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4411107893"
  1082565
]
97 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4688768390"
  1082566
]
98 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4924662016"
  1082567
]
99 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4924662017"
  1082568
]
100 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5189619785"
  1082569
]
101 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5425520722"
  1082570
]
102 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5862290768"
  1082571
]
103 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6049039987"
  1082572
]
104 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6142403802"
  1082573
]
105 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6144851918"
  1082574
]
106 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6360679185"
  1082575
]
107 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6465862285"
  1082576
]
108 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6746601944"
  1082577
]
109 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6763717813"
  1082578
]
110 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6996771685"
  1082579
]
111 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7015084916"
  1082580
]
112 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7123359588"
  1082581
]
113 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7892866785"
  1082582
]
114 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7892866885"
  1082583
]
115 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7892866886"
  1082584
]
116 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8241132099"
  1082585
]
117 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8241132102"
  1082586
]
118 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8241132103"
  1082587
]
119 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8241132104"
  1082588
]
120 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8241132105"
  1082589
]
121 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8241132106"
  1082590
]
122 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8241132108"
  1082591
]
123 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8720802417"
  1082592
]
124 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8771736617"
  1082593
]
125 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8873042399"
  1082594
]
126 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9561513939"
  1082595
]
127 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9710766287"
  1082596
]
128 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9791739442"
  1082597
]
129 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9792926672"
  1082598
]
130 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9792960460"
  1082599
]
131 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9818210966"
  1082600
]
132 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9820902375"
  1082601
]
133 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9848495868"
  1082602
]
134 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9848523042"
  1082603
]
135 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9848528892"
  1082604
]
136 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9848530955"
  1082605
]
137 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9848530956"
  1082606
]
138 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9848701378"
  1082607
]
139 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9848701379"
  1082608
]
140 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9848701380"
  1082609
]
141 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9848701383"
  1082610
]
142 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9850575002"
  1082611
]
143 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9860142814"
  1082612
]
144 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9860142815"
  1082613
]
145 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9860159385"
  1082614
]
146 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9860308818"
  1082615
]
147 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9861885713"
  1082616
]
148 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9861885714"
  1082617
]
149 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9861885715"
  1082618
]
150 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9876627704"
  1082619
]
151 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9897417273"
  1082620
]
152 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9901714183"
  1082621
]
153 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9986650528"
  1082622
]
154 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9986650537"
  1082623
]
155 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9986650652"
  1082624
]
156 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9986650653"
  1082625
]
157 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10110743217"
  1082626
]
158 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10598689605"
  1082627
]
159 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10803681283"
  1082628
]
160 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10826836305"
  1082629
]
161 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10826837805"
  1082630
]
162 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11047610480"
  1082631
]
163 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11047610483"
  1082632
]
164 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11612953570"
  1082633
]
165 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12351615701"
  1082634
]
166 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12535852501"
  1082635
]
167 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13041518744"
  1082636
]
168 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13041518745"
  1082637
]
169 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13094649407"
  1082638
]
170 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13105391576"
  1082639
]
171 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13105391577"
  1082640
]
172 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13105391578"
  1082641
]
173 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13105410069"
  1082642
]
174 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13110944452"
  1082643
]
175 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13121204365"
  1082644
]
176 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13179044882"
  1082645
]
177 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13185561701"
  1082646
]
178 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13204753081"
  1082647
]
179 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13238602389"
  1082648
]
180 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13240348471"
  1082649
]
181 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13240348472"
  1082650
]
182 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13242892388"
  1082651
]
183 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13242892389"
  1082652
]
184 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "13242892390"
  1082653
]
185 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "56158266"
  1082654
]
186 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "115105819"
  1082655
]
187 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "115106086"
  1082656
]
188 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159767932"
  1082657
]
189 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159767934"
  1082658
]
190 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159767982"
  1082659
]
191 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768007"
  1082660
]
192 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768119"
  1082661
]
193 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768148"
  1082662
]
194 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768324"
  1082663
]
195 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768375"
  1082664
]
196 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768484"
  1082665
]
197 0.11 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768494"
  1082666
]
198 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768587"
  1082667
]
199 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768623"
  1082668
]
200 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768683"
  1082669
]
201 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768706"
  1082670
]
202 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768905"
  1082671
]
203 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768912"
  1082672
]
204 0.10 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768925"
  1082673
]
205 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768959"
  1082674
]
206 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768964"
  1082675
]
207 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768977"
  1082676
]
208 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159768997"
  1082677
]
209 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159769082"
  1082678
]
210 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159769478"
  1082679
]
211 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159769607"
  1082680
]
212 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159769807"
  1082681
]
213 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159770062"
  1082682
]
214 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159770911"
  1082683
]
215 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159770920"
  1082684
]
216 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159771387"
  1082685
]
217 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159771908"
  1082686
]
218 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159774888"
  1082687
]
219 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159775645"
  1082688
]
220 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159775864"
  1082689
]
221 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159776054"
  1082690
]
222 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159776329"
  1082691
]
223 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159776720"
  1082692
]
224 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159777057"
  1082693
]
225 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159777883"
  1082694
]
226 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159777902"
  1082695
]
227 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159777908"
  1082696
]
228 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159777995"
  1082697
]
229 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "159778257"
  1082698
]
230 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "782818079"
  1082699
]
231 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "897305006"
  1082700
]
232 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "897305007"
  1082701
]
233 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "897305073"
  1082702
]
234 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1069715980"
  1082703
]
235 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1072962064"
  1082704
]
236 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1077118019"
  1082705
]
237 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1081000252"
  1082706
]
238 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1189331590"
  1082707
]
239 0.12 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1310168822"
  1082708
]
240 0.10 ms
"COMMIT"
Parameters:
[]
241 0.22 ms
"START TRANSACTION"
Parameters:
[]
242 0.29 ms
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "stats_de_ville"
  "{"insee_code":"02168","nom":"02168"}"
  "2026-01-30 20:35:44"
  null
  null
]
243 1003.15 ms
"COMMIT"
Parameters:
[]
244 0.30 ms
SELECT s0_.id AS id_0, s0_.places_count AS places_count_1, s0_.emails_count AS emails_count_2, s0_.completion_percent AS completion_percent_3, s0_.emails_sent AS emails_sent_4, s0_.date AS date_5, s0_.names_count AS names_count_6, s0_.opening_hours_count AS opening_hours_count_7, s0_.website_count AS website_count_8, s0_.address_count AS address_count_9, s0_.siret_count AS siret_count_10, s0_.stats_id AS stats_id_11 FROM stats_history s0_ WHERE s0_.stats_id = ? ORDER BY s0_.id DESC LIMIT 100
Parameters:
[
  5538
]
245 1.23 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:
[
  5538
]
246 0.99 ms
SELECT p0_.osm_user AS osm_user_0, COUNT(p0_.id) AS sclr_1, AVG((CASE WHEN p0_.has_opening_hours = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_address = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_website = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_wheelchair = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_note = 1 THEN 1 ELSE 0 END)) / 5 * 100 AS sclr_2 FROM place p0_ WHERE p0_.osm_user IS NOT NULL AND p0_.osm_user <> '' AND p0_.stats_id = ? GROUP BY p0_.osm_user ORDER BY sclr_1 DESC LIMIT 100
Parameters:
[
  5538
]
247 648.30 ms
SELECT t0.id AS id_1, t0.disappeared_list AS disappeared_list_2, t0.current_list AS current_list_3, t0.theme AS theme_4, t0.stats_id AS stats_id_5 FROM zone_places t0 WHERE t0.stats_id = ?
Parameters:
[
  5538
]

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 235
App\Entity\CityFollowUp 54
App\Entity\ZonePlaces 27
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.