Including Functions.php

Time Before: 0.00231 seconds
Time After: 0.00484 seconds
Time Taken: 0.00252 seconds

Memory Before: 455.656 KB
Memory After: 464.852 KB
Memory Used: 9.195 KB

Connect to Database on Server: localhost

Time Before: 0.00489 seconds
Time After: 0.00584 seconds
Time Taken: 0.00095 seconds

Memory Before: 464.859 KB
Memory After: 465.758 KB
Memory Used: 0.898 KB

Datastore Setup
SQL Query
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache')
1SIMPLEdatastorerangePRIMARYPRIMARY50 14Using index condition

Time Before: 0.00616 seconds
Time After: 0.00656 seconds
Time Taken: 0.00040 seconds

Memory Before: 469.367 KB
Memory After: 469.875 KB
Memory Used: 0.508 KB

Time Before: 0.00590 seconds
Time After: 0.00797 seconds
Time Taken: 0.00206 seconds

Memory Before: 465.555 KB
Memory After: 1,513.602 KB
Memory Used: 1,048.047 KB

Session Handling
SQL Query
FROM session
WHERE userid = 0
	AND host = ''
	AND idhash = '654c4a8ce458811fa5b266adc837ce54'
1SIMPLEsessionALL    284Using where

Time Before: 0.00856 seconds
Time After: 0.00866 seconds
Time Taken: 0.00010 seconds

Memory Before: 1,532.758 KB
Memory After: 1,533.164 KB
Memory Used: 0.406 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_fronthelp AS phrasegroup_fronthelp,
			phrasegroup_register AS phrasegroup_register,
			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 = 2

Time Before: 0.00897 seconds
Time After: 0.00914 seconds
Time Taken: 0.00018 seconds

Memory Before: 1,544.219 KB
Memory After: 1,544.070 KB
Memory Used: -0.148 KB

Time Before: 0.00833 seconds
Time After: 0.00922 seconds
Time Taken: 0.00089 seconds

Memory Before: 1,527.891 KB
Memory After: 1,615.914 KB
Memory Used: 88.023 KB

SQL Query
SELECT IF(visible = 2, 1, 0) AS isdeleted,


FROM thread AS thread

WHERE thread.threadid = 11743

Time Before: 0.01047 seconds
Time After: 0.01058 seconds
Time Taken: 0.00010 seconds

Memory Before: 1,777.703 KB
Memory After: 1,778.102 KB
Memory Used: 0.398 KB

SQL Query
FROM style
WHERE (styleid = 36 AND userselect = 1)
	OR styleid = 36
ORDER BY styleid ASC

Time Before: 0.01098 seconds
Time After: 0.01109 seconds
Time Taken: 0.00011 seconds

Memory Before: 1,797.438 KB
Memory After: 1,797.867 KB
Memory Used: 0.430 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (543,544,745,744,564,67,66,68,63,62,339,741,291,292,293,559,562,571,312,313,314,315,513,576,575,577,580,677,678,679,680,681,682,683,684,685,686,687,689,688,690,691)
1SIMPLEtemplaterangePRIMARYPRIMARY4 42Using index condition

Time Before: 0.01159 seconds
Time After: 0.01184 seconds
Time Taken: 0.00025 seconds

Memory Before: 1,979.930 KB
Memory After: 1,980.250 KB
Memory Used: 0.320 KB

SQL Query
SELECT userip
FROM cybvilxh_guests AS cybvilxh_guests
WHERE userip = ''
1SIMPLEcybvilxh_guestsALL    629Using where

Time Before: 0.01498 seconds
Time After: 0.01513 seconds
Time Taken: 0.00015 seconds

Memory Before: 2,546.648 KB
Memory After: 2,547.094 KB
Memory Used: 0.445 KB

SQL Query
UPDATE cybvilxh_guests
SET dateline = '1545152614'
WHERE userip = ''

Time Before: 0.01517 seconds
Time After: 0.01647 seconds
Time Taken: 0.00129 seconds

Memory Before: 2,547.320 KB
Memory After: 2,547.656 KB
Memory Used: 0.336 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1545066214'

Time Before: 0.01649 seconds
Time After: 0.01667 seconds
Time Taken: 0.00017 seconds

Memory Before: 2,546.516 KB
Memory After: 2,546.898 KB
Memory Used: 0.383 KB

SQL Query
SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts
FROM user AS user
WHERE posts > '0' 
1SIMPLEuserALL    5670Using where; Using filesort

Time Before: 0.01720 seconds
Time After: 0.02227 seconds
Time Taken: 0.00507 seconds

Memory Before: 2,580.031 KB
Memory After: 2,580.375 KB
Memory Used: 0.344 KB

SQL Query
SELECT COUNT(*) AS refnumber, user.username, user.userid, user.usergroupid, user.referrerid
FROM user AS refs
LEFT JOIN user AS user ON (refs.referrerid = user.userid)
WHERE refs.referrerid > '0' 
GROUP BY refs.referrerid
ORDER BY refnumber DESC LIMIT 0, 5
1SIMPLErefsrangereferreridreferrerid4 151Using where; Using index; Using temporary; Using filesort

Time Before: 0.02283 seconds
Time After: 0.02317 seconds
Time Taken: 0.00034 seconds

Memory Before: 2,584.117 KB
Memory After: 2,584.383 KB
Memory Used: 0.266 KB

SQL Query
SELECT threadid, title, forumid, dateline, IF(views<=replycount, replycount+1, views) AS views, visible
FROM thread AS thread
WHERE NOT ISNULL(threadid) AND visible = '1' AND views > '0' 
1SIMPLEthreadALLPRIMARY   12267Using where; Using filesort

Time Before: 0.02350 seconds
Time After: 0.03050 seconds
Time Taken: 0.00700 seconds

Memory Before: 2,586.844 KB
Memory After: 2,587.156 KB
Memory Used: 0.313 KB

SQL Query
SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts, reputation
FROM user AS user
WHERE reputation > '0' 
ORDER BY reputation DESC LIMIT 0, 5
1SIMPLEuserALL    5670Using where; Using filesort

Time Before: 0.03101 seconds
Time After: 0.03664 seconds
Time Taken: 0.00563 seconds

Memory Before: 2,589.781 KB
Memory After: 2,590.109 KB
Memory Used: 0.328 KB

SQL Query
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter) 
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' 
ORDER BY lastpost DESC LIMIT 0, 10
1SIMPLEthreadindexPRIMARYlastpost6 10Using where

Time Before: 0.03703 seconds
Time After: 0.03726 seconds
Time Taken: 0.00023 seconds

Memory Before: 2,593.797 KB
Memory After: 2,593.828 KB
Memory Used: 0.031 KB

End call of global.php: 0.040605068206787
SQL Query
SELECT COUNT(postid) AS posts,
post.username AS postuser,user.userid,user.username
FROM post AS post
LEFT JOIN user AS user USING(userid)
WHERE threadid = 11743
	AND visible = 1
GROUP BY userid
1SIMPLEpostrefthreadidthreadid4const1Using where; Using temporary; Using filesort 

Time Before: 0.04106 seconds
Time After: 0.04130 seconds
Time Taken: 0.00024 seconds

Memory Before: 2,289.984 KB
Memory After: 2,290.305 KB
Memory Used: 0.320 KB

SQL Query
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid
FROM forum AS forum
1SIMPLEforumALL    82 

Time Before: 0.04282 seconds
Time After: 0.04302 seconds
Time Taken: 0.00021 seconds

Memory Before: 2,436.789 KB
Memory After: 2,437.172 KB
Memory Used: 0.383 KB

SQL Query
UPDATE session
SET lastactivity = 1545152614, location = '/vb/misc.php?do=whoposted&t=11743&explain=1', inforum = 5, inthread = 11743, incalendar = 0, badlocation = 0
WHERE sessionhash = '6372b4e6d5fd9becbc410cee87d9b2fc'

Time Before: 0.04382 seconds
Time After: 0.04390 seconds
Time Taken: 0.00009 seconds

Memory Before: 2,600.672 KB
Memory After: 2,600.859 KB
Memory Used: 0.188 KB

Page generated in 0.041790008544922 seconds with 20 queries, spending 0.022687435150146 doing MySQL queries and 0.019102573394775 doing PHP things.
Shutdown Queries: