Including Functions.php

Time Before: 0.01942 seconds
Time After: 0.02008 seconds
Time Taken: 0.00067 seconds

Memory Before: 758.813 KB
Memory After: 767.500 KB
Memory Used: 8.688 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.02024 seconds
Time After: 0.02405 seconds
Time Taken: 0.00381 seconds

Memory Before: 767.422 KB
Memory After: 768.297 KB
Memory Used: 0.875 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.02567 seconds
Time After: 0.02604 seconds
Time Taken: 0.00037 seconds

Memory Before: 769.047 KB
Memory After: 769.570 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.02830 seconds
Time After: 0.03034 seconds
Time Taken: 0.00204 seconds

Memory Before: 772.305 KB
Memory After: 772.641 KB
Memory Used: 0.336 KB

Time Before: 0.02728 seconds
Time After: 0.03649 seconds
Time Taken: 0.00921 seconds

Memory Before: 768.844 KB
Memory After: 2,517.969 KB
Memory Used: 1,749.125 KB

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

Time Before: 0.03853 seconds
Time After: 0.03891 seconds
Time Taken: 0.00039 seconds

Memory Before: 2,542.109 KB
Memory After: 2,542.602 KB
Memory Used: 0.492 KB

Session Handling
SQL Query
SELECT *
FROM vb_session
WHERE userid = 0
	AND host = '34.204.189.171'
	AND idhash = 'fa2082900578e72eb1da75e75823b084'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_sessionALL    27Using where

Time Before: 0.04104 seconds
Time After: 0.04160 seconds
Time Taken: 0.00056 seconds

Memory Before: 2,927.070 KB
Memory After: 2,927.484 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.04321 seconds
Time After: 0.04379 seconds
Time Taken: 0.00058 seconds

Memory Before: 2,938.625 KB
Memory After: 2,938.250 KB
Memory Used: -0.375 KB

Time Before: 0.04024 seconds
Time After: 0.04405 seconds
Time Taken: 0.00382 seconds

Memory Before: 2,922.555 KB
Memory After: 3,075.227 KB
Memory Used: 152.672 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.05571 seconds
Time After: 0.05605 seconds
Time Taken: 0.00034 seconds

Memory Before: 3,407.508 KB
Memory After: 3,407.945 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.05968 seconds
Time After: 0.06032 seconds
Time Taken: 0.00064 seconds

Memory Before: 3,698.484 KB
Memory After: 3,698.297 KB
Memory Used: -0.188 KB

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

Time Before: 0.07139 seconds
Time After: 0.07182 seconds
Time Taken: 0.00043 seconds

Memory Before: 4,287.602 KB
Memory After: 4,288.484 KB
Memory Used: 0.883 KB

SQL Query
UPDATE vb_cybvilxh_guests
SET dateline = '1571733223'
WHERE userip = '34.204.189.171'

Time Before: 0.07193 seconds
Time After: 0.13737 seconds
Time Taken: 0.06544 seconds

Memory Before: 4,288.781 KB
Memory After: 4,289.078 KB
Memory Used: 0.297 KB

SQL Query
DELETE FROM vb_cybvilxh_guests WHERE dateline < '1571646823'

Time Before: 0.13748 seconds
Time After: 0.13791 seconds
Time Taken: 0.00043 seconds

Memory Before: 4,287.922 KB
Memory After: 4,288.273 KB
Memory Used: 0.352 KB

End call of global.php: 0.14071106910706
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.15069 seconds
Time After: 0.15096 seconds
Time Taken: 0.00028 seconds

Memory Before: 4,639.953 KB
Memory After: 4,640.359 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
1SIMPLEuserindexusergroupidusergroupid2 344Using where; Using index

Time Before: 0.15277 seconds
Time After: 0.15345 seconds
Time Taken: 0.00068 seconds

Memory Before: 4,678.141 KB
Memory After: 4,678.547 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
1SIMPLEuserALLusergroupid   344Using where; Using filesort
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 
1SIMPLEusertextfieldeq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 

Time Before: 0.15621 seconds
Time After: 0.16903 seconds
Time Taken: 0.01282 seconds

Memory Before: 4,691.938 KB
Memory After: 4,691.406 KB
Memory Used: -0.531 KB

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

Time Before: 0.20397 seconds
Time After: 0.20444 seconds
Time Taken: 0.00046 seconds

Memory Before: 5,149.547 KB
Memory After: 5,149.688 KB
Memory Used: 0.141 KB

Page generated in 0.20285892486572 seconds with 14 queries, spending 0.080536365509033 doing MySQL queries and 0.12232255935669 doing PHP things.
Shutdown Queries:
DISABLED