Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

17.66 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.47 ms
(53.63%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.event_type AS event_type_3, t0.event_at AS event_at_4, t0.channel AS channel_5, t0.log_uuid AS log_uuid_6, t0.recipient AS recipient_7, t0.recipient_uuid AS recipient_uuid_8, t0.optional_data AS optional_data_9, t0.sender AS sender_10, t0.behaviour_data AS behaviour_data_11, t0.raw_payload AS raw_payload_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.processed_at AS processed_at_15, t0.processing_error AS processing_error_16, t0.replayed_at AS replayed_at_17, t0.replayed_by_user_uuid AS replayed_by_user_uuid_18, t0.payload_signature AS payload_signature_19 FROM mx_gateway_webhook t0 WHERE t0.log_uuid = ? AND t0.event_type = ? LIMIT 1

Parameters:

[
  "1f1a2b38-2b27-6b9c-8919-57eb8ef5745d"
  "EventWebhookClick"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.event_type AS event_type_3,
  t0.event_at AS event_at_4,
  t0.channel AS channel_5,
  t0.log_uuid AS log_uuid_6,
  t0.recipient AS recipient_7,
  t0.recipient_uuid AS recipient_uuid_8,
  t0.optional_data AS optional_data_9,
  t0.sender AS sender_10,
  t0.behaviour_data AS behaviour_data_11,
  t0.raw_payload AS raw_payload_12,
  t0.status AS status_13,
  t0.created_at AS created_at_14,
  t0.processed_at AS processed_at_15,
  t0.processing_error AS processing_error_16,
  t0.replayed_at AS replayed_at_17,
  t0.replayed_by_user_uuid AS replayed_by_user_uuid_18,
  t0.payload_signature AS payload_signature_19
FROM
  mx_gateway_webhook t0
WHERE
  t0.log_uuid = ?
  AND t0.event_type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.event_type AS event_type_3, t0.event_at AS event_at_4, t0.channel AS channel_5, t0.log_uuid AS log_uuid_6, t0.recipient AS recipient_7, t0.recipient_uuid AS recipient_uuid_8, t0.optional_data AS optional_data_9, t0.sender AS sender_10, t0.behaviour_data AS behaviour_data_11, t0.raw_payload AS raw_payload_12, t0.status AS status_13, t0.created_at AS created_at_14, t0.processed_at AS processed_at_15, t0.processing_error AS processing_error_16, t0.replayed_at AS replayed_at_17, t0.replayed_by_user_uuid AS replayed_by_user_uuid_18, t0.payload_signature AS payload_signature_19 FROM mx_gateway_webhook t0 WHERE t0.log_uuid = '1f1a2b38-2b27-6b9c-8919-57eb8ef5745d' AND t0.event_type = 'EventWebhookClick' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\MxGatewayWebhookRepository->findOneByLogUuidAndEventType (line 52)
5	App\Controller\App\Api\V1\MxGatewayWebhookController->__invoke (line 80)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

4.01 ms
(22.70%)

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

Parameters:

[
  "{"type":"EventWebhookClick","event_at":"2026-08-28T07:39:14+00:00","channel":"sms","log_uuid":"1f1a2b38-2b27-6b9c-8919-57eb8ef5745d","recipient":"+33649750092","recipient_uuid":"1f1a21c7-cf09-60be-a93f-c527a93df2dc","optional_data":"oo-2-bat","behaviour_data":null,"sender":"Ooklo","campaign_identifier":"oo-2-bat","channel_type":"sms","event_type":"click","contact_uuid":"1f1a21c7-cf09-60be-a93f-c527a93df2dc","force_replay":false}"
  "{"type":"App\\Messages\\Campaigns\\CampaignTrackingEvent"}"
  "tracking"
  "2026-08-28 07:39:15"
  "2026-08-28 07:39:15"
]

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('{\"type\":\"EventWebhookClick\",\"event_at\":\"2026-08-28T07:39:14+00:00\",\"channel\":\"sms\",\"log_uuid\":\"1f1a2b38-2b27-6b9c-8919-57eb8ef5745d\",\"recipient\":\"+33649750092\",\"recipient_uuid\":\"1f1a21c7-cf09-60be-a93f-c527a93df2dc\",\"optional_data\":\"oo-2-bat\",\"behaviour_data\":null,\"sender\":\"Ooklo\",\"campaign_identifier\":\"oo-2-bat\",\"channel_type\":\"sms\",\"event_type\":\"click\",\"contact_uuid\":\"1f1a21c7-cf09-60be-a93f-c527a93df2dc\",\"force_replay\":false}', '{\"type\":\"App\\\\Messages\\\\Campaigns\\\\CampaignTrackingEvent\"}', 'tracking', '2026-08-28 07:39:15', '2026-08-28 07:39:15') RETURNING id;

#	File/Call
1	Doctrine\DBAL\Connection->fetchFirstColumn (line 670)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 446)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 144)
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	App\Messenger\CampaignTransportNamingMiddleware->handle (line 34)
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	App\Service\Campaign\CampaignTrackingWebhookBridge->dispatch (line 53)
17	App\Controller\App\Api\V1\MxGatewayWebhookController->handleWebhook (line 244)
18	App\Controller\App\Api\V1\MxGatewayWebhookController->__invoke (line 87)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

