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

Query Metrics

103 Database Queries
52 Different statements
380.01 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
107.78 ms
(28.36%)
47
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:
[
  1670
]
52.79 ms
(13.89%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9508 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
19.17 ms
(5.04%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 8894 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
17.11 ms
(4.50%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 7063 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
14.87 ms
(3.91%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 837 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
14.27 ms
(3.75%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9202 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
13.69 ms
(3.60%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 2751 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
12.29 ms
(3.23%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 2134 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
11.45 ms
(3.01%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9145 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
10.12 ms
(2.66%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9214 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
9.17 ms
(2.41%)
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:
[]
7.94 ms
(2.09%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9385 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.32 ms
(1.93%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 3501 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.86 ms
(1.81%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9306 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.35 ms
(1.67%)
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 1350
Parameters:
[]
6.30 ms
(1.66%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9424 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
5.72 ms
(1.50%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 8776 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
5.67 ms
(1.49%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9488 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
5.56 ms
(1.46%)
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:
[
  133
  132
  130
  129
  128
  127
  126
  125
  121
  123
  122
  119
  120
  115
  116
  117
  114
  113
  112
  111
  110
  109
  108
  107
  106
  104
  105
  102
  103
  99
  101
  100
  98
  96
  95
  97
  94
  93
  92
  91
  89
  88
  87
  86
  85
  84
  83
  82
  81
  79
]
4.73 ms
(1.25%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9760 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.82 ms
(1.00%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 1670 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.52 ms
(0.93%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 4562 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.03 ms
(0.80%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 8658 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.67 ms
(0.70%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 3652 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.31 ms
(0.61%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9298 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.15 ms
(0.56%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9460 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.99 ms
(0.52%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 8409 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.94 ms
(0.51%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9342 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.92 ms
(0.51%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 224 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.58 ms
(0.42%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9270 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.43 ms
(0.38%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9392 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.33 ms
(0.35%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9340 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.27 ms
(0.33%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9117 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.04 ms
(0.27%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9819 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.95 ms
(0.25%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 1483 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.90 ms
(0.24%)
2
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 8889 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.84 ms
(0.22%)
2
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9701 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.77 ms
(0.20%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9490 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.75 ms
(0.20%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9237 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.70 ms
(0.18%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9659 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.66 ms
(0.17%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9556 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.64 ms
(0.17%)
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.58 ms
(0.15%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9517 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.56 ms
(0.15%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9804 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.53 ms
(0.14%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9629 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.52 ms
(0.14%)
2
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 6064 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.51 ms
(0.13%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9310 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.49 ms
(0.13%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9834 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.45 ms
(0.12%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9637 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.35 ms
(0.09%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9516 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.32 ms
(0.09%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 6985 AND 1754500857 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.32 ms
(0.08%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9391 AND 1754500857 - 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.