POST https://app.biobt.in/desktop/api/v1/patients

Query Metrics

10 Database Queries
8 Different statements
8.64 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.21 ms
(37.08%)
3
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:
[
  "274fd884-808b-4024-9eb7-07689279ea25"
]
2.19 ms
(25.35%)
1
"COMMIT"
Parameters:
[]
1.68 ms
(19.39%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.age AS age_3, t0.gender AS gender_4, t0.height AS height_5, t0.weight AS weight_6, t0.mobile AS mobile_7, t0.aadhar_id AS aadhar_id_8, t0.address AS address_9, t0.history AS history_10, t0.remark AS remark_11, t0.guid AS guid_12, t0.last_modified AS last_modified_13, t0.sync_updated_on AS sync_updated_on_14, t0.is_default AS is_default_15, t0.code AS code_16, t0.diabetic AS diabetic_17, t0.smoker AS smoker_18, t0.ref_id AS ref_id_19, t0.doctor_id AS doctor_id_20, t0.user_id AS user_id_21 FROM patient t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
  "3e3d4fb0-fb3d-452a-bebf-24b71615dab8"
]
0.42 ms
(4.85%)
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:
[
  "9ee854f8-c40c-40ef-9f96-a9fe59d69e23"
]
0.36 ms
(4.21%)
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:
[
  1
  "active"
  "2026-08-17 13:14:00"
]
0.35 ms
(4.09%)
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:
[
  1
]
0.32 ms
(3.69%)
1
INSERT INTO patient (name, age, gender, height, weight, mobile, aadhar_id, address, history, remark, guid, last_modified, sync_updated_on, is_default, code, diabetic, smoker, ref_id, doctor_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "khem1"
  23
  "male"
  "174"
  "78"
  null
  null
  null
  ""
  ""
  "3e3d4fb0-fb3d-452a-bebf-24b71615dab8"
  "2026-08-17 13:14:00"
  "2026-08-17 13:14:00"
  0
  "4"
  null
  0
  null
  null
  1
]
0.12 ms
(1.34%)
1
"START TRANSACTION"
Parameters:
[]

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.
App\Entity\RrGluData No errors.