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 = '042653b78b2283743b494ee24ec49e7b' LIMIT 1;

"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 = ?
LIMIT
  1

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 = '1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t5.id AS id_6,
  t5.secret AS secret_7,
  t5.backup_codes AS backup_codes_8,
  t5.enabled AS enabled_9,
  t5.created_at AS created_at_10,
  t5.enabled_at AS enabled_at_11,
  t5.last_used_at AS last_used_at_12,
  t5.tenant_user_id AS tenant_user_id_13
FROM
  tenant_user t0
  LEFT JOIN tenant_user_authenticator t5 ON t5.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, t5.id AS id_6, t5.secret AS secret_7, t5.backup_codes AS backup_codes_8, t5.enabled AS enabled_9, t5.created_at AS created_at_10, t5.enabled_at AS enabled_at_11, t5.last_used_at AS last_used_at_12, t5.tenant_user_id AS tenant_user_id_13 FROM tenant_user t0 LEFT JOIN tenant_user_authenticator t5 ON t5.tenant_user_id = t0.id WHERE t0.id = 1;

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

INSERT INTO api_logs (id, timestamp, username, action, details, request_data, response_data, ip_address, user_agent, tenant_db_config_id) VALUES (3944, '2026-03-16 16:19:58', '[email protected]', 'POST /api/recipients/sync/batch (200)', 'API call completed in 46.71ms with status 200', '{\"body\":{\"changes\":[{\"operation\":\"delete\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"JOEL KALETE 44110a\",\"references\":[],\"source_id\":\"623\"},\"_queue_id\":2672},{\"operation\":\"delete\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"JANE DOE 44110a\",\"references\":[],\"source_id\":\"624\"},\"_queue_id\":2673},{\"operation\":\"delete\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"PROD ACTIVE TRIGGER 44110a\",\"references\":[],\"source_id\":\"625\"},\"_queue_id\":2674},{\"operation\":\"delete\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"PROD TRIGGER TEST 44110a\",\"references\":[],\"source_id\":\"626\"},\"_queue_id\":2675},{\"operation\":\"create\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"ALICE PASSIVE d95017\",\"postcode\":\"M2 3PQ\",\"references\":[{\"reference\":\"PASV1_d95017\",\"department\":\"Benefits\",\"enrol_type\":\"1\",\"enrol_custom_data\":\"\",\"enrol_confirm_field\":\"\",\"enrol_custom_data_label\":\"\"}],\"address1\":\"10 TEST LANE\",\"address2\":\"MANCHESTER\",\"address5\":\"M2 3PQ\",\"source_id\":\"627\"},\"_queue_id\":2676}]}}', '{\"success\":true}', '172.68.229.10', 'Symfony HttpClient/Curl', 1);

SELECT
  NEXTVAL('api_logs_id_seq')

SELECT NEXTVAL('api_logs_id_seq');

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 = 1;

UPDATE
  tenant_api_key
SET
  last_used_at = ?
WHERE
  id = ?

UPDATE tenant_api_key SET last_used_at = '2026-03-16 16:19:58' WHERE id = 1;

"START TRANSACTION"

"START TRANSACTION";

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.enrollment_token AS enrollment_token_9,
  t0.unsubscribe_token AS unsubscribe_token_10,
  t0.confirmation_postcode AS confirmation_postcode_11,
  t0.confirmation_type AS confirmation_type_12,
  t0.one_time_code AS one_time_code_13,
  t0.deleted_at AS deleted_at_14,
  t0.address AS address_15,
  t0.version AS version_16,
  t0.source AS source_17,
  t0.last_synced_at AS last_synced_at_18,
  t0.updated_at AS updated_at_19,
  t0.source_id AS source_id_20
FROM
  recipient t0
WHERE
  t0.source_id = ?
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.enrollment_token AS enrollment_token_9, t0.unsubscribe_token AS unsubscribe_token_10, t0.confirmation_postcode AS confirmation_postcode_11, t0.confirmation_type AS confirmation_type_12, t0.one_time_code AS one_time_code_13, t0.deleted_at AS deleted_at_14, t0.address AS address_15, t0.version AS version_16, t0.source AS source_17, t0.last_synced_at AS last_synced_at_18, t0.updated_at AS updated_at_19, t0.source_id AS source_id_20 FROM recipient t0 WHERE t0.source_id = '623' 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.enrollment_token AS enrollment_token_9,
  t0.unsubscribe_token AS unsubscribe_token_10,
  t0.confirmation_postcode AS confirmation_postcode_11,
  t0.confirmation_type AS confirmation_type_12,
  t0.one_time_code AS one_time_code_13,
  t0.deleted_at AS deleted_at_14,
  t0.address AS address_15,
  t0.version AS version_16,
  t0.source AS source_17,
  t0.last_synced_at AS last_synced_at_18,
  t0.updated_at AS updated_at_19,
  t0.source_id AS source_id_20
