[2025-07-04 16:06:07] SELECT b.is_holiday sch_holiday, c.is_holiday d_holiday, d.is_lecturer, d.annual_leave_count,
				   a.is_schedule_work, 
				   b.start_time sch_start_time, b.end_time sch_end_time, b.start_day sch_start_day, b.end_day sch_end_day,
				   c.start_time d_start_time, c.end_time d_end_time, c.start_day d_start_day, c.end_day d_end_day
				   FROM db_hris.t_schedule_emp a
				   LEFT JOIN db_hris.m_schedule_work_dt b ON a.schedule_work_id = b.schedule_work_id
				   AND b.start_day = (DAYOFWEEK(DATE_ADD('2025-05-19', INTERVAL 10 DAY)))
				   LEFT JOIN db_hris.t_schedule_emp_dt c ON c.schedule_emp_id = a.id
				   AND c.start_day = (DAYOFWEEK(DATE_ADD('2025-05-19', INTERVAL 10 DAY)))
				   LEFT JOIN db_hris.m_employee d ON a.employee_id = d.id 
				   WHERE DATE_ADD('2025-05-19', INTERVAL 10 DAY) BETWEEN a.start_date AND a.end_date 
				   AND a.cos_id = '1CA82842-53E5-42A5-A751-9090FD12DC33' AND a.employee_id = '0060A60B-3EB7-41E7-878D-9E34592F00EC'  || Error: MySQL server has gone away
[2026-09-05 13:05:49] SELECT b.is_holiday sch_holiday, c.is_holiday d_holiday, d.is_lecturer, d.annual_leave_count,
				   a.is_schedule_work, 
				   b.start_time sch_start_time, b.end_time sch_end_time, b.start_day sch_start_day, b.end_day sch_end_day,
				   c.start_time d_start_time, c.end_time d_end_time, c.start_day d_start_day, c.end_day d_end_day
				   FROM db_hris.t_schedule_emp a
				   LEFT JOIN db_hris.m_schedule_work_dt b ON a.schedule_work_id = b.schedule_work_id
				   AND b.start_day = (DAYOFWEEK(DATE_ADD('2026-06-22', INTERVAL 1 DAY)))
				   LEFT JOIN db_hris.t_schedule_emp_dt c ON c.schedule_emp_id = a.id
				   AND c.start_day = (DAYOFWEEK(DATE_ADD('2026-06-22', INTERVAL 1 DAY)))
				   LEFT JOIN db_hris.m_employee d ON a.employee_id = d.id 
				   WHERE DATE_ADD('2026-06-22', INTERVAL 1 DAY) BETWEEN a.start_date AND a.end_date 
				   AND a.cos_id = '5c97f294-394d-11f1-abbb-6045bd1ef19f' AND a.employee_id = '2f72cb63-8b74-11f1-aae9-6045bd1ef19f'  || Error: MySQL server has gone away