--------------------------------------------------------------- [ 2023-11-09T09:02:46+08:00 ] 202.62.99.245 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.029297s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'ZRH' AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-11-09 09:02:46',`web_session_id`='lhtgi16d8pa9oofvpj78d7g4m5' WHERE `id` = 15 [ RunTime:0.007812s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.032226s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '202.62.99.245') [ RunTime:0.004883s ] --------------------------------------------------------------- [ 2023-11-09T09:02:48+08:00 ] 202.62.99.245 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.005860s ] --------------------------------------------------------------- [ 2023-11-09T09:02:49+08:00 ] 202.62.99.245 GET 103.45.248.127:8001/index/index/content.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.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-11-01' AND '2023-11-09' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2023-11-01' AND '2023-11-09' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.004883s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-03' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-04' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-05' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-06' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-07' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-08' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-09' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-03' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-04' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-05' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-06' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-07' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-08' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-09' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-03' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-04' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-05' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-06' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-07' LIMIT 1 [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-08' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-09' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-03' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-04' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-05' LIMIT 1 [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-06' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-07' LIMIT 1 [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-08' LIMIT 1 [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-09' LIMIT 1 [ RunTime:0.023437s ] --------------------------------------------------------------- [ 2023-11-09T09:02:57+08:00 ] 202.62.99.245 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.018554s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'billdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-11-09T09:02:59+08:00 ] 202.62.99.245 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90 [ 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.035156s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-11-01' AND '2023-11-09' LIMIT 1 [ RunTime:0.525390s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-11-01' AND '2023-11-09' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.573242s ] --------------------------------------------------------------- [ 2023-11-09T09:03:40+08:00 ] 202.62.99.245 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2023-09-26&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%8B%89%E6%9D%86&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.034180s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.039063s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-09-26' AND '2023-11-09' AND `goodsname` LIKE '%拉杆%' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-09-26' AND '2023-11-09' AND `goodsname` LIKE '%拉杆%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.046875s ] --------------------------------------------------------------- [ 2023-11-09T14:16:09+08:00 ] 202.62.106.122 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.039063s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'WYH' AND `password` = 'MDAwMDAwMDAwMI9noICxiYKw' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '嘎西 仓储' AND `status` = 1 LIMIT 1 [ RunTime:0.065430s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-11-09 14:16:09',`web_session_id`='o3va97ot07pfavhnghb6u6gcb4' WHERE `id` = 23 [ RunTime:0.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.024415s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'WYH' , 'WYH' , '202.62.106.122') [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2023-11-09T14:16:11+08:00 ] 202.62.106.122 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ 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.001953s ] --------------------------------------------------------------- [ 2023-11-09T14:16:13+08:00 ] 202.62.106.122 GET 103.45.248.127:8001/index/index/content.html [ 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.026367s ] [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2023-11-01' AND '2023-11-09' LIMIT 1 [ RunTime:0.049804s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2023-11-01' AND '2023-11-09' LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.035156s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.004883s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.036132s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-03' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-04' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-05' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-06' LIMIT 1 [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-07' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-08' LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-11-09' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-03' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-04' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-05' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-06' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-07' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-08' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-11-09' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-03' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-04' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-05' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-06' LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-07' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-08' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-11-09' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-03' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-04' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-05' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-06' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-07' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-08' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-11-09' LIMIT 1 [ RunTime:0.019532s ] --------------------------------------------------------------- [ 2023-11-09T14:16:16+08:00 ] 202.62.106.122 GET 103.45.248.127:8001/index/dataquery/stock_search.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.040039s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ 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 `fieldshow` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'stock' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-11-09T14:16:32+08:00 ] 202.62.106.122 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.018554s ] [ 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-11-09' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:14.899415s ] --------------------------------------------------------------- [ 2023-11-09T14:16:43+08:00 ] 202.62.106.122 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%B9%E8%BD%A6%E6%B2%B9&zero=false&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.034180s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.009766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%刹车油%' [ 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-11-09' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%刹车油%' limit 0,90 [ RunTime:14.656250s ] --------------------------------------------------------------- [ 2023-11-09T14:16:58+08:00 ] 202.62.106.122 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%B9%E8%BD%A6%E6%B2%B9&zero=false&goodscategory= [ 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.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.028320s ] [ 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.011718s ] [ 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-11-09' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%刹车油%' limit 0,90 [ RunTime:14.614258s ]