无合适where条件过滤时尽量选择orderby后的字段以驱动表进行查询:后台查询语句SELECTo.orders_id,s.orders_status_name,ot.text,af.affiliate_idFROMordersoLEFTJOINorders_totalotON(o.orders_id=ot.orders_id)LEFTJOINaffilia 后台查询语句SELECT o.orders_id, s.ord