Query Metrics

4 Database Queries
4 Different statements
33.05 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 4.31 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
]
2 2.11 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 INNER JOIN tenant_user_tenant_db_config ON t0.id = tenant_user_tenant_db_config.tenant_db_config_id WHERE tenant_user_tenant_db_config.tenant_user_id = ?
Parameters:
[
  1
]
3 15.21 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM api_logs a0_ LEFT JOIN tenant_db_config t1_ ON a0_.tenant_db_config_id = t1_.id WHERE (a0_.username = ? OR (a0_.tenant_db_config_id IS NOT NULL AND t1_.id IN (?, ?, ?, ?))) AND (a0_.timestamp >= ? AND a0_.timestamp < ?)
Parameters:
[
  "[email protected]"
  1
  2
  3
  4
  "2026-07-16 00:00:00"
  "2026-07-17 00:00:00"
]
4 11.43 ms
SELECT a0_.id AS id_0, a0_.timestamp AS timestamp_1, a0_.username AS username_2, a0_.action AS action_3, a0_.details AS details_4, a0_.request_data AS request_data_5, a0_.response_data AS response_data_6, a0_.ip_address AS ip_address_7, a0_.user_agent AS user_agent_8, t1_.id AS id_9, t1_.driver_type AS driver_type_10, t1_.db_name AS db_name_11, t1_.db_user_name AS db_user_name_12, t1_.db_password AS db_password_13, t1_.db_host AS db_host_14, t1_.db_port AS db_port_15, t1_.database_status AS database_status_16, a0_.tenant_db_config_id AS tenant_db_config_id_17 FROM api_logs a0_ LEFT JOIN tenant_db_config t1_ ON a0_.tenant_db_config_id = t1_.id WHERE (a0_.username = ? OR (a0_.tenant_db_config_id IS NOT NULL AND t1_.id IN (?, ?, ?, ?))) AND (a0_.timestamp >= ? AND a0_.timestamp < ?) ORDER BY a0_.timestamp DESC LIMIT 10
Parameters:
[
  "[email protected]"
  1
  2
  3
  4
  "2026-07-16 00:00:00"
  "2026-07-17 00:00:00"
]

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

default entity manager

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

Entities Mapping

tenant entity manager

No loaded entities.

default entity manager

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