Time Before: 0.07378 seconds
Time After: 0.18831 seconds
Time Taken: 0.11453 seconds

Memory Before: 2,758.633 KB
Memory After: 5,117.648 KB
Memory Used: 2,359.016 KB

Time Before: 0.18896 seconds
Time After: 0.19165 seconds
Time Taken: 0.00269 seconds

Memory Before: 5,119.094 KB
Memory After: 5,121.648 KB
Memory Used: 2.555 KB

SET @@sql_mode = ''

Time Before: 0.19268 seconds
Time After: 0.19314 seconds
Time Taken: 0.00046 seconds

Memory Before: 5,119.789 KB
Memory After: 5,120.969 KB
Memory Used: 1.180 KB

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

Time Before: 0.19348 seconds
Time After: 0.21726 seconds
Time Taken: 0.02378 seconds

Memory Before: 5,118.914 KB
Memory After: 5,828.969 KB
Memory Used: 710.055 KB

SELECT *
FROM session
WHERE userid = 0
	AND host = '3.235.188.113'
	AND idhash = '200bab90a670a25b51afdf335110ce19'
LIMIT 1

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroup_socialgroups AS phrasegroup_socialgroups,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroup_user AS phrasegroup_user,
			phrasegroupinfo AS lang_phrasegroupinfo,
			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.24480 seconds
Time After: 0.25684 seconds
Time Taken: 0.01204 seconds

Memory Before: 6,619.852 KB
Memory After: 6,760.547 KB
Memory Used: 140.695 KB

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

Time Before: 0.32231 seconds
Time After: 0.32654 seconds
Time Taken: 0.00423 seconds

Memory Before: 7,432.180 KB
Memory After: 7,433.156 KB
Memory Used: 0.977 KB

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vb_types.types'

Time Before: 0.60156 seconds
Time After: 0.60233 seconds
Time Taken: 0.00077 seconds

Memory Before: 12,236.773 KB
Memory After: 12,237.781 KB
Memory Used: 1.008 KB

SELECT thread.threadid
FROM thread AS thread

WHERE thread.forumid IN(52, 1, 2, 3, 4, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 5, 6, 8, 37, 26, 9, 27, 22, 23, 24, 25, 28, 29, 30, 31, 32, 36, 38, 39, 40, 41, 42, 43, 44, 45, 49, 50, 51, 46, 47, 48, 33, 34, 35)
	AND thread.lastpost >= 1696183114
	AND thread.open <> 10
ORDER BY thread.lastpost desc
LIMIT 500

Time Before: 0.73592 seconds
Time After: 0.73697 seconds
Time Taken: 0.00105 seconds

Memory Before: 13,491.539 KB
Memory After: 13,492.258 KB
Memory Used: 0.719 KB

REPLACE INTO searchlog
	(userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,criteria,results)
VALUES
	(0,'3.235.188.113','8694b6ab7d55372c11c1d39cc23e5dd4','groupdateline','desc',0,1696269514,0,'O:18:\"vB_Search_Criteria\":15:{s:28:\"\0vB_Search_Criteria\0keywords\";a:0:{}s:32:\"\0vB_Search_Criteria\0raw_keywords\";s:0:\"\";s:29:\"\0vB_Search_Criteria\0titleonly\";b:0;s:27:\"\0vB_Search_Criteria\0filters\";a:2:{s:11:\"contenttype\";a:1:{s:2:\"eq\";a:1:{i:0;i:1;}}s:7:\"datecut\";a:1:{s:2:\"gt\";i:1696183114;}}s:24:\"\0vB_Search_Criteria\0sort\";a:2:{i:0;s:13:\"groupdateline\";i:1;s:4:\"desc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i:1;s:31:\"\0vB_Search_Criteria\0searchterms\";a:4:{s:10:\"searchdate\";i:1;s:13:\"contenttypeid\";s:1:\"1\";s:11:\"search_type\";i:1;s:9:\"showposts\";i:0;}s:32:\"\0vB_Search_Criteria\0criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";b:0;s:35:\"\0vB_Search_Criteria\0display_strings\";a:2:{s:4:\"type\";s:14:\"Тип: Сообщения\";s:7:\"newitem\";s:21:\"Сегодняшние сообщения\";}s:32:\"\0vB_Search_Criteria\0common_words\";a:0:{}s:30:\"\0vB_Search_Criteria\0highlights\";a:0:{}s:33:\"\0vB_Search_Criteria\0search_string\";N;s:26:\"\0vB_Search_Criteria\0errors\";a:0:{}s:11:\"search_type\";s:3:\"new\";}','')

