Query Metrics

31 Database Queries
25 Different statements
58.68 ms Query time
5 Invalid entities
722 Managed entities

Queries

Group similar statements

# Time Info
1 0.55 ms
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.slug = ? LIMIT 1
Parameters:
[
  "9589-grundfos-nbe-konsolno-monoblochniy-nasos-80-160-161af2abaqe-96539050"
]
2 0.11 ms
SELECT p0_.id AS id_0, p0_.is_published AS is_published_1, p0_.is_on_sale AS is_on_sale_2, p0_.name AS name_3, p0_.s1_code AS s1_code_4, p0_.description AS description_5, p0_.is_description_unique AS is_description_unique_6, p0_.product_code AS product_code_7, p0_.seo_name AS seo_name_8, p0_.seo_description AS seo_description_9, p0_.previous_id AS previous_id_10, p0_.created_at AS created_at_11, p0_.price_value AS price_value_12, p0_.price_value_client AS price_value_client_13, p0_.imported_at AS imported_at_14, p0_.set_categories_at AS set_categories_at_15, p0_.is_archives AS is_archives_16, p0_.temp_price_value AS temp_price_value_17, p0_.updated_at AS updated_at_18, p0_.is_api_image AS is_api_image_19, p0_.file_order AS file_order_20, p0_.slug AS slug_21, p0_.unit AS unit_22, p0_.replaced_s1_code AS replaced_s1_code_23, p0_.is_show_price AS is_show_price_24, p0_.is_service AS is_service_25, p0_.promo_description AS promo_description_26, p0_.s1_slug AS s1_slug_27, p0_.is_actual AS is_actual_28, p0_.ratio AS ratio_29, p0_.shop_count AS shop_count_30, p0_.is_sale AS is_sale_31, p0_.is_sale_admin AS is_sale_admin_32, p0_.direct_code AS direct_code_33, p0_.temp_product_code_duplicates AS temp_product_code_duplicates_34, b1_.id AS id_35, b1_.name AS name_36, b1_.is_published AS is_published_37, b1_.slug AS slug_38, b1_.description AS description_39, b1_.sort AS sort_40, b1_.intro AS intro_41, b1_.temp_products_count AS temp_products_count_42, b1_.is_drop_down AS is_drop_down_43, b1_.link_advertising AS link_advertising_44, b1_.link_catalogue AS link_catalogue_45, b1_.link_instruction AS link_instruction_46, b1_.link_certificate AS link_certificate_47, b1_.link_shop AS link_shop_48, b1_.description_corporate AS description_corporate_49, b1_.is_published_corporate AS is_published_corporate_50, b1_.heading AS heading_51, b1_.heading_corporate AS heading_corporate_52, b1_.is_show_catalogue AS is_show_catalogue_53, b1_.alias AS alias_54, b1_.categories_updated_at AS categories_updated_at_55, b1_.is_description_corporate_full_page AS is_description_corporate_full_page_56, b1_.is_description_full_page AS is_description_full_page_57, b1_.sort_corporate AS sort_corporate_58, b1_.is_original AS is_original_59, b2_.id AS id_60, b2_.name AS name_61, b2_.slug AS slug_62, b2_.is_published AS is_published_63, b2_.created_at AS created_at_64, b2_.sort AS sort_65, b2_.intro AS intro_66, b2_.description AS description_67, b2_.title AS title_68, b2_.description_product_all AS description_product_all_69, p0_.brand_id AS brand_id_70, p0_.file_list_id AS file_list_id_71, p0_.currency_id AS currency_id_72, p0_.currency_client_id AS currency_client_id_73, p0_.country_id AS country_id_74, p0_.brand_series_id AS brand_series_id_75, p0_.model_id AS model_id_76, b1_.file_id AS file_id_77, b1_.country_id AS country_id_78, b1_.disk_folder_id AS disk_folder_id_79, b2_.brand_id AS brand_id_80, b2_.file_id AS file_id_81, b2_.brand_series_group_id AS brand_series_group_id_82, b2_.intro_file_id AS intro_file_id_83, b2_.brand_series_id AS brand_series_id_84 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN brand_series b2_ ON p0_.brand_series_id = b2_.id WHERE p0_.is_archives = 0 AND p0_.is_published = 1 AND p0_.id = ? LIMIT 1
Parameters:
[
  9589
]
3 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.sort AS sort_4, t0.value AS value_5 FROM property t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "PRODUCT_HIDE_PRICE"
]
4 0.66 ms
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 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
Parameters:
[
  9589
]
5 0.17 ms
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
]
6 51.38 ms
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.is_from_s1 AS is_from_s1_2, p0_.created_at AS created_at_3, p0_.is_from_command AS is_from_command_4, p0_.sort AS sort_5, p1_.id AS id_6, p1_.name AS name_7, p1_.created_at AS created_at_8, p1_.is_from_s1 AS is_from_s1_9, p1_.type AS type_10, p1_.parameters AS parameters_11, p1_.is_for_analogues AS is_for_analogues_12, p1_.is_new AS is_new_13, p2_.id AS id_14, p2_.name AS name_15, p2_.sort AS sort_16, p2_.previous_id AS previous_id_17, p2_.is_published AS is_published_18, p2_.created_at AS created_at_19, p2_.is_from_s1 AS is_from_s1_20, p0_.product_id AS product_id_21, p0_.product_property_id AS product_property_id_22, p0_.product_property_group_id AS product_property_group_id_23 FROM product_property_value p0_ INNER JOIN product_property p1_ ON p0_.product_property_id = p1_.id AND (p1_.id = p0_.product_property_id) INNER JOIN product_property_group p2_ ON p0_.product_property_group_id = p2_.id AND (p2_.id = p0_.product_property_group_id) WHERE p0_.product_id = ? AND p2_.is_published = 1 ORDER BY p2_.sort ASC, p2_.id ASC, p0_.sort ASC
Parameters:
[
  9589
]
7 0.51 ms
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:
[
  9589
]
8 0.47 ms
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:
[
  9589
]
9 0.08 ms
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.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.is_availability = ? AND t0.is_published = ? ORDER BY t0.is_main DESC, t0.sort ASC, t0.name ASC
Parameters:
[
  1
  1
]
10 0.27 ms
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.shop_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0.product_id = ?
Parameters:
[
  11
  15
  20
  10
  3
  6
  4
  2
  8
  9589
]
11 0.11 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.product_id AS product_id_4, t0.user_id AS user_id_5 FROM wish_product t0 WHERE t0.session_id = ? AND t0.product_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  "2e701e49-29c0-4932-90d5-71ffa7136050"
  9589
]
12 0.17 ms
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_product ON t0.id = product_product.product_target WHERE product_product.product_source = ?
Parameters:
[
  9589
]
13 0.12 ms
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_product ON t0.id = product_product.product_source WHERE product_product.product_target = ?
Parameters:
[
  9589
]
14 0.03 ms
SELECT t0.id AS id_1, t0.is_included_children1 AS is_included_children1_2, t0.is_included_children2 AS is_included_children2_3, t0.is_published AS is_published_4, t0.category1_id AS category1_id_5, t0.category2_id AS category2_id_6 FROM category_link t0 WHERE t0.category1_id = ? AND t0.is_published = ?
Parameters:
[
  1003
  1
]
15 0.03 ms
SELECT t0.id AS id_1, t0.is_included_children1 AS is_included_children1_2, t0.is_included_children2 AS is_included_children2_3, t0.is_published AS is_published_4, t0.category1_id AS category1_id_5, t0.category2_id AS category2_id_6 FROM category_link t0 WHERE t0.category2_id = ? AND t0.is_published = ?
Parameters:
[
  1003
  1
]
16 0.03 ms
SELECT t0.id AS id_1, t0.is_included_children1 AS is_included_children1_2, t0.is_included_children2 AS is_included_children2_3, t0.is_published AS is_published_4, t0.category1_id AS category1_id_5, t0.category2_id AS category2_id_6 FROM category_link t0 WHERE t0.category1_id = ? AND t0.is_published = ?
Parameters:
[
  1035
  1
]
17 0.03 ms
SELECT t0.id AS id_1, t0.is_included_children1 AS is_included_children1_2, t0.is_included_children2 AS is_included_children2_3, t0.is_published AS is_published_4, t0.category1_id AS category1_id_5, t0.category2_id AS category2_id_6 FROM category_link t0 WHERE t0.category2_id = ? AND t0.is_published = ?
Parameters:
[
  1035
  1
]
18 0.03 ms
SELECT t0.id AS id_1, t0.is_included_children1 AS is_included_children1_2, t0.is_included_children2 AS is_included_children2_3, t0.is_published AS is_published_4, t0.category1_id AS category1_id_5, t0.category2_id AS category2_id_6 FROM category_link t0 WHERE t0.category1_id = ? AND t0.is_published = ?
Parameters:
[
  1042
  1
]
19 0.03 ms
SELECT t0.id AS id_1, t0.is_included_children1 AS is_included_children1_2, t0.is_included_children2 AS is_included_children2_3, t0.is_published AS is_published_4, t0.category1_id AS category1_id_5, t0.category2_id AS category2_id_6 FROM category_link t0 WHERE t0.category2_id = ? AND t0.is_published = ?
Parameters:
[
  1042
  1
]
20 0.59 ms
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 WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND p0_.is_published = ? AND p0_.is_actual = ? AND p0_.is_service = ? 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
Parameters:
[
  1
  1
  0
]
21 0.18 ms
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 WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND p0_.is_published = ? AND p0_.is_actual = ? AND p0_.is_service = ? ORDER BY p0_.id ASC
Parameters:
[
  1
  1
  0
]
22 0.18 ms
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
]
23 0.31 ms
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_analogues ON t0.id = product_analogues.product_target WHERE product_analogues.product_source = ?
Parameters:
[
  9589
]
24 0.46 ms
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_analogues ON t0.id = product_analogues.product_source WHERE product_analogues.product_target = ?
Parameters:
[
  9589
]
25 0.16 ms
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:
[
  134
]
26 0.19 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.description AS description_4, t0.h1 AS h1_5 FROM page_tag t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "/product/9589-grundfos-nbe-konsolno-monoblochniy-nasos-80-160-161af2abaqe-96539050"
]
27 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_default AS is_default_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.price AS price_6, t0.is_address AS is_address_7, t0.is_time AS is_time_8, t0.description AS description_9, t0.comment AS comment_10, t0.code AS code_11, t0.price_comment AS price_comment_12, t0.use_auto_payment AS use_auto_payment_13, t0.default_city AS default_city_14, t0.price_min AS price_min_15, t0.shop_id AS shop_id_16 FROM delivery t0 WHERE t0.is_published = ? ORDER BY t0.sort ASC
Parameters:
[
  1
]
28 0.04 ms
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.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = ?
Parameters:
[
  1
]
29 0.04 ms
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.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = ?
Parameters:
[
  7
]
30 0.21 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.product_id AS product_id_4, t0.user_id AS user_id_5 FROM wish_product t0 WHERE t0.session_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  "2e701e49-29c0-4932-90d5-71ffa7136050"
]
31 1.37 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.count AS count_3, t0.created_at AS created_at_4, t0.price AS price_5, t0.product_id AS product_id_6, t0.user_id AS user_id_7 FROM cart_product t0 WHERE t0.session_id = ? ORDER BY t0.created_at ASC
Parameters:
[
  "2e701e49-29c0-4932-90d5-71ffa7136050"
]

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\File 340
App\Entity\Product 174
App\Entity\ProductPropertyValue 61
App\Entity\ProductProperty 56
App\Entity\BrandSeries 20
App\Entity\Brand 16
App\Entity\Category 13
App\Entity\Shop 11
App\Entity\Delivery 10
App\Entity\ProductPropertyGroup 8
App\Entity\Country 7
App\Entity\Currency 3
App\Entity\BrandSeriesGroup 1
App\Entity\Property 1
App\Entity\DiskFolder 1

