Symfony Profiler

Query Metrics

11 Database Queries

7 Different statements

22.31 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.58 ms
(42.95%)

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)

3.88 ms
(17.40%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 434)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\App\Api\V1\MxGatewayWebhookController->createWebhookEntity (line 227)
4	App\Controller\App\Api\V1\MxGatewayWebhookController->__invoke (line 93)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

3.80 ms
(17.05%)

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

Parameters:

[
  "{"type":"EventWebhookClick","event_at":"2026-08-28T07:38:55+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:38:57"
  "2026-08-28 07:38:57"
]

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:38:55+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:38:57', '2026-08-28 07:38:57') 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 96)
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)

1.57 ms
(7.02%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 383)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\App\Api\V1\MxGatewayWebhookController->createWebhookEntity (line 227)
4	App\Controller\App\Api\V1\MxGatewayWebhookController->__invoke (line 93)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

1.55 ms
(6.95%)

INSERT INTO mx_gateway_webhook (uuid, event_type, event_at, channel, log_uuid, recipient, recipient_uuid, optional_data, sender, behaviour_data, raw_payload, status, created_at, processed_at, processing_error, replayed_at, replayed_by_user_uuid, payload_signature) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "1f1a2b38-6d14-685c-8601-61de206b2c2b"
  "EventWebhookClick"
  "2026-08-28 07:38:55"
  "sms"
  "1f1a2b38-2b27-6b9c-8919-57eb8ef5745d"
  "+33649750092"
  "1f1a21c7-cf09-60be-a93f-c527a93df2dc"
  "oo-2-bat"
  "Ooklo"
  null
  "{"type":"EventWebhookClick","event_at":"2026-08-28 07:38:55","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"}"
  "pending"
  "2026-08-28 07:38:56"
  null
  null
  null
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO mx_gateway_webhook (
  uuid, event_type, event_at, channel,
  log_uuid, recipient, recipient_uuid,
  optional_data, sender, behaviour_data,
  raw_payload, status, created_at,
  processed_at, processing_error,
  replayed_at, replayed_by_user_uuid,
  payload_signature
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO mx_gateway_webhook (uuid, event_type, event_at, channel, log_uuid, recipient, recipient_uuid, optional_data, sender, behaviour_data, raw_payload, status, created_at, processed_at, processing_error, replayed_at, replayed_by_user_uuid, payload_signature) VALUES ('1f1a2b38-6d14-685c-8601-61de206b2c2b', 'EventWebhookClick', '2026-08-28 07:38:55', 'sms', '1f1a2b38-2b27-6b9c-8919-57eb8ef5745d', '+33649750092', '1f1a21c7-cf09-60be-a93f-c527a93df2dc', 'oo-2-bat', 'Ooklo', NULL, '{\"type\":\"EventWebhookClick\",\"event_at\":\"2026-08-28 07:38:55\",\"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\"}', 'pending', '2026-08-28 07:38:56', NULL, NULL, NULL, NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1061)
4	Doctrine\ORM\UnitOfWork->commit (line 404)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\App\Api\V1\MxGatewayWebhookController->createWebhookEntity (line 227)
7	App\Controller\App\Api\V1\MxGatewayWebhookController->__invoke (line 93)
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)

1.28 ms
(5.75%)

UPDATE mx_gateway_webhook SET status = ?, processed_at = ? WHERE id = ?

Parameters:

[
  "processed"
  "2026-08-28 07:38:57"
  29
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  mx_gateway_webhook
SET
  status = ?,
  processed_at = ?
WHERE
  id = ?

UPDATE mx_gateway_webhook SET status = 'processed', processed_at = '2026-08-28 07:38:57' 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 96)
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.64 ms
(2.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 96)
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