Query Metrics
15
Database Queries
11
Different statements
43.23 ms
Query time
0
Invalid entities
4
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.50 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:
[
"7698a68238a20b789118ec4251d5a3b0"
]
|
| 2 | 0.29 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 1.07 ms |
UPDATE tenant_api_key SET last_used_at = ? WHERE id = ?
Parameters:
[ "2026-11-12 09:20:56" 6 ] |
| 4 | 1.40 ms |
"COMMIT"
Parameters:
[] |
| 5 | 1.27 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:
[
4
]
|
| 6 | 0.54 ms |
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
]
|
| 7 | 0.57 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:
[
"7698a68238a20b789118ec4251d5a3b0"
]
|
| 8 | 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:
[
"7698a68238a20b789118ec4251d5a3b0"
]
|
| 9 | 3.59 ms |
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
]
|
| 10 | 1.69 ms |
SELECT NEXTVAL('api_logs_id_seq')
Parameters:
[] |
| 11 | 0.25 ms |
"START TRANSACTION"
Parameters:
[] |
| 12 | 2.19 ms |
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:
[ 340830 "2026-11-12 09:20:56" "[email protected]" "GET /api/recipients/reconcile (200)" "API call completed in 33.31ms with status 200" "{"query":{"buckets":"256","bucket":"08,11,1b,2e,46,6a,cf,ee,ff","include_disabled":"true"}}" null null "162.158.216.186" "Symfony HttpClient/Curl" 4 ] |
| 13 | 1.02 ms |
"COMMIT"
Parameters:
[] |
tenant connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 21.74 ms |
SELECT id, source_id, email, version, updated_at FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL AND SUBSTR(MD5(LOWER(TRIM(email))), 1, 2) IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY LOWER(TRIM(email)) COLLATE "C" ASC, id ASC
Parameters:
[ "08" "11" "1b" "2e" "46" "6a" "cf" "ee" "ff" ] |
| 2 | 1.65 ms |
SELECT id, source_id, email, version, updated_at, deleted_at FROM recipient WHERE (enable <= 0 OR deleted_at IS NOT NULL) AND email IS NOT NULL AND SUBSTR(MD5(LOWER(TRIM(email))), 1, 2) IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "08" "11" "1b" "2e" "46" "6a" "cf" "ee" "ff" ] |
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.