SELECT TOP 1 * FROM [dnt_online] WHERE [userid]=@userid AND [ip]=@ip
@userid
@ip
Int32
AnsiString
-1
38.107.179.234
TIME: 0.0156001
SELECT * FROM [dnt_usergroups] ORDER BY [groupid]
TIME: 0
SELECT * FROM [dnt_templates] ORDER BY [templateid]
TIME: 0
SELECT [advid], [type], [displayorder], [targets], [parameters], [code] FROM [dnt_advertisements] WHERE [available]=1 AND [starttime] <='2012/5/21' AND [endtime] >='2012/5/21' ORDER BY [displayorder] DESC, [advid] DESC
TIME: 0.0156001
SELECT * FROM [dnt_smilies] ORDER BY [type],[displayorder],[id]
TIME: 0
SELECT * FROM [dnt_smilies] WHERE [type]=0 ORDER BY [displayorder],[id]
TIME: 0.0468003
SELECT [dnt_forums].*, [dnt_forumfields].* FROM [dnt_forums] LEFT JOIN [dnt_forumfields] ON [dnt_forums].[fid]=[dnt_forumfields].[fid] ORDER BY [displayorder]
TIME: 0
dnt_gettopiccountbycondition
@fid
@state
@condition
Int32
Int32
AnsiString
14
-1
TIME: 0.0936006
dnt_gettopiclist
@fid
@pagesize
@pageindex
@startnum
@condition
Int32
Int32
Int32
Int32
AnsiString
14
20
13
0
TIME: 0
SELECT [typeid],[name] FROM [dnt_topictypes] ORDER BY [displayorder]
TIME: 0
SELECT [name], [fid], [layer] FROM [dnt_forums] WHERE [parentid] NOT IN (SELECT fid FROM [dnt_forums] WHERE [status] < 1 AND [layer] = 0) AND [status] > 0 AND [displayorder] >=0 ORDER BY [displayorder]
TIME: 0
SELECT [title], [img] FROM [dnt_onlinelist] WHERE [img]<> '' ORDER BY [displayorder]
有新的回复
多于15篇回复)
关闭的主题
无新回复
多于15篇回复)
跳转的主题