Including Functions.php

Time Before: 0.00189 seconds
Time After: 0.00247 seconds
Time Taken: 0.00058 seconds

Memory Before: 424.047 KB
Memory After: 432.180 KB
Memory Used: 8.133 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00261 seconds
Time After: 0.00660 seconds
Time Taken: 0.00399 seconds

Memory Before: 432.078 KB
Memory After: 432.984 KB
Memory Used: 0.906 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00811 seconds
Time After: 0.00829 seconds
Time Taken: 0.00018 seconds

Memory Before: 433.648 KB
Memory After: 434.172 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.01016 seconds
Time After: 0.01210 seconds
Time Taken: 0.00194 seconds

Memory Before: 436.625 KB
Memory After: 436.961 KB
Memory Used: 0.336 KB

Time Before: 0.00934 seconds
Time After: 0.01845 seconds
Time Taken: 0.00911 seconds

Memory Before: 433.414 KB
Memory After: 2,182.359 KB
Memory Used: 1,748.945 KB

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

Time Before: 0.02035 seconds
Time After: 0.02061 seconds
Time Taken: 0.00026 seconds

Memory Before: 2,209.383 KB
Memory After: 2,209.875 KB
Memory Used: 0.492 KB

Session Handling
SQL Query
SELECT *
FROM vb_session
WHERE userid = 0
	AND host = '18.232.38.214'
	AND idhash = '728670f2aa309b784f177fc4c1a2cfdc'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_sessionALL    23Using where

Time Before: 0.02281 seconds
Time After: 0.02344 seconds
Time Taken: 0.00063 seconds

Memory Before: 2,594.984 KB
Memory After: 2,595.398 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.02448 seconds
Time After: 0.02515 seconds
Time Taken: 0.00067 seconds

Memory Before: 2,606.266 KB
Memory After: 2,605.891 KB
Memory Used: -0.375 KB

Time Before: 0.02214 seconds
Time After: 0.02543 seconds
Time Taken: 0.00330 seconds

Memory Before: 2,589.828 KB
Memory After: 2,742.875 KB
Memory Used: 153.047 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.03703 seconds
Time After: 0.03723 seconds
Time Taken: 0.00020 seconds

Memory Before: 3,074.641 KB
Memory After: 3,075.078 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.04029 seconds
Time After: 0.04103 seconds
Time Taken: 0.00075 seconds

Memory Before: 3,364.820 KB
Memory After: 3,364.633 KB
Memory Used: -0.188 KB

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

Time Before: 0.05104 seconds
Time After: 0.05143 seconds
Time Taken: 0.00039 seconds

Memory Before: 3,951.523 KB
Memory After: 3,952.406 KB
Memory Used: 0.883 KB

SQL Query
UPDATE vb_cybvilxh_guests
SET dateline = '1591408479'
WHERE userip = '18.232.38.214'

Time Before: 0.05152 seconds
Time After: 0.10921 seconds
Time Taken: 0.05769 seconds

Memory Before: 3,952.672 KB
Memory After: 3,952.969 KB
Memory Used: 0.297 KB

SQL Query
DELETE FROM vb_cybvilxh_guests WHERE dateline < '1591322079'

Time Before: 0.10932 seconds
Time After: 0.10972 seconds
Time Taken: 0.00040 seconds

Memory Before: 3,951.813 KB
Memory After: 3,952.164 KB
Memory Used: 0.352 KB

End call of global.php: 0.1123731136322
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.11566 seconds
Time After: 0.11589 seconds
Time Taken: 0.00023 seconds

Memory Before: 3,827.570 KB
Memory After: 3,827.977 KB
Memory Used: 0.406 KB

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


WHERE 1=1 AND username LIKE("C%")
	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
1SIMPLEuserrangeusergroupid,usernameusername102 32Using where

Time Before: 0.11763 seconds
Time After: 0.11840 seconds
Time Taken: 0.00077 seconds

Memory Before: 3,865.219 KB
Memory After: 3,865.609 KB
Memory Used: 0.391 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 username LIKE("C%")
	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 0, 30
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEavatarsystemPRIMARY   0const row not found
1SIMPLEuserrangeusergroupid,usernameusername102 32Using where
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 
1SIMPLEusertextfieldeq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 

Time Before: 0.12093 seconds
Time After: 0.12343 seconds
Time Taken: 0.00250 seconds

Memory Before: 3,878.375 KB
Memory After: 3,877.820 KB
Memory Used: -0.555 KB

SQL Query
UPDATE vb_session
SET lastactivity = 1591408479, location = '/forum/memberlist.php?ltr=C&pp=30&sort=username&order=asc&explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '2558aa48fa8cf7ddb55e36fdff8a481c'

Time Before: 0.14962 seconds
Time After: 0.15000 seconds
Time Taken: 0.00038 seconds

Memory Before: 4,283.164 KB
Memory After: 4,283.297 KB
Memory Used: 0.133 KB

Page generated in 0.14851498603821 seconds with 14 queries, spending 0.062352895736694 doing MySQL queries and 0.086162090301514 doing PHP things.
Shutdown Queries:
DISABLED