GET https://sanatory-api.test.itlabs.top/api/staff

Query Metrics

2 Database Queries
2 Different statements
0.89 ms Query time
0 Invalid entities
3 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.54 ms
(60.10%)
1
SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM staff s0_ LEFT JOIN specialty s1_ ON s0_.specialty_id = s1_.id LEFT JOIN staff_position s3_ ON s0_.id = s3_.staff_id LEFT JOIN position p2_ ON p2_.id = s3_.position_id ORDER BY s0_.id ASC LIMIT 25
Parameters:
[]
0.36 ms
(39.90%)
1
SELECT s0_.id AS id_0, s0_.full_name AS full_name_1, s0_.office AS office_2, s0_.building AS building_3, s0_.description AS description_4, s0_.image AS image_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s1_.id AS id_8, s1_.name AS name_9, p2_.id AS id_10, p2_.name AS name_11, s0_.specialty_id AS specialty_id_12 FROM staff s0_ LEFT JOIN specialty s1_ ON s0_.specialty_id = s1_.id LEFT JOIN staff_position s3_ ON s0_.id = s3_.staff_id LEFT JOIN position p2_ ON p2_.id = s3_.position_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  2
]

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\Staff 1
App\Entity\Specialty 1
App\Entity\Position 1

Entities Mapping

Class Mapping errors
App\Entity\Staff No errors.
App\Entity\Specialty No errors.
App\Entity\Position No errors.