--------------------------------------------------------------- [ 2019-07-03T11:22:09+08:00 ] 60.177.220.201 OPTIONS webest.leaper.ltd:8084/public/v1/staffToken [运行时间：0.031171s] [吞吐率：32.08req/s] [内存消耗：1,215.15kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/login', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-03T11:22:09+08:00 ] 60.177.220.201 POST webest.leaper.ltd:8084/public/v1/staffToken [运行时间：0.148061s] [吞吐率：6.75req/s] [内存消耗：3,244.66kb] [文件加载：77] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/staffToken', 'route' => 'api/v1.token/staffToken', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '302', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/login', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'data' => '{"enStr":"ODFoBLzL+TJeoG2+uw9ddUVKOVhHzBrD3uI/2cLjtwot8+TYu8+yr4kOldzGixrOe8veLOzXFAup8B2wuWL+molSnfC+ShEurw80nvQrWFk73C5XpDb8Gtv0qtJ10bREKEjhWpPm92Qxm7+Sd+Trg6YpFKWcvIOJhvneYxviqVI=","data":{"staffName":"LD","timestamp":1562124125}}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.018508s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'Staff' [ RunTime:0.054549s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Staff' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [id],[role],[staff_realname] FROM [Staff] WHERE [staff_name] = 'LD' AND [staff_pwd] = '123456') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'role' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='role' [ RunTime:0.015585s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [url],[actions] FROM [role] WHERE [role_name] IN ('admin')) AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-03T11:22:09+08:00 ] 60.177.220.201 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.27kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-03T11:22:09+08:00 ] 60.177.220.201 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.031171s] [吞吐率：32.08req/s] [内存消耗：1,215.16kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-03T11:22:09+08:00 ] 60.177.220.201 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,090.79kb] [文件加载：75] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/bulidCustomer', 'route' => 'api/v1.backStage/bulidCustomer', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '8', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjpTSXFXdTZPVHQ5eTZVM25OUXdlRDNWNWJYUDJZN0pyQTpUN1A0V0pBNkY0dUxPNWRDUmxZMVY4ZUR6NXNmZ1FtMw==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'cusName' => '', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'Customer' [ RunTime:0.015586s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer]) AS thinkphp) AS T1 [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2019-07-03T11:22:09+08:00 ] 60.177.220.201 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.077926s] [吞吐率：12.83req/s] [内存消耗：3,019.03kb] [文件加载：73] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getAuthUrl', 'route' => 'api/v1.backStage/getAuthUrl', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjpTSXFXdTZPVHQ5eTZVM25OUXdlRDNWNWJYUDJZN0pyQTpUN1A0V0pBNkY0dUxPNWRDUmxZMVY4ZUR6NXNmZ1FtMw==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'demandtable' [ RunTime:0.015585s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [demandtable] WHERE [demand_status] = 0) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [demandtable] WHERE [demand_status] = 1) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015585s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [demandtable] WHERE [demand_status] = 2) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]