Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

25.68 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

21.38 ms
(83.28%)

SELECT profile.id, profile_region.value AS region, profile_shop.value AS shop, profile_orders.value AS orders, profile_warehouse.value AS warehouse, region_trans.name AS region_name, users_profile_personal.location, users_profile_personal.latitude, users_profile_personal.longitude, JSON_AGG ( DISTINCT

                JSONB_BUILD_OBJECT
                (
                    'value', user_profile_value.value,
                    'name', user_profile_field_trans.name,
                    'type', user_profile_field.type
                )

            ) AS profile_value FROM users_profile profile INNER JOIN users_profile_info info ON info.profile = profile.id AND info.status = ? LEFT JOIN users_profile_event event ON event.id = profile.event INNER JOIN user_profile_region profile_region ON profile_region.event = profile.event LEFT JOIN user_profile_shop profile_shop ON profile_shop.event = profile.event LEFT JOIN user_profile_orders profile_orders ON profile_orders.event = profile.event LEFT JOIN user_profile_warehouse profile_warehouse ON profile_warehouse.event = profile.event LEFT JOIN users_profile_personal users_profile_personal ON users_profile_personal.event = profile.event LEFT JOIN users_profile_value user_profile_value ON user_profile_value.event = profile.event LEFT JOIN region region ON region.id = profile_region.value LEFT JOIN region_trans region_trans ON region_trans.event = region.event INNER JOIN type_users_profile_section_field user_profile_field ON 
                    user_profile_field.id = user_profile_value.field 
                    AND user_profile_field.card = true
                 LEFT JOIN type_users_profile_section_field_trans user_profile_field_trans ON 
                    user_profile_field_trans.field = user_profile_field.id 
                    AND user_profile_field_trans.local = ?
                 GROUP BY event.sort, profile.id, profile_region.value, profile_shop.value, profile_orders.value, profile_warehouse.value, region_trans.name, users_profile_personal.location, users_profile_personal.latitude, users_profile_personal.longitude ORDER BY CASE WHEN profile.id = ? THEN 0 ELSE 1 END, CASE WHEN profile_region.value = ? THEN 0 ELSE 1 END, profile_region.value, event.sort DESC

Parameters:

