---------------------------------------------------------------
[ 2025-10-03T21:09:52+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2020-10-02&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E8%9E%BA%E6%A0%93&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.022461s ]
[ 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-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%螺栓%'order by billdetailid DESC [ RunTime:0.037109s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2020-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%螺栓%'order by billdetailid DESC limit 0,90 [ RunTime:0.016601s ]
---------------------------------------------------------------
[ 2025-10-03T21:10:09+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-10-02&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E8%9E%BA%E6%A0%93&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:0.031250s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ 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-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%螺栓%'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-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%螺栓%'order by billdetailid DESC limit 0,3000 [ RunTime:0.018555s ]
---------------------------------------------------------------
[ 2025-10-03T21:10:41+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-10-02&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ 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-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%螺丝%'order by billdetailid DESC [ RunTime:0.064453s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2020-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%螺丝%'order by billdetailid DESC limit 0,3000 [ RunTime:0.046875s ]
---------------------------------------------------------------
[ 2025-10-03T21:12:31+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-10-02&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E5%A4%96%E5%85%AD%E8%A7%92%E8%9E%BA%E4%B8%9D&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.025390s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ 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-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%外六角螺丝%'order by billdetailid DESC [ RunTime:0.029297s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2020-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%外六角螺丝%'order by billdetailid DESC limit 0,3000 [ RunTime:0.019531s ]
---------------------------------------------------------------
[ 2025-10-03T22:18:32+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-10-02&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E6%B8%B8%E6%A0%87%E5%8D%A1&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.023438s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ 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-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' 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-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%游标卡%'order by billdetailid DESC limit 0,3000 [ RunTime:0.012695s ]
---------------------------------------------------------------
[ 2025-10-03T22:43:49+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-10-02&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E5%A4%A7%E9%A3%8E%E7%82%AE&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.027343s ]
[ 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.001953s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2020-10-02' and adddate <='2025-10-03' 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-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%大风炮%'order by billdetailid DESC limit 0,3000 [ RunTime:0.014648s ]
---------------------------------------------------------------
[ 2025-10-03T22:50:07+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-10-02&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E5%A5%97%E7%AD%92&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] 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.016601s ]
[ 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-10-02' and adddate <='2025-10-03' 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-10-02' and adddate <='2025-10-03' and depotname='纸浆厂仓库' and goodsname like '%套筒%'order by billdetailid DESC limit 0,3000 [ RunTime:0.023438s ]