Symfony Profiler

Query Metrics

49 Database Queries

18 Different statements

63.38 ms Query time

0 Invalid entities

68 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.89 ms
(18.76%)

SELECT DISTINCT s0_.id AS id_0, s0_.code AS code_1, s0_.id AS id_2 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) LEFT JOIN sylius_product_variant s2_ ON s0_.id = s2_.product_id AND (s2_.enabled = ?) LEFT JOIN sylius_product_association s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_product_association_product s5_ ON s3_.id = s5_.association_id LEFT JOIN sylius_product s4_ ON s4_.id = s5_.product_id AND (s4_.enabled = 1 AND s3_.product_id = s0_.id) LEFT JOIN sylius_taxon s6_ ON s0_.main_taxon_id = s6_.id LEFT JOIN sylius_product_taxon s7_ ON s0_.id = s7_.product_id LEFT JOIN sylius_product_image s8_ ON s0_.id = s8_.owner_id LEFT JOIN sylius_product_options s10_ ON s0_.id = s10_.product_id LEFT JOIN sylius_product_option s9_ ON s9_.id = s10_.option_id WHERE EXISTS (SELECT 1 FROM sylius_product_channels s11_ WHERE s11_.product_id = s0_.id AND s11_.channel_id IN (?)) AND s0_.enabled = ? AND ((SELECT COUNT(*) FROM sylius_product_association s12_ WHERE s12_.product_id = s0_.id) = 0 OR s4_.id IS NOT NULL) ORDER BY s0_.code ASC, s0_.id ASC LIMIT 4

Parameters:

[
  "fr"
  1
  3
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.id AS id_2
FROM
  sylius_product s0_
  INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id
  AND (s1_.locale = ?)
  LEFT JOIN sylius_product_variant s2_ ON s0_.id = s2_.product_id
  AND (s2_.enabled = ?)
  LEFT JOIN sylius_product_association s3_ ON s0_.id = s3_.product_id
  LEFT JOIN sylius_product_association_product s5_ ON s3_.id = s5_.association_id
  LEFT JOIN sylius_product s4_ ON s4_.id = s5_.product_id
  AND (
    s4_.enabled = 1
    AND s3_.product_id = s0_.id
  )
  LEFT JOIN sylius_taxon s6_ ON s0_.main_taxon_id = s6_.id
  LEFT JOIN sylius_product_taxon s7_ ON s0_.id = s7_.product_id
  LEFT JOIN sylius_product_image s8_ ON s0_.id = s8_.owner_id
  LEFT JOIN sylius_product_options s10_ ON s0_.id = s10_.product_id
  LEFT JOIN sylius_product_option s9_ ON s9_.id = s10_.option_id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      sylius_product_channels s11_
    WHERE
      s11_.product_id = s0_.id
      AND s11_.channel_id IN (?)
  )
  AND s0_.enabled = ?
  AND (
    (
      SELECT
        COUNT(*)
      FROM
        sylius_product_association s12_
      WHERE
        s12_.product_id = s0_.id
    ) = 0
    OR s4_.id IS NOT NULL
  )
ORDER BY
  s0_.code ASC,
  s0_.id ASC
LIMIT
  4

SELECT DISTINCT s0_.id AS id_0, s0_.code AS code_1, s0_.id AS id_2 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'fr') LEFT JOIN sylius_product_variant s2_ ON s0_.id = s2_.product_id AND (s2_.enabled = 1) LEFT JOIN sylius_product_association s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_product_association_product s5_ ON s3_.id = s5_.association_id LEFT JOIN sylius_product s4_ ON s4_.id = s5_.product_id AND (s4_.enabled = 1 AND s3_.product_id = s0_.id) LEFT JOIN sylius_taxon s6_ ON s0_.main_taxon_id = s6_.id LEFT JOIN sylius_product_taxon s7_ ON s0_.id = s7_.product_id LEFT JOIN sylius_product_image s8_ ON s0_.id = s8_.owner_id LEFT JOIN sylius_product_options s10_ ON s0_.id = s10_.product_id LEFT JOIN sylius_product_option s9_ ON s9_.id = s10_.option_id WHERE EXISTS (SELECT 1 FROM sylius_product_channels s11_ WHERE s11_.product_id = s0_.id AND s11_.channel_id IN (3)) AND s0_.enabled = 1 AND ((SELECT COUNT(*) FROM sylius_product_association s12_ WHERE s12_.product_id = s0_.id) = 0 OR s4_.id IS NOT NULL) ORDER BY s0_.code ASC, s0_.id ASC LIMIT 4;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 86)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Serializer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->serialize (line 131)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

11.63 ms
(18.35%)

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) LEFT JOIN sylius_product_variant s2_ ON s0_.id = s2_.product_id AND (s2_.enabled = ?) LEFT JOIN sylius_product_association s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_product_association_product s5_ ON s3_.id = s5_.association_id LEFT JOIN sylius_product s4_ ON s4_.id = s5_.product_id AND (s4_.enabled = 1 AND s3_.product_id = s0_.id) LEFT JOIN sylius_taxon s6_ ON s0_.main_taxon_id = s6_.id LEFT JOIN sylius_product_taxon s7_ ON s0_.id = s7_.product_id LEFT JOIN sylius_product_image s8_ ON s0_.id = s8_.owner_id LEFT JOIN sylius_product_options s10_ ON s0_.id = s10_.product_id LEFT JOIN sylius_product_option s9_ ON s9_.id = s10_.option_id WHERE EXISTS (SELECT 1 FROM sylius_product_channels s11_ WHERE s11_.product_id = s0_.id AND s11_.channel_id IN (?)) AND s0_.enabled = ? AND ((SELECT COUNT(*) FROM sylius_product_association s12_ WHERE s12_.product_id = s0_.id) = 0 OR s4_.id IS NOT NULL)

Parameters:

