Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

18.92 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

17.60 ms
(92.99%)

"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 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 71)
5	App\Component\Parsio\ParsioWebhookHandler->consume (line 39)
6	Symfony\Component\RemoteEvent\Messenger\ConsumeRemoteEventHandler->__invoke (line 152)
7	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
9	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
10	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
11	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
12	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
13	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
14	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
15	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
16	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 48)
17	Symfony\Component\Webhook\Controller\WebhookController->handle (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.44 ms
(2.35%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3 FROM parsio_mailbox t0 WHERE t0.id = ?

Parameters:

[
  "66447fa1d8a51c000e7ec7f2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3
FROM
  parsio_mailbox t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3 FROM parsio_mailbox t0 WHERE t0.id = '66447fa1d8a51c000e7ec7f2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 47)
5	App\Component\Parsio\ParsioSyncService->upsertMailbox (line 34)
6	App\Component\Parsio\ParsioSyncService->mailbox (line 67)
7	App\Component\Parsio\ParsioWebhookHandler->consume (line 39)
8	Symfony\Component\RemoteEvent\Messenger\ConsumeRemoteEventHandler->__invoke (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
16	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
17	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
18	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 48)
19	Symfony\Component\Webhook\Controller\WebhookController->handle (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.39 ms
(2.04%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.status AS status_4, t0.timestamp AS timestamp_5, t0.processed AS processed_6, t0.error AS error_7, t0.mailbox_id AS mailbox_id_8 FROM parsio_mailbox_document t0 WHERE t0.id = ?

Parameters:

[
  "677f2f0d2abfd7000ea60c5b"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.status AS status_4,
  t0.timestamp AS timestamp_5,
  t0.processed AS processed_6,
  t0.error AS error_7,
  t0.mailbox_id AS mailbox_id_8
FROM
  parsio_mailbox_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.status AS status_4, t0.timestamp AS timestamp_5, t0.processed AS processed_6, t0.error AS error_7, t0.mailbox_id AS mailbox_id_8 FROM parsio_mailbox_document t0 WHERE t0.id = '677f2f0d2abfd7000ea60c5b';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 57)
5	App\Component\Parsio\ParsioSyncService->upsertDocument (line 42)
6	App\Component\Parsio\ParsioSyncService->document (line 70)
7	App\Component\Parsio\ParsioWebhookHandler->consume (line 39)
8	Symfony\Component\RemoteEvent\Messenger\ConsumeRemoteEventHandler->__invoke (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
16	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
17	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
18	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 48)
19	Symfony\Component\Webhook\Controller\WebhookController->handle (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.31 ms
(1.66%)

INSERT INTO parsio_mailbox_document (id, name, type, status, timestamp, processed, error, mailbox_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "677f2f0d2abfd7000ea60c5b"
  "CODA 't Kwetterhof van 08/01/2025 - BNP PARIBAS FORTIS - BE22001925144347 - EUR"
  "email"
  "parsed"
  "2025-01-09 02:06:08"
  null
  null
  "66447fa1d8a51c000e7ec7f2"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO parsio_mailbox_document (
  id, name, type, status, timestamp, processed,
  error, mailbox_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO parsio_mailbox_document (id, name, type, status, timestamp, processed, error, mailbox_id) VALUES ('677f2f0d2abfd7000ea60c5b', 'CODA \'t Kwetterhof van 08/01/2025 - BNP PARIBAS FORTIS - BE22001925144347 - EUR', 'email', 'parsed', '2025-01-09 02:06:08', NULL, NULL, '66447fa1d8a51c000e7ec7f2');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 71)
7	App\Component\Parsio\ParsioWebhookHandler->consume (line 39)
8	Symfony\Component\RemoteEvent\Messenger\ConsumeRemoteEventHandler->__invoke (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
16	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
17	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
18	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 48)
19	Symfony\Component\Webhook\Controller\WebhookController->handle (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.18 ms
(0.96%)

"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 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 71)
4	App\Component\Parsio\ParsioWebhookHandler->consume (line 39)
5	Symfony\Component\RemoteEvent\Messenger\ConsumeRemoteEventHandler->__invoke (line 152)
6	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 91)
7	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 71)
8	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 34)
9	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 68)
10	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 41)
11	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 35)
12	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 36)
13	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 70)
14	Symfony\Component\Messenger\MessageBus->dispatch (line 38)
15	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 48)
16	Symfony\Component\Webhook\Controller\WebhookController->handle (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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.

Entities Mapping

Class	Mapping errors
App\Entity\Parsio\Mailbox	No errors.
App\Entity\Parsio\Document	No errors.

Symfony Profiler

POST https://pos-io.ddev.torfs.org/webhook/parsio

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping