---------------------------------------------------------------
[ 2024-08-25T09:14:59+08:00 ] 114.129.26.83 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.030273s ]
[ sql ] [ SQL ] SELECT * FROM `user` WHERE  `username` = 'YYW'  AND `password` = 'MDAwMDAwMDAwMJ6OoGqxiYKw' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT * FROM `role` WHERE  `rolename` = '嘎西 仓储'  AND `status` = 1 LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] UPDATE `user`  SET `logintime`='2024-08-25 09:14:59',`web_session_id`='1r5u6fjgteqq0cte72p3orbqs4'  WHERE  `id` = 14 [ RunTime:0.004883s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.019531s ]
[ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'YYW' , '杨雅雯' , '114.129.26.83') [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-08-25T09:15:00+08:00 ] 114.129.26.83 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.026367s ]
[ 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.000976s ]
---------------------------------------------------------------
[ 2024-08-25T09:15:02+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/index/content.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ 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 ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储')  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25' LIMIT 1 [ RunTime:0.046875s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储')  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25' 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.025391s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.003906s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` <> '调入仓库' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-08-19' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-08-20' LIMIT 1 [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-08-21' LIMIT 1 [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-08-22' LIMIT 1 [ RunTime:0.023437s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-08-23' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-08-24' LIMIT 1 [ RunTime:0.024414s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-08-19' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-08-20' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-08-21' LIMIT 1 [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-08-22' LIMIT 1 [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-08-23' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-08-24' LIMIT 1 [ RunTime:0.022460s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-08-19' LIMIT 1 [ RunTime:0.023437s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-08-20' LIMIT 1 [ RunTime:0.036133s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-08-21' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-08-22' LIMIT 1 [ RunTime:0.023438s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-08-23' LIMIT 1 [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-08-24' LIMIT 1 [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-08-19' LIMIT 1 [ RunTime:0.020507s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-08-20' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-08-21' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-08-22' LIMIT 1 [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-08-23' LIMIT 1 [ RunTime:0.030274s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-08-24' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-08-25' LIMIT 1 [ RunTime:0.024414s ]
---------------------------------------------------------------
[ 2024-08-25T09:15:16+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/billshow.html?type=XS
[ 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.022461s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017579s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'xsbill'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-08-25T09:15:17+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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.052735s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.089844s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.031250s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.079102s ]
---------------------------------------------------------------
[ 2024-08-25T09:15:23+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS
[ 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.020508s ]
[ 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 ] SHOW COLUMNS FROM `bill` [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = '' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.025390s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = '' [ RunTime:0.136719s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE  `makedate` = '2024-08-25'  AND `type` = '销售提货' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.037109s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T09:16:08+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/custom/select_custom.html?dw=%E5%AE%A2%E6%88%B7
[ 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.049805s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.061523s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'custom'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ]
---------------------------------------------------------------
[ 2024-08-25T09:16:09+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/custom/selectcustom_data.html?dw=%E5%AE%A2%E6%88%B7&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.147461s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.008789s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.045899s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.004883s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE  `type` LIKE '%客户%' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT * FROM `custom` WHERE  `type` LIKE '%客户%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T09:16:33+08:00 ] 114.129.26.83 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.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T09:16:48+08:00 ] 114.129.26.83 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.003906s ] 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.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.017578s ]
[ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:14.091796s ]
---------------------------------------------------------------
[ 2024-08-25T09:17:57+08:00 ] 114.129.26.83 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=goodscode&value=G10315&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.022461s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ 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 ] select id from goods where 1=1  and goodscode like '%G10315%' [ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodscode like '%G10315%' limit 0,90 [ RunTime:13.670898s ]
---------------------------------------------------------------
[ 2024-08-25T09:20:34+08:00 ] 114.129.26.83 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.020508s ]
[ 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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.028320s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'XS-2024-08-25-0001' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `custname` , `operator` , `originalcode` , `note`) VALUES ('销售提货' , '出库' , '2024-08-25 09:15:22' , 'XS-2024-08-25-0001' , '2024-08-25' , '杨雅雯' , '2024-08-24' , '铅锌矿仓库' , '洪老板' , '张让红' , '' , '') [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.032227s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10315' GROUP BY `goodscode` [ RunTime:8.963867s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.035157s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10315' , '电雷管' , '' , '个' , 7.84 , 400 , 3136 , '2024年8月24号 张经理带走 电雷管4盒（400发）' , 7.84 , 'XS-2024-08-25-0001' , -1) [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T09:20:36+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&page=1&limit=90
[ 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.023438s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.028321s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.034179s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.063476s ]
---------------------------------------------------------------
[ 2024-08-25T09:20:49+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS
[ 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.066406s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.045899s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.040039s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = '' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = '' [ RunTime:0.132812s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE  `makedate` = '2024-08-25'  AND `type` = '销售提货' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T09:20:58+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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.029297s ]
[ 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.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.033204s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.070313s ]
---------------------------------------------------------------
[ 2024-08-25T09:21:03+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/billshow.html?type=XS
[ 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.025390s ]
[ 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` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'xsbill'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ]
---------------------------------------------------------------
[ 2024-08-25T09:21:04+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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.068359s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.058594s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.040039s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.035157s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.062500s ]
---------------------------------------------------------------
[ 2024-08-25T09:21:15+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS
[ 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.035156s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026368s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.028320s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = '' LIMIT 1 [ RunTime:0.000000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = '' [ RunTime:0.118165s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE  `makedate` = '2024-08-25'  AND `type` = '销售提货' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T09:21:29+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&page=1&limit=90
[ 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.039062s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.030273s ]
[ 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 '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.029296s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.084961s ]
---------------------------------------------------------------
[ 2024-08-25T09:21:55+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/bill_detail.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.025390s ]
[ 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.016602s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T09:21:57+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.057617s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.043945s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.003906s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.036133s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.483398s ]
[ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.638672s ]
---------------------------------------------------------------
[ 2024-08-25T09:22:09+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=%E9%94%80%E5%94%AE%E9%80%80%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote=
[ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.109375s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.039063s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.004883s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.102539s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储')  AND `type` = '销售退货' LIMIT 1 [ RunTime:0.493164s ]
[ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储')  AND `type` = '销售退货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.558594s ]
---------------------------------------------------------------
[ 2024-08-25T09:22:20+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/billshow.html?type=XT
[ 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.060547s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.042969s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XT' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'xtbill'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-08-25T09:22:22+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E9%80%80%E8%B4%A7&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.128906s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.175781s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.067383s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售退货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.031250s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售退货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.064453s ]
---------------------------------------------------------------
[ 2024-08-25T09:22:29+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XT
[ 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.031250s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.043945s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.044922s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = '' LIMIT 1 [ RunTime:0.006836s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XT' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = '' [ RunTime:0.131836s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE  `makedate` = '2024-08-25'  AND `type` = '销售退货' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.037110s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T09:22:47+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/custom/select_custom.html?dw=%E5%AE%A2%E6%88%B7
[ 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.022461s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'custom'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.003906s ]
---------------------------------------------------------------
[ 2024-08-25T09:22:48+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/custom/selectcustom_data.html?dw=%E5%AE%A2%E6%88%B7&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.002930s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE  `type` LIKE '%客户%' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT * FROM `custom` WHERE  `type` LIKE '%客户%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T09:23:05+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%85%A5%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93
[ 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.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.000977s ]
---------------------------------------------------------------
[ 2024-08-25T09:23:21+08:00 ] 114.129.26.83 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.004883s ] 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.049805s ]
[ 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.019531s ]
[ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:14.318359s ]
---------------------------------------------------------------
[ 2024-08-25T09:23:41+08:00 ] 114.129.26.83 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=goodscode&value=G10315&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.030274s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.045898s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodscode like '%G10315%' [ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodscode like '%G10315%' limit 0,90 [ RunTime:13.866211s ]
---------------------------------------------------------------
[ 2024-08-25T09:23:57+08:00 ] 114.129.26.83 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=goodscode&value=G10572&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.020508s ]
[ 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 ] select id from goods where 1=1  and goodscode like '%G10572%' [ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodscode like '%G10572%' limit 0,90 [ RunTime:13.423828s ]
---------------------------------------------------------------
[ 2024-08-25T09:25:01+08:00 ] 114.129.26.83 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.039062s ]
[ 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.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'XT-2024-08-25-0001' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `custname` , `operator` , `originalcode` , `note`) VALUES ('销售退货' , '入库' , '2024-08-25 09:22:29' , 'XT-2024-08-25-0001' , '2024-08-25' , '杨雅雯' , '2024-08-24' , '铅锌矿仓库' , '洪老板' , '张让红' , '' , '') [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.016602s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 7.07 , 1018 , 7197.26 , '' , 7.07 , 'XT-2024-08-25-0001' , 1) [ RunTime:0.001954s ]
---------------------------------------------------------------
[ 2024-08-25T09:25:03+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E9%80%80%E8%B4%A7&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.024415s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.007813s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售退货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.044922s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售退货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.062500s ]
---------------------------------------------------------------
[ 2024-08-25T09:25:34+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/bill_detail.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020507s ]
[ 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.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'billdetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.009766s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T09:25:36+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.058594s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.465820s ]
[ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.625977s ]
---------------------------------------------------------------
[ 2024-08-25T09:25:47+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=%E9%94%80%E5%94%AE%E9%80%80%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote=
[ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.039063s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.028320s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储')  AND `type` = '销售退货' LIMIT 1 [ RunTime:0.466797s ]
[ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储')  AND `type` = '销售退货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.548828s ]
---------------------------------------------------------------
[ 2024-08-25T09:26:13+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote=
[ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.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 ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储')  AND `type` = '销售提货' LIMIT 1 [ RunTime:0.473633s ]
[ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储')  AND `type` = '销售提货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.572266s ]
---------------------------------------------------------------
[ 2024-08-25T09:35:41+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/billshow.html?type=LY
[ 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.024414s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.023438s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'LY' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'lybill'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-08-25T09:35:43+08:00 ] 114.129.26.83 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
[ 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.042969s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.042969s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.045899s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.033203s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.063477s ]
---------------------------------------------------------------
[ 2024-08-25T09:35:49+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=LY
[ 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.112304s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.007812s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ]
[ 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` = '' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'LY' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = '' [ RunTime:0.121094s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.043945s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE  `makedate` = '2024-08-25'  AND `type` = '领用出库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.041015s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.039063s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T09:36:56+08:00 ] 114.129.26.83 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.022461s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T09:37:11+08:00 ] 114.129.26.83 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.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.042969s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.081054s ]
[ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:13.717773s ]
---------------------------------------------------------------
[ 2024-08-25T09:37:51+08:00 ] 114.129.26.83 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=goodscode&value=G10572&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.026367s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ]
[ 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 ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodscode like '%G10572%' [ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodscode like '%G10572%' limit 0,90 [ RunTime:14.637695s ]
---------------------------------------------------------------
[ 2024-08-25T09:38:47+08:00 ] 114.129.26.83 POST 103.45.248.127:8001/index/bill/save_bill.html
[ 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.027343s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'LY-2024-08-25-0001' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `custname` , `operator` , `originalcode` , `note`) VALUES ('领用出库' , '出库' , '2024-08-25 09:35:48' , 'LY-2024-08-25-0001' , '2024-08-25' , '杨雅雯' , '2024-08-25' , '铅锌矿仓库' , '霸王山综合管理部' , '张让红' , '' , '被老鼠咬及受潮损失') [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10572' GROUP BY `goodscode` [ RunTime:7.977539s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.021484s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8 , 1018 , 8144 , '被老鼠咬及受潮损失' , 8 , 'LY-2024-08-25-0001' , -1) [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T09:38:49+08:00 ] 114.129.26.83 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
[ 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.020508s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.035156s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.079101s ]
---------------------------------------------------------------
[ 2024-08-25T09:39:00+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=LY
[ sql ] [ DB ] CONNECT:[ UseTime:0.008789s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.125977s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = '' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'LY' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = '' [ RunTime:0.131836s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.245117s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.010742s ]
[ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE  `makedate` = '2024-08-25'  AND `type` = '领用出库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.003907s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.164062s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T09:39:31+08:00 ] 114.129.26.83 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.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027343s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T09:39:47+08:00 ] 114.129.26.83 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.004883s ] 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.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 [ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:14.679687s ]
---------------------------------------------------------------
[ 2024-08-25T09:39:58+08:00 ] 114.129.26.83 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=goodscode&value=G10572&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.113281s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.008789s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodscode like '%G10572%' [ RunTime:0.006835s ]
[ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodscode like '%G10572%' limit 0,90 [ RunTime:14.713868s ]
---------------------------------------------------------------
[ 2024-08-25T09:40:13+08:00 ] 114.129.26.83 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=goodscode&value=G10572&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.056641s ]
[ 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.000977s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodscode like '%G10572%' [ RunTime:0.006835s ]
[ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodscode like '%G10572%' limit 0,90 [ RunTime:14.256836s ]
---------------------------------------------------------------
[ 2024-08-25T09:40:58+08:00 ] 114.129.26.83 POST 103.45.248.127:8001/index/bill/save_bill.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'LY-2024-08-25-0002' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `custname` , `operator` , `originalcode` , `note`) VALUES ('领用出库' , '出库' , '2024-08-25 09:38:59' , 'LY-2024-08-25-0002' , '2024-08-25' , '杨雅雯' , '2024-08-25' , '铅锌矿仓库' , '霸王山综合管理部' , '张让红' , '' , '') [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10572' GROUP BY `goodscode` [ RunTime:12.654297s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.020507s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8 , 131523 , 1052184 , '被老鼠咬及受潮损失' , 8 , 'LY-2024-08-25-0002' , -1) [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-08-25T09:41:00+08:00 ] 114.129.26.83 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
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.038086s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.070312s ]
---------------------------------------------------------------
[ 2024-08-25T09:41:07+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=LY&billcode=LY-2024-08-25-0002
[ 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.031250s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.055664s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'LY-2024-08-25-0002' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'LY' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.064453s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'LY-2024-08-25-0002' [ RunTime:0.139648s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.049805s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.095703s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T09:41:11+08:00 ] 114.129.26.83 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.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.055664s ]
[ 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 ]
---------------------------------------------------------------
[ 2024-08-25T09:41:17+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/goods/goods_info.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.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 ] SHOW COLUMNS FROM `goods` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `goods` WHERE  `id` = 0 LIMIT 1 [ RunTime:0.000977s ]
[ 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.018554s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE  `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T09:41:25+08:00 ] 114.129.26.83 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.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.016601s ]
[ 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.017579s ]
[ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:13.782226s ]
---------------------------------------------------------------
[ 2024-08-25T09:41:39+08:00 ] 114.129.26.83 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.014648s ] 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.026368s ]
[ 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.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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:13.432617s ]
---------------------------------------------------------------
[ 2024-08-25T09:42:06+08:00 ] 114.129.26.83 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=goodscode&value=G10315&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.065430s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.070313s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodscode like '%G10315%' [ 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 <= '2024-08-25'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodscode like '%G10315%' limit 0,90 [ RunTime:13.712891s ]
---------------------------------------------------------------
[ 2024-08-25T09:43:58+08:00 ] 114.129.26.83 POST 103.45.248.127:8001/index/bill/save_bill.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.068359s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.033203s ]
[ 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.035156s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10572' GROUP BY `goodscode` [ RunTime:7.348633s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.033203s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'LY-2024-08-25-0002'  AND `goodscode` = 'G10572' LIMIT 1 [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10315' GROUP BY `goodscode` [ RunTime:11.996093s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'LY-2024-08-25-0002'  AND `goodscode` = 'G10315' LIMIT 1 [ RunTime:0.011719s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.089844s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `type`='领用出库',`inorout`='出库',`newtime`='2024-08-25 09:38:59',`billcode`='LY-2024-08-25-0002',`makedate`='2024-08-25',`maker`='杨雅雯',`adddate`='2024-08-25',`depotname`='铅锌矿仓库',`custname`='霸王山综合管理部',`operator`='张让红',`originalcode`='',`note`='',`updateman`='杨雅雯',`updatetime`='2024-08-25'  WHERE  `billid` = 43456 [ RunTime:0.001953s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'LY-2024-08-25-0002' [ RunTime:0.130859s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8 , 131523 , 1052184 , '被老鼠咬及受潮损失' , 8 , 'LY-2024-08-25-0002' , -1) [ RunTime:0.008789s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10315' , '电雷管' , '' , '个' , 7.84 , 2191 , 17177.44 , '2.191个（1000发/箱）被老鼠咬及受潮损失' , 7.84 , 'LY-2024-08-25-0002' , -1) [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T09:44:00+08:00 ] 114.129.26.83 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
[ 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.023437s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.036133s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.063476s ]
---------------------------------------------------------------
[ 2024-08-25T09:44:31+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote=
[ sql ] [ DB ] CONNECT:[ UseTime:0.021484s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.041016s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.110352s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.051758s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储')  AND `type` = '销售提货' LIMIT 1 [ RunTime:0.550781s ]
[ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储')  AND `type` = '销售提货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.626953s ]
---------------------------------------------------------------
[ 2024-08-25T09:44:35+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote=
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.026367s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.515625s ]
[ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.575195s ]
---------------------------------------------------------------
[ 2024-08-25T09:44:40+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote=
[ 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.050781s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.033203s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.034179s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.486328s ]
[ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.572265s ]
---------------------------------------------------------------
[ 2024-08-25T09:47:23+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&billcode=LY-2024-08-25-0002
[ 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.020508s ]
[ 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.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017579s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'LY-2024-08-25-0002' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billname` = '领用出库' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'LY-2024-08-25-0002' [ RunTime:0.128906s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T09:50:30+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/billshow.html?type=PD
[ 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.022461s ]
[ 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.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'PD' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'pdbill'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ]
---------------------------------------------------------------
[ 2024-08-25T09:50:31+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E5%BA%93%E5%AD%98%E7%9B%98%E7%82%B9&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.011718s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '库存盘点'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.030273s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '库存盘点'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.060547s ]
---------------------------------------------------------------
[ 2024-08-25T09:50:34+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=PD
[ 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.028321s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = '' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'PD' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = '' [ RunTime:0.133789s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.065429s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE  `makedate` = '2024-08-25'  AND `type` = '库存盘点' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.035156s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.050782s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T09:50:49+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%85%A5%E5%BA%93&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93
[ 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.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T09:51:04+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&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.053711s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.081054s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.007812s ]
[ 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 <= '2024-08-25'
  and depotname='铜矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:13.515625s ]
---------------------------------------------------------------
[ 2024-08-25T09:51:07+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/goods/goods_info.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.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 ] SHOW COLUMNS FROM `goods` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `goods` WHERE  `id` = 0 LIMIT 1 [ RunTime:0.000977s ]
[ 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.016601s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE  `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T09:51:32+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90
[ 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.023438s ]
[ 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.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 <= '2024-08-25'
  and depotname='铜矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:20.532227s ]
---------------------------------------------------------------
[ 2024-08-25T09:51:37+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodscode&value=G10572&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.023437s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodscode like '%G10572%' [ 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 <= '2024-08-25'
  and depotname='铜矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodscode like '%G10572%' limit 0,90 [ RunTime:18.361328s ]
---------------------------------------------------------------
[ 2024-08-25T09:51:57+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodscode&value=G10572&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.126953s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodscode like '%G10572%' [ 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 <= '2024-08-25'
  and depotname='铜矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodscode like '%G10572%' limit 0,90 [ RunTime:19.715820s ]
---------------------------------------------------------------
[ 2024-08-25T09:52:02+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodscode&value=G10315&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.046875s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.038086s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodscode like '%G10315%' [ 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 <= '2024-08-25'
  and depotname='铜矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodscode like '%G10315%' limit 0,90 [ RunTime:17.074219s ]
---------------------------------------------------------------
[ 2024-08-25T09:56:11+08:00 ] 114.129.26.83 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.033203s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.042969s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.049805s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'PD-2024-08-25-0001' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `operator` , `originalcode` , `note`) VALUES ('库存盘点' , '入库' , '2024-08-25 09:50:34' , 'PD-2024-08-25-0001' , '2024-08-25' , '杨雅雯' , '2024-08-25' , '铜矿仓库' , '张让红' , '' , '') [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.019531s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `zmnumber` , `spnumber` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8 , 2442 , 0 , -2442 , -19536 , '' , 8 , 'PD-2024-08-25-0001' , 1) [ RunTime:0.001953s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `zmnumber` , `spnumber` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10315' , '电雷管' , '' , '个' , 0.01 , 86 , 0 , -86 , -0.86 , '' , 0.01 , 'PD-2024-08-25-0001' , 1) [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T09:56:13+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E5%BA%93%E5%AD%98%E7%9B%98%E7%82%B9&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.017578s ]
[ 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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.039062s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '库存盘点'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.031250s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '库存盘点'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.069336s ]
---------------------------------------------------------------
[ 2024-08-25T09:56:33+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/kcreport/stock_sum.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.020508s ]
[ 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.001953s ]
---------------------------------------------------------------
[ 2024-08-25T09:56:34+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.071289s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.110352s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ]
---------------------------------------------------------------
[ 2024-08-25T09:56:49+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10572&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.102539s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.029297s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1   and goodscode like '%G10572%' [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT
	aa.goodscode,
	aa.goodsname,
	aa.specification,
	aa.unit,
	aa.goodscategory,
	IFNULL(endnumber,0)as endnumber,
	IFNULL(endmon,0)as endmon,
	IFNULL(innumber,0) as innumber,
	IFNULL(inmoney,0) as inmoney,
	IFNULL(outnumber,0) as outnumber,
	IFNULL(outmoney,0) as outmoney,
	IFNULL(startnumber,0) as startnumber,
	IFNULL(startmon,0) as startmon
FROM
    (
    SELECT
							goodscode,
							goodsname,
							specification,
							unit,
							goodscategory						  
						FROM
							goods
							WHERE
			                1=1  and goodscode like '%G10572%'					  
					) AS aa
					LEFT JOIN(
        SELECT
							goodscode,
							IFNULL(SUM(t_num), 0) AS endnumber,
							ifnull(SUM(t_mon),0) AS endmon			  
						FROM
							s_billdetail
						WHERE 	adddate <= '2024-08-25' and depotname='铜矿仓库' 
						GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode 				
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(SUM(number), 0) AS innumber,
						ifnull(SUM(money), 0) AS inmoney
					FROM
						s_billdetail
					WHERE
					     sign= 1 
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铜矿仓库'
					GROUP BY
						goodscode
				) AS s_in ON aa.goodscode = s_in.goodscode
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(sum(number), 0) AS outnumber,
						ifnull(sum(money), 0) AS outmoney
					FROM
						s_billdetail
					WHERE
						sign=-1
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铜矿仓库'
					GROUP BY
						goodscode
				) AS s_out ON aa.goodscode = s_out.goodscode			
			LEFT JOIN (
        SELECT
					goodscode,
					ifnull(SUM(t_num), 0) AS startnumber,
					ifnull(SUM(t_mon),0) AS startmon
				FROM
					s_billdetail
				WHERE				
					adddate < '2024-08-01' and depotname='铜矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.675781s ]
---------------------------------------------------------------
[ 2024-08-25T09:57:09+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10513&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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.032226s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1   and goodscode like '%G10513%' [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT
	aa.goodscode,
	aa.goodsname,
	aa.specification,
	aa.unit,
	aa.goodscategory,
	IFNULL(endnumber,0)as endnumber,
	IFNULL(endmon,0)as endmon,
	IFNULL(innumber,0) as innumber,
	IFNULL(inmoney,0) as inmoney,
	IFNULL(outnumber,0) as outnumber,
	IFNULL(outmoney,0) as outmoney,
	IFNULL(startnumber,0) as startnumber,
	IFNULL(startmon,0) as startmon
FROM
    (
    SELECT
							goodscode,
							goodsname,
							specification,
							unit,
							goodscategory						  
						FROM
							goods
							WHERE
			                1=1  and goodscode like '%G10513%'					  
					) AS aa
					LEFT JOIN(
        SELECT
							goodscode,
							IFNULL(SUM(t_num), 0) AS endnumber,
							ifnull(SUM(t_mon),0) AS endmon			  
						FROM
							s_billdetail
						WHERE 	adddate <= '2024-08-25' and depotname='铜矿仓库' 
						GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode 				
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(SUM(number), 0) AS innumber,
						ifnull(SUM(money), 0) AS inmoney
					FROM
						s_billdetail
					WHERE
					     sign= 1 
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铜矿仓库'
					GROUP BY
						goodscode
				) AS s_in ON aa.goodscode = s_in.goodscode
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(sum(number), 0) AS outnumber,
						ifnull(sum(money), 0) AS outmoney
					FROM
						s_billdetail
					WHERE
						sign=-1
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铜矿仓库'
					GROUP BY
						goodscode
				) AS s_out ON aa.goodscode = s_out.goodscode			
			LEFT JOIN (
        SELECT
					goodscode,
					ifnull(SUM(t_num), 0) AS startnumber,
					ifnull(SUM(t_mon),0) AS startmon
				FROM
					s_billdetail
				WHERE				
					adddate < '2024-08-01' and depotname='铜矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.736328s ]
---------------------------------------------------------------
[ 2024-08-25T09:57:21+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10315&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.030273s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select id from goods where 1=1   and goodscode like '%G10315%' [ RunTime:0.006836s ]
[ sql ] [ SQL ] SELECT
	aa.goodscode,
	aa.goodsname,
	aa.specification,
	aa.unit,
	aa.goodscategory,
	IFNULL(endnumber,0)as endnumber,
	IFNULL(endmon,0)as endmon,
	IFNULL(innumber,0) as innumber,
	IFNULL(inmoney,0) as inmoney,
	IFNULL(outnumber,0) as outnumber,
	IFNULL(outmoney,0) as outmoney,
	IFNULL(startnumber,0) as startnumber,
	IFNULL(startmon,0) as startmon
FROM
    (
    SELECT
							goodscode,
							goodsname,
							specification,
							unit,
							goodscategory						  
						FROM
							goods
							WHERE
			                1=1  and goodscode like '%G10315%'					  
					) AS aa
					LEFT JOIN(
        SELECT
							goodscode,
							IFNULL(SUM(t_num), 0) AS endnumber,
							ifnull(SUM(t_mon),0) AS endmon			  
						FROM
							s_billdetail
						WHERE 	adddate <= '2024-08-25' and depotname='铜矿仓库' 
						GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode 				
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(SUM(number), 0) AS innumber,
						ifnull(SUM(money), 0) AS inmoney
					FROM
						s_billdetail
					WHERE
					     sign= 1 
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铜矿仓库'
					GROUP BY
						goodscode
				) AS s_in ON aa.goodscode = s_in.goodscode
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(sum(number), 0) AS outnumber,
						ifnull(sum(money), 0) AS outmoney
					FROM
						s_billdetail
					WHERE
						sign=-1
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铜矿仓库'
					GROUP BY
						goodscode
				) AS s_out ON aa.goodscode = s_out.goodscode			
			LEFT JOIN (
        SELECT
					goodscode,
					ifnull(SUM(t_num), 0) AS startnumber,
					ifnull(SUM(t_mon),0) AS startmon
				FROM
					s_billdetail
				WHERE				
					adddate < '2024-08-01' and depotname='铜矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.768554s ]
---------------------------------------------------------------
[ 2024-08-25T09:58:09+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10315&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.044922s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.030273s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] select id from goods where 1=1   and goodscode like '%G10315%' [ RunTime:0.005859s ]
[ sql ] [ SQL ] SELECT
	aa.goodscode,
	aa.goodsname,
	aa.specification,
	aa.unit,
	aa.goodscategory,
	IFNULL(endnumber,0)as endnumber,
	IFNULL(endmon,0)as endmon,
	IFNULL(innumber,0) as innumber,
	IFNULL(inmoney,0) as inmoney,
	IFNULL(outnumber,0) as outnumber,
	IFNULL(outmoney,0) as outmoney,
	IFNULL(startnumber,0) as startnumber,
	IFNULL(startmon,0) as startmon
FROM
    (
    SELECT
							goodscode,
							goodsname,
							specification,
							unit,
							goodscategory						  
						FROM
							goods
							WHERE
			                1=1  and goodscode like '%G10315%'					  
					) AS aa
					LEFT JOIN(
        SELECT
							goodscode,
							IFNULL(SUM(t_num), 0) AS endnumber,
							ifnull(SUM(t_mon),0) AS endmon			  
						FROM
							s_billdetail
						WHERE 	adddate <= '2024-08-25' and depotname='铅锌矿仓库' 
						GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode 				
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(SUM(number), 0) AS innumber,
						ifnull(SUM(money), 0) AS inmoney
					FROM
						s_billdetail
					WHERE
					     sign= 1 
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铅锌矿仓库'
					GROUP BY
						goodscode
				) AS s_in ON aa.goodscode = s_in.goodscode
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(sum(number), 0) AS outnumber,
						ifnull(sum(money), 0) AS outmoney
					FROM
						s_billdetail
					WHERE
						sign=-1
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铅锌矿仓库'
					GROUP BY
						goodscode
				) AS s_out ON aa.goodscode = s_out.goodscode			
			LEFT JOIN (
        SELECT
					goodscode,
					ifnull(SUM(t_num), 0) AS startnumber,
					ifnull(SUM(t_mon),0) AS startmon
				FROM
					s_billdetail
				WHERE				
					adddate < '2024-08-01' and depotname='铅锌矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.884766s ]
---------------------------------------------------------------
[ 2024-08-25T09:59:29+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10572&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.022461s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] select id from goods where 1=1   and goodscode like '%G10572%' [ RunTime:0.005859s ]
[ sql ] [ SQL ] SELECT
	aa.goodscode,
	aa.goodsname,
	aa.specification,
	aa.unit,
	aa.goodscategory,
	IFNULL(endnumber,0)as endnumber,
	IFNULL(endmon,0)as endmon,
	IFNULL(innumber,0) as innumber,
	IFNULL(inmoney,0) as inmoney,
	IFNULL(outnumber,0) as outnumber,
	IFNULL(outmoney,0) as outmoney,
	IFNULL(startnumber,0) as startnumber,
	IFNULL(startmon,0) as startmon
FROM
    (
    SELECT
							goodscode,
							goodsname,
							specification,
							unit,
							goodscategory						  
						FROM
							goods
							WHERE
			                1=1  and goodscode like '%G10572%'					  
					) AS aa
					LEFT JOIN(
        SELECT
							goodscode,
							IFNULL(SUM(t_num), 0) AS endnumber,
							ifnull(SUM(t_mon),0) AS endmon			  
						FROM
							s_billdetail
						WHERE 	adddate <= '2024-08-25' and depotname='铅锌矿仓库' 
						GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode 				
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(SUM(number), 0) AS innumber,
						ifnull(SUM(money), 0) AS inmoney
					FROM
						s_billdetail
					WHERE
					     sign= 1 
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铅锌矿仓库'
					GROUP BY
						goodscode
				) AS s_in ON aa.goodscode = s_in.goodscode
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(sum(number), 0) AS outnumber,
						ifnull(sum(money), 0) AS outmoney
					FROM
						s_billdetail
					WHERE
						sign=-1
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铅锌矿仓库'
					GROUP BY
						goodscode
				) AS s_out ON aa.goodscode = s_out.goodscode			
			LEFT JOIN (
        SELECT
					goodscode,
					ifnull(SUM(t_num), 0) AS startnumber,
					ifnull(SUM(t_mon),0) AS startmon
				FROM
					s_billdetail
				WHERE				
					adddate < '2024-08-01' and depotname='铅锌矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.903320s ]
---------------------------------------------------------------
[ 2024-08-25T10:00:53+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/billshow.html?type=XS
[ 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.034180s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.112305s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'xsbill'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-08-25T10:00:55+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.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 '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.028320s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.059571s ]
---------------------------------------------------------------
[ 2024-08-25T10:01:17+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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=&note=
[ 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.029297s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025391s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.026367s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.032226s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.059571s ]
---------------------------------------------------------------
[ 2024-08-25T10:01:21+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS&billcode=XS-2024-08-25-0001
[ 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.020508s ]
[ 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.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'XS-2024-08-25-0001' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-25-0001' [ RunTime:0.125977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T10:01:48+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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=&note=
[ 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.054687s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.034180s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.058594s ]
---------------------------------------------------------------
[ 2024-08-25T10:01:51+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS&billcode=XS-2024-08-24-0005
[ 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.022461s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'XS-2024-08-24-0005' LIMIT 1 [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.057618s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-24-0005' [ RunTime:0.123047s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T10:04:07+08:00 ] 114.129.26.83 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.020508s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.060547s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10572' GROUP BY `goodscode` [ RunTime:14.156250s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.082032s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-24-0005'  AND `goodscode` = 'G10572' LIMIT 1 [ RunTime:0.006836s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.044922s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `type`='销售提货',`inorout`='出库',`newtime`='2024-08-24 10:14:00',`billcode`='XS-2024-08-24-0005',`makedate`='2024-08-24',`maker`='杨雅雯',`adddate`='2024-08-19',`depotname`='铅锌矿仓库',`custname`='洪老板',`operator`='张让红',`originalcode`='',`note`='销售3600发收3600美元',`updateman`='杨雅雯',`updatetime`='2024-08-25'  WHERE  `billid` = 43452 [ RunTime:0.001954s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'XS-2024-08-24-0005' [ RunTime:0.126953s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8.08 , 3600 , 29088 , '销售3600发收3600美元' , 8.01 , 'XS-2024-08-24-0005' , -1) [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T10:04:08+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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=&note=
[ 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.033203s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.028320s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.030273s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.066406s ]
---------------------------------------------------------------
[ 2024-08-25T10:04:18+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS&billcode=XS-2024-08-24-0004
[ 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.021484s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'XS-2024-08-24-0004' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-24-0004' [ RunTime:0.123047s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T10:04:39+08:00 ] 114.129.26.83 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.053711s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.051758s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.003906s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.113281s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10572' GROUP BY `goodscode` [ RunTime:11.516602s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.029297s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-24-0004'  AND `goodscode` = 'G10572' LIMIT 1 [ RunTime:0.008789s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.019532s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `type`='销售提货',`inorout`='出库',`newtime`='2024-08-24 10:08:22',`billcode`='XS-2024-08-24-0004',`makedate`='2024-08-24',`maker`='杨雅雯',`adddate`='2024-08-19',`depotname`='铅锌矿仓库',`custname`='洪老板',`operator`='张让红',`originalcode`='',`note`='销售2900发收1400美元+3550Kip',`updateman`='杨雅雯',`updatetime`='2024-08-25'  WHERE  `billid` = 43451 [ RunTime:0.001953s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'XS-2024-08-24-0004' [ RunTime:0.128906s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8.08 , 2900 , 23432 , '销售2900发收1400美元' , 8 , 'XS-2024-08-24-0004' , -1) [ RunTime:0.009765s ]
---------------------------------------------------------------
[ 2024-08-25T10:04:40+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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=&note=
[ 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.043946s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.031250s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.053711s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.030273s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.059570s ]
---------------------------------------------------------------
[ 2024-08-25T10:04:45+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS&billcode=XS-2024-08-24-0003
[ 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.046875s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.036133s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'XS-2024-08-24-0003' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.046875s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-24-0003' [ RunTime:0.116211s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T10:05:07+08:00 ] 114.129.26.83 POST 103.45.248.127:8001/index/bill/save_bill.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.057617s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.157227s ]
[ 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.034179s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10572' GROUP BY `goodscode` [ RunTime:11.307617s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.033204s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-24-0003'  AND `goodscode` = 'G10572' LIMIT 1 [ RunTime:0.008789s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.020508s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `type`='销售提货',`inorout`='出库',`newtime`='2024-08-24 10:01:10',`billcode`='XS-2024-08-24-0003',`makedate`='2024-08-24',`maker`='杨雅雯',`adddate`='2024-08-14',`depotname`='铅锌矿仓库',`custname`='洪老板',`operator`='张让红',`originalcode`='',`note`='销售3300发收人民币',`updateman`='杨雅雯',`updatetime`='2024-08-25'  WHERE  `billid` = 43450 [ RunTime:0.000976s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'XS-2024-08-24-0003' [ RunTime:0.125000s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8.08 , 3300 , 26664 , '销售3300发收人民币' , 8.01 , 'XS-2024-08-24-0003' , -1) [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T10:05:09+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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=&note=
[ 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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.119141s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.029297s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.037110s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.057617s ]
---------------------------------------------------------------
[ 2024-08-25T10:05:13+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS&billcode=XS-2024-08-24-0002
[ 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.018555s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'XS-2024-08-24-0002' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-24-0002' [ RunTime:0.114257s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.030273s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T10:05:35+08:00 ] 114.129.26.83 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.045899s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.044921s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.003907s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.042968s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10572' GROUP BY `goodscode` [ RunTime:13.623047s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.024414s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-24-0002'  AND `goodscode` = 'G10572' LIMIT 1 [ RunTime:0.009766s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018555s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `type`='销售提货',`inorout`='出库',`newtime`='2024-08-24 09:57:45',`billcode`='XS-2024-08-24-0002',`makedate`='2024-08-24',`maker`='杨雅雯',`adddate`='2024-08-14',`depotname`='铅锌矿仓库',`custname`='洪老板',`operator`='张让红',`originalcode`='',`note`='销售3500发收人民币',`updateman`='杨雅雯',`updatetime`='2024-08-25'  WHERE  `billid` = 43449 [ RunTime:0.002930s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'XS-2024-08-24-0002' [ RunTime:0.131836s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8.08 , 3500 , 28280 , '销售3500发收人民币' , 8 , 'XS-2024-08-24-0002' , -1) [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T10:05:37+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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=&note=
[ 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.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.028321s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.056641s ]
---------------------------------------------------------------
[ 2024-08-25T10:05:43+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS&billcode=XS-2024-08-24-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.024414s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'XS-2024-08-24-0001' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-24-0001' [ RunTime:0.120117s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.051758s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T10:06:05+08:00 ] 114.129.26.83 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.021484s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10572' GROUP BY `goodscode` [ RunTime:12.260743s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-24-0001'  AND `goodscode` = 'G10572' LIMIT 1 [ RunTime:0.007813s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.026367s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `type`='销售提货',`inorout`='出库',`newtime`='2024-08-24 09:45:31',`billcode`='XS-2024-08-24-0001',`makedate`='2024-08-24',`maker`='杨雅雯',`adddate`='2024-08-07',`depotname`='铅锌矿仓库',`custname`='洪老板',`operator`='张让红',`originalcode`='',`note`='销售3000发收人民币',`updateman`='杨雅雯',`updatetime`='2024-08-25'  WHERE  `billid` = 43448 [ RunTime:0.001954s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'XS-2024-08-24-0001' [ RunTime:0.125976s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8.08 , 3000 , 24240 , '销售3000发收人民币' , 8.01 , 'XS-2024-08-24-0001' , -1) [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T10:06:07+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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=&note=
[ 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.020508s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.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 '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.032227s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.068359s ]
---------------------------------------------------------------
[ 2024-08-25T10:06:11+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS&billcode=XS-2024-08-20-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.114258s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'XS-2024-08-20-0001' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.043945s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'XS' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.401368s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-20-0001' [ RunTime:0.160156s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.047852s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.039063s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-08-25T10:06:34+08:00 ] 114.129.26.83 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.032226s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.029297s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.046875s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10572' GROUP BY `goodscode` [ RunTime:11.920899s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.034179s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'XS-2024-08-20-0001'  AND `goodscode` = 'G10572' LIMIT 1 [ RunTime:0.006836s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.026367s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `type`='销售提货',`inorout`='出库',`newtime`='2024-08-20 17:55:14',`billcode`='XS-2024-08-20-0001',`makedate`='2024-08-20',`maker`='张让红',`adddate`='2024-08-19',`depotname`='铅锌矿仓库',`custname`='洪老板',`operator`='张让红',`originalcode`='',`note`='汇率：7.15',`updateman`='杨雅雯',`updatetime`='2024-08-25'  WHERE  `billid` = 43447 [ RunTime:0.001953s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'XS-2024-08-20-0001' [ RunTime:0.140625s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8.08 , 4500 , 36360 , '5000$' , 8.01 , 'XS-2024-08-20-0001' , -1) [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-08-25T10:06:36+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&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=&note=
[ 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.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.024414s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.032227s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.058594s ]
---------------------------------------------------------------
[ 2024-08-25T10:06:50+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote=
[ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.042969s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.041016s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.049804s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库'  AND `type` = '销售提货' LIMIT 1 [ RunTime:0.510742s ]
[ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库'  AND `type` = '销售提货' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.579101s ]
---------------------------------------------------------------
[ 2024-08-25T10:07:04+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10572&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.058593s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.078125s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] select id from goods where 1=1   and goodscode like '%G10572%' [ RunTime:0.005859s ]
[ sql ] [ SQL ] SELECT
	aa.goodscode,
	aa.goodsname,
	aa.specification,
	aa.unit,
	aa.goodscategory,
	IFNULL(endnumber,0)as endnumber,
	IFNULL(endmon,0)as endmon,
	IFNULL(innumber,0) as innumber,
	IFNULL(inmoney,0) as inmoney,
	IFNULL(outnumber,0) as outnumber,
	IFNULL(outmoney,0) as outmoney,
	IFNULL(startnumber,0) as startnumber,
	IFNULL(startmon,0) as startmon
FROM
    (
    SELECT
							goodscode,
							goodsname,
							specification,
							unit,
							goodscategory						  
						FROM
							goods
							WHERE
			                1=1  and goodscode like '%G10572%'					  
					) AS aa
					LEFT JOIN(
        SELECT
							goodscode,
							IFNULL(SUM(t_num), 0) AS endnumber,
							ifnull(SUM(t_mon),0) AS endmon			  
						FROM
							s_billdetail
						WHERE 	adddate <= '2024-08-25' and depotname='铅锌矿仓库' 
						GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode 				
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(SUM(number), 0) AS innumber,
						ifnull(SUM(money), 0) AS inmoney
					FROM
						s_billdetail
					WHERE
					     sign= 1 
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铅锌矿仓库'
					GROUP BY
						goodscode
				) AS s_in ON aa.goodscode = s_in.goodscode
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(sum(number), 0) AS outnumber,
						ifnull(sum(money), 0) AS outmoney
					FROM
						s_billdetail
					WHERE
						sign=-1
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铅锌矿仓库'
					GROUP BY
						goodscode
				) AS s_out ON aa.goodscode = s_out.goodscode			
			LEFT JOIN (
        SELECT
					goodscode,
					ifnull(SUM(t_num), 0) AS startnumber,
					ifnull(SUM(t_mon),0) AS startmon
				FROM
					s_billdetail
				WHERE				
					adddate < '2024-08-01' and depotname='铅锌矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.844727s ]
---------------------------------------------------------------
[ 2024-08-25T10:07:35+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10572&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.020508s ]
[ 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.000977s ]
[ sql ] [ SQL ] select id from goods where 1=1   and goodscode like '%G10572%' [ RunTime:0.005859s ]
[ sql ] [ SQL ] SELECT
	aa.goodscode,
	aa.goodsname,
	aa.specification,
	aa.unit,
	aa.goodscategory,
	IFNULL(endnumber,0)as endnumber,
	IFNULL(endmon,0)as endmon,
	IFNULL(innumber,0) as innumber,
	IFNULL(inmoney,0) as inmoney,
	IFNULL(outnumber,0) as outnumber,
	IFNULL(outmoney,0) as outmoney,
	IFNULL(startnumber,0) as startnumber,
	IFNULL(startmon,0) as startmon
FROM
    (
    SELECT
							goodscode,
							goodsname,
							specification,
							unit,
							goodscategory						  
						FROM
							goods
							WHERE
			                1=1  and goodscode like '%G10572%'					  
					) AS aa
					LEFT JOIN(
        SELECT
							goodscode,
							IFNULL(SUM(t_num), 0) AS endnumber,
							ifnull(SUM(t_mon),0) AS endmon			  
						FROM
							s_billdetail
						WHERE 	adddate <= '2024-08-25' and depotname='铅锌矿仓库' 
						GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode 				
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(SUM(number), 0) AS innumber,
						ifnull(SUM(money), 0) AS inmoney
					FROM
						s_billdetail
					WHERE
					     sign= 1 
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铅锌矿仓库'
					GROUP BY
						goodscode
				) AS s_in ON aa.goodscode = s_in.goodscode
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(sum(number), 0) AS outnumber,
						ifnull(sum(money), 0) AS outmoney
					FROM
						s_billdetail
					WHERE
						sign=-1
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铅锌矿仓库'
					GROUP BY
						goodscode
				) AS s_out ON aa.goodscode = s_out.goodscode			
			LEFT JOIN (
        SELECT
					goodscode,
					ifnull(SUM(t_num), 0) AS startnumber,
					ifnull(SUM(t_mon),0) AS startmon
				FROM
					s_billdetail
				WHERE				
					adddate < '2024-08-01' and depotname='铅锌矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.820312s ]
---------------------------------------------------------------
[ 2024-08-25T10:08:10+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote=
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.040039s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.003906s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库'  AND `type` = '领用出库' LIMIT 1 [ RunTime:0.558593s ]
[ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE  `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` = '铅锌矿仓库'  AND `type` = '领用出库' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.636719s ]
---------------------------------------------------------------
[ 2024-08-25T10:08:27+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/billshow.html?type=LY
[ 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.023437s ]
[ 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 ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'LY' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'lybill'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ]
---------------------------------------------------------------
[ 2024-08-25T10:08:29+08:00 ] 114.129.26.83 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
[ 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.020508s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.051758s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.025391s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.037109s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.060547s ]
---------------------------------------------------------------
[ 2024-08-25T10:08:33+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/bill/bill_info.html?type=LY&billcode=LY-2024-08-25-0002
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ 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 * FROM `bill` WHERE  `billcode` = 'LY-2024-08-25-0002' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'LY' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'LY-2024-08-25-0002' [ RunTime:0.123047s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-08-25T10:08:57+08:00 ] 114.129.26.83 POST 103.45.248.127:8001/index/bill/save_bill.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.034180s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.004883s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ]
[ 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.025391s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10572' GROUP BY `goodscode` [ RunTime:8.053711s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.065430s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'LY-2024-08-25-0002'  AND `goodscode` = 'G10572' LIMIT 1 [ RunTime:0.006835s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10315' GROUP BY `goodscode` [ RunTime:7.993165s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'LY-2024-08-25-0002'  AND `goodscode` = 'G10315' LIMIT 1 [ RunTime:0.004882s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.078125s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `type`='领用出库',`inorout`='出库',`newtime`='2024-08-25 09:38:59',`billcode`='LY-2024-08-25-0002',`makedate`='2024-08-25',`maker`='杨雅雯',`adddate`='2024-08-25',`depotname`='铅锌矿仓库',`custname`='霸王山综合管理部',`operator`='张让红',`originalcode`='',`note`='',`updateman`='杨雅雯',`updatetime`='2024-08-25'  WHERE  `billid` = 43456 [ RunTime:0.001953s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'LY-2024-08-25-0002' [ RunTime:0.148437s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10572' , '雷管' , '炸材' , '' , 8.08 , 131523 , 1062705.84 , '被老鼠咬及受潮损失' , 8.08 , 'LY-2024-08-25-0002' , -1) [ RunTime:0.000976s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10315' , '电雷管' , '' , '个' , 7.84 , 2191 , 17177.44 , '2.191个（1000发/箱）被老鼠咬及受潮损失' , 7.84 , 'LY-2024-08-25-0002' , -1) [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2024-08-25T10:08:59+08:00 ] 114.129.26.83 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
[ 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.035156s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.046875s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.035156s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.035156s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2024-08-01' AND '2024-08-25'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.064453s ]
---------------------------------------------------------------
[ 2024-08-25T10:09:05+08:00 ] 114.129.26.83 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&field=goodscode&value=G10572&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.088868s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.066406s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1   and goodscode like '%G10572%' [ RunTime:0.005860s ]
[ sql ] [ SQL ] SELECT
	aa.goodscode,
	aa.goodsname,
	aa.specification,
	aa.unit,
	aa.goodscategory,
	IFNULL(endnumber,0)as endnumber,
	IFNULL(endmon,0)as endmon,
	IFNULL(innumber,0) as innumber,
	IFNULL(inmoney,0) as inmoney,
	IFNULL(outnumber,0) as outnumber,
	IFNULL(outmoney,0) as outmoney,
	IFNULL(startnumber,0) as startnumber,
	IFNULL(startmon,0) as startmon
FROM
    (
    SELECT
							goodscode,
							goodsname,
							specification,
							unit,
							goodscategory						  
						FROM
							goods
							WHERE
			                1=1  and goodscode like '%G10572%'					  
					) AS aa
					LEFT JOIN(
        SELECT
							goodscode,
							IFNULL(SUM(t_num), 0) AS endnumber,
							ifnull(SUM(t_mon),0) AS endmon			  
						FROM
							s_billdetail
						WHERE 	adddate <= '2024-08-25' and depotname='铅锌矿仓库' 
						GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode 				
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(SUM(number), 0) AS innumber,
						ifnull(SUM(money), 0) AS inmoney
					FROM
						s_billdetail
					WHERE
					     sign= 1 
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铅锌矿仓库'
					GROUP BY
						goodscode
				) AS s_in ON aa.goodscode = s_in.goodscode
				LEFT JOIN (
        SELECT
						goodscode,
						ifnull(sum(number), 0) AS outnumber,
						ifnull(sum(money), 0) AS outmoney
					FROM
						s_billdetail
					WHERE
						sign=-1
                        AND adddate >= '2024-08-01'
                        AND adddate <= '2024-08-25' and depotname='铅锌矿仓库'
					GROUP BY
						goodscode
				) AS s_out ON aa.goodscode = s_out.goodscode			
			LEFT JOIN (
        SELECT
					goodscode,
					ifnull(SUM(t_num), 0) AS startnumber,
					ifnull(SUM(t_mon),0) AS startmon
				FROM
					s_billdetail
				WHERE				
					adddate < '2024-08-01' and depotname='铅锌矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.814453s ]