Redirect 302 redirect from GET @admin (6421a8)

Query Metrics

4 Database Queries
4 Different statements
4.84 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.21 ms
(45.57%)
1
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
]
1.76 ms
(36.31%)
1
SELECT DISTINCT r0_.id AS id_0 FROM room_type r0_ LIMIT 20
Parameters:
[]
0.52 ms
(10.70%)
1
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.room_id AS room_id_2 FROM room_type r0_ WHERE r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  5
  6
  7
  8
  9
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  25
  26
]
0.36 ms
(7.42%)
1
SELECT count(r0_.id) AS sclr_0 FROM room_type 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.