Including Functions.php

Time Before: 0.00706 seconds
Time After: 0.01148 seconds
Time Taken: 0.00443 seconds

Memory Before: 1,184.258 KB
Memory After: 1,928.266 KB
Memory Used: 744.008 KB

Connect to Database on Server: localhost

Time Before: 0.01154 seconds
Time After: 0.01243 seconds
Time Taken: 0.00090 seconds

Memory Before: 1,928.250 KB
Memory After: 1,935.797 KB
Memory Used: 7.547 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01284 seconds
Time After: 0.01328 seconds
Time Taken: 0.00044 seconds

Memory Before: 1,936.508 KB
Memory After: 1,937.070 KB
Memory Used: 0.563 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 14Using index condition

Time Before: 0.01444 seconds
Time After: 0.01685 seconds
Time Taken: 0.00240 seconds

Memory Before: 1,939.711 KB
Memory After: 1,986.125 KB
Memory Used: 46.414 KB

Time Before: 0.01335 seconds
Time After: 0.02065 seconds
Time Taken: 0.00731 seconds

Memory Before: 1,936.313 KB
Memory After: 3,430.266 KB
Memory Used: 1,493.953 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('ehdaa_userban','ehdaa')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 2Using index condition

Time Before: 0.02261 seconds
Time After: 0.02300 seconds
Time Taken: 0.00039 seconds

Memory Before: 3,455.133 KB
Memory After: 3,457.641 KB
Memory Used: 2.508 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '216.73.216.236'
	AND idhash = 'ea5a359a73a8141a16de516480d33c34'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    110Using where

Time Before: 0.02406 seconds
Time After: 0.02459 seconds
Time Taken: 0.00053 seconds

Memory Before: 3,480.359 KB
Memory After: 3,485.844 KB
Memory Used: 5.484 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_messaging AS phrasegroup_messaging,
			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 language
WHERE languageid = 2
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguageconstPRIMARYPRIMARY2const1 

Time Before: 0.02574 seconds
Time After: 0.02643 seconds
Time Taken: 0.00069 seconds

Memory Before: 3,491.227 KB
Memory After: 3,496.422 KB
Memory Used: 5.195 KB

Time Before: 0.02323 seconds
Time After: 0.02664 seconds
Time Taken: 0.00341 seconds

Memory Before: 3,475.602 KB
Memory After: 3,540.633 KB
Memory Used: 65.031 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 72 AND userselect = 1)
	OR styleid = 72
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 

Time Before: 0.02907 seconds
Time After: 0.02947 seconds
Time Taken: 0.00040 seconds

Memory Before: 3,628.219 KB
Memory After: 3,632.734 KB
Memory Used: 4.516 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (5597,5601,5581,5582,5330,0,5212,6838,6856,5592,5095,5094,5096,5091,5090,5367,5006,5319,5320,5321,5587,5590,5599,5340,5341,5342,5343,5541,5604,5603,5605,5608,4697,4702,4701,4703,4705,4684,4675,4676,4680,4683,4681,4677,4673,4682,4685,4686,4678,4674,4687,4679,4644,4645,4656,4669,4670,3211,4503,0,4504,4506,6848,6850,6849,4689,4690,4698,4699,4700,6034,6038,6037,6036,6035,6032,6031,5159,5160,5161,5162,5163,5164,5166,5329,5167,5177,6033,6039)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 88Using index condition

Time Before: 0.03117 seconds
Time After: 0.03284 seconds
Time Taken: 0.00167 seconds

Memory Before: 3,851.633 KB
Memory After: 3,855.453 KB
Memory Used: 3.820 KB

SQL Query
SELECT *
FROM bbcode
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEbbcodesystem    1 

Time Before: 0.08283 seconds
Time After: 0.08295 seconds
Time Taken: 0.00012 seconds

Memory Before: 5,349.227 KB
Memory After: 5,353.195 KB
Memory Used: 3.969 KB

