Connecting to database
Time before: 0.00020599365234375
Memory Before: 256KB 
Time after: 0.00061798095703125
Time taken: 0.0004119873046875
Memory After: 264KB 


Query: SELECT title, data FROM datastore WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings', 'iconcache', 'mailqueue') Time before: 0.00067591667175293 Memory Before: 265KB Time after: 0.0015630722045898 Time taken: 0.00088715553283691 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.003000020980835
Memory Before: 921KB 
Time after:  0.0031709671020508
Time taken: 0.00017094612121582
Memory After: 925KB 


Query: SELECT * FROM session WHERE userid = 0 AND host = '172.68.65.219' AND idhash = '63427e432f933117f699128b80c5eb2a' LIMIT 1 Time before: 0.0032999515533447 Memory Before: 935KB Time after: 0.016360998153687 Time taken: 0.013061046600342 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.017030954360962
Memory Before: 942KB 
Time after: 0.017415046691895
Time taken: 0.00038409233093262
Memory After: 947KB 
table type possible_keys key key_len ref rows Extra
language  system  PRIMARY         


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

End sessions.php processing
Time after:  0.017817974090576
Time taken: 0.01456093788147
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.018598079681396 Memory Before: 1,089KB Time after: 0.018937110900879 Time taken: 0.00033903121948242 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.019498109817505
Memory Before: 1,206KB 
Time after: 0.020224094390869
Time taken: 0.00072598457336426
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.021250009536743


Query: SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount FROM forum AS forum Time before: 0.021379947662354 Memory Before: 1,301KB Time after: 0.021684885025024 Time taken: 0.0003049373626709 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.022293090820312
Memory Before: 1,433KB 
Time after: 0.022546052932739
Time taken: 0.00025296211242676
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 > 1614365922
		ORDER BY lastactivity DESC
	
Time before: 0.023170948028564
Memory Before: 1,466KB 
Time after: 0.043906927108765
Time taken: 0.0207359790802
Memory After: 1,474KB 
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   


Page generated in 0.04849696 seconds with 8 queries,
spending 0.037103176116943 doing MySQL queries and 0.011393783883057 doing PHP things.


Shutdown Queries:

Query: INSERT INTO session (sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid ,inforum, inthread, incalendar, badlocation ) VALUES ('b233f82e1d1c64526ea88eb144766ec2', 0, '172.68.65.219', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '63427e432f933117f699128b80c5eb2a', 1614367722, '/cosarchive/forumdisplay.php?f=1&explain=1', 0, 0 ,1, 0, 0,0 ) Time before: 0.049765110015869 Memory Before: 1,724KB Time after: 0.05004096031189 Time taken: 0.00027585029602051 Memory After: 1,724KB