Query Metrics

5 Database Queries
5 Different statements
4.17 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.90 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 WHERE t0.id = ?
Parameters:
[
  "10"
]
2 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.deep_value AS deep_value_3, t0.switch AS switch_4, t0.department_id AS department_id_5 FROM lesson t0 WHERE t0.department_id = ?
Parameters:
[
  10
]
3 1.02 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.surname AS surname_5 FROM teacher t0 INNER JOIN teacher_department ON t0.id = teacher_department.teacher_id WHERE teacher_department.department_id = ?
Parameters:
[
  10
]
4 0.29 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.deep_value AS deep_value_2, l0_.switch AS switch_3, l0_.department_id AS department_id_4 FROM lesson l0_
Parameters:
[]
5 0.46 ms
SELECT t0_.id AS id_0, t0_.first_name AS first_name_1, t0_.last_name AS last_name_2, t0_.email AS email_3, t0_.surname AS surname_4 FROM teacher 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.

Entities Mapping

Class Mapping errors
App\Entity\Department No errors.
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\Teacher No errors.
App\Entity\ClassTime No errors.
App\Entity\SubGroup
  • The mappings App\Entity\SubGroup#directionLesson and App\Entity\Lesson#subGroups are inconsistent with each other.
App\Entity\PhaseGroup No errors.
App\Entity\ChoosedLesson
  • The association App\Entity\ChoosedLesson#typeClass refers to the inverse side field App\Entity\TypeClass#choosedLessons which does not exist.
App\Entity\LessonType No errors.
App\Entity\PhaseItem No errors.
App\Entity\Phase No errors.