Including Functions.php

Time Before: 0.00347 seconds
Time After: 0.00876 seconds
Time Taken: 0.00529 seconds

Memory Before: 1,177.969 KB
Memory After: 1,939.563 KB
Memory Used: 761.594 KB

Connect to Database on Server: localhost

Time Before: 0.00882 seconds
Time After: 0.00912 seconds
Time Taken: 0.00030 seconds

Memory Before: 1,939.547 KB
Memory After: 1,940.500 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.00963 seconds
Time After: 0.01011 seconds
Time Taken: 0.00048 seconds

Memory Before: 1,944.367 KB
Memory After: 1,945.398 KB
Memory Used: 1.031 KB

Time Before: 0.00920 seconds
Time After: 0.01115 seconds
Time Taken: 0.00195 seconds

Memory Before: 1,940.281 KB
Memory After: 2,693.148 KB
Memory Used: 752.867 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '34.204.0.181'
	AND idhash = 'a430c06a8860ba84efb0411319a4e4fd'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession ALL    31010.10Using where

Time Before: 0.01176 seconds
Time After: 0.01215 seconds
Time Taken: 0.00039 seconds

Memory Before: 2,729.117 KB
Memory After: 2,729.711 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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLElanguage constPRIMARYPRIMARY2const1100.00 

Time Before: 0.01255 seconds
Time After: 0.01273 seconds
Time Taken: 0.00017 seconds

Memory Before: 2,739.938 KB
Memory After: 2,740.023 KB
Memory Used: 0.086 KB

Time Before: 0.01147 seconds
Time After: 0.01283 seconds
Time Taken: 0.00136 seconds

Memory Before: 2,724.328 KB
Memory After: 2,782.109 KB
Memory Used: 57.781 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.01378 seconds
Time After: 0.01393 seconds
Time Taken: 0.00015 seconds

Memory Before: 2,842.531 KB
Memory After: 2,843.117 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.01499 seconds
Time After: 0.01563 seconds
Time Taken: 0.00064 seconds

Memory Before: 3,069.438 KB
Memory After: 3,071.438 KB
Memory Used: 2.000 KB

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

Time Before: 0.02216 seconds
Time After: 0.02235 seconds
Time Taken: 0.00019 seconds

Memory Before: 4,609.539 KB
Memory After: 4,610.055 KB
Memory Used: 0.516 KB

SQL Query
UPDATE cybvilxh_guests
SET dateline = '1558669559'
WHERE userip = '34.204.0.181'

Time Before: 0.02240 seconds
Time After: 0.11589 seconds
Time Taken: 0.09349 seconds

Memory Before: 4,610.250 KB
Memory After: 4,610.555 KB
Memory Used: 0.305 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1558583159'

Time Before: 0.11593 seconds
Time After: 0.11621 seconds
Time Taken: 0.00028 seconds

Memory Before: 4,609.344 KB
Memory After: 4,609.695 KB
Memory Used: 0.352 KB

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

Time Before: 0.12053 seconds
Time After: 0.12707 seconds
Time Taken: 0.00654 seconds

Memory Before: 4,731.711 KB
Memory After: 4,884.555 KB
Memory Used: 152.844 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.13247 seconds
Time After: 0.13263 seconds
Time Taken: 0.00016 seconds

Memory Before: 4,740.797 KB
Memory After: 4,744.656 KB
Memory Used: 3.859 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.13326 seconds
Time After: 0.13349 seconds
Time Taken: 0.00024 seconds

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

Time Before: 0.14139 seconds
Time After: 0.14178 seconds
Time Taken: 0.00039 seconds

Memory Before: 4,972.625 KB
Memory After: 4,972.992 KB
Memory Used: 0.367 KB

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

Time Before: 0.14199 seconds
Time After: 0.14232 seconds
Time Taken: 0.00033 seconds

Memory Before: 4,972.602 KB
Memory After: 4,984.063 KB
Memory Used: 11.461 KB

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

Time Before: 0.14590 seconds
Time After: 0.15580 seconds
Time Taken: 0.00990 seconds

Memory Before: 5,879.258 KB
Memory After: 5,879.578 KB
Memory Used: 0.320 KB

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

Time Before: 0.15596 seconds
Time After: 0.15605 seconds
Time Taken: 0.00009 seconds

Memory Before: 5,882.820 KB
Memory After: 5,883.023 KB
Memory Used: 0.203 KB

Page generated in 0.143731117249 seconds with 16 queries, spending 0.114243507385 doing MySQL queries and 0.0294876098633 doing PHP things.
Shutdown Queries:
DISABLED