Query Metrics

23 Database Queries
4 Different statements
10.64 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.33 ms
SELECT DISTINCT t0_.id AS id_0 FROM teacher t0_ LIMIT 20 OFFSET 160
Parameters:
[]
2 0.64 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_ WHERE t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  49
  47
  177
  20
  182
  33
  76
  106
  18
  185
  64
  110
  178
  145
  55
  148
  130
  129
  27
  143
]
3 0.47 ms
SELECT count(t0_.id) AS sclr_0 FROM teacher t0_
Parameters:
[]
4 1.04 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  18
]
5 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  20
]
6 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  27
]
7 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  33
]
8 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  47
]
9 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  49
]
10 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  55
]
11 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  64
]
12 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  76
]
13 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  106
]
14 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  110
]
15 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  129
]
16 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  130
]
17 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  143
]
18 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  145
]
19 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  148
]
20 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  177
]
21 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  178
]
22 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  182
]
23 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM department t0 INNER JOIN teacher_department ON t0.id = teacher_department.department_id WHERE teacher_department.teacher_id = ?
Parameters:
[
  185
]

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\Teacher No errors.
App\Entity\Department No errors.
App\Entity\ClassTime 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.