POST https://biobt.sarabit.com/mobile/public/user/otpVerification.json

Query Metrics

5 Database Queries
5 Different statements
17.07 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.51 ms
(73.26%)
1
"COMMIT"
Parameters:
[]
2.12 ms
(12.39%)
1
INSERT INTO user_auth_keys (auth_key, roles, user_id) VALUES (?, ?, ?)
Parameters:
[
  "48dcc01c-c320-4ae6-860e-4092f909f87b"
  "["ROLE_USER"]"
  449
]
1.26 ms
(7.39%)
1
SELECT t0.id AS id_1, t0.guid AS guid_2, t0.otp AS otp_3, t0.user_id AS user_id_4 FROM user_otp_keys t0 WHERE t0.guid = ? AND t0.user_id = ? LIMIT 1
Parameters:
[
  "1bf61f6d-1476-48a8-9d84-0ffd251229e3"
  449
]
1.07 ms
(6.26%)
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.mobile = ? LIMIT 1
Parameters:
[
  "7736175446"
]
0.12 ms
(0.70%)
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\User
  • The mappings App\Entity\User#ecgRecords and App\Entity\EcgRecord#user are inconsistent with each other.
App\Entity\Doctor No errors.
App\Entity\UserAuthKeys 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.