Symfony Profiler

Query Metrics

68 Database Queries

26 Different statements

50.64 ms Query time

0 Invalid entities

18 Managed entities

Queries

Group similar statements

default connection


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
"START TRANSACTION"
UPDATE tenant_api_key SET last_used_at = ? WHERE id = ?
"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 = ?
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 = ? 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 NEXTVAL('api_logs_id_seq')
"START TRANSACTION"
INSERT INTO api_logs (id, timestamp, username, action, details, request_data, response_data, ip_address, user_agent, tenant_db_config_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"

#▲	Time	Info
1	5.09 ms	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 Parameters: [`"042653b78b2283743b494ee24ec49e7b"`] View formatted query View runnable query Explain query 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;
2	0.28 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
3	0.90 ms	UPDATE tenant_api_key SET last_used_at = ? WHERE id = ? Parameters: [`"2026-03-16 16:16:49" 1`] View formatted query View runnable query Explain query UPDATE tenant_api_key SET last_used_at = ? WHERE id = ? UPDATE tenant_api_key SET last_used_at = '2026-03-16 16:16:49' WHERE id = 1;
4	1.74 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
5	3.05 ms	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 Parameters: [`"1"`] View formatted query View runnable query Explain query 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;
6	1.09 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
7	0.47 ms	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 Parameters: [`"042653b78b2283743b494ee24ec49e7b"`] View formatted query View runnable query Explain query 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;
8	0.48 ms	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 Parameters: [`"042653b78b2283743b494ee24ec49e7b"`] View formatted query View runnable query Explain query 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;
9	2.66 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
10	0.74 ms	SELECT NEXTVAL('api_logs_id_seq') Parameters: [] View formatted query View runnable query Explain query SELECT NEXTVAL('api_logs_id_seq') SELECT NEXTVAL('api_logs_id_seq');
11	0.26 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
12	1.59 ms	INSERT INTO api_logs (id, timestamp, username, action, details, request_data, response_data, ip_address, user_agent, tenant_db_config_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [3937 "2026-03-16 16:16:49" "[email protected]" "POST /api/recipients/sync/batch (200)" "API call completed in 75.38ms with status 200" "{"body":{"changes":[{"operation":"update","data":{"email":"[email protected]","recip name":"SARAH JONES 659299","telephone":"01234567891","postcode":"M5 4XY","references":[{"reference":"BENS301_659299","department":"Benefits"},{"reference":"BENS300_659299","department":"Benefits","enrol_type":"1"},{"reference":"HOUS1_659299","department":"Housing","enrol_type":"1","enrol_custom_data":"","enrol_confirm_field":"","enrol_custom_data_label":""}],"address1":"456 OAK AVENUE","address2":"SALFORD","address5":"M5 4XY","source_id":"607"},"_queue_id":2551},{"operation":"update","data":{"email":"[email protected]","recip name":"JOHN SMITH 659299","telephone":"01234567895","postcode":"SW1 1AA","references":[{"reference":"HOUS100_659299","department":"Housing"}],"address1":"456 OAK AVENUE","address2":"LONDON","address3":"SW1 1AA","source_id":"606"},"_queue_id":2549},{"operation":"create","data":{"email":"[email protected]","recip name":"ARTEMIS KALETE 659299","telephone":"01234567892","postcode":"BL1 2AB","references":[{"reference":"CTAX2_659299","department":"Council Tax","enrol_type":"1","enrol_custom_data":"","enrol_confirm_field":"","enrol_custom_data_label":""}],"address1":"789 ELM STREET","address2":"BOLTON","address5":"BL1 2AB","source_id":"608"},"_queue_id":2553},{"operation":"delete","data":{"email":"[email protected]","recip name":"SARAH JONES 659299","source_id":"607"},"_queue_id":2547},{"operation":"update","data":{"email":"[email protected]","recip name":"JANE DOE 659299","telephone":"01234567893","postcode":"M1 1AA","references":[{"reference":"BENS200_659299","department":"Benefits","enrol_type":"1","enrol_custom_data":"","enrol_confirm_field":"","enrol_custom_data_label":""}],"address1":"123 HIGH STREET","address2":"MANCHESTER","address5":"M1 1AA","source_id":"605"},"_queue_id":2546},{"operation":"delete","data":{"email":"[email protected]","recip name":"JOHN SMITH 659299","source_id":"606"},"_queue_id":2552},{"operation":"update","data":{"email":"[email protected]","recip name":"JOEL KALETE 659299","telephone":"01234567890","postcode":"M1 1AA","references":[{"reference":"BENS1_659299","department":"Benefits","enrol_type":"1","enrol_custom_data":"","enrol_confirm_field":"","enrol_custom_data_label":""},{"reference":"CTAX1_659299","department":"Council Tax","enrol_type":"1"}],"address1":"123 MAIN ST","address2":"MANCHESTER","address5":"M1 1AA","source_id":"604"},"_queue_id":2550}]}}" "{"success":true}" "172.69.194.40" "Symfony HttpClient/Curl" 1] View formatted query View runnable query Explain query 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 (3937, '2026-03-16 16:16:49', '[email protected]', 'POST /api/recipients/sync/batch (200)', 'API call completed in 75.38ms with status 200', '{\"body\":{\"changes\":[{\"operation\":\"update\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"SARAH JONES 659299\",\"telephone\":\"01234567891\",\"postcode\":\"M5 4XY\",\"references\":[{\"reference\":\"BENS301_659299\",\"department\":\"Benefits\"},{\"reference\":\"BENS300_659299\",\"department\":\"Benefits\",\"enrol_type\":\"1\"},{\"reference\":\"HOUS1_659299\",\"department\":\"Housing\",\"enrol_type\":\"1\",\"enrol_custom_data\":\"\",\"enrol_confirm_field\":\"\",\"enrol_custom_data_label\":\"\"}],\"address1\":\"456 OAK AVENUE\",\"address2\":\"SALFORD\",\"address5\":\"M5 4XY\",\"source_id\":\"607\"},\"_queue_id\":2551},{\"operation\":\"update\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"JOHN SMITH 659299\",\"telephone\":\"01234567895\",\"postcode\":\"SW1 1AA\",\"references\":[{\"reference\":\"HOUS100_659299\",\"department\":\"Housing\"}],\"address1\":\"456 OAK AVENUE\",\"address2\":\"LONDON\",\"address3\":\"SW1 1AA\",\"source_id\":\"606\"},\"_queue_id\":2549},{\"operation\":\"create\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"ARTEMIS KALETE 659299\",\"telephone\":\"01234567892\",\"postcode\":\"BL1 2AB\",\"references\":[{\"reference\":\"CTAX2_659299\",\"department\":\"Council Tax\",\"enrol_type\":\"1\",\"enrol_custom_data\":\"\",\"enrol_confirm_field\":\"\",\"enrol_custom_data_label\":\"\"}],\"address1\":\"789 ELM STREET\",\"address2\":\"BOLTON\",\"address5\":\"BL1 2AB\",\"source_id\":\"608\"},\"_queue_id\":2553},{\"operation\":\"delete\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"SARAH JONES 659299\",\"source_id\":\"607\"},\"_queue_id\":2547},{\"operation\":\"update\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"JANE DOE 659299\",\"telephone\":\"01234567893\",\"postcode\":\"M1 1AA\",\"references\":[{\"reference\":\"BENS200_659299\",\"department\":\"Benefits\",\"enrol_type\":\"1\",\"enrol_custom_data\":\"\",\"enrol_confirm_field\":\"\",\"enrol_custom_data_label\":\"\"}],\"address1\":\"123 HIGH STREET\",\"address2\":\"MANCHESTER\",\"address5\":\"M1 1AA\",\"source_id\":\"605\"},\"_queue_id\":2546},{\"operation\":\"delete\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"JOHN SMITH 659299\",\"source_id\":\"606\"},\"_queue_id\":2552},{\"operation\":\"update\",\"data\":{\"email\":\"[email protected]\",\"recip name\":\"JOEL KALETE 659299\",\"telephone\":\"01234567890\",\"postcode\":\"M1 1AA\",\"references\":[{\"reference\":\"BENS1_659299\",\"department\":\"Benefits\",\"enrol_type\":\"1\",\"enrol_custom_data\":\"\",\"enrol_confirm_field\":\"\",\"enrol_custom_data_label\":\"\"},{\"reference\":\"CTAX1_659299\",\"department\":\"Council Tax\",\"enrol_type\":\"1\"}],\"address1\":\"123 MAIN ST\",\"address2\":\"MANCHESTER\",\"address5\":\"M1 1AA\",\"source_id\":\"604\"},\"_queue_id\":2550}]}}', '{\"success\":true}', '172.69.194.40', 'Symfony HttpClient/Curl', 1);
13	1.65 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

tenant connection


"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.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ?
SELECT NEXTVAL('recipient_reference_id_seq')
SELECT NEXTVAL('recipient_reference_id_seq')
SAVEPOINT DOCTRINE_2
INSERT INTO recipient_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (?, ?, ?, ?, ?)
INSERT INTO recipient_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (?, ?, ?, ?, ?)
UPDATE recipient SET version = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
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.source_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ?
SAVEPOINT DOCTRINE_2
UPDATE recipient SET version = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
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.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.email = ? LIMIT 1
SELECT NEXTVAL('recipient_id_seq')
SELECT NEXTVAL('recipient_reference_id_seq')
SAVEPOINT DOCTRINE_2
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_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (?, ?, ?, ?, ?)
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.source_id = ? LIMIT 1
SAVEPOINT DOCTRINE_2
UPDATE recipient SET deleted_at = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
RELEASE SAVEPOINT DOCTRINE_2
SAVEPOINT DOCTRINE_2
UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ?
UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ?
UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ?
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.source_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ?
SAVEPOINT DOCTRINE_2
UPDATE recipient SET deleted_at = ?, version = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ?
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.source_id = ? LIMIT 1
SAVEPOINT DOCTRINE_2
UPDATE recipient SET deleted_at = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
RELEASE SAVEPOINT DOCTRINE_2
SAVEPOINT DOCTRINE_2
UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ?
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.source_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ?
SAVEPOINT DOCTRINE_2
UPDATE recipient SET version = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
RELEASE SAVEPOINT DOCTRINE_2
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
SAVEPOINT DOCTRINE_2
UPDATE customer_sync_status SET last_sync_at = ?, synced_today = ?, updated_at = ? WHERE id = ?
RELEASE SAVEPOINT DOCTRINE_2
"COMMIT"

#▲	Time	Info
1	0.32 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
2	5.11 ms	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 Parameters: [`"607"`] View formatted query View runnable query Explain query 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 = '607' LIMIT 1;
3	1.71 ms	SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ? Parameters: [`2609`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ? SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = 2609;
4	0.68 ms	SELECT NEXTVAL('recipient_reference_id_seq') Parameters: [] View formatted query View runnable query Explain query SELECT NEXTVAL('recipient_reference_id_seq') SELECT NEXTVAL('recipient_reference_id_seq');
5	0.32 ms	SELECT NEXTVAL('recipient_reference_id_seq') Parameters: [] View formatted query View runnable query Explain query SELECT NEXTVAL('recipient_reference_id_seq') SELECT NEXTVAL('recipient_reference_id_seq');
6	0.28 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
7	0.95 ms	INSERT INTO recipient_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (?, ?, ?, ?, ?) Parameters: [`3461 "Benefits" "BENS301_659299" null 2609`] View formatted query View runnable query Explain query INSERT INTO recipient_reference ( id, key, value, unsubscribed_at, recipient_id ) VALUES (?, ?, ?, ?, ?) INSERT INTO recipient_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (3461, 'Benefits', 'BENS301_659299', NULL, 2609);
8	0.47 ms	INSERT INTO recipient_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (?, ?, ?, ?, ?) Parameters: [`3462 "Housing" "HOUS1_659299" null 2609`] View formatted query View runnable query Explain query INSERT INTO recipient_reference ( id, key, value, unsubscribed_at, recipient_id ) VALUES (?, ?, ?, ?, ?) INSERT INTO recipient_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (3462, 'Housing', 'HOUS1_659299', NULL, 2609);
9	0.66 ms	UPDATE recipient SET version = ?, last_synced_at = ?, updated_at = ? WHERE id = ? Parameters: [`2 "2026-03-16 16:16:49" "2026-03-16 16:16:49" 2609`] View formatted query View runnable query Explain query UPDATE recipient SET version = ?, last_synced_at = ?, updated_at = ? WHERE id = ? UPDATE recipient SET version = 2, last_synced_at = '2026-03-16 16:16:49', updated_at = '2026-03-16 16:16:49' WHERE id = 2609;
10	0.28 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
11	0.56 ms	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 Parameters: [`"606"`] View formatted query View runnable query Explain query 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 = '606' LIMIT 1;
12	0.42 ms	SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ? Parameters: [`2608`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ? SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = 2608;
13	0.26 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
14	0.45 ms	UPDATE recipient SET version = ?, last_synced_at = ?, updated_at = ? WHERE id = ? Parameters: [`2 "2026-03-16 16:16:49" "2026-03-16 16:16:49" 2608`] View formatted query View runnable query Explain query UPDATE recipient SET version = ?, last_synced_at = ?, updated_at = ? WHERE id = ? UPDATE recipient SET version = 2, last_synced_at = '2026-03-16 16:16:49', updated_at = '2026-03-16 16:16:49' WHERE id = 2608;
15	0.26 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
16	0.52 ms	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 Parameters: [`"608"`] View formatted query View runnable query Explain query 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 = '608' LIMIT 1;
17	0.53 ms	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 Parameters: [`"[email protected]"`] View formatted query View runnable query Explain query 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;
18	0.53 ms	SELECT NEXTVAL('recipient_id_seq') Parameters: [] View formatted query View runnable query Explain query SELECT NEXTVAL('recipient_id_seq') SELECT NEXTVAL('recipient_id_seq');
19	0.31 ms	SELECT NEXTVAL('recipient_reference_id_seq') Parameters: [] View formatted query View runnable query Explain query SELECT NEXTVAL('recipient_reference_id_seq') SELECT NEXTVAL('recipient_reference_id_seq');
20	0.28 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
21	0.54 ms	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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`2610 "1418c4d0-7da7-4420-ac35-bbf44b6b03d3" "ARTEMIS KALETE 659299" "[email protected]" null null 1 "01234567892" null null "BL1 2AB" null null null "789 ELM STREET\|BOLTON\|BL1 2AB" 1 "customer" "2026-03-16 16:16:49" "2026-03-16 16:16:49" "608"`] View formatted query View runnable query Explain query 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 (2610, '1418c4d0-7da7-4420-ac35-bbf44b6b03d3', 'ARTEMIS KALETE 659299', '[email protected]', NULL, NULL, 1, '01234567892', NULL, NULL, 'BL1 2AB', NULL, NULL, NULL, '789 ELM STREET\|BOLTON\|BL1 2AB', 1, 'customer', '2026-03-16 16:16:49', '2026-03-16 16:16:49', '608');
22	0.46 ms	INSERT INTO recipient_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (?, ?, ?, ?, ?) Parameters: [`3463 "Council Tax" "CTAX2_659299" null 2610`] View formatted query View runnable query Explain query INSERT INTO recipient_reference ( id, key, value, unsubscribed_at, recipient_id ) VALUES (?, ?, ?, ?, ?) INSERT INTO recipient_reference (id, key, value, unsubscribed_at, recipient_id) VALUES (3463, 'Council Tax', 'CTAX2_659299', NULL, 2610);
23	0.27 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
24	0.56 ms	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 Parameters: [`"607"`] View formatted query View runnable query Explain query 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 = '607' LIMIT 1;
25	0.30 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
26	0.46 ms	UPDATE recipient SET deleted_at = ?, last_synced_at = ?, updated_at = ? WHERE id = ? Parameters: [`"2026-03-16 16:16:49" "2026-03-16 16:16:49" "2026-03-16 16:16:49" 2609`] View formatted query View runnable query Explain query UPDATE recipient SET deleted_at = ?, last_synced_at = ?, updated_at = ? WHERE id = ? UPDATE recipient SET deleted_at = '2026-03-16 16:16:49', last_synced_at = '2026-03-16 16:16:49', updated_at = '2026-03-16 16:16:49' WHERE id = 2609;
27	0.26 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
28	0.25 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
29	0.44 ms	UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ? Parameters: [`"2026-03-16 16:16:49" 3460`] View formatted query View runnable query Explain query UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ? UPDATE recipient_reference SET unsubscribed_at = '2026-03-16 16:16:49' WHERE id = 3460;
30	0.48 ms	UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ? Parameters: [`"2026-03-16 16:16:49" 3461`] View formatted query View runnable query Explain query UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ? UPDATE recipient_reference SET unsubscribed_at = '2026-03-16 16:16:49' WHERE id = 3461;
31	0.48 ms	UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ? Parameters: [`"2026-03-16 16:16:49" 3462`] View formatted query View runnable query Explain query UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ? UPDATE recipient_reference SET unsubscribed_at = '2026-03-16 16:16:49' WHERE id = 3462;
32	0.26 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
33	0.53 ms	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 Parameters: [`"605"`] View formatted query View runnable query Explain query 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 = '605' LIMIT 1;
34	0.39 ms	SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ? Parameters: [`2607`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ? SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = 2607;
35	0.28 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
36	0.46 ms	UPDATE recipient SET deleted_at = ?, version = ?, last_synced_at = ?, updated_at = ? WHERE id = ? Parameters: [`null 3 "2026-03-16 16:16:49" "2026-03-16 16:16:49" 2607`] View formatted query View runnable query Explain query UPDATE recipient SET deleted_at = ?, version = ?, last_synced_at = ?, updated_at = ? WHERE id = ? UPDATE recipient SET deleted_at = NULL, version = 3, last_synced_at = '2026-03-16 16:16:49', updated_at = '2026-03-16 16:16:49' WHERE id = 2607;
37	0.39 ms	UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ? Parameters: [`null 3458`] View formatted query View runnable query Explain query UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ? UPDATE recipient_reference SET unsubscribed_at = NULL WHERE id = 3458;
38	0.26 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
39	0.52 ms	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 Parameters: [`"606"`] View formatted query View runnable query Explain query 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 = '606' LIMIT 1;
40	0.31 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
41	0.45 ms	UPDATE recipient SET deleted_at = ?, last_synced_at = ?, updated_at = ? WHERE id = ? Parameters: [`"2026-03-16 16:16:49" "2026-03-16 16:16:49" "2026-03-16 16:16:49" 2608`] View formatted query View runnable query Explain query UPDATE recipient SET deleted_at = ?, last_synced_at = ?, updated_at = ? WHERE id = ? UPDATE recipient SET deleted_at = '2026-03-16 16:16:49', last_synced_at = '2026-03-16 16:16:49', updated_at = '2026-03-16 16:16:49' WHERE id = 2608;
42	0.26 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
43	0.28 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
44	0.40 ms	UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ? Parameters: [`"2026-03-16 16:16:49" 3459`] View formatted query View runnable query Explain query UPDATE recipient_reference SET unsubscribed_at = ? WHERE id = ? UPDATE recipient_reference SET unsubscribed_at = '2026-03-16 16:16:49' WHERE id = 3459;
45	0.26 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
46	0.53 ms	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 Parameters: [`"604"`] View formatted query View runnable query Explain query 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 = '604' LIMIT 1;
47	0.41 ms	SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ? Parameters: [`2606`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = ? SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3, t0.unsubscribed_at AS unsubscribed_at_4, t0.recipient_id AS recipient_id_5 FROM recipient_reference t0 WHERE t0.recipient_id = 2606;
48	0.26 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
49	0.45 ms	UPDATE recipient SET version = ?, last_synced_at = ?, updated_at = ? WHERE id = ? Parameters: [`3 "2026-03-16 16:16:49" "2026-03-16 16:16:49" 2606`] View formatted query View runnable query Explain query UPDATE recipient SET version = ?, last_synced_at = ?, updated_at = ? WHERE id = ? UPDATE recipient SET version = 3, last_synced_at = '2026-03-16 16:16:49', updated_at = '2026-03-16 16:16:49' WHERE id = 2606;
50	0.27 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
51	1.39 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
52	0.28 ms	SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query SAVEPOINT DOCTRINE_2 SAVEPOINT DOCTRINE_2;
53	0.49 ms	UPDATE customer_sync_status SET last_sync_at = ?, synced_today = ?, updated_at = ? WHERE id = ? Parameters: [`"2026-03-16 16:16:49" 7 "2026-03-16 16:16:49" 1`] View formatted query View runnable query Explain query 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:16:49', synced_today = 7, updated_at = '2026-03-16 16:16:49' WHERE id = 1;
54	0.31 ms	RELEASE SAVEPOINT DOCTRINE_2 Parameters: [] View formatted query View runnable query Explain query RELEASE SAVEPOINT DOCTRINE_2 RELEASE SAVEPOINT DOCTRINE_2;
55	1.78 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

Database Connections

Name	Service
tenant	doctrine.dbal.tenant_connection
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
tenant	doctrine.orm.tenant_entity_manager
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

tenant entity manager

Class	Amount of managed objects
App\Entity\Tenant\RecipientReference	8
App\Entity\Tenant\Recipient	5
App\Entity\Tenant\CustomerSyncStatus	1

default entity manager

Class	Amount of managed objects
App\Entity\Main\TenantApiKey	1
App\Entity\Main\TenantUser	1
App\Entity\Main\TenantDbConfig	1
App\Entity\Main\ApiLog	1

Entities Mapping

tenant entity manager

Class	Mapping errors
App\Entity\Tenant\Recipient	No errors.
App\Entity\Tenant\Document	No errors.
App\Entity\Tenant\AccessLog	No errors.
App\Entity\Tenant\RecipientReference	No errors.
App\Entity\Tenant\CustomerSyncStatus	No errors.

default entity manager

Class	Mapping errors
App\Entity\Main\TenantApiKey	No errors.
App\Entity\Main\TenantUser	No errors.
App\Entity\Main\TenantDbConfig	No errors.
App\Entity\Main\TenantHostname	No errors.
App\Entity\Main\TenantUserAuthenticator	No errors.
App\Entity\Main\ApiLog	No errors.

Symfony Profiler

POST https://publite-test.servicelevelmanagement.co.uk/api/recipients/sync/batch

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

tenant connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

tenant entity manager

default entity manager

Entities Mapping

tenant entity manager

default entity manager