https://www.test.dombusin.com/uk/comments?start=50

Query Metrics

86 Database Queries
40 Different statements
1852.77 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
414.52 ms
(22.37%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 87127 AND 1750513952 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
208.95 ms
(11.28%)
30
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.facebook_id AS facebook_id_6, t0.manager AS manager_7, t0.referal AS referal_8, t0.type AS type_9, t0.name AS name_10, t0.surname AS surname_11, t0.gender AS gender_12, t0.country AS country_13, t0.city AS city_14, t0.address AS address_15, t0.lat AS lat_16, t0.lon AS lon_17, t0.phone AS phone_18, t0.discount AS discount_19, t0.visible AS visible_20, t0.status AS status_21, t0.birth AS birth_22, t0.ip AS ip_23, t0.lastlogon AS lastlogon_24, t0.logons AS logons_25, t0.created AS created_26, t0.color AS color_27, t0.opt AS opt_28, t0.miniopt AS miniopt_29, t0.lastordertime AS lastordertime_30, t0.ordersum AS ordersum_31, t0.ordernum AS ordernum_32, t0.external_id AS external_id_33, t0.company_nip AS company_nip_34, t0.company_name AS company_name_35, t0.company_index AS company_index_36, t0.company_city AS company_city_37, t0.company_street AS company_street_38, t0.company_house AS company_house_39, t0.company_flat AS company_flat_40 FROM user t0 WHERE t0.id = ?
Parameters:
[
  34257
]
201.59 ms
(10.88%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21220 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
161.20 ms
(8.70%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 25325 AND 1750513952 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
147.47 ms
(7.96%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 101087 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
114.21 ms
(6.16%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 97045 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
89.69 ms
(4.84%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 99653 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
73.53 ms
(3.97%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 26470 AND 1750513954 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
65.23 ms
(3.52%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 97418 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
63.27 ms
(3.42%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 29927 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
34.51 ms
(1.86%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31941 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
33.51 ms
(1.81%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 20309 AND 1750513952 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
33.18 ms
(1.79%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 100222 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
30.36 ms
(1.64%)
10
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 34257 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
26.64 ms
(1.44%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 62185 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
21.15 ms
(1.14%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 98211 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
18.69 ms
(1.01%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 72737 AND 1750513954 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
18.65 ms
(1.01%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 106777 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
18.46 ms
(1.00%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 97502 AND 1750513952 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
8.50 ms
(0.46%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 89905 AND 1750513954 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
8.50 ms
(0.46%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 96626 AND 1750513954 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
8.39 ms
(0.45%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 94994 AND 1750513954 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
8.24 ms
(0.44%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 102427 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.35 ms
(0.40%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 106944 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.88 ms
(0.37%)
3
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 34257 AND 1750513954 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.36 ms
(0.34%)
4
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 34257 AND 1750513952 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
5.18 ms
(0.28%)
2
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, tstamp_5 FROM (SELECT c0_.id AS id_0, c0_.par AS par_1, c0_.type AS type_2, c0_.user AS user_3, c0_.author AS author_4, c0_.tstamp AS tstamp_5, c0_.theme AS theme_6, c0_.cont AS cont_7, c0_.answer AS answer_8, c0_.visible AS visible_9, c0_.lang AS lang_10 FROM COMMENT c0_ WHERE c0_.visible = 1) dctrn_result_inner ORDER BY tstamp_5 DESC) dctrn_result LIMIT 50 OFFSET 50
Parameters:
[]
3.49 ms
(0.19%)
2
SELECT c0_.id AS id_0, c0_.par AS par_1, c0_.type AS type_2, c0_.user AS user_3, c0_.author AS author_4, c0_.tstamp AS tstamp_5, c0_.theme AS theme_6, c0_.cont AS cont_7, c0_.answer AS answer_8, c0_.visible AS visible_9, c0_.lang AS lang_10 FROM COMMENT c0_ WHERE c0_.visible = 1 AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.tstamp DESC
Parameters:
[
  5078
  5077
  5076
  5075
  5074
  5073
  5072
  5071
  5070
  5069
  5068
  5067
  5056
  5055
  5054
  5053
  5052
  5051
  5050
  5049
  5048
  5047
  5046
  5045
  5044
  3903
  3895
  3894
  3893
  3892
  3891
  3890
  3887
  3886
  3884
  3883
  3882
  3881
  3880
  3879
  3878
  3877
  3876
  3874
  3873
  3872
  3871
  3870
  3869
  3868
]
3.06 ms
(0.17%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 98066 AND 1750513954 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.94 ms
(0.16%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 106811 AND 1750513952 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.64 ms
(0.09%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.par AS par_1, c0_.type AS type_2, c0_.user AS user_3, c0_.author AS author_4, c0_.tstamp AS tstamp_5, c0_.theme AS theme_6, c0_.cont AS cont_7, c0_.answer AS answer_8, c0_.visible AS visible_9, c0_.lang AS lang_10 FROM COMMENT c0_ WHERE c0_.visible = 1 ORDER BY c0_.tstamp DESC) dctrn_result) dctrn_table
Parameters:
[]
1.26 ms
(0.07%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 106906 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.08 ms
(0.06%)
2
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36623 AND 1750513952 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.87 ms
(0.05%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 25325 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.84 ms
(0.05%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 45798 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.81 ms
(0.04%)
1
SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = ? ORDER BY t0.id DESC
Parameters:
[
  0
]
0.77 ms
(0.04%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36623 AND 1750513954 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.65 ms
(0.04%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 101325 AND 1750513953 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.57 ms
(0.03%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 29927 AND 1750513954 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.57 ms
(0.03%)
1
SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 96597 AND 1750513954 - o0_.tstamp < 60 * 60 * 24 * 365
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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Discount No errors.
App\Entity\Comment No errors.
App\Entity\Wishlist No errors.
App\Entity\Order No errors.