Including Functions.php

Time Before: 0.00329 seconds
Time After: 0.00390 seconds
Time Taken: 0.00061 seconds

Memory Before: 747.172 KB
Memory After: 755.578 KB
Memory Used: 8.406 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00403 seconds
Time After: 0.00808 seconds
Time Taken: 0.00406 seconds

Memory Before: 755.539 KB
Memory After: 756.414 KB
Memory Used: 0.875 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00952 seconds
Time After: 0.00972 seconds
Time Taken: 0.00019 seconds

Memory Before: 757.164 KB
Memory After: 757.688 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.01132 seconds
Time After: 0.01374 seconds
Time Taken: 0.00241 seconds

Memory Before: 760.328 KB
Memory After: 760.664 KB
Memory Used: 0.336 KB

Time Before: 0.01056 seconds
Time After: 0.01973 seconds
Time Taken: 0.00917 seconds

Memory Before: 756.930 KB
Memory After: 2,505.984 KB
Memory Used: 1,749.055 KB

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

Time Before: 0.02157 seconds
Time After: 0.02173 seconds
Time Taken: 0.00016 seconds

Memory Before: 2,529.938 KB
Memory After: 2,530.430 KB
Memory Used: 0.492 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    7Using where

Time Before: 0.02355 seconds
Time After: 0.02408 seconds
Time Taken: 0.00053 seconds

Memory Before: 2,915.508 KB
Memory After: 2,915.914 KB
Memory Used: 0.406 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.02539 seconds
Time After: 0.02580 seconds
Time Taken: 0.00041 seconds

Memory Before: 2,926.750 KB
Memory After: 2,926.375 KB
Memory Used: -0.375 KB

Time Before: 0.02296 seconds
Time After: 0.02606 seconds
Time Taken: 0.00310 seconds

Memory Before: 2,910.328 KB
Memory After: 3,063.320 KB
Memory Used: 152.992 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.03743 seconds
Time After: 0.03769 seconds
Time Taken: 0.00027 seconds

Memory Before: 3,395.094 KB
Memory After: 3,395.531 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.04090 seconds
Time After: 0.04145 seconds
Time Taken: 0.00056 seconds

Memory Before: 3,685.344 KB
Memory After: 3,685.156 KB
Memory Used: -0.188 KB

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

Time Before: 0.05126 seconds
Time After: 0.05213 seconds
Time Taken: 0.00087 seconds

Memory Before: 4,271.133 KB
Memory After: 4,272.016 KB
Memory Used: 0.883 KB

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

Time Before: 0.05222 seconds
Time After: 0.12184 seconds
Time Taken: 0.06962 seconds

Memory Before: 4,272.305 KB
Memory After: 4,272.609 KB
Memory Used: 0.305 KB

SQL Query
DELETE FROM vb_cybvilxh_guests WHERE dateline < '1573562518'

Time Before: 0.12196 seconds
Time After: 0.12381 seconds
Time Taken: 0.00185 seconds

Memory Before: 4,271.453 KB
Memory After: 4,271.805 KB
Memory Used: 0.352 KB

End call of global.php: 0.12637090682983
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.13841 seconds
Time After: 0.13872 seconds
Time Taken: 0.00031 seconds

Memory Before: 4,621.133 KB
Memory After: 4,621.539 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 21Using where

Time Before: 0.14079 seconds
Time After: 0.14172 seconds
Time Taken: 0.00093 seconds

Memory Before: 4,659.430 KB
Memory After: 4,659.820 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 21Using where
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 
1SIMPLEusertextfieldeq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 

Time Before: 0.14470 seconds
Time After: 0.14738 seconds
Time Taken: 0.00269 seconds

Memory Before: 4,673.094 KB
Memory After: 4,672.539 KB
Memory Used: -0.555 KB

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

Time Before: 0.17627 seconds
Time After: 0.17667 seconds
Time Taken: 0.00040 seconds

Memory Before: 5,076.000 KB
Memory After: 5,076.133 KB
Memory Used: 0.133 KB

Page generated in 0.17512989044189 seconds with 14 queries, spending 0.07666802406311 doing MySQL queries and 0.098461866378784 doing PHP things.
Shutdown Queries:
DISABLED