GET https://daisy.alexsuleymanov.com/en/product

Query Metrics

285 Database Queries
16 Different statements
36.62 ms Query time
3 Invalid entities
553 Managed entities

Grouped Statements

Show all queries

Time Count Info
26.42 ms
(72.15%)
244
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 labels_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
3.66 ms
(10.00%)
4
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
]
2.21 ms
(6.03%)
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 cat_translation t0 WHERE t0.object_id = ?
Parameters:
[
  5
]
1.20 ms
(3.26%)
4
SELECT t0.id AS id_1, t0.page AS page_2, t0.intname AS intname_3, t0.mainpage AS mainpage_4, t0.name AS name_5, t0.href AS href_6, t0.short AS short_7, t0.cont AS cont_8, t0.prior AS prior_9, t0.visible AS visible_10, t0.main AS main_11, t0.foot AS foot_12, t0.title AS title_13, t0.h1 AS h1_14, t0.kw AS kw_15, t0.descr AS descr_16, t0.tstamp AS tstamp_17, t0.icon AS icon_18, t0.topmenu AS topmenu_19, t0.footmenu AS footmenu_20, t0.noindex AS noindex_21 FROM page t0 WHERE t0.page = ? AND t0.visible = ? AND t0.topmenu = ? ORDER BY t0.prior DESC
Parameters:
[
  0
  1
  1
]
1.15 ms
(3.15%)
9
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:
[
  26
]
0.28 ms
(0.76%)
1
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.inprice AS inprice_12, t0.incatalog AS incatalog_13, t0.notinxml AS notinxml_14, t0.title AS title_15, t0.h1 AS h1_16, t0.kw AS kw_17, t0.descr AS descr_18 FROM cat t0 WHERE t0.cat = ? AND t0.visible = ? ORDER BY t0.prior DESC
Parameters:
[
  0
  1
]
0.24 ms
(0.64%)
2
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 sett_translation t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
0.21 ms
(0.58%)
1
SELECT t0.id AS id_1, t0.cat AS cat_2, t0.intname AS intname_3, t0.name AS name_4, t0.art AS art_5, t0.short AS short_6, t0.cont AS cont_7, t0.price AS price_8, t0.oldprice AS oldprice_9, t0.discount AS discount_10, t0.num AS num_11, t0.pop AS pop_12, t0.action AS action_13, t0.mix AS mix_14, t0.main AS main_15, t0.new AS new_16, t0.sale AS sale_17, t0.onsale AS onsale_18, t0.visible AS visible_19, t0.prior AS prior_20, t0.title AS title_21, t0.descr AS descr_22, t0.kw AS kw_23, t0.h1 AS h1_24, t0.spec AS spec_25, t0.changed AS changed_26, t0.recommend AS recommend_27, t0.noindex AS noindex_28 FROM prod t0 WHERE t0.intname = ? LIMIT 1
Parameters:
[
  ""
]
0.20 ms
(0.55%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.intname AS intname_3, t0.name AS name_4, t0.value AS value_5 FROM sett t0
Parameters:
[]
0.20 ms
(0.55%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.intname AS intname_3, t0.name AS name_4, t0.value AS value_5 FROM labels t0
Parameters:
[]
0.16 ms
(0.44%)
1
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.inprice AS inprice_12, t0.incatalog AS incatalog_13, t0.notinxml AS notinxml_14, t0.title AS title_15, t0.h1 AS h1_16, t0.kw AS kw_17, t0.descr AS descr_18 FROM cat t0 WHERE t0.id = ?
Parameters:
[
  0
]
0.16 ms
(0.43%)
1
SELECT t0.id AS id_1, t0.page AS page_2, t0.intname AS intname_3, t0.mainpage AS mainpage_4, t0.name AS name_5, t0.href AS href_6, t0.short AS short_7, t0.cont AS cont_8, t0.prior AS prior_9, t0.visible AS visible_10, t0.main AS main_11, t0.foot AS foot_12, t0.title AS title_13, t0.h1 AS h1_14, t0.kw AS kw_15, t0.descr AS descr_16, t0.tstamp AS tstamp_17, t0.icon AS icon_18, t0.topmenu AS topmenu_19, t0.footmenu AS footmenu_20, t0.noindex AS noindex_21 FROM page t0 WHERE t0.page = ? AND t0.visible = ? AND t0.footmenu = ? ORDER BY t0.prior DESC
Parameters:
[
  0
  1
  1
]
0.15 ms
(0.41%)
1
SELECT p0_.id AS id_0, p0_.page AS page_1, p0_.intname AS intname_2, p0_.mainpage AS mainpage_3, p0_.name AS name_4, p0_.href AS href_5, p0_.short AS short_6, p0_.cont AS cont_7, p0_.prior AS prior_8, p0_.visible AS visible_9, p0_.main AS main_10, p0_.foot AS foot_11, p0_.title AS title_12, p0_.h1 AS h1_13, p0_.kw AS kw_14, p0_.descr AS descr_15, p0_.tstamp AS tstamp_16, p0_.icon AS icon_17, p0_.topmenu AS topmenu_18, p0_.footmenu AS footmenu_19, p0_.noindex AS noindex_20 FROM page p0_ WHERE p0_.intname = ?
Parameters:
[
  "catalog"
]
0.14 ms
(0.39%)
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_.oldprice AS oldprice_8, p0_.discount AS discount_9, p0_.num AS num_10, p0_.pop AS pop_11, p0_.action AS action_12, p0_.mix AS mix_13, p0_.main AS main_14, p0_.new AS new_15, p0_.sale AS sale_16, p0_.onsale AS onsale_17, p0_.visible AS visible_18, p0_.prior AS prior_19, p0_.title AS title_20, p0_.descr AS descr_21, p0_.kw AS kw_22, p0_.h1 AS h1_23, p0_.spec AS spec_24, p0_.changed AS changed_25, p0_.recommend AS recommend_26, p0_.noindex AS noindex_27 FROM prod p0_ WHERE p0_.visible = 1 AND p0_.id <> 26 ORDER BY p0_.prior DESC LIMIT 8
Parameters:
[]
0.13 ms
(0.34%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.intname AS intname_3, t0.name AS name_4, t0.value AS value_5 FROM template t0
Parameters:
[]
0.12 ms
(0.32%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.video AS video_3, t0.prior AS prior_4, t0.visible AS visible_5, t0.prod_id AS prod_id_6 FROM prod_photo t0 WHERE t0.prod_id = ? ORDER BY t0.prior DESC
Parameters:
[
  26
]

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\Labels 244
App\Entity\Translation\CatTranslation 168
App\Entity\Translation\PageTranslation 56
App\Entity\Translation\ProdTranslation 54
App\Entity\Cat 12
App\Entity\Prod 9
App\Entity\Page 4
App\Entity\Translation\LabelsTranslation 4
App\Entity\Sett 2

Entities Mapping

Class Mapping 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\Cat No errors.
App\Entity\Translation\CatTranslation No errors.
App\Entity\Catpage 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\Template No errors.
App\Entity\Sett No errors.
App\Entity\Translation\SettTranslation No errors.
App\Entity\Labels No errors.
App\Entity\Translation\LabelsTranslation No errors.