GET https://osm-commerces.cipherbliss.com/admin/stats/06018

Query Metrics

108 Database Queries
7 Different statements
35.67 ms Query time
0 Invalid entities
100 Managed entities

Queries

Group similar statements

# Time Info
1 17.68 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.zip_code = ?
Parameters:
[
  "06018"
]
2 0.32 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 FROM stats t0 WHERE t0.zone = ? LIMIT 1
Parameters:
[
  "06018"
]
3 0.12 ms
"START TRANSACTION"
Parameters:
[]
4 0.23 ms
UPDATE stats SET completion_percent = ?, places_count = ?, avec_horaires = ?, avec_adresse = ?, avec_site = ?, avec_accessibilite = ? WHERE id = ?
Parameters:
[
  0
  0
  0
  0
  0
  0
  600
]
5 0.58 ms
"COMMIT"
Parameters:
[]
6 0.69 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.stats_id AS stats_id_27 FROM place t0 WHERE t0.stats_id = ?
Parameters:
[
  600
]
7 0.22 ms
"START TRANSACTION"
Parameters:
[]
8 0.31 ms
UPDATE stats SET completion_percent = ?, places_count = ?, avec_horaires = ?, avec_adresse = ?, avec_site = ?, avec_accessibilite = ? WHERE id = ?
Parameters:
[
  20
  99
  34
  26
  26
  13
  600
]
9 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "305569145"
  517793
]
10 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "305569146"
  517794
]
11 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "442496558"
  517795
]
12 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "442496624"
  517796
]
13 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "442498407"
  517797
]
14 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "560844579"
  517798
]
15 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "564702276"
  517799
]
16 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "564702278"
  517800
]
17 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "564702280"
  517801
]
18 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "564702284"
  517802
]
19 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "564702287"
  517803
]
20 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "564702291"
  517804
]
21 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "564702292"
  517805
]
22 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "881706407"
  517806
]
23 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "883089091"
  517807
]
24 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "883089162"
  517808
]
25 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "883089581"
  517809
]
26 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "956908827"
  517810
]
27 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1037349718"
  517811
]
28 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1037349719"
  517812
]
29 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1037349720"
  517813
]
30 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1037349725"
  517814
]
31 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1037349728"
  517815
]
32 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1196717251"
  517816
]
33 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1196717254"
  517817
]
34 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1205676772"
  517818
]
35 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "1945772212"
  517819
]
36 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2624050476"
  517820
]
37 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "2898809674"
  517821
]
38 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3129777298"
  517822
]
39 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3247516766"
  517823
]
40 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3328177635"
  517824
]
41 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3328183684"
  517825
]
42 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3637118993"
  517826
]
43 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3661591364"
  517827
]
44 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "3723897848"
  517828
]
45 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4235223894"
  517829
]
46 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4325305315"
  517830
]
47 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4793674908"
  517831
]
48 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4793674910"
  517832
]
49 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4793674911"
  517833
]
50 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4865592303"
  517834
]
51 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4866099191"
  517835
]
52 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4866103354"
  517836
]
53 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4866103355"
  517837
]
54 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4866517421"
  517838
]
55 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4868071956"
  517839
]
56 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "4875516228"
  517840
]
57 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5062520224"
  517841
]
58 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5062520226"
  517842
]
59 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5062520227"
  517843
]
60 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5062520228"
  517844
]
61 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5062543921"
  517845
]
62 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5062545321"
  517846
]
63 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5110841523"
  517847
]
64 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "5699834072"
  517848
]
65 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6250169368"
  517849
]
66 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6311554614"
  517850
]
67 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6311554615"
  517851
]
68 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6602145052"
  517852
]
69 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6744130504"
  517853
]
70 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "6863639285"
  517854
]
71 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7880643498"
  517855
]
72 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7880643499"
  517856
]
73 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "7880643501"
  517857
]
74 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8437454384"
  517858
]
75 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8478607941"
  517859
]
76 0.19 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8500067167"
  517860
]
77 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "8589190073"
  517861
]
78 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9700009813"
  517862
]
79 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "9976791117"
  517863
]
80 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10002774157"
  517864
]
81 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10002774158"
  517865
]
82 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "10003446307"
  517866
]
83 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11824560403"
  517867
]
84 0.17 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "11925845869"
  517868
]
85 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12104030117"
  517869
]
86 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12184439559"
  517870
]
87 0.18 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "12705845009"
  517871
]
88 0.21 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "28564756"
  517872
]
89 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "38595577"
  517873
]
90 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "38595580"
  517874
]
91 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "38595582"
  517875
]
92 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "38595583"
  517876
]
93 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "38595584"
  517877
]
94 0.20 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "38595585"
  517878
]
95 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "89088394"
  517879
]
96 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "89089781"
  517880
]
97 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "89090499"
  517881
]
98 0.16 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "89092159"
  517882
]
99 0.15 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "89107650"
  517883
]
100 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "89113367"
  517884
]
101 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "89114204"
  517885
]
102 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "89115346"
  517886
]
103 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "123717653"
  517887
]
104 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "123717654"
  517888
]
105 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "124838923"
  517889
]
106 0.14 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "232662002"
  517890
]
107 0.13 ms
UPDATE place SET osm_id = ? WHERE id = ?
Parameters:
[
  "854199404"
  517891
]
108 0.47 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\Place 99
App\Entity\Stats 1

Entities Mapping

Class Mapping errors
App\Entity\Place No errors.
App\Entity\Stats No errors.
App\Entity\History No errors.