不知道什么原因
具体语句如下
select DISTINCT BOOK_LIST.BLCODE ,BLNAME, BOOK_LIST.TYPE ,INTRODUCE , rtrim(PIC_URL) as PIC_URL ,QTY ,BOOK_LIST.TOTAL,BOOK_LIST.ISBY, (select case when T.TYPE = 2 then sum(MP_CQXHSD.dbo.func_getRealprice('501301', BOOK_LIST_PLU.PLUCODE)) else case when sum(MP_CQXHSD.dbo.func_getRealprice('501301',BOOK_LIST_PLU.PLUCODE))< T.STOTAL then sum(MP_CQXHSD.dbo.func_getRealprice('501301',BOOK_LIST_PLU.PLUCODE)) else T.STOTAL end end as STOTAL from BOOK_LIST AS T,BOOK_LIST_PLU where BOOK_LIST_PLU.BLCODE = BOOK_LIST.BLCODE and T.BLCODE = BOOK_LIST.BLCODE group by TYPE ,STOTAL) AS STOTAL ,case when GBL = '130001' then 1 else 2 end px,case when BOOK_LIST.TYPE = 2 then 0 else BOOK_LIST.TYPE end pxt ,BOOK_LIST.RNDATE ,BOOK_LIST.GBL ,BOOK_LIST.STORE from BOOK_LIST left join GBL_INFO on GBL_INFO.STORE = BOOK_LIST.STORE and GBL_INFO.CODE= BOOK_LIST.GBL where ((BOOK_LIST.STORE = '501301' and BOOK_LIST.GBL is null) or BOOK_LIST.GBL = '130001' or BOOK_LIST.STORE = '9999') and '20220115 BETWEEN BOOK_LIST.BDATE AND BOOK_LIST.EDATE and BOOK_LIST.STATUS in(2)
在sql工具里面执行100毫秒不到就执行了,在应用程序里面执行需要 10秒左右.查出来的数据只有几条