GET https://publite-joel.servicelevelmanagement.co.uk/api/recipients/integrity?after_id=961465&limit=5000

Query Metrics

15 Database Queries
11 Different statements
26.50 ms Query time
0 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
6.92 ms
(26.10%)
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.45 ms
(13.04%)
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.94 ms
(11.10%)
2
"COMMIT"
Parameters:
[]
2.03 ms
(7.68%)
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:
[
  340815
  "2026-11-12 09:20:50"
  "[email protected]"
  "GET /api/recipients/integrity (200)"
  "API call completed in 14.81ms with status 200"
  "{"query":{"after_id":"961465","limit":"5000"}}"
  null
  null
  "162.158.216.186"
  "Symfony HttpClient/Curl"
  4
]
1.26 ms
(4.75%)
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
]
1.04 ms
(3.93%)
1
UPDATE tenant_api_key SET last_used_at = ? WHERE id = ?
Parameters:
[
  "2026-11-12 09:20:50"
  6
]
0.90 ms
(3.40%)
1
SELECT NEXTVAL('api_logs_id_seq')
Parameters:
[]
0.56 ms
(2.12%)
2
"START TRANSACTION"
Parameters:
[]
0.56 ms
(2.10%)
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
]

tenant connection

Time▼ Count Info
4.87 ms
(18.39%)
1
SELECT id, source_id, email, name, enable, version, deleted_at
             FROM recipient WHERE id > ? ORDER BY id ASC LIMIT ?
Parameters:
[
  961465
  5000
]
1.96 ms
(7.39%)
1
SELECT recipient_id, "key" AS ref_key, value FROM recipient_reference
                 WHERE recipient_id IN (?, ?, ?) AND unsubscribed_at IS NULL
Parameters:
[
  961466
  961467
  961468
]

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

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

No loaded entities.

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.