QUERY PLAN
Limit (cost=11.56..11.57 rows=1 width=3162)
-> Sort (cost=11.56..11.57 rows=1 width=3162)
Sort Key: index, current_join_count DESC
-> Seq Scan on promotion (cost=0.00..11.55 rows=1 width=3162)
Filter: (((start_date)::text <= '2025-04-23'::text) AND ((end_date)::text >= '2025-04-23'::text) AND ((start_time)::text <= '00:20'::text) AND ((end_time)::text >= '00:20'::text) AND (is_deleted = 0) AND (is_active = 1))