Symfony Profiler

Query Metrics

9 Database Queries

4 Different statements

27.21 ms Query time

1 Invalid entities

85 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

23.85 ms
(87.66%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.price AS price_5, p0_.is_gift_card AS is_gift_card_6, p0_.is_only_for_seo AS is_only_for_seo_7, p0_.visible AS visible_8, p0_.new AS new_9, p0_.featured AS featured_10, p0_.sku AS sku_11, p0_.meta_title AS meta_title_12, p0_.meta_description AS meta_description_13, p0_.meta_robots AS meta_robots_14, p0_.url_path AS url_path_15, p0_.buying_price AS buying_price_16, p0_.vat_rate AS vat_rate_17, p0_.weight AS weight_18, p0_.width AS width_19, p0_.height AS height_20, p0_.additional_shipping_costs AS additional_shipping_costs_21, p0_.inventory AS inventory_22, p0_.data AS data_23, p0_.created_at AS created_at_24, p0_.updated_at AS updated_at_25, p1_.id AS id_26, p1_.name AS name_27, p1_.label AS label_28, p1_.type AS type_29, p1_.ordering AS ordering_30, p2_.id AS id_31, p2_.attributes_hash AS attributes_hash_32, p2_.active AS active_33, p2_.label AS label_34, p2_.short_label AS short_label_35, p2_.sku AS sku_36, p2_.price AS price_37, p2_.buying_price AS buying_price_38, p2_.weight AS weight_39, p2_.width AS width_40, p2_.height AS height_41, p2_.additional_shipping_costs AS additional_shipping_costs_42, p2_.inventory AS inventory_43, p2_.extra_weight AS extra_weight_44, p3_.id AS id_45, p3_.name AS name_46, p3_.label AS label_47, p3_.type AS type_48, p3_.required AS required_49, p3_.ordering AS ordering_50, p4_.id AS id_51, p4_.label AS label_52, p4_.description AS description_53, p4_.value AS value_54, p4_.technical_value AS technical_value_55, p4_.extra_price AS extra_price_56, p4_.is_default AS is_default_57, p4_.ordering AS ordering_58, p5_.id AS id_59, p5_.rule_type AS rule_type_60, p5_.price_or_discount AS price_or_discount_61, p5_.discount_type AS discount_type_62, p5_.quantity_min AS quantity_min_63, p5_.quantity_max AS quantity_max_64, p5_.date_start AS date_start_65, p5_.date_end AS date_end_66, p5_.customer_group AS customer_group_67, p5_.priority AS priority_68, p5_.active AS active_69, p6_.id AS id_70, p6_.ordering AS ordering_71, p1_.product_id AS product_id_72, p2_.product_id AS product_id_73, p7_.product_variant_id AS product_variant_id_74, p7_.product_attribute_value_id AS product_attribute_value_id_75, p3_.product_id AS product_id_76, p4_.product_option_id AS product_option_id_77, p5_.product_id AS product_id_78, p5_.product_variant_id AS product_variant_id_79, p5_.shop_id AS shop_id_80, p6_.product_id AS product_id_81, p6_.media_id AS media_id_82 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant p2_ ON p0_.id = p2_.product_id LEFT JOIN product_variant_attribute p7_ ON p2_.id = p7_.product_variant_id LEFT JOIN product_option p3_ ON p0_.id = p3_.product_id LEFT JOIN product_option_value p4_ ON p3_.id = p4_.product_option_id LEFT JOIN product_pricing_rule p5_ ON p0_.id = p5_.product_id LEFT JOIN product_media p6_ ON p0_.id = p6_.product_id WHERE p0_.id = ? ORDER BY p6_.ordering ASC

Parameters:

[
  847
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.short_description AS short_description_4,
  p0_.price AS price_5,
  p0_.is_gift_card AS is_gift_card_6,
  p0_.is_only_for_seo AS is_only_for_seo_7,
  p0_.visible AS visible_8,
  p0_.new AS new_9,
  p0_.featured AS featured_10,
  p0_.sku AS sku_11,
  p0_.meta_title AS meta_title_12,
  p0_.meta_description AS meta_description_13,
  p0_.meta_robots AS meta_robots_14,
  p0_.url_path AS url_path_15,
  p0_.buying_price AS buying_price_16,
  p0_.vat_rate AS vat_rate_17,
  p0_.weight AS weight_18,
  p0_.width AS width_19,
  p0_.height AS height_20,
  p0_.additional_shipping_costs AS additional_shipping_costs_21,
  p0_.inventory AS inventory_22,
  p0_.data AS data_23,
  p0_.created_at AS created_at_24,
  p0_.updated_at AS updated_at_25,
  p1_.id AS id_26,
  p1_.name AS name_27,
  p1_.label AS label_28,
  p1_.type AS type_29,
  p1_.ordering AS ordering_30,
  p2_.id AS id_31,
  p2_.attributes_hash AS attributes_hash_32,
  p2_.active AS active_33,
  p2_.label AS label_34,
  p2_.short_label AS short_label_35,
  p2_.sku AS sku_36,
  p2_.price AS price_37,
  p2_.buying_price AS buying_price_38,
  p2_.weight AS weight_39,
  p2_.width AS width_40,
  p2_.height AS height_41,
  p2_.additional_shipping_costs AS additional_shipping_costs_42,
  p2_.inventory AS inventory_43,
  p2_.extra_weight AS extra_weight_44,
  p3_.id AS id_45,
  p3_.name AS name_46,
  p3_.label AS label_47,
  p3_.type AS type_48,
  p3_.required AS required_49,
  p3_.ordering AS ordering_50,
  p4_.id AS id_51,
  p4_.label AS label_52,
  p4_.description AS description_53,
  p4_.value AS value_54,
  p4_.technical_value AS technical_value_55,
  p4_.extra_price AS extra_price_56,
  p4_.is_default AS is_default_57,
  p4_.ordering AS ordering_58,
  p5_.id AS id_59,
  p5_.rule_type AS rule_type_60,
  p5_.price_or_discount AS price_or_discount_61,
  p5_.discount_type AS discount_type_62,
  p5_.quantity_min AS quantity_min_63,
  p5_.quantity_max AS quantity_max_64,
  p5_.date_start AS date_start_65,
  p5_.date_end AS date_end_66,
  p5_.customer_group AS customer_group_67,
  p5_.priority AS priority_68,
  p5_.active AS active_69,
  p6_.id AS id_70,
  p6_.ordering AS ordering_71,
  p1_.product_id AS product_id_72,
  p2_.product_id AS product_id_73,
  p7_.product_variant_id AS product_variant_id_74,
  p7_.product_attribute_value_id AS product_attribute_value_id_75,
  p3_.product_id AS product_id_76,
  p4_.product_option_id AS product_option_id_77,
  p5_.product_id AS product_id_78,
  p5_.product_variant_id AS product_variant_id_79,
  p5_.shop_id AS shop_id_80,
  p6_.product_id AS product_id_81,
  p6_.media_id AS media_id_82
FROM
  product p0_
  LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id
  LEFT JOIN product_variant p2_ ON p0_.id = p2_.product_id
  LEFT JOIN product_variant_attribute p7_ ON p2_.id = p7_.product_variant_id
  LEFT JOIN product_option p3_ ON p0_.id = p3_.product_id
  LEFT JOIN product_option_value p4_ ON p3_.id = p4_.product_option_id
  LEFT JOIN product_pricing_rule p5_ ON p0_.id = p5_.product_id
  LEFT JOIN product_media p6_ ON p0_.id = p6_.product_id
WHERE
  p0_.id = ?
ORDER BY
  p6_.ordering ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.short_description AS short_description_4, p0_.price AS price_5, p0_.is_gift_card AS is_gift_card_6, p0_.is_only_for_seo AS is_only_for_seo_7, p0_.visible AS visible_8, p0_.new AS new_9, p0_.featured AS featured_10, p0_.sku AS sku_11, p0_.meta_title AS meta_title_12, p0_.meta_description AS meta_description_13, p0_.meta_robots AS meta_robots_14, p0_.url_path AS url_path_15, p0_.buying_price AS buying_price_16, p0_.vat_rate AS vat_rate_17, p0_.weight AS weight_18, p0_.width AS width_19, p0_.height AS height_20, p0_.additional_shipping_costs AS additional_shipping_costs_21, p0_.inventory AS inventory_22, p0_.data AS data_23, p0_.created_at AS created_at_24, p0_.updated_at AS updated_at_25, p1_.id AS id_26, p1_.name AS name_27, p1_.label AS label_28, p1_.type AS type_29, p1_.ordering AS ordering_30, p2_.id AS id_31, p2_.attributes_hash AS attributes_hash_32, p2_.active AS active_33, p2_.label AS label_34, p2_.short_label AS short_label_35, p2_.sku AS sku_36, p2_.price AS price_37, p2_.buying_price AS buying_price_38, p2_.weight AS weight_39, p2_.width AS width_40, p2_.height AS height_41, p2_.additional_shipping_costs AS additional_shipping_costs_42, p2_.inventory AS inventory_43, p2_.extra_weight AS extra_weight_44, p3_.id AS id_45, p3_.name AS name_46, p3_.label AS label_47, p3_.type AS type_48, p3_.required AS required_49, p3_.ordering AS ordering_50, p4_.id AS id_51, p4_.label AS label_52, p4_.description AS description_53, p4_.value AS value_54, p4_.technical_value AS technical_value_55, p4_.extra_price AS extra_price_56, p4_.is_default AS is_default_57, p4_.ordering AS ordering_58, p5_.id AS id_59, p5_.rule_type AS rule_type_60, p5_.price_or_discount AS price_or_discount_61, p5_.discount_type AS discount_type_62, p5_.quantity_min AS quantity_min_63, p5_.quantity_max AS quantity_max_64, p5_.date_start AS date_start_65, p5_.date_end AS date_end_66, p5_.customer_group AS customer_group_67, p5_.priority AS priority_68, p5_.active AS active_69, p6_.id AS id_70, p6_.ordering AS ordering_71, p1_.product_id AS product_id_72, p2_.product_id AS product_id_73, p7_.product_variant_id AS product_variant_id_74, p7_.product_attribute_value_id AS product_attribute_value_id_75, p3_.product_id AS product_id_76, p4_.product_option_id AS product_option_id_77, p5_.product_id AS product_id_78, p5_.product_variant_id AS product_variant_id_79, p5_.shop_id AS shop_id_80, p6_.product_id AS product_id_81, p6_.media_id AS media_id_82 FROM product p0_ LEFT JOIN product_attribute p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant p2_ ON p0_.id = p2_.product_id LEFT JOIN product_variant_attribute p7_ ON p2_.id = p7_.product_variant_id LEFT JOIN product_option p3_ ON p0_.id = p3_.product_id LEFT JOIN product_option_value p4_ ON p3_.id = p4_.product_option_id LEFT JOIN product_pricing_rule p5_ ON p0_.id = p5_.product_id LEFT JOIN product_media p6_ ON p0_.id = p6_.product_id WHERE p0_.id = 847 ORDER BY p6_.ordering ASC;

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

1.86 ms
(6.83%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = ?

Parameters:

[
  1037938
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.shop_id AS shop_id_4
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.shop_id AS shop_id_4 FROM media t0 WHERE t0.id = 1037938;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\Media::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Media->__get (line 62)
8	App\Entity\Media->getName (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 780)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 198)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 138)
14	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
16	Symfony\Component\Serializer\Serializer->normalize (line 227)
17	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 70)
18	ApiPlatform\JsonLd\Serializer\ObjectNormalizer->normalize (line 50)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
20	Symfony\Component\Serializer\Serializer->normalize (line 110)
21	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalizeRawCollection (line 81)
22	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
23	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
24	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
25	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
26	Symfony\Component\Serializer\Serializer->normalize (line 755)
27	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 198)
28	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
29	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 138)
30	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 50)
31	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
32	Symfony\Component\Serializer\Serializer->normalize (line 131)
33	Symfony\Component\Serializer\Serializer->serialize (line 44)
34	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
35	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
36	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
37	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 14)