[
  "fr"
  1
  3
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  sylius_product s0_
  INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id
  AND (s1_.locale = ?)
  LEFT JOIN sylius_product_variant s2_ ON s0_.id = s2_.product_id
  AND (s2_.enabled = ?)
  LEFT JOIN sylius_product_association s3_ ON s0_.id = s3_.product_id
  LEFT JOIN sylius_product_association_product s5_ ON s3_.id = s5_.association_id
  LEFT JOIN sylius_product s4_ ON s4_.id = s5_.product_id
  AND (
    s4_.enabled = 1
    AND s3_.product_id = s0_.id
  )
  LEFT JOIN sylius_taxon s6_ ON s0_.main_taxon_id = s6_.id
  LEFT JOIN sylius_product_taxon s7_ ON s0_.id = s7_.product_id
  LEFT JOIN sylius_product_image s8_ ON s0_.id = s8_.owner_id
  LEFT JOIN sylius_product_options s10_ ON s0_.id = s10_.product_id
  LEFT JOIN sylius_product_option s9_ ON s9_.id = s10_.option_id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      sylius_product_channels s11_
    WHERE
      s11_.product_id = s0_.id
      AND s11_.channel_id IN (?)
  )
  AND s0_.enabled = ?
  AND (
    (
      SELECT
        COUNT(*)
      FROM
        sylius_product_association s12_
      WHERE
        s12_.product_id = s0_.id
    ) = 0
    OR s4_.id IS NOT NULL
  )

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'fr') LEFT JOIN sylius_product_variant s2_ ON s0_.id = s2_.product_id AND (s2_.enabled = 1) LEFT JOIN sylius_product_association s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_product_association_product s5_ ON s3_.id = s5_.association_id LEFT JOIN sylius_product s4_ ON s4_.id = s5_.product_id AND (s4_.enabled = 1 AND s3_.product_id = s0_.id) LEFT JOIN sylius_taxon s6_ ON s0_.main_taxon_id = s6_.id LEFT JOIN sylius_product_taxon s7_ ON s0_.id = s7_.product_id LEFT JOIN sylius_product_image s8_ ON s0_.id = s8_.owner_id LEFT JOIN sylius_product_options s10_ ON s0_.id = s10_.product_id LEFT JOIN sylius_product_option s9_ ON s9_.id = s10_.option_id WHERE EXISTS (SELECT 1 FROM sylius_product_channels s11_ WHERE s11_.product_id = s0_.id AND s11_.channel_id IN (3)) AND s0_.enabled = 1 AND ((SELECT COUNT(*) FROM sylius_product_association s12_ WHERE s12_.product_id = s0_.id) = 0 OR s4_.id IS NOT NULL);

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 49)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 66)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 90)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Serializer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->serialize (line 131)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

6.57 ms
(10.36%)

SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.price AS price_1,
  t0.original_price AS original_price_2,
  t0.minimum_price AS minimum_price_3,
  t0.lowest_price_before_discount AS lowest_price_before_discount_4,
  t0.channel_code AS channel_code_5,
  t0.id AS id_6,
  t0.product_variant_id AS product_variant_id_7
FROM
  sylius_channel_pricing t0
WHERE
  t0.product_variant_id = ?
ORDER BY
  t0.id ASC

SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = 1 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 110)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Sylius\Component\Core\Model\ProductVariant->getChannelPricingForChannel (line 231)
9	Sylius\Component\Core\Calculator\ProductVariantPriceCalculator->calculate (line 34)
10	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductVariantNormalizer->normalize (line 73)
11	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Serializer->normalize (line 152)
13	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->populateDefaultVariantData (line 106)
14	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->normalize (line 64)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Serializer->normalize (line 152)
17	App\Serializer\ProductNormalizer->normalize (line 38)
18	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
19	Symfony\Component\Serializer\Serializer->normalize (line 152)
20	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
21	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
22	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
23	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
24	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
25	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
26	Symfony\Component\Serializer\Serializer->normalize (line 152)
27	Symfony\Component\Serializer\Serializer->serialize (line 131)
28	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
29	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
30	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

3.88 ms
(6.12%)

SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s0_.code AS code_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.enabled AS enabled_10, s0_.id AS id_11, s0_.variant_selection_method AS variant_selection_method_12, s0_.average_rating AS average_rating_13, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.meta_keywords AS meta_keywords_17, s1_.meta_description AS meta_description_18, s1_.id AS id_19, s1_.short_description AS short_description_20, s1_.descriptionEquipement AS descriptionEquipement_21, s1_.youtubeVideoUrl AS youtubeVideoUrl_22, s1_.locale AS locale_23, s2_.code AS code_24, s2_.created_at AS created_at_25, s2_.updated_at AS updated_at_26, s2_.position AS position_27, s2_.enabled AS enabled_28, s2_.id AS id_29, s2_.version AS version_30, s2_.on_hold AS on_hold_31, s2_.on_hand AS on_hand_32, s2_.tracked AS tracked_33, s2_.width AS width_34, s2_.height AS height_35, s2_.depth AS depth_36, s2_.weight AS weight_37, s2_.shipping_required AS shipping_required_38, s2_.recurring AS recurring_39, s2_.recurring_times AS recurring_times_40, s2_.recurring_interval AS recurring_interval_41, s3_.created_at AS created_at_42, s3_.updated_at AS updated_at_43, s3_.id AS id_44, s4_.code AS code_45, s4_.tree_left AS tree_left_46, s4_.tree_right AS tree_right_47, s4_.tree_level AS tree_level_48, s4_.position AS position_49, s4_.enabled AS enabled_50, s4_.id AS id_51, s4_.created_at AS created_at_52, s4_.updated_at AS updated_at_53, s5_.position AS position_54, s5_.id AS id_55, s6_.type AS type_56, s6_.path AS path_57, s6_.id AS id_58, s6_.position AS position_59, s7_.code AS code_60, s7_.position AS position_61, s7_.created_at AS created_at_62, s7_.updated_at AS updated_at_63, s7_.id AS id_64, s0_.main_taxon_id AS main_taxon_id_65, s0_.product_type_id AS product_type_id_66, s1_.translatable_id AS translatable_id_67, s2_.product_id AS product_id_68, s2_.tax_category_id AS tax_category_id_69, s2_.shipping_category_id AS shipping_category_id_70, s3_.association_type_id AS association_type_id_71, s3_.product_id AS product_id_72, s4_.tree_root AS tree_root_73, s4_.parent_id AS parent_id_74, s5_.product_id AS product_id_75, s5_.taxon_id AS taxon_id_76, s6_.owner_id AS owner_id_77 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) LEFT JOIN sylius_product_variant s2_ ON s0_.id = s2_.product_id AND (s2_.enabled = ?) LEFT JOIN sylius_product_association s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_product_association_product s9_ ON s3_.id = s9_.association_id LEFT JOIN sylius_product s8_ ON s8_.id = s9_.product_id AND (s8_.enabled = 1 AND s3_.product_id = s0_.id) LEFT JOIN sylius_taxon s4_ ON s0_.main_taxon_id = s4_.id LEFT JOIN sylius_product_taxon s5_ ON s0_.id = s5_.product_id LEFT JOIN sylius_product_image s6_ ON s0_.id = s6_.owner_id LEFT JOIN sylius_product_options s10_ ON s0_.id = s10_.product_id LEFT JOIN sylius_product_option s7_ ON s7_.id = s10_.option_id WHERE EXISTS (SELECT 1 FROM sylius_product_channels s11_ WHERE s11_.product_id = s0_.id AND s11_.channel_id IN (?)) AND s0_.enabled = ? AND ((SELECT COUNT(*) FROM sylius_product_association s12_ WHERE s12_.product_id = s0_.id) = 0 OR s8_.id IS NOT NULL) AND s0_.id IN (?, ?, ?, ?) ORDER BY s0_.code ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC, s3_.id ASC, s5_.id ASC, s6_.position ASC, s6_.id ASC, s7_.position ASC, s7_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.code AS code_0,
  s0_.created_at AS created_at_1,
  s0_.updated_at AS updated_at_2,
  s0_.enabled AS enabled_3,
  s0_.id AS id_4,
  s0_.variant_selection_method AS variant_selection_method_5,
  s0_.average_rating AS average_rating_6,
  s0_.code AS code_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9,
  s0_.enabled AS enabled_10,
  s0_.id AS id_11,
  s0_.variant_selection_method AS variant_selection_method_12,
  s0_.average_rating AS average_rating_13,
  s1_.name AS name_14,
  s1_.slug AS slug_15,
  s1_.description AS description_16,
  s1_.meta_keywords AS meta_keywords_17,
  s1_.meta_description AS meta_description_18,
  s1_.id AS id_19,
  s1_.short_description AS short_description_20,
  s1_.descriptionEquipement AS descriptionEquipement_21,
  s1_.youtubeVideoUrl AS youtubeVideoUrl_22,
  s1_.locale AS locale_23,
  s2_.code AS code_24,
  s2_.created_at AS created_at_25,
  s2_.updated_at AS updated_at_26,
  s2_.position AS position_27,
  s2_.enabled AS enabled_28,
  s2_.id AS id_29,
  s2_.version AS version_30,
  s2_.on_hold AS on_hold_31,
  s2_.on_hand AS on_hand_32,
  s2_.tracked AS tracked_33,
  s2_.width AS width_34,
  s2_.height AS height_35,
  s2_.depth AS depth_36,
  s2_.weight AS weight_37,
  s2_.shipping_required AS shipping_required_38,
  s2_.recurring AS recurring_39,
  s2_.recurring_times AS recurring_times_40,
  s2_.recurring_interval AS recurring_interval_41,
  s3_.created_at AS created_at_42,
  s3_.updated_at AS updated_at_43,
  s3_.id AS id_44,
  s4_.code AS code_45,
  s4_.tree_left AS tree_left_46,
  s4_.tree_right AS tree_right_47,
  s4_.tree_level AS tree_level_48,
  s4_.position AS position_49,
  s4_.enabled AS enabled_50,
  s4_.id AS id_51,
  s4_.created_at AS created_at_52,
  s4_.updated_at AS updated_at_53,
  s5_.position AS position_54,
  s5_.id AS id_55,
  s6_.type AS type_56,
  s6_.path AS path_57,
  s6_.id AS id_58,
  s6_.position AS position_59,
  s7_.code AS code_60,
  s7_.position AS position_61,
  s7_.created_at AS created_at_62,
  s7_.updated_at AS updated_at_63,
  s7_.id AS id_64,
  s0_.main_taxon_id AS main_taxon_id_65,
  s0_.product_type_id AS product_type_id_66,
  s1_.translatable_id AS translatable_id_67,
  s2_.product_id AS product_id_68,
  s2_.tax_category_id AS tax_category_id_69,
  s2_.shipping_category_id AS shipping_category_id_70,
  s3_.association_type_id AS association_type_id_71,
  s3_.product_id AS product_id_72,
  s4_.tree_root AS tree_root_73,
  s4_.parent_id AS parent_id_74,
  s5_.product_id AS product_id_75,
  s5_.taxon_id AS taxon_id_76,
  s6_.owner_id AS owner_id_77
FROM
  sylius_product s0_
  INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id
  AND (s1_.locale = ?)
  LEFT JOIN sylius_product_variant s2_ ON s0_.id = s2_.product_id
  AND (s2_.enabled = ?)
  LEFT JOIN sylius_product_association s3_ ON s0_.id = s3_.product_id
  LEFT JOIN sylius_product_association_product s9_ ON s3_.id = s9_.association_id
  LEFT JOIN sylius_product s8_ ON s8_.id = s9_.product_id
  AND (
    s8_.enabled = 1
    AND s3_.product_id = s0_.id
  )
  LEFT JOIN sylius_taxon s4_ ON s0_.main_taxon_id = s4_.id
  LEFT JOIN sylius_product_taxon s5_ ON s0_.id = s5_.product_id
  LEFT JOIN sylius_product_image s6_ ON s0_.id = s6_.owner_id
  LEFT JOIN sylius_product_options s10_ ON s0_.id = s10_.product_id
  LEFT JOIN sylius_product_option s7_ ON s7_.id = s10_.option_id
WHERE
  EXISTS (
    SELECT
      1
    FROM
      sylius_product_channels s11_
    WHERE
      s11_.product_id = s0_.id
      AND s11_.channel_id IN (?)
  )
  AND s0_.enabled = ?
  AND (
    (
      SELECT
        COUNT(*)
      FROM
        sylius_product_association s12_
      WHERE
        s12_.product_id = s0_.id
    ) = 0
    OR s8_.id IS NOT NULL
  )
  AND s0_.id IN (?, ?, ?, ?)
