Query Metrics
103
Database Queries
13
Different statements
10.62 ms
Query time
4
Invalid entities
83
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.13 ms (29.50%) |
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:
[
"gld60786-gb70838_o-almazna-moza-ka-30-40sm-park-rulon-u-pvc-bez-p-dram"
]
|
|
2.43 ms (22.92%) |
63 |
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
]
|
|
2.00 ms (18.84%) |
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:
[ 756240 755015 ] |
|
0.92 ms (8.68%) |
14 |
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:
[
755015
]
|
|
0.53 ms (5.01%) |
5 |
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:
[
708484
]
|
|
0.47 ms (4.40%) |
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.28 ms (2.67%) |
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.55%) |
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.22 ms (2.12%) |
3 |
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:
[
756240
]
|
|
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_.topmenu = 1 ORDER BY p0_.prior DESC
Parameters:
[] |
|
0.09 ms (0.83%) |
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:
[
755015
]
|
|
0.09 ms (0.80%) |
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.09 ms (0.80%) |
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:
[
755015
]
|
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 | 63 |
| App\Entity\Prod | 14 |
| 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 |
|
| App\Entity\Translation\ProdTranslation | No errors. |
| App\Entity\Prodvar |
|
| App\Entity\Prodchar |
|
| App\Entity\ProdPhoto | No errors. |
| App\Entity\ProdComment | No errors. |
| App\Entity\Char |
|
| App\Entity\Charval | No errors. |
| App\Entity\User | No errors. |