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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
2.21 ms
(64.95%)
2
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"
]
0.40 ms
(11.71%)
1
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"
]
0.34 ms
(9.98%)
1
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:21"
]
0.23 ms
(6.89%)
1
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
]
0.22 ms
(6.47%)
1
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.