---------------------------------------------------------------
[ 2019-07-20T15:35:11+08:00 ] 122.235.227.55 OPTIONS webest.leaper.ltd:8084/public/v1/staffToken
[运行时间：0.031171s] [吞吐率：32.08req/s] [内存消耗：1,215.15kb] [文件加载：47]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
)
[ info ] [ HEADER ] array (
  'host' => 'webest.leaper.ltd:8084',
  'connection' => 'keep-alive',
  'access-control-request-method' => 'POST',
  'origin' => 'http://webest.leaper.ltd:8087',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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-20T15:35:12+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/staffToken
[运行时间：0.385737s] [吞吐率：2.59req/s] [内存消耗：3,244.45kb] [文件加载：77]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/staffToken',
  'route' => 'api/v1.token/staffToken',
  'option' => 
  array (
    'merge_rule_regex' => false,
    'header' => 
    array (
      'Access-Control-Allow-Origin' => '*',
      'Access-Control-Allow-Methods' => 'POST,OPTIONS',
      'Access-Control-Allow-Headers' => 'authentication',
    ),
    'cross_domain' => true,
  ),
  'var' => 
  array (
    'version' => 'v1',
  ),
)
[ info ] [ HEADER ] array (
  'host' => 'webest.leaper.ltd:8084',
  'connection' => 'keep-alive',
  'content-length' => '292',
  '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.142 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":"FEiLpfWuYLzoYrcbfsvH2Fvx+xZWxhTGFMAaYQiSRz1FATiGX60Vfgb2znSgDQDq4HQdmaukEGYfI4x+dLxzLa/NIEe5qqiawvw6Yg6Lj4iBidSPaHEDgw/0hBYenqheRT4cUyQuAwHRkoKOUvkt9Bjzcg8rllSs9LHr99VVWLU=","data":{"staffName":"LD","timestamp":1563608100}}',
  'version' => 'v1',
)
[ info ] [ DB ] INIT sqlsrv
[ sql ] [ DB ] CONNECT:[ UseTime:0.096435s ] 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.031170s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Staff' [ RunTime:0.071108s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [id],[role],[staff_realname] FROM [Staff] WHERE  [staff_name] = 'LD'  AND [staff_pwd] = '123456') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.016559s ]
[ 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.039937s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='role' [ RunTime:0.062341s ]
[ 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.015586s ]
---------------------------------------------------------------
[ 2019-07-20T15:35:12+08:00 ] 122.235.227.55 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer
[运行时间：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.142 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-20T15:35:12+08:00 ] 122.235.227.55 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl
[运行时间：0.046756s] [吞吐率：21.39req/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.142 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-20T15:35:12+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer
[运行时间：0.192869s] [吞吐率：5.18req/s] [内存消耗：3,090.79kb] [文件加载：75]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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.046756s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.064289s ]
[ 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-20T15:35:12+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl
[运行时间：0.282484s] [吞吐率：3.54req/s] [内存消耗：3,019.03kb] [文件加载：73]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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.048704s ] 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.031171s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.093512s ]
[ 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.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.015586s ]
---------------------------------------------------------------
[ 2019-07-20T15:35:14+08:00 ] 122.235.227.55 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.142 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-20T15:35:14+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/modList
[运行时间：0.103253s] [吞吐率：9.68req/s] [内存消耗：3,087.70kb] [文件加载：75]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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.046756s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [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-20T15:35:22+08:00 ] 122.235.227.55 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/getFilterData
[运行时间：0.049678s] [吞吐率：20.13req/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.142 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-20T15:35:22+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/getFilterData
[运行时间：0.124683s] [吞吐率：8.02req/s] [内存消耗：3,094.80kb] [文件加载：75]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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.015585s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [id] desc) AS ROW_NUMBER FROM (SELECT  [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE  [d].[demand_status] 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-20T15:35:24+08:00 ] 122.235.227.55 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.142 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-20T15:35:24+08:00 ] 122.235.227.55 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer
[运行时间：0.031171s] [吞吐率：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.142 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-20T15:35:24+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl
[运行时间：0.099356s] [吞吐率：10.06req/s] [内存消耗：3,019.03kb] [文件加载：73]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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.015586s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  COUNT(*) AS tp_count FROM [demandtable] WHERE  [demand_status] = 0) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.020456s ]
[ 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-20T15:35:24+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/bulidCustomer
[运行时间：0.099357s] [吞吐率：10.06req/s] [内存消耗：3,090.79kb] [文件加载：75]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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.015586s ]
---------------------------------------------------------------
[ 2019-07-20T15:35:25+08:00 ] 122.235.227.55 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/analystsList
[运行时间：0.031171s] [吞吐率：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.142 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-20T15:35:25+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/analystsList
[运行时间：0.097409s] [吞吐率：10.27req/s] [内存消耗：3,080.66kb] [文件加载：75]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.003896s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [id] DESC) AS ROW_NUMBER FROM (SELECT  [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE  [d].[demand_status] = '0') AS thinkphp) AS T1 [ RunTime:0.006818s ]
---------------------------------------------------------------
[ 2019-07-20T15:35:28+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/getAuthUrl
[运行时间：0.124682s] [吞吐率：8.02req/s] [内存消耗：3,019.03kb] [文件加载：73]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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.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] = 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.015585s ]
---------------------------------------------------------------
[ 2019-07-20T15:35:29+08:00 ] 122.235.227.55 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/testList
[运行时间：0.031170s] [吞吐率：32.08req/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.142 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-20T15:35:29+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/testList
[运行时间：0.128579s] [吞吐率：7.78req/s] [内存消耗：3,307.28kb] [文件加载：77]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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.015586s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [id] DESC) AS ROW_NUMBER FROM (SELECT  [d].*,a.staff_realname as analysts,m.staff_realname as modipersons,t.staff_realname as testers,c.propose_cus as propose_cus,c.contact_person as contact_person,c.contact_tel_no_1 as contact_tel_no_1 FROM [demandtable] [d] LEFT JOIN [customer] [c] ON [d].[customer_id]=[c].[id] LEFT JOIN [staff] [a] ON [d].[analysts_id]=[a].[id] LEFT JOIN [staff] [m] ON [d].[modipersons_id]=[m].[id] LEFT JOIN [staff] [t] ON [d].[testers_id]=[t].[id] WHERE  [analysts_id] = 6  AND [d].[demand_status] = '2') AS thinkphp) AS T1 [ RunTime:0.033119s ]
---------------------------------------------------------------
[ 2019-07-20T15:35:43+08:00 ] 122.235.227.55 OPTIONS webest.leaper.ltd:8084/public/v1/backStage/testList
[运行时间：0.031171s] [吞吐率：32.08req/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.142 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-20T15:35:43+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/testList
[运行时间：0.109097s] [吞吐率：9.17req/s] [内存消耗：3,276.64kb] [文件加载：77]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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] <> 6  AND [d].[demand_status] = '2') AS thinkphp) AS T1 [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2019-07-20T15:35:46+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/testList
[运行时间：0.124682s] [吞吐率：8.02req/s] [内存消耗：3,307.28kb] [文件加载：77]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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] = 6  AND [d].[demand_status] = '2') AS thinkphp) AS T1 [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2019-07-20T15:35:47+08:00 ] 122.235.227.55 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.142 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-20T15:35:47+08:00 ] 122.235.227.55 POST webest.leaper.ltd:8084/public/v1/backStage/getFilterData
[运行时间：0.119813s] [吞吐率：8.35req/s] [内存消耗：3,094.80kb] [文件加载：75]
[ info ] [ LANG ] C:\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'rule' => '<version>/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 anBkbjo2M2RxTVFVbHlnb1JmT1RwOGNGbkd2V3I0MlYzRTF3OTpheFVmTDM3WkViZXo1RnVjUGlvSHdJcVJ0NEFsOFE4Uw==',
  'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.142 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.005844s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.003897s ]
[ 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.008767s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  COUNT(*) AS tp_count FROM [demandtable] [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.025326s ]