这个sql语句怎样改了下，能提高点速度？现在我用这个sql几千条数据，分页比较慢。
select * from moonjxcmx where buyersId like '%"+ViewState["seeBuyersId"]+"%' and buyersMs like '%"+ViewState["seeBuyersName"]+"%' and goodsId like '%"+ViewState["seeGoodsId"]+"%' and goodsSpell like '%"+ViewState["seeGoodsName"]+"%' and onlyId like '%"+seeOnlyId.Text+"%' order by "+str+" "+ViewState["Direction"].ToString() se
select * from moonjxcmx where buyersId like '%"+ViewState["seeBuyersId"]+"%' and buyersMs like '%"+ViewState["seeBuyersName"]+"%' and goodsId like '%"+ViewState["seeGoodsId"]+"%' and goodsSpell like '%"+ViewState["seeGoodsName"]+"%' and onlyId like '%"+seeOnlyId.Text+"%' order by "+str+" "+ViewState["Direction"].ToString() se
