GET https://publite-joel.servicelevelmanagement.co.uk/api/recipients/950181

Query Metrics

15 Database Queries
11 Different statements
25.24 ms Query time
0 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
6.47 ms
(25.64%)
3
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:
[
  "7698a68238a20b789118ec4251d5a3b0"
]
3.56 ms
(14.12%)
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 = ?
Parameters:
[
  1
]
2.62 ms
(10.40%)
2
"COMMIT"
Parameters:
[]
2.45 ms
(9.72%)
1
INSERT INTO api_logs (id, timestamp, username, action, details, request_data, document_uuid, response_data, ip_address, user_agent, tenant_db_config_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  340050
  "2026-11-12 09:02:07"
  "[email protected]"
  "GET /api/recipients/950181 (200)"
  "API call completed in 16.38ms with status 200"
  null
  null
  "{"id":950181,"uuid":"42c1cf78-6647-4521-854a-fdf381739785"}"
  "172.69.43.189"
  "Symfony HttpClient/Curl"
  4
]
1.21 ms
(4.78%)
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 = ?
Parameters:
[
  4
]
0.97 ms
(3.83%)
1
UPDATE tenant_api_key SET last_used_at = ? WHERE id = ?
Parameters:
[
  "2026-11-12 09:02:07"
  6
]
0.87 ms
(3.45%)
1
SELECT NEXTVAL('api_logs_id_seq')
Parameters:
[]
0.73 ms
(2.88%)
1
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 = ?
Parameters:
[
  4
]
0.53 ms
(2.08%)
2
"START TRANSACTION"
Parameters:
[]

tenant connection

Time▼ Count Info
4.29 ms
(16.99%)
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.id = ?
Parameters:
[
  "950181"
]
1.54 ms
(6.12%)
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 = ?
Parameters:
[
  950181
]

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
queue doctrine.orm.queue_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

tenant entity manager

Class Amount of managed objects
App\Entity\Tenant\Recipient 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

queue entity manager

Class Amount of managed objects

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.

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\TenantMembership No errors.
App\Entity\Main\TenantHostname No errors.
App\Entity\Main\TenantUserAuthenticator No errors.
App\Entity\Main\ApiLog No errors.

queue entity manager

No loaded entities.