--------------------------------------------------------------- [ 2024-11-23T11:11:36+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=3000&depotname=&enddate=&field=goodsname&value=%E9%BC%BB&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%鼻%' [ RunTime:14.677734s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%鼻%' limit 0,3000 [ RunTime:14.057617s ] --------------------------------------------------------------- [ 2024-11-23T11:14:48+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=3000&depotname=&enddate=&field=goodsname&value=%E7%94%B5%E7%BA%BF&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%电线%' [ RunTime:15.016601s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%电线%' limit 0,3000 [ RunTime:13.906250s ] --------------------------------------------------------------- [ 2024-11-23T11:15:14+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E7%BA%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.008789s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%线%'order by billdetailid DESC [ RunTime:0.084961s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%线%'order by billdetailid DESC limit 0,3000 [ RunTime:0.671875s ] --------------------------------------------------------------- [ 2024-11-23T14:39:41+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E5%8E%8B%E5%8A%9B%E8%A1%A8&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%压力表%'order by billdetailid DESC [ RunTime:0.022461s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%压力表%'order by billdetailid DESC limit 0,3000 [ RunTime:0.637695s ] --------------------------------------------------------------- [ 2024-11-23T14:40:39+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E6%89%8E%E9%92%A9&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%扎钩%'order by billdetailid DESC [ RunTime:0.019531s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%扎钩%'order by billdetailid DESC limit 0,3000 [ RunTime:0.712891s ] --------------------------------------------------------------- [ 2024-11-23T14:40:46+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%89%8E%E9%92%A9&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.018555s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%扎钩%'order by billdetailid DESC [ RunTime:0.018554s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%扎钩%'order by billdetailid DESC limit 0,3000 [ RunTime:0.787109s ] --------------------------------------------------------------- [ 2024-11-23T14:41:27+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=3000&depotname=&enddate=&field=goodsname&value=%E6%89%8E%E9%92%A9&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.007813s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.036133s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%扎钩%' [ RunTime:15.030273s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%扎钩%' limit 0,3000 [ RunTime:14.061523s ] --------------------------------------------------------------- [ 2024-11-23T14:43:05+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2022-11-22&enddate=&depotname=&goodscode=&goodsname=%E6%89%8E%E9%92%A9&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%扎钩%'order by billdetailid DESC [ RunTime:0.017578s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%扎钩%'order by billdetailid DESC limit 0,3000 [ RunTime:0.671875s ] --------------------------------------------------------------- [ 2024-11-23T14:43:11+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2022-11-22&enddate=&depotname=&goodscode=&goodsname=%E9%92%A9&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%钩%'order by billdetailid DESC [ RunTime:0.016601s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%钩%'order by billdetailid DESC limit 0,3000 [ RunTime:0.596679s ] --------------------------------------------------------------- [ 2024-11-23T14:44:05+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%81%A5%E6%8E%A7%E5%99%A8&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.020508s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%遥控器%'order by billdetailid DESC [ RunTime:0.020508s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%遥控器%'order by billdetailid DESC limit 0,3000 [ RunTime:0.780273s ] --------------------------------------------------------------- [ 2024-11-23T14:45:23+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%A1%8C%E7%A8%8B%E5%BC%80%E5%85%B3&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%行程开关%'order by billdetailid DESC [ RunTime:0.017578s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%行程开关%'order by billdetailid DESC limit 0,3000 [ RunTime:0.749023s ] --------------------------------------------------------------- [ 2024-11-23T14:46:36+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B0%B4%E9%BE%99%E5%A4%B4&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.017578s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%水龙头%'order by billdetailid DESC [ RunTime:0.028320s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%水龙头%'order by billdetailid DESC limit 0,3000 [ RunTime:0.752930s ] --------------------------------------------------------------- [ 2024-11-23T14:47:56+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2022-11-22&enddate=&depotname=&goodscode=&goodsname=%E5%A0%B5%E5%A4%B4&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.020508s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%堵头%'order by billdetailid DESC [ RunTime:0.022461s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%堵头%'order by billdetailid DESC limit 0,3000 [ RunTime:0.720703s ] --------------------------------------------------------------- [ 2024-11-23T14:49:06+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2022-11-22&enddate=&depotname=&goodscode=&goodsname=%E7%81%AF%E5%A4%B4&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.002930s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%灯头%'order by billdetailid DESC [ RunTime:0.034179s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%灯头%'order by billdetailid DESC limit 0,3000 [ RunTime:0.664063s ] --------------------------------------------------------------- [ 2024-11-23T14:49:59+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2022-11-22&enddate=&depotname=&goodscode=&goodsname=%E7%81%AF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024415s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%灯%'order by billdetailid DESC [ RunTime:0.053711s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%灯%'order by billdetailid DESC limit 0,3000 [ RunTime:0.633789s ] --------------------------------------------------------------- [ 2024-11-23T15:07:58+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2022-11-22&enddate=&depotname=&goodscode=&goodsname=%E5%86%85%E4%B8%9D%E7%9B%B4%E6%8E%A5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.040039s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%内丝直接%'order by billdetailid DESC [ RunTime:0.033203s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%内丝直接%'order by billdetailid DESC limit 0,3000 [ RunTime:0.649414s ] --------------------------------------------------------------- [ 2024-11-23T15:10:05+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E7%9B%B4%E6%8E%A5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.007812s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%直接%'order by billdetailid DESC [ RunTime:0.038085s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%直接%'order by billdetailid DESC limit 0,3000 [ RunTime:0.673828s ] --------------------------------------------------------------- [ 2024-11-23T15:11:13+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%86%85%E4%B8%9D%E7%9B%B4%E6%8E%A5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%内丝直接%'order by billdetailid DESC [ RunTime:0.021484s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%内丝直接%'order by billdetailid DESC limit 0,3000 [ RunTime:0.764648s ] --------------------------------------------------------------- [ 2024-11-23T15:13:01+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=PPR%E7%9B%B4%E6%8E%A5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%PPR直接%'order by billdetailid DESC [ RunTime:0.023438s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%PPR直接%'order by billdetailid DESC limit 0,3000 [ RunTime:0.757813s ] --------------------------------------------------------------- [ 2024-11-23T15:17:48+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B0%B4%E9%BE%99%E5%A4%B4&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%水龙头%'order by billdetailid DESC [ RunTime:0.028321s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%水龙头%'order by billdetailid DESC limit 0,3000 [ RunTime:0.756836s ] --------------------------------------------------------------- [ 2024-11-23T15:18:33+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=PPR%E5%BC%AF%E5%A4%B4&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%PPR弯头%'order by billdetailid DESC [ RunTime:0.026367s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%PPR弯头%'order by billdetailid DESC limit 0,3000 [ RunTime:0.784179s ] --------------------------------------------------------------- [ 2024-11-23T15:20:02+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B0%B4%E9%BE%99%E5%A4%B4&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.019531s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%水龙头%'order by billdetailid DESC [ RunTime:0.028320s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%水龙头%'order by billdetailid DESC limit 0,3000 [ RunTime:0.775391s ] --------------------------------------------------------------- [ 2024-11-23T15:20:50+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=PVC%E4%B8%89%E9%80%9A&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.017578s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.010742s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%PVC三通%'order by billdetailid DESC [ RunTime:0.022461s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%PVC三通%'order by billdetailid DESC limit 0,3000 [ RunTime:0.683594s ] --------------------------------------------------------------- [ 2024-11-23T15:21:11+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=PVC%E7%9B%B4%E6%8E%A5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.022461s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%PVC直接%'order by billdetailid DESC [ RunTime:0.024414s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%PVC直接%'order by billdetailid DESC limit 0,3000 [ RunTime:0.662110s ] --------------------------------------------------------------- [ 2024-11-23T15:21:56+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E7%90%83%E9%98%80&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%球阀%'order by billdetailid DESC [ RunTime:0.038086s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%球阀%'order by billdetailid DESC limit 0,3000 [ RunTime:0.662110s ] --------------------------------------------------------------- [ 2024-11-23T15:23:15+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E9%93%9C%E9%93%9D&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%铜铝%'order by billdetailid DESC [ RunTime:0.031250s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%铜铝%'order by billdetailid DESC limit 0,3000 [ RunTime:0.649414s ] --------------------------------------------------------------- [ 2024-11-23T15:23:53+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2022-11-22&enddate=&depotname=&goodscode=&goodsname=%E9%93%9C%E9%93%9D%E9%BC%BB%E5%AD%90&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.005859s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%铜铝鼻子%'order by billdetailid DESC [ RunTime:0.020507s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%铜铝鼻子%'order by billdetailid DESC limit 0,3000 [ RunTime:0.634766s ] --------------------------------------------------------------- [ 2024-11-23T15:25:16+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2022-11-22&enddate=&depotname=&goodscode=&goodsname=%E8%83%B6%E6%B0%B4&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.018554s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%胶水%'order by billdetailid DESC [ RunTime:0.028320s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%胶水%'order by billdetailid DESC limit 0,3000 [ RunTime:0.684570s ] --------------------------------------------------------------- [ 2024-11-23T15:25:58+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E9%97%A8%E9%94%81&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%门锁%'order by billdetailid DESC [ RunTime:0.017579s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%门锁%'order by billdetailid DESC limit 0,3000 [ RunTime:0.693360s ] --------------------------------------------------------------- [ 2024-11-23T15:26:25+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E9%94%81&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.035157s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%锁%'order by billdetailid DESC [ RunTime:0.036133s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%锁%'order by billdetailid DESC limit 0,3000 [ RunTime:0.640625s ] --------------------------------------------------------------- [ 2024-11-23T15:29:44+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=G10271&goodsname=%E9%94%81&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodscode='G10271' and goodsname like '%锁%'order by billdetailid DESC [ RunTime:0.006836s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodscode='G10271' and goodsname like '%锁%'order by billdetailid DESC limit 0,3000 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-11-23T15:29:48+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=G10271&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodscode='G10271'order by billdetailid DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodscode='G10271'order by billdetailid DESC limit 0,3000 [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-11-23T15:36:43+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=3000&depotname=&enddate=&field=goodsname&value=%E6%89%8E%E9%92%A9%E6%B3%B5%E4%B9%8B%E6%BA%90&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.008789s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%扎钩泵之源%' [ RunTime:15.889649s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%扎钩泵之源%' limit 0,3000 [ RunTime:18.721680s ] --------------------------------------------------------------- [ 2024-11-23T15:37:26+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=3000&depotname=&enddate=&field=goodsname&value=%E6%B3%B5%E4%B9%8B%E6%BA%90&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%泵之源%' [ RunTime:26.577148s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%泵之源%' limit 0,3000 [ RunTime:41.097656s ] --------------------------------------------------------------- [ 2024-11-23T15:38:01+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=3000&depotname=&enddate=&field=goodsname&value=%E6%B3%B5&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.222656s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.239258s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%泵%' [ RunTime:35.361328s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%泵%' limit 0,3000 [ RunTime:30.591797s ] --------------------------------------------------------------- [ 2024-11-23T15:38:01+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=3000&depotname=&enddate=&field=goodsname&value=%E6%B3%B5%E4%B9%8B%E6%BA%90&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.019531s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:2.111329s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%泵之源%' [ RunTime:46.979493s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%泵之源%' limit 0,3000 [ RunTime:32.958008s ] --------------------------------------------------------------- [ 2024-11-23T15:38:01+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=3000&depotname=&enddate=&field=goodsname&value=%E6%B3%B5%E4%B9%8B%E6%BA%90&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:1.810547s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%泵之源%' [ RunTime:45.722656s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%泵之源%' limit 0,3000 [ RunTime:34.310547s ] --------------------------------------------------------------- [ 2024-11-23T15:39:56+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=3000&depotname=&enddate=&field=goodsname&value=%E8%BD%AF%E7%AE%A1&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%软管%' [ RunTime:14.697265s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-11-23' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%软管%' limit 0,3000 [ RunTime:13.745118s ] --------------------------------------------------------------- [ 2024-11-23T15:40:30+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E6%B0%B4%E5%B9%B3%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.007812s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.015625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%水平管%'order by billdetailid DESC [ RunTime:0.022461s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and depotname='铅锌矿仓库' and goodsname like '%水平管%'order by billdetailid DESC limit 0,3000 [ RunTime:0.644531s ] --------------------------------------------------------------- [ 2024-11-23T15:40:38+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B0%B4%E5%B9%B3%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%水平管%'order by billdetailid DESC [ RunTime:0.015625s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%水平管%'order by billdetailid DESC limit 0,3000 [ RunTime:0.774414s ] --------------------------------------------------------------- [ 2024-11-23T15:48:55+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%AE%89%E5%85%A8%E5%B8%A6&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.007813s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%安全带%'order by billdetailid DESC [ RunTime:0.021484s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%安全带%'order by billdetailid DESC limit 0,3000 [ RunTime:0.775391s ] --------------------------------------------------------------- [ 2024-11-23T15:49:53+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%BD%A9%E9%92%A2%E7%93%A6%E9%92%89&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%彩钢瓦钉%'order by billdetailid DESC [ RunTime:0.024414s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%彩钢瓦钉%'order by billdetailid DESC limit 0,3000 [ RunTime:0.737304s ] --------------------------------------------------------------- [ 2024-11-23T15:50:05+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%92%89&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.007813s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%钉%'order by billdetailid DESC [ RunTime:0.034180s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%钉%'order by billdetailid DESC limit 0,3000 [ RunTime:0.712890s ] --------------------------------------------------------------- [ 2024-11-23T15:51:37+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%BD%A9%E9%92%A2%E7%93%A6&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%彩钢瓦%'order by billdetailid DESC [ RunTime:0.022461s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%彩钢瓦%'order by billdetailid DESC limit 0,3000 [ RunTime:0.797851s ] --------------------------------------------------------------- [ 2024-11-23T15:52:08+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%92%BB%E5%B0%BE%E8%9E%BA%E4%B8%9D&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.027344s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%钻尾螺丝%'order by billdetailid DESC [ RunTime:0.028320s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%钻尾螺丝%'order by billdetailid DESC limit 0,3000 [ RunTime:0.768555s ] --------------------------------------------------------------- [ 2024-11-23T15:54:29+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2022-11-22&enddate=&depotname=&goodscode=&goodsname=%E9%92%BB%E5%B0%BE%E8%9E%BA%E4%B8%9D&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%钻尾螺丝%'order by billdetailid DESC [ RunTime:0.026367s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2022-11-22' and adddate <='2024-11-23' and goodsname like '%钻尾螺丝%'order by billdetailid DESC limit 0,3000 [ RunTime:0.659179s ] --------------------------------------------------------------- [ 2024-11-23T15:56:45+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%95%80%E9%94%8C%E8%9E%BA%E4%B8%9D&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%镀锌螺丝%'order by billdetailid DESC [ RunTime:0.019531s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%镀锌螺丝%'order by billdetailid DESC limit 0,3000 [ RunTime:0.785157s ] --------------------------------------------------------------- [ 2024-11-23T15:57:21+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%95%80%E9%94%8C%E8%9E%BA&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.006836s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%镀锌螺%'order by billdetailid DESC [ RunTime:0.028320s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%镀锌螺%'order by billdetailid DESC limit 0,3000 [ RunTime:0.803710s ] --------------------------------------------------------------- [ 2024-11-23T15:58:24+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%9C%A8%E8%9E%BA%E4%B8%9D&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.017578s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.040039s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%木螺丝%'order by billdetailid DESC [ RunTime:0.022461s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%木螺丝%'order by billdetailid DESC limit 0,3000 [ RunTime:0.761719s ] --------------------------------------------------------------- [ 2024-11-23T15:58:58+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%89%A3&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.026367s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%扣%'order by billdetailid DESC [ RunTime:0.030273s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%扣%'order by billdetailid DESC limit 0,3000 [ RunTime:0.751954s ] --------------------------------------------------------------- [ 2024-11-23T15:59:49+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%BB%91%E8%BD%AE&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%滑轮%'order by billdetailid DESC [ RunTime:0.020508s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%滑轮%'order by billdetailid DESC limit 0,3000 [ RunTime:0.794921s ] --------------------------------------------------------------- [ 2024-11-23T16:00:27+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=PVC%E5%BC%AF%E5%A4%B4&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%PVC弯头%'order by billdetailid DESC [ RunTime:0.027344s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%PVC弯头%'order by billdetailid DESC limit 0,3000 [ RunTime:0.780274s ] --------------------------------------------------------------- [ 2024-11-23T16:01:02+08:00 ] 202.62.102.86 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-11-20&enddate=&depotname=&custname=&goodscode=&goodsname=PPR%E7%9B%B4%E6%8E%A5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%PPR直接%'order by billdetailid DESC [ RunTime:0.023437s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-11-20' and adddate <='2024-11-23' and goodsname like '%PPR直接%'order by billdetailid DESC limit 0,3000 [ RunTime:0.802735s ]