--------------------------------------------------------------- [ 2025-03-02T09:30:45+08:00 ] 182.240.195.200 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.033203s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'zrh' AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2025-03-02 09:30:45',`web_session_id`='7ne53opk94b56h96211rghu5a3' WHERE `id` = 15 [ RunTime:0.005860s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.019532s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '182.240.195.200') [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2025-03-02T09:30:46+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/home [ 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.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2025-03-02T09:30:48+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/index/content.html [ sql ] [ DB ] CONNECT:[ UseTime:0.028321s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2025-03-01' AND '2025-03-02' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2025-03-01' AND '2025-03-02' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.019531s ] [ 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.021484s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.016602s ] [ 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` = '2025-02-24' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-02-25' LIMIT 1 [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-02-26' LIMIT 1 [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-02-27' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-02-28' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-03-01' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-03-02' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-02-24' LIMIT 1 [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-02-25' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-02-26' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-02-27' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-02-28' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-03-01' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-03-02' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-02-24' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-02-25' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-02-26' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-02-27' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-02-28' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-03-01' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-03-02' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-02-24' LIMIT 1 [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-02-25' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-02-26' LIMIT 1 [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-02-27' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-02-28' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-03-01' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-03-02' LIMIT 1 [ RunTime:0.020508s ] --------------------------------------------------------------- [ 2025-03-02T09:31:35+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/cg_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.028321s ] 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.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.038086s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.025390s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2025-03-02T09:31:37+08:00 ] 182.240.195.200 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.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2025-03-01' and adddate <='2025-03-02'order by billdetailid DESC [ RunTime:0.632813s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2025-03-01' and adddate <='2025-03-02'order by billdetailid DESC limit 0,90 [ RunTime:0.605468s ] --------------------------------------------------------------- [ 2025-03-02T09:31:50+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-03-02&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%85%A8%E7%AB%99%E4%BB%AA&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.024415s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%全站仪%'order by billdetailid DESC [ RunTime:0.016601s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%全站仪%'order by billdetailid DESC limit 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2025-03-02T09:31:58+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-03-02&enddate=&depotname=&custname=&goodscode=&goodsname=%E5%A1%94%E5%B0%BA&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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%塔尺%'order by billdetailid DESC [ RunTime:0.014648s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%塔尺%'order by billdetailid DESC limit 0,90 [ RunTime:0.014649s ] --------------------------------------------------------------- [ 2025-03-02T09:32:06+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-03-02&enddate=&depotname=&custname=&goodscode=&goodsname=RTK&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.018555s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%RTK%'order by billdetailid DESC [ RunTime:0.016601s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%RTK%'order by billdetailid DESC limit 0,90 [ RunTime:0.014649s ] --------------------------------------------------------------- [ 2025-03-02T09:32:12+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-03-02&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B5%8B%E9%87%8F&goodscategory= [ 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.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%测量%'order by billdetailid DESC [ RunTime:0.041015s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%测量%'order by billdetailid DESC limit 0,90 [ RunTime:0.012695s ] --------------------------------------------------------------- [ 2025-03-02T09:32:30+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-03-02&enddate=&depotname=&custname=&goodscode=&goodsname=%E8%9E%BA%E4%B8%9D&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.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%螺丝%'order by billdetailid DESC [ RunTime:0.360352s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%螺丝%'order by billdetailid DESC limit 0,90 [ RunTime:0.044921s ] --------------------------------------------------------------- [ 2025-03-02T09:41:25+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-03-02&enddate=&depotname=&custname=&goodscode=&goodsname=%E4%BB%AA%E5%99%A8&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.053711s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%仪器%'order by billdetailid DESC [ RunTime:0.015625s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%仪器%'order by billdetailid DESC limit 0,90 [ RunTime:0.017578s ] --------------------------------------------------------------- [ 2025-03-02T09:41:32+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-03-02&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%B5%8B%E9%87%8F&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.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%测量%'order by billdetailid DESC [ RunTime:0.014649s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%测量%'order by billdetailid DESC limit 0,90 [ RunTime:0.013672s ] --------------------------------------------------------------- [ 2025-03-02T09:41:41+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/purchase_sum.html [ sql ] [ DB ] CONNECT:[ UseTime:0.026367s ] 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.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'purchasesum' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2025-03-02T09:41:44+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/purchasesum_data.html?page=1&limit=90 [ 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.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT a.*, 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 ( ( goods a RIGHT JOIN ( SELECT goodscode, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2025-03-01' and adddate <='2025-03-02' GROUP BY goodscode ) d ON a.goodscode = d.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2025-03-01' and adddate <='2025-03-02' GROUP BY goodscode ) c ON a.goodscode = c.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2025-03-01' and adddate <='2025-03-02' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:1.496094s ] [ sql ] [ SQL ] SELECT a.*, 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 ( ( goods a RIGHT JOIN ( SELECT goodscode, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2025-03-01' and adddate <='2025-03-02' GROUP BY goodscode ) d ON a.goodscode = d.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2025-03-01' and adddate <='2025-03-02' GROUP BY goodscode ) c ON a.goodscode = c.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2025-03-01' and adddate <='2025-03-02' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:1.430664s ] --------------------------------------------------------------- [ 2025-03-02T09:42:06+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/purchasesum_data.html?page=1&limit=90&startdate=2020-03-02&enddate=&depotname=&goodscode=&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT a.*, 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 ( ( goods a RIGHT JOIN ( SELECT goodscode, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) d ON a.goodscode = d.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) c ON a.goodscode = c.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:10.590820s ] [ sql ] [ SQL ] SELECT a.*, 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 ( ( goods a RIGHT JOIN ( SELECT goodscode, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) d ON a.goodscode = d.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) c ON a.goodscode = c.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:1.993164s ] --------------------------------------------------------------- [ 2025-03-02T09:42:19+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/purchasesum_data.html?page=1&limit=90&startdate=2020-03-02&enddate=&depotname=&goodscode=&goodsname=%E4%BB%AA%E5%99%A8&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.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] SELECT a.*, 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 ( ( goods a RIGHT JOIN ( SELECT goodscode, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2020-03-02' and adddate <='2025-03-02' and goodsname like '%仪器%' GROUP BY goodscode ) d ON a.goodscode = d.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2020-03-02' and adddate <='2025-03-02' and goodsname like '%仪器%' GROUP BY goodscode ) c ON a.goodscode = c.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2020-03-02' and adddate <='2025-03-02' and goodsname like '%仪器%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT a.*, 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 ( ( goods a RIGHT JOIN ( SELECT goodscode, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2020-03-02' and adddate <='2025-03-02' and goodsname like '%仪器%' GROUP BY goodscode ) d ON a.goodscode = d.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2020-03-02' and adddate <='2025-03-02' and goodsname like '%仪器%' GROUP BY goodscode ) c ON a.goodscode = c.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2020-03-02' and adddate <='2025-03-02' and goodsname like '%仪器%' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:0.024414s ] --------------------------------------------------------------- [ 2025-03-02T09:42:39+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/purchasesum_data.html?page=1&limit=90&startdate=2020-03-02&enddate=&depotname=&goodscode=&goodsname=&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.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT a.*, 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 ( ( goods a RIGHT JOIN ( SELECT goodscode, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) d ON a.goodscode = d.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) c ON a.goodscode = c.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:10.450195s ] [ sql ] [ SQL ] SELECT a.*, 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 ( ( goods a RIGHT JOIN ( SELECT goodscode, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) d ON a.goodscode = d.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) c ON a.goodscode = c.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,90 [ RunTime:1.890625s ] --------------------------------------------------------------- [ 2025-03-02T09:43:33+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/purchasesum_data.html?page=1&limit=3000&startdate=2020-03-02&enddate=&depotname=&goodscode=&goodsname=&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT a.*, 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 ( ( goods a RIGHT JOIN ( SELECT goodscode, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) d ON a.goodscode = d.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) c ON a.goodscode = c.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) b ON a.goodscode = b.goodscode [ RunTime:11.011719s ] [ sql ] [ SQL ] SELECT a.*, 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 ( ( goods a RIGHT JOIN ( SELECT goodscode, sum(number * sign) AS t_num2, sum(money * sign) AS t_money2 FROM s_billdetail WHERE type IN ( '采购入库', '采购退货' ) and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) d ON a.goodscode = d.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num1, sum(money) AS t_money1 FROM s_billdetail WHERE type = '采购退货' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) c ON a.goodscode = c.goodscode ) LEFT JOIN ( SELECT goodscode, sum(number) AS t_num, sum(money) AS t_money FROM s_billdetail WHERE type = '采购入库' and adddate >='2020-03-02' and adddate <='2025-03-02' GROUP BY goodscode ) b ON a.goodscode = b.goodscode limit 0,3000 [ RunTime:5.435546s ] --------------------------------------------------------------- [ 2025-03-02T15:40:41+08:00 ] 182.240.195.200 POST 103.45.248.127:8001/index/login/dologin.html [ sql ] [ DB ] CONNECT:[ UseTime:0.009766s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `user` WHERE `username` = 'zrh' AND `password` = 'MDAwMDAwMDAwMJ6NaK-ziZxo' LIMIT 1 [ RunTime:0.016601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `role` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `role` WHERE `rolename` = '超级管理员' AND `status` = 1 LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `authority` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `functionname` FROM `authority` WHERE `status` = 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] UPDATE `user` SET `logintime`='2025-03-02 15:40:41',`web_session_id`='akho68q0gm12rgacbov4jpqv50' WHERE `id` = 15 [ RunTime:0.004882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `managelog` [ RunTime:0.019531s ] [ sql ] [ SQL ] INSERT INTO `managelog` (`type` , `info` , `username` , `truename` , `ip`) VALUES ('用户登录' , '登录了系统' , 'ZRH' , '张让红' , '182.240.195.200') [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2025-03-02T15:40:42+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/home [ sql ] [ DB ] CONNECT:[ UseTime:0.016601s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2025-03-02T15:40:43+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/index/content.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.025390s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2025-03-01' AND '2025-03-02' LIMIT 1 [ RunTime:0.041016s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `adddate` BETWEEN '2025-03-01' AND '2025-03-02' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `checkstatus` = '未审核' AND `type` <> '调入仓库' LIMIT 1 [ RunTime:0.023438s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `goods` LIMIT 1 [ RunTime:0.004883s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` <> '调入仓库' LIMIT 1 [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `depot` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.047852s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `employee` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-02-24' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-02-25' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-02-26' LIMIT 1 [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-02-27' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-02-28' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-03-01' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `makedate` = '2025-03-02' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-02-24' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-02-25' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-02-26' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-02-27' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-02-28' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-03-01' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '销售提货' AND `makedate` = '2025-03-02' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-02-24' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-02-25' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-02-26' LIMIT 1 [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-02-27' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-02-28' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-03-01' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '生产入库' AND `makedate` = '2025-03-02' LIMIT 1 [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-02-24' LIMIT 1 [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-02-25' LIMIT 1 [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-02-26' LIMIT 1 [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-02-27' LIMIT 1 [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-02-28' LIMIT 1 [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-03-01' LIMIT 1 [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '领用出库' AND `makedate` = '2025-03-02' LIMIT 1 [ RunTime:0.019531s ] --------------------------------------------------------------- [ 2025-03-02T15:40:51+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/cg_detail.html [ sql ] [ DB ] CONNECT:[ UseTime:0.042968s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'cgdetail' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2025-03-02T15:40:53+08:00 ] 182.240.195.200 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.034179s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2025-03-01' and adddate <='2025-03-02'order by billdetailid DESC [ RunTime:0.626953s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2025-03-01' and adddate <='2025-03-02'order by billdetailid DESC limit 0,90 [ RunTime:0.587891s ] --------------------------------------------------------------- [ 2025-03-02T15:41:09+08:00 ] 182.240.195.200 GET 103.45.248.127:8001/index/cgreport/cgdetail_data.html?custname=&startdate=&enddate=&depotname=&goodscode=&page=1&limit=90&startdate=2021-03-02&enddate=&depotname=&custname=&goodscode=&goodsname=%E6%8A%95%E5%BD%B1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.035157s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025391s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%投影%'order by billdetailid DESC [ RunTime:0.021485s ] [ sql ] [ SQL ] select *,(number*sign)as t_num,(money*sign)as t_mon from s_billdetail where type in ('采购入库','采购退货') and adddate >='2021-03-02' and adddate <='2025-03-02' and goodsname like '%投影%'order by billdetailid DESC limit 0,90 [ RunTime:0.013672s ]