Query Metrics
36
Database Queries
29
Different statements
6.70 ms
Query time
5
Invalid entities
588
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.24 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:
[
"46198-geberit-perehodnik-mapress-iz-medi-s-naruzhnoy-rezboy-61710"
]
|
| 2 | 0.23 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:
[
46198
]
|
| 3 | 0.16 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.25 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:
[
46198
]
|
| 5 | 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:
[
1
]
|
| 6 | 0.41 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:
[
46198
]
|
| 7 | 0.17 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:
[
46198
]
|
| 8 | 0.05 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 WHERE t0.id = ? LIMIT 1
Parameters:
[ "" ] |
| 9 | 0.04 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 brand_series_product_file ON t0.id = brand_series_product_file.file_id WHERE brand_series_product_file.brand_series_id = ?
Parameters:
[
704
]
|
| 10 | 0.15 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:
[
46198
]
|
| 11 | 0.05 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 ] |
| 12 | 0.15 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 46198 ] |
| 13 | 0.09 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:
[ "91e28371-488b-47e6-8072-ae7b604e8f80" 46198 ] |
| 14 | 0.13 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:
[
46198
]
|
| 15 | 0.24 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:
[
46198
]
|
| 16 | 0.04 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:
[ 1507 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:
[ 1507 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:
[ 1508 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:
[ 1508 1 ] |
| 20 | 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:
[ 1582 1 ] |
| 21 | 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:
[ 1582 1 ] |
| 22 | 0.94 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 ] |
| 23 | 0.07 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 ] |
| 24 | 0.03 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
]
|
| 25 | 0.03 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:
[
2
]
|
| 26 | 0.40 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:
[
46198
]
|
| 27 | 0.13 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:
[
46198
]
|
| 28 | 0.15 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/46198-geberit-perehodnik-mapress-iz-medi-s-naruzhnoy-rezboy-61710"
]
|
| 29 | 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
]
|
| 30 | 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
]
|
| 31 | 0.03 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
]
|
| 32 | 0.42 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:
[
"91e28371-488b-47e6-8072-ae7b604e8f80"
]
|
| 33 | 1.61 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:
[
"91e28371-488b-47e6-8072-ae7b604e8f80"
]
|
| 34 | 0.04 ms |
SELECT COUNT(*) FROM user_notification t0 WHERE t0.user_id IS NULL AND t0.is_read = ?
Parameters:
[
0
]
|
| 35 | 0.03 ms |
SELECT COUNT(*) FROM `order` t0 WHERE t0.user_id IS NULL
Parameters:
[] |
| 36 | 0.02 ms |
SELECT COUNT(*) FROM feedback t0 WHERE t0.user_id IS NULL AND t0.closed_at IS NULL
Parameters:
[] |
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 | 341 |
| App\Entity\Product | 174 |
| App\Entity\BrandSeries | 20 |
| App\Entity\Brand | 16 |
| App\Entity\Shop | 11 |
| App\Entity\Delivery | 10 |
| App\Entity\Country | 7 |
| App\Entity\Currency | 3 |
| App\Entity\Category | 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 |
|
| App\Entity\File | No errors. |
| App\Entity\Currency |
|
| App\Entity\Country | No errors. |
| App\Entity\BrandSeries | No errors. |
| App\Entity\Model |
|
| App\Entity\Category |
|
| 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 |
|
| 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. |