--------------------------------------------------------------- [ 2024-12-10T10:21:03+08:00 ] 114.129.30.132 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'HDQ' AND `password` = 'MDAwMDAwMDAwMIaKea-xiX6u' LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '铅锌矿库管' AND `status` = 1 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-12-10 10:21:03',`web_session_id`='ab79jlni5l1esmfqja34ehikq3' WHERE `id` = 22 [ RunTime:0.014648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.021485s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'HDQ' , '杨金富' , '114.129.30.132') [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2024-12-10T10:21:04+08:00 ] 114.129.30.132 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-10T10:21:08+08:00 ] 114.129.30.132 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-12-01' AND '2024-12-10' LIMIT 1 [ RunTime:0.036133s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-12-01' AND '2024-12-10' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.003906s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-04' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-05' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-06' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-07' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-08' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-09' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-10' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-04' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-05' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-06' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-07' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-08' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-09' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-10' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-04' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-05' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-06' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-07' LIMIT 1 [ RunTime:0.029296s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-08' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-09' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-10' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-04' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-05' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-06' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-07' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-08' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-09' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-10' LIMIT 1 [ RunTime:0.022461s ] --------------------------------------------------------------- [ 2024-12-10T10:21:24+08:00 ] 114.129.30.132 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'billdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-10T10:21:28+08:00 ] 114.129.30.132 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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-12-01' AND '2024-12-10' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.501953s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-12-01' AND '2024-12-10' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.625000s ] --------------------------------------------------------------- [ 2024-12-10T10:22:01+08:00 ] 114.129.30.132 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2018-01-01&enddate=&billtype=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E5%85%AD%E5%81%8F&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.018555s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.058594s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.062500s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2018-01-01' AND '2024-12-10' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `type` = '采购入库' AND `goodsname` LIKE '%六偏%' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2018-01-01' AND '2024-12-10' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `type` = '采购入库' AND `goodsname` LIKE '%六偏%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.860352s ] --------------------------------------------------------------- [ 2024-12-10T10:22:47+08:00 ] 114.129.30.132 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2018-01-01&enddate=&billtype=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=2%E5%8F%B7&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.013672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2018-01-01' AND '2024-12-10' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `type` = '采购入库' AND `goodsname` LIKE '%2号%' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2018-01-01' AND '2024-12-10' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `type` = '采购入库' AND `goodsname` LIKE '%2号%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.791993s ] --------------------------------------------------------------- [ 2024-12-10T10:24:11+08:00 ] 114.129.30.132 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2018-01-01&enddate=&billtype=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%9D%BE%E6%B2%B9&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.007813s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2018-01-01' AND '2024-12-10' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `type` = '采购入库' AND `goodsname` LIKE '%松油%' LIMIT 1 [ RunTime:0.059570s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2018-01-01' AND '2024-12-10' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `type` = '采购入库' AND `goodsname` LIKE '%松油%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.808594s ] --------------------------------------------------------------- [ 2024-12-10T14:31:37+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cg_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.029297s ] [ 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 `fieldshow` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-12-10T14:31:39+08:00 ] 101.78.12.185 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.013672s ] 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.018555s ] [ 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 in ('采购入库','采购退货') and adddate >='2024-12-01' and adddate <='2024-12-10'order by billdetailid DESC [ RunTime:0.651367s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-12-01' and adddate <='2024-12-10'order by billdetailid DESC limit 0,90 [ RunTime:0.635743s ] --------------------------------------------------------------- [ 2024-12-10T14:31:59+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%92%BB%E5%B0%BE%E8%9E%BA%E4%B8%9D&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.021485s ] [ 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 ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%钻尾螺丝%'order by billdetailid DESC [ RunTime:0.082031s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%钻尾螺丝%'order by billdetailid DESC limit 0,90 [ RunTime:0.772461s ] --------------------------------------------------------------- [ 2024-12-10T14:38:04+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/dataquery/stock_search.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.037110s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.018555s ] [ 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 ] --------------------------------------------------------------- [ 2024-12-10T14:38:20+08:00 ] 101.78.12.185 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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.015625s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-10' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:14.707031s ] --------------------------------------------------------------- [ 2024-12-10T14:38:50+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&enddate=&field=goodscode&value=%E9%92%BB%E5%B0%BE%E8%9E%BA%E4%B8%9D&zero=true&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-10' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodscode like '%钻尾螺丝%' [ RunTime:13.570312s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-10' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodscode like '%钻尾螺丝%' limit 0,90 [ RunTime:12.969727s ] --------------------------------------------------------------- [ 2024-12-10T14:40:49+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=%E9%92%BB%E5%B0%BE%E8%9E%BA%E4%B8%9D&zero=true&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.062500s ] [ 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.000976s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-10' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%钻尾螺丝%' [ RunTime:13.713867s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-10' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and t_num <>0 and goodsname like '%钻尾螺丝%' limit 0,90 [ RunTime:12.833007s ] --------------------------------------------------------------- [ 2024-12-10T14:43:03+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=G13247&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.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ 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 >='2021-12-10' and adddate <='2024-12-10' and goodscode='G13247'order by billdetailid DESC [ RunTime:0.035156s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G13247'order by billdetailid DESC limit 0,90 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-10T14:43:31+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=G14467&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.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.002929s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G14467'order by billdetailid DESC [ RunTime:0.015625s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G14467'order by billdetailid DESC limit 0,90 [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2024-12-10T14:44:13+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=G10740&goodsname=&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.034180s ] [ 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 in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G10740'order by billdetailid DESC [ RunTime:0.005859s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G10740'order by billdetailid DESC limit 0,90 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-10T14:44:32+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=G10223&goodsname=&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.050781s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.081054s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2021-12-10' and adddate <='2024-12-10' and goodscode='G10223'order by billdetailid DESC [ RunTime:0.018555s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G10223'order by billdetailid DESC limit 0,90 [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2024-12-10T14:45:19+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=G17967&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.007813s ] 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.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.032226s ] [ 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 >='2021-12-10' and adddate <='2024-12-10' and goodscode='G17967'order by billdetailid DESC [ RunTime:0.005859s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G17967'order by billdetailid DESC limit 0,90 [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-12-10T14:47:23+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%9D%A2&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.030274s ] [ 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 >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%面%'order by billdetailid DESC [ RunTime:0.152344s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%面%'order by billdetailid DESC limit 0,90 [ RunTime:0.424805s ] --------------------------------------------------------------- [ 2024-12-10T14:47:36+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%9D%A2&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%面%'order by billdetailid DESC [ RunTime:0.049804s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%面%'order by billdetailid DESC limit 0,3000 [ RunTime:0.777343s ] --------------------------------------------------------------- [ 2024-12-10T14:48:52+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%98%B2%E6%AF%92&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.026367s ] [ 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 ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%防毒%'order by billdetailid DESC [ RunTime:0.015625s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%防毒%'order by billdetailid DESC limit 0,3000 [ RunTime:0.760742s ] --------------------------------------------------------------- [ 2024-12-10T14:48:59+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%8F%A3%E7%BD%A9&goodscategory= [ 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.001954s ] [ 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 *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%口罩%'order by billdetailid DESC [ RunTime:0.082031s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%口罩%'order by billdetailid DESC limit 0,3000 [ RunTime:0.806641s ] --------------------------------------------------------------- [ 2024-12-10T14:51:44+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=G10983&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.046875s ] [ 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 in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G10983'order by billdetailid DESC [ RunTime:0.003906s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G10983'order by billdetailid DESC limit 0,3000 [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2024-12-10T15:33:11+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=G11254&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.018555s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022460s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G11254'order by billdetailid DESC [ RunTime:0.005859s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G11254'order by billdetailid DESC limit 0,3000 [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-12-10T15:33:36+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=G11256&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.041015s ] 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.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ 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 in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G11256'order by billdetailid DESC [ RunTime:0.007812s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodscode='G11256'order by billdetailid DESC limit 0,3000 [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-12-10T15:34:30+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2021-12-10&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=PPR+&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.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.019532s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and depotname='铅锌矿仓库' and goodsname like '%PPR %'order by billdetailid DESC [ RunTime:0.020507s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and depotname='铅锌矿仓库' and goodsname like '%PPR %'order by billdetailid DESC limit 0,3000 [ RunTime:0.722657s ] --------------------------------------------------------------- [ 2024-12-10T15:34:44+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2021-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=PPR+&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%PPR %'order by billdetailid DESC [ RunTime:0.024414s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-12-10' and adddate <='2024-12-10' and goodsname like '%PPR %'order by billdetailid DESC limit 0,3000 [ RunTime:0.751953s ] --------------------------------------------------------------- [ 2024-12-10T15:35:11+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=PPR+&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.060547s ] 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.019531s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and depotname='纸浆厂仓库' and goodsname like '%PPR %'order by billdetailid DESC [ RunTime:0.017578s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and depotname='纸浆厂仓库' and goodsname like '%PPR %'order by billdetailid DESC limit 0,3000 [ RunTime:0.729492s ] --------------------------------------------------------------- [ 2024-12-10T15:35:33+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=PPR&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ 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 in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and depotname='纸浆厂仓库' and goodsname like '%PPR%'order by billdetailid DESC [ RunTime:0.043945s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and depotname='纸浆厂仓库' and goodsname like '%PPR%'order by billdetailid DESC limit 0,3000 [ RunTime:0.661133s ] --------------------------------------------------------------- [ 2024-12-10T15:35:39+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=PPR&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.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%PPR%'order by billdetailid DESC [ RunTime:0.034179s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%PPR%'order by billdetailid DESC limit 0,3000 [ RunTime:0.819336s ] --------------------------------------------------------------- [ 2024-12-10T15:36:02+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=PPR&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.035157s ] 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.010742s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and depotname='铅锌矿仓库' and goodsname like '%PPR%'order by billdetailid DESC [ RunTime:0.040039s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and depotname='铅锌矿仓库' and goodsname like '%PPR%'order by billdetailid DESC limit 0,3000 [ RunTime:0.688477s ] --------------------------------------------------------------- [ 2024-12-10T15:38:13+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=PE&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.085938s ] [ 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.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and depotname='铅锌矿仓库' and goodsname like '%PE%'order by billdetailid DESC [ RunTime:0.032227s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and depotname='铅锌矿仓库' and goodsname like '%PE%'order by billdetailid DESC limit 0,3000 [ RunTime:0.688477s ] --------------------------------------------------------------- [ 2024-12-10T15:46:55+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E6%B8%B8%E6%A0%87%E5%8D%A1%E5%B0%BA&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.029296s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and depotname='铅锌矿仓库' and goodsname like '%游标卡尺%'order by billdetailid DESC [ RunTime:0.020508s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and depotname='铅锌矿仓库' and goodsname like '%游标卡尺%'order by billdetailid DESC limit 0,3000 [ RunTime:0.693359s ] --------------------------------------------------------------- [ 2024-12-10T15:47:02+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B8%B8%E6%A0%87%E5%8D%A1%E5%B0%BA&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.019532s ] [ 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 in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%游标卡尺%'order by billdetailid DESC [ RunTime:0.017578s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%游标卡尺%'order by billdetailid DESC limit 0,3000 [ RunTime:0.769531s ] --------------------------------------------------------------- [ 2024-12-10T15:47:53+08:00 ] 101.78.12.185 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.030273s ] [ 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 `fieldshow` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'adjustdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2024-12-10T15:47:55+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.036133s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.057617s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-12-01' and adddate <='2024-12-10'order by billdetailid DESC [ RunTime:0.690430s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-12-01' and adddate <='2024-12-10'order by billdetailid DESC limit 0,90 [ RunTime:0.615235s ] --------------------------------------------------------------- [ 2024-12-10T15:48:10+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=G11041&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.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ 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 in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodscode='G11041'order by billdetailid DESC [ RunTime:0.007812s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodscode='G11041'order by billdetailid DESC limit 0,3000 [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-12-10T15:49:41+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E7%AE%A1%E9%92%B3&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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020507s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%管钳%'order by billdetailid DESC [ RunTime:0.026367s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%管钳%'order by billdetailid DESC limit 0,3000 [ RunTime:0.792969s ] --------------------------------------------------------------- [ 2024-12-10T15:51:17+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=G13520&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.017578s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2020-12-10' and adddate <='2024-12-10' and goodscode='G13520'order by billdetailid DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodscode='G13520'order by billdetailid DESC limit 0,3000 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-10T15:53:25+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%A7%92%E7%A3%A8%E7%89%87&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.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%角磨片%'order by billdetailid DESC [ RunTime:0.029296s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%角磨片%'order by billdetailid DESC limit 0,3000 [ RunTime:0.750000s ] --------------------------------------------------------------- [ 2024-12-10T15:54:28+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=G10716&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.057617s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.068359s ] [ 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 in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodscode='G10716'order by billdetailid DESC [ RunTime:0.011719s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodscode='G10716'order by billdetailid DESC limit 0,3000 [ RunTime:0.004883s ] --------------------------------------------------------------- [ 2024-12-10T15:55:16+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%87%AA%E5%96%B7%E6%BC%86&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.062500s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.040039s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%自喷漆%'order by billdetailid DESC [ RunTime:0.030273s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%自喷漆%'order by billdetailid DESC limit 0,3000 [ RunTime:0.773438s ] --------------------------------------------------------------- [ 2024-12-10T15:57:28+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&enddate=&depotname=&goodscode=&goodsname=%E8%87%AA%E5%96%B7%E6%BC%86&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-12-01' and adddate <='2024-12-10' and goodsname like '%自喷漆%'order by billdetailid DESC [ RunTime:0.027343s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-12-01' and adddate <='2024-12-10' and goodsname like '%自喷漆%'order by billdetailid DESC limit 0,90 [ RunTime:0.633790s ] --------------------------------------------------------------- [ 2024-12-10T15:59:40+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%89%8B%E5%8A%A8%E9%BB%84%E6%B2%B9%E6%9E%AA&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.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%手动黄油枪%'order by billdetailid DESC [ RunTime:0.021485s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%手动黄油枪%'order by billdetailid DESC limit 0,3000 [ RunTime:0.796875s ] --------------------------------------------------------------- [ 2024-12-10T16:00:39+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%A2%A8%E7%9B%92&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.026368s ] [ 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.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%墨盒%'order by billdetailid DESC [ RunTime:0.017578s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%墨盒%'order by billdetailid DESC limit 0,3000 [ RunTime:0.769532s ] --------------------------------------------------------------- [ 2024-12-10T16:00:45+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%A2%A8&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%墨%'order by billdetailid DESC [ RunTime:0.021485s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%墨%'order by billdetailid DESC limit 0,3000 [ RunTime:0.765625s ] --------------------------------------------------------------- [ 2024-12-10T16:14:33+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/bill/billshow.html?type=LY [ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.006836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'LY' LIMIT 1 [ RunTime:0.007812s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'lybill' AND `show` = 1 ORDER BY `showid` [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2024-12-10T16:14:39+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025390s ] [ 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 ] SHOW COLUMNS FROM `bill` [ RunTime:0.052734s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-10' LIMIT 1 [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '领用出库' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-10' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.066406s ] --------------------------------------------------------------- [ 2024-12-10T16:14:41+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/bill/bill_info.html?type=LY [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ 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.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'LY' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.132813s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.039062s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2024-12-10' AND `type` = '领用出库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.037110s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-12-10T16:14:51+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%87%BA%E5%BA%93&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-12-10T16:15:05+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.022461s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-10' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:14.064453s ] --------------------------------------------------------------- [ 2024-12-10T16:15:24+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodscode&value=12174&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.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%12174%' [ RunTime:0.005859s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-10' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodscode like '%12174%' limit 0,90 [ RunTime:13.349610s ] --------------------------------------------------------------- [ 2024-12-10T16:15:36+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%87%BA%E5%BA%93&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93 [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-12-10T16:15:59+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.020508s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-10' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:22.277343s ] --------------------------------------------------------------- [ 2024-12-10T16:16:04+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodscode&value=12174&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.252929s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%12174%' [ RunTime:0.200195s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-10' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodscode like '%12174%' limit 0,90 [ RunTime:20.440430s ] --------------------------------------------------------------- [ 2024-12-10T16:16:19+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodscode&value=12174&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.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.002930s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%12174%' [ RunTime:0.006836s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-10' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodscode like '%12174%' limit 0,90 [ RunTime:14.557617s ] --------------------------------------------------------------- [ 2024-12-10T16:16:51+08:00 ] 101.78.12.185 POST 103.45.248.127:8001/index/bill/save_bill.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ 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 ] SHOW COLUMNS FROM `bill` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'LY-2024-12-10-0001' LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `custname` , `operator` , `originalcode` , `note`) VALUES ('领用出库' , '出库' , '2024-12-10 16:14:41' , 'LY-2024-12-10-0001' , '2024-12-10' , '张让红' , '2024-12-10' , '纸浆厂仓库' , '纸浆厂设能部' , '丁淑英' , '' , '') [ RunTime:0.055664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.058593s ] [ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE `depotname` = '纸浆厂仓库' AND `goodscode` = 'G12174' GROUP BY `goodscode` [ RunTime:16.217773s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.036133s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G12174' , '空滤' , '2440' , '个' , 240 , 1 , 240 , '外出租装载机' , 240 , 'LY-2024-12-10-0001' , -1) [ RunTime:0.017579s ] --------------------------------------------------------------- [ 2024-12-10T16:16:54+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-10' LIMIT 1 [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '领用出库' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-10' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.068360s ] --------------------------------------------------------------- [ 2024-12-10T16:39:56+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&enddate=&depotname=&goodscode=&goodsname=%E6%B3%95%E5%85%B0%E7%9B%98&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.037109s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.029296s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-12-01' and adddate <='2024-12-10' and goodsname like '%法兰盘%'order by billdetailid DESC [ RunTime:0.039062s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-12-01' and adddate <='2024-12-10' and goodsname like '%法兰盘%'order by billdetailid DESC limit 0,90 [ RunTime:0.634766s ] --------------------------------------------------------------- [ 2024-12-10T16:40:04+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/qtreport/adjustdetail_data.html?startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=&enddate=&depotname=&goodscode=&goodsname=%E6%B3%95%E5%85%B0&goodscategory= [ 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.030274s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-12-01' and adddate <='2024-12-10' and goodsname like '%法兰%'order by billdetailid DESC [ RunTime:0.026367s ] [ sql ] [ SQL ] select * from s_billdetail where type ='库存盘点' and adddate >='2024-12-01' and adddate <='2024-12-10' and goodsname like '%法兰%'order by billdetailid DESC limit 0,90 [ RunTime:0.600586s ] --------------------------------------------------------------- [ 2024-12-10T16:40:29+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B3%95%E5%85%B0%E7%9B%98&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%法兰盘%'order by billdetailid DESC [ RunTime:0.028320s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%法兰盘%'order by billdetailid DESC limit 0,3000 [ RunTime:0.823242s ] --------------------------------------------------------------- [ 2024-12-10T16:50:45+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B2%B9%E9%94%AF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.023438s ] 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.032227s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.011719s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%油锯%'order by billdetailid DESC [ RunTime:0.036133s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%油锯%'order by billdetailid DESC limit 0,3000 [ RunTime:0.852539s ] --------------------------------------------------------------- [ 2024-12-10T16:52:01+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%8F%91%E7%83%AD%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.033203s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.009765s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%发热管%'order by billdetailid DESC [ RunTime:0.018554s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%发热管%'order by billdetailid DESC limit 0,3000 [ RunTime:0.844727s ] --------------------------------------------------------------- [ 2024-12-10T16:52:45+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%89%8B%E6%8A%8A%E9%94%AF&goodscategory= [ 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.026368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%手把锯%'order by billdetailid DESC [ RunTime:0.025391s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%手把锯%'order by billdetailid DESC limit 0,3000 [ RunTime:0.775390s ] --------------------------------------------------------------- [ 2024-12-10T16:53:13+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%92%A2%E9%94%AF%E7%89%87&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.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.009765s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%钢锯片%'order by billdetailid DESC [ RunTime:0.023437s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%钢锯片%'order by billdetailid DESC limit 0,3000 [ RunTime:0.801758s ] --------------------------------------------------------------- [ 2024-12-10T16:53:53+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=G15912&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.035157s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.065429s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and goodscode='G15912'order by billdetailid DESC [ RunTime:0.005859s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodscode='G15912'order by billdetailid DESC limit 0,3000 [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2024-12-10T16:54:02+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=G15911&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.018554s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.055664s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.066406s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and goodscode='G15911'order by billdetailid DESC [ RunTime:0.006836s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodscode='G15911'order by billdetailid DESC limit 0,3000 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-10T16:54:50+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.043945s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ 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 in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%轴承%'order by billdetailid DESC [ RunTime:0.083008s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%轴承%'order by billdetailid DESC limit 0,3000 [ RunTime:0.857422s ] --------------------------------------------------------------- [ 2024-12-10T17:00:05+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=G11030&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.029297s ] 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.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ 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 in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodscode='G11030'order by billdetailid DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodscode='G11030'order by billdetailid DESC limit 0,3000 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-10T17:00:31+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.017578s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.057617s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.034179s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.009766s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%轴承%'order by billdetailid DESC [ RunTime:0.059570s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%轴承%'order by billdetailid DESC limit 0,3000 [ RunTime:0.785157s ] --------------------------------------------------------------- [ 2024-12-10T17:00:48+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&custname=&goodscode=&goodsname=%E8%BD%B4%E6%89%BF&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.042969s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2020-12-10' and adddate <='2024-12-10' and depotname='嘎西仓储' and goodsname like '%轴承%'order by billdetailid DESC [ RunTime:0.048829s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and depotname='嘎西仓储' and goodsname like '%轴承%'order by billdetailid DESC limit 0,3000 [ RunTime:0.704102s ] --------------------------------------------------------------- [ 2024-12-10T17:02:01+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%BD%B4%E6%89%BF&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.059570s ] [ 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.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%轴承%'order by billdetailid DESC [ RunTime:0.053711s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%轴承%'order by billdetailid DESC limit 0,3000 [ RunTime:0.793946s ] --------------------------------------------------------------- [ 2024-12-10T17:05:42+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%93%BE%E6%9D%A1&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.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.013672s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%链条%'order by billdetailid DESC [ RunTime:0.028320s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%链条%'order by billdetailid DESC limit 0,3000 [ RunTime:0.779296s ] --------------------------------------------------------------- [ 2024-12-10T17:06:54+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E7%94%B5%E7%84%8A%E7%9C%BC%E9%95%9C&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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%电焊眼镜%'order by billdetailid DESC [ RunTime:0.024414s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%电焊眼镜%'order by billdetailid DESC limit 0,3000 [ RunTime:0.832031s ] --------------------------------------------------------------- [ 2024-12-10T17:07:44+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B2%B9%E6%BC%86%E5%88%B7&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.039062s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%油漆刷%'order by billdetailid DESC [ RunTime:0.032227s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%油漆刷%'order by billdetailid DESC limit 0,3000 [ RunTime:0.763672s ] --------------------------------------------------------------- [ 2024-12-10T17:08:22+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%85%89%E6%B8%85&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.031250s ] 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.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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%光清%'order by billdetailid DESC [ RunTime:0.021485s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%光清%'order by billdetailid DESC limit 0,3000 [ RunTime:0.758789s ] --------------------------------------------------------------- [ 2024-12-10T17:08:40+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E7%BD%91%E7%BA%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.026367s ] 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.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.121094s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.011719s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%网线%'order by billdetailid DESC [ RunTime:0.020508s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%网线%'order by billdetailid DESC limit 0,3000 [ RunTime:0.797851s ] --------------------------------------------------------------- [ 2024-12-10T17:09:02+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E7%94%B5%E5%88%A8&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.031250s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ 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 in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%电刨%'order by billdetailid DESC [ RunTime:0.016601s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%电刨%'order by billdetailid DESC limit 0,3000 [ RunTime:0.798828s ] --------------------------------------------------------------- [ 2024-12-10T17:09:29+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%88%87%E5%89%B2%E6%9C%BA&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%切割机%'order by billdetailid DESC [ RunTime:0.032226s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%切割机%'order by billdetailid DESC limit 0,3000 [ RunTime:0.807617s ] --------------------------------------------------------------- [ 2024-12-10T17:09:47+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%A7%92%E7%A3%A8%E6%9C%BA&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.031250s ] 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.025390s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%角磨机%'order by billdetailid DESC [ RunTime:0.035156s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%角磨机%'order by billdetailid DESC limit 0,3000 [ RunTime:0.828125s ] --------------------------------------------------------------- [ 2024-12-10T17:10:16+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%86%B2%E5%87%BB%E9%92%BB&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.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.011719s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025390s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%冲击钻%'order by billdetailid DESC [ RunTime:0.027344s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%冲击钻%'order by billdetailid DESC limit 0,3000 [ RunTime:0.775391s ] --------------------------------------------------------------- [ 2024-12-10T17:11:04+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%89%8B%E6%8B%89%E8%91%AB%E8%8A%A6&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.048828s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.034180s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%手拉葫芦%'order by billdetailid DESC [ RunTime:0.023438s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%手拉葫芦%'order by billdetailid DESC limit 0,3000 [ RunTime:0.789063s ] --------------------------------------------------------------- [ 2024-12-10T17:11:29+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%8C%85%E7%BA%BF&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.012695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000000s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%包线%'order by billdetailid DESC [ RunTime:0.025390s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%包线%'order by billdetailid DESC limit 0,3000 [ RunTime:0.804687s ] --------------------------------------------------------------- [ 2024-12-10T17:12:28+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.034180s ] 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.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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%轴承%'order by billdetailid DESC [ RunTime:0.061524s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%轴承%'order by billdetailid DESC limit 0,3000 [ RunTime:0.791993s ] --------------------------------------------------------------- [ 2024-12-10T17:14:28+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E4%B8%8D%E9%94%88%E9%92%A2&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.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ 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 in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%不锈钢%'order by billdetailid DESC [ RunTime:0.033203s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%不锈钢%'order by billdetailid DESC limit 0,3000 [ RunTime:0.804688s ] --------------------------------------------------------------- [ 2024-12-10T17:18:46+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E7%94%B5%E9%98%BB%E8%A1%A8&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.052734s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.061524s ] [ 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 >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%电阻表%'order by billdetailid DESC [ RunTime:0.023438s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%电阻表%'order by billdetailid DESC limit 0,3000 [ RunTime:0.828125s ] --------------------------------------------------------------- [ 2024-12-10T17:19:23+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%88%B9%E8%BD%A6&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.010742s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%刹车%'order by billdetailid DESC [ RunTime:0.049805s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2020-12-10' and adddate <='2024-12-10' and goodsname like '%刹车%'order by billdetailid DESC limit 0,3000 [ RunTime:0.739258s ]