ORDER BY
  s0_.code ASC,
  s0_.id ASC,
  s2_.position ASC,
  s2_.id ASC,
  s3_.id ASC,
  s5_.id ASC,
  s6_.position ASC,
  s6_.id ASC,
  s7_.position ASC,
  s7_.id ASC

SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s0_.code AS code_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.enabled AS enabled_10, s0_.id AS id_11, s0_.variant_selection_method AS variant_selection_method_12, s0_.average_rating AS average_rating_13, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.meta_keywords AS meta_keywords_17, s1_.meta_description AS meta_description_18, s1_.id AS id_19, s1_.short_description AS short_description_20, s1_.descriptionEquipement AS descriptionEquipement_21, s1_.youtubeVideoUrl AS youtubeVideoUrl_22, s1_.locale AS locale_23, s2_.code AS code_24, s2_.created_at AS created_at_25, s2_.updated_at AS updated_at_26, s2_.position AS position_27, s2_.enabled AS enabled_28, s2_.id AS id_29, s2_.version AS version_30, s2_.on_hold AS on_hold_31, s2_.on_hand AS on_hand_32, s2_.tracked AS tracked_33, s2_.width AS width_34, s2_.height AS height_35, s2_.depth AS depth_36, s2_.weight AS weight_37, s2_.shipping_required AS shipping_required_38, s2_.recurring AS recurring_39, s2_.recurring_times AS recurring_times_40, s2_.recurring_interval AS recurring_interval_41, s3_.created_at AS created_at_42, s3_.updated_at AS updated_at_43, s3_.id AS id_44, s4_.code AS code_45, s4_.tree_left AS tree_left_46, s4_.tree_right AS tree_right_47, s4_.tree_level AS tree_level_48, s4_.position AS position_49, s4_.enabled AS enabled_50, s4_.id AS id_51, s4_.created_at AS created_at_52, s4_.updated_at AS updated_at_53, s5_.position AS position_54, s5_.id AS id_55, s6_.type AS type_56, s6_.path AS path_57, s6_.id AS id_58, s6_.position AS position_59, s7_.code AS code_60, s7_.position AS position_61, s7_.created_at AS created_at_62, s7_.updated_at AS updated_at_63, s7_.id AS id_64, s0_.main_taxon_id AS main_taxon_id_65, s0_.product_type_id AS product_type_id_66, s1_.translatable_id AS translatable_id_67, s2_.product_id AS product_id_68, s2_.tax_category_id AS tax_category_id_69, s2_.shipping_category_id AS shipping_category_id_70, s3_.association_type_id AS association_type_id_71, s3_.product_id AS product_id_72, s4_.tree_root AS tree_root_73, s4_.parent_id AS parent_id_74, s5_.product_id AS product_id_75, s5_.taxon_id AS taxon_id_76, s6_.owner_id AS owner_id_77 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'fr') LEFT JOIN sylius_product_variant s2_ ON s0_.id = s2_.product_id AND (s2_.enabled = 1) LEFT JOIN sylius_product_association s3_ ON s0_.id = s3_.product_id LEFT JOIN sylius_product_association_product s9_ ON s3_.id = s9_.association_id LEFT JOIN sylius_product s8_ ON s8_.id = s9_.product_id AND (s8_.enabled = 1 AND s3_.product_id = s0_.id) LEFT JOIN sylius_taxon s4_ ON s0_.main_taxon_id = s4_.id LEFT JOIN sylius_product_taxon s5_ ON s0_.id = s5_.product_id LEFT JOIN sylius_product_image s6_ ON s0_.id = s6_.owner_id LEFT JOIN sylius_product_options s10_ ON s0_.id = s10_.product_id LEFT JOIN sylius_product_option s7_ ON s7_.id = s10_.option_id WHERE EXISTS (SELECT 1 FROM sylius_product_channels s11_ WHERE s11_.product_id = s0_.id AND s11_.channel_id IN (3)) AND s0_.enabled = 1 AND ((SELECT COUNT(*) FROM sylius_product_association s12_ WHERE s12_.product_id = s0_.id) = 0 OR s8_.id IS NOT NULL) AND s0_.id IN (1, 2, 3, 4) ORDER BY s0_.code ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC, s3_.id ASC, s5_.id ASC, s6_.position ASC, s6_.id ASC, s7_.position ASC, s7_.id ASC;

#	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->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 86)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Serializer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->serialize (line 131)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

3.37 ms
(5.31%)

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.recurring AS recurring_16, t0.recurring_times AS recurring_times_17, t0.recurring_interval AS recurring_interval_18, t0.product_id AS product_id_19, t0.tax_category_id AS tax_category_id_20, t0.shipping_category_id AS shipping_category_id_21 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.position AS position_4,
  t0.enabled AS enabled_5,
  t0.id AS id_6,
  t0.version AS version_7,
  t0.on_hold AS on_hold_8,
  t0.on_hand AS on_hand_9,
  t0.tracked AS tracked_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.depth AS depth_13,
  t0.weight AS weight_14,
  t0.shipping_required AS shipping_required_15,
  t0.recurring AS recurring_16,
  t0.recurring_times AS recurring_times_17,
  t0.recurring_interval AS recurring_interval_18,
  t0.product_id AS product_id_19,
  t0.tax_category_id AS tax_category_id_20,
  t0.shipping_category_id AS shipping_category_id_21
FROM
  sylius_product_variant t0
WHERE
  t0.product_id = ?
  AND t0.enabled = ?
ORDER BY
  t0.position ASC,
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.recurring AS recurring_16, t0.recurring_times AS recurring_times_17, t0.recurring_interval AS recurring_interval_18, t0.product_id AS product_id_19, t0.tax_category_id AS tax_category_id_20, t0.shipping_category_id AS shipping_category_id_21 FROM sylius_product_variant t0 WHERE t0.product_id = 1 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Sylius\Component\Product\Resolver\DefaultProductVariantResolver->getVariant (line 30)
4	Sylius\Component\Product\Resolver\CompositeProductVariantResolver->getVariant (line 31)
5	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->populateDefaultVariantData (line 89)
6	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->normalize (line 64)
7	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
8	Symfony\Component\Serializer\Serializer->normalize (line 152)
9	App\Serializer\ProductNormalizer->normalize (line 38)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
11	Symfony\Component\Serializer\Serializer->normalize (line 152)
12	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
13	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
14	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
15	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
16	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Serializer->normalize (line 152)
19	Symfony\Component\Serializer\Serializer->serialize (line 131)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
21	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
22	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