[
  "act"
  "ru"
  "01982ecf-0a6a-79e5-967b-4992d1b836bb"
  "201042a6-c35d-7bc4-9cb9-ef8bc1c8711e"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  profile.id,
  profile_region.value AS region,
  profile_shop.value AS shop,
  profile_orders.value AS orders,
  profile_warehouse.value AS warehouse,
  region_trans.name AS region_name,
  users_profile_personal.location,
  users_profile_personal.latitude,
  users_profile_personal.longitude,
  JSON_AGG (
    DISTINCT JSONB_BUILD_OBJECT (
      'value', user_profile_value.value,
      'name', user_profile_field_trans.name,
      'type', user_profile_field.type
    )
  ) AS profile_value
FROM
  users_profile profile
  INNER JOIN users_profile_info info ON info.profile = profile.id
  AND info.status = ?
  LEFT JOIN users_profile_event event ON event.id = profile.event
  INNER JOIN user_profile_region profile_region ON profile_region.event = profile.event
  LEFT JOIN user_profile_shop profile_shop ON profile_shop.event = profile.event
  LEFT JOIN user_profile_orders profile_orders ON profile_orders.event = profile.event
  LEFT JOIN user_profile_warehouse profile_warehouse ON profile_warehouse.event = profile.event
  LEFT JOIN users_profile_personal users_profile_personal ON users_profile_personal.event = profile.event
  LEFT JOIN users_profile_value user_profile_value ON user_profile_value.event = profile.event
  LEFT JOIN region region ON region.id = profile_region.value
  LEFT JOIN region_trans region_trans ON region_trans.event = region.event
  INNER JOIN type_users_profile_section_field user_profile_field ON user_profile_field.id = user_profile_value.field
  AND user_profile_field.card = true
  LEFT JOIN type_users_profile_section_field_trans user_profile_field_trans ON user_profile_field_trans.field = user_profile_field.id
  AND user_profile_field_trans.local = ?
GROUP BY
  event.sort,
  profile.id,
  profile_region.value,
  profile_shop.value,
  profile_orders.value,
  profile_warehouse.value,
  region_trans.name,
  users_profile_personal.location,
  users_profile_personal.latitude,
  users_profile_personal.longitude
ORDER BY
  CASE WHEN profile.id = ? THEN
    0
  ELSE
    1
  END,
  CASE WHEN profile_region.value = ? THEN
    0
  ELSE
    1
  END,
  profile_region.value,
  event.sort DESC

SELECT profile.id, profile_region.value AS region, profile_shop.value AS shop, profile_orders.value AS orders, profile_warehouse.value AS warehouse, region_trans.name AS region_name, users_profile_personal.location, users_profile_personal.latitude, users_profile_personal.longitude, JSON_AGG ( DISTINCT

                JSONB_BUILD_OBJECT
                (
                    'value', user_profile_value.value,
                    'name', user_profile_field_trans.name,
                    'type', user_profile_field.type
                )

            ) AS profile_value FROM users_profile profile INNER JOIN users_profile_info info ON info.profile = profile.id AND info.status = 'act' LEFT JOIN users_profile_event event ON event.id = profile.event INNER JOIN user_profile_region profile_region ON profile_region.event = profile.event LEFT JOIN user_profile_shop profile_shop ON profile_shop.event = profile.event LEFT JOIN user_profile_orders profile_orders ON profile_orders.event = profile.event LEFT JOIN user_profile_warehouse profile_warehouse ON profile_warehouse.event = profile.event LEFT JOIN users_profile_personal users_profile_personal ON users_profile_personal.event = profile.event LEFT JOIN users_profile_value user_profile_value ON user_profile_value.event = profile.event LEFT JOIN region region ON region.id = profile_region.value LEFT JOIN region_trans region_trans ON region_trans.event = region.event INNER JOIN type_users_profile_section_field user_profile_field ON 
                    user_profile_field.id = user_profile_value.field 
                    AND user_profile_field.card = true
                 LEFT JOIN type_users_profile_section_field_trans user_profile_field_trans ON 
                    user_profile_field_trans.field = user_profile_field.id 
                    AND user_profile_field_trans.local = 'ru'
                 GROUP BY event.sort, profile.id, profile_region.value, profile_shop.value, profile_orders.value, profile_warehouse.value, region_trans.name, users_profile_personal.location, users_profile_personal.latitude, users_profile_personal.longitude ORDER BY CASE WHEN profile.id = '01982ecf-0a6a-79e5-967b-4992d1b836bb' THEN 0 ELSE 1 END, CASE WHEN profile_region.value = '201042a6-c35d-7bc4-9cb9-ef8bc1c8711e' THEN 0 ELSE 1 END, profile_region.value, event.sort DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeCacheQuery (line 851)
2	BaksDev\Core\Doctrine\DBALQueryBuilder->executeCacheQuery (line 479)
3	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 253)
4	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
5	Generator->current (line 67)
6	BaksDev\Users\Profile\UserProfile\Controller\Public\ContactsController->index (line 67)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

2.00 ms
(7.78%)

