Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 76
• Events
• Routing
• Cache
• Translation 4
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

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 = ?

[
  98
]

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 = ?

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 = 98;

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 = ?

[
  98
]

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 = ?

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 = 98;

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 = ?

[
  14
]

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 = ?

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 = 14;

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 = ?

[
  4
]

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 = ?

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 = 4;

SELECT DISTINCT s0_.id AS id_0 FROM sub_group s0_ WHERE s0_.number = ? LIMIT 20

[
  11
]

SELECT
  DISTINCT s0_.id AS id_0
FROM
  sub_group s0_
WHERE
  s0_.number = ?
LIMIT
  20

SELECT DISTINCT s0_.id AS id_0 FROM sub_group s0_ WHERE s0_.number = 11 LIMIT 20;

SELECT count(s0_.id) AS sclr_0 FROM sub_group s0_ WHERE s0_.number = ?

[
  11
]

SELECT
  count(s0_.id) AS sclr_0
FROM
  sub_group s0_
WHERE
  s0_.number = ?

SELECT count(s0_.id) AS sclr_0 FROM sub_group s0_ WHERE s0_.number = 11;

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 = ?

[
  9
]

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 = ?

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 = 9;

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 (?, ?, ?, ?, ?)

[
  11
  102
  101
  99
  98
  100
]

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 (?, ?, ?, ?, ?)

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 = 11 AND s0_.id IN (102, 101, 99, 98, 100);