Symfony Profiler

Query Metrics

7 Database Queries

4 Different statements

15.52 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.29 ms
(46.97%)

SELECT s0_.email AS email_0 FROM officer o1_ INNER JOIN "security_user" s0_ ON o1_.member_id = s0_.id WHERE o1_.email_recipient = true

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.email AS email_0
FROM
  officer o1_
  INNER JOIN "security_user" s0_ ON o1_.member_id = s0_.id
WHERE
  o1_.email_recipient = true

SELECT s0_.email AS email_0 FROM officer o1_ INNER JOIN "security_user" s0_ ON o1_.member_id = s0_.id WHERE o1_.email_recipient = true;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 713)
6	Doctrine\ORM\AbstractQuery->getSingleColumnResult (line 30)
7	App\Repository\Core\OfficerRepository->findEmailRecipient (line 29)
8	App\Controller\Public\ContactController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

4.99 ms
(32.16%)

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: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:51:\"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\":2:{s:60:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0message\";O:39:\"Symfony\\Bridge\\Twig\\Mime\\TemplatedEmail\":5:{i:0;s:31:\"email/contact/contact.html.twig\";i:1;N;i:2;a:1:{s:4:\"data\";O:18:\"App\\DTO\\ContactDTO\":3:{s:4:\"name\";s:6:\"TedHam\";s:5:\"email\";s:21:\"ocopesuq299@gmail.com\";s:7:\"message\";s:30:\"Hola, volia saber el seu preu.\";}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\"Symfony\\Component\\Mime\\Header\\Headers\":2:{s:46:\"\0Symfony\\Component\\Mime\\Header\\Headers\0headers\";a:2:{s:2:\"to\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:2:\"To\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:0:{}}}s:7:\"subject\";a:1:{i:0;O:48:\"Symfony\\Component\\Mime\\Header\\UnstructuredHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:7:\"Subject\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:55:\"\0Symfony\\Component\\Mime\\Header\\UnstructuredHeader\0value\";s:18:\"Demande de contact\";}}}s:49:\"\0Symfony\\Component\\Mime\\Header\\Headers\0lineLength\";i:76;}i:1;N;}}i:4;N;}s:61:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0envelope\";N;}}"
  "[]"
  "default"
  "2025-03-17 02:35:43"
  "2025-03-17 02:35:43"
]

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: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:51:\\\"Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\\":2:{s:60:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0message\\\";O:39:\\\"Symfony\\\\Bridge\\\\Twig\\\\Mime\\\\TemplatedEmail\\\":5:{i:0;s:31:\\\"email/contact/contact.html.twig\\\";i:1;N;i:2;a:1:{s:4:\\\"data\\\";O:18:\\\"App\\\\DTO\\\\ContactDTO\\\":3:{s:4:\\\"name\\\";s:6:\\\"TedHam\\\";s:5:\\\"email\\\";s:21:\\\"ocopesuq299@gmail.com\\\";s:7:\\\"message\\\";s:30:\\\"Hola, volia saber el seu preu.\\\";}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\\":2:{s:46:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0headers\\\";a:2:{s:2:\\\"to\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:2:\\\"To\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:0:{}}}s:7:\\\"subject\\\";a:1:{i:0;O:48:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:7:\\\"Subject\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:55:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\0value\\\";s:18:\\\"Demande de contact\\\";}}}s:49:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0lineLength\\\";i:76;}i:1;N;}}i:4;N;}s:61:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0envelope\\\";N;}}', '[]', 'default', '2025-03-17 02:35:43', '2025-03-17 02:35:43') RETURNING id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 648)
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 62)
15	Symfony\Component\Mailer\Mailer->send (line 46)
16	App\Controller\Public\ContactController->index (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)

2.30 ms
(14.79%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 477)
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 62)
14	Symfony\Component\Mailer\Mailer->send (line 46)
15	App\Controller\Public\ContactController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.94 ms
(6.07%)

"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 62)
14	Symfony\Component\Mailer\Mailer->send (line 46)
15	App\Controller\Public\ContactController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	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\Core\Officer	No errors.
App\Entity\Security\User	No errors.

Symfony Profiler

POST https://accord-parfait.ovh/contact

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping