Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

10.11 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.10 ms
(89.95%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.hashed_password AS hashed_password_3, t0.display_name AS display_name_4, t0.roles AS roles_5, t0.avatar_url AS avatar_url_6, t0.theme_config AS theme_config_7, t0.status AS status_8, t0.custom_status_text AS custom_status_text_9, t0.last_seen_at AS last_seen_at_10, t0.created_at AS created_at_11, t0.is_email_verified AS is_email_verified_12, t0.email_verification_token AS email_verification_token_13, t0.email_verification_token_expires_at AS email_verification_token_expires_at_14, t0.account_type AS account_type_15, t0.description AS description_16, t0.organization_category AS organization_category_17 FROM users t0 WHERE t0.email_verification_token = ? LIMIT 1

Parameters:

[
  "33e4a4ebdb3db0319da4869c0e7b3be2bdade04abcb142c9265d6b56ab78936a"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.hashed_password AS hashed_password_3,
  t0.display_name AS display_name_4,
  t0.roles AS roles_5,
  t0.avatar_url AS avatar_url_6,
  t0.theme_config AS theme_config_7,
  t0.status AS status_8,
  t0.custom_status_text AS custom_status_text_9,
  t0.last_seen_at AS last_seen_at_10,
  t0.created_at AS created_at_11,
  t0.is_email_verified AS is_email_verified_12,
  t0.email_verification_token AS email_verification_token_13,
  t0.email_verification_token_expires_at AS email_verification_token_expires_at_14,
  t0.account_type AS account_type_15,
  t0.description AS description_16,
  t0.organization_category AS organization_category_17
FROM
  users t0
WHERE
  t0.email_verification_token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.hashed_password AS hashed_password_3, t0.display_name AS display_name_4, t0.roles AS roles_5, t0.avatar_url AS avatar_url_6, t0.theme_config AS theme_config_7, t0.status AS status_8, t0.custom_status_text AS custom_status_text_9, t0.last_seen_at AS last_seen_at_10, t0.created_at AS created_at_11, t0.is_email_verified AS is_email_verified_12, t0.email_verification_token AS email_verification_token_13, t0.email_verification_token_expires_at AS email_verification_token_expires_at_14, t0.account_type AS account_type_15, t0.description AS description_16, t0.organization_category AS organization_category_17 FROM users t0 WHERE t0.email_verification_token = '33e4a4ebdb3db0319da4869c0e7b3be2bdade04abcb142c9265d6b56ab78936a' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	App\Identity\Infrastructure\Persistence\Doctrine\DoctrineUserRepository->findByVerificationToken (line 45)
4	App\Identity\Application\Command\VerifyEmail\VerifyEmailHandler->__invoke (line 24)
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\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 33)
9	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 42)
10	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
11	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
12	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
13	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
14	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
15	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
16	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
17	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
18	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
19	App\SharedKernel\Infrastructure\Bus\MessengerCommandBus->dispatch (line 18)
20	App\UI\Http\Web\VerificationController->verify (line 33)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.62 ms
(6.16%)

"ROLLBACK"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"ROLLBACK"

"ROLLBACK";

#	File/Call
1	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 52)
2	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 42)
3	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
4	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
5	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
6	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
7	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
8	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
9	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
10	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
11	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
12	App\SharedKernel\Infrastructure\Bus\MessengerCommandBus->dispatch (line 18)
13	App\UI\Http\Web\VerificationController->verify (line 33)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 191)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.39 ms
(3.89%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Symfony\Bridge\Doctrine\Messenger\DoctrineTransactionMiddleware->handleForManager (line 29)
2	Symfony\Bridge\Doctrine\Messenger\AbstractDoctrineMiddleware->handle (line 42)
3	Symfony\Component\Messenger\Middleware\DeduplicateMiddleware->handle (line 28)
4	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
5	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
6	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
7	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
8	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
9	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
10	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
11	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
12	App\SharedKernel\Infrastructure\Bus\MessengerCommandBus->dispatch (line 18)
13	App\UI\Http\Web\VerificationController->verify (line 33)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 191)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	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\Identity\Domain\Model\User	No errors.

Symfony Profiler

GET https://tokiwoki.fr/verify-email/c275388031bfe635a3a5e3698d0437ecbdf572d2650559b08f1e81ba747f9809

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping