Query Metrics
36
Database Queries
18
Different statements
7.50 ms
Query time
5
Invalid entities
54
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.08 ms |
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.slug = ? AND t0.is_published = ? LIMIT 1
Parameters:
[ "danfoss" 1 ] |
| 2 | 0.95 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.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_id = ? AND t0.slug = ? AND t0.is_published = ? LIMIT 1
Parameters:
[ 6 "thermostat-radiator-accessory" 1 ] |
| 3 | 0.54 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.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:
[
139
]
|
| 4 | 0.32 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.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:
[
139
]
|
| 5 | 1.05 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, f3_.id AS id_76, f3_.name AS name_77, f3_.image_width AS image_width_78, f3_.image_height AS image_height_79, f3_.type AS type_80, f3_.bytes AS bytes_81, f3_.created_at AS created_at_82, f3_.is_tested AS is_tested_83, f3_.title AS title_84, f3_.description AS description_85, f3_.priority AS priority_86, f3_.filename_original AS filename_original_87, f3_.checked AS checked_88, f4_.id AS id_89, f4_.name AS name_90, f4_.image_width AS image_width_91, f4_.image_height AS image_height_92, f4_.type AS type_93, f4_.bytes AS bytes_94, f4_.created_at AS created_at_95, f4_.is_tested AS is_tested_96, f4_.title AS title_97, f4_.description AS description_98, f4_.priority AS priority_99, f4_.filename_original AS filename_original_100, f4_.checked AS checked_101, p0_.brand_id AS brand_id_102, p0_.file_list_id AS file_list_id_103, p0_.currency_id AS currency_id_104, p0_.currency_client_id AS currency_client_id_105, p0_.country_id AS country_id_106, p0_.brand_series_id AS brand_series_id_107, p0_.model_id AS model_id_108, b1_.file_id AS file_id_109, b1_.country_id AS country_id_110, b1_.disk_folder_id AS disk_folder_id_111, f2_.file_display_id AS file_display_id_112, f2_.file_preview_id AS file_preview_id_113, f3_.file_display_id AS file_display_id_114, f3_.file_preview_id AS file_preview_id_115, f4_.file_display_id AS file_display_id_116, f4_.file_preview_id AS file_preview_id_117 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN file f2_ ON p0_.file_list_id = f2_.id LEFT JOIN file f3_ ON f2_.file_preview_id = f3_.id LEFT JOIN file f4_ ON f2_.file_display_id = f4_.id WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND p0_.is_published = ? AND p0_.is_service = ? AND p0_.brand_series_id IN (139) ORDER BY p0_.is_show_price DESC, p0_.is_on_sale DESC, sclr_0 DESC, sclr_2 DESC, sclr_1 DESC, p0_.is_actual DESC, p0_.file_list_id DESC LIMIT 50
Parameters:
[ 1 0 ] |
| 6 | 0.57 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 LEFT JOIN file f3_ ON f2_.file_preview_id = f3_.id LEFT JOIN file f4_ ON f2_.file_display_id = f4_.id WHERE p0_.is_archives = 0 AND (b1_.id IS NULL OR b1_.is_published = 1) AND p0_.is_published = ? AND p0_.is_service = ? AND p0_.brand_series_id IN (139) ORDER BY p0_.id ASC
Parameters:
[ 1 0 ] |
| 7 | 0.04 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
]
|
| 8 | 0.20 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
]
|
| 9 | 0.30 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:
[
"ea0357a3-e33b-475c-bf4a-72cdacc622a5"
]
|
| 10 | 0.13 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:
[
"/brand/danfoss/series/thermostat-radiator-accessory"
]
|
| 11 | 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
]
|
| 12 | 0.06 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:
[
2
]
|
| 13 | 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
]
|
| 14 | 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:
[
3
]
|
| 15 | 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:
[
6
]
|
| 16 | 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:
[
8
]
|
| 17 | 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
]
|
| 18 | 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:
[
10
]
|
| 19 | 0.06 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:
[
"ea0357a3-e33b-475c-bf4a-72cdacc622a5"
]
|
| 20 | 1.28 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:
[
"ea0357a3-e33b-475c-bf4a-72cdacc622a5"
]
|
| 21 | 0.04 ms |
SELECT COUNT(*) FROM user_notification t0 WHERE t0.user_id IS NULL AND t0.is_read = ?
Parameters:
[
0
]
|
| 22 | 0.03 ms |
SELECT COUNT(*) FROM `order` t0 WHERE t0.user_id IS NULL
Parameters:
[] |
| 23 | 0.03 ms |
SELECT COUNT(*) FROM feedback t0 WHERE t0.user_id IS NULL AND t0.closed_at IS NULL
Parameters:
[] |
| 24 | 0.06 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_file ON t0.id = brand_series_file.file_id WHERE brand_series_file.brand_series_id = ?
Parameters:
[
139
]
|
| 25 | 0.06 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:
[
34993
]
|
| 26 | 0.06 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:
[
34757
]
|
| 27 | 0.37 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:
[
34991
]
|
| 28 | 0.16 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:
[
34822
]
|
| 29 | 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_duplicates ON t0.id = product_duplicates.product_target WHERE product_duplicates.product_source = ?
Parameters:
[
34992
]
|
| 30 | 0.11 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:
[
34823
]
|
| 31 | 0.14 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:
[
34995
]
|
| 32 | 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_duplicates ON t0.id = product_duplicates.product_target WHERE product_duplicates.product_source = ?
Parameters:
[
34824
]
|
| 33 | 0.04 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:
[
34994
]
|
| 34 | 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_duplicates ON t0.id = product_duplicates.product_target WHERE product_duplicates.product_source = ?
Parameters:
[
1200
]
|
| 35 | 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_duplicates ON t0.id = product_duplicates.product_target WHERE product_duplicates.product_source = ?
Parameters:
[
11959
]
|
| 36 | 0.08 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:
[
139
]
|
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 | 20 |
| App\Entity\Product | 11 |
| App\Entity\Delivery | 10 |
| App\Entity\Shop | 7 |
| App\Entity\Currency | 2 |
| App\Entity\Brand | 1 |
| App\Entity\Country | 1 |
| App\Entity\BrandSeries | 1 |
| App\Entity\BrandSeriesGroup | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Brand |
|
| 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\BrandSeries | No errors. |
| App\Entity\BrandSeriesGroup | No errors. |
| App\Entity\Currency |
|
| App\Entity\Model |
|
| App\Entity\Category |
|
| App\Entity\ProductPropertyValue | No errors. |
| App\Entity\ShopProduct | No errors. |
| App\Entity\CurrencyValue |
|
| App\Entity\WishProduct | No errors. |
| App\Entity\Profile\User | No errors. |
| App\Entity\PageTag | No errors. |
| App\Entity\Delivery | No errors. |
| App\Entity\Shop | No errors. |
| App\Entity\Order\Order | No errors. |
| App\Entity\DiskFile | No errors. |
| App\Entity\CategoryProductProperty | No errors. |
| App\Entity\ProductProperty | No errors. |
| App\Entity\ProductPropertyGroup | 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\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\FeedbackMessage | No errors. |
| App\Entity\CartProduct | No errors. |