---------------------------------------------------------------
[ 2023-04-01T20:58:47+08:00 ] 27.148.248.212 GET 103.45.248.127:8001/index/lyreport/receivesum_data.html?page=1&limit=3000&startdate=2023-02-26&enddate=2023-03-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&goodscode=&goodsname=&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.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.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 >='2023-02-26' and adddate <='2023-03-25' and depotname='纸浆厂仓库'
				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 >='2023-02-26' and adddate <='2023-03-25' and depotname='纸浆厂仓库'
			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 >='2023-02-26' and adddate <='2023-03-25' and depotname='纸浆厂仓库'
	GROUP BY
		goodscode
) b ON a.goodscode = b.goodscode [ RunTime:1.403321s ]
[ 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 >='2023-02-26' and adddate <='2023-03-25' and depotname='纸浆厂仓库'
				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 >='2023-02-26' and adddate <='2023-03-25' and depotname='纸浆厂仓库'
			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 >='2023-02-26' and adddate <='2023-03-25' and depotname='纸浆厂仓库'
	GROUP BY
		goodscode
) b ON a.goodscode = b.goodscode limit 0,3000 [ RunTime:1.347656s ]
---------------------------------------------------------------
[ 2023-04-01T21:23:51+08:00 ] 27.148.248.212 GET 103.45.248.127:8001/index/qtreport/transfer_detail.html
[ 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.001954s ]
[ 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.017578s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'transferdetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.003906s ]
---------------------------------------------------------------
[ 2023-04-01T21:23:53+08:00 ] 27.148.248.212 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&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.017578s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE  `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库'  and adddate >='2023-04-01' and adddate <='2023-04-01' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC [ RunTime:0.508790s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库'  and adddate >='2023-04-01' and adddate <='2023-04-01' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC limit 0,90 [ RunTime:0.481445s ]
---------------------------------------------------------------
[ 2023-04-01T21:24:09+08:00 ] 27.148.248.212 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-02-26&enddate=2023-03-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&depotname1=&goodscode=&goodsname=&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.021484s ]
[ 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.000976s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库'  and adddate >='2023-02-26' and adddate <='2023-03-25' and depotname='纸浆厂仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC [ RunTime:0.508789s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库'  and adddate >='2023-02-26' and adddate <='2023-03-25' and depotname='纸浆厂仓库' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库","嘎西仓储")order by billdetailid DESC limit 0,90 [ RunTime:0.480469s ]