--------------------------------------------------------------- [ 2024-09-01T16:25:35+08:00 ] 101.78.12.254 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010742s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'zrh' AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-09-01 16:25:34',`web_session_id`='4gbhi7dm9rtffp6cgacq6or1v5' WHERE `id` = 15 [ RunTime:0.013672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.023438s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '101.78.12.254') [ RunTime:0.012695s ] --------------------------------------------------------------- [ 2024-09-01T16:25:36+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/home [ 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.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-09-01T16:25:37+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/index/content.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.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2024-09-01' AND '2024-09-01' LIMIT 1 [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-09-01' AND '2024-09-01' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.022460s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.003906s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.018555s ] [ 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-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.027344s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-30' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-09-01' 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.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.022460s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.023438s ] [ 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.028321s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-09-01' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-26' LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-27' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.023438s ] [ 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.025391s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-09-01' 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.022461s ] [ 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.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-30' LIMIT 1 [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-09-01' LIMIT 1 [ RunTime:0.024414s ] --------------------------------------------------------------- [ 2024-09-01T16:27:08+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/warehouse_sum.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.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-09-01T16:29:30+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/warehousesum_data.html?page=1&limit=90&startdate=2020-09-01&enddate= [ sql ] [ DB ] CONNECT:[ UseTime:0.127930s ] 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.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022460s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] select id from depot [ RunTime:0.004883s ] [ sql ] [ SQL ] SELECT a.depotname, a.g_user, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(endnumber,0) as endnumber, IFNULL(endmon,0) as endmon FROM ( ( ( depot a LEFT JOIN ( SELECT depotname, Sum(sign*number) AS startnumber, CASE WHEN Sum(sign*number) = 0 THEN 0 ELSE Sum(sign*number*price) END AS startmon FROM s_goodsnum1 WHERE adddate < '2020-09-01' GROUP BY depotname ) b ON a.depotname = b.depotname ) LEFT JOIN ( SELECT CASE WHEN Sum(sign*number) = 0 THEN ifnull(Sum(sign*number), 0) ELSE Sum(sign*number*price) END AS endmon, depotname, Sum(sign*number) AS endnumber FROM s_goodsnum1 WHERE adddate <= '2024-09-01' GROUP BY depotname ) c ON a.depotname = c.depotname ) LEFT JOIN ( SELECT case when Sum(number) = 0 then ifnull(Sum(number), 0) else Sum(number*price) end AS outmoney, depotname, Sum(number) AS outnumber from s_goodsnum1 where sign=- 1 AND adddate >= '2020-09-01' and adddate <= '2024-09-01' group by depotname ) d on a.depotname = d.depotname ) LEFT JOIN ( SELECT case when Sum(number) = 0 then ifnull(Sum(sign*number), 0) else Sum(sign*number*price) end AS inmoney, depotname, CASE WHEN Sum(number) = 0 THEN ifnull(Sum(sign*number), 0) ELSE Sum(sign*number) END AS innumber from s_goodsnum1 where sign= 1 AND adddate >= '2020-09-01' and adddate <= '2024-09-01' group by depotname ) e on a.depotname = e.depotname where 1=1 limit 0,90 [ RunTime:93.029297s ] --------------------------------------------------------------- [ 2024-09-01T16:29:30+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/warehousesum_data.html?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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from depot [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT a.depotname, a.g_user, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(endnumber,0) as endnumber, IFNULL(endmon,0) as endmon FROM ( ( ( depot a LEFT JOIN ( SELECT depotname, Sum(sign*number) AS startnumber, CASE WHEN Sum(sign*number) = 0 THEN 0 ELSE Sum(sign*number*price) END AS startmon FROM s_goodsnum1 WHERE adddate < '2024-09-01' GROUP BY depotname ) b ON a.depotname = b.depotname ) LEFT JOIN ( SELECT CASE WHEN Sum(sign*number) = 0 THEN ifnull(Sum(sign*number), 0) ELSE Sum(sign*number*price) END AS endmon, depotname, Sum(sign*number) AS endnumber FROM s_goodsnum1 WHERE adddate <= '2024-09-01' GROUP BY depotname ) c ON a.depotname = c.depotname ) LEFT JOIN ( SELECT case when Sum(number) = 0 then ifnull(Sum(number), 0) else Sum(number*price) end AS outmoney, depotname, Sum(number) AS outnumber from s_goodsnum1 where sign=- 1 AND adddate >= '2024-09-01' and adddate <= '2024-09-01' group by depotname ) d on a.depotname = d.depotname ) LEFT JOIN ( SELECT case when Sum(number) = 0 then ifnull(Sum(sign*number), 0) else Sum(sign*number*price) end AS inmoney, depotname, CASE WHEN Sum(number) = 0 THEN ifnull(Sum(sign*number), 0) ELSE Sum(sign*number) END AS innumber from s_goodsnum1 where sign= 1 AND adddate >= '2024-09-01' and adddate <= '2024-09-01' group by depotname ) e on a.depotname = e.depotname where 1=1 limit 0,90 [ RunTime:141.426758s ] --------------------------------------------------------------- [ 2024-09-01T16:41:33+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stock_sum.html [ sql ] [ DB ] CONNECT:[ UseTime:0.007812s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.005859s ] --------------------------------------------------------------- [ 2024-09-01T16:41:33+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.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-09-01T16:45:35+08:00 ] 101.78.12.254 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=goodsname&value=%E5%85%AD%E5%81%8F&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.036133s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%六偏%' [ RunTime:0.027343s ] [ 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 goodsname like '%六偏%' ) 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-09-01' 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-09-01' AND adddate <= '2024-09-01' 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-09-01' AND adddate <= '2024-09-01' 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-09-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.907227s ] --------------------------------------------------------------- [ 2024-09-01T16:54:24+08:00 ] 101.78.12.254 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=goodsname&value=%E6%B0%B4%E7%8E%BB%E7%92%83&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%水玻璃%' [ RunTime:0.009766s ] [ 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 goodsname like '%水玻璃%' ) 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-09-01' 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-09-01' AND adddate <= '2024-09-01' 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-09-01' AND adddate <= '2024-09-01' 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-09-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.800781s ] --------------------------------------------------------------- [ 2024-09-01T16:54:45+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2021-09-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodsname&value=%E6%B0%B4%E7%8E%BB%E7%92%83&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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%水玻璃%' [ RunTime:0.010743s ] [ 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 goodsname like '%水玻璃%' ) 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-09-01' 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 >= '2021-09-01' AND adddate <= '2024-09-01' 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 >= '2021-09-01' AND adddate <= '2024-09-01' 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 < '2021-09-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.841796s ] --------------------------------------------------------------- [ 2024-09-01T18:30:33+08:00 ] 101.78.12.254 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.010742s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'zrh' AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-09-01 18:30:33',`web_session_id`='dm6fpnjmel4h3fcqaofapdpr35' WHERE `id` = 15 [ RunTime:0.004882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.020508s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '101.78.12.254') [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-09-01T18:30:35+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-09-01T18:30:37+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/index/content.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.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2024-09-01' AND '2024-09-01' LIMIT 1 [ RunTime:0.038086s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-09-01' AND '2024-09-01' LIMIT 1 [ RunTime:0.022460s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.047852s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.003906s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.017578s ] [ 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-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.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.031250s ] [ 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.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-09-01' 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.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.019532s ] [ 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.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-08-31' LIMIT 1 [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-09-01' 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.023437s ] [ 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.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-09-01' 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.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-28' LIMIT 1 [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-08-29' LIMIT 1 [ RunTime:0.019531s ] [ 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 ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-09-01' LIMIT 1 [ RunTime:0.020507s ] --------------------------------------------------------------- [ 2024-09-01T18:30:46+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/cgreport/cg_detail.html [ 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.041015s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.004882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-09-01T18:30:48+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.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-09-01' and adddate <='2024-09-01'order by billdetailid DESC [ RunTime:0.605469s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-09-01' and adddate <='2024-09-01'order by billdetailid DESC limit 0,90 [ RunTime:0.594726s ] --------------------------------------------------------------- [ 2024-09-01T18:30:56+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/custom/select_custom.html?dw=%E4%BE%9B%E5%BA%94%E5%95%86 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'custom' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-09-01T18:30:57+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/custom/selectcustom_data.html?dw=%E4%BE%9B%E5%BA%94%E5%95%86&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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE `type` LIKE '%供应商%' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT * FROM `custom` WHERE `type` LIKE '%供应商%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2024-09-01T18:31:10+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=2021-09-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E5%8F%98%E9%80%9F%E7%AE%B1&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.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='铅锌矿仓库' and goodsname like '%变速箱%'order by billdetailid DESC [ RunTime:0.028320s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='铅锌矿仓库' and goodsname like '%变速箱%'order by billdetailid DESC limit 0,90 [ RunTime:0.020508s ] --------------------------------------------------------------- [ 2024-09-01T18:32: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=2021-09-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E6%8B%96%E6%8B%89%E6%9C%BA%E5%8F%98%E9%80%9F%E7%AE%B1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='铅锌矿仓库' and goodsname like '%拖拉机变速箱%'order by billdetailid DESC [ RunTime:0.017578s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='铅锌矿仓库' and goodsname like '%拖拉机变速箱%'order by billdetailid DESC limit 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-01T18:32:17+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=2021-09-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E6%8B%96%E6%8B%89%E6%9C%BA&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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='铅锌矿仓库' and goodsname like '%拖拉机%'order by billdetailid DESC [ RunTime:0.018555s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='铅锌矿仓库' and goodsname like '%拖拉机%'order by billdetailid DESC limit 0,90 [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2024-09-01T18:32:41+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=2021-09-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E5%8F%98%E9%80%9F&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.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.005860s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='铅锌矿仓库' and goodsname like '%变速%'order by billdetailid DESC [ RunTime:0.024414s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='铅锌矿仓库' and goodsname like '%变速%'order by billdetailid DESC limit 0,90 [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2024-09-01T18:32:48+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=2021-09-01&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&custname=&goodscode=&goodsname=%E5%8F%98%E9%80%9F&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='嘎西仓储' and goodsname like '%变速%'order by billdetailid DESC [ RunTime:0.016601s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='嘎西仓储' and goodsname like '%变速%'order by billdetailid DESC limit 0,90 [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2024-09-01T18:33: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=2021-09-01&enddate=&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E5%8F%98%E9%80%9F&goodscategory= [ 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.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='铜矿仓库' and goodsname like '%变速%'order by billdetailid DESC [ RunTime:0.023437s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-09-01' and adddate <='2024-09-01' and depotname='铜矿仓库' and goodsname like '%变速%'order by billdetailid DESC limit 0,90 [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2024-09-01T18:33:58+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stock_sum.html [ sql ] [ DB ] CONNECT:[ UseTime:0.018554s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2024-09-01T18:33:58+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.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-09-01T18:34:18+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2021-09-01&enddate=&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodsname&value=%E5%8F%98%E9%80%9F%E7%AE%B1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%变速箱%' [ RunTime:0.009766s ] [ 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 goodsname like '%变速箱%' ) 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-09-01' 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 >= '2021-09-01' AND adddate <= '2024-09-01' 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 >= '2021-09-01' AND adddate <= '2024-09-01' 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 < '2021-09-01' and depotname='铜矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.745117s ] --------------------------------------------------------------- [ 2024-09-01T18:35:00+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2021-09-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodsname&value=%E5%8F%98%E9%80%9F%E7%AE%B1&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.027343s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%变速箱%' [ RunTime:0.009766s ] [ 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 goodsname like '%变速箱%' ) 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-09-01' 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 >= '2021-09-01' AND adddate <= '2024-09-01' 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 >= '2021-09-01' AND adddate <= '2024-09-01' 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 < '2021-09-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.924805s ] --------------------------------------------------------------- [ 2024-09-01T18:35:30+08:00 ] 101.78.12.254 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=3000&startdate=2021-09-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodsname&value=%E5%8F%98%E9%80%9F%E7%AE%B1&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.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%变速箱%' [ RunTime:0.012695s ] [ 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 goodsname like '%变速箱%' ) 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-09-01' 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 >= '2021-09-01' AND adddate <= '2024-09-01' 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 >= '2021-09-01' AND adddate <= '2024-09-01' 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 < '2021-09-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,3000 [ RunTime:1.910157s ]