Connecting to database
Time before: 0.00018000602722168
Memory Before: 254KB 
Time after: 0.00051093101501465
Time taken: 0.00033092498779297
Memory After: 262KB 



Query:

				SELECT title, data
				FROM datastore
				WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings', 'smiliecache', 'bbcodecache')
			
Time before: 0.00057005882263184
Memory Before: 264KB 
Time after: 0.0014169216156006
Time taken: 0.00084686279296875
Memory After: 302KB

table	type	possible_keys	key	key_len	ref	rows	Extra
datastore	range	PRIMARY	PRIMARY	17		8	Using index condition

Parsing functions.php
Time before: 0.0027289390563965
Memory Before: 979KB 
Time after:  0.0028460025787354
Time taken: 0.00011706352233887
Memory After: 984KB 



Query:

		SELECT *
		FROM session
		WHERE userid = 0
		AND host = '141.101.102.7'
		AND idhash = '58091fd649f72e3837f7b561c5969ce6'
		LIMIT 1
	
Time before: 0.0029189586639404
Memory Before: 994KB 
Time after: 0.023539066314697
Time taken: 0.020620107650757
Memory After: 998KB

table	type	possible_keys	key	key_len	ref	rows	Extra
session	ALL					32004	Using where

Query:

		SELECT languageid,
			phrasegroup_showthread AS phrasegroup_showthread,
			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 = 1
	
Time before: 0.023983955383301
Memory Before: 1,001KB 
Time after: 0.024490118026733
Time taken: 0.00050616264343262
Memory After: 1,006KB

table	type	possible_keys	key	key_len	ref	rows	Extra
language	system	PRIMARY				1

Processing sessions.php
Time before: 0.0028929710388184
Memory Before: 991KB 

End sessions.php processing
Time after:  0.024882078170776
Time taken: 0.021989107131958
Memory After: 1,034KB 



Query:

			SELECT NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
			deletionlog.username AS del_username, deletionlog.reason AS del_reason,
			
			thread.*
			FROM thread AS thread
			LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
			
			
			WHERE thread.threadid = 23414
		
Time before: 0.025588989257812
Memory Before: 1,145KB 
Time after: 0.02595591545105
Time taken: 0.0003669261932373
Memory After: 1,152KB

table	type	possible_keys	key	key_len	ref	rows	Extra
thread	const	PRIMARY	PRIMARY	4	const	1
deletionlog	const	PRIMARY	PRIMARY	5	const,const	0	unique row not found

Query:

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

Time before: 0.026240110397339
Memory Before: 1,156KB 
Time after: 0.026437044143677
Time taken: 0.00019693374633789
Memory After: 1,160KB

table	type	possible_keys	key	key_len	ref	rows	Extra
style	const	PRIMARY	PRIMARY	2	const	1

Query:

			SELECT title, template
			FROM template
			WHERE templateid IN (4724,4725,4528,4529,4530,1494,3093,2998,4041,3085,4685,4696,1515,4664,4803,4806,4813,4682,4683,4684,4774,4818,4817,4824,4823,4822,4819,4821,2177,2176)
		
Time before: 0.026884078979492
Memory Before: 1,270KB 
Time after: 0.027549982070923
Time taken: 0.00066590309143066
Memory After: 1,272KB

table	type	possible_keys	key	key_len	ref	rows	Extra
template	range	PRIMARY	PRIMARY	4		30	Using index condition

End call of global.php:  0.028693914413452



Query:

	SELECT COUNT(*) AS total
	FROM post AS post
	LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
	WHERE threadid=23414 AND visible=1 AND deletionlog.primaryid IS NULL

Time before: 0.028899908065796
Memory Before: 1,341KB 
Time after: 0.055774927139282
Time taken: 0.026875019073486
Memory After: 1,343KB

table	type	possible_keys	key	key_len	ref	rows	Extra
post	ref	threadid	threadid	4	const	1	Using where
deletionlog	eq_ref	PRIMARY	PRIMARY	5	cos_oldposts.post.postid,const	1	Using where; Not exists; Using index

Query:

	SELECT post.*,post.username AS postusername,user.username
	FROM post AS post
	LEFT JOIN user AS user ON(user.userid = post.userid)
	LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
	WHERE post.threadid=23414 AND post.visible=1 AND deletionlog.primaryid IS NULL
	ORDER BY dateline 
	LIMIT 0, 30

Time before: 0.056809902191162
Memory Before: 1,345KB 
Time after: 0.08720588684082
Time taken: 0.030395984649658
Memory After: 1,350KB

table	type	possible_keys	key	key_len	ref	rows	Extra
post	ref	threadid	threadid	4	const	1	Using where; Using filesort
user	eq_ref	PRIMARY	PRIMARY	4	cos_oldposts.post.userid	1
deletionlog	eq_ref	PRIMARY	PRIMARY	5	cos_oldposts.post.postid,const	1	Using where; Not exists; Using index

Page generated in 0.09807897 seconds with 8 queries,
spending 0.080804824829102 doing MySQL queries and 0.017274145170898 doing PHP things.

Shutdown Queries:

Query:

		INSERT INTO session
			(sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid
			,inforum, inthread, incalendar, badlocation
			)
		VALUES
			('93ee6a4ff108f0a5190e29048d572169', 0,
			'141.101.102.7', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '58091fd649f72e3837f7b561c5969ce6',
			1618242338, '/cosarchive/printthread.php?t=23414&tempusage=1&explain=1', 0, 0
			,98, 23414, 0,0
			)
	
Time before: 0.098959922790527
Memory Before: 1,504KB 
Time after: 0.11080598831177
Time taken: 0.01184606552124
Memory After: 1,504KB