Time Before: 0.00411 seconds
Time After: 0.00734 seconds
Time Taken: 0.00323 seconds

Memory Before: 1,112.438 KB
Memory After: 1,856.523 KB
Memory Used: 744.086 KB

Time Before: 0.00739 seconds
Time After: 0.00792 seconds
Time Taken: 0.00053 seconds

Memory Before: 1,856.508 KB
Memory After: 1,864.055 KB
Memory Used: 7.547 KB

SET @@sql_mode = ''

Time Before: 0.00810 seconds
Time After: 0.00849 seconds
Time Taken: 0.00039 seconds

Memory Before: 1,864.773 KB
Memory After: 1,865.336 KB
Memory Used: 0.563 KB

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache')

Time Before: 0.00851 seconds
Time After: 0.01161 seconds
Time Taken: 0.00310 seconds

Memory Before: 1,864.578 KB
Memory After: 3,358.594 KB
Memory Used: 1,494.016 KB

SELECT *
FROM datastore
WHERE title IN ('ehdaa_userban','ehdaa')

Time Before: 0.01255 seconds
Time After: 0.01293 seconds
Time Taken: 0.00038 seconds

Memory Before: 3,383.477 KB
Memory After: 3,385.984 KB
Memory Used: 2.508 KB

SELECT *
FROM session
WHERE userid = 0
	AND host = '216.73.216.138'
	AND idhash = 'ea5a359a73a8141a16de516480d33c34'
LIMIT 1

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			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

Time Before: 0.01300 seconds
Time After: 0.01506 seconds
Time Taken: 0.00206 seconds

Memory Before: 3,404.078 KB
Memory After: 3,465.414 KB
Memory Used: 61.336 KB

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

Time Before: 0.01623 seconds
Time After: 0.01658 seconds
Time Taken: 0.00035 seconds

Memory Before: 3,546.969 KB
Memory After: 3,551.492 KB
Memory Used: 4.523 KB

SELECT title, template
FROM template
WHERE templateid IN (5420,5421,5422,5423,5394,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)

Time Before: 0.01775 seconds
Time After: 0.01948 seconds
Time Taken: 0.00173 seconds

Memory Before: 3,769.656 KB
Memory After: 3,773.492 KB
Memory Used: 3.836 KB

SELECT *
FROM bbcode

Time Before: 0.20831 seconds
Time After: 0.20883 seconds
Time Taken: 0.00052 seconds

Memory Before: 5,264.109 KB
Memory After: 5,268.078 KB
Memory Used: 3.969 KB

SELECT *, LENGTH(smilietext) AS smilielen
FROM smilie
ORDER BY smilielen DESC

Time Before: 0.20978 seconds
Time After: 0.21049 seconds
Time Taken: 0.00071 seconds

Memory Before: 5,282.586 KB
Memory After: 5,290.906 KB
Memory Used: 8.320 KB

SELECT userip
FROM cybvilxh_guests AS cybvilxh_guests
WHERE userip = '216.73.216.138'

Time Before: 0.30359 seconds
Time After: 0.31081 seconds
Time Taken: 0.00722 seconds

Memory Before: 5,423.156 KB
Memory After: 5,425.156 KB
Memory Used: 2.000 KB

UPDATE cybvilxh_guests
SET dateline = '1757088489'
WHERE userip = '216.73.216.138'

Time Before: 0.31088 seconds
Time After: 0.31799 seconds
Time Taken: 0.00711 seconds

Memory Before: 5,425.313 KB
Memory After: 5,425.680 KB
Memory Used: 0.367 KB

DELETE FROM cybvilxh_guests WHERE dateline < '1756829289'

Time Before: 0.31806 seconds
Time After: 0.31885 seconds
Time Taken: 0.00079 seconds

Memory Before: 5,422.992 KB
Memory After: 5,423.281 KB
Memory Used: 0.289 KB

SELECT profilefieldid
FROM profilefield
WHERE profilefieldid = 2

Time Before: 0.39321 seconds
Time After: 0.39377 seconds
Time Taken: 0.00056 seconds

Memory Before: 4,851.359 KB
Memory After: 4,853.414 KB
Memory Used: 2.055 KB

SELECT user.*,
	usergroup.usergroupid, usergroup.title,
	user.options, usertextfield.buddylist,
	userfield.field2,
	IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM user AS user
LEFT JOIN usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids))
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
WHERE (usergroup.genericoptions & 1)

Time Before: 0.39865 seconds
Time After: 0.44127 seconds
Time Taken: 0.04261 seconds

Memory Before: 4,900.148 KB
Memory After: 5,768.617 KB
Memory Used: 868.469 KB

SELECT user.*,
	moderator.forumid,
	usertextfield.buddylist,
	userfield.field2,
	IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
INNER JOIN userfield AS userfield ON(userfield.userid = user.userid)
INNER JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
WHERE moderator.forumid <> -1

Time Before: 1.00657 seconds
Time After: 1.00859 seconds
Time Taken: 0.00201 seconds

Memory Before: 5,603.703 KB
Memory After: 5,649.945 KB
Memory Used: 46.242 KB

UPDATE session
SET location = '/vb/showgroups.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 = 'f83a08a866d34b08ab36fed891c11f68'

Time Before: 1.02539 seconds
Time After: 1.02608 seconds
Time Taken: 0.00069 seconds

Memory Before: 8,268.148 KB
Memory After: 8,268.305 KB
Memory Used: 0.156 KB