Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

17.12 ms Query time

0 Invalid entities

Group similar statements

#▲

Time

Info

5.76 ms

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.customized_route AS customized_route_3, t0.customized_domain AS customized_domain_4, t0.iconify_code AS iconify_code_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10, t0.background__sebii__file__media__id AS background__sebii__file__media__id_11 FROM "sebii__category__universe" t0 WHERE t0.customized_domain = ? LIMIT 1

Parameters:

  0 of 0   
[▼
  "stream.sebii.dev"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.customized_route AS customized_route_3,
  t0.customized_domain AS customized_domain_4,
  t0.iconify_code AS iconify_code_5,
  t0.id AS id_6,
  t0.api_id AS api_id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10,
  t0.background__sebii__file__media__id AS background__sebii__file__media__id_11
FROM
  "sebii__category__universe" t0
WHERE
  t0.customized_domain = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.customized_route AS customized_route_3, t0.customized_domain AS customized_domain_4, t0.iconify_code AS iconify_code_5, t0.id AS id_6, t0.api_id AS api_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.cover__sebii__file__media__id AS cover__sebii__file__media__id_10, t0.background__sebii__file__media__id AS background__sebii__file__media__id_11 FROM "sebii__category__universe" t0 WHERE t0.customized_domain = 'stream.sebii.dev' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 158)
5	Doctrine\ORM\EntityRepository->__call (line 94)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 36)
7	App\Event\EventSubscriber\Kernel\UniverseSubscriber->detectUniverse (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 28)
15	require (line 9)
16	require_once (line 8)

0.44 ms

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 446)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 141)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 70)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 62)
6	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
7	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
8	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
9	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
10	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
11	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 69)
12	Symfony\Component\Messenger\MessageBus->dispatch (line 37)
13	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 29)
14	App\Event\EventSubscriber\RequestSubscriber->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 28)
22	require (line 9)
23	require_once (line 8)

4.26 ms

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

Parameters:

  0 of 0   
[▼
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{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:46:\"App\\Messenger\\Message\\Security\\AnalyticMessage\":6:{s:50:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0at\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2025-04-30 18:37:41.893621\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:52:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0page\";s:1:\"/\";s:54:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0domain\";s:16:\"stream.sebii.dev\";s:57:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0ipAddress\";s:10:\"172.19.0.1\";s:57:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0userAgent\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.3\";s:56:\"\0App\\Messenger\\Message\\Security\\AnalyticMessage\0referrer\";N;}}"
  "[]"
  "security_analytic"
  "2025-04-30 18:37:41"
  "2025-04-30 18:37:41"
]

View formatted query View runnable query Explain query View query backtrace

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

INSERT INTO sebii__messenger__message (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{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:46:\\\"App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\\":6:{s:50:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0at\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-04-30 18:37:41.893621\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:52:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0page\\\";s:1:\\\"/\\\";s:54:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0domain\\\";s:16:\\\"stream.sebii.dev\\\";s:57:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0ipAddress\\\";s:10:\\\"172.19.0.1\\\";s:57:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0userAgent\\\";s:114:\\\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.3\\\";s:56:\\\"\\0App\\\\Messenger\\\\Message\\\\Security\\\\AnalyticMessage\\0referrer\\\";N;}}', '[]', 'security_analytic', '2025-04-30 18:37:41', '2025-04-30 18:37:41') RETURNING id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 953)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 450)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 141)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 46)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 70)
6	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 62)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 69)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 37)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 29)
15	App\Event\EventSubscriber\RequestSubscriber->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 28)
23	require (line 9)
24	require_once (line 8)

6.67 ms

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 477)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 141)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 46)
5	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 70)
6	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 62)
7	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
11	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 69)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 37)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 29)
15	App\Event\EventSubscriber\RequestSubscriber->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 28)
23	require (line 9)
24	require_once (line 8)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Class	Mapping errors
App\Entity\Category\Universe	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\File\Media	No errors.

Symfony Profiler

GET https://stream.sebii.dev/

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

GET https://stream.sebii.dev/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping