Symfony Profiler

"COMMIT"

"COMMIT";

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:51:\\\"Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\\":2:{s:60:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0message\\\";O:39:\\\"Symfony\\\\Bridge\\\\Twig\\\\Mime\\\\TemplatedEmail\\\":5:{i:0;s:30:\\\"emails/leave-request.html.twig\\\";i:1;N;i:2;a:9:{s:9:\\\"firstname\\\";s:10:\\\"christophe\\\";s:8:\\\"lastname\\\";s:7:\\\"lucette\\\";s:11:\\\"emailMessge\\\";s:19:\\\"added a sick dayoff\\\";s:9:\\\"startDate\\\";s:11:\\\"11 Jun 2026\\\";s:7:\\\"endDate\\\";s:11:\\\"11 Jun 2026\\\";s:5:\\\"count\\\";i:1;s:9:\\\"leavetype\\\";s:4:\\\"sick\\\";s:6:\\\"reason\\\";s:4:\\\"sick\\\";s:7:\\\"empData\\\";a:13:{s:9:\\\"firstname\\\";s:10:\\\"Stéphanie\\\";s:8:\\\"lastname\\\";s:8:\\\"Tickfine\\\";s:12:\\\"scheduleUsed\\\";d:8;s:10:\\\"casualUsed\\\";d:6.5;s:16:\\\"pastScheduleUsed\\\";d:0;s:14:\\\"pastCasualUsed\\\";d:0;s:17:\\\"scheduleRemaining\\\";s:4:\\\"14.0\\\";s:15:\\\"casualRemaining\\\";s:3:\\\"8.5\\\";s:17:\\\"totalScheduleUsed\\\";d:8;s:15:\\\"totalCasualUsed\\\";d:6.5;s:13:\\\"totalSchedule\\\";s:4:\\\"22.0\\\";s:11:\\\"totalCasual\\\";s:4:\\\"15.0\\\";s:7:\\\"leaveid\\\";N;}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\\":2:{s:46:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0headers\\\";a:4:{s:4:\\\"from\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:4:\\\"From\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:22:\\\"dayoff@pinkart-ltd.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}s:2:\\\"to\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:2:\\\"To\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:2:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:22:\\\"ajalon@pinkart-ltd.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}i:1;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:25:\\\"stephanie@pinkart-ltd.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}s:7:\\\"subject\\\";a:1:{i:0;O:48:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:7:\\\"Subject\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:55:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\0value\\\";s:20:\\\"Added a sick day off\\\";}}s:3:\\\"bcc\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:3:\\\"Bcc\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:22:\\\"dayoff@pinkart-ltd.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}}s:49:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0lineLength\\\";i:76;}i:1;N;}}i:4;N;}s:61:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0envelope\\\";N;}}', '[]', 'default', '2026-06-11 05:20:23', '2026-06-11 05:20:23');

SELECT
  l0_.slug AS slug_0
FROM
  leaves l0_
WHERE
  l0_.slug LIKE ?

SELECT l0_.slug AS slug_0 FROM leaves l0_ WHERE l0_.slug LIKE '%';

SELECT
  o0_.date AS date_0,
  o0_.name AS name_1
FROM
  official_holiday o0_
WHERE
  o0_.date >= ?
  AND o0_.date < ?

SELECT o0_.date AS date_0, o0_.name AS name_1 FROM official_holiday o0_ WHERE o0_.date >= '2026-06-11' AND o0_.date < '2026-06-12';

INSERT INTO leaves (
  start_date, end_date, count, approved_start_date,
  approved_end_date, approved_count,
  reason, reject_reason, is_half_day,
  is_schedule_leave, category, is_active,
  type, certificate, status, is_manager_added,
  is_ceo_added, is_fingerprint_leave,
  created, updated, slug, emp_id, approver_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO leaves (start_date, end_date, count, approved_start_date, approved_end_date, approved_count, reason, reject_reason, is_half_day, is_schedule_leave, category, is_active, type, certificate, status, is_manager_added, is_ceo_added, is_fingerprint_leave, created, updated, slug, emp_id, approver_id) VALUES ('2026-06-11', '2026-06-11', '1', NULL, NULL, '0.0', 'sick', '', 0, 0, 'annual', 0, 'sick', NULL, 2, 1, 0, 0, '2026-06-11 09:20:22', '2026-06-11 09:20:22', '-811', 67, 32);

SELECT
  t0.id AS id_1,
  t0.message AS message_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.created AS created_5,
  t0.updated AS updated_6,
  t0.leave_id AS leave_id_7
FROM
  notification t0
  INNER JOIN notify_receiver ON t0.id = notify_receiver.notify_id
WHERE
  notify_receiver.receiver_id = ?

SELECT t0.id AS id_1, t0.message AS message_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.created AS created_5, t0.updated AS updated_6, t0.leave_id AS leave_id_7 FROM notification t0 INNER JOIN notify_receiver ON t0.id = notify_receiver.notify_id WHERE notify_receiver.receiver_id = 58;

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

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.emp_id = 67;

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.start_date = ?
  AND t0.end_date = ?
  AND t0.emp_id = ?
LIMIT
  1

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.start_date = '2026-06-11' AND t0.end_date = '2026-06-11' AND t0.emp_id = 67 LIMIT 1;

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 = 'christophe' OR e0_.email = 'christophe';

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

INSERT INTO notify_receiver (receiver_id, notify_id)
VALUES
  (?, ?)

INSERT INTO notify_receiver (receiver_id, notify_id) VALUES (67, 6185);

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_.roles LIKE ?
  OR e0_.roles LIKE ?

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_.roles LIKE '%\"ROLE_MANAGER\"%' OR e0_.roles LIKE '%\"ROLE_CEO\"%';

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.username AS username_5,
  t0.fingerprintid AS fingerprintid_6,
  t0.fingerprintname AS fingerprintname_7,
  t0.password AS password_8,
  t0.phone AS phone_9,
  t0.fixedline AS fixedline_10,
  t0.roles AS roles_11,
  t0.status AS status_12,
  t0.is_vacation_allowed AS is_vacation_allowed_13,
  t0.schedule_used AS schedule_used_14,
  t0.casual_used AS casual_used_15,
  t0.vacation_used AS vacation_used_16,
  t0.wfh_used AS wfh_used_17,
  t0.past_schedule_used AS past_schedule_used_18,
  t0.past_casual_used AS past_casual_used_19,
  t0.last_year_schedule_used AS last_year_schedule_used_20,
  t0.last_year_casual_used AS last_year_casual_used_21,
  t0.schedule_remaining AS schedule_remaining_22,
  t0.casual_remaining AS casual_remaining_23,
  t0.vacation_remaining AS vacation_remaining_24,
  t0.total_schedule_used AS total_schedule_used_25,
  t0.total_casual_used AS total_casual_used_26,
  t0.total_schedule AS total_schedule_27,
  t0.total_casual AS total_casual_28,
  t0.created AS created_29,
  t0.updated AS updated_30,
  t0.slug AS slug_31,
  t0.team_id AS team_id_32,
  t33.id AS id_34,
  t33.name AS name_35,
  t33.email AS email_36,
  t33.password AS password_37,
  t33.created AS created_38,
  t33.updated AS updated_39,
  t33.slug AS slug_40,
  t33.employ_id AS employ_id_41,
  t33.inviter_id AS inviter_id_42
FROM
  employee t0
  LEFT JOIN invite t33 ON t33.employ_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.username AS username_5, t0.fingerprintid AS fingerprintid_6, t0.fingerprintname AS fingerprintname_7, t0.password AS password_8, t0.phone AS phone_9, t0.fixedline AS fixedline_10, t0.roles AS roles_11, t0.status AS status_12, t0.is_vacation_allowed AS is_vacation_allowed_13, t0.schedule_used AS schedule_used_14, t0.casual_used AS casual_used_15, t0.vacation_used AS vacation_used_16, t0.wfh_used AS wfh_used_17, t0.past_schedule_used AS past_schedule_used_18, t0.past_casual_used AS past_casual_used_19, t0.last_year_schedule_used AS last_year_schedule_used_20, t0.last_year_casual_used AS last_year_casual_used_21, t0.schedule_remaining AS schedule_remaining_22, t0.casual_remaining AS casual_remaining_23, t0.vacation_remaining AS vacation_remaining_24, t0.total_schedule_used AS total_schedule_used_25, t0.total_casual_used AS total_casual_used_26, t0.total_schedule AS total_schedule_27, t0.total_casual AS total_casual_28, t0.created AS created_29, t0.updated AS updated_30, t0.slug AS slug_31, t0.team_id AS team_id_32, t33.id AS id_34, t33.name AS name_35, t33.email AS email_36, t33.password AS password_37, t33.created AS created_38, t33.updated AS updated_39, t33.slug AS slug_40, t33.employ_id AS employ_id_41, t33.inviter_id AS inviter_id_42 FROM employee t0 LEFT JOIN invite t33 ON t33.employ_id = t0.id WHERE t0.id = 67 LIMIT 1;

UPDATE
  employee
SET
  casual_used = ?,
  casual_remaining = ?,
  total_casual_used = ?,
  updated = ?
WHERE
  id = ?

UPDATE employee SET casual_used = '6.5', casual_remaining = '8.5', total_casual_used = '6.5', updated = '2026-06-11 09:20:22' WHERE id = 67;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO notification (
  message, firstname, lastname, created,
  updated, leave_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO notification (message, firstname, lastname, created, updated, leave_id) VALUES (' added a sick day off', 'christophe', 'lucette', '2026-06-11 09:20:22', '2026-06-11 09:20:22', 6224);

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
WHERE
  t0.id = ?

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 WHERE t0.id = 24;

UPDATE
  employee
SET
  updated = ?
WHERE
  id = ?

UPDATE employee SET updated = '2026-06-11 09:20:22' WHERE id = 58;