0.95 ms
(3.49%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.uuid AS uuid_4, t0.ordering AS ordering_5, t0.product_attribute_id AS product_attribute_id_6 FROM product_attribute_value t0 WHERE t0.product_attribute_id = ?

Parameters:

[
  536
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.value AS value_3,
  t0.uuid AS uuid_4,
  t0.ordering AS ordering_5,
  t0.product_attribute_id AS product_attribute_id_6
FROM
  product_attribute_value t0
WHERE
  t0.product_attribute_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.uuid AS uuid_4, t0.ordering AS ordering_5, t0.product_attribute_id AS product_attribute_id_6 FROM product_attribute_value t0 WHERE t0.product_attribute_id = 536;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 109)
8	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalizeRawCollection (line 81)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
13	Symfony\Component\Serializer\Serializer->normalize (line 227)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 70)
15	ApiPlatform\JsonLd\Serializer\ObjectNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
17	Symfony\Component\Serializer\Serializer->normalize (line 110)
18	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalizeRawCollection (line 81)
19	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
20	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
21	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
22	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
23	Symfony\Component\Serializer\Serializer->normalize (line 755)
24	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 198)
25	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
26	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 138)
27	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 50)
28	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
29	Symfony\Component\Serializer\Serializer->normalize (line 131)
30	Symfony\Component\Serializer\Serializer->serialize (line 44)
31	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
32	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
33	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
34	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 14)

