http://www.test.dombusin.com/uk/comments?start=600

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
52.43 ms
(16.53%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 14823 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
39.99 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:
[
  32141
]
31.55 ms
(9.95%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31949 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
29.88 ms
(9.42%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 32151 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
20.17 ms
(6.36%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30680 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
16.36 ms
(5.16%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 25825 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
9.61 ms
(3.03%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30620 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
8.88 ms
(2.80%)
2
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 29677 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
7.17 ms
(2.26%)
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 600
Parameters:
[]
6.81 ms
(2.15%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 12955 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
5.48 ms
(1.73%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 8541 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.92 ms
(1.55%)
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:
[
  1082
  1080
  1081
  1079
  1078
  1077
  1076
  1075
  1074
  1073
  1072
  1071
  1070
  1069
  1068
  1067
  1066
  1065
  1064
  1063
  1062
  1061
  1060
  1059
  1058
  1057
  1056
  1055
  1054
  1053
  1052
  1050
  1051
  1049
  1048
  1047
  1046
  1045
  1044
  1043
  1042
  1041
  1040
  1039
  1038
  1036
  1035
  1037
  1034
  1033
]
4.91 ms
(1.55%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31956 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.68 ms
(1.47%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 26292 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.44 ms
(1.40%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30927 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
4.44 ms
(1.40%)
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
]
3.69 ms
(1.16%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30758 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.51 ms
(1.11%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31347 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.26 ms
(1.03%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 21815 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
3.09 ms
(0.97%)
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.98 ms
(0.94%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 19816 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.86 ms
(0.90%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31170 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.80 ms
(0.88%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 19377 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.60 ms
(0.82%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 24999 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.53 ms
(0.80%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30719 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.44 ms
(0.77%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 32141 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.30 ms
(0.73%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31422 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.26 ms
(0.71%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30694 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
2.09 ms
(0.66%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30727 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.97 ms
(0.62%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30948 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.94 ms
(0.61%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30802 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.91 ms
(0.60%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31682 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.82 ms
(0.57%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31730 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.75 ms
(0.55%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31656 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.68 ms
(0.53%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31240 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.58 ms
(0.50%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31969 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.53 ms
(0.48%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 3848 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.39 ms
(0.44%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31960 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.27 ms
(0.40%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31649 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.26 ms
(0.40%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30843 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.18 ms
(0.37%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31414 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.13 ms
(0.36%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31613 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
1.09 ms
(0.34%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30774 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.95 ms
(0.30%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30794 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.86 ms
(0.27%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 32148 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.85 ms
(0.27%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31399 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.69 ms
(0.22%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 31878 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.55 ms
(0.17%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 27219 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.54 ms
(0.17%)
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.52 ms
(0.16%)
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.52 ms
(0.16%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30507 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.50 ms
(0.16%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30480 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.50 ms
(0.16%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 17390 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.39 ms
(0.12%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30539 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.33 ms
(0.10%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30470 AND 1766217318 - o0_.tstamp < 60 * 60 * 24 * 365
Parameters:
[]
0.30 ms
(0.10%)
1
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.user = 30422 AND 1766217318 - 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.