---------------------------------------------------------------
[ 2024-02-07T11:18:34+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/kcreport/stock_sum.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.046875s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.104493s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.047852s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.053711s ]
---------------------------------------------------------------
[ 2024-02-07T11:18:35+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.003907s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.051758s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.053711s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-02-07T11:19:16+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&field=&value=&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.065429s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.053710s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.019531s ]
[ 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 					  
					) 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-01-31' 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 >= '2023-12-26'
                        AND adddate <= '2024-01-31' 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 >= '2023-12-26'
                        AND adddate <= '2024-01-31' 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 < '2023-12-26' and depotname='铜矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.837891s ]
---------------------------------------------------------------
[ 2024-02-07T11:19:28+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=3000&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&field=&value=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.126953s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.067383s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.055664s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.014649s ]
[ 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 					  
					) 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-01-31' 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 >= '2023-12-26'
                        AND adddate <= '2024-01-31' 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 >= '2023-12-26'
                        AND adddate <= '2024-01-31' 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 < '2023-12-26' and depotname='铜矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 0,3000 [ RunTime:3.817383s ]
---------------------------------------------------------------
[ 2024-02-07T11:19:50+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=2&limit=3000&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&field=&value=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.020508s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.058594s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.042968s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ]
[ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.016601s ]
[ 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 					  
					) 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-01-31' 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 >= '2023-12-26'
                        AND adddate <= '2024-01-31' 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 >= '2023-12-26'
                        AND adddate <= '2024-01-31' 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 < '2023-12-26' and depotname='铜矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 3000,3000 [ RunTime:5.833984s ]
---------------------------------------------------------------
[ 2024-02-07T11:20:28+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=3&limit=3000&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&field=&value=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.030274s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.078125s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.047852s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.026367s ]
[ 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 					  
					) 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-01-31' 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 >= '2023-12-26'
                        AND adddate <= '2024-01-31' 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 >= '2023-12-26'
                        AND adddate <= '2024-01-31' 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 < '2023-12-26' and depotname='铜矿仓库'
				GROUP BY
					goodscode
			) AS s_start ON aa.goodscode = s_start.goodscode limit 6000,3000 [ RunTime:7.655273s ]
---------------------------------------------------------------
[ 2024-02-07T11:27:34+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/cgreport/cg_detail.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.087890s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.084961s ]
[ 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` ORDER BY `id` DESC [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.049804s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'cgdetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.003906s ]
---------------------------------------------------------------
[ 2024-02-07T11:27:36+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.021485s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.042968s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.048828s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC [ RunTime:0.654297s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC limit 0,90 [ RunTime:0.544922s ]
---------------------------------------------------------------
[ 2024-02-07T11:27:49+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.205079s ] 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.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.044922s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC [ RunTime:0.574219s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.564453s ]
---------------------------------------------------------------
[ 2024-02-07T11:28:16+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/xsreport/sale_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.083008s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.052734s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.045898s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'saledetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-02-07T11:28:18+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/xsreport/saledetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.056641s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.048828s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.053711s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('销售提货','销售退货')  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC [ RunTime:0.612305s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('销售提货','销售退货')  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC limit 0,90 [ RunTime:0.594726s ]
---------------------------------------------------------------
[ 2024-02-07T11:28:30+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/xsreport/saledetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&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.062500s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.052734s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('销售提货','销售退货')  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC [ RunTime:0.601563s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('销售提货','销售退货')  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.583984s ]
---------------------------------------------------------------
[ 2024-02-07T11:28:58+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/lyreport/receive_detail.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.056641s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.110351s ]
[ 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` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.050781s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'receivedetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.010742s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.054687s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-02-07T11:29:00+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&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.055665s ]
[ 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` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库')  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC [ RunTime:0.654297s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库')  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC limit 0,90 [ RunTime:0.580078s ]
---------------------------------------------------------------
[ 2024-02-07T11:29:13+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.049804s ] 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.041016s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.042969s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库')  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC [ RunTime:0.626953s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库')  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.597656s ]
---------------------------------------------------------------
[ 2024-02-07T11:30:33+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/screport/product_detail.html
[ 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.072266s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:70.056641s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.042969s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'productdetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.053711s ]
[ sql ] [ SQL ] SELECT * FROM `other` WHERE  `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-02-07T11:30:35+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/screport/productdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&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.052735s ]
[ 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` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type ='生产入库'  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC [ RunTime:0.600586s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type ='生产入库'  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC limit 0,90 [ RunTime:0.587891s ]
---------------------------------------------------------------
[ 2024-02-07T11:30:47+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/screport/productdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.055664s ] 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.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.040039s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type ='生产入库'  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC [ RunTime:0.653320s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type ='生产入库'  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.610352s ]
---------------------------------------------------------------
[ 2024-02-07T11:30:58+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/jhreport/circulate_detail.html
[ 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.076172s ]
[ 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` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.045899s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'circulatedetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ]
---------------------------------------------------------------
[ 2024-02-07T11:31:00+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/jhreport/circulatedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.045898s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.044921s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.051757s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('借货入库',
			'借入还出',
			'借货出库',
			'借出还入')  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC [ RunTime:0.633789s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('借货入库',
			'借入还出',
			'借货出库',
			'借出还入')  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC limit 0,90 [ RunTime:0.553711s ]
---------------------------------------------------------------
[ 2024-02-07T11:31:13+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/jhreport/circulatedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&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.062500s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.054687s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('借货入库',
			'借入还出',
			'借货出库',
			'借出还入')  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC [ RunTime:0.588867s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('借货入库',
			'借入还出',
			'借货出库',
			'借出还入')  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.535156s ]
---------------------------------------------------------------
[ 2024-02-07T11:31:18+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/qtreport/transfer_detail.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.089844s ] 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.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.042968s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.043945s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'transferdetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-02-07T11:31:20+08:00 ] 43.252.246.84 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.012695s ] 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.054688s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.054687s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库'  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC [ RunTime:0.595703s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库'  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC limit 0,90 [ RunTime:0.556641s ]
---------------------------------------------------------------
[ 2024-02-07T11:31:45+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-12-26&enddate=2024-01-31&depotname=&depotname1=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.022461s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.064453s ]
[ 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` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库'  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname1='铜矿仓库'order by billdetailid DESC [ RunTime:0.584961s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库'  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname1='铜矿仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.581055s ]
---------------------------------------------------------------
[ 2024-02-07T11:31:56+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.053711s ] 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.034180s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.044922s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库'  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC [ RunTime:0.589844s ]
[ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库'  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.599609s ]
---------------------------------------------------------------
[ 2024-02-07T11:32:02+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/qtreport/adjust_detail.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.070312s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.051758s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.044922s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.040039s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'adjustdetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-02-07T11:32:04+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90
[ sql ] [ DB ] CONNECT:[ UseTime:0.055664s ] 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.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.048828s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点'  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC [ RunTime:0.616211s ]
[ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点'  and adddate >='2024-02-01' and adddate <='2024-02-07'order by billdetailid DESC limit 0,90 [ RunTime:0.605469s ]
---------------------------------------------------------------
[ 2024-02-07T11:32:18+08:00 ] 43.252.246.84 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-12-26&enddate=2024-01-31&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=&goodsname=&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.061524s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.012696s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.050782s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点'  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC [ RunTime:0.584961s ]
[ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点'  and adddate >='2023-12-26' and adddate <='2024-01-31' and depotname='铜矿仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.540039s ]