Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.48 ms Query time

5 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	0.48 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: [`"266293-kombinirovanniy-napolniy-vodonagrevatel-green-line-eldom-fv30067s21-s-dvumya-parallelnymi-teploobmennikami-300-l…"`] 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 = '266293-kombinirovanniy-napolniy-vodonagrevatel-green-line-eldom-fv30067s21-s-dvumya-parallelnymi-teploobmennikami-300-l…' LIMIT 1;

#▲

Time

Info

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

[
  "266293-kombinirovanniy-napolniy-vodonagrevatel-green-line-eldom-fv30067s21-s-dvumya-parallelnymi-teploobmennikami-300-l…"
]

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 = '266293-kombinirovanniy-napolniy-vodonagrevatel-green-line-eldom-fv30067s21-s-dvumya-parallelnymi-teploobmennikami-300-l…' 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

Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\Brand	The field App\Entity\Brand#currencyValue is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BrandCurrencyValue#brand does not contain the required 'inversedBy="currencyValue"' attribute.
App\Entity\File	No errors.
App\Entity\Currency	The mappings App\Entity\Currency#currencyValue and App\Entity\CurrencyValue#currency are inconsistent with each other.
App\Entity\Country	No errors.
App\Entity\BrandSeries	No errors.
App\Entity\Model	The association App\Entity\Model#brand refers to the inverse side field App\Entity\Brand#models which does not exist.
App\Entity\Category	The field App\Entity\Category#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\DiskFolder	No errors.
App\Entity\CategoryBrand	No errors.
App\Entity\BrandCurrencyValue	No errors.
App\Entity\CurrencyValue	The association App\Entity\CurrencyValue#currency refers to the inverse side field App\Entity\Currency#value which does not exist.
App\Entity\BrandSeriesGroup	No errors.

Symfony Profiler

GET https://lk.vodokomfort.ru/api/v1/product/266293-kombinirovanniy-napolniy-vodonagrevatel-green-line-eldom-fv30067s21-s-dvumya-parallelnymi-teploobmennikami-300-l…

Configuration Settings

Theme

Page Width