Query Metrics
6
Database Queries
5
Different statements
3.79 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.app_key AS app_key_3 FROM app_keys t0 WHERE t0.app_key = ? LIMIT 1
Parameters:
[
"1676DAFE-D14F-49DA-B191-A1EAD4A8D70A"
]
|
| 2 | 1.29 ms |
SELECT t0.id AS id_1, t0.auth_key AS auth_key_2, t0.roles AS roles_3, t0.user_id AS user_id_4 FROM user_auth_keys t0 WHERE t0.auth_key = ? LIMIT 1
Parameters:
[
"380a1f73-3f5e-4be0-92b7-0374827d7f27"
]
|
| 3 | 0.27 ms |
SELECT t0.id AS id_1, t0.mobile AS mobile_2, t0.name AS name_3, t0.app_mode AS app_mode_4, t0.is_deleted AS is_deleted_5, t0.email AS email_6, t0.doctor_id AS doctor_id_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
398
]
|
| 4 | 1.14 ms |
SELECT t0.id AS id_1, t0.auth_key AS auth_key_2, t0.roles AS roles_3, t0.user_id AS user_id_4 FROM user_auth_keys t0 WHERE t0.auth_key = ? LIMIT 1
Parameters:
[
"380a1f73-3f5e-4be0-92b7-0374827d7f27"
]
|
| 5 | 0.38 ms |
SELECT u0_.id AS id_0, u0_.subscription_date AS subscription_date_1, u0_.subscription_end_date AS subscription_end_date_2, u0_.amount_paid AS amount_paid_3, u0_.status AS status_4, u0_.user_id AS user_id_5, u0_.plan_id AS plan_id_6, u0_.subscription_order_id AS subscription_order_id_7 FROM user_subscription u0_ WHERE u0_.user_id = ? AND u0_.status = ? AND u0_.subscription_end_date >= ? ORDER BY u0_.subscription_end_date DESC LIMIT 1
Parameters:
[ 398 "active" "2026-08-17 12:59:31" ] |
| 6 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.subscription_code AS subscription_code_3, t0.description AS description_4, t0.amount AS amount_5, t0.duration_days AS duration_days_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8 FROM subscription_plan t0 WHERE t0.id = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_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\AppKeys | No errors. |
| App\Entity\UserAuthKeys | No errors. |
| App\Entity\User |
|
| App\Entity\Doctor | No errors. |
| App\Entity\UserOtpKeys | No errors. |
| App\Entity\UserDoctor | No errors. |
| App\Entity\Patient |
|
| App\Entity\EcgRecord |
|
| App\Entity\HolterRecords | No errors. |
| App\Entity\Enquiry | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\UserSubscription | No errors. |
| App\Entity\SubscriptionPlan | No errors. |
| App\Entity\SubscriptionOrder | No errors. |