slow query都是一样的
SELECT order_id,agent_tx_no,paid_amount,pay_time,recon_time FROM pay_order WHERE pay_time > ? AND pay_time < ? AND status = ? AND channel_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ORDER BY id desc [arguments: (“1718899199”, “1718985600”, “3”, “9”, “31”, “122”, “126”, “132”, “136”, “179”, “180”, “181”, “182”, “183”, “186”, “118”, “119”, “229”)];
slow_query.sql (3.2 KB)