Query Metrics
94
Database Queries
26
Different statements
503.73 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
243.07 ms (48.25%) |
1 |
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_.skidka > 0 AND (p0_.num <> 0 OR p0_.num2 <> 0 OR p0_.num3 <> 0) ORDER BY p0_.changed DESC LIMIT 12
Parameters:
[] |
166.08 ms (32.97%) |
12 |
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:
[
85383
]
|
30.97 ms (6.15%) |
26 |
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 opt_page_translation t0 WHERE t0.object_id = ?
Parameters:
[
1
]
|
15.34 ms (3.04%) |
12 |
SELECT b0_.content AS content_0, b0_.field AS field_1 FROM banner_translation b0_ WHERE b0_.locale = ? AND b0_.object_id = ?
Parameters:
[ "pl" 821 ] |
8.81 ms (1.75%) |
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
]
|
5.68 ms (1.13%) |
1 |
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_68f3477d6892f"
]
|
5.24 ms (1.04%) |
1 |
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 = 69837
Parameters:
[] |
5.01 ms (1.00%) |
1 |
SELECT t0.id AS id_1, t0.page AS page_2, t0.position AS position_3, t0.href AS href_4, t0.cont AS cont_5, t0.visible AS visible_6, t0.prior AS prior_7 FROM opt_banner t0 WHERE t0.visible = ? ORDER BY t0.prior DESC
Parameters:
[
1
]
|
4.74 ms (0.94%) |
1 |
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 = 47603
Parameters:
[] |
3.86 ms (0.77%) |
1 |
SELECT t0.id AS id_1, t0.oldurl AS oldurl_2, t0.newurl AS newurl_3 FROM redirect t0
Parameters:
[] |
3.78 ms (0.75%) |
1 |
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 = 93422
Parameters:
[] |
1.43 ms (0.28%) |
1 |
SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.page AS page_2, o0_.intname AS intname_3, o0_.mainpage AS mainpage_4, o0_.name AS name_5, o0_.href AS href_6, o0_.short AS short_7, o0_.cont AS cont_8, o0_.prior AS prior_9, o0_.visible AS visible_10, o0_.title AS title_11, o0_.h1 AS h1_12, o0_.kw AS kw_13, o0_.descr AS descr_14, o0_.tstamp AS tstamp_15, o0_.icon AS icon_16 FROM opt_page o0_ WHERE o0_.type = 'actions' AND o0_.visible = 1 ORDER BY o0_.tstamp DESC LIMIT 12
Parameters:
[] |
1.08 ms (0.21%) |
1 |
SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.page AS page_2, o0_.intname AS intname_3, o0_.mainpage AS mainpage_4, o0_.name AS name_5, o0_.href AS href_6, o0_.short AS short_7, o0_.cont AS cont_8, o0_.prior AS prior_9, o0_.visible AS visible_10, o0_.title AS title_11, o0_.h1 AS h1_12, o0_.kw AS kw_13, o0_.descr AS descr_14, o0_.tstamp AS tstamp_15, o0_.icon AS icon_16 FROM opt_page o0_ WHERE o0_.type = 'newactions' AND o0_.visible = 1 ORDER BY o0_.tstamp DESC LIMIT 12
Parameters:
[] |
0.92 ms (0.18%) |
1 |
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 = 42906
Parameters:
[] |
0.92 ms (0.18%) |
1 |
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 = 85383
Parameters:
[] |
0.89 ms (0.18%) |
1 |
SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.page AS page_2, o0_.intname AS intname_3, o0_.mainpage AS mainpage_4, o0_.name AS name_5, o0_.href AS href_6, o0_.short AS short_7, o0_.cont AS cont_8, o0_.prior AS prior_9, o0_.visible AS visible_10, o0_.title AS title_11, o0_.h1 AS h1_12, o0_.kw AS kw_13, o0_.descr AS descr_14, o0_.tstamp AS tstamp_15, o0_.icon AS icon_16 FROM opt_page o0_ WHERE o0_.type = 'page' AND o0_.intname = ? LIMIT 1
Parameters:
[
"catalog/action"
]
|
0.73 ms (0.15%) |
1 |
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 = 121129
Parameters:
[] |
0.71 ms (0.14%) |
1 |
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 = 77998
Parameters:
[] |
0.70 ms (0.14%) |
1 |
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 = 73087
Parameters:
[] |
0.63 ms (0.12%) |
1 |
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 = 96795
Parameters:
[] |
0.61 ms (0.12%) |
1 |
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 = 38938
Parameters:
[] |
0.58 ms (0.11%) |
1 |
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 = 115098
Parameters:
[] |
0.56 ms (0.11%) |
1 |
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 = 36940
Parameters:
[] |
0.54 ms (0.11%) |
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.53 ms (0.11%) |
1 |
SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.page AS page_2, o0_.intname AS intname_3, o0_.mainpage AS mainpage_4, o0_.name AS name_5, o0_.href AS href_6, o0_.short AS short_7, o0_.cont AS cont_8, o0_.prior AS prior_9, o0_.visible AS visible_10, o0_.title AS title_11, o0_.h1 AS h1_12, o0_.kw AS kw_13, o0_.descr AS descr_14, o0_.tstamp AS tstamp_15, o0_.icon AS icon_16 FROM opt_page o0_ WHERE o0_.mainpage = 1 LIMIT 1
Parameters:
[] |
0.35 ms (0.07%) |
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
]
|
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\Redirect | No errors. |
App\Entity\Prod | No errors. |
App\Entity\CartUnsaved | No errors. |
App\Entity\Cart | No errors. |
App\Entity\Page | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
App\Entity\Translation\PageTranslation | No errors. |
App\Entity\Banner | No errors. |
App\Entity\Order | No errors. |
App\Entity\Sett | No errors. |
App\Entity\Translation\SettTranslation | No errors. |
App\Entity\Template | No errors. |
App\Entity\Translation\TemplateTranslation | No errors. |
App\Entity\Timer | No errors. |
App\Entity\Translation\TimerTranslation | No errors. |
App\Entity\Transaction | No errors. |
App\Entity\Block | No errors. |
App\Entity\Translation\BlockTranslation | No errors. |
App\Entity\Wishlist | No errors. |
App\Entity\PagePhoto | No errors. |
App\Entity\PageBlock | No errors. |
App\Entity\Translation\BannerTranslation | No errors. |
App\Entity\Translation\ProdTranslation | No errors. |
App\Entity\Photo | No errors. |