3.28 ms
(5.17%)

SELECT t0.locale_code AS locale_code_1, t0.text_value AS text_value_2, t0.boolean_value AS boolean_value_3, t0.integer_value AS integer_value_4, t0.float_value AS float_value_5, t0.datetime_value AS datetime_value_6, t0.date_value AS date_value_7, t0.json_value AS json_value_8, t0.id AS id_9, t0.showOnFront AS showOnFront_10, t0.product_id AS product_id_11, t0.attribute_id AS attribute_id_12 FROM sylius_product_attribute_value t0 WHERE t0.product_id = ? ORDER BY t0.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.locale_code AS locale_code_1,
  t0.text_value AS text_value_2,
  t0.boolean_value AS boolean_value_3,
  t0.integer_value AS integer_value_4,
  t0.float_value AS float_value_5,
  t0.datetime_value AS datetime_value_6,
  t0.date_value AS date_value_7,
  t0.json_value AS json_value_8,
  t0.id AS id_9,
  t0.showOnFront AS showOnFront_10,
  t0.product_id AS product_id_11,
  t0.attribute_id AS attribute_id_12
FROM
  sylius_product_attribute_value t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.id ASC

SELECT t0.locale_code AS locale_code_1, t0.text_value AS text_value_2, t0.boolean_value AS boolean_value_3, t0.integer_value AS integer_value_4, t0.float_value AS float_value_5, t0.datetime_value AS datetime_value_6, t0.date_value AS date_value_7, t0.json_value AS json_value_8, t0.id AS id_9, t0.showOnFront AS showOnFront_10, t0.product_id AS product_id_11, t0.attribute_id AS attribute_id_12 FROM sylius_product_attribute_value t0 WHERE t0.product_id = 1 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Serializer\ProductNormalizer->enhanceProductData (line 175)
8	App\Serializer\ProductNormalizer->normalize (line 44)
9	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
10	Symfony\Component\Serializer\Serializer->normalize (line 152)
11	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
12	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
13	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
14	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
15	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
17	Symfony\Component\Serializer\Serializer->normalize (line 152)
18	Symfony\Component\Serializer\Serializer->serialize (line 131)
19	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
20	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
21	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

3.21 ms
(5.06%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.enabled AS enabled_5, t0.priority AS priority_6, t0.exclusive AS exclusive_7, t0.state AS state_8, t0.id AS id_9 FROM sylius_catalog_promotion t0 INNER JOIN sylius_channel_pricing_catalog_promotions ON t0.id = sylius_channel_pricing_catalog_promotions.catalog_promotion_id WHERE sylius_channel_pricing_catalog_promotions.channel_pricing_id = ? ORDER BY t0.id ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.enabled AS enabled_5,
  t0.priority AS priority_6,
  t0.exclusive AS exclusive_7,
  t0.state AS state_8,
  t0.id AS id_9
FROM
  sylius_catalog_promotion t0
  INNER JOIN sylius_channel_pricing_catalog_promotions ON t0.id = sylius_channel_pricing_catalog_promotions.catalog_promotion_id
WHERE
  sylius_channel_pricing_catalog_promotions.channel_pricing_id = ?
ORDER BY
  t0.id ASC

SELECT t0.code AS code_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.enabled AS enabled_5, t0.priority AS priority_6, t0.exclusive AS exclusive_7, t0.state AS state_8, t0.id AS id_9 FROM sylius_catalog_promotion t0 INNER JOIN sylius_channel_pricing_catalog_promotions ON t0.id = sylius_channel_pricing_catalog_promotions.catalog_promotion_id WHERE sylius_channel_pricing_catalog_promotions.channel_pricing_id = 3 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 446)
9	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductVariantNormalizer->normalize (line 85)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
11	Symfony\Component\Serializer\Serializer->normalize (line 152)
12	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->populateDefaultVariantData (line 106)
13	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->normalize (line 64)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Serializer->normalize (line 152)
16	App\Serializer\ProductNormalizer->normalize (line 38)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Serializer->normalize (line 152)
19	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
20	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
21	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
22	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
23	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
24	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
25	Symfony\Component\Serializer\Serializer->normalize (line 152)
26	Symfony\Component\Serializer\Serializer->serialize (line 131)
27	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
28	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
29	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
30	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
31	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
32	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 5)

2.83 ms
(4.46%)

SELECT t0.title AS title_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.product_id AS product_id_8, t0.author_id AS author_id_9 FROM sylius_product_review t0 WHERE t0.product_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.rating AS rating_2,
  t0.comment AS comment_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.id AS id_7,
  t0.product_id AS product_id_8,
  t0.author_id AS author_id_9
FROM
  sylius_product_review t0
WHERE
  t0.product_id = ?

SELECT t0.title AS title_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.product_id AS product_id_8, t0.author_id AS author_id_9 FROM sylius_product_review t0 WHERE t0.product_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	Sylius\Component\Core\Model\Product->getAcceptedReviews (line 176)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
10	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1001)
11	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
12	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 194)
13	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 149)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
15	Symfony\Component\Serializer\Serializer->normalize (line 152)
16	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->normalize (line 62)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Serializer->normalize (line 152)
19	App\Serializer\ProductNormalizer->normalize (line 38)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
21	Symfony\Component\Serializer\Serializer->normalize (line 152)
22	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
23	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
24	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
25	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
26	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
27	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
28	Symfony\Component\Serializer\Serializer->normalize (line 152)
29	Symfony\Component\Serializer\Serializer->serialize (line 131)
30	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
31	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
32	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
33	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
34	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
35	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
36	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 193)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
41	require_once (line 32)
42	require_once (line 5)

2.82 ms
(4.45%)

SELECT t0.id AS id_1, t0.bestSeller AS bestSeller_2, t0.onSale AS onSale_3, t0.product_id AS product_id_4, t0.channel_id AS channel_id_5 FROM app_product_channel_config t0 WHERE t0.product_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.bestSeller AS bestSeller_2,
  t0.onSale AS onSale_3,
  t0.product_id AS product_id_4,
  t0.channel_id AS channel_id_5
