--------------------------------------------------------------- [ 2025-10-30T08:59:04+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/checklist/?current=1&size=10&reportclass=CP&entcode=002&table=db_con3 [运行时间：4.893452s] [吞吐率：0.20req/s] [内存消耗：2,982.59kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8', ) [ 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.027002s ] 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.056003s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.009000s ] [ 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:3.290166s ] [ 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.060003s ] [ sql ] [ DB ] CONNECT:[ UseTime:0.021002s ] 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.117403s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.030002s ] [ 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.003000s ] [ 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.122007s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.177010s ] [ 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.004001s ] [ 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.003000s ] [ 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.109006s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.042003s ] [ 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.003000s ] [ 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.054003s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.114007s ] [ 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.003000s ] [ 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.059003s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='QMCHECKPROJECT' [ RunTime:0.071004s ] [ 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.031200s ] [ 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.016600s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] [ 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.001001s ] [ 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.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000114') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] --------------------------------------------------------------- [ 2025-10-30T08:59:12+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getByCbatchNo/?cbatchno=251015305090&table=db_con3 [运行时间：0.308017s] [吞吐率：3.25req/s] [内存消耗：2,744.45kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8', ) [ info ] [ PARAM ] array ( 'cbatchno' => '251015305090', '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.018001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreport] WHERE [BatchNo] = '251015305090') AS thinkphp) AS T1 [ RunTime:0.108006s ] [ 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.077004s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT 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.001000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] --------------------------------------------------------------- [ 2025-10-30T08:59:14+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getDetail/?danju=1000404745&invcode2=NR950&cBatchNo=251015305090&checkDate=2025-10-16 [运行时间：0.307811s] [吞吐率：3.25req/s] [内存消耗：2,897.73kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'accept' => 'application/json, text/plain, */*', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8', ) [ info ] [ PARAM ] array ( 'danju' => '1000404745', 'invcode2' => 'NR950', 'cBatchNo' => '251015305090', 'checkDate' => '2025-10-16', ) [ 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.032200s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreportdetail' [ RunTime:0.050603s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY SortSeq asc) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreportdetail] WHERE [id] = '1000404745') AS thinkphp) AS T1 [ RunTime:0.015000s ] [ 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.015001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_records' [ RunTime:0.020600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_records] WHERE [RowNums] = '1000404745') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.061801s ] [ sql ] [ SQL ] INSERT INTO [kjp_records] ([RowNums] , [Address]) VALUES ('1000404745' , 'static/COA/NR950-251015305090-COA-1000404745.docx') [ RunTime:0.009001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [Address] FROM [kjp_records] WHERE [RowNums] = '1000404745') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.005000s ] --------------------------------------------------------------- [ 2025-10-30T10:56:18+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/checklist/?current=1&size=10&reportclass=CP&entcode=002&table=db_con3 [运行时间：2.752739s] [吞吐率：0.36req/s] [内存消耗：2,982.59kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ 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.032002s ] 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.114007s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.092005s ] [ 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.869447s ] [ 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.061603s ] 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.124007s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.150405s ] [ 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.004001s ] [ 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.176807s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.080005s ] [ 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.004000s ] [ 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.004000s ] [ 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.093006s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.046602s ] [ 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.064801s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.079004s ] [ 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.003001s ] [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'QMCHECKPROJECT' [ RunTime:0.053003s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='QMCHECKPROJECT' [ RunTime:0.066003s ] [ 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.008001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010105') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010105') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001001s ] [ 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.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.003000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.003000s ] [ 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.001000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.003001s ] [ 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.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ 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.002000s ] --------------------------------------------------------------- [ 2025-10-30T11:01:50+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/checklist/?current=1&size=10&reportclass=CP&entcode=002&table=db_con3 [运行时间：0.952248s] [吞吐率：1.05req/s] [内存消耗：2,982.59kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ 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.026002s ] 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.004000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.002000s ] [ 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.540229s ] [ 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.069004s ] [ sql ] [ DB ] CONNECT:[ UseTime:0.019001s ] 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.001000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT 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.002001s ] [ 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] = '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 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.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 = 'QMCHECKPROJECT' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='QMCHECKPROJECT' [ 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 ] [ 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.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 [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000117') 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.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.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000119') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001001s ] [ 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.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000114') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] --------------------------------------------------------------- [ 2025-10-30T11:01:55+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getByCbatchNo/?cbatchno=250924305128&table=db_con3 [运行时间：0.232811s] [吞吐率：4.30req/s] [内存消耗：2,744.52kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'cbatchno' => '250924305128', '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.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreport] WHERE [BatchNo] = '250924305128') AS thinkphp) AS T1 [ RunTime:0.086005s ] [ 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.050603s ] [ 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.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.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010107') 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.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 ] --------------------------------------------------------------- [ 2025-10-30T11:01:57+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getDetail/?danju=1000402636&invcode2=NR930&cBatchNo=250924305128&checkDate=2025-09-28 [运行时间：0.282615s] [吞吐率：3.54req/s] [内存消耗：2,893.08kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'danju' => '1000402636', 'invcode2' => 'NR930', 'cBatchNo' => '250924305128', 'checkDate' => '2025-09-28', ) [ 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.023001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreportdetail' [ RunTime:0.037002s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY SortSeq asc) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreportdetail] WHERE [id] = '1000402636') AS thinkphp) AS T1 [ RunTime:0.021001s ] [ 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.016001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_records' [ RunTime:0.034002s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_records] WHERE [RowNums] = '1000402636') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.036002s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [Address] FROM [kjp_records] WHERE [RowNums] = '1000402636') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] --------------------------------------------------------------- [ 2025-10-30T11:02:09+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getByCbatchNo/?cbatchno=250924301127&table=db_con3 [运行时间：0.315815s] [吞吐率：3.17req/s] [内存消耗：2,744.52kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'cbatchno' => '250924301127', '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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreport] WHERE [BatchNo] = '250924301127') AS thinkphp) AS T1 [ RunTime:0.135805s ] [ 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.057003s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT 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.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] [ 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.002001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] --------------------------------------------------------------- [ 2025-10-30T11:02:11+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getDetail/?danju=1000402736&invcode2=NR930&cBatchNo=250924301127&checkDate=2025-09-29 [运行时间：0.214809s] [吞吐率：4.66req/s] [内存消耗：2,897.55kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'danju' => '1000402736', 'invcode2' => 'NR930', 'cBatchNo' => '250924301127', 'checkDate' => '2025-09-29', ) [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreportdetail' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY SortSeq asc) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreportdetail] WHERE [id] = '1000402736') AS thinkphp) AS T1 [ RunTime:0.086802s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_records' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_records] WHERE [RowNums] = '1000402736') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.006001s ] [ sql ] [ SQL ] INSERT INTO [kjp_records] ([RowNums] , [Address]) VALUES ('1000402736' , 'static/COA/NR930-250924301127-COA-1000402736.docx') [ RunTime:0.012001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [Address] FROM [kjp_records] WHERE [RowNums] = '1000402736') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.005000s ] --------------------------------------------------------------- [ 2025-10-30T11:02:32+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getByCbatchNo/?cbatchno=251010305061&table=db_con3 [运行时间：0.265812s] [吞吐率：3.76req/s] [内存消耗：2,744.52kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'cbatchno' => '251010305061', '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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreport] WHERE [BatchNo] = '251010305061') AS thinkphp) AS T1 [ RunTime:0.097005s ] [ 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.047003s ] [ 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] = '300458') 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] = '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 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 ] --------------------------------------------------------------- [ 2025-10-30T11:02:34+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getDetail/?danju=1000404112&invcode2=NR930&cBatchNo=251010305061&checkDate=2025-10-11 [运行时间：0.132008s] [吞吐率：7.58req/s] [内存消耗：2,893.05kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'danju' => '1000404112', 'invcode2' => 'NR930', 'cBatchNo' => '251010305061', 'checkDate' => '2025-10-11', ) [ 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.002001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreportdetail' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY SortSeq asc) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreportdetail] WHERE [id] = '1000404112') AS thinkphp) AS T1 [ RunTime:0.010000s ] [ 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.002001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_records' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_records] WHERE [RowNums] = '1000404112') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.006000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [Address] FROM [kjp_records] WHERE [RowNums] = '1000404112') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.004000s ] --------------------------------------------------------------- [ 2025-10-30T11:02:57+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/checklist/?current=1&size=10&reportclass=CP&entcode=002&table=db_con3 [运行时间：0.574429s] [吞吐率：1.74req/s] [内存消耗：2,982.59kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ 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.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.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.001000s ] [ 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.228013s ] [ 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.059004s ] [ 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.001000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT 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.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.002001s ] [ 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.002000s ] [ 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.001000s ] [ 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.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.001000s ] [ 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.002001s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='QMCHECKPROJECT' [ RunTime:0.001000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010105') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000117') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000119') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.003000s ] [ 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.001000s ] [ 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.002001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000114') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ 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.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300508') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] --------------------------------------------------------------- [ 2025-10-30T11:03:48+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getByCbatchNo/?cbatchno=251010305061&table=db_con3 [运行时间：1.866504s] [吞吐率：0.54req/s] [内存消耗：2,744.52kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'cbatchno' => '251010305061', '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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreport] WHERE [BatchNo] = '251010305061') AS thinkphp) AS T1 [ RunTime:1.552486s ] [ 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.200011s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300458') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ 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.003001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010107') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002001s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ] --------------------------------------------------------------- [ 2025-10-30T11:03:59+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getDetail/?danju=1000404112&invcode2=NR930&cBatchNo=251010305061&checkDate=2025-10-11 [运行时间：0.119606s] [吞吐率：8.36req/s] [内存消耗：2,893.08kb] [文件加载：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 ( 'host' => '221.226.68.130:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'origin' => 'http://221.226.68.130:8089', 'referer' => 'http://221.226.68.130:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'danju' => '1000404112', 'invcode2' => 'NR930', 'cBatchNo' => '251010305061', 'checkDate' => '2025-10-11', ) [ 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.003001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreportdetail' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY SortSeq asc) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreportdetail] WHERE [id] = '1000404112') AS thinkphp) AS T1 [ RunTime:0.003000s ] [ 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_records' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_records] WHERE [RowNums] = '1000404112') 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 [Address] FROM [kjp_records] WHERE [RowNums] = '1000404112') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2025-10-30T14:18:01+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getDeplist/?table=db_con3 [运行时间：0.400820s] [吞吐率：2.49req/s] [内存消耗：2,644.44kb] [文件加载：58] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getDeplist', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'table' => 'db_con3', ) [ info ] [ RUN ] app\api\controller\Chuku->getDepList[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.080203s ] 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.064003s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.139008s ] [ 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.026001s ] --------------------------------------------------------------- [ 2025-10-30T14:18:01+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getDStyleList/?table=db_con3 [运行时间：0.467824s] [吞吐率：2.14req/s] [内存消耗：2,644.45kb] [文件加载：58] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getDStyleList', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'table' => 'db_con3', ) [ info ] [ RUN ] app\api\controller\Chuku->getDStyleList[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.067603s ] 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.061004s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.137008s ] [ 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.094005s ] --------------------------------------------------------------- [ 2025-10-30T14:18:01+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2025-09-30T16:00:00.000Z&enddate=2025%2F10%2F30&cDepCode=[]&invCode=[]&styleCode=[] [运行时间：0.480825s] [吞吐率：2.08req/s] [内存消耗：2,659.18kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getData', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'current' => '1', 'size' => '10', 'startdate' => '2025-09-30T16:00:00.000Z', 'enddate' => '2025/10/30', '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.045003s ] 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.059003s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.139008s ] [ 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 '2025-10-01 00:00:00' AND '2025-10-30 00:00:00') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.069004s ] [ 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 '2025-10-01 00:00:00' AND '2025-10-30 00:00:00') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.036002s ] --------------------------------------------------------------- [ 2025-10-30T14:18:02+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getInv/?table=db_con3 [运行时间：0.904845s] [吞吐率：1.11req/s] [内存消耗：2,962.45kb] [文件加载：58] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getInv', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'table' => 'db_con3', ) [ info ] [ RUN ] app\api\controller\Chuku->getInv[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.023001s ] 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.033002s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='rdrecords11' [ RunTime:0.129007s ] [ 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.522625s ] --------------------------------------------------------------- [ 2025-10-30T14:18:10+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2025-09-30T16:00:00.000Z&enddate=2025-10-29T16:00:00.000Z&cDepCode=[]&invCode=[]&styleCode=[%22210%22,%22209%22,%22221%22,%22208%22] [运行时间：0.113006s] [吞吐率：8.85req/s] [内存消耗：2,659.72kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getData', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'current' => '1', 'size' => '10', 'startdate' => '2025-09-30T16:00:00.000Z', 'enddate' => '2025-10-29T16:00:00.000Z', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '["210","209","221","208"]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'RdRecord11' [ RunTime:0.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.003000s ] [ 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 '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [rd].[cRdCode] IN ('210','209','221','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.023001s ] [ 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 '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [rd].[cRdCode] IN ('210','209','221','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.011001s ] --------------------------------------------------------------- [ 2025-10-30T14:18:14+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=127&startdate=2025-09-30T16:00:00.000Z&enddate=2025-10-29T16:00:00.000Z&cDepCode=[]&invCode=[]&styleCode=[%22210%22,%22209%22,%22221%22,%22208%22] [运行时间：0.174010s] [吞吐率：5.75req/s] [内存消耗：2,693.52kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getData', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.69', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6', ) [ info ] [ PARAM ] array ( 'current' => '1', 'size' => '127', 'startdate' => '2025-09-30T16:00:00.000Z', 'enddate' => '2025-10-29T16:00:00.000Z', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '["210","209","221","208"]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'RdRecord11' [ RunTime:0.004001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [rs].[cRdName],[dp].[cDepName],[rd].[cCode],[rd].[dDate],[rds].[cInvCode],[i].[cInvName],[i].[cInvStd],[cmp].[cComUnitName],[rds].[iQuantity],[rds].[iUnitCost],[rds].[cName],[i].[iInvNCost] FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [rd].[cRdCode] IN ('210','209','221','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 127) [ RunTime:0.028002s ] [ 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 '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [rd].[cRdCode] IN ('210','209','221','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.003000s ] --------------------------------------------------------------- [ 2025-10-30T18:37:32+08:00 ] 117.89.248.182 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyDiQu?startdate=2025-09-30T16:00:00.000Z&enddate=2025%2F10%2F30&iverifystate=[]&group_id=[]&cInvNameArr=[] [运行时间：1.403623s] [吞吐率：0.71req/s] [内存消耗：2,853.38kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyDiQu', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.64(0x1800402c) NetType/WIFI Language/zh_CN', 'accept-language' => 'zh-CN,zh-Hans;q=0.9', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-09-30T16:00:00.000Z', 'enddate' => '2025/10/30', 'iverifystate' => '[]', 'group_id' => '[]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyDiQu[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.031200s ] sqlsrv:Database=API;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'view1' [ RunTime:0.201804s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.078000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cDCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [cSTCode] <> '99' GROUP BY [cDCName]) AS thinkphp) AS T1 [ RunTime:1.021817s ] --------------------------------------------------------------- [ 2025-10-30T18:37:32+08:00 ] 117.89.248.182 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyCustomer?startdate=2025-09-30T16:00:00.000Z&enddate=2025%2F10%2F30&iverifystate=[]&group_id=[]&cInvNameArr=[] [运行时间：1.482624s] [吞吐率：0.67req/s] [内存消耗：2,874.58kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyCustomer', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.64(0x1800402c) NetType/WIFI Language/zh_CN', 'accept-language' => 'zh-CN,zh-Hans;q=0.9', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-09-30T16:00:00.000Z', 'enddate' => '2025/10/30', 'iverifystate' => '[]', 'group_id' => '[]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyCustomer[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.031200s ] sqlsrv:Database=API;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'view1' [ RunTime:0.201804s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.062400s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 40) [ RunTime:1.037417s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 [ RunTime:0.063400s ] --------------------------------------------------------------- [ 2025-10-30T18:37:34+08:00 ] 117.89.248.182 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyHangYe?startdate=2025-09-30T16:00:00.000Z&enddate=2025%2F10%2F30&iverifystate=[]&group_id=[]&cInvNameArr=[] [运行时间：3.186445s] [吞吐率：0.31req/s] [内存消耗：2,853.40kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyHangYe', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.64(0x1800402c) NetType/WIFI Language/zh_CN', 'accept-language' => 'zh-CN,zh-Hans;q=0.9', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-09-30T16:00:00.000Z', 'enddate' => '2025/10/30', 'iverifystate' => '[]', 'group_id' => '[]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyHangYe[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:3.029241s ] sqlsrv:Database=API;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [cSTCode] <> '99' GROUP BY [cCCName]) AS thinkphp) AS T1 [ RunTime:0.070802s ] --------------------------------------------------------------- [ 2025-10-30T18:37:44+08:00 ] 117.89.248.182 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyDiQu?startdate=2025-10-30+&enddate=2025-10-29T16:00:00.000Z&iverifystate=[]&group_id=[%22003%22]&cInvNameArr=[] [运行时间：0.144009s] [吞吐率：6.94req/s] [内存消耗：2,854.23kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyDiQu', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.64(0x1800402c) NetType/WIFI Language/zh_CN', 'accept-language' => 'zh-CN,zh-Hans;q=0.9', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-10-30 ', 'enddate' => '2025-10-29T16:00:00.000Z', 'iverifystate' => '[]', 'group_id' => '["003"]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyDiQu[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.024002s ] sqlsrv:Database=API;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'view1' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cDCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-30 00:00:00' AND '2025-10-30 00:00:00' AND [group_id] IN ('003') AND [cSTCode] <> '99' GROUP BY [cDCName]) AS thinkphp) AS T1 [ RunTime:0.038003s ] --------------------------------------------------------------- [ 2025-10-30T18:37:44+08:00 ] 117.89.248.182 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyHangYe?startdate=2025-10-30+&enddate=2025-10-29T16:00:00.000Z&iverifystate=[]&group_id=[%22003%22]&cInvNameArr=[] [运行时间：0.148008s] [吞吐率：6.76req/s] [内存消耗：2,854.27kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyHangYe', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.64(0x1800402c) NetType/WIFI Language/zh_CN', 'accept-language' => 'zh-CN,zh-Hans;q=0.9', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-10-30 ', 'enddate' => '2025-10-29T16:00:00.000Z', 'iverifystate' => '[]', 'group_id' => '["003"]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyHangYe[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'view1' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.002001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-30 00:00:00' AND '2025-10-30 00:00:00' AND [group_id] IN ('003') AND [cSTCode] <> '99' GROUP BY [cCCName]) AS thinkphp) AS T1 [ RunTime:0.038002s ] --------------------------------------------------------------- [ 2025-10-30T18:37:44+08:00 ] 117.89.248.182 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyCustomer?startdate=2025-10-30+&enddate=2025-10-29T16:00:00.000Z&iverifystate=[]&group_id=[%22003%22]&cInvNameArr=[] [运行时间：0.158010s] [吞吐率：6.33req/s] [内存消耗：2,858.96kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyCustomer', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.64(0x1800402c) NetType/WIFI Language/zh_CN', 'accept-language' => 'zh-CN,zh-Hans;q=0.9', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-10-30 ', 'enddate' => '2025-10-29T16:00:00.000Z', 'iverifystate' => '[]', 'group_id' => '["003"]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyCustomer[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'view1' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-30 00:00:00' AND '2025-10-30 00:00:00' AND [group_id] IN ('003') AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 40) [ RunTime:0.048003s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-30 00:00:00' AND '2025-10-30 00:00:00' AND [group_id] IN ('003') AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 [ RunTime:0.036002s ] --------------------------------------------------------------- [ 2025-10-30T18:38:17+08:00 ] 117.89.248.182 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyHangYe?startdate=2025-10-01+&enddate=2025-10-29T16:00:00.000Z&iverifystate=[]&group_id=[%22003%22]&cInvNameArr=[] [运行时间：0.085005s] [吞吐率：11.76req/s] [内存消耗：2,854.32kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyHangYe', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.64(0x1800402c) NetType/WIFI Language/zh_CN', 'accept-language' => 'zh-CN,zh-Hans;q=0.9', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-10-01 ', 'enddate' => '2025-10-29T16:00:00.000Z', 'iverifystate' => '[]', 'group_id' => '["003"]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyHangYe[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'view1' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [group_id] IN ('003') AND [cSTCode] <> '99' GROUP BY [cCCName]) AS thinkphp) AS T1 [ RunTime:0.012001s ] --------------------------------------------------------------- [ 2025-10-30T18:38:17+08:00 ] 117.89.248.182 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyDiQu?startdate=2025-10-01+&enddate=2025-10-29T16:00:00.000Z&iverifystate=[]&group_id=[%22003%22]&cInvNameArr=[] [运行时间：0.113007s] [吞吐率：8.85req/s] [内存消耗：2,854.20kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyDiQu', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.64(0x1800402c) NetType/WIFI Language/zh_CN', 'accept-language' => 'zh-CN,zh-Hans;q=0.9', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-10-01 ', 'enddate' => '2025-10-29T16:00:00.000Z', 'iverifystate' => '[]', 'group_id' => '["003"]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyDiQu[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'view1' [ RunTime:0.001001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cDCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [group_id] IN ('003') AND [cSTCode] <> '99' GROUP BY [cDCName]) AS thinkphp) AS T1 [ RunTime:0.009000s ] --------------------------------------------------------------- [ 2025-10-30T18:38:17+08:00 ] 117.89.248.182 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyCustomer?startdate=2025-10-01+&enddate=2025-10-29T16:00:00.000Z&iverifystate=[]&group_id=[%22003%22]&cInvNameArr=[] [运行时间：0.137008s] [吞吐率：7.30req/s] [内存消耗：2,874.96kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'erp', 2 => 'dataListbyCustomer', ), ) [ info ] [ HEADER ] array ( 'host' => 'dcs.nanjingtaibai.com:8086', 'origin' => 'http://dcs.nanjingtaibai.com:8089', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.64(0x1800402c) NetType/WIFI Language/zh_CN', 'accept-language' => 'zh-CN,zh-Hans;q=0.9', 'referer' => 'http://dcs.nanjingtaibai.com:8089/', 'accept-encoding' => 'gzip, deflate', ) [ info ] [ PARAM ] array ( 'startdate' => '2025-10-01 ', 'enddate' => '2025-10-29T16:00:00.000Z', 'iverifystate' => '[]', 'group_id' => '["003"]', 'cInvNameArr' => '[]', ) [ info ] [ RUN ] app\api\controller\Erp->dataListbyCustomer[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.001000s ] sqlsrv:Database=API;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'view1' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.001000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [group_id] IN ('003') AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 40) [ RunTime:0.008000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE [dDate] BETWEEN '2025-10-01 00:00:00' AND '2025-10-30 00:00:00' AND [group_id] IN ('003') AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 [ RunTime:0.006000s ]