--------------------------------------------------------------- [ 2019-12-06T18:02:03+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/reg/login [运行时间：0.125003s] [吞吐率：8.00req/s] [内存消耗：2,526.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 => 'reg', 2 => 'login', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '50', '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=1574677652,1574819873,1575015463,1575252486', ) [ 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.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.100.106') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:02:03+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/setting/rolelistByname [运行时间：0.093752s] [吞吐率：10.67req/s] [内存消耗：2,659.94kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; 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-12-06T18:02:04+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/hycount [运行时间：0.140629s] [吞吐率：7.11req/s] [内存消耗：2,499.13kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.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.015625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_kaika` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `hy_kaika` WHERE `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:02:04+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getBySale [运行时间：0.265632s] [吞吐率：3.76req/s] [内存消耗：2,486.64kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.031251s ] 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.015626s ] --------------------------------------------------------------- [ 2019-12-06T18:02:04+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getMoneyByChongzhi [运行时间：0.250006s] [吞吐率：4.00req/s] [内存消耗：2,486.74kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:02:04+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getproductcount [运行时间：0.296883s] [吞吐率：3.37req/s] [内存消耗：2,485.04kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015626s ] [ 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', '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=1574677652,1574819873,1575015463,1575252486; 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.031251s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.015626s ] [ 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-12-06T18:02:04+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getbypay [运行时间：0.125003s] [吞吐率：8.00req/s] [内存消耗：2,486.58kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.015625s ] [ 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-12-06T18:02:04+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getchongzhi [运行时间：0.328133s] [吞吐率：3.05req/s] [内存消耗：2,487.09kb] [文件加载：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 => 'getchongzhi', ), ) [ 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=1574677652,1574819873,1575015463,1575252486; 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.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.031251s ] [ sql ] [ SQL ] SELECT * FROM `hy_manager` WHERE `token` = 'f37a20d38049676a77388c8b333aacb6' AND `manager_id` = 8 LIMIT 1 [ RunTime:0.015626s ] [ 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-12-06T18:02:04+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getbirthdaycount [运行时间：0.328133s] [吞吐率：3.05req/s] [内存消耗：2,485.55kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015626s ] [ 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', '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=1574677652,1574819873,1575015463,1575252486; 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.015625s ] mysql:host=127.0.0.1;dbname=huiyuan;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_manager` [ RunTime:0.046877s ] [ 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.015625s ] --------------------------------------------------------------- [ 2019-12-06T18:05:26+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/product/productlistex [运行时间：0.109378s] [吞吐率：9.14req/s] [内存消耗：2,619.16kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; 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.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.015626s ] [ sql ] [ SQL ] SELECT * FROM `hy_productlist` WHERE `manager_id` = 8 AND `shopname` = '十堰华思信息科技' [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:26+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.109378s] [吞吐率：9.14req/s] [内存消耗：2,610.25kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; 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.015626s ] 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-12-06T18:05:28+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/hycount [运行时间：0.140629s] [吞吐率：7.11req/s] [内存消耗：2,499.13kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.000000s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `hy_kaika` [ RunTime:0.015626s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `hy_kaika` WHERE `manager_id` = 8 LIMIT 1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:28+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getchongzhi [运行时间：0.140629s] [吞吐率：7.11req/s] [内存消耗：2,487.09kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.015626s ] 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( 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.015625s ] --------------------------------------------------------------- [ 2019-12-06T18:05:28+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getMoneyByChongzhi [运行时间：0.125003s] [吞吐率：8.00req/s] [内存消耗：2,486.74kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.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.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:28+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getbirthdaycount [运行时间：0.203130s] [吞吐率：4.92req/s] [内存消耗：2,485.55kb] [文件加载：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 => 'getbirthdaycount', ), ) [ 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=1574677652,1574819873,1575015463,1575252486; 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.015626s ] 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-12-06T18:05:28+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getproductcount [运行时间：0.265632s] [吞吐率：3.76req/s] [内存消耗：2,485.07kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015626s ] [ 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', '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=1574677652,1574819873,1575015463,1575252486; 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.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 SUM( innum - outnum) as SUM FROM hy_productoutin where manager_id =8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:28+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getBySale [运行时间：0.218755s] [吞吐率：4.57req/s] [内存消耗：2,486.63kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015626s ] [ 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', '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=1574677652,1574819873,1575015463,1575252486; 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.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 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-12-06T18:05:28+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getbypay [运行时间：0.140628s] [吞吐率：7.11req/s] [内存消耗：2,486.58kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.015625s ] [ 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-12-06T18:05:32+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/huiyuan/hyleixing [运行时间：0.156254s] [吞吐率：6.40req/s] [内存消耗：2,611.58kb] [文件加载：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 => 'hyleixing', ), ) [ 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=1574677652,1574819873,1575015463,1575252486; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->hyleixing[ C:\wamp\www\cms\api\application\index\controller\Huiyuan.php ] [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015626s ] 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_hyleixing` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `hy_hyleixing` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:32+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.140628s] [吞吐率：7.11req/s] [内存消耗：2,610.25kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; 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-12-06T18:05:33+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/setting/getwxcode [运行时间：0.718768s] [吞吐率：1.39req/s] [内存消耗：2,650.26kb] [文件加载：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 => 'getwxcode', ), ) [ 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=1574677652,1574819873,1575015463,1575252486; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\setting->getwxcode[ 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.015626s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_shanghu` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:35+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/huiyuan/hyleixing [运行时间：0.125003s] [吞吐率：8.00req/s] [内存消耗：2,611.58kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015626s ] [ info ] [ LANG ] C:\wamp\www\cms\api\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'huiyuan', 2 => 'hyleixing', ), ) [ 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=1574677652,1574819873,1575015463,1575252486; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT mysql [ info ] [ RUN ] app\index\controller\Huiyuan->hyleixing[ 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_hyleixing` [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_hyleixing` WHERE `manager_id` = 8 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:35+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.156254s] [吞吐率：6.40req/s] [内存消耗：2,610.25kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; 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.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.015626s ] --------------------------------------------------------------- [ 2019-12-06T18:05:35+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/huiyuan/huiyuanlist [运行时间：0.171879s] [吞吐率：5.82req/s] [内存消耗：2,630.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 => 'huiyuan', 2 => 'huiyuanlist', ), ) [ info ] [ HEADER ] array ( 'host' => 'web.huasivip.com', 'connection' => 'keep-alive', 'content-length' => '29', '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=1574677652,1574819873,1575015463,1575252486; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'name' => '', 'leixing' => '', 'dianpu' => '', 'value' => '', ) [ 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.031251s ] 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.000000s ] [ sql ] [ SQL ] SELECT * FROM `hy_kaika` WHERE `manager_id` = 8 ORDER BY `id` DESC [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:38+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getchongzhi [运行时间：0.140629s] [吞吐率：7.11req/s] [内存消耗：2,487.09kb] [文件加载：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 => 'getchongzhi', ), ) [ 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=1574677652,1574819873,1575015463,1575252486; 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.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 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-12-06T18:05:38+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/hycount [运行时间：0.156254s] [吞吐率：6.40req/s] [内存消耗：2,499.13kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.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 ] SHOW COLUMNS FROM `hy_kaika` [ RunTime:0.015626s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `hy_kaika` WHERE `manager_id` = 8 LIMIT 1 [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2019-12-06T18:05:38+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getproductcount [运行时间：0.187505s] [吞吐率：5.33req/s] [内存消耗：2,485.07kb] [文件加载：41] [ info ] [ BEHAVIOR ] Run app\api\behavior\CORS @app_init [ RunTime:0.015626s ] [ 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', '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=1574677652,1574819873,1575015463,1575252486; 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.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-12-06T18:05:38+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getbirthdaycount [运行时间：0.125003s] [吞吐率：8.00req/s] [内存消耗：2,485.55kb] [文件加载：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 => 'getbirthdaycount', ), ) [ 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=1574677652,1574819873,1575015463,1575252486; 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.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 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-12-06T18:05:38+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getbypay [运行时间：0.125003s] [吞吐率：8.00req/s] [内存消耗：2,486.58kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.015625s ] --------------------------------------------------------------- [ 2019-12-06T18:05:38+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getMoneyByChongzhi [运行时间：0.312508s] [吞吐率：3.20req/s] [内存消耗：2,486.74kb] [文件加载：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', '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=1574677652,1574819873,1575015463,1575252486; 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.015626s ] 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.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:38+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/shouye/getBySale [运行时间：0.203130s] [吞吐率：4.92req/s] [内存消耗：2,486.63kb] [文件加载：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 => 'getBySale', ), ) [ 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=1574677652,1574819873,1575015463,1575252486; 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.015626s ] 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-12-06T18:05:48+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.109378s] [吞吐率：9.14req/s] [内存消耗：2,610.25kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; 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-12-06T18:05:48+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/product/productlistex [运行时间：0.109378s] [吞吐率：9.14req/s] [内存消耗：2,619.16kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; 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.015626s ] 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-12-06T18:05:53+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/huiyuan/dianpu [运行时间：0.125003s] [吞吐率：8.00req/s] [内存消耗：2,610.25kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; 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.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-12-06T18:05:53+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/dianpufx/getjiaoban [运行时间：0.140628s] [吞吐率：7.11req/s] [内存消耗：2,489.72kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'stime' => '2019-12-06 00:00:00', 'etime' => '2019-12-06 18:05:53', '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.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_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-12-06 00:00:00' and t_time<='2019-12-06 18:05:53' and shopname='十堰华思信息科技' and manager_id =8 GROUP BY c_change_type [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:53+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/dianpufx/getjiaobanzfmx [运行时间：0.109377s] [吞吐率：9.14req/s] [内存消耗：2,490.91kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'stime' => '2019-12-06 00:00:00', 'etime' => '2019-12-06 18:05:53', '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.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 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-12-06 00:00:00' and t_time<='2019-12-06 18:05:53' and shopname='十堰华思信息科技' and manager_id =8 ) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:58+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/dianpufx/getjiaoban [运行时间：0.109378s] [吞吐率：9.14req/s] [内存消耗：2,489.55kb] [文件加载：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' => '87', '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=1574677652,1574819873,1575015463,1575252486; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'stime' => '2019-12-06 00:00:00', 'etime' => '2019-12-06 18:05:53', '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.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_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-12-06 00:00:00' and t_time<='2019-12-06 18:05:53' and shopname='分店' and manager_id =8 GROUP BY c_change_type [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:05:58+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/dianpufx/getjiaobanzfmx [运行时间：0.109378s] [吞吐率：9.14req/s] [内存消耗：2,490.73kb] [文件加载：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' => '87', '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=1574677652,1574819873,1575015463,1575252486; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'stime' => '2019-12-06 00:00:00', 'etime' => '2019-12-06 18:05:53', '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.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 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-12-06 00:00:00' and t_time<='2019-12-06 18:05:53' and shopname='分店' and manager_id =8 ) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-12-06T18:06:03+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/dianpufx/getjiaoban [运行时间：0.093752s] [吞吐率：10.67req/s] [内存消耗：2,491.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 => '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=1574677652,1574819873,1575015463,1575252486; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'stime' => '2019-01-01 00:00:00', 'etime' => '2019-12-06 18:06:02', '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.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_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-01-01 00:00:00' and t_time<='2019-12-06 18:06:02' and shopname='十堰华思信息科技' and manager_id =8 GROUP BY c_change_type [ RunTime:0.015625s ] --------------------------------------------------------------- [ 2019-12-06T18:06:03+08:00 ] 117.150.100.106 POST web.huasivip.com/api/public/index/dianpufx/getjiaobanzfmx [运行时间：0.109378s] [吞吐率：9.14req/s] [内存消耗：2,491.02kb] [文件加载：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=1574677652,1574819873,1575015463,1575252486; Admin-Token=f37a20d38049676a77388c8b333aacb6', ) [ info ] [ PARAM ] array ( 'stime' => '2019-01-01 00:00:00', 'etime' => '2019-12-06 18:06:02', '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.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 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-01-01 00:00:00' and t_time<='2019-12-06 18:06:02' and shopname='十堰华思信息科技' and manager_id =8 ) [ RunTime:0.000000s ]