| 1 |
9.58 ms |
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"
]
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;
|
| 3 |
1.55 ms |
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
]
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);
|
| 6 |
3.80 ms |
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"
]
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;
|