Query Metrics
8
Database Queries
8
Different statements
2.30 ms
Query time
0
Invalid entities
14
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.65 ms (28.45%) |
1 |
SELECT DISTINCT d0_.id AS id_0, d0_.surname AS surname_1 FROM doctor d0_ ORDER BY d0_.surname ASC LIMIT 20 OFFSET 80
Parameters:
[] |
|
0.38 ms (16.73%) |
1 |
SELECT d0_.id AS id_0, d0_.external_id AS external_id_1, d0_.surname AS surname_2, d0_.name AS name_3, d0_.patronymic AS patronymic_4, d0_.online_recording_information AS online_recording_information_5, d0_.sex AS sex_6, d0_.image AS image_7, d0_.specialities AS specialities_8, d0_.near_record AS near_record_9, d0_.is_active AS is_active_10, d0_.created_at AS created_at_11, d0_.updated_at AS updated_at_12 FROM doctor d0_ WHERE d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.surname ASC
Parameters:
[ 11 14 50 42 28 66 33 23 85 65 34 ] |
|
0.33 ms (14.55%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.32 ms (13.94%) |
1 |
SELECT COUNT(*) FROM wait_mode t0
Parameters:
[] |
|
0.22 ms (9.71%) |
1 |
SELECT count(*) AS sclr_0 FROM doctor d0_
Parameters:
[] |
|
0.13 ms (5.62%) |
1 |
SELECT COUNT(*) FROM contract_pdf_settings t0
Parameters:
[] |
|
0.13 ms (5.52%) |
1 |
SELECT t0.id AS id_1, t0.sleep_mode_seconds AS sleep_mode_seconds_2, t0.notification_seconds AS notification_seconds_3 FROM wait_mode t0
Parameters:
[] |
|
0.13 ms (5.48%) |
1 |
SELECT t0.id AS id_1, t0.consent_text AS consent_text_2, t0.media AS media_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM contract_pdf_settings t0
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Doctor | 11 |
| App\Entity\User | 1 |
| App\Entity\WaitMode | 1 |
| App\Entity\ContractPdfSettings | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Doctor | No errors. |
| App\Entity\MainScreenAd | No errors. |
| App\Entity\WaitMode | No errors. |
| App\Entity\WorkScreenAd | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ContractPdfSettings | No errors. |