2.30 ms
(13.01%)

"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 467)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 144)
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	App\Messenger\CampaignTransportNamingMiddleware->handle (line 34)
7	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
11	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
15	App\Service\Campaign\CampaignTrackingWebhookBridge->dispatch (line 53)
16	App\Controller\App\Api\V1\MxGatewayWebhookController->handleWebhook (line 244)
17	App\Controller\App\Api\V1\MxGatewayWebhookController->__invoke (line 87)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 191)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.92 ms
(5.22%)

UPDATE mx_gateway_webhook SET processed_at = ? WHERE id = ?

Parameters:

[
  "2026-08-28 07:39:15"
  29
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  mx_gateway_webhook
SET
  processed_at = ?
WHERE
  id = ?

UPDATE mx_gateway_webhook SET processed_at = '2026-08-28 07:39:15' WHERE id = 29;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1141)
4	Doctrine\ORM\UnitOfWork->commit (line 409)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\App\Api\V1\MxGatewayWebhookController->handleWebhook (line 257)
7	App\Controller\App\Api\V1\MxGatewayWebhookController->__invoke (line 87)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.63 ms
(3.56%)

"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 442)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 144)
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	App\Messenger\CampaignTransportNamingMiddleware->handle (line 34)
7	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
11	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
15	App\Service\Campaign\CampaignTrackingWebhookBridge->dispatch (line 53)
16	App\Controller\App\Api\V1\MxGatewayWebhookController->handleWebhook (line 244)
17	App\Controller\App\Api\V1\MxGatewayWebhookController->__invoke (line 87)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 191)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.33 ms
(1.88%)

SELECT pg_notify(?, ?)

Parameters:

[
  "messenger_messages"
  "tracking"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  pg_notify(?, ?)

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

#	File/Call
1	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 450)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 144)
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	App\Messenger\CampaignTransportNamingMiddleware->handle (line 34)
7	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
8	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
9	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
10	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 35)
11	Symfony\Component\Messenger\Middleware\AddDefaultStampsMiddleware->handle (line 33)
12	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 36)
13	Symfony\Component\Messenger\MessageBus->dispatch (line 69)
14	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 42)
15	App\Service\Campaign\CampaignTrackingWebhookBridge->dispatch (line 53)
16	App\Controller\App\Api\V1\MxGatewayWebhookController->handleWebhook (line 244)
17	App\Controller\App\Api\V1\MxGatewayWebhookController->__invoke (line 87)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 191)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	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
App\Entity\MxGatewayWebhook	1

Entities Mapping

Class	Mapping errors
App\Entity\MxGatewayWebhook	No errors.

Symfony Profiler

POST https://api.directeurmonde.com/api/v1/webhook/mx-gateway

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping