---------------------------------------------------------------
[ 2023-06-13T07:48:47+08:00 ] 202.62.102.46 GET 103.45.248.127:8001/index/lyreport/receivesum_data.html?page=1&limit=90&startdate=2022-02-26&enddate=2023-02-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E6%9F%B4%E6%B2%B9&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.038086s ]
[ 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 ] SELECT
 a.*, IFNULL(t_num,0)as t_num,
	IFNULL(t_money,0)as t_money,
	IFNULL(t_num1,0)as t_num1,
	IFNULL(t_money1,0)as t_money1,
	IFNULL(t_num2,0)as t_num2,
	IFNULL(t_money2,0)as t_money2
FROM
	(
		(
			goods a
			RIGHT JOIN (
				SELECT
					goodscode,
					-sum(number * sign) AS t_num2,
					-sum(money * sign) AS t_money2
				FROM
					s_billdetail
				WHERE
					type IN (
						'领用出库',
						'领用退库'
					)  and adddate >='2022-02-26' and adddate <='2023-02-25' and depotname='纸浆厂仓库' and goodsname like '%柴油%'
				GROUP BY
					goodscode
			) d ON a.goodscode = d.goodscode
		)
		LEFT JOIN (
			SELECT
				goodscode,
				sum(number) AS t_num1,
				sum(money) AS t_money1
			FROM
				s_billdetail
			WHERE
				type = '领用退库'  and adddate >='2022-02-26' and adddate <='2023-02-25' and depotname='纸浆厂仓库' and goodsname like '%柴油%'
			GROUP BY
				goodscode
		) c ON a.goodscode = c.goodscode
	)
LEFT JOIN (
	SELECT
		goodscode,
		sum(number) AS t_num,
		sum(money) AS t_money
	FROM
		s_billdetail
	WHERE
		type = '领用出库'  and adddate >='2022-02-26' and adddate <='2023-02-25' and depotname='纸浆厂仓库' and goodsname like '%柴油%'
	GROUP BY
		goodscode
) b ON a.goodscode = b.goodscode [ RunTime:0.311523s ]
[ sql ] [ SQL ] SELECT
 a.*, IFNULL(t_num,0)as t_num,
	IFNULL(t_money,0)as t_money,
	IFNULL(t_num1,0)as t_num1,
	IFNULL(t_money1,0)as t_money1,
	IFNULL(t_num2,0)as t_num2,
	IFNULL(t_money2,0)as t_money2
FROM
	(
		(
			goods a
			RIGHT JOIN (
				SELECT
					goodscode,
					-sum(number * sign) AS t_num2,
					-sum(money * sign) AS t_money2
				FROM
					s_billdetail
				WHERE
					type IN (
						'领用出库',
						'领用退库'
					)  and adddate >='2022-02-26' and adddate <='2023-02-25' and depotname='纸浆厂仓库' and goodsname like '%柴油%'
				GROUP BY
					goodscode
			) d ON a.goodscode = d.goodscode
		)
		LEFT JOIN (
			SELECT
				goodscode,
				sum(number) AS t_num1,
				sum(money) AS t_money1
			FROM
				s_billdetail
			WHERE
				type = '领用退库'  and adddate >='2022-02-26' and adddate <='2023-02-25' and depotname='纸浆厂仓库' and goodsname like '%柴油%'
			GROUP BY
				goodscode
		) c ON a.goodscode = c.goodscode
	)
LEFT JOIN (
	SELECT
		goodscode,
		sum(number) AS t_num,
		sum(money) AS t_money
	FROM
		s_billdetail
	WHERE
		type = '领用出库'  and adddate >='2022-02-26' and adddate <='2023-02-25' and depotname='纸浆厂仓库' and goodsname like '%柴油%'
	GROUP BY
		goodscode
) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.266602s ]
---------------------------------------------------------------
[ 2023-06-13T07:49:08+08:00 ] 202.62.102.46 GET 103.45.248.127:8001/index/cgreport/purchasesum_data.html?page=1&limit=90&startdate=2022-02-26&enddate=2023-02-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E6%9F%B4%E6%B2%B9&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT
 a.*, IFNULL(t_num,0)as t_num,
	IFNULL(t_money,0)as t_money,
	IFNULL(t_num1,0)as t_num1,
	IFNULL(t_money1,0)as t_money1,
	IFNULL(t_num2,0)as t_num2,
	IFNULL(t_money2,0)as t_money2
FROM
	(
		(
			goods a
			RIGHT JOIN (
				SELECT
					goodscode,
					sum(number * sign) AS t_num2,
					sum(money * sign) AS t_money2
				FROM
					s_billdetail
				WHERE
					type IN (
						'采购入库',
						'采购退货'
					)  and adddate >='2022-02-26' and adddate <='2023-02-25' and DepotName='纸浆厂仓库' and goodsname like '%柴油%'
				GROUP BY
					goodscode
			) d ON a.goodscode = d.goodscode
		)
		LEFT JOIN (
			SELECT
				goodscode,
				sum(number) AS t_num1,
				sum(money) AS t_money1
			FROM
				s_billdetail
			WHERE
				type = '采购退货'  and adddate >='2022-02-26' and adddate <='2023-02-25' and DepotName='纸浆厂仓库' and goodsname like '%柴油%'
			GROUP BY
				goodscode
		) c ON a.goodscode = c.goodscode 
	)
LEFT JOIN (
	SELECT
		goodscode,
		sum(number) AS t_num,
		sum(money) AS t_money
	FROM
		s_billdetail
	WHERE
		type = '采购入库'  and adddate >='2022-02-26' and adddate <='2023-02-25' and DepotName='纸浆厂仓库' and goodsname like '%柴油%'
	GROUP BY
		goodscode
) b ON a.goodscode = b.goodscode [ RunTime:0.329102s ]
[ sql ] [ SQL ] SELECT
 a.*, IFNULL(t_num,0)as t_num,
	IFNULL(t_money,0)as t_money,
	IFNULL(t_num1,0)as t_num1,
	IFNULL(t_money1,0)as t_money1,
	IFNULL(t_num2,0)as t_num2,
	IFNULL(t_money2,0)as t_money2
FROM
	(
		(
			goods a
			RIGHT JOIN (
				SELECT
					goodscode,
					sum(number * sign) AS t_num2,
					sum(money * sign) AS t_money2
				FROM
					s_billdetail
				WHERE
					type IN (
						'采购入库',
						'采购退货'
					)  and adddate >='2022-02-26' and adddate <='2023-02-25' and DepotName='纸浆厂仓库' and goodsname like '%柴油%'
				GROUP BY
					goodscode
			) d ON a.goodscode = d.goodscode
		)
		LEFT JOIN (
			SELECT
				goodscode,
				sum(number) AS t_num1,
				sum(money) AS t_money1
			FROM
				s_billdetail
			WHERE
				type = '采购退货'  and adddate >='2022-02-26' and adddate <='2023-02-25' and DepotName='纸浆厂仓库' and goodsname like '%柴油%'
			GROUP BY
				goodscode
		) c ON a.goodscode = c.goodscode 
	)
LEFT JOIN (
	SELECT
		goodscode,
		sum(number) AS t_num,
		sum(money) AS t_money
	FROM
		s_billdetail
	WHERE
		type = '采购入库'  and adddate >='2022-02-26' and adddate <='2023-02-25' and DepotName='纸浆厂仓库' and goodsname like '%柴油%'
	GROUP BY
		goodscode
) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.270508s ]
---------------------------------------------------------------
[ 2023-06-13T09:33:54+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/bill/bill_info.html?type=LY
[ 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.041992s ]
[ 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 `bill` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = '' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'LY' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.033203s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = '' [ RunTime:0.125000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.002930s ]
[ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE  `makedate` = '2023-06-13'  AND `type` = '领用出库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.036133s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2023-06-13T09:39:42+08:00 ] 202.62.99.225 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.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2023-06-13T09:39:59+08:00 ] 202.62.99.225 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.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 [ 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 <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:14.329102s ]
---------------------------------------------------------------
[ 2023-06-13T09:40:02+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E7%BC%96%E7%BB%87%E8%A2%8B&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodsname like '%编织袋%' [ RunTime:0.009766s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodsname like '%编织袋%' limit 0,90 [ RunTime:12.919921s ]
---------------------------------------------------------------
[ 2023-06-13T09:40:13+08:00 ] 202.62.99.225 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.015625s ] 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.009766s ]
[ 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 ]
---------------------------------------------------------------
[ 2023-06-13T09:40:28+08:00 ] 202.62.99.225 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.020508s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ]
[ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.015625s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:12.431641s ]
---------------------------------------------------------------
[ 2023-06-13T09:40:40+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E9%92%BB%E5%A4%B4&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.036133s ]
[ 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 ] select id from goods where 1=1  and goodsname like '%钻头%' [ RunTime:0.008789s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodsname like '%钻头%' limit 0,90 [ RunTime:12.108398s ]
---------------------------------------------------------------
[ 2023-06-13T09:40:53+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E9%92%BB%E5%A4%B4&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.035156s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodsname like '%钻头%' [ RunTime:0.008789s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodsname like '%钻头%' limit 0,90 [ RunTime:12.445312s ]
---------------------------------------------------------------
[ 2023-06-13T09:49:18+08:00 ] 202.62.99.225 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.005860s ] 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.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2023-06-13T09:49:33+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.016601s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:12.038086s ]
---------------------------------------------------------------
[ 2023-06-13T09:49:59+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E6%89%8B%E5%A5%97&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.021485s ]
[ 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 goodsname like '%手套%' [ RunTime:0.007812s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodsname like '%手套%' limit 0,90 [ RunTime:12.055664s ]
---------------------------------------------------------------
[ 2023-06-13T09:50:15+08:00 ] 202.62.99.225 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.021484s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2023-06-13T09:50:30+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ]
[ 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.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 <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:12.028320s ]
---------------------------------------------------------------
[ 2023-06-13T09:50:42+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=specification&value=51305&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027343s ]
[ 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 ] select id from goods where 1=1  and specification like '%51305%' [ RunTime:0.008789s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and specification like '%51305%' limit 0,90 [ RunTime:11.721680s ]
---------------------------------------------------------------
[ 2023-06-13T09:50:59+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=specification&value=51305&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.022460s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1  and specification like '%51305%' [ RunTime:0.008789s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and specification like '%51305%' limit 0,90 [ RunTime:16.705078s ]
---------------------------------------------------------------
[ 2023-06-13T09:51:02+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodsname like '%轴承%' [ RunTime:0.009765s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodsname like '%轴承%' limit 0,90 [ RunTime:12.273438s ]
---------------------------------------------------------------
[ 2023-06-13T09:51:28+08:00 ] 202.62.99.225 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.013671s ] 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.016602s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2023-06-13T09:51:43+08:00 ] 202.62.99.225 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.018554s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.014649s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:12.738281s ]
---------------------------------------------------------------
[ 2023-06-13T09:51:59+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E8%9E%BA%E5%B8%BD&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.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.000977s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodsname like '%螺帽%' [ RunTime:0.012696s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodsname like '%螺帽%' limit 0,90 [ RunTime:17.601562s ]
---------------------------------------------------------------
[ 2023-06-13T09:51:59+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E6%BB%A4%E6%A3%89&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.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodsname like '%滤棉%' [ RunTime:0.007813s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodsname like '%滤棉%' limit 0,90 [ RunTime:15.548828s ]
---------------------------------------------------------------
[ 2023-06-13T09:52:12+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E6%BB%A4%E6%A3%89&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.020507s ] 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.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodsname like '%滤棉%' [ RunTime:0.008789s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodsname like '%滤棉%' limit 0,90 [ RunTime:12.033203s ]
---------------------------------------------------------------
[ 2023-06-13T09:52:24+08:00 ] 202.62.99.225 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.024414s ]
[ 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 ]
---------------------------------------------------------------
[ 2023-06-13T09:52:25+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E6%BB%A4%E6%A3%89&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018554s ]
[ 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.000976s ]
[ sql ] [ SQL ] select id from goods where 1=1  and goodsname like '%滤棉%' [ RunTime:0.007812s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  and goodsname like '%滤棉%' limit 0,90 [ RunTime:12.377930s ]
---------------------------------------------------------------
[ 2023-06-13T09:52:38+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017578s ]
[ 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.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.016602s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:11.914063s ]
---------------------------------------------------------------
[ 2023-06-13T09:52:40+08:00 ] 202.62.99.225 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.018555s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2023-06-13T09:52:56+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018555s ]
[ 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 [ RunTime:0.014649s ]
[ sql ] [ SQL ] select * from(SELECT
	goods.*, '铅锌矿仓库' as depotname,
  IFNULL(t_num,0) AS t_num,
	IFNULL(t_price,0) AS t_price,
	IFNULL(t_money,0) AS t_money
FROM
	goods
LEFT OUTER JOIN (
	SELECT
		goodscode,
		case
WHEN sum(number * sign) = -0 THEN
		0
	ELSE
		sum(number * sign)
	END AS t_num,
		CASE
	WHEN sum(number * sign) = 0 THEN
		0
	ELSE
		sum(cbprice * sign * number) / sum(number * sign)
	END AS t_price,
	sum(number * sign) * CASE
WHEN sum(number * sign) = 0 THEN
	0
ELSE
	sum(cbprice * sign * number) / sum(number * sign)
END AS t_money
FROM
	s_goodsnum1
WHERE
	adddate <= '2023-06-13'
  and depotname='铅锌矿仓库'
GROUP BY
	goodscode
) AS depot ON depot.goodscode = goods.goodscode
) as S3 where 1=1  limit 0,90 [ RunTime:15.298828s ]
---------------------------------------------------------------
[ 2023-06-13T09:53:36+08:00 ] 202.62.99.225 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.018555s ]
[ 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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'LY-2023-06-13-0001' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `custname` , `operator` , `originalcode` , `note`) VALUES ('领用出库' , '出库' , '2023-06-13 09:33:54' , 'LY-2023-06-13-0001' , '2023-06-13' , '小胡' , '2023-06-13' , '铅锌矿仓库' , '霸王山坑内钻' , '胡甸琼' , '' , '李正全领') [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10257' GROUP BY `goodscode` [ RunTime:12.860352s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.020508s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10257' , '编织袋' , '' , '个' , 0.71 , 10 , 7.1 , '' , 0.71 , 'LY-2023-06-13-0001' , -1) [ RunTime:0.002929s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G15725' GROUP BY `goodscode` [ RunTime:9.002930s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G15725' , '帆布手套' , '' , '双' , 2.56 , 5 , 12.8 , '' , 2.56 , 'LY-2023-06-13-0001' , -1) [ RunTime:0.002929s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G16500' GROUP BY `goodscode` [ RunTime:11.342773s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G16500' , '防滑手套' , '807' , '双' , 8.38 , 5 , 41.9 , '' , 8.38 , 'LY-2023-06-13-0001' , -1) [ RunTime:0.002930s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10951' GROUP BY `goodscode` [ RunTime:10.238282s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10951' , '轴承' , 'NQ' , '只' , 35 , 19 , 665 , '' , 35 , 'LY-2023-06-13-0001' , -1) [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '铅锌矿仓库'  AND `goodscode` = 'G10223' GROUP BY `goodscode` [ RunTime:7.151367s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G10223' , '3M防尘口罩滤棉' , '5N11CN' , '片' , 1.32 , 20 , 26.4 , '' , 1.32 , 'LY-2023-06-13-0001' , -1) [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2023-06-13T09:53:38+08:00 ] 202.62.99.225 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.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.036133s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.068360s ]
---------------------------------------------------------------
[ 2023-06-13T09:59:21+08:00 ] 202.62.99.225 GET 103.45.248.127:8001/index/bill/bill_info.html?type=LY
[ 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.026367s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = '' LIMIT 1 [ RunTime:0.001953s ]
[ 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.017579s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.002929s ]
[ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE  `makedate` = '2023-06-13'  AND `type` = '领用出库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.003907s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2023-06-13T17:39:47+08:00 ] 202.62.102.209 GET 103.45.248.127:8001/home
[ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ]
---------------------------------------------------------------
[ 2023-06-13T18:01:52+08:00 ] 202.62.99.245 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.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.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.019532s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.051758s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.058594s ]
---------------------------------------------------------------
[ 2023-06-13T18:01:52+08:00 ] 202.62.99.245 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.016602s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ 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` = '' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'LY' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = '' [ RunTime:0.136719s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.002930s ]
[ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE  `makedate` = '2023-06-13'  AND `type` = '领用出库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2023-06-13T20:49:57+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_print.html?type=excel&billcode=DC-2023-06-06-0001
[ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ]
[ 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.015625s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'DC-2023-06-06-0001' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-06-0001' [ RunTime:0.110352s ]
[ sql ] [ SQL ] SELECT sum(money) as tmoney,sum(number) as tnum FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-06-0001' LIMIT 1 [ RunTime:0.045898s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billname` = '调出仓库' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `company` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `company` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2023-06-13T20:50:03+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_info.html?type=DC&billcode=DC-2023-06-05-0001
[ 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.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.020508s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'DC-2023-06-05-0001' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'DC' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-05-0001' [ RunTime:0.101563s ]
[ 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.001953s ]
---------------------------------------------------------------
[ 2023-06-13T20:50:07+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90
[ 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.019531s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '调出仓库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.041016s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '调出仓库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.056640s ]
---------------------------------------------------------------
[ 2023-06-13T20:50:14+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_info.html?type=DC&billcode=DC-2023-06-02-0006
[ 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.033203s ]
[ 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.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017579s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'DC-2023-06-02-0006' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'DC' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.014649s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-02-0006' [ RunTime:0.105469s ]
[ 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.016601s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2023-06-13T20:50:18+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.004882s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014648s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '调出仓库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.041015s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '调出仓库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.055664s ]
---------------------------------------------------------------
[ 2023-06-13T20:50:21+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_info.html?type=DC&billcode=DC-2023-06-06-0001
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.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` = 'DC-2023-06-06-0001' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'DC' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-06-0001' [ 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 ]
---------------------------------------------------------------
[ 2023-06-13T20:51:13+08:00 ] 202.62.99.65 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.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.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '嘎西仓储'  AND `goodscode` = 'G17800' GROUP BY `goodscode` [ RunTime:7.441406s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-06-0001'  AND `goodscode` = 'G17800' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '嘎西仓储'  AND `goodscode` = 'G17801' GROUP BY `goodscode` [ RunTime:6.175781s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-06-0001'  AND `goodscode` = 'G17801' LIMIT 1 [ RunTime:0.005859s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '嘎西仓储'  AND `goodscode` = 'G17802' GROUP BY `goodscode` [ RunTime:6.928711s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-06-0001'  AND `goodscode` = 'G17802' LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '嘎西仓储'  AND `goodscode` = 'G17803' GROUP BY `goodscode` [ RunTime:8.058593s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-06-0001'  AND `goodscode` = 'G17803' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '嘎西仓储'  AND `goodscode` = 'G17805' GROUP BY `goodscode` [ RunTime:8.974610s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-06-0001'  AND `goodscode` = 'G17805' LIMIT 1 [ RunTime:0.003906s ]
[ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE  `depotname` = '嘎西仓储'  AND `goodscode` = 'G17806' GROUP BY `goodscode` [ RunTime:7.008789s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-06-0001'  AND `goodscode` = 'G17806' LIMIT 1 [ RunTime:0.004883s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.020508s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `type`='调出仓库',`inorout`='出库',`newtime`='2023-06-06 11:01:42',`billcode`='DC-2023-06-06-0001',`makedate`='2023-06-06',`maker`='杨雅雯',`adddate`='2023-06-06',`depotname`='嘎西仓储',`depotname1`='铅锌矿仓库',`operator`='孙干智',`originalcode`='',`note`='',`updateman`='杨雅雯',`updatetime`='2023-06-13'  WHERE  `billid` = 40448 [ RunTime:0.004883s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'DC-2023-06-06-0001' [ RunTime:0.109375s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17800' , '螺杆空压机油' , '开山1号' , '桶' , 340 , 10 , 3400 , '' , 340 , 'DC-2023-06-06-0001' , -1) [ RunTime:0.000977s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17801' , '10T下沟' , '' , '个' , 1150 , 1 , 1150 , '' , 1150 , 'DC-2023-06-06-0001' , -1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17802' , '10T下沟轮子' , '' , '个' , 220 , 1 , 220 , '' , 220 , 'DC-2023-06-06-0001' , -1) [ RunTime:0.000976s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17803' , '潜孔钻钻杆' , '60MM' , '根' , 115 , 10 , 1150 , '' , 115 , 'DC-2023-06-06-0001' , -1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17805' , '轴承' , '32230' , '个' , 1280 , 2 , 2560 , '' , 1280 , 'DC-2023-06-06-0001' , -1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17806' , '油封' , '150*180*15' , '个' , 55 , 2 , 110 , '' , 55 , 'DC-2023-06-06-0001' , -1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `depotname`='铅锌矿仓库',`depotname1`='嘎西仓储',`adddate`='2023-06-06',`originalcode`='',`operator`='孙干智',`barcode`=NULL,`note`='',`updateman`='杨雅雯',`updatetime`='2023-06-13'  WHERE  `billcode` = 'DR-2023-06-06-0001' [ RunTime:0.001953s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'DR-2023-06-06-0001' [ RunTime:0.098633s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17800' , '螺杆空压机油' , '开山1号' , '桶' , 340 , 10 , 3400 , '' , 340 , 'DR-2023-06-06-0001' , 1) [ RunTime:0.001953s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17801' , '10T下沟' , '' , '个' , 1150 , 1 , 1150 , '' , 1150 , 'DR-2023-06-06-0001' , 1) [ RunTime:0.000977s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17802' , '10T下沟轮子' , '' , '个' , 220 , 1 , 220 , '' , 220 , 'DR-2023-06-06-0001' , 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17803' , '潜孔钻钻杆' , '60MM' , '根' , 115 , 10 , 1150 , '' , 115 , 'DR-2023-06-06-0001' , 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17805' , '轴承' , '32230' , '个' , 1280 , 2 , 2560 , '' , 1280 , 'DR-2023-06-06-0001' , 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17806' , '油封' , '150*180*15' , '个' , 55 , 2 , 110 , '' , 55 , 'DR-2023-06-06-0001' , 1) [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2023-06-13T20:51:17+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ 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.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '调出仓库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.034179s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '调出仓库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.052734s ]
---------------------------------------------------------------
[ 2023-06-13T20:51:28+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_info.html?type=CG&billcode=CG-2023-06-09-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.016602s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'CG-2023-06-09-0001' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.014648s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'CG' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'CG-2023-06-09-0001' [ RunTime:0.104492s ]
[ 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.015625s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2023-06-13T20:51:37+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.009766s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.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.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.025391s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '采购入库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.061523s ]
---------------------------------------------------------------
[ 2023-06-13T20:51:44+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_info.html?type=CG&billcode=CG-2023-06-06-0001
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.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 ] SHOW COLUMNS FROM `bill` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'CG-2023-06-06-0001' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'CG' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'CG-2023-06-06-0001' [ RunTime:0.120117s ]
[ 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.016602s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2023-06-13T20:51:53+08:00 ] 202.62.99.65 POST 103.45.248.127:8001/index/bill/save_bill.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.023437s ] 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.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014648s ]
[ sql ] [ SQL ] UPDATE `bill`  SET `type`='采购入库',`inorout`='入库',`newtime`='2023-06-06 09:44:22',`billcode`='CG-2023-06-06-0001',`makedate`='2023-06-06',`maker`='杨雅雯',`adddate`='2023-06-06',`depotname`='嘎西仓储',`custname`='万象金弓机电',`operator`='孙干智',`originalcode`='',`note`='铅锌矿',`updateman`='杨雅雯',`updatetime`='2023-06-13'  WHERE  `billid` = 40447 [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.016602s ]
[ sql ] [ SQL ] DELETE FROM `billdetail`    WHERE  `billcode` = 'CG-2023-06-06-0001' [ RunTime:0.108399s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17800' , '螺杆空压机油' , '开山1号' , '桶' , 340 , 10 , 3400 , '83号单' , 340 , 'CG-2023-06-06-0001' , 1) [ RunTime:0.001953s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17801' , '10T下沟' , '' , '个' , 1150 , 1 , 1150 , '83号单' , 1150 , 'CG-2023-06-06-0001' , 1) [ RunTime:0.000977s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17802' , '10T下沟轮子' , '' , '个' , 220 , 1 , 220 , '83号单' , 220 , 'CG-2023-06-06-0001' , 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17803' , '潜孔钻钻杆' , '60MM' , '根' , 115 , 10 , 1150 , '83号单' , 115 , 'CG-2023-06-06-0001' , 1) [ RunTime:0.000976s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17805' , '轴承' , '32230' , '个' , 1280 , 2 , 2560 , '83号单' , 1280 , 'CG-2023-06-06-0001' , 1) [ RunTime:0.000977s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17806' , '油封' , '150*180*15' , '个' , 55 , 2 , 110 , '83号单' , 55 , 'CG-2023-06-06-0001' , 1) [ RunTime:0.000977s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17076' , '轴承' , '6302' , '个' , 13 , 1 , 13 , '83号单' , 13 , 'CG-2023-06-06-0001' , 1) [ RunTime:0.000977s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17807' , '叉车离合器片' , '' , '片' , 125 , 1 , 125 , '83号单' , 125 , 'CG-2023-06-06-0001' , 1) [ RunTime:0.000976s ]
[ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G16582' , '离合器压盘' , '' , '个' , 300 , 1 , 300 , '83号单' , 300 , 'CG-2023-06-06-0001' , 1) [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2023-06-13T20:51:55+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90
[ 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.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.028321s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '采购入库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.055664s ]
---------------------------------------------------------------
[ 2023-06-13T20:52:06+08:00 ] 202.62.99.65 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&type=DC&billcode=DC-2023-06-06-0001
[ 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.030273s ]
[ 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 ] SHOW COLUMNS FROM `bill` [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `billcode` = 'DC-2023-06-06-0001' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `configuration` WHERE  `billtype` = 'DC' LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE  `billcode` = 'DC-2023-06-06-0001' [ RunTime:0.115234s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2023-06-13T20:53:28+08:00 ] 202.62.99.245 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.015625s ] 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.002930s ]
[ 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.015625s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.032226s ]
[ sql ] [ SQL ] SELECT * FROM `bill` WHERE  `type` = '领用出库'  AND `adddate` BETWEEN '2023-06-01' AND '2023-06-13'  AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.057617s ]