Query Metrics
1098
Database Queries
15
Different statements
43.53 ms
Query time
3
Invalid entities
1081
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
35.44 ms (81.41%) |
1064 |
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.17 ms (4.99%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, prior_38 FROM (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 IN (718701)) dctrn_result_inner ORDER BY prior_38 DESC) dctrn_result LIMIT 30 OFFSET 30
Parameters:
[] |
|
2.08 ms (4.77%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 IN (718701) ORDER BY p0_.prior DESC) dctrn_result) dctrn_table
Parameters:
[] |
|
1.47 ms (3.38%) |
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_.visible = 1 ORDER BY c0_.prior DESC
Parameters:
[] |
|
0.59 ms (1.35%) |
6 |
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.43 ms (0.98%) |
11 |
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:
[
749340
]
|
|
0.28 ms (0.65%) |
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.26 ms (0.59%) |
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.25 ms (0.57%) |
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 IN (718701) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.prior DESC
Parameters:
[ 749340 752940 760942 760940 760939 760938 760918 759210 759209 753701 706370 ] |
|
0.14 ms (0.33%) |
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_.intname = ? AND c0_.visible = 1
Parameters:
[
"24-04-papki-shkolnie-plastikovie-na-zmejke-knopke-i-lipuchke"
]
|
|
0.11 ms (0.25%) |
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_.intname = ?
Parameters:
[
"catalog"
]
|
|
0.10 ms (0.23%) |
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.10 ms (0.22%) |
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.16%) |
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.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:
[
0
]
|
|
0.05 ms (0.12%) |
1 |
SELECT c0_.id AS id_0 FROM cat c0_ WHERE c0_.cat IN (?)
Parameters:
[
718701
]
|
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 | 1064 |
| App\Entity\Prod | 11 |
| 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. |