Symfony Profiler

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

SELECT
  DISTINCT s0_.id AS id_0
FROM
  student s0_
WHERE
  (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )
  AND (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )
LIMIT
  20

SELECT DISTINCT s0_.id AS id_0 FROM student s0_ WHERE (LOWER(s0_.first_name || '') LIKE '%աննա%' OR LOWER(s0_.last_name || '') LIKE '%աննա%' OR LOWER(s0_.email || '') LIKE '%աննա%' OR LOWER(s0_.surname || '') LIKE '%աննա%') AND (LOWER(s0_.first_name || '') LIKE '%նիկ%' OR LOWER(s0_.last_name || '') LIKE '%նիկ%' OR LOWER(s0_.email || '') LIKE '%նիկ%' OR LOWER(s0_.surname || '') LIKE '%նիկ%') LIMIT 20;

SELECT
  s0_.id AS id_0,
  s0_.direction_sub_group_id AS direction_sub_group_id_1,
  s0_.lessons_time_map AS lessons_time_map_2,
  s0_.lessons_type_map AS lessons_type_map_3,
  s0_.matrix AS matrix_4,
  s0_.removed_lessons AS removed_lessons_5,
  s0_.first_name AS first_name_6,
  s0_.last_name AS last_name_7,
  s0_.age AS age_8,
  s0_.email AS email_9,
  s0_.surname AS surname_10,
  s0_.created_at AS created_at_11,
  s0_.updated_at AS updated_at_12,
  s0_.group_id AS group_id_13,
  s0_.user_id AS user_id_14
FROM
  student s0_
WHERE
  (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )
  AND (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )
  AND s0_.id IN (?, ?, ?)

SELECT s0_.id AS id_0, s0_.direction_sub_group_id AS direction_sub_group_id_1, s0_.lessons_time_map AS lessons_time_map_2, s0_.lessons_type_map AS lessons_type_map_3, s0_.matrix AS matrix_4, s0_.removed_lessons AS removed_lessons_5, s0_.first_name AS first_name_6, s0_.last_name AS last_name_7, s0_.age AS age_8, s0_.email AS email_9, s0_.surname AS surname_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.group_id AS group_id_13, s0_.user_id AS user_id_14 FROM student s0_ WHERE (LOWER(s0_.first_name || '') LIKE '%աննա%' OR LOWER(s0_.last_name || '') LIKE '%աննա%' OR LOWER(s0_.email || '') LIKE '%աննա%' OR LOWER(s0_.surname || '') LIKE '%աննա%') AND (LOWER(s0_.first_name || '') LIKE '%նիկ%' OR LOWER(s0_.last_name || '') LIKE '%նիկ%' OR LOWER(s0_.email || '') LIKE '%նիկ%' OR LOWER(s0_.surname || '') LIKE '%նիկ%') AND s0_.id IN (327, 880, 1018);

SELECT
  count(s0_.id) AS sclr_0
FROM
  student s0_
WHERE
  (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )
  AND (
    LOWER(s0_.first_name || '') LIKE ?
    OR LOWER(s0_.last_name || '') LIKE ?
    OR LOWER(s0_.email || '') LIKE ?
    OR LOWER(s0_.surname || '') LIKE ?
  )

SELECT count(s0_.id) AS sclr_0 FROM student s0_ WHERE (LOWER(s0_.first_name || '') LIKE '%աննա%' OR LOWER(s0_.last_name || '') LIKE '%աննա%' OR LOWER(s0_.email || '') LIKE '%աննա%' OR LOWER(s0_.surname || '') LIKE '%աննա%') AND (LOWER(s0_.first_name || '') LIKE '%նիկ%' OR LOWER(s0_.last_name || '') LIKE '%նիկ%' OR LOWER(s0_.email || '') LIKE '%նիկ%' OR LOWER(s0_.surname || '') LIKE '%նիկ%');

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number AS number_3,
  t0.matrix AS matrix_4,
  t0.m_id AS m_id_5,
  t0.group_id AS group_id_6,
  t0.lesson_id AS lesson_id_7,
  t0.type_class_id AS type_class_id_8,
  t0.group_direction_id AS group_direction_id_9
FROM
  sub_group t0
  INNER JOIN student_sub_group ON t0.id = student_sub_group.sub_group_id
WHERE
  student_sub_group.student_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.matrix AS matrix_4, t0.m_id AS m_id_5, t0.group_id AS group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.group_direction_id AS group_direction_id_9 FROM sub_group t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.sub_group_id WHERE student_sub_group.student_id = 327;

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
  INNER JOIN student_phase_group ON t0.id = student_phase_group.phase_group_id
WHERE
  student_phase_group.student_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 INNER JOIN student_phase_group ON t0.id = student_phase_group.phase_group_id WHERE student_phase_group.student_id = 327;

SELECT
  t0.id AS id_1,
  t0.duration_in_minutes AS duration_in_minutes_2,
  t0.length AS length_3,
  t0.tmp_count AS tmp_count_4,
  t0.start_time AS start_time_5,
  t0.end_time AS end_time_6,
  t0.group_ids AS group_ids_7,
  t0.sub_group_ids AS sub_group_ids_8,
  t0.phase_group_ids AS phase_group_ids_9,
  t0.ref_id AS ref_id_10,
  t0.phase_part AS phase_part_11,
  t0.group_id AS group_id_12,
  t0.sub_group_id AS sub_group_id_13,
  t0.lesson_id AS lesson_id_14,
  t0.department_id AS department_id_15,
  t0.teacher_id AS teacher_id_16,
  t0.phase_group_id AS phase_group_id_17,
  t0.room_id AS room_id_18,
  t0.selecting_class_time_id AS selecting_class_time_id_19,
  t0.type_class_id AS type_class_id_20
FROM
  class_time t0
  INNER JOIN student_class_time ON t0.id = student_class_time.class_time_id
WHERE
  student_class_time.student_id = ?

SELECT t0.id AS id_1, t0.duration_in_minutes AS duration_in_minutes_2, t0.length AS length_3, t0.tmp_count AS tmp_count_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.group_ids AS group_ids_7, t0.sub_group_ids AS sub_group_ids_8, t0.phase_group_ids AS phase_group_ids_9, t0.ref_id AS ref_id_10, t0.phase_part AS phase_part_11, t0.group_id AS group_id_12, t0.sub_group_id AS sub_group_id_13, t0.lesson_id AS lesson_id_14, t0.department_id AS department_id_15, t0.teacher_id AS teacher_id_16, t0.phase_group_id AS phase_group_id_17, t0.room_id AS room_id_18, t0.selecting_class_time_id AS selecting_class_time_id_19, t0.type_class_id AS type_class_id_20 FROM class_time t0 INNER JOIN student_class_time ON t0.id = student_class_time.class_time_id WHERE student_class_time.student_id = 327;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number AS number_3,
  t0.matrix AS matrix_4,
  t0.m_id AS m_id_5,
  t0.group_id AS group_id_6,
  t0.lesson_id AS lesson_id_7,
  t0.type_class_id AS type_class_id_8,
  t0.group_direction_id AS group_direction_id_9
FROM
  sub_group t0
  INNER JOIN student_sub_group ON t0.id = student_sub_group.sub_group_id
WHERE
  student_sub_group.student_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.matrix AS matrix_4, t0.m_id AS m_id_5, t0.group_id AS group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.group_direction_id AS group_direction_id_9 FROM sub_group t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.sub_group_id WHERE student_sub_group.student_id = 880;

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
  INNER JOIN student_phase_group ON t0.id = student_phase_group.phase_group_id
WHERE
  student_phase_group.student_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 INNER JOIN student_phase_group ON t0.id = student_phase_group.phase_group_id WHERE student_phase_group.student_id = 880;

SELECT
  t0.id AS id_1,
  t0.duration_in_minutes AS duration_in_minutes_2,
  t0.length AS length_3,
  t0.tmp_count AS tmp_count_4,
  t0.start_time AS start_time_5,
  t0.end_time AS end_time_6,
  t0.group_ids AS group_ids_7,
  t0.sub_group_ids AS sub_group_ids_8,
  t0.phase_group_ids AS phase_group_ids_9,
  t0.ref_id AS ref_id_10,
  t0.phase_part AS phase_part_11,
  t0.group_id AS group_id_12,
  t0.sub_group_id AS sub_group_id_13,
  t0.lesson_id AS lesson_id_14,
  t0.department_id AS department_id_15,
  t0.teacher_id AS teacher_id_16,
  t0.phase_group_id AS phase_group_id_17,
  t0.room_id AS room_id_18,
  t0.selecting_class_time_id AS selecting_class_time_id_19,
  t0.type_class_id AS type_class_id_20
FROM
  class_time t0
  INNER JOIN student_class_time ON t0.id = student_class_time.class_time_id
WHERE
  student_class_time.student_id = ?

SELECT t0.id AS id_1, t0.duration_in_minutes AS duration_in_minutes_2, t0.length AS length_3, t0.tmp_count AS tmp_count_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.group_ids AS group_ids_7, t0.sub_group_ids AS sub_group_ids_8, t0.phase_group_ids AS phase_group_ids_9, t0.ref_id AS ref_id_10, t0.phase_part AS phase_part_11, t0.group_id AS group_id_12, t0.sub_group_id AS sub_group_id_13, t0.lesson_id AS lesson_id_14, t0.department_id AS department_id_15, t0.teacher_id AS teacher_id_16, t0.phase_group_id AS phase_group_id_17, t0.room_id AS room_id_18, t0.selecting_class_time_id AS selecting_class_time_id_19, t0.type_class_id AS type_class_id_20 FROM class_time t0 INNER JOIN student_class_time ON t0.id = student_class_time.class_time_id WHERE student_class_time.student_id = 880;

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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number AS number_3,
  t0.matrix AS matrix_4,
  t0.m_id AS m_id_5,
  t0.group_id AS group_id_6,
  t0.lesson_id AS lesson_id_7,
  t0.type_class_id AS type_class_id_8,
  t0.group_direction_id AS group_direction_id_9
FROM
  sub_group t0
  INNER JOIN student_sub_group ON t0.id = student_sub_group.sub_group_id
WHERE
  student_sub_group.student_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.matrix AS matrix_4, t0.m_id AS m_id_5, t0.group_id AS group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.group_direction_id AS group_direction_id_9 FROM sub_group t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.sub_group_id WHERE student_sub_group.student_id = 1018;

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
  INNER JOIN student_phase_group ON t0.id = student_phase_group.phase_group_id
WHERE
  student_phase_group.student_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 INNER JOIN student_phase_group ON t0.id = student_phase_group.phase_group_id WHERE student_phase_group.student_id = 1018;

SELECT
  t0.id AS id_1,
  t0.duration_in_minutes AS duration_in_minutes_2,
  t0.length AS length_3,
  t0.tmp_count AS tmp_count_4,
  t0.start_time AS start_time_5,
  t0.end_time AS end_time_6,
  t0.group_ids AS group_ids_7,
  t0.sub_group_ids AS sub_group_ids_8,
  t0.phase_group_ids AS phase_group_ids_9,
  t0.ref_id AS ref_id_10,
  t0.phase_part AS phase_part_11,
  t0.group_id AS group_id_12,
  t0.sub_group_id AS sub_group_id_13,
  t0.lesson_id AS lesson_id_14,
  t0.department_id AS department_id_15,
  t0.teacher_id AS teacher_id_16,
  t0.phase_group_id AS phase_group_id_17,
  t0.room_id AS room_id_18,
  t0.selecting_class_time_id AS selecting_class_time_id_19,
  t0.type_class_id AS type_class_id_20
FROM
  class_time t0
  INNER JOIN student_class_time ON t0.id = student_class_time.class_time_id
WHERE
  student_class_time.student_id = ?

SELECT t0.id AS id_1, t0.duration_in_minutes AS duration_in_minutes_2, t0.length AS length_3, t0.tmp_count AS tmp_count_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.group_ids AS group_ids_7, t0.sub_group_ids AS sub_group_ids_8, t0.phase_group_ids AS phase_group_ids_9, t0.ref_id AS ref_id_10, t0.phase_part AS phase_part_11, t0.group_id AS group_id_12, t0.sub_group_id AS sub_group_id_13, t0.lesson_id AS lesson_id_14, t0.department_id AS department_id_15, t0.teacher_id AS teacher_id_16, t0.phase_group_id AS phase_group_id_17, t0.room_id AS room_id_18, t0.selecting_class_time_id AS selecting_class_time_id_19, t0.type_class_id AS type_class_id_20 FROM class_time t0 INNER JOIN student_class_time ON t0.id = student_class_time.class_time_id WHERE student_class_time.student_id = 1018;