Including Functions.php

Time Before: 0.00353 seconds
Time After: 0.00419 seconds
Time Taken: 0.00066 seconds

Memory Before: 496.227 KB
Memory After: 504.633 KB
Memory Used: 8.406 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00430 seconds
Time After: 0.00773 seconds
Time Taken: 0.00343 seconds

Memory Before: 504.594 KB
Memory After: 505.469 KB
Memory Used: 0.875 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00930 seconds
Time After: 0.00947 seconds
Time Taken: 0.00017 seconds

Memory Before: 506.219 KB
Memory After: 506.742 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.01121 seconds
Time After: 0.01315 seconds
Time Taken: 0.00194 seconds

Memory Before: 509.383 KB
Memory After: 509.719 KB
Memory Used: 0.336 KB

Time Before: 0.01043 seconds
Time After: 0.01948 seconds
Time Taken: 0.00905 seconds

Memory Before: 505.984 KB
Memory After: 2,255.070 KB
Memory Used: 1,749.086 KB

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

Time Before: 0.02141 seconds
Time After: 0.02164 seconds
Time Taken: 0.00023 seconds

Memory Before: 2,279.047 KB
Memory After: 2,279.539 KB
Memory Used: 0.492 KB

Session Handling
SQL Query
SELECT *
FROM vb_session
WHERE userid = 0
	AND host = '34.231.21.160'
	AND idhash = 'ba885b1e4a38b7ec4e31331ed922144c'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_sessionALL    128Using where

Time Before: 0.02360 seconds
Time After: 0.02411 seconds
Time Taken: 0.00051 seconds

Memory Before: 2,664.633 KB
Memory After: 2,665.047 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.02509 seconds
Time After: 0.02579 seconds
Time Taken: 0.00070 seconds

Memory Before: 2,675.891 KB
Memory After: 2,675.516 KB
Memory Used: -0.375 KB

Time Before: 0.02297 seconds
Time After: 0.02608 seconds
Time Taken: 0.00311 seconds

Memory Before: 2,659.453 KB
Memory After: 2,812.469 KB
Memory Used: 153.016 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.03833 seconds
Time After: 0.03864 seconds
Time Taken: 0.00031 seconds

Memory Before: 3,144.328 KB
Memory After: 3,144.766 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.04209 seconds
Time After: 0.04282 seconds
Time Taken: 0.00073 seconds

Memory Before: 3,434.547 KB
Memory After: 3,434.359 KB
Memory Used: -0.188 KB

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

Time Before: 0.05337 seconds
Time After: 0.05375 seconds
Time Taken: 0.00038 seconds

Memory Before: 4,021.195 KB
Memory After: 4,022.078 KB
Memory Used: 0.883 KB

SQL Query
UPDATE vb_cybvilxh_guests
SET dateline = '1593805953'
WHERE userip = '34.231.21.160'

Time Before: 0.05386 seconds
Time After: 0.13200 seconds
Time Taken: 0.07814 seconds

Memory Before: 4,022.375 KB
Memory After: 4,022.672 KB
Memory Used: 0.297 KB

SQL Query
DELETE FROM vb_cybvilxh_guests WHERE dateline < '1593719553'

Time Before: 0.13213 seconds
Time After: 0.19044 seconds
Time Taken: 0.05831 seconds

Memory Before: 4,021.516 KB
Memory After: 4,021.867 KB
Memory Used: 0.352 KB

End call of global.php: 0.19390201568604
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.19794 seconds
Time After: 0.19817 seconds
Time Taken: 0.00022 seconds

Memory Before: 3,897.266 KB
Memory After: 3,897.672 KB
Memory Used: 0.406 KB

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


WHERE 1=1 AND username LIKE("K%")
	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 15Using where

Time Before: 0.20015 seconds
Time After: 0.20037 seconds
Time Taken: 0.00022 seconds

Memory Before: 3,934.906 KB
Memory After: 3,935.297 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("K%")
	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 15Using where
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 
1SIMPLEusertextfieldeq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 

Time Before: 0.20327 seconds
Time After: 0.20538 seconds
Time Taken: 0.00211 seconds

Memory Before: 3,948.055 KB
Memory After: 3,947.500 KB
Memory Used: -0.555 KB

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

Time Before: 0.22541 seconds
Time After: 0.22581 seconds
Time Taken: 0.00040 seconds

Memory Before: 4,323.914 KB
Memory After: 4,324.047 KB
Memory Used: 0.133 KB

Page generated in 0.22428297996521 seconds with 14 queries, spending 0.13978004455566 doing MySQL queries and 0.084502935409546 doing PHP things.
Shutdown Queries:
DISABLED