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 = 'tr_categories' [ RunTime:0.063004s ]
SQL: SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME='tr_categories' [ RunTime:0.055003s ]
NOTIC: [8] Undefined offset: 0 C:\Inetpub\WWWRoot\ThinkPHP322\Library\Think\Db\Driver\Sqlsrv.class.php 第 221 行.
NOTIC: [8] Undefined offset: 0 C:\Inetpub\WWWRoot\ThinkPHP322\Library\Think\Db\Driver\Sqlsrv.class.php 第 221 行.
NOTIC: [8] Undefined offset: 0 C:\Inetpub\WWWRoot\ThinkPHP322\Library\Think\Db\Driver\Sqlsrv.class.php 第 221 行.
SQL: SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY Orders asc) AS ROW_NUMBER FROM (SELECT [ID],[Category],[Orders] FROM [tr_categories]) AS thinkphp) AS T1 [ RunTime:0.019001s ]
SQL: SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY UserName) AS ROW_NUMBER FROM (SELECT u.[ID],u.UserName FROM tr_users u WHERE ( u.[ID]>1 AND (u.[ID] IN (3,2)) )) AS thinkphp) AS T1 [ RunTime:0.144008s ]