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

Query Metrics

128 Database Queries
56 Different statements
170.57 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
27.24 ms
(15.97%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 10217 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
21.51 ms
(12.61%)
49
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.ads AS ads_30, t0.lastordertime AS lastordertime_31, t0.ordersum AS ordersum_32, t0.ordernum AS ordernum_33, t0.external_id AS external_id_34, t0.company_nip AS company_nip_35, t0.company_name AS company_name_36, t0.company_index AS company_index_37, t0.company_city AS company_city_38, t0.company_street AS company_street_39, t0.company_house AS company_house_40, t0.company_flat AS company_flat_41 FROM user t0 WHERE t0.id = ?
Parameters:
[
  14923
]
17.90 ms
(10.49%)
22
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM block_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
15.38 ms
(9.02%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 2543 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.47 ms
(4.38%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13032 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.64 ms
(3.89%)
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 1200
Parameters:
[]
5.34 ms
(3.13%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 14941 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.30 ms
(2.52%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13134 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.09 ms
(2.40%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13199 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.08 ms
(2.39%)
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:
[]
3.71 ms
(2.17%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13064 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.22 ms
(1.89%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13378 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.18 ms
(1.86%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13893 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.14 ms
(1.84%)
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:
[
  395
  391
  390
  394
  393
  389
  386
  385
  384
  383
  380
  382
  381
  378
  377
  376
  375
  374
  372
  373
  369
  370
  368
  367
  365
  364
  362
  363
  361
  359
  357
  358
  356
  354
  350
  352
  349
  344
  346
  342
  341
  339
  338
  336
  331
  329
  326
  325
  322
  321
]
2.26 ms
(1.32%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9749 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.23 ms
(1.31%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 14828 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.13 ms
(1.25%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13467 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.06 ms
(1.21%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 9012 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.83 ms
(1.07%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 7870 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.75 ms
(1.03%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13541 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.64 ms
(0.96%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 14907 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.63 ms
(0.96%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13066 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.62 ms
(0.95%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 11610 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.61 ms
(0.94%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 6389 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.60 ms
(0.94%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 14904 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.36 ms
(0.80%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13271 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.36 ms
(0.80%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13867 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.33 ms
(0.78%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 14923 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.31 ms
(0.77%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13678 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.22 ms
(0.71%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13787 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.21 ms
(0.71%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13257 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.20 ms
(0.70%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13630 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.06 ms
(0.62%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13203 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.01 ms
(0.59%)
2
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13098 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.97 ms
(0.57%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13560 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.76 ms
(0.44%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13809 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.75 ms
(0.44%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 14866 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.74 ms
(0.43%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13088 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.68 ms
(0.40%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13223 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.65 ms
(0.38%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13402 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.62 ms
(0.36%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13183 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.57 ms
(0.33%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13465 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.57 ms
(0.33%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13615 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.54 ms
(0.31%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13754 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.52 ms
(0.31%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13057 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.48 ms
(0.28%)
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:
[]
0.48 ms
(0.28%)
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.48 ms
(0.28%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13800 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.48 ms
(0.28%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13475 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.46 ms
(0.27%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13848 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.44 ms
(0.26%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13544 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.43 ms
(0.25%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13568 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.43 ms
(0.25%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13877 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.41 ms
(0.24%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13452 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.26 ms
(0.15%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13796 AND 1765843417 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.24 ms
(0.14%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 13604 AND 1765843417 - 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.