--------------------------------------------------------------- [ 2024-09-20T12:12:05+08:00 ] 114.129.30.149 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.017578s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.277343s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'ZRH' AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-09-20 12:12:05',`web_session_id`='kambanqqjm6klibikdv4cbjfu7' WHERE `id` = 15 [ RunTime:0.005859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.029297s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '114.129.30.149') [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2024-09-20T12:12:06+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/home [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-09-20T12:12:08+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/index/content.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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2024-09-01' AND '2024-09-20' LIMIT 1 [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-09-01' AND '2024-09-20' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.003906s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-09-14' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-09-15' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-09-16' LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-09-17' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-09-18' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-09-19' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-09-20' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-09-14' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-09-15' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-09-16' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-09-17' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-09-18' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-09-19' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-09-20' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-09-14' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-09-15' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-09-16' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-09-17' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-09-18' LIMIT 1 [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-09-19' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-09-20' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-09-14' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-09-15' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-09-16' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-09-17' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-09-18' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-09-19' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-09-20' LIMIT 1 [ RunTime:0.019531s ] --------------------------------------------------------------- [ 2024-09-20T12:12:19+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ 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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'billdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-09-20T12:12:21+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.016601s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-09-01' AND '2024-09-20' LIMIT 1 [ RunTime:0.468750s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-09-01' AND '2024-09-20' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.006836s ] --------------------------------------------------------------- [ 2024-09-20T12:13:01+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E4%BF%AE%E7%90%86%E5%8C%85&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.036132s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%修理包%' LIMIT 1 [ RunTime:0.041992s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%修理包%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.039062s ] --------------------------------------------------------------- [ 2024-09-20T12:15:15+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%B3%A8%E6%B2%B9%E5%99%A8%E6%9D%AF&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%注油器杯%' LIMIT 1 [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%注油器杯%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.012695s ] --------------------------------------------------------------- [ 2024-09-20T12:15:20+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%B3%A8%E6%B2%B9%E6%9D%AF&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.018555s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%注油杯%' LIMIT 1 [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%注油杯%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.014649s ] --------------------------------------------------------------- [ 2024-09-20T12:15:28+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%9D%AF&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.018555s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.039062s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%杯%' LIMIT 1 [ RunTime:0.012696s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%杯%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T12:19:23+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%94%81%E7%B4%A7%E8%9E%BA%E6%AF%8D&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.008789s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.052735s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%锁紧螺母%' LIMIT 1 [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%锁紧螺母%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.014649s ] --------------------------------------------------------------- [ 2024-09-20T12:20:15+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%B0%94%E8%85%BF%E6%94%AF%E6%9E%B6&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.010743s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.045898s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%气腿支架%' LIMIT 1 [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%气腿支架%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T12:20:24+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%B0%94%E8%85%BF&detailnote= [ 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.030274s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%气腿%' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%气腿%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.019531s ] --------------------------------------------------------------- [ 2024-09-20T12:26:30+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E5%86%85%E6%A3%98%E8%BD%AE&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.009765s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%内棘轮%' LIMIT 1 [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%内棘轮%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.014649s ] --------------------------------------------------------------- [ 2024-09-20T12:26:35+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%A3%98%E8%BD%AE&detailnote= [ 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.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%棘轮%' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%棘轮%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.023437s ] --------------------------------------------------------------- [ 2024-09-20T12:27:58+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E8%8A%B1%E9%94%AE%E8%9E%BA%E6%97%8B%E6%AF%8D&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.020508s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%花键螺旋母%' LIMIT 1 [ RunTime:0.011719s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%花键螺旋母%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T12:28:07+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E8%9E%BA%E6%97%8B%E6%AF%8D&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.038086s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%螺旋母%' LIMIT 1 [ RunTime:0.051758s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%螺旋母%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.036132s ] --------------------------------------------------------------- [ 2024-09-20T12:30:50+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E7%94%B5%E7%84%8A%E6%89%8B%E6%8A%8A&detailnote= [ 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.037109s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%电焊手把%' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%电焊手把%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T12:31:06+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E7%94%B5%E7%84%8A&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.008789s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.022460s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%电焊%' LIMIT 1 [ RunTime:0.080078s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%电焊%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.079101s ] --------------------------------------------------------------- [ 2024-09-20T12:32:25+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%89%8B%E6%8A%8A&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.009766s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.034180s ] [ 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.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.034179s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%手把%' LIMIT 1 [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%手把%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.014649s ] --------------------------------------------------------------- [ 2024-09-20T12:32:38+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%89%8B%E6%8A%8A&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%手把%' LIMIT 1 [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%手把%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.017578s ] --------------------------------------------------------------- [ 2024-09-20T12:32:55+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%8A%8A%E6%89%8B&detailnote= [ 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.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%把手%' LIMIT 1 [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%把手%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.014649s ] --------------------------------------------------------------- [ 2024-09-20T13:15:38+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%A5%BC&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.008789s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.044922s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%饼%' LIMIT 1 [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%饼%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2024-09-20T13:28:21+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%93%9D%E7%BA%BF%E7%AE%A1&detailnote= [ 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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%铝线管%' LIMIT 1 [ RunTime:0.011719s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%铝线管%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.019531s ] --------------------------------------------------------------- [ 2024-09-20T13:30:30+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%93%9D%E7%9B%B4&detailnote= [ 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.032226s ] [ 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 ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%铝直%' LIMIT 1 [ RunTime:0.011718s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%铝直%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2024-09-20T13:31:46+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%93%9D&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.007813s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%铝%' LIMIT 1 [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%铝%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.044922s ] --------------------------------------------------------------- [ 2024-09-20T13:32:37+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%93%9D%E6%8E%A5&detailnote= [ 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.035156s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%铝接%' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%铝接%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.024414s ] --------------------------------------------------------------- [ 2024-09-20T13:32:53+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%93%9D%E6%8E%A5&detailnote= [ 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.034180s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%铝接%' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%铝接%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.022461s ] --------------------------------------------------------------- [ 2024-09-20T13:35:11+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E7%A9%BA%E5%BC%80&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.016601s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%空开%' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%空开%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.029297s ] --------------------------------------------------------------- [ 2024-09-20T13:47:13+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%94%BE%E7%82%AE%E5%99%A8&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.007813s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.036133s ] [ 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 ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%放炮器%' LIMIT 1 [ RunTime:0.011719s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%放炮器%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T13:47:18+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%94%BE%E7%82%AE&detailnote= [ 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.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%放炮%' LIMIT 1 [ RunTime:0.039062s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%放炮%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.028320s ] --------------------------------------------------------------- [ 2024-09-20T13:47:27+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E5%8F%91%E7%82%AE&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%发炮%' LIMIT 1 [ RunTime:0.008789s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%发炮%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.012695s ] --------------------------------------------------------------- [ 2024-09-20T13:47:37+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E7%82%AE%E5%99%A8&detailnote= [ 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.033204s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%炮器%' LIMIT 1 [ RunTime:0.011718s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%炮器%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T13:50:17+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E5%8F%8C%E5%A4%B4%E4%B8%9D&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.016601s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.036133s ] [ 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.010742s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%双头丝%' LIMIT 1 [ RunTime:0.011719s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%双头丝%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2024-09-20T13:52:08+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%95%80%E9%94%8C%E5%8F%98%E6%8E%A5&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.020508s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.046875s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%镀锌变接%' LIMIT 1 [ RunTime:0.011719s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%镀锌变接%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T13:52:55+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E5%8F%98%E6%8E%A5&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%变接%' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%变接%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T13:53:09+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E5%8F%98%E6%8E%A5&detailnote= [ 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.036133s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024415s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%变接%' LIMIT 1 [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%变接%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.016602s ] --------------------------------------------------------------- [ 2024-09-20T14:20:23+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E4%BC%A0%E9%80%81%E5%B8%A6%E6%9E%B6%E5%AD%90&detailnote= [ 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.034179s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%传送带架子%' LIMIT 1 [ RunTime:0.011718s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%传送带架子%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2024-09-20T14:20:32+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E4%BC%A0%E9%80%81%E5%B8%A6&detailnote= [ 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.026368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.014649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%传送带%' LIMIT 1 [ RunTime:0.009766s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%传送带%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.014649s ] --------------------------------------------------------------- [ 2024-09-20T14:20:42+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E6%9E%B6%E5%AD%90&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%架子%' LIMIT 1 [ RunTime:0.009765s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%架子%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T14:44:40+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%92%A2%E7%BB%B3%E5%8D%A1&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%钢绳卡%' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%钢绳卡%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.018555s ] --------------------------------------------------------------- [ 2024-09-20T14:53:33+08:00 ] 114.129.30.149 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.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.034179s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'custom' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-09-20T14:53:34+08:00 ] 114.129.30.149 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.011718s ] 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.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE `type` LIKE '%供应商%' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT * FROM `custom` WHERE `type` LIKE '%供应商%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-09-20T14:53:47+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2015-01-01&enddate=2022-12-31&depotname=&custname=&goodscode=%E6%A7%BD%E9%92%A2&goodsname=%E9%9B%B7%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.018554s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2015-01-01' and adddate <='2022-12-31' and goodscode='槽钢' and goodsname like '%雷管%'order by billdetailid 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 >='2015-01-01' and adddate <='2022-12-31' and goodscode='槽钢' and goodsname like '%雷管%'order by billdetailid DESC limit 0,90 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-09-20T14:53:58+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2015-01-01&enddate=2022-12-31&depotname=&custname=&goodscode=&goodsname=%E6%A7%BD%E9%92%A2&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.016601s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030274s ] [ 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.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2015-01-01' and adddate <='2022-12-31' and goodsname like '%槽钢%'order by billdetailid DESC [ RunTime:0.039062s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2015-01-01' and adddate <='2022-12-31' and goodsname like '%槽钢%'order by billdetailid DESC limit 0,90 [ RunTime:0.020507s ] --------------------------------------------------------------- [ 2024-09-20T15:04:09+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E8%86%A8%E8%83%80&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%膨胀%' LIMIT 1 [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%膨胀%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.020508s ] --------------------------------------------------------------- [ 2024-09-20T15:10:38+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E9%92%A2%E7%BB%B3%E5%8D%A1&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%钢绳卡%' LIMIT 1 [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodsname` LIKE '%钢绳卡%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.016602s ] --------------------------------------------------------------- [ 2024-09-20T15:18:28+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2015-01-01&enddate=2022-12-31&depotname=&custname=&goodscode=&goodsname=%E6%BD%9C%E6%B0%B4%E6%B3%B5&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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2015-01-01' and adddate <='2022-12-31' 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 >='2015-01-01' and adddate <='2022-12-31' and goodsname like '%潜水泵%'order by billdetailid DESC limit 0,90 [ RunTime:0.012695s ] --------------------------------------------------------------- [ 2024-09-20T15:18:41+08:00 ] 114.129.30.149 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.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'custom' AND `show` = 1 ORDER BY `showid` [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2024-09-20T15:18:42+08:00 ] 114.129.30.149 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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ 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 `custom` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE `type` LIKE '%供应商%' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT * FROM `custom` WHERE `type` LIKE '%供应商%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-09-20T15:18:53+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2015-01-01&enddate=2024-12-31&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E6%BD%9C%E6%B0%B4%E6%B3%B5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ 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.005859s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2015-01-01' and adddate <='2024-12-31' and custname='万象金弓机电' 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 >='2015-01-01' and adddate <='2024-12-31' and custname='万象金弓机电' and goodsname like '%潜水泵%'order by billdetailid DESC limit 0,90 [ RunTime:0.012696s ] --------------------------------------------------------------- [ 2024-09-20T15:19:05+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2015-01-01&enddate=2024-12-31&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E6%B0%B4%E6%B3%B5&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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2015-01-01' and adddate <='2024-12-31' and custname='万象金弓机电' 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 >='2015-01-01' and adddate <='2024-12-31' and custname='万象金弓机电' and goodsname like '%水泵%'order by billdetailid DESC limit 0,90 [ RunTime:0.020508s ] --------------------------------------------------------------- [ 2024-09-20T15:19:36+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=G14280&goodsname=%E9%92%A2%E7%BB%B3%E5%8D%A1&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G14280%' AND `goodsname` LIKE '%钢绳卡%' LIMIT 1 [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G14280%' AND `goodsname` LIKE '%钢绳卡%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2024-09-20T15:19:40+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=G14280&goodsname=%E9%92%A2%E7%BB%B3%E5%8D%A1&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.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.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G14280%' AND `goodsname` LIKE '%钢绳卡%' LIMIT 1 [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G14280%' AND `goodsname` LIKE '%钢绳卡%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.014649s ] --------------------------------------------------------------- [ 2024-09-20T15:20:19+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=G14280&goodsname=%E9%92%A2%E7%BB%B3%E5%8D%A1&detailnote= [ 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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G14280%' AND `goodsname` LIKE '%钢绳卡%' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G14280%' AND `goodsname` LIKE '%钢绳卡%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.018554s ] --------------------------------------------------------------- [ 2024-09-20T15:20:27+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=G11194&goodsname=%E9%92%A2%E7%BB%B3%E5%8D%A1&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.035157s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G11194%' AND `goodsname` LIKE '%钢绳卡%' LIMIT 1 [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G11194%' AND `goodsname` LIKE '%钢绳卡%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.016601s ] --------------------------------------------------------------- [ 2024-09-20T15:20:31+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=G11194&goodsname=%E9%92%A2%E7%BB%B3%E5%8D%A1&detailnote= [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G11194%' AND `goodsname` LIKE '%钢绳卡%' LIMIT 1 [ RunTime:0.009766s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G11194%' AND `goodsname` LIKE '%钢绳卡%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T15:20:49+08:00 ] 114.129.30.149 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.033204s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.003907s ] --------------------------------------------------------------- [ 2024-09-20T15:20:51+08:00 ] 114.129.30.149 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.020508s ] 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.025390s ] [ 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 >='2024-09-01' and adddate <='2024-09-20'order by billdetailid DESC [ RunTime:0.609375s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-09-01' and adddate <='2024-09-20'order by billdetailid DESC limit 0,90 [ RunTime:0.621094s ] --------------------------------------------------------------- [ 2024-09-20T15:21:04+08:00 ] 114.129.30.149 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.013672s ] 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.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'custom' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-09-20T15:21:05+08:00 ] 114.129.30.149 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.021484s ] [ 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.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.020508s ] [ 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-09-20T15:21:25+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=G14280&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodscode='G14280'order by billdetailid DESC [ RunTime:0.003907s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodscode='G14280'order by billdetailid DESC limit 0,90 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-09-20T15:21:50+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=20&startdate=2019-01-01&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=G14280&goodsname=%E9%92%A2%E7%BB%B3%E5%8D%A1&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G14280%' AND `goodsname` LIKE '%钢绳卡%' LIMIT 1 [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-09-20' AND `goodscode` LIKE '%G14280%' AND `goodsname` LIKE '%钢绳卡%' ORDER BY `billdetailid` DESC LIMIT 0,20 [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2024-09-20T15:22:09+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=G11194&goodsname=&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodscode='G11194'order by billdetailid DESC [ RunTime:0.005860s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodscode='G11194'order by billdetailid DESC limit 0,90 [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2024-09-20T15:22:55+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/qtreport/transfersum_data.html?page=1&limit=90&startdate=2022-12-19&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=G11194&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2022-12-19' and adddate <='2024-09-20' and depotname='铅锌矿仓库' and depotname1='铜矿仓库' and goodscode='G11194' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.006836s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2022-12-19' and adddate <='2024-09-20' and depotname='铅锌矿仓库' and depotname1='铜矿仓库' and goodscode='G11194' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2024-09-20T15:23:00+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/qtreport/transfersum_data.html?page=1&limit=90&startdate=2022-12-19&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=G11194&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.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2022-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='铜矿仓库' and goodscode='G11194' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.003906s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2022-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='铜矿仓库' and goodscode='G11194' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-09-20T15:23:07+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/qtreport/transfersum_data.html?page=1&limit=90&startdate=2019-12-19&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&goodscode=G11194&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.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.008789s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='铜矿仓库' and goodscode='G11194' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.005859s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='铜矿仓库' and goodscode='G11194' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-09-20T15:23:13+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/qtreport/transfersum_data.html?page=1&limit=90&startdate=2019-12-19&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&goodscode=G11194&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='嘎西仓储' and goodscode='G11194' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.003906s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='嘎西仓储' and goodscode='G11194' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-09-20T15:23:25+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/qtreport/transfersum_data.html?page=1&limit=90&startdate=2019-12-19&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&goodscode=&goodsname=%E6%B0%B4%E6%B3%B5&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.034180s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='嘎西仓储' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='嘎西仓储' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.012696s ] --------------------------------------------------------------- [ 2024-09-20T15:23:36+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/qtreport/transfersum_data.html?page=1&limit=90&startdate=2019-12-19&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E6%B0%B4%E6%B3%B5&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.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='纸浆厂仓库' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='纸浆厂仓库' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2024-09-20T15:23:40+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E5%8F%91%E7%94%B5%E6%9C%BA&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' 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 >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%发电机%'order by billdetailid DESC limit 0,90 [ RunTime:0.021485s ] --------------------------------------------------------------- [ 2024-09-20T15:23:47+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/qtreport/transfersum_data.html?page=1&limit=90&startdate=2019-12-19&enddate=&depotname=%E5%98%8E%E8%A5%BF%E8%B4%A7%E5%9C%BA&depotname1=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E6%B0%B4%E6%B3%B5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西货场' and depotname1='纸浆厂仓库' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西货场' and depotname1='纸浆厂仓库' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T15:24:06+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/qtreport/transfersum_data.html?page=1&limit=90&startdate=2019-12-19&enddate=&depotname=%E5%98%8E%E8%A5%BF%E4%BB%93%E5%82%A8&depotname1=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E6%B0%B4%E6%B3%B5&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.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='纸浆厂仓库' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='嘎西仓储' and depotname1='纸浆厂仓库' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.022461s ] --------------------------------------------------------------- [ 2024-09-20T15:24:08+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=20&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E5%8F%91%E7%94%B5%E6%9C%BA&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' 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 >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%发电机%'order by billdetailid DESC limit 0,20 [ RunTime:0.018555s ] --------------------------------------------------------------- [ 2024-09-20T15:24:12+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/qtreport/transfersum_data.html?page=1&limit=90&startdate=2019-12-19&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E6%B0%B4%E6%B3%B5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='铅锌矿仓库' and depotname1='纸浆厂仓库' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='铅锌矿仓库' and depotname1='纸浆厂仓库' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.018555s ] --------------------------------------------------------------- [ 2024-09-20T15:24:16+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/qtreport/transfersum_data.html?page=1&limit=90&startdate=2019-12-19&enddate=&depotname=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&goodscode=&goodsname=%E6%B0%B4%E6%B3%B5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.022461s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026368s ] [ 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 a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='铜矿仓库' and depotname1='纸浆厂仓库' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT a.*, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money FROM goods a right JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '调出仓库' and adddate >='2019-12-19' and adddate <='2024-09-20' and depotname='铜矿仓库' and depotname1='纸浆厂仓库' and goodsname like '%水泵%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.012695s ] --------------------------------------------------------------- [ 2024-09-20T15:25:44+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=20&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E5%B8%98%E5%AD%90%E7%BA%BF%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' 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 >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%帘子线管%'order by billdetailid DESC limit 0,20 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T15:27:58+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=20&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=DZ47sLE%E7%A9%BA%E5%BC%80%EF%BC%88%E5%B8%A6%E6%BC%8F%E7%94%B5%EF%BC%89&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%DZ47sLE空开（带漏电）%'order by billdetailid DESC [ RunTime:0.024414s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%DZ47sLE空开（带漏电）%'order by billdetailid DESC limit 0,20 [ RunTime:0.018554s ] --------------------------------------------------------------- [ 2024-09-20T15:28:22+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=20&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=DZ47sLE%E7%A9%BA%E5%BC%80&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.034180s ] [ 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.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%DZ47sLE空开%'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 >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%DZ47sLE空开%'order by billdetailid DESC limit 0,20 [ RunTime:0.021484s ] --------------------------------------------------------------- [ 2024-09-20T15:28:54+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=20&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E7%A9%BA%E5%BC%80&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.024414s ] 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.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.007813s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' 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 >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%空开%'order by billdetailid DESC limit 0,20 [ RunTime:0.018554s ] --------------------------------------------------------------- [ 2024-09-20T15:29:38+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=50&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E7%A9%BA%E5%BC%80&goodscategory= [ 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.043945s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' 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 >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%空开%'order by billdetailid DESC limit 0,50 [ RunTime:0.019532s ] --------------------------------------------------------------- [ 2024-09-20T15:30:37+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2015-01-01&enddate=2024-12-31&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E7%A9%BA%E5%BC%80&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.036132s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2015-01-01' and adddate <='2024-12-31' and custname='万象金弓机电' 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 >='2015-01-01' and adddate <='2024-12-31' and custname='万象金弓机电' and goodsname like '%空开%'order by billdetailid DESC limit 0,90 [ RunTime:0.017578s ] --------------------------------------------------------------- [ 2024-09-20T15:31:33+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=50&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E6%94%B9%E5%90%91%E8%BE%8A%E7%AD%92&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.039063s ] [ 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 >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' 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 >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%改向辊筒%'order by billdetailid DESC limit 0,50 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T15:32:40+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=50&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E9%93%9C%E6%8E%A5%E7%BA%BF%E7%AB%AF%E5%AD%90&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' 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 >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%铜接线端子%'order by billdetailid DESC limit 0,50 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-09-20T15:37:15+08:00 ] 114.129.30.149 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=50&startdate=2021-01-01&enddate=&depotname=&custname=%E4%B8%87%E8%B1%A1%E9%87%91%E5%BC%93%E6%9C%BA%E7%94%B5&goodscode=&goodsname=%E9%93%9C%E9%BC%BB%E5%AD%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.043945s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%铜鼻子%'order by billdetailid DESC [ RunTime:0.024414s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-01-01' and adddate <='2024-09-20' and custname='万象金弓机电' and goodsname like '%铜鼻子%'order by billdetailid DESC limit 0,50 [ RunTime:0.017578s ]