Connecting to database
Time before: 0.00020599365234375
Memory Before: 259KB 
Time after: 0.00060892105102539
Time taken: 0.00040292739868164
Memory After: 268KB 



Query:

				SELECT title, data
				FROM datastore
				WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings', 'rankphp', 'smiliecache', 'bbcodecache', 'mailqueue', 'hidprofilecache')
			
Time before: 0.0006709098815918
Memory Before: 269KB 
Time after: 0.0016040802001953
Time taken: 0.00093317031860352
Memory After: 308KB

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

Parsing functions.php
Time before: 0.0028769969940186
Memory Before: 985KB 
Time after:  0.0030050277709961
Time taken: 0.00012803077697754
Memory After: 990KB 



Query:

		SELECT *
		FROM session
		WHERE userid = 0
		AND host = '108.162.219.219'
		AND idhash = '8353da068bf91378729cc13b8d1fa2ff'
		LIMIT 1
	
Time before: 0.0030820369720459
Memory Before: 1,000KB 
Time after: 0.022102117538452
Time taken: 0.019020080566406
Memory After: 1,004KB

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

Query:

		SELECT languageid,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_postbit AS phrasegroup_postbit,
			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.022595882415771
Memory Before: 1,007KB 
Time after: 0.023080110549927
Time taken: 0.00048422813415527
Memory After: 1,013KB

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

Processing sessions.php
Time before: 0.0030510425567627
Memory Before: 997KB 

End sessions.php processing
Time after:  0.023466110229492
Time taken: 0.020415067672729
Memory After: 1,049KB 



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 = 23411
		
Time before: 0.0242600440979
Memory Before: 1,180KB 
Time after: 0.024611949920654
Time taken: 0.00035190582275391
Memory After: 1,186KB

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.024877071380615
Memory Before: 1,190KB 
Time after: 0.025154113769531
Time taken: 0.00027704238891602
Memory After: 1,194KB

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 (4589,4804,4615,4616,4618,4623,1517,4711,4712,4714,4713,4715,0,4716,4717,4718,4720,4721,4528,4529,4530,1494,1521,4742,4745,4746,2996,2995,4704,4703,4705,4709,4707,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.025670051574707
Memory Before: 1,308KB 
Time after: 0.026794910430908
Time taken: 0.0011248588562012
Memory After: 1,311KB

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

End call of global.php:  0.027822017669678



Query:

			SELECT threadid
			FROM thread AS thread
			LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
			WHERE forumid = 98 AND lastpost < 1076614615 AND visible = 1 AND open <> 10
			AND deletionlog.primaryid IS NULL
			ORDER BY lastpost DESC
			LIMIT 1
		
Time before: 0.027987003326416
Memory Before: 1,441KB 
Time after: 0.028645992279053
Time taken: 0.00065898895263672
Memory After: 1,442KB

table	type	possible_keys	key	key_len	ref	rows	Extra
thread	ref	forumid	forumid	4	const,const	83	Using index condition; Using where; Using filesort
deletionlog	eq_ref	PRIMARY	PRIMARY	5	cos_oldposts.thread.threadid,const	1	Using where; Not exists; Using index

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 = 23387
		
Time before: 0.029366016387939
Memory Before: 1,444KB 
Time after: 0.029628038406372
Time taken: 0.00026202201843262
Memory After: 1,451KB

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 forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
			FROM forum AS forum
			
Time before: 0.029951095581055
Memory Before: 1,454KB 
Time after: 0.030251979827881
Time taken: 0.00030088424682617
Memory After: 1,462KB

table	type	possible_keys	key	key_len	ref	rows	Extra
forum	ALL					67

Query:

			SELECT postid FROM post AS post
			LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
			WHERE threadid = 23387 AND visible = 1 AND deletionlog.primaryid IS NULL
			ORDER BY dateline 
			LIMIT 0, 30
		
Time before: 0.030930995941162
Memory Before: 1,590KB 
Time after: 0.031338930130005
Time taken: 0.00040793418884277
Memory After: 1,591KB

table	type	possible_keys	key	key_len	ref	rows	Extra
post	ref	threadid	threadid	4	const	1	Using where; Using filesort
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, post.ipaddress AS ip,
			user.*, userfield.*, usertextfield.*,
			icon.title as icontitle, icon.iconpath,
			avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
			
			
			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
			editlog.reason AS edit_reason,
			post_parsed.pagetext_html, post_parsed.hasimages,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
			, '' AS field15, '' AS field18, '' AS field19, '' AS field20, '' AS field21
		FROM post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		
		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
		WHERE post.postid IN (0,787502)
		ORDER BY dateline 
	
Time before: 0.031722068786621
Memory Before: 1,591KB 
Time after: 0.061328887939453
Time taken: 0.029606819152832
Memory After: 1,617KB

table	type	possible_keys	key	key_len	ref	rows	Extra
icon	system	PRIMARY				0	const row not found
avatar	system	PRIMARY				0	const row not found
post_parsed	system	PRIMARY				0	const row not found
post	range	PRIMARY	PRIMARY	4		2	Using index condition; Using filesort
user	eq_ref	PRIMARY	PRIMARY	4	cos_oldposts.post.userid	1
userfield	eq_ref	PRIMARY	PRIMARY	4	cos_oldposts.user.userid	1
usertextfield	eq_ref	PRIMARY	PRIMARY	4	cos_oldposts.user.userid	1
customavatar	eq_ref	PRIMARY	PRIMARY	4	cos_oldposts.user.userid	1
editlog	eq_ref	PRIMARY	PRIMARY	4	cos_oldposts.post.postid	1

Time after parsing all posts:  0.071615934371948
Memory After: 1,703KB 



Query:

		SELECT user.username, user.usergroupid, user.membergroupids,
			session.userid, session.inthread, session.lastactivity,
			IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid,
			IF(user.options & 512, 1, 0) AS invisible
		FROM session AS session
		LEFT JOIN user AS user ON(user.userid = session.userid)
		WHERE session.lastactivity > 1618497837
		ORDER BY  lastactivity DESC
	
Time before: 0.07165002822876
Memory Before: 1,705KB 
Time after: 0.087433099746704
Time taken: 0.015783071517944
Memory After: 1,708KB

table	type	possible_keys	key	key_len	ref	rows	Extra
session	ALL					32004	Using where; Using filesort
user	eq_ref	PRIMARY	PRIMARY	4	cos_oldposts.session.userid	1

Page generated in 0.08941507 seconds with 12 queries,
spending 0.069613933563232 doing MySQL queries and 0.019801136436768 doing PHP things.

Shutdown Queries:

Query:

		INSERT INTO session
			(sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid
			,inforum, inthread, incalendar, badlocation
			)
		VALUES
			('afdfc43ba36fa51fcd56114b226b8c81', 0,
			'108.162.219.219', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '8353da068bf91378729cc13b8d1fa2ff',
			1618499637, '/cosarchive/showthread.php?t=23411&goto=nextoldest&explain=1', 0, 0
			,98, 23387, 0,0
			)
	
Time before: 0.089802980422974
Memory Before: 1,972KB 
Time after: 0.090142011642456
Time taken: 0.00033903121948242
Memory After: 1,972KB 



Query:

		INSERT INTO threadviews (threadid)
		VALUES (23387)
Time before: 0.090187072753906
Memory Before: 1,971KB 
Time after: 0.11491107940674
Time taken: 0.024724006652832
Memory After: 1,972KB