Symfony Profiler

Query Metrics

42 Database Queries

8 Different statements

49.32 ms Query time

0 Invalid entities

156 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.42 ms
(37.35%)

SELECT t0.id AS id_1, t0.shop_id AS shop_id_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.option_value_ids AS option_value_ids_5, t0.price_cents AS price_cents_6, t0.currency AS currency_7, t0.original_price_cents AS original_price_cents_8, t0.tax_rate_bps AS tax_rate_bps_9, t0.stock_quantity AS stock_quantity_10, t0.low_stock_threshold AS low_stock_threshold_11, t0.tracks_inventory AS tracks_inventory_12, t0.allow_backorder AS allow_backorder_13, t0.weight_grams AS weight_grams_14, t0.enabled AS enabled_15, t0.position AS position_16, t0.product_id AS product_id_17 FROM shop_product_variants t0 WHERE t0.product_id = ? ORDER BY t0.position ASC

Parameters:

[
  "019faa7b-74be-775e-9b87-b14c66b209b9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.shop_id AS shop_id_2,
  t0.sku AS sku_3,
  t0.barcode AS barcode_4,
  t0.option_value_ids AS option_value_ids_5,
  t0.price_cents AS price_cents_6,
  t0.currency AS currency_7,
  t0.original_price_cents AS original_price_cents_8,
  t0.tax_rate_bps AS tax_rate_bps_9,
  t0.stock_quantity AS stock_quantity_10,
  t0.low_stock_threshold AS low_stock_threshold_11,
  t0.tracks_inventory AS tracks_inventory_12,
  t0.allow_backorder AS allow_backorder_13,
  t0.weight_grams AS weight_grams_14,
  t0.enabled AS enabled_15,
  t0.position AS position_16,
  t0.product_id AS product_id_17
FROM
  shop_product_variants t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.shop_id AS shop_id_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.option_value_ids AS option_value_ids_5, t0.price_cents AS price_cents_6, t0.currency AS currency_7, t0.original_price_cents AS original_price_cents_8, t0.tax_rate_bps AS tax_rate_bps_9, t0.stock_quantity AS stock_quantity_10, t0.low_stock_threshold AS low_stock_threshold_11, t0.tracks_inventory AS tracks_inventory_12, t0.allow_backorder AS allow_backorder_13, t0.weight_grams AS weight_grams_14, t0.enabled AS enabled_15, t0.position AS position_16, t0.product_id AS product_id_17 FROM shop_product_variants t0 WHERE t0.product_id = '019faa7b-74be-775e-9b87-b14c66b209b9' ORDER BY t0.position 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->first (line 169)
7	Doctrine\ORM\PersistentCollection->first (line 518)
8	App\Shop\Domain\Model\Product->defaultVariant (line 408)
9	App\Shop\Application\Service\ShopCatalogItemProjector->item (line 32)
10	App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler->{closure:App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler::__invoke():81} (line 81)
11	array_map (line 81)
12	App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler::__invoke (line 81)
13	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
14	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
15	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
16	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
17	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
18	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
19	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
20	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
21	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
22	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
23	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
24	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
25	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
26	App\UI\Http\Api\Shop\PublicShopController->products (line 38)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

14.67 ms
(29.75%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt_text AS alt_text_3, t0.position AS position_4, t0.product_id AS product_id_5 FROM shop_product_images t0 WHERE t0.product_id = ? ORDER BY t0.position ASC

Parameters:

[
  "019faa7b-74be-775e-9b87-b14c66b209b9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.alt_text AS alt_text_3,
  t0.position AS position_4,
  t0.product_id AS product_id_5
FROM
  shop_product_images t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt_text AS alt_text_3, t0.position AS position_4, t0.product_id AS product_id_5 FROM shop_product_images t0 WHERE t0.product_id = '019faa7b-74be-775e-9b87-b14c66b209b9' ORDER BY t0.position 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->first (line 169)
7	Doctrine\ORM\PersistentCollection->first (line 518)
8	App\Shop\Application\Service\ShopCatalogItemProjector->item (line 31)
9	App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler->{closure:App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler::__invoke():81} (line 81)
10	array_map (line 81)
11	App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler::__invoke (line 81)
12	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
13	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
14	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
15	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
16	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
17	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
18	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
19	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
20	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
21	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
22	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
23	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
24	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
25	App\UI\Http\Api\Shop\PublicShopController->products (line 38)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

4.99 ms
(10.11%)

SELECT s0_.id AS id_0, s0_.shop_id AS shop_id_1, s0_.name AS name_2, s0_.slug AS slug_3, s0_.description AS description_4, s0_.short_description AS short_description_5, s0_.status AS status_6, s0_.product_type AS product_type_7, s0_.brand AS brand_8, s0_.position AS position_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.taxon_ids AS taxon_ids_12 FROM shop_products s0_ WHERE s0_.shop_id = ? AND s0_.status = ? ORDER BY s0_.position ASC, s0_.created_at DESC LIMIT 100

Parameters:

[
  "019faa7b-7350-76c5-a323-f767c991beda"
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.shop_id AS shop_id_1,
  s0_.name AS name_2,
  s0_.slug AS slug_3,
  s0_.description AS description_4,
  s0_.short_description AS short_description_5,
  s0_.status AS status_6,
  s0_.product_type AS product_type_7,
  s0_.brand AS brand_8,
  s0_.position AS position_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.taxon_ids AS taxon_ids_12
FROM
  shop_products s0_
WHERE
  s0_.shop_id = ?
  AND s0_.status = ?
ORDER BY
  s0_.position ASC,
  s0_.created_at DESC
LIMIT
  100

SELECT s0_.id AS id_0, s0_.shop_id AS shop_id_1, s0_.name AS name_2, s0_.slug AS slug_3, s0_.description AS description_4, s0_.short_description AS short_description_5, s0_.status AS status_6, s0_.product_type AS product_type_7, s0_.brand AS brand_8, s0_.position AS position_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.taxon_ids AS taxon_ids_12 FROM shop_products s0_ WHERE s0_.shop_id = '019faa7b-7350-76c5-a323-f767c991beda' AND s0_.status = 'published' ORDER BY s0_.position ASC, s0_.created_at DESC LIMIT 100;

#	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	App\Shop\Infrastructure\Persistence\Doctrine\DoctrineProductRepository->search (line 55)
7	App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler->__invoke (line 48)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
11	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
16	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
17	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
18	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
19	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
20	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
21	App\UI\Http\Api\Shop\PublicShopController->products (line 38)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

4.75 ms
(9.64%)

SELECT t0.id AS id_1, t0.conversation_id AS conversation_id_2, t0.currency AS currency_3, t0.prices_include_tax AS prices_include_tax_4, t0.enabled AS enabled_5, t0.pickup_enabled AS pickup_enabled_6, t0.shipping_enabled AS shipping_enabled_7, t0.pickup_address AS pickup_address_8, t0.pickup_instructions AS pickup_instructions_9, t0.flat_shipping_cents AS flat_shipping_cents_10, t0.free_shipping_threshold_cents AS free_shipping_threshold_cents_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM shop_shops t0 WHERE t0.conversation_id = ? LIMIT 1

Parameters:

[
  "019faa7b-72fa-79fe-a64d-cb92fba2ab2b"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.conversation_id AS conversation_id_2,
  t0.currency AS currency_3,
  t0.prices_include_tax AS prices_include_tax_4,
  t0.enabled AS enabled_5,
  t0.pickup_enabled AS pickup_enabled_6,
  t0.shipping_enabled AS shipping_enabled_7,
  t0.pickup_address AS pickup_address_8,
  t0.pickup_instructions AS pickup_instructions_9,
  t0.flat_shipping_cents AS flat_shipping_cents_10,
  t0.free_shipping_threshold_cents AS free_shipping_threshold_cents_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  shop_shops t0
WHERE
  t0.conversation_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.conversation_id AS conversation_id_2, t0.currency AS currency_3, t0.prices_include_tax AS prices_include_tax_4, t0.enabled AS enabled_5, t0.pickup_enabled AS pickup_enabled_6, t0.shipping_enabled AS shipping_enabled_7, t0.pickup_address AS pickup_address_8, t0.pickup_instructions AS pickup_instructions_9, t0.flat_shipping_cents AS flat_shipping_cents_10, t0.free_shipping_threshold_cents AS free_shipping_threshold_cents_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM shop_shops t0 WHERE t0.conversation_id = '019faa7b-72fa-79fe-a64d-cb92fba2ab2b' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Shop\Infrastructure\Persistence\Doctrine\DoctrineShopRepository->findByConversation (line 33)
4	App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler->__invoke (line 42)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Api\Shop\PublicShopController->products (line 38)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

1.84 ms
(3.73%)

SELECT t0.id AS id_1, t0.shop_id AS shop_id_2, t0.parent_id AS parent_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.position AS position_6 FROM shop_taxons t0 WHERE t0.shop_id = ? ORDER BY t0.position ASC

Parameters:

[
  "019faa7b-7350-76c5-a323-f767c991beda"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.shop_id AS shop_id_2,
  t0.parent_id AS parent_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.position AS position_6
FROM
  shop_taxons t0
WHERE
  t0.shop_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.shop_id AS shop_id_2, t0.parent_id AS parent_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.position AS position_6 FROM shop_taxons t0 WHERE t0.shop_id = '019faa7b-7350-76c5-a323-f767c991beda' ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Shop\Infrastructure\Persistence\Doctrine\DoctrineTaxonRepository->findByShop (line 40)
4	App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler->__invoke (line 60)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Api\Shop\PublicShopController->products (line 38)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

1.76 ms
(3.57%)

SELECT t0.id AS id_1, t0.shop_id AS shop_id_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.starts_at AS starts_at_6, t0.ends_at AS ends_at_7, t0.target_channel_ids AS target_channel_ids_8, t0.promotion_ids AS promotion_ids_9, t0.banner_text AS banner_text_10, t0.banner_image_path AS banner_image_path_11, t0.announcement_sent AS announcement_sent_12 FROM shop_campaigns t0 WHERE t0.status = ?

Parameters:

[
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.shop_id AS shop_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.status AS status_5,
  t0.starts_at AS starts_at_6,
  t0.ends_at AS ends_at_7,
  t0.target_channel_ids AS target_channel_ids_8,
  t0.promotion_ids AS promotion_ids_9,
  t0.banner_text AS banner_text_10,
  t0.banner_image_path AS banner_image_path_11,
  t0.announcement_sent AS announcement_sent_12
FROM
  shop_campaigns t0
WHERE
  t0.status = ?

SELECT t0.id AS id_1, t0.shop_id AS shop_id_2, t0.name AS name_3, t0.description AS description_4, t0.status AS status_5, t0.starts_at AS starts_at_6, t0.ends_at AS ends_at_7, t0.target_channel_ids AS target_channel_ids_8, t0.promotion_ids AS promotion_ids_9, t0.banner_text AS banner_text_10, t0.banner_image_path AS banner_image_path_11, t0.announcement_sent AS announcement_sent_12 FROM shop_campaigns t0 WHERE t0.status = 'active';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Shop\Infrastructure\Persistence\Doctrine\DoctrineCampaignRepository->findActiveForChannel (line 55)
4	App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler->__invoke (line 70)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Api\Shop\PublicShopController->products (line 38)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

1.51 ms
(3.05%)

SELECT COUNT(s0_.id) AS sclr_0 FROM shop_products s0_ WHERE s0_.shop_id = ? AND s0_.status = ?

Parameters:

[
  "019faa7b-7350-76c5-a323-f767c991beda"
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  shop_products s0_
WHERE
  s0_.shop_id = ?
  AND s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM shop_products s0_ WHERE s0_.shop_id = '019faa7b-7350-76c5-a323-f767c991beda' AND s0_.status = 'published';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Shop\Infrastructure\Persistence\Doctrine\DoctrineProductRepository->countSearch (line 65)
8	App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler->__invoke (line 49)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
11	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
12	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
13	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
14	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
15	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
16	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
17	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
18	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
19	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
20	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
21	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
22	App\UI\Http\Api\Shop\PublicShopController->products (line 38)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

1.37 ms
(2.78%)

SELECT t0.id AS id_1, t0.shop_id AS shop_id_2, t0.name AS name_3, t0.scope_type AS scope_type_4, t0.scope_id AS scope_id_5, t0.action_type AS action_type_6, t0.action_value AS action_value_7, t0.starts_at AS starts_at_8, t0.ends_at AS ends_at_9, t0.priority AS priority_10, t0.enabled AS enabled_11 FROM shop_catalog_promotions t0 WHERE t0.shop_id = ? ORDER BY t0.priority DESC

Parameters:

[
  "019faa7b-7350-76c5-a323-f767c991beda"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.shop_id AS shop_id_2,
  t0.name AS name_3,
  t0.scope_type AS scope_type_4,
  t0.scope_id AS scope_id_5,
  t0.action_type AS action_type_6,
  t0.action_value AS action_value_7,
  t0.starts_at AS starts_at_8,
  t0.ends_at AS ends_at_9,
  t0.priority AS priority_10,
  t0.enabled AS enabled_11
FROM
  shop_catalog_promotions t0
WHERE
  t0.shop_id = ?
ORDER BY
  t0.priority DESC

SELECT t0.id AS id_1, t0.shop_id AS shop_id_2, t0.name AS name_3, t0.scope_type AS scope_type_4, t0.scope_id AS scope_id_5, t0.action_type AS action_type_6, t0.action_value AS action_value_7, t0.starts_at AS starts_at_8, t0.ends_at AS ends_at_9, t0.priority AS priority_10, t0.enabled AS enabled_11 FROM shop_catalog_promotions t0 WHERE t0.shop_id = '019faa7b-7350-76c5-a323-f767c991beda' ORDER BY t0.priority DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	App\Shop\Infrastructure\Persistence\Doctrine\DoctrineCatalogPromotionRepository->findByShop (line 34)
4	App\Shop\Application\Query\GetPublicShopCatalog\GetPublicShopCatalogHandler->__invoke (line 51)
5	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 148)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 90)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 75)
8	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
17	App\SharedKernel\Infrastructure\Bus\MessengerQueryBus->ask (line 19)
18	App\UI\Http\Api\Shop\PublicShopController->products (line 38)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	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\Shop\Domain\Model\ProductVariant	84
App\Shop\Domain\Model\ProductImage	36
App\Shop\Domain\Model\Product	18
App\Shop\Domain\Model\Taxon	16
App\Shop\Domain\Model\Shop	1
App\Shop\Domain\Model\Campaign	1

Entities Mapping

Class	Mapping errors
App\Shop\Domain\Model\Shop	No errors.
App\Shop\Domain\Model\Product	No errors.
App\Shop\Domain\Model\ProductImage	No errors.
App\Shop\Domain\Model\ProductOption	No errors.
App\Shop\Domain\Model\ProductVariant	No errors.
App\Shop\Domain\Model\CatalogPromotion	No errors.
App\Shop\Domain\Model\Taxon	No errors.
App\Shop\Domain\Model\Campaign	No errors.

Symfony Profiler

GET https://optiquelumiere.tokii.fr/public-api/shop/019faa7b-72fa-79fe-a64d-cb92fba2ab2b/products?limit=100

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping