SELECT TOP 1 * FROM [dnt_online] WHERE [userid]=@userid AND [ip]=@ip
@userid
@ip
Int32
AnsiString
-1
38.107.191.98
TIME: 0.005859
SELECT [name], [fid] FROM [dnt_forums] WHERE [dnt_forums].[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.046872
dnt_gettopiccountbytype
@condition
AnsiString
AND digest>0 AND fid IN(11)
TIME: 0.0029295
dnt_gettopiclistbytype
@pagesize
@pageindex
@startnum
@condition
@ascdesc
Int32
Int32
Int32
AnsiString
Int32
0
1
0
AND digest>0 AND fid IN(11)
1
TIME: 0.1376865
SELECT [dnt_forums].*, [dnt_forumfields].* FROM [dnt_forums] LEFT JOIN [dnt_forumfields] ON [dnt_forums].[fid]=[dnt_forumfields].[fid] ORDER BY [displayorder]
