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

Query Metrics

7 Database Queries
5 Different statements
17.92 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.37 ms
(57.89%)
2
"COMMIT"
Parameters:
[]
3.67 ms
(20.46%)
1
INSERT INTO user_otp_keys (guid, otp, user_id) VALUES (?, ?, ?)
Parameters:
[
  "1bf61f6d-1476-48a8-9d84-0ffd251229e3"
  "4839"
  449
]
1.86 ms
(10.38%)
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"
]
1.70 ms
(9.51%)
1
INSERT INTO user (mobile, name, app_mode, is_deleted, email, doctor_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  "7736175446"
  null
  null
  0
  null
  null
]
0.32 ms
(1.76%)
2
"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.