---------------------------------------------------------------
[ 2023-12-20T21:57:18+08:00 ] 101.78.12.165 POST 103.45.248.127:8001/index/login/dologin.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.018555s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.049804s ]
[ sql ] [ SQL ] SELECT * FROM `user` WHERE  `username` = 'zrh'  AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.034180s ]
[ sql ] [ SQL ] SELECT * FROM `role` WHERE  `rolename` = '超级管理员'  AND `status` = 1 LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.032227s ]
[ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE  `status` = 1 [ RunTime:0.010743s ]
[ sql ] [ SQL ] UPDATE `user`  SET `logintime`='2023-12-20 21:57:18',`web_session_id`='lgidk264n8e2dd5m50449gdp93'  WHERE  `id` = 15 [ RunTime:0.033203s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.045898s ]
[ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '101.78.12.165') [ RunTime:0.007812s ]
---------------------------------------------------------------
[ 2023-12-20T21:57:20+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/home
[ 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.057617s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.035156s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2023-12-20T21:57:21+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/index/index/content.html
[ 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.040039s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.041992s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.044922s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `adddate` BETWEEN '2023-12-01' AND '2023-12-20' LIMIT 1 [ RunTime:0.039062s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2023-12-01' AND '2023-12-20' LIMIT 1 [ RunTime:0.023437s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `checkstatus` = '未审核'  AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.023437s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.038086s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.003906s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` <> '调入仓库' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.051758s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.036133s ]
[ 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` = '2023-12-14' LIMIT 1 [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2023-12-15' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2023-12-16' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2023-12-17' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2023-12-18' LIMIT 1 [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2023-12-19' LIMIT 1 [ RunTime:0.020507s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2023-12-20' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2023-12-14' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2023-12-15' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2023-12-16' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2023-12-17' LIMIT 1 [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2023-12-18' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2023-12-19' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2023-12-20' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2023-12-14' LIMIT 1 [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2023-12-15' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2023-12-16' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2023-12-17' LIMIT 1 [ RunTime:0.020507s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2023-12-18' LIMIT 1 [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2023-12-19' LIMIT 1 [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2023-12-20' LIMIT 1 [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2023-12-14' LIMIT 1 [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2023-12-15' LIMIT 1 [ RunTime:0.022460s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2023-12-16' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2023-12-17' LIMIT 1 [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2023-12-18' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2023-12-19' LIMIT 1 [ RunTime:0.023437s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2023-12-20' LIMIT 1 [ RunTime:0.020508s ]
---------------------------------------------------------------
[ 2023-12-20T21:58:04+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/index/bill/billshow.html?type=LY
[ sql ] [ DB ] CONNECT:[ UseTime:0.064453s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.104492s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.032227s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.040039s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'LY' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.046875s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'lybill'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.003907s ]
---------------------------------------------------------------
[ 2023-12-20T21:58:06+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&page=1&limit=90
[ 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.046875s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.036133s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.049805s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-12-01' AND '2023-12-20' LIMIT 1 [ RunTime:0.033203s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-12-01' AND '2023-12-20' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.066407s ]
---------------------------------------------------------------
[ 2023-12-20T21:58:40+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&page=1&limit=90&startdate=2023-10-20&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=%E8%BD%A6%E9%98%9F%E4%BD%BF%E7%94%A8&billcode=&originalcode=&checkstatus=&operator=&maker=&note=
[ sql ] [ DB ] CONNECT:[ UseTime:0.066407s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.055664s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.036133s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.033203s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-10-20' AND '2023-12-20'  AND `depotname` = '纸浆厂仓库'  AND `custname` LIKE '%车队使用%' LIMIT 1 [ RunTime:0.038086s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-10-20' AND '2023-12-20'  AND `depotname` = '纸浆厂仓库'  AND `custname` LIKE '%车队使用%' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.070313s ]
---------------------------------------------------------------
[ 2023-12-20T21:59:15+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&page=1&limit=90&startdate=2023-10-20&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=%E8%AE%BE%E8%83%BD%E9%83%A8&billcode=&originalcode=&checkstatus=&operator=&maker=&note=
[ sql ] [ DB ] CONNECT:[ UseTime:0.053711s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.112304s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.041015s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.041016s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-10-20' AND '2023-12-20'  AND `depotname` = '纸浆厂仓库'  AND `custname` LIKE '%设能部%' LIMIT 1 [ RunTime:0.035156s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-10-20' AND '2023-12-20'  AND `depotname` = '纸浆厂仓库'  AND `custname` LIKE '%设能部%' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.003906s ]
---------------------------------------------------------------
[ 2023-12-20T21:59:23+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&page=1&limit=3000&startdate=2023-10-20&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=%E8%AE%BE%E8%83%BD%E9%83%A8&billcode=&originalcode=&checkstatus=&operator=&maker=&note=
[ sql ] [ DB ] CONNECT:[ UseTime:0.021484s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.040040s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.032227s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.037109s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-10-20' AND '2023-12-20'  AND `depotname` = '纸浆厂仓库'  AND `custname` LIKE '%设能部%' LIMIT 1 [ RunTime:0.033203s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-10-20' AND '2023-12-20'  AND `depotname` = '纸浆厂仓库'  AND `custname` LIKE '%设能部%' ORDER BY `billid` DESC LIMIT 0,3000 [ RunTime:0.069336s ]
---------------------------------------------------------------
[ 2023-12-20T22:00:47+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/index/lyreport/receive_detail.html
[ 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.068359s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.031250s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.031250s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'receivedetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.029297s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2023-12-20T22:00:49+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.031250s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.100586s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.076172s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.039063s ]
[ 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 >='2023-12-01' and adddate <='2023-12-20'order by billdetailid DESC [ RunTime:0.611329s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库')  and adddate >='2023-12-01' and adddate <='2023-12-20'order by billdetailid DESC limit 0,90 [ RunTime:0.588867s ]
---------------------------------------------------------------
[ 2023-12-20T22:01:06+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-10-20&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=%E7%BA%B8%E6%B5%86%E5%8E%82%E8%AE%BE%E8%83%BD%E9%83%A8&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.025391s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.067383s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.033203s ]
[ 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 >='2023-10-20' and adddate <='2023-12-20' and depotname='纸浆厂仓库' and custname='纸浆厂设能部'order by billdetailid DESC [ RunTime:0.625000s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库')  and adddate >='2023-10-20' and adddate <='2023-12-20' and depotname='纸浆厂仓库' and custname='纸浆厂设能部'order by billdetailid DESC limit 0,90 [ RunTime:0.008789s ]
---------------------------------------------------------------
[ 2023-12-20T22:01:15+08:00 ] 101.78.12.165 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2023-10-20&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=%E7%BA%B8%E6%B5%86%E5%8E%82%E8%AE%BE%E8%83%BD%E9%83%A8&goodscode=&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.043945s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.043945s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000000s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库')  and adddate >='2023-10-20' and adddate <='2023-12-20' and depotname='纸浆厂仓库' and custname='纸浆厂设能部'order by billdetailid DESC [ RunTime:0.632812s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库')  and adddate >='2023-10-20' and adddate <='2023-12-20' and depotname='纸浆厂仓库' and custname='纸浆厂设能部'order by billdetailid DESC limit 0,3000 [ RunTime:0.640625s ]