Time Before: 0.00035 seconds
Time After: 0.00045 seconds
Time Taken: 0.00010 seconds
Memory Before: 512.938 KB
Memory After: 537.867 KB
Memory Used: 24.930 KB
Time Before: 0.00047 seconds
Time After: 0.00062 seconds
Time Taken: 0.00015 seconds
Memory Before: 537.805 KB
Memory After: 538.719 KB
Memory Used: 0.914 KB
SET @@sql_mode = ''
Time Before: 0.00069 seconds
Time After: 0.00076 seconds
Time Taken: 0.00007 seconds
Memory Before: 539.273 KB
Memory After: 539.797 KB
Memory Used: 0.523 KB
SELECT *
FROM datastore
WHERE title IN ('navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 16 | Using index condition |
Time Before: 0.00101 seconds
Time After: 0.00131 seconds
Time Taken: 0.00030 seconds
Memory Before: 542.531 KB
Memory After: 543.383 KB
Memory Used: 0.852 KB
Time Before: 0.00077 seconds
Time After: 0.00187 seconds
Time Taken: 0.00110 seconds
Memory Before: 539.047 KB
Memory After: 1,256.711 KB
Memory Used: 717.664 KB
SELECT *
FROM datastore
WHERE title IN ('dbtech_downloads_category','dbtech_downloads_domain','dbtech_downloads_extension','dbtech_downloads_extensiongroup')| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 4 | Using index condition |
Time Before: 0.00275 seconds
Time After: 0.00287 seconds
Time Taken: 0.00012 seconds
Memory Before: 1,822.461 KB
Memory After: 1,822.961 KB
Memory Used: 0.500 KB
SELECT * FROM session WHERE userid = 0 AND host = '216.73.216.28' AND idhash = 'ea5a359a73a8141a16de516480d33c34' LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | session | ref | guest_lookup,user_activity | guest_lookup | 55 | const,const,const | 2 | Using where |
Time Before: 0.00319 seconds
Time After: 0.00331 seconds
Time Taken: 0.00012 seconds
Memory Before: 1,844.664 KB
Memory After: 1,845.273 KB
Memory Used: 0.609 KB
SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroupinfo AS lang_phrasegroupinfo, options AS lang_options, languagecode AS lang_code, charset AS lang_charset, locale AS lang_locale, imagesoverride AS lang_imagesoverride, dateoverride AS lang_dateoverride, timeoverride AS lang_timeoverride, registereddateoverride AS lang_registereddateoverride, calformat1override AS lang_calformat1override, calformat2override AS lang_calformat2override, logdateoverride AS lang_logdateoverride, decimalsep AS lang_decimalsep, thousandsep AS lang_thousandsep FROM language WHERE languageid = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | language | system | PRIMARY | 1 |
Time Before: 0.00360 seconds
Time After: 0.00379 seconds
Time Taken: 0.00019 seconds
Memory Before: 1,855.859 KB
Memory After: 1,855.945 KB
Memory Used: 0.086 KB
Time Before: 0.00295 seconds
Time After: 0.00384 seconds
Time Taken: 0.00089 seconds
Memory Before: 1,837.742 KB
Memory After: 1,902.031 KB
Memory Used: 64.289 KB
SELECT *
FROM datastore
WHERE title IN ('dbtech_downloads_domain','dbtech_downloads_extension')| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 2 | Using index condition |
Time Before: 0.00429 seconds
Time After: 0.00435 seconds
Time Taken: 0.00007 seconds
Memory Before: 1,950.625 KB
Memory After: 1,951.117 KB
Memory Used: 0.492 KB
SELECT * FROM style WHERE (styleid = 4 AND userselect = 1) OR styleid = 4 ORDER BY styleid ASC LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 |
Time Before: 0.04716 seconds
Time After: 0.04733 seconds
Time Taken: 0.00017 seconds
Memory Before: 2,213.516 KB
Memory After: 2,214.125 KB
Memory Used: 0.609 KB
SELECT profilefieldid FROM profilefield WHERE profilefieldid = 2
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | profilefield | const | PRIMARY | PRIMARY | 2 | const | 1 | Using index |
Time Before: 0.04843 seconds
Time After: 0.04854 seconds
Time Taken: 0.00010 seconds
Memory Before: 2,737.672 KB
Memory After: 2,738.234 KB
Memory Used: 0.563 KB
SELECT data, expires, locktime, serialized FROM cache WHERE cacheid = 'showgroups.groupcache'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | Impossible WHERE noticed after reading const tables |
Time Before: 0.04905 seconds
Time After: 0.04918 seconds
Time Taken: 0.00013 seconds
Memory Before: 2,791.016 KB
Memory After: 2,791.531 KB
Memory Used: 0.516 KB
SELECT user.*, usergroup.title, user.options, usertextfield.buddylist, userfield.field2, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom FROM user AS user LEFT JOIN usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids)) LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) WHERE (usergroup.genericoptions & 1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | avatar | system | PRIMARY | 0 | Const row not found | |||
| 1 | SIMPLE | customavatar | system | PRIMARY | 0 | Const row not found | |||
| 1 | SIMPLE | user | ALL | usergroupid | 15605 | ||||
| 1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | underdog_vbulletin.user.userid | 1 | |
| 1 | SIMPLE | usertextfield | eq_ref | PRIMARY | PRIMARY | 4 | underdog_vbulletin.user.userid | 1 | |
| 1 | SIMPLE | usergroup | ALL | PRIMARY | 9 | Using where; Using join buffer (flat, BNL join) |
Time Before: 0.04965 seconds
Time After: 0.44391 seconds
Time Taken: 0.39426 seconds
Memory Before: 2,794.664 KB
Memory After: 2,801.445 KB
Memory Used: 6.781 KB
REPLACE INTO cache
SET cacheid = 'showgroups.groupcache',
expires = 1762121746,
created = 1762110946,
locktime = 0,
data = "a:2:{s:14:\"ADMINISTRATORS\";a:2:{s:8:\"UNDERDOG\";a:89:{s:6:\"userid\";s:1:\"4\";s:11:\"usergroupid\";s:1:\"6\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"2\";s:8:\"username\";s:8:\"Underdog\";s:8:\"password\";s:32:\"8106ac73b2e13548ad9ddbfdf7710b06\";s:12:\"passworddate\";s:10:\"2015-02-12\";s:5:\"email\";s:18:\"ccjurist@gmail.com\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:10:\"showvbcode\";s:1:\"0\";s:9:\"usertitle\";s:9:\"Micro Dog\";s:11:\"customtitle\";s:1:\"0\";s:8:\"joindate\";s:10:\"1063558800\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1435283080\";s:12:\"lastactivity\";s:10:\"1435285059\";s:8:\"lastpost\";s:10:\"1435283068\";s:5:\"posts\";s:1:\"6\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:2:\"-8\";s:7:\"pmpopup\";s:1:\"0\";s:8:\"avatarid\";s:2:\"66\";s:14:\"avatarrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45108439\";s:8:\"birthday\";s:10:\"04-01-1969\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"1\";s:9:\"ipaddress\";s:0:\"\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"0\";s:3:\"msn\";s:0:\"\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:30:\"#FEp0T0kRdrRbN$YG:va!)pa\'Y9\';0\";s:13:\"autosubscribe\";s:2:\"-1\";s:15:\"birthday_search\";s:10:\"1969-04-01\";s:18:\"profilepicrevision\";s:1:\"0\";s:12:\"showbirthday\";s:1:\"2\";s:5:\"skype\";s:0:\"\";s:12:\"adminoptions\";s:1:\"0\";s:10:\"lastpostid\";s:4:\"2152\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:13:\"profilevisits\";s:5:\"29497\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:32:\"54e1576d8211e00609b2e9f53d96445e\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:32:\"dbtech_downloads_downloads_today\";s:1:\"0\";s:36:\"dbtech_downloads_download_size_today\";s:1:\"0\";s:27:\"dbtech_downloads_favourites\";N;s:23:\"dbtech_downloads_banned\";s:1:\"0\";s:31:\"dbtech_downloads_comment_notifs\";N;s:5:\"title\";s:14:\"Administrators\";s:9:\"buddylist\";s:0:\"\";s:6:\"field2\";s:0:\"\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:7:\"avwidth\";N;s:8:\"avheight\";N;s:13:\"avwidth_thumb\";N;s:14:\"avheight_thumb\";N;s:14:\"filedata_thumb\";N;s:9:\"hascustom\";s:1:\"0\";}s:12:\"THE UNDERDOG\";a:89:{s:6:\"userid\";s:1:\"2\";s:11:\"usergroupid\";s:1:\"6\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"6\";s:8:\"username\";s:12:\"The Underdog\";s:8:\"password\";s:32:\"2d6938e547e56bc67c4892ce871fb1c0\";s:12:\"passworddate\";s:10:\"2013-05-06\";s:5:\"email\";s:21:\"michael@simkinlaw.com\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:26:\"http://www.underdoglaw.com\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:10:\"showvbcode\";s:1:\"2\";s:9:\"usertitle\";s:13:\"Administrator\";s:11:\"customtitle\";s:1:\"0\";s:8:\"joindate\";s:10:\"1070474400\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1350757280\";s:12:\"lastactivity\";s:10:\"1367866264\";s:8:\"lastpost\";s:10:\"1330549694\";s:5:\"posts\";s:3:\"149\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:2:\"-8\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:3:\"110\";s:14:\"avatarrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45113046\";s:8:\"birthday\";s:10:\"04-01-1969\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"1\";s:9:\"ipaddress\";s:13:\"24.130.171.87\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"0\";s:3:\"msn\";s:0:\"\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:7:\"pmtotal\";s:1:\"1\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:30:\":#y[:$l;7`M:qUq$/@vgpqf:}@)NeV\";s:13:\"autosubscribe\";s:2:\"-1\";s:15:\"birthday_search\";s:10:\"1969-04-01\";s:18:\"profilepicrevision\";s:1:\"0\";s:12:\"showbirthday\";s:1:\"0\";s:5:\"skype\";s:0:\"\";s:12:\"adminoptions\";s:1:\"2\";s:10:\"lastpostid\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:13:\"profilevisits\";s:5:\"32839\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:32:\"76f8aa6dd5e7c57dd980216677457130\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:32:\"dbtech_downloads_downloads_today\";s:1:\"0\";s:36:\"dbtech_downloads_download_size_today\";s:1:\"0\";s:27:\"dbtech_downloads_favourites\";N;s:23:\"dbtech_downloads_banned\";s:1:\"0\";s:31:\"dbtech_downloads_comment_notifs\";N;s:5:\"title\";s:14:\"Administrators\";s:9:\"buddylist\";s:0:\"\";s:6:\"field2\";s:11:\"Los Angeles\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:7:\"avwidth\";N;s:8:\"avheight\";N;s:13:\"avwidth_thumb\";N;s:14:\"avheight_thumb\";N;s:14:\"filedata_thumb\";N;s:9:\"hascustom\";s:1:\"0\";}}s:6:\"BANNED\";a:8:{s:10:\"ZJNY5JXLF9\";a:89:{s:6:\"userid\";s:2:\"37\";s:11:\"usergroupid\";s:1:\"9\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"9\";s:8:\"username\";s:10:\"zjny5jxlf9\";s:8:\"password\";s:32:\"429c64eb4bb378de55cdd3c7cc98df80\";s:12:\"passworddate\";s:10:\"2005-02-04\";s:5:\"email\";s:29:\"sourcream@bakedpotato2005.biz\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:10:\"showvbcode\";s:1:\"0\";s:9:\"usertitle\";s:14:\"Minimal Doggie\";s:11:\"customtitle\";s:1:\"0\";s:8:\"joindate\";s:10:\"1107536400\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1107989700\";s:12:\"lastactivity\";s:10:\"1108412400\";s:8:\"lastpost\";s:1:\"0\";s:5:\"posts\";s:1:\"0\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:3:\"-12\";s:7:\"pmpopup\";s:1:\"0\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45105152\";s:8:\"birthday\";s:10:\"01-01-1969\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"1\";s:9:\"ipaddress\";s:14:\"200.73.174.183\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"0\";s:3:\"msn\";s:0:\"\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:3:\"ES.\";s:13:\"autosubscribe\";s:2:\"-1\";s:15:\"birthday_search\";s:10:\"1969-01-01\";s:18:\"profilepicrevision\";s:1:\"0\";s:12:\"showbirthday\";s:1:\"2\";s:5:\"skype\";s:0:\"\";s:12:\"adminoptions\";s:1:\"0\";s:10:\"lastpostid\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:13:\"profilevisits\";s:5:\"18574\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:0:\"\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:32:\"dbtech_downloads_downloads_today\";s:1:\"0\";s:36:\"dbtech_downloads_download_size_today\";s:1:\"0\";s:27:\"dbtech_downloads_favourites\";N;s:23:\"dbtech_downloads_banned\";s:1:\"0\";s:31:\"dbtech_downloads_comment_notifs\";N;s:5:\"title\";s:6:\"banned\";s:9:\"buddylist\";s:0:\"\";s:6:\"field2\";s:0:\"\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:7:\"avwidth\";N;s:8:\"avheight\";N;s:13:\"avwidth_thumb\";N;s:14:\"avheight_thumb\";N;s:14:\"filedata_thumb\";N;s:9:\"hascustom\";s:1:\"0\";}s:10:\"JJRRZG12RL\";a:89:{s:6:\"userid\";s:2:\"39\";s:11:\"usergroupid\";s:1:\"9\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"9\";s:8:\"username\";s:10:\"jjrrzg12rl\";s:8:\"password\";s:32:\"71d174cd8b412b0e2e20e44ad9554891\";s:12:\"passworddate\";s:10:\"2005-02-14\";s:5:\"email\";s:31:\"sneeze@bagelsandcreamcheese.biz\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:10:\"showvbcode\";s:1:\"0\";s:9:\"usertitle\";s:14:\"Minimal Doggie\";s:11:\"customtitle\";s:1:\"0\";s:8:\"joindate\";s:10:\"1108400400\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1108751991\";s:12:\"lastactivity\";s:10:\"1108751991\";s:8:\"lastpost\";s:1:\"0\";s:5:\"posts\";s:1:\"0\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:3:\"-12\";s:7:\"pmpopup\";s:1:\"0\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45105152\";s:8:\"birthday\";s:10:\"01-01-1969\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"1\";s:9:\"ipaddress\";s:14:\"200.73.174.183\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"0\";s:3:\"msn\";s:0:\"\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:3:\"x~c\";s:13:\"autosubscribe\";s:2:\"-1\";s:15:\"birthday_search\";s:10:\"1969-01-01\";s:18:\"profilepicrevision\";s:1:\"0\";s:12:\"showbirthday\";s:1:\"2\";s:5:\"skype\";s:0:\"\";s:12:\"adminoptions\";s:1:\"0\";s:10:\"lastpostid\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:13:\"profilevisits\";s:5:\"11780\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:0:\"\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:32:\"dbtech_downloads_downloads_today\";s:1:\"0\";s:36:\"dbtech_downloads_download_size_today\";s:1:\"0\";s:27:\"dbtech_downloads_favourites\";N;s:23:\"dbtech_downloads_banned\";s:1:\"0\";s:31:\"dbtech_downloads_comment_notifs\";N;s:5:\"title\";s:6:\"banned\";s:9:\"buddylist\";s:0:\"\";s:6:\"field2\";s:0:\"\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:7:\"avwidth\";N;s:8:\"avheight\";N;s:13:\"avwidth_thumb\";N;s:14:\"avheight_thumb\";N;s:14:\"filedata_thumb\";N;s:9:\"hascustom\";s:1:\"0\";}s:10:\"V650YWFDM1\";a:89:{s:6:\"userid\";s:2:\"40\";s:11:\"usergroupid\";s:1:\"9\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"9\";s:8:\"username\";s:10:\"v650ywfdm1\";s:8:\"password\";s:32:\"cb76e40fd96d5b71d2568d86e2ff41f6\";s:12:\"passworddate\";s:10:\"2005-02-18\";s:5:\"email\";s:23:\"marty@hottamlideals.biz\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:10:\"showvbcode\";s:1:\"1\";s:9:\"usertitle\";s:14:\"Minimal Doggie\";s:11:\"customtitle\";s:1:\"0\";s:8:\"joindate\";s:10:\"1108762259\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1108762259\";s:12:\"lastactivity\";s:10:\"1109014349\";s:8:\"lastpost\";s:1:\"0\";s:5:\"posts\";s:1:\"0\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:3:\"-12\";s:7:\"pmpopup\";s:1:\"0\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45108503\";s:8:\"birthday\";s:10:\"01-01-1969\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"1\";s:9:\"ipaddress\";s:14:\"200.73.174.183\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"0\";s:3:\"msn\";s:0:\"\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:3:\"H\'V\";s:13:\"autosubscribe\";s:2:\"-1\";s:15:\"birthday_search\";s:10:\"1969-01-01\";s:18:\"profilepicrevision\";s:1:\"0\";s:12:\"showbirthday\";s:1:\"2\";s:5:\"skype\";s:0:\"\";s:12:\"adminoptions\";s:1:\"0\";s:10:\"lastpostid\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:13:\"profilevisits\";s:5:\"10127\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:0:\"\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:32:\"dbtech_downloads_downloads_today\";s:1:\"0\";s:36:\"dbtech_downloads_download_size_today\";s:1:\"0\";s:27:\"dbtech_downloads_favourites\";N;s:23:\"dbtech_downloads_banned\";s:1:\"0\";s:31:\"dbtech_downloads_comment_notifs\";N;s:5:\"title\";s:6:\"banned\";s:9:\"buddylist\";s:0:\"\";s:6:\"field2\";s:0:\"\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:7:\"avwidth\";N;s:8:\"avheight\";N;s:13:\"avwidth_thumb\";N;s:14:\"avheight_thumb\";N;s:14:\"filedata_thumb\";N;s:9:\"hascustom\";s:1:\"0\";}s:5:\"H123H\";a:89:{s:6:\"userid\";s:2:\"42\";s:11:\"usergroupid\";s:1:\"9\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"9\";s:8:\"username\";s:5:\"h123h\";s:8:\"password\";s:32:\"9b3bfd172d270bded72f7a0272c01a9f\";s:12:\"passworddate\";s:10:\"2005-03-01\";s:5:\"email\";s:12:\"moda@msn.com\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:10:\"showvbcode\";s:1:\"1\";s:9:\"usertitle\";s:14:\"Minimal Doggie\";s:11:\"customtitle\";s:1:\"0\";s:8:\"joindate\";s:10:\"1109724327\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1109724327\";s:12:\"lastactivity\";s:10:\"1109724360\";s:8:\"lastpost\";s:1:\"0\";s:5:\"posts\";s:1:\"0\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:2:\"-8\";s:7:\"pmpopup\";s:1:\"0\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45108567\";s:8:\"birthday\";s:10:\"01-01-1970\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:1:\"1\";s:9:\"ipaddress\";s:13:\"69.111.18.128\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"0\";s:3:\"msn\";s:0:\"\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:3:\"{%&\";s:13:\"autosubscribe\";s:2:\"-1\";s:15:\"birthday_search\";s:10:\"1970-01-01\";s:18:\"profilepicrevision\";s:1:\"0\";s:12:\"showbirthday\";s:1:\"2\";s:5:\"skype\";s:0:\"\";s:12:\"adminoptions\";s:1:\"0\";s:10:\"lastpostid\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:13:\"profilevisits\";s:5:\"12590\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:0:\"\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:32:\"dbtech_downloads_downloads_today\";s:1:\"0\";s:36:\"dbtech_downloads_download_size_today\";s:1:\"0\";s:27:\"dbtech_downloads_favourites\";N;s:23:\"dbtech_downloads_banned\";s:1:\"0\";s:31:\"dbtech_downloads_comment_notifs\";N;s:5:\"title\";s:6:\"banned\";s:9:\"buddylist\";s:0:\"\";s:6:\"field2\";s:0:\"\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:7:\"avwidth\";N;s:8:\"avheight\";N;s:13:\"avwidth_thumb\";N;s:14:\"avheight_thumb\";N;s:14:\"filedata_thumb\";N;s:9:\"hascustom\";s:1:\"0\";}s:11:\"FILESHARING\";a:89:{s:6:\"userid\";s:2:\"73\";s:11:\"usergroupid\";s:1:\"9\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"9\";s:8:\"username\";s:11:\"FileSharing\";s:8:\"password\";s:32:\"0a200fb4aca0a3cd25b455f768f030dc\";s:12:\"passworddate\";s:10:\"2006-01-27\";s:5:\"email\";s:20:\"linktohome@gmail.com\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:10:\"showvbcode\";s:1:\"1\";s:9:\"usertitle\";s:14:\"Minimal Doggie\";s:11:\"customtitle\";s:1:\"0\";s:8:\"joindate\";s:10:\"1138400880\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1138400934\";s:12:\"lastactivity\";s:10:\"1138400880\";s:8:\"lastpost\";s:1:\"0\";s:5:\"posts\";s:1:\"0\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:2:\"-8\";s:7:\"pmpopup\";s:1:\"0\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:7:\"options\";s:8:\"45108311\";s:8:\"birthday\";s:10:\"05-05-1980\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:2:\"-1\";s:9:\"ipaddress\";s:15:\"207.200.116.196\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"1\";s:3:\"msn\";s:0:\"\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:3:\"[Ch\";s:13:\"autosubscribe\";s:2:\"-1\";s:15:\"birthday_search\";s:10:\"1980-05-05\";s:18:\"profilepicrevision\";s:1:\"0\";s:12:\"showbirthday\";s:1:\"0\";s:5:\"skype\";s:0:\"\";s:12:\"adminoptions\";s:1:\"0\";s:10:\"lastpostid\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:13:\"profilevisits\";s:5:\"10078\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:0:\"\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:32:\"dbtech_downloads_downloads_today\";s:1:\"0\";s:36:\"dbtech_downloads_download_size_today\";s:1:\"0\";s:27:\"dbtech_downloads_favourites\";N;s:23:\"dbtech_downloads_banned\";s:1:\"0\";s:31:\"dbtech_downloads_comment_notifs\";N;s:5:\"title\";s:6:\"banned\";s:9:\"buddylist\";s:0:\"\";s:6:\"field2\";s:0:\"\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:7:\"avwidth\";N;s:8:\"avheight\";N;s:13:\"avwidth_thumb\";N;s:14:\"avheight_thumb\";N;s:14:\"filedata_thumb\";N;s:9:\"hascustom\";s:1:\"0\";}s:9:\"BODOINSIC\";a:89:{s:6:\"userid\";s:3:\"313\";s:11:\"usergroupid\";s:1:\"9\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"9\";s:8:\"username\";s:9:\"Bodoinsic\";s:8:\"password\";s:32:\"975cbb4e34b39665fc754d8dedb42096\";s:12:\"passworddate\";s:10:\"2009-01-20\";s:5:\"email\";s:21:\"sheeclage@antimir.net\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:10:\"showvbcode\";s:1:\"1\";s:9:\"usertitle\";s:14:\"Minimal Doggie\";s:11:\"customtitle\";s:1:\"0\";s:8:\"joindate\";s:10:\"1232428416\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1232428416\";s:12:\"lastactivity\";s:10:\"1232428416\";s:8:\"lastpost\";s:1:\"0\";s:5:\"posts\";s:1:\"0\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:3:\"-12\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:7:\"options\";s:7:\"3165527\";s:8:\"birthday\";s:10:\"09-20-1985\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:2:\"-1\";s:9:\"ipaddress\";s:14:\"194.176.176.82\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"1\";s:3:\"msn\";s:0:\"\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:3:\",Gl\";s:13:\"autosubscribe\";s:2:\"-1\";s:15:\"birthday_search\";s:10:\"1985-09-20\";s:18:\"profilepicrevision\";s:1:\"0\";s:12:\"showbirthday\";s:1:\"0\";s:5:\"skype\";s:0:\"\";s:12:\"adminoptions\";s:1:\"0\";s:10:\"lastpostid\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:13:\"profilevisits\";s:5:\"12048\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:0:\"\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:32:\"dbtech_downloads_downloads_today\";s:1:\"0\";s:36:\"dbtech_downloads_download_size_today\";s:1:\"0\";s:27:\"dbtech_downloads_favourites\";N;s:23:\"dbtech_downloads_banned\";s:1:\"0\";s:31:\"dbtech_downloads_comment_notifs\";N;s:5:\"title\";s:6:\"banned\";s:9:\"buddylist\";s:0:\"\";s:6:\"field2\";s:0:\"\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:7:\"avwidth\";N;s:8:\"avheight\";N;s:13:\"avwidth_thumb\";N;s:14:\"avheight_thumb\";N;s:14:\"filedata_thumb\";N;s:9:\"hascustom\";s:1:\"0\";}s:9:\"TRONINOWL\";a:89:{s:6:\"userid\";s:3:\"319\";s:11:\"usergroupid\";s:1:\"9\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"9\";s:8:\"username\";s:9:\"Troninowl\";s:8:\"password\";s:32:\"9c8e75e96c0dfdde6611601f6bbaa2ce\";s:12:\"passworddate\";s:10:\"2009-01-21\";s:5:\"email\";s:21:\"woonygrounk@gmail.com\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:10:\"showvbcode\";s:1:\"1\";s:9:\"usertitle\";s:14:\"Minimal Doggie\";s:11:\"customtitle\";s:1:\"0\";s:8:\"joindate\";s:10:\"1232516015\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1232516015\";s:12:\"lastactivity\";s:10:\"1232516038\";s:8:\"lastpost\";s:1:\"0\";s:5:\"posts\";s:1:\"0\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:3:\"-12\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:7:\"options\";s:7:\"3165527\";s:8:\"birthday\";s:10:\"06-08-1986\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:2:\"-1\";s:9:\"ipaddress\";s:13:\"89.149.227.18\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"1\";s:3:\"msn\";s:0:\"\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:3:\"py\"\";s:13:\"autosubscribe\";s:2:\"-1\";s:15:\"birthday_search\";s:10:\"1986-06-08\";s:18:\"profilepicrevision\";s:1:\"0\";s:12:\"showbirthday\";s:1:\"0\";s:5:\"skype\";s:0:\"\";s:12:\"adminoptions\";s:1:\"0\";s:10:\"lastpostid\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:13:\"profilevisits\";s:5:\"12306\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:0:\"\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:32:\"dbtech_downloads_downloads_today\";s:1:\"0\";s:36:\"dbtech_downloads_download_size_today\";s:1:\"0\";s:27:\"dbtech_downloads_favourites\";N;s:23:\"dbtech_downloads_banned\";s:1:\"0\";s:31:\"dbtech_downloads_comment_notifs\";N;s:5:\"title\";s:6:\"banned\";s:9:\"buddylist\";s:0:\"\";s:6:\"field2\";s:0:\"\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:7:\"avwidth\";N;s:8:\"avheight\";N;s:13:\"avwidth_thumb\";N;s:14:\"avheight_thumb\";N;s:14:\"filedata_thumb\";N;s:9:\"hascustom\";s:1:\"0\";}s:9:\"LEARRYBEW\";a:89:{s:6:\"userid\";s:3:\"325\";s:11:\"usergroupid\";s:1:\"9\";s:14:\"membergroupids\";s:0:\"\";s:14:\"displaygroupid\";s:1:\"9\";s:8:\"username\";s:9:\"Learrybew\";s:8:\"password\";s:32:\"02b9d18255fea459181c780802ee90be\";s:12:\"passworddate\";s:10:\"2009-05-04\";s:5:\"email\";s:21:\"lardalaytaw@gmail.com\";s:7:\"styleid\";s:1:\"0\";s:11:\"parentemail\";s:0:\"\";s:8:\"homepage\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:10:\"showvbcode\";s:1:\"1\";s:9:\"usertitle\";s:14:\"Minimal Doggie\";s:11:\"customtitle\";s:1:\"0\";s:8:\"joindate\";s:10:\"1241430156\";s:9:\"daysprune\";s:1:\"0\";s:9:\"lastvisit\";s:10:\"1241430156\";s:12:\"lastactivity\";s:10:\"1241430168\";s:8:\"lastpost\";s:1:\"0\";s:5:\"posts\";s:1:\"0\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:2:\"-5\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:7:\"options\";s:7:\"3165271\";s:8:\"birthday\";s:10:\"09-27-1960\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:2:\"-1\";s:9:\"ipaddress\";s:13:\"195.2.240.105\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"1\";s:3:\"msn\";s:0:\"\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:3:\"c5c\";s:13:\"autosubscribe\";s:2:\"-1\";s:15:\"birthday_search\";s:10:\"1960-09-27\";s:18:\"profilepicrevision\";s:1:\"0\";s:12:\"showbirthday\";s:1:\"0\";s:5:\"skype\";s:0:\"\";s:12:\"adminoptions\";s:1:\"0\";s:10:\"lastpostid\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:13:\"profilevisits\";s:5:\"11137\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:13:\"assetposthash\";s:0:\"\";s:8:\"fbuserid\";s:0:\"\";s:10:\"fbjoindate\";s:1:\"0\";s:6:\"fbname\";s:0:\"\";s:9:\"logintype\";s:2:\"vb\";s:13:\"fbaccesstoken\";s:0:\"\";s:11:\"newrepcount\";s:1:\"0\";s:32:\"dbtech_downloads_downloads_today\";s:1:\"0\";s:36:\"dbtech_downloads_download_size_today\";s:1:\"0\";s:27:\"dbtech_downloads_favourites\";N;s:23:\"dbtech_downloads_banned\";s:1:\"0\";s:31:\"dbtech_downloads_comment_notifs\";N;s:5:\"title\";s:6:\"banned\";s:9:\"buddylist\";s:0:\"\";s:6:\"field2\";s:0:\"\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:7:\"avwidth\";N;s:8:\"avheight\";N;s:13:\"avwidth_thumb\";N;s:14:\"avheight_thumb\";N;s:14:\"filedata_thumb\";N;s:9:\"hascustom\";s:1:\"0\";}}}",
serialized = '1'Time Before: 0.44433 seconds
Time After: 0.44462 seconds
Time Taken: 0.00029 seconds
Memory Before: 3,067.500 KB
Memory After: 3,039.375 KB
Memory Used: -28.125 KB
SELECT title, template FROM template WHERE templateid IN (15549,15552,15553,15502,15073,15072,15723,15724,12126,12125,12127,12122,12121,12713,12714,12712,12711,12130,12131,12718,15468,15753,15070,15418,15415,15416,15417,15761,0,0,15775,15716,15438,15439,15441,15442,15665,15745,15784,15737,15746,15265,15264,15268)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 43 | Using index condition |
Time Before: 0.44532 seconds
Time After: 0.44565 seconds
Time Taken: 0.00032 seconds
Memory Before: 3,192.445 KB
Memory After: 3,193.719 KB
Memory Used: 1.273 KB
SELECT user.*, moderator.forumid, usertextfield.buddylist, userfield.field2, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom FROM moderator AS moderator INNER JOIN user AS user USING(userid) INNER JOIN userfield AS userfield ON(userfield.userid = user.userid) INNER JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) WHERE moderator.forumid <> -1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | avatar | system | PRIMARY | 0 | Const row not found | |||
| 1 | SIMPLE | customavatar | system | PRIMARY | 0 | Const row not found | |||
| 1 | SIMPLE | moderator | index | userid_forumid | userid_forumid | 6 | 6 | Using where; Using index | |
| 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | underdog_vbulletin.moderator.userid | 1 | |
| 1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | underdog_vbulletin.moderator.userid | 1 | |
| 1 | SIMPLE | usertextfield | eq_ref | PRIMARY | PRIMARY | 4 | underdog_vbulletin.moderator.userid | 1 |
Time Before: 0.44979 seconds
Time After: 0.45006 seconds
Time Taken: 0.00027 seconds
Memory Before: 3,309.461 KB
Memory After: 3,309.172 KB
Memory Used: -0.289 KB
UPDATE session SET location = '/showgroups.php?explain=1', badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' WHERE sessionhash = '1d735fc36e09052e5aa4cdb3382e5aa2'
Time Before: 0.45153 seconds
Time After: 0.45166 seconds
Time Taken: 0.00013 seconds
Memory Before: 3,514.594 KB
Memory After: 3,514.742 KB
Memory Used: 0.148 KB