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    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         


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  const   


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    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  cos_oldposts.moderator.userid   


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  cos_oldposts.session.userid   


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  cos_oldposts.announcement.userid   


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  const,const,const   
deletionlog  eq_ref  PRIMARY  PRIMARY  cos_oldposts.thread.threadid,const  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  const,const,const   
deletionlog  eq_ref  PRIMARY  PRIMARY  cos_oldposts.thread.threadid,const  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  const,const,const  Using where 
deletionlog  eq_ref  PRIMARY  PRIMARY  cos_oldposts.thread.threadid,const  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    Using index condition; Using filesort 
post  eq_ref  PRIMARY  PRIMARY  cos_oldposts.thread.firstpostid   


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