https://www.dombusin.com/comments?start=1250

Query Metrics

104 Database Queries
54 Different statements
538.94 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
158.55 ms
(29.42%)
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:
[
  12953
]
43.95 ms
(8.15%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12202 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
38.05 ms
(7.06%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11481 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
28.00 ms
(5.20%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12955 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
21.58 ms
(4.00%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12338 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
19.33 ms
(3.59%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9953 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
17.46 ms
(3.24%)
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:
[
  310
  306
  305
  304
  303
  302
  301
  298
  297
  296
  295
  292
  294
  293
  291
  289
  290
  288
  287
  286
  280
  278
  277
  276
  275
  273
  274
  271
  270
  268
  269
  265
  264
  263
  262
  261
  259
  260
  256
  258
  255
  253
  251
  250
  249
  247
  245
  243
  241
  236
]
17.04 ms
(3.16%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12847 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
15.14 ms
(2.81%)
2
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12514 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
12.83 ms
(2.38%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12638 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
10.37 ms
(1.92%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12861 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
9.62 ms
(1.78%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 10968 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
9.19 ms
(1.70%)
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:
[]
8.56 ms
(1.59%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12752 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
8.53 ms
(1.58%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12774 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
8.25 ms
(1.53%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12465 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
8.16 ms
(1.51%)
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
]
7.33 ms
(1.36%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11271 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.29 ms
(1.35%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 8585 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.21 ms
(1.34%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12239 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.16 ms
(1.33%)
2
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12444 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.79 ms
(1.26%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12213 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.74 ms
(1.25%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12251 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.52 ms
(1.21%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12216 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.08 ms
(1.13%)
1
SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.value AS value_4 FROM block t0
Parameters:
[]
5.55 ms
(1.03%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12953 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.68 ms
(0.87%)
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 1250
Parameters:
[]
4.09 ms
(0.76%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12254 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.04 ms
(0.75%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12255 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.69 ms
(0.69%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12892 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.52 ms
(0.47%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12688 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.48 ms
(0.46%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12905 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.33 ms
(0.43%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11532 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.32 ms
(0.43%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12274 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.97 ms
(0.37%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12269 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.72 ms
(0.32%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12496 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.47 ms
(0.27%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12300 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.45 ms
(0.27%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12397 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.20 ms
(0.22%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12218 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.19 ms
(0.22%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12889 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.19 ms
(0.22%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12834 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.11 ms
(0.21%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12661 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.10 ms
(0.20%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12408 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.74 ms
(0.14%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12624 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.64 ms
(0.12%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12627 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.58 ms
(0.11%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12242 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.47 ms
(0.09%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12465 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.46 ms
(0.08%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12791 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.45 ms
(0.08%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12248 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.44 ms
(0.08%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12515 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.41 ms
(0.08%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12880 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.35 ms
(0.07%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12432 AND 1756337211 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.33 ms
(0.06%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12179 AND 1756337212 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.25 ms
(0.05%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12471 AND 1756337212 - 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.