--------------------------------------------------------------- [ 2019-06-21T07:58:03+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.254191s] [吞吐率：3.93req/s] [内存消耗：1,211.77kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T07:58:05+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：1.382426s] [吞吐率：0.72req/s] [内存消耗：3,006.40kb] [文件加载：73] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjo2Z0E5RTQyOGJCMTdkVE9sWmU0ZjlrandXdVFHQzVEYzpXVjdhRjZVeTBqRUFYWjFET3BNeHJlUDJoNUk4bXYzZg==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://test.leaper.ltd:8085/common/echart', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.317578s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.637744s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.163169s ] [ 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.032496s ] [ 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.000501s ] [ 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.000384s ] --------------------------------------------------------------- [ 2019-06-21T17:25:08+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/staffToken [运行时间：0.346703s] [吞吐率：2.88req/s] [内存消耗：1,211.55kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/login', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:25:11+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/staffToken [运行时间：0.034980s] [吞吐率：28.59req/s] [内存消耗：1,211.55kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/login', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:25:11+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/staffToken [运行时间：0.199396s] [吞吐率：5.02req/s] [内存消耗：1,858.50kb] [文件加载：60] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '292', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/login', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"enStr":"LJ+b7Gjrw/jEC/uCsQgvgX4viEDmzeOxpwddcUwAiWWf8LccylnzU6VJ0tkPn5rvEzr8lnYMhFdKXzwoPiFAAR8jMrt0FZtJBycxWU2VoJWIqtiwZLtfXFyIWSZOmBSaQZw2vYU8FUQlmKb+MgAe8OJE12O5rb6HjqGzCNE957g=","data":{"staffName":"LD","timestamp":1561109111}}', 'version' => 'v1', ) --------------------------------------------------------------- [ 2019-06-21T17:25:14+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/staffToken [运行时间：0.035728s] [吞吐率：27.99req/s] [内存消耗：1,211.55kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/login', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:25:15+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/staffToken [运行时间：0.843764s] [吞吐率：1.19req/s] [内存消耗：3,242.05kb] [文件加载：77] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '300', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/login', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"enStr":"T6jfA+m+h3w37nNNrL8qN3K42yOL+fsMnvtrz3Y6Q/d6CVFmImKHNgeA+Swi6K7qhAMbOxJfr4BsbJhPohzt8nX6HbqCIl/7hXKMnmqYml7dc94wijKSG6qabL8+QXigKz6RCzaIFqaUYsOIq14pJWWr8xeK4hif/wKlHnG63oc=","data":{"staffName":"LD","timestamp":1561109114}}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.180236s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.237025s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Staff' [ RunTime:0.127637s ] [ 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.008870s ] [ 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.016062s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='role' [ RunTime:0.031456s ] [ 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.002445s ] --------------------------------------------------------------- [ 2019-06-21T17:25:15+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.047146s] [吞吐率：21.21req/s] [内存消耗：1,211.59kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:25:15+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.049743s] [吞吐率：20.10req/s] [内存消耗：1,211.78kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:25:15+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.159519s] [吞吐率：6.27req/s] [内存消耗：3,090.55kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '8', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.005807s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.021120s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.035553s ] [ 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.001816s ] --------------------------------------------------------------- [ 2019-06-21T17:25:15+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.169937s] [吞吐率：5.88req/s] [内存消耗：3,018.75kb] [文件加载：73] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.007252s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.022186s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.036584s ] [ 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.018353s ] [ 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.000537s ] [ 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.000483s ] --------------------------------------------------------------- [ 2019-06-21T17:26:10+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.041868s] [吞吐率：23.88req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:26:10+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.168328s] [吞吐率：5.94req/s] [内存消耗：3,090.70kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '281', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"","demandStatus":["0","1"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":"2","curPage":1,"keyWorld":"","keyType":["1"]}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000077s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000721s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000463s ] [ 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.102636s ] [ 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.003642s ] --------------------------------------------------------------- [ 2019-06-21T17:26:11+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.037619s] [吞吐率：26.58req/s] [内存消耗：1,211.59kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:26:11+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.038524s] [吞吐率：25.96req/s] [内存消耗：1,211.78kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:26:11+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.074311s] [吞吐率：13.46req/s] [内存消耗：3,090.55kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '8', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000113s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000600s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000587s ] [ 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.000584s ] --------------------------------------------------------------- [ 2019-06-21T17:26:11+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.073557s] [吞吐率：13.59req/s] [内存消耗：3,018.75kb] [文件加载：73] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000064s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000641s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000462s ] [ 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.000523s ] [ 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.000622s ] [ 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.000527s ] --------------------------------------------------------------- [ 2019-06-21T17:26:12+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/buildOrderNum [运行时间：0.037689s] [吞吐率：26.53req/s] [内存消耗：1,211.58kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:26:12+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/buildOrderNum [运行时间：0.047831s] [吞吐率：20.91req/s] [内存消耗：1,744.02kb] [文件加载：61] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/buildOrderNum', 'route' => 'api/v1.backStage/buildOrderNum', 'option' => array ( 'merge_rule_regex' => false, 'header' => array ( 'Access-Control-Allow-Origin' => '*', 'Access-Control-Allow-Methods' => 'POST,OPTIONS', 'Access-Control-Allow-Headers' => 'authentication', ), 'cross_domain' => true, ), 'var' => array ( 'version' => 'v1', ), ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) --------------------------------------------------------------- [ 2019-06-21T17:26:23+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.038502s] [吞吐率：25.97req/s] [内存消耗：1,211.58kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:26:23+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.062560s] [吞吐率：15.98req/s] [内存消耗：3,063.02kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '26', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '天华', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000067s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000608s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000415s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer] WHERE [propose_cus] LIKE '%天华%') AS thinkphp) AS T1 [ RunTime:0.001598s ] --------------------------------------------------------------- [ 2019-06-21T17:26:31+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.037527s] [吞吐率：26.65req/s] [内存消耗：1,211.58kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:26:31+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.069154s] [吞吐率：14.46req/s] [内存消耗：3,064.47kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '26', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '利永', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000064s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000601s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000451s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer] WHERE [propose_cus] LIKE '%利永%') AS thinkphp) AS T1 [ RunTime:0.000596s ] --------------------------------------------------------------- [ 2019-06-21T17:26:37+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.041966s] [吞吐率：23.83req/s] [内存消耗：1,211.58kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:26:37+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.069595s] [吞吐率：14.37req/s] [内存消耗：3,064.47kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '26', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '利永', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000082s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000595s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000466s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer] WHERE [propose_cus] LIKE '%利永%') AS thinkphp) AS T1 [ RunTime:0.000536s ] --------------------------------------------------------------- [ 2019-06-21T17:27:05+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.038092s] [吞吐率：26.25req/s] [内存消耗：1,211.58kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:27:05+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.066943s] [吞吐率：14.94req/s] [内存消耗：3,065.20kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '17', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '利', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000071s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000579s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000404s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer] WHERE [propose_cus] LIKE '%利%') AS thinkphp) AS T1 [ RunTime:0.001289s ] --------------------------------------------------------------- [ 2019-06-21T17:27:22+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.043849s] [吞吐率：22.81req/s] [内存消耗：1,211.58kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:27:23+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.075803s] [吞吐率：13.19req/s] [内存消耗：3,063.01kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '35', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '百利达', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000076s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000557s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000481s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer] WHERE [propose_cus] LIKE '%百利达%') AS thinkphp) AS T1 [ RunTime:0.001440s ] --------------------------------------------------------------- [ 2019-06-21T17:27:32+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.038695s] [吞吐率：25.84req/s] [内存消耗：1,211.58kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:27:32+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.071554s] [吞吐率：13.98req/s] [内存消耗：3,064.47kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '26', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '利永', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000063s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000510s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000412s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer] WHERE [propose_cus] LIKE '%利永%') AS thinkphp) AS T1 [ RunTime:0.000494s ] --------------------------------------------------------------- [ 2019-06-21T17:27:58+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/demandSave [运行时间：0.039198s] [吞吐率：25.51req/s] [内存消耗：1,211.77kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:27:59+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/demandSave [运行时间：0.243514s] [吞吐率：4.11req/s] [内存消耗：3,218.90kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'rule' => '/backStage/demandSave', 'route' => 'api/v1.backStage/demandSave', '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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '286', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/common/demand', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'demand_id' => '1561109172770', 'demand_instru' => '123123sdf数量单价分开是但减分开时代峻峰sd卡减肥是', 'expect_com_time' => '2019-06-22', 'propose_time' => '2019-06-21', 'customer_id' => '18', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000090s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000666s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000448s ] [ sql ] [ SQL ] INSERT INTO [demandtable] ([demand_id] , [demand_instru] , [expect_com_time] , [propose_time] , [customer_id]) VALUES ('1561109172770' , '123123sdf数量单价分开是但减分开时代峻峰sd卡减肥是' , '2019-06-22' , '2019-06-21' , 18) [ RunTime:0.150799s ] --------------------------------------------------------------- [ 2019-06-21T17:28:01+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.045694s] [吞吐率：21.88req/s] [内存消耗：1,211.78kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:28:01+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getAuthUrl [运行时间：0.071782s] [吞吐率：13.93req/s] [内存消耗：3,018.75kb] [文件加载：73] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '0', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'referer' => 'http://test.leaper.ltd:8085/common/operate', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000067s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000761s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000540s ] [ 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.000899s ] [ 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.000825s ] [ 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.000682s ] --------------------------------------------------------------- [ 2019-06-21T17:28:04+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.044916s] [吞吐率：22.26req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:28:04+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.078375s] [吞吐率：12.76req/s] [内存消耗：3,094.02kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '281', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"","demandStatus":["0","1"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":"2","curPage":1,"keyWorld":"","keyType":["1"]}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000083s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000598s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000394s ] [ 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.000748s ] [ 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.000671s ] --------------------------------------------------------------- [ 2019-06-21T17:28:37+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.039814s] [吞吐率：25.12req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:28:37+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.085766s] [吞吐率：11.66req/s] [内存消耗：3,081.43kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '317', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"武义天华","demandStatus":["0","1"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":"2","curPage":1,"keyWorld":"","keyType":["1"]}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000081s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000774s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000507s ] [ 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] LIKE '%武义天华%' AND [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.005226s ] [ 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 [c].[propose_cus] LIKE '%武义天华%' AND [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.004830s ] --------------------------------------------------------------- [ 2019-06-21T17:28:44+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.049872s] [吞吐率：20.05req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:28:44+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.078981s] [吞吐率：12.66req/s] [内存消耗：3,081.43kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '317', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"重庆利永","demandStatus":["0","1"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":"2","curPage":1,"keyWorld":"","keyType":["1"]}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000069s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000841s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000638s ] [ 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] LIKE '%重庆利永%' AND [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.000560s ] [ 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 [c].[propose_cus] LIKE '%重庆利永%' AND [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.000730s ] --------------------------------------------------------------- [ 2019-06-21T17:28:52+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.041492s] [吞吐率：24.10req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:28:52+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.081489s] [吞吐率：12.27req/s] [内存消耗：3,087.84kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '337', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"重庆利永","demandStatus":["0","1","2","3"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":"2","curPage":1,"keyWorld":"","keyType":["1"]}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000066s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000599s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000451s ] [ 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] LIKE '%重庆利永%' AND [d].[demand_status] IN ('0','1','2','3') 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.007494s ] [ 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 [c].[propose_cus] LIKE '%重庆利永%' AND [d].[demand_status] IN ('0','1','2','3') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.003506s ] --------------------------------------------------------------- [ 2019-06-21T17:29:00+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.045255s] [吞吐率：22.10req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:29:00+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.075807s] [吞吐率：13.19req/s] [内存消耗：3,087.84kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '337', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"重庆利永","demandStatus":["0","1","2","3"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":"2","curPage":1,"keyWorld":"","keyType":["1"]}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000080s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000595s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000440s ] [ 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] LIKE '%重庆利永%' AND [d].[demand_status] IN ('0','1','2','3') 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.000644s ] [ 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 [c].[propose_cus] LIKE '%重庆利永%' AND [d].[demand_status] IN ('0','1','2','3') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000800s ] --------------------------------------------------------------- [ 2019-06-21T17:29:06+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.040458s] [吞吐率：24.72req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:29:07+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.092236s] [吞吐率：10.84req/s] [内存消耗：3,118.84kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '301', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"","demandStatus":["0","1","2","3"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":"2","curPage":1,"keyWorld":"","keyType":["1"]}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000066s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000608s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000423s ] [ 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','2','3') 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.006890s ] [ 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','2','3') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002860s ] --------------------------------------------------------------- [ 2019-06-21T17:29:19+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.044149s] [吞吐率：22.65req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:29:19+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.092483s] [吞吐率：10.81req/s] [内存消耗：3,112.78kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '301', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"","demandStatus":["0","1","2","3"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":"2","curPage":2,"keyWorld":"","keyType":["1"]}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000068s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000678s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000415s ] [ 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','2','3') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 10 + 1 AND 10 + 10) [ RunTime:0.005045s ] [ 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','2','3') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000938s ] --------------------------------------------------------------- [ 2019-06-21T17:30:42+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.043270s] [吞吐率：23.11req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:30:42+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.084422s] [吞吐率：11.85req/s] [内存消耗：3,062.99kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '26', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '台州', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.011840s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000527s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000454s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer] WHERE [propose_cus] LIKE '%台州%') AS thinkphp) AS T1 [ RunTime:0.000540s ] --------------------------------------------------------------- [ 2019-06-21T17:30:50+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.041013s] [吞吐率：24.38req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:30:50+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.072866s] [吞吐率：13.72req/s] [内存消耗：3,062.99kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '26', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '武义', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000065s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000610s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000427s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer] WHERE [propose_cus] LIKE '%武义%') AS thinkphp) AS T1 [ RunTime:0.000544s ] --------------------------------------------------------------- [ 2019-06-21T17:31:11+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.038804s] [吞吐率：25.77req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:31:11+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/bulidCustomer [运行时间：0.069368s] [吞吐率：14.42req/s] [内存消耗：3,064.45kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '26', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'cusName' => '利永', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000063s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000573s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Customer' [ RunTime:0.000402s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [propose_cus],[id] FROM [Customer] WHERE [propose_cus] LIKE '%利永%') AS thinkphp) AS T1 [ RunTime:0.000532s ] --------------------------------------------------------------- [ 2019-06-21T17:31:35+08:00 ] 125.119.123.11 OPTIONS test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.055701s] [吞吐率：17.95req/s] [内存消耗：1,211.54kb] [文件加载：47] [ info ] [ LANG ] D:\erp\webapp\xampp\htdocs\demand-poject\backstage\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( ) [ info ] [ HEADER ] array ( 'host' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'access-control-request-method' => 'POST', 'origin' => 'http://test.leaper.ltd:8085', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'access-control-request-headers' => 'authentication', 'accept' => '*/*', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( ) --------------------------------------------------------------- [ 2019-06-21T17:31:35+08:00 ] 125.119.123.11 POST test.leaper.ltd:8084/public/v1/backStage/getFilterData [运行时间：0.075680s] [吞吐率：13.21req/s] [内存消耗：3,087.84kb] [文件加载：75] [ info ] [ LANG ] D:\erp\webapp\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' => 'test.leaper.ltd:8084', 'connection' => 'keep-alive', 'content-length' => '337', 'pragma' => 'no-cache', 'cache-control' => 'no-cache', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://test.leaper.ltd:8085', 'authentication' => 'userInfo anBkbjpGZzN3MkowTFF1S0c4UHQ2cGtxZDFFMVhvemxZNFdjRDpIYVZtdTlXY1FwZ3JNNmQwNHpCQURxR0ZvWmw5Mkl0WA==', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1', 'content-type' => 'application/x-www-form-urlencoded;charset=UTF-8', 'referer' => 'http://test.leaper.ltd:8085/home', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.8', ) [ info ] [ PARAM ] array ( 'data' => '{"cusName":"重庆利永","demandStatus":["1","2","3","0"],"isMajor":"2","demandType":["0","1","2","3"],"priorityLevel":"2","curPage":1,"keyWorld":"","keyType":["1"]}', 'version' => 'v1', ) [ info ] [ DB ] INIT sqlsrv [ sql ] [ DB ] CONNECT:[ UseTime:0.000095s ] sqlsrv:Server=LDWIN10\LDWIN102008,1434;Database=demand [ 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.000762s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='demandtable' [ RunTime:0.000451s ] [ 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] LIKE '%重庆利永%' AND [d].[demand_status] IN ('1','2','3','0') 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.000547s ] [ 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 [c].[propose_cus] LIKE '%重庆利永%' AND [d].[demand_status] IN ('1','2','3','0') AND [d].[demand_type] IN ('0','1','2','3')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000645s ]