Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

9.61 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.28 ms

SET TIME ZONE 'UTC'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SET
  TIME ZONE 'UTC'

SET TIME ZONE 'UTC';

#	File/Call
1	Doctrine\DBAL\Connection->connect (line 222)
2	Doctrine\DBAL\Connection->executeQuery (line 792)
3	Doctrine\DBAL\Connection->fetchOne (line 332)
4	App\Identity\Infrastructure\Adapter\DbalOrganizationTimeZones->ofConversation (line 44)
5	App\UI\Http\Listener\DisplayTimeZoneListener->zoneOf (line 67)
6	App\UI\Http\Listener\DisplayTimeZoneListener->__invoke (line 43)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

4.34 ms

SELECT group_id FROM channels WHERE id = ?

Parameters:

[
  "01a154d0-2bf6-74d0-bc8c-897b35056e01"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  group_id
FROM
  channels
WHERE
  id = ?

SELECT group_id FROM channels WHERE id = '01a154d0-2bf6-74d0-bc8c-897b35056e01';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Identity\Infrastructure\Adapter\DbalOrganizationTimeZones->ofConversation (line 44)
3	App\UI\Http\Listener\DisplayTimeZoneListener->zoneOf (line 67)
4	App\UI\Http\Listener\DisplayTimeZoneListener->__invoke (line 43)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

2.78 ms

SELECT timezone FROM users WHERE id = ? AND account_type IN ('group', 'organization')

Parameters:

[
  "01a154cc-beb0-72dd-8312-040cb8716c73"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  timezone
FROM
  users
WHERE
  id = ?
  AND account_type IN ('group', 'organization')

SELECT timezone FROM users WHERE id = '01a154cc-beb0-72dd-8312-040cb8716c73' AND account_type IN ('group', 'organization');

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	App\Identity\Infrastructure\Adapter\DbalOrganizationTimeZones->read (line 74)
3	App\Identity\Infrastructure\Adapter\DbalOrganizationTimeZones->of (line 35)
4	App\Identity\Infrastructure\Adapter\DbalOrganizationTimeZones->ofConversation (line 46)
5	App\UI\Http\Listener\DisplayTimeZoneListener->zoneOf (line 67)
6	App\UI\Http\Listener\DisplayTimeZoneListener->__invoke (line 43)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

2.20 ms

SELECT t0.id AS id_1, t0.conversation_id AS conversation_id_2, t0.currency AS currency_3, t0.enabled AS enabled_4, t0.closed_message AS closed_message_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.packaging_grams AS packaging_grams_12, t0.default_item_grams AS default_item_grams_13, t0.pickup_lead_time AS pickup_lead_time_14, t0.shipping_lead_time AS shipping_lead_time_15, t0.return_instructions AS return_instructions_16, t0.default_low_stock_threshold AS default_low_stock_threshold_17, t0.abandoned_carts_enabled AS abandoned_carts_enabled_18, t0.abandoned_cart_first_delay_hours AS abandoned_cart_first_delay_hours_19, t0.abandoned_cart_second_delay_hours AS abandoned_cart_second_delay_hours_20, t0.abandoned_cart_discount_bps AS abandoned_cart_discount_bps_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23 FROM shop_shops t0 WHERE t0.conversation_id = ? LIMIT 1

Parameters:

[
  "01a154d0-2bf6-74d0-bc8c-897b35056e01"
]

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.enabled AS enabled_4,
  t0.closed_message AS closed_message_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.packaging_grams AS packaging_grams_12,
  t0.default_item_grams AS default_item_grams_13,
  t0.pickup_lead_time AS pickup_lead_time_14,
  t0.shipping_lead_time AS shipping_lead_time_15,
  t0.return_instructions AS return_instructions_16,
  t0.default_low_stock_threshold AS default_low_stock_threshold_17,
  t0.abandoned_carts_enabled AS abandoned_carts_enabled_18,
  t0.abandoned_cart_first_delay_hours AS abandoned_cart_first_delay_hours_19,
  t0.abandoned_cart_second_delay_hours AS abandoned_cart_second_delay_hours_20,
  t0.abandoned_cart_discount_bps AS abandoned_cart_discount_bps_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23
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.enabled AS enabled_4, t0.closed_message AS closed_message_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.packaging_grams AS packaging_grams_12, t0.default_item_grams AS default_item_grams_13, t0.pickup_lead_time AS pickup_lead_time_14, t0.shipping_lead_time AS shipping_lead_time_15, t0.return_instructions AS return_instructions_16, t0.default_low_stock_threshold AS default_low_stock_threshold_17, t0.abandoned_carts_enabled AS abandoned_carts_enabled_18, t0.abandoned_cart_first_delay_hours AS abandoned_cart_first_delay_hours_19, t0.abandoned_cart_second_delay_hours AS abandoned_cart_second_delay_hours_20, t0.abandoned_cart_discount_bps AS abandoned_cart_discount_bps_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23 FROM shop_shops t0 WHERE t0.conversation_id = '01a154d0-2bf6-74d0-bc8c-897b35056e01' 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 49)
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 22)
18	App\UI\Http\Api\Shop\PublicShopController->products (line 65)
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

Entities Mapping

Class	Mapping errors
App\Shop\Domain\Model\Shop	No errors.

Symfony Profiler

GET https://ofiladdict.tokii.fr/public-api/shop/01a154d0-2bf6-74d0-bc8c-897b35056e01/products?limit=100

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping