--------------------------------------------------------------- [ 2024-08-31T10:06:27+08:00 ] 101.78.12.241 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.713867s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'ZRH' AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.051758s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.055664s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.030273s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-08-31 10:06:26',`web_session_id`='gaqjebc6850q5ulipa0ccsq9h1' WHERE `id` = 15 [ RunTime:0.088867s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.217774s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '101.78.12.241') [ RunTime:0.271484s ] --------------------------------------------------------------- [ 2024-08-31T10:06:30+08:00 ] 101.78.12.241 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:1.051758s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:1.138671s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-08-31T10:06:36+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/index/content.html [ 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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.446289s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.244141s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2024-08-01' AND '2024-08-31' LIMIT 1 [ RunTime:0.065429s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-08-01' AND '2024-08-31' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.690430s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.036133s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.005860s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.385743s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.823242s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-26' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-27' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-30' LIMIT 1 [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-26' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-27' LIMIT 1 [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.080078s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-30' LIMIT 1 [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-26' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-27' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-30' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-26' LIMIT 1 [ RunTime:0.060547s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-27' LIMIT 1 [ RunTime:0.036133s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-30' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.021485s ] --------------------------------------------------------------- [ 2024-08-31T10:06:55+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ 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.719727s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.810547s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.874023s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'billdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.018554s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.693359s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-08-31T10:07:01+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90 [ 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.704102s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:1.002930s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.936523s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-08-01' AND '2024-08-31' LIMIT 1 [ RunTime:1.284180s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-08-01' AND '2024-08-31' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.599609s ] --------------------------------------------------------------- [ 2024-08-31T10:07:13+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ 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.757813s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.433594s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.326172s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-08-01' AND '2024-08-31' AND `type` = '销售提货' LIMIT 1 [ RunTime:0.472656s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-08-01' AND '2024-08-31' AND `type` = '销售提货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.592773s ] --------------------------------------------------------------- [ 2024-08-31T10:07:33+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2023-10-31&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:1.069336s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.931640s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.813477s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-10-31' AND '2024-08-31' AND `type` = '销售提货' LIMIT 1 [ RunTime:0.517578s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-10-31' AND '2024-08-31' AND `type` = '销售提货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.627929s ] --------------------------------------------------------------- [ 2024-08-31T10:08:19+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2023-10-31&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=G10459&goodsname=&detailnote= [ 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.208985s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.436523s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.585938s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-10-31' AND '2024-08-31' AND `type` = '销售提货' AND `goodscode` LIKE '%G10459%' LIMIT 1 [ RunTime:0.078125s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-10-31' AND '2024-08-31' AND `type` = '销售提货' AND `goodscode` LIKE '%G10459%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.141602s ] --------------------------------------------------------------- [ 2024-08-31T10:22:23+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/kcreport/stock_sum.html [ 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.510743s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.556640s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2024-08-31T10:22:26+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90 [ 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.778320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.008789s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:1.507813s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-08-31T10:22:43+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=&field=goodscode&value=G10459&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.416015s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.119141s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-08-31T10:22:52+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&field=goodscode&value=G10459&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.448242s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.816407s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G10459%' [ RunTime:0.004883s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 and goodscode like '%G10459%' ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-08-31' and depotname='嘎西仓储' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='嘎西仓储' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='嘎西仓储' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-08-01' and depotname='嘎西仓储' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.876953s ] --------------------------------------------------------------- [ 2024-08-31T10:23:01+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10459&goodscategory= [ 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.873047s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:1.132813s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G10459%' [ RunTime:0.006836s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 and goodscode like '%G10459%' ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-08-31' and depotname='铜矿仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='铜矿仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='铜矿仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-08-01' and depotname='铜矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.875977s ] --------------------------------------------------------------- [ 2024-08-31T10:23:07+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10459&goodscategory= [ 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.149414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.178710s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G10459%' [ RunTime:0.005860s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 and goodscode like '%G10459%' ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-08-31' and depotname='铅锌矿仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-08-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:2.115234s ] --------------------------------------------------------------- [ 2024-08-31T10:23:14+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E5%98%8E%E8%A5%BF%E8%B4%A7%E5%9C%BA&field=goodscode&value=G10459&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.651367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.388671s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G10459%' [ RunTime:0.005859s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 and goodscode like '%G10459%' ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-08-31' and depotname='嘎西货场' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='嘎西货场' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='嘎西货场' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-08-01' and depotname='嘎西货场' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.576172s ] --------------------------------------------------------------- [ 2024-08-31T10:23:22+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=goodscode&value=G10459&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.396484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.412110s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G10459%' [ RunTime:0.005860s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 and goodscode like '%G10459%' ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-08-01' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:2.150391s ] --------------------------------------------------------------- [ 2024-08-31T10:37:00+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003907s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.714844s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.989258s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.423828s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'billdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.184570s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-08-31T10:37:03+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90 [ 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.575195s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.609375s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.694336s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-08-01' AND '2024-08-31' LIMIT 1 [ RunTime:0.489257s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-08-01' AND '2024-08-31' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.582031s ] --------------------------------------------------------------- [ 2024-08-31T10:37:19+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ 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.896484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:1.297852s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.435547s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-08-01' AND '2024-08-31' AND `type` = '销售提货' LIMIT 1 [ RunTime:0.608398s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-08-01' AND '2024-08-31' AND `type` = '销售提货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.608398s ] --------------------------------------------------------------- [ 2024-08-31T10:37:31+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2023-08-31&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ 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.852539s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.626953s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.191407s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-08-31' AND '2024-08-31' AND `type` = '销售提货' LIMIT 1 [ RunTime:0.526367s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-08-31' AND '2024-08-31' AND `type` = '销售提货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.637695s ] --------------------------------------------------------------- [ 2024-08-31T10:52:54+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2023-08-31&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ 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.374024s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.562500s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.704101s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-08-31' AND '2024-08-31' AND `type` = '销售提货' LIMIT 1 [ RunTime:0.507812s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-08-31' AND '2024-08-31' AND `type` = '销售提货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.650390s ] --------------------------------------------------------------- [ 2024-08-31T10:52:57+08:00 ] 101.78.12.241 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2023-08-31&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ 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.110352s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.207031s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.520508s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-08-31' AND '2024-08-31' AND `type` = '销售提货' LIMIT 1 [ RunTime:0.485352s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-08-31' AND '2024-08-31' AND `type` = '销售提货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.658203s ] --------------------------------------------------------------- [ 2024-08-31T17:33:59+08:00 ] 101.78.12.254 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.008789s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.197265s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'dsy' AND `password` = 'MDAwMDAwMDAwMJN-gmw' LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.152343s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '纸浆厂库管' AND `status` = 1 LIMIT 1 [ RunTime:0.055664s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-08-31 17:33:58',`web_session_id`='s0smltq36tik95s5994rbldlg6' WHERE `id` = 19 [ RunTime:0.016602s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.388672s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'DSY' , '丁淑英' , '101.78.12.254') [ RunTime:0.135742s ] --------------------------------------------------------------- [ 2024-08-31T17:34:01+08:00 ] 101.78.12.254 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.390625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.673828s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-08-31T17:34:06+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/index/content.html [ 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.424805s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.292969s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.585937s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-08-01' AND '2024-08-31' LIMIT 1 [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-08-01' AND '2024-08-31' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.035156s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.314453s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.005859s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.138672s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.059570s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-26' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-27' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-30' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-26' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-27' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-30' LIMIT 1 [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-26' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-27' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-30' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-26' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-27' LIMIT 1 [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.034179s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-30' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.020508s ] --------------------------------------------------------------- [ 2024-08-31T17:35:24+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/cgreport/cg_detail.html [ 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.322266s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.574219s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.006836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.467773s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-08-31T17:35:28+08:00 ] 101.78.12.254 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.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.257813s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.201172s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC [ RunTime:0.601563s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC limit 0,90 [ RunTime:0.576171s ] --------------------------------------------------------------- [ 2024-08-31T17:35:35+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&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.617188s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.782227s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.650390s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.570313s ] --------------------------------------------------------------- [ 2024-08-31T17:36:07+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2024-07-01&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&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.474609s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.007812s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.393555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 >='2024-07-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.680664s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-07-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.682617s ] --------------------------------------------------------------- [ 2024-08-31T17:36:23+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/adjust_detail.html [ 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.416015s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.133789s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.009766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.112305s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'adjustdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2024-08-31T17:36:25+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.011718s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.074219s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.070312s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC [ RunTime:0.646484s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC limit 0,90 [ RunTime:0.645508s ] --------------------------------------------------------------- [ 2024-08-31T17:36:35+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&goodscode=&goodsname=&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.300781s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.384765s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.632812s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.600586s ] --------------------------------------------------------------- [ 2024-08-31T17:41:42+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/lyreport/receive_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010742s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.427734s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.385742s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.397461s ] [ 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.155273s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-08-31T17:41:45+08:00 ] 101.78.12.254 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.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.566406s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.250000s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC [ RunTime:0.583008s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC limit 0,90 [ RunTime:0.595703s ] --------------------------------------------------------------- [ 2024-08-31T17:42:01+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&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.359375s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.005859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.430664s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.660156s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.593750s ] --------------------------------------------------------------- [ 2024-08-31T17:42:19+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.016601s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.375000s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.063477s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 >='2024-08-01' and adddate <='2024-08-31' and depotname='铅锌矿仓库'order by billdetailid DESC [ RunTime:0.640625s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='铅锌矿仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.587891s ] --------------------------------------------------------------- [ 2024-08-31T17:43:36+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.019532s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.247070s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.003907s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.172852s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.610351s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.597657s ] --------------------------------------------------------------- [ 2024-08-31T17:49:36+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/transfer_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.016602s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.320312s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.253906s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.049805s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'transferdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-08-31T17:49:39+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.011718s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.364257s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.552734s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC [ RunTime:0.661132s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC limit 0,90 [ RunTime:0.612305s ] --------------------------------------------------------------- [ 2024-08-31T17:49:54+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&depotname1=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=&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.454101s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.208984s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.014648s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC [ RunTime:0.615234s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC limit 0,90 [ RunTime:0.607421s ] --------------------------------------------------------------- [ 2024-08-31T17:51:18+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stock_sum.html [ 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.186524s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.278320s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.005860s ] --------------------------------------------------------------- [ 2024-08-31T17:51:20+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.291016s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.507812s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.008789s ] --------------------------------------------------------------- [ 2024-08-31T17:51:30+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.553711s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.432617s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.064453s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-08-01' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:2.167968s ] --------------------------------------------------------------- [ 2024-08-31T17:51:49+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=3000&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.304688s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.143555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-08-01' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,3000 [ RunTime:5.627930s ] --------------------------------------------------------------- [ 2024-08-31T17:52:21+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=2&limit=3000&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.368164s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.144531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-08-01' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 3000,3000 [ RunTime:8.806641s ] --------------------------------------------------------------- [ 2024-08-31T17:52:54+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=3&limit=3000&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.137696s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.436524s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-08-01' AND adddate <= '2024-08-31' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-08-01' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 6000,3000 [ RunTime:11.848633s ] --------------------------------------------------------------- [ 2024-08-31T18:00:52+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/lyreport/receive_detail.html [ 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.285156s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.192382s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.003906s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.493164s ] [ 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.152343s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-08-31T18:00:55+08:00 ] 101.78.12.254 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.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.561524s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.138671s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC [ RunTime:0.652344s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC limit 0,90 [ RunTime:0.551758s ] --------------------------------------------------------------- [ 2024-08-31T18:01:07+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&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.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.354492s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.333984s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002930s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and custname='纸浆厂设能部'order by billdetailid DESC [ RunTime:0.684571s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and custname='纸浆厂设能部'order by billdetailid DESC limit 0,90 [ RunTime:0.590820s ] --------------------------------------------------------------- [ 2024-08-31T18:01:10+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ 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.220703s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-08-31T18:01:13+08:00 ] 101.78.12.254 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ 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.637696s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.447265s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.422852s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-08-31T18:01:19+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&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=%E7%87%83%E6%B2%B9%E3%80%81%E6%B6%A6%E6%BB%91%E6%B2%B9%E8%84%82%E7%B1%BB [ sql ] [ DB ] CONNECT:[ UseTime:0.003907s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.207032s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.609375s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.408203s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '燃油、润滑油脂类' [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132404%' [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and custname='纸浆厂设能部' and goodscategory in ("燃油、润滑油脂类","燃油","液压油、齿轮油、锂基脂、机油、传动油等")order by billdetailid DESC [ RunTime:0.621094s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and custname='纸浆厂设能部' and goodscategory in ("燃油、润滑油脂类","燃油","液压油、齿轮油、锂基脂、机油、传动油等")order by billdetailid DESC limit 0,90 [ RunTime:0.173828s ] --------------------------------------------------------------- [ 2024-08-31T18:01:46+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ 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.036133s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-08-31T18:01:47+08:00 ] 101.78.12.254 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ 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.242187s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.146484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.005859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.240234s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-08-31T18:01:53+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&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=%E6%9C%BA%E6%A2%B0%E9%85%8D%E4%BB%B6 [ 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.895508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.943360s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.620117s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '机械配件' [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132585%' [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and custname='纸浆厂设能部' and goodscategory in ("机械配件","运输设备配件","工程机械设备配件","选厂设备配件","其他设备配件")order by billdetailid DESC [ RunTime:0.403320s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and custname='纸浆厂设能部' and goodscategory in ("机械配件","运输设备配件","工程机械设备配件","选厂设备配件","其他设备配件")order by billdetailid DESC limit 0,90 [ RunTime:0.287110s ] --------------------------------------------------------------- [ 2024-08-31T18:02:23+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&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.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.258789s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.005860s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.197265s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and custname='纸浆厂设能部'order by billdetailid DESC [ RunTime:0.635742s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and custname='纸浆厂设能部'order by billdetailid DESC limit 0,90 [ RunTime:0.610351s ] --------------------------------------------------------------- [ 2024-08-31T18:02:30+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/transfer_detail.html [ 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.091797s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.120117s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'transferdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2024-08-31T18:02:33+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90 [ 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.606445s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.647460s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC [ RunTime:0.633789s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC limit 0,90 [ RunTime:0.583008s ] --------------------------------------------------------------- [ 2024-08-31T18:02:42+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ 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.581054s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.916992s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2024-08-31T18:02:44+08:00 ] 101.78.12.254 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ 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.660157s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.416016s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.389649s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-08-31T18:02:48+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&depotname1=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=&goodscategory=%E7%87%83%E6%B2%B9%E3%80%81%E6%B6%A6%E6%BB%91%E6%B2%B9%E8%84%82%E7%B1%BB [ 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.237305s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.169922s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.271484s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '燃油、润滑油脂类' [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132404%' [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodscategory in ("燃油、润滑油脂类","燃油","液压油、齿轮油、锂基脂、机油、传动油等")order by billdetailid DESC [ RunTime:0.166016s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodscategory in ("燃油、润滑油脂类","燃油","液压油、齿轮油、锂基脂、机油、传动油等")order by billdetailid DESC limit 0,90 [ RunTime:0.128906s ] --------------------------------------------------------------- [ 2024-08-31T18:03:10+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ 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.673828s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.439453s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-08-31T18:03:13+08:00 ] 101.78.12.254 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.047852s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.693359s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.917969s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.512696s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-08-31T18:03:21+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&depotname1=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=&goodscategory=%E6%9C%BA%E6%A2%B0%E9%85%8D%E4%BB%B6 [ 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.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.137695s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '机械配件' [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132585%' [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodscategory in ("机械配件","运输设备配件","工程机械设备配件","选厂设备配件","其他设备配件")order by billdetailid DESC [ RunTime:0.303711s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodscategory in ("机械配件","运输设备配件","工程机械设备配件","选厂设备配件","其他设备配件")order by billdetailid DESC limit 0,90 [ RunTime:0.247070s ] --------------------------------------------------------------- [ 2024-08-31T18:03:23+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ 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.225586s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.254883s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-08-31T18:03:25+08:00 ] 101.78.12.254 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002930s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.450195s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.462891s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.522461s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-08-31T18:03:32+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&depotname1=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=&goodscategory=%E8%BE%85%E6%96%99%E9%85%8D%E4%BB%B6 [ 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.090820s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.074219s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.229493s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '辅料配件' [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696%' [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodscategory in ("辅料配件","电器材料","阀门类","劳保用品","药剂","实验室材料","工业气体","其他辅料","运输等其他费用","选厂药剂")order by billdetailid DESC [ RunTime:0.568359s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodscategory in ("辅料配件","电器材料","阀门类","劳保用品","药剂","实验室材料","工业气体","其他辅料","运输等其他费用","选厂药剂")order by billdetailid DESC limit 0,90 [ RunTime:0.431640s ] --------------------------------------------------------------- [ 2024-08-31T18:03:51+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&depotname1=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=&goodscategory= [ 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.370117s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.050781s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.007813s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC [ RunTime:0.653320s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2024-08-01' and adddate <='2024-08-31' and depotname='纸浆厂仓库' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC limit 0,90 [ RunTime:0.591797s ]