Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.firstname AS firstname_1,
  e0_.lastname AS lastname_2,
  e0_.email AS email_3,
  e0_.username AS username_4,
  e0_.fingerprintid AS fingerprintid_5,
  e0_.fingerprintname AS fingerprintname_6,
  e0_.password AS password_7,
  e0_.phone AS phone_8,
  e0_.fixedline AS fixedline_9,
  e0_.roles AS roles_10,
  e0_.status AS status_11,
  e0_.is_vacation_allowed AS is_vacation_allowed_12,
  e0_.schedule_used AS schedule_used_13,
  e0_.casual_used AS casual_used_14,
  e0_.vacation_used AS vacation_used_15,
  e0_.wfh_used AS wfh_used_16,
  e0_.past_schedule_used AS past_schedule_used_17,
  e0_.past_casual_used AS past_casual_used_18,
  e0_.last_year_schedule_used AS last_year_schedule_used_19,
  e0_.last_year_casual_used AS last_year_casual_used_20,
  e0_.schedule_remaining AS schedule_remaining_21,
  e0_.casual_remaining AS casual_remaining_22,
  e0_.vacation_remaining AS vacation_remaining_23,
  e0_.total_schedule_used AS total_schedule_used_24,
  e0_.total_casual_used AS total_casual_used_25,
  e0_.total_schedule AS total_schedule_26,
  e0_.total_casual AS total_casual_27,
  e0_.created AS created_28,
  e0_.updated AS updated_29,
  e0_.slug AS slug_30,
  e0_.team_id AS team_id_31
FROM
  employee e0_
WHERE
  e0_.username = ?
  OR e0_.email = ?

SELECT e0_.id AS id_0, e0_.firstname AS firstname_1, e0_.lastname AS lastname_2, e0_.email AS email_3, e0_.username AS username_4, e0_.fingerprintid AS fingerprintid_5, e0_.fingerprintname AS fingerprintname_6, e0_.password AS password_7, e0_.phone AS phone_8, e0_.fixedline AS fixedline_9, e0_.roles AS roles_10, e0_.status AS status_11, e0_.is_vacation_allowed AS is_vacation_allowed_12, e0_.schedule_used AS schedule_used_13, e0_.casual_used AS casual_used_14, e0_.vacation_used AS vacation_used_15, e0_.wfh_used AS wfh_used_16, e0_.past_schedule_used AS past_schedule_used_17, e0_.past_casual_used AS past_casual_used_18, e0_.last_year_schedule_used AS last_year_schedule_used_19, e0_.last_year_casual_used AS last_year_casual_used_20, e0_.schedule_remaining AS schedule_remaining_21, e0_.casual_remaining AS casual_remaining_22, e0_.vacation_remaining AS vacation_remaining_23, e0_.total_schedule_used AS total_schedule_used_24, e0_.total_casual_used AS total_casual_used_25, e0_.total_schedule AS total_schedule_26, e0_.total_casual AS total_casual_27, e0_.created AS created_28, e0_.updated AS updated_29, e0_.slug AS slug_30, e0_.team_id AS team_id_31 FROM employee e0_ WHERE e0_.username = 'joan' OR e0_.email = 'joan';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.created AS created_5,
  t0.updated AS updated_6,
  t0.slug AS slug_7,
  t0.employ_id AS employ_id_8,
  t0.inviter_id AS inviter_id_9
FROM
  invite t0
WHERE
  t0.employ_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.password AS password_4, t0.created AS created_5, t0.updated AS updated_6, t0.slug AS slug_7, t0.employ_id AS employ_id_8, t0.inviter_id AS inviter_id_9 FROM invite t0 WHERE t0.employ_id = 100;

SELECT
  t0.id AS id_1,
  t0.schedule AS schedule_2,
  t0.casual AS casual_3,
  t0.vacation AS vacation_4,
  t0.vacation_start_date AS vacation_start_date_5,
  t0.vacation_end_date AS vacation_end_date_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.slug AS slug_9
FROM
  leave_settings t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.schedule AS schedule_2, t0.casual AS casual_3, t0.vacation AS vacation_4, t0.vacation_start_date AS vacation_start_date_5, t0.vacation_end_date AS vacation_end_date_6, t0.created AS created_7, t0.updated AS updated_8, t0.slug AS slug_9 FROM leave_settings t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.date AS date_2,
  o0_.created AS created_3,
  o0_.updated AS updated_4
FROM
  official_holiday o0_
WHERE
  o0_.date >= ?
  AND o0_.date <= ?

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.date AS date_2, o0_.created AS created_3, o0_.updated AS updated_4 FROM official_holiday o0_ WHERE o0_.date >= '2024-01-11' AND o0_.date <= '2026-01-10';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.slug AS slug_6
FROM
  status t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.created AS created_4, t0.updated AS updated_5, t0.slug AS slug_6 FROM status t0;

SELECT
  te.id AS id,
  te.message AS message,
  te.firstname AS firstname,
  te.lastname AS lastname,
  te.created AS created,
  te.updated AS updated,
  te.leave_id AS leave_id
FROM
  notification te
  JOIN notify_receiver t ON t.notify_id = te.id
WHERE
  t.receiver_id = ?
ORDER BY
  created DESC
LIMIT
  10

SELECT te.id AS id, te.message AS message, te.firstname AS firstname, te.lastname AS lastname, te.created AS created, te.updated AS updated, te.leave_id AS leave_id FROM notification te JOIN notify_receiver t ON t.notify_id = te.id WHERE t.receiver_id = 100 ORDER BY created DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.count AS count_4,
  t0.approved_start_date AS approved_start_date_5,
  t0.approved_end_date AS approved_end_date_6,
  t0.approved_count AS approved_count_7,
  t0.reason AS reason_8,
  t0.reject_reason AS reject_reason_9,
  t0.is_half_day AS is_half_day_10,
  t0.is_schedule_leave AS is_schedule_leave_11,
  t0.category AS category_12,
  t0.is_active AS is_active_13,
  t0.type AS type_14,
  t0.certificate AS certificate_15,
  t0.status AS status_16,
  t0.is_manager_added AS is_manager_added_17,
  t0.is_ceo_added AS is_ceo_added_18,
  t0.is_fingerprint_leave AS is_fingerprint_leave_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.slug AS slug_22,
  t0.emp_id AS emp_id_23,
  t0.approver_id AS approver_id_24
FROM
  leaves t0
WHERE
  t0.status IN (?, ?, ?, ?)
  AND t0.emp_id = ?
ORDER BY
  t0.updated DESC
LIMIT
  10

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.count AS count_4, t0.approved_start_date AS approved_start_date_5, t0.approved_end_date AS approved_end_date_6, t0.approved_count AS approved_count_7, t0.reason AS reason_8, t0.reject_reason AS reject_reason_9, t0.is_half_day AS is_half_day_10, t0.is_schedule_leave AS is_schedule_leave_11, t0.category AS category_12, t0.is_active AS is_active_13, t0.type AS type_14, t0.certificate AS certificate_15, t0.status AS status_16, t0.is_manager_added AS is_manager_added_17, t0.is_ceo_added AS is_ceo_added_18, t0.is_fingerprint_leave AS is_fingerprint_leave_19, t0.created AS created_20, t0.updated AS updated_21, t0.slug AS slug_22, t0.emp_id AS emp_id_23, t0.approver_id AS approver_id_24 FROM leaves t0 WHERE t0.status IN (2, 3, 4, 5) AND t0.emp_id = 100 ORDER BY t0.updated DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created AS created_3,
  t0.updated AS updated_4,
  t0.slug AS slug_5,
  t0.agency_id AS agency_id_6,
  t0.manager_id AS manager_id_7
FROM
  grp_team t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.created AS created_3, t0.updated AS updated_4, t0.slug AS slug_5, t0.agency_id AS agency_id_6, t0.manager_id AS manager_id_7 FROM grp_team t0;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 5632;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 5633;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 5631;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 5628;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 5629;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 5630;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 4948;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 4949;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 4937;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.updated AS updated_4,
  t0.leave_id AS leave_id_5
FROM
  certificates t0
WHERE
  t0.leave_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.updated AS updated_4, t0.leave_id AS leave_id_5 FROM certificates t0 WHERE t0.leave_id = 4938;