Description:
Here are some of the database queries that are slow and consume a lot of server resources:
LIST OF QUERIES
Executed 14 min ago for 6 sec on Database --> ezcool_abc.
SELECT data.tagid, data.tagtext, SUM(data.searchcount) AS searchcount FROM ( SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount FROM tagcontent AS tagcontent INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid) INNER JOIN thread AS thread ON (tagcontent.contentid = thread.threadid) WHERE tagcontent.contenttypeid IN (2) AND tagcontent.dateline > 1244611169 AND thread.open <> 10 AND thread.visible = 1 AND thread.forumid IN (1,2,4,5,6,7,8,9,11,12,13,15,14,16,17,18,19,20,21,22,23,45,46,41,42,43,44,37,38,39,40,24,25,26,27,28,29,30,33,34,35,36,31) GROUP BY tagcontent.tagid, tag.tagtext ) AS data GROUP BY data.tagid, data.tagtext ORDER BY searchcount DESC LIMIT 150
How to repeat:
Executed 10 min ago for 3 sec on Database --> ezcool_abc.
SELECT thread.threadid, thread.title, thread.lastpost, thread.lastpostid, thread.forumid, thread.lastposter, thread.dateline, thread.views, thread.replycount, thread.visible, thread.open, thread.prefixid, 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(32) ORDER BY lastpost DESC LIMIT 0, 10
Executed 10 min ago for 6 sec on Database --> ezcool_abc.
INSERT INTO searchcore (username, contenttypeid, primaryid, groupcontenttypeid, groupid, ipaddress, userid, dateline, searchgroupid) VALUES ( '', 3, 23, 3, 23, 0, 0, 1276147212, 33 ) ON DUPLICATE KEY UPDATE username = VALUES(username), contenttypeid = VALUES(contenttypeid), primaryid = VALUES(primaryid), groupcontenttypeid = VALUES(groupcontenttypeid), groupid = VALUES(groupid), ipaddress = VALUES(ipaddress), userid = VALUES(userid), dateline = VALUES(dateline), searchgroupid = VALUES(searchgroupid