Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

13.28 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.48 ms
(48.78%)

SELECT event.token, event.secret, event.url, profile.value as profile, JSON_AGG
			( DISTINCT
					message.message
			) FILTER (WHERE message.message IS NOT NULL) AS messages FROM telegram_bot_settings settings LEFT JOIN telegram_bot_settings_event event ON event.id = settings.event LEFT JOIN telegram_bot_settings_message message ON message.event = settings.event INNER JOIN telegram_bot_settings_profile profile ON profile.event = settings.event AND profile.value = ? GROUP BY event.token, event.secret, event.url, profile.value

Parameters:

[
  "0191363e-8dbc-7536-ba46-f8ded7e9d754"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  event.token,
  event.secret,
  event.url,
  profile.value as profile,
  JSON_AGG (DISTINCT message.message) FILTER (
    WHERE
      message.message IS NOT NULL
  ) AS messages
FROM
  telegram_bot_settings settings
  LEFT JOIN telegram_bot_settings_event event ON event.id = settings.event
  LEFT JOIN telegram_bot_settings_message message ON message.event = settings.event
  INNER JOIN telegram_bot_settings_profile profile ON profile.event = settings.event
  AND profile.value = ?
GROUP BY
  event.token,
  event.secret,
  event.url,
  profile.value

SELECT event.token, event.secret, event.url, profile.value as profile, JSON_AGG
			( DISTINCT
					message.message
			) FILTER (WHERE message.message IS NOT NULL) AS messages FROM telegram_bot_settings settings LEFT JOIN telegram_bot_settings_event event ON event.id = settings.event LEFT JOIN telegram_bot_settings_message message ON message.event = settings.event INNER JOIN telegram_bot_settings_profile profile ON profile.event = settings.event AND profile.value = '0191363e-8dbc-7536-ba46-f8ded7e9d754' GROUP BY event.token, event.secret, event.url, profile.value;

#	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->fetchAssociative (line 364)
5	BaksDev\Telegram\Bot\Repository\TelegramBotSettings\TelegramBotSettingsRepository->settings (line 124)
6	BaksDev\Auth\Telegram\Controller\Public\AuthController->index (line 126)
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 32)
12	require_once (line 7)

3.09 ms
(23.30%)

INSERT INTO messenger_messages (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:8:\"telegram\";s:59:\"\0BaksDev\\Core\\Doctrine\\DBAL\\Cache\\DBALCacheResetMessage\0key\";s:40:\"288f51b51d16c89df50b1caeb458e01ac3bb0d6c\";}}"
  "[]"
  "default"
  "2026-04-01 01:31:48"
  "2026-04-01 01:31:48"
]

View formatted query View runnable query Explain query View query backtrace

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

INSERT INTO messenger_messages (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:8:\\\"telegram\\\";s:59:\\\"\\0BaksDev\\\\Core\\\\Doctrine\\\\DBAL\\\\Cache\\\\DBALCacheResetMessage\\0key\\\";s:40:\\\"288f51b51d16c89df50b1caeb458e01ac3bb0d6c\\\";}}', '[]', 'default', '2026-04-01 01:31:48', '2026-04-01 01:31:48') 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 62)
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\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	BaksDev\Core\Messenger\MessageDispatch->dispatch (line 122)
18	BaksDev\Core\Doctrine\DBALQueryBuilder->executeDBALQuery (line 247)
19	BaksDev\Core\Doctrine\DBALQueryBuilder->fetchAssociative (line 364)
20	BaksDev\Telegram\Bot\Repository\TelegramBotSettings\TelegramBotSettingsRepository->settings (line 124)
21	BaksDev\Auth\Telegram\Controller\Public\AuthController->index (line 126)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 7)

2.89 ms
(21.78%)

"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 62)
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\AddDefaultStampsMiddleware->handle (line 33)
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->fetchAssociative (line 364)
19	BaksDev\Telegram\Bot\Repository\TelegramBotSettings\TelegramBotSettingsRepository->settings (line 124)
20	BaksDev\Auth\Telegram\Controller\Public\AuthController->index (line 126)
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 32)
26	require_once (line 7)

0.56 ms
(4.19%)

SELECT pg_notify(?, ?)

Parameters:

[
  "messenger_messages"
  "default"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  pg_notify(?, ?)

SELECT pg_notify('messenger_messages', 'default');

#	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 62)
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\AddDefaultStampsMiddleware->handle (line 33)
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->fetchAssociative (line 364)
19	BaksDev\Telegram\Bot\Repository\TelegramBotSettings\TelegramBotSettingsRepository->settings (line 124)
20	BaksDev\Auth\Telegram\Controller\Public\AuthController->index (line 126)
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 32)
26	require_once (line 7)

0.26 ms
(1.94%)

"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 62)
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\AddDefaultStampsMiddleware->handle (line 33)
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->fetchAssociative (line 364)
19	BaksDev\Telegram\Bot\Repository\TelegramBotSettings\TelegramBotSettingsRepository->settings (line 124)
20	BaksDev\Auth\Telegram\Controller\Public\AuthController->index (line 126)
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 32)
26	require_once (line 7)

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.baks.dev/telegram/auth

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping