--------------------------------------------------------------- [ 2024-02-18T17:55:44+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.070313s ] 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.018555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.008789s ] --------------------------------------------------------------- [ 2024-02-18T17:55:47+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.064453s ] 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.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-02-01' AND '2024-02-18' LIMIT 1 [ RunTime:0.287109s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-02-01' AND '2024-02-18' LIMIT 1 [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.016602s ] [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.011718s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-02-12' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-02-13' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-02-14' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-02-15' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-02-16' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-02-17' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-02-18' LIMIT 1 [ RunTime:0.033204s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-02-12' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-02-13' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-02-14' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-02-15' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-02-16' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-02-17' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-02-18' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-02-12' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-02-13' LIMIT 1 [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-02-14' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-02-15' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-02-16' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-02-17' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-02-18' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-02-12' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-02-13' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-02-14' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-02-15' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-02-16' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-02-17' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-02-18' LIMIT 1 [ RunTime:0.019531s ] --------------------------------------------------------------- [ 2024-02-18T17:56:09+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.056641s ] 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.017579s ] [ 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.025390s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.026367s ] --------------------------------------------------------------- [ 2024-02-18T17:56:13+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90 [ 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.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.040039s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-02-01' AND '2024-02-18' LIMIT 1 [ RunTime:1.033203s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-02-01' AND '2024-02-18' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.579101s ] --------------------------------------------------------------- [ 2024-02-18T17:56:54+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E5%A4%9A%E7%BA%A7%25&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.030273s ] 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.021484s ] [ 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 '2024-02-01' AND '2024-02-18' AND `goodsname` LIKE '%多级%%' LIMIT 1 [ RunTime:0.154297s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-02-01' AND '2024-02-18' AND `goodsname` LIKE '%多级%%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2024-02-18T17:57:04+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%E5%A4%9A%E7%BA%A7*&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.057617s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.154297s ] [ 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.019531s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-02-01' AND '2024-02-18' AND `goodsname` LIKE '%多级*%' LIMIT 1 [ RunTime:0.009766s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-02-01' AND '2024-02-18' AND `goodsname` LIKE '%多级*%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.012695s ] --------------------------------------------------------------- [ 2024-02-18T17:57:18+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/goods/goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.041992s ] 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.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'goods' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-02-18T17:57:19+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/goods/goods_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.004883s ] [ sql ] [ SQL ] SELECT * FROM `goods` ORDER BY `goodscode` DESC LIMIT 0,90 [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2024-02-18T17:57:43+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/goods/goods_data.html?page=1&limit=90&pym=&field=specification&value=11&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.064453s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.017579s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` WHERE `specification` LIKE '%11%' LIMIT 1 [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `specification` LIKE '%11%' ORDER BY `goodscode` DESC LIMIT 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2024-02-18T17:57:59+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/goods/goods_data.html?page=1&limit=90&pym=&field=specification&value=11kw&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.000977s ] [ 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 `goods` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` WHERE `specification` LIKE '%11kw%' LIMIT 1 [ RunTime:0.008789s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `specification` LIKE '%11kw%' ORDER BY `goodscode` DESC LIMIT 0,90 [ RunTime:0.038086s ] --------------------------------------------------------------- [ 2024-02-18T17:58:41+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/goods/goods_data.html?page=1&limit=20&pym=&field=specification&value=11kw&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030274s ] [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` WHERE `specification` LIKE '%11kw%' LIMIT 1 [ RunTime:0.011719s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `specification` LIKE '%11kw%' ORDER BY `goodscode` DESC LIMIT 0,20 [ RunTime:0.032227s ] --------------------------------------------------------------- [ 2024-02-18T17:58:52+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/goods/goods_info.html?action=look&id=7197 [ sql ] [ DB ] CONNECT:[ UseTime:0.055664s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 7197 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='G11194' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.010742s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.012696s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-02-18T17:59:08+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/goods/goods_data.html?page=1&limit=20&pym=&field=specification&value=11kw&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.041016s ] 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.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.041016s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` WHERE `specification` LIKE '%11kw%' LIMIT 1 [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `specification` LIKE '%11kw%' ORDER BY `goodscode` DESC LIMIT 0,20 [ RunTime:0.034180s ] --------------------------------------------------------------- [ 2024-02-18T18:00:34+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=*%E6%B3%B5&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.054688s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.037109s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-02-01' AND '2024-02-18' AND `goodsname` LIKE '%*泵%' LIMIT 1 [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-02-01' AND '2024-02-18' AND `goodsname` LIKE '%*泵%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2024-02-18T18:01:12+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2022-02-18&enddate=&billtype=&depotname=&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=*%E6%B3%B5&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.067383s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2022-02-18' AND '2024-02-18' AND `goodsname` LIKE '%*泵%' LIMIT 1 [ RunTime:0.009766s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2022-02-18' AND '2024-02-18' AND `goodsname` LIKE '%*泵%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.018554s ] --------------------------------------------------------------- [ 2024-02-18T18:01:23+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2022-02-18&enddate=&billtype=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=*%E6%B3%B5&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.040039s ] 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.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2022-02-18' AND '2024-02-18' AND `depotname` = '铅锌矿仓库' AND `goodsname` LIKE '%*泵%' LIMIT 1 [ RunTime:0.009766s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2022-02-18' AND '2024-02-18' AND `depotname` = '铅锌矿仓库' AND `goodsname` LIKE '%*泵%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.011719s ] --------------------------------------------------------------- [ 2024-02-18T18:01:35+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90&startdate=2022-02-18&enddate=&billtype=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%25%E6%B3%B5&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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025391s ] [ 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 '2022-02-18' AND '2024-02-18' AND `depotname` = '铅锌矿仓库' AND `goodsname` LIKE '%%泵%' LIMIT 1 [ RunTime:0.506836s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2022-02-18' AND '2024-02-18' AND `depotname` = '铅锌矿仓库' AND `goodsname` LIKE '%%泵%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.083008s ] --------------------------------------------------------------- [ 2024-02-18T18:01:47+08:00 ] 43.252.247.210 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=3000&startdate=2022-02-18&enddate=&billtype=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&operator=&maker=&goodscode=&goodsname=%25%E6%B3%B5&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.053711s ] 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.025390s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2022-02-18' AND '2024-02-18' AND `depotname` = '铅锌矿仓库' AND `goodsname` LIKE '%%泵%' LIMIT 1 [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2022-02-18' AND '2024-02-18' AND `depotname` = '铅锌矿仓库' AND `goodsname` LIKE '%%泵%' ORDER BY `billdetailid` DESC LIMIT 0,3000 [ RunTime:0.043945s ]