https://somelove.mldev.ru/catalog/product-1.html

Query Metrics

76 Database Queries
32 Different statements
46.27 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.64 ms
(18.67%)
1
SELECT COUNT(*) FROM MLDev_Product_Page t WHERE t.product_id = ?
Parameters:
[
  1
]
6.62 ms
(14.32%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM MLDev_Menu t0 INNER JOIN MLDev_Menu_Page ON t0.id = MLDev_Menu_Page.menu_id WHERE MLDev_Menu_Page.page_id = ?
Parameters:
[
  4
]
6.55 ms
(14.15%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.is_layout AS is_layout_4 FROM MLDev_Page_Template t0 WHERE t0.id = ?
Parameters:
[
  1
]
2.19 ms
(4.72%)
7
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM MLDev_Menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "default-top"
]
2.15 ms
(4.65%)
4
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.alter_name AS alter_name_4, t0.type_prefix AS type_prefix_5, t0.alias AS alias_6, t0.unit AS unit_7, t0.annotation AS annotation_8, t0.description AS description_9, t0.priority AS priority_10, t0.is_active AS is_active_11, t0.extra_fields AS extra_fields_12, t0.articles AS articles_13, t0.rating_score AS rating_score_14, t0.reviews_count AS reviews_count_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.brand_id AS brand_id_18 FROM MLDev_Product t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.98 ms
(4.28%)
8
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.is_active AS is_active_5 FROM MLDev_Block t0 WHERE t0.alias = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "header-warning-message"
  1
]
1.87 ms
(4.04%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.caption AS caption_3, t0.description AS description_4, t0.priority AS priority_5, t0.image AS image_6 FROM MLDev_Product_Composition t0 WHERE t0.id = ?
Parameters:
[
  3
]
1.80 ms
(3.89%)
7
SELECT te.id AS id, te.type AS type, te.external_link AS external_link, te.name AS name, te.alias AS alias, te.route AS route, te.description AS description, te.priority AS priority, te.is_active AS is_active, te.image AS image, te.lft AS lft, te.lvl AS lvl, te.rgt AS rgt, te.created_at AS created_at, te.updated_at AS updated_at, te.parent_id AS parent_id, te.template_id AS template_id, te.layout_template_id AS layout_template_id, te.root_id AS root_id FROM MLDev_Page te JOIN MLDev_Menu_Page t ON t.page_id = te.id WHERE t.menu_id = ? AND te.is_active = ? ORDER BY priority ASC
Parameters:
[
  1
  1
]
1.72 ms
(3.73%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.priority AS priority_4, t0.uri AS uri_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8 FROM MLDev_Product_Image t0 WHERE t0.product_id = ? ORDER BY t0.priority ASC
Parameters:
[
  1
]
1.43 ms
(3.09%)
5
SELECT t0.value AS value_1, t0.old_value AS old_value_2, t0.price_id AS price_id_3, t0.product_item_id AS product_item_id_4 FROM MLDev_Product_Item_Price t0 WHERE t0.product_item_id = ?
Parameters:
[
  1
]
1.36 ms
(2.95%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 INNER JOIN MLDev_Product_Page ON t0.id = MLDev_Product_Page.page_id WHERE MLDev_Product_Page.product_id = ?
Parameters:
[
  1
]
1.32 ms
(2.85%)
4
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.alterName AS alterName_4, t0.sku AS sku_5, t0.amount AS amount_6, t0.is_active AS is_active_7, t0.is_new AS is_new_8, t0.is_sale AS is_sale_9, t0.use_on_yandex_market AS use_on_yandex_market_10, t0.available_image_list AS available_image_list_11, t0.available_image_list_for_yandex_market AS available_image_list_for_yandex_market_12, t0.volume AS volume_13, t0.volume_unit AS volume_unit_14, t0.marketplace_link_yandex_market AS marketplace_link_yandex_market_15, t0.marketplace_link_ozon AS marketplace_link_ozon_16, t0.marketplace_link_wildberries AS marketplace_link_wildberries_17, t0.product_id AS product_id_18, t0.product_image_id AS product_image_id_19, t0.color_id AS color_id_20 FROM MLDev_Product_Item t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
1.31 ms
(2.83%)
4
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.alterName AS alterName_4, t0.sku AS sku_5, t0.amount AS amount_6, t0.is_active AS is_active_7, t0.is_new AS is_new_8, t0.is_sale AS is_sale_9, t0.use_on_yandex_market AS use_on_yandex_market_10, t0.available_image_list AS available_image_list_11, t0.available_image_list_for_yandex_market AS available_image_list_for_yandex_market_12, t0.volume AS volume_13, t0.volume_unit AS volume_unit_14, t0.marketplace_link_yandex_market AS marketplace_link_yandex_market_15, t0.marketplace_link_ozon AS marketplace_link_ozon_16, t0.marketplace_link_wildberries AS marketplace_link_wildberries_17, t0.product_id AS product_id_18, t0.product_image_id AS product_image_id_19, t0.color_id AS color_id_20 FROM MLDev_Product_Item t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
1.05 ms
(2.27%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.id = ?
Parameters:
[
  3
]
1.01 ms
(2.19%)
4
SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
0.43 ms
(0.92%)
1
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.alter_name AS alter_name_4, t0.type_prefix AS type_prefix_5, t0.alias AS alias_6, t0.unit AS unit_7, t0.annotation AS annotation_8, t0.description AS description_9, t0.priority AS priority_10, t0.is_active AS is_active_11, t0.extra_fields AS extra_fields_12, t0.articles AS articles_13, t0.rating_score AS rating_score_14, t0.reviews_count AS reviews_count_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.brand_id AS brand_id_18 FROM MLDev_Product t0 INNER JOIN MLDev_Product_Related ON t0.id = MLDev_Product_Related.linked_id WHERE MLDev_Product_Related.main_id = ?
Parameters:
[
  1
]
0.40 ms
(0.86%)
1
SELECT t0.id AS id_1, t0.where_from AS where_from_2, t0.where_to AS where_to_3, t0.http_code AS http_code_4 FROM MLDev_Redirect t0 WHERE t0.where_from = ? LIMIT 1
Parameters:
[
  "/catalog/product-1.html"
]
0.39 ms
(0.84%)
1
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.external_link AS external_link_2, m0_.name AS name_3, m0_.alias AS alias_4, m0_.route AS route_5, m0_.description AS description_6, m0_.priority AS priority_7, m0_.is_active AS is_active_8, m0_.image AS image_9, m0_.lft AS lft_10, m0_.lvl AS lvl_11, m0_.rgt AS rgt_12, m0_.created_at AS created_at_13, m0_.updated_at AS updated_at_14, m0_.parent_id AS parent_id_15, m0_.template_id AS template_id_16, m0_.layout_template_id AS layout_template_id_17, m0_.root_id AS root_id_18 FROM MLDev_Page m0_ WHERE m0_.parent_id IS NULL ORDER BY m0_.lft ASC
Parameters:
[]
0.37 ms
(0.80%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.is_default AS is_default_5, t0.seo_site_id AS seo_site_id_6 FROM MLDev_SeoInfo t0 INNER JOIN MLDev_Page_SeoInfo ON t0.id = MLDev_Page_SeoInfo.seo_info_id WHERE MLDev_Page_SeoInfo.page_id = ?
Parameters:
[
  4
]
0.37 ms
(0.80%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.priority AS priority_3, t0.is_active AS is_active_4, t0.widget AS widget_5, t0.options AS options_6, t0.page_id AS page_id_7 FROM MLDev_Page_Content t0 WHERE t0.page_id = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
  4
]
0.36 ms
(0.77%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.priority AS priority_4, t0.uri AS uri_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8 FROM MLDev_Product_Image t0 WHERE t0.id = ?
Parameters:
[
  39
]
0.34 ms
(0.73%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM MLDev_Product_Skin t0 INNER JOIN MLDev_Product_To_Skin ON t0.id = MLDev_Product_To_Skin.skin_id WHERE MLDev_Product_To_Skin.product_id = ?
Parameters:
[
  1
]
0.31 ms
(0.67%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM MLDev_Product_SkinCondition t0 INNER JOIN MLDev_Product_To_SkinCondition ON t0.id = MLDev_Product_To_SkinCondition.skin_condition_id WHERE MLDev_Product_To_SkinCondition.product_id = ?
Parameters:
[
  1
]
0.31 ms
(0.67%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.robots AS robots_5, t0.isActive AS isActive_6, t0.isDefault AS isDefault_7 FROM MLDev_SeoSite t0 WHERE t0.isActive = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
0.29 ms
(0.64%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.is_default AS is_default_5, t0.seo_site_id AS seo_site_id_6 FROM MLDev_SeoInfo t0 INNER JOIN MLDev_Product_Item_SeoInfo ON t0.id = MLDev_Product_Item_SeoInfo.seo_info_id WHERE MLDev_Product_Item_SeoInfo.product_item_id = ?
Parameters:
[
  1
]
0.29 ms
(0.62%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.robots AS robots_5, t0.isActive AS isActive_6, t0.isDefault AS isDefault_7 FROM MLDev_SeoSite t0 WHERE t0.isActive = ? AND t0.isDefault = ? LIMIT 1
Parameters:
[
  1
  1
]
0.26 ms
(0.57%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM MLDev_Product_Aroma t0 INNER JOIN MLDev_Product_To_Aroma ON t0.id = MLDev_Product_To_Aroma.aroma_id WHERE MLDev_Product_To_Aroma.product_id = ?
Parameters:
[
  1
]
0.26 ms
(0.56%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.priority AS priority_3, t0.is_active AS is_active_4, t0.widget AS widget_5, t0.options AS options_6, t0.product_id AS product_id_7 FROM MLDev_Product_Content t0 WHERE (t0.is_active = ? AND t0.product_id = ?) ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
  1
  1
]
0.25 ms
(0.55%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.basic AS basic_4, t0.syncIdentity AS syncIdentity_5 FROM MLDev_Product_Price t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.22 ms
(0.48%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM MLDev_Product_HairState t0 INNER JOIN MLDev_Product_To_HairState ON t0.id = MLDev_Product_To_HairState.hair_state_id WHERE MLDev_Product_To_HairState.product_id = ?
Parameters:
[
  1
]
0.21 ms
(0.46%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM MLDev_Product_Effect t0 INNER JOIN MLDev_Product_To_Effect ON t0.id = MLDev_Product_To_Effect.aroma_id WHERE MLDev_Product_To_Effect.product_id = ?
Parameters:
[
  1
]
0.20 ms
(0.44%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM MLDev_Product_HairType t0 INNER JOIN MLDev_Product_To_HairType ON t0.id = MLDev_Product_To_HairType.hair_type_id WHERE MLDev_Product_To_HairType.product_id = ?
Parameters:
[
  1
]

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.