Query Metrics

3 Database Queries
3 Different statements
3.25 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.11 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.password_old1 AS password_old1_4, t0.password_old2 AS password_old2_5, t0.password_md5 AS password_md5_6, t0.is_active AS is_active_7, t0.token AS token_8, t0.roles AS roles_9, t0.last_login AS last_login_10, t0.auth_code AS auth_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.profile_id AS profile_id_14 FROM users t0 WHERE t0.id = ?
Parameters:
[
  40
]
2 1.07 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.message AS message_3, t0.is_read AS is_read_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6 FROM notifications t0 WHERE t0.user_id = ? AND t0.is_read = ? ORDER BY t0.created_at DESC LIMIT 5
Parameters:
[
  40
  0
]

cnmgts connection

# Time Info
1 1.07 ms
SELECT * FROM cnmgts_abha_consent_request ORDER BY id DESC
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
cnmgts doctrine.dbal.cnmgts_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\StaffProfile No errors.
App\Entity\UserLoginHistory No errors.
App\Entity\Patient No errors.
App\Entity\Notification No errors.