GET https://vitel.alexsuleymanov.com/ua/product/ks-128-nozhic-of-s-tm-kangaro-128mmblister

Query Metrics

93 Database Queries
13 Different statements
9.65 ms Query time
4 Invalid entities
78 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
3.05 ms
(31.66%)
1
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.brand AS brand_3, t0.intname AS intname_4, t0.name AS name_5, t0.code AS code_6, t0.code_pack AS code_pack_7, t0.art AS art_8, t0.short AS short_9, t0.cont AS cont_10, t0.price AS price_11, t0.price_usd AS price_usd_12, t0.price_eur AS price_eur_13, t0.pricedistr AS pricedistr_14, t0.pricediller AS pricediller_15, t0.priceopt AS priceopt_16, t0.pricesmallopt AS pricesmallopt_17, t0.course AS course_18, t0.oldprice AS oldprice_19, t0.discount AS discount_20, t0.num AS num_21, t0.weight AS weight_22, t0.volume AS volume_23, t0.packing AS packing_24, t0.packing_base AS packing_base_25, t0.points AS points_26, t0.avail AS avail_27, t0.income AS income_28, t0.rating AS rating_29, t0.inprice AS inprice_30, t0.pop AS pop_31, t0.action AS action_32, t0.mix AS mix_33, t0.main AS main_34, t0.new AS new_35, t0.sale AS sale_36, t0.onsale AS onsale_37, t0.visible AS visible_38, t0.prior AS prior_39, t0.title AS title_40, t0.descr AS descr_41, t0.kw AS kw_42, t0.h1 AS h1_43, t0.spec AS spec_44, t0.pic AS pic_45, t0.pic1 AS pic1_46, t0.pic2 AS pic2_47, t0.pic3 AS pic3_48, t0.pic4 AS pic4_49, t0.pic5 AS pic5_50, t0.changed AS changed_51, t0.recommend AS recommend_52, t0.noindex AS noindex_53 FROM prod t0 WHERE t0.intname = ? LIMIT 1
Parameters:
[
  "ks-128-nozhic-of-s-tm-kangaro-128mmblister"
]
2.61 ms
(27.09%)
62
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 cat_translation t0 WHERE t0.object_id = ?
Parameters:
[
  739730
]
1.84 ms
(19.11%)
1
SELECT p0_.id AS id_0, p0_.cat AS cat_1, p0_.brand AS brand_2, p0_.intname AS intname_3, p0_.name AS name_4, p0_.code AS code_5, p0_.code_pack AS code_pack_6, p0_.art AS art_7, p0_.short AS short_8, p0_.cont AS cont_9, p0_.price AS price_10, p0_.price_usd AS price_usd_11, p0_.price_eur AS price_eur_12, p0_.pricedistr AS pricedistr_13, p0_.pricediller AS pricediller_14, p0_.priceopt AS priceopt_15, p0_.pricesmallopt AS pricesmallopt_16, p0_.course AS course_17, p0_.oldprice AS oldprice_18, p0_.discount AS discount_19, p0_.num AS num_20, p0_.weight AS weight_21, p0_.volume AS volume_22, p0_.packing AS packing_23, p0_.packing_base AS packing_base_24, p0_.points AS points_25, p0_.avail AS avail_26, p0_.income AS income_27, p0_.rating AS rating_28, p0_.inprice AS inprice_29, p0_.pop AS pop_30, p0_.action AS action_31, p0_.mix AS mix_32, p0_.main AS main_33, p0_.new AS new_34, p0_.sale AS sale_35, p0_.onsale AS onsale_36, p0_.visible AS visible_37, p0_.prior AS prior_38, p0_.title AS title_39, p0_.descr AS descr_40, p0_.kw AS kw_41, p0_.h1 AS h1_42, p0_.spec AS spec_43, p0_.pic AS pic_44, p0_.pic1 AS pic1_45, p0_.pic2 AS pic2_46, p0_.pic3 AS pic3_47, p0_.pic4 AS pic4_48, p0_.pic5 AS pic5_49, p0_.changed AS changed_50, p0_.recommend AS recommend_51, p0_.noindex AS noindex_52 FROM prod p0_ WHERE p0_.visible = 1 AND p0_.cat = ? AND p0_.id <> ? ORDER BY p0_.prior DESC LIMIT 8
Parameters:
[
  756239
  754499
]
0.50 ms
(5.21%)
10
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:
[
  754499
]
0.48 ms
(4.98%)
5
SELECT c0_.id AS id_0, c0_.cat AS cat_1, c0_.intname AS intname_2, c0_.name AS name_3, c0_.short AS short_4, c0_.cont AS cont_5, c0_.cont2 AS cont2_6, c0_.prior AS prior_7, c0_.visible AS visible_8, c0_.spec AS spec_9, c0_.newlabel AS newlabel_10, c0_.supercat AS supercat_11, c0_.inprice AS inprice_12, c0_.incatalog AS incatalog_13, c0_.notinxml AS notinxml_14, c0_.title AS title_15, c0_.h1 AS h1_16, c0_.kw AS kw_17, c0_.descr AS descr_18, c0_.pic AS pic_19, c0_.bc AS bc_20, c0_.noindex AS noindex_21 FROM cat c0_ WHERE c0_.visible = 1 AND c0_.cat = ? ORDER BY c0_.prior DESC
Parameters:
[
  739730
]
0.34 ms
(3.54%)
1
SELECT c0_.id AS id_0, c0_.cat AS cat_1, c0_.intname AS intname_2, c0_.name AS name_3, c0_.short AS short_4, c0_.cont AS cont_5, c0_.cont2 AS cont2_6, c0_.prior AS prior_7, c0_.visible AS visible_8, c0_.spec AS spec_9, c0_.newlabel AS newlabel_10, c0_.supercat AS supercat_11, c0_.inprice AS inprice_12, c0_.incatalog AS incatalog_13, c0_.notinxml AS notinxml_14, c0_.title AS title_15, c0_.h1 AS h1_16, c0_.kw AS kw_17, c0_.descr AS descr_18, c0_.pic AS pic_19, c0_.bc AS bc_20, c0_.noindex AS noindex_21 FROM cat c0_ WHERE c0_.supercat = 1 AND c0_.visible = 1 ORDER BY c0_.prior DESC
Parameters:
[]
0.27 ms
(2.75%)
6
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:
[
  236
]
0.12 ms
(1.24%)
1
SELECT p0_.id AS id_0, p0_.page AS page_1, p0_.type AS type_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_.autosub AS autosub_9, p0_.prior AS prior_10, p0_.visible AS visible_11, p0_.main AS main_12, p0_.foot AS foot_13, p0_.title AS title_14, p0_.h1 AS h1_15, p0_.kw AS kw_16, p0_.descr AS descr_17, p0_.tstamp AS tstamp_18, p0_.icon AS icon_19, p0_.topmenu AS topmenu_20, p0_.footmenu AS footmenu_21, p0_.noindex AS noindex_22, p0_.rating AS rating_23 FROM page p0_ WHERE p0_.visible = 1 AND p0_.topmenu = 1 ORDER BY p0_.prior DESC
Parameters:
[]
0.12 ms
(1.23%)
2
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.intname AS intname_3, t0.name AS name_4, t0.short AS short_5, t0.cont AS cont_6, t0.cont2 AS cont2_7, t0.prior AS prior_8, t0.visible AS visible_9, t0.spec AS spec_10, t0.newlabel AS newlabel_11, t0.supercat AS supercat_12, t0.inprice AS inprice_13, t0.incatalog AS incatalog_14, t0.notinxml AS notinxml_15, t0.title AS title_16, t0.h1 AS h1_17, t0.kw AS kw_18, t0.descr AS descr_19, t0.pic AS pic_20, t0.bc AS bc_21, t0.noindex AS noindex_22 FROM cat t0 WHERE t0.id = ?
Parameters:
[
  756239
]
0.09 ms
(0.96%)
1
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.brand AS brand_3, t0.intname AS intname_4, t0.name AS name_5, t0.code AS code_6, t0.code_pack AS code_pack_7, t0.art AS art_8, t0.short AS short_9, t0.cont AS cont_10, t0.price AS price_11, t0.price_usd AS price_usd_12, t0.price_eur AS price_eur_13, t0.pricedistr AS pricedistr_14, t0.pricediller AS pricediller_15, t0.priceopt AS priceopt_16, t0.pricesmallopt AS pricesmallopt_17, t0.course AS course_18, t0.oldprice AS oldprice_19, t0.discount AS discount_20, t0.num AS num_21, t0.weight AS weight_22, t0.volume AS volume_23, t0.packing AS packing_24, t0.packing_base AS packing_base_25, t0.points AS points_26, t0.avail AS avail_27, t0.income AS income_28, t0.rating AS rating_29, t0.inprice AS inprice_30, t0.pop AS pop_31, t0.action AS action_32, t0.mix AS mix_33, t0.main AS main_34, t0.new AS new_35, t0.sale AS sale_36, t0.onsale AS onsale_37, t0.visible AS visible_38, t0.prior AS prior_39, t0.title AS title_40, t0.descr AS descr_41, t0.kw AS kw_42, t0.h1 AS h1_43, t0.spec AS spec_44, t0.pic AS pic_45, t0.pic1 AS pic1_46, t0.pic2 AS pic2_47, t0.pic3 AS pic3_48, t0.pic4 AS pic4_49, t0.pic5 AS pic5_50, t0.changed AS changed_51, t0.recommend AS recommend_52, t0.noindex AS noindex_53 FROM prod t0 WHERE t0.id = ?
Parameters:
[
  758878
]
0.09 ms
(0.89%)
1
SELECT p0_.id AS id_0, p0_.page AS page_1, p0_.type AS type_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_.autosub AS autosub_9, p0_.prior AS prior_10, p0_.visible AS visible_11, p0_.main AS main_12, p0_.foot AS foot_13, p0_.title AS title_14, p0_.h1 AS h1_15, p0_.kw AS kw_16, p0_.descr AS descr_17, p0_.tstamp AS tstamp_18, p0_.icon AS icon_19, p0_.topmenu AS topmenu_20, p0_.footmenu AS footmenu_21, p0_.noindex AS noindex_22, p0_.rating AS rating_23 FROM page p0_ WHERE p0_.visible = 1 AND p0_.footmenu = 1 ORDER BY p0_.prior DESC
Parameters:
[]
0.07 ms
(0.67%)
1
SELECT t0.id AS id_1, t0.author AS author_2, t0.tstamp AS tstamp_3, t0.subj AS subj_4, t0.cont AS cont_5, t0.answer AS answer_6, t0.visible AS visible_7, t0.lang AS lang_8, t0.rating AS rating_9, t0.prod_id AS prod_id_10, t0.user_id AS user_id_11 FROM prod_comment t0 WHERE t0.prod_id = ?
Parameters:
[
  754499
]
0.06 ms
(0.66%)
1
SELECT t0.id AS id_1, t0.value AS value_2, t0.char_id AS char_id_3, t0.charval_id AS charval_id_4, t0.prod_id AS prod_id_5 FROM prodchar t0 WHERE t0.prod_id = ?
Parameters:
[
  754499
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Cat 62
App\Entity\Prod 10
App\Entity\Page 6

Entities Mapping

Class Mapping errors
App\Entity\Cat No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
App\Entity\Translation\CatTranslation No errors.
App\Entity\Catpage No errors.
App\Entity\Page No errors.
App\Entity\PagePhoto No errors.
App\Entity\PageBlock No errors.
App\Entity\Translation\PageTranslation No errors.
App\Entity\Prod
  • The mappings App\Entity\Prod#vars and App\Entity\Prodvar#prod are inconsistent with each other.
  • The mappings App\Entity\Prod#chars and App\Entity\Prodchar#prod are inconsistent with each other.
App\Entity\Translation\ProdTranslation No errors.
App\Entity\Prodvar
  • The association App\Entity\Prodvar#prod refers to the inverse side field App\Entity\Prod#prodvars which does not exist.
App\Entity\Prodchar
  • The association App\Entity\Prodchar#prod refers to the inverse side field App\Entity\Prod#prodchars which does not exist.
App\Entity\ProdPhoto No errors.
App\Entity\ProdComment No errors.
App\Entity\Char
  • The field 'App\Entity\Char#search' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Charval No errors.
App\Entity\User No errors.