MySQL slow query

محروم.كوم · #1 04-03-2010, 12:30 PM

Hey,
i got email from my hosting and they say that i make too many/long query's to server.

Can you help me to find out what script/mod it cause
Log are here
Code:
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 8.097893 Lock_time: 0.000126 Rows_sent: 30 Rows_examined: 143771
use np16487_forum;
SET timestamp=1270103660;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '1475')
OR
(s.s_private -1 AND s.s_user = '1475')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '1475')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 7.329978 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270103660;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 7.029994 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270103660;
SELECT *

FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 8.067171 Lock_time: 0.000106 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270103660;
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('9d1a95c6c98a362949d4b4ea36d86777', 0, '188.92.74.49', '2af635b9d0a349754e70b5d5e3575d3e', 1270103652, '/index.php', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 5.0; Windows 3.1)', 0, 0);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.772825 Lock_time: 0.000089 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270103891;
UPDATE user
SET
lastvisit = lastactivity,
lastactivity = 1270103886
WHERE userid = 1798;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.755323 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270103891;
SELECT thread.pollid, open, thread.threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public
FROM poll AS poll
INNER JOIN thread AS thread USING (pollid)
WHERE thread.threadid IN (26197)
LIMIT 1;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.767807 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270103891;
SELECT *
FROM style
WHERE (styleid = 5 AND userselect = 1)
OR styleid = 5
ORDER BY styleid ASC
LIMIT 1;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.673684 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270103891;
SELECT *

FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 6.842733 Lock_time: 0.000108 Rows_sent: 0 Rows_examined: 1
use np16487_forum;
SET timestamp=1270104182;
UPDATE thread AS thread,taggregate_temp_1270097760 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.526298 Lock_time: 0.000086 Rows_sent: 0 Rows_examined: 10
use np16487_forum;
SET timestamp=1270130171;
UPDATE thread AS thread,taggregate_temp_1270130160 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.484805 Lock_time: 0.000145 Rows_sent: 30 Rows_examined: 143775
use np16487_forum;
SET timestamp=1270133668;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '102')
OR
(s.s_private -1 AND s.s_user = '102')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '102')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.267070 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270133668;
select s.sid, u.username, u.userid, u.displaygroupid, u.usergroupid
from infernoshoutsessions s
left join user u on (u.userid = s.s_user)
where s.s_activity > 1270133364
group by s_user;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.787158 Lock_time: 0.276306 Rows_sent: 30 Rows_examined: 143775
use np16487_forum;
SET timestamp=1270133668;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '1460')
OR
(s.s_private -1 AND s.s_user = '1460')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '1460')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.723730 Lock_time: 0.230198 Rows_sent: 30 Rows_examined: 143775
SET timestamp=1270133668;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '600')
OR
(s.s_private -1 AND s.s_user = '600')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '600')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.373422 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270133668;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.799905 Lock_time: 0.273214 Rows_sent: 30 Rows_examined: 143775
SET timestamp=1270133668;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '65')
OR
(s.s_private -1 AND s.s_user = '65')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '65')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.498615 Lock_time: 0.000095 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270133668;
INSERT INTO thread
(prefixid, postusername, postuserid, title, iconid, visible, forumid, description, similar, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount)
VALUES
('', 'Chief', 600, '[0104] VA_-_Teckno.Com_Summer_2008-2CD-2008-FQS', 2, 1, 25, '', '834, 6309, 10533, 4660, 14530', 1270133663, 1, 0, 1270133663, 'Chief', 0, 0, 0);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.362451 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270139999;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.362161 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270139999;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.593128 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270139999;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.652272 Lock_time: 0.000030 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270139999;
UPDATE thread
SET forumid = 24

WHERE threadid IN(28752);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.749081 Lock_time: 0.000042 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270147486;
UPDATE thread SET
lastpost = 1270147479,
lastposter = 'Err0r',
lastpostid = 41306,
replycount = replycount + 1
WHERE threadid = 28841;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.701838 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270147486;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.855369 Lock_time: 0.103247 Rows_sent: 30 Rows_examined: 143780
use np16487_forum;
SET timestamp=1270147486;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '1460')
OR
(s.s_private -1 AND s.s_user = '1460')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '1460')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.752140 Lock_time: 0.000117 Rows_sent: 30 Rows_examined: 143780
SET timestamp=1270147486;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '2')
OR
(s.s_private -1 AND s.s_user = '2')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '2')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.553296 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270147486;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.137945 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270147486;
SELECT *

FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.084099 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270147486;
SELECT *

FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.218605 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270147486;
SELECT *

FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.077872 Lock_time: 0.000078 Rows_sent: 0 Rows_examined: 14
SET timestamp=1270148221;
UPDATE thread AS thread,taggregate_temp_1270148160 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.104941 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270148221;
select s.sid, u.username, u.userid, u.displaygroupid, u.usergroupid
from infernoshoutsessions s
left join user u on (u.userid = s.s_user)
where s.s_activity > 1270147918
group by s_user;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.678671 Lock_time: 0.002494 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
select s.sid, u.username, u.userid, u.displaygroupid, u.usergroupid
from infernoshoutsessions s
left join user u on (u.userid = s.s_user)
where s.s_activity > 1270149408
group by s_user;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.698018 Lock_time: 0.008527 Rows_sent: 30 Rows_examined: 143781
SET timestamp=1270149713;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '4')
OR
(s.s_private -1 AND s.s_user = '4')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '4')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.913501 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
SELECT *

FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.527385 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.035847 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.042436 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.318430 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.085331 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.381246 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.188044 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.588481 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.091045 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.721324 Lock_time: 0.000091 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270149713;
INSERT INTO thread
(prefixid, postusername, postuserid, title, iconid, visible, forumid, description, similar, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount)
VALUES
('', 'calibersmith666', 868, '[0104] Pants & Corset - Unknown White Label', 21, 1, 35, '', '4664, 23558, 3305, 24454, 23167', 1270149707, 1, 0, 1270149707, 'calibersmith666', 0, 0, 0);

# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.478558 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270151786;
select s.sid, u.username, u.userid, u.displaygroupid, u.usergroupid
from infernoshoutsessions s
left join user u on (u.userid = s.s_user)
where s.s_activity > 1270151480
group by s_user;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.508741 Lock_time: 0.000110 Rows_sent: 0 Rows_examined: 16
SET timestamp=1270151786;
UPDATE thread AS thread,taggregate_temp_1270151760 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.478464 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270154245;
SELECT title, template
FROM template
WHERE templateid IN (889,0,894,898,899,1600,898,1787,1791,1797,1106,11 05,1107,1102,1101,1378,1788,1330,1331,1332,1598,16 01,1610,1795,1352,1353,1354,1552,1615,1614,1616,16 19,1677,1678,1679,907,909,917,920,924,925,926,927, 928,929,930,931,932,933,934,935,939,936,937,938,94 0,941,942,943,944,945,947,981,1810,1034,1034,1035, 1039,1033,970,971,972,973,974,975,999,1010,1011,16 74,1851,1852,1853,1854,1855,1856,1806,1812,1849,18 50,1857);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.484281 Lock_time: 0.000115 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270154245;
INSERT INTO thread
(prefixid, postusername, postuserid, title, iconid, visible, forumid, description, similar, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount)
VALUES
('', 'VisousSupra', 102, '[0104] Barcelona_Project-Tears_In_Rain-(CHA00)-Vinyl-2009-NRG', 0, 1, 40, '', '10533, 4660, 16764, 17676', 1270154239, 1, 0, 1270154239, 'VisousSupra', 0, 0, 0);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.509818 Lock_time: 0.002146 Rows_sent: 30 Rows_examined: 143782
SET timestamp=1270154245;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '61')
OR
(s.s_private -1 AND s.s_user = '61')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '61')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.397247 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270154245;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.851221 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270154245;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.481478 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270154245;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.103355 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270154245;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.173729 Lock_time: 0.000083 Rows_sent: 0 Rows_examined: 4
SET timestamp=1270155419;
UPDATE thread AS thread,taggregate_temp_1270155360 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.256426 Lock_time: 0.000161 Rows_sent: 30 Rows_examined: 143782
SET timestamp=1270155419;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '1')
OR
(s.s_private -1 AND s.s_user = '1')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '1')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.274873 Lock_time: 0.000154 Rows_sent: 30 Rows_examined: 143782
SET timestamp=1270155419;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '61')
OR
(s.s_private -1 AND s.s_user = '61')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '61')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.075700 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270159854;
SELECT title, template
FROM template
WHERE templateid IN (889,0,894,898,899,1600,898,1787,1791,1797,1106,11 05,1107,1102,1101,1378,1788,1330,1331,1332,1598,16 01,1610,1795,1352,1353,1354,1552,1615,1614,1616,16 19,1677,1678,1679,907,909,917,920,924,925,926,927, 928,929,930,931,932,933,934,935,939,936,937,938,94 0,941,942,943,944,945,947,981,1810,1034,1034,1035, 1039,1033,970,971,972,973,974,975,999,1010,1011,16 74,1851,1852,1853,1854,1855,1856,1806,1812,1849,18 50,1857);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.097505 Lock_time: 0.000087 Rows_sent: 13 Rows_examined: 13
SET timestamp=1270159854;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.124734 Lock_time: 0.000131 Rows_sent: 0 Rows_examined: 26
SET timestamp=1270159854;
UPDATE thread AS thread,taggregate_temp_1270158960 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.208397 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270165974;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.756725 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270165974;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.296387 Lock_time: 0.000052 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270165974;
INSERT INTO thread
(prefixid, postusername, postuserid, title, iconid, visible, forumid, description, similar, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount)
VALUES
('3', 'VisousSupra', 102, '[0104] CeeAnDee_-_Get_Wicked-(DSR-007)-WEB-2009-HB', 0, 1, 57, '', '10533, 4660, 16764, 23376, 25505', 1270165968, 1, 0, 1270165968, 'VisousSupra', 0, 0, 0);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.341227 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270165974;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.171268 Lock_time: 0.000077 Rows_sent: 0 Rows_examined: 6
use np16487_forum;
SET timestamp=1270169971;
UPDATE thread AS thread,taggregate_temp_1270169760 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.469853 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270178369;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.599361 Lock_time: 0.000098 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270178369;
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('ea9a993bdb3c9049a3423b4048c43cc2', 0, '70.173.151.161', '56813047bb5eb0b69b07e98982215cdf', 1270178365, '/', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.5 (KHTML, like Gecko) Chrome/4.1.249.1045 Safari/532.5', 0, 0);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.593921 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270178369;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 7.733233 Lock_time: 0.000111 Rows_sent: 0 Rows_examined: 24
use np16487_forum;
SET timestamp=1270178409;
UPDATE thread AS thread,taggregate_temp_1270173360 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.736113 Lock_time: 0.000100 Rows_sent: 0 Rows_examined: 8
SET timestamp=1270180852;
UPDATE thread AS thread,taggregate_temp_1270180560 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.737710 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270180852;
select s.sid, u.username, u.userid, u.displaygroupid, u.usergroupid
from infernoshoutsessions s
left join user u on (u.userid = s.s_user)
where s.s_activity > 1270180548
group by s_user;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 10.783811 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270191689;
UPDATE thread SET
lastpost = 1270191677,
lastposter = 'FroG',
lastpostid = 41326,
replycount = replycount + 1
WHERE threadid = 28841;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 10.105634 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 8.773108 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 8.578270 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 8.852348 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 8.627081 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 10.631851 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.041378 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 10.593474 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.643510 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.796022 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 8.207281 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 8.749934 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 10.025156 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270191689;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.838173 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270207729;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.732396 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270207729;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.239138 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270207729;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.537857 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270207729;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.532388 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270207729;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.773900 Lock_time: 0.007972 Rows_sent: 0 Rows_examined: 26
use np16487_forum;
SET timestamp=1270209416;
UPDATE thread AS thread,taggregate_temp_1270209360 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.868968 Lock_time: 0.000155 Rows_sent: 30 Rows_examined: 143831
SET timestamp=1270209416;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '102')
OR
(s.s_private -1 AND s.s_user = '102')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '102')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.714530 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270218959;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.221525 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270218959;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.675625 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270218959;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');

# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.183955 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270218959;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.104330 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270218959;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.820769 Lock_time: 0.000126 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270218959;
INSERT INTO thread
(prefixid, postusername, postuserid, title, iconid, visible, forumid, description, similar, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount)
VALUES
('', '.:TaraBoy:.', 2, '[0204] 31_Records-Method_One_and_Stunna-_31R044_-WEB-2010-DEF', 0, 1, 65, '', '25461', 1270218954, 1, 0, 1270218954, '.:TaraBoy:.', 0, 0, 0);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.003442 Lock_time: 0.000098 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270219849;
INSERT INTO thread
(prefixid, postusername, postuserid, title, iconid, visible, forumid, description, similar, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount)
VALUES
('', 'wakka880', 28, '[0204] Anybody Got . . . Sharkey - Today\'s The Day (Master)', 0, 1, 73, '', '4660, 10533, 18572, 18191, 23639', 1270219845, 1, 0, 1270219845, 'wakka880', 0, 0, 0);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.616239 Lock_time: 0.000084 Rows_sent: 0 Rows_examined: 30
SET timestamp=1270231171;
UPDATE thread AS thread,taggregate_temp_1270230960 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 10.754156 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 12.967207 Lock_time: 0.000135 Rows_sent: 30 Rows_examined: 143936
SET timestamp=1270236023;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '0')
OR
(s.s_private -1 AND s.s_user = '0')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '0')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 11.714374 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 11.406593 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 10.519306 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 11.933628 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 12.885434 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 6.985682 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 12.441205 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 10.702413 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 10.249335 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.472162 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 7.710561 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 12.445830 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 6.322697 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 12.572364 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.589556 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270236023;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.481267 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270237161;
select * from infernoshoutusers where s_user='102';
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.958065 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270237161;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.260981 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270237161;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.678043 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270237161;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.496618 Lock_time: 0.000030 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270237161;
INSERT INTO force_read_users
(force_read_userid, force_read_threadid)
VALUES
('1804', '5');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.112925 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270237161;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.110968 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270237161;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.051170 Lock_time: 0.017997 Rows_sent: 0 Rows_examined: 20
use np16487_forum;
SET timestamp=1270238173;
UPDATE thread AS thread,taggregate_temp_1270238160 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.030014 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270238173;
select * from infernoshoutusers where s_user='1460';
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.030397 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270238173;
select * from infernoshoutusers where s_user='1460';
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.117282 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270243124;
select s.sid, u.username, u.userid, u.displaygroupid, u.usergroupid
from infernoshoutsessions s
left join user u on (u.userid = s.s_user)
where s.s_activity > 1270242818
group by s_user;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.217074 Lock_time: 0.048272 Rows_sent: 30 Rows_examined: 143936
use np16487_forum;
SET timestamp=1270243124;
select s.*, u.username, u.displaygroupid, u.usergroupid, u.userid, o.*
from infernoshout s
left join user u on (u.userid = s.s_user)
left join infernoshoutusers o on (o.s_user = s.s_user)
where
(
(s.s_private = -1)
OR
(s.s_private = '1576')
OR
(s.s_private -1 AND s.s_user = '1576')
)
and u.userid not in (-1)
and
(
o.s_silenced = '0'
OR
(o.s_silenced '0' AND u.userid = '1576')
)

order by s.s_time desc
limit 30;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.171523 Lock_time: 0.000094 Rows_sent: 0 Rows_examined: 22
SET timestamp=1270243124;
UPDATE thread AS thread,taggregate_temp_1270241760 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.121303 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270267007;
select s.sid, u.username, u.userid, u.displaygroupid, u.usergroupid
from infernoshoutsessions s
left join user u on (u.userid = s.s_user)
where s.s_activity > 1270266704
group by s_user;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.148377 Lock_time: 0.000101 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270267007;
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('86020162bb1f2518f39bc08a69567680', 0, '79.196.54.174', 'e312ccfa6d4cfdfb6cd755bf2833a046', 1270267004, '/', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.2) Gecko/20100316 Firefox/3.6.2 (.NET CLR 3.5.30729)', 0, 0);
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 7.688589 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270270095;
SELECT *
FROM style
WHERE (styleid = 5)
OR styleid = 5
ORDER BY styleid ASC
LIMIT 1;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 7.690976 Lock_time: 0.000086 Rows_sent: 0 Rows_examined: 1
SET timestamp=1270270095;
UPDATE thread AS thread,taggregate_temp_1270263360 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 7.336222 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270270095;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 7.375023 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270270095;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 7.653486 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270270095;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 7.372087 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270270095;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 6.364703 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270270095;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.525648 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270270095;
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 5.574356 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1270270095;
SELECT *

FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache');
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 3.071879 Lock_time: 0.000099 Rows_sent: 0 Rows_examined: 8
SET timestamp=1270271663;
UPDATE thread AS thread,taggregate_temp_1270270560 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.009888 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use np16487_forum;
SET timestamp=1270277965;
select s.sid, u.username, u.userid, u.displaygroupid, u.usergroupid
from infernoshoutsessions s
left join user u on (u.userid = s.s_user)
where s.s_activity > 1270277661
group by s_user;
# User@Host: np16487_np16487[np16487_np16487] @ localhost []
# Query_time: 4.088425 Lock_time: 0.000099 Rows_sent: 0 Rows_examined: 1
use np16487_forum;
SET timestamp=1270277965;
UPDATE thread AS thread,taggregate_temp_1270274160 AS aggregate
SET thread.views = thread.views + aggregate.views
WHERE thread.threadid = aggregate.threadid;
Thanks in advance. __DEFINE_LIKE_SHARE__