Symfony Profiler

SET
  search_path TO bws_dev_hr

SET search_path TO bws_dev_hr;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.uuid AS uuid_5,
  t0.data AS data_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.active AS active_9,
  t0.middle_name AS middle_name_10,
  t0.avatar AS avatar_11,
  t0.changed AS changed_12,
  t0.guardian AS guardian_13,
  t0.logged_in_at AS logged_in_at_14,
  t0.first_login_at AS first_login_at_15,
  t0.username AS username_16,
  t0.birthdate AS birthdate_17,
  t0.student_password_is_set AS student_password_is_set_18,
  t0.internal_registration AS internal_registration_19,
  t0.organisations AS organisations_20,
  t0.cookies_compliance AS cookies_compliance_21,
  t0.full_time_access AS full_time_access_22,
  t0.created_at AS created_at_23,
  t0.login_token AS login_token_24,
  t25.id AS id_26,
  t25.mobile_phone AS mobile_phone_27,
  t25.token AS token_28,
  t25.user_id AS user_id_29,
  t30.id AS id_31,
  t30.token AS token_32,
  t30.created_at AS created_at_33,
  t30.user_id AS user_id_34,
  t35.id AS id_36,
  t35.max_devices AS max_devices_37,
  t35.expire_at AS expire_at_38,
  t35.user_id AS user_id_39,
  t40.id AS id_41,
  t40.token AS token_42,
  t40.data AS data_43,
  t40.is_confirmed AS is_confirmed_44,
  t40.changed_at AS changed_at_45,
  t40.email AS email_46,
  t40.user_id AS user_id_47,
  t48.id AS id_49,
  t48.external_id AS external_id_50,
  t48.type AS type_51,
  t48.status AS status_52,
  t48.changed_at AS changed_at_53,
  t48.expiry_at AS expiry_at_54,
  t48.user_id AS user_id_55,
  t56.id AS id_57,
  t56.aliases AS aliases_58,
  t56.created_at AS created_at_59,
  t56.updated_at AS updated_at_60,
  t56.user_id AS user_id_61
FROM
  user_entity_table t0
  LEFT JOIN verified_mobilephone t25 ON t25.user_id = t0.id
  LEFT JOIN registration t30 ON t30.user_id = t0.id
  LEFT JOIN user_devices_settings t35 ON t35.user_id = t0.id
  LEFT JOIN external_registration t40 ON t40.user_id = t0.id
  LEFT JOIN external_user_connection t48 ON t48.user_id = t0.id
  LEFT JOIN ext_user_aliases t56 ON t56.user_id = t0.id
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.uuid AS uuid_5, t0.data AS data_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.active AS active_9, t0.middle_name AS middle_name_10, t0.avatar AS avatar_11, t0.changed AS changed_12, t0.guardian AS guardian_13, t0.logged_in_at AS logged_in_at_14, t0.first_login_at AS first_login_at_15, t0.username AS username_16, t0.birthdate AS birthdate_17, t0.student_password_is_set AS student_password_is_set_18, t0.internal_registration AS internal_registration_19, t0.organisations AS organisations_20, t0.cookies_compliance AS cookies_compliance_21, t0.full_time_access AS full_time_access_22, t0.created_at AS created_at_23, t0.login_token AS login_token_24, t25.id AS id_26, t25.mobile_phone AS mobile_phone_27, t25.token AS token_28, t25.user_id AS user_id_29, t30.id AS id_31, t30.token AS token_32, t30.created_at AS created_at_33, t30.user_id AS user_id_34, t35.id AS id_36, t35.max_devices AS max_devices_37, t35.expire_at AS expire_at_38, t35.user_id AS user_id_39, t40.id AS id_41, t40.token AS token_42, t40.data AS data_43, t40.is_confirmed AS is_confirmed_44, t40.changed_at AS changed_at_45, t40.email AS email_46, t40.user_id AS user_id_47, t48.id AS id_49, t48.external_id AS external_id_50, t48.type AS type_51, t48.status AS status_52, t48.changed_at AS changed_at_53, t48.expiry_at AS expiry_at_54, t48.user_id AS user_id_55, t56.id AS id_57, t56.aliases AS aliases_58, t56.created_at AS created_at_59, t56.updated_at AS updated_at_60, t56.user_id AS user_id_61 FROM user_entity_table t0 LEFT JOIN verified_mobilephone t25 ON t25.user_id = t0.id LEFT JOIN registration t30 ON t30.user_id = t0.id LEFT JOIN user_devices_settings t35 ON t35.user_id = t0.id LEFT JOIN external_registration t40 ON t40.user_id = t0.id LEFT JOIN external_user_connection t48 ON t48.user_id = t0.id LEFT JOIN ext_user_aliases t56 ON t56.user_id = t0.id WHERE t0.uuid = '60d32cb9-5555-458f-a65c-a05427202f9c' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.beginning_at AS beginning_at_2,
  s0_.ending_at AS ending_at_3
