原语句 查询慢的要命：
SELECT COUNT(*) cn1 FROM bill_sale_dtl WHERE
(customid like '%')AND (supplyerid like '%')AND (GOODSID like '%')AND (salerid like '%')AND (FACTORYID like '%')AND (agentid like '%') AND LOTNO like '%%'
AND ((batchid in (select BATCHID from bms_batch_def where COMPANYID in (select des from P_DataResponsibility where TYPE='供应商' and UserID='3065253')) ))
AND (BILL_TYPE like '%%'AND(GOODSID like '%%' OR GOODSNAME like '%%' ) AND(CREDATE >= '2018-6-1 00:00:00' AND CREDATE <= '2018-6-12 23:59:59')
AND(customid like '%%' OR customname like '%%')AND(agentid like '%%' OR agentname like '%%'))
注销其中一个条件：
SELECT COUNT(*) cn1 FROM bill_sale_dtl WHERE
(customid like '%')AND (supplyerid like '%')AND (GOODSID like '%')AND (salerid like '%')AND (FACTORYID like '%')AND (agentid like '%') AND LOTNO like '%%'
--AND ((batchid in (select BATCHID from bms_batch_def where COMPANYID in (select des from P_DataResponsibility where TYPE='供应商' and UserID='3065253')) ))
AND (BILL_TYPE like '%%'AND(GOODSID like '%%' OR GOODSNAME like '%%' ) AND(CREDATE >= '2018-6-1 00:00:00' AND CREDATE <= '2018-6-12 23:59:59')
AND(customid like '%%' OR customname like '%%')AND(agentid like '%%' OR agentname like '%%'))
效率就上来了。注释这段该怎么 优化？

in条件用的太多了
改成join或者建临时表