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 = 'Soft' [ RunTime:0.001395s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [ID] desc) AS ROW_NUMBER FROM (SELECT [s].*,[SoftCategory].[ItemDirectory],SoftCategory.Name as catename FROM [Soft] [s] INNER JOIN [SoftCategory] ON [s].[CategoryID]=[SoftCategory].[ID] WHERE [SoftCategory].[ParentID] = '1') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 6) [ RunTime:0.001651s ]
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 = 'Topic' [ RunTime:0.001687s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [t].*,TopicCategory.[Key] as cate_key,TopicCategory.Name as cate_name FROM [Topic] [t] INNER JOIN [TopicCategory] ON [t].[CategoryID]=[TopicCategory].[ID] WHERE [t].[Key] = 'gsj') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001838s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [s].*,[SoftCategory].[ItemDirectory],SoftCategory.Name as catename FROM [Soft] [s] INNER JOIN [SoftCategory] ON [s].[CategoryID]=[SoftCategory].[ID] WHERE [Tags] LIKE '%肝时间%') AS thinkphp) AS T1 [ RunTime:0.009916s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [ViewTimes] desc) AS ROW_NUMBER FROM (SELECT [t].*,TopicCategory.[Key] as cate_key,TopicCategory.Name as cate_name FROM [Topic] [t] INNER JOIN [TopicCategory] ON [t].[CategoryID]=[TopicCategory].[ID] WHERE [TopicCategory].[Key] = 'ztgame') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 4) [ RunTime:0.005766s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [ID] desc) AS ROW_NUMBER FROM (SELECT [t].*,TopicCategory.[Key] as cate_key,TopicCategory.Name as cate_name FROM [Topic] [t] INNER JOIN [TopicCategory] ON [t].[CategoryID]=[TopicCategory].[ID] WHERE [TopicCategory].[Key] = 'ztgame') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 14) [ RunTime:0.001539s ]
