--------------------------------------------------------------- [ 2024-12-22T15:07:47+08:00 ] 114.129.30.136 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.016602s ] 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` = 'HDQ' AND `password` = 'MDAwMDAwMDAwMIaKea-xiX6u' LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '铅锌矿库管' AND `status` = 1 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-12-22 15:07:47',`web_session_id`='jsleicnmiuoito0a52vrallnm2' WHERE `id` = 22 [ RunTime:0.017578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.014648s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'HDQ' , '杨金富' , '114.129.30.136') [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-12-22T15:07:49+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/home [ 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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-12-22T15:07:50+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.038086s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-12-01' AND '2024-12-22' LIMIT 1 [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-12-01' AND '2024-12-22' LIMIT 1 [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.003907s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-16' LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.040039s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-16' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-16' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-16' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.020507s ] --------------------------------------------------------------- [ 2024-12-22T15:14:21+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ 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.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.056640s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.016602s ] [ 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.015625s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-12-22T15:14:24+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?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.016601s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-12-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.517578s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-12-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.569336s ] --------------------------------------------------------------- [ 2024-12-22T15:14:42+08:00 ] 114.129.30.136 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=G12522&goodsname=&detailnote= [ 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.021484s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12522%' LIMIT 1 [ RunTime:0.072266s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12522%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.140625s ] --------------------------------------------------------------- [ 2024-12-22T15:16:48+08:00 ] 114.129.30.136 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=G12687&goodsname=&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.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12687%' LIMIT 1 [ RunTime:0.080079s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12687%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.125977s ] --------------------------------------------------------------- [ 2024-12-22T15:17:26+08:00 ] 114.129.30.136 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=G12889&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.062500s ] 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.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12889%' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12889%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.123047s ] --------------------------------------------------------------- [ 2024-12-22T15:26:51+08:00 ] 114.129.30.136 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=G12890&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.048828s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12890%' LIMIT 1 [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12890%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.120117s ] --------------------------------------------------------------- [ 2024-12-22T15:27:02+08:00 ] 114.129.30.136 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=G12145&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.020508s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12145%' LIMIT 1 [ RunTime:0.078125s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12145%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.125977s ] --------------------------------------------------------------- [ 2024-12-22T15:28:34+08:00 ] 114.129.30.136 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=G17230&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.042969s ] 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.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17230%' LIMIT 1 [ RunTime:0.074218s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17230%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.118164s ] --------------------------------------------------------------- [ 2024-12-22T15:30:04+08:00 ] 114.129.30.136 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=G11074&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.044921s ] 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.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G11074%' LIMIT 1 [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G11074%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.115234s ] --------------------------------------------------------------- [ 2024-12-22T15:31:27+08:00 ] 114.129.30.136 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=G12890&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.044921s ] 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12890%' LIMIT 1 [ RunTime:0.117188s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12890%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.122070s ] --------------------------------------------------------------- [ 2024-12-22T15:33:28+08:00 ] 114.129.30.136 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=G12147&goodsname=&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.024414s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12147%' LIMIT 1 [ RunTime:0.080078s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12147%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.118164s ] --------------------------------------------------------------- [ 2024-12-22T15:34:14+08:00 ] 114.129.30.136 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=G12146&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.025391s ] 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.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12146%' LIMIT 1 [ RunTime:0.083008s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12146%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.125977s ] --------------------------------------------------------------- [ 2024-12-22T15:34:23+08:00 ] 114.129.30.136 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=G12146&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.007812s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12146%' LIMIT 1 [ RunTime:0.067383s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12146%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.122071s ] --------------------------------------------------------------- [ 2024-12-22T16:28:30+08:00 ] 114.129.30.136 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=G12148&goodsname=&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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12148%' LIMIT 1 [ RunTime:0.083007s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12148%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.123047s ] --------------------------------------------------------------- [ 2024-12-22T16:28:37+08:00 ] 114.129.30.136 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=G12148&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.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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12148%' LIMIT 1 [ RunTime:0.077149s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12148%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.116211s ] --------------------------------------------------------------- [ 2024-12-22T16:28:59+08:00 ] 114.129.30.136 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.076172s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'HDQ' AND `password` = 'MDAwMDAwMDAwMIaKea-xiX6u' LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '铅锌矿库管' AND `status` = 1 LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-12-22 16:28:59',`web_session_id`='qo4301kdos2m3denm81nmebib4' WHERE `id` = 22 [ RunTime:0.006836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.016602s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'HDQ' , '杨金富' , '114.129.30.136') [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-12-22T16:29:01+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/home [ 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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-12-22T16:29:03+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-12-01' AND '2024-12-22' LIMIT 1 [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-12-01' AND '2024-12-22' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.015625s ] [ 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.021484s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.013671s ] [ 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-12-16' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-16' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-16' LIMIT 1 [ RunTime:0.029296s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.036133s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-16' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.020508s ] --------------------------------------------------------------- [ 2024-12-22T16:29:23+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-12-22T16:29:23+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/home [ 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.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-12-22T16:29:25+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-12-01' AND '2024-12-22' LIMIT 1 [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `adddate` BETWEEN '2024-12-01' AND '2024-12-22' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.017578s ] [ 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.021484s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.017578s ] [ 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-12-16' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-16' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-16' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-16' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-17' LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-18' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-19' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-20' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-21' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-22' LIMIT 1 [ RunTime:0.021484s ] --------------------------------------------------------------- [ 2024-12-22T16:29:32+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/index/dataquery/bill_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.045899s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'billdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `configuration` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-12-22T16:29:35+08:00 ] 114.129.30.136 GET 103.45.248.127:8001/index/dataquery/billdetail_data.html?page=1&limit=90 [ 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.018555s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 '2024-12-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.477539s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-12-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.605469s ] --------------------------------------------------------------- [ 2024-12-22T16:29:40+08:00 ] 114.129.30.136 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=G12148&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.020508s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 '2024-12-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12148%' LIMIT 1 [ RunTime:0.070313s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-12-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12148%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.137696s ] --------------------------------------------------------------- [ 2024-12-22T16:30:49+08:00 ] 114.129.30.136 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=G12888&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.026367s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 '2024-12-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12888%' LIMIT 1 [ RunTime:0.085938s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-12-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12888%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.115235s ] --------------------------------------------------------------- [ 2024-12-22T16:31:01+08:00 ] 114.129.30.136 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=G12779&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.021484s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-12-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12779%' LIMIT 1 [ RunTime:0.106445s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2024-12-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12779%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.133790s ] --------------------------------------------------------------- [ 2024-12-22T16:31:18+08:00 ] 114.129.30.136 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=G12779&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.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12779%' LIMIT 1 [ RunTime:0.083008s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12779%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.160156s ] --------------------------------------------------------------- [ 2024-12-22T16:31:42+08:00 ] 114.129.30.136 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=G12148&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.023438s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12148%' LIMIT 1 [ RunTime:0.082031s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12148%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.141601s ] --------------------------------------------------------------- [ 2024-12-22T16:32:00+08:00 ] 114.129.30.136 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=G12888&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.033204s ] 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.020507s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12888%' LIMIT 1 [ RunTime:0.082031s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12888%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.130860s ] --------------------------------------------------------------- [ 2024-12-22T16:32:28+08:00 ] 114.129.30.136 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=G12522&goodsname=&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.027344s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12522%' LIMIT 1 [ RunTime:0.089843s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12522%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.130860s ] --------------------------------------------------------------- [ 2024-12-22T16:33:54+08:00 ] 114.129.30.136 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=G12689&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.039062s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12689%' LIMIT 1 [ RunTime:0.078125s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12689%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.124023s ] --------------------------------------------------------------- [ 2024-12-22T16:35:36+08:00 ] 114.129.30.136 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=G10843&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.024415s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G10843%' LIMIT 1 [ RunTime:0.083984s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G10843%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.122070s ] --------------------------------------------------------------- [ 2024-12-22T16:36:20+08:00 ] 114.129.30.136 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=G12779&goodsname=&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.036133s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12779%' LIMIT 1 [ RunTime:0.085938s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12779%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.116211s ] --------------------------------------------------------------- [ 2024-12-22T16:38:42+08:00 ] 114.129.30.136 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=G14471&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.031250s ] 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G14471%' LIMIT 1 [ RunTime:0.081055s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G14471%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.143554s ] --------------------------------------------------------------- [ 2024-12-22T16:39:28+08:00 ] 114.129.30.136 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=G15825&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.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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G15825%' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G15825%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.129883s ] --------------------------------------------------------------- [ 2024-12-22T16:39:54+08:00 ] 114.129.30.136 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=G12133&goodsname=&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.038086s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12133%' LIMIT 1 [ RunTime:0.103516s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12133%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.126953s ] --------------------------------------------------------------- [ 2024-12-22T16:40:27+08:00 ] 114.129.30.136 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=G14720&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.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G14720%' LIMIT 1 [ RunTime:0.085938s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G14720%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.121094s ] --------------------------------------------------------------- [ 2024-12-22T16:41:54+08:00 ] 114.129.30.136 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=G12096&goodsname=&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.020508s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12096%' LIMIT 1 [ RunTime:0.083008s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12096%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.133789s ] --------------------------------------------------------------- [ 2024-12-22T16:42:31+08:00 ] 114.129.30.136 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=G16855&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.045898s ] 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.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16855%' LIMIT 1 [ RunTime:0.083984s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16855%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.122070s ] --------------------------------------------------------------- [ 2024-12-22T16:43:11+08:00 ] 114.129.30.136 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=G14450&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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G14450%' LIMIT 1 [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G14450%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.124023s ] --------------------------------------------------------------- [ 2024-12-22T16:44:15+08:00 ] 114.129.30.136 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=G10090&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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G10090%' LIMIT 1 [ RunTime:0.111328s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G10090%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.119141s ] --------------------------------------------------------------- [ 2024-12-22T16:44:59+08:00 ] 114.129.30.136 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=G16217&goodsname=&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.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16217%' LIMIT 1 [ RunTime:0.087890s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16217%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.142578s ] --------------------------------------------------------------- [ 2024-12-22T16:46:28+08:00 ] 114.129.30.136 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=G16888&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.039063s ] 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.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16888%' LIMIT 1 [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16888%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.116211s ] --------------------------------------------------------------- [ 2024-12-22T16:47:16+08:00 ] 114.129.30.136 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=G10134&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.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G10134%' LIMIT 1 [ RunTime:0.077148s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G10134%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.134766s ] --------------------------------------------------------------- [ 2024-12-22T16:48:13+08:00 ] 114.129.30.136 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=G12925&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.025391s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12925%' LIMIT 1 [ RunTime:0.100586s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12925%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.124024s ] --------------------------------------------------------------- [ 2024-12-22T16:48:47+08:00 ] 114.129.30.136 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=G12096&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.028320s ] 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.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12096%' LIMIT 1 [ RunTime:0.081055s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12096%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.137695s ] --------------------------------------------------------------- [ 2024-12-22T16:49:13+08:00 ] 114.129.30.136 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=G15864&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.060547s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G15864%' LIMIT 1 [ RunTime:0.080078s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G15864%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.119141s ] --------------------------------------------------------------- [ 2024-12-22T16:49:57+08:00 ] 114.129.30.136 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=G16265&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.019532s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16265%' LIMIT 1 [ RunTime:0.081054s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16265%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.117187s ] --------------------------------------------------------------- [ 2024-12-22T16:50:38+08:00 ] 114.129.30.136 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=G12133&goodsname=&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.038086s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12133%' LIMIT 1 [ RunTime:0.083985s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12133%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.122070s ] --------------------------------------------------------------- [ 2024-12-22T16:51:27+08:00 ] 114.129.30.136 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=G12945&goodsname=&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.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12945%' LIMIT 1 [ RunTime:0.099610s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12945%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.122071s ] --------------------------------------------------------------- [ 2024-12-22T16:52:12+08:00 ] 114.129.30.136 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=G17883&goodsname=&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.026367s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17883%' LIMIT 1 [ RunTime:0.083984s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17883%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.116211s ] --------------------------------------------------------------- [ 2024-12-22T16:52:41+08:00 ] 114.129.30.136 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=G16869&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.030274s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.003906s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16869%' LIMIT 1 [ RunTime:0.080078s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16869%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.120117s ] --------------------------------------------------------------- [ 2024-12-22T16:53:25+08:00 ] 114.129.30.136 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=G16890&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.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16890%' LIMIT 1 [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16890%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.137696s ] --------------------------------------------------------------- [ 2024-12-22T16:54:37+08:00 ] 114.129.30.136 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=G17340&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.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17340%' LIMIT 1 [ RunTime:0.087890s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17340%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.125977s ] --------------------------------------------------------------- [ 2024-12-22T16:55:03+08:00 ] 114.129.30.136 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=G12137&goodsname=&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.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12137%' LIMIT 1 [ RunTime:0.080078s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12137%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.120117s ] --------------------------------------------------------------- [ 2024-12-22T16:56:24+08:00 ] 114.129.30.136 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=G12974&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.074219s ] 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12974%' LIMIT 1 [ RunTime:0.082032s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12974%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.136719s ] --------------------------------------------------------------- [ 2024-12-22T17:01:34+08:00 ] 114.129.30.136 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=G15943&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.028320s ] 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.025391s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G15943%' LIMIT 1 [ RunTime:0.083985s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G15943%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.123047s ] --------------------------------------------------------------- [ 2024-12-22T17:06:04+08:00 ] 114.129.30.136 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=G15166&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.027344s ] 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.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G15166%' LIMIT 1 [ RunTime:0.094727s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G15166%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.134766s ] --------------------------------------------------------------- [ 2024-12-22T17:08:59+08:00 ] 114.129.30.136 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=G11076&goodsname=&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.036133s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G11076%' LIMIT 1 [ RunTime:0.083984s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G11076%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.117187s ] --------------------------------------------------------------- [ 2024-12-22T17:10:49+08:00 ] 114.129.30.136 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=G16140&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.043945s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16140%' LIMIT 1 [ RunTime:0.099610s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16140%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.126953s ] --------------------------------------------------------------- [ 2024-12-22T17:12:34+08:00 ] 114.129.30.136 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=G17767&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.060547s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17767%' LIMIT 1 [ RunTime:0.085937s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17767%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.118164s ] --------------------------------------------------------------- [ 2024-12-22T17:13:33+08:00 ] 114.129.30.136 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=G10024&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.052734s ] 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.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G10024%' LIMIT 1 [ RunTime:0.079102s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G10024%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.125000s ] --------------------------------------------------------------- [ 2024-12-22T17:14:34+08:00 ] 114.129.30.136 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=G16736&goodsname=&detailnote= [ 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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16736%' LIMIT 1 [ RunTime:0.081055s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16736%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.124024s ] --------------------------------------------------------------- [ 2024-12-22T17:15:29+08:00 ] 114.129.30.136 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=G16347&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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16347%' LIMIT 1 [ RunTime:0.080078s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G16347%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.115234s ] --------------------------------------------------------------- [ 2024-12-22T17:16:25+08:00 ] 114.129.30.136 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=G15216&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.034179s ] 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.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G15216%' LIMIT 1 [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G15216%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.131836s ] --------------------------------------------------------------- [ 2024-12-22T17:17:20+08:00 ] 114.129.30.136 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=G14725&goodsname=&detailnote= [ 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.028320s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G14725%' LIMIT 1 [ RunTime:0.086914s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G14725%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.122070s ] --------------------------------------------------------------- [ 2024-12-22T17:19:17+08:00 ] 114.129.30.136 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=G17913&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.123047s ] 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.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_billdetail` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17913%' LIMIT 1 [ RunTime:0.081055s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17913%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.124023s ] --------------------------------------------------------------- [ 2024-12-22T17:20:33+08:00 ] 114.129.30.136 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=G17673&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.068360s ] 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.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17673%' LIMIT 1 [ RunTime:0.079102s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17673%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.120117s ] --------------------------------------------------------------- [ 2024-12-22T17:30:36+08:00 ] 114.129.30.136 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=G17673&goodsname=&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.025391s ] [ 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` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ 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-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17673%' LIMIT 1 [ RunTime:0.095703s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G17673%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.124023s ] --------------------------------------------------------------- [ 2024-12-22T17:30:44+08:00 ] 114.129.30.136 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=G12952&goodsname=&detailnote= [ sql ] [ DB ] CONNECT:[ UseTime:0.034179s ] 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.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') 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 '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12952%' LIMIT 1 [ RunTime:0.090821s ] [ sql ] [ SQL ] SELECT * FROM `s_billdetail` WHERE `adddate` BETWEEN '2019-01-01' AND '2024-12-22' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') AND `goodscode` LIKE '%G12952%' ORDER BY `billdetailid` DESC LIMIT 0,90 [ RunTime:0.132813s ]