Announcement

Collapse
No announcement yet.

Help me for Error of "mysql_slow_queries"

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help me for Error of "mysql_slow_queries"

    I has updated to V3.8.0 but my host is "Has Been Disabled"
    Surppotter of my host is said:
    Brent [9:33:59 AM]: I see your account has been suspended due to performance problems.
    [9:34:20 AM]: Your account is causing high load on the server with the following process. /home/yourdisk/public_html/forum/ajax.php
    [9:34:43 AM]: this needs to be either removed, or rewritten to make it more efficient
    What is happened on ajax.php?
    Can you help me for fix it?
    I see *.log on mysql_slow_queries'forlder:
    PHP Code:
    # Sat Jan 10 08:00:08 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:00:16 2009
    # Query_time: 51  Lock_time: 0  Rows_sent: 1  Rows_examined: 1888
    use room_4rum;
    SELECT user.useriduser.usernameCOUNT(post.postid) AS replycount
            FROM post 
    AS post
            LEFT JOIN thread 
    AS thread ON (post.threadid thread.threadid)
            
    LEFT JOIN user AS user ON (post.userid user.userid)
            
    WHERE thread.forumid=112 AND thread.firstpostid != post.postid
            GROUP BY post
    .userid
            ORDER BY replycount DESC
            LIMIT 1

    # Sat Jan 10 08:00:19 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:00:23 2009
    # Query_time: 4  Lock_time: 0  Rows_sent: 1041  Rows_examined: 2082
    use room_4rum;
    SELECT p.threadidt.forumid FROM post p LEFT JOIN thread t ON(t.threadid p.threadidWHERE p.userid 607

    # Sat Jan 10 08:00:26 2009
    # Query_time: 10  Lock_time: 0  Rows_sent: 1  Rows_examined: 929
    use room_4rum;
    SELECT forum.title AS forumCOUNT(attachment.attachmentid) AS countSUM(attachment.filesize) AS bytes
            FROM attachment 
    AS attachmentpost AS postthread AS threadforum AS forum
            WHERE attachment
    .postid post.postid
            
    AND post.threadid=thread.threadid
            
    AND forum.forumid=thread.forumid
            
    AND forum.forumid=112
            GROUP BY thread
    .forumid
            ORDER BY count DESC

    # Sat Jan 10 08:00:26 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:00:35 2009
    # Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:00:40 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 14  Rows_examined: 14
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:00:45 2009
    # Query_time: 5  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:00:48 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 14  Rows_examined: 14
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:00:52 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:01 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 08:01:01 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:10 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:14 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:18 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:20 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:22 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:30 2009
    # Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:37 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:41 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:45 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:49 2009
    # Query_time: 4  Lock_time: 0  Rows_sent: 14  Rows_examined: 14
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:52 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:01:58 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:02 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:10 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:14 2009
    # Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:19 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:26 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:28 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:30 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:30 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    REPLACE INTO datastore
      
    (titledataunserialize)
      
    VALUES
      
    ('cron''1231599600'0)

    # Sat Jan 10 08:02:30 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    UPDATE session
      SET lastactivity 
    1231599747badlocation 0
      WHERE sessionhash 
    'cbea09d7191852fca32381509b74ea44'

    # Sat Jan 10 08:02:39 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:41 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:43 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:48 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:52 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:02:56 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:02 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:04 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:06 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:10 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:13 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:15 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:21 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 14  Rows_examined: 14
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:22 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 91  Rows_examined: 91
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (9021,9110,8934,9464,9463,9121,9118,9120,8924,9119,9125,9127,9111,9124,9112,9113,9126,9128,9123,9513,9523,9452,8937,8936,8938,9024,9023,9025,9020,9019,9296,8926,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8787,8788,8785,8786,1377,1378,1455,1457,1462,1461,1596,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,7502,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310)

    # Sat Jan 10 08:03:24 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 198  Rows_examined: 393
    SELECT subscribeforumidforum.forumidlastpostlastposterlastthreadlastthreadidlasticonidthreadcountreplycountlastpostidlastprefixid
      
    forumread.readtime AS forumread
      FROM forum 
    AS forum
      LEFT JOIN subscribeforum 
    AS subscribeforum ON (subscribeforum.forumid forum.forumid AND subscribeforum.userid 2459)
      
    LEFT JOIN forumread AS forumread ON (forumread.forumid forum.forumid AND forumread.userid 2459)

    # Sat Jan 10 08:03:25 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 15  Rows_examined: 1443
    SELECT thread.threadidthread.titlethread.lastpostthread.forumidthread.replycountthread.postusername,thread.lastposterthread.datelinethread.viewsthread.visiblethread.openuser.usernameuser.useriduser.usergroupiduser.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(135,161,190,121,200,201,191,136,197,198,199,164,162)
      
    ORDER BY lastpost DESC
      LIMIT 0
    15

    # Sat Jan 10 08:03:27 2009
    # Query_time: 3  Lock_time: 1  Rows_sent: 45  Rows_examined: 90
    SELECT moderator.*, user.username,
            IF(
    user.displaygroupid 0user.usergroupiduser.displaygroupid) AS displaygroupidinfractiongroupid
            FROM moderator 
    AS moderator
            INNER JOIN user 
    AS user USING(userid)

    # Sat Jan 10 08:03:34 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 40
    use room_4rum;
    SELECT forum.title AS forumCOUNT(attachment.attachmentid) AS countSUM(attachment.filesize) AS bytes
            FROM attachment 
    AS attachmentpost AS postthread AS threadforum AS forum
            WHERE attachment
    .postid post.postid
            
    AND post.threadid=thread.threadid
            
    AND forum.forumid=thread.forumid
            
    AND forum.forumid=154
            GROUP BY thread
    .forumid
            ORDER BY count DESC

    # Sat Jan 10 08:03:34 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8842,8841,9517,9024,9023,9025,9020,9019,9296,8847,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8843,8844,8785,8845,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 08:03:36 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 14  Rows_examined: 14
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:45 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 08:03:47 2009
    # Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:49 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 33  Rows_examined: 132
    SELECT user.useriduser.optionsuser.username
            
    user.usergroupiduser.displaygroupidwhoread.datelinewhoread.ipaddress
            FROM whoread 
    as whoread
            LEFT JOIN user 
    as user USING (userid)
            
    WHERE whoread.threadid 1442
            
    AND whoread.dateline 0 ORDER BY username

    # Sat Jan 10 08:03:55 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 08:03:58 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache'
    Last edited by tiengnhat; Sat 10 Jan '09, 8:19am.

  • #2
    PHP Code:
    # Sat Jan 10 07:00:44 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 18  Rows_examined: 72
    use room_4rum;
    SELECT
      post
    .*, post.username AS postusernamepost.ipaddress AS ip, IF(post.visible 210) AS isdeleted,
      
    user.*, userfield.*
            
    FROM post AS post
            LEFT JOIN user 
    AS user ON(user.userid post.userid)
            
    LEFT JOIN userfield AS userfield ON(userfield.userid user.userid)
            
    WHERE threadid 2126
            ORDER BY postid

    # Sat Jan 10 07:17:31 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 1373  Rows_examined: 2746
    use room_4rum;
    SELECT p.threadidt.forumid FROM post p LEFT JOIN thread t ON(t.threadid p.threadidWHERE p.userid 135

    # Sat Jan 10 07:45:31 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 24  Rows_examined: 169
    use room_4rum;
    SELECT
      post
    .*, post.username AS postusernamepost.ipaddress AS ip, IF(post.visible 210) AS isdeleted,
      
    user.*, userfield.*, usertextfield.*,
      
    icon.title as icontitleicon.iconpath,
      
    avatar.avatarpathNOT ISNULL(customavatar.userid) AS hascustomavatarcustomavatar.dateline AS avatardateline,
      
    editlog.userid AS edit_userideditlog.username AS edit_usernameeditlog.dateline AS edit_dateline,
      
    editlog.reason AS edit_reasoneditlog.hashistory,
      
    postparsed.pagetext_htmlpostparsed.hasimages,
      
    sigparsed.signatureparsedsigparsed.hasimages AS sighasimages,
      
    sigpic.userid AS sigpicsigpic.dateline AS sigpicdatelinesigpic.width AS sigpicwidthsigpic.height AS sigpicheight,
      IF(
    displaygroupid=0user.usergroupiddisplaygroupid) AS displaygroupidinfractiongroupid
      
    ,blog_user.entries
            FROM post 
    AS post
            LEFT JOIN user 
    AS user ON(user.userid post.userid)
            
    LEFT JOIN userfield AS userfield ON(userfield.userid user.userid)
            
    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid user.userid)
            
    LEFT JOIN icon AS icon ON(icon.iconid post.iconid)
            
    LEFT JOIN avatar AS avatar ON(avatar.avatarid user.avataridLEFT JOIN customavatar AS customavatar ON(customavatar.userid user.userid)
            
    LEFT JOIN editlog AS editlog ON(editlog.postid post.postid)
            
    LEFT JOIN postparsed AS postparsed ON(postparsed.postid post.postid AND postparsed.styleid 38 AND postparsed.languageid 3)
            
    LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid user.userid AND sigparsed.styleid 38 AND sigparsed.languageid 3)
            
    LEFT JOIN sigpic AS sigpic ON(sigpic.userid post.userid)
      
    LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid post.userid)
            
    WHERE post.postid IN (7952,7954,7959,7955,7964,7965,7966,7967,7968,7985,7990,8008,7994,7995,7996,8000,8001,8002,8139,10069,10784,10808,10800,10874)

    # Sat Jan 10 07:47:53 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:48:03 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:48:05 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:48:06 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:48:16 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:48:35 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 255
    use room_4rum;
    SELECT user.useriduser.usernameCOUNT(post.postid) AS replycount
            FROM post 
    AS post
            LEFT JOIN thread 
    AS thread ON (post.threadid thread.threadid)
            
    LEFT JOIN user AS user ON (post.userid user.userid)
            
    WHERE thread.forumid=168 AND thread.firstpostid != post.postid
            GROUP BY post
    .userid
            ORDER BY replycount DESC
            LIMIT 1

    # Sat Jan 10 07:49:15 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:49:15 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:49:15 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:49:18 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:49:29 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:49:32 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:49:33 2009
    # Query_time: 14  Lock_time: 0  Rows_sent: 1373  Rows_examined: 2746
    use room_4rum;
    SELECT p.threadidt.forumid FROM post p LEFT JOIN thread t ON(t.threadid p.threadidWHERE p.userid 135

    # Sat Jan 10 07:49:35 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8842,8841,9517,9024,9023,9025,9020,9019,9296,8847,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8843,8844,8785,8845,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:49:42 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:49:42 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:49:45 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:49:51 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:49:55 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:50:00 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:50:11 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:50:13 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:50:17 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:50:35 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    use room_4rum;
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8842,8841,9517,9024,9023,9025,9020,9019,9296,8847,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8843,8844,8785,8845,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:50:35 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:50:51 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:50:59 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:51:20 2009
    # Query_time: 4  Lock_time: 0  Rows_sent: 16  Rows_examined: 16
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smiliecache','bbcodecache','ranks')

    # Sat Jan 10 07:51:47 2009
    # Query_time: 49  Lock_time: 0  Rows_sent: 1  Rows_examined: 1888
    use room_4rum;
    SELECT user.useriduser.usernameCOUNT(post.postid) AS replycount
            FROM post 
    AS post
            LEFT JOIN thread 
    AS thread ON (post.threadid thread.threadid)
            
    LEFT JOIN user AS user ON (post.userid user.userid)
            
    WHERE thread.forumid=112 AND thread.firstpostid != post.postid
            GROUP BY post
    .userid
            ORDER BY replycount DESC
            LIMIT 1

    # Sat Jan 10 07:51:51 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:51:55 2009
    # Query_time: 8  Lock_time: 0  Rows_sent: 1  Rows_examined: 929
    use room_4rum;
    SELECT forum.title AS forumCOUNT(attachment.attachmentid) AS countSUM(attachment.filesize) AS bytes
            FROM attachment 
    AS attachmentpost AS postthread AS threadforum AS forum
            WHERE attachment
    .postid post.postid
            
    AND post.threadid=thread.threadid
            
    AND forum.forumid=thread.forumid
            
    AND forum.forumid=112
            GROUP BY thread
    .forumid
            ORDER BY count DESC

    # Sat Jan 10 07:51:55 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:04 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:08 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:14 2009
    # Query_time: 6  Lock_time: 0  Rows_sent: 14  Rows_examined: 14
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:19 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:24 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:27 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 3  Rows_examined: 3
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','pluginlist')

    # Sat Jan 10 07:52:31 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:33 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:36 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:38 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:42 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:44 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:51 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:53 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:52:53 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:53:06 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 14  Rows_examined: 14
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:53:10 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:53:12 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:53:21 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:53:27 2009
    # Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:53:28 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:53:30 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:53:32 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 374
    SELECT user.useriduser.usernameCOUNT(post.postid) AS replycount
            FROM post 
    AS post
            LEFT JOIN thread 
    AS thread ON (post.threadid thread.threadid)
            
    LEFT JOIN user AS user ON (post.userid user.userid)
            
    WHERE thread.forumid=91 AND thread.firstpostid != post.postid
            GROUP BY post
    .userid
            ORDER BY replycount DESC
            LIMIT 1

    # Sat Jan 10 07:53:36 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:53:37 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:53:38 2009
    # Query_time: 6  Lock_time: 0  Rows_sent: 0  Rows_examined: 197
    use room_4rum;
    SELECT forum.title AS forumCOUNT(attachment.attachmentid) AS countSUM(attachment.filesize) AS bytes
            FROM attachment 
    AS attachmentpost AS postthread AS threadforum AS forum
            WHERE attachment
    .postid post.postid
            
    AND post.threadid=thread.threadid
            
    AND forum.forumid=thread.forumid
            
    AND forum.forumid=91
            GROUP BY thread
    .forumid
            ORDER BY count DESC

    # Sat Jan 10 07:53:42 2009
    # Query_time: 5  Lock_time: 0  Rows_sent: 14  Rows_examined: 14
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:53:44 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:53:50 2009
    # Query_time: 5  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    UPDATE session
      SET lastactivity 
    1231599223badlocation 0
      WHERE sessionhash 
    '9f89cc6bbf5ea2f61ac9844f65bb6879'

    # Sat Jan 10 07:53:53 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 41  Rows_examined: 164
    use room_4rum;
    SELECT user.useriduser.optionsuser.username
            
    user.usergroupiduser.displaygroupidwhoread.datelinewhoread.ipaddress
            FROM whoread 
    as whoread
            LEFT JOIN user 
    as user USING (userid)
            
    WHERE whoread.threadid 1555
            
    AND whoread.dateline 0 ORDER BY username

    # Sat Jan 10 07:53:54 2009
    # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:53:59 2009
    # Query_time: 5  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:54:04 2009
    # Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:54:13 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:54:17 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache')

    # Sat Jan 10 07:54:21 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    use room_4rum;
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache')

    # Sat Jan 10 07:54:23 2009
    # Query_time: 3  Lock_time: 0  Rows_sent: 82  Rows_examined: 82
    SELECT titletemplate
      FROM template
      WHERE templateid IN 
    (8069,8171,8070,9024,9023,9025,9020,9019,9296,6935,9248,9249,9250,9512,9515,9524,9269,9270,9271,9272,9466,9529,9528,9530,9533,8779,8780,8785,8784,1377,1378,1455,1457,1462,1461,2893,1600,1601,1602,1603,1604,1605,1606,1622,1631,1687,1710,3180,3179,3178,3177,7509,7511,8064,8063,0,0,0,0,0,0,0,0,4311,6343,6352,6355,8071,8144,8145,9304,9305,9306,9308,9310,9564,9561,9566,9567,9563,9565,9570,9568,9569,9572,9573,9558,9556,9562,9557)

    # Sat Jan 10 07:54:25 2009
    # Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
    SELECT *
      
    FROM datastore
      WHERE title IN 
    ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','bbcodecache'
    Last edited by tiengnhat; Sat 10 Jan '09, 8:23am.

    Comment


    • #3
      I have no idea what they mean. Do you have any add-ons installed?
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X