POST https://lk.vodokomfort.ru/api/v1/brand/46/products

Query Metrics

308 Database Queries
14 Different statements
9.33 ms Query time
5 Invalid entities
56 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.74 ms
(18.66%)
50
SELECT t0.id AS id_1, t0.is_published AS is_published_2, t0.is_on_sale AS is_on_sale_3, t0.name AS name_4, t0.s1_code AS s1_code_5, t0.description AS description_6, t0.is_description_unique AS is_description_unique_7, t0.product_code AS product_code_8, t0.seo_name AS seo_name_9, t0.seo_description AS seo_description_10, t0.previous_id AS previous_id_11, t0.created_at AS created_at_12, t0.price_value AS price_value_13, t0.price_value_client AS price_value_client_14, t0.imported_at AS imported_at_15, t0.set_categories_at AS set_categories_at_16, t0.is_archives AS is_archives_17, t0.temp_price_value AS temp_price_value_18, t0.updated_at AS updated_at_19, t0.is_api_image AS is_api_image_20, t0.file_order AS file_order_21, t0.slug AS slug_22, t0.unit AS unit_23, t0.replaced_s1_code AS replaced_s1_code_24, t0.is_show_price AS is_show_price_25, t0.is_service AS is_service_26, t0.promo_description AS promo_description_27, t0.s1_slug AS s1_slug_28, t0.is_actual AS is_actual_29, t0.ratio AS ratio_30, t0.shop_count AS shop_count_31, t0.is_sale AS is_sale_32, t0.is_sale_admin AS is_sale_admin_33, t0.direct_code AS direct_code_34, t0.temp_product_code_duplicates AS temp_product_code_duplicates_35, t0.brand_id AS brand_id_36, t0.file_list_id AS file_list_id_37, t0.currency_id AS currency_id_38, t0.currency_client_id AS currency_client_id_39, t0.country_id AS country_id_40, t0.brand_series_id AS brand_series_id_41, t0.model_id AS model_id_42 FROM product t0 INNER JOIN product_duplicates ON t0.id = product_duplicates.product_target WHERE product_duplicates.product_source = ?
Parameters:
[
  154131
]
1.44 ms
(15.46%)
50
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_width AS image_width_3, t0.image_height AS image_height_4, t0.type AS type_5, t0.bytes AS bytes_6, t0.created_at AS created_at_7, t0.is_tested AS is_tested_8, t0.title AS title_9, t0.description AS description_10, t0.priority AS priority_11, t0.filename_original AS filename_original_12, t0.checked AS checked_13, t0.file_display_id AS file_display_id_14, t0.file_preview_id AS file_preview_id_15 FROM file t0 INNER JOIN product_document ON t0.id = product_document.file_id WHERE product_document.product_id = ?
Parameters:
[
  154131
]
1.31 ms
(14.01%)
50
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_width AS image_width_3, t0.image_height AS image_height_4, t0.type AS type_5, t0.bytes AS bytes_6, t0.created_at AS created_at_7, t0.is_tested AS is_tested_8, t0.title AS title_9, t0.description AS description_10, t0.priority AS priority_11, t0.filename_original AS filename_original_12, t0.checked AS checked_13, t0.file_display_id AS file_display_id_14, t0.file_preview_id AS file_preview_id_15 FROM file t0 INNER JOIN product_file ON t0.id = product_file.file_id WHERE product_file.product_id = ?
Parameters:
[
  154131
]
1.29 ms
(13.82%)
50
SELECT t0.id AS id_1, t0.value AS value_2, t0.is_from_s1 AS is_from_s1_3, t0.created_at AS created_at_4, t0.is_from_command AS is_from_command_5, t0.sort AS sort_6, t0.product_id AS product_id_7, t0.product_property_id AS product_property_id_8, t0.product_property_group_id AS product_property_group_id_9 FROM product_property_value t0 WHERE t0.product_id = ?
Parameters:
[
  154131
]
1.28 ms
(13.76%)
50
SELECT t0.id AS id_1, t0.value AS value_2, t0.updated_at AS updated_at_3, t0.is_published AS is_published_4, t0.brand_id AS brand_id_5, t0.currency_id AS currency_id_6 FROM brand_currency_value t0 WHERE (t0.is_published = ? AND t0.brand_id = ?) ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  1
  46
]
1.27 ms
(13.66%)
50
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.count AS count_3, t0.uploaded_at AS uploaded_at_4, t0.shop_id AS shop_id_5, t0.product_id AS product_id_6 FROM shop_product t0 WHERE t0.product_id = ?
Parameters:
[
  154131
]
0.29 ms
(3.15%)
1
SELECT t0.id AS id_1, t0.is_published AS is_published_2, t0.is_on_sale AS is_on_sale_3, t0.name AS name_4, t0.s1_code AS s1_code_5, t0.description AS description_6, t0.is_description_unique AS is_description_unique_7, t0.product_code AS product_code_8, t0.seo_name AS seo_name_9, t0.seo_description AS seo_description_10, t0.previous_id AS previous_id_11, t0.created_at AS created_at_12, t0.price_value AS price_value_13, t0.price_value_client AS price_value_client_14, t0.imported_at AS imported_at_15, t0.set_categories_at AS set_categories_at_16, t0.is_archives AS is_archives_17, t0.temp_price_value AS temp_price_value_18, t0.updated_at AS updated_at_19, t0.is_api_image AS is_api_image_20, t0.file_order AS file_order_21, t0.slug AS slug_22, t0.unit AS unit_23, t0.replaced_s1_code AS replaced_s1_code_24, t0.is_show_price AS is_show_price_25, t0.is_service AS is_service_26, t0.promo_description AS promo_description_27, t0.s1_slug AS s1_slug_28, t0.is_actual AS is_actual_29, t0.ratio AS ratio_30, t0.shop_count AS shop_count_31, t0.is_sale AS is_sale_32, t0.is_sale_admin AS is_sale_admin_33, t0.direct_code AS direct_code_34, t0.temp_product_code_duplicates AS temp_product_code_duplicates_35, t0.brand_id AS brand_id_36, t0.file_list_id AS file_list_id_37, t0.currency_id AS currency_id_38, t0.currency_client_id AS currency_client_id_39, t0.country_id AS country_id_40, t0.brand_series_id AS brand_series_id_41, t0.model_id AS model_id_42 FROM product t0 WHERE t0.brand_id = ? LIMIT 50
Parameters:
[
  46
]
0.24 ms
(2.57%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_published AS is_published_3, t0.slug AS slug_4, t0.description AS description_5, t0.sort AS sort_6, t0.intro AS intro_7, t0.temp_products_count AS temp_products_count_8, t0.is_drop_down AS is_drop_down_9, t0.link_advertising AS link_advertising_10, t0.link_catalogue AS link_catalogue_11, t0.link_instruction AS link_instruction_12, t0.link_certificate AS link_certificate_13, t0.link_shop AS link_shop_14, t0.description_corporate AS description_corporate_15, t0.is_published_corporate AS is_published_corporate_16, t0.heading AS heading_17, t0.heading_corporate AS heading_corporate_18, t0.is_show_catalogue AS is_show_catalogue_19, t0.alias AS alias_20, t0.categories_updated_at AS categories_updated_at_21, t0.is_description_corporate_full_page AS is_description_corporate_full_page_22, t0.is_description_full_page AS is_description_full_page_23, t0.sort_corporate AS sort_corporate_24, t0.is_original AS is_original_25, t0.file_id AS file_id_26, t0.country_id AS country_id_27, t0.disk_folder_id AS disk_folder_id_28 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  "46"
]
0.19 ms
(2.01%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.symbol AS symbol_4, t0.is_main AS is_main_5, t0.is_published AS is_published_6, t0.fix_value AS fix_value_7 FROM currency t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.14 ms
(1.49%)
1
SELECT COUNT(*) FROM product t0 WHERE t0.brand_id = ?
Parameters:
[
  46
]
0.05 ms
(0.51%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3, t0.previous_id AS previous_id_4, t0.is_published AS is_published_5, t0.created_at AS created_at_6, t0.is_from_s1 AS is_from_s1_7 FROM product_property_group t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.03 ms
(0.32%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_width AS image_width_3, t0.image_height AS image_height_4, t0.type AS type_5, t0.bytes AS bytes_6, t0.created_at AS created_at_7, t0.is_tested AS is_tested_8, t0.title AS title_9, t0.description AS description_10, t0.priority AS priority_11, t0.filename_original AS filename_original_12, t0.checked AS checked_13, t0.file_display_id AS file_display_id_14, t0.file_preview_id AS file_preview_id_15 FROM file t0 WHERE t0.id = ?
Parameters:
[
  89457
]
0.03 ms
(0.32%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.is_from_s1 AS is_from_s1_4, t0.type AS type_5, t0.parameters AS parameters_6, t0.is_for_analogues AS is_for_analogues_7, t0.is_new AS is_new_8 FROM product_property t0 WHERE t0.id = ?
Parameters:
[
  4548
]
0.02 ms
(0.26%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.currency_id AS currency_id_5 FROM currency_value t0 WHERE t0.currency_id = ? ORDER BY t0.id DESC
Parameters:
[
  3
]

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\Product 50
App\Entity\Brand 1
App\Entity\File 1
App\Entity\Currency 1
App\Entity\ProductPropertyValue 1
App\Entity\ProductProperty 1
App\Entity\ProductPropertyGroup 1

Entities Mapping

Class Mapping errors
App\Entity\Brand
  • The field App\Entity\Brand#currencyValue is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BrandCurrencyValue#brand does not contain the required 'inversedBy="currencyValue"' attribute.
App\Entity\File No errors.
App\Entity\Country No errors.
App\Entity\DiskFolder No errors.
App\Entity\BrandSeriesCategory No errors.
App\Entity\Product No errors.
App\Entity\CategoryBrand No errors.
App\Entity\BrandCurrencyValue No errors.
App\Entity\Currency
  • The mappings App\Entity\Currency#currencyValue and App\Entity\CurrencyValue#currency are inconsistent with each other.
App\Entity\BrandSeries No errors.
App\Entity\Model
  • The association App\Entity\Model#brand refers to the inverse side field App\Entity\Brand#models which does not exist.
App\Entity\Category
  • The field App\Entity\Category#categories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Category#category does not contain the required 'inversedBy="categories"' attribute.
  • The field App\Entity\Category#brand is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CategoryBrand#category does not contain the required 'inversedBy="brand"' attribute.
App\Entity\ProductPropertyValue No errors.
App\Entity\ShopProduct No errors.
App\Entity\CurrencyValue
  • The association App\Entity\CurrencyValue#currency refers to the inverse side field App\Entity\Currency#value which does not exist.
App\Entity\Shop No errors.
App\Entity\ProductProperty No errors.
App\Entity\ProductPropertyGroup No errors.