---------------------------------------------------------------
[ 2024-04-27T14:23:51+08:00 ] 43.252.247.151 POST 103.45.248.127:8001/index/login/dologin.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.025390s ]
[ sql ] [ SQL ] SELECT * FROM `user` WHERE  `username` = 'zrh'  AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `role` WHERE  `rolename` = '超级管理员'  AND `status` = 1 LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE  `status` = 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] UPDATE `user`  SET `logintime`='2024-04-27 14:23:51',`web_session_id`='onesq7n0iba7jd7tk7to1mkh94'  WHERE  `id` = 15 [ RunTime:0.008789s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.038086s ]
[ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '43.252.247.151') [ RunTime:0.009765s ]
---------------------------------------------------------------
[ 2024-04-27T14:23:54+08:00 ] 43.252.247.151 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.017578s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
---------------------------------------------------------------
[ 2024-04-27T14:23:55+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/index/content.html
[ 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.016602s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `adddate` BETWEEN '2024-04-01' AND '2024-04-27' LIMIT 1 [ RunTime:0.036133s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `adddate` BETWEEN '2024-04-01' AND '2024-04-27' LIMIT 1 [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `checkstatus` = '未审核'  AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.021484s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.003907s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` <> '调入仓库' LIMIT 1 [ RunTime:0.020507s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-04-21' LIMIT 1 [ RunTime:0.021484s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-04-22' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-04-23' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-04-24' LIMIT 1 [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-04-25' LIMIT 1 [ RunTime:0.022461s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-04-26' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '采购入库'  AND `makedate` = '2024-04-27' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-04-21' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-04-22' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-04-23' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-04-24' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-04-25' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-04-26' LIMIT 1 [ RunTime:0.024414s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '销售提货'  AND `makedate` = '2024-04-27' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-04-21' LIMIT 1 [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-04-22' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-04-23' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-04-24' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-04-25' LIMIT 1 [ RunTime:0.018554s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-04-26' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '生产入库'  AND `makedate` = '2024-04-27' LIMIT 1 [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-04-21' LIMIT 1 [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-04-22' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-04-23' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-04-24' LIMIT 1 [ RunTime:0.020508s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-04-25' LIMIT 1 [ RunTime:0.026367s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-04-26' LIMIT 1 [ RunTime:0.021485s ]
[ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE  `type` = '领用出库'  AND `makedate` = '2024-04-27' LIMIT 1 [ RunTime:0.024414s ]
---------------------------------------------------------------
[ 2024-04-27T14:24:10+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cg_detail.html
[ 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.024414s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ]
[ 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.019531s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'cgdetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-04-27T14:24:13+08:00 ] 43.252.247.151 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.023438s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ 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-04-01' and adddate <='2024-04-27'order by billdetailid DESC [ RunTime:0.649414s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2024-04-01' and adddate <='2024-04-27'order by billdetailid DESC limit 0,90 [ RunTime:0.570312s ]
---------------------------------------------------------------
[ 2024-04-27T14:24:54+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2017-04-27&enddate=&depotname=&custname=&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2017-04-27' and adddate <='2024-04-27'order by billdetailid DESC [ RunTime:1.161133s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2017-04-27' and adddate <='2024-04-27'order by billdetailid DESC limit 0,90 [ RunTime:0.128906s ]
---------------------------------------------------------------
[ 2024-04-27T14:24:58+08:00 ] 43.252.247.151 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.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.023437s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'custom'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ]
---------------------------------------------------------------
[ 2024-04-27T14:24:59+08:00 ] 43.252.247.151 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.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE  `type` LIKE '%供应商%' LIMIT 1 [ RunTime:0.000976s ]
[ sql ] [ SQL ] SELECT * FROM `custom` WHERE  `type` LIKE '%供应商%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-04-27T14:25:13+08:00 ] 43.252.247.151 POST 103.45.248.127:8001/index/login/dologin.html
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.027344s ]
[ sql ] [ SQL ] SELECT * FROM `user` WHERE  `username` = 'ZRH'  AND `password` = 'MDAwMDAwMDAwMIaKfbGyeY5otKucdg' LIMIT 1 [ RunTime:0.001954s ]
---------------------------------------------------------------
[ 2024-04-27T14:25:31+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2017-04-27&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.041016s ]
[ 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.000976s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2017-04-27' and adddate <='2024-04-27' and custname='万象金弓机电'order by billdetailid DESC [ RunTime:0.733399s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2017-04-27' and adddate <='2024-04-27' and custname='万象金弓机电'order by billdetailid DESC limit 0,90 [ RunTime:0.100586s ]
---------------------------------------------------------------
[ 2024-04-27T14:25:42+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2017-04-27&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ]
[ 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 >='2017-04-27' and adddate <='2024-04-27' and custname='万象金弓机电'order by billdetailid DESC [ RunTime:0.737305s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2017-04-27' and adddate <='2024-04-27' and custname='万象金弓机电'order by billdetailid DESC limit 0,3000 [ RunTime:0.547851s ]
---------------------------------------------------------------
[ 2024-04-27T14:25:54+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2017-04-27&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019532s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2017-04-27' and adddate <='2024-04-27' and custname='万象金弓机电'order by billdetailid DESC [ RunTime:0.703125s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2017-04-27' and adddate <='2024-04-27' and custname='万象金弓机电'order by billdetailid DESC limit 0,3000 [ RunTime:0.472656s ]
---------------------------------------------------------------
[ 2024-04-27T14:28:18+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=2&limit=3000&startdate=2017-04-27&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=&goodscategory=
[ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ]
[ 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` 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 >='2017-04-27' and adddate <='2024-04-27' and custname='万象金弓机电'order by billdetailid DESC [ RunTime:0.741211s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2017-04-27' and adddate <='2024-04-27' and custname='万象金弓机电'order by billdetailid DESC limit 3000,3000 [ RunTime:0.670899s ]
---------------------------------------------------------------
[ 2024-04-27T14:29:04+08:00 ] 43.252.247.151 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.023437s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.018555s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'cgdetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.001953s ]
---------------------------------------------------------------
[ 2024-04-27T14:29:07+08:00 ] 43.252.247.151 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.011719s ] 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.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` 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 >='2024-04-01' and adddate <='2024-04-27'order by billdetailid DESC [ RunTime:0.589843s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2024-04-01' and adddate <='2024-04-27'order by billdetailid DESC limit 0,90 [ RunTime:0.601563s ]
---------------------------------------------------------------
[ 2024-04-27T14:29:28+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2020-04-27&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%A3%85%E8%BD%BD%E6%9C%BA&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.024414s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2020-04-27' and adddate <='2024-04-27' 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-04-27' and adddate <='2024-04-27' and goodsname like '%装载机%'order by billdetailid DESC limit 0,90 [ RunTime:0.013672s ]
---------------------------------------------------------------
[ 2024-04-27T14:30:38+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-04-27&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%A3%85%E8%BD%BD%E6%9C%BA&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.040039s ]
[ 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-04-27' and adddate <='2024-04-27' 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-04-27' and adddate <='2024-04-27' and goodsname like '%装载机%'order by billdetailid DESC limit 0,3000 [ RunTime:0.013672s ]
---------------------------------------------------------------
[ 2024-04-27T14:38:24+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods
[ 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.035156s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
---------------------------------------------------------------
[ 2024-04-27T14:38:35+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cg_detail.html
[ 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.025391s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.017579s ]
[ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE  `tablename` = 'cgdetail'  AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ]
---------------------------------------------------------------
[ 2024-04-27T14:38:38+08:00 ] 43.252.247.151 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.004882s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017579s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2024-04-01' and adddate <='2024-04-27'order by billdetailid DESC [ RunTime:0.606446s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2024-04-01' and adddate <='2024-04-27'order by billdetailid DESC limit 0,90 [ RunTime:0.576172s ]
---------------------------------------------------------------
[ 2024-04-27T14:38:52+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2020-04-27&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%8B%96%E6%8B%89%E6%9C%BA&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.029297s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.003906s ]
[ 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-04-27' and adddate <='2024-04-27' 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-04-27' and adddate <='2024-04-27' and goodsname like '%拖拉机%'order by billdetailid DESC limit 0,90 [ RunTime:0.014649s ]
---------------------------------------------------------------
[ 2024-04-27T14:39:03+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-04-27&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%8B%96%E6%8B%89%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.020508s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2020-04-27' and adddate <='2024-04-27' 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-04-27' and adddate <='2024-04-27' and goodsname like '%拖拉机%'order by billdetailid DESC limit 0,3000 [ RunTime:0.014649s ]
---------------------------------------------------------------
[ 2024-04-27T14:40:11+08:00 ] 43.252.247.151 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2020-04-27&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%96%B0%E5%A4%A9%E5%8A%9B&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.035156s ]
[ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ]
[ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ]
[ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货')  and adddate >='2020-04-27' and adddate <='2024-04-27' 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-04-27' and adddate <='2024-04-27' and goodsname like '%新天力%'order by billdetailid DESC limit 0,3000 [ RunTime:0.012696s ]