# Time: 130410  1:34:03
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 32.099663  Lock_time: 0.000045 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365554043;
UPDATE mybb_users
			SET `unreadpms`='0' WHERE uid='924';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 30.585160  Lock_time: 0.000024 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365554043;
UPDATE mybb_users SET lastactive='1365553994', timeonline=timeonline+153  WHERE uid='18964';
# Time: 130410  1:34:21
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 69.389710  Lock_time: 0.000059 Rows_sent: 1  Rows_examined: 8
SET timestamp=1365554061;
SELECT COUNT(pmid) AS pms_unread FROM mybb_privatemessages WHERE uid='19672' AND status='0' AND folder='1';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 70.049459  Lock_time: 0.000023 Rows_sent: 1  Rows_examined: 30
SET timestamp=1365554061;
SELECT COUNT(pmid) AS pms_unread FROM mybb_privatemessages WHERE uid='46557' AND status='0' AND folder='1';
# Time: 130410  1:35:13
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 15.774699  Lock_time: 0.000237 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554113;
SHOW COLUMNS
			FROM mybb_users
			LIKE 'unreadpms';
# Time: 130410  1:35:42
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 29.610004  Lock_time: 0.000245 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554142;
SHOW COLUMNS
			FROM mybb_users
			LIKE 'unreadpms';
# Time: 130410  1:35:46
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 23.485064  Lock_time: 3.895031 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554146;
SHOW COLUMNS
			FROM mybb_users
			LIKE 'unreadpms';
# Time: 130410  1:35:49
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 16.045694  Lock_time: 0.000225 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554149;
SHOW COLUMNS
			FROM mybb_users
			LIKE 'unreadpms';
# Time: 130410  1:35:54
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 7.409903  Lock_time: 0.000045 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365554154;
UPDATE mybb_users
			SET `unreadpms`='0' WHERE uid='970';
# Time: 130410  1:36:05
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 11.339968  Lock_time: 0.000046 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365554165;
UPDATE mybb_users
			SET `unreadpms`='0' WHERE uid='970';
# Time: 130410  1:36:25
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 72.154962  Lock_time: 0.000043 Rows_sent: 1  Rows_examined: 322
SET timestamp=1365554185;
SELECT COUNT(pmid) AS pms_unread FROM mybb_privatemessages WHERE uid='42' AND status='0' AND folder='1';
# Time: 130410  1:39:17
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 96.380866  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554357;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='18964'
			LIMIT 1;
# Time: 130410  1:39:26
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 56.881021  Lock_time: 0.000049 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554366;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='156'
			LIMIT 1;
# Time: 130410  1:39:27
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 86.335591  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554367;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='152'
			LIMIT 1;
# Time: 130410  1:39:29
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 197.876363  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554369;
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'css' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'' ,'global_pending_joinrequests' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error') AND sid IN ('-2','-1','8') ORDER BY sid ASC;
# Time: 130410  1:39:40
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 80.335418  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554380;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='18964'
			LIMIT 1;
# Time: 130410  1:39:45
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 164.606743  Lock_time: 0.000050 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554385;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='16711'
			LIMIT 1;
# Time: 130410  1:39:46
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 27.655716  Lock_time: 0.000224 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554386;
SHOW COLUMNS
			FROM mybb_users
			LIKE 'unreadpms';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 147.143149  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554386;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='970'
			LIMIT 1;
# Time: 130410  1:39:54
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 223.319352  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554394;
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_welcomemembertext' ,'index_welcomeguest' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'index_modcolumn' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_welcomeguesttext' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_pms' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'css' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'' ,'global_pending_joinrequests' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error') AND sid IN ('-2','-1','8') ORDER BY sid ASC;
# Time: 130410  1:40:01
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 15.508850  Lock_time: 0.000031 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365554401;
UPDATE mybb_users
			SET `unreadpms`='0' WHERE uid='19672';
