GET https://school.itlabs.top/api/week_days_with_study_class/7

Query Metrics

6 Database Queries
6 Different statements
2.65 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.66 ms
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.study_class_id AS study_class_id_2 FROM day_of_week d0_ WHERE d0_.study_class_id = ?
Parameters:
[
  7
]
2 0.47 ms
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.office_id AS office_id_4, t0.teacher_id AS teacher_id_5, t0.subject_id AS subject_id_6, t0.day_of_week_id AS day_of_week_id_7 FROM lesson t0 WHERE t0.day_of_week_id = ?
Parameters:
[
  6
]
3 0.35 ms
SELECT t0.id AS id_1, t0.number AS number_2 FROM office t0 WHERE t0.id = ?
Parameters:
[
  3
]
4 0.37 ms
SELECT t0.id AS id_1, t0.surname AS surname_2, t0.name AS name_3, t0.patronymic AS patronymic_4, t0.photograph AS photograph_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM teacher t0 WHERE t0.id = ?
Parameters:
[
  3
]
5 0.39 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM subject t0 WHERE t0.id = ?
Parameters:
[
  3
]
6 0.40 ms
SELECT t0.id AS id_1, t0.number AS number_2 FROM study_class t0 WHERE t0.id = ?
Parameters:
[
  7
]

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\DayOfWeek No errors.
App\Entity\StudyClass No errors.
App\Entity\Lesson No errors.
App\Entity\Office No errors.
App\Entity\Teacher No errors.
App\Entity\Subject No errors.