https://www.test.dombusin.com/uk

Query Metrics

73 Database Queries
24 Different statements
973.21 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.40 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.cart AS cart_3 FROM cart_unsaved t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  "guest_685685008869e"
]
2 5.50 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.page AS page_3, t0.intname AS intname_4, t0.mainpage AS mainpage_5, t0.name AS name_6, t0.href AS href_7, t0.short AS short_8, t0.cont AS cont_9, t0.prior AS prior_10, t0.visible AS visible_11, t0.title AS title_12, t0.h1 AS h1_13, t0.kw AS kw_14, t0.descr AS descr_15, t0.tstamp AS tstamp_16, t0.icon AS icon_17 FROM PAGE t0 WHERE t0.intname = ? LIMIT 1
Parameters:
[
  "uk"
]
3 8.29 ms
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
]
4 8.05 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.page AS page_2, p0_.intname AS intname_3, p0_.mainpage AS mainpage_4, p0_.name AS name_5, p0_.href AS href_6, p0_.short AS short_7, p0_.cont AS cont_8, p0_.prior AS prior_9, p0_.visible AS visible_10, p0_.title AS title_11, p0_.h1 AS h1_12, p0_.kw AS kw_13, p0_.descr AS descr_14, p0_.tstamp AS tstamp_15, p0_.icon AS icon_16 FROM PAGE p0_ WHERE p0_.mainpage = 1 LIMIT 1
Parameters:
[]
5 5.04 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
6 2.32 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.page AS page_2, p0_.intname AS intname_3, p0_.mainpage AS mainpage_4, p0_.name AS name_5, p0_.href AS href_6, p0_.short AS short_7, p0_.cont AS cont_8, p0_.prior AS prior_9, p0_.visible AS visible_10, p0_.title AS title_11, p0_.h1 AS h1_12, p0_.kw AS kw_13, p0_.descr AS descr_14, p0_.tstamp AS tstamp_15, p0_.icon AS icon_16 FROM PAGE p0_ WHERE p0_.type = 'page' AND p0_.intname = ? LIMIT 1
Parameters:
[
  "catalog/action"
]
7 3.57 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  565
]
8 2.29 ms
SELECT b0_.id AS id_0, b0_.page AS page_1, b0_.position AS position_2, b0_.href AS href_3, b0_.cont AS cont_4, b0_.visible AS visible_5, b0_.prior AS prior_6 FROM banner b0_ WHERE b0_.visible = 1 ORDER BY b0_.prior DESC
Parameters:
[]
9 1.36 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  948
]
10 8.06 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  949
]
11 0.56 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  950
]
12 0.20 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  951
]
13 0.18 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  952
]
14 0.19 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  953
]
15 0.18 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  959
]
16 0.20 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  956
]
17 0.20 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  961
]
18 0.21 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  960
]
19 0.17 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  958
]
20 0.17 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  955
]
21 0.20 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  954
]
22 0.19 ms
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[
  "uk"
  957
]
23 0.60 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.page AS page_2, p0_.intname AS intname_3, p0_.mainpage AS mainpage_4, p0_.name AS name_5, p0_.href AS href_6, p0_.short AS short_7, p0_.cont AS cont_8, p0_.prior AS prior_9, p0_.visible AS visible_10, p0_.title AS title_11, p0_.h1 AS h1_12, p0_.kw AS kw_13, p0_.descr AS descr_14, p0_.tstamp AS tstamp_15, p0_.icon AS icon_16 FROM PAGE p0_ WHERE p0_.type = 'actions' AND p0_.visible = 1 ORDER BY p0_.tstamp DESC LIMIT 12
Parameters:
[]
24 5.83 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  613
]
25 0.24 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  614
]
26 0.19 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  615
]
27 0.20 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  616
]
28 0.18 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  617
]
29 0.20 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  618
]
30 0.23 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  611
]
31 0.21 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  609
]
32 0.19 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  612
]
33 0.19 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  610
]
34 2.90 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  619
]
35 3.63 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  620
]
36 0.58 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.page AS page_2, p0_.intname AS intname_3, p0_.mainpage AS mainpage_4, p0_.name AS name_5, p0_.href AS href_6, p0_.short AS short_7, p0_.cont AS cont_8, p0_.prior AS prior_9, p0_.visible AS visible_10, p0_.title AS title_11, p0_.h1 AS h1_12, p0_.kw AS kw_13, p0_.descr AS descr_14, p0_.tstamp AS tstamp_15, p0_.icon AS icon_16 FROM PAGE p0_ WHERE p0_.type = 'newactions' AND p0_.visible = 1 ORDER BY p0_.tstamp DESC LIMIT 12
Parameters:
[]
37 0.26 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  621
]
38 0.21 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  622
]
39 0.21 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  623
]
40 0.31 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  624
]
41 0.23 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  625
]
42 3.03 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  626
]
43 2.89 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  627
]
44 0.33 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  628
]
45 0.27 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  629
]
46 0.22 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  630
]
47 0.21 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  631
]
48 0.22 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  632
]
49 802.37 ms
SELECT p0_.id AS id_0, p0_.cat AS cat_1, p0_.intname AS intname_2, p0_.name AS name_3, p0_.art AS art_4, p0_.short AS short_5, p0_.cont AS cont_6, p0_.price AS price_7, p0_.price2 AS price2_8, p0_.price3 AS price3_9, p0_.price4 AS price4_10, p0_.priceopt AS priceopt_11, p0_.priceopt2 AS priceopt2_12, p0_.priceopt3 AS priceopt3_13, p0_.priceopt4 AS priceopt4_14, p0_.skidka AS skidka_15, p0_.skidka2 AS skidka2_16, p0_.skidka3 AS skidka3_17, p0_.skidka4 AS skidka4_18, p0_.skidkaopt AS skidkaopt_19, p0_.skidkaopt2 AS skidkaopt2_20, p0_.skidkaopt3 AS skidkaopt3_21, p0_.skidkaopt4 AS skidkaopt4_22, p0_.numdiscount AS numdiscount_23, p0_.numdiscount2 AS numdiscount2_24, p0_.numdiscount3 AS numdiscount3_25, p0_.numdiscount4 AS numdiscount4_26, p0_.numdiscountopt AS numdiscountopt_27, p0_.numdiscountopt2 AS numdiscountopt2_28, p0_.numdiscountopt3 AS numdiscountopt3_29, p0_.numdiscountopt4 AS numdiscountopt4_30, p0_.num AS num_31, p0_.num2 AS num2_32, p0_.num3 AS num3_33, p0_.num4 AS num4_34, p0_.inpack AS inpack_35, p0_.inpack2 AS inpack2_36, p0_.inpack3 AS inpack3_37, p0_.inpack4 AS inpack4_38, p0_.weight AS weight_39, p0_.weight2 AS weight2_40, p0_.weight3 AS weight3_41, p0_.weight4 AS weight4_42, p0_.visible AS visible_43, p0_.pop AS pop_44, p0_.action AS action_45, p0_.mix AS mix_46, p0_.main AS main_47, p0_.new AS new_48, p0_.sale AS sale_49, p0_.onsale AS onsale_50, p0_.prior AS prior_51, p0_.title AS title_52, p0_.descr AS descr_53, p0_.kw AS kw_54, p0_.h1 AS h1_55, p0_.rating AS rating_56, p0_.spec AS spec_57, p0_.ordered AS ordered_58, p0_.izm AS izm_59, p0_.pic AS pic_60, p0_.views AS views_61, p0_.justuploaded AS justuploaded_62, p0_.uploaded AS uploaded_63, p0_.changed AS changed_64, p0_.colors AS colors_65, p0_.sku AS sku_66, p0_.model AS model_67, p0_.chars AS chars_68, p0_.tags AS tags_69, p0_.external_id AS external_id_70 FROM prod p0_ WHERE p0_.visible = 1 AND p0_.skidka > 0 AND (p0_.num <> 0 OR p0_.num2 <> 0 OR p0_.num3 <> 0) ORDER BY p0_.changed DESC LIMIT 12
Parameters:
[]
50 9.88 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  71798
]
51 19.47 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  78251
]
52 14.30 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  110957
]
53 14.31 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  35060
]
54 0.22 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  35061
]
55 0.19 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  35062
]
56 16.99 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  71510
]
57 1.61 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  71511
]
58 0.22 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  71512
]
59 4.55 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  71650
]
60 3.67 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  35063
]
61 5.62 ms
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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
  71523
]
62 0.48 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 71798
Parameters:
[]
63 0.42 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 78251
Parameters:
[]
64 0.41 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 110957
Parameters:
[]
65 0.34 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 35060
Parameters:
[]
66 0.39 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 35061
Parameters:
[]
67 0.46 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 35062
Parameters:
[]
68 0.53 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 71510
Parameters:
[]
69 0.40 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 71511
Parameters:
[]
70 0.51 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 71512
Parameters:
[]
71 0.37 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 71650
Parameters:
[]
72 1.82 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 35063
Parameters:
[]
73 0.39 ms
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.par AS par_2, p0_.name AS name_3, p0_.prior AS prior_4, p0_.visible AS visible_5 FROM photo p0_ WHERE p0_.type = 'prod' AND p0_.par = 71523
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.