Including Functions.php

Time Before: 0.00454 seconds
Time After: 0.00992 seconds
Time Taken: 0.00538 seconds

Memory Before: 1,177.148 KB
Memory After: 1,938.766 KB
Memory Used: 761.617 KB

Connect to Database on Server: localhost

Time Before: 0.01005 seconds
Time After: 0.01065 seconds
Time Taken: 0.00060 seconds

Memory Before: 1,938.742 KB
Memory After: 1,939.719 KB
Memory Used: 0.977 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.01146 seconds
Time After: 0.01209 seconds
Time Taken: 0.00063 seconds

Memory Before: 1,943.539 KB
Memory After: 1,944.570 KB
Memory Used: 1.031 KB

Time Before: 0.01078 seconds
Time After: 0.01327 seconds
Time Taken: 0.00249 seconds

Memory Before: 1,939.477 KB
Memory After: 2,692.313 KB
Memory Used: 752.836 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.196.116.3'
	AND idhash = 'a0982899f4d6ae13335114a03649548e'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession ALL    23190.10Using where

Time Before: 0.01400 seconds
Time After: 0.01431 seconds
Time Taken: 0.00031 seconds

Memory Before: 2,728.305 KB
Memory After: 2,728.898 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.01476 seconds
Time After: 0.01499 seconds
Time Taken: 0.00023 seconds

Memory Before: 2,739.125 KB
Memory After: 2,739.211 KB
Memory Used: 0.086 KB

Time Before: 0.01370 seconds
Time After: 0.01511 seconds
Time Taken: 0.00141 seconds

Memory Before: 2,723.516 KB
Memory After: 2,781.297 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.01607 seconds
Time After: 0.01621 seconds
Time Taken: 0.00015 seconds

Memory Before: 2,841.672 KB
Memory After: 2,842.258 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.01730 seconds
Time After: 0.01792 seconds
Time Taken: 0.00062 seconds

Memory Before: 3,068.570 KB
Memory After: 3,070.570 KB
Memory Used: 2.000 KB

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

Time Before: 0.02559 seconds
Time After: 0.02577 seconds
Time Taken: 0.00018 seconds

Memory Before: 4,608.617 KB
Memory After: 4,609.133 KB
Memory Used: 0.516 KB

SQL Query
UPDATE cybvilxh_guests
SET dateline = '1563245659'
WHERE userip = '54.196.116.3'

Time Before: 0.02581 seconds
Time After: 0.07795 seconds
Time Taken: 0.05213 seconds

Memory Before: 4,609.328 KB
Memory After: 4,609.633 KB
Memory Used: 0.305 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1563159259'

Time Before: 0.07807 seconds
Time After: 0.07841 seconds
Time Taken: 0.00034 seconds

Memory Before: 4,608.422 KB
Memory After: 4,608.773 KB
Memory Used: 0.352 KB

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

Time Before: 0.08410 seconds
Time After: 0.09080 seconds
Time Taken: 0.00670 seconds

Memory Before: 4,730.820 KB
Memory After: 4,878.195 KB
Memory Used: 147.375 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.09685 seconds
Time After: 0.09702 seconds
Time Taken: 0.00017 seconds

Memory Before: 4,740.172 KB
Memory After: 4,744.031 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.09764 seconds
Time After: 0.09789 seconds
Time Taken: 0.00025 seconds

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

Time Before: 0.10932 seconds
Time After: 0.10992 seconds
Time Taken: 0.00060 seconds

Memory Before: 4,971.898 KB
Memory After: 4,972.352 KB
Memory Used: 0.453 KB

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

Time Before: 0.11021 seconds
Time After: 0.11052 seconds
Time Taken: 0.00031 seconds

Memory Before: 4,972.813 KB
Memory After: 4,983.250 KB
Memory Used: 10.438 KB

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

Time Before: 0.11550 seconds
Time After: 0.15112 seconds
Time Taken: 0.03563 seconds

Memory Before: 5,879.617 KB
Memory After: 5,879.938 KB
Memory Used: 0.320 KB

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

Time Before: 0.15134 seconds
Time After: 0.15154 seconds
Time Taken: 0.00020 seconds

Memory Before: 5,883.180 KB
Memory After: 5,883.383 KB
Memory Used: 0.203 KB

Page generated in 0.11322593689 seconds with 16 queries, spending 0.0995759963989 doing MySQL queries and 0.0136499404907 doing PHP things.
Shutdown Queries:
DISABLED