Including Functions.php

Time Before: 0.00216 seconds
Time After: 0.00277 seconds
Time Taken: 0.00061 seconds

Memory Before: 423.477 KB
Memory After: 431.609 KB
Memory Used: 8.133 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00291 seconds
Time After: 0.00678 seconds
Time Taken: 0.00387 seconds

Memory Before: 431.508 KB
Memory After: 432.414 KB
Memory Used: 0.906 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00847 seconds
Time After: 0.00879 seconds
Time Taken: 0.00032 seconds

Memory Before: 433.078 KB
Memory After: 433.602 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')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_datastorerangePRIMARYPRIMARY50 14Using where

Time Before: 0.01081 seconds
Time After: 0.01243 seconds
Time Taken: 0.00161 seconds

Memory Before: 436.055 KB
Memory After: 436.391 KB
Memory Used: 0.336 KB

Time Before: 0.00996 seconds
Time After: 0.01854 seconds
Time Taken: 0.00857 seconds

Memory Before: 432.844 KB
Memory After: 2,181.742 KB
Memory Used: 1,748.898 KB

SQL Query
SELECT *
FROM vb_datastore
WHERE title IN ('wol_spiders')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_datastoreconstPRIMARYPRIMARY50const1 

Time Before: 0.02046 seconds
Time After: 0.02080 seconds
Time Taken: 0.00034 seconds

Memory Before: 2,208.789 KB
Memory After: 2,209.281 KB
Memory Used: 0.492 KB

Session Handling
SQL Query
SELECT *
FROM vb_session
WHERE userid = 0
	AND host = '34.204.176.125'
	AND idhash = '3bbd76b974ad66ba464b7c77ac0d4b31'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_sessionALL    58Using where

Time Before: 0.02287 seconds
Time After: 0.02357 seconds
Time Taken: 0.00070 seconds

Memory Before: 2,594.352 KB
Memory After: 2,594.766 KB
Memory Used: 0.414 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_user AS phrasegroup_user,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
			phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
			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.02480 seconds
Time After: 0.02536 seconds
Time Taken: 0.00056 seconds

Memory Before: 2,605.625 KB
Memory After: 2,605.250 KB
Memory Used: -0.375 KB

Time Before: 0.02211 seconds
Time After: 0.02564 seconds
Time Taken: 0.00352 seconds

Memory Before: 2,589.195 KB
Memory After: 2,742.234 KB
Memory Used: 153.039 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.03719 seconds
Time After: 0.03754 seconds
Time Taken: 0.00035 seconds

Memory Before: 3,074.078 KB
Memory After: 3,074.516 KB
Memory Used: 0.438 KB

SQL Query
SELECT title, template
FROM vb_template
WHERE templateid IN (3694,234,237,1039,236,186,3784,189,196,195,156,368,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,2128,3788,3787,1115,1113,1112,1114,1122,1123,1128,3531,3779,1238,1237,1250,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 146Using where

Time Before: 0.04086 seconds
Time After: 0.04153 seconds
Time Taken: 0.00066 seconds

Memory Before: 3,364.273 KB
Memory After: 3,364.086 KB
Memory Used: -0.188 KB

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

Time Before: 0.05171 seconds
Time After: 0.05220 seconds
Time Taken: 0.00050 seconds

Memory Before: 3,950.969 KB
Memory After: 3,951.852 KB
Memory Used: 0.883 KB

SQL Query
UPDATE vb_cybvilxh_guests
SET dateline = '1591106312'
WHERE userip = '34.204.176.125'

Time Before: 0.05231 seconds
Time After: 0.15324 seconds
Time Taken: 0.10094 seconds

Memory Before: 3,952.117 KB
Memory After: 3,952.414 KB
Memory Used: 0.297 KB

SQL Query
DELETE FROM vb_cybvilxh_guests WHERE dateline < '1591019912'

Time Before: 0.15340 seconds
Time After: 0.15394 seconds
Time Taken: 0.00054 seconds

Memory Before: 3,951.258 KB
Memory After: 3,951.609 KB
Memory Used: 0.352 KB

End call of global.php: 0.15648198127747
SQL Query
SELECT profilefieldid, type, data, optional, memberlist, searchable
FROM vb_profilefield
WHERE form = 0 	AND hidden = 0
ORDER BY displayorder
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_profilefieldALL    16Using where; Using filesort

Time Before: 0.15956 seconds
Time After: 0.15979 seconds
Time Taken: 0.00023 seconds

Memory Before: 3,827.086 KB
Memory After: 3,827.492 KB
Memory Used: 0.406 KB

SQL Query
SELECT COUNT(*) AS users
FROM vb_user AS user


WHERE 1=1
	AND (user.usergroupid IN (-1,10,12,9,11,39,38,37,19,36,40,6,5,8,7,3,2,34))
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserrangeusergroupidusergroupid2 869Using where; Using index

Time Before: 0.16137 seconds
Time After: 0.16215 seconds
Time Taken: 0.00078 seconds

Memory Before: 3,864.609 KB
Memory After: 3,865.016 KB
Memory Used: 0.406 KB

SQL Query
SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight

 , IF((options & 512 AND user.userid <> 0), 0, lastactivity) AS lastvisittime 
, IF(YEAR(user.birthday_search) > 0 AND user.showbirthday IN (1,2) AND YEAR(user.birthday_search) < YEAR(CURDATE()), user.birthday_search, '0000-00-00') AS agesort

, user.xperience, user.xperience_level 
FROM vb_user AS user
LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN vb_userfield AS userfield ON(userfield.userid=user.userid)

LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)



WHERE 1=1
	AND (user.usergroupid IN (-1,10,12,9,11,39,38,37,19,36,40,6,5,8,7,3,2,34))
	
ORDER BY user.username asc 
LIMIT 300, 30
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEavatarsystemPRIMARY   0const row not found
1SIMPLEuserrangeusergroupidusergroupid2 869Using where; Using filesort
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 
1SIMPLEusertextfieldeq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 

Time Before: 0.16462 seconds
Time After: 0.18196 seconds
Time Taken: 0.01734 seconds

Memory Before: 3,877.930 KB
Memory After: 3,877.406 KB
Memory Used: -0.523 KB

SQL Query
UPDATE vb_session
SET lastactivity = 1591106312, location = '/forum/memberlist.php?order=asc&sort=username&page=11&explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '771c8f7032267d1b82d4c4dab2f0c55d'

Time Before: 0.22488 seconds
Time After: 0.22529 seconds
Time Taken: 0.00041 seconds

Memory Before: 4,343.445 KB
Memory After: 4,343.586 KB
Memory Used: 0.141 KB

Page generated in 0.22354888916016 seconds with 14 queries, spending 0.12072944641113 doing MySQL queries and 0.10281944274902 doing PHP things.
Shutdown Queries:
DISABLED