Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.employee_code AS employee_code_7,
  t0.hire_date AS hire_date_8,
  t0.termination_date AS termination_date_9,
  t0.is_active AS is_active_10,
  t0.phone AS phone_11,
  t0.job_title AS job_title_12,
  t0.annual_leave_allowance AS annual_leave_allowance_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.department_id AS department_id_16,
  t0.work_schedule_template_id AS work_schedule_template_id_17,
  t0.job_position_id AS job_position_id_18
FROM
  kronos_user t0
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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.employee_code AS employee_code_7, t0.hire_date AS hire_date_8, t0.termination_date AS termination_date_9, t0.is_active AS is_active_10, t0.phone AS phone_11, t0.job_title AS job_title_12, t0.annual_leave_allowance AS annual_leave_allowance_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.department_id AS department_id_16, t0.work_schedule_template_id AS work_schedule_template_id_17, t0.job_position_id AS job_position_id_18 FROM kronos_user t0 WHERE t0.id = 1;

SELECT
  k0_.id AS id_0,
  k0_.type AS type_1,
  k0_.event_time AS event_time_2,
  k0_.location AS location_3,
  k0_.raw_data AS raw_data_4,
  k0_.is_processed AS is_processed_5,
  k0_.created_at AS created_at_6,
  k1_.id AS id_7,
  k1_.email AS email_8,
  k1_.roles AS roles_9,
  k1_.password AS password_10,
  k1_.first_name AS first_name_11,
  k1_.last_name AS last_name_12,
  k1_.employee_code AS employee_code_13,
  k1_.hire_date AS hire_date_14,
  k1_.termination_date AS termination_date_15,
  k1_.is_active AS is_active_16,
  k1_.phone AS phone_17,
  k1_.job_title AS job_title_18,
  k1_.annual_leave_allowance AS annual_leave_allowance_19,
  k1_.created_at AS created_at_20,
  k1_.updated_at AS updated_at_21,
  k2_.id AS id_22,
  k2_.name AS name_23,
  k2_.external_code AS external_code_24,
  k2_.description AS description_25,
  k2_.is_active AS is_active_26,
  k0_.user_id AS user_id_27,
  k0_.data_source_id AS data_source_id_28,
  k0_.external_identifier_id AS external_identifier_id_29,
  k0_.access_point_id AS access_point_id_30,
  k1_.department_id AS department_id_31,
  k1_.work_schedule_template_id AS work_schedule_template_id_32,
  k1_.job_position_id AS job_position_id_33,
  k2_.data_source_id AS data_source_id_34
FROM
  kronos_movement_event k0_
  LEFT JOIN kronos_user k1_ ON k0_.user_id = k1_.id
  LEFT JOIN kronos_access_point k2_ ON k0_.access_point_id = k2_.id
WHERE
  k0_.access_point_id = ?
  AND k0_.event_time >= ?
  AND k0_.event_time <= ?
ORDER BY
  k0_.event_time DESC
LIMIT
  500

SELECT k0_.id AS id_0, k0_.type AS type_1, k0_.event_time AS event_time_2, k0_.location AS location_3, k0_.raw_data AS raw_data_4, k0_.is_processed AS is_processed_5, k0_.created_at AS created_at_6, k1_.id AS id_7, k1_.email AS email_8, k1_.roles AS roles_9, k1_.password AS password_10, k1_.first_name AS first_name_11, k1_.last_name AS last_name_12, k1_.employee_code AS employee_code_13, k1_.hire_date AS hire_date_14, k1_.termination_date AS termination_date_15, k1_.is_active AS is_active_16, k1_.phone AS phone_17, k1_.job_title AS job_title_18, k1_.annual_leave_allowance AS annual_leave_allowance_19, k1_.created_at AS created_at_20, k1_.updated_at AS updated_at_21, k2_.id AS id_22, k2_.name AS name_23, k2_.external_code AS external_code_24, k2_.description AS description_25, k2_.is_active AS is_active_26, k0_.user_id AS user_id_27, k0_.data_source_id AS data_source_id_28, k0_.external_identifier_id AS external_identifier_id_29, k0_.access_point_id AS access_point_id_30, k1_.department_id AS department_id_31, k1_.work_schedule_template_id AS work_schedule_template_id_32, k1_.job_position_id AS job_position_id_33, k2_.data_source_id AS data_source_id_34 FROM kronos_movement_event k0_ LEFT JOIN kronos_user k1_ ON k0_.user_id = k1_.id LEFT JOIN kronos_access_point k2_ ON k0_.access_point_id = k2_.id WHERE k0_.access_point_id = '80' AND k0_.event_time >= '2026-04-01 00:00:00' AND k0_.event_time <= '2026-04-10 23:59:59' ORDER BY k0_.event_time DESC LIMIT 500;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.employee_code AS employee_code_7,
  t0.hire_date AS hire_date_8,
  t0.termination_date AS termination_date_9,
  t0.is_active AS is_active_10,
  t0.phone AS phone_11,
  t0.job_title AS job_title_12,
  t0.annual_leave_allowance AS annual_leave_allowance_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.department_id AS department_id_16,
  t0.work_schedule_template_id AS work_schedule_template_id_17,
  t0.job_position_id AS job_position_id_18
FROM
  kronos_user t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.last_name ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.employee_code AS employee_code_7, t0.hire_date AS hire_date_8, t0.termination_date AS termination_date_9, t0.is_active AS is_active_10, t0.phone AS phone_11, t0.job_title AS job_title_12, t0.annual_leave_allowance AS annual_leave_allowance_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.department_id AS department_id_16, t0.work_schedule_template_id AS work_schedule_template_id_17, t0.job_position_id AS job_position_id_18 FROM kronos_user t0 WHERE t0.is_active = 1 ORDER BY t0.last_name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.external_code AS external_code_3,
  t0.description AS description_4,
  t0.is_active AS is_active_5,
  t0.data_source_id AS data_source_id_6
FROM
  kronos_access_point t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.external_code AS external_code_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.data_source_id AS data_source_id_6 FROM kronos_access_point t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;