INSERT INTO messenger_core (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id

Parameters:

[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:2:{s:53:\"Symfony\\Component\\Messenger\\Stamp\\TransportNamesStamp\";a:1:{i:0;O:53:\"Symfony\\Component\\Messenger\\Stamp\\TransportNamesStamp\":1:{s:69:\"\0Symfony\\Component\\Messenger\\Stamp\\TransportNamesStamp\0transportNames\";a:1:{i:0;s:9:\"async-low\";}}}s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:54:\"BaksDev\\Core\\Doctrine\\DBAL\\Cache\\DBALCacheResetMessage\":2:{s:65:\"\0BaksDev\\Core\\Doctrine\\DBAL\\Cache\\DBALCacheResetMessage\0namespace\";s:18:\"users-profile-user\";s:59:\"\0BaksDev\\Core\\Doctrine\\DBAL\\Cache\\DBALCacheResetMessage\0key\";s:40:\"ea1074c9def4a74cccd898325b80406d13cad070\";}}"
  "[]"
  "low"
  "2026-02-21 14:19:49"
  "2026-02-21 14:19:49"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO messenger_core (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?) RETURNING id

INSERT INTO messenger_core (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:2:{s:53:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\\";a:1:{i:0;O:53:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\\":1:{s:69:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\TransportNamesStamp\\0transportNames\\\";a:1:{i:0;s:9:\\\"async-low\\\";}}}s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:54:\\\"BaksDev\\\\Core\\\\Doctrine\\\\DBAL\\\\Cache\\\\DBALCacheResetMessage\\\":2:{s:65:\\\"\\0BaksDev\\\\Core\\\\Doctrine\\\\DBAL\\\\Cache\\\\DBALCacheResetMessage\\0namespace\\\";s:18:\\\"users-profile-user\\\";s:59:\\\"\\0BaksDev\\\\Core\\\\Doctrine\\\\DBAL\\\\Cache\\\\DBALCacheResetMessage\\0key\\\";s:40:\\\"ea1074c9def4a74cccd898325b80406d13cad070\\\";}}', '[]', 'low', '2026-02-21 14:19:49', '2026-02-21 14:19:49') RETURNING id;

#	File/Call
1	Doctrine\DBAL\Connection->fetchFirstColumn (line 670)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 461)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 145)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 76)
6	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 65)
7	BaksDev\Core\Messenger\MessageHandleMiddleware->handle (line 96)
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\TraceableMiddleware->handle (line 36)
14	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
15	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
16	BaksDev\Core\Messenger\MessageDispatch->dispatch (line 122)
17	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 247)
18	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
19	Generator->current (line 67)
20	BaksDev\Users\Profile\UserProfile\Controller\Public\ContactsController->index (line 67)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

1.43 ms
(5.58%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 482)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 145)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 76)
5	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 65)
6	BaksDev\Core\Messenger\MessageHandleMiddleware->handle (line 96)
7	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
15	BaksDev\Core\Messenger\MessageDispatch->dispatch (line 122)
16	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 247)
17	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
18	Generator->current (line 67)
19	BaksDev\Users\Profile\UserProfile\Controller\Public\ContactsController->index (line 67)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.51 ms
(1.99%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 457)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 145)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 76)
5	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 65)
6	BaksDev\Core\Messenger\MessageHandleMiddleware->handle (line 96)
7	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
15	BaksDev\Core\Messenger\MessageDispatch->dispatch (line 122)
16	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 247)
17	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
18	Generator->current (line 67)
19	BaksDev\Users\Profile\UserProfile\Controller\Public\ContactsController->index (line 67)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.35 ms
(1.36%)

SELECT pg_notify(?, ?)

Parameters:

[
  "messenger_core"
  "low"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  pg_notify(?, ?)

SELECT pg_notify('messenger_core', 'low');

#	File/Call
1	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 465)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 145)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 76)
5	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 65)
6	BaksDev\Core\Messenger\MessageHandleMiddleware->handle (line 96)
7	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
15	BaksDev\Core\Messenger\MessageDispatch->dispatch (line 122)
16	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 247)
17	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAllHydrate (line 341)
18	Generator->current (line 67)
19	BaksDev\Users\Profile\UserProfile\Controller\Public\ContactsController->index (line 67)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	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

No loaded entities.

Symfony Profiler

GET https://dvz.all.baks.dev/contact

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping