---------------------------------------------------------------
[ 2024-12-11T14:48:14+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%8B%89%E6%9D%86&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.007812s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.273437s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.082032s ]
[ 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-11' 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-11' and goodsname like '%拉杆%'order by billdetailid DESC limit 0,3000 [ RunTime:0.932618s ]
---------------------------------------------------------------
[ 2024-12-11T14:49: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=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B2%B9%E9%94%AF&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.340820s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.318359s ]
[ 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-11' and goodsname like '%油锯%'order by billdetailid DESC [ RunTime:0.034180s ]
[ 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-11' and goodsname like '%油锯%'order by billdetailid DESC limit 0,3000 [ RunTime:0.882813s ]
---------------------------------------------------------------
[ 2024-12-11T14:50: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%90%B9%E7%81%B0&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.070313s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.170898s ]
[ 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-11' and goodsname like '%吹灰%'order by billdetailid DESC [ RunTime:0.022461s ]
[ 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-11' and goodsname like '%吹灰%'order by billdetailid DESC limit 0,3000 [ RunTime:0.868164s ]
---------------------------------------------------------------
[ 2024-12-11T14:50: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=&goodsname=%E5%90%B9%E5%B0%98&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.007812s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.070313s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.095703s ]
[ 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-11' and goodsname like '%吹尘%'order by billdetailid DESC [ RunTime:0.022461s ]
[ 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-11' and goodsname like '%吹尘%'order by billdetailid DESC limit 0,3000 [ RunTime:0.869140s ]
---------------------------------------------------------------
[ 2024-12-11T14:50:57+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%90%B9&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.166992s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.147461s ]
[ 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-11' and goodsname like '%吹%'order by billdetailid DESC [ RunTime:0.016602s ]
[ 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-11' and goodsname like '%吹%'order by billdetailid DESC limit 0,3000 [ RunTime:0.873047s ]
---------------------------------------------------------------
[ 2024-12-11T14:51:24+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods
[ sql ] [ DB ] CONNECT:[ UseTime:0.020507s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.877930s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.507812s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-12-11T14:51:25+08:00 ] 101.78.12.185 POST 103.45.248.127:8001/index/goodscategory/getdata.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.031250s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.216797s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.292969s ]
[ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.002929s ]
---------------------------------------------------------------
[ 2024-12-11T14:52:37+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=&goodscategory=%E9%80%89%E5%8E%82%E8%AE%BE%E5%A4%87%E9%85%8D%E4%BB%B6
[ sql ] [ DB ] CONNECT:[ UseTime:0.019532s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.508789s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.374024s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.042969s ]
[ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE  `name` = '选厂设备配件' [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE  `code` LIKE 'code1/1639132585/1639132651%' [ 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-11' and goodscategory in ("选厂设备配件")order by billdetailid DESC [ RunTime:0.090820s ]
[ 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-11' and goodscategory in ("选厂设备配件")order by billdetailid DESC limit 0,3000 [ RunTime:0.816406s ]
---------------------------------------------------------------
[ 2024-12-11T14:59:49+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%BC%86&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.335938s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.414062s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.002930s ]
[ 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-11' and goodsname like '%电缆%'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-11' and goodsname like '%电缆%'order by billdetailid DESC limit 0,3000 [ RunTime:0.857422s ]
---------------------------------------------------------------
[ 2024-12-11T15:00:37+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods
[ 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.430664s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.528321s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-12-11T15:00:38+08:00 ] 101.78.12.185 POST 103.45.248.127:8001/index/goodscategory/getdata.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.437500s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.186523s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.078125s ]
[ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-12-11T15:00: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=&goodscategory=%E9%80%89%E5%8E%82%E8%AE%BE%E5%A4%87%E9%85%8D%E4%BB%B6
[ sql ] [ DB ] CONNECT:[ UseTime:0.038086s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.438476s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.123047s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.136719s ]
[ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE  `name` = '选厂设备配件' [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE  `code` LIKE 'code1/1639132585/1639132651%' [ 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-11' and goodscategory in ("选厂设备配件")order by billdetailid DESC [ RunTime:0.081055s ]
[ 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-11' and goodscategory in ("选厂设备配件")order by billdetailid DESC limit 0,3000 [ RunTime:0.842774s ]
---------------------------------------------------------------
[ 2024-12-11T15:01: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=&custname=&goodscode=&goodsname=%E6%B2%B9%E4%BD%8D%E8%AE%A1&goodscategory=%E9%80%89%E5%8E%82%E8%AE%BE%E5%A4%87%E9%85%8D%E4%BB%B6
[ 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.060547s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.054687s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.076171s ]
[ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE  `name` = '选厂设备配件' [ RunTime:0.000977s ]
[ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE  `code` LIKE 'code1/1639132585/1639132651%' [ 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-11' and goodsname like '%油位计%' and goodscategory in ("选厂设备配件")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-11' and goodsname like '%油位计%' and goodscategory in ("选厂设备配件")order by billdetailid DESC limit 0,3000 [ RunTime:0.864258s ]
---------------------------------------------------------------
[ 2024-12-11T15:02:14+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%B6%B2%E4%BD%8D%E8%AE%A1&goodscategory=%E9%80%89%E5%8E%82%E8%AE%BE%E5%A4%87%E9%85%8D%E4%BB%B6
[ 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.341797s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.224609s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.046875s ]
[ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE  `name` = '选厂设备配件' [ RunTime:0.001954s ]
[ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE  `code` LIKE 'code1/1639132585/1639132651%' [ 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-11' and goodsname like '%液位计%' and goodscategory in ("选厂设备配件")order by billdetailid DESC [ RunTime:0.016602s ]
[ 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-11' and goodsname like '%液位计%' and goodscategory in ("选厂设备配件")order by billdetailid DESC limit 0,3000 [ RunTime:0.855469s ]
---------------------------------------------------------------
[ 2024-12-11T15:02: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=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B3%A8%E6%B2%B9%E6%9D%AF&goodscategory=%E9%80%89%E5%8E%82%E8%AE%BE%E5%A4%87%E9%85%8D%E4%BB%B6
[ 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.090821s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.004883s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE  `name` = '选厂设备配件' [ RunTime:0.002930s ]
[ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE  `code` LIKE 'code1/1639132585/1639132651%' [ 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-11' and goodsname like '%注油杯%' and goodscategory in ("选厂设备配件")order by billdetailid DESC [ RunTime:0.027343s ]
[ 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-11' and goodsname like '%注油杯%' and goodscategory in ("选厂设备配件")order by billdetailid DESC limit 0,3000 [ RunTime:0.906250s ]
---------------------------------------------------------------
[ 2024-12-11T15:02:38+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%9D%AF&goodscategory=%E9%80%89%E5%8E%82%E8%AE%BE%E5%A4%87%E9%85%8D%E4%BB%B6
[ 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.024414s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE  `name` = '选厂设备配件' [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE  `code` LIKE 'code1/1639132585/1639132651%' [ 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-11' and goodsname like '%杯%' and goodscategory in ("选厂设备配件")order by billdetailid DESC [ RunTime:0.016602s ]
[ 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-11' and goodsname like '%杯%' and goodscategory in ("选厂设备配件")order by billdetailid DESC limit 0,3000 [ RunTime:0.907226s ]
---------------------------------------------------------------
[ 2024-12-11T15:03:24+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=&goodscategory=%E9%80%89%E5%8E%82%E8%AE%BE%E5%A4%87%E9%85%8D%E4%BB%B6
[ 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.064453s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.076172s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.024414s ]
[ sql ] [ SQL ] SELECT `code` FROM `goodscategory` WHERE  `name` = '选厂设备配件' [ RunTime:0.003906s ]
[ sql ] [ SQL ] SELECT `name` FROM `goodscategory` WHERE  `code` LIKE 'code1/1639132585/1639132651%' [ 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-11' and goodscategory in ("选厂设备配件")order by billdetailid DESC [ RunTime:0.077149s ]
[ 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-11' and goodscategory in ("选厂设备配件")order by billdetailid DESC limit 0,3000 [ RunTime:0.876953s ]
---------------------------------------------------------------
[ 2024-12-11T15:10:35+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%91%A9%E6%89%98%E8%BD%A6%E9%92%A2%E5%9C%88&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.048828s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.138671s ]
[ 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-11' and goodsname like '%摩托车钢圈%'order by billdetailid DESC [ RunTime:0.021484s ]
[ 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-11' and goodsname like '%摩托车钢圈%'order by billdetailid DESC limit 0,3000 [ RunTime:0.816407s ]
---------------------------------------------------------------
[ 2024-12-11T15:11: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=&custname=&goodscode=&goodsname=%E6%B5%8B%E7%94%B5%E7%AC%94&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.344726s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.581055s ]
[ 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-11' and goodsname like '%测电笔%'order by billdetailid DESC [ RunTime:0.022460s ]
[ 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-11' and goodsname like '%测电笔%'order by billdetailid DESC limit 0,3000 [ RunTime:0.896485s ]
---------------------------------------------------------------
[ 2024-12-11T15:11: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=%E7%AC%94&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.295899s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.034179s ]
[ 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-11' 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-11' and goodsname like '%笔%'order by billdetailid DESC limit 0,3000 [ RunTime:0.867187s ]
---------------------------------------------------------------
[ 2024-12-11T15:13: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=&custname=&goodscode=&goodsname=%E4%B8%8D%E9%94%88%E9%92%A2%E7%9B%86&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.228516s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.038086s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.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-11' and goodsname like '%不锈钢盆%'order by billdetailid DESC [ RunTime:0.022461s ]
[ 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-11' and goodsname like '%不锈钢盆%'order by billdetailid DESC limit 0,3000 [ RunTime:0.862304s ]
---------------------------------------------------------------
[ 2024-12-11T15:14:38+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%99%B6%E7%93%B7%E7%9B%98&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.599610s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.616211s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` 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-11' and goodsname like '%陶瓷盘%'order by billdetailid DESC [ RunTime:0.021484s ]
[ 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-11' and goodsname like '%陶瓷盘%'order by billdetailid DESC limit 0,3000 [ RunTime:0.883789s ]
---------------------------------------------------------------
[ 2024-12-11T15:14: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=%E9%99%B6%E7%93%B7&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.059571s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.065430s ]
[ 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-11' and goodsname like '%陶瓷%'order by billdetailid 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 >='2020-12-10' and adddate <='2024-12-11' and goodsname like '%陶瓷%'order by billdetailid DESC limit 0,3000 [ RunTime:0.864258s ]
---------------------------------------------------------------
[ 2024-12-11T15:15:06+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%8F%9C%E7%9B%98&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.364258s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.093750s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.002930s ]
[ 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-11' 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-11' and goodsname like '%菜盘%'order by billdetailid DESC limit 0,3000 [ RunTime:0.938477s ]
---------------------------------------------------------------
[ 2024-12-11T15:15: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=&custname=&goodscode=&goodsname=%E7%9B%98&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.547851s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.467773s ]
[ 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-11' and goodsname like '%盘%'order by billdetailid DESC [ RunTime:0.034180s ]
[ 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-11' and goodsname like '%盘%'order by billdetailid DESC limit 0,3000 [ RunTime:0.791015s ]
---------------------------------------------------------------
[ 2024-12-11T15:16: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=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E7%A2%97&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.179688s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.182618s ]
[ 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-11' and goodsname like '%碗%'order by billdetailid DESC [ RunTime:0.036132s ]
[ 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-11' and goodsname like '%碗%'order by billdetailid DESC limit 0,3000 [ RunTime:0.854492s ]
---------------------------------------------------------------
[ 2024-12-11T15:17: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%BF%AB%E9%A4%90&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.490234s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.371094s ]
[ 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-11' 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-11' and goodsname like '%快餐%'order by billdetailid DESC limit 0,3000 [ RunTime:0.854492s ]
---------------------------------------------------------------
[ 2024-12-11T15:17: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=%E9%A4%90&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.019531s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.078125s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.083984s ]
[ 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-11' and goodsname like '%餐%'order by billdetailid DESC [ RunTime:0.070313s ]
[ 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-11' and goodsname like '%餐%'order by billdetailid DESC limit 0,3000 [ RunTime:0.823242s ]
---------------------------------------------------------------
[ 2024-12-11T15:17:56+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.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.020508s ]
[ 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 >='2020-12-10' and adddate <='2024-12-11' 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-11' and goodsname like '%不锈钢%'order by billdetailid DESC limit 0,3000 [ RunTime:0.814453s ]
---------------------------------------------------------------
[ 2024-12-11T15:21: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=%E7%9B%92&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.020507s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.385742s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.250976s ]
[ 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-11' and goodsname like '%盒%'order by billdetailid DESC [ RunTime:0.041016s ]
[ 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-11' and goodsname like '%盒%'order by billdetailid DESC limit 0,3000 [ RunTime:0.843750s ]
---------------------------------------------------------------
[ 2024-12-11T15:22: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=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%87%AA%E7%94%B1%E9%92%B3&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.160157s ]
[ 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.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-11' and goodsname like '%自由钳%'order by billdetailid DESC [ RunTime:0.019531s ]
[ 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-11' and goodsname like '%自由钳%'order by billdetailid DESC limit 0,3000 [ RunTime:0.805664s ]
---------------------------------------------------------------
[ 2024-12-11T15:25:35+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%A5%97%E7%AD%92&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.016602s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.186524s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.055664s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] select *,(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-11' and goodsname like '%套筒%'order by billdetailid DESC [ RunTime:0.028321s ]
[ 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-11' and goodsname like '%套筒%'order by billdetailid DESC limit 0,3000 [ RunTime:0.787109s ]
---------------------------------------------------------------
[ 2024-12-11T15:28: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=&custname=&goodscode=&goodsname=%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.293946s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.233399s ]
[ 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-11' and goodsname like '%螺丝%'order by billdetailid DESC [ RunTime:0.104492s ]
[ 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-11' and goodsname like '%螺丝%'order by billdetailid DESC limit 0,3000 [ RunTime:0.790039s ]
---------------------------------------------------------------
[ 2024-12-11T15:29:00+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%BC%B9%E7%B0%A7&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.063477s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.030273s ]
[ 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-11' and goodsname like '%弹簧%'order by billdetailid DESC [ RunTime:0.031250s ]
[ 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-11' and goodsname like '%弹簧%'order by billdetailid DESC limit 0,3000 [ RunTime:0.873047s ]
---------------------------------------------------------------
[ 2024-12-11T15:35: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=&custname=&goodscode=G11164&goodsname=&goodscategory=
[ 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.160156s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.160156s ]
[ 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-11' and goodscode='G11164'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-11' and goodscode='G11164'order by billdetailid DESC limit 0,3000 [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-12-11T15:37:56+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%94%AE%E7%9B%98&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.036133s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.028321s ]
[ 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-11' 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-11' and goodsname like '%键盘%'order by billdetailid DESC limit 0,3000 [ RunTime:0.864258s ]
---------------------------------------------------------------
[ 2024-12-11T15:38:12+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%94%AE%E7%9B%98&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.023437s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.041992s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.130859s ]
[ 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 >='2020-12-10' and adddate <='2024-12-11' 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-11' and goodsname like '%键盘%'order by billdetailid DESC limit 0,3000 [ RunTime:0.946290s ]
---------------------------------------------------------------
[ 2024-12-11T15:39:43+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%9E%BA%E4%B8%9D&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.057617s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.104492s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.008789s ]
[ 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-11' and goodsname like '%螺丝%'order by billdetailid DESC [ RunTime:0.069336s ]
[ 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-11' and goodsname like '%螺丝%'order by billdetailid DESC limit 0,3000 [ RunTime:0.857421s ]
---------------------------------------------------------------
[ 2024-12-11T15:41: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=&goodsname=%E5%AE%89%E5%85%A8%E5%B8%BD&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.516601s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.387695s ]
[ 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-11' 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-11' and goodsname like '%安全帽%'order by billdetailid DESC limit 0,3000 [ RunTime:0.842774s ]
---------------------------------------------------------------
[ 2024-12-11T15:42:37+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%AF%B9%E6%8E%A5&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.253906s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.276367s ]
[ 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-11' and goodsname like '%对接%'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 >='2020-12-10' and adddate <='2024-12-11' and goodsname like '%对接%'order by billdetailid DESC limit 0,3000 [ RunTime:0.794922s ]
---------------------------------------------------------------
[ 2024-12-11T15:42: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=&custname=&goodscode=&goodsname=PE&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.232422s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.192383s ]
[ 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-11' and goodsname like '%PE%'order by billdetailid DESC [ RunTime:0.031250s ]
[ 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-11' and goodsname like '%PE%'order by billdetailid DESC limit 0,3000 [ RunTime:0.823242s ]
---------------------------------------------------------------
[ 2024-12-11T15:45: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=%E7%AE%A1%E9%92%B3&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.110352s ]
[ 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.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-11' 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-11' and goodsname like '%管钳%'order by billdetailid DESC limit 0,3000 [ RunTime:0.905274s ]
---------------------------------------------------------------
[ 2024-12-11T15:45: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%86%B2%E5%8E%8B%E5%BC%AF%E5%A4%B4&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.351562s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.093750s ]
[ 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-11' 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-11' and goodsname like '%冲压弯头%'order by billdetailid DESC limit 0,3000 [ RunTime:0.829101s ]
---------------------------------------------------------------
[ 2024-12-11T15:46:14+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%92%AC%E6%A3%8D&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.403320s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.174805s ]
[ 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-11' and goodsname like '%撬棍%'order by billdetailid DESC [ RunTime:0.029297s ]
[ 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-11' and goodsname like '%撬棍%'order by billdetailid DESC limit 0,3000 [ RunTime:0.886718s ]
---------------------------------------------------------------
[ 2024-12-11T15:47:15+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%94%9A%E5%A4%B9%E5%A4%B4&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.382812s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.166016s ]
[ 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-11' 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-11' and goodsname like '%锚夹头%'order by billdetailid DESC limit 0,3000 [ RunTime:0.856446s ]
---------------------------------------------------------------
[ 2024-12-11T15:47:24+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%94%9A%E5%A4%B9%E7%89%87&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.290040s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.099610s ]
[ 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-11' 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-11' and goodsname like '%锚夹片%'order by billdetailid DESC limit 0,3000 [ RunTime:0.827148s ]
---------------------------------------------------------------
[ 2024-12-11T15:47: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=3000&startdate=2020-12-10&enddate=&depotname=&custname=&goodscode=&goodsname=%E9%94%9A%E5%A4%B9&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.351563s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.218750s ]
[ 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-11' 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 >='2020-12-10' and adddate <='2024-12-11' and goodsname like '%锚夹%'order by billdetailid DESC limit 0,3000 [ RunTime:0.877930s ]
---------------------------------------------------------------
[ 2024-12-11T15:47:37+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%94%9A&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.080078s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.008790s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.188477s ]
[ 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-11' 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-11' and goodsname like '%锚%'order by billdetailid DESC limit 0,3000 [ RunTime:0.815430s ]
---------------------------------------------------------------
[ 2024-12-11T15:47: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=%E5%A4%B9%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.386718s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.093750s ]
[ 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-11' and goodsname like '%夹片%'order by billdetailid DESC [ RunTime:0.022461s ]
[ 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-11' and goodsname like '%夹片%'order by billdetailid DESC limit 0,3000 [ RunTime:0.820313s ]
---------------------------------------------------------------
[ 2024-12-11T15:47:58+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%A4%B9&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.156250s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.045899s ]
[ 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-11' 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-11' and goodsname like '%夹%'order by billdetailid DESC limit 0,3000 [ RunTime:0.866211s ]
---------------------------------------------------------------
[ 2024-12-11T15:53: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=%E9%95%80%E9%94%8C&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.650391s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.526368s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.004882s ]
[ 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-11' and goodsname like '%镀锌%'order by billdetailid DESC [ RunTime:0.048828s ]
[ 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-11' and goodsname like '%镀锌%'order by billdetailid DESC limit 0,3000 [ RunTime:0.899414s ]
---------------------------------------------------------------
[ 2024-12-11T15:54:21+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%95%80%E9%94%8C%E8%9E%BA%E4%B8%9D&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.291016s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.180664s ]
[ 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-11' 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-11' and goodsname like '%镀锌螺丝%'order by billdetailid DESC limit 0,3000 [ RunTime:0.865235s ]
---------------------------------------------------------------
[ 2024-12-11T15:55:30+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/custom/select_custom.html?dw=%E4%BE%9B%E5%BA%94%E5%95%86
[ 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.064453s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.083007s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.054688s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'custom'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.003906s ]
---------------------------------------------------------------
[ 2024-12-11T15:55:31+08:00 ] 101.78.12.185 GET 103.45.248.127:8001/index/custom/selectcustom_data.html?dw=%E4%BE%9B%E5%BA%94%E5%95%86&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.222657s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.168946s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.074219s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE  `type` LIKE '%供应商%' LIMIT 1 [ RunTime:0.001954s ]
[ sql ] [ SQL ] SELECT * FROM `custom` WHERE  `type` LIKE '%供应商%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-12-11T15:55:43+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=%E5%98%8E%E8%A5%BF%E8%8A%B3%E8%8A%B3&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.035156s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.422851s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.144531s ]
[ 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-11' and custname='嘎西芳芳'order by billdetailid DESC [ RunTime:0.788086s ]
[ 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-11' and custname='嘎西芳芳'order by billdetailid DESC limit 0,3000 [ RunTime:0.773438s ]