--------------------------------------------------------------- [ 2025-06-13T08:57:15+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 [运行时间：3.836267s] [吞吐率：0.26req/s] [内存消耗：2,982.60kb] [文件加载：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 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.95 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.031200s ] sqlsrv:Database=UMCJP;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'kjp_checkreport' [ RunTime:0.084001s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.015600s ] [ 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:2.482042s ] [ 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.039602s ] [ sql ] [ DB ] CONNECT:[ UseTime:0.031200s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'Person' [ RunTime:0.031200s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ 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 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.163802s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.086401s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'Department' [ RunTime:0.080000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.069802s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'ComputationUnit' [ RunTime:0.031200s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.061801s ] [ 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.065004s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='QMCHECKPROJECT' [ RunTime:0.071202s ] [ 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.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.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.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000114') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cPersonName] FROM [Person] WHERE [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.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.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.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.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] = '0201010054') 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] = '0201010054') 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.015601s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000116') 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] = '0201010054') 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] = '0201010054') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000116') 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] = '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.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] = '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] = '0201010105') 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] = '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] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cDepName] FROM [Department] WHERE [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cComUnitName] FROM [ComputationUnit] WHERE [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CPROJECTNAME] FROM [QMCHECKPROJECT] WHERE [CPROJECTCODE] = '0000000118') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2025-06-13T08:57:16+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getByCbatchNo/?cbatchno=250529301174&table=db_con3 [运行时间：0.312811s] [吞吐率：3.20req/s] [内存消耗：2,764.21kb] [文件加载：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 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.95 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' => '250529301174', '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.008001s ] 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.015600s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreport] WHERE [BatchNo] = '250529301174') AS thinkphp) AS T1 [ RunTime:0.083401s ] [ 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.050003s ] [ sql ] [ DB ] CONNECT:[ UseTime:0.018001s ] 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.019001s ] [ 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.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 = 'Inventory' [ RunTime:0.002000s ] [ 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] = '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 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.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 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 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.003000s ] [ 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.003000s ] --------------------------------------------------------------- [ 2025-06-13T08:57:18+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getDetail/?danju=1000393454&invcode2=NR960&cBatchNo=250529301174&checkDate=2025-05-31 [运行时间：0.418606s] [吞吐率：2.39req/s] [内存消耗：2,897.71kb] [文件加载：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 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.95 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' => '1000393454', 'invcode2' => 'NR960', 'cBatchNo' => '250529301174', 'checkDate' => '2025-05-31', ) [ 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.063400s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreportdetail' [ RunTime:0.067801s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY SortSeq asc) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreportdetail] WHERE [id] = '1000393454') AS thinkphp) AS T1 [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'kjp_records' [ RunTime:0.033200s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_records' [ RunTime:0.067802s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_records] WHERE [RowNums] = '1000393454') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.032200s ] [ sql ] [ SQL ] INSERT INTO [kjp_records] ([RowNums] , [Address]) VALUES ('1000393454' , 'static/COA/NR960-250529301174-COA-1000393454.docx') [ RunTime:0.033200s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [Address] FROM [kjp_records] WHERE [RowNums] = '1000393454') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2025-06-13T09:24:43+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getByCbatchNo/?cbatchno=250307301041&table=db_con3 [运行时间：2.177633s] [吞吐率：0.46req/s] [内存消耗：2,744.41kb] [文件加载：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 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.95 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' => '250307301041', '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.036200s ] 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.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreport] WHERE [BatchNo] = '250307301041') AS thinkphp) AS T1 [ RunTime:1.292017s ] [ 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.096402s ] [ sql ] [ DB ] CONNECT:[ UseTime:0.020001s ] 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.020002s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ 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 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.083401s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.032200s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvName] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cInvStd] FROM [Inventory] WHERE [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'Department' [ RunTime:0.069801s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ 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 column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'ComputationUnit' [ RunTime:0.031200s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.031201s ] [ 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-06-13T09:24:50+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getDetail/?danju=1000382515&invcode2=NR960&cBatchNo=250307301041&checkDate=2025-03-08 [运行时间：0.207004s] [吞吐率：4.83req/s] [内存消耗：2,897.71kb] [文件加载：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 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.95 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' => '1000382515', 'invcode2' => 'NR960', 'cBatchNo' => '250307301041', 'checkDate' => '2025-03-08', ) [ 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.015600s ] sqlsrv:Database=UMCJP;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'kjp_checkreportdetail' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreportdetail' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY SortSeq asc) AS ROW_NUMBER FROM (SELECT * FROM [kjp_checkreportdetail] WHERE [id] = '1000382515') AS thinkphp) AS T1 [ RunTime:0.031200s ] [ 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.003000s ] [ 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] = '1000382515') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.032601s ] [ sql ] [ SQL ] INSERT INTO [kjp_records] ([RowNums] , [Address]) VALUES ('1000382515' , 'static/COA/NR960-250307301041-COA-1000382515.docx') [ RunTime:0.015601s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [Address] FROM [kjp_records] WHERE [RowNums] = '1000382515') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] --------------------------------------------------------------- [ 2025-06-13T13:20:57+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getDStyleList/?table=db_con3 [运行时间：0.730012s] [吞吐率：1.37req/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.026601s ] 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.125602s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.131201s ] [ 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.367207s ] --------------------------------------------------------------- [ 2025-06-13T13:20:57+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getDeplist/?table=db_con3 [运行时间：1.009618s] [吞吐率：0.99req/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.020601s ] 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.131602s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.131201s ] [ 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.641813s ] --------------------------------------------------------------- [ 2025-06-13T13:20:57+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2025-05-31T16:00:00.000Z&enddate=2025%2F6%2F13&cDepCode=[]&invCode=[]&styleCode=[] [运行时间：1.120021s] [吞吐率：0.89req/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-05-31T16:00:00.000Z', 'enddate' => '2025/6/13', '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.031200s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'RdRecord11' [ RunTime:0.153203s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.131201s ] [ 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-06-01 00:00:00' AND '2025-06-13 00:00:00') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.653814s ] [ 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-06-01 00:00:00' AND '2025-06-13 00:00:00') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.096402s ] --------------------------------------------------------------- [ 2025-06-13T13:20:57+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getInv/?table=db_con3 [运行时间：1.363625s] [吞吐率：0.73req/s] [内存消耗：2,954.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.037201s ] 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.046201s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='rdrecords11' [ RunTime:0.261804s ] [ 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.853018s ] --------------------------------------------------------------- [ 2025-06-13T13:21:07+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2025-05-31T16:00:00.000Z&enddate=2025-06-12T16:00:00.000Z&cDepCode=[]&invCode=[]&styleCode=[%22210%22,%22221%22,%22209%22,%22208%22] [运行时间：0.100402s] [吞吐率：9.96req/s] [内存消耗：2,659.69kb] [文件加载：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-05-31T16:00:00.000Z', 'enddate' => '2025-06-12T16:00:00.000Z', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '["210","221","209","208"]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'RdRecord11' [ RunTime:0.003001s ] [ 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-06-01 00:00:00' AND '2025-06-13 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.018001s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2025-06-01 00:00:00' AND '2025-06-13 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2025-06-13T13:21:12+08:00 ] 192.168.8.56 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=115&startdate=2025-05-31T16:00:00.000Z&enddate=2025-06-12T16:00:00.000Z&cDepCode=[]&invCode=[]&styleCode=[%22210%22,%22221%22,%22209%22,%22208%22] [运行时间：0.216603s] [吞吐率：4.62req/s] [内存消耗：2,689.41kb] [文件加载：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' => '115', 'startdate' => '2025-05-31T16:00:00.000Z', 'enddate' => '2025-06-12T16:00:00.000Z', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '["210","221","209","208"]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'RdRecord11' [ RunTime:0.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.002001s ] [ 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-06-01 00:00:00' AND '2025-06-13 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 115) [ RunTime:0.044201s ] [ 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-06-01 00:00:00' AND '2025-06-13 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2025-06-13T13:54:05+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getDeplist/?table=db_con3 [运行时间：0.119404s] [吞吐率：8.37req/s] [内存消耗：2,644.31kb] [文件加载：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/124.0.0.0 Safari/537.36 SLBrowser/9.0.6.5061 SLBChan/133 SLBVPV/64-bit', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'table' => 'db_con3', ) [ info ] [ RUN ] app\api\controller\Chuku->getDepList[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.020001s ] 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.002000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [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.015601s ] --------------------------------------------------------------- [ 2025-06-13T13:54:06+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getDStyleList/?table=db_con3 [运行时间：0.135004s] [吞吐率：7.41req/s] [内存消耗：2,644.41kb] [文件加载：58] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => '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/124.0.0.0 Safari/537.36 SLBrowser/9.0.6.5061 SLBChan/133 SLBVPV/64-bit', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'table' => 'db_con3', ) [ info ] [ RUN ] app\api\controller\Chuku->getDStyleList[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.015601s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'RdRecord11' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [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.015600s ] --------------------------------------------------------------- [ 2025-06-13T13:54:08+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2025-05-31T16:00:00.000Z&enddate=2025%2F6%2F13&cDepCode=[]&invCode=[]&styleCode=[] [运行时间：3.121062s] [吞吐率：0.32req/s] [内存消耗：2,659.02kb] [文件加载：59] [ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php [ info ] [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'api', 1 => 'chuku', 2 => 'getData', ), ) [ info ] [ HEADER ] array ( 'host' => '192.168.8.222:8086', 'connection' => 'keep-alive', 'accept' => 'application/json, text/plain, */*', 'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 SLBrowser/9.0.6.5061 SLBChan/133 SLBVPV/64-bit', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'current' => '1', 'size' => '10', 'startdate' => '2025-05-31T16:00:00.000Z', 'enddate' => '2025/6/13', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '[]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:3.031859s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'RdRecord11' [ RunTime:0.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [rs].[cRdName],[dp].[cDepName],[rd].[cCode],[rd].[dDate],[rds].[cInvCode],[i].[cInvName],[i].[cInvStd],[cmp].[cComUnitName],[rds].[iQuantity],[rds].[iUnitCost],[rds].[cName],[i].[iInvNCost] FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2025-06-01 00:00:00' AND '2025-06-13 00:00:00') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.005000s ] [ 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-06-01 00:00:00' AND '2025-06-13 00:00:00') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.003001s ] --------------------------------------------------------------- [ 2025-06-13T13:54:09+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getInv/?table=db_con3 [运行时间：3.217067s] [吞吐率：0.31req/s] [内存消耗：2,954.47kb] [文件加载：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/124.0.0.0 Safari/537.36 SLBrowser/9.0.6.5061 SLBChan/133 SLBVPV/64-bit', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'table' => 'db_con3', ) [ info ] [ RUN ] app\api\controller\Chuku->getInv[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:3.032859s ] 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.003000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='rdrecords11' [ RunTime:0.002000s ] [ 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.065004s ] --------------------------------------------------------------- [ 2025-06-13T13:54:25+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2025-05-01+&enddate=2025-05-31+&cDepCode=[]&invCode=[]&styleCode=[%22210%22,%22221%22,%22209%22,%22208%22] [运行时间：0.159005s] [吞吐率：6.29req/s] [内存消耗：2,659.59kb] [文件加载：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/124.0.0.0 Safari/537.36 SLBrowser/9.0.6.5061 SLBChan/133 SLBVPV/64-bit', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'current' => '1', 'size' => '10', 'startdate' => '2025-05-01 ', 'enddate' => '2025-05-31 ', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '["210","221","209","208"]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'RdRecord11' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [rs].[cRdName],[dp].[cDepName],[rd].[cCode],[rd].[dDate],[rds].[cInvCode],[i].[cInvName],[i].[cInvStd],[cmp].[cComUnitName],[rds].[iQuantity],[rds].[iUnitCost],[rds].[cName],[i].[iInvNCost] FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2025-05-01 00:00:00' AND '2025-05-31 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.034601s ] [ 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-05-01 00:00:00' AND '2025-05-31 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.055003s ] --------------------------------------------------------------- [ 2025-06-13T13:54:26+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=10&startdate=2025-05-01+&enddate=2025-05-31+&cDepCode=[]&invCode=[]&styleCode=[%22210%22,%22221%22,%22209%22,%22208%22] [运行时间：0.086402s] [吞吐率：11.57req/s] [内存消耗：2,659.59kb] [文件加载：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/124.0.0.0 Safari/537.36 SLBrowser/9.0.6.5061 SLBChan/133 SLBVPV/64-bit', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'current' => '1', 'size' => '10', 'startdate' => '2025-05-01 ', 'enddate' => '2025-05-31 ', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '["210","221","209","208"]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'RdRecord11' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [rs].[cRdName],[dp].[cDepName],[rd].[cCode],[rd].[dDate],[rds].[cInvCode],[i].[cInvName],[i].[cInvStd],[cmp].[cComUnitName],[rds].[iQuantity],[rds].[iUnitCost],[rds].[cName],[i].[iInvNCost] FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2025-05-01 00:00:00' AND '2025-05-31 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10) [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS tp_count FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2025-05-01 00:00:00' AND '2025-05-31 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ] --------------------------------------------------------------- [ 2025-06-13T13:54:35+08:00 ] 192.168.8.146 GET 192.168.8.222:8086/public/api/chuku/getData/?current=1&size=236&startdate=2025-05-01+&enddate=2025-05-31+&cDepCode=[]&invCode=[]&styleCode=[%22210%22,%22221%22,%22209%22,%22208%22] [运行时间：0.229202s] [吞吐率：4.36req/s] [内存消耗：2,728.53kb] [文件加载：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/124.0.0.0 Safari/537.36 SLBrowser/9.0.6.5061 SLBChan/133 SLBVPV/64-bit', 'origin' => 'http://192.168.8.222:8089', 'referer' => 'http://192.168.8.222:8089/', 'accept-encoding' => 'gzip, deflate', 'accept-language' => 'zh-CN,zh;q=0.9', ) [ info ] [ PARAM ] array ( 'current' => '1', 'size' => '236', 'startdate' => '2025-05-01 ', 'enddate' => '2025-05-31 ', 'cDepCode' => '[]', 'invCode' => '[]', 'styleCode' => '["210","221","209","208"]', ) [ info ] [ RUN ] app\api\controller\Chuku->getData[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Chuku.php ] [ info ] [ DB ] INIT Sqlsrv [ info ] [ LOG ] INIT File [ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=UFDATA_002_2018;Server=192.168.8.238 [ sql ] [ SQL ] SELECT column_name, data_type, column_default, is_nullable FROM information_schema.tables AS t JOIN information_schema.columns AS c ON t.table_catalog = c.table_catalog AND t.table_schema = c.table_schema AND t.table_name = c.table_name WHERE t.table_name = 'RdRecord11' [ RunTime:0.000000s ] [ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='RdRecord11' [ RunTime:0.015600s ] [ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [rs].[cRdName],[dp].[cDepName],[rd].[cCode],[rd].[dDate],[rds].[cInvCode],[i].[cInvName],[i].[cInvStd],[cmp].[cComUnitName],[rds].[iQuantity],[rds].[iUnitCost],[rds].[cName],[i].[iInvNCost] FROM [RdRecord11] [rd] RIGHT JOIN [rdrecords11] [rds] ON [rd].[ID]=[rds].[ID] LEFT JOIN [Inventory] [i] ON [rds].[cInvCode]=[i].[cInvCode] LEFT JOIN [Rd_Style] [rs] ON [rd].[cRdCode]=[rs].[cRdCode] LEFT JOIN [Department] [dp] ON [rd].[cDepCode]=[dp].[cDepCode] LEFT JOIN [ComputationUnit] [cmp] ON [i].[cComUnitCode]=[cmp].[cComUnitCode] WHERE [rd].[dDate] BETWEEN '2025-05-01 00:00:00' AND '2025-05-31 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 236) [ RunTime:0.036601s ] [ 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-05-01 00:00:00' AND '2025-05-31 00:00:00' AND [rd].[cRdCode] IN ('210','221','209','208')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.003000s ]