Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.created_at AS created_at_3,
  t0.last_used_at AS last_used_at_4,
  t0.tenant_user_id AS tenant_user_id_5,
  t0.tenant_db_config_id AS tenant_db_config_id_6
FROM
  tenant_api_key t0
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = '7698a68238a20b789118ec4251d5a3b0' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  tenant_api_key
SET
  last_used_at = ?
WHERE
  id = ?

UPDATE tenant_api_key SET last_used_at = '2026-11-12 10:12:53' WHERE id = 6;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.driver_type AS driver_type_2,
  t0.db_name AS db_name_3,
  t0.db_user_name AS db_user_name_4,
  t0.db_password AS db_password_5,
  t0.db_host AS db_host_6,
  t0.db_port AS db_port_7,
  t0.database_status AS database_status_8
FROM
  tenant_db_config t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.driver_type AS driver_type_2, t0.db_name AS db_name_3, t0.db_user_name AS db_user_name_4, t0.db_password AS db_password_5, t0.db_host AS db_host_6, t0.db_port AS db_port_7, t0.database_status AS database_status_8 FROM tenant_db_config t0 WHERE t0.id = 4;

SELECT
  t0_.id AS id_0,
  t0_.driver_type AS driver_type_1,
  t0_.db_name AS db_name_2,
  t0_.db_user_name AS db_user_name_3,
  t0_.db_password AS db_password_4,
  t0_.db_host AS db_host_5,
  t0_.db_port AS db_port_6,
  t0_.database_status AS database_status_7
FROM
  tenant_db_config t0_
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.driver_type AS driver_type_1, t0_.db_name AS db_name_2, t0_.db_user_name AS db_user_name_3, t0_.db_password AS db_password_4, t0_.db_host AS db_host_5, t0_.db_port AS db_port_6, t0_.database_status AS database_status_7 FROM tenant_db_config t0_ WHERE t0_.id = 4;

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.created_at AS created_at_3,
  t0.last_used_at AS last_used_at_4,
  t0.tenant_user_id AS tenant_user_id_5,
  t0.tenant_db_config_id AS tenant_db_config_id_6
FROM
  tenant_api_key t0
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = '7698a68238a20b789118ec4251d5a3b0' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.created_at AS created_at_3,
  t0.last_used_at AS last_used_at_4,
  t0.tenant_user_id AS tenant_user_id_5,
  t0.tenant_db_config_id AS tenant_db_config_id_6
FROM
  tenant_api_key t0
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = '7698a68238a20b789118ec4251d5a3b0' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.invite_token AS invite_token_5,
  t0.invite_expires_at AS invite_expires_at_6,
  t7.id AS id_8,
  t7.secret AS secret_9,
  t7.backup_codes AS backup_codes_10,
  t7.enabled AS enabled_11,
  t7.created_at AS created_at_12,
  t7.enabled_at AS enabled_at_13,
  t7.last_used_at AS last_used_at_14,
  t7.tenant_user_id AS tenant_user_id_15
FROM
  tenant_user t0
  LEFT JOIN tenant_user_authenticator t7 ON t7.tenant_user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.invite_token AS invite_token_5, t0.invite_expires_at AS invite_expires_at_6, t7.id AS id_8, t7.secret AS secret_9, t7.backup_codes AS backup_codes_10, t7.enabled AS enabled_11, t7.created_at AS created_at_12, t7.enabled_at AS enabled_at_13, t7.last_used_at AS last_used_at_14, t7.tenant_user_id AS tenant_user_id_15 FROM tenant_user t0 LEFT JOIN tenant_user_authenticator t7 ON t7.tenant_user_id = t0.id WHERE t0.id = 1;

SELECT
  NEXTVAL('api_logs_id_seq')

