Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 10
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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

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

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;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

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

[
  "{"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"
]

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;

SELECT pg_notify(?, ?)

[
  "messenger_messages"
  "tracking"
]

SELECT
  pg_notify(?, ?)

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

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE mx_gateway_webhook SET processed_at = ? WHERE id = ?

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

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;

"COMMIT"

[]

"COMMIT"

"COMMIT";