Entities Mapping

Class Mapping errors
App\Entity\Product No 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\Currency
  • The mappings App\Entity\Currency#currencyValue and App\Entity\CurrencyValue#currency are inconsistent with each other.
App\Entity\Country No errors.
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\DiskFolder No errors.
App\Entity\BrandSeriesGroup No errors.
App\Entity\BrandSeriesCategory No errors.
App\Entity\CategoryBrand No errors.
App\Entity\BrandCurrencyValue No errors.
App\Entity\Property No errors.
App\Entity\CategoryProductProperty 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\ProductProperty No errors.
App\Entity\ProductPropertyGroup No errors.
App\Entity\Shop No errors.
App\Entity\Order\Order No errors.
App\Entity\WishProduct No errors.
App\Entity\Profile\User No errors.
App\Entity\CategoryLink No errors.
App\Entity\PageTag No errors.
App\Entity\Delivery No errors.
App\Entity\DiskFile No errors.
App\Entity\Order\OrderProduct No errors.
App\Entity\Profile\Address No errors.
App\Entity\Order\OrderDescription No errors.
App\Entity\Profile\Company No errors.
App\Entity\Order\OrderPayForm No errors.
App\Entity\Order\OrderPayment No errors.
App\Entity\Order\OrderStatus No errors.
App\Entity\Payment\PaymentMethod No errors.
App\Entity\Profile\UserCompany No errors.
App\Entity\Profile\UserAddress No errors.
App\Entity\Profile\UserNotification No errors.
App\Entity\Profile\Feedback No errors.
App\Entity\Profile\FeedbackMessage No errors.
App\Entity\CartProduct No errors.