--------------------------------------------------------------- [ 2024-11-13T10:43:57+08:00 ] 114.129.30.175 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'HDQ' AND `password` = 'MDAwMDAwMDAwMIaKea-xiX6u' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.038086s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '铅锌矿库管' AND `status` = 1 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-11-13 10:43:57',`web_session_id`='qjfofgb0o1arqd4e45ecahvu31' WHERE `id` = 22 [ RunTime:0.005859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.020508s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'HDQ' , '杨金富' , '114.129.30.175') [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-11-13T10:43:59+08:00 ] 114.129.30.175 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.028321s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-11-13T10:44:07+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/index/content.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.020508s ] [ 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.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-11-01' AND '2024-11-13' LIMIT 1 [ RunTime:0.034179s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-11-01' AND '2024-11-13' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.004883s ] [ 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.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-07' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-08' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-09' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-10' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-11' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-12' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-13' LIMIT 1 [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-07' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-08' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-09' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-10' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-11' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-12' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-13' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-07' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-08' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-09' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-10' LIMIT 1 [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-11' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-12' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-13' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-07' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-08' LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-09' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-10' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-11' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-12' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-13' LIMIT 1 [ RunTime:0.020508s ] --------------------------------------------------------------- [ 2024-11-13T10:44:42+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004882s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024415s ] [ 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.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.019532s ] [ 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.017578s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-11-13T10:44:44+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_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.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-11-01' AND '2024-11-13' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.491211s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-11-01' AND '2024-11-13' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.597656s ] --------------------------------------------------------------- [ 2024-11-13T10:45:19+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%92%A2%E7%AE%A1&detailnote= [ 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.029297s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铅锌矿仓库' AND `type` = '采购入库' AND `goodsname` LIKE '%钢管%' LIMIT 1 [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铅锌矿仓库' AND `type` = '采购入库' AND `goodsname` LIKE '%钢管%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.667969s ] --------------------------------------------------------------- [ 2024-11-13T11:32:39+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E7%94%B5%E7%BC%86&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.026367s ] [ 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.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铅锌矿仓库' AND `type` = '采购入库' AND `goodsname` LIKE '%电缆%' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铅锌矿仓库' AND `type` = '采购入库' AND `goodsname` LIKE '%电缆%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.651367s ] --------------------------------------------------------------- [ 2024-11-13T11:43:29+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%AB%98%E5%8E%8B&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.008789s ] 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铅锌矿仓库' AND `type` = '采购入库' AND `goodsname` LIKE '%高压%' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铅锌矿仓库' AND `type` = '采购入库' AND `goodsname` LIKE '%高压%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.677735s ] --------------------------------------------------------------- [ 2024-11-13T11:49:17+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/kcreport/stock_sum.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.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2024-11-13T11:49:19+08:00 ] 114.129.30.175 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.021485s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-11-13T11:49:51+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2021-01-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G14653&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.017578s ] [ 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 and goodscode like '%G14653%' [ 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 '%G14653%' ) 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-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.961914s ] --------------------------------------------------------------- [ 2024-11-13T11:50:26+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2021-01-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10610&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G10610%' [ 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 '%G10610%' ) 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-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.905274s ] --------------------------------------------------------------- [ 2024-11-13T11:50:49+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2021-01-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G16131&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.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G16131%' [ 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 '%G16131%' ) 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-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.863281s ] --------------------------------------------------------------- [ 2024-11-13T11:51:12+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2021-01-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G16131&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.040039s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G16131%' [ RunTime:0.004882s ] [ 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 '%G16131%' ) 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-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.895508s ] --------------------------------------------------------------- [ 2024-11-13T11:51:47+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2021-01-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G14023&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.023438s ] [ 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 ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G14023%' [ 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 goodscode like '%G14023%' ) 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-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.959961s ] --------------------------------------------------------------- [ 2024-11-13T11:52:48+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2021-01-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G12824&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.027344s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G12824%' [ RunTime:0.011719s ] [ 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 '%G12824%' ) 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-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.957031s ] --------------------------------------------------------------- [ 2024-11-13T11:53:19+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2021-01-01&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G12845&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025390s ] [ 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 and goodscode like '%G12845%' [ 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 '%G12845%' ) 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-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' AND adddate <= '2024-11-13' 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-01-01' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.975586s ] --------------------------------------------------------------- [ 2024-11-13T13:19:55+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%8A%93%E9%92%89&detailnote= [ 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.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铅锌矿仓库' AND `type` = '采购入库' AND `goodsname` LIKE '%抓钉%' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铅锌矿仓库' AND `type` = '采购入库' AND `goodsname` LIKE '%抓钉%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.711914s ] --------------------------------------------------------------- [ 2024-11-13T15:59:55+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%92%8E%E6%9D%86&detailnote= [ 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.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铅锌矿仓库' AND `type` = '采购入库' AND `goodsname` LIKE '%钎杆%' LIMIT 1 [ RunTime:0.037110s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铅锌矿仓库' AND `type` = '采购入库' AND `goodsname` LIKE '%钎杆%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.680664s ] --------------------------------------------------------------- [ 2024-11-13T16:00:46+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%92%8E%E6%9D%86&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.040039s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '纸浆厂仓库' AND `type` = '销售提货' AND `goodsname` LIKE '%钎杆%' LIMIT 1 [ RunTime:0.065430s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '纸浆厂仓库' AND `type` = '销售提货' AND `goodsname` LIKE '%钎杆%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.658203s ] --------------------------------------------------------------- [ 2024-11-13T16:01:01+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%92%8E%E6%9D%86&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铜矿仓库' AND `type` = '销售提货' AND `goodsname` LIKE '%钎杆%' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '铜矿仓库' AND `type` = '销售提货' AND `goodsname` LIKE '%钎杆%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.619141s ] --------------------------------------------------------------- [ 2024-11-13T16:01:53+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=PE&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.024414s ] [ 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.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '纸浆厂仓库' AND `type` = '销售提货' AND `goodsname` LIKE '%PE%' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '纸浆厂仓库' AND `type` = '销售提货' AND `goodsname` LIKE '%PE%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.648437s ] --------------------------------------------------------------- [ 2024-11-13T16:02:00+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=PVC&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.026367s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '纸浆厂仓库' AND `type` = '销售提货' AND `goodsname` LIKE '%PVC%' LIMIT 1 [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` = '纸浆厂仓库' AND `type` = '销售提货' AND `goodsname` LIKE '%PVC%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.611328s ] --------------------------------------------------------------- [ 2024-11-13T16:02:14+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=PVC&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.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodsname` LIKE '%PVC%' LIMIT 1 [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodsname` LIKE '%PVC%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.126953s ] --------------------------------------------------------------- [ 2024-11-13T16:04:17+08:00 ] 114.129.30.175 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2020-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=PE&detailnote= [ 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.023437s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodsname` LIKE '%PE%' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2020-01-01' AND '2024-11-13' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodsname` LIKE '%PE%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.189454s ]