Including Functions.php

Time Before: 0.00354 seconds
Time After: 0.00882 seconds
Time Taken: 0.00528 seconds

Memory Before: 1,176.367 KB
Memory After: 1,937.813 KB
Memory Used: 761.445 KB

Connect to Database on Server: localhost

Time Before: 0.00887 seconds
Time After: 0.00914 seconds
Time Taken: 0.00027 seconds

Memory Before: 1,937.797 KB
Memory After: 1,938.750 KB
Memory Used: 0.953 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY50 20Using where

Time Before: 0.00959 seconds
Time After: 0.01000 seconds
Time Taken: 0.00041 seconds

Memory Before: 1,942.531 KB
Memory After: 1,943.555 KB
Memory Used: 1.023 KB

Time Before: 0.00921 seconds
Time After: 0.01104 seconds
Time Taken: 0.00183 seconds

Memory Before: 1,938.531 KB
Memory After: 2,691.305 KB
Memory Used: 752.773 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.172.221.7'
	AND idhash = '5beeef1553f061f143479b55a39d44dc'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    1442Using where

Time Before: 0.01160 seconds
Time After: 0.01183 seconds
Time Taken: 0.00023 seconds

Memory Before: 2,727.211 KB
Memory After: 2,727.805 KB
Memory Used: 0.594 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_holiday AS phrasegroup_holiday,
			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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguageconstPRIMARYPRIMARY2const1 

Time Before: 0.01217 seconds
Time After: 0.01233 seconds
Time Taken: 0.00016 seconds

Memory Before: 2,737.969 KB
Memory After: 2,738.047 KB
Memory Used: 0.078 KB

Time Before: 0.01136 seconds
Time After: 0.01244 seconds
Time Taken: 0.00108 seconds

Memory Before: 2,722.469 KB
Memory After: 2,780.172 KB
Memory Used: 57.703 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 2 AND userselect = 1)
	OR styleid = 2
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 

Time Before: 0.01332 seconds
Time After: 0.01344 seconds
Time Taken: 0.00012 seconds

Memory Before: 2,840.609 KB
Memory After: 2,841.195 KB
Memory Used: 0.586 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (65,617,159,160,161,162,163,164,618,167,168,169,170,171,166,158,745,622,564,67,66,68,63,62,339,619,291,292,293,559,562,571,312,313,314,315,513,576,575,577,580,624,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,625,735,737,736,738,740,741,658,660,656,672,0,673,675,694,695)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 76Using where

Time Before: 0.01445 seconds
Time After: 0.01497 seconds
Time Taken: 0.00051 seconds

Memory Before: 3,067.422 KB
Memory After: 3,069.422 KB
Memory Used: 2.000 KB

SQL Query
SELECT userip
FROM cybvilxh_guests AS cybvilxh_guests
WHERE userip = '54.172.221.7'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcybvilxh_guestsALL    534Using where

Time Before: 0.02139 seconds
Time After: 0.02156 seconds
Time Taken: 0.00017 seconds

Memory Before: 4,537.984 KB
Memory After: 4,538.500 KB
Memory Used: 0.516 KB

SQL Query
UPDATE cybvilxh_guests
SET dateline = '1548261610'
WHERE userip = '54.172.221.7'

Time Before: 0.02161 seconds
Time After: 0.12824 seconds
Time Taken: 0.10663 seconds

Memory Before: 4,538.758 KB
Memory After: 4,539.063 KB
Memory Used: 0.305 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1548175210'

Time Before: 0.12828 seconds
Time After: 0.12856 seconds
Time Taken: 0.00027 seconds

Memory Before: 4,537.852 KB
Memory After: 4,538.203 KB
Memory Used: 0.352 KB

End call of global.php: 0.129374027252
SQL Query
SELECT
	user.username, (user.options & 512) AS invisible, user.usergroupid,
	session.userid, session.inforum, session.lastactivity, session.badlocation,
 			IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
	
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)

WHERE session.lastactivity > 1547361610
	
ORDER BY username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    1442Using where; Using temporary; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4mo0ojcco_vb.session.userid1 

Time Before: 0.13274 seconds
Time After: 0.13703 seconds
Time Taken: 0.00428 seconds

Memory Before: 4,659.758 KB
Memory After: 4,766.422 KB
Memory Used: 106.664 KB

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

Time Before: 0.14087 seconds
Time After: 0.14101 seconds
Time Taken: 0.00014 seconds

Memory Before: 4,669.125 KB
Memory After: 4,672.992 KB
Memory Used: 3.867 KB

SQL Query
SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmoderatorALLuserid_forumid   18 
1SIMPLEusereq_refPRIMARYPRIMARY4mo0ojcco_vb.moderator.userid1 

Time Before: 0.14156 seconds
Time After: 0.14176 seconds
Time Taken: 0.00020 seconds

Memory Before: 4,743.477 KB
Memory After: 4,745.125 KB
Memory Used: 1.648 KB

SQL Query
SELECT userid, username, usergroupid, displaygroupid, lastactivity, IF(user.options & 512, 1, 0) AS invisible
FROM user AS user
WHERE lastactivity > 1548175210
ORDER BY username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserALL    307Using where; Using filesort

Time Before: 0.14942 seconds
Time After: 0.14976 seconds
Time Taken: 0.00034 seconds

Memory Before: 4,900.961 KB
Memory After: 4,901.398 KB
Memory Used: 0.438 KB

SQL Query
SELECT userip, dateline
FROM cybvilxh_guests AS cybvilxh_guests
WHERE dateline > 1548175210
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcybvilxh_guestsALL    534Using where

Time Before: 0.14997 seconds
Time After: 0.15028 seconds
Time Taken: 0.00031 seconds

Memory Before: 4,901.805 KB
Memory After: 4,914.664 KB
Memory Used: 12.859 KB

SQL Query
UPDATE ads_bnr AS ads_bnr SET ads_bnr.views = ads_bnr.views + 1 WHERE id IN(29)

Time Before: 0.15391 seconds
Time After: 0.16109 seconds
Time Taken: 0.00717 seconds

Memory Before: 5,775.094 KB
Memory After: 5,775.414 KB
Memory Used: 0.320 KB

SQL Query
UPDATE session
SET lastactivity = 1548261610, location = '/vb/?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '360cda0f28bc36d8822a60b7e4fa4d98'

Time Before: 0.16119 seconds
Time After: 0.16128 seconds
Time Taken: 0.00009 seconds

Memory Before: 5,778.656 KB
Memory After: 5,778.859 KB
Memory Used: 0.203 KB

Page generated in 0.151765108109 seconds with 16 queries, spending 0.121926784515 doing MySQL queries and 0.0298383235931 doing PHP things.
Shutdown Queries:
DISABLED