GET https://osm-labo.cipherbliss.com/admin/delete_by_zone/02114

Query Metrics

181 Database Queries
11 Different statements
2534.51 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 2.51 ms
"START TRANSACTION"
Parameters:
[]
2 2.98 ms
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "admin/delete_by_zone"
  "{"insee_code":"02114"}"
  "2026-03-19 12:31:47"
  null
  null
]
3 472.11 ms
"COMMIT"
Parameters:
[]
4 33.86 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:
[
  "02114"
]
5 5.14 ms
SELECT t0.id AS id_1, t0.places_count AS places_count_2, t0.emails_count AS emails_count_3, t0.completion_percent AS completion_percent_4, t0.emails_sent AS emails_sent_5, t0.date AS date_6, t0.names_count AS names_count_7, t0.opening_hours_count AS opening_hours_count_8, t0.website_count AS website_count_9, t0.address_count AS address_count_10, t0.siret_count AS siret_count_11, t0.stats_id AS stats_id_12 FROM stats_history t0 WHERE t0.stats_id = ?
Parameters:
[
  13994
]
6 2.45 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:
[
  13994
]
7 3.65 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:
[
  13994
]
8 11.91 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:
[
  13994
]
9 6.18 ms
"START TRANSACTION"
Parameters:
[]
10 3.85 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342482
]
11 2.68 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342483
]
12 4.06 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342484
]
13 2.66 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342485
]
14 2.69 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342486
]
15 2.78 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342487
]
16 2.75 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342488
]
17 2.54 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342489
]
18 2.63 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342490
]
19 3.96 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342491
]
20 3.94 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342492
]
21 2.69 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342493
]
22 2.61 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342494
]
23 6.30 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342495
]
24 2.64 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342496
]
25 2.49 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342497
]
26 13.04 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342498
]
27 2.58 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342499
]
28 5.11 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342500
]
29 4.07 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342501
]
30 2.66 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342502
]
31 3.96 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342503
]
32 28.42 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342504
]
33 18.51 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342505
]
34 9.54 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342506
]
35 26.64 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342507
]
36 2.45 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342508
]
37 2.57 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342509
]
38 7.64 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342510
]
39 5.49 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342511
]
40 2.50 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342512
]
41 18.98 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342513
]
42 3.99 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342514
]
43 2.33 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342515
]
44 10.84 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342516
]
45 5.31 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342517
]
46 2.55 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342518
]
47 7.93 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342519
]
48 3.94 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342520
]
49 2.63 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342521
]
50 2.54 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342522
]
51 33.57 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342523
]
52 3.60 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342524
]
53 5.06 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342525
]
54 2.46 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342526
]
55 3.84 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342527
]
56 5.08 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342528
]
57 2.34 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342529
]
58 5.14 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342530
]
59 2.40 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342531
]
60 2.24 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342532
]
61 2.45 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342533
]
62 7.40 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342534
]
63 3.81 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2342535
]
64 9.99 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344726
]
65 25.31 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344727
]
66 3.42 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344728
]
67 3.82 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344729
]
68 2.35 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344730
]
69 13.85 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344731
]
70 18.89 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344732
]
71 2.31 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344733
]
72 3.64 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344734
]
73 3.64 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344735
]
74 3.69 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344736
]
75 88.20 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344737
]
76 18.74 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344738
]
77 36.66 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344739
]
78 5.63 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344740
]
79 19.64 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344741
]
80 48.12 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344742
]
81 3.42 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344743
]
82 3.44 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344744
]
83 4.52 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344745
]
84 8.06 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344746
]
85 5.18 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344747
]
86 10.15 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344748
]
87 8.04 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344749
]
88 2.13 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344750
]
89 44.40 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344751
]
90 12.23 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344752
]
91 2.18 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344753
]
92 44.14 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344754
]
93 2.16 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344755
]
94 13.32 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344756
]
95 6.65 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344757
]
96 5.66 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344758
]
97 3.26 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344759
]
98 30.67 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344760
]
99 12.31 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344761
]
100 2.21 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344762
]
101 2.15 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344763
]
102 3.35 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344764
]
103 8.85 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344765
]
104 2.20 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344766
]
105 4.41 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344767
]
106 44.41 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344768
]
107 12.36 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344769
]
108 38.33 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344770
]
109 6.65 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344771
]
110 74.86 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344772
]
111 2.05 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344773
]
112 8.43 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344774
]
113 5.43 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344775
]
114 19.33 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344776
]
115 12.98 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344777
]
116 6.07 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344778
]
117 3.16 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344779
]
118 23.64 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2344780
]
119 1.93 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390833
]
120 2.95 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390834
]
121 11.89 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390835
]
122 6.59 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390836
]
123 2.10 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390837
]
124 2.04 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390838
]
125 23.35 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390839
]
126 2.00 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390840
]
127 2.04 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390841
]
128 3.11 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390842
]
129 3.16 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390843
]
130 2.07 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390844
]
131 6.32 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390845
]
132 10.91 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390846
]
133 1.97 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390847
]
134 2.00 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390848
]
135 2.94 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390849
]
136 1.98 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390850
]
137 1.95 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390851
]
138 1.94 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390852
]
139 15.99 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390853
]
140 4.97 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390854
]
141 28.96 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390855
]
142 29.04 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390856
]
143 20.87 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390857
]
144 3.22 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390858
]
145 10.73 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390859
]
146 2.91 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390860
]
147 22.04 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390861
]
148 4.90 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390862
]
149 7.89 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390863
]
150 2.91 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390864
]
151 10.91 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390865
]
152 2.90 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390866
]
153 38.03 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390867
]
154 2.84 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390868
]
155 3.96 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390869
]
156 2.86 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390870
]
157 6.88 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390871
]
158 32.10 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390872
]
159 59.57 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390873
]
160 3.67 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390874
]
161 10.39 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390875
]
162 7.40 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390876
]
163 16.15 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390877
]
164 1.86 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390878
]
165 136.95 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390879
]
166 21.96 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390880
]
167 7.31 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390881
]
168 8.19 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390882
]
169 13.75 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390883
]
170 16.66 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390884
]
171 10.12 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390885
]
172 2.57 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390886
]
173 3.35 ms
DELETE FROM city_follow_up WHERE id = ?
Parameters:
[
  2390887
]
174 42.22 ms
DELETE FROM zone_places WHERE id = ?
Parameters:
[
  259315
]
175 39.10 ms
DELETE FROM zone_places WHERE id = ?
Parameters:
[
  259552
]
176 2.35 ms
DELETE FROM zone_places WHERE id = ?
Parameters:
[
  259934
]
177 51.01 ms
DELETE FROM zone_places WHERE id = ?
Parameters:
[
  260152
]
178 6.13 ms
DELETE FROM zone_places WHERE id = ?
Parameters:
[
  260254
]
179 6.27 ms
DELETE FROM zone_places WHERE id = ?
Parameters:
[
  261038
]
180 13.58 ms
DELETE FROM stats WHERE id = ?
Parameters:
[
  13994
]
181 27.46 ms
"COMMIT"
Parameters:
[]

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

Entities Mapping

Class Mapping errors
App\Entity\ActionLog No 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\SireneEntreprise No errors.