Time Before: 0.74119 seconds
Time After: 0.74217 seconds
Time Taken: 0.00098 seconds

Memory Before: 13,488.063 KB
Memory After: 13,487.766 KB
Memory Used: -0.297 KB

UPDATE searchlog
SET results = 'a:4:{i:0;a:1:{i:0;a:3:{i:0;s:1:\"2\";i:1;s:3:\"313\";i:2;s:3:\"313\";}}i:1;i:-1;i:2;N;i:3;N;}'
WHERE searchlogid = 378684

Time Before: 0.74290 seconds
Time After: 0.74347 seconds
Time Taken: 0.00057 seconds

Memory Before: 13,482.109 KB
Memory After: 13,482.938 KB
Memory Used: 0.828 KB

UPDATE searchlog
SET searchtime = 0.05849,
	completed = 1
WHERE searchlogid = 378684

Time Before: 0.74410 seconds
Time After: 0.74478 seconds
Time Taken: 0.00068 seconds

Memory Before: 13,481.695 KB
Memory After: 13,482.586 KB
Memory Used: 0.891 KB

SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)

Time Before: 0.75333 seconds
Time After: 0.75401 seconds
Time Taken: 0.00068 seconds

Memory Before: 13,549.758 KB
Memory After: 13,550.641 KB
Memory Used: 0.883 KB

SELECT thread.*,post.pagetext AS preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision,
			customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height,
			customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb,
			first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath,
			NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline,
			first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb
			AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS
			first_filedata_thumb,lastpost.lastposttime
FROM thread AS thread
	LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN user AS first_user ON (first_user.userid = thread.postuserid)
LEFT JOIN avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid)
LEFT JOIN customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid)
LEFT JOIN (
	SELECT threadid, MAX(dateline) AS lastposttime
	FROM post
	WHERE threadid IN (313)
		AND userid = 0
	GROUP BY threadid
) AS lastpost ON (lastpost.threadid = thread.threadid)
WHERE thread.threadid IN (313)

Time Before: 0.76139 seconds
Time After: 0.76344 seconds
Time Taken: 0.00205 seconds

Memory Before: 13,578.516 KB
Memory After: 13,577.984 KB
Memory Used: -0.531 KB

UPDATE searchlog
SET results = 'a:4:{i:0;a:1:{i:0;a:3:{i:0;s:1:\"2\";i:1;s:3:\"313\";i:2;s:3:\"313\";}}i:1;i:0;i:2;a:1:{i:2;a:1:{i:0;s:3:\"313\";}}i:3;a:1:{i:2;a:0:{}}}'
WHERE searchlogid = 378684

Time Before: 0.76580 seconds
Time After: 0.76641 seconds
Time Taken: 0.00061 seconds

Memory Before: 13,584.484 KB
Memory After: 13,585.266 KB
Memory Used: 0.781 KB

SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'frontredirect'
	AND varname = 'search' AND languageid IN (-1, 0, 2)

Time Before: 0.76944 seconds
Time After: 0.77015 seconds
Time Taken: 0.00071 seconds

Memory Before: 13,584.148 KB
Memory After: 13,585.055 KB
Memory Used: 0.906 KB