Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.30 ms Query time

0 Invalid entities

6 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.52 ms

SELECT p0_.id AS id_0, p0_.data_type AS data_type_1, p0_.string_value AS string_value_2, p0_.text_value AS text_value_3, p0_.int_value AS int_value_4, p0_.decimal_value AS decimal_value_5, p0_.bool_value AS bool_value_6, p0_.date_value AS date_value_7, p0_.json_value AS json_value_8, p0_.unit AS unit_9, p0_.position AS position_10, p0_.sort_order AS sort_order_11, p1_.id AS id_12, p1_.name AS name_13, p1_.slug AS slug_14, p1_.sort_order AS sort_order_15, p1_.effective_price AS effective_price_16, p1_.status AS status_17, p1_.type AS type_18, p1_.quantity AS quantity_19, p1_.options_json AS options_json_20, p1_.attribute_json AS attribute_json_21, p1_.code AS code_22, p1_.description AS description_23, p1_.similar_group_id AS similar_group_id_24, p1_.price AS price_25, p1_.sale_price AS sale_price_26, p1_.currency AS currency_27, p1_.date_added AS date_added_28, p1_.date_edited AS date_edited_29, a2_.id AS id_30, a2_.name AS name_31, a2_.sort_order AS sort_order_32, a2_.show_in_category AS show_in_category_33, a2_.short_name AS short_name_34, a2_.code AS code_35, a3_.id AS id_36, a3_.name AS name_37, a3_.sort_order AS sort_order_38, a3_.code AS code_39, p0_.product_id AS product_id_40, p0_.attribute_id AS attribute_id_41, p0_.attribute_group_id AS attribute_group_id_42, p1_.manufacturer_id AS manufacturer_id_43, p1_.series_id AS series_id_44, a2_.attribute_group_id AS attribute_group_id_45 FROM product_attribute_assignment p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN attribute a2_ ON p0_.attribute_id = a2_.id LEFT JOIN attribute_group a3_ ON p0_.attribute_group_id = a3_.id WHERE p0_.id = ?

Parameters:

[
  3447
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.data_type AS data_type_1,
  p0_.string_value AS string_value_2,
  p0_.text_value AS text_value_3,
  p0_.int_value AS int_value_4,
  p0_.decimal_value AS decimal_value_5,
  p0_.bool_value AS bool_value_6,
  p0_.date_value AS date_value_7,
  p0_.json_value AS json_value_8,
  p0_.unit AS unit_9,
  p0_.position AS position_10,
  p0_.sort_order AS sort_order_11,
  p1_.id AS id_12,
  p1_.name AS name_13,
  p1_.slug AS slug_14,
  p1_.sort_order AS sort_order_15,
  p1_.effective_price AS effective_price_16,
  p1_.status AS status_17,
  p1_.type AS type_18,
  p1_.quantity AS quantity_19,
  p1_.options_json AS options_json_20,
  p1_.attribute_json AS attribute_json_21,
  p1_.code AS code_22,
  p1_.description AS description_23,
  p1_.similar_group_id AS similar_group_id_24,
  p1_.price AS price_25,
  p1_.sale_price AS sale_price_26,
  p1_.currency AS currency_27,
  p1_.date_added AS date_added_28,
  p1_.date_edited AS date_edited_29,
  a2_.id AS id_30,
  a2_.name AS name_31,
  a2_.sort_order AS sort_order_32,
  a2_.show_in_category AS show_in_category_33,
  a2_.short_name AS short_name_34,
  a2_.code AS code_35,
  a3_.id AS id_36,
  a3_.name AS name_37,
  a3_.sort_order AS sort_order_38,
  a3_.code AS code_39,
  p0_.product_id AS product_id_40,
  p0_.attribute_id AS attribute_id_41,
  p0_.attribute_group_id AS attribute_group_id_42,
  p1_.manufacturer_id AS manufacturer_id_43,
  p1_.series_id AS series_id_44,
  a2_.attribute_group_id AS attribute_group_id_45
FROM
  product_attribute_assignment p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
  INNER JOIN attribute a2_ ON p0_.attribute_id = a2_.id
  LEFT JOIN attribute_group a3_ ON p0_.attribute_group_id = a3_.id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.data_type AS data_type_1, p0_.string_value AS string_value_2, p0_.text_value AS text_value_3, p0_.int_value AS int_value_4, p0_.decimal_value AS decimal_value_5, p0_.bool_value AS bool_value_6, p0_.date_value AS date_value_7, p0_.json_value AS json_value_8, p0_.unit AS unit_9, p0_.position AS position_10, p0_.sort_order AS sort_order_11, p1_.id AS id_12, p1_.name AS name_13, p1_.slug AS slug_14, p1_.sort_order AS sort_order_15, p1_.effective_price AS effective_price_16, p1_.status AS status_17, p1_.type AS type_18, p1_.quantity AS quantity_19, p1_.options_json AS options_json_20, p1_.attribute_json AS attribute_json_21, p1_.code AS code_22, p1_.description AS description_23, p1_.similar_group_id AS similar_group_id_24, p1_.price AS price_25, p1_.sale_price AS sale_price_26, p1_.currency AS currency_27, p1_.date_added AS date_added_28, p1_.date_edited AS date_edited_29, a2_.id AS id_30, a2_.name AS name_31, a2_.sort_order AS sort_order_32, a2_.show_in_category AS show_in_category_33, a2_.short_name AS short_name_34, a2_.code AS code_35, a3_.id AS id_36, a3_.name AS name_37, a3_.sort_order AS sort_order_38, a3_.code AS code_39, p0_.product_id AS product_id_40, p0_.attribute_id AS attribute_id_41, p0_.attribute_group_id AS attribute_group_id_42, p1_.manufacturer_id AS manufacturer_id_43, p1_.series_id AS series_id_44, a2_.attribute_group_id AS attribute_group_id_45 FROM product_attribute_assignment p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id INNER JOIN attribute a2_ ON p0_.attribute_id = a2_.id LEFT JOIN attribute_group a3_ ON p0_.attribute_group_id = a3_.id WHERE p0_.id = 3447;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 89)
