Connecting to database
Time before: 0.00018501281738281
Memory Before: 256KB 
Time after: 0.00055503845214844
Time taken: 0.00037002563476562
Memory After: 264KB 



Query:

				SELECT title, data
				FROM datastore
				WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings', 'iconcache', 'mailqueue')
			
Time before: 0.00060510635375977
Memory Before: 265KB 
Time after: 0.0013830661773682
Time taken: 0.0007779598236084
Memory After: 300KB

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.0032050609588623
Memory Before: 921KB 
Time after:  0.0033090114593506
Time taken: 0.00010395050048828
Memory After: 925KB 



Query:

		SELECT *
		FROM session
		WHERE userid = 0
		AND host = '162.158.79.152'
		AND idhash = 'f8b36a7088f11fd097b1f1ab14e9b8d1'
		LIMIT 1
	
Time before: 0.0033800601959229
Memory Before: 935KB 
Time after: 0.022532939910889
Time taken: 0.019152879714966
Memory After: 940KB

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

Query:

		SELECT languageid,
			phrasegroup_forumdisplay AS phrasegroup_forumdisplay,
			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.023049116134644
Memory Before: 942KB 
Time after: 0.023442983627319
Time taken: 0.00039386749267578
Memory After: 947KB

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

Processing sessions.php
Time before: 0.0033559799194336
Memory Before: 933KB 

End sessions.php processing
Time after:  0.023879051208496
Time taken: 0.020523071289062
Memory After: 975KB 



Query:

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

Time before: 0.024571895599365
Memory Before: 1,089KB 
Time after: 0.024908065795898
Time taken: 0.0003361701965332
Memory After: 1,092KB

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 (1498,3130,4773,2993,1505,4595,1503,1502,4596,4601,4603,4589,4600,4590,4591,4602,4604,4804,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.025499105453491
Memory Before: 1,206KB 
Time after: 0.026237964630127
Time taken: 0.00073885917663574
Memory After: 1,209KB

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

End call of global.php:  0.027326107025146



Query:

			SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
			FROM forum AS forum
			
Time before: 0.027499914169312
Memory Before: 1,301KB 
Time after: 0.027801036834717
Time taken: 0.00030112266540527
Memory After: 1,308KB

table	type	possible_keys	key	key_len	ref	rows	Extra
forum	ALL					67

Query:

		SELECT moderator.*, user.username,
		IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
		FROM moderator AS moderator
		INNER JOIN user AS user USING(userid)
	
Time before: 0.028518915176392
Memory Before: 1,433KB 
Time after: 0.028840065002441
Time taken: 0.0003211498260498
Memory After: 1,436KB

table	type	possible_keys	key	key_len	ref	rows	Extra
moderator	ALL	userid				10
user	eq_ref	PRIMARY	PRIMARY	4	cos_oldposts.moderator.userid	1

Query:

		SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, session.inforum, session.lastactivity,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
		FROM session AS session
		LEFT JOIN user AS user ON(user.userid = session.userid)
		WHERE session.lastactivity > 1615260160
		ORDER BY lastactivity DESC
	
Time before: 0.029503107070923
Memory Before: 1,465KB 
Time after: 0.048017024993896
Time taken: 0.018513917922974
Memory After: 1,473KB

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

Query:

		SELECT
			announcementid, startdate, title, announcement.views,
			user.username, user.userid, user.usertitle, user.customtitle
		FROM announcement AS announcement
		LEFT JOIN user AS user ON(user.userid = announcement.userid)
		WHERE startdate <= 1615294360
			AND enddate >= 1615294360
			AND forumid IN (95,1,-1)
		ORDER BY startdate DESC
		LIMIT 1
Time before: 0.050262928009033
Memory Before: 1,516KB 
Time after: 0.050776958465576
Time taken: 0.00051403045654297
Memory After: 1,519KB

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

Query:

		SELECT COUNT(*) AS threads,
		SUM(IF(lastpost>=1615261960 AND open<>10,1,0)) AS newthread
		FROM thread AS thread
		LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
		WHERE forumid = 95
			AND sticky = 0
			AND visible = 1
			
			
			
			AND deletionlog.primaryid IS NULL
	
Time before: 0.051064014434814
Memory Before: 1,523KB 
Time after: 0.051296949386597
Time taken: 0.00023293495178223
Memory After: 1,525KB

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

Query:

			SELECT threadid
			FROM thread AS thread
			LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
			WHERE forumid = 95
				AND visible = 1
				AND sticky = 1
				
				
				AND deletionlog.primaryid IS NULL
		
Time before: 0.051567077636719
Memory Before: 1,524KB 
Time after: 0.051793098449707
Time taken: 0.00022602081298828
Memory After: 1,525KB

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

Query:

		SELECT  threadid
		FROM thread AS thread
		LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
		WHERE forumid = 95
			AND sticky = 0
			AND visible = 1
			
			
			
			AND deletionlog.primaryid IS NULL
		ORDER BY sticky DESC, lastpost DESC
		LIMIT 0, 50
	
Time before: 0.052063941955566
Memory Before: 1,525KB 
Time after: 0.05231499671936
Time taken: 0.00025105476379395
Memory After: 1,526KB

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

Query:

		SELECT 
			IF(votenum >= 2, votenum, 0) AS votenum,
			IF(votenum >= 2 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
		 post.pagetext AS preview,
			thread.threadid, thread.title AS threadtitle, lastpost, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
			lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach
			
			
		FROM thread AS thread
		
		
		LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
		WHERE thread.threadid IN (0,23853)
		ORDER BY sticky DESC, lastpost DESC
	
Time before: 0.052581071853638
Memory Before: 1,525KB 
Time after: 0.052926063537598
Time taken: 0.00034499168395996
Memory After: 1,531KB

table	type	possible_keys	key	key_len	ref	rows	Extra
thread	range	PRIMARY	PRIMARY	4		2	Using index condition; Using filesort
post	eq_ref	PRIMARY	PRIMARY	4	cos_oldposts.thread.firstpostid	1

Page generated in 0.05451012 seconds with 13 queries,
spending 0.042474985122681 doing MySQL queries and 0.012035134877319 doing PHP things.

Shutdown Queries:

Query:

		INSERT INTO session
			(sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid
			,inforum, inthread, incalendar, badlocation
			)
		VALUES
			('be14b71e3b00ba8bd66d5594d0e88d08', 0,
			'162.158.79.152', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'f8b36a7088f11fd097b1f1ab14e9b8d1',
			1615261960, '/cosarchive/forumdisplay.php?f=95&explain=1', 0, 0
			,95, 0, 0,0
			)
	
Time before: 0.055272102355957
Memory Before: 1,740KB 
Time after: 0.055474996566772
Time taken: 0.00020289421081543
Memory After: 1,740KB