--------------------------------------------------------------- [ 2019-07-01T08:17:47+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/staffToken [运行时间：0.017534s] [吞吐率：57.03req/s] [内存消耗：1,215.17kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/login', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:17:47+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/staffToken [运行时间：0.093511s] [吞吐率：10.69req/s] [内存消耗：3,244.55kb] [文件加载：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' => '289', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/login', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'data' => '{"enStr":"UuKyJbphpzsgRL0CqJvu8A8uCr3u1T31R6WhbOI+VTguuNdryoqOjP8xLfgIGw+eh8qV9bxvAvHv29Frc9PdlCnIxtKCUxtU2H69rihqHRFJr3Qzevy9qVZvQg1xi0CrGhLN15ZuGyaTVD9cXuvHXLExO0wnE45nCA6PSJEiUFY=","data":{"staffName":"MWJ","timestamp":1561940266}}', '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 = 'Staff' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Staff' [ RunTime:0.015585s ] [ 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] = 'MWJ' AND [staff_pwd] = '123456') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'role' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='role' [ RunTime:0.015585s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [url],[actions] FROM [role] WHERE [role_name] IN ('admin')) AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:17:48+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,215.27kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:17:48+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.16kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:17:48+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,090.79kb] [文件加载：75] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/bulidCustomer', 'route' => 'api/v1.backStage/bulidCustomer', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '8', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'cusName' => '', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'Customer' [ RunTime:0.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.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:17:48+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.077926s] [吞吐率：12.83req/s] [内存消耗：3,019.09kb] [文件加载：73] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getAuthUrl', 'route' => 'api/v1.backStage/getAuthUrl', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.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 = '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.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 ] --------------------------------------------------------------- [ 2019-07-01T08:17:53+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/analystsList [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.27kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/analist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:17:53+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/analystsList [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,080.66kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'referer' => 'http://webest.leaper.ltd:8087/common/analist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'demandtable' [ RunTime:0.015585s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [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.015585s ] --------------------------------------------------------------- [ 2019-07-01T08:17:59+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.16kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:17:59+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.111044s] [吞吐率：9.01req/s] [内存消耗：3,019.09kb] [文件加载：73] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getAuthUrl', 'route' => 'api/v1.backStage/getAuthUrl', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'demandtable' [ RunTime:0.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.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.046755s ] --------------------------------------------------------------- [ 2019-07-01T08:18:00+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/modList [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.22kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/modlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:00+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/modList [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,087.70kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'referer' => 'http://webest.leaper.ltd:8087/common/modlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'demandtable' [ RunTime:0.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] = '1') AS thinkphp) AS T1 [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2019-07-01T08:18:10+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/modList [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.22kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/modlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:10+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/modList [运行时间：0.046755s] [吞吐率：21.39req/s] [内存消耗：3,087.70kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'referer' => 'http://webest.leaper.ltd:8087/common/modlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'demandtable' [ RunTime:0.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] = '1') AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:18:11+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.16kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:12+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,019.09kb] [文件加载：73] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getAuthUrl', 'route' => 'api/v1.backStage/getAuthUrl', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'demandtable' [ RunTime:0.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.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 ] --------------------------------------------------------------- [ 2019-07-01T08:18:13+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间：0.033119s] [吞吐率：30.19req/s] [内存消耗：1,215.22kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:13+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间：0.062340s] [吞吐率：16.04req/s] [内存消耗：3,272.45kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ 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.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 [analysts_id] = 1 AND [d].[demand_status] = '2') AS thinkphp) AS T1 [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2019-07-01T08:18:16+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间：0.062340s] [吞吐率：16.04req/s] [内存消耗：3,310.73kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ 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.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 [analysts_id] <> 1 AND [d].[demand_status] = '2') AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:18:21+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.22kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:21+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间：0.077926s] [吞吐率：12.83req/s] [内存消耗：3,272.45kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ 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.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 [analysts_id] = 1 AND [d].[demand_status] = '2') AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:18:23+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,310.73kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ 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] <> 1 AND [d].[demand_status] = '2') AS thinkphp) AS T1 [ RunTime:0.015586s ] --------------------------------------------------------------- [ 2019-07-01T08:18:28+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.22kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:28+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/testList [运行时间：0.062340s] [吞吐率：16.04req/s] [内存消耗：3,310.73kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/tlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ 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] <> 1 AND [d].[demand_status] = '2') AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:18:32+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.031171s] [吞吐率：32.08req/s] [内存消耗：1,215.25kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:32+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.065263s] [吞吐率：15.32req/s] [内存消耗：3,094.80kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ 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.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 ] --------------------------------------------------------------- [ 2019-07-01T08:18:33+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.27kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:33+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.031170s] [吞吐率：32.08req/s] [内存消耗：1,215.16kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:33+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,090.79kb] [文件加载：75] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/bulidCustomer', 'route' => 'api/v1.backStage/bulidCustomer', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '8', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'cusName' => '', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'Customer' [ RunTime:0.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 ] --------------------------------------------------------------- [ 2019-07-01T08:18:33+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.077926s] [吞吐率：12.83req/s] [内存消耗：3,019.09kb] [文件加载：73] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getAuthUrl', 'route' => 'api/v1.backStage/getAuthUrl', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'demandtable' [ RunTime:0.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.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] = 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.015586s ] --------------------------------------------------------------- [ 2019-07-01T08:18:35+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,215.16kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:35+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.064289s] [吞吐率：15.55req/s] [内存消耗：3,081.66kb] [文件加载：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' => '187', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'data' => 'IpOm6ZdCWq+zJ9B2c/IovBF/9NUQu9titsSAetzgNpijH1Mci9Bwwd1HhdSgTa9+VOZMpPSK0PJzevU4x42vJGNZwExew0jpfKJe1ZxmNq8B5pM4fmntkM7FZzEtLBoDUmyHY6fM7fI46UpHeDESlc97T3BJYJoSfU5ZbkXcaRo=', '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.000974s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.016559s ] [ 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.015585s ] --------------------------------------------------------------- [ 2019-07-01T08:18:41+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.16kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:41+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.062340s] [吞吐率：16.04req/s] [内存消耗：3,077.00kb] [文件加载：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' => '195', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'data' => 'MSuv9w9/IWH20GKCl6uPXX2Ebl0dHTbzZ2GILVYayv+2DWv9PH5mFSWnpYlJlqXiR4kt6PK+SLkL/dbv1+LPkADCD8Pi8V1oY3E/tKvNjh5UbPHxP+ld6zUxyx/891u6nkJ25QuP8Dqy4EyR0zPdCQUY6TrLSOAu75Nxy0xGRoU=', '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 [OrderMonth] ASC) AS ROW_NUMBER FROM (SELECT DATEPART(mm,propose_time) AS OrderMonth,COUNT(id) AS Total,SUM(CASE WHEN is_major_mod = 1 THEN 1 ELSE 0 end) AS IsMajor FROM [demandtable] WHERE [propose_time] LIKE '2019%' GROUP BY DATEPART(mm,propose_time)) AS thinkphp) AS T1 [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2019-07-01T08:18:49+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/ecahrtDetail [运行时间：0.031170s] [吞吐率：32.08req/s] [内存消耗：1,215.27kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/viewDetail', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:49+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/ecahrtDetail [运行时间：0.077926s] [吞吐率：12.83req/s] [内存消耗：3,336.45kb] [文件加载：78] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/ecahrtDetail', 'route' => 'api/v1.backStage/ecahrtDetail', '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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/viewDetail', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'data' => 'QNh34shj6JJTdpkWLADm4imZGjJv5hj+9HTU1eTlmSQ2OiQ49IlbfIaeClS/LU5YqGslF8d7519jogTK/veeO56zItRP+yLB647D/qjs5taa5NDA2yH16V/Z25AbJz2zkJTyidvaMj0Uk7Ob9kTQRgM9dHaiCTMxKsG2VmOMcok=', '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 [propose_time] LIKE '2019-06%') AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:18:55+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/ecahrtDetail [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,215.27kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/viewDetail', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:18:55+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/ecahrtDetail [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,336.45kb] [文件加载：78] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/ecahrtDetail', 'route' => 'api/v1.backStage/ecahrtDetail', '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' => '189', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/viewDetail', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'data' => 'HFUPyo9m57WTSAwcxvO5wiUMiDKYvjpI9VXIDjrFiQhU3ge87bhJUZxBSLExNSw/V4l43nUmiJqdZnTXT09MH5pz07IUADuFofN/hVg6lGFMQV7v5tUlJ4xwG8BBa4kWoj/RDJKCZDp5nIPD3q8xiuuZ/ivQAeIyYR1Ytd+AGUA=', '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 [propose_time] LIKE '2019-06%') AS thinkphp) AS T1 [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2019-07-01T08:19:02+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/ecahrtDetail [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.27kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/viewDetail', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:19:02+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/ecahrtDetail [运行时间：0.079875s] [吞吐率：12.52req/s] [内存消耗：3,307.26kb] [文件加载：78] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/ecahrtDetail', 'route' => 'api/v1.backStage/ecahrtDetail', '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' => '183', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/viewDetail', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'data' => 'P7/d1V9SlXdJZaVk74EpMKRWwhdMgAHWrl42AsKpRd5pixiczMs1juxcv6g93g0PjRvlD49zVEZOK5sjChJEqlTXoPWS0EjqSVZNZbdPQl26g8a3cWIac1fELJ+RWC4O4JmXGeV90yNicJtR68jcxV6qyPhfvPq38Kh3T1E9w14=', '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 [c].[propose_cus] = '内部需求' AND [propose_time] LIKE '2019%') AS thinkphp) AS T1 [ RunTime:0.033119s ] --------------------------------------------------------------- [ 2019-07-01T08:19:26+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/ecahrtDetail [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,215.27kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/viewDetail', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:19:26+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/ecahrtDetail [运行时间：0.093511s] [吞吐率：10.69req/s] [内存消耗：3,286.09kb] [文件加载：78] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/ecahrtDetail', 'route' => 'api/v1.backStage/ecahrtDetail', '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' => '193', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/common/viewDetail', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'data' => 'XATjwcbKgs1+ZVsqJR//EsSs6HDlRCpJY/2Num3cYhghdsemy2h5uiHu9q/PizIN3YyMG1f0oIBjYzgQS37UcmxMyUZ6YiBftRk+RtkkeWMJfbK98cMZoNLe8PIYwRa8wOh1WnmSV0jupocWQb8ezXWaFqQEEJeDnVJ7dMC+XLw=', '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.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 [c].[propose_cus] = '江阴要塞' AND [propose_time] LIKE '2019%') AS thinkphp) AS T1 [ RunTime:0.015585s ] --------------------------------------------------------------- [ 2019-07-01T08:20:13+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.031171s] [吞吐率：32.08req/s] [内存消耗：1,215.16kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:20:14+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.077926s] [吞吐率：12.83req/s] [内存消耗：3,019.09kb] [文件加载：73] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getAuthUrl', 'route' => 'api/v1.backStage/getAuthUrl', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'demandtable' [ RunTime:0.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.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 ] --------------------------------------------------------------- [ 2019-07-01T08:20:14+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.25kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:20:14+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,094.80kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjprNkw3eGVXWXBWYzR1NU9qbXFVZkhKbFpQTjlzN0JoQTpXdFQ5eGZuSWdGQWhwVThtdzFFN3JMOUhqN2tvWlBYeQ==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://webest.leaper.ltd:8087/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ 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.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.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:20:43+08:00 ] 223.104.246.108 OPTIONS webest.leaper.ltd:8084/public/v1/staffToken [运行时间：0.031171s] [吞吐率：32.08req/s] [内存消耗：1,215.50kb] [文件加载：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', 'origin' => 'http://webest.leaper.ltd:8087', 'access-control-request-method' => 'POST', 'content-length' => '0', 'access-control-request-headers' => 'authentication', 'connection' => 'keep-alive', 'accept' => '*/*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/login', 'accept-language' => 'zh-cn', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:20:44+08:00 ] 223.104.246.108 POST webest.leaper.ltd:8084/public/v1/staffToken [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,244.75kb] [文件加载：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', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'origin' => 'http://webest.leaper.ltd:8087', 'accept-encoding' => 'gzip, deflate', 'connection' => 'keep-alive', 'authentication' => 'userInfo', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/login', 'content-length' => '297', 'accept-language' => 'zh-cn', ) [ info ] [ PARAM ] array ( 'data' => '{"enStr":"B3PvlPR8mde6m0+L8qw3bIA/WbrKbKdoICLzvZqQVEXrx3Uhh6010pd6k9ljXHYt4iQIipJUjEsz9aPNTdmVL78l7gmuLK4eMZVCH2jTSq5U5bzFpUX/JihcqwRe/Pv2uliR3YDPLP5TP20xjTbdyoja0nmgIdeD2++ju6Fl58Q=","data":{"staffName":"mwj","timestamp":1561940441}}', '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] = 'mwj' 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.015586s ] [ 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 ] --------------------------------------------------------------- [ 2019-07-01T08:20:44+08:00 ] 223.104.246.108 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,215.62kb] [文件加载：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', 'origin' => 'http://webest.leaper.ltd:8087', 'access-control-request-method' => 'POST', 'content-length' => '0', 'access-control-request-headers' => 'authentication', 'connection' => 'keep-alive', 'accept' => '*/*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-language' => 'zh-cn', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:20:44+08:00 ] 223.104.246.108 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.52kb] [文件加载：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', 'origin' => 'http://webest.leaper.ltd:8087', 'access-control-request-method' => 'POST', 'content-length' => '0', 'access-control-request-headers' => 'authentication', 'connection' => 'keep-alive', 'accept' => '*/*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-language' => 'zh-cn', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:20:44+08:00 ] 223.104.246.108 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.046756s] [吞吐率：21.39req/s] [内存消耗：3,091.02kb] [文件加载：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', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'origin' => 'http://webest.leaper.ltd:8087', 'accept-encoding' => 'gzip, deflate', 'connection' => 'keep-alive', 'authentication' => 'userInfo anBkbjpqZ2FBRzFPM1A0bVc3NFN5OGh0MVR2MndOVTJxSjhrYzpPUUN6anRzNTJFVGI2TEhZMzhXOXZBdzhwVTdmU203Wg==', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'content-length' => '8', 'accept-language' => 'zh-cn', ) [ 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.015585s ] [ 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 ] --------------------------------------------------------------- [ 2019-07-01T08:20:44+08:00 ] 223.104.246.108 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,019.19kb] [文件加载：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', 'origin' => 'http://webest.leaper.ltd:8087', 'content-length' => '0', 'connection' => 'keep-alive', 'authentication' => 'userInfo anBkbjpqZ2FBRzFPM1A0bVc3NFN5OGh0MVR2MndOVTJxSjhrYzpPUUN6anRzNTJFVGI2TEhZMzhXOXZBdzhwVTdmU203Wg==', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-language' => 'zh-cn', 'accept-encoding' => 'gzip, deflate', ) [ 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.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] = 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.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:20:47+08:00 ] 223.104.246.108 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.033119s] [吞吐率：30.19req/s] [内存消耗：1,215.53kb] [文件加载：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', 'origin' => 'http://webest.leaper.ltd:8087', 'access-control-request-method' => 'POST', 'content-length' => '0', 'access-control-request-headers' => 'authentication', 'connection' => 'keep-alive', 'accept' => '*/*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-language' => 'zh-cn', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:20:47+08:00 ] 223.104.246.108 POST webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.077926s] [吞吐率：12.83req/s] [内存消耗：3,081.85kb] [文件加载：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', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'origin' => 'http://webest.leaper.ltd:8087', 'accept-encoding' => 'gzip, deflate', 'connection' => 'keep-alive', 'authentication' => 'userInfo anBkbjpqZ2FBRzFPM1A0bVc3NFN5OGh0MVR2MndOVTJxSjhrYzpPUUN6anRzNTJFVGI2TEhZMzhXOXZBdzhwVTdmU203Wg==', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'content-length' => '187', 'accept-language' => 'zh-cn', ) [ info ] [ PARAM ] array ( 'data' => 'Z44MrPFGpoKZ/psPrBj0TRpjWBDp3xdIOiV1xgqubNpeRSRDbw6KEJ04mkwquJJqDo3Uib6rgh0sJfZezB5470ux9NleJ6ceOBgPmohSQ/oF6cLfjCLXH+n5JpvbU0lgR6TnRTVdr5E72+NWuV7zSVT3vxaq9HaHGyMrbprriBw=', '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 [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.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:20:53+08:00 ] 223.104.246.108 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.53kb] [文件加载：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', 'origin' => 'http://webest.leaper.ltd:8087', 'access-control-request-method' => 'POST', 'content-length' => '0', 'access-control-request-headers' => 'authentication', 'connection' => 'keep-alive', 'accept' => '*/*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-language' => 'zh-cn', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:20:53+08:00 ] 223.104.246.108 POST webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.062341s] [吞吐率：16.04req/s] [内存消耗：3,077.45kb] [文件加载：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', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'origin' => 'http://webest.leaper.ltd:8087', 'accept-encoding' => 'gzip, deflate', 'connection' => 'keep-alive', 'authentication' => 'userInfo anBkbjpqZ2FBRzFPM1A0bVc3NFN5OGh0MVR2MndOVTJxSjhrYzpPUUN6anRzNTJFVGI2TEhZMzhXOXZBdzhwVTdmU203Wg==', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'content-length' => '189', 'accept-language' => 'zh-cn', ) [ info ] [ PARAM ] array ( 'data' => 'QL5U+6xVfV1M7dqkITMty+Sg/GfFtNtkoPGs9hxzzmQrUcUWcY60/BZlGXHwTA6TXMLU/DWIYXACGw7E6RRxy5kkkxftSkoGfjuvyWBKx7AC31UtLXN5VpwHgJ0p9v2S6nFnJTqZk5ViAAyCftv5Fjps4NZiBsOa3t23ZCZZulU=', '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 [OrderMonth] ASC) AS ROW_NUMBER FROM (SELECT DATEPART(mm,propose_time) AS OrderMonth,COUNT(id) AS Total,SUM(CASE WHEN is_major_mod = 1 THEN 1 ELSE 0 end) AS IsMajor FROM [demandtable] WHERE [propose_time] LIKE '2019%' GROUP BY DATEPART(mm,propose_time)) AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:21:02+08:00 ] 223.104.246.108 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.53kb] [文件加载：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', 'origin' => 'http://webest.leaper.ltd:8087', 'access-control-request-method' => 'POST', 'content-length' => '0', 'access-control-request-headers' => 'authentication', 'connection' => 'keep-alive', 'accept' => '*/*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-language' => 'zh-cn', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:21:02+08:00 ] 223.104.246.108 POST webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.046756s] [吞吐率：21.39req/s] [内存消耗：3,075.51kb] [文件加载：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', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'origin' => 'http://webest.leaper.ltd:8087', 'accept-encoding' => 'gzip, deflate', 'connection' => 'keep-alive', 'authentication' => 'userInfo anBkbjpqZ2FBRzFPM1A0bVc3NFN5OGh0MVR2MndOVTJxSjhrYzpPUUN6anRzNTJFVGI2TEhZMzhXOXZBdzhwVTdmU203Wg==', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'content-length' => '183', 'accept-language' => 'zh-cn', ) [ info ] [ PARAM ] array ( 'data' => 'UqZpj6KfblDx7Ji0rg4NSbCdvKLUZiNVqPcfOgsB6Z/BuRBqchfRBwNibyv5enDxASKLkNgLvGoYidUT8qGJJGAJ8tm5nO04w3iPnMNWKo8UHNm00wmBZY49YR73UMXXLrDyd5PhmOoWZgPpe1bmZL5UHqY7UiUB+d61EvFLYKA=', '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 [OrderMonth] ASC) AS ROW_NUMBER FROM (SELECT DATEPART(mm,propose_time) AS OrderMonth,COUNT(id) AS Total,SUM(CASE WHEN is_major_mod = 1 THEN 1 ELSE 0 end) AS IsMajor FROM [demandtable] WHERE [propose_time] LIKE '2016%' GROUP BY DATEPART(mm,propose_time)) AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:21:06+08:00 ] 223.104.246.108 POST webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.046756s] [吞吐率：21.39req/s] [内存消耗：3,077.24kb] [文件加载：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', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'origin' => 'http://webest.leaper.ltd:8087', 'accept-encoding' => 'gzip, deflate', 'connection' => 'keep-alive', 'authentication' => 'userInfo anBkbjpqZ2FBRzFPM1A0bVc3NFN5OGh0MVR2MndOVTJxSjhrYzpPUUN6anRzNTJFVGI2TEhZMzhXOXZBdzhwVTdmU203Wg==', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'content-length' => '187', 'accept-language' => 'zh-cn', ) [ info ] [ PARAM ] array ( 'data' => 'oKgVEcbXk+Eewf5cmd2+8+O5medTsfbCn2yHgKr5TBf/0asUz3IaLNsOwvOVdKqhzxEgGwyBO8KT2OeFJjhv2GqugvCQ8hEd6UUxTr3J6UPjBETZpaCJkNmUiA7IBmW6t2k2IreeuqrQ2uSmrVef8qYAcUX1Wj4532yW3EeuU4M=', '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 [OrderMonth] ASC) AS ROW_NUMBER FROM (SELECT DATEPART(mm,propose_time) AS OrderMonth,COUNT(id) AS Total,SUM(CASE WHEN is_major_mod = 1 THEN 1 ELSE 0 end) AS IsMajor FROM [demandtable] WHERE [propose_time] LIKE '2018%' GROUP BY DATEPART(mm,propose_time)) AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T08:21:14+08:00 ] 223.104.246.108 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.015585s] [吞吐率：64.16req/s] [内存消耗：1,215.53kb] [文件加载：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', 'origin' => 'http://webest.leaper.ltd:8087', 'access-control-request-method' => 'POST', 'content-length' => '0', 'access-control-request-headers' => 'authentication', 'connection' => 'keep-alive', 'accept' => '*/*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-language' => 'zh-cn', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T08:21:14+08:00 ] 223.104.246.108 POST webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.072082s] [吞吐率：13.87req/s] [内存消耗：3,079.22kb] [文件加载：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', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'origin' => 'http://webest.leaper.ltd:8087', 'accept-encoding' => 'gzip, deflate', 'connection' => 'keep-alive', 'authentication' => 'userInfo anBkbjpqZ2FBRzFPM1A0bVc3NFN5OGh0MVR2MndOVTJxSjhrYzpPUUN6anRzNTJFVGI2TEhZMzhXOXZBdzhwVTdmU203Wg==', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.4(0x17000428) NetType/4G Language/zh_CN', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'content-length' => '193', 'accept-language' => 'zh-cn', ) [ info ] [ PARAM ] array ( 'data' => 'W68hzrC6A6FakpteyjRWRBHorxNbi9+naJ+PzggaSEm90sMCrrJ9s9HAVlPdjBpGFkaXsO7O9DomcM8rxGooLbCaonnm3VpUgt+HupqCs/CVsD2dF9A7qreIzoPCW+qh9XazXwPefyYL4sv+oBAsXran0LICeaGiMG7+GUtajfY=', '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.016560s ] [ 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 '2018%' GROUP BY [propose_cus]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 10) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T15:34:32+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/staffToken [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,216.03kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', '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,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T15:34:33+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/staffToken [运行时间：0.093514s] [吞吐率：10.69req/s] [内存消耗：3,245.35kb] [文件加载：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' => '299', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', '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,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( 'data' => '{"enStr":"uAIThMGc+88Vm/KMSD2vN9qRkZ10/1fZ0Uf+LSXw/fRpaXH+91VfsiDcmcSYMC5KxSvxnfj0ajWZLsly2YoDOPaIEoAuDff9QgSaDe0j/BHWTYxSNKzckDPnwbHmQk2ZMKvKsqkdfqfJLl9TS3G2rsgF6UqtVet99jYHZ4zzAi4=","data":{"staffName":"jcl","timestamp":1561966467}}', '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 = 'Staff' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Staff' [ RunTime:0.015586s ] [ 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] = 'jcl' 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.015586s ] [ 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 ('modifies')) AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T15:34:33+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,216.14kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', '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,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T15:34:33+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,216.13kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', '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,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T15:34:33+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.077929s] [吞吐率：12.83req/s] [内存消耗：3,091.50kb] [文件加载：75] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/bulidCustomer', 'route' => 'api/v1.backStage/bulidCustomer', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '8', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjo2YkNySUJrNDgzRjU5MVdsUHRtR2ZKdVVzOTF3TDdZTzpFUlZYQ0dUdmMzaXRaUWptSzFndWtTMGUyYUk3MTVZTw==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', '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,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( 'cusName' => '', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'Customer' [ RunTime:0.015586s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer]) AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T15:34:33+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.077929s] [吞吐率：12.83req/s] [内存消耗：3,017.50kb] [文件加载：73] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getAuthUrl', 'route' => 'api/v1.backStage/getAuthUrl', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjo2YkNySUJrNDgzRjU5MVdsUHRtR2ZKdVVzOTF3TDdZTzpFUlZYQ0dUdmMzaXRaUWptSzFndWtTMGUyYUk3MTVZTw==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( '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 = '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] = 1) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T15:34:34+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/modList [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,216.09kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/modlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T15:34:35+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/modList [运行时间：0.062343s] [吞吐率：16.04req/s] [内存消耗：3,088.48kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjo2YkNySUJrNDgzRjU5MVdsUHRtR2ZKdVVzOTF3TDdZTzpFUlZYQ0dUdmMzaXRaUWptSzFndWtTMGUyYUk3MTVZTw==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', 'referer' => 'http://webest.leaper.ltd:8087/common/modlist', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Server=rm-uf66kg1hxv4tt67p7o.sqlserver.rds.aliyuncs.com,3433;Database=demand2 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'demandtable' [ RunTime:0.015585s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [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 ] --------------------------------------------------------------- [ 2019-07-01T15:34:37+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.077928s] [吞吐率：12.83req/s] [内存消耗：3,017.50kb] [文件加载：73] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getAuthUrl', 'route' => 'api/v1.backStage/getAuthUrl', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjo2YkNySUJrNDgzRjU5MVdsUHRtR2ZKdVVzOTF3TDdZTzpFUlZYQ0dUdmMzaXRaUWptSzFndWtTMGUyYUk3MTVZTw==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8,en-US;q=0.6,en;q=0.5;q=0.4', ) [ 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] = 1) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T15:34:39+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,216.12kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T15:34:39+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.176313s] [吞吐率：5.67req/s] [内存消耗：3,082.37kb] [文件加载：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', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjo2YkNySUJrNDgzRjU5MVdsUHRtR2ZKdVVzOTF3TDdZTzpFUlZYQ0dUdmMzaXRaUWptSzFndWtTMGUyYUk3MTVZTw==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', '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,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( 'data' => 'ZNXug5nNp/6RqrEAJcOtCtnGfS4aA4jH9F2cYsBkd+GpLhDkicqgDNgWxuIVsyMab5MSvZVDDpFdN+ZDk6AIKBKAn2PtspIJzInMBMZmgwUhQsiX8+Ae84uOqvZCCjst7Og4X01PQ9U7JS1Lf+2V44msTEqObhPEd+Xhb3EJKjQ=', '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.077928s ] [ 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.016560s ] --------------------------------------------------------------- [ 2019-07-01T15:34:50+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.017534s] [吞吐率：57.03req/s] [内存消耗：1,216.12kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://webest.leaper.ltd:8087/common/echart', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T15:34:50+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/echartData [运行时间：0.084747s] [吞吐率：11.80req/s] [内存消耗：3,077.82kb] [文件加载：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' => '195', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjo2YkNySUJrNDgzRjU5MVdsUHRtR2ZKdVVzOTF3TDdZTzpFUlZYQ0dUdmMzaXRaUWptSzFndWtTMGUyYUk3MTVZTw==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', '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,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( 'data' => 'iKdq6v66pKKxUR1p+JQTxIgmi1AkJaE4rQi8XGn9FxebH1+PbHveDrOLow//sp6CioMXG0xwmNu4X/I+WPCZuP3SPYFEfvPWQ7luFz5Crzt0B0rEpNbDhwZ/C0LJdfHg8UGYRyQ4PEM7XS7gbXmGWk1vZKb+yW4Ho2Qz80BZVq8=', '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 [OrderMonth] ASC) AS ROW_NUMBER FROM (SELECT DATEPART(mm,propose_time) AS OrderMonth,COUNT(id) AS Total,SUM(CASE WHEN is_major_mod = 1 THEN 1 ELSE 0 end) AS IsMajor FROM [demandtable] WHERE [propose_time] LIKE '2019%' GROUP BY DATEPART(mm,propose_time)) AS thinkphp) AS T1 [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2019-07-01T15:35:59+08:00 ] 122.234.66.252 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.015586s] [吞吐率：64.16req/s] [内存消耗：1,216.13kb] [文件加载：47] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'access-control-request-method' => 'POST', 'origin' => 'http://webest.leaper.ltd:8087', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', '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,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-07-01T15:35:59+08:00 ] 122.234.66.252 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.564008s] [吞吐率：1.77req/s] [内存消耗：3,017.50kb] [文件加载：73] [ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/getAuthUrl', 'route' => 'api/v1.backStage/getAuthUrl', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'webest.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://webest.leaper.ltd:8087', 'authentication' => 'userInfo anBkbjo2YkNySUJrNDgzRjU5MVdsUHRtR2ZKdVVzOTF3TDdZTzpFUlZYQ0dUdmMzaXRaUWptSzFndWtTMGUyYUk3MTVZTw==', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36 QBCore/3.53.1159.400 QQBrowser/9.0.2524.400 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36 MicroMessenger/6.5.2.501 NetType/WIFI WindowsWechat', 'referer' => 'http://webest.leaper.ltd:8087/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8,en-US;q=0.6,en;q=0.5;q=0.4', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.438348s ] 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 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.032146s ]