7	ApiPlatform\State\CallableProvider->provide (line 43)
8	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
9	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
10	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
11	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
12	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
14	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
16	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
17	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
18	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.87 ms

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?

Parameters:

[
  268
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.meta_title AS meta_title_1,
  t0.meta_description AS meta_description_2,
  t0.meta_keywords AS meta_keywords_3,
  t0.h1 AS h1_4,
  t0.product_id AS product_id_5
FROM
  product_seo t0
WHERE
  t0.product_id = ?

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = 268;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 442)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 89)
12	ApiPlatform\State\CallableProvider->provide (line 43)
13	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
14	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
16	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
17	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
18	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
19	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
20	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
21	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
22	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
23	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
24	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.91 ms

SELECT t0.id AS id_1, t0.data_type AS data_type_2, t0.string_value AS string_value_3, t0.text_value AS text_value_4, t0.int_value AS int_value_5, t0.decimal_value AS decimal_value_6, t0.bool_value AS bool_value_7, t0.date_value AS date_value_8, t0.json_value AS json_value_9, t0.unit AS unit_10, t0.position AS position_11, t0.sort_order AS sort_order_12, t0.product_id AS product_id_13, t0.attribute_id AS attribute_id_14, t0.attribute_group_id AS attribute_group_id_15 FROM product_attribute_assignment t0 WHERE t0.id = ?

Parameters:

[
  3447
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.data_type AS data_type_2,
  t0.string_value AS string_value_3,
  t0.text_value AS text_value_4,
  t0.int_value AS int_value_5,
  t0.decimal_value AS decimal_value_6,
  t0.bool_value AS bool_value_7,
  t0.date_value AS date_value_8,
  t0.json_value AS json_value_9,
  t0.unit AS unit_10,
  t0.position AS position_11,
  t0.sort_order AS sort_order_12,
  t0.product_id AS product_id_13,
  t0.attribute_id AS attribute_id_14,
  t0.attribute_group_id AS attribute_group_id_15
FROM
  product_attribute_assignment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.data_type AS data_type_2, t0.string_value AS string_value_3, t0.text_value AS text_value_4, t0.int_value AS int_value_5, t0.decimal_value AS decimal_value_6, t0.bool_value AS bool_value_7, t0.date_value AS date_value_8, t0.json_value AS json_value_9, t0.unit AS unit_10, t0.position AS position_11, t0.sort_order AS sort_order_12, t0.product_id AS product_id_13, t0.attribute_id AS attribute_id_14, t0.attribute_group_id AS attribute_group_id_15 FROM product_attribute_assignment t0 WHERE t0.id = 3447;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->refresh (line 853)
2	Doctrine\ORM\UnitOfWork->doRefresh (line 2019)
3	Doctrine\ORM\UnitOfWork->refresh (line 1981)
4	Doctrine\ORM\EntityManager->refresh (line 466)
5	ApiPlatform\Doctrine\Common\State\PersistProcessor->process (line 145)
6	ApiPlatform\State\CallableProcessor->process (line 52)
7	ApiPlatform\State\Processor\WriteProcessor->process (line 58)
8	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

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\ProductAttributeAssignment	1
App\Entity\Product	1
App\Entity\Category	1
App\Entity\ProductSeo	1
App\Entity\Attribute	1
App\Entity\AttributeGroup	1

Entities Mapping

Class	Mapping errors
App\Entity\ProductAttributeAssignment	No errors.
App\Entity\Embeddable\ProductPrice	No errors.
App\Entity\Embeddable\ProductTimestamps	No errors.
App\Entity\Product	No errors.
App\Entity\Attribute	No errors.
App\Entity\AttributeGroup	No errors.
App\Entity\Manufacturer	No errors.
App\Entity\Category	No errors.
App\Entity\ProductSeo	No errors.
App\Entity\ProductToCategory	No errors.
App\Entity\ProductImage	No errors.
App\Entity\Badge	No errors.
App\Entity\Carousel	No errors.
App\Entity\ProductOptionValueAssignment	No errors.
App\Entity\RelatedProduct	No errors.
App\Entity\Review	No errors.
App\Entity\ProductVideo	No errors.

Symfony Profiler

PATCH https://www.lustra-bronza.ru/api/product_attribute_assignments/3447

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping