[Andreas]

(Utterly) Bad Query

# Time: 090615 12:01:57
# User@Host: xxx[xxx] @ localhost []
# Query_time: 12  Lock_time: 0  Rows_sent: 605  Rows_examined: 784838
use xxx;
SELECT postid
			FROM post AS post
			INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
			WHERE post.post_thanks_amount != 0
				AND thread.forumid IN(5,20,3,45,8,18,39,1,11,31,46,10,76,25,59,4,14,53,15,54,35,55,36,56,16,58,52,57,19,7,17,13,6,66,47,21,30,23,78,77,80,79,81,82,83,84,85,86,87,88,89,90,91,27,63,71,29,93)
			ORDER BY post.dateline DESC
			LIMIT 1000;

This is caused by

PHP Code:

        $posts = $db->query_read("
            SELECT postid
            FROM " . TABLE_PREFIX . "post AS post
            INNER JOIN " . TABLE_PREFIX . "thread AS thread ON(thread.threadid = post.threadid)
            WHERE post.post_thanks_amount != 0
                AND thread.forumid IN(" . implode(',', $forumids) . ")
            ORDER BY post.dateline DESC
            LIMIT " . ($vbulletin->options['maxresults'] * 2) . "
        "); 


You might als want to use slave db.