--------------------------------------------------------------- [ 2023-03-10T15:05:58+08:00 ] 119.100.92.208 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.334961s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.104492s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'admin' AND `password` = 'MDAwMDAwMDAwMJJphqA' LIMIT 1 [ RunTime:0.102539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.098633s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.102539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.098633s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.101562s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-03-10 15:05:58',`web_session_id`='egetrgigh0o4t6e65727h1vqa5' WHERE `id` = 3 [ RunTime:0.102539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.102539s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'admin' , 'admin' , '119.100.92.208') [ RunTime:0.100585s ] --------------------------------------------------------------- [ 2023-03-10T15:06:00+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.130860s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.086914s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.085937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.080079s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.084961s ] --------------------------------------------------------------- [ 2023-03-10T15:06:08+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.137695s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.091796s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.090820s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.090820s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.090821s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.090821s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.083007s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.090821s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.090821s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.090820s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.085937s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.098633s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.089843s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.083985s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.089843s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.090820s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.090820s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.089843s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.089843s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.099609s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.104493s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.089843s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.087890s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.089844s ] --------------------------------------------------------------- [ 2023-03-10T15:06:18+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/dataquery/stock_search.html [ sql ] [ DB ] CONNECT:[ UseTime:0.136719s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.090820s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.088867s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.090821s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'stock' AND `show` = 1 ORDER BY `showid` [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.089844s ] --------------------------------------------------------------- [ 2023-03-10T15:06:25+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.138672s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.090820s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.090820s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.090820s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.088867s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.242187s ] [ 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 <= '2023-03-10' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:4.749023s ] --------------------------------------------------------------- [ 2023-03-10T15:06:33+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/billshow.html?type=CG [ sql ] [ DB ] CONNECT:[ UseTime:0.130860s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.086914s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.085937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.085938s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.084961s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.085937s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.085937s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.086914s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgbill' AND `show` = 1 ORDER BY `showid` [ RunTime:0.081055s ] --------------------------------------------------------------- [ 2023-03-10T15:06:34+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.122071s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.081054s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.081055s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.081054s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.080078s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.081054s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.081055s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.116211s ] --------------------------------------------------------------- [ 2023-03-10T15:06:39+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/bill_info.html?type=CG [ sql ] [ DB ] CONNECT:[ UseTime:0.138672s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.087891s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.088867s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.087891s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.087891s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.088868s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.083008s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.144532s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2023-03-10' AND `type` = '采购入库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.104492s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.088867s ] --------------------------------------------------------------- [ 2023-03-10T15:06:47+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.128906s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.077149s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.083984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.085937s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.083985s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.084961s ] --------------------------------------------------------------- [ 2023-03-10T15:06:51+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&type=CG&billcode=CG-2023-03-07-0005 [ sql ] [ DB ] CONNECT:[ UseTime:0.126953s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.083985s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.083984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.083984s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.089844s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.083985s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'CG-2023-03-07-0005' LIMIT 1 [ RunTime:0.083985s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.083984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'CG-2023-03-07-0005' [ RunTime:0.125000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.083984s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.083985s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.083984s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.083984s ] --------------------------------------------------------------- [ 2023-03-10T15:06:58+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&type=CG&billcode=CG-2023-03-07-0004 [ sql ] [ DB ] CONNECT:[ UseTime:0.137696s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.090821s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.091796s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.090820s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'CG-2023-03-07-0004' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.090820s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'CG-2023-03-07-0004' [ RunTime:0.133789s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.091797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.091796s ] --------------------------------------------------------------- [ 2023-03-10T15:07:17+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/index/logout.html [ sql ] [ DB ] CONNECT:[ UseTime:0.140625s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.092774s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.077149s ] --------------------------------------------------------------- [ 2023-03-10T15:07:36+08:00 ] 119.100.92.208 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.154297s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.101563s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'admin' AND `password` = 'MDAwMDAwMDAwMJJphqA' LIMIT 1 [ RunTime:0.101563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.101562s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.100586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.101563s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.096679s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-03-10 15:07:36',`web_session_id`='egetrgigh0o4t6e65727h1vqa5' WHERE `id` = 3 [ RunTime:0.099610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.101563s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'admin' , 'admin' , '119.100.92.208') [ RunTime:0.112304s ] --------------------------------------------------------------- [ 2023-03-10T15:07:38+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.128906s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.086914s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.087891s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.086914s ] --------------------------------------------------------------- [ 2023-03-10T15:07:43+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.140625s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.092773s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.091796s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.091797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.092773s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.091796s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.086914s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.092773s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.092773s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.092773s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.090821s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.081055s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.090820s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.089843s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.096680s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.091796s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.098633s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.085937s ] --------------------------------------------------------------- [ 2023-03-10T15:08:02+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/import/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.143555s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.093750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.093750s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.092773s ] --------------------------------------------------------------- [ 2023-03-10T15:08:05+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/backup/index.html [ sql ] [ DB ] CONNECT:[ UseTime:0.117187s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.083008s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.082032s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.082032s ] --------------------------------------------------------------- [ 2023-03-10T15:08:31+08:00 ] 202.62.102.42 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.138672s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.095703s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'my' AND `password` = 'MDAwMDAwMDAwMIaKfbE' LIMIT 1 [ RunTime:0.095703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.095703s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '纸浆厂库管' AND `status` = 1 LIMIT 1 [ RunTime:0.095703s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-03-10 15:08:31',`web_session_id`='jsrqcsdmvj249jirg6kd4m1d62' WHERE `id` = 20 [ RunTime:0.099609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.088867s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'MY' , '马应' , '202.62.102.42') [ RunTime:0.094726s ] --------------------------------------------------------------- [ 2023-03-10T15:08:33+08:00 ] 202.62.102.42 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.133789s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.083984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.088867s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.087891s ] --------------------------------------------------------------- [ 2023-03-10T15:08:40+08:00 ] 202.62.102.42 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.145508s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.086915s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.091796s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') LIMIT 1 [ RunTime:0.091796s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.093750s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.091796s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.092773s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.093750s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.092773s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.084961s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.094727s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.091796s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.085937s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.092773s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.091796s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.099610s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.099610s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.091797s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.091796s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.091797s ] --------------------------------------------------------------- [ 2023-03-10T15:08:49+08:00 ] 202.62.102.42 GET 103.45.248.127:8001/index/kcreport/stock_sum.html [ sql ] [ DB ] CONNECT:[ UseTime:0.120117s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.080078s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.079102s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.079102s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.078125s ] --------------------------------------------------------------- [ 2023-03-10T15:09:38+08:00 ] 202.62.102.42 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.135742s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.087891s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.087891s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.088867s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-03-01' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:23.478516s ] [ error ] [1]Maximum execution time of 30 seconds exceeded --------------------------------------------------------------- [ 2023-03-10T15:09:47+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/billshow.html?type=CG [ sql ] [ DB ] CONNECT:[ UseTime:0.130860s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.086914s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.085938s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.086914s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.085938s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.086914s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.083008s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.086914s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgbill' AND `show` = 1 ORDER BY `showid` [ RunTime:0.091797s ] --------------------------------------------------------------- [ 2023-03-10T15:09:48+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.139648s ] mysql:host=47.114.155.187;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.103515s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.092774s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.092774s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.091796s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.082031s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.089844s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.091797s ] --------------------------------------------------------------- [ 2023-03-10T15:18:12+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/index/logout.html [ 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.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-03-10T15:18:20+08:00 ] 119.100.92.208 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'admin' AND `password` = 'MDAwMDAwMDAwMJJphqA' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-03-10 15:18:20',`web_session_id`='egetrgigh0o4t6e65727h1vqa5' WHERE `id` = 3 [ RunTime:0.008789s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.030273s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'admin' , 'admin' , '119.100.92.208') [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-03-10T15:18:21+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-03-10T15:18:22+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.012695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.022461s ] [ 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.016601s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.021485s ] [ 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` = '2023-03-04' LIMIT 1 [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.018555s ] --------------------------------------------------------------- [ 2023-03-10T15:18:25+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/dataquery/stock_search.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'stock' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-03-10T15:18:37+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90 [ 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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.013672s ] [ 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 <= '2023-03-10' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:11.454102s ] --------------------------------------------------------------- [ 2023-03-10T15:18:42+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/billshow.html?type=CG [ 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.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgbill' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2023-03-10T15:18:42+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.051758s ] --------------------------------------------------------------- [ 2023-03-10T15:29:23+08:00 ] 202.62.102.71 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'dsy' AND `password` = 'MDAwMDAwMDAwMIaKfbE' LIMIT 1 [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2023-03-10T15:29:32+08:00 ] 202.62.102.71 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'my' AND `password` = 'MDAwMDAwMDAwMIaKfbE' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '纸浆厂库管' AND `status` = 1 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-03-10 15:29:32',`web_session_id`='f4no3mn7qi7rngj7d4pcir5035' WHERE `id` = 20 [ RunTime:0.006836s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.024414s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'MY' , '马应' , '202.62.102.71') [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-03-10T15:29:33+08:00 ] 202.62.102.71 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'my' AND `password` = 'MDAwMDAwMDAwMIaKfbE' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '纸浆厂库管' AND `status` = 1 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-03-10 15:29:33',`web_session_id`='f4no3mn7qi7rngj7d4pcir5035' WHERE `id` = 20 [ RunTime:0.005859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.022461s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'MY' , '马应' , '202.62.102.71') [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-03-10T15:29:34+08:00 ] 202.62.102.71 GET 103.45.248.127:8001/home [ 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.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-03-10T15:29:36+08:00 ] 202.62.102.71 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.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.017578s ] --------------------------------------------------------------- [ 2023-03-10T15:29:55+08:00 ] 202.62.102.71 GET 103.45.248.127:8001/index/kcreport/stock_sum.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.001954s ] [ 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 ] --------------------------------------------------------------- [ 2023-03-10T15:30:25+08:00 ] 202.62.102.71 GET 103.45.248.127:8001/index/cgreport/cg_detail.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:1.304687s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2023-03-10T15:30:27+08:00 ] 202.62.102.71 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.007812s ] 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.036133s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') 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 >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库")order by billdetailid DESC [ RunTime:0.500000s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库")order by billdetailid DESC limit 0,90 [ RunTime:0.543945s ] --------------------------------------------------------------- [ 2023-03-10T15:30:37+08:00 ] 202.62.102.71 GET 103.45.248.127:8001/index/cgreport/supplier_sum.html [ sql ] [ DB ] CONNECT:[ UseTime:0.009766s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.878907s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.009766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'suppliersum' AND `show` = 1 ORDER BY `showid` [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2023-03-10T15:30:41+08:00 ] 202.62.102.71 GET 103.45.248.127:8001/index/cgreport/suppliersum_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT a.custname, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money, IFNULL(t_num1,0)as t_num1, IFNULL(t_money1,0)as t_money1, IFNULL(t_num2,0)as t_num2, IFNULL(t_money2,0)as t_money2 FROM ( ( custom a LEFT JOIN ( SELECT custname, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) b ON a.custname = b.custname ) LEFT JOIN ( SELECT custname, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) c ON a.custname = c.custname ) LEFT JOIN ( SELECT custname, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) d ON a.custname = d.custname WHERE type LIKE '%供应商%' AND a.custname IN ( SELECT DISTINCT custname FROM bill where type IN ( '采购入库', '采购退货' ) ) [ RunTime:1.898437s ] [ sql ] [ SQL ] SELECT a.custname, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money, IFNULL(t_num1,0)as t_num1, IFNULL(t_money1,0)as t_money1, IFNULL(t_num2,0)as t_num2, IFNULL(t_money2,0)as t_money2 FROM ( ( custom a LEFT JOIN ( SELECT custname, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) b ON a.custname = b.custname ) LEFT JOIN ( SELECT custname, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) c ON a.custname = c.custname ) LEFT JOIN ( SELECT custname, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) d ON a.custname = d.custname WHERE type LIKE '%供应商%' AND a.custname IN ( SELECT DISTINCT custname FROM bill where type IN ( '采购入库', '采购退货' ) ) limit 0,90 [ RunTime:1.642578s ] --------------------------------------------------------------- [ 2023-03-10T15:30:42+08:00 ] 202.62.102.71 GET 103.45.248.127:8001/index/cgreport/suppliersum_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT a.custname, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money, IFNULL(t_num1,0)as t_num1, IFNULL(t_money1,0)as t_money1, IFNULL(t_num2,0)as t_num2, IFNULL(t_money2,0)as t_money2 FROM ( ( custom a LEFT JOIN ( SELECT custname, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) b ON a.custname = b.custname ) LEFT JOIN ( SELECT custname, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) c ON a.custname = c.custname ) LEFT JOIN ( SELECT custname, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) d ON a.custname = d.custname WHERE type LIKE '%供应商%' AND a.custname IN ( SELECT DISTINCT custname FROM bill where type IN ( '采购入库', '采购退货' ) ) [ RunTime:1.907227s ] [ sql ] [ SQL ] SELECT a.custname, IFNULL(t_num,0)as t_num, IFNULL(t_money,0)as t_money, IFNULL(t_num1,0)as t_num1, IFNULL(t_money1,0)as t_money1, IFNULL(t_num2,0)as t_num2, IFNULL(t_money2,0)as t_money2 FROM ( ( custom a LEFT JOIN ( SELECT custname, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) b ON a.custname = b.custname ) LEFT JOIN ( SELECT custname, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) c ON a.custname = c.custname ) LEFT JOIN ( SELECT custname, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY custname ) d ON a.custname = d.custname WHERE type LIKE '%供应商%' AND a.custname IN ( SELECT DISTINCT custname FROM bill where type IN ( '采购入库', '采购退货' ) ) limit 0,90 [ RunTime:1.733398s ] --------------------------------------------------------------- [ 2023-03-10T15:30:52+08:00 ] 202.62.102.71 GET 103.45.248.127:8001/index/kcreport/stocksum_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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001953s ] [ error ] [1]Maximum execution time of 30 seconds exceeded --------------------------------------------------------------- [ 2023-03-10T15:31:15+08:00 ] 202.62.102.71 GET 103.45.248.127:8001/index/bill/billshow.html?type=CG [ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.039062s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgbill' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2023-03-10T15:31:16+08:00 ] 202.62.102.71 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%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.023437s ] [ 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.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') LIMIT 1 [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.049805s ] --------------------------------------------------------------- [ 2023-03-10T15:36:25+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/kcreport/stock_sum.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.030274s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-03-10T15:39:18+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.011718s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-10' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-03-01' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:55.978515s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-10' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-03-01' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 limit 0,90 [ RunTime:116.579102s ] --------------------------------------------------------------- [ 2023-03-10T15:39:49+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/bill_info.html?type=CG [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ 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 `bill` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.101563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2023-03-10' AND `type` = '采购入库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.033203s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-03-10T15:40:03+08:00 ] 119.100.92.208 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&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.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.057617s ] --------------------------------------------------------------- [ 2023-03-10T15:46:10+08:00 ] 43.252.246.90 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] 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` = 'YYW' AND `password` = 'MDAwMDAwMDAwMIaKfbGyeY5o' LIMIT 1 [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2023-03-10T17:10:24+08:00 ] 202.62.102.116 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'my' AND `password` = 'MDAwMDAwMDAwMIaKfbE' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '纸浆厂库管' AND `status` = 1 LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-03-10 17:10:24',`web_session_id`='ag9ke3h1k55nfods3d6ca9fkk7' WHERE `id` = 20 [ RunTime:0.009766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.025391s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'MY' , '马应' , '202.62.102.116') [ RunTime:0.004883s ] --------------------------------------------------------------- [ 2023-03-10T17:10:25+08:00 ] 202.62.102.116 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'my' AND `password` = 'MDAwMDAwMDAwMIaKfbE' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '纸浆厂库管' AND `status` = 1 LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2023-03-10 17:10:25',`web_session_id`='svmik8d5cqv440pge0p3k62tq0' WHERE `id` = 20 [ RunTime:0.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.022461s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'MY' , '马应' , '202.62.102.116') [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-03-10T17:10:26+08:00 ] 202.62.102.116 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.023438s ] [ 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.000977s ] --------------------------------------------------------------- [ 2023-03-10T17:10:28+08:00 ] 202.62.102.116 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.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.007813s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.025391s ] [ 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.018555s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.021484s ] [ 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` = '2023-03-04' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.017578s ] --------------------------------------------------------------- [ 2023-03-10T17:10:55+08:00 ] 202.62.102.116 GET 103.45.248.127:8001/index/kcreport/stock_sum.html [ 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.040039s ] [ 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.000977s ] --------------------------------------------------------------- [ 2023-03-10T17:14:01+08:00 ] 202.62.102.116 GET 103.45.248.127:8001/index/kcreport/stocksum_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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-03-01' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:85.348633s ] [ error ] [1]Maximum execution time of 180 seconds exceeded --------------------------------------------------------------- [ 2023-03-10T17:15:04+08:00 ] 202.62.102.116 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-01-26&enddate=2023-03-05&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.128906s ] [ 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.001953s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-01-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-01-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-01-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:171.260742s ] [ error ] [1]Maximum execution time of 180 seconds exceeded --------------------------------------------------------------- [ 2023-03-10T17:17:34+08:00 ] 202.62.102.116 GET 103.45.248.127:8001/index/cgreport/cg_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-03-10T17:17:41+08:00 ] 202.62.102.116 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.014648s ] 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.038086s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') 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 >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库")order by billdetailid DESC [ RunTime:0.487305s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2023-03-01' and adddate <='2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库")order by billdetailid DESC limit 0,90 [ RunTime:0.444336s ] --------------------------------------------------------------- [ 2023-03-10T17:17:57+08:00 ] 202.62.102.116 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2023-01-26&enddate=2023-03-05&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.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') 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 >='2023-01-26' and adddate <='2023-03-05' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.472656s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2023-01-26' and adddate <='2023-03-05' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,90 [ RunTime:0.014648s ] --------------------------------------------------------------- [ 2023-03-10T17:18:03+08:00 ] 202.62.102.116 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=3000&startdate=2023-01-26&enddate=2023-03-05&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.004883s ] 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.025390s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') 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 >='2023-01-26' and adddate <='2023-03-05' and depotname='纸浆厂仓库'order by billdetailid DESC [ RunTime:0.528320s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2023-01-26' and adddate <='2023-03-05' and depotname='纸浆厂仓库'order by billdetailid DESC limit 0,3000 [ RunTime:0.459961s ] --------------------------------------------------------------- [ 2023-03-10T17:43:12+08:00 ] 202.62.102.116 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-03-10T17:43:14+08:00 ] 202.62.102.116 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.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') AND `adddate` BETWEEN '2023-03-01' AND '2023-03-10' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.006836s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.022461s ] [ 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` = '2023-03-04' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-04' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-05' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-06' LIMIT 1 [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-07' LIMIT 1 [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-08' LIMIT 1 [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-09' LIMIT 1 [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2023-03-10' LIMIT 1 [ RunTime:0.016602s ] --------------------------------------------------------------- [ 2023-03-10T17:43:20+08:00 ] 202.62.102.116 GET 103.45.248.127:8001/index/kcreport/stock_sum.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.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-03-10T17:45:47+08:00 ] 202.62.102.116 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.002930s ] 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.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-03-01' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:85.967774s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-03-01' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 limit 0,90 [ RunTime:60.479493s ] --------------------------------------------------------------- [ 2023-03-10T17:46:42+08:00 ] 202.62.102.116 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-01-26&enddate=2023-03-05&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.651368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-01-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-01-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-01-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:129.941406s ] [ error ] [1]Maximum execution time of 180 seconds exceeded --------------------------------------------------------------- [ 2023-03-10T18:23:12+08:00 ] 202.62.102.163 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-01-26&enddate=2023-03-05&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-01-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-01-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-01-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:52.034180s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-01-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-01-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-01-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 limit 0,90 [ RunTime:56.408203s ] --------------------------------------------------------------- [ 2023-03-10T18:32:52+08:00 ] 202.62.102.242 GET 103.45.248.127:8001/index/kcreport/substore_sum.html [ 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.041016s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'substoresum' AND `show` = 1 ORDER BY `showid` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-03-10T18:32:58+08:00 ] 202.62.102.242 GET 103.45.248.127:8001/index/kcreport/stock_sum.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.028321s ] [ 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 ] --------------------------------------------------------------- [ 2023-03-10T18:34:05+08:00 ] 202.62.102.242 GET 103.45.248.127:8001/index/kcreport/substoresum_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select num,mon,depotname,goodscode,goodsname,specification,unit,goodscategory from (select c.num,c.mon,c.goodscode,c.depotname,d.goodsname,d.specification,d.unit,d.goodscategory from (select sum(number*sign) as num , sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS mon,goodscode,depotname from s_goodsnum1 where number<>0 and adddate<= '2023-03-10' group by goodscode,depotname)as c left join(select goodscode,goodsname,specification,unit,goodscategory from goods) as d on c.goodscode=d.goodscode ) as TT where 1=1 and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") [ RunTime:17.526368s ] [ sql ] [ SQL ] select num,mon,depotname,goodscode,goodsname,specification,unit,goodscategory from (select c.num,c.mon,c.goodscode,c.depotname,d.goodsname,d.specification,d.unit,d.goodscategory from (select sum(number*sign) as num , sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS mon,goodscode,depotname from s_goodsnum1 where number<>0 and adddate<= '2023-03-10' group by goodscode,depotname)as c left join(select goodscode,goodsname,specification,unit,goodscategory from goods) as d on c.goodscode=d.goodscode ) as TT where 1=1 and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") limit 0,90 [ RunTime:54.334961s ] --------------------------------------------------------------- [ 2023-03-10T18:36:57+08:00 ] 202.62.102.242 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.039062s ] [ 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.000977s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-03-01' AND adddate <= '2023-03-10' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-03-01' and depotname in ("纸浆厂仓库","铅锌矿仓库","铜矿仓库") GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:102.197266s ] [ error ] [1]Maximum execution time of 180 seconds exceeded --------------------------------------------------------------- [ 2023-03-10T18:37:18+08:00 ] 202.62.102.242 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-02-26&enddate=2023-03-05&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.011718s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:2.102539s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.036133s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000977s ] [ error ] [1]Maximum execution time of 180 seconds exceeded --------------------------------------------------------------- [ 2023-03-10T18:37:28+08:00 ] 202.62.102.242 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-02-26&enddate=2023-03-05&depotname=&field=&value=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:1.145508s ] 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.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 ] [ error ] [1]Maximum execution time of 180 seconds exceeded --------------------------------------------------------------- [ 2023-03-10T18:41:04+08:00 ] 202.62.102.242 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-02-26&enddate=2023-03-05&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&goodscategory= [ 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.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-02-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:91.113282s ] [ error ] [1]Maximum execution time of 180 seconds exceeded --------------------------------------------------------------- [ 2023-03-10T18:41:07+08:00 ] 202.62.102.242 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-02-26&enddate=2023-03-05&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-02-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:101.784179s ] [ error ] [1]Maximum execution time of 180 seconds exceeded --------------------------------------------------------------- [ 2023-03-10T20:41:08+08:00 ] 202.62.102.97 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-02-26&enddate=2023-03-05&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.033203s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-02-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:54.001953s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-02-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 limit 0,90 [ RunTime:54.367187s ] --------------------------------------------------------------- [ 2023-03-10T21:08:54+08:00 ] 202.62.102.26 GET 103.45.248.127:8001/index/kcreport/stocksum_data.html?page=1&limit=90&startdate=2023-02-26&enddate=2023-03-05&depotname=%E7%BA%B8%E6%B5%86%E5%8E%82%E4%BB%93%E5%BA%93&field=&value=&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.046875s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.005859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-02-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 [ RunTime:54.056641s ] [ sql ] [ SQL ] select * from (SELECT a.goodscode as goodscode, goodsname, specification, unit, goodscategory, pym, note, 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, avgprice, IFNULL(startmon + inmoney - outmoney - endmon,0) as t_money FROM ( ( SELECT goodscode, goodsname, pym, specification, unit, goodscategory, note FROM goods ) AS a LEFT JOIN( SELECT goodscode, IFNULL(SUM(number*sign), 0) AS endnumber, ifnull(SUM(number*sign*price),0) AS endmon, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS avgprice FROM s_goodsnum WHERE adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode) AS s_end ON a.goodscode = s_end.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number), 0) AS innumber, ifnull(SUM(number*price), 0) AS inmoney FROM s_goodsnum WHERE sign= 1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_in ON a.goodscode = s_in.goodscode LEFT JOIN ( SELECT goodscode, ifnull(sum(number), 0) AS outnumber, ifnull(sum(number*price), 0) AS outmoney FROM s_goodsnum WHERE sign=-1 AND adddate >= '2023-02-26' AND adddate <= '2023-03-05' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_out ON a.goodscode = s_out.goodscode LEFT JOIN ( SELECT goodscode, ifnull(SUM(number*sign), 0) AS startnumber, ifnull( SUM(number*sign*price), 0 ) AS startmon FROM s_goodsnum WHERE adddate < '2023-02-26' and depotname='纸浆厂仓库' GROUP BY goodscode ) AS s_start ON a.goodscode = s_start.goodscode ) where (1=1))AS TT WHERE 1=1 limit 0,90 [ RunTime:57.903320s ]