--------------------------------------------------------------- [ 2023-05-19T08:37:10+08:00 ] 202.62.102.185 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.017578s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.036132s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'FC' AND `password` = 'MDAwMDAwMDAwMIaKfbE' LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '纸浆厂库管' AND `status` = 1 LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-05-19 08:37:10',`web_session_id`='offvlp4l11lndb1llkbumhvv90' WHERE `id` = 24 [ RunTime:0.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.018554s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'FC' , '费成' , '202.62.102.185') [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2023-05-19T08:37:11+08:00 ] 202.62.102.185 GET 103.45.248.127:8001/home [ 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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-05-19T08:37:13+08:00 ] 202.62.102.185 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.063476s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' LIMIT 1 [ RunTime:0.186523s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.044922s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.007812s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-13' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-14' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-15' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-16' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-17' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-18' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-19' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-13' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-14' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-15' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-16' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-17' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-18' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-19' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-13' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-14' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-15' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-16' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-17' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-18' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-19' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-13' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-14' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-15' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-16' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-17' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-18' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-19' LIMIT 1 [ RunTime:0.026367s ] --------------------------------------------------------------- [ 2023-05-19T08:39:15+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_info.html?type=CG&billcode=CG-2023-05-18-0001 [ 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.016602s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'CG-2023-05-18-0001' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.098633s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'CG-2023-05-18-0001' [ RunTime:0.315429s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T08:39:50+08:00 ] 43.252.247.123 POST 103.45.248.127:8001/index/bill/save_bill.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.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016602s ] [ sql ] [ SQL ] UPDATE `bill` SET `type`='采购入库',`inorout`='入库',`newtime`='2023-05-18 10:04:08',`billcode`='CG-2023-05-18-0001',`makedate`='2023-05-18',`maker`='杨雅雯',`adddate`='2023-05-18',`depotname`='嘎西仓储',`custname`='付现采购',`operator`='孙干智',`originalcode`='',`note`='',`updateman`='杨雅雯',`updatetime`='2023-05-19' WHERE `billid` = 40111 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.014648s ] [ sql ] [ SQL ] DELETE FROM `billdetail` WHERE `billcode` = 'CG-2023-05-18-0001' [ RunTime:0.116211s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17746' , '硫化钠' , '25KG/袋' , '吨' , 5620 , 64 , 359680 , '第二批硫化钠' , 5620 , 'CG-2023-05-18-0001' , 1) [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-05-19T08:39:51+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90&startdate=&enddate=2023-05-18&depotname=&custname=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-18' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-18' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.060547s ] --------------------------------------------------------------- [ 2023-05-19T08:40:13+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90&startdate=&enddate=2023-05-19&depotname=&custname=%E4%BB%98%E7%8E%B0%E9%87%87%E8%B4%AD&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `custname` LIKE '%付现采购%' LIMIT 1 [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `custname` LIKE '%付现采购%' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.054688s ] --------------------------------------------------------------- [ 2023-05-19T08:40:30+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90&startdate=2023-04-19&enddate=2023-05-19&depotname=&custname=%E4%BB%98%E7%8E%B0%E9%87%87%E8%B4%AD&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-04-19' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `custname` LIKE '%付现采购%' LIMIT 1 [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-04-19' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `custname` LIKE '%付现采购%' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.060547s ] --------------------------------------------------------------- [ 2023-05-19T08:40:35+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&type=CG&billcode=CG-2023-04-22-0001 [ 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.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'CG-2023-04-22-0001' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'CG-2023-04-22-0001' [ RunTime:0.114258s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T08:40:42+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90&startdate=2023-04-26&enddate=2023-05-19&depotname=&custname=%E4%BB%98%E7%8E%B0%E9%87%87%E8%B4%AD&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.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 `bill` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `custname` LIKE '%付现采购%' LIMIT 1 [ RunTime:0.041016s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `custname` LIKE '%付现采购%' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.066406s ] --------------------------------------------------------------- [ 2023-05-19T08:40:46+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_info.html?type=CG [ 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.016601s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.117188s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2023-05-19' AND `type` = '采购入库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T08:41:10+08:00 ] 43.252.247.123 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.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'custom' AND `show` = 1 ORDER BY `showid` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-05-19T08:41:11+08:00 ] 43.252.247.123 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.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE `type` LIKE '%供应商%' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT * FROM `custom` WHERE `type` LIKE '%供应商%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-05-19T08:41:26+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%85%A5%E5%BA%93&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8 [ 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.020507s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2023-05-19T08:41:31+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%85%A5%E5%BA%93&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8 [ 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.016601s ] [ 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.000977s ] --------------------------------------------------------------- [ 2023-05-19T08:41:35+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.002929s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013671s ] [ 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 [ RunTime:0.015625s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:9.145508s ] --------------------------------------------------------------- [ 2023-05-19T08:41:39+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.039062s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ 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 [ RunTime:0.014648s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:7.696289s ] --------------------------------------------------------------- [ 2023-05-19T08:42:00+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&page=1&limit=90&field=&value=%E5%85%B6%E4%BB%96%E8%B4%B9%E7%94%A8&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.014649s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:8.080078s ] --------------------------------------------------------------- [ 2023-05-19T08:42:29+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&page=1&limit=90&field=&value=%E5%85%B6%E4%BB%96%E8%B4%B9%E7%94%A8&goodscategory= [ 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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.020508s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:7.575195s ] --------------------------------------------------------------- [ 2023-05-19T08:42:50+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&page=1&limit=90&field=goodsname&value=%E5%85%B6%E4%BB%96%E8%B4%B9%E7%94%A8&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.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ 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 goodsname like '%其他费用%' [ RunTime:0.009765s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%其他费用%' limit 0,90 [ RunTime:7.767579s ] --------------------------------------------------------------- [ 2023-05-19T08:42:54+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/goods_info.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.016602s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T08:43:39+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&enddate=&field=&value=&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 [ RunTime:7.809570s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 limit 0,90 [ RunTime:7.712890s ] --------------------------------------------------------------- [ 2023-05-19T08:43:58+08:00 ] 43.252.247.123 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.017579s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T08:43:59+08:00 ] 43.252.247.123 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T08:44:18+08:00 ] 43.252.247.123 POST 103.45.248.127:8001/index/goods/save_goods.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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G17751' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G17751' , '其他费用' , '运输等其他费用' , 'QTFY' , '' , '吨' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.014649s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G17751' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G17751' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G17751' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G17751' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G17751' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-05-19T08:44:27+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&page=1&limit=90&field=goodsname&value=%E5%85%B6%E4%BB%96%E8%B4%B9%E7%94%A8&goodscategory= [ 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ 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 goodsname like '%其他费用%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%其他费用%' limit 0,90 [ RunTime:7.902344s ] --------------------------------------------------------------- [ 2023-05-19T08:45:05+08:00 ] 43.252.247.123 POST 103.45.248.127:8001/index/bill/save_bill.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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'CG-2023-05-19-0001' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `custname` , `operator` , `originalcode` , `note`) VALUES ('采购入库' , '入库' , '2023-05-19 08:40:46' , 'CG-2023-05-19-0001' , '2023-05-19' , '杨雅雯' , '2023-05-19' , '嘎西仓储' , '付现采购' , '孙干智' , '' , '铅锌矿') [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.012696s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17751' , '其他费用' , '' , '吨' , 2000 , 64 , 128000 , '第一批硫化钠广州到万象，万象到嘎西运费' , 2000 , 'CG-2023-05-19-0001' , 1) [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T08:45:07+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90&startdate=2023-04-26&enddate=2023-05-19&depotname=&custname=%E4%BB%98%E7%8E%B0%E9%87%87%E8%B4%AD&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013671s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `custname` LIKE '%付现采购%' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `custname` LIKE '%付现采购%' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.059570s ] --------------------------------------------------------------- [ 2023-05-19T08:45:54+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&enddate=&field=&value=&zero=true&goodscategory= [ 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.021484s ] [ 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 ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 [ RunTime:7.778321s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 limit 0,90 [ RunTime:10.260742s ] --------------------------------------------------------------- [ 2023-05-19T08:46:54+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_info.html?type=DC [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'DC' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.108399s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2023-05-19' AND `type` = '调出仓库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.031250s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T08:46:55+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90&startdate=&enddate=2023-05-18&depotname=&depotname1=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ sql ] [ DB ] CONNECT:[ UseTime:0.002929s ] 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.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-18' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-18' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.054688s ] --------------------------------------------------------------- [ 2023-05-19T08:46:57+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_info.html?type=DC [ 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'DC' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.109375s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.013671s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2023-05-19' AND `type` = '调出仓库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.034179s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T08:47:05+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%87%BA%E5%BA%93&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8 [ 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.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013671s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T08:47:13+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.013672s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:7.708984s ] --------------------------------------------------------------- [ 2023-05-19T08:47:24+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&page=1&limit=90&field=goodscode&value=17746&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.016601s ] [ 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 '%17746%' [ RunTime:0.005859s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodscode like '%17746%' limit 0,90 [ RunTime:7.701172s ] --------------------------------------------------------------- [ 2023-05-19T08:49:54+08:00 ] 202.62.102.185 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004882s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.029296s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'FC' AND `password` = 'MDAwMDAwMDAwMIaKfbE' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '纸浆厂库管' AND `status` = 1 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-05-19 08:49:54',`web_session_id`='gr5prb1mqo55ehc741lr5fgl86' WHERE `id` = 24 [ RunTime:0.005859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.016602s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'FC' , '费成' , '202.62.102.185') [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-05-19T08:49:56+08:00 ] 202.62.102.185 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.017578s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T08:49:57+08:00 ] 202.62.102.185 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' LIMIT 1 [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.015625s ] [ 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.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-13' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-14' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-15' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-16' LIMIT 1 [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-17' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-18' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-05-19' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-13' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-14' LIMIT 1 [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-15' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-16' LIMIT 1 [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-17' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-18' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-05-19' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-13' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-14' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-15' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-16' LIMIT 1 [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-17' LIMIT 1 [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-18' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-05-19' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-13' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-14' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-15' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-16' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-17' LIMIT 1 [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-18' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-05-19' LIMIT 1 [ RunTime:0.017578s ] --------------------------------------------------------------- [ 2023-05-19T10:27:31+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ 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.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T10:27:33+08:00 ] 202.62.99.65 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ 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.014649s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T10:27:52+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=+&zero=false&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '% %' and goodscategory in ("选厂药剂") [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '% %' and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:14.488281s ] --------------------------------------------------------------- [ 2023-05-19T10:27:55+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=&enddate=&field=goodsname&value=+&zero=false&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '% %' and goodscategory in ("选厂药剂") [ RunTime:0.007812s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '% %' and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:13.725586s ] --------------------------------------------------------------- [ 2023-05-19T10:28:12+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=&enddate=&field=&value=+&zero=false&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.025390s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscategory in ("选厂药剂") [ RunTime:0.006836s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:12.208008s ] --------------------------------------------------------------- [ 2023-05-19T10:29:38+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=&enddate=&field=&value=+&zero=true&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013671s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000976s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodscategory in ("选厂药剂") [ RunTime:18.431641s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:15.265625s ] --------------------------------------------------------------- [ 2023-05-19T10:29:40+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=&value=+&zero=true&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodscategory in ("选厂药剂") [ RunTime:13.676758s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:16.199219s ] --------------------------------------------------------------- [ 2023-05-19T10:38:14+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=+%E7%A1%AB%E5%8C%96%E9%92%A0&zero=true&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000976s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '% 硫化钠%' and goodscategory in ("选厂药剂") [ RunTime:11.919922s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '% 硫化钠%' and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:11.157226s ] --------------------------------------------------------------- [ 2023-05-19T10:39:43+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=%E9%BB%84%E8%8D%AF&zero=false&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.016601s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%黄药%' and goodscategory in ("选厂药剂") [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%黄药%' and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:11.755860s ] --------------------------------------------------------------- [ 2023-05-19T11:27:49+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%87%BA%E5%BA%93&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8 [ 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.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T11:27:57+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.002929s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ 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.015625s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:7.240235s ] --------------------------------------------------------------- [ 2023-05-19T11:28:12+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&page=1&limit=90&field=goodscode&value=17751&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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%17751%' [ RunTime:0.004883s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodscode like '%17751%' limit 0,90 [ RunTime:8.157227s ] --------------------------------------------------------------- [ 2023-05-19T11:28:39+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' AND `depotname` = '铅锌矿仓库' AND `depotname1` = '纸浆厂仓库' LIMIT 1 [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' AND `depotname` = '铅锌矿仓库' AND `depotname1` = '纸浆厂仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.051758s ] --------------------------------------------------------------- [ 2023-05-19T11:28:45+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90&startdate=2023-04-26&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` = '铅锌矿仓库' AND `depotname1` = '纸浆厂仓库' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` = '铅锌矿仓库' AND `depotname1` = '纸浆厂仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.046875s ] --------------------------------------------------------------- [ 2023-05-19T11:28:47+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&type=DC&billcode=DC-2023-04-29-0001 [ 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.019531s ] [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'DC-2023-04-29-0001' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'DC' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'DC-2023-04-29-0001' [ RunTime:0.136719s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T11:28:55+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&type=DC&billcode=DC-2023-05-17-0001 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'DC-2023-05-17-0001' LIMIT 1 [ RunTime:0.005859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'DC' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'DC-2023-05-17-0001' [ RunTime:0.128906s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T11:29:03+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_info.html?type=DC [ 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.018554s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'DC' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.114257s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2023-05-19' AND `type` = '调出仓库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.041993s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T11:29:20+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&type=CG&billcode=CG-2023-05-19-0001 [ 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.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'CG-2023-05-19-0001' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'CG-2023-05-19-0001' [ RunTime:0.125000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T11:29:32+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%87%BA%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93 [ 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.018554s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T11:29:48+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90 [ 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.015625s ] [ 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.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.020508s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:12.361328s ] --------------------------------------------------------------- [ 2023-05-19T11:29:58+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E7%9B%B4%E6%8E%A5%E5%A4%B4&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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%直接头%' [ RunTime:0.007813s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%直接头%' limit 0,90 [ RunTime:11.605468s ] --------------------------------------------------------------- [ 2023-05-19T11:30:10+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E7%9B%B4%E6%8E%A5%E5%A4%B4&goodscategory= [ 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.015625s ] [ 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 ] select id from goods where 1=1 and goodsname like '%直接头%' [ RunTime:0.012696s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%直接头%' limit 0,90 [ RunTime:11.529297s ] --------------------------------------------------------------- [ 2023-05-19T11:30:25+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=PE&goodscategory= [ 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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%PE%' [ RunTime:0.006836s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%PE%' limit 0,90 [ RunTime:11.629883s ] --------------------------------------------------------------- [ 2023-05-19T11:32:21+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=specification&value=100&goodscategory= [ 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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ 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 specification like '%100%' [ RunTime:0.026367s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and specification like '%100%' limit 0,90 [ RunTime:11.742188s ] --------------------------------------------------------------- [ 2023-05-19T11:33:30+08:00 ] 43.252.247.123 POST 103.45.248.127:8001/index/bill/save_bill.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.018555s ] [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'DC-2023-05-19-0001' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `depotname1` , `operator` , `originalcode` , `note`) VALUES ('调出仓库' , '出库' , '2023-05-19 08:46:57' , 'DC-2023-05-19-0001' , '2023-05-19' , '杨雅雯' , '2023-05-19' , '嘎西仓储' , '铅锌矿仓库' , '孙干智' , '' , '') [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE `depotname` = '嘎西仓储' AND `goodscode` = 'G17746' GROUP BY `goodscode` [ RunTime:8.654297s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.019531s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17746' , '硫化钠' , '25KG/袋' , '吨' , 5620 , 32 , 179840 , '第二批硫化钠的32吨' , 5620 , 'DC-2023-05-19-0001' , -1) [ RunTime:0.001954s ] [ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE `depotname` = '嘎西仓储' AND `goodscode` = 'G17751' GROUP BY `goodscode` [ RunTime:11.519531s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17751' , '其他费用' , '' , '吨' , 2000 , 36.924 , 73848 , '第一批硫化钠广州到万象，万象到嘎西运费' , 2000 , 'DC-2023-05-19-0001' , -1) [ RunTime:0.002930s ] [ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `depotname1` , `operator` , `originalcode` , `note`) VALUES ('调入仓库' , '入库' , '2023-05-19 08:46:57' , 'DR-2023-05-19-0001' , '2023-05-19' , '杨雅雯' , '2023-05-19' , '铅锌矿仓库' , '嘎西仓储' , '孙干智' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17746' , '硫化钠' , '25KG/袋' , '吨' , 5620 , 32 , 179840 , '第二批硫化钠的32吨' , 5620 , 'DR-2023-05-19-0001' , 1) [ RunTime:0.001954s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17751' , '其他费用' , '' , '吨' , 2000 , 36.924 , 73848 , '第一批硫化钠广州到万象，万象到嘎西运费' , 2000 , 'DR-2023-05-19-0001' , 1) [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T11:33:31+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90&startdate=&enddate=2023-05-18&depotname=&depotname1=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-18' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-18' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.051758s ] --------------------------------------------------------------- [ 2023-05-19T11:33:57+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=3&limit=90&field=specification&value=100&goodscategory= [ 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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.006836s ] [ sql ] [ SQL ] select id from goods where 1=1 and specification like '%100%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and specification like '%100%' limit 180,90 [ RunTime:13.962891s ] --------------------------------------------------------------- [ 2023-05-19T11:34:07+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&enddate=&field=&value=&zero=true&goodscategory= [ 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 [ RunTime:12.070312s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '嘎西仓储' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='嘎西仓储' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 limit 0,90 [ RunTime:8.208008s ] --------------------------------------------------------------- [ 2023-05-19T11:35:21+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_print.html?type=excel&billcode=DC-2023-05-18-0007 [ 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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'DC-2023-05-18-0007' LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.013671s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'DC-2023-05-18-0007' [ RunTime:0.111328s ] [ sql ] [ SQL ] SELECT sum(money) as tmoney,sum(number) as tnum FROM `billdetail` WHERE `billcode` = 'DC-2023-05-18-0007' LIMIT 1 [ RunTime:0.046875s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billname` = '调出仓库' LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `company` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT * FROM `company` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T11:35:26+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90&startdate=&enddate=2023-05-19&depotname=&depotname1=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.057617s ] --------------------------------------------------------------- [ 2023-05-19T11:36:07+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_print.html?type=excel&billcode=DC-2023-05-19-0001 [ 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.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'DC-2023-05-19-0001' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'DC-2023-05-19-0001' [ RunTime:0.123047s ] [ sql ] [ SQL ] SELECT sum(money) as tmoney,sum(number) as tnum FROM `billdetail` WHERE `billcode` = 'DC-2023-05-19-0001' LIMIT 1 [ RunTime:0.046875s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billname` = '调出仓库' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `company` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `company` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-05-19T11:50:42+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%87%BA%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93 [ 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.023438s ] [ 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.001953s ] --------------------------------------------------------------- [ 2023-05-19T11:50:56+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ 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.016602s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:11.967774s ] --------------------------------------------------------------- [ 2023-05-19T11:52:56+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E5%88%98%E6%AC%A2&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ 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 goodsname like '%刘欢%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%刘欢%' limit 0,90 [ RunTime:13.922852s ] --------------------------------------------------------------- [ 2023-05-19T11:52:58+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E7%A1%AB%E5%8C%96%E9%92%A0&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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.029297s ] [ 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 goodsname like '%硫化钠%' [ RunTime:0.010742s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%硫化钠%' limit 0,90 [ RunTime:12.273437s ] --------------------------------------------------------------- [ 2023-05-19T11:56:35+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%87%BA%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93 [ 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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-05-19T11:56:52+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&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.014649s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ 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 * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:15.008789s ] --------------------------------------------------------------- [ 2023-05-19T11:57:00+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=PE%E7%AE%A1&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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%PE管%' [ RunTime:0.007812s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%PE管%' limit 0,90 [ RunTime:13.375977s ] --------------------------------------------------------------- [ 2023-05-19T11:57:09+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=specification&value=DN100&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.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.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and specification like '%DN100%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and specification like '%DN100%' limit 0,90 [ RunTime:11.906250s ] --------------------------------------------------------------- [ 2023-05-19T11:57:35+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E6%8E%A5%E5%A4%B4&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.016602s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.012695s ] [ 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 goodsname like '%接头%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%接头%' limit 0,90 [ RunTime:11.959961s ] --------------------------------------------------------------- [ 2023-05-19T11:57:50+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E6%8E%A5%E5%A4%B4&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.017578s ] [ 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 ] select id from goods where 1=1 and goodsname like '%接头%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%接头%' limit 0,90 [ RunTime:11.506836s ] --------------------------------------------------------------- [ 2023-05-19T12:00:42+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=2&limit=90&field=goodsname&value=%E6%8E%A5%E5%A4%B4&goodscategory= [ 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.022461s ] [ 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.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%接头%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%接头%' limit 90,90 [ RunTime:12.616211s ] --------------------------------------------------------------- [ 2023-05-19T12:01:13+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodscategory&value=DN100&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ 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 goodscategory like '%DN100%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodscategory like '%DN100%' limit 0,90 [ RunTime:11.801758s ] --------------------------------------------------------------- [ 2023-05-19T12:04:33+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90&startdate=2023-04-26&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.012696s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` = '铅锌矿仓库' AND `depotname1` = '纸浆厂仓库' LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` = '铅锌矿仓库' AND `depotname1` = '纸浆厂仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.053711s ] --------------------------------------------------------------- [ 2023-05-19T12:04:55+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=%E5%88%98%E6%AC%A2&zero=false&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%刘欢%' and goodscategory in ("选厂药剂") [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%刘欢%' and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:13.261719s ] --------------------------------------------------------------- [ 2023-05-19T12:04:57+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=%E7%A1%AB%E5%8C%96%E9%92%A0&zero=false&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.020508s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%硫化钠%' and goodscategory in ("选厂药剂") [ RunTime:0.007812s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%硫化钠%' and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:12.548828s ] --------------------------------------------------------------- [ 2023-05-19T12:05:10+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=%E7%A1%AB%E5%8C%96&zero=false&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.023437s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%硫化%' and goodscategory in ("选厂药剂") [ RunTime:0.008790s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%硫化%' and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:12.251953s ] --------------------------------------------------------------- [ 2023-05-19T12:05:38+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90&startdate=2023-04-26&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.030273s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` = '嘎西仓储' AND `depotname1` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` = '嘎西仓储' AND `depotname1` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.060547s ] --------------------------------------------------------------- [ 2023-05-19T12:05:45+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-03-26&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=&goodscode=&goodsname=%E7%A1%AB%E5%8C%96%E9%92%A0&goodscategory= [ 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.016601s ] [ 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` 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 >='2023-03-26' and adddate <='2023-05-19' and depotname='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC [ RunTime:0.021484s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-03-26' and adddate <='2023-05-19' and depotname='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC limit 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2023-05-19T12:05:48+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-03-26&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=&goodscode=&goodsname=%E7%A1%AB%E5%8C%96%E9%92%A0&goodscategory= [ 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.017578s ] [ 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.000977s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-03-26' and adddate <='2023-05-19' and depotname='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC [ RunTime:0.016602s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-03-26' and adddate <='2023-05-19' and depotname='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC limit 0,90 [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2023-05-19T12:05:52+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-03-26&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E7%A1%AB%E5%8C%96%E9%92%A0&goodscategory= [ 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ 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 ='调出仓库' and adddate >='2023-03-26' and adddate <='2023-05-19' and depotname='嘎西仓储' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC [ RunTime:0.014649s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-03-26' and adddate <='2023-05-19' and depotname='嘎西仓储' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC limit 0,90 [ RunTime:0.011719s ] --------------------------------------------------------------- [ 2023-05-19T12:06:51+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-04-26&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E7%A1%AB%E5%8C%96%E9%92%A0&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ 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 ='调出仓库' and adddate >='2023-04-26' and adddate <='2023-05-19' and depotname='嘎西仓储' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") 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 ='调出仓库' and adddate >='2023-04-26' and adddate <='2023-05-19' and depotname='嘎西仓储' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC limit 0,90 [ RunTime:0.013671s ] --------------------------------------------------------------- [ 2023-05-19T12:07:00+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-03-26&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E7%A1%AB%E5%8C%96%E9%92%A0&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.020507s ] [ 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` 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 >='2023-03-26' and adddate <='2023-05-19' and depotname='嘎西仓储' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC [ RunTime:0.031250s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-03-26' and adddate <='2023-05-19' and depotname='嘎西仓储' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC limit 0,90 [ RunTime:0.019531s ] --------------------------------------------------------------- [ 2023-05-19T12:07:47+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-04-22&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E7%A1%AB%E5%8C%96%E9%92%A0&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.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2023-04-22' and adddate <='2023-05-19' and depotname='嘎西仓储' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC [ RunTime:0.020508s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-04-22' and adddate <='2023-05-19' and depotname='嘎西仓储' and depotname1='铅锌矿仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储") and goodsname like '%硫化钠%'order by billdetailid DESC limit 0,90 [ RunTime:0.011719s ] --------------------------------------------------------------- [ 2023-05-19T14:14:38+08:00 ] 202.62.99.65 POST 103.45.248.127:8001/index/bill/save_bill.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.024415s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'LY-2023-05-18-0005' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `custname` , `operator` , `originalcode` , `note`) VALUES ('领用出库' , '出库' , '2023-05-18 15:20:52' , 'LY-2023-05-18-0005' , '2023-05-18' , '小胡' , '2023-05-18' , '铅锌矿仓库' , '霸王山坑内钻' , '胡甸琼' , '' , '李正全领') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE `depotname` = '铅锌矿仓库' AND `goodscode` = 'G16783' GROUP BY `goodscode` [ RunTime:10.611328s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.020508s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G16783' , '头灯' , '宝丽来778' , '个' , 65 , 1 , 65 , '' , 65 , 'LY-2023-05-18-0005' , -1) [ RunTime:0.001954s ] [ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE `depotname` = '铅锌矿仓库' AND `goodscode` = 'G11393' GROUP BY `goodscode` [ RunTime:7.162109s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G11393' , '水平捞矛头' , 'NQ' , '个' , 120 , 1 , 120 , '' , 120 , 'LY-2023-05-18-0005' , -1) [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE `depotname` = '铅锌矿仓库' AND `goodscode` = 'G10529' GROUP BY `goodscode` [ RunTime:6.136719s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10529' , '金刚石钻头' , 'NQ' , '只' , 600 , 2 , 1200 , '' , 600 , 'LY-2023-05-18-0005' , -1) [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T14:14:39+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '领用出库' AND `adddate` BETWEEN '2023-05-01' AND '2023-05-19' AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.057618s ] --------------------------------------------------------------- [ 2023-05-19T16:31:38+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=%E4%BA%9A%E7%A1%AB%E9%85%B8%E9%92%A0&zero=false&goodscategory=%E9%80%89%E5%8E%82%E8%8D%AF%E5%89%82 [ 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.018554s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE `name` = '选厂药剂' [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE `code` LIKE 'code1/1639132696/1682758741%' [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%亚硫酸钠%' and goodscategory in ("选厂药剂") [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-05-19' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%亚硫酸钠%' and goodscategory in ("选厂药剂") limit 0,90 [ RunTime:12.078125s ] --------------------------------------------------------------- [ 2023-05-19T16:31:43+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stock_detail.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=G14519&enddate= [ 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.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-05-19T16:32:02+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/dataquery/stockdetail_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=G14519&enddate=&page=1&limit=10 [ sql ] [ DB ] CONNECT:[ UseTime:0.027344s ] 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.002929s ] [ 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_goodsnum` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(depotname) AS tp_count FROM `s_goodsnum` WHERE `depotname` = '铅锌矿仓库' AND `adddate` <= '2023-05-19' AND `goodscode` = 'G14519' LIMIT 1 [ RunTime:8.876953s ] [ sql ] [ SQL ] SELECT *,number*sign as num,money*sign as mon FROM `s_goodsnum` WHERE `depotname` = '铅锌矿仓库' AND `adddate` <= '2023-05-19' AND `goodscode` = 'G14519' ORDER BY `adddate` DESC [ RunTime:7.037109s ] --------------------------------------------------------------- [ 2023-05-19T17:17:23+08:00 ] 111.61.249.39 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = '旭叶紫' AND `password` = 'MDAwMDAwMDAwMJKNaK-xr35msp2DmoaXcZ8' LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-05-19T17:21:47+08:00 ] 111.61.249.39 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003907s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = '13102641291' AND `password` = 'MDAwMDAwMDAwMJKNaK-xr35msp2DmoaXcZ8' LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-05-19T17:21:57+08:00 ] 111.61.249.39 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = '13102641291' AND `password` = 'MDAwMDAwMDAwMJKNaK-xr35msp2DmoaXcZ8' LIMIT 1 [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T17:23:31+08:00 ] 111.61.249.39 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003907s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = '13102641291' AND `password` = 'MDAwMDAwMDAwMJKNaK-xr35msp2DmoaXcZ8' LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-05-19T17:23:32+08:00 ] 111.61.249.39 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001953s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = '13102641291' AND `password` = 'MDAwMDAwMDAwMJKNaK-xr35msp2DmoaXcZ8' LIMIT 1 [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-05-19T18:25:44+08:00 ] 43.252.247.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90&startdate=2023-04-26&enddate=2023-05-19&depotname=&custname=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.026367s ] [ 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.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-04-26' AND '2023-05-19' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.056641s ]