Query Metrics

20 Database Queries
8 Different statements
13.04 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 2.13 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.verification_token AS verification_token_6, t0.reset_token AS reset_token_7, t0.reset_token_expires_at AS reset_token_expires_at_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.verify_code AS verify_code_11, t0.verify_code_created_at AS verify_code_created_at_12, t0.jwt_token AS jwt_token_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.first_name AS first_name_18, t16.last_name AS last_name_19, t16.email AS email_20, t16.surname AS surname_21, t16.created_at AS created_at_22, t16.updated_at AS updated_at_23, t16.timesheet_number AS timesheet_number_24, t16.m_id AS m_id_25, t16.user_id AS user_id_26, t27.id AS id_28, t27.direction_sub_group_id AS direction_sub_group_id_29, t27.lessons_time_map AS lessons_time_map_30, t27.lessons_type_map AS lessons_type_map_31, t27.matrix AS matrix_32, t27.removed_lessons AS removed_lessons_33, t27.first_name AS first_name_34, t27.last_name AS last_name_35, t27.age AS age_36, t27.email AS email_37, t27.surname AS surname_38, t27.created_at AS created_at_39, t27.updated_at AS updated_at_40, t27.group_id AS group_id_41, t27.user_id AS user_id_42 FROM "user" t0 LEFT JOIN teacher t16 ON t16.user_id = t0.id LEFT JOIN student t27 ON t27.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  14
]
2 0.93 ms
SELECT DISTINCT s0_.id AS id_0 FROM sub_group s0_ WHERE s0_.number = ? LIMIT 20
Parameters:
[
  11
]
3 0.51 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.number AS number_2, s0_.matrix AS matrix_3, s0_.m_id AS m_id_4, s0_.group_id AS group_id_5, s0_.lesson_id AS lesson_id_6, s0_.type_class_id AS type_class_id_7, s0_.group_direction_id AS group_direction_id_8 FROM sub_group s0_ WHERE s0_.number = ? AND s0_.id IN (?, ?, ?, ?, ?)
Parameters:
[
  11
  102
  101
  99
  98
  100
]
4 0.67 ms
SELECT count(s0_.id) AS sclr_0 FROM sub_group s0_ WHERE s0_.number = ?
Parameters:
[
  11
]
5 0.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.m_id AS m_id_4, t0.level_class_id AS level_class_id_5 FROM "group" t0 WHERE t0.id = ?
Parameters:
[
  9
]
6 1.12 ms
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = ?
Parameters:
[
  98
]
7 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = ?
Parameters:
[
  98
]
8 0.43 ms
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = ?
Parameters:
[
  4
]
9 0.63 ms
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = ?
Parameters:
[
  101
]
10 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = ?
Parameters:
[
  101
]
11 0.37 ms
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = ?
Parameters:
[
  1
]
12 0.85 ms
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = ?
Parameters:
[
  99
]
13 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = ?
Parameters:
[
  99
]
14 0.33 ms
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = ?
Parameters:
[
  3
]
15 0.90 ms
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = ?
Parameters:
[
  100
]
16 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = ?
Parameters:
[
  100
]
17 0.34 ms
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = ?
Parameters:
[
  6
]
18 0.71 ms
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = ?
Parameters:
[
  102
]
19 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = ?
Parameters:
[
  102
]
20 0.33 ms
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\User No errors.
App\Entity\Teacher No errors.
App\Entity\Student No errors.
App\Entity\Group No errors.
App\Entity\SubGroup No errors.
App\Entity\Lesson No errors.
App\Entity\TypeClass
  • The mappings App\Entity\TypeClass#choosedLesson and App\Entity\ChoosedLesson#typeClass are inconsistent with each other.
App\Entity\GroupDirection No errors.
App\Entity\ClassTime No errors.
App\Entity\PhaseGroup No errors.
App\Entity\Phase No errors.
App\Entity\SelectingClassTime No errors.
App\Entity\SelectingClassTimeGroup No errors.
App\Entity\LevelClass 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\PhaseItem No errors.
App\Entity\LessonType No errors.