GET https://app.biobt.in/desktop/api/v1/subscription

Query Metrics

6 Database Queries
5 Different statements
3.79 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.43 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.34 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.13 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.36 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:16"
]
6 0.26 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
  • The mappings App\Entity\User#ecgRecords and App\Entity\EcgRecord#user are inconsistent with each other.
App\Entity\Doctor No errors.
App\Entity\UserOtpKeys No errors.
App\Entity\UserDoctor No errors.
App\Entity\Patient
  • The mappings App\Entity\Patient#ecgRecords and App\Entity\EcgRecord#patient are inconsistent with each other.
App\Entity\EcgRecord
  • The association App\Entity\EcgRecord#user refers to the inverse side field App\Entity\User#ecgReacords which does not exist.
  • The association App\Entity\EcgRecord#patient refers to the inverse side field App\Entity\Patient#ecgReacords which does not exist.
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.