--------------------------------------------------------------- [ 2026-05-27T14:25:04+08:00 ] 49.78.49.27 GET 221.226.68.130:8086/public/api/dcs/pointlists?fromtb=dcs2 [运行时间：16.187439s] [吞吐率：0.06req/s] [内存消耗：2,532.72kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'dcs', 2 => 'pointlists', ), ) [ info ] [ HEADER ] array ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Linux; Android 12; FIN-AL60 Build/HUAWEIFIN-AL60; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/146.0.7680.178 Mobile Safari/537.36 XWEB/1460093 MMWEBSDK/20260502 MMWEBID/4334 REV/4cb416278fee580afddaa1deee63e57ec09535ab MicroMessenger/8.0.72.3100(0x28004839) WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://dcs.nanjingtaibai.com:8070', 'x-requested-with' => 'com.tencent.mm', 'referer' => 'http://dcs.nanjingtaibai.com:8070/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7', ) [ info ] [ PARAM ] array ( 'fromtb' => 'dcs2', ) [ info ] [ RUN ] app\api\controller\Dcs->pointLists[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Dcs.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ error ] [08001]SQLSTATE[08001]: [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [1326]. [D:\phpStudy\PHPTutorial\WWW\thinkphp\library\think\db\Connection.php:295] --------------------------------------------------------------- [ 2026-05-27T16:14:33+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getDeplist/?table=db_con3 [运行时间：0.493028s] [吞吐率：2.03req/s] [内存消耗：2,644.41kb] [文件加载：58] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getDeplist', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'table' => 'db_con3', ) [ info ] [ RUN ] app\api\controller\Chuku->getDepList[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.025001s ] sqlsrv:Database=UFDATA_002_2018;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 = 'RdRecord11' [ RunTime:0.122007s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.124007s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [rd].[cDepCode],[dp].[cDepName] FROM [RdRecord11] [rd] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] GROUP BY rd.cDepCode,dp.cDepName) AS thinkphp) AS T1 [ RunTime:0.094005s ] --------------------------------------------------------------- [ 2026-05-27T16:14:33+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getDStyleList/?table=db_con3 [运行时间：0.545031s] [吞吐率：1.83req/s] [内存消耗：2,644.42kb] [文件加载：58] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getDStyleList', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'table' => 'db_con3', ) [ info ] [ RUN ] app\api\controller\Chuku->getDStyleList[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.040002s ] sqlsrv:Database=UFDATA_002_2018;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 = 'RdRecord11' [ RunTime:0.141008s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.124007s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [rd].[cRdCode],[rs].[cRdName] FROM [RdRecord11] [rd] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] GROUP BY rd.cRdCode,rs.cRdName) AS thinkphp) AS T1 [ RunTime:0.148008s ] --------------------------------------------------------------- [ 2026-05-27T16:14:34+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getInv/?table=db_con3 [运行时间：0.924252s] [吞吐率：1.08req/s] [内存消耗：2,966.40kb] [文件加载：58] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getInv', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'table' => 'db_con3', ) [ info ] [ RUN ] app\api\controller\Chuku->getInv[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.034002s ] sqlsrv:Database=UFDATA_002_2018;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 = 'rdrecords11' [ RunTime:0.094005s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='rdrecords11' [ RunTime:0.103006s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [i].[cInvName] FROM [rdrecords11] [rds] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] GROUP BY [i].[cInvName]) AS thinkphp) AS T1 [ RunTime:0.472225s ] --------------------------------------------------------------- [ 2026-05-27T16:14:36+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2026-04-30T16:00:00.000Z&enddate=2026%2F5%2F27&cDepCode=[]&invCode=[]&styleCode=[] [运行时间：3.631984s] [吞吐率：0.28req/s] [内存消耗：2,659.16kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getData', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'current' => '1', 'size' => '10', 'startdate' => '2026-04-30T16:00:00.000Z', 'enddate' => '2026/5/27', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '[]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:3.299965s ] sqlsrv:Database=UFDATA_002_2018;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 = 'RdRecord11' [ RunTime:0.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [rs].[cRdName],[dp].[cDepName],[rd].[cCode],[rd].[dDate],[rds].[cInvCode],[i].[cInvName],[i].[cInvStd],[cmp].[cComUnitName],[rds].[iQuantity],[rds].[iUnitCost],[rds].[cName],[i].[iInvNCost] FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2026-05-01 00:00:00' AND '2026-05-27 00:00:00') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.225013s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2026-05-01 00:00:00' AND '2026-05-27 00:00:00') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.018001s ] --------------------------------------------------------------- [ 2026-05-27T16:14:52+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2026-04-30T16:00:00.000Z&enddate=2026-05-26T16:00:00.000Z&cDepCode=[]&invCode=[]&styleCode=[%22210%22,%22221%22,%22209%22,%22208%22] [运行时间：0.104006s] [吞吐率：9.61req/s] [内存消耗：2,659.72kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getData', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'current' => '1', 'size' => '10', 'startdate' => '2026-04-30T16:00:00.000Z', 'enddate' => '2026-05-26T16:00:00.000Z', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '["210","221","209","208"]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=UFDATA_002_2018;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 = 'RdRecord11' [ RunTime:0.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [rs].[cRdName],[dp].[cDepName],[rd].[cCode],[rd].[dDate],[rds].[cInvCode],[i].[cInvName],[i].[cInvStd],[cmp].[cComUnitName],[rds].[iQuantity],[rds].[iUnitCost],[rds].[cName],[i].[iInvNCost] FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2026-05-01 00:00:00' AND '2026-05-27 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.018001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2026-05-01 00:00:00' AND '2026-05-27 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.010001s ] --------------------------------------------------------------- [ 2026-05-27T16:14:57+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=67&startdate=2026-04-30T16:00:00.000Z&enddate=2026-05-26T16:00:00.000Z&cDepCode=[]&invCode=[]&styleCode=[%22210%22,%22221%22,%22209%22,%22208%22] [运行时间：0.158009s] [吞吐率：6.33req/s] [内存消耗：2,676.54kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getData', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'current' => '1', 'size' => '67', 'startdate' => '2026-04-30T16:00:00.000Z', 'enddate' => '2026-05-26T16:00:00.000Z', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '["210","221","209","208"]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=UFDATA_002_2018;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 = 'RdRecord11' [ RunTime:0.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [rs].[cRdName],[dp].[cDepName],[rd].[cCode],[rd].[dDate],[rds].[cInvCode],[i].[cInvName],[i].[cInvStd],[cmp].[cComUnitName],[rds].[iQuantity],[rds].[iUnitCost],[rds].[cName],[i].[iInvNCost] FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2026-05-01 00:00:00' AND '2026-05-27 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 67) [ RunTime:0.038002s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2026-05-01 00:00:00' AND '2026-05-27 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] --------------------------------------------------------------- [ 2026-05-27T19:55:38+08:00 ] 66.132.224.237 GET 221.226.68.130:8086/public/ [运行时间：2.036215s] [吞吐率：0.49req/s] [内存消耗：3,403.92kb] [文件加载：61] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => '', 1 => NULL, 2 => NULL, ), ) [ info ] [ HEADER ] array ( 'host' => '221.226.68.130:8086', 'user-agent' => 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'referer' => 'http://221.226.68.130:8086/public', 'accept-encoding' => 'gzip', ) [ info ] [ PARAM ] array ( ) [ info ] [ DB ] INIT Sqlsrv [ info ] [ RUN ] app\index\controller\Index->index[ D:\phpStudy\PHPTutorial\WWW\application\index\controller\Index.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.024601s ] sqlsrv:Database=UMCJP;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 = 'kjp_checkreport' [ RunTime:0.093600s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.046800s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY CheckDate desc) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreport] WHERE [ReportClass] = 'CP' AND [EntCode] = '002') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 20) [ RunTime:0.063400s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [kjp_checkreport] WHERE [ReportClass] = 'CP' AND [EntCode] = '002') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] [ sql ] [ DB ] CONNECT:[ UseTime:0.015600s ] sqlsrv:Database=UFDATA_002_2018;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 = 'Person' [ RunTime:0.082802s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.141401s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.016600s ] [ 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 = 'Inventory' [ RunTime:0.229802s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.120201s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.003001s ] [ 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 = 'Department' [ RunTime:0.117002s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.078000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'ComputationUnit' [ RunTime:0.062400s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.079001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]