Query Metrics

3 Database Queries
3 Different statements
2.83 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.room_id AS room_id_3 FROM room_type t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
2 1.45 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.capacity AS capacity_3, t0.floor AS floor_4, t0.name AS name_5, t0.building_id AS building_id_6, t7.id AS id_8, t7.duration_in_minutes AS duration_in_minutes_9, t7.length AS length_10, t7.tmp_count AS tmp_count_11, t7.start_time AS start_time_12, t7.end_time AS end_time_13, t7.group_ids AS group_ids_14, t7.sub_group_ids AS sub_group_ids_15, t7.phase_group_ids AS phase_group_ids_16, t7.ref_id AS ref_id_17, t7.phase_part AS phase_part_18, t7.group_id AS group_id_19, t7.sub_group_id AS sub_group_id_20, t7.lesson_id AS lesson_id_21, t7.department_id AS department_id_22, t7.teacher_id AS teacher_id_23, t7.phase_group_id AS phase_group_id_24, t7.room_id AS room_id_25, t7.selecting_class_time_id AS selecting_class_time_id_26 FROM room t0 LEFT JOIN class_time t7 ON t7.room_id = t0.id WHERE t0.id = ?
Parameters:
[
  3
]
3 0.30 ms
SELECT r0_.id AS id_0, r0_.number AS number_1, r0_.capacity AS capacity_2, r0_.floor AS floor_3, r0_.name AS name_4, r0_.building_id AS building_id_5 FROM room r0_
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\RoomType No errors.
App\Entity\Room No errors.
App\Entity\Building No errors.
App\Entity\ClassTime No errors.
App\Entity\Group No errors.
App\Entity\SubGroup
  • The mappings App\Entity\SubGroup#directionLesson and App\Entity\Lesson#subGroups are inconsistent with each other.
App\Entity\Lesson
  • The association App\Entity\Lesson#subGroups refers to the owning side field App\Entity\SubGroup#lesson which does not exist.
App\Entity\Department No errors.
App\Entity\Teacher No errors.
App\Entity\PhaseGroup No errors.
App\Entity\SelectingClassTime No errors.