SQL Query
SELECT *, LENGTH(smilietext) AS smilielen
FROM smilie
ORDER BY smilielen DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsmilieALL    80Using filesort

Time Before: 0.08344 seconds
Time After: 0.08372 seconds
Time Taken: 0.00027 seconds

Memory Before: 5,367.703 KB
Memory After: 5,376.023 KB
Memory Used: 8.320 KB

SQL Query
SELECT userip
FROM cybvilxh_guests AS cybvilxh_guests
WHERE userip = '216.73.216.236'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcybvilxh_guestsALL    681Using where

Time Before: 0.09875 seconds
Time After: 0.09917 seconds
Time Taken: 0.00043 seconds

Memory Before: 5,508.266 KB
Memory After: 5,510.266 KB
Memory Used: 2.000 KB

SQL Query
UPDATE cybvilxh_guests
SET dateline = '1752289960'
WHERE userip = '216.73.216.236'

Time Before: 0.09921 seconds
Time After: 0.10261 seconds
Time Taken: 0.00340 seconds

Memory Before: 5,510.422 KB
Memory After: 5,510.789 KB
Memory Used: 0.367 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1752030760'

Time Before: 0.10268 seconds
Time After: 0.10301 seconds
Time Taken: 0.00033 seconds

Memory Before: 5,508.102 KB
Memory After: 5,508.391 KB
Memory Used: 0.289 KB

End call of global.php: 0.10383796691895
SQL Query
SELECT hvquestion.questionid, COUNT(*) AS answers
FROM hvquestion AS hvquestion
LEFT JOIN hvanswer AS hvanswer
	ON (hvquestion.questionid = hvanswer.questionid)
WHERE hvanswer.answerid IS NOT NULL
	OR hvquestion.regex <> ''
GROUP BY hvquestion.questionid
ORDER BY RAND()
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhvquestionsystem    1 
1SIMPLEhvanswersystemPRIMARY,questionid   0Const row not found

Time Before: 0.10649 seconds
Time After: 0.10675 seconds
Time Taken: 0.00026 seconds

Memory Before: 4,932.844 KB
Memory After: 4,934.820 KB
Memory Used: 1.977 KB

SQL Query
INSERT INTO humanverify
	(hash, answer, dateline)
VALUES
	('a5aaa29be0434323b48c0ea9f2ea0601', '1', 1752289960)

Time Before: 0.10680 seconds
Time After: 0.10706 seconds
Time Taken: 0.00026 seconds

Memory Before: 4,932.656 KB
Memory After: 4,932.938 KB
Memory Used: 0.281 KB

SQL Query
SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'hvquestion'
	AND varname = 'question1'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserefname_lang_typename_lang_type252const1Using index condition
1SIMPLEphrasetypeconstPRIMARYPRIMARY22const1Using where

Time Before: 0.10875 seconds
Time After: 0.10909 seconds
Time Taken: 0.00034 seconds

Memory Before: 5,065.125 KB
Memory After: 5,067.523 KB
Memory Used: 2.398 KB

SQL Query
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid
	
FROM forum AS forum
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumALL    108 

Time Before: 0.11092 seconds
Time After: 0.11129 seconds
Time Taken: 0.00037 seconds

Memory Before: 5,416.250 KB
Memory After: 5,429.445 KB
Memory Used: 13.195 KB

SQL Query
UPDATE session
SET lastactivity = 1752289960, location = '/vb/sendmessage.php?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
WHERE sessionhash = '458929fbe46b99375e43cefb00a0a604'

Time Before: 0.11236 seconds
Time After: 0.11255 seconds
Time Taken: 0.00019 seconds

Memory Before: 5,574.609 KB
Memory After: 5,574.750 KB
Memory Used: 0.141 KB

Page generated in 0.10980296134949 seconds with 26 queries, spending 0.044672727584839 doing MySQL queries and 0.065130233764648 doing PHP things.
Shutdown Queries:
DISABLED