Query Metrics
1139
Database Queries
19
Different statements
49.61 ms
Query time
3
Invalid entities
1100
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
37.46 ms (75.51%) |
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.04 ms (4.10%) |
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 (700658, 700659, 700667, 700669, 723750, 725484, 729799, 731212, 731841, 732854, 734098, 734100, 734104, 734107, 736147, 741272, 744720, 749223, 749485, 723770, 723771, 723772, 725487, 734165, 735453, 740333, 733759, 734112, 734113, 734116, 734117, 734118, 734556, 734099, 738716, 738717, 738718, 732855, 732856, 734101, 734102, 734103, 735060, 744402, 734109, 738719, 730642, 734108, 740973, 745239, 745240, 741371) ORDER BY p0_.prior DESC) dctrn_result) dctrn_table
Parameters:
[] |
|
2.01 ms (4.05%) |
1 |
SELECT p0_.cat AS cat_0, COUNT(p0_.id) AS sclr_1 FROM prod p0_ WHERE p0_.visible = 1 AND p0_.cat IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY p0_.cat
Parameters:
[ 734099 738716 738717 738718 735060 734101 734102 734103 732855 732856 744402 734109 738719 730642 740973 734108 734556 734116 734117 734118 723770 723771 723772 734165 735453 740333 725487 733759 734112 734113 ] |
|
1.97 ms (3.96%) |
24 |
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
]
|
|
1.89 ms (3.81%) |
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 (700658, 700659, 700667, 700669, 723750, 725484, 729799, 731212, 731841, 732854, 734098, 734100, 734104, 734107, 736147, 741272, 744720, 749223, 749485, 723770, 723771, 723772, 725487, 734165, 735453, 740333, 733759, 734112, 734113, 734116, 734117, 734118, 734556, 734099, 738716, 738717, 738718, 732855, 732856, 734101, 734102, 734103, 735060, 744402, 734109, 738719, 730642, 734108, 740973, 745239, 745240, 741371)) dctrn_result_inner ORDER BY prior_38 DESC) dctrn_result LIMIT 30 OFFSET 210
Parameters:
[] |
|
1.22 ms (2.47%) |
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:
[] |
|
1.08 ms (2.17%) |
30 |
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:
[
732928
]
|
|
0.37 ms (0.75%) |
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.30 ms (0.60%) |
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 (700658, 700659, 700667, 700669, 723750, 725484, 729799, 731212, 731841, 732854, 734098, 734100, 734104, 734107, 736147, 741272, 744720, 749223, 749485, 723770, 723771, 723772, 725487, 734165, 735453, 740333, 733759, 734112, 734113, 734116, 734117, 734118, 734556, 734099, 738716, 738717, 738718, 732855, 732856, 734101, 734102, 734103, 735060, 744402, 734109, 738719, 730642, 734108, 740973, 745239, 745240, 741371) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.prior DESC
Parameters:
[ 735465 734753 734752 733747 733746 733744 732956 732955 732953 732949 732944 732943 732941 732939 732938 732937 732936 732934 732928 732961 732962 733743 733741 733740 733389 733387 733229 733227 733210 732971 ] |
|
0.29 ms (0.58%) |
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.29 ms (0.58%) |
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:
[
"12-ryukzaki-sumki-tubusi-fartuki"
]
|
|
0.12 ms (0.23%) |
1 |
SELECT c0_.id AS id_0 FROM cat c0_ WHERE c0_.cat IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 700659 700667 700669 723750 725484 729799 731212 731841 732854 734098 734100 734104 734107 736147 741272 744720 749223 749485 ] |
|
0.10 ms (0.21%) |
1 |
SELECT c0_.id AS id_0 FROM cat c0_ WHERE c0_.cat IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 723770 723771 723772 725487 734165 735453 740333 733759 734112 734113 734116 734117 734118 734556 734099 738716 738717 738718 732855 732856 734101 734102 734103 735060 744402 734109 738719 730642 734108 740973 ] |
|
0.10 ms (0.21%) |
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.20%) |
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.09 ms (0.19%) |
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.08 ms (0.17%) |
1 |
SELECT c0_.id AS id_0 FROM cat c0_ WHERE c0_.cat IN (?)
Parameters:
[
700658
]
|
|
0.06 ms (0.13%) |
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.04 ms (0.09%) |
1 |
SELECT c0_.id AS id_0 FROM cat c0_ WHERE c0_.cat IN (?, ?, ?)
Parameters:
[ 745239 745240 741371 ] |
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 | 30 |
| 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. |