sql语句如下:
SELECT
COUNT(1) AS freecount,
SUM(dishesamount+packdetailcountamount) AS freeamount
FROM rept_billdetailed
WHERE fdb_freeflag=1 AND fdd_paydate BETWEEN '2016/10/12' AND '2017/5/3' AND fdi_ognid IN (2,4,5,6,3,8,9,10,11,12,13,14,15,17,16,7,21)
AND fdm_packageitemid=0;
explain结果:
sql.png
profiles结果
sqls.png