FROM
  app_product_channel_config t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.bestSeller AS bestSeller_2, t0.onSale AS onSale_3, t0.product_id AS product_id_4, t0.channel_id AS channel_id_5 FROM app_product_channel_config t0 WHERE t0.product_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Product\Product->getChannelConfig (line 69)
8	App\Entity\Product\Product->isBestSellerForChannel (line 91)
9	App\Serializer\ProductNormalizer->enhanceProductData (line 148)
10	App\Serializer\ProductNormalizer->normalize (line 44)
11	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Serializer->normalize (line 152)
13	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
14	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
15	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
16	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
17	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
18	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
19	Symfony\Component\Serializer\Serializer->normalize (line 152)
20	Symfony\Component\Serializer\Serializer->serialize (line 131)
21	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
22	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
23	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

2.71 ms
(4.28%)

SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_variant_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1

Parameters:

[
  1
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  sylius_product_variant_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_variant_translation t0 WHERE t0.translatable_id = 1 AND t0.locale = 'fr' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Collection\OneToManyPersister->get (line 71)
3	Doctrine\ORM\PersistentCollection->get (line 377)
4	Sylius\Component\Product\Model\ProductVariant->doGetTranslation (line 60)
5	Sylius\Component\Product\Model\ProductVariant->getTranslation (line 136)
6	Sylius\Component\Product\Model\ProductVariant->getName (line 71)
7	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
8	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
9	Symfony\Component\Serializer\Normalizer\ObjectNormalizer->getAttributeValue (line 115)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
11	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->populateDefaultVariantData (line 102)
12	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->normalize (line 64)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Serializer->normalize (line 152)
15	App\Serializer\ProductNormalizer->normalize (line 38)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
17	Symfony\Component\Serializer\Serializer->normalize (line 152)
18	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
19	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
20	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
21	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
22	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
23	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
24	Symfony\Component\Serializer\Serializer->normalize (line 152)
25	Symfony\Component\Serializer\Serializer->serialize (line 131)
26	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
27	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
28	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
29	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
30	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
31	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 193)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 32)
38	require_once (line 5)

