Sort (cost=2.13..2.14 rows=1 width=207) |
Sort Key: verify_at DESC |
-> Seq Scan on tbl_punch_travels (cost=0.00..2.12 rows=1 width=207) |
Filter: ((created_by = 1000) AND (status = 1) AND (((travel_start < '2025-06-25'::date) AND (travel_end > '2025-06-25'::date)) OR ((travel_end = '2025-06-25'::date) AND (travel_end_type = 2)) OR ((travel_start = '2025-06-25'::date) AND (travel_start_type = 2)) OR ((travel_start = '2025-06-25'::date) AND (travel_start_type = 1) AND (travel_end <> '2025-06-25'::date)))) |