---------------------------------------------------------------
[ 2025-11-04T12:23:16+08:00 ] 66.132.153.112 GET 221.226.68.130:8086/public/
[运行时间：5.100153s] [吞吐率：0.20req/s] [内存消耗：3,403.96kb] [文件加载：61]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => '',
    1 => NULL,
    2 => NULL,
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'user-agent' => 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)',
  'referer' => 'http://221.226.68.130:8086/public',
  'accept-encoding' => 'gzip',
)
[ info ] [ PARAM ] array (
)
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ RUN ] app\index\controller\Index->index[ D:\phpStudy\PHPTutorial\WWW\application\index\controller\Index.php ]
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ LOG ] INIT File
[ sql ] [ DB ] CONNECT:[ UseTime:0.030001s ] 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.130008s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.059202s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY CheckDate desc) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_checkreport] WHERE  [ReportClass] = 'CP'  AND [EntCode] = '002') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 20) [ RunTime:3.469120s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  COUNT(*) AS tp_count FROM [kjp_checkreport] WHERE  [ReportClass] = 'CP'  AND [EntCode] = '002') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ 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.164402s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.173402s ]
[ 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.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 = 'Inventory' [ RunTime:0.130202s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.108601s ]
[ 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   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.102403s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.065400s ]
[ 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.055800s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.063802s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010106') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '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  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010105') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '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.016600s ]
[ 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  [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  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') 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  [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  [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  [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  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010105') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '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  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.016600s ]
[ 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  [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  [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  [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  [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  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010108') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.015600s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '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 ]
---------------------------------------------------------------
[ 2025-11-04T14:12:31+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
[运行时间：1.844101s] [吞吐率：0.54req/s] [内存消耗：2,982.65kb] [文件加载：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.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.040200s ]
[ 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:0.165010s ]
[ 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.046002s ]
[ sql ] [ DB ] CONNECT:[ UseTime:0.022001s ] 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.036003s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.032001s ]
[ 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.153008s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.134007s ]
[ 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.006000s ]
[ 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.087005s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.053003s ]
[ 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.032002s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.162009s ]
[ 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.173010s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='QMCHECKPROJECT' [ RunTime:0.123007s ]
[ 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.004000s ]
[ 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.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] = '0000000114') 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  [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.003000s ]
[ 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 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.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] = '0000000117') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '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.002000s ]
[ 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.002000s ]
[ 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.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] = '0000000116') 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] = '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.001000s ]
[ 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.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.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.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] = '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.002000s ]
[ 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.002000s ]
[ 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.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.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] = '0000000116') 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.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.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 ]
---------------------------------------------------------------
[ 2025-11-04T14:12:33+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getByCbatchNo/?cbatchno=250728302145&table=db_con3
[运行时间：0.363417s] [吞吐率：2.75req/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' => '250728302145',
  '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.101006s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_checkreport] WHERE  [BatchNo] = '250728302145') AS thinkphp) AS T1 [ RunTime:0.058003s ]
[ 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.089005s ]
[ 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.002001s ]
[ 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   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.002001s ]
[ 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-11-04T14:12:38+08:00 ] 36.152.122.218 GET 221.226.68.130:8086/public//api/check/getDetail/?danju=1000397717&invcode2=NR960&cBatchNo=250728302145&checkDate=2025-07-28
[运行时间：0.422421s] [吞吐率：2.37req/s] [内存消耗：2,893.06kb] [文件加载：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' => '1000397717',
  'invcode2' => 'NR960',
  'cBatchNo' => '250728302145',
  'checkDate' => '2025-07-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.073603s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreportdetail' [ RunTime:0.052800s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY SortSeq asc) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_checkreportdetail] WHERE  [id] = '1000397717') AS thinkphp) AS T1 [ RunTime:0.041002s ]
[ 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.017001s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_records' [ RunTime:0.074004s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_records] WHERE  [RowNums] = '1000397717') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.050003s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [Address] FROM [kjp_records] WHERE  [RowNums] = '1000397717') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.006001s ]
---------------------------------------------------------------
[ 2025-11-04T14:18:22+08:00 ] 183.161.137.116 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyDiQu?startdate=2025-10-31T16:00:00.000Z&enddate=2025%2F11%2F4&iverifystate=[]&group_id=[]&cInvNameArr=[]
[运行时间：1.980023s] [吞吐率：0.51req/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(0x18004030) 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-31T16:00:00.000Z',
  'enddate' => '2025/11/4',
  '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.015600s ] 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.116200s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.093001s ]
[ 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-11-01 00:00:00' AND '2025-11-04 00:00:00'  AND [cSTCode] <> '99' GROUP BY [cDCName]) AS thinkphp) AS T1 [ RunTime:1.685821s ]
---------------------------------------------------------------
[ 2025-11-04T14:18:23+08:00 ] 183.161.137.116 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyHangYe?startdate=2025-10-31T16:00:00.000Z&enddate=2025%2F11%2F4&iverifystate=[]&group_id=[]&cInvNameArr=[]
[运行时间：3.197437s] [吞吐率：0.31req/s] [内存消耗：2,853.42kb] [文件加载：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(0x18004030) 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-31T16:00:00.000Z',
  'enddate' => '2025/11/4',
  '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.026034s ] 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-11-01 00:00:00' AND '2025-11-04 00:00:00'  AND [cSTCode] <> '99' GROUP BY [cCCName]) AS thinkphp) AS T1 [ RunTime:0.103002s ]
---------------------------------------------------------------
[ 2025-11-04T14:18:23+08:00 ] 183.161.137.116 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyCustomer?startdate=2025-10-31T16:00:00.000Z&enddate=2025%2F11%2F4&iverifystate=[]&group_id=[]&cInvNameArr=[]
[运行时间：3.261238s] [吞吐率：0.31req/s] [内存消耗：2,857.98kb] [文件加载：59]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => 'api',
    1 => 'erp',
    2 => '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(0x18004030) 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-31T16:00:00.000Z',
  'enddate' => '2025/11/4',
  '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:3.026034s ] sqlsrv:Database=API;Server=192.168.8.238
[ sql ] [ SQL ] SELECT   column_name,   data_type,   column_default,   is_nullable
        FROM    information_schema.tables AS t
        JOIN    information_schema.columns AS c
        ON  t.table_catalog = c.table_catalog
        AND t.table_schema  = c.table_schema
        AND t.table_name    = c.table_name
        WHERE   t.table_name = 'view1' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT  cCusName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE  [dDate] BETWEEN '2025-11-01 00:00:00' AND '2025-11-04 00:00:00'  AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 40) [ RunTime:0.118602s ]
[ 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-11-01 00:00:00' AND '2025-11-04 00:00:00'  AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 [ RunTime:0.043201s ]
---------------------------------------------------------------
[ 2025-11-04T14:18:27+08:00 ] 183.161.137.116 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyDiQu?startdate=2025-11-04+&enddate=2025-11-03T16:00:00.000Z&iverifystate=[]&group_id=[%22002%22]&cInvNameArr=[]
[运行时间：0.113601s] [吞吐率：8.80req/s] [内存消耗：2,854.16kb] [文件加载：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(0x18004030) 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-11-04 ',
  'enddate' => '2025-11-03T16:00:00.000Z',
  'iverifystate' => '[]',
  'group_id' => '["002"]',
  'cInvNameArr' => '[]',
)
[ info ] [ RUN ] app\api\controller\Erp->dataListbyDiQu[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ]
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ LOG ] INIT File
[ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238
[ sql ] [ SQL ] SELECT   column_name,   data_type,   column_default,   is_nullable
        FROM    information_schema.tables AS t
        JOIN    information_schema.columns AS c
        ON  t.table_catalog = c.table_catalog
        AND t.table_schema  = c.table_schema
        AND t.table_name    = c.table_name
        WHERE   t.table_name = 'view1' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='view1' [ RunTime:0.000000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY iQuantity desc) AS ROW_NUMBER FROM (SELECT  cDCName,sum(iQuantity) as iQuantity,sum(iQuantity*Price)/NULLIF(sum(iQuantity),0) as Price FROM [view1] WHERE  [dDate] BETWEEN '2025-11-04 00:00:00' AND '2025-11-04 00:00:00'  AND [group_id] IN ('002')  AND [cSTCode] <> '99' GROUP BY [cDCName]) AS thinkphp) AS T1 [ RunTime:0.046800s ]
---------------------------------------------------------------
[ 2025-11-04T14:18:27+08:00 ] 183.161.137.116 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyCustomer?startdate=2025-11-04+&enddate=2025-11-03T16:00:00.000Z&iverifystate=[]&group_id=[%22002%22]&cInvNameArr=[]
[运行时间：0.150802s] [吞吐率：6.63req/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(0x18004030) 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-11-04 ',
  'enddate' => '2025-11-03T16:00:00.000Z',
  'iverifystate' => '[]',
  'group_id' => '["002"]',
  'cInvNameArr' => '[]',
)
[ info ] [ RUN ] app\api\controller\Erp->dataListbyCustomer[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ]
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ LOG ] INIT File
[ sql ] [ DB ] CONNECT:[ UseTime:0.000000s ] sqlsrv:Database=API;Server=192.168.8.238
[ sql ] [ SQL ] SELECT   column_name,   data_type,   column_default,   is_nullable
        FROM    information_schema.tables AS t
        JOIN    information_schema.columns AS c
        ON  t.table_catalog = c.table_catalog
        AND t.table_schema  = c.table_schema
        AND t.table_name    = c.table_name
        WHERE   t.table_name = 'view1' [ RunTime:0.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-11-04 00:00:00' AND '2025-11-04 00:00:00'  AND [group_id] IN ('002')  AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 40) [ RunTime:0.041201s ]
[ 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-11-04 00:00:00' AND '2025-11-04 00:00:00'  AND [group_id] IN ('002')  AND [cSTCode] <> '99' GROUP BY [cCusName]) AS thinkphp) AS T1 [ RunTime:0.031200s ]
---------------------------------------------------------------
[ 2025-11-04T14:18:27+08:00 ] 183.161.137.116 GET dcs.nanjingtaibai.com:8086/public/api/erp/dataListbyHangYe?startdate=2025-11-04+&enddate=2025-11-03T16:00:00.000Z&iverifystate=[]&group_id=[%22002%22]&cInvNameArr=[]
[运行时间：0.685608s] [吞吐率：1.46req/s] [内存消耗：2,854.31kb] [文件加载：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(0x18004030) 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-11-04 ',
  'enddate' => '2025-11-03T16:00:00.000Z',
  'iverifystate' => '[]',
  'group_id' => '["002"]',
  'cInvNameArr' => '[]',
)
[ info ] [ RUN ] app\api\controller\Erp->dataListbyHangYe[ D:\phpStudy\PHPTutorial\WWW\application\api\controller\Erp.php ]
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ LOG ] INIT File
[ sql ] [ DB ] CONNECT:[ UseTime:0.581007s ] 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-11-04 00:00:00' AND '2025-11-04 00:00:00'  AND [group_id] IN ('002')  AND [cSTCode] <> '99' GROUP BY [cCCName]) AS thinkphp) AS T1 [ RunTime:0.046800s ]
---------------------------------------------------------------
[ 2025-11-04T18:34:36+08:00 ] 194.110.115.35 GET 221.226.68.130:8086/public/
[运行时间：4.284025s] [吞吐率：0.23req/s] [内存消耗：3,403.92kb] [文件加载：61]
[ info ] [ LANG ] D:\phpStudy\PHPTutorial\WWW\thinkphp\lang\zh-cn.php
[ info ] [ ROUTE ] array (
  'type' => 'module',
  'module' => 
  array (
    0 => '',
    1 => NULL,
    2 => NULL,
  ),
)
[ info ] [ HEADER ] array (
  'host' => '221.226.68.130:8086',
  'user-agent' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 11_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36',
  'accept-encoding' => 'gzip',
)
[ info ] [ PARAM ] array (
)
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ RUN ] app\index\controller\Index->index[ D:\phpStudy\PHPTutorial\WWW\application\index\controller\Index.php ]
[ info ] [ DB ] INIT Sqlsrv
[ info ] [ LOG ] INIT File
[ sql ] [ DB ] CONNECT:[ UseTime:0.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.066004s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='kjp_checkreport' [ RunTime:0.046002s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY CheckDate desc) AS ROW_NUMBER FROM (SELECT  * FROM [kjp_checkreport] WHERE  [ReportClass] = 'CP'  AND [EntCode] = '002') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 20) [ RunTime:1.861896s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  COUNT(*) AS tp_count FROM [kjp_checkreport] WHERE  [ReportClass] = 'CP'  AND [EntCode] = '002') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.006000s ]
[ 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 = 'Person' [ RunTime:0.232013s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Person' [ RunTime:0.139806s ]
[ 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.044002s ]
[ 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.303018s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Inventory' [ RunTime:0.089006s ]
[ 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.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.142008s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='Department' [ RunTime:0.081005s ]
[ 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.055003s ]
[ sql ] [ SQL ] SELECT column_name FROM information_schema.key_column_usage WHERE table_name='ComputationUnit' [ RunTime:0.086005s ]
[ 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 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  [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  [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.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  [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  [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  [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  [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  [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] = '0201010054') 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  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') 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  [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  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.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  [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.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] = '0201010054') 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  [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  [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  [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] = '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.001000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.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  [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  [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  [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  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') 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  [cInvName] FROM [Inventory] WHERE  [cInvCode] = '0201010052') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cDepName] FROM [Department] WHERE  [cDepCode] = '3011') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.002000s ]
[ sql ] [ SQL ] SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT  [cComUnitName] FROM [ComputationUnit] WHERE  [cComunitCode] = '0101') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.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.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.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] = '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  [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  [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  [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  [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  [cPersonName] FROM [Person] WHERE  [cPersonCode] = '300185') 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  [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  [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  [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  [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.001001s ]