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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 3.79 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.mobile = ? LIMIT 1
Parameters:
[
  "7736175446"
]
2 3.16 ms
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
]
3 0.27 ms
"START TRANSACTION"
Parameters:
[]
4 2.65 ms
INSERT INTO user_auth_keys (auth_key, roles, user_id) VALUES (?, ?, ?)
Parameters:
[
  "6b72cfe6-87b0-427f-a3aa-e10369a677d3"
  "["ROLE_USER"]"
  449
]
5 3.60 ms
"COMMIT"
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.