Query took long time? What is the cause?

[محروم.كوم]

Hi,

Recently my board is under some kind of attack which makes the iowait very high and the server is down because of highload.

When i check mysql slow query logs, i found lot of these:

PHP Code:

# User@Host: xxxx[xxxxxxx] @ localhost []
# Query_time: 318 Lock_time: 259 Rows_sent: 10 Rows_examined: 46574
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.views, thread.visible, thread.open, user.username, user.userid, user.usergroupid, user.displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(4,91,104,111,4,9,75,91,58,81,84,59,60,61,104,108,117)
ORDER BY lastpost DESC
LIMIT 0, 10;
# User@Host: xxxxxxx[xxxxxxx] @ localhost []
# Query_time: 320 Lock_time: 261 Rows_sent: 10 Rows_examined: 46574
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.views, thread.visible, thread.open, user.username, user.userid, user.usergroupid, user.displaygroupid

FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(4,91,104,111,4,9,75,91,58,81,84,59,60,61,104,108,117)
ORDER BY lastpost DESC
LIMIT 0, 10;

What page, what query is it? Would could be the possible cause for this?

Thanks __DEFINE_LIKE_SHARE__