QUERY PLAN
Sort (cost=10.53..10.53 rows=1 width=140)
Sort Key: verify_at DESC
-> Seq Scan on tbl_punch_leaves (cost=0.00..10.52 rows=1 width=140)
Filter: ((status = ANY ('{2,5}'::integer[])) AND (created_by = 1001) AND (((leave_start < '2026-07-01'::date) AND (leave_end > '2026-07-01'::date)) OR ((leave_end = '2026-07-01'::date) AND (leave_end_type = 2)) OR ((leave_start = '2026-07-01'::date) AND (leave_start_type = 2)) OR ((leave_start = '2026-07-01'::date) AND (leave_start_type = 1) AND (leave_end <> '2026-07-01'::date)) OR ((leave_start = '2026-07-01'::date) AND (leave_end = '2026-07-01'::date) AND (leave_end_time IS NOT NULL) AND ((leave_end_time)::text > '12:00'::text))))