Redirect 302 redirect from GET @admin (d61957)

Query Metrics

6 Database Queries
4 Different statements
5.12 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.57 ms
(50.10%)
3
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.building_id = ?
Parameters:
[
  4
]
1.44 ms
(28.07%)
1
SELECT DISTINCT b0_.id AS id_0 FROM building b0_ LIMIT 20
Parameters:
[]
0.62 ms
(12.19%)
1
SELECT count(b0_.id) AS sclr_0 FROM building b0_
Parameters:
[]
0.49 ms
(9.64%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1 FROM building b0_ WHERE b0_.id IN (?, ?, ?)
Parameters:
[
  4
  5
  6
]

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\Building No errors.
App\Entity\Room 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.
App\Entity\RoomType No errors.