--------------------------------------------------------------- [ 2019-11-10T09:36:21+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/wx/wxlist [运行时间：0.156247s] [吞吐率：6.40req/s] [内存消耗：1,682.80kb] [文件加载：35] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'wx', 2 => 'wxlist', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '191', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://localhost:8080', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://localhost:8080/user', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', ) [ info ] [ PARAM ] array ( 'url' => 'https://api.weixin.qq.com/sns/oauth2/access_token?appid=wxeeb99119c4591ed7&secret=8d3e43791807324662af6e27a5566d50&code=undefined&grant_type=authorization_code', ) [ info ] [ RUN ] app\index\controller\Wx->wxlist[ C:\wamp\www\cms\api\application\index\controller\Wx.php ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2019-11-10T09:36:21+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/wx/wxbindcard [运行时间：0.078124s] [吞吐率：12.80req/s] [内存消耗：2,563.65kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'wx', 2 => 'wxbindcard', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://localhost:8080', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://localhost:8080/user', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', ) [ info ] [ PARAM ] array ( ) [ info ] [ RUN ] app\index\controller\Wx->wxbindcard[ C:\wamp\www\cms\api\application\index\controller\Wx.php ] [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_openid` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_openid` WHERE `openid` IS NULL LIMIT 1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:36:21+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/wx/wxlistlogo [运行时间：0.140623s] [吞吐率：7.11req/s] [内存消耗：1,682.61kb] [文件加载：35] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'wx', 2 => 'wxlistlogo', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '115', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://localhost:8080', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://localhost:8080/user', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', ) [ info ] [ PARAM ] array ( 'url' => 'https://api.weixin.qq.com/sns/userinfo?access_token=undefined&openid=undefined&lang=zh_CN', ) [ info ] [ RUN ] app\index\controller\Wx->wxlistlogo[ C:\wamp\www\cms\api\application\index\controller\Wx.php ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2019-11-10T09:36:43+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/setting/rolelistByname [运行时间：0.093748s] [吞吐率：10.67req/s] [内存消耗：2,660.04kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015625s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'setting', 2 => 'rolelistByname', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '32', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'name' => '管理员', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\setting->rolelistByname[ C:\wamp\www\cms\api\application\index\controller\Setting.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_gangwei` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `quanxian` FROM `hy_gangwei` WHERE `name` = '管理员' AND `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:36:44+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/baobiao/getdanju [运行时间：0.093748s] [吞吐率：10.67req/s] [内存消耗：2,556.30kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'baobiao', 2 => 'getdanju', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '155', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'stime' => '2019-11-01 00:00:00', 'etime' => '2019-11-10 09:36:42', 'shop' => '十堰华思信息科技', 'user' => '', 'danhao' => '', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Baobiao->getdanju[ C:\wamp\www\cms\api\application\index\controller\Baobiao.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_posoutin` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_posoutin` WHERE `t_time` BETWEEN '2019-11-01 00:00:00' AND '2019-11-10 09:36:42' AND `shopname` = '十堰华思信息科技' AND `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:36:44+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.109373s] [吞吐率：9.14req/s] [内存消耗：2,610.36kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015624s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:15+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.109373s] [吞吐率：9.14req/s] [内存消耗：2,610.36kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:15+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/baobiao/getxiaoliang [运行时间：0.109373s] [吞吐率：9.14req/s] [内存消耗：2,518.44kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'baobiao', 2 => 'getxiaoliang', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '141', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'stime' => '2019-11-01 00:00:00', 'etime' => '2019-11-10 09:37:13', 'shop' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Baobiao->getxiaoliang[ C:\wamp\www\cms\api\application\index\controller\Baobiao.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select shopname, mingcheng,leixing,danwei, SUM(CAST(outnum AS DECIMAL(18, 0))) AS num,SUM(CAST(outnum * outprice AS DECIMAL(18, 0))) AS numprice FROM hy_productoutin where type='商品销售' and shopname='十堰华思信息科技' and (time >='2019-11-01 00:00:00' and time <='2019-11-10 09:37:13') and manager_id =8 GROUP BY shopname,mingcheng order by num desc [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:18+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.109373s] [吞吐率：9.14req/s] [内存消耗：2,610.36kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015625s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:18+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/baobiao/getdanju [运行时间：0.124997s] [吞吐率：8.00req/s] [内存消耗：2,556.30kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'baobiao', 2 => 'getdanju', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '155', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'stime' => '2019-11-01 00:00:00', 'etime' => '2019-11-10 09:37:16', 'shop' => '十堰华思信息科技', 'user' => '', 'danhao' => '', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Baobiao->getdanju[ C:\wamp\www\cms\api\application\index\controller\Baobiao.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.031250s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_posoutin` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_posoutin` WHERE `t_time` BETWEEN '2019-11-01 00:00:00' AND '2019-11-10 09:37:16' AND `shopname` = '十堰华思信息科技' AND `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.124997s] [吞吐率：8.00req/s] [内存消耗：2,610.36kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/dianpufx/getjiaoban [运行时间：0.140622s] [吞吐率：7.11req/s] [内存消耗：2,490.68kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'dianpufx', 2 => 'getjiaoban', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '141', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'stime' => '2019-11-01 00:00:00', 'etime' => '2019-11-10 09:37:21', 'shop' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Dianpufx->getjiaoban[ C:\wamp\www\cms\api\application\index\controller\Dianpufx.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015624s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select c_change_type, CONVERT( t_time, DATE) AS time, SUM(CAST(n_pay_shiji AS DECIMAL(18, 0))) AS num,count(id) as countnum FROM hy_posoutin where c_change_type not like '%积分%' and t_time >='2019-11-01 00:00:00' and t_time<='2019-11-10 09:37:21' and shopname='十堰华思信息科技' and manager_id =8 GROUP BY c_change_type [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/dianpufx/getjiaobanzfmx [运行时间：0.140622s] [吞吐率：7.11req/s] [内存消耗：2,491.01kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'dianpufx', 2 => 'getjiaobanzfmx', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '141', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'stime' => '2019-11-01 00:00:00', 'etime' => '2019-11-10 09:37:21', 'shop' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Dianpufx->getjiaobanzfmx[ C:\wamp\www\cms\api\application\index\controller\Dianpufx.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015624s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select SUM(CAST(n_pay_cash AS DECIMAL(18, 0))) AS 现金, SUM(CAST(n_pay_zfb AS DECIMAL(18, 0))) AS 支付宝,SUM(CAST(n_pay_wx AS DECIMAL(18, 0))) AS 微信,SUM(CAST(n_pay_bank AS DECIMAL(18, 0))) AS 银行卡,SUM(CAST(n_pay_qt AS DECIMAL(18, 0))) AS 其它 FROM hy_posoutin where( c_change_type not like '%积分%' and t_time >='2019-11-01 00:00:00' and t_time<='2019-11-10 09:37:21' and shopname='十堰华思信息科技' and manager_id =8 ) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/baobiao/getticheng [运行时间：0.140622s] [吞吐率：7.11req/s] [内存消耗：2,519.45kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'baobiao', 2 => 'getticheng', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '141', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'stime' => '2019-11-01 00:00:00', 'etime' => '2019-11-10 09:37:21', 'shop' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Baobiao->getticheng[ C:\wamp\www\cms\api\application\index\controller\Baobiao.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select hy_posoutin.shopname,hy_posoutin.tcyg,sum(hy_posoutin.tc) as je,sum(hy_posoutin.n_pay_shiji) as xsje, count(hy_posoutin.id) as count,hy_yuangong.beizhu,hy_yuangong.leixing,hy_yuangong.jine from hy_posoutin LEFT JOIN hy_yuangong ON hy_posoutin.tcyg = hy_yuangong.xingming where hy_posoutin.shopname='十堰华思信息科技' and (hy_posoutin.t_time >='2019-11-01 00:00:00' and hy_posoutin.t_time <='2019-11-10 09:37:21') and hy_posoutin.tcyg !='' and hy_posoutin.manager_id =8 and hy_yuangong.manager_id =8 group by hy_posoutin.tcyg [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.140622s] [吞吐率：7.11req/s] [内存消耗：2,610.36kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015624s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/setting/yuangonglist [运行时间：0.156247s] [吞吐率：6.40req/s] [内存消耗：2,653.36kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'setting', 2 => 'yuangonglist', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\setting->yuangonglist[ C:\wamp\www\cms\api\application\index\controller\Setting.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.015625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_yuangong` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_yuangong` WHERE `manager_id` = 8 [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2019-11-10T09:37:25+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.109373s] [吞吐率：9.14req/s] [内存消耗：2,610.36kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.015625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:25+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/baobiao/getczxl [运行时间：0.109373s] [吞吐率：9.14req/s] [内存消耗：2,524.95kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'baobiao', 2 => 'getczxl', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '141', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'stime' => '2019-11-01 00:00:00', 'etime' => '2019-11-10 09:37:23', 'shop' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Baobiao->getczxl[ C:\wamp\www\cms\api\application\index\controller\Baobiao.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select shopname,usertype,cardNo,c_name,购物消费,快速消费,(购物消费+快速消费) as '合计消费',开户收费,充值收费,会员充次,(开户收费+充值收费+会员充次) as '合计充值' from (select shopname,usertype,cardNo,c_name,sum(CASE WHEN c_Change_type='购物消费' THEN a ELSE '0' END) AS '购物消费',sum(CASE WHEN c_Change_type='快速消费' THEN a ELSE '0' END) AS '快速消费',sum(CASE WHEN c_Change_type='开户收费' THEN totshiji ELSE '0' END) AS '开户收费',sum(CASE WHEN c_Change_type='充值收费' THEN totshiji ELSE '0' END) AS '充值收费',sum(CASE WHEN c_Change_type='会员充次' THEN totshiji - a ELSE '0' END) AS '会员充次' from(select shopname, usertype, cardNo, SUM(CAST(n_pay_card AS DECIMAL(18, 0))) AS a , SUM(CAST(n_pay_shiji AS DECIMAL(18, 0))) AS totshiji, c_Change_type, c_name from hy_posoutin where cardno != '' and shopname='十堰华思信息科技' and (t_time >='2019-11-01 00:00:00' and t_time <='2019-11-10 09:37:23') and manager_id =8 group by cardNo, c_Change_type, c_name, shopname, usertype) AS t group by cardNo, c_name, shopname, usertype) AS s order by 合计充值 desc [ RunTime:0.000000s ] [ sql ] [ SQL ] select sum(合计消费) as xiaofei ,sum(合计充值) as chongzhi from (select shopname,usertype,cardNo,c_name,购物消费,快速消费,(购物消费+快速消费) as '合计消费',开户收费,充值收费,会员充次,(开户收费+充值收费+会员充次) as '合计充值' from (select shopname,usertype,cardNo,c_name,sum(CASE WHEN c_Change_type='购物消费' THEN a ELSE '0' END) AS '购物消费',sum(CASE WHEN c_Change_type='快速消费' THEN a ELSE '0' END) AS '快速消费',sum(CASE WHEN c_Change_type='开户收费' THEN totshiji ELSE '0' END) AS '开户收费',sum(CASE WHEN c_Change_type='充值收费' THEN totshiji ELSE '0' END) AS '充值收费',sum(CASE WHEN c_Change_type='会员充次' THEN totshiji - a ELSE '0' END) AS '会员充次' from(select shopname, usertype, cardNo, SUM(CAST(n_pay_card AS DECIMAL(18, 0))) AS a , SUM(CAST(n_pay_shiji AS DECIMAL(18, 0))) AS totshiji, c_Change_type, c_name from hy_posoutin where cardno != '' and shopname='十堰华思信息科技' and (t_time >='2019-11-01 00:00:00' and t_time <='2019-11-10 09:37:23') and manager_id =8 group by cardNo, c_Change_type, c_name, shopname, usertype) AS t group by cardNo, c_name, shopname, usertype) AS s order by 合计充值 desc) AS temp [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:31+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.093748s] [吞吐率：10.67req/s] [内存消耗：2,610.36kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:37:31+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/productlistex [运行时间：0.109373s] [吞吐率：9.14req/s] [内存消耗：2,621.88kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'productlistex', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '77', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'name' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->productlistex[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015624s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productlist` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_productlist` WHERE `manager_id` = 8 AND `shopname` = '十堰华思信息科技' [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:38:16+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.140622s] [吞吐率：7.11req/s] [内存消耗：2,610.36kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015624s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:38:16+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/productlist [运行时间：0.156247s] [吞吐率：6.40req/s] [内存消耗：2,626.56kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'productlist', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '99', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'name' => '', 'leixing' => 'all', 'dianming' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->productlist[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.031249s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productlist` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `productlist`.*,sum(innum)-sum(outnum) AS `kucun`,`productoutin`.`shopname` FROM `hy_productlist` `productlist` LEFT JOIN `hy_productoutin` `productoutin` ON `productlist`.`id`=`productoutin`.`productid` WHERE `productoutin`.`shopname` = '十堰华思信息科技' AND `productlist`.`shopname` = '十堰华思信息科技' AND ( `productlist`.`mingcheng` LIKE '%%' OR `productlist`.`suoxie` LIKE '%%' ) AND `productoutin`.`manager_id` = '8' AND `productlist`.`manager_id` = '8' GROUP BY productlist.id,productoutin.shopname [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:38:16+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/mingcheng [运行时间：0.171872s] [吞吐率：5.82req/s] [内存消耗：2,607.41kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'mingcheng', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->mingcheng[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productleixing` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_productleixing` WHERE `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:41:57+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/productlist [运行时间：0.093748s] [吞吐率：10.67req/s] [内存消耗：2,626.56kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'productlist', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '99', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'name' => '', 'leixing' => 'all', 'dianming' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->productlist[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productlist` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `productlist`.*,sum(innum)-sum(outnum) AS `kucun`,`productoutin`.`shopname` FROM `hy_productlist` `productlist` LEFT JOIN `hy_productoutin` `productoutin` ON `productlist`.`id`=`productoutin`.`productid` WHERE `productoutin`.`shopname` = '十堰华思信息科技' AND `productlist`.`shopname` = '十堰华思信息科技' AND ( `productlist`.`mingcheng` LIKE '%%' OR `productlist`.`suoxie` LIKE '%%' ) AND `productoutin`.`manager_id` = '8' AND `productlist`.`manager_id` = '8' GROUP BY productlist.id,productoutin.shopname [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:48:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/wx/wxlist [运行时间：0.171871s] [吞吐率：5.82req/s] [内存消耗：1,684.42kb] [文件加载：35] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'wx', 2 => 'wxlist', ), ) [ info ] [ HEADER ] array ( 'accept' => 'application/json, text/plain, */*', 'accept-encoding' => 'gzip', 'accept-language' => 'zh-CN,en-US;q=0.9', 'connection' => 'close', 'content-length' => '214', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'host' => 'web.huasivip.com', 'origin' => 'http://wx.huasivip.com', 'referer' => 'http://wx.huasivip.com/user?code=0812Vcrk2M1KFD0uSHpk2zo6rk22Vcrd&state=13635715047', 'user-agent' => 'Mozilla/5.0 (Linux; Android 9; TNY-AL00 Build/HUAWEITNY-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/66.0.3359.126 MQQBrowser/6.2 TBS/045008 Mobile Safari/537.36 MMWEBID/5244 MicroMessenger/7.0.8.1540(0x27000833) Process/tools NetType/WIFI Language/zh_CN ABI/arm64', 'x-forwarded-for' => '117.150.96.145', 'x-forwarded-for-pound' => '117.150.96.145', 'x-requested-with' => 'com.tencent.mm', ) [ info ] [ PARAM ] array ( 'url' => 'https://api.weixin.qq.com/sns/oauth2/access_token?appid=wxeeb99119c4591ed7&secret=8d3e43791807324662af6e27a5566d50&code=0812Vcrk2M1KFD0uSHpk2zo6rk22Vcrd&grant_type=authorization_code', ) [ info ] [ RUN ] app\index\controller\Wx->wxlist[ C:\wamp\www\cms\api\application\index\controller\Wx.php ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2019-11-10T09:48:24+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/wx/wxbindcard [运行时间：0.093748s] [吞吐率：10.67req/s] [内存消耗：2,586.68kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'wx', 2 => 'wxbindcard', ), ) [ info ] [ HEADER ] array ( 'accept' => 'application/json, text/plain, */*', 'accept-encoding' => 'gzip', 'accept-language' => 'zh-CN,en-US;q=0.9', 'connection' => 'close', 'content-length' => '35', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'host' => 'web.huasivip.com', 'origin' => 'http://wx.huasivip.com', 'referer' => 'http://wx.huasivip.com/user?code=0812Vcrk2M1KFD0uSHpk2zo6rk22Vcrd&state=13635715047', 'user-agent' => 'Mozilla/5.0 (Linux; Android 9; TNY-AL00 Build/HUAWEITNY-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/66.0.3359.126 MQQBrowser/6.2 TBS/045008 Mobile Safari/537.36 MMWEBID/5244 MicroMessenger/7.0.8.1540(0x27000833) Process/tools NetType/WIFI Language/zh_CN ABI/arm64', 'x-forwarded-for' => '117.150.96.145', 'x-forwarded-for-pound' => '117.150.96.145', 'x-requested-with' => 'com.tencent.mm', ) [ info ] [ PARAM ] array ( 'openid' => 'omEuq1N4tZlN5fVNik7vX8D8uFt4', ) [ info ] [ RUN ] app\index\controller\Wx->wxbindcard[ C:\wamp\www\cms\api\application\index\controller\Wx.php ] [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_openid` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_openid` WHERE `openid` = 'omEuq1N4tZlN5fVNik7vX8D8uFt4' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `phone` = '13635715047' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_kaika` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `kahao`,`syje`,`jifeng` FROM `hy_kaika` WHERE `manager_id` = 8 AND `wxopenid` = 'omEuq1N4tZlN5fVNik7vX8D8uFt4' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select kahao,mingcheng,sum(shuliang) as sumcount from hy_cika where kahao='20191019001' and manager_id =8 group by kahao,mingcheng [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:48:24+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/wx/wxlistlogo [运行时间：0.203121s] [吞吐率：4.92req/s] [内存消耗：1,684.50kb] [文件加载：35] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015625s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'wx', 2 => 'wxlistlogo', ), ) [ info ] [ HEADER ] array ( 'accept' => 'application/json, text/plain, */*', 'accept-encoding' => 'gzip', 'accept-language' => 'zh-CN,en-US;q=0.9', 'connection' => 'close', 'content-length' => '235', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'host' => 'web.huasivip.com', 'origin' => 'http://wx.huasivip.com', 'referer' => 'http://wx.huasivip.com/user?code=0812Vcrk2M1KFD0uSHpk2zo6rk22Vcrd&state=13635715047', 'user-agent' => 'Mozilla/5.0 (Linux; Android 9; TNY-AL00 Build/HUAWEITNY-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/66.0.3359.126 MQQBrowser/6.2 TBS/045008 Mobile Safari/537.36 MMWEBID/5244 MicroMessenger/7.0.8.1540(0x27000833) Process/tools NetType/WIFI Language/zh_CN ABI/arm64', 'x-forwarded-for' => '117.150.96.145', 'x-forwarded-for-pound' => '117.150.96.145', 'x-requested-with' => 'com.tencent.mm', ) [ info ] [ PARAM ] array ( 'url' => 'https://api.weixin.qq.com/sns/userinfo?access_token=27_F7RMjcWHGfmKoG66CuqpWANNbXoSLpUZFzbVnXH_N1G770unvIXfiThaXL-IR83vAYNldCnPqm9trrhSJWOMy--t5PeQEcgZfftopXXtp2w&openid=omEuq1N4tZlN5fVNik7vX8D8uFt4&lang=zh_CN', ) [ info ] [ RUN ] app\index\controller\Wx->wxlistlogo[ C:\wamp\www\cms\api\application\index\controller\Wx.php ] [ info ] [ LOG ] INIT File --------------------------------------------------------------- [ 2019-11-10T09:48:26+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/wx/getcika [运行时间：0.093748s] [吞吐率：10.67req/s] [内存消耗：2,594.90kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'wx', 2 => 'getcika', ), ) [ info ] [ HEADER ] array ( 'accept' => 'application/json, text/plain, */*', 'accept-encoding' => 'gzip', 'accept-language' => 'zh-CN,en-US;q=0.9', 'connection' => 'close', 'content-length' => '53', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'host' => 'web.huasivip.com', 'origin' => 'http://wx.huasivip.com', 'referer' => 'http://wx.huasivip.com/user?code=0812Vcrk2M1KFD0uSHpk2zo6rk22Vcrd&state=13635715047', 'user-agent' => 'Mozilla/5.0 (Linux; Android 9; TNY-AL00 Build/HUAWEITNY-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/66.0.3359.126 MQQBrowser/6.2 TBS/045008 Mobile Safari/537.36 MMWEBID/5244 MicroMessenger/7.0.8.1540(0x27000833) Process/tools NetType/WIFI Language/zh_CN ABI/arm64', 'x-forwarded-for' => '117.150.96.145', 'x-forwarded-for-pound' => '117.150.96.145', 'x-requested-with' => 'com.tencent.mm', ) [ info ] [ PARAM ] array ( 'kahao' => '20191019001', 'openid' => 'omEuq1N4tZlN5fVNik7vX8D8uFt4', ) [ info ] [ RUN ] app\index\controller\Wx->getcika[ C:\wamp\www\cms\api\application\index\controller\Wx.php ] [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015624s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_openid` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_openid` WHERE `openid` = 'omEuq1N4tZlN5fVNik7vX8D8uFt4' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `phone` = '13635715047' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_cika` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_cika` WHERE `kahao` = '20191019001' AND `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:48:35+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/wx/getjifeng [运行时间：0.093749s] [吞吐率：10.67req/s] [内存消耗：2,592.93kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'wx', 2 => 'getjifeng', ), ) [ info ] [ HEADER ] array ( 'accept' => 'application/json, text/plain, */*', 'accept-encoding' => 'gzip', 'accept-language' => 'zh-CN,en-US;q=0.9', 'connection' => 'close', 'content-length' => '53', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'host' => 'web.huasivip.com', 'origin' => 'http://wx.huasivip.com', 'referer' => 'http://wx.huasivip.com/user?code=0812Vcrk2M1KFD0uSHpk2zo6rk22Vcrd&state=13635715047', 'user-agent' => 'Mozilla/5.0 (Linux; Android 9; TNY-AL00 Build/HUAWEITNY-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/66.0.3359.126 MQQBrowser/6.2 TBS/045008 Mobile Safari/537.36 MMWEBID/5244 MicroMessenger/7.0.8.1540(0x27000833) Process/tools NetType/WIFI Language/zh_CN ABI/arm64', 'x-forwarded-for' => '117.150.96.145', 'x-forwarded-for-pound' => '117.150.96.145', 'x-requested-with' => 'com.tencent.mm', ) [ info ] [ PARAM ] array ( 'kahao' => '20191019001', 'openid' => 'omEuq1N4tZlN5fVNik7vX8D8uFt4', ) [ info ] [ RUN ] app\index\controller\Wx->getjifeng[ C:\wamp\www\cms\api\application\index\controller\Wx.php ] [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_openid` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_openid` WHERE `openid` = 'omEuq1N4tZlN5fVNik7vX8D8uFt4' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `phone` = '13635715047' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_posoutin` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `shopname`,`c_change_type`,`jifeng`,`t_time`,`n_sale_bill` FROM `hy_posoutin` WHERE `cardNo` = '20191019001' AND `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:49:04+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/setting/rolelistByname [运行时间：0.078124s] [吞吐率：12.80req/s] [内存消耗：2,660.04kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'setting', 2 => 'rolelistByname', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '32', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'name' => '管理员', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\setting->rolelistByname[ C:\wamp\www\cms\api\application\index\controller\Setting.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_gangwei` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `quanxian` FROM `hy_gangwei` WHERE `name` = '管理员' AND `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:49:04+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/productlist [运行时间：0.124998s] [吞吐率：8.00req/s] [内存消耗：2,626.56kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'productlist', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '99', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'name' => '', 'leixing' => 'all', 'dianming' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->productlist[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productlist` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `productlist`.*,sum(innum)-sum(outnum) AS `kucun`,`productoutin`.`shopname` FROM `hy_productlist` `productlist` LEFT JOIN `hy_productoutin` `productoutin` ON `productlist`.`id`=`productoutin`.`productid` WHERE `productoutin`.`shopname` = '十堰华思信息科技' AND `productlist`.`shopname` = '十堰华思信息科技' AND ( `productlist`.`mingcheng` LIKE '%%' OR `productlist`.`suoxie` LIKE '%%' ) AND `productoutin`.`manager_id` = '8' AND `productlist`.`manager_id` = '8' GROUP BY productlist.id,productoutin.shopname [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:49:04+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.124998s] [吞吐率：8.00req/s] [内存消耗：2,610.36kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.015624s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T09:49:04+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/mingcheng [运行时间：0.140623s] [吞吐率：7.11req/s] [内存消耗：2,607.41kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015624s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'mingcheng', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->mingcheng[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productleixing` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_productleixing` WHERE `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T10:12:55+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/setting/rolelistByname [运行时间：0.124997s] [吞吐率：8.00req/s] [内存消耗：2,566.84kb] [文件加载：39] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'setting', 2 => 'rolelistByname', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => '||undefined', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; Admin-Token=f37a20d38049676a77388c8b333aacb6; sidebarStatus=1', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.046874s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = '' AND `manager_id` = 0 AND `id` = 0 LIMIT 1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:41:14+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/reg/login [运行时间：0.375000s] [吞吐率：2.67req/s] [内存消耗：2,526.66kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'reg', 2 => 'login', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '50', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => '||undefined', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'username' => 'admin', 'password' => '12345678', 'phone' => '13635715047', ) [ info ] [ RUN ] app\index\controller\reg->login[ C:\wamp\www\cms\api\application\index\controller\Reg.php ] [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `phone` = '13635715047' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `xingming` = 'admin' AND `password` = '12345678' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_jifengshezhi` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `bili`,`content` FROM `hy_jifengshezhi` WHERE `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_rizhi` [ RunTime:0.015625s ] [ sql ] [ SQL ] INSERT INTO `hy_rizhi` (`manager_id` , `caozuo` , `caozuoren` , `result` , `ip`) VALUES (8 , '登录软件' , 'admin' , '成功' , '117.150.96.145') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:41:15+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/setting/rolelistByname [运行时间：0.093750s] [吞吐率：10.67req/s] [内存消耗：2,660.37kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'setting', 2 => 'rolelistByname', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '32', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'name' => '管理员', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\setting->rolelistByname[ C:\wamp\www\cms\api\application\index\controller\Setting.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_gangwei` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `quanxian` FROM `hy_gangwei` WHERE `name` = '管理员' AND `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:41:16+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getMoneyByChongzhi [运行时间：0.156250s] [吞吐率：6.40req/s] [内存消耗：2,487.48kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getMoneyByChongzhi', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getMoneyByChongzhi[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select CONVERT( t_time, DATE) AS time, SUM(CAST(n_pay_shiji AS DECIMAL(18, 2))) AS num,count(id) as countnum FROM hy_posoutin where (c_change_type="开户收费" or c_change_type="充值收费" ) and manager_id =8 GROUP BY time limit 0,10 [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2019-11-10T14:41:16+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getproductcount [运行时间：0.203125s] [吞吐率：4.92req/s] [内存消耗：2,485.59kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getproductcount', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getproductcount[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT SUM( innum - outnum) as SUM FROM hy_productoutin where manager_id =8 [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2019-11-10T14:41:16+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getchongzhi [运行时间：0.203125s] [吞吐率：4.92req/s] [内存消耗：2,487.75kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getchongzhi', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getchongzhi[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.031250s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT SUM( CASE WHEN `c_change_type` = "开户收费" OR `c_change_type` = "充值收费" OR `c_change_type` = "日常收支" THEN CAST(n_pay_Shiji AS DECIMAL(18, 2)) ELSE( CAST(n_pay_Shiji AS DECIMAL(18, 2)) - CAST(n_pay_card AS DECIMAL(18, 2)) ) END ) as SUM FROM hy_posoutin WHERE DATEDIFF(t_time, NOW()) = 0 and manager_id =8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:41:16+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getbirthdaycount [运行时间：0.187500s] [吞吐率：5.33req/s] [内存消耗：2,486.12kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getbirthdaycount', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getbirthdaycount[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT count(id) as SUM FROM hy_kaika WHERE manager_id =8 and DATE_FORMAT( birthday, '%m%d' ) BETWEEN DATE_FORMAT(CURDATE()-INTERVAL 30 DAY,'%m%d') AND DATE_FORMAT(CURDATE()+INTERVAL 5 DAY,'%m%d') [ RunTime:0.031250s ] --------------------------------------------------------------- [ 2019-11-10T14:41:16+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/hycount [运行时间：0.234375s] [吞吐率：4.27req/s] [内存消耗：2,499.77kb] [文件加载：42] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'hycount', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->hycount[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.015625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_kaika` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `hy_kaika` WHERE `manager_id` = 8 LIMIT 1 [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2019-11-10T14:41:16+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getbypay [运行时间：0.078125s] [吞吐率：12.80req/s] [内存消耗：2,487.23kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getbypay', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getByPay[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select c_name, SUM(CAST(n_pay_shiji AS DECIMAL(18, 0))) AS num,count(id) as countnum FROM hy_posoutin where ( c_change_type="开户收费" or c_change_type="充值收费" ) and manager_id =8 GROUP BY userid,c_name order by num desc limit 0,10 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:41:16+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getBySale [运行时间：0.187500s] [吞吐率：5.33req/s] [内存消耗：2,487.29kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015625s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getBySale', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getBySale[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select mingcheng, SUM(CAST(outnum AS DECIMAL(18, 0))) AS num FROM hy_productoutin where type="商品销售" and manager_id =8 GROUP BY productid order by num desc limit 0,10 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:47:50+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/setting/rolelistByname [运行时间：0.093766s] [吞吐率：10.66req/s] [内存消耗：2,660.00kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'setting', 2 => 'rolelistByname', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '32', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'name' => '管理员', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\setting->rolelistByname[ C:\wamp\www\cms\api\application\index\controller\Setting.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015628s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_gangwei` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `quanxian` FROM `hy_gangwei` WHERE `name` = '管理员' AND `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:47:50+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/mingcheng [运行时间：0.156277s] [吞吐率：6.40req/s] [内存消耗：2,607.39kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015628s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'mingcheng', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->mingcheng[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.015628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productleixing` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_productleixing` WHERE `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:47:50+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.171905s] [吞吐率：5.82req/s] [内存消耗：2,610.31kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.015627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:47:50+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/productlist [运行时间：0.171905s] [吞吐率：5.82req/s] [内存消耗：2,626.49kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'productlist', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '99', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'name' => '', 'leixing' => 'all', 'dianming' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->productlist[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015628s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productlist` [ RunTime:0.015628s ] [ sql ] [ SQL ] SELECT `productlist`.*,sum(innum)-sum(outnum) AS `kucun`,`productoutin`.`shopname` FROM `hy_productlist` `productlist` LEFT JOIN `hy_productoutin` `productoutin` ON `productlist`.`id`=`productoutin`.`productid` WHERE `productoutin`.`shopname` = '十堰华思信息科技' AND `productlist`.`shopname` = '十堰华思信息科技' AND ( `productlist`.`mingcheng` LIKE '%%' OR `productlist`.`suoxie` LIKE '%%' ) AND `productoutin`.`manager_id` = '8' AND `productlist`.`manager_id` = '8' GROUP BY productlist.id,productoutin.shopname [ RunTime:0.015628s ] --------------------------------------------------------------- [ 2019-11-10T14:48:13+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/reg/login [运行时间：0.109394s] [吞吐率：9.14req/s] [内存消耗：2,526.71kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'reg', 2 => 'login', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '50', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => '||undefined', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'username' => 'admin', 'password' => '12345678', 'phone' => '13635715047', ) [ info ] [ RUN ] app\index\controller\reg->login[ C:\wamp\www\cms\api\application\index\controller\Reg.php ] [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015628s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `phone` = '13635715047' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `xingming` = 'admin' AND `password` = '12345678' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_jifengshezhi` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `bili`,`content` FROM `hy_jifengshezhi` WHERE `manager_id` = 8 LIMIT 1 [ RunTime:0.015627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_rizhi` [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `hy_rizhi` (`manager_id` , `caozuo` , `caozuoren` , `result` , `ip`) VALUES (8 , '登录软件' , 'admin' , '成功' , '117.150.96.145') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:13+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/setting/rolelistByname [运行时间：0.093766s] [吞吐率：10.66req/s] [内存消耗：2,660.29kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015627s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'setting', 2 => 'rolelistByname', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '32', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'name' => '管理员', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\setting->rolelistByname[ C:\wamp\www\cms\api\application\index\controller\Setting.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015628s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_gangwei` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `quanxian` FROM `hy_gangwei` WHERE `name` = '管理员' AND `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:13+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/mingcheng [运行时间：0.109394s] [吞吐率：9.14req/s] [内存消耗：2,607.86kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'mingcheng', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->mingcheng[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.015628s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productleixing` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_productleixing` WHERE `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:13+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/productlist [运行时间：0.109394s] [吞吐率：9.14req/s] [内存消耗：2,627.05kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'productlist', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '99', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'name' => '', 'leixing' => 'all', 'dianming' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->productlist[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productlist` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `productlist`.*,sum(innum)-sum(outnum) AS `kucun`,`productoutin`.`shopname` FROM `hy_productlist` `productlist` LEFT JOIN `hy_productoutin` `productoutin` ON `productlist`.`id`=`productoutin`.`productid` WHERE `productoutin`.`shopname` = '十堰华思信息科技' AND `productlist`.`shopname` = '十堰华思信息科技' AND ( `productlist`.`mingcheng` LIKE '%%' OR `productlist`.`suoxie` LIKE '%%' ) AND `productoutin`.`manager_id` = '8' AND `productlist`.`manager_id` = '8' GROUP BY productlist.id,productoutin.shopname [ RunTime:0.015628s ] --------------------------------------------------------------- [ 2019-11-10T14:48:13+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.140650s] [吞吐率：7.11req/s] [内存消耗：2,610.77kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015627s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:17+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.109394s] [吞吐率：9.14req/s] [内存消耗：2,610.77kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'dianpu', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->dianpu[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015628s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_dianming` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_dianming` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:17+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/productlistex [运行时间：0.109394s] [吞吐率：9.14req/s] [内存消耗：2,622.17kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'productlistex', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '77', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'name' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->productlistex[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015628s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productlist` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_productlist` WHERE `manager_id` = 8 AND `shopname` = '十堰华思信息科技' [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:19+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/productlistGet [运行时间：0.093766s] [吞吐率：10.66req/s] [内存消耗：2,626.30kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'productlistGet', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '81', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'shopname' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->productlistGet[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015627s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productlist` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `productlist`.*,sum(innum)-sum(outnum) AS `kucun`,`productoutin`.`shopname` FROM `hy_productlist` `productlist` LEFT JOIN `hy_productoutin` `productoutin` ON `productlist`.`id`=`productoutin`.`productid` WHERE `productoutin`.`manager_id` = '8' AND `productlist`.`manager_id` = '8' AND `productoutin`.`shopname` = '十堰华思信息科技' AND `productlist`.`shopname` = '十堰华思信息科技' GROUP BY productlist.id,productoutin.shopname [ RunTime:0.015628s ] --------------------------------------------------------------- [ 2019-11-10T14:48:24+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/reg/login [运行时间：0.093766s] [吞吐率：10.66req/s] [内存消耗：2,526.93kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'reg', 2 => 'login', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '50', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'username' => 'admin', 'password' => '12345678', 'phone' => '13635715047', ) [ info ] [ RUN ] app\index\controller\reg->login[ C:\wamp\www\cms\api\application\index\controller\Reg.php ] [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015628s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `phone` = '13635715047' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `xingming` = 'admin' AND `password` = '12345678' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_jifengshezhi` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `bili`,`content` FROM `hy_jifengshezhi` WHERE `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_rizhi` [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `hy_rizhi` (`manager_id` , `caozuo` , `caozuoren` , `result` , `ip`) VALUES (8 , '登录软件' , 'admin' , '成功' , '117.150.96.145') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:24+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/setting/rolelistByname [运行时间：0.078139s] [吞吐率：12.80req/s] [内存消耗：2,660.29kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'setting', 2 => 'rolelistByname', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '32', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'name' => '管理员', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\setting->rolelistByname[ C:\wamp\www\cms\api\application\index\controller\Setting.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015628s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_gangwei` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `quanxian` FROM `hy_gangwei` WHERE `name` = '管理员' AND `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:24+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/productlistGet [运行时间：0.093767s] [吞吐率：10.66req/s] [内存消耗：2,626.30kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'productlistGet', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '81', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'shopname' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->productlistGet[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015628s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productlist` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `productlist`.*,sum(innum)-sum(outnum) AS `kucun`,`productoutin`.`shopname` FROM `hy_productlist` `productlist` LEFT JOIN `hy_productoutin` `productoutin` ON `productlist`.`id`=`productoutin`.`productid` WHERE `productoutin`.`manager_id` = '8' AND `productlist`.`manager_id` = '8' AND `productoutin`.`shopname` = '十堰华思信息科技' AND `productlist`.`shopname` = '十堰华思信息科技' GROUP BY productlist.id,productoutin.shopname [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:31+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/mingcheng [运行时间：0.093766s] [吞吐率：10.66req/s] [内存消耗：2,607.88kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'mingcheng', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->mingcheng[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015627s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productleixing` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_productleixing` WHERE `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:39+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/reg/login [运行时间：0.093766s] [吞吐率：10.66req/s] [内存消耗：2,526.93kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'reg', 2 => 'login', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '50', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1', ) [ info ] [ PARAM ] array ( 'username' => 'admin', 'password' => '12345678', 'phone' => '13635715047', ) [ info ] [ RUN ] app\index\controller\reg->login[ C:\wamp\www\cms\api\application\index\controller\Reg.php ] [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `phone` = '13635715047' LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `xingming` = 'admin' AND `password` = '12345678' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_jifengshezhi` [ RunTime:0.015628s ] [ sql ] [ SQL ] SELECT `bili`,`content` FROM `hy_jifengshezhi` WHERE `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_rizhi` [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `hy_rizhi` (`manager_id` , `caozuo` , `caozuoren` , `result` , `ip`) VALUES (8 , '登录软件' , 'admin' , '成功' , '117.150.96.145') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:39+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/setting/rolelistByname [运行时间：0.093767s] [吞吐率：10.66req/s] [内存消耗：2,660.29kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'setting', 2 => 'rolelistByname', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '32', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'name' => '管理员', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\setting->rolelistByname[ C:\wamp\www\cms\api\application\index\controller\Setting.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_gangwei` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT `quanxian` FROM `hy_gangwei` WHERE `name` = '管理员' AND `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:48:39+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/product/mingcheng [运行时间：0.093766s] [吞吐率：10.66req/s] [内存消耗：2,607.88kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'product', 2 => 'mingcheng', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Product->mingcheng[ C:\wamp\www\cms\api\application\index\controller\Product.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015627s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productleixing` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_productleixing` WHERE `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:49:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getproductcount [运行时间：0.125021s] [吞吐率：8.00req/s] [内存消耗：2,485.53kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getproductcount', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getproductcount[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015628s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT SUM( innum - outnum) as SUM FROM hy_productoutin where manager_id =8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:49:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/hycount [运行时间：0.187532s] [吞吐率：5.33req/s] [内存消耗：2,499.78kb] [文件加载：42] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'hycount', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->hycount[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015627s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.015628s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_kaika` [ RunTime:0.015628s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `hy_kaika` WHERE `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:49:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getbirthdaycount [运行时间：0.156277s] [吞吐率：6.40req/s] [内存消耗：2,486.08kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getbirthdaycount', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getbirthdaycount[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015627s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT count(id) as SUM FROM hy_kaika WHERE manager_id =8 and DATE_FORMAT( birthday, '%m%d' ) BETWEEN DATE_FORMAT(CURDATE()-INTERVAL 30 DAY,'%m%d') AND DATE_FORMAT(CURDATE()+INTERVAL 5 DAY,'%m%d') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:49:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getMoneyByChongzhi [运行时间：0.156277s] [吞吐率：6.40req/s] [内存消耗：2,487.48kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getMoneyByChongzhi', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getMoneyByChongzhi[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.015627s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select CONVERT( t_time, DATE) AS time, SUM(CAST(n_pay_shiji AS DECIMAL(18, 2))) AS num,count(id) as countnum FROM hy_posoutin where (c_change_type="开户收费" or c_change_type="充值收费" ) and manager_id =8 GROUP BY time limit 0,10 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:49:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getchongzhi [运行时间：0.265670s] [吞吐率：3.76req/s] [内存消耗：2,487.69kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015628s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getchongzhi', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getchongzhi[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.109394s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.015627s ] [ sql ] [ SQL ] SELECT SUM( CASE WHEN `c_change_type` = "开户收费" OR `c_change_type` = "充值收费" OR `c_change_type` = "日常收支" THEN CAST(n_pay_Shiji AS DECIMAL(18, 2)) ELSE( CAST(n_pay_Shiji AS DECIMAL(18, 2)) - CAST(n_pay_card AS DECIMAL(18, 2)) ) END ) as SUM FROM hy_posoutin WHERE DATEDIFF(t_time, NOW()) = 0 and manager_id =8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:49:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getBySale [运行时间：0.187533s] [吞吐率：5.33req/s] [内存消耗：2,487.22kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015628s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getBySale', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getBySale[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015627s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select mingcheng, SUM(CAST(outnum AS DECIMAL(18, 0))) AS num FROM hy_productoutin where type="商品销售" and manager_id =8 GROUP BY productid order by num desc limit 0,10 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:49:23+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouye/getbypay [运行时间：0.140649s] [吞吐率：7.11req/s] [内存消耗：2,487.20kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouye', 2 => 'getbypay', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouye->getByPay[ C:\wamp\www\cms\api\application\index\controller\Shouye.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] select c_name, SUM(CAST(n_pay_shiji AS DECIMAL(18, 0))) AS num,count(id) as countnum FROM hy_posoutin where ( c_change_type="开户收费" or c_change_type="充值收费" ) and manager_id =8 GROUP BY userid,c_name order by num desc limit 0,10 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:49:25+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouyin/productlistByType [运行时间：0.109394s] [吞吐率：9.14req/s] [内存消耗：2,620.00kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouyin', 2 => 'productlistByType', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '86', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'id' => '0', 'shopname' => '十堰华思信息科技', ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouyin->productlistbyType[ C:\wamp\www\cms\api\application\index\controller\Shouyin.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015627s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_productlist` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_productlist` WHERE `shopname` = '十堰华思信息科技' AND `danwei` <> '次' AND `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T14:49:25+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/shouyin/getyuangonglist [运行时间：0.140649s] [吞吐率：7.11req/s] [内存消耗：2,607.31kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'shouyin', 2 => 'getyuangonglist', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Shouyin->getyuangonglist[ C:\wamp\www\cms\api\application\index\controller\Shouyin.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015627s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_yuangong` [ RunTime:0.031256s ] [ sql ] [ SQL ] SELECT * FROM `hy_yuangong` WHERE `manager_id` = 8 [ RunTime:0.015627s ] --------------------------------------------------------------- [ 2019-11-10T14:49:25+08:00 ] 117.150.96.145 POST web.huasivip.com/api/public/index/huiyuan/huiyuanlist [运行时间：0.140649s] [吞吐率：7.11req/s] [内存消耗：2,681.09kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015628s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'huiyuanlist', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'https://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36', 'token' => 'f37a20d38049676a77388c8b333aacb6|8|6', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'https://web.huasivip.com/', 'accept-encoding' => 'gzip, deflate, br', 'accept-language' => 'zh-CN,zh;q=0.9,cs;q=0.8', 'cookie' => 'Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1571534518,1571534878,1571534917,1571628442; sidebarStatus=1; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->huiyuanlist[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 AND `id` = 6 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_kaika` [ RunTime:0.015628s ] [ sql ] [ SQL ] SELECT * FROM `hy_kaika` WHERE `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-11-10T21:34:36+08:00 ] 14.27.54.160 POST web.huasivip.com/api/public/index/reg/login [运行时间：0.109376s] [吞吐率：9.14req/s] [内存消耗：2,554.85kb] [文件加载：44] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.000000s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'reg', 2 => 'login', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'accept' => 'application/json, text/plain, */*', 'accept-language' => 'zh-cn', 'accept-encoding' => 'gzip, deflate', 'token' => 'null|null|undefined', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'origin' => 'http://web.huasivip.com', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.1 Mobile/15E148 Safari/604.1', 'connection' => 'keep-alive', 'referer' => 'http://web.huasivip.com/mt/', 'content-length' => '26', 'cookie' => 'Hm_lpvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1573392595; Hm_lvt_ac26ebef3e1a774402ea1cd5cc0cfdb5=1573392595', ) [ info ] [ PARAM ] array ( 'username' => '', 'password' => '', 'phone' => '', ) [ info ] [ RUN ] app\index\controller\reg->login[ C:\wamp\www\cms\api\application\index\controller\Reg.php ] [ info ] [ DB ] INIT mysql [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_shanghu` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `phone` = '' LIMIT 1 [ RunTime:0.000000s ] [ error ] [8]未定义变量: manager_id[C:\wamp\www\cms\api\application\index\controller\Reg.php:49]