SELECT NEXTVAL('api_logs_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO api_logs (
  id, timestamp, username, action, details,
  request_data, document_uuid, response_data,
  ip_address, user_agent, tenant_db_config_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO api_logs (id, timestamp, username, action, details, request_data, document_uuid, response_data, ip_address, user_agent, tenant_db_config_id) VALUES (341180, '2026-11-12 10:12:53', '[email protected]', 'POST /api/bulk-recipients (201)', 'API call completed in 34.46ms with status 201', '{\"body\":[{\"recip name\":\"MISS JOANNE XDNMQQBDQB\",\"address1\":\"1 SHARED ROAD\",\"address2\":\"LEEDS\",\"address3\":\"\",\"address4\":\"\",\"address5\":\"\",\"address6\":\"\",\"address7\":\"LS1 1AA\",\"email\":\"[email protected]\",\"telephone\":\"\",\"reference\":\"XD-NM-A-05BD4B\",\"department\":\"Cross Dept Individual\",\"enrol_type\":\"1\",\"enrol_custom_data\":\"\",\"enrol_custom_data_label\":\"\",\"enrol_confirm_field\":\"\",\"delete_ref\":0,\"_line_number\":2,\"recipient_id\":800180184}]}', NULL, '{\"success\":\"Recipients bulk add queued successfully\"}', '162.158.216.186', 'Symfony HttpClient/Curl', 4);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.key AS key_2,
  t0.value AS value_3
FROM
  config t0
WHERE
  t0.key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3 FROM config t0 WHERE t0.key = 'duplicate_email_enabled' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.meta AS meta_6,
  t0.enable AS enable_7,
  t0.telephone AS telephone_8,
  t0.preferred_channel AS preferred_channel_9,
  t0.enrollment_token AS enrollment_token_10,
  t0.unsubscribe_token AS unsubscribe_token_11,
  t0.totp_secret AS totp_secret_12,
  t0.confirmation_postcode AS confirmation_postcode_13,
  t0.confirmation_type AS confirmation_type_14,
  t0.one_time_code AS one_time_code_15,
  t0.deleted_at AS deleted_at_16,
  t0.address AS address_17,
  t0.version AS version_18,
  t0.source AS source_19,
  t0.last_synced_at AS last_synced_at_20,
  t0.updated_at AS updated_at_21,
  t0.source_id AS source_id_22,
  t0.subscriber AS subscriber_23
FROM
  recipient t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.email AS email_4, t0.password AS password_5, t0.meta AS meta_6, t0.enable AS enable_7, t0.telephone AS telephone_8, t0.preferred_channel AS preferred_channel_9, t0.enrollment_token AS enrollment_token_10, t0.unsubscribe_token AS unsubscribe_token_11, t0.totp_secret AS totp_secret_12, t0.confirmation_postcode AS confirmation_postcode_13, t0.confirmation_type AS confirmation_type_14, t0.one_time_code AS one_time_code_15, t0.deleted_at AS deleted_at_16, t0.address AS address_17, t0.version AS version_18, t0.source AS source_19, t0.last_synced_at AS last_synced_at_20, t0.updated_at AS updated_at_21, t0.source_id AS source_id_22, t0.subscriber AS subscriber_23 FROM recipient t0 WHERE t0.email = '[email protected]' LIMIT 1;

SELECT
  NEXTVAL('recipient_id_seq')

SELECT NEXTVAL('recipient_id_seq');

SELECT
  NEXTVAL('recipient_reference_id_seq')

SELECT NEXTVAL('recipient_reference_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO recipient (
  id, uuid, name, email, password, meta,
  enable, telephone, preferred_channel,
  enrollment_token, unsubscribe_token,
  totp_secret, confirmation_postcode,
  confirmation_type, one_time_code,
  deleted_at, address, version, source,
  last_synced_at, updated_at, source_id,
  subscriber
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO recipient (id, uuid, name, email, password, meta, enable, telephone, preferred_channel, enrollment_token, unsubscribe_token, totp_secret, confirmation_postcode, confirmation_type, one_time_code, deleted_at, address, version, source, last_synced_at, updated_at, source_id, subscriber) VALUES (962808, 'e74cae97-6487-44e2-bf39-6dec1063f204', 'MISS JOANNE XDNMQQBDQB', '[email protected]', NULL, NULL, 0, '', NULL, NULL, NULL, NULL, NULL, 'no_confirmation', NULL, NULL, '1 SHARED ROAD|LEEDS|LS1 1AA', 1, 'cloud', NULL, '2026-11-12 10:12:53', NULL, 0);

INSERT INTO recipient_reference (
  id, key, value, unsubscribed_at, recipient_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO recipient_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (705187, 'Cross Dept Individual', 'XD-NM-A-05BD4B', NULL, 962808);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO domain_event (
  id, type, subject_type, subject_id,
  actor, payload, correlation_id, changed_fields,
  occurred_at, status, dispatched_at,
  processed_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO domain_event (id, type, subject_type, subject_id, actor, payload, correlation_id, changed_fields, occurred_at, status, dispatched_at, processed_at) VALUES ('a5589f60-6678-4410-b42e-1ff6bad69a6d', 'recipient.created', 'recipient', '962808', 'admin', '{\"fields\":[\"id\",\"uuid\",\"name\",\"email\",\"password\",\"meta\",\"enable\",\"telephone\",\"preferredChannel\",\"enrollmentToken\",\"unsubscribeToken\",\"totpSecret\",\"confirmationPostcode\",\"confirmationType\",\"oneTimeCode\",\"deletedAt\",\"address\",\"version\",\"source\",\"lastSyncedAt\",\"updatedAt\",\"sourceId\",\"subscriber\"],\"changes\":{\"id\":{\"from\":null,\"to\":962808},\"uuid\":{\"from\":null,\"to\":\"e74cae97-6487-44e2-bf39-6dec1063f204\"},\"name\":{\"from\":null,\"to\":\"MISS JOANNE XDNMQQBDQB\"},\"email\":{\"from\":null,\"to\":\"[email protected]\"},\"password\":{\"from\":\"(hidden)\",\"to\":\"(hidden)\"},\"meta\":{\"from\":null,\"to\":null},\"enable\":{\"from\":null,\"to\":0},\"telephone\":{\"from\":null,\"to\":\"\"},\"preferredChannel\":{\"from\":null,\"to\":null},\"enrollmentToken\":{\"from\":\"(hidden)\",\"to\":\"(hidden)\"},\"unsubscribeToken\":{\"from\":\"(hidden)\",\"to\":\"(hidden)\"},\"totpSecret\":{\"from\":\"(hidden)\",\"to\":\"(hidden)\"},\"confirmationPostcode\":{\"from\":\"(hidden)\",\"to\":\"(hidden)\"},\"confirmationType\":{\"from\":null,\"to\":\"no_confirmation\"},\"oneTimeCode\":{\"from\":\"(hidden)\",\"to\":\"(hidden)\"},\"deletedAt\":{\"from\":null,\"to\":null},\"address\":{\"from\":null,\"to\":\"1 SHARED ROAD|LEEDS|LS1 1AA\"},\"version\":{\"from\":null,\"to\":1},\"source\":{\"from\":null,\"to\":\"cloud\"},\"lastSyncedAt\":{\"from\":null,\"to\":null},\"updatedAt\":{\"from\":null,\"to\":\"2026-11-12T10:12:53+00:00\"},\"sourceId\":{\"from\":null,\"to\":null},\"subscriber\":{\"from\":null,\"to\":false}},\"by\":\"[email protected]\"}', '553f0ca6abc4175bafb5565f206b828b', ',id,uuid,name,email,password,meta,enable,telephone,preferredChannel,enrollmentToken,unsubscribeToken,totpSecret,confirmationPostcode,confirmationType,oneTimeCode,deletedAt,address,version,source,lastSyncedAt,updatedAt,sourceId,subscriber,', '2026-11-12 10:12:53', 'pending', NULL, NULL);

INSERT INTO domain_event (
  id, type, subject_type, subject_id,
  actor, payload, correlation_id, changed_fields,
  occurred_at, status, dispatched_at,
  processed_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO domain_event (id, type, subject_type, subject_id, actor, payload, correlation_id, changed_fields, occurred_at, status, dispatched_at, processed_at) VALUES ('4cf1bc84-cb44-4ce8-badb-f5d3796072b1', 'recipient.reference_added', 'recipient', '962808', 'admin', '{\"fields\":[\"reference\"],\"key\":\"Cross Dept Individual\",\"value\":\"XD-NM-A-05BD4B\",\"by\":\"[email protected]\"}', '553f0ca6abc4175bafb5565f206b828b', ',reference,', '2026-11-12 10:12:53', 'pending', NULL, NULL);

"COMMIT"

"COMMIT";