GET https://medmis-api-new.itlabs.top/admin/doctor?page=5

Query Metrics

8 Database Queries
8 Different statements
3.64 ms Query time
0 Invalid entities
14 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.01 ms
(27.84%)
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.62 ms
(17.12%)
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.44 ms
(12.23%)
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.39 ms
(10.82%)
1
SELECT COUNT(*) FROM wait_mode t0
Parameters:
[]
0.38 ms
(10.55%)
1
SELECT count(*) AS sclr_0 FROM doctor d0_
Parameters:
[]
0.30 ms
(8.14%)
1
SELECT COUNT(*) FROM contract_pdf_settings t0
Parameters:
[]
0.25 ms
(6.98%)
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:
[]
0.23 ms
(6.32%)
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:
[]

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\User No errors.
App\Entity\Doctor No errors.
App\Entity\WaitMode No errors.
App\Entity\ContractPdfSettings No errors.