Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.22 ms Query time

4 Invalid entities

8 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	0.50 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: [`"46359-geberit-uglovoe-shtucernoe-soedinenie-mapress-iz-medi-65386 }}"`] View formatted query View runnable query Explain query 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 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 = '46359-geberit-uglovoe-shtucernoe-soedinenie-mapress-iz-medi-65386 }}' LIMIT 1;
2	0.72 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: [`46359`] View formatted query View runnable query Explain query 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 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 = 46359 LIMIT 1;

#▲

Time

Info

0.50 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:

[
  "46359-geberit-uglovoe-shtucernoe-soedinenie-mapress-iz-medi-65386 }}"
]

View formatted query View runnable query Explain query

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

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 = '46359-geberit-uglovoe-shtucernoe-soedinenie-mapress-iz-medi-65386 }}' LIMIT 1;

0.72 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:

[
  46359
]

View formatted query View runnable query Explain query

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

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 = 46359 LIMIT 1;

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	2
App\Entity\Product	1
App\Entity\Currency	1
App\Entity\Brand	1
App\Entity\Country	1
App\Entity\BrandSeries	1
App\Entity\BrandSeriesGroup	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\DiskFolder	No errors.
App\Entity\BrandSeriesGroup	No errors.
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\BrandSeriesCategory	No errors.
App\Entity\CategoryBrand	No errors.
App\Entity\BrandCurrencyValue	No errors.

Symfony Profiler

GET https://lk.vodokomfort.ru/index.php/product/46359-geberit-uglovoe-shtucernoe-soedinenie-mapress-iz-medi-65386%20%7D%7D

Configuration Settings

Theme

Page Width