--------------------------------------------------------------- [ 2024-12-01T11:34:13+08:00 ] 202.62.106.123 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'zrh' AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2024-12-01 11:34:13',`web_session_id`='46i8v4rj2vkkaece51h1873732' WHERE `id` = 15 [ RunTime:0.006836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.019532s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '202.62.106.123') [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2024-12-01T11:34:15+08:00 ] 202.62.106.123 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.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2024-12-01T11:34:17+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-01' LIMIT 1 [ RunTime:0.045899s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-01' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.031250s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.003906s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000977s ] [ 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-11-25' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-26' LIMIT 1 [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-27' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-28' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-29' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-11-30' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2024-12-01' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-25' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-26' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-27' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-28' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-29' LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-11-30' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2024-12-01' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-25' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-26' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-27' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-28' LIMIT 1 [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-29' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-11-30' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2024-12-01' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-25' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-26' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-27' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-28' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-29' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-11-30' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2024-12-01' LIMIT 1 [ RunTime:0.021485s ] --------------------------------------------------------------- [ 2024-12-01T11:34:23+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/bill/billshow.html?type=LY [ 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.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'LY' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'lybill' AND `show` = 1 ORDER BY `showid` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-01T11:34:24+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%A2%86%E7%94%A8%E5%87%BA%E5%BA%93&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.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-01' LIMIT 1 [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '领用出库' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-01' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.061523s ] --------------------------------------------------------------- [ 2024-12-01T11:34:30+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/bill/bill_info.html?type=LY [ 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.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'LY' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.124024s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2024-12-01' AND `type` = '领用出库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.032227s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-01T11:35:26+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/bill/billshow.html?type=XS [ 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.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'XS' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'xsbill' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-12-01T11:35:28+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.023437s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.006836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-01' LIMIT 1 [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-01' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.062500s ] --------------------------------------------------------------- [ 2024-12-01T11:35:49+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS [ 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.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` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.053711s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'XS' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.140625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2024-12-01' AND `type` = '销售提货' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.038086s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-01T11:36:04+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/custom/select_custom.html?dw=%E5%AE%A2%E6%88%B7 [ 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.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'custom' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-12-01T11:36:05+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/custom/selectcustom_data.html?dw=%E5%AE%A2%E6%88%B7&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE `type` LIKE '%客户%' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT * FROM `custom` WHERE `type` LIKE '%客户%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-12-01T11:36:38+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%87%BA%E5%BA%93&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93 [ 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.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2024-12-01T11:36:53+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&page=1&limit=90 [ 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.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.016601s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-01' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:13.452149s ] --------------------------------------------------------------- [ 2024-12-01T11:37:47+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E6%B4%BB%E6%80%A7%E7%82%AD&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%活性炭%' [ RunTime:0.009766s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '纸浆厂仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2024-12-01' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%活性炭%' limit 0,90 [ RunTime:13.454102s ] --------------------------------------------------------------- [ 2024-12-01T11:38:38+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/custom/select_custom.html?dw=%E5%AE%A2%E6%88%B7 [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'custom' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2024-12-01T11:38:39+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/custom/selectcustom_data.html?dw=%E5%AE%A2%E6%88%B7&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE `type` LIKE '%客户%' LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SELECT * FROM `custom` WHERE `type` LIKE '%客户%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-01T11:38:58+08:00 ] 202.62.106.123 POST 103.45.248.127:8001/index/bill/save_bill.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'XS-2024-12-01-0001' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `custname` , `operator` , `originalcode` , `note`) VALUES ('销售提货' , '出库' , '2024-12-01 11:35:49' , 'XS-2024-12-01-0001' , '2024-12-01' , '张让红' , '2024-11-20' , '纸浆厂仓库' , '廖总' , '丁淑英' , '' , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE `depotname` = '纸浆厂仓库' AND `goodscode` = 'G17678' GROUP BY `goodscode` [ RunTime:13.821289s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.020508s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17678' , '粉末活性炭' , '25KG/袋' , '吨' , 5000 , 7 , 35000 , '' , 7489.19 , 'XS-2024-12-01-0001' , -1) [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-01T11:39:00+08:00 ] 202.62.106.123 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&page=1&limit=90 [ 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.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-01' LIMIT 1 [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-12-01' AND '2024-12-01' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.060547s ] --------------------------------------------------------------- [ 2024-12-01T11:39:44+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/lyreport/receive_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'receivedetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-01T11:39:47+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.020508s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.006836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-12-01' and adddate <='2024-12-01'order by billdetailid DESC [ RunTime:0.629882s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-12-01' and adddate <='2024-12-01'order by billdetailid DESC limit 0,90 [ RunTime:0.565430s ] --------------------------------------------------------------- [ 2024-12-01T11:40:23+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/lyreport/receivedetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2024-11-01&enddate=2024-11-30&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-11-01' and adddate <='2024-11-30' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.604492s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('领用出库','领用退库') and adddate >='2024-11-01' and adddate <='2024-11-30' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.604492s ] --------------------------------------------------------------- [ 2024-12-01T11:41:00+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/cgreport/cg_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2024-12-01T11:41:03+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.010742s ] 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.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-12-01' and adddate <='2024-12-01'order by billdetailid DESC [ RunTime:0.635742s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-12-01' and adddate <='2024-12-01'order by billdetailid DESC limit 0,90 [ RunTime:0.562500s ] --------------------------------------------------------------- [ 2024-12-01T11:41:14+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2024-11-01&enddate=2024-11-30&depotname=&custname=&goodscode=&goodsname=&goodscategory= [ 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.022460s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-11-01' and adddate <='2024-11-30'order by billdetailid DESC [ RunTime:0.573242s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2024-11-01' and adddate <='2024-11-30'order by billdetailid DESC limit 0,90 [ RunTime:0.588868s ] --------------------------------------------------------------- [ 2024-12-01T11:41:29+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/xsreport/sale_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'saledetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2024-12-01T11:41:31+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/xsreport/saledetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.018554s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('销售提货','销售退货') and adddate >='2024-12-01' and adddate <='2024-12-01'order by billdetailid DESC [ RunTime:0.628906s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('销售提货','销售退货') and adddate >='2024-12-01' and adddate <='2024-12-01'order by billdetailid DESC limit 0,90 [ RunTime:0.563477s ] --------------------------------------------------------------- [ 2024-12-01T11:41:45+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/xsreport/saledetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2024-11-01&enddate=2024-11-30&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&goodscategory= [ 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.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` ORDER BY `id` DESC [ RunTime:0.008789s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('销售提货','销售退货') and adddate >='2024-11-01' and adddate <='2024-11-30' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.613281s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('销售提货','销售退货') and adddate >='2024-11-01' and adddate <='2024-11-30' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.563476s ] --------------------------------------------------------------- [ 2024-12-01T11:47:01+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/kcreport/stock_sum.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-01T11:47:02+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90 [ 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.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-01T11:47:54+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2024-11-01&enddate=2024-11-30&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=goodscode&value=G17678&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G17678%' [ RunTime:0.007813s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 and goodscode like '%G17678%' ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-11-30' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-11-01' AND adddate <= '2024-11-30' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-11-01' AND adddate <= '2024-11-30' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-11-01' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.946289s ] --------------------------------------------------------------- [ 2024-12-01T11:48:29+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2022-11-01&enddate=2024-11-30&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=%E6%B4%BB%E6%80%A7%E7%82%AD&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2022-11-01' and adddate <='2024-11-30' and depotname='纸浆厂仓库' and goodsname like '%活性炭%'order by billdetailid DESC [ RunTime:0.016601s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2022-11-01' and adddate <='2024-11-30' and depotname='纸浆厂仓库' and goodsname like '%活性炭%'order by billdetailid DESC limit 0,90 [ RunTime:0.629883s ] --------------------------------------------------------------- [ 2024-12-01T11:51:11+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&page=1&limit=90&startdate=2024-11-01&enddate=&depotname=&custname=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-11-01' AND '2024-12-01' LIMIT 1 [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-11-01' AND '2024-12-01' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.065430s ] --------------------------------------------------------------- [ 2024-12-01T11:51:18+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/bill/bill_info.html?type=XS&billcode=XS-2024-12-01-0001 [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'XS-2024-12-01-0001' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'XS' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'XS-2024-12-01-0001' [ RunTime:0.122070s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2024-12-01T11:51:52+08:00 ] 202.62.102.143 POST 103.45.248.127:8001/index/bill/save_bill.html [ 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.024415s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE `depotname` = '纸浆厂仓库' AND `goodscode` = 'G17678' GROUP BY `goodscode` [ RunTime:10.942382s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'XS-2024-12-01-0001' AND `goodscode` = 'G17678' LIMIT 1 [ RunTime:0.003906s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.020508s ] [ sql ] [ SQL ] UPDATE `bill` SET `type`='销售提货',`inorout`='出库',`newtime`='2024-12-01 11:35:49',`billcode`='XS-2024-12-01-0001',`makedate`='2024-12-01',`maker`='张让红',`adddate`='2024-11-20',`depotname`='纸浆厂仓库',`custname`='廖总',`operator`='丁淑英',`originalcode`='',`note`='',`updateman`='张让红',`updatetime`='2024-12-01' WHERE `billid` = 43705 [ RunTime:0.001953s ] [ sql ] [ SQL ] DELETE FROM `billdetail` WHERE `billcode` = 'XS-2024-12-01-0001' [ RunTime:0.146484s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17678' , '粉末活性炭' , '25KG/袋' , '吨' , 7340.2 , 7 , 51381.4 , '' , 7489.19 , 'XS-2024-12-01-0001' , -1) [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2024-12-01T11:51:54+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%94%80%E5%94%AE%E6%8F%90%E8%B4%A7&page=1&limit=90&startdate=2024-11-01&enddate=&depotname=&custname=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ 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.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-11-01' AND '2024-12-01' LIMIT 1 [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2024-11-01' AND '2024-12-01' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.059570s ] --------------------------------------------------------------- [ 2024-12-01T11:51:58+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/xsreport/saledetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2024-11-01&enddate=2024-11-30&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&custname=&goodscode=&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('销售提货','销售退货') and adddate >='2024-11-01' and adddate <='2024-11-30' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.607422s ] [ sql ] [ SQL ] select *,-(number*sign)as t_num,-(money*sign)as t_mon from s_billdetail where type in ('销售提货','销售退货') and adddate >='2024-11-01' and adddate <='2024-11-30' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.559571s ] --------------------------------------------------------------- [ 2024-12-01T11:57:57+08:00 ] 202.62.102.143 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2024-11-01&enddate=2024-11-30&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=goodscode&value=G17678&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.007812s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%G17678%' [ RunTime:0.005860s ] [ sql ] [ SQL ] SELECT aa.goodscode, aa.goodsname, aa.specification, aa.unit, aa.goodscategory, IFNULL(endnumber,0)as endnumber, IFNULL(endmon,0)as endmon, IFNULL(innumber,0) as innumber, IFNULL(inmoney,0) as inmoney, IFNULL(outnumber,0) as outnumber, IFNULL(outmoney,0) as outmoney, IFNULL(startnumber,0) as startnumber, IFNULL(startmon,0) as startmon FROM ( SELECT goodscode, goodsname, specification, unit, goodscategory FROM goods WHERE 1=1 and goodscode like '%G17678%' ) AS aa LEFT JOIN( SELECT goodscode, IFNULL(SUM(t_num), 0) AS endnumber, ifnull(SUM(t_mon),0) AS endmon FROM s_billdetail WHERE adddate <= '2024-11-30' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON aa.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(money), 0) AS inmoney FROM s_billdetail WHERE sign= 1 AND adddate >= '2024-11-01' AND adddate <= '2024-11-30' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON aa.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(money), 0) AS outmoney FROM s_billdetail WHERE sign=-1 AND adddate >= '2024-11-01' AND adddate <= '2024-11-30' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON aa.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(t_num), 0) AS startnumber, ifnull(SUM(t_mon),0) AS startmon FROM s_billdetail WHERE adddate < '2024-11-01' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON aa.goodscode = s_start.goodscode limit 0,90 [ RunTime:1.938476s ]