--------------------------------------------------------------- [ 2025-02-16T17:39:09+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyCustomer?startdate=2025-01-31T16:00:00.000Z&enddate=2025%2F2%2F16&iverifystate=[]&group_id=[]&cInvNameArr=[] [运行时间：1.467821s] [吞吐率：0.68req/s] [内存消耗：2,875.38kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyCustomer', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-01-31T16:00:00.000Z', 'enddate' => '2025/2/16', 'iverifystate' => '[]', 'group_id' => '[]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyCustomer[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.031200s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view1' [ RunTime:0.166802s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.048800s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-02-01 00:00:00' AND '2025-02-16 00:00:00' AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 40) [ RunTime:1.064816s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-02-01 00:00:00' AND '2025-02-16 00:00:00' AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 [ RunTime:0.070801s ] --------------------------------------------------------------- [ 2025-02-16T17:39:11+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyHangYe?startdate=2025-01-31T16:00:00.000Z&enddate=2025%2F2%2F16&iverifystate=[]&group_id=[]&cInvNameArr=[] [运行时间：3.196247s] [吞吐率：0.31req/s] [内存消耗：2,854.22kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyHangYe', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-01-31T16:00:00.000Z', 'enddate' => '2025/2/16', 'iverifystate' => '[]', 'group_id' => '[]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyHangYe[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:3.031444s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-02-01 00:00:00' AND '2025-02-16 00:00:00' AND [cSTCode] <> '99' GROUP BY [cCCName]) AS thinkphp) AS T1 [ RunTime:0.090001s ] --------------------------------------------------------------- [ 2025-02-16T17:39:11+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyDiQu?startdate=2025-01-31T16:00:00.000Z&enddate=2025%2F2%2F16&iverifystate=[]&group_id=[]&cInvNameArr=[] [运行时间：3.218848s] [吞吐率：0.31req/s] [内存消耗：2,854.18kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyDiQu', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-01-31T16:00:00.000Z', 'enddate' => '2025/2/16', 'iverifystate' => '[]', 'group_id' => '[]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyDiQu[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:3.031444s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cDCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-02-01 00:00:00' AND '2025-02-16 00:00:00' AND [cSTCode] <> '99' GROUP BY [cDCName]) AS thinkphp) AS T1 [ RunTime:0.102002s ] --------------------------------------------------------------- [ 2025-02-16T17:39:15+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyHangYe?startdate=2025-01-31T16:00:00.000Z&enddate=2025-02-15T16:00:00.000Z&iverifystate=[]&group_id=[%22002%22]&cInvNameArr=[] [运行时间：0.117602s] [吞吐率：8.50req/s] [内存消耗：2,854.98kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyHangYe', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-01-31T16:00:00.000Z', 'enddate' => '2025-02-15T16:00:00.000Z', 'iverifystate' => '[]', 'group_id' => '["002"]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyHangYe[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-02-01 00:00:00' AND '2025-02-16 00:00:00' AND [group_id] IN ('002') AND [cSTCode] <> '99' GROUP BY [cCCName]) AS thinkphp) AS T1 [ RunTime:0.046800s ] --------------------------------------------------------------- [ 2025-02-16T17:39:15+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyDiQu?startdate=2025-01-31T16:00:00.000Z&enddate=2025-02-15T16:00:00.000Z&iverifystate=[]&group_id=[%22002%22]&cInvNameArr=[] [运行时间：0.117602s] [吞吐率：8.50req/s] [内存消耗：2,854.96kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyDiQu', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-01-31T16:00:00.000Z', 'enddate' => '2025-02-15T16:00:00.000Z', 'iverifystate' => '[]', 'group_id' => '["002"]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyDiQu[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cDCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-02-01 00:00:00' AND '2025-02-16 00:00:00' AND [group_id] IN ('002') AND [cSTCode] <> '99' GROUP BY [cDCName]) AS thinkphp) AS T1 [ RunTime:0.031200s ] --------------------------------------------------------------- [ 2025-02-16T17:39:15+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyCustomer?startdate=2025-01-31T16:00:00.000Z&enddate=2025-02-15T16:00:00.000Z&iverifystate=[]&group_id=[%22002%22]&cInvNameArr=[] [运行时间：0.164402s] [吞吐率：6.08req/s] [内存消耗：2,859.70kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyCustomer', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-01-31T16:00:00.000Z', 'enddate' => '2025-02-15T16:00:00.000Z', 'iverifystate' => '[]', 'group_id' => '["002"]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyCustomer[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-02-01 00:00:00' AND '2025-02-16 00:00:00' AND [group_id] IN ('002') AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 40) [ RunTime:0.062400s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-02-01 00:00:00' AND '2025-02-16 00:00:00' AND [group_id] IN ('002') AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 [ RunTime:0.031200s ] --------------------------------------------------------------- [ 2025-02-16T17:39:34+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListforNewCustomer?startdate=2025-01-31T16:00:00.000Z&enddate=2025%2F2%2F16&iverifystate=[]&group_id=[]&cInvNameArr=[]&cDepName2=[]&cPersonNameArr=[] [运行时间：0.485808s] [吞吐率：2.06req/s] [内存消耗：2,854.95kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListforNewCustomer', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-01-31T16:00:00.000Z', 'enddate' => '2025/2/16', 'iverifystate' => '[]', 'group_id' => '[]', 'cInvNameArr' => '[]', 'cDepName2' => '[]', 'cPersonNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListforNewCustomer[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price,cCCName FROM [view1] WHERE [dCusDevDate] BETWEEN '2025-02-01 00:00:00' AND '2025-02-16 00:00:00' AND [cSTCode] <> '99' GROUP BY cCusName,cCCName) AS thinkphp) AS T1 [ RunTime:0.416007s ] --------------------------------------------------------------- [ 2025-02-16T17:39:34+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/erp/getPersonList/ [运行时间：0.978017s] [吞吐率：1.02req/s] [内存消耗：2,845.41kb] [文件加载：58] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'getPersonList', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( ) [ info ] [ RUN ] app\api\controller\Erp->getPersonList[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName],[cPersonCode] FROM [view1] GROUP BY cPersonCode,cPersonName) AS thinkphp) AS T1 [ RunTime:0.923816s ] --------------------------------------------------------------- [ 2025-02-16T17:39:50+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/caigou/getInvName/ [运行时间：2.887846s] [吞吐率：0.35req/s] [内存消耗：2,854.55kb] [文件加载：58] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'caigou', 2 => 'getInvName', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( ) [ info ] [ RUN ] app\api\controller\Caigou->getInvName[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Caigou.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view2' [ RunTime:0.031200s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view2' [ RunTime:0.053801s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [cInvCode]) AS ROW_NUMBER FROM (SELECT DISTINCT [cInvName],[cInvCode],[cInvStd] FROM [view2]) AS thinkphp) AS T1 [ RunTime:2.732044s ] --------------------------------------------------------------- [ 2025-02-16T17:40:00+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/caigou/getCVenName/?cInvCode=0101010001 [运行时间：0.856415s] [吞吐率：1.17req/s] [内存消耗：2,858.65kb] [文件加载：58] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'caigou', 2 => 'getCVenName', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( 'cInvCode' => '0101010001', ) [ info ] [ RUN ] app\api\controller\Caigou->getCVenName[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Caigou.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view2' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view2' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [cVenCode]) AS ROW_NUMBER FROM (SELECT DISTINCT [cVenCode],[cVenName] FROM [view2] WHERE [cInvCode] = '0101010001' AND ( [cVenCode] <> 'G999999901' AND [cVenCode] <> 'G999999902' )) AS thinkphp) AS T1 [ RunTime:0.785015s ] --------------------------------------------------------------- [ 2025-02-16T17:40:01+08:00 ] 49.93.195.74 GET dcs.nanjingtaibai.com:8086/public/api/caigou/dataListForCaigou?group_id=[%22002%22]&year_id=2019&inv_id=0101010001&cVenCode= [运行时间：0.282805s] [吞吐率：3.54req/s] [内存消耗：2,871.88kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'caigou', 2 => 'dataListForCaigou', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 15; PJW110 Build/AP3A.240617.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/130.0.6723.103 Mobile Safari/537.36 XWEB/1300333 MMWEBSDK/20241202 MMWEBID/5295 MicroMessenger/8.0.56.2800(0x28003856) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( 'group_id' => '["002"]', 'year_id' => '2019', 'inv_id' => '0101010001', 'cVenCode' => '', ) [ info ] [ RUN ] app\api\controller\Caigou->dataListForCaigou[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Caigou.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ 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 = 'view2' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view2' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT cVenName,sum(iPBVQuantity) as iQuantity,sum(iPBVQuantity*iCost)/NULLIF(sum(iPBVQuantity),0) as Price,sum(iSum)/NULLIF(sum(iPBVQuantity),0) as Price2 FROM [view2] WHERE [cInvCode] = '0101010001' AND [group_id] IN ('002') AND [year] = 2019 GROUP BY [cVenName]) AS thinkphp) AS T1 [ RunTime:0.168402s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT month,sum(iPBVQuantity) as iQuantity,sum(iPBVQuantity*iCost)/NULLIF(sum(iPBVQuantity),0) as Price,sum(iSum)/NULLIF(sum(iPBVQuantity),0) as Price2 FROM [view2] WHERE [cInvCode] = '0101010001' AND [group_id] IN ('002') AND [year] = 2019 GROUP BY [month]) AS thinkphp) AS T1 [ RunTime:0.042003s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT year,sum(iPBVQuantity) as iQuantity,sum(iPBVQuantity*iCost)/NULLIF(sum(iPBVQuantity),0) as Price,sum(iSum)/NULLIF(sum(iPBVQuantity),0) as Price2 FROM [view2] WHERE [cInvCode] = '0101010001' AND [group_id] IN ('002') AND [year] = 2019 GROUP BY [year]) AS thinkphp) AS T1 [ RunTime:0.022600s ]