Including Functions.php

Time Before: 0.00345 seconds
Time After: 0.00871 seconds
Time Taken: 0.00525 seconds

Memory Before: 1,177.531 KB
Memory After: 1,939.250 KB
Memory Used: 761.719 KB

Connect to Database on Server: localhost

Time Before: 0.00876 seconds
Time After: 0.00908 seconds
Time Taken: 0.00032 seconds

Memory Before: 1,939.234 KB
Memory After: 1,940.188 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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY50 20100.00Using where

Time Before: 0.00961 seconds
Time After: 0.01008 seconds
Time Taken: 0.00048 seconds

Memory Before: 1,944.031 KB
Memory After: 1,945.063 KB
Memory Used: 1.031 KB

Time Before: 0.00917 seconds
Time After: 0.01124 seconds
Time Taken: 0.00208 seconds

Memory Before: 1,939.969 KB
Memory After: 2,692.844 KB
Memory Used: 752.875 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.90.204.233'
	AND idhash = '728bc058b98e505b9d739d84dedcb470'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession ALL    17500.10Using where

Time Before: 0.01186 seconds
Time After: 0.01212 seconds
Time Taken: 0.00026 seconds

Memory Before: 2,728.852 KB
Memory After: 2,729.430 KB
Memory Used: 0.578 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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLElanguage constPRIMARYPRIMARY2const1100.00 

Time Before: 0.01252 seconds
Time After: 0.01270 seconds
Time Taken: 0.00018 seconds

Memory Before: 2,739.656 KB
Memory After: 2,739.742 KB
Memory Used: 0.086 KB

Time Before: 0.01157 seconds
Time After: 0.01281 seconds
Time Taken: 0.00124 seconds

Memory Before: 2,724.023 KB
Memory After: 2,781.813 KB
Memory Used: 57.789 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 2 AND userselect = 1)
	OR styleid = 2
ORDER BY styleid ASC
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

Time Before: 0.01373 seconds
Time After: 0.01388 seconds
Time Taken: 0.00015 seconds

Memory Before: 2,842.242 KB
Memory After: 2,842.828 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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 76100.00Using where

Time Before: 0.01494 seconds
Time After: 0.01564 seconds
Time Taken: 0.00070 seconds

Memory Before: 3,069.125 KB
Memory After: 3,071.125 KB
Memory Used: 2.000 KB

SQL Query
SELECT userip
FROM cybvilxh_guests AS cybvilxh_guests
WHERE userip = '54.90.204.233'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcybvilxh_guests ALL    57610.00Using where

Time Before: 0.02225 seconds
Time After: 0.02245 seconds
Time Taken: 0.00021 seconds

Memory Before: 4,609.156 KB
Memory After: 4,609.680 KB
Memory Used: 0.523 KB

SQL Query
UPDATE cybvilxh_guests
SET dateline = '1553597735'
WHERE userip = '54.90.204.233'

Time Before: 0.02250 seconds
Time After: 0.17582 seconds
Time Taken: 0.15332 seconds

Memory Before: 4,609.867 KB
Memory After: 4,610.172 KB
Memory Used: 0.305 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1553511335'

Time Before: 0.17592 seconds
Time After: 0.18712 seconds
Time Taken: 0.01120 seconds

Memory Before: 4,608.961 KB
Memory After: 4,609.313 KB
Memory Used: 0.352 KB

End call of global.php: 0.188033103943
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 > 1552697735
	
ORDER BY username ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession ALL    175033.33Using where; Using temporary; Using filesort
1SIMPLEuser eq_refPRIMARYPRIMARY4mo0ojcco_vb.session.userid1100.00 

Time Before: 0.19161 seconds
Time After: 0.19688 seconds
Time Taken: 0.00527 seconds

Memory Before: 4,731.289 KB
Memory After: 4,847.570 KB
Memory Used: 116.281 KB

SQL Query
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid
	
FROM forum AS forum
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEforum ALL    40100.00 

Time Before: 0.20128 seconds
Time After: 0.20144 seconds
Time Taken: 0.00016 seconds

Memory Before: 4,740.297 KB
Memory After: 4,744.164 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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEmoderator ALLuserid_forumid   18100.00 
1SIMPLEuser eq_refPRIMARYPRIMARY4mo0ojcco_vb.moderator.userid1100.00 

Time Before: 0.20206 seconds
Time After: 0.20230 seconds
Time Taken: 0.00025 seconds

Memory Before: 4,814.656 KB
Memory After: 4,816.305 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 > 1553511335
ORDER BY username ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEuser ALL    30733.33Using where; Using filesort

Time Before: 0.21040 seconds
Time After: 0.21084 seconds
Time Taken: 0.00044 seconds

Memory Before: 4,972.008 KB
Memory After: 4,972.383 KB
Memory Used: 0.375 KB

SQL Query
SELECT userip, dateline
FROM cybvilxh_guests AS cybvilxh_guests
WHERE dateline > 1553511335
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcybvilxh_guests ALL    57533.33Using where

Time Before: 0.21106 seconds
Time After: 0.21145 seconds
Time Taken: 0.00039 seconds

Memory Before: 4,971.992 KB
Memory After: 4,985.945 KB
Memory Used: 13.953 KB

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

Time Before: 0.21521 seconds
Time After: 0.24554 seconds
Time Taken: 0.03033 seconds

Memory Before: 5,879.922 KB
Memory After: 5,880.242 KB
Memory Used: 0.320 KB

SQL Query
UPDATE session
SET lastactivity = 1553597735, location = '/vb/?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '47c5f240f3362c736f1502515d93f997'

Time Before: 0.24569 seconds
Time After: 0.24580 seconds
Time Taken: 0.00011 seconds

Memory Before: 5,883.484 KB
Memory After: 5,883.688 KB
Memory Used: 0.203 KB

Page generated in 0.213000059128 seconds with 16 queries, spending 0.204249382019 doing MySQL queries and 0.00875067710876 doing PHP things.
Shutdown Queries:
DISABLED