# Time: 130410  1:40:09
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 198.385521  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554409;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='970'
			LIMIT 1;
# Time: 130410  1:40:12
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 184.945926  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554412;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='18964'
			LIMIT 1;
# Time: 130410  1:40:14
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 95.456313  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554414;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='970'
			LIMIT 1;
# Time: 130410  1:40:17
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 32.995915  Lock_time: 0.000236 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554417;
SHOW COLUMNS
			FROM mybb_users
			LIKE 'unreadpms';
# Time: 130410  1:40:38
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 31.050038  Lock_time: 9.780552 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554438;
SHOW COLUMNS
			FROM mybb_users
			LIKE 'unreadpms';
# Time: 130410  1:40:42
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 80.090777  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554442;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='18964'
			LIMIT 1;
# Time: 130410  1:40:54
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 218.995467  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554454;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='152'
			LIMIT 1;
# Time: 130410  1:41:04
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 227.332745  Lock_time: 0.000066 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554464;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='16711'
			LIMIT 1;
# Time: 130410  1:41:13
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 92.847737  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554473;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='970'
			LIMIT 1;
# Time: 130410  1:42:15
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 44.756065  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554535;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='970'
			LIMIT 1;
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 51.148944  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554535;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='18964'
			LIMIT 1;
# Time: 130410  1:42:18
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 46.704410  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554538;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='18964'
			LIMIT 1;
# Time: 130410  1:42:21
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 56.755500  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554541;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='42'
			LIMIT 1;
# Time: 130410  1:42:46
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 62.726232  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554566;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='970'
			LIMIT 1;
# Time: 130410  1:43:05
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 11.010023  Lock_time: 0.000031 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365554585;
UPDATE mybb_users SET lastactive='1365554568', timeonline=timeonline+574  WHERE uid='18964';
# Time: 130410  1:43:30
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 23.838752  Lock_time: 0.000220 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554610;
SHOW COLUMNS
			FROM mybb_users
			LIKE 'unreadpms';
# Time: 130410  1:43:34
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 3.114931  Lock_time: 0.774964 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554614;
SELECT * FROM mybb_sessions WHERE sid='4482f50379807ea00d8408f8caa61610' AND ip='IP ADDRESS HERE' LIMIT 1;
# Time: 130410  1:43:41
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 10.559743  Lock_time: 0.779862 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554621;
SELECT * FROM mybb_sessions WHERE sid='82887b2d183ef2aac6c1a9fa5781805e' AND ip='IP ADDRESS HERE' LIMIT 1;
# Time: 130410  1:43:46
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 15.779248  Lock_time: 0.779269 Rows_sent: 1  Rows_examined: 27
SET timestamp=1365554626;
SELECT COUNT(pmid) AS pms_unread FROM mybb_privatemessages WHERE uid='970' AND status='0' AND folder='1';
# Time: 130410  1:43:54
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 8.459972  Lock_time: 0.000049 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365554634;
UPDATE mybb_users
			SET `unreadpms`='0' WHERE uid='970';
# Time: 130410  1:44:32
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 74.725228  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1365554672;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='970'
			LIMIT 1;
# Time: 130410  1:44:35
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 64.824459  Lock_time: 0.384622 Rows_sent: 1  Rows_examined: 1
SET timestamp=1365554675;
SELECT u.*, f.*
			FROM mybb_users u
			LEFT JOIN mybb_userfields f ON (f.ufid=u.uid)
			WHERE u.uid='924'
			LIMIT 1;
/usr/sbin/mysqld, Version: 5.5.30-1~dotdeb.0-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
# Time: 130410  1:47:26
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 2.851259  Lock_time: 0.000052 Rows_sent: 0  Rows_examined: 1
use SHforum;
SET timestamp=1365554846;
UPDATE
					SHforum.ajax_chat_online
				SET
					dateTime = DATE_SUB(NOW(), interval 6 MINUTE)
				WHERE
					userID='18964' OR userName='USERNAME HERE';
# Time: 130410  1:52:19
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 7.150572  Lock_time: 0.000034 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555139;
UPDATE mybb_users
			SET `unreadpms`='0' WHERE uid='16711';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 6.494938  Lock_time: 0.000029 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555139;
UPDATE mybb_users SET lastactive='1365555118', timeonline=timeonline+4  WHERE uid='18964';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 6.944449  Lock_time: 0.000028 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555139;
UPDATE mybb_users SET lastactive='1365555116', timeonline=timeonline+3  WHERE uid='970';
# Time: 130410  1:52:46
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 2.422716  Lock_time: 0.000025 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555166;
UPDATE mybb_users SET lastactive='1365555159', timeonline=timeonline+7  WHERE uid='970';
# Time: 130410  1:53:04
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 2.801946  Lock_time: 0.000025 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555184;
UPDATE mybb_users SET lastactive='1365555181', timeonline=timeonline+67  WHERE uid='156';
/usr/sbin/mysqld, Version: 5.5.30-1~dotdeb.0-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
# Time: 130410  2:00:55
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 6.812009  Lock_time: 0.000044 Rows_sent: 0  Rows_examined: 0
use SHforum;
SET timestamp=1365555655;
INSERT
			INTO mybb_sf_shouts (`uid`,`shout_msg`,`shout_date`,`shout_ip`)
			VALUES ('3633','Eh','1365555648','75.97.13.189');
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 4.441606  Lock_time: 0.000116 Rows_sent: 1  Rows_examined: 2
SET timestamp=1365555655;
SELECT s.*, u.username, u.usergroup, u.displaygroup FROM mybb_sf_shouts s
							LEFT JOIN mybb_users u ON (u.uid = s.uid)
						WHERE s.id>224338 ORDER by s.id DESC LIMIT 5;
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 2.867774  Lock_time: 0.000021 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555655;
UPDATE mybb_spiders
			SET `lastvisit`='1365555653' WHERE sid='12' LIMIT 1;
# Time: 130410  2:00:59
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 15.545881  Lock_time: 0.000031 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555659;
UPDATE mybb_users SET lastactive='1365555643', timeonline=timeonline+9  WHERE uid='156';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 13.904314  Lock_time: 0.000023 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555659;
UPDATE mybb_users SET lastactive='1365555645', timeonline=timeonline+54  WHERE uid='3';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 11.811194  Lock_time: 0.000025 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555659;
UPDATE mybb_users SET lastactive='1365555647', timeonline=timeonline+60  WHERE uid='18964';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 3.961247  Lock_time: 0.000054 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555659;
UPDATE mybb_users SET lastactive='1365555648', timeonline=timeonline+23  WHERE uid='3633';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 3.960448  Lock_time: 0.000023 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555659;
UPDATE mybb_users SET lastactive='1365555651', timeonline=timeonline+6  WHERE uid='3';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 3.881804  Lock_time: 0.000024 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555659;
UPDATE mybb_users SET lastactive='1365555655', timeonline=timeonline+60  WHERE uid='16711';
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 2.963978  Lock_time: 0.000022 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555659;
UPDATE mybb_users SET lastactive='1365555656', timeonline=timeonline+5  WHERE uid='3';
# Time: 130410  2:01:48
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 38.784519  Lock_time: 0.000025 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555708;
UPDATE mybb_users SET lastactive='1365555669', timeonline=timeonline+2  WHERE uid='3';
# Time: 130410  2:02:13
# User@Host: sonichen[sonichen] @ localhost []
# Query_time: 28.825277  Lock_time: 0.000023 Rows_sent: 0  Rows_examined: 1
SET timestamp=1365555733;
UPDATE mybb_users SET lastactive='1365555703', timeonline=timeonline+44  WHERE uid='19672';
/usr/sbin/mysqld, Version: 5.5.30-1~dotdeb.0-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument