--------------------------------------------------------------- [ 2024-11-18T13:05:03+08:00 ] 202.62.102.42 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.023438s ] [ 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.016602s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-11-18 13:05:03',`web_session_id`='d6jh08u9e7rcirtr6f31ib1834' WHERE `id` = 15 [ RunTime:0.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.016601s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '202.62.102.42') [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-11-18T13:05:05+08:00 ] 202.62.102.42 GET 103.45.248.127:8001/home [ 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.018554s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-11-18T13:05:09+08:00 ] 202.62.102.42 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.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2024-11-01' AND '2024-11-18' LIMIT 1 [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-11-01' AND '2024-11-18' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.004883s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.001953s ] [ 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-11-12' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-13' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-14' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-15' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-16' LIMIT 1 [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-17' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-18' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-12' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-13' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-14' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-15' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-16' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-17' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-18' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-12' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-13' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-14' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-15' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-16' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-17' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-18' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-12' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-13' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-14' LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-15' LIMIT 1 [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-16' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-17' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-18' LIMIT 1 [ RunTime:0.021484s ] --------------------------------------------------------------- [ 2024-11-18T13:05:47+08:00 ] 202.62.102.42 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ 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.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'billdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-11-18T13:05:53+08:00 ] 202.62.102.42 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90 [ 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.018554s ] [ 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 ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-11-01' AND '2024-11-18' LIMIT 1 [ RunTime:0.501953s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-11-01' AND '2024-11-18' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.609375s ] --------------------------------------------------------------- [ 2024-11-18T13:06:15+08:00 ] 202.62.102.42 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=18084&goodsname=&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.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-11-01' AND '2024-11-18' AND `goodscode` LIKE '%18084%' LIMIT 1 [ RunTime:0.100586s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-11-01' AND '2024-11-18' AND `goodscode` LIKE '%18084%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.124024s ] --------------------------------------------------------------- [ 2024-11-18T13:06:33+08:00 ] 202.62.102.42 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=18084&goodsname=&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.021484s ] [ 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.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18084%' LIMIT 1 [ RunTime:0.082031s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18084%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.125000s ] --------------------------------------------------------------- [ 2024-11-18T13:07:16+08:00 ] 202.62.102.42 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%B8%8B%E6%B0%B4%E7%AE%A1&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.037109s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.005860s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ 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 '2019-01-01' AND '2024-11-18' AND `goodsname` LIKE '%下水管%' LIMIT 1 [ RunTime:0.012695s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodsname` LIKE '%下水管%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:1.163086s ] --------------------------------------------------------------- [ 2024-11-18T13:08:09+08:00 ] 202.62.102.42 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=18084&goodsname=&detailnote= [ 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.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.005860s ] [ 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-11-18' AND `goodscode` LIKE '%18084%' LIMIT 1 [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18084%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.120118s ] --------------------------------------------------------------- [ 2024-11-18T13:08:30+08:00 ] 202.62.102.42 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=18083&goodsname=&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.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.036133s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18083%' LIMIT 1 [ RunTime:0.081055s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18083%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.125000s ] --------------------------------------------------------------- [ 2024-11-18T13:08:50+08:00 ] 202.62.102.42 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=18067&goodsname=&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.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.010742s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18067%' LIMIT 1 [ RunTime:0.080078s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18067%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.130860s ] --------------------------------------------------------------- [ 2024-11-18T13:09:06+08:00 ] 202.62.102.42 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=18087&goodsname=&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ 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 `s_billdetail` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18087%' LIMIT 1 [ RunTime:0.100586s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18087%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.118164s ] --------------------------------------------------------------- [ 2024-11-18T13:09:22+08:00 ] 202.62.102.42 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=18089&goodsname=&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.023438s ] [ 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.023437s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18089%' LIMIT 1 [ RunTime:0.078125s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18089%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.122070s ] --------------------------------------------------------------- [ 2024-11-18T13:09:44+08:00 ] 202.62.102.42 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=18090&goodsname=&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.030274s ] [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18090%' LIMIT 1 [ RunTime:0.075195s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18090%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.113281s ] --------------------------------------------------------------- [ 2024-11-18T13:09:58+08:00 ] 202.62.102.42 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=18091&goodsname=&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.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022460s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18091%' LIMIT 1 [ RunTime:0.076172s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18091%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.111329s ] --------------------------------------------------------------- [ 2024-11-18T13:10:15+08:00 ] 202.62.102.42 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=13945&goodsname=&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.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] 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-11-18' AND `goodscode` LIKE '%13945%' LIMIT 1 [ RunTime:0.085937s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%13945%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.122070s ] --------------------------------------------------------------- [ 2024-11-18T13:10:40+08:00 ] 202.62.102.42 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=12072&goodsname=&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.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ 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-11-18' AND `goodscode` LIKE '%12072%' LIMIT 1 [ RunTime:0.079102s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%12072%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.125000s ] --------------------------------------------------------------- [ 2024-11-18T13:10:50+08:00 ] 202.62.102.42 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&billcode=LY-2022-11-18-0039 [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'LY-2022-11-18-0039' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billname` = '领用出库' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'LY-2022-11-18-0039' [ RunTime:0.139648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2024-11-18T13:11:45+08:00 ] 202.62.102.42 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%88%B9%E8%BD%A6%E7%AE%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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.005859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodsname` LIKE '%刹车管%' LIMIT 1 [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodsname` LIKE '%刹车管%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:1.112304s ] --------------------------------------------------------------- [ 2024-11-18T13:17:29+08:00 ] 202.62.102.42 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=18093&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.029297s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ 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.022461s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18093%' LIMIT 1 [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18093%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.123046s ] --------------------------------------------------------------- [ 2024-11-18T13:17:53+08:00 ] 202.62.102.42 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=18088&goodsname=&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.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.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-11-18' AND `goodscode` LIKE '%18088%' LIMIT 1 [ RunTime:0.077149s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18088%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.112305s ] --------------------------------------------------------------- [ 2024-11-18T13:18:29+08:00 ] 202.62.102.42 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=10650&goodsname=&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.025390s ] [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%10650%' LIMIT 1 [ RunTime:0.079101s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%10650%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.116211s ] --------------------------------------------------------------- [ 2024-11-18T13:18:43+08:00 ] 202.62.102.42 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=14639&goodsname=&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.021484s ] [ 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.001954s ] [ 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-11-18' AND `goodscode` LIKE '%14639%' LIMIT 1 [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%14639%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.120117s ] --------------------------------------------------------------- [ 2024-11-18T13:19:11+08:00 ] 202.62.102.42 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=18206&goodsname=&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.026368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-11-18' AND `goodscode` LIKE '%18206%' LIMIT 1 [ RunTime:0.078125s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18206%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.124024s ] --------------------------------------------------------------- [ 2024-11-18T13:20:16+08:00 ] 202.62.102.42 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=18205&goodsname=&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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ 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-11-18' AND `goodscode` LIKE '%18205%' LIMIT 1 [ RunTime:0.083984s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18205%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.111328s ] --------------------------------------------------------------- [ 2024-11-18T13:20:24+08:00 ] 202.62.102.42 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=18205&goodsname=&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.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-11-18' AND `goodscode` LIKE '%18205%' LIMIT 1 [ RunTime:0.069336s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18205%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.113282s ] --------------------------------------------------------------- [ 2024-11-18T13:20:35+08:00 ] 202.62.102.42 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=14638&goodsname=&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.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.005860s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%14638%' LIMIT 1 [ RunTime:0.071289s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%14638%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.123047s ] --------------------------------------------------------------- [ 2024-11-18T13:21:01+08:00 ] 202.62.102.42 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=18204&goodsname=&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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18204%' LIMIT 1 [ RunTime:0.076172s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18204%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.117187s ] --------------------------------------------------------------- [ 2024-11-18T13:22:06+08:00 ] 202.62.102.42 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%A4%A7%E6%B3%B5%E7%8E%89%E6%9F%B4&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.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodsname` LIKE '%大泵玉柴%' LIMIT 1 [ RunTime:0.010742s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodsname` LIKE '%大泵玉柴%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:1.129883s ] --------------------------------------------------------------- [ 2024-11-18T13:22:18+08:00 ] 202.62.102.42 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%A4%A7%E6%B3%B5%E7%8E%89%E6%9F%B4&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.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 `s_billdetail` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodsname` LIKE '%大泵玉柴%' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodsname` LIKE '%大泵玉柴%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:1.138672s ] --------------------------------------------------------------- [ 2024-11-18T13:22:55+08:00 ] 202.62.102.42 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%A4%A7%E6%B3%B5&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.009765s ] 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.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ 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-11-18' AND `goodsname` LIKE '%大泵%' LIMIT 1 [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodsname` LIKE '%大泵%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:1.156250s ] --------------------------------------------------------------- [ 2024-11-18T13:26:12+08:00 ] 202.62.102.42 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=18225&goodsname=&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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] 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-11-18' AND `goodscode` LIKE '%18225%' LIMIT 1 [ RunTime:0.078125s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18225%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.125000s ] --------------------------------------------------------------- [ 2024-11-18T13:26:47+08:00 ] 202.62.102.42 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=15125&goodsname=&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.035157s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] 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-11-18' AND `goodscode` LIKE '%15125%' LIMIT 1 [ RunTime:0.079101s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%15125%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.122070s ] --------------------------------------------------------------- [ 2024-11-18T13:27:15+08:00 ] 202.62.102.42 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=13078&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.023437s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ] [ 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.019532s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%13078%' LIMIT 1 [ RunTime:0.086914s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%13078%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.118164s ] --------------------------------------------------------------- [ 2024-11-18T13:27:41+08:00 ] 202.62.102.42 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=18160&goodsname=&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.026367s ] [ 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.020507s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18160%' LIMIT 1 [ RunTime:0.085938s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18160%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.118164s ] --------------------------------------------------------------- [ 2024-11-18T13:28:05+08:00 ] 202.62.102.42 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=12294&goodsname=&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.032227s ] [ 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.025390s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%12294%' LIMIT 1 [ RunTime:0.083007s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%12294%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.112305s ] --------------------------------------------------------------- [ 2024-11-18T13:28:20+08:00 ] 202.62.102.42 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=11206&goodsname=&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.027343s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.009766s ] [ 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.019531s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%11206%' LIMIT 1 [ RunTime:0.076172s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%11206%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.119141s ] --------------------------------------------------------------- [ 2024-11-18T13:28:39+08:00 ] 202.62.102.42 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=16614&goodsname=&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.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] 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-11-18' AND `goodscode` LIKE '%16614%' LIMIT 1 [ RunTime:0.091796s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%16614%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.118164s ] --------------------------------------------------------------- [ 2024-11-18T13:29:06+08:00 ] 202.62.102.42 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=10977&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.021485s ] 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.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%10977%' LIMIT 1 [ RunTime:0.075195s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%10977%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.133789s ] --------------------------------------------------------------- [ 2024-11-18T13:29:19+08:00 ] 202.62.102.42 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=10978&goodsname=&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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.012695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ 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-11-18' AND `goodscode` LIKE '%10978%' LIMIT 1 [ RunTime:0.079101s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%10978%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.120117s ] --------------------------------------------------------------- [ 2024-11-18T13:29:43+08:00 ] 202.62.102.42 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=18086&goodsname=&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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.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-11-18' AND `goodscode` LIKE '%18086%' LIMIT 1 [ RunTime:0.088868s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-11-18' AND `goodscode` LIKE '%18086%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.110351s ]