--------------------------------------------------------------- [ 2023-07-31T08:56:52+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/stock_search.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ 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` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'stock' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-31T08:56:55+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ 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.020508s ] [ 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` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'billdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-31T08:56:57+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ] [ 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` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-07-01' AND '2023-07-31' LIMIT 1 [ RunTime:0.466796s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-07-01' AND '2023-07-31' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2023-07-31T08:57:08+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013671s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.022460s ] [ 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-07-31' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:14.091797s ] --------------------------------------------------------------- [ 2023-07-31T08:57:17+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2023-05-26&enddate=2023-07-25&billtype=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.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` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' LIMIT 1 [ RunTime:0.506836s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.008789s ] --------------------------------------------------------------- [ 2023-07-31T08:57:31+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=3000&startdate=2023-05-26&enddate=2023-07-25&billtype=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' LIMIT 1 [ RunTime:0.493164s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' ORDER BY `billdetailid` DESC LIMIT 0,3000 [ RunTime:0.615235s ] --------------------------------------------------------------- [ 2023-07-31T09:00:31+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/kcreport/stock_sum.html [ sql ] [ DB ] CONNECT:[ UseTime:0.016602s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-31T09:00:32+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?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.016601s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-31T09:00:47+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-05-26&enddate=2023-07-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.017579s ] [ 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 <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2023-05-26' AND adddate <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2023-05-26' AND adddate <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2023-05-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.923828s ] --------------------------------------------------------------- [ 2023-07-31T09:00:59+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=3000&startdate=2023-05-26&enddate=2023-07-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.014648s ] [ 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 <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2023-05-26' AND adddate <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2023-05-26' AND adddate <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2023-05-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,3000 [ RunTime:5.613281s ] --------------------------------------------------------------- [ 2023-07-31T09:01:28+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=2&limit=3000&startdate=2023-05-26&enddate=2023-07-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ 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` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.013671s ] [ 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 <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2023-05-26' AND adddate <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2023-05-26' AND adddate <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2023-05-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 3000,3000 [ RunTime:9.219727s ] --------------------------------------------------------------- [ 2023-07-31T09:01:55+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=3&limit=3000&startdate=2023-05-26&enddate=2023-07-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.015625s ] [ 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 <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2023-05-26' AND adddate <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2023-05-26' AND adddate <= '2023-07-25' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2023-05-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 6000,3000 [ RunTime:11.969726s ] --------------------------------------------------------------- [ 2023-07-31T09:15:38+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=3000&startdate=2023-05-26&enddate=2023-07-25&billtype=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&billcode=DC-2023-07-15-0001&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ 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.037110s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' AND `type` = '领用出库' AND `billcode` LIKE '%DC-2023-07-15-0001%' LIMIT 1 [ RunTime:0.539063s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' AND `type` = '领用出库' AND `billcode` LIKE '%DC-2023-07-15-0001%' ORDER BY `billdetailid` DESC LIMIT 0,3000 [ RunTime:0.541992s ] --------------------------------------------------------------- [ 2023-07-31T09:16:06+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=3000&startdate=2023-05-26&enddate=2023-07-25&billtype=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&depotname=&custname=&billcode=DC-2023-07-15-0001&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ 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` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `type` = '领用出库' AND `billcode` LIKE '%DC-2023-07-15-0001%' LIMIT 1 [ RunTime:0.473633s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `type` = '领用出库' AND `billcode` LIKE '%DC-2023-07-15-0001%' ORDER BY `billdetailid` DESC LIMIT 0,3000 [ RunTime:0.569336s ] --------------------------------------------------------------- [ 2023-07-31T09:16:23+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=3000&startdate=2023-05-26&enddate=2023-07-25&billtype=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&depotname=&custname=&billcode=DC-2023-07-15-0001&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ 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.022461s ] [ 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` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `type` = '领用出库' AND `billcode` LIKE '%DC-2023-07-15-0001%' LIMIT 1 [ RunTime:0.482422s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `type` = '领用出库' AND `billcode` LIKE '%DC-2023-07-15-0001%' ORDER BY `billdetailid` DESC LIMIT 0,3000 [ RunTime:0.633789s ] --------------------------------------------------------------- [ 2023-07-31T09:16:35+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ] [ 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` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'billdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-31T09:16:37+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017578s ] [ 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` ORDER BY `id` DESC [ RunTime:0.008789s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-07-01' AND '2023-07-31' LIMIT 1 [ RunTime:0.422851s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-07-01' AND '2023-07-31' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.005859s ] --------------------------------------------------------------- [ 2023-07-31T09:17:00+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2023-05-26&enddate=2023-07-25&billtype=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.040039s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' AND `type` = '领用出库' LIMIT 1 [ RunTime:0.504883s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' AND `type` = '领用出库' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.017578s ] --------------------------------------------------------------- [ 2023-07-31T09:17:07+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&billcode=LY-2023-07-12-0014 [ 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.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` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'LY-2023-07-12-0014' LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billname` = '领用出库' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'LY-2023-07-12-0014' [ RunTime:0.125000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-31T09:17:34+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2023-05-26&enddate=2023-07-25&billtype=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.014648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' AND `type` = '调出仓库' LIMIT 1 [ RunTime:0.489257s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' AND `type` = '调出仓库' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.628906s ] --------------------------------------------------------------- [ 2023-07-31T09:17:39+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&billcode=DC-2023-07-15-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.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` 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-07-15-0001' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billname` = '调出仓库' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'DC-2023-07-15-0001' [ RunTime:0.114258s ] [ 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.021484s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-31T09:18:22+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2023-05-26&enddate=2023-07-25&billtype=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&billcode=DC-2023-07-15-0001&originalcode=&operator=&maker=&goodscode=&goodsname=&detailnote= [ 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.032227s ] [ 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` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' AND `type` = '调出仓库' AND `billcode` LIKE '%DC-2023-07-15-0001%' LIMIT 1 [ RunTime:0.489258s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' AND `type` = '调出仓库' AND `billcode` LIKE '%DC-2023-07-15-0001%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.542969s ] --------------------------------------------------------------- [ 2023-07-31T09:18:27+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&billcode=DC-2023-07-15-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.027344s ] [ 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` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'DC-2023-07-15-0001' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billname` = '调出仓库' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'DC-2023-07-15-0001' [ RunTime:0.102539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-31T09:18:58+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/bill/billshow.html?type=DC [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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 `fieldshow` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'dcbill' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2023-07-31T09:18:59+08:00 ] 43.252.246.150 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.015625s ] 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` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-31' LIMIT 1 [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-31' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.060547s ] --------------------------------------------------------------- [ 2023-07-31T09:19:16+08:00 ] 43.252.246.150 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&startdate=2023-05-26&enddate=2023-07-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&depotname1=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-05-26' AND '2023-07-25' AND `depotname` = '纸浆厂仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.057617s ] --------------------------------------------------------------- [ 2023-07-31T09:19:40+08:00 ] 43.252.246.150 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.028320s ] [ 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` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'transferdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2023-07-31T09:19:42+08:00 ] 43.252.246.150 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.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017579s ] [ 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` 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-07-01' and adddate <='2023-07-31'order by billdetailid DESC [ RunTime:0.579102s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-07-01' and adddate <='2023-07-31'order by billdetailid DESC limit 0,90 [ RunTime:0.018554s ] --------------------------------------------------------------- [ 2023-07-31T09:20:00+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-05-26&enddate=2023-07-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.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.015625s ] [ 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-05-26' and adddate <='2023-07-25' 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 ='调出仓库' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.563477s ] --------------------------------------------------------------- [ 2023-07-31T09:27:59+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/cgreport/cg_detail.html [ 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.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2023-07-31T09:28:04+08:00 ] 43.252.246.150 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.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ 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 >='2023-07-01' and adddate <='2023-07-31'order by billdetailid DESC [ RunTime:0.613281s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2023-07-01' and adddate <='2023-07-31'order by billdetailid DESC limit 0,90 [ RunTime:0.018555s ] --------------------------------------------------------------- [ 2023-07-31T09:28:24+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-05-26&enddate=2023-07-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&goodscategory= [ 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.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'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 >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.607422s ] --------------------------------------------------------------- [ 2023-07-31T09:28:42+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=40&startdate=2023-05-26&enddate=2023-07-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&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.022461s ] [ 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` 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 >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.569336s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,40 [ RunTime:0.564453s ] --------------------------------------------------------------- [ 2023-07-31T09:42:01+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/transfer_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.007812s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.049805s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'transferdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2023-07-31T09:42:03+08:00 ] 43.252.246.150 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.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ 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-07-01' and adddate <='2023-07-31'order by billdetailid DESC [ RunTime:0.614258s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-07-01' and adddate <='2023-07-31'order by billdetailid DESC limit 0,90 [ RunTime:0.018554s ] --------------------------------------------------------------- [ 2023-07-31T09:42:17+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=90&startdate=2023-05-26&enddate=2023-07-25&depotname=&depotname1=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&goodscode=&goodsname=&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.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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-05-26' and adddate <='2023-07-25' and depotname1='纸浆厂仓库'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 ='调出仓库' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname1='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.037110s ] --------------------------------------------------------------- [ 2023-07-31T09:42:38+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=3000&startdate=2023-05-26&enddate=2023-07-25&depotname=&depotname1=%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.024414s ] [ 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` 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-05-26' and adddate <='2023-07-25' and depotname1='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.593750s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname1='纸浆厂仓库'order by billdetailid DESC limit 0,3000 [ RunTime:0.538086s ] --------------------------------------------------------------- [ 2023-07-31T09:43:12+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/adjust_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.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'adjustdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2023-07-31T09:43:15+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.002929s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2023-07-01' and adddate <='2023-07-31'order by billdetailid DESC [ RunTime:0.618164s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2023-07-01' and adddate <='2023-07-31'order by billdetailid DESC limit 0,90 [ RunTime:0.011719s ] --------------------------------------------------------------- [ 2023-07-31T09:43:29+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-05-26&enddate=2023-07-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.014649s ] 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.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.599610s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.009766s ] --------------------------------------------------------------- [ 2023-07-31T09:44:43+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/lyreport/receive_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.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'receivedetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-31T09:44:45+08:00 ] 43.252.246.150 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.011718s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017579s ] [ 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` 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-07-01' and adddate <='2023-07-31'order by billdetailid DESC [ RunTime:0.608398s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2023-07-01' and adddate <='2023-07-31'order by billdetailid DESC limit 0,90 [ RunTime:0.018555s ] --------------------------------------------------------------- [ 2023-07-31T09:45:00+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-05-26&enddate=2023-07-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.632813s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.016601s ] --------------------------------------------------------------- [ 2023-07-31T09:45:12+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2023-05-26&enddate=2023-07-25&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&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.025390s ] [ 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` 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 >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.625977s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,3000 [ RunTime:0.563476s ] --------------------------------------------------------------- [ 2023-07-31T09:47:36+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=3000&startdate=2023-05-26&enddate=2023-07-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.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026368s ] [ 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` 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-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.575196s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,3000 [ RunTime:0.541992s ] --------------------------------------------------------------- [ 2023-07-31T09:47:51+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/transferdetail_data.html?goodscode=&startdate=&enddate=&depotname=&depotname1=&page=1&limit=30&startdate=2023-05-26&enddate=2023-07-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.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.604492s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type ='调出仓库' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,30 [ RunTime:0.525390s ] --------------------------------------------------------------- [ 2023-07-31T10:16:40+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-05-26&enddate=2023-07-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.032227s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.052734s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:1.834961s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.009766s ] --------------------------------------------------------------- [ 2023-07-31T10:16:54+08:00 ] 43.252.246.150 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2023-05-26&enddate=2023-07-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.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.592773s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2023-05-26' and adddate <='2023-07-25' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,3000 [ RunTime:0.547852s ]