Long query "Sorting result" and abuse

[Ghostt]

there is a a very big overload problem and there are many long querys.

very much SLEEP with long duration like 0-200. what does it meaN?


and can you explain me this query ? it processes very often and long 10-100 duration

PHP Code:

SELECT threadid, title, prefixid, lastpost, replycount
FROM vbthread AS thread
WHERE forumid = 


and

PHP Code:

Sorting result     SELECT thread.threadid, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount 


is it like this link?:
/forumdisplay.php?s=&f=161&page=1&pp=20&sort=views& order=desc&daysprune=2

how to fix?


is it also possible to limit the "&pp=20" part so no one can abuse and slowing down site by visiting this page on "&pp=200" ? or does it make no sense.