https://test.dombusin.com/comments?start=400

Query Metrics

106 Database Queries
55 Different statements
735.78 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
249.32 ms
(33.88%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 34257 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
241.13 ms
(32.77%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 19816 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
64.10 ms
(8.71%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38810 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
23.63 ms
(3.21%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 39006 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
22.55 ms
(3.06%)
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:
[
  31283
]
13.80 ms
(1.88%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31283 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
11.25 ms
(1.53%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38628 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
10.35 ms
(1.41%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35326 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
8.03 ms
(1.09%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38041 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.49 ms
(1.02%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38024 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.22 ms
(0.98%)
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 400
Parameters:
[]
6.76 ms
(0.92%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37829 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
5.38 ms
(0.73%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 23797 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.99 ms
(0.68%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37499 AND 1765906196 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.86 ms
(0.66%)
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:
[
  1303
  1304
  1305
  1302
  1301
  1300
  1298
  1299
  1297
  1296
  1295
  1294
  1293
  1292
  1291
  1290
  1289
  1288
  1286
  1285
  1283
  1284
  1282
  1281
  1280
  1278
  1277
  1276
  1275
  1274
  1273
  1272
  1271
  1270
  1269
  1268
  1267
  1266
  1264
  1263
  1262
  1261
  1260
  1259
  1258
  1257
  1256
  1254
  1255
  1251
]
4.71 ms
(0.64%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38232 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.00 ms
(0.54%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37810 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.44 ms
(0.47%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37597 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.23 ms
(0.44%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38554 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.66 ms
(0.36%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38282 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.57 ms
(0.35%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35792 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.44 ms
(0.33%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38966 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.40 ms
(0.33%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37982 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.20 ms
(0.30%)
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:
[]
2.04 ms
(0.28%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37894 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.83 ms
(0.25%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 34315 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.56 ms
(0.21%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37912 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.54 ms
(0.21%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37555 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.39 ms
(0.19%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37721 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.30 ms
(0.18%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37434 AND 1765906196 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.20 ms
(0.16%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 22076 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.98 ms
(0.13%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38793 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.96 ms
(0.13%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38060 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.96 ms
(0.13%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37560 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.87 ms
(0.12%)
2
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37940 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.81 ms
(0.11%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37419 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.80 ms
(0.11%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38714 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.78 ms
(0.11%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38321 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.78 ms
(0.11%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37238 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.77 ms
(0.11%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37839 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.76 ms
(0.10%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37827 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.74 ms
(0.10%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 39123 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.71 ms
(0.10%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38005 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.68 ms
(0.09%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37328 AND 1765906196 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.68 ms
(0.09%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37650 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.68 ms
(0.09%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37814 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.66 ms
(0.09%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38353 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.57 ms
(0.08%)
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.55 ms
(0.07%)
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.54 ms
(0.07%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38995 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.50 ms
(0.07%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38269 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.46 ms
(0.06%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38832 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.46 ms
(0.06%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38303 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.45 ms
(0.06%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 38281 AND 1765906195 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.25 ms
(0.03%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37760 AND 1765906195 - 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.