Including Functions.php

Time Before: 0.00334 seconds
Time After: 0.00394 seconds
Time Taken: 0.00060 seconds

Memory Before: 622.625 KB
Memory After: 631.313 KB
Memory Used: 8.688 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00407 seconds
Time After: 0.00816 seconds
Time Taken: 0.00409 seconds

Memory Before: 631.234 KB
Memory After: 632.109 KB
Memory Used: 0.875 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00980 seconds
Time After: 0.01010 seconds
Time Taken: 0.00030 seconds

Memory Before: 632.859 KB
Memory After: 633.383 KB
Memory Used: 0.523 KB

Datastore Setup
SQL Query
SELECT *
FROM vb_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
1SIMPLEvb_datastorerangePRIMARYPRIMARY50 20Using where

Time Before: 0.01200 seconds
Time After: 0.01714 seconds
Time Taken: 0.00514 seconds

Memory Before: 636.430 KB
Memory After: 636.688 KB
Memory Used: 0.258 KB

Time Before: 0.01097 seconds
Time After: 0.02302 seconds
Time Taken: 0.01205 seconds

Memory Before: 632.656 KB
Memory After: 2,410.969 KB
Memory Used: 1,778.313 KB

SQL Query
SELECT *
FROM vb_datastore
WHERE title IN ('wol_spiders','nex_crawlers_list_wgo_stats')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_datastorerangePRIMARYPRIMARY50 2Using where

Time Before: 0.02505 seconds
Time After: 0.02562 seconds
Time Taken: 0.00058 seconds

Memory Before: 2,435.328 KB
Memory After: 2,435.797 KB
Memory Used: 0.469 KB

Session Handling
SQL Query
SELECT *
FROM vb_session
WHERE userid = 0
	AND host = '3.81.29.226'
	AND idhash = '98f26011348c0e2a2d4a88580bae7cdf'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_sessionALL    11Using where

Time Before: 0.02777 seconds
Time After: 0.02864 seconds
Time Taken: 0.00087 seconds

Memory Before: 2,820.203 KB
Memory After: 2,820.609 KB
Memory Used: 0.406 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_holiday AS phrasegroup_holiday,
			phrasegroup_autopm_title AS phrasegroup_autopm_title,
			phrasegroup_autopm_text AS phrasegroup_autopm_text,
			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 vb_language
WHERE languageid = 2
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_languageconstPRIMARYPRIMARY2const1 

Time Before: 0.03017 seconds
Time After: 0.03105 seconds
Time Taken: 0.00088 seconds

Memory Before: 2,831.289 KB
Memory After: 2,831.070 KB
Memory Used: -0.219 KB

Time Before: 0.02691 seconds
Time After: 0.03129 seconds
Time Taken: 0.00438 seconds

Memory Before: 2,815.773 KB
Memory After: 2,920.688 KB
Memory Used: 104.914 KB

SQL Query
SELECT *
FROM vb_style
WHERE (styleid = 5 AND userselect = 1)
	OR styleid = 5
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_styleconstPRIMARYPRIMARY2const1 

Time Before: 0.04034 seconds
Time After: 0.04059 seconds
Time Taken: 0.00025 seconds

Memory Before: 3,158.938 KB
Memory After: 3,159.375 KB
Memory Used: 0.438 KB

SQL Query
SELECT title, template
FROM vb_template
WHERE templateid IN (65,758,159,759,1014,1226,760,164,165,167,1167,1168,170,171,166,158,3805,3806,3797,67,66,68,63,62,339,1088,291,292,293,559,562,571,312,313,314,315,513,576,575,3665,580,3600,3602,3598,3601,3488,1018,3597,2128,3788,3787,1115,1113,1112,1114,1122,1123,1128,3531,3779,1238,1237,1250,1500,2005,2004,2058,2126,2278,2279,2280,2645,3769,3751,2637,2636,3750,3723,3763,3765,3766,3764,2638,2639,2640,2641,2665,2666,2667,3673,2669,2670,3809,3810,3812,3811,3807,3808,2699,2704,2707,2703,2705,2706,2708,2700,2701,0,2702,2717,2719,2720,3161,3162,3527,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3231,3212,3232,3233,3369,3370,3236,3237,3238,3245,3246,3406,3407,3532,3477,3478,3479,3480,3561)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templaterangePRIMARYPRIMARY4 152Using where

