Query Metrics
121
Database Queries
24
Different statements
4.30 ms
Query time
5
Invalid entities
1155
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.61 ms (14.08%) |
13 |
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.is_published = ? AND t0.brand_series_id = ?)
Parameters:
[ 1 751 ] |
|
0.54 ms (12.47%) |
13 |
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:
[
264791
]
|
|
0.47 ms (11.05%) |
16 |
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:
[
154345
]
|
|
0.44 ms (10.27%) |
13 |
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:
[
264791
]
|
|
0.36 ms (8.33%) |
13 |
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:
[
264791
]
|
|
0.35 ms (8.21%) |
13 |
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:
[
264791
]
|
|
0.34 ms (7.93%) |
13 |
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:
[
264791
]
|
|
0.18 ms (4.18%) |
6 |
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:
[
790
]
|
|
0.10 ms (2.42%) |
1 |
SELECT CASE WHEN (((p0_.is_sale_admin IS NOT NULL AND 1 = p0_.is_sale_admin) OR (p0_.is_sale_admin IS NULL AND 1 = p0_.is_sale)) AND p0_.shop_count > 0) THEN 1 ELSE 0 END AS sclr_0, CASE WHEN (p0_.is_sale_admin IS NOT NULL AND 1 = p0_.is_sale_admin) OR (p0_.is_sale_admin IS NULL AND 1 = p0_.is_sale) THEN 1 ELSE 0 END AS sclr_1, CASE WHEN p0_.shop_count > 0 THEN 1 ELSE 0 END AS sclr_2, p0_.id AS id_3, p0_.is_published AS is_published_4, p0_.is_on_sale AS is_on_sale_5, p0_.name AS name_6, p0_.s1_code AS s1_code_7, p0_.description AS description_8, p0_.is_description_unique AS is_description_unique_9, p0_.product_code AS product_code_10, p0_.seo_name AS seo_name_11, p0_.seo_description AS seo_description_12, p0_.previous_id AS previous_id_13, p0_.created_at AS created_at_14, p0_.price_value AS price_value_15, p0_.price_value_client AS price_value_client_16, p0_.imported_at AS imported_at_17, p0_.set_categories_at AS set_categories_at_18, p0_.is_archives AS is_archives_19, p0_.temp_price_value AS temp_price_value_20, p0_.updated_at AS updated_at_21, p0_.is_api_image AS is_api_image_22, p0_.file_order AS file_order_23, p0_.slug AS slug_24, p0_.unit AS unit_25, p0_.replaced_s1_code AS replaced_s1_code_26, p0_.is_show_price AS is_show_price_27, p0_.is_service AS is_service_28, p0_.promo_description AS promo_description_29, p0_.s1_slug AS s1_slug_30, p0_.is_actual AS is_actual_31, p0_.ratio AS ratio_32, p0_.shop_count AS shop_count_33, p0_.is_sale AS is_sale_34, p0_.is_sale_admin AS is_sale_admin_35, p0_.direct_code AS direct_code_36, p0_.temp_product_code_duplicates AS temp_product_code_duplicates_37, b1_.id AS id_38, b1_.name AS name_39, b1_.is_published AS is_published_40, b1_.slug AS slug_41, b1_.description AS description_42, b1_.sort AS sort_43, b1_.intro AS intro_44, b1_.temp_products_count AS temp_products_count_45, b1_.is_drop_down AS is_drop_down_46, b1_.link_advertising AS link_advertising_47, b1_.link_catalogue AS link_catalogue_48, b1_.link_instruction AS link_instruction_49, b1_.link_certificate AS link_certificate_50, b1_.link_shop AS link_shop_51, b1_.description_corporate AS description_corporate_52, b1_.is_published_corporate AS is_published_corporate_53, b1_.heading AS heading_54, b1_.heading_corporate AS heading_corporate_55, b1_.is_show_catalogue AS is_show_catalogue_56, b1_.alias AS alias_57, b1_.categories_updated_at AS categories_updated_at_58, b1_.is_description_corporate_full_page AS is_description_corporate_full_page_59, b1_.is_description_full_page AS is_description_full_page_60, b1_.sort_corporate AS sort_corporate_61, b1_.is_original AS is_original_62, f2_.id AS id_63, f2_.name AS name_64, f2_.image_width AS image_width_65, f2_.image_height AS image_height_66, f2_.type AS type_67, f2_.bytes AS bytes_68, f2_.created_at AS created_at_69, f2_.is_tested AS is_tested_70, f2_.title AS title_71, f2_.description AS description_72, f2_.priority AS priority_73, f2_.filename_original AS filename_original_74, f2_.checked AS checked_75, p0_.brand_id AS brand_id_76, p0_.file_list_id AS file_list_id_77, p0_.currency_id AS currency_id_78, p0_.currency_client_id AS currency_client_id_79, p0_.country_id AS country_id_80, p0_.brand_series_id AS brand_series_id_81, p0_.model_id AS model_id_82, b1_.file_id AS file_id_83, b1_.country_id AS country_id_84, b1_.disk_folder_id AS disk_folder_id_85, f2_.file_display_id AS file_display_id_86, f2_.file_preview_id AS file_preview_id_87 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id INNER JOIN product_category p4_ ON p0_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND c3_.id = ? AND p0_.temp_price_value >= ? AND p0_.temp_price_value <= ? AND b1_.id IN (?) ORDER BY sclr_0 DESC, sclr_2 DESC, sclr_1 DESC, p0_.is_actual DESC, p0_.is_show_price DESC, p0_.is_on_sale DESC, p0_.file_list_id DESC LIMIT 50
Parameters:
[ 1526 0.0 0.0 73 ] |
|
0.09 ms (2.19%) |
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:
[
1
]
|
|
0.09 ms (2.16%) |
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.08 ms (1.84%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort AS sort_3, t0.slug AS slug_4, t0.s1_code AS s1_code_5, t0.is_published AS is_published_6, t0.intro AS intro_7, t0.description AS description_8, t0.previous_id AS previous_id_9, t0.is_root AS is_root_10, t0.is_catalogue AS is_catalogue_11, t0.title AS title_12, t0.name_in_navigation AS name_in_navigation_13, t0.temp_products_count AS temp_products_count_14, t0.temp_price_min AS temp_price_min_15, t0.temp_price_max AS temp_price_max_16, t0.is_drop_down AS is_drop_down_17, t0.path_redirect AS path_redirect_18, t0.is_actual AS is_actual_19, t0.is_on_main AS is_on_main_20, t0.temp_file_list_name AS temp_file_list_name_21, t0.category_id AS category_id_22, t0.file_intro_id AS file_intro_id_23, t0.file_description_id AS file_description_id_24, t0.link_id AS link_id_25, t0.file_list_id AS file_list_id_26, t0.file_icon_id AS file_icon_id_27, t0.file_actual_id AS file_actual_id_28, t0.file_catalogue_id AS file_catalogue_id_29, t0.file_application_id AS file_application_id_30 FROM category t0 WHERE t0.id = ?
Parameters:
[
1526
]
|
|
0.08 ms (1.79%) |
2 |
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 brand_series_product_file ON t0.id = brand_series_product_file.file_id WHERE brand_series_product_file.brand_series_id = ?
Parameters:
[
751
]
|
|
0.07 ms (1.60%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.created_at AS created_at_5, t0.sort AS sort_6, t0.intro AS intro_7, t0.description AS description_8, t0.title AS title_9, t0.description_product_all AS description_product_all_10, t0.brand_id AS brand_id_11, t0.file_id AS file_id_12, t0.brand_series_group_id AS brand_series_group_id_13, t0.intro_file_id AS intro_file_id_14, t0.brand_series_id AS brand_series_id_15 FROM brand_series t0 WHERE t0.id = ?
Parameters:
[
751
]
|
|
0.06 ms (1.39%) |
1 |
SELECT MIN(p0_.temp_price_value) AS sclr_0, MAX(p0_.temp_price_value) AS sclr_1 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id INNER JOIN product_category p4_ ON p0_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND c3_.id = ? AND p0_.temp_price_value >= ? AND p0_.temp_price_value <= ? AND b1_.id IN (?) AND p0_.temp_price_value > 0
Parameters:
[ 1526 0.0 0.0 73 ] |
|
0.06 ms (1.32%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.brand_id AS brand_id_6, t0.brand_series_category_id AS brand_series_category_id_7, t0.intro_file_id AS intro_file_id_8, t0.description_file_id AS description_file_id_9 FROM brand_series_category t0 INNER JOIN brand_series_brand_series_category ON t0.id = brand_series_brand_series_category.brand_series_category_id WHERE brand_series_brand_series_category.brand_series_id = ?
Parameters:
[
751
]
|
|
0.06 ms (1.30%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.created_at AS created_at_5, t0.sort AS sort_6, t0.intro AS intro_7, t0.description AS description_8, t0.title AS title_9, t0.description_product_all AS description_product_all_10, t0.brand_id AS brand_id_11, t0.file_id AS file_id_12, t0.brand_series_group_id AS brand_series_group_id_13, t0.intro_file_id AS intro_file_id_14, t0.brand_series_id AS brand_series_id_15 FROM brand_series t0 WHERE t0.brand_series_id = ? ORDER BY t0.sort ASC
Parameters:
[
751
]
|
|
0.06 ms (1.28%) |
2 |
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 brand_series_file ON t0.id = brand_series_file.file_id WHERE brand_series_file.brand_series_id = ?
Parameters:
[
751
]
|
|
0.05 ms (1.25%) |
1 |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id INNER JOIN product_category p4_ ON p0_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND c3_.id = ? AND p0_.temp_price_value >= ? AND p0_.temp_price_value <= ? AND b1_.id IN (?)
Parameters:
[ 1526 0.0 0.0 73 ] |
|
0.05 ms (1.19%) |
1 |
SELECT t0.id AS id_1, t0.is_published AS is_published_2, t0.sort AS sort_3, t0.values_list AS values_list_4, t0.is_public AS is_public_5, t0.category_id AS category_id_6, t0.product_property_id AS product_property_id_7 FROM category_product_property t0 WHERE t0.category_id = ? ORDER BY t0.sort ASC
Parameters:
[
1526
]
|
|
0.05 ms (1.07%) |
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, COUNT(DISTINCT p1_.id) AS sclr_3 FROM product p1_ LEFT JOIN brand b2_ ON p1_.brand_id = b2_.id LEFT JOIN file f3_ ON p1_.file_list_id = f3_.id INNER JOIN product_category p5_ ON p1_.id = p5_.product_id INNER JOIN category c4_ ON c4_.id = p5_.category_id INNER JOIN brand b0_ ON p1_.brand_id = b0_.id WHERE p1_.is_archives = 0 AND (b2_.id IS NULL OR b2_.is_published = 1) AND c4_.id = ? AND p1_.temp_price_value >= ? AND p1_.temp_price_value <= ? AND (b0_.id IS NULL OR b0_.is_published = 1) GROUP BY b0_.id, b0_.name, b0_.slug HAVING COUNT(DISTINCT p1_.id) > 0 ORDER BY name_1 ASC
Parameters:
[ 1526 0.0 0.0 ] |
|
0.04 ms (0.93%) |
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:
[
1
]
|
|
0.04 ms (0.90%) |
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, COUNT(DISTINCT p1_.id) AS sclr_3 FROM product p1_ LEFT JOIN brand b2_ ON p1_.brand_id = b2_.id LEFT JOIN file f3_ ON p1_.file_list_id = f3_.id INNER JOIN product_category p5_ ON p1_.id = p5_.product_id INNER JOIN category c4_ ON c4_.id = p5_.category_id INNER JOIN brand_series b0_ ON p1_.brand_series_id = b0_.id WHERE p1_.is_archives = 0 AND (b2_.id IS NULL OR b2_.is_published = 1) AND c4_.id = ? AND p1_.temp_price_value >= ? AND p1_.temp_price_value <= ? AND b2_.id IN (?) AND b0_.is_published = 1 GROUP BY b0_.id, b0_.name, b0_.slug HAVING COUNT(DISTINCT p1_.id) > 0 ORDER BY name_1 ASC
Parameters:
[ 1526 0.0 0.0 73 ] |
|
0.04 ms (0.82%) |
1 |
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.brand_id = ? ORDER BY t0.id DESC
Parameters:
[
73
]
|
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\CurrencyValue | 1062 |
| App\Entity\File | 37 |
| App\Entity\ProductPropertyValue | 27 |
| App\Entity\Product | 14 |
| App\Entity\ProductProperty | 6 |
| App\Entity\BrandSeries | 2 |
| App\Entity\Category | 1 |
| App\Entity\Currency | 1 |
| App\Entity\Brand | 1 |
| App\Entity\Country | 1 |
| App\Entity\BrandSeriesGroup | 1 |
| App\Entity\BrandSeriesCategory | 1 |
| App\Entity\ProductPropertyGroup | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category |
|
| App\Entity\File | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\CategoryProductProperty | No errors. |
| App\Entity\CategoryBrand | No errors. |
| App\Entity\ProductProperty | No errors. |
| App\Entity\Brand |
|
| App\Entity\Currency |
|
| App\Entity\Country | No errors. |
| App\Entity\BrandSeries | No errors. |
| App\Entity\Model |
|
| App\Entity\DiskFolder | No errors. |
| App\Entity\ProductPropertyValue | No errors. |
| App\Entity\ShopProduct | No errors. |
| App\Entity\BrandSeriesCategory | No errors. |
| App\Entity\BrandCurrencyValue | No errors. |
| App\Entity\CurrencyValue |
|
| App\Entity\BrandSeriesGroup | No errors. |
| App\Entity\Shop | No errors. |
| App\Entity\ProductPropertyGroup | No errors. |