Including Functions.php

Time Before: 0.00349 seconds
Time After: 0.00881 seconds
Time Taken: 0.00532 seconds

Memory Before: 1,176.383 KB
Memory After: 1,937.953 KB
Memory Used: 761.570 KB

Connect to Database on Server: localhost

Time Before: 0.00886 seconds
Time After: 0.00918 seconds
Time Taken: 0.00031 seconds

Memory Before: 1,937.930 KB
Memory After: 1,938.883 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.00961 seconds
Time After: 0.00994 seconds
Time Taken: 0.00033 seconds

Memory Before: 1,942.664 KB
Memory After: 1,943.688 KB
Memory Used: 1.023 KB

Time Before: 0.00925 seconds
Time After: 0.01100 seconds
Time Taken: 0.00175 seconds

Memory Before: 1,938.664 KB
Memory After: 2,691.484 KB
Memory Used: 752.820 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.167.112.42'
	AND idhash = '76b9c057afd5192552df04c84cf7b0ac'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    1119Using where

Time Before: 0.01155 seconds
Time After: 0.01172 seconds
Time Taken: 0.00017 seconds

Memory Before: 2,727.398 KB
Memory After: 2,727.977 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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguageconstPRIMARYPRIMARY2const1 

Time Before: 0.01204 seconds
Time After: 0.01217 seconds
Time Taken: 0.00013 seconds

Memory Before: 2,738.141 KB
Memory After: 2,738.219 KB
Memory Used: 0.078 KB

Time Before: 0.01133 seconds
Time After: 0.01229 seconds
Time Taken: 0.00096 seconds

Memory Before: 2,722.633 KB
Memory After: 2,780.344 KB
Memory Used: 57.711 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.01314 seconds
Time After: 0.01324 seconds
Time Taken: 0.00010 seconds

Memory Before: 2,840.781 KB
Memory After: 2,841.367 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.01426 seconds
Time After: 0.01466 seconds
Time Taken: 0.00040 seconds

Memory Before: 3,067.602 KB
Memory After: 3,069.602 KB
Memory Used: 2.000 KB

SQL Query
SELECT userip
FROM cybvilxh_guests AS cybvilxh_guests
WHERE userip = '54.167.112.42'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcybvilxh_guestsALL    457Using where

Time Before: 0.02118 seconds
Time After: 0.02132 seconds
Time Taken: 0.00014 seconds

Memory Before: 4,538.180 KB
Memory After: 4,538.695 KB
Memory Used: 0.516 KB

SQL Query
UPDATE cybvilxh_guests
SET dateline = '1542158503'
WHERE userip = '54.167.112.42'

Time Before: 0.02136 seconds
Time After: 0.10990 seconds
Time Taken: 0.08854 seconds

Memory Before: 4,538.953 KB
Memory After: 4,539.258 KB
Memory Used: 0.305 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1542072103'

Time Before: 0.10995 seconds
Time After: 0.11019 seconds
Time Taken: 0.00024 seconds

Memory Before: 4,538.047 KB
Memory After: 4,538.398 KB
Memory Used: 0.352 KB

End call of global.php: 0.111001968384
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 > 1541258503
	
ORDER BY username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    1119Using where; Using temporary; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4mo0ojcco_vb.session.userid1 

Time Before: 0.11437 seconds
Time After: 0.11779 seconds
Time Taken: 0.00343 seconds

Memory Before: 4,659.977 KB
Memory After: 4,745.234 KB
Memory Used: 85.258 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.12099 seconds
Time After: 0.12113 seconds
Time Taken: 0.00014 seconds

Memory Before: 4,668.930 KB
Memory After: 4,672.773 KB
Memory Used: 3.844 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.12168 seconds
Time After: 0.12188 seconds
Time Taken: 0.00020 seconds

Memory Before: 4,743.070 KB
Memory After: 4,744.719 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 > 1542072103
ORDER BY username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserALL    307Using where; Using filesort

Time Before: 0.12955 seconds
Time After: 0.12988 seconds
Time Taken: 0.00033 seconds

Memory Before: 4,900.453 KB
Memory After: 4,900.992 KB
Memory Used: 0.539 KB

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

Time Before: 0.13013 seconds
Time After: 0.13041 seconds
Time Taken: 0.00027 seconds

Memory Before: 4,901.711 KB
Memory After: 4,912.898 KB
Memory Used: 11.188 KB

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

Time Before: 0.13409 seconds
Time After: 0.14240 seconds
Time Taken: 0.00831 seconds

Memory Before: 5,777.281 KB
Memory After: 5,777.602 KB
Memory Used: 0.320 KB

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

Time Before: 0.14250 seconds
Time After: 0.14258 seconds
Time Taken: 0.00009 seconds

Memory Before: 5,780.844 KB
Memory After: 5,781.047 KB
Memory Used: 0.203 KB

Page generated in 0.131895065308 seconds with 16 queries, spending 0.103833913803 doing MySQL queries and 0.0280611515045 doing PHP things.
Shutdown Queries:
DISABLED