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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.33 ms
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
]
2 0.65 ms
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:
[]
3 0.38 ms
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
]
4 0.22 ms
SELECT count(*) AS sclr_0 FROM doctor d0_
Parameters:
[]
5 0.32 ms
SELECT COUNT(*) FROM wait_mode t0
Parameters:
[]
6 0.13 ms
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:
[]
7 0.13 ms
SELECT COUNT(*) FROM contract_pdf_settings t0
Parameters:
[]
8 0.13 ms
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.