0.55 ms
(2.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.position AS position_6, t0.level AS level_7, t0.need_customer_image AS need_customer_image_8, t0.is_gift_card_category AS is_gift_card_category_9, t0.media_id AS media_id_10, t0.lft AS lft_11, t0.rght AS rght_12, t0.visible AS visible_13, t0.featured AS featured_14, t0.url_path AS url_path_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.meta_robots AS meta_robots_18, t0.description_seo AS description_seo_19, t0.data AS data_20, t0.sort_method AS sort_method_21, t0.parent_id AS parent_id_22, t0.shop_id AS shop_id_23 FROM category t0 INNER JOIN category_product ON t0.id = category_product.category_id WHERE category_product.product_id = ?

Parameters:

[
  847
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.position AS position_6,
  t0.level AS level_7,
  t0.need_customer_image AS need_customer_image_8,
  t0.is_gift_card_category AS is_gift_card_category_9,
  t0.media_id AS media_id_10,
  t0.lft AS lft_11,
  t0.rght AS rght_12,
  t0.visible AS visible_13,
  t0.featured AS featured_14,
  t0.url_path AS url_path_15,
  t0.meta_title AS meta_title_16,
  t0.meta_description AS meta_description_17,
  t0.meta_robots AS meta_robots_18,
  t0.description_seo AS description_seo_19,
  t0.data AS data_20,
  t0.sort_method AS sort_method_21,
  t0.parent_id AS parent_id_22,
  t0.shop_id AS shop_id_23
FROM
  category t0
  INNER JOIN category_product ON t0.id = category_product.category_id
WHERE
  category_product.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.position AS position_6, t0.level AS level_7, t0.need_customer_image AS need_customer_image_8, t0.is_gift_card_category AS is_gift_card_category_9, t0.media_id AS media_id_10, t0.lft AS lft_11, t0.rght AS rght_12, t0.visible AS visible_13, t0.featured AS featured_14, t0.url_path AS url_path_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.meta_robots AS meta_robots_18, t0.description_seo AS description_seo_19, t0.data AS data_20, t0.sort_method AS sort_method_21, t0.parent_id AS parent_id_22, t0.shop_id AS shop_id_23 FROM category t0 INNER JOIN category_product ON t0.id = category_product.category_id WHERE category_product.product_id = 847;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 793)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 198)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 138)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 14)

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\ProductVariant	44
App\Entity\ProductAttributeValue	24
App\Entity\ProductMedia	5
App\Entity\Media	5
App\Entity\ProductAttribute	2
App\Entity\Category	2
App\Entity\Shop	2
App\Entity\Product	1

Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\ProductVariant	The field 'App\Entity\ProductVariant#additionalShippingCosts' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ProductOption	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\ProductVariantAttribute	No errors.
App\Entity\ProductOptionValue	No errors.
App\Entity\ProductPricingRule	No errors.
App\Entity\ProductMedia	No errors.
App\Entity\ProductAttributeValue	No errors.
App\Entity\Shop	No errors.
App\Entity\Media	No errors.
App\Entity\Category	No errors.
App\Entity\ProductVisibility	No errors.

Symfony Profiler

GET https://www.arcanes-labo.btov-dev.fr/api/products/847?shop=2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping