Including Functions.php

Time Before: 0.00188 seconds
Time After: 0.00247 seconds
Time Taken: 0.00060 seconds

Memory Before: 416.555 KB
Memory After: 424.688 KB
Memory Used: 8.133 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00259 seconds
Time After: 0.00653 seconds
Time Taken: 0.00394 seconds

Memory Before: 424.586 KB
Memory After: 425.492 KB
Memory Used: 0.906 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00818 seconds
Time After: 0.00836 seconds
Time Taken: 0.00018 seconds

Memory Before: 426.156 KB
Memory After: 426.680 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','tagcloud','iconcache')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_datastorerangePRIMARYPRIMARY50 16Using where

Time Before: 0.01024 seconds
Time After: 0.01397 seconds
Time Taken: 0.00373 seconds

Memory Before: 429.227 KB
Memory After: 429.539 KB
Memory Used: 0.313 KB

Time Before: 0.00940 seconds
Time After: 0.02020 seconds
Time Taken: 0.01079 seconds

Memory Before: 425.922 KB
Memory After: 2,201.875 KB
Memory Used: 1,775.953 KB

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

Time Before: 0.02216 seconds
Time After: 0.02242 seconds
Time Taken: 0.00026 seconds

Memory Before: 2,228.953 KB
Memory After: 2,229.445 KB
Memory Used: 0.492 KB

Session Handling
SQL Query
SELECT *
FROM vb_session
WHERE userid = 0
	AND host = '75.101.173.236'
	AND idhash = 'a60a46834ce9a37a12d43aefdae7e6f0'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_sessionALL    148Using where

Time Before: 0.02431 seconds
Time After: 0.02473 seconds
Time Taken: 0.00042 seconds

Memory Before: 2,614.492 KB
Memory After: 2,614.906 KB
Memory Used: 0.414 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_search AS phrasegroup_search,
			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.02612 seconds
Time After: 0.02792 seconds
Time Taken: 0.00179 seconds

Memory Before: 2,625.406 KB
Memory After: 2,625.141 KB
Memory Used: -0.266 KB

Time Before: 0.02366 seconds
Time After: 0.02815 seconds
Time Taken: 0.00449 seconds

Memory Before: 2,609.398 KB
Memory After: 2,725.203 KB
Memory Used: 115.805 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.03755 seconds
Time After: 0.03778 seconds
Time Taken: 0.00022 seconds

Memory Before: 2,982.453 KB
Memory After: 2,982.891 KB
Memory Used: 0.438 KB

SQL Query
SELECT title, template
FROM vb_template
WHERE templateid IN (472,474,475,476,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 138Using where

Time Before: 0.04083 seconds
Time After: 0.15734 seconds
Time Taken: 0.11651 seconds

Memory Before: 3,270.906 KB
Memory After: 3,270.742 KB
Memory Used: -0.164 KB

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

Time Before: 0.16994 seconds
Time After: 0.17067 seconds
Time Taken: 0.00073 seconds

Memory Before: 3,850.266 KB
Memory After: 3,851.148 KB
Memory Used: 0.883 KB

SQL Query
UPDATE vb_cybvilxh_guests
SET dateline = '1596837793'
WHERE userip = '75.101.173.236'

Time Before: 0.17084 seconds
Time After: 0.53384 seconds
Time Taken: 0.36300 seconds

Memory Before: 3,851.414 KB
Memory After: 3,851.711 KB
Memory Used: 0.297 KB

SQL Query
DELETE FROM vb_cybvilxh_guests WHERE dateline < '1596751393'

Time Before: 0.53399 seconds
Time After: 0.53483 seconds
Time Taken: 0.00083 seconds

Memory Before: 3,850.555 KB
Memory After: 3,850.906 KB
Memory Used: 0.352 KB

End call of global.php: 0.53726100921631
SQL Query
SELECT tagthread.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM vb_tagthread AS tagthread
INNER JOIN vb_tag AS tag ON (tagthread.tagid = tag.tagid)
INNER JOIN vb_thread AS thread ON (tagthread.threadid = thread.threadid)
WHERE thread.open <> 10
	AND thread.visible = 1
AND thread.forumid IN (1,2,176,3,65,5,6,11,12,230,66,236,239,78,67,241,26,237,20,55,13,14,70,233,235,234,69,15,59,60,61,17,21,63,228,229,16,56,57,58,62,166,167,22,225)
AND tagthread.dateline > 1565301793
GROUP BY tagthread.tagid, tag.tagtext
ORDER BY searchcount DESC
LIMIT 50
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtagthreadrangePRIMARY,threadid,datelinedateline4 1Using where; Using temporary; Using filesort
1SIMPLEthreadeq_refPRIMARY,forumidPRIMARY4lddnsk_forum.tagthread.threadid1Using where
1SIMPLEtageq_refPRIMARYPRIMARY4lddnsk_forum.tagthread.tagid1 

Time Before: 0.53940 seconds
Time After: 0.54037 seconds
Time Taken: 0.00097 seconds

Memory Before: 3,648.547 KB
Memory After: 3,648.523 KB
Memory Used: -0.023 KB

SQL Query
REPLACE INTO vb_datastore
	(title, data, unserialize)
VALUES
	('tagcloud', 'a:3:{s:4:\"tags\";a:0:{}s:5:\"count\";i:0;s:8:\"dateline\";i:1596837793;}', 1)

Time Before: 0.54093 seconds
Time After: 0.54257 seconds
Time Taken: 0.00163 seconds

Memory Before: 3,647.984 KB
Memory After: 3,648.219 KB
Memory Used: 0.234 KB

SQL Query
UPDATE vb_session
SET lastactivity = 1596837793, location = '/forum/tags.php?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'f5042577d54ea4171ca30818ed558834'

Time Before: 0.54614 seconds
Time After: 0.54661 seconds
Time Taken: 0.00047 seconds

Memory Before: 3,896.617 KB
Memory After: 3,896.813 KB
Memory Used: 0.195 KB

Page generated in 0.54496598243713 seconds with 13 queries, spending 0.36764359474182 doing MySQL queries and 0.17732238769531 doing PHP things.
Shutdown Queries:
DISABLED