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

Query Metrics

104 Database Queries
55 Different statements
409.08 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
83.44 ms
(20.40%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36623 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
32.87 ms
(8.04%)
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.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:
[
  37665
]
28.45 ms
(6.95%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 2045 AND 1765933322 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
23.17 ms
(5.66%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37472 AND 1765933322 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
17.47 ms
(4.27%)
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 450
Parameters:
[]
14.36 ms
(3.51%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36040 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
12.92 ms
(3.16%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36824 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
12.17 ms
(2.97%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36848 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
12.05 ms
(2.94%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35954 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
11.83 ms
(2.89%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36865 AND 1765933322 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
11.73 ms
(2.87%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36899 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
10.52 ms
(2.57%)
2
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36402 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
10.20 ms
(2.49%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36741 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
10.01 ms
(2.45%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36053 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
9.75 ms
(2.38%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35811 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
9.60 ms
(2.35%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35913 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
8.50 ms
(2.08%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37032 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.66 ms
(1.87%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37059 AND 1765933322 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.56 ms
(1.85%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35910 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.07 ms
(1.73%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36793 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.72 ms
(1.64%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37091 AND 1765933322 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
6.04 ms
(1.48%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36444 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
5.81 ms
(1.42%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36910 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
5.19 ms
(1.27%)
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:
[]
4.91 ms
(1.20%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 34987 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.42 ms
(1.08%)
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:
[
  1253
  1252
  1250
  1249
  1246
  1248
  1245
  1247
  1244
  1240
  1238
  1242
  1241
  1237
  1234
  1236
  1235
  1231
  1230
  1229
  1233
  1227
  1228
  1226
  1225
  1224
  1223
  1222
  1220
  1219
  1218
  1217
  1216
  1215
  1214
  1213
  1212
  1211
  1210
  1209
  1208
  1207
  1205
  1204
  1203
  1202
  1201
  1200
  1199
  1197
]
4.15 ms
(1.01%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35861 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.78 ms
(0.92%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 32578 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.33 ms
(0.82%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37318 AND 1765933322 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.26 ms
(0.80%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36483 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.27 ms
(0.55%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36240 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.18 ms
(0.53%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35047 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.03 ms
(0.50%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36948 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.86 ms
(0.46%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36876 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.04 ms
(0.25%)
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.94 ms
(0.23%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36866 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.79 ms
(0.19%)
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.71 ms
(0.17%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37315 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.71 ms
(0.17%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36865 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.69 ms
(0.17%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37059 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.67 ms
(0.16%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35792 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.63 ms
(0.15%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 34702 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.61 ms
(0.15%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37665 AND 1765933322 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.60 ms
(0.15%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36970 AND 1765933323 - 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 = 37435 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.50 ms
(0.12%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37205 AND 1765933322 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.46 ms
(0.11%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37328 AND 1765933322 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.45 ms
(0.11%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36002 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.44 ms
(0.11%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36367 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.42 ms
(0.10%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 36432 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.38 ms
(0.09%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 37597 AND 1765933322 - 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 = 35602 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.31 ms
(0.08%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35064 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.30 ms
(0.07%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35809 AND 1765933323 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.29 ms
(0.07%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 35491 AND 1765933323 - 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.