---------------------------------------------------------------
[ 2025-10-02T10:02:05+08:00 ] 139.5.157.144 POST 103.45.248.127:8001/index/login/dologin.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.004882s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.034179s ]
[ sql ] [ SQL ] SELECT * FROM `user` WHERE  `username` = 'zrh'  AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2025-10-02T10:02:14+08:00 ] 139.5.157.144 POST 103.45.248.127:8001/index/login/dologin.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.002930s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `user` WHERE  `username` = 'zrh'  AND `password` = 'MDAwMDAwMDAwMJKOfqaxiYKw' LIMIT 1 [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2025-10-02T10:02:32+08:00 ] 139.5.157.144 POST 103.45.248.127:8001/index/login/dologin.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.027343s ]
[ sql ] [ SQL ] SELECT * FROM `user` WHERE  `username` = 'zrh'  AND `password` = 'MDAwMDAwMDAwMJ6kfqaxiYKw' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `role` WHERE  `rolename` = '超级管理员'  AND `status` = 1 LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE  `status` = 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] UPDATE `user`  SET `logintime`='2025-10-02 10:02:32',`web_session_id`='g1lmn8f1o129omtieanr9dlhr3'  WHERE  `id` = 15 [ RunTime:0.005859s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.021484s ]
[ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '139.5.157.144') [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2025-10-02T10:02:34+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/home
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] 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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2025-10-02T10:02:35+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/index/index/content.html
[ 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.017578s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.025391s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `adddate` BETWEEN '2025-10-01' AND '2025-10-02' LIMIT 1 [ RunTime:0.028321s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2025-10-01' AND '2025-10-02' LIMIT 1 [ RunTime:0.023438s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `checkstatus` = '未审核'  AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.003907s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` <> '调入仓库' LIMIT 1 [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2025-09-26' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2025-09-27' LIMIT 1 [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2025-09-28' LIMIT 1 [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2025-09-29' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2025-09-30' LIMIT 1 [ RunTime:0.022460s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2025-10-01' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2025-10-02' LIMIT 1 [ RunTime:0.028320s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2025-09-26' LIMIT 1 [ RunTime:0.024414s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2025-09-27' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2025-09-28' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2025-09-29' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2025-09-30' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2025-10-01' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2025-10-02' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2025-09-26' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2025-09-27' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2025-09-28' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2025-09-29' LIMIT 1 [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2025-09-30' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2025-10-01' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2025-10-02' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2025-09-26' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2025-09-27' LIMIT 1 [ RunTime:0.026368s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2025-09-28' LIMIT 1 [ RunTime:0.020507s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2025-09-29' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2025-09-30' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2025-10-01' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2025-10-02' LIMIT 1 [ RunTime:0.030273s ]
---------------------------------------------------------------
[ 2025-10-02T10:02:52+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/index/cgreport/cg_detail.html
[ 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.022460s ]
[ 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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'cgdetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2025-10-02T10:02:55+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
[ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ 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 >='2025-10-01' and adddate <='2025-10-02'order by billdetailid DESC [ RunTime:0.603515s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2025-10-01' and adddate <='2025-10-02'order by billdetailid DESC limit 0,90 [ RunTime:0.612305s ]
---------------------------------------------------------------
[ 2025-10-02T10:03: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=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=%E5%AF%B9%E8%AE%B2%E6%9C%BA&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.032226s ]
[ 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%对讲机%'order by billdetailid DESC [ RunTime:0.018555s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%对讲机%'order by billdetailid DESC limit 0,90 [ RunTime:0.014648s ]
---------------------------------------------------------------
[ 2025-10-02T13:32:38+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=%E7%94%B5%E7%BC%86&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.027344s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%电缆%'order by billdetailid DESC [ RunTime:0.048828s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%电缆%'order by billdetailid DESC limit 0,90 [ RunTime:0.020507s ]
---------------------------------------------------------------
[ 2025-10-02T13:33:53+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=%E5%9E%AB%E5%AD%90&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.027343s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%垫子%'order by billdetailid DESC [ RunTime:0.016602s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%垫子%'order by billdetailid DESC limit 0,90 [ RunTime:0.013671s ]
---------------------------------------------------------------
[ 2025-10-02T13:34:36+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%A2%AB%E5%AD%90&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.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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%被子%'order by billdetailid DESC [ RunTime:0.032227s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%被子%'order by billdetailid DESC limit 0,90 [ RunTime:0.019531s ]
---------------------------------------------------------------
[ 2025-10-02T13:35:39+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%9A%8A%E5%B8%90&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.023437s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ 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-02' 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-02' and depotname='纸浆厂仓库' and goodsname like '%蚊帐%'order by billdetailid DESC limit 0,90 [ RunTime:0.030274s ]
---------------------------------------------------------------
[ 2025-10-02T13:36:29+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%BD%B4%E6%89%BF&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.024414s ]
[ 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.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-02' and depotname='纸浆厂仓库' and goodsname like '%轴承%'order by billdetailid DESC [ RunTime:0.049805s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%轴承%'order by billdetailid DESC limit 0,90 [ RunTime:0.030273s ]
---------------------------------------------------------------
[ 2025-10-02T13:37:11+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=%E6%B4%BB%E5%8A%A8%E6%89%B3%E6%89%8B&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.020507s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ]
[ 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-02' 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-02' and depotname='纸浆厂仓库' and goodsname like '%活动扳手%'order by billdetailid DESC limit 0,90 [ RunTime:0.015625s ]
---------------------------------------------------------------
[ 2025-10-02T13:37:46+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=%E6%8F%92%E9%94%80&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.023438s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ 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-02' and depotname='纸浆厂仓库' 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%插销%'order by billdetailid DESC limit 0,90 [ RunTime:0.015625s ]
---------------------------------------------------------------
[ 2025-10-02T13:38:22+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%E4%B8%9D%E8%83%B6&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.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-02' and depotname='纸浆厂仓库' and goodsname like '%螺丝胶%'order by billdetailid DESC [ RunTime:0.014648s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%螺丝胶%'order by billdetailid DESC limit 0,90 [ RunTime:0.018555s ]
---------------------------------------------------------------
[ 2025-10-02T13:38:57+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%A1%A5%E8%83%8E%E8%83%B6&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.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.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-02' and depotname='纸浆厂仓库' and goodsname like '%补胎胶%'order by billdetailid DESC [ RunTime:0.020507s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%补胎胶%'order by billdetailid DESC limit 0,90 [ RunTime:0.013672s ]
---------------------------------------------------------------
[ 2025-10-02T13:39:45+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=%E5%BC%80%E5%8F%A3%E6%89%B3%E6%89%8B&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.027344s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ]
[ 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-02' 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-02' and depotname='纸浆厂仓库' and goodsname like '%开口扳手%'order by billdetailid DESC limit 0,90 [ RunTime:0.015625s ]
---------------------------------------------------------------
[ 2025-10-02T13:40: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=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=%E9%92%B3&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.022461s ]
[ 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.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-02' and depotname='纸浆厂仓库' and goodsname like '%钳%'order by billdetailid DESC [ RunTime:0.062500s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%钳%'order by billdetailid DESC limit 0,90 [ RunTime:0.035157s ]
---------------------------------------------------------------
[ 2025-10-02T13:41:28+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=%E7%94%B5%E7%AC%94&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.023438s ]
[ 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-02' 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-02' and depotname='纸浆厂仓库' and goodsname like '%电笔%'order by billdetailid DESC limit 0,90 [ RunTime:0.015625s ]
---------------------------------------------------------------
[ 2025-10-02T13:42:10+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=%E5%A5%97%E7%AD%92%E6%89%B3%E6%89%8B&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.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-02' 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-02' and depotname='纸浆厂仓库' and goodsname like '%套筒扳手%'order by billdetailid DESC limit 0,90 [ RunTime:0.016601s ]
---------------------------------------------------------------
[ 2025-10-02T13:43:03+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=%E5%8D%83%E6%96%A4%E9%A1%B6&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.024414s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%千斤顶%'order by billdetailid DESC limit 0,90 [ RunTime:0.015625s ]
---------------------------------------------------------------
[ 2025-10-02T13:43: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=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=%E7%94%B5%E7%93%B6%E5%8D%A1%E5%AD%90&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.021484s ]
[ 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%电瓶卡子%'order by billdetailid DESC limit 0,90 [ RunTime:0.013671s ]
---------------------------------------------------------------
[ 2025-10-02T13:44:19+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=G17868&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.025390s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%G17868%'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-02' and depotname='纸浆厂仓库' and goodsname like '%G17868%'order by billdetailid DESC limit 0,90 [ RunTime:0.012695s ]
---------------------------------------------------------------
[ 2025-10-02T13:45:27+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=G17868&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.021485s ]
[ 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.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-02' and depotname='纸浆厂仓库' and goodscode='G17868'order by billdetailid DESC [ RunTime:0.003906s ]
[ 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-02' and depotname='纸浆厂仓库' and goodscode='G17868'order by billdetailid DESC limit 0,90 [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2025-10-02T13:45:33+08:00 ] 139.5.157.144 GET 103.45.248.127:8001/index/custom/select_custom.html?dw=%E4%BE%9B%E5%BA%94%E5%95%86
[ 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.023437s ]
[ 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.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'custom'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.001954s ]
---------------------------------------------------------------
[ 2025-10-02T13:45:55+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=%E5%8D%A1%E5%AD%90&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.029297s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020507s ]
[ 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-02' 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-02' and depotname='纸浆厂仓库' and goodsname like '%卡子%'order by billdetailid DESC limit 0,90 [ RunTime:0.014648s ]
---------------------------------------------------------------
[ 2025-10-02T13:46: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=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=%E7%94%B5%E7%93%B6&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.023438s ]
[ 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.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-02' 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%电瓶%'order by billdetailid DESC limit 0,90 [ RunTime:0.023438s ]
---------------------------------------------------------------
[ 2025-10-02T13:46:39+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=%E7%A0%82%E7%BA%B8&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.018555s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ]
[ 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-02' 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-02' and depotname='纸浆厂仓库' and goodsname like '%砂纸%'order by billdetailid DESC limit 0,90 [ RunTime:0.022461s ]
---------------------------------------------------------------
[ 2025-10-02T13:48:18+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=%E7%94%9F%E6%96%99%E5%B8%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.032226s ]
[ 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-02' 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%生料带%'order by billdetailid DESC limit 0,90 [ RunTime:0.014648s ]
---------------------------------------------------------------
[ 2025-10-02T13:49:01+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=%E5%90%B9%E7%81%B0%E6%9E%AA&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.021485s ]
[ 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-02' 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%吹灰枪%'order by billdetailid DESC limit 0,90 [ RunTime:0.012696s ]
---------------------------------------------------------------
[ 2025-10-02T13:49:11+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=%E6%9E%AA&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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ]
[ 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-02' 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%枪%'order by billdetailid DESC limit 0,90 [ RunTime:0.023438s ]
---------------------------------------------------------------
[ 2025-10-02T13:50:30+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=%E7%94%B5%E5%8A%A8%E6%89%B3%E6%89%8B&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.019532s ]
[ 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.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-02' and depotname='纸浆厂仓库' 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%电动扳手%'order by billdetailid DESC limit 0,90 [ RunTime:0.015625s ]
---------------------------------------------------------------
[ 2025-10-02T13:51:35+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=%E5%88%87%E5%89%B2%E7%89%87&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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.002929s ]
[ 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-02' 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-02' and depotname='纸浆厂仓库' and goodsname like '%切割片%'order by billdetailid DESC limit 0,90 [ RunTime:0.022461s ]
---------------------------------------------------------------
[ 2025-10-02T13:52:36+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=%E6%89%8E%E5%B8%A6&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.030274s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.003907s ]
[ 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%扎带%'order by billdetailid DESC [ RunTime:0.027343s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%扎带%'order by billdetailid DESC limit 0,90 [ RunTime:0.016602s ]
---------------------------------------------------------------
[ 2025-10-02T13:53:57+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=%E6%B0%94%E5%8A%A8%E7%A3%A8&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.023438s ]
[ 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-10-02' and adddate <='2025-10-02' and depotname='纸浆厂仓库' and goodsname like '%气动磨%'order by billdetailid DESC [ RunTime:0.016601s ]
[ 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-02' and depotname='纸浆厂仓库' and goodsname like '%气动磨%'order by billdetailid DESC limit 0,90 [ RunTime:0.013672s ]
---------------------------------------------------------------
[ 2025-10-02T13:54:03+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=%E7%A3%A8&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.018554s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ]
[ 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-02' 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-02' and depotname='纸浆厂仓库' and goodsname like '%磨%'order by billdetailid DESC limit 0,90 [ RunTime:0.029297s ]