Time Before: 0.04382 seconds
Time After: 0.04685 seconds
Time Taken: 0.00303 seconds

Memory Before: 3,450.094 KB
Memory After: 3,449.883 KB
Memory Used: -0.211 KB

SQL Query
SELECT userip
FROM vb_cybvilxh_guests AS cybvilxh_guests
WHERE userip = '3.81.29.226'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcybvilxh_guestsALL    1628Using where

Time Before: 0.05664 seconds
Time After: 0.05792 seconds
Time Taken: 0.00128 seconds

Memory Before: 4,054.531 KB
Memory After: 4,055.414 KB
Memory Used: 0.883 KB

SQL Query
UPDATE vb_cybvilxh_guests
SET dateline = '1573650337'
WHERE userip = '3.81.29.226'

Time Before: 0.05801 seconds
Time After: 0.52457 seconds
Time Taken: 0.46656 seconds

Memory Before: 4,055.703 KB
Memory After: 4,056.008 KB
Memory Used: 0.305 KB

SQL Query
DELETE FROM vb_cybvilxh_guests WHERE dateline < '1573563937'

Time Before: 0.52476 seconds
Time After: 0.52674 seconds
Time Taken: 0.00198 seconds

Memory Before: 4,054.852 KB
Memory After: 4,055.203 KB
Memory Used: 0.352 KB

End call of global.php: 0.53157210350037
SQL Query
select * FROM vb_color_groups order by orderid

Time Before: 0.53188 seconds
Time After: 0.54366 seconds
Time Taken: 0.01178 seconds

Memory Before: 3,890.844 KB
Memory After: 3,891.359 KB
Memory Used: 0.516 KB

SQL Query
SELECT
	user.username, (user.options & 512) AS invisible, user.usergroupid,
	session.userid, session.inforum, session.lastactivity, session.badlocation,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
	
FROM vb_session AS session
LEFT JOIN vb_user AS user ON(user.userid = session.userid)

WHERE session.lastactivity > 1573649437
	
ORDER BY username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    11Using where; Using temporary; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4lddnsk_forum.session.userid1 

Time Before: 0.54916 seconds
Time After: 0.54999 seconds
Time Taken: 0.00083 seconds

Memory Before: 4,193.102 KB
Memory After: 4,193.234 KB
Memory Used: 0.133 KB

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

Time Before: 0.55126 seconds
Time After: 0.55154 seconds
Time Taken: 0.00027 seconds

Memory Before: 4,196.883 KB
Memory After: 4,197.258 KB
Memory Used: 0.375 KB

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

Time Before: 0.57447 seconds
Time After: 0.57586 seconds
Time Taken: 0.00139 seconds

Memory Before: 4,485.398 KB
Memory After: 4,485.758 KB
Memory Used: 0.359 KB

SQL Query
SELECT userip, dateline
FROM vb_cybvilxh_guests AS cybvilxh_guests
WHERE dateline > 1573563937
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcybvilxh_guestsALL    1628Using where

Time Before: 0.57686 seconds
Time After: 0.57873 seconds
Time Taken: 0.00186 seconds

Memory Before: 4,487.445 KB
Memory After: 4,487.898 KB
Memory Used: 0.453 KB

SQL Query
SELECT user.username, session.host, session.useragent, session.location, session.lastactivity, user.userid
FROM vb_session AS session
 LEFT JOIN vb_user AS user USING (userid) 
WHERE session.lastactivity > 1573649437
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    11Using where
1SIMPLEusereq_refPRIMARYPRIMARY4lddnsk_forum.session.userid1 

Time Before: 0.57987 seconds
Time After: 0.58054 seconds
Time Taken: 0.00066 seconds

Memory Before: 4,495.383 KB
Memory After: 4,495.719 KB
Memory Used: 0.336 KB

SQL Query
UPDATE vb_session
SET lastactivity = 1573650337, location = '/forum/index.php?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'f4b955ae31a4102827f8180d87805c6b'

Time Before: 0.58796 seconds
Time After: 0.58837 seconds
Time Taken: 0.00041 seconds

Memory Before: 4,951.891 KB
Memory After: 4,952.078 KB
Memory Used: 0.188 KB

Page generated in 0.58643698692322 seconds with 17 queries, spending 0.48702669143677 doing MySQL queries and 0.09941029548645 doing PHP things.
Shutdown Queries:
DISABLED