--------------------------------------------------------------- [ 2020-03-26T08:16:04+08:00 ] 101.132.185.22 OPTIONS webest.leaper.ltd:8084/public/v1/staffToken [运行时间:0.049679s] [吞吐率:20.13req/s] [内存消耗:1,215.79kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/login', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:16:05+08:00 ] 101.132.185.22 POST webest.leaper.ltd:8084/public/v1/staffToken [运行时间:0.324374s] [吞吐率:3.08req/s] [内存消耗:3,245.20kb] [文件加载: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' => '292', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', '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.8', ) [ info ] [ PARAM ] array ( 'data' => '{"enStr":"ShUITfl6BrXrJXvBGqPF4fN7yPeo7kpS2q4VA0PAAAfl3uL8+MfBNcPaUnFHknLGpFb0t1DUg0ILxSSMeX/TamQro30ruSlXWZTtWWaZ3wu4jZ/YI93++GhQ+wc6WbOaj482gaYaWl2fZVVVFJlHdZnpdcKIHKsofOVabTHTGA4=","data":{"staffName":"ld","timestamp":1585181764}}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.040912s ] 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.051627s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Staff' [ RunTime:0.060394s ] [ 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.015585s ] [ 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.015586s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='role' [ RunTime:0.062342s ] [ 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.015585s ] --------------------------------------------------------------- [ 2020-03-26T08:16:06+08:00 ] 101.132.185.22 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间:0.017534s] [吞吐率:57.03req/s] [内存消耗:1,215.87kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:16:06+08:00 ] 101.132.185.22 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.022404s] [吞吐率:44.63req/s] [内存消耗:1,215.80kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:16:06+08:00 ] 101.132.185.22 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.203586s] [吞吐率:4.91req/s] [内存消耗:3,019.58kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjo4THhrZGF0NGJSWktKdjJOekdoSGwzdTFBZjVYOWc3WTpwY3M3dnFKWW40OFh6ZEtNRGZPeTNobTMydzViTjJUVw==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000975s ] 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.037015s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.045783s ] [ 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.023378s ] [ 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.049679s ] [ 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.005844s ] --------------------------------------------------------------- [ 2020-03-26T08:16:06+08:00 ] 101.132.185.22 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间:0.205535s] [吞吐率:4.87req/s] [内存消耗:3,091.36kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjo4THhrZGF0NGJSWktKdjJOekdoSGwzdTFBZjVYOWc3WTpwY3M3dnFKWW40OFh6ZEtNRGZPeTNobTMydzViTjJUVw==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', '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.8', ) [ info ] [ PARAM ] array ( 'cusName' => '', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.075979s ] 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.021431s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.052601s ] [ 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.006819s ] --------------------------------------------------------------- [ 2020-03-26T08:16:11+08:00 ] 101.132.185.22 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间:0.024353s] [吞吐率:41.06req/s] [内存消耗:1,215.84kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:16:11+08:00 ] 101.132.185.22 POST webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间:0.076954s] [吞吐率:12.99req/s] [内存消耗:3,095.41kb] [文件加载:75] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getFilterData', 'route' => 'api/v1.backStage/getFilterData', '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' => '317', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjo4THhrZGF0NGJSWktKdjJOekdoSGwzdTFBZjVYOWc3WTpwY3M3dnFKWW40OFh6ZEtNRGZPeTNobTMydzViTjJUVw==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"","demandStatus":["0","1"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":["0","1","2","3"],"curPage":1,"keyWorld":"","keyType":["1"]}', '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.003897s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.003896s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [id] desc) AS ROW_NUMBER FROM (SELECT [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [d].[demand_status] IN ('0','1') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.012664s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [d].[demand_status] IN ('0','1') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.004871s ] --------------------------------------------------------------- [ 2020-03-26T08:17:11+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/staffToken [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.65kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/login', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:17:12+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/staffToken [运行时间:0.077927s] [吞吐率:12.83req/s] [内存消耗:3,245.20kb] [文件加载: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' => '292', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', '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.8', ) [ info ] [ PARAM ] array ( 'data' => '{"enStr":"fwA7MPSyEcTxht2wVA5sxxJdbt/p1GaGgg7rivixAPRl7Shk/XTTQyOzfCUFpIU2zVxXFuTfri+7tjTKGspz2yQNSbw1Ba2EY99GOVOhU3Gh8swILsYln/HhWBXuvS1ek7dRUeR4IhFUZXQZiWXmBqwOjMektyMqXwKqhY4CtuU=","data":{"staffName":"ld","timestamp":1585181826}}', '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 = 'Staff' [ RunTime:0.015585s ] [ 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.000000s ] [ 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.015585s ] --------------------------------------------------------------- [ 2020-03-26T08:17:12+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间:0.015585s] [吞吐率:64.16req/s] [内存消耗:1,215.68kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', '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.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:17:12+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.015586s] [吞吐率:64.16req/s] [内存消耗:1,215.70kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', '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.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:17:12+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间:0.062342s] [吞吐率:16.04req/s] [内存消耗:3,091.36kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjpmN2hSSkR1M0djOFg2VG90QUNpSG55dmtleDJFU3c1STpZMXEza0RBd3p0dmhJajBYSFo5SzdiU2RSMTI4YzNUcw==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', '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.8', ) [ info ] [ PARAM ] array ( 'cusName' => '', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.015586s ] 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.000000s ] [ 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 ] --------------------------------------------------------------- [ 2020-03-26T08:17:12+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.077927s] [吞吐率:12.83req/s] [内存消耗:3,019.58kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjpmN2hSSkR1M0djOFg2VG90QUNpSG55dmtleDJFU3c1STpZMXEza0RBd3p0dmhJajBYSFo5SzdiU2RSMTI4YzNUcw==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ 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.000000s ] [ 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.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] = 2) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2020-03-26T08:25:13+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/staffToken [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.77kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/login', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:13+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/staffToken [运行时间:0.125658s] [吞吐率:7.96req/s] [内存消耗:3,245.20kb] [文件加载: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' => '288', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', '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.8', ) [ info ] [ PARAM ] array ( 'data' => '{"enStr":"ZClFWGwBnZDlKCkxYu2gc84GTxbNZQDDVHeFiE/8Eyl3nYcXslWwg+QCaswjLda+MwN5I8IHnx6yvBg4uEKvvmCZaZOF2g4LfVoNSjtpN2HGpfNduvHubOmmkNialE2xt4AP04tyZixmNoMW8bF5uCfBulwl7RROdN5WABD2uYI=","data":{"staffName":"ld","timestamp":1585182387}}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.032145s ] 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.000000s ] [ 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.015585s ] [ 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.000000s ] [ 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 ] --------------------------------------------------------------- [ 2020-03-26T08:25:14+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间:0.015586s] [吞吐率:64.16req/s] [内存消耗:1,215.87kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:14+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.80kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:14+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.120788s] [吞吐率:8.28req/s] [内存消耗:3,019.58kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ 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.000000s ] [ 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.031171s ] [ 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.005845s ] [ 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.020456s ] --------------------------------------------------------------- [ 2020-03-26T08:25:14+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间:0.136373s] [吞吐率:7.33req/s] [内存消耗:3,091.36kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', '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.8', ) [ info ] [ PARAM ] array ( 'cusName' => '', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.074031s ] 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.015585s ] [ 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.000000s ] --------------------------------------------------------------- [ 2020-03-26T08:25:16+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/buildOrderNum [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.90kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/demand', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:16+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/buildOrderNum [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,744.97kb] [文件加载:61] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/buildOrderNum', 'route' => 'api/v1.backStage/buildOrderNum', '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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) --------------------------------------------------------------- [ 2020-03-26T08:25:18+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.80kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:18+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.095461s] [吞吐率:10.48req/s] [内存消耗:3,019.58kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ 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.000000s ] [ 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.000974s ] [ 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.032145s ] --------------------------------------------------------------- [ 2020-03-26T08:25:18+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/analystsList [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.91kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/analist', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:18+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/analystsList [运行时间:0.077927s] [吞吐率:12.83req/s] [内存消耗:3,081.41kb] [文件加载:75] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/analystsList', 'route' => 'api/v1.backStage/analystsList', '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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/analist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ 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.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.015586s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [id] DESC) AS ROW_NUMBER FROM (SELECT [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [d].[demand_status] = '0') AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2020-03-26T08:25:20+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.80kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:20+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.075006s] [吞吐率:13.33req/s] [内存消耗:3,019.58kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ 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.003897s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.002922s ] [ 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.008767s ] [ 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.005845s ] [ 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.005845s ] --------------------------------------------------------------- [ 2020-03-26T08:25:21+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/modList [运行时间:0.015586s] [吞吐率:64.16req/s] [内存消耗:1,215.74kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/modlist', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:21+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/modList [运行时间:0.062342s] [吞吐率:16.04req/s] [内存消耗:3,088.41kb] [文件加载:75] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/modList', 'route' => 'api/v1.backStage/modList', '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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/modlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ 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.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.015585s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [id] DESC) AS ROW_NUMBER FROM (SELECT [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [d].[demand_status] = '1') AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2020-03-26T08:25:22+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.80kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:23+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.093513s] [吞吐率:10.69req/s] [内存消耗:3,019.58kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ 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.015586s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ 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] = 0) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015586s ] [ 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.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] = 2) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2020-03-26T08:25:23+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间:0.020456s] [吞吐率:48.89req/s] [内存消耗:1,215.92kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:23+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间:0.077927s] [吞吐率:12.83req/s] [内存消耗:3,307.80kb] [文件加载:77] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/testList', 'route' => 'api/v1.backStage/testList', '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' => '15', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'demand_belong' => '0', '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.000000s ] [ 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 [id] DESC) AS ROW_NUMBER FROM (SELECT [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [analysts_id] = 6 AND [d].[demand_status] = '2') AS thinkphp) AS T1 [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2020-03-26T08:25:26+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.92kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:26+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间:0.077927s] [吞吐率:12.83req/s] [内存消耗:3,277.16kb] [文件加载:77] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/testList', 'route' => 'api/v1.backStage/testList', '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' => '15', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'demand_belong' => '1', '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.000000s ] [ 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 [id] DESC) AS ROW_NUMBER FROM (SELECT [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [analysts_id] <> 6 AND [d].[demand_status] = '2') AS thinkphp) AS T1 [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2020-03-26T08:25:28+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.80kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:28+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.077927s] [吞吐率:12.83req/s] [内存消耗:3,019.58kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ 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.000000s ] [ 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.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] = 2) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2020-03-26T08:25:30+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.83kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:30+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间:0.110072s] [吞吐率:9.08req/s] [内存消耗:3,082.23kb] [文件加载:77] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/echartData', 'route' => 'api/v1.backStage/echartData', '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' => '191', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => 'TBdU1ppjpjGG58+AVmgy3FF0IXQjWyxD2k/ImaUWanhKRZ+/YCUNtb5b+l4fXizGGUICkHeo1zTy4X79BQ/oECm/aWBgOVEGc/X/vB4IOQSd5Cf3g53w2sC8X+mgV/2+VuQAoV4wySUMUIZdpDWP17akvQzMXjBSe8t4ojd+Z9A=', '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.000000s ] [ 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 [TOTAL] DESC) AS ROW_NUMBER FROM (SELECT c.propose_cus AS propose_cus,COUNT(d.id) AS Total,SUM(CASE WHEN is_major_mod = 1 THEN 1 ELSE 0 end) AS IsMajor FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] WHERE [propose_time] LIKE '2019%' GROUP BY [propose_cus]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10) [ RunTime:0.046756s ] --------------------------------------------------------------- [ 2020-03-26T08:25:38+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.024353s] [吞吐率:41.06req/s] [内存消耗:1,215.80kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:38+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.077927s] [吞吐率:12.83req/s] [内存消耗:3,019.58kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ 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.015586s ] [ 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 ] --------------------------------------------------------------- [ 2020-03-26T08:25:48+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间:0.015586s] [吞吐率:64.16req/s] [内存消耗:1,215.84kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:48+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间:0.080850s] [吞吐率:12.37req/s] [内存消耗:3,095.41kb] [文件加载:75] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getFilterData', 'route' => 'api/v1.backStage/getFilterData', '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' => '317', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"","demandStatus":["0","1"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":["0","1","2","3"],"curPage":1,"keyWorld":"","keyType":["1"]}', '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 [id] desc) AS ROW_NUMBER FROM (SELECT [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [d].[demand_status] IN ('0','1') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.015586s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [d].[demand_status] IN ('0','1') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2020-03-26T08:25:54+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间:0.015586s] [吞吐率:64.16req/s] [内存消耗:1,215.84kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:54+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间:0.077927s] [吞吐率:12.83req/s] [内存消耗:3,095.41kb] [文件加载:75] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getFilterData', 'route' => 'api/v1.backStage/getFilterData', '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' => '317', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"","demandStatus":["0","1"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":["0","1","2","3"],"curPage":1,"keyWorld":"","keyType":["1"]}', '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.000000s ] [ 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 [id] desc) AS ROW_NUMBER FROM (SELECT [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [d].[demand_status] IN ('0','1') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ 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] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [d].[demand_status] IN ('0','1') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2020-03-26T08:25:55+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间:0.015586s] [吞吐率:64.16req/s] [内存消耗:1,215.87kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:55+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.046756s] [吞吐率:21.39req/s] [内存消耗:1,215.80kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:55+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间:0.062342s] [吞吐率:16.04req/s] [内存消耗:3,091.36kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', '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.8', ) [ 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.000000s ] [ 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 ] --------------------------------------------------------------- [ 2020-03-26T08:25:55+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.077927s] [吞吐率:12.83req/s] [内存消耗:3,019.58kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ 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.015586s ] [ 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 ] --------------------------------------------------------------- [ 2020-03-26T08:25:58+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.84kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:25:58+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间:0.062342s] [吞吐率:16.04req/s] [内存消耗:3,095.41kb] [文件加载:75] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getFilterData', 'route' => 'api/v1.backStage/getFilterData', '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' => '317', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"","demandStatus":["0","1"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":["0","1","2","3"],"curPage":1,"keyWorld":"","keyType":["1"]}', '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.015586s ] [ 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 [id] desc) AS ROW_NUMBER FROM (SELECT [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [d].[demand_status] IN ('0','1') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ 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] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE [d].[demand_status] IN ('0','1') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2020-03-26T08:34:36+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间:0.015586s] [吞吐率:64.16req/s] [内存消耗:1,215.87kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication, content-type', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:34:36+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.015586s] [吞吐率:64.16req/s] [内存消耗:1,215.80kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:34:36+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间:0.093512s] [吞吐率:10.69req/s] [内存消耗:3,091.36kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', '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.8', ) [ info ] [ PARAM ] array ( 'cusName' => '', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.015585s ] 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.000000s ] --------------------------------------------------------------- [ 2020-03-26T08:34:36+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间:0.187998s] [吞吐率:5.32req/s] [内存消耗:3,019.58kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.063315s ] 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.046756s ] [ 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.015586s ] [ 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.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] = 2) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2020-03-26T08:34:49+08:00 ] 115.216.121.39 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/buildOrderNum [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,215.90kb] [文件加载: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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'accept, authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/demand', 'accept-encoding' => 'gzip, deflate, sdch', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2020-03-26T08:34:49+08:00 ] 115.216.121.39 POST webest.leaper.ltd:8084/public/v1/backStage/buildOrderNum [运行时间:0.031171s] [吞吐率:32.08req/s] [内存消耗:1,744.97kb] [文件加载:61] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/buildOrderNum', 'route' => 'api/v1.backStage/buildOrderNum', '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', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjphbzI5cDEwUGV3SUVUOEpnZGN1QzRyUVZrSEcxQmlBeTo4MmZMRE5rTUU5WjRuMzZkSHFwQllzNzZDOUZ1YmlJdA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://webest.leaper.ltd:8087/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'version' => 'v1', )