---------------------------------------------------------------
[ 2024-06-12T10:17:16+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getDeplist/?table=db_con3
[运行时间：0.514800s] [吞吐率：1.94req/s] [内存消耗：2,644.30kb] [文件加载：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/109.0.0.0 Safari/537.36 SLBrowser/9.0.3.5211 SLBChan/133',
  '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',
)
[ 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.031200s ] 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.156000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.202800s ]
[ 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.031200s ]
---------------------------------------------------------------
[ 2024-06-12T10:17:16+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getDStyleList/?table=db_con3
[运行时间：0.561600s] [吞吐率：1.78req/s] [内存消耗：2,644.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 => '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/109.0.0.0 Safari/537.36 SLBrowser/9.0.3.5211 SLBChan/133',
  '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',
)
[ 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.031200s ] 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.156000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.202800s ]
[ 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.093600s ]
---------------------------------------------------------------
[ 2024-06-12T10:17:16+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2024-05-31T16:00:00.000Z&enddate=2024%2F6%2F12&cDepCode=[]&invCode=[]&styleCode=[]
[运行时间：0.608401s] [吞吐率：1.64req/s] [内存消耗：2,659.02kb] [文件加载：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/109.0.0.0 Safari/537.36 SLBrowser/9.0.3.5211 SLBChan/133',
  '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',
)
[ info ] [ PARAM ] array (
  'current' => '1',
  'size' => '10',
  'startdate' => '2024-05-31T16:00:00.000Z',
  'enddate' => '2024/6/12',
  '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: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 = 'RdRecord11' [ RunTime:0.140400s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.202800s ]
[ 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 '2024-06-01 00:00:00' AND '2024-06-12 00:00:00') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.124801s ]
[ 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 '2024-06-01 00:00:00' AND '2024-06-12 00:00:00') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2024-06-12T10:17:17+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getInv/?table=db_con3
[运行时间：0.967201s] [吞吐率：1.03req/s] [内存消耗：2,930.34kb] [文件加载：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/109.0.0.0 Safari/537.36 SLBrowser/9.0.3.5211 SLBChan/133',
  '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',
)
[ 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.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 = 'rdrecords11' [ RunTime:0.093600s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='rdrecords11' [ RunTime:0.312001s ]
[ 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.343200s ]
---------------------------------------------------------------
[ 2024-06-12T10:17:47+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2024-05-01+&enddate=2024-05-31+&cDepCode=[%223014%22]&invCode=[]&styleCode=[%22210%22]
[运行时间：0.655201s] [吞吐率：1.53req/s] [内存消耗：2,659.77kb] [文件加载：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/109.0.0.0 Safari/537.36 SLBrowser/9.0.3.5211 SLBChan/133',
  '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',
)
[ info ] [ PARAM ] array (
  'current' => '1',
  'size' => '10',
  'startdate' => '2024-05-01 ',
  'enddate' => '2024-05-31 ',
  'cDepCode' => '["3014"]',
  'invCode' => '[]',
  'styleCode' => '["210"]',
)
[ 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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.000000s ]
[ 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 '2024-05-01 00:00:00' AND '2024-05-31 00:00:00'  AND [rd].[cDepCode] IN ('3014')  AND [rd].[cRdCode] IN ('210')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.577201s ]
[ 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 '2024-05-01 00:00:00' AND '2024-05-31 00:00:00'  AND [rd].[cDepCode] IN ('3014')  AND [rd].[cRdCode] IN ('210')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ]
---------------------------------------------------------------
[ 2024-06-12T10:17:57+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=88&startdate=2024-05-01+&enddate=2024-05-31+&cDepCode=[%223014%22]&invCode=[]&styleCode=[%22210%22]
[运行时间：0.218400s] [吞吐率：4.58req/s] [内存消耗：2,676.74kb] [文件加载：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/109.0.0.0 Safari/537.36 SLBrowser/9.0.3.5211 SLBChan/133',
  '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',
)
[ info ] [ PARAM ] array (
  'current' => '1',
  'size' => '88',
  'startdate' => '2024-05-01 ',
  'enddate' => '2024-05-31 ',
  'cDepCode' => '["3014"]',
  'invCode' => '[]',
  'styleCode' => '["210"]',
)
[ 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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.015600s ]
[ 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 '2024-05-01 00:00:00' AND '2024-05-31 00:00:00'  AND [rd].[cDepCode] IN ('3014')  AND [rd].[cRdCode] IN ('210')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 88) [ RunTime:0.031200s ]
[ 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 '2024-05-01 00:00:00' AND '2024-05-31 00:00:00'  AND [rd].[cDepCode] IN ('3014')  AND [rd].[cRdCode] IN ('210')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ]
---------------------------------------------------------------
[ 2024-06-12T10:19:59+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=88&startdate=2024-05-01+&enddate=2024-05-31+&cDepCode=[%223014%22]&invCode=[]&styleCode=[%22210%22]
[运行时间：0.109201s] [吞吐率：9.16req/s] [内存消耗：2,676.73kb] [文件加载：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/109.0.0.0 Safari/537.36 SLBrowser/9.0.3.5211 SLBChan/133',
  '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',
)
[ info ] [ PARAM ] array (
  'current' => '1',
  'size' => '88',
  'startdate' => '2024-05-01 ',
  'enddate' => '2024-05-31 ',
  'cDepCode' => '["3014"]',
  'invCode' => '[]',
  'styleCode' => '["210"]',
)
[ 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.031200s ] 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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.000000s ]
[ 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 '2024-05-01 00:00:00' AND '2024-05-31 00:00:00'  AND [rd].[cDepCode] IN ('3014')  AND [rd].[cRdCode] IN ('210')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 88) [ RunTime:0.015600s ]
[ 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 '2024-05-01 00:00:00' AND '2024-05-31 00:00:00'  AND [rd].[cDepCode] IN ('3014')  AND [rd].[cRdCode] IN ('210')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2024-06-12T10:20:40+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=88&startdate=2024-05-01+&enddate=2024-05-31+&cDepCode=[%223014%22]&invCode=[]&styleCode=[%22210%22]
[运行时间：0.078000s] [吞吐率：12.82req/s] [内存消耗：2,676.74kb] [文件加载：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/109.0.0.0 Safari/537.36 SLBrowser/9.0.3.5211 SLBChan/133',
  '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',
)
[ info ] [ PARAM ] array (
  'current' => '1',
  'size' => '88',
  'startdate' => '2024-05-01 ',
  'enddate' => '2024-05-31 ',
  'cDepCode' => '["3014"]',
  'invCode' => '[]',
  'styleCode' => '["210"]',
)
[ 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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.000000s ]
[ 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 '2024-05-01 00:00:00' AND '2024-05-31 00:00:00'  AND [rd].[cDepCode] IN ('3014')  AND [rd].[cRdCode] IN ('210')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 88) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  COUNT(*) AS tp_count FROM [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 '2024-05-01 00:00:00' AND '2024-05-31 00:00:00'  AND [rd].[cDepCode] IN ('3014')  AND [rd].[cRdCode] IN ('210')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2024-06-12T13:49:48+08:00 ] 10.0.8.52 GET 192.168.8.222:8086/public//api/check/checklist/?current=1&size=10&reportclass=CP&entcode=002&table=db_con3
[运行时间：1.341603s] [吞吐率：0.75req/s] [内存消耗：2,982.29kb] [文件加载：59]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'check',
    2 => 'checklist',
  ),
)
[ info ] [ HEADER ] array (
  'accept' => 'application/json, text/plain, */*',
  'referer' => 'http://192.168.8.222:8089/',
  'accept-language' => 'zh-CN',
  'origin' => 'http://192.168.8.222:8089',
  'accept-encoding' => 'gzip, deflate',
  'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko',
  'host' => '192.168.8.222:8086',
  'connection' => 'Keep-Alive',
)
[ info ] [ PARAM ] array (
  'current' => '1',
  'size' => '10',
  'reportclass' => 'CP',
  'entcode' => '002',
  'table' => 'db_con3',
)
[ info ] [ RUN ] app\api\controller\Check->checkList[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Check.php ]
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ LOG ] INIT File
[ sql ] [ DB ] CONNECT:[ UseTime:0.031200s ] 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.062401s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.062400s ]
[ 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'  AND [Status] <> 4) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.046800s ]
[ 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'  AND [Status] <> 4) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.046800s ]
[ 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.046800s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.078000s ]
[ 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   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.093600s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.078000s ]
[ 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.015600s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvStd] FROM [Inventory] WHERE  [cInvCode] = '0201010106') 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 = 'Department' [ RunTime:0.062400s ]
[ 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.031200s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.078000s ]
[ 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   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 = 'QMCHECKPROJECT' [ RunTime:0.031200s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='QMCHECKPROJECT' [ RunTime:0.062400s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE  [CPROJECTCODE] = '0000000118') 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] = '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  [cInvStd] 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  [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE  [CPROJECTCODE] = '0000000118') 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] = '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  [cInvStd] 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  [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE  [CPROJECTCODE] = '0000000113') 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  [cInvStd] 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  [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE  [CPROJECTCODE] = '0000000114') 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.015601s ]
[ 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  [cInvStd] 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  [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE  [CPROJECTCODE] = '0000000114') 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  [cInvStd] 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  [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE  [CPROJECTCODE] = '0000000119') 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  [cInvStd] 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  [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE  [CPROJECTCODE] = '0000000113') 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  [cInvStd] 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  [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE  [CPROJECTCODE] = '0000000113') 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  [cInvStd] 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  [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE  [CPROJECTCODE] = '0000000119') 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] = '0201010105') 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  [cInvStd] FROM [Inventory] WHERE  [cInvCode] = '0201010105') 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  [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE  [CPROJECTCODE] = '0000000117') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2024-06-12T13:49:49+08:00 ] 10.0.8.52 GET 192.168.8.222:8086/public//api/check/getByCbatchNo/?cbatchno=240608305052&table=db_con3
[运行时间：0.327600s] [吞吐率：3.05req/s] [内存消耗：2,744.11kb] [文件加载：59]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'check',
    2 => 'getByCbatchNo',
  ),
)
[ info ] [ HEADER ] array (
  'accept' => 'application/json, text/plain, */*',
  'referer' => 'http://192.168.8.222:8089/',
  'accept-language' => 'zh-CN',
  'origin' => 'http://192.168.8.222:8089',
  'accept-encoding' => 'gzip, deflate',
  'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko',
  'host' => '192.168.8.222:8086',
  'connection' => 'Keep-Alive',
)
[ info ] [ PARAM ] array (
  'cbatchno' => '240608305052',
  'table' => 'db_con3',
)
[ info ] [ RUN ] app\api\controller\Check->getByCbatchNo[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Check.php ]
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ LOG ] INIT File
[ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] 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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_checkreport] WHERE  [BatchNo] = '240608305052') AS thinkphp) AS T1 [ RunTime:0.124800s ]
[ 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  [BatchNo] = '$doccode') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.109200s ]
[ 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 = 'Person' [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ 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   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.015600s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ 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  [cInvStd] FROM [Inventory] WHERE  [cInvCode] = '0201010108') 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 = 'Department' [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ 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   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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ 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 ]
---------------------------------------------------------------
[ 2024-06-12T13:49:50+08:00 ] 10.0.8.52 GET 192.168.8.222:8086/public//api/check/getDetail/?danju=1000340200&invcode2=NR960&cBatchNo=240608305052&checkDate=2024-06-09
[运行时间：0.249600s] [吞吐率：4.01req/s] [内存消耗：2,897.30kb] [文件加载：62]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'check',
    2 => 'getDetail',
  ),
)
[ info ] [ HEADER ] array (
  'accept' => 'application/json, text/plain, */*',
  'referer' => 'http://192.168.8.222:8089/',
  'accept-language' => 'zh-CN',
  'origin' => 'http://192.168.8.222:8089',
  'accept-encoding' => 'gzip, deflate',
  'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko',
  'host' => '192.168.8.222:8086',
  'connection' => 'Keep-Alive',
)
[ info ] [ PARAM ] array (
  'danju' => '1000340200',
  'invcode2' => 'NR960',
  'cBatchNo' => '240608305052',
  'checkDate' => '2024-06-09',
)
[ info ] [ RUN ] app\api\controller\Check->getDetail[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Check.php ]
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ LOG ] INIT File
[ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] 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_checkreportdetail' [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreportdetail' [ RunTime:0.046800s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY SortSeq asc) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_checkreportdetail] WHERE  [id] = '1000340200') AS thinkphp) AS T1 [ 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 = 'kjp_records' [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_records' [ RunTime:0.031200s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_records] WHERE  [RowNums] = '1000340200') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.031200s ]
[ sql ] [ SQL ] INSERT INTO [kjp_records] ([RowNums] , [Address]) VALUES ('1000340200' , 'static/COA/NR960-240608305052-COA-1000340200.docx') [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [Address] FROM [kjp_records] WHERE  [RowNums] = '1000340200') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ]
---------------------------------------------------------------
[ 2024-06-12T13:50:01+08:00 ] 10.0.8.52 GET 192.168.8.222:8086/public//api/check/getByCbatchNo/?cbatchno=240609305062&table=db_con3
[运行时间：0.218400s] [吞吐率：4.58req/s] [内存消耗：2,744.11kb] [文件加载：59]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'check',
    2 => 'getByCbatchNo',
  ),
)
[ info ] [ HEADER ] array (
  'accept' => 'application/json, text/plain, */*',
  'referer' => 'http://192.168.8.222:8089/',
  'accept-language' => 'zh-CN',
  'origin' => 'http://192.168.8.222:8089',
  'accept-encoding' => 'gzip, deflate',
  'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko',
  'host' => '192.168.8.222:8086',
  'connection' => 'Keep-Alive',
)
[ info ] [ PARAM ] array (
  'cbatchno' => '240609305062',
  'table' => 'db_con3',
)
[ info ] [ RUN ] app\api\controller\Check->getByCbatchNo[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Check.php ]
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ LOG ] INIT File
[ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] 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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_checkreport] WHERE  [BatchNo] = '240609305062') AS thinkphp) AS T1 [ RunTime:0.046800s ]
[ 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  [BatchNo] = '$doccode') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.046800s ]
[ 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 = 'Person' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ 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   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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ 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  [cInvStd] FROM [Inventory] WHERE  [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ]
[ 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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ 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   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.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ 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 ]
---------------------------------------------------------------
[ 2024-06-12T13:50:02+08:00 ] 10.0.8.52 GET 192.168.8.222:8086/public//api/check/getDetail/?danju=1000340338&invcode2=NR960&cBatchNo=240609305062&checkDate=2024-06-10
[运行时间：0.124800s] [吞吐率：8.01req/s] [内存消耗：2,897.30kb] [文件加载：62]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'check',
    2 => 'getDetail',
  ),
)
[ info ] [ HEADER ] array (
  'accept' => 'application/json, text/plain, */*',
  'referer' => 'http://192.168.8.222:8089/',
  'accept-language' => 'zh-CN',
  'origin' => 'http://192.168.8.222:8089',
  'accept-encoding' => 'gzip, deflate',
  'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko',
  'host' => '192.168.8.222:8086',
  'connection' => 'Keep-Alive',
)
[ info ] [ PARAM ] array (
  'danju' => '1000340338',
  'invcode2' => 'NR960',
  'cBatchNo' => '240609305062',
  'checkDate' => '2024-06-10',
)
[ info ] [ RUN ] app\api\controller\Check->getDetail[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Check.php ]
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ LOG ] INIT File
[ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] 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_checkreportdetail' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreportdetail' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY SortSeq asc) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_checkreportdetail] WHERE  [id] = '1000340338') AS thinkphp) AS T1 [ RunTime:0.015600s ]
[ 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_records' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_records' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_records] WHERE  [RowNums] = '1000340338') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] INSERT INTO [kjp_records] ([RowNums] , [Address]) VALUES ('1000340338' , 'static/COA/NR960-240609305062-COA-1000340338.docx') [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [Address] FROM [kjp_records] WHERE  [RowNums] = '1000340338') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
---------------------------------------------------------------
[ 2024-06-12T14:18:54+08:00 ] 209.141.52.211 GET 221.226.68.130:8086/public/
[运行时间：1.388402s] [吞吐率：0.72req/s] [内存消耗：3,404.13kb] [文件加载：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 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.3.1 Safari/605.1.15',
  'accept' => '*/*',
  '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.031200s ] 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.031200s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.031200s ]
[ 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.639601s ]
[ 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.046800s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.062400s ]
[ 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   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.015600s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.046800s ]
[ 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   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.031200s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.031200s ]
[ 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   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.015601s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.031200s ]
[ 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] = '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.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] = '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.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.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.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] = '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] = '0201010052') 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] = '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.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] = '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.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.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010105') 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.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.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.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.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 ]
---------------------------------------------------------------
[ 2024-06-12T22:39:41+08:00 ] 221.226.68.130 GET 221.226.68.130:8086/public/api/dcs/pointlists2?groupName=comm
[运行时间：16.161629s] [吞吐率：0.06req/s] [内存消耗：2,532.73kb] [文件加载：59]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'dcs',
    2 => 'pointlists2',
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'connection' => 'keep-alive',
  'accept' => 'application/json, text/plain, */*',
  'user-agent' => 'Mozilla/5.0 (Linux; Android 12; TAS-AN00 Build/HUAWEITAS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/122.0.6261.120 Mobile Safari/537.36 XWEB/1220089 MMWEBSDK/20240404 MMWEBID/4655 MicroMessenger/8.0.49.2600(0x28003157) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64',
  '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 (
  'groupName' => 'comm',
)
[ info ] [ RUN ] app\api\controller\Dcs->pointLists2[ 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]
---------------------------------------------------------------
[ 2024-06-12T23:59:00+08:00 ] 223.104.150.76 GET 221.226.68.130:8086/public/api/erdaomen/index
[运行时间：0.748801s] [吞吐率：1.34req/s] [内存消耗：1,847.92kb] [文件加载：51]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'erdaomen',
    2 => 'index',
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'connection' => 'keep-alive',
  'accept' => 'application/json, text/plain, */*',
  'user-agent' => 'Mozilla/5.0 (Linux; Android 12; TAS-AN00 Build/HUAWEITAS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/122.0.6261.120 Mobile Safari/537.36 XWEB/1220089 MMWEBSDK/20240404 MMWEBID/4655 MicroMessenger/8.0.49.2600(0x28003157) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64',
  '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 (
)
[ info ] [ RUN ] app\api\controller\Erdaomen->index[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erdaomen.php ]
[ info ] [ LOG ] INIT File
---------------------------------------------------------------
[ 2024-06-12T23:59:10+08:00 ] 223.104.150.76 GET 221.226.68.130:8086/public/api/erdaomen/index
[运行时间：0.702001s] [吞吐率：1.42req/s] [内存消耗：1,847.92kb] [文件加载：51]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'erdaomen',
    2 => 'index',
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'connection' => 'keep-alive',
  'accept' => 'application/json, text/plain, */*',
  'user-agent' => 'Mozilla/5.0 (Linux; Android 12; TAS-AN00 Build/HUAWEITAS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/122.0.6261.120 Mobile Safari/537.36 XWEB/1220089 MMWEBSDK/20240404 MMWEBID/4655 MicroMessenger/8.0.49.2600(0x28003157) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64',
  '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 (
)
[ info ] [ RUN ] app\api\controller\Erdaomen->index[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erdaomen.php ]
[ info ] [ LOG ] INIT File
---------------------------------------------------------------
[ 2024-06-12T23:59:20+08:00 ] 223.104.150.76 GET 221.226.68.130:8086/public/api/erdaomen/index
[运行时间：0.748802s] [吞吐率：1.34req/s] [内存消耗：1,847.92kb] [文件加载：51]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'erdaomen',
    2 => 'index',
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'connection' => 'keep-alive',
  'accept' => 'application/json, text/plain, */*',
  'user-agent' => 'Mozilla/5.0 (Linux; Android 12; TAS-AN00 Build/HUAWEITAS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/122.0.6261.120 Mobile Safari/537.36 XWEB/1220089 MMWEBSDK/20240404 MMWEBID/4655 MicroMessenger/8.0.49.2600(0x28003157) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64',
  '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 (
)
[ info ] [ RUN ] app\api\controller\Erdaomen->index[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erdaomen.php ]
[ info ] [ LOG ] INIT File
---------------------------------------------------------------
[ 2024-06-12T23:59:30+08:00 ] 223.104.150.76 GET 221.226.68.130:8086/public/api/erdaomen/index
[运行时间：0.702001s] [吞吐率：1.42req/s] [内存消耗：1,847.92kb] [文件加载：51]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'erdaomen',
    2 => 'index',
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'connection' => 'keep-alive',
  'accept' => 'application/json, text/plain, */*',
  'user-agent' => 'Mozilla/5.0 (Linux; Android 12; TAS-AN00 Build/HUAWEITAS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/122.0.6261.120 Mobile Safari/537.36 XWEB/1220089 MMWEBSDK/20240404 MMWEBID/4655 MicroMessenger/8.0.49.2600(0x28003157) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64',
  '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 (
)
[ info ] [ RUN ] app\api\controller\Erdaomen->index[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erdaomen.php ]
[ info ] [ LOG ] INIT File
---------------------------------------------------------------
[ 2024-06-12T23:59:36+08:00 ] 223.104.150.76 GET 221.226.68.130:8086/public/api/erdaomen/test
[运行时间：0.046800s] [吞吐率：21.37req/s] [内存消耗：1,831.30kb] [文件加载：51]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'erdaomen',
    2 => 'test',
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'connection' => 'keep-alive',
  'accept' => 'application/json, text/plain, */*',
  'user-agent' => 'Mozilla/5.0 (Linux; Android 12; TAS-AN00 Build/HUAWEITAS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/122.0.6261.120 Mobile Safari/537.36 XWEB/1220089 MMWEBSDK/20240404 MMWEBID/4655 MicroMessenger/8.0.49.2600(0x28003157) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64',
  '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 (
)
[ info ] [ RUN ] app\api\controller\Erdaomen->test[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erdaomen.php ]
[ info ] [ LOG ] INIT File
---------------------------------------------------------------
[ 2024-06-12T23:59:41+08:00 ] 223.104.150.76 GET 221.226.68.130:8086/public/api/erdaomen/test
[运行时间：0.046800s] [吞吐率：21.37req/s] [内存消耗：1,831.30kb] [文件加载：51]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'erdaomen',
    2 => 'test',
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'connection' => 'keep-alive',
  'accept' => 'application/json, text/plain, */*',
  'user-agent' => 'Mozilla/5.0 (Linux; Android 12; TAS-AN00 Build/HUAWEITAS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/122.0.6261.120 Mobile Safari/537.36 XWEB/1220089 MMWEBSDK/20240404 MMWEBID/4655 MicroMessenger/8.0.49.2600(0x28003157) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64',
  '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 (
)
[ info ] [ RUN ] app\api\controller\Erdaomen->test[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erdaomen.php ]
[ info ] [ LOG ] INIT File
---------------------------------------------------------------
[ 2024-06-12T23:59:46+08:00 ] 223.104.150.76 GET 221.226.68.130:8086/public/api/erdaomen/test
[运行时间：0.062400s] [吞吐率：16.03req/s] [内存消耗：1,831.30kb] [文件加载：51]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'erdaomen',
    2 => 'test',
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'connection' => 'keep-alive',
  'accept' => 'application/json, text/plain, */*',
  'user-agent' => 'Mozilla/5.0 (Linux; Android 12; TAS-AN00 Build/HUAWEITAS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/122.0.6261.120 Mobile Safari/537.36 XWEB/1220089 MMWEBSDK/20240404 MMWEBID/4655 MicroMessenger/8.0.49.2600(0x28003157) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64',
  '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 (
)
[ info ] [ RUN ] app\api\controller\Erdaomen->test[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erdaomen.php ]
[ info ] [ LOG ] INIT File
---------------------------------------------------------------
[ 2024-06-12T23:59:52+08:00 ] 223.104.150.76 GET 221.226.68.130:8086/public/api/erdaomen/index
[运行时间：0.748801s] [吞吐率：1.34req/s] [内存消耗：1,847.92kb] [文件加载：51]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'erdaomen',
    2 => 'index',
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'connection' => 'keep-alive',
  'accept' => 'application/json, text/plain, */*',
  'user-agent' => 'Mozilla/5.0 (Linux; Android 12; TAS-AN00 Build/HUAWEITAS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/122.0.6261.120 Mobile Safari/537.36 XWEB/1220089 MMWEBSDK/20240404 MMWEBID/4655 MicroMessenger/8.0.49.2600(0x28003157) WeChat/arm64 Weixin NetType/5G Language/zh_CN ABI/arm64',
  '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 (
)
[ info ] [ RUN ] app\api\controller\Erdaomen->index[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erdaomen.php ]
[ info ] [ LOG ] INIT File