2.22 ms
(3.51%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.channel_id AS channel_id_3, t0.highlight_id AS highlight_id_4 FROM app_product_channel_highlight t0 WHERE t0.product_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.channel_id AS channel_id_3,
  t0.highlight_id AS highlight_id_4
FROM
  app_product_channel_highlight t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.channel_id AS channel_id_3, t0.highlight_id AS highlight_id_4 FROM app_product_channel_highlight t0 WHERE t0.product_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\Product\Product->getHighlightsForChannel (line 109)
8	App\Serializer\ProductNormalizer->enhanceProductData (line 95)
9	App\Serializer\ProductNormalizer->normalize (line 44)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
11	Symfony\Component\Serializer\Serializer->normalize (line 152)
12	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
13	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
14	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
15	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
16	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Serializer->normalize (line 152)
19	Symfony\Component\Serializer\Serializer->serialize (line 131)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
21	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
22	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

2.18 ms
(3.44%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.channel_id AS channel_id_3, t0.document_id AS document_id_4 FROM app_product_channel_document t0 WHERE t0.product_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.channel_id AS channel_id_3,
  t0.document_id AS document_id_4
FROM
  app_product_channel_document t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.channel_id AS channel_id_3, t0.document_id AS document_id_4 FROM app_product_channel_document t0 WHERE t0.product_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\Product\Product->getDocumentsForChannel (line 202)
8	App\Serializer\ProductNormalizer->enhanceProductData (line 114)
9	App\Serializer\ProductNormalizer->normalize (line 44)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
11	Symfony\Component\Serializer\Serializer->normalize (line 152)
12	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
13	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
14	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
15	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
16	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Serializer->normalize (line 152)
19	Symfony\Component\Serializer\Serializer->serialize (line 131)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
21	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
22	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

2.15 ms
(3.40%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.channel_id AS channel_id_3, t0.equipment_id AS equipment_id_4 FROM app_product_channel_equipment t0 WHERE t0.product_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.channel_id AS channel_id_3,
  t0.equipment_id AS equipment_id_4
FROM
  app_product_channel_equipment t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.channel_id AS channel_id_3, t0.equipment_id AS equipment_id_4 FROM app_product_channel_equipment t0 WHERE t0.product_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\Product\Product->getEquipmentsForChannel (line 140)
8	App\Serializer\ProductNormalizer->enhanceProductData (line 109)
9	App\Serializer\ProductNormalizer->normalize (line 44)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
11	Symfony\Component\Serializer\Serializer->normalize (line 152)
12	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
13	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
14	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
15	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
16	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
18	Symfony\Component\Serializer\Serializer->normalize (line 152)
19	Symfony\Component\Serializer\Serializer->serialize (line 131)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
21	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
22	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

1.29 ms
(2.04%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Channel\Channel::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Channel\Channel->__get (line 153)
7	Sylius\Component\Channel\Model\Channel->getCode (line 58)
8	App\Entity\Product\Product->getChannelConfig (line 70)
9	App\Entity\Product\Product->isBestSellerForChannel (line 91)
10	App\Serializer\ProductNormalizer->enhanceProductData (line 148)
11	App\Serializer\ProductNormalizer->normalize (line 44)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
15	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
16	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
17	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
18	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
20	Symfony\Component\Serializer\Serializer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->serialize (line 131)
22	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
23	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
24	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

1.02 ms
(1.60%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1

Parameters:

[
  "dimaco-back-preprod.kwantic.dev"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.hostname = ?
  AND t0.enabled = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = 'dimaco-back-preprod.kwantic.dev' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Sylius\Bundle\ChannelBundle\Doctrine\ORM\ChannelRepository->findOneEnabledByHostname (line 37)
4	Sylius\Component\Channel\Context\RequestBased\HostnameBasedRequestResolver->findChannel (line 32)
5	Sylius\Component\Channel\Context\RequestBased\CompositeRequestResolver->findChannel (line 38)
6	Sylius\Component\Channel\Context\RequestBased\ChannelContext->getChannelForRequest (line 39)
7	Sylius\Component\Channel\Context\RequestBased\ChannelContext->getChannel (line 31)
8	Sylius\Component\Channel\Context\CompositeChannelContext->getChannel (line 38)
9	Sylius\Component\Channel\Context\CachedPerRequestChannelContext->getChannel (line 44)
10	Sylius\Component\Core\Provider\ChannelBasedLocaleProvider->getDefaultLocaleCode (line 50)
11	Sylius\Bundle\LocaleBundle\Context\RequestHeaderBasedLocaleContext->getLocaleCode (line 47)
12	Sylius\Component\Locale\Context\CompositeLocaleContext->getLocaleCode (line 39)
13	Sylius\Bundle\LocaleBundle\Listener\RequestLocaleSetter->onKernelRequest (line 34)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.84 ms
(1.33%)

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4
FROM
  sylius_locale t0
  INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id
WHERE
  sylius_channel_locales.channel_id = ?

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->map (line 259)
7	Sylius\Component\Core\Provider\ChannelBasedLocaleProvider->getAvailableLocalesCodes (line 36)
8	Sylius\Bundle\LocaleBundle\Context\RequestHeaderBasedLocaleContext->getLocaleCode (line 48)
9	Sylius\Component\Locale\Context\CompositeLocaleContext->getLocaleCode (line 39)
10	Sylius\Bundle\LocaleBundle\Listener\RequestLocaleSetter->onKernelRequest (line 34)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

0.80 ms
(1.26%)

SELECT t0.lowest_price_for_discounted_products_checking_period AS lowest_price_for_discounted_products_checking_period_1, t0.lowest_price_for_discounted_products_visible AS lowest_price_for_discounted_products_visible_2, t0.id AS id_3 FROM sylius_channel_price_history_config t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.lowest_price_for_discounted_products_checking_period AS lowest_price_for_discounted_products_checking_period_1,
  t0.lowest_price_for_discounted_products_visible AS lowest_price_for_discounted_products_visible_2,
  t0.id AS id_3
FROM
  sylius_channel_price_history_config t0
WHERE
  t0.id = ?

SELECT t0.lowest_price_for_discounted_products_checking_period AS lowest_price_for_discounted_products_checking_period_1, t0.lowest_price_for_discounted_products_visible AS lowest_price_for_discounted_products_visible_2, t0.id AS id_3 FROM sylius_channel_price_history_config t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Channel\ChannelPriceHistoryConfig::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Channel\ChannelPriceHistoryConfig->__get (line 153)
7	Sylius\Component\Core\Model\ChannelPriceHistoryConfig->isLowestPriceForDiscountedProductsVisible (line 54)
8	Sylius\Component\Core\Checker\ProductVariantLowestPriceDisplayChecker->isLowestPriceDisplayable (line 35)
9	Sylius\Component\Core\Calculator\ProductVariantPriceCalculator->calculateLowestPriceBeforeDiscount (line 77)
10	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductVariantNormalizer->normalize (line 75)
11	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Serializer->normalize (line 152)
13	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->populateDefaultVariantData (line 106)
14	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->normalize (line 64)
15	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
16	Symfony\Component\Serializer\Serializer->normalize (line 152)
17	App\Serializer\ProductNormalizer->normalize (line 38)
18	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
19	Symfony\Component\Serializer\Serializer->normalize (line 152)
20	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
21	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
22	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
23	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
24	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
25	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
26	Symfony\Component\Serializer\Serializer->normalize (line 152)
27	Symfony\Component\Serializer\Serializer->serialize (line 131)
28	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
29	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
30	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 193)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

0.68 ms
(1.08%)

SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 INNER JOIN sylius_channel_price_history_config_excluded_taxons ON t0.id = sylius_channel_price_history_config_excluded_taxons.taxon_id WHERE sylius_channel_price_history_config_excluded_taxons.channel_id = ? ORDER BY t0.id ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.tree_left AS tree_left_2,
  t0.tree_right AS tree_right_3,
  t0.tree_level AS tree_level_4,
  t0.position AS position_5,
  t0.enabled AS enabled_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.tree_root AS tree_root_10,
  t0.parent_id AS parent_id_11
FROM
  sylius_taxon t0
  INNER JOIN sylius_channel_price_history_config_excluded_taxons ON t0.id = sylius_channel_price_history_config_excluded_taxons.taxon_id
WHERE
  sylius_channel_price_history_config_excluded_taxons.channel_id = ?
ORDER BY
  t0.id ASC

SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.tree_root AS tree_root_10, t0.parent_id AS parent_id_11 FROM sylius_taxon t0 INNER JOIN sylius_channel_price_history_config_excluded_taxons ON t0.id = sylius_channel_price_history_config_excluded_taxons.taxon_id WHERE sylius_channel_price_history_config_excluded_taxons.channel_id = 3 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 446)
9	Sylius\Component\Core\Checker\ProductVariantLowestPriceDisplayChecker->isLowestPriceDisplayable (line 48)
10	Sylius\Component\Core\Calculator\ProductVariantPriceCalculator->calculateLowestPriceBeforeDiscount (line 77)
11	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductVariantNormalizer->normalize (line 75)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->populateDefaultVariantData (line 106)
15	Sylius\Bundle\ApiBundle\Serializer\Normalizer\ProductNormalizer->normalize (line 64)
16	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
17	Symfony\Component\Serializer\Serializer->normalize (line 152)
18	App\Serializer\ProductNormalizer->normalize (line 38)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
20	Symfony\Component\Serializer\Serializer->normalize (line 152)
21	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
22	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
23	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
24	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
25	Sylius\Bundle\ApiBundle\ApiPlatform\Hydra\Serializer\EmptyCollectionFiltersNormalizer->normalize (line 51)
26	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
27	Symfony\Component\Serializer\Serializer->normalize (line 152)
28	Symfony\Component\Serializer\Serializer->serialize (line 131)
29	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
30	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
31	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
32	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
33	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
34	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
35	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
38	Symfony\Component\HttpKernel\Kernel->handle (line 193)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 32)
41	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\Product\ProductTaxon	12
App\Entity\Channel\ChannelPricing	12
App\Entity\Product\ProductChannelConfig	12
App\Entity\Taxonomy\Taxon	5
App\Entity\Product\Product	4
App\Entity\Product\ProductTranslation	4
App\Entity\Product\ProductVariant	4
App\Entity\Product\ProductVariantTranslation	4
App\Entity\Channel\Channel	3
App\Entity\Channel\ChannelPriceHistoryConfig	3
App\Entity\Channel\ShopBillingData	2
App\Entity\Locale\Locale	1
App\Entity\Currency\Currency	1
App\Entity\Taxation\TaxCategory	1

Entities Mapping

Class	Mapping errors
Sylius\Component\Payment\Model\PaymentMethod	No errors.
Sylius\Component\Core\Model\PaymentMethod	No errors.
App\Entity\Payment\PaymentMethod	No errors.
Sylius\Component\Order\Model\Order	No errors.
Sylius\Component\Core\Model\Order	No errors.
App\Entity\Order\Order	No errors.
Sylius\Component\Shipping\Model\Shipment	No errors.
Sylius\Component\Core\Model\Shipment	No errors.
App\Entity\Shipping\Shipment	No errors.
Sylius\Component\Product\Model\Product	No errors.
Sylius\Component\Core\Model\Product	No errors.
App\Entity\Product\Product	No errors.
Sylius\Component\Channel\Model\Channel	No errors.
Sylius\Component\Core\Model\Channel	No errors.
App\Entity\Channel\Channel	No errors.
Sylius\Component\Locale\Model\Locale	No errors.
App\Entity\Locale\Locale	No errors.
Sylius\Component\Currency\Model\Currency	No errors.
App\Entity\Currency\Currency	No errors.
Sylius\Component\Addressing\Model\Zone	No errors.
App\Entity\Addressing\Zone	No errors.
Sylius\Component\Taxonomy\Model\Taxon	No errors.
Sylius\Component\Core\Model\Taxon	No errors.
App\Entity\Taxonomy\Taxon	No errors.
Sylius\Component\Core\Model\ShopBillingData	No errors.
App\Entity\Channel\ShopBillingData	No errors.
Sylius\Component\Core\Model\ChannelPriceHistoryConfig	No errors.
App\Entity\Channel\ChannelPriceHistoryConfig	No errors.
Sylius\Component\Addressing\Model\Country	No errors.
App\Entity\Addressing\Country	No errors.
Sylius\Component\Core\Model\Image	No errors.
Sylius\Component\Core\Model\ProductImage	No errors.
App\Entity\Product\ProductImage	No errors.
Sylius\Component\Promotion\Model\PromotionRule	No errors.
App\Entity\Promotion\PromotionRule	No errors.
Sylius\Component\Payment\Model\PaymentRequest	No errors.
App\Entity\Payment\PaymentRequest	No errors.
Sylius\Component\Currency\Model\ExchangeRate	No errors.
App\Entity\Currency\ExchangeRate	No errors.
Sylius\Component\Shipping\Model\ShippingMethod	No errors.
Sylius\Component\Core\Model\ShippingMethod	No errors.
App\Entity\Shipping\ShippingMethod	No errors.
Sylius\MolliePlugin\Entity\MollieCustomer	No errors.
Sylius\MolliePlugin\Entity\MollieGatewayConfig	No errors.
Sylius\Component\Product\Model\ProductTranslation	No errors.
Sylius\Component\Core\Model\ProductTranslation	No errors.
App\Entity\Product\ProductTranslation	No errors.
Sylius\Component\Product\Model\ProductVariant	No errors.
Sylius\Component\Core\Model\ProductVariant	No errors.
App\Entity\Product\ProductVariant	No errors.
Sylius\Component\Product\Model\ProductAssociation	No errors.
App\Entity\Product\ProductAssociation	No errors.
Sylius\Component\Core\Model\ProductTaxon	No errors.
App\Entity\Product\ProductTaxon	No errors.
Sylius\Component\Product\Model\ProductOption	No errors.
App\Entity\Product\ProductOption	No errors.
Sylius\MolliePlugin\Entity\ProductType	No errors.
Sylius\Component\Taxation\Model\TaxCategory	No errors.
App\Entity\Taxation\TaxCategory	No errors.
Sylius\Component\Shipping\Model\ShippingCategory	No errors.
App\Entity\Shipping\ShippingCategory	No errors.
Sylius\Component\Product\Model\ProductAssociationType	No errors.
App\Entity\Product\ProductAssociationType	No errors.
App\Entity\Product\ProductChannelConfig	No errors.
App\Entity\Product\ProductChannelHighlight	No errors.
App\Entity\Product\ProductChannelEquipment	No errors.
App\Entity\Product\ProductChannelCharacteristic	No errors.
App\Entity\Product\ProductChannelDocument	No errors.
Sylius\Component\Review\Model\Review	No errors.
Sylius\Component\Core\Model\ProductReview	No errors.
App\Entity\Product\ProductReview	No errors.
Sylius\Component\Attribute\Model\AttributeValue	No errors.
Sylius\Component\Product\Model\ProductAttributeValue	No errors.
App\Entity\Product\ProductAttributeValue	No errors.
Sylius\Component\Product\Model\ProductVariantTranslation	No errors.
App\Entity\Product\ProductVariantTranslation	No errors.
Sylius\Component\Core\Model\ChannelPricing	No errors.
App\Entity\Channel\ChannelPricing	No errors.
Sylius\Component\Product\Model\ProductOptionValue	No errors.
App\Entity\Product\ProductOptionValue	No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation	No errors.
App\Entity\Taxonomy\TaxonTranslation	No errors.
Sylius\Component\Core\Model\TaxonImage	No errors.
App\Entity\Taxonomy\TaxonImage	No errors.
Sylius\Component\Customer\Model\Customer	No errors.
Sylius\Component\Core\Model\Customer	No errors.
App\Entity\Customer\Customer	No errors.
Sylius\Component\Promotion\Model\CatalogPromotion	No errors.
Sylius\Component\Core\Model\CatalogPromotion	No errors.
App\Entity\Promotion\CatalogPromotion	No errors.
App\Entity\Product\Highlight	No errors.
App\Entity\Product\Equipment	No errors.
App\Entity\Product\ProductDocument	No errors.
Sylius\Component\Attribute\Model\Attribute	No errors.
Sylius\Component\Product\Model\ProductAttribute	No errors.
App\Entity\Product\ProductAttribute	No errors.

Symfony Profiler

GET https://dimaco-back-preprod.kwantic.dev/api/v2/shop/products?itemsPerPage=4&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping