Query Metrics
58
Database Queries
22
Different statements
284.70 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.26 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_6822dfe21b0c4"
]
|
2 | 2.87 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
]
|
3 | 14.85 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:
[] |
4 | 0.41 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
]
|
5 | 3.90 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_.intname = ? LIMIT 1
Parameters:
[
"catalog/action"
]
|
6 | 2.69 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:
[
52
]
|
7 | 4.80 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:
[] |
8 | 1.57 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:
[] |
9 | 0.25 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:
[
593
]
|
10 | 0.70 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:
[
594
]
|
11 | 2.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:
[
595
]
|
12 | 0.72 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:
[
597
]
|
13 | 0.86 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:
[
596
]
|
14 | 1.35 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:
[
591
]
|
15 | 1.68 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:
[
592
]
|
16 | 0.16 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:
[
589
]
|
17 | 1.43 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:
[
590
]
|
18 | 3.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:
[
598
]
|
19 | 0.15 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:
[
599
]
|
20 | 0.17 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:
[
600
]
|
21 | 3.68 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:
[] |
22 | 0.76 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:
[
587
]
|
23 | 0.41 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:
[
588
]
|
24 | 0.53 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:
[
586
]
|
25 | 2.43 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:
[
585
]
|
26 | 0.14 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:
[
584
]
|
27 | 0.14 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:
[
583
]
|
28 | 0.36 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:
[
582
]
|
29 | 0.34 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:
[
581
]
|
30 | 2.92 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:
[
580
]
|
31 | 0.70 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:
[
579
]
|
32 | 0.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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
578
]
|
33 | 3.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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
577
]
|
34 | 196.45 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:
[] |
35 | 0.43 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:
[
87268
]
|
36 | 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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
38163
]
|
37 | 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:
[
71075
]
|
38 | 0.29 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:
[
85137
]
|
39 | 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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
115189
]
|
40 | 0.17 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:
[
87540
]
|
41 | 0.15 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:
[
114837
]
|
42 | 0.17 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:
[
87562
]
|
43 | 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 prod_translation t0 WHERE t0.object_id = ?
Parameters:
[
60399
]
|
44 | 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:
[
97641
]
|
45 | 0.34 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:
[
115245
]
|
46 | 0.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:
[
87620
]
|
47 | 2.86 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 = 87268
Parameters:
[] |
48 | 3.69 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 = 38163
Parameters:
[] |
49 | 8.86 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 = 71075
Parameters:
[] |
50 | 0.63 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 = 85137
Parameters:
[] |
51 | 0.52 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 = 115189
Parameters:
[] |
52 | 0.98 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 = 87540
Parameters:
[] |
53 | 0.28 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 = 114837
Parameters:
[] |
54 | 1.66 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 = 87562
Parameters:
[] |
55 | 0.27 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 = 60399
Parameters:
[] |
56 | 1.07 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 = 97641
Parameters:
[] |
57 | 1.06 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 = 115245
Parameters:
[] |
58 | 0.27 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 = 87620
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Discount | No errors. |
App\Entity\Prod | No errors. |
App\Entity\CartUnsaved | No errors. |
App\Entity\Cart | No errors. |
App\Entity\Wishlist | No errors. |
App\Entity\Page | No errors. |
App\Entity\PagePhoto | No errors. |
App\Entity\PageBlock | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
App\Entity\Translation\PageTranslation | No errors. |
App\Entity\Banner | No errors. |
App\Entity\Translation\ProdTranslation | No errors. |
App\Entity\Photo | No errors. |