GET https://osm-commerces.cipherbliss.com/admin/stats/94003/followup-graph/tree

Response
200 OK
IP
216.73.216.135
Profiled on
Token
a93355

Query Metrics

176 Database Queries
8 Different statements
164.69 ms Query time
0 Invalid entities
383 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.44 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: 
[
  "94003"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.45 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: 
[
  1245
]
View formatted query    View runnable query    Explain query    View query backtrace
3 130.53 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: 
[
  "94003"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.21 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.53 ms 
INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  "[DEBUG][followupThemeGraph]"
  "{"theme":"tree","tagKey":null,"tagValue":null,"main_tags":["shop=supermarket","amenity=fuel","amenity=bank","healthcare=pharmacy","amenity=bank","amenity=bar","amenity=fast_food","amenity=restaurant","shop=beauty","shop=hairdresser","amenity=pub","amenity=veterinary","shop=laundry","shop=butcher","shop=travel_agency","shop=newsagent","shop=convenience","shop=hifi","amenity=cafe","shop=tobacco","amenity=driving_school","healthcare=pharmacy","shop=car","shop=bed","tourism=hotel","amenity=vehicle_inspection","tourism=hotel","shop=paint","amenity=fast_food","shop=bakery","shop=car_repair","amenity=library","office=telecommunication","amenity=fast_food","shop=supermarket","amenity=cafe","shop=tailor","shop=dry_cleaning","amenity=restaurant","shop=bakery","amenity=bank","amenity=bank","office=estate_agent","amenity=bank","shop=car_repair","amenity=restaurant","shop=garden_centre","healthcare=pharmacy","shop=supermarket","shop=clothes","shop=clothes","shop=clothes","shop=clothes","shop=bag","shop=electronics","shop=clothes","shop=shoes","shop=clothes","shop=clothes","shop=clothes","shop=beauty","shop=hairdresser","shop=car","shop=supermarket","amenity=restaurant","amenity=kindergarten","amenity=restaurant","shop=convenience","amenity=car_wash","office=insurance","shop=butcher","office=association","amenity=bank","amenity=restaurant","office=company","amenity=cafe","shop=clothes","amenity=restaurant","shop=optician","shop=hairdresser","amenity=restaurant","amenity=driving_school","shop=supermarket","office=association","shop=hairdresser","office=association","office=association","shop=optician","shop=variety_store","shop=sports","office=company","shop=bakery","shop=car_repair","shop=convenience","office=company","shop=travel_agency","office=company","amenity=restaurant","shop=car_repair","office=estate_agent","office=company","office=company","shop=car","shop=mobile_phone","healthcare=dentist","healthcare=doctor","healthcare=doctor","amenity=restaurant","shop=second_hand","healthcare=laboratory","office=construction_company","office=construction_company","amenity=restaurant","shop=car_repair","shop=sewing","shop=florist","shop=cheese","shop=beauty","shop=convenience","amenity=dentist","healthcare=dentist","shop=hairdresser","shop=hairdresser","amenity=fast_food","amenity=fast_food","amenity=restaurant","shop=yes","amenity=bar","shop=electrical","office=coworking","shop=convenience","shop=cannabis","shop=hearing_aids","shop=laundry","shop=car_repair","shop=hookah","amenity=restaurant","shop=clothes","shop=clothes","amenity=fast_food","amenity=restaurant","shop=optician","shop=shoe_repair","shop=beauty","shop=baby_goods","shop=cosmetics","shop=chocolate","shop=optician","tourism=gallery","shop=clothes","shop=jewelry","office=company","shop=bakery","healthcare=pharmacy","healthcare=centre","amenity=kindergarten","amenity=restaurant","shop=second_hand","tourism=hotel","shop=car","office=company","shop=mall","shop=furniture","shop=doityourself","shop=art","amenity=kindergarten","amenity=restaurant","shop=convenience","shop=car_repair"],"places_count":169,"filtered_count":0,"filtered_main_tags":[]}"
  "2025-09-23 03:22:32"
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.26 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "310990566"
  749720
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.23 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "339346042"
  749721
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "469287855"
  749724
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "469287863"
  749725
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "469287865"
  749726
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "772405622"
  749729
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "772600423"
  749730
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "772600424"
  749731
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "772600425"
  749732
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "772600426"
  749733
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "772600427"
  749734
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "772600428"
  749735
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "777378935"
  749737
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "777378937"
  749738
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "777378939"
  749740
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "777378940"
  749741
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "777378943"
  749742
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "777378944"
  749743
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "777385254"
  749744
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "777385259"
  749745
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "777387091"
  749746
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "778108810"
  749747
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "778108813"
  749748
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "778108814"
  749749
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "778108815"
  749750
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "778108818"
  749751
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "778108824"
  749752
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "778117630"
  749754
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "778117632"
  749756
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "1309080725"
  749759
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "1526141670"
  749760
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "1526144658"
  749761
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "1669792603"
  749763
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2442551232"
  749768
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2479127866"
  749769
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2563169617"
  749770
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2563169618"
  749771
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "2563183468"
  749772
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3032392456"
  749775
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3032392457"
  749776
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3032392458"
  749777
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3032392461"
  749778
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3423874635"
  749779
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3423874636"
  749780
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3523697987"
  749782
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3656454103"
  749783
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3656454104"
  749784
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3656458344"
  749785
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3658997163"
  749786
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659020747"
  749787
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659020748"
  749788
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659020749"
  749789
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659021221"
  749790
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659021222"
  749791
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659021224"
  749792
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659021825"
  749793
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659021828"
  749794
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659021829"
  749795
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659021830"
  749796
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659021831"
  749797
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659021832"
  749798
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3659021833"
  749799
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3860628308"
  749800
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3867444867"
  749801
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3867491140"
  749802
]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3867553101"
  749803
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "3867553104"
  749804
]
View formatted query    View runnable query    Explain query    View query backtrace
73 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "4351299289"
  749808
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "4365968701"
  749809
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "4751279157"
  749811
]
View formatted query    View runnable query    Explain query    View query backtrace
76 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5021873481"
  749815
]
View formatted query    View runnable query    Explain query    View query backtrace
77 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5021913729"
  749818
]
View formatted query    View runnable query    Explain query    View query backtrace
78 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5152496936"
  749820
]
View formatted query    View runnable query    Explain query    View query backtrace
79 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5152503549"
  749822
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5204546970"
  749824
]
View formatted query    View runnable query    Explain query    View query backtrace
81 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5723816446"
  749825
]
View formatted query    View runnable query    Explain query    View query backtrace
82 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "5839936169"
  749826
]
View formatted query    View runnable query    Explain query    View query backtrace
83 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6064970710"
  749829
]
View formatted query    View runnable query    Explain query    View query backtrace
84 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6064970712"
  749830
]
View formatted query    View runnable query    Explain query    View query backtrace
85 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6064970713"
  749831
]
View formatted query    View runnable query    Explain query    View query backtrace
86 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6064970715"
  749833
]
View formatted query    View runnable query    Explain query    View query backtrace
87 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6064970718"
  749835
]
View formatted query    View runnable query    Explain query    View query backtrace
88 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6064970719"
  749836
]
View formatted query    View runnable query    Explain query    View query backtrace
89 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6207195409"
  749838
]
View formatted query    View runnable query    Explain query    View query backtrace
90 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6631934079"
  749842
]
View formatted query    View runnable query    Explain query    View query backtrace
91 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6659057620"
  749844
]
View formatted query    View runnable query    Explain query    View query backtrace
92 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6668190912"
  749845
]
View formatted query    View runnable query    Explain query    View query backtrace
93 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "6761395265"
  749847
]
View formatted query    View runnable query    Explain query    View query backtrace
94 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7047420060"
  749850
]
View formatted query    View runnable query    Explain query    View query backtrace
95 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7194246848"
  749853
]
View formatted query    View runnable query    Explain query    View query backtrace
96 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7197561288"
  749854
]
View formatted query    View runnable query    Explain query    View query backtrace
97 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7403207295"
  749855
]
View formatted query    View runnable query    Explain query    View query backtrace
98 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7403207297"
  749856
]
View formatted query    View runnable query    Explain query    View query backtrace
99 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7623753917"
  749858
]
View formatted query    View runnable query    Explain query    View query backtrace
100 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7623753918"
  749859
]
View formatted query    View runnable query    Explain query    View query backtrace
101 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7704817112"
  749864
]
View formatted query    View runnable query    Explain query    View query backtrace
102 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7711376282"
  749865
]
View formatted query    View runnable query    Explain query    View query backtrace
103 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "7855054314"
  749867
]
View formatted query    View runnable query    Explain query    View query backtrace
104 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8066175114"
  749868
]
View formatted query    View runnable query    Explain query    View query backtrace
105 0.22 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8152609043"
  749870
]
View formatted query    View runnable query    Explain query    View query backtrace
106 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8203763421"
  749872
]
View formatted query    View runnable query    Explain query    View query backtrace
107 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8203763422"
  749873
]
View formatted query    View runnable query    Explain query    View query backtrace
108 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8391060904"
  749875
]
View formatted query    View runnable query    Explain query    View query backtrace
109 0.21 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8462426249"
  749876
]
View formatted query    View runnable query    Explain query    View query backtrace
110 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8483907405"
  749878
]
View formatted query    View runnable query    Explain query    View query backtrace
111 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8483907406"
  749879
]
View formatted query    View runnable query    Explain query    View query backtrace
112 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8483907407"
  749880
]
View formatted query    View runnable query    Explain query    View query backtrace
113 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8492074362"
  749881
]
View formatted query    View runnable query    Explain query    View query backtrace
114 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8607133601"
  749882
]
View formatted query    View runnable query    Explain query    View query backtrace
115 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8676510017"
  749883
]
View formatted query    View runnable query    Explain query    View query backtrace
116 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8691336919"
  749886
]
View formatted query    View runnable query    Explain query    View query backtrace
117 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8691336920"
  749887
]
View formatted query    View runnable query    Explain query    View query backtrace
118 0.20 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "8974692790"
  749889
]
View formatted query    View runnable query    Explain query    View query backtrace
119 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9146277820"
  749890
]
View formatted query    View runnable query    Explain query    View query backtrace
120 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9461186236"
  749897
]
View formatted query    View runnable query    Explain query    View query backtrace
121 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9461186237"
  749898
]
View formatted query    View runnable query    Explain query    View query backtrace
122 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9461186238"
  749899
]
View formatted query    View runnable query    Explain query    View query backtrace
123 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9461186254"
  749900
]
View formatted query    View runnable query    Explain query    View query backtrace
124 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9461186255"
  749901
]
View formatted query    View runnable query    Explain query    View query backtrace
125 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9826837691"
  749905
]
View formatted query    View runnable query    Explain query    View query backtrace
126 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "9860417726"
  749906
]
View formatted query    View runnable query    Explain query    View query backtrace
127 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10095466417"
  749909
]
View formatted query    View runnable query    Explain query    View query backtrace
128 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10127499373"
  749910
]
View formatted query    View runnable query    Explain query    View query backtrace
129 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10147545617"
  749911
]
View formatted query    View runnable query    Explain query    View query backtrace
130 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10149217082"
  749912
]
View formatted query    View runnable query    Explain query    View query backtrace
131 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10161573877"
  749913
]
View formatted query    View runnable query    Explain query    View query backtrace
132 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10312680716"
  749916
]
View formatted query    View runnable query    Explain query    View query backtrace
133 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10652400485"
  749923
]
View formatted query    View runnable query    Explain query    View query backtrace
134 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10758850570"
  749924
]
View formatted query    View runnable query    Explain query    View query backtrace
135 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "10922149669"
  749926
]
View formatted query    View runnable query    Explain query    View query backtrace
136 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11136476316"
  749932
]
View formatted query    View runnable query    Explain query    View query backtrace
137 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11230512057"
  749936
]
View formatted query    View runnable query    Explain query    View query backtrace
138 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11267241267"
  749937
]
View formatted query    View runnable query    Explain query    View query backtrace
139 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11267241268"
  749938
]
View formatted query    View runnable query    Explain query    View query backtrace
140 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11290295269"
  749939
]
View formatted query    View runnable query    Explain query    View query backtrace
141 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11483243283"
  749940
]
View formatted query    View runnable query    Explain query    View query backtrace
142 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11592836750"
  749941
]
View formatted query    View runnable query    Explain query    View query backtrace
143 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11592836751"
  749942
]
View formatted query    View runnable query    Explain query    View query backtrace
144 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11592836752"
  749943
]
View formatted query    View runnable query    Explain query    View query backtrace
145 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11592860302"
  749944
]
View formatted query    View runnable query    Explain query    View query backtrace
146 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11592860303"
  749945
]
View formatted query    View runnable query    Explain query    View query backtrace
147 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11592860304"
  749946
]
View formatted query    View runnable query    Explain query    View query backtrace
148 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11592860305"
  749947
]
View formatted query    View runnable query    Explain query    View query backtrace
149 0.19 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11758823822"
  749949
]
View formatted query    View runnable query    Explain query    View query backtrace
150 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11799485660"
  749950
]
View formatted query    View runnable query    Explain query    View query backtrace
151 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11799485661"
  749951
]
View formatted query    View runnable query    Explain query    View query backtrace
152 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11799485662"
  749952
]
View formatted query    View runnable query    Explain query    View query backtrace
153 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11799485663"
  749953
]
View formatted query    View runnable query    Explain query    View query backtrace
154 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11799485664"
  749954
]
View formatted query    View runnable query    Explain query    View query backtrace
155 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11799485665"
  749955
]
View formatted query    View runnable query    Explain query    View query backtrace
156 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "11799485666"
  749956
]
View formatted query    View runnable query    Explain query    View query backtrace
157 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "12009166969"
  749962
]
View formatted query    View runnable query    Explain query    View query backtrace
158 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "12186485301"
  749963
]
View formatted query    View runnable query    Explain query    View query backtrace
159 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "13017135032"
  749966
]
View formatted query    View runnable query    Explain query    View query backtrace
160 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "61360943"
  749969
]
View formatted query    View runnable query    Explain query    View query backtrace
161 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "61515552"
  749970
]
View formatted query    View runnable query    Explain query    View query backtrace
162 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "61519021"
  749971
]
View formatted query    View runnable query    Explain query    View query backtrace
163 0.16 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "61751237"
  749972
]
View formatted query    View runnable query    Explain query    View query backtrace
164 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "61752128"
  749973
]
View formatted query    View runnable query    Explain query    View query backtrace
165 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "61996980"
  749977
]
View formatted query    View runnable query    Explain query    View query backtrace
166 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "61999712"
  749978
]
View formatted query    View runnable query    Explain query    View query backtrace
167 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "62031372"
  749979
]
View formatted query    View runnable query    Explain query    View query backtrace
168 0.17 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "62034060"
  749980
]
View formatted query    View runnable query    Explain query    View query backtrace
169 0.18 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "62463173"
  749982
]
View formatted query    View runnable query    Explain query    View query backtrace
170 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "62464827"
  749983
]
View formatted query    View runnable query    Explain query    View query backtrace
171 0.14 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "63574197"
  749985
]
View formatted query    View runnable query    Explain query    View query backtrace
172 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "607098148"
  749986
]
View formatted query    View runnable query    Explain query    View query backtrace
173 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "1100865475"
  749988
]
View formatted query    View runnable query    Explain query    View query backtrace
174 0.15 ms 
UPDATE place SET osm_id = ? WHERE id = ?
Parameters: 
[
  "1358665080"
  749989
]
View formatted query    View runnable query    Explain query    View query backtrace
175 1.73 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
176 1.73 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: 
[
  1245
]
View formatted query    View runnable query    Explain query    View query backtrace

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 270
App\Entity\CityFollowUp 111
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\History No errors.
App\Entity\ActionLog No errors.