FROM
  recipient t0
WHERE
  t0.id = ?

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.enrollment_token AS enrollment_token_9, t0.unsubscribe_token AS unsubscribe_token_10, t0.confirmation_postcode AS confirmation_postcode_11, t0.confirmation_type AS confirmation_type_12, t0.one_time_code AS one_time_code_13, t0.deleted_at AS deleted_at_14, t0.address AS address_15, t0.version AS version_16, t0.source AS source_17, t0.last_synced_at AS last_synced_at_18, t0.updated_at AS updated_at_19, t0.source_id AS source_id_20 FROM recipient t0 WHERE t0.id = '623';

"COMMIT"

"COMMIT";

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

INSERT INTO recipient_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (3467, 'Benefits', 'PASV1_d95017', NULL, 2614);

SELECT
  t0.id AS id_1,
  t0.last_sync_at AS last_sync_at_2,
  t0.last_poll_at AS last_poll_at_3,
  t0.pending_changes AS pending_changes_4,
  t0.sync_lag_seconds AS sync_lag_seconds_5,
  t0.health_status AS health_status_6,
  t0.total_recipients AS total_recipients_7,
  t0.synced_today AS synced_today_8,
  t0.conflicts_today AS conflicts_today_9,
  t0.last_error AS last_error_10,
  t0.updated_at AS updated_at_11
FROM
  customer_sync_status t0
LIMIT
  1

SELECT t0.id AS id_1, t0.last_sync_at AS last_sync_at_2, t0.last_poll_at AS last_poll_at_3, t0.pending_changes AS pending_changes_4, t0.sync_lag_seconds AS sync_lag_seconds_5, t0.health_status AS health_status_6, t0.total_recipients AS total_recipients_7, t0.synced_today AS synced_today_8, t0.conflicts_today AS conflicts_today_9, t0.last_error AS last_error_10, t0.updated_at AS updated_at_11 FROM customer_sync_status t0 LIMIT 1;

SELECT
  NEXTVAL('recipient_id_seq')

SELECT NEXTVAL('recipient_id_seq');

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

INSERT INTO recipient (id, uuid, name, email, password, meta, enable, telephone, enrollment_token, unsubscribe_token, confirmation_postcode, confirmation_type, one_time_code, deleted_at, address, version, source, last_synced_at, updated_at, source_id) VALUES (2614, 'cc4f02e9-e0ae-4b6d-b9e9-2fed83a25050', 'ALICE PASSIVE d95017', '[email protected]', NULL, NULL, 1, NULL, NULL, NULL, 'M2 3PQ', NULL, NULL, NULL, '10 TEST LANE|MANCHESTER|M2 3PQ', 1, 'customer', '2026-03-16 16:19:58', '2026-03-16 16:19:58', '627');

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

UPDATE
  customer_sync_status
SET
  last_sync_at = ?,
  synced_today = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE customer_sync_status SET last_sync_at = '2026-03-16 16:19:58', synced_today = 5, updated_at = '2026-03-16 16:19:58' WHERE id = 1;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

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.enrollment_token AS enrollment_token_9,
  t0.unsubscribe_token AS unsubscribe_token_10,
  t0.confirmation_postcode AS confirmation_postcode_11,
  t0.confirmation_type AS confirmation_type_12,
  t0.one_time_code AS one_time_code_13,
  t0.deleted_at AS deleted_at_14,
  t0.address AS address_15,
  t0.version AS version_16,
  t0.source AS source_17,
  t0.last_synced_at AS last_synced_at_18,
  t0.updated_at AS updated_at_19,
  t0.source_id AS source_id_20
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.enrollment_token AS enrollment_token_9, t0.unsubscribe_token AS unsubscribe_token_10, t0.confirmation_postcode AS confirmation_postcode_11, t0.confirmation_type AS confirmation_type_12, t0.one_time_code AS one_time_code_13, t0.deleted_at AS deleted_at_14, t0.address AS address_15, t0.version AS version_16, t0.source AS source_17, t0.last_synced_at AS last_synced_at_18, t0.updated_at AS updated_at_19, t0.source_id AS source_id_20 FROM recipient t0 WHERE t0.email = '[email protected]' LIMIT 1;

SELECT
  NEXTVAL('recipient_reference_id_seq')

SELECT NEXTVAL('recipient_reference_id_seq');

"START TRANSACTION"

"START TRANSACTION";