[THE]Perrin
Veteran X
Connecting to database
Time before: 0.00384902954102
Query:
### QUERY SPECIAL TEMPLATES ###
SELECT title, data FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'rankphp', 'smiliecache', 'bbcodecache', 'mailqueue')
Time before: 0.00607895851135
Time after: 0.0185769796371
Time taken: 0.0124980211258
table type possible_keys key key_len ref rows Extra
datastore range PRIMARY PRIMARY 200 8 where used
--------------------------------------------------------------------------------
Parsing functions.php
Time before: 0.0287539958954
Time after: 0.0453439950943
--------------------------------------------------------------------------------
Query:
SELECT *
FROM session
WHERE sessionhash = 'c827b0e3c2a2c3d1f106642a1e6af5fc'
AND lastactivity > 1060814438
AND host = '63.207.184.86'
AND idhash = '40b5cdf7cbaec1b3d0e39b95bfa6c335'
Time before: 0.0482870340347
Time after: 0.0491809844971
Time taken: 0.000893950462341
table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1
--------------------------------------------------------------------------------
Query:
### GET USER INFO query(userid:1530 option
###
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options, language.languagecode AS lang_code,
language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride, language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 1530
Time before: 0.0502979755402
Time after: 0.0549199581146
Time taken: 0.00462198257446
table type possible_keys key key_len ref rows Extra
language system PRIMARY 1
user const PRIMARY PRIMARY 4 const 1
userfield const PRIMARY PRIMARY 4 const 1
usertextfield const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
deletionlog.username AS del_username, deletionlog.reason AS del_reason,
thread.*
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
WHERE thread.threadid = 232601
Time before: 0.0694940090179
Time after: 2.94667100906
Time taken: 2.87717700005
table type possible_keys key key_len ref rows Extra
thread const PRIMARY PRIMARY 4 const 1
deletionlog const PRIMARY PRIMARY 5 const,const 0 unique row not found
--------------------------------------------------------------------------------
Query:
### QUERY STYLES ###
SELECT * FROM style
WHERE (styleid = 8 AND userselect = 1)
OR styleid = 8
ORDER BY styleid ASC
LIMIT 1
Time before: 2.95683395863
Time after: 2.96090304852
Time taken: 0.00406908988953
table type possible_keys key key_len ref rows Extra
style const PRIMARY PRIMARY 2 const 1
--------------------------------------------------------------------------------
Query:
### CACHE TEMPLATES ###
SELECT title, template
FROM template
WHERE templateid IN (12263, 12495, 12281, 12283, 12285, 12291, 12358, 12361, 10681, 12359, 10683, 12372, 10688, 12365, 12366, 12367, 12368, 0, 10684, 12374, 12375, 10685, 10686, 12379, 12380, 12381, 12383, 12384, 12378, 12385, 12386, 0, 12387, 12388, 12389, 10687, 12391, 12392, 12393, 12394, 12369, 12370, 10698, 10691, 12440, 12441, 12442, 12443, 12444, 0, 0, 10692, 12447, 12450, 12451, 12453, 12454, 10695, 10694, 12498, 10679, 12345, 10672, 12316, 12279, 12280, 12496, 12504, 12342, 12343, 12344, 12515, 10696, 12513, 12511, 12512)
Time before: 2.97363805771
Time after: 3.11700904369
Time taken: 0.143370985985
table type possible_keys key key_len ref rows Extra
template range PRIMARY PRIMARY 4 73 where used
--------------------------------------------------------------------------------
Query:
### GET FORUM COUNTERS ###
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
FROM forum AS forum
Time before: 3.17318499088
Time after: 3.1762919426
Time taken: 0.00310695171356
table type possible_keys key key_len ref rows Extra
forum ALL 39
--------------------------------------------------------------------------------
Query:
SELECT permissions
FROM moderator
WHERE userid = 1530 AND forumid IN (1,164,-1)
Time before: 3.18179404736
Time after: 3.18264305592
Time taken: 0.000849008560181
table type possible_keys key key_len ref rows Extra
moderator range userid userid 6 3 where used
--------------------------------------------------------------------------------
Query:
### GET POST IDS ###
SELECT postid FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
WHERE threadid = 232601 AND visible = 1 AND deletionlog.primaryid IS NULL
ORDER BY dateline
LIMIT 0, 20
Time before: 3.18482100964
Time after: 3.1941139698
Time taken: 0.00929296016693
table type possible_keys key key_len ref rows Extra
post ref threadid threadid 4 const 25 where used; Using filesort
deletionlog eq_ref PRIMARY PRIMARY 5 post.postid,const 1 where used; Using index; Not exists
--------------------------------------------------------------------------------
Query:
### QUERY POSTS (LINEAR MODE) ###
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,4686453,4686457,4686465,4686467,4686468,4686470,4686501,4686507,4686537,4686540,4686545)
ORDER BY dateline
Time before: 3.19831597805
Time after: 3.35581505299
Time taken: 0.157499074936
table type possible_keys key key_len ref rows Extra
post_parsed system PRIMARY 0 const row not found
post range PRIMARY PRIMARY 8 12 where used
user eq_ref PRIMARY PRIMARY 4 post.userid 1
userfield eq_ref PRIMARY PRIMARY 4 user.userid 1
usertextfield eq_ref PRIMARY PRIMARY 4 user.userid 1
icon eq_ref PRIMARY PRIMARY 2 post.iconid 1
editlog eq_ref PRIMARY PRIMARY 4 post.postid 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='20223'
Time before: 3.35863804817
Time after: 3.36087203026
Time taken: 0.00223398208618
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='20223'
Time before: 3.36676001549
Time after: 3.36910200119
Time taken: 0.00234198570251
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='14819'
Time before: 3.45965194702
Time after: 3.46354103088
Time taken: 0.0038890838623
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='14819'
Time before: 3.46703505516
Time after: 3.46901500225
Time taken: 0.00197994709015
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='19671'
Time before: 3.62427699566
Time after: 3.85972702503
Time taken: 0.235450029373
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='19671'
Time before: 3.86956894398
Time after: 3.87044095993
Time taken: 0.000872015953064
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='20223'
Time before: 3.94360899925
Time after: 3.94968497753
Time taken: 0.00607597827911
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='20223'
Time before: 3.95406794548
Time after: 3.9562690258
Time taken: 0.00220108032227
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='14235'
Time before: 3.96532094479
Time after: 3.9674179554
Time taken: 0.00209701061249
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='14235'
Time before: 3.96999502182
Time after: 3.97124099731
Time taken: 0.00124597549438
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='14235'
Time before: 4.00339901447
Time after: 4.00605094433
Time taken: 0.00265192985535
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='14235'
Time before: 4.00998997688
Time after: 4.01153504848
Time taken: 0.00154507160187
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='5094'
Time before: 4.10079598427
Time after: 4.10246300697
Time taken: 0.00166702270508
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='5094'
Time before: 4.13088297844
Time after: 4.20292401314
Time taken: 0.0720410346985
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='18038'
Time before: 4.27051401138
Time after: 4.27141296864
Time taken: 0.000898957252502
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='18038'
Time before: 4.27389395237
Time after: 4.27569198608
Time taken: 0.00179803371429
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='16534'
Time before: 4.31276702881
Time after: 4.31355297565
Time taken: 0.000785946846008
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='16534'
Time before: 4.31673395634
Time after: 4.3175419569
Time taken: 0.000808000564575
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='2897'
Time before: 4.34321498871
Time after: 4.3439719677
Time taken: 0.000756978988647
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='2897'
Time before: 4.34655594826
Time after: 4.34732294083
Time taken: 0.00076699256897
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='4'
Time before: 4.40607202053
Time after: 4.41555702686
Time taken: 0.0094850063324
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='4'
Time before: 4.42754995823
Time after: 4.42835199833
Time taken: 0.000802040100098
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usertitle FROM usergroup WHERE usergroupid='160'
Time before: 4.43413901329
Time after: 4.43510198593
Time taken: 0.000962972640991
table type possible_keys key key_len ref rows Extra
usergroup const PRIMARY PRIMARY 2 const 1
--------------------------------------------------------------------------------
Page generated in 4.45073 seconds with 33 queries,
spending 3.5667361021 doing MySQL queries and 0.883993897896 doing PHP things.
Query:
UPDATE user
SET lastactivity = 1060814738
WHERE userid = 1530
Time before: 4.46397805214
Time after: 4.46727204323
Time taken: 0.00329399108887
--------------------------------------------------------------------------------
Query:
UPDATE session
SET useragent = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Avant Browser [avantbrowser.com]; .NET CLR 1.0.3705; .NET CLR 1.1.4322)', lastactivity = 1060814738, location = "/forums/showthread.php?threadid=232601&explain=1", styleid = 0, bypass = 0
,inforum = 1, inthread = 232601, incalendar = 0, badlocation = 0
WHERE sessionhash = 'c827b0e3c2a2c3d1f106642a1e6af5fc'
Time before: 4.4678260088
Time after: 4.46856200695
Time taken: 0.000735998153687
--------------------------------------------------------------------------------
Query:
UPDATE thread
SET views = views + 1
WHERE threadid = 232601
Time before: 4.46893703938
Time after: 6.91656494141
Time taken: 2.44762790203
You know. In case you were interested.
Time before: 0.00384902954102
Query:
### QUERY SPECIAL TEMPLATES ###
SELECT title, data FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'rankphp', 'smiliecache', 'bbcodecache', 'mailqueue')
Time before: 0.00607895851135
Time after: 0.0185769796371
Time taken: 0.0124980211258
table type possible_keys key key_len ref rows Extra
datastore range PRIMARY PRIMARY 200 8 where used
--------------------------------------------------------------------------------
Parsing functions.php
Time before: 0.0287539958954
Time after: 0.0453439950943
--------------------------------------------------------------------------------
Query:
SELECT *
FROM session
WHERE sessionhash = 'c827b0e3c2a2c3d1f106642a1e6af5fc'
AND lastactivity > 1060814438
AND host = '63.207.184.86'
AND idhash = '40b5cdf7cbaec1b3d0e39b95bfa6c335'
Time before: 0.0482870340347
Time after: 0.0491809844971
Time taken: 0.000893950462341
table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1
--------------------------------------------------------------------------------
Query:
### GET USER INFO query(userid:1530 option
###SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options, language.languagecode AS lang_code,
language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride, language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 1530
Time before: 0.0502979755402
Time after: 0.0549199581146
Time taken: 0.00462198257446
table type possible_keys key key_len ref rows Extra
language system PRIMARY 1
user const PRIMARY PRIMARY 4 const 1
userfield const PRIMARY PRIMARY 4 const 1
usertextfield const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
deletionlog.username AS del_username, deletionlog.reason AS del_reason,
thread.*
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
WHERE thread.threadid = 232601
Time before: 0.0694940090179
Time after: 2.94667100906
Time taken: 2.87717700005
table type possible_keys key key_len ref rows Extra
thread const PRIMARY PRIMARY 4 const 1
deletionlog const PRIMARY PRIMARY 5 const,const 0 unique row not found
--------------------------------------------------------------------------------
Query:
### QUERY STYLES ###
SELECT * FROM style
WHERE (styleid = 8 AND userselect = 1)
OR styleid = 8
ORDER BY styleid ASC
LIMIT 1
Time before: 2.95683395863
Time after: 2.96090304852
Time taken: 0.00406908988953
table type possible_keys key key_len ref rows Extra
style const PRIMARY PRIMARY 2 const 1
--------------------------------------------------------------------------------
Query:
### CACHE TEMPLATES ###
SELECT title, template
FROM template
WHERE templateid IN (12263, 12495, 12281, 12283, 12285, 12291, 12358, 12361, 10681, 12359, 10683, 12372, 10688, 12365, 12366, 12367, 12368, 0, 10684, 12374, 12375, 10685, 10686, 12379, 12380, 12381, 12383, 12384, 12378, 12385, 12386, 0, 12387, 12388, 12389, 10687, 12391, 12392, 12393, 12394, 12369, 12370, 10698, 10691, 12440, 12441, 12442, 12443, 12444, 0, 0, 10692, 12447, 12450, 12451, 12453, 12454, 10695, 10694, 12498, 10679, 12345, 10672, 12316, 12279, 12280, 12496, 12504, 12342, 12343, 12344, 12515, 10696, 12513, 12511, 12512)
Time before: 2.97363805771
Time after: 3.11700904369
Time taken: 0.143370985985
table type possible_keys key key_len ref rows Extra
template range PRIMARY PRIMARY 4 73 where used
--------------------------------------------------------------------------------
Query:
### GET FORUM COUNTERS ###
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
FROM forum AS forum
Time before: 3.17318499088
Time after: 3.1762919426
Time taken: 0.00310695171356
table type possible_keys key key_len ref rows Extra
forum ALL 39
--------------------------------------------------------------------------------
Query:
SELECT permissions
FROM moderator
WHERE userid = 1530 AND forumid IN (1,164,-1)
Time before: 3.18179404736
Time after: 3.18264305592
Time taken: 0.000849008560181
table type possible_keys key key_len ref rows Extra
moderator range userid userid 6 3 where used
--------------------------------------------------------------------------------
Query:
### GET POST IDS ###
SELECT postid FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
WHERE threadid = 232601 AND visible = 1 AND deletionlog.primaryid IS NULL
ORDER BY dateline
LIMIT 0, 20
Time before: 3.18482100964
Time after: 3.1941139698
Time taken: 0.00929296016693
table type possible_keys key key_len ref rows Extra
post ref threadid threadid 4 const 25 where used; Using filesort
deletionlog eq_ref PRIMARY PRIMARY 5 post.postid,const 1 where used; Using index; Not exists
--------------------------------------------------------------------------------
Query:
### QUERY POSTS (LINEAR MODE) ###
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,4686453,4686457,4686465,4686467,4686468,4686470,4686501,4686507,4686537,4686540,4686545)
ORDER BY dateline
Time before: 3.19831597805
Time after: 3.35581505299
Time taken: 0.157499074936
table type possible_keys key key_len ref rows Extra
post_parsed system PRIMARY 0 const row not found
post range PRIMARY PRIMARY 8 12 where used
user eq_ref PRIMARY PRIMARY 4 post.userid 1
userfield eq_ref PRIMARY PRIMARY 4 user.userid 1
usertextfield eq_ref PRIMARY PRIMARY 4 user.userid 1
icon eq_ref PRIMARY PRIMARY 2 post.iconid 1
editlog eq_ref PRIMARY PRIMARY 4 post.postid 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='20223'
Time before: 3.35863804817
Time after: 3.36087203026
Time taken: 0.00223398208618
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='20223'
Time before: 3.36676001549
Time after: 3.36910200119
Time taken: 0.00234198570251
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='14819'
Time before: 3.45965194702
Time after: 3.46354103088
Time taken: 0.0038890838623
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='14819'
Time before: 3.46703505516
Time after: 3.46901500225
Time taken: 0.00197994709015
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='19671'
Time before: 3.62427699566
Time after: 3.85972702503
Time taken: 0.235450029373
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='19671'
Time before: 3.86956894398
Time after: 3.87044095993
Time taken: 0.000872015953064
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='20223'
Time before: 3.94360899925
Time after: 3.94968497753
Time taken: 0.00607597827911
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='20223'
Time before: 3.95406794548
Time after: 3.9562690258
Time taken: 0.00220108032227
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='14235'
Time before: 3.96532094479
Time after: 3.9674179554
Time taken: 0.00209701061249
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='14235'
Time before: 3.96999502182
Time after: 3.97124099731
Time taken: 0.00124597549438
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='14235'
Time before: 4.00339901447
Time after: 4.00605094433
Time taken: 0.00265192985535
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='14235'
Time before: 4.00998997688
Time after: 4.01153504848
Time taken: 0.00154507160187
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='5094'
Time before: 4.10079598427
Time after: 4.10246300697
Time taken: 0.00166702270508
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='5094'
Time before: 4.13088297844
Time after: 4.20292401314
Time taken: 0.0720410346985
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='18038'
Time before: 4.27051401138
Time after: 4.27141296864
Time taken: 0.000898957252502
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='18038'
Time before: 4.27389395237
Time after: 4.27569198608
Time taken: 0.00179803371429
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='16534'
Time before: 4.31276702881
Time after: 4.31355297565
Time taken: 0.000785946846008
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='16534'
Time before: 4.31673395634
Time after: 4.3175419569
Time taken: 0.000808000564575
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='2897'
Time before: 4.34321498871
Time after: 4.3439719677
Time taken: 0.000756978988647
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='2897'
Time before: 4.34655594826
Time after: 4.34732294083
Time taken: 0.00076699256897
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usergroupid FROM user WHERE userid='4'
Time before: 4.40607202053
Time after: 4.41555702686
Time taken: 0.0094850063324
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT membergroupids FROM user WHERE userid='4'
Time before: 4.42754995823
Time after: 4.42835199833
Time taken: 0.000802040100098
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query:
SELECT usertitle FROM usergroup WHERE usergroupid='160'
Time before: 4.43413901329
Time after: 4.43510198593
Time taken: 0.000962972640991
table type possible_keys key key_len ref rows Extra
usergroup const PRIMARY PRIMARY 2 const 1
--------------------------------------------------------------------------------
Page generated in 4.45073 seconds with 33 queries,
spending 3.5667361021 doing MySQL queries and 0.883993897896 doing PHP things.
Query:
UPDATE user
SET lastactivity = 1060814738
WHERE userid = 1530
Time before: 4.46397805214
Time after: 4.46727204323
Time taken: 0.00329399108887
--------------------------------------------------------------------------------
Query:
UPDATE session
SET useragent = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Avant Browser [avantbrowser.com]; .NET CLR 1.0.3705; .NET CLR 1.1.4322)', lastactivity = 1060814738, location = "/forums/showthread.php?threadid=232601&explain=1", styleid = 0, bypass = 0
,inforum = 1, inthread = 232601, incalendar = 0, badlocation = 0
WHERE sessionhash = 'c827b0e3c2a2c3d1f106642a1e6af5fc'
Time before: 4.4678260088
Time after: 4.46856200695
Time taken: 0.000735998153687
--------------------------------------------------------------------------------
Query:
UPDATE thread
SET views = views + 1
WHERE threadid = 232601
Time before: 4.46893703938
Time after: 6.91656494141
Time taken: 2.44762790203
You know. In case you were interested.