FROM
  school_year s0_
WHERE
  s0_.beginning_at < ?
  AND s0_.ending_at > ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.beginning_at AS beginning_at_2, s0_.ending_at AS ending_at_3 FROM school_year s0_ WHERE s0_.beginning_at < '2026-04-02 10:37:15' AND s0_.ending_at > '2026-04-02 10:37:15';

SELECT
  c0_.id AS id_0,
  c0_.grade AS grade_1,
  c0_.letter AS letter_2,
  c0_.custom_group AS custom_group_3,
  t1_.id AS id_4,
  c0_.school_year_id AS school_year_id_5,
  c0_.school_id AS school_id_6,
  t1_.teacher_id AS teacher_id_7,
  t1_.classroom_id AS classroom_id_8
FROM
  classroom c0_
  LEFT JOIN teacher_classroom t1_ ON c0_.id = t1_.classroom_id
  LEFT JOIN teacher_classroom_student t2_ ON t1_.id = t2_.teacher_classroom_id
WHERE
  c0_.school_year_id = ?
  AND t2_.user_id = ?
ORDER BY
  c0_.school_id ASC,
  c0_.grade ASC,
  c0_.letter ASC

SELECT c0_.id AS id_0, c0_.grade AS grade_1, c0_.letter AS letter_2, c0_.custom_group AS custom_group_3, t1_.id AS id_4, c0_.school_year_id AS school_year_id_5, c0_.school_id AS school_id_6, t1_.teacher_id AS teacher_id_7, t1_.classroom_id AS classroom_id_8 FROM classroom c0_ LEFT JOIN teacher_classroom t1_ ON c0_.id = t1_.classroom_id LEFT JOIN teacher_classroom_student t2_ ON t1_.id = t2_.teacher_classroom_id WHERE c0_.school_year_id = 2 AND t2_.user_id = 20 ORDER BY c0_.school_id ASC, c0_.grade ASC, c0_.letter ASC;

SELECT
  c0_.id AS id_0,
  c0_.grade AS grade_1,
  c0_.letter AS letter_2,
  c0_.custom_group AS custom_group_3,
  t1_.id AS id_4,
  c0_.school_year_id AS school_year_id_5,
  c0_.school_id AS school_id_6,
  t1_.teacher_id AS teacher_id_7,
  t1_.classroom_id AS classroom_id_8
FROM
  classroom c0_
  LEFT JOIN teacher_classroom t1_ ON c0_.id = t1_.classroom_id
WHERE
  c0_.school_year_id = ?
  AND t1_.teacher_id = ?
ORDER BY
  c0_.school_id ASC,
  c0_.grade ASC,
  c0_.letter ASC

SELECT c0_.id AS id_0, c0_.grade AS grade_1, c0_.letter AS letter_2, c0_.custom_group AS custom_group_3, t1_.id AS id_4, c0_.school_year_id AS school_year_id_5, c0_.school_id AS school_id_6, t1_.teacher_id AS teacher_id_7, t1_.classroom_id AS classroom_id_8 FROM classroom c0_ LEFT JOIN teacher_classroom t1_ ON c0_.id = t1_.classroom_id WHERE c0_.school_year_id = 2 AND t1_.teacher_id = 20 ORDER BY c0_.school_id ASC, c0_.grade ASC, c0_.letter ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.teacher_classroom_id AS teacher_classroom_id_3,
  t0.user_id AS user_id_4
FROM
  teacher_classroom_student t0
WHERE
  t0.teacher_classroom_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.teacher_classroom_id AS teacher_classroom_id_3, t0.user_id AS user_id_4 FROM teacher_classroom_student t0 WHERE t0.teacher_classroom_id = 43;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.city AS city_3,
  t0.county AS county_4,
  t0.sid AS sid_5
FROM
  school t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.county AS county_4, t0.sid AS sid_5 FROM school t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.teacher_classroom_id AS teacher_classroom_id_3,
  t0.user_id AS user_id_4
FROM
  teacher_classroom_student t0
WHERE
  t0.teacher_classroom_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.teacher_classroom_id AS teacher_classroom_id_3, t0.user_id AS user_id_4 FROM teacher_classroom_student t0 WHERE t0.teacher_classroom_id = 55;