Connecting to database
Time before: 0.00043606758117676
Memory Before: 258KB 
Time after: 0.00087308883666992
Time taken: 0.00043702125549316
Memory After: 267KB 


Query: SELECT title, data FROM datastore WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings', 'iconcache', 'mailqueue') Time before: 0.0009310245513916 Memory Before: 268KB Time after: 0.0020079612731934 Time taken: 0.0010769367218018 Memory After: 303KB
table type possible_keys key key_len ref rows Extra
datastore  range  PRIMARY  PRIMARY  17    Using index condition 


Parsing functions.php
Time before: 0.0036799907684326
Memory Before: 923KB 
Time after:  0.0040030479431152
Time taken: 0.00032305717468262
Memory After: 928KB 


Query: SELECT * FROM session WHERE userid = 0 AND host = '172.70.34.175' AND idhash = '016ec0366955b93fbae447e4b59fe30f' LIMIT 1 Time before: 0.0041220188140869 Memory Before: 938KB Time after: 0.025176048278809 Time taken: 0.021054029464722 Memory After: 942KB
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.025765895843506
Memory Before: 944KB 
Time after: 0.026263952255249
Time taken: 0.00049805641174316
Memory After: 950KB 
table type possible_keys key key_len ref rows Extra
language  system  PRIMARY         


Processing sessions.php
Time before: 0.0040719509124756
Memory Before: 935KB 

End sessions.php processing
Time after:  0.026839017868042
Time taken: 0.022767066955566
Memory After: 978KB 


Query: SELECT * FROM style WHERE (styleid = 10 AND userselect = 1) OR styleid = 10 ORDER BY styleid ASC LIMIT 1 Time before: 0.027854919433594 Memory Before: 1,091KB Time after: 0.028271913528442 Time taken: 0.00041699409484863 Memory After: 1,095KB
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.029114961624146
Memory Before: 1,208KB 
Time after: 0.029980897903442
Time taken: 0.00086593627929688
Memory After: 1,211KB 
table type possible_keys key key_len ref rows Extra
template  range  PRIMARY  PRIMARY    42  Using index condition 


End call of global.php:  0.031138896942139


Query: SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount FROM forum AS forum Time before: 0.0313720703125 Memory Before: 1,303KB Time after: 0.031716108322144 Time taken: 0.00034403800964355 Memory After: 1,311KB
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.032558917999268
Memory Before: 1,435KB 
Time after: 0.032917022705078
Time taken: 0.00035810470581055
Memory After: 1,439KB 
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 > 1618753522
		ORDER BY lastactivity DESC
	
Time before: 0.033610105514526
Memory Before: 1,468KB 
Time after: 0.053880929946899
Time taken: 0.020270824432373
Memory After: 1,472KB 
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 <= 1618784122
			AND enddate >= 1618784122
			AND forumid IN (95,1,-1)
		ORDER BY startdate DESC
		LIMIT 1
Time before: 0.056463956832886
Memory Before: 1,519KB 
Time after: 0.056926012039185
Time taken: 0.00046205520629883
Memory After: 1,522KB 
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>=1618755322 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.057302951812744
Memory Before: 1,526KB 
Time after: 0.057596921920776
Time taken: 0.00029397010803223
Memory After: 1,527KB 
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.057887077331543
Memory Before: 1,527KB 
Time after: 0.058109998703003
Time taken: 0.00022292137145996
Memory After: 1,528KB 
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, replycount DESC
		LIMIT 0, 50
	
Time before: 0.058413982391357
Memory Before: 1,527KB 
Time after: 0.058648109436035
Time taken: 0.00023412704467773
Memory After: 1,529KB 
table type possible_keys key key_len ref rows Extra
thread  ref  forumid  forumid  const,const,const  Using where; Using filesort 
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, replycount DESC
	
Time before: 0.058974027633667
Memory Before: 1,528KB 
Time after: 0.059237957000732
Time taken: 0.00026392936706543
Memory After: 1,534KB 
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.06108308 seconds with 13 queries,
spending 0.046798944473267 doing MySQL queries and 0.014284135526733 doing PHP things.


Shutdown Queries:

Query: INSERT INTO session (sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid ,inforum, inthread, incalendar, badlocation ) VALUES ('0c05458d0c80aae50b06f52be01ded52', 0, '172.70.34.175', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '016ec0366955b93fbae447e4b59fe30f', 1618755322, '/cosarchive/forumdisplay.php?f=95&daysprune=-1&order=desc&sort=replycount&explain=1', 0, 0 ,95, 0, 0,0 ) Time before: 0.061614036560059 Memory Before: 1,744KB Time after: 0.062401056289673 Time taken: 0.00078701972961426 Memory After: 1,744KB