Query Metrics
5
Database Queries
5
Different statements
13.47 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.79 ms (28.11%) |
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"
]
|
|
3.60 ms (26.73%) |
1 |
"COMMIT"
Parameters:
[] |
|
3.16 ms (23.48%) |
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 ] |
|
2.65 ms (19.68%) |
1 |
INSERT INTO user_auth_keys (auth_key, roles, user_id) VALUES (?, ?, ?)
Parameters:
[ "6b72cfe6-87b0-427f-a3aa-e10369a677d3" "["ROLE_USER"]" 449 ] |
|
0.27 ms (2.00%) |
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 |
|
| App\Entity\Doctor | No errors. |
| App\Entity\UserAuthKeys | No errors. |
| App\Entity\UserOtpKeys | No errors. |
| App\Entity\UserDoctor | No errors. |
| App\Entity\Patient |
|
| App\Entity\EcgRecord |
|
| App\Entity\HolterRecords | No errors. |
| App\Entity\Enquiry | No errors. |
| App\Entity\Notification | No errors. |