https://test.dombusin.com/cart

Query Metrics

27 Database Queries
14 Different statements
127.33 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 21.66 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_693e52058c2b3"
]
2 0.66 ms
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:
[]
3 0.67 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 29.60 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_693e52059b770"
]
5 0.70 ms
select d.id as id, d.intname as intname, d.name as name, d.cont as cont, d.prior as prior, d.fields as fields, 0 as cost
            from delivery as d
            where d.visible = 1 or d.visible = 3 order by d.prior desc, d.name
Parameters:
[]
6 0.42 ms
SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.cont AS cont_4, t0.prior AS prior_5, t0.price AS price_6, t0.fields AS fields_7, t0.visible AS visible_8 FROM delivery t0 WHERE t0.id IN (?) ORDER BY t0.prior DESC
Parameters:
[
  14
]
7 0.51 ms
SELECT t0.id AS id_1, t0.delivery AS delivery_2, t0.name AS name_3, t0.code AS code_4, t0.fields AS fields_5, t0.visible AS visible_6, t0.prior AS prior_7 FROM subdelivery t0 WHERE t0.delivery = ?
Parameters:
[
  14
]
8 33.72 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_.selection1 AS selection1_51, p0_.selection2 AS selection2_52, p0_.prior AS prior_53, p0_.title AS title_54, p0_.descr AS descr_55, p0_.kw AS kw_56, p0_.h1 AS h1_57, p0_.rating AS rating_58, p0_.spec AS spec_59, p0_.ordered AS ordered_60, p0_.izm AS izm_61, p0_.pic AS pic_62, p0_.views AS views_63, p0_.justuploaded AS justuploaded_64, p0_.uploaded AS uploaded_65, p0_.changed AS changed_66, p0_.colors AS colors_67, p0_.sku AS sku_68, p0_.model AS model_69, p0_.chars AS chars_70, p0_.tags AS tags_71, p0_.external_id AS external_id_72 FROM prod p0_ WHERE p0_.visible = 1 AND p0_.new = 1 AND (p0_.num > 0 OR p0_.num2 > 0 OR p0_.num3 > 0) LIMIT 6
Parameters:
[]
9 2.02 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_.selection1 AS selection1_51, p0_.selection2 AS selection2_52, p0_.prior AS prior_53, p0_.title AS title_54, p0_.descr AS descr_55, p0_.kw AS kw_56, p0_.h1 AS h1_57, p0_.rating AS rating_58, p0_.spec AS spec_59, p0_.ordered AS ordered_60, p0_.izm AS izm_61, p0_.pic AS pic_62, p0_.views AS views_63, p0_.justuploaded AS justuploaded_64, p0_.uploaded AS uploaded_65, p0_.changed AS changed_66, p0_.colors AS colors_67, p0_.sku AS sku_68, p0_.model AS model_69, p0_.chars AS chars_70, p0_.tags AS tags_71, p0_.external_id AS external_id_72 FROM prod p0_ WHERE p0_.visible = 1 AND p0_.pop = 1 AND (p0_.num > 0 OR p0_.num2 > 0 OR p0_.num3 > 0) LIMIT 6
Parameters:
[]
10 0.74 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:
[
  "cart"
]
11 3.11 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.page AS page_2, a0_.intname AS intname_3, a0_.mainpage AS mainpage_4, a0_.name AS name_5, a0_.href AS href_6, a0_.short AS short_7, a0_.cont AS cont_8, a0_.prior AS prior_9, a0_.visible AS visible_10, a0_.title AS title_11, a0_.h1 AS h1_12, a0_.kw AS kw_13, a0_.descr AS descr_14, a0_.tstamp AS tstamp_15, a0_.icon AS icon_16 FROM article a0_ WHERE a0_.visible = 1 AND a0_.type = 'article' ORDER BY a0_.tstamp DESC) dctrn_result) dctrn_table
Parameters:
[]
12 29.12 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_693e5205bfab5"
]
13 0.26 ms
"START TRANSACTION"
Parameters:
[]
14 0.41 ms
INSERT INTO cart_unsaved (user_id, cart) VALUES (?, ?)
Parameters:
[
  "guest_693e5205bfab5"
  "[]"
]
15 0.40 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1761963222"
  12922
]
16 0.24 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1761962930"
  30981
]
17 0.23 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1764554458"
  75547
]
18 0.26 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1761962429"
  78050
]
19 0.22 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1764554420"
  114297
]
20 0.21 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1763258422"
  114385
]
21 0.25 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1761963288"
  405
]
22 0.20 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1763259255"
  531
]
23 0.18 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1763259255"
  537
]
24 0.17 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1763259254"
  549
]
25 0.17 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1763259254"
  550
]
26 0.16 ms
UPDATE prod SET spec = ? WHERE id = ?
Parameters:
[
  "1763259254"
  559
]
27 1.01 ms
"COMMIT"
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.