TIME: 0
dnt_getonlineuserbyip| @userid | @ip |
| Int32 | AnsiString |
| -1 | 38.107.191.86 |
TIME: 0
UPDATE [dnt_stats] SET [count]=[count]+1 WHERE ([type]='total' AND [variable]='hits') OR ([type]='browser' AND [variable]='Other') OR ([type]='os' AND [variable]='Spiders') OR ([type]='total' AND [variable]='guests') OR ([type]='month' AND [variable]='201007') OR ([type]='week' AND [variable]='6') OR ([type]='hour' AND [variable]='02')
TIME: 0
SELECT TOP 10 [t].[tid],[t].[fid],[t].[iconid],[t].[typeid],[t].[readperm],[t].[price],[t].[poster],[t].[posterid],[t].[title],[t].[attention],[t].[postdatetime],[t].[lastpost],[t].[lastpostid],[t].[lastposter],[t].[lastposterid],[t].[views],[t].[replies],[t].[displayorder],[t].[highlight],[t].[digest],[t].[rate],[t].[hide],[t].[attachment],[t].[moderated],[t].[closed],[t].[magic],[t].[identify],[t].[special], [f].[name], [ff].[rewritename] FROM [dnt_topics] AS [t] LEFT JOIN [dnt_forums] AS [f] ON [t].[fid] = [f].[fid] LEFT JOIN [dnt_forumfields] ff ON [f].[fid] = [ff].[fid] WHERE [t].[closed]<>1 AND [t].[displayorder] >=0 AND [t].[views] > 0 AND [t].[postdatetime] > @starttime AND [t].[fid] IN (1,3,4,5,6,8,9,10,11,12,22,7,13,14,15,16,23,24) AND [ff].[password] ='' ORDER BY [t].[postdatetime] DESC| @starttime |
| DateTime |
| 1754-1-1 0:00:00 |
TIME: 0
SELECT TOP 10 [t].[tid],[t].[fid],[t].[iconid],[t].[typeid],[t].[readperm],[t].[price],[t].[poster],[t].[posterid],[t].[title],[t].[attention],[t].[postdatetime],[t].[lastpost],[t].[lastpostid],[t].[lastposter],[t].[lastposterid],[t].[views],[t].[replies],[t].[displayorder],[t].[highlight],[t].[digest],[t].[rate],[t].[hide],[t].[attachment],[t].[moderated],[t].[closed],[t].[magic],[t].[identify],[t].[special], [f].[name], [ff].[rewritename] FROM [dnt_topics] AS [t] LEFT JOIN [dnt_forums] AS [f] ON [t].[fid] = [f].[fid] LEFT JOIN [dnt_forumfields] ff ON [f].[fid] = [ff].[fid] WHERE [t].[closed]<>1 AND [t].[displayorder] >=0 AND [t].[views] > 0 AND [t].[postdatetime] > @starttime AND [t].[fid] IN (1,3,4,5,6,8,9,10,11,12,22,7,13,14,15,16,23,24) AND [ff].[password] ='' ORDER BY [t].[views] DESC| @starttime |
| DateTime |
| 1754-1-1 0:00:00 |
TIME: 0
SELECT TOP 5 [postid],[title],[author],[uid],[postdatetime],[commentcount],[views] FROM [dnt_spaceposts] WHERE [poststatus] = 1 ORDER BY [views] DESC
最多评论文章