Connecting to database
Time before: 0.00016403198242188
Memory Before: 253KB 
Time after: 0.00057101249694824
Time taken: 0.00040698051452637
Memory After: 262KB 


Query: SELECT title, data FROM datastore WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings', 'smiliecache', 'bbcodecache') Time before: 0.00061702728271484 Memory Before: 263KB Time after: 0.0014340877532959 Time taken: 0.00081706047058105 Memory After: 302KB
table type possible_keys key key_len ref rows Extra
datastore  range  PRIMARY  PRIMARY  17    Using index condition 


Parsing functions.php
Time before: 0.0031259059906006
Memory Before: 978KB 
Time after:  0.0032610893249512
Time taken: 0.00013518333435059
Memory After: 983KB 


Query: SELECT * FROM session WHERE userid = 0 AND host = '173.245.54.176' AND idhash = '63427e432f933117f699128b80c5eb2a' LIMIT 1 Time before: 0.0033359527587891 Memory Before: 993KB Time after: 0.043313980102539 Time taken: 0.03997802734375 Memory After: 998KB
table type possible_keys key key_len ref rows Extra
session  ALL          32004  Using where 


Query:

		SELECT languageid,
			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.043946981430054
Memory Before: 1,000KB 
Time after: 0.044832944869995
Time taken: 0.00088596343994141
Memory After: 1,005KB 
table type possible_keys key key_len ref rows Extra
language  system  PRIMARY         


Processing sessions.php
Time before: 0.003309965133667
Memory Before: 990KB 

End sessions.php processing
Time after:  0.045202016830444
Time taken: 0.041892051696777
Memory After: 1,033KB 


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 = 23414 Time before: 0.046025037765503 Memory Before: 1,145KB Time after: 0.046690940856934 Time taken: 0.00066590309143066 Memory After: 1,152KB
table type possible_keys key key_len ref rows Extra
thread  const  PRIMARY  PRIMARY  const   
deletionlog  const  PRIMARY  PRIMARY  const,const  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.04749608039856
Memory Before: 1,156KB 
Time after: 0.047792911529541
Time taken: 0.00029683113098145
Memory After: 1,160KB 
table type possible_keys key key_len ref rows Extra
style  const  PRIMARY  PRIMARY  const   


Query:

			SELECT title, template
			FROM template
			WHERE templateid IN (4724,4725,4528,4529,4530,1494,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.048427104949951
Memory Before: 1,269KB 
Time after: 0.049405097961426
Time taken: 0.00097799301147461
Memory After: 1,272KB 
table type possible_keys key key_len ref rows Extra
template  range  PRIMARY  PRIMARY    30  Using index condition 


End call of global.php:  0.050681114196777


Query: SELECT COUNT(*) AS total FROM post AS post LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post') WHERE threadid=23414 AND visible=1 AND deletionlog.primaryid IS NULL Time before: 0.051054000854492 Memory Before: 1,340KB Time after: 0.094510078430176 Time taken: 0.043456077575684 Memory After: 1,342KB
table type possible_keys key key_len ref rows Extra
post  ref  threadid  threadid  const  Using where 
deletionlog  eq_ref  PRIMARY  PRIMARY  cos_oldposts.post.postid,const  Using where; Not exists; Using index 


Query:

	SELECT post.*,post.username AS postusername,user.username
	FROM post AS post
	LEFT JOIN user AS user ON(user.userid = post.userid)
	LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
	WHERE post.threadid=23414 AND post.visible=1 AND deletionlog.primaryid IS NULL
	ORDER BY dateline 
	LIMIT 0, 30

Time before: 0.095412969589233
Memory Before: 1,344KB 
Time after: 0.12056708335876
Time taken: 0.025154113769531
Memory After: 1,350KB 
table type possible_keys key key_len ref rows Extra
post  ref  threadid  threadid  const  Using where; Using filesort 
user  eq_ref  PRIMARY  PRIMARY  cos_oldposts.post.userid   
deletionlog  eq_ref  PRIMARY  PRIMARY  cos_oldposts.post.postid,const  Using where; Not exists; Using index 


Page generated in 0.12839389 seconds with 8 queries,
spending 0.1126389503479 doing MySQL queries and 0.0157549396521 doing PHP things.


Shutdown Queries:

Query: INSERT INTO session (sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid ,inforum, inthread, incalendar, badlocation ) VALUES ('7046d66495a8f429d1949e64aac228ff', 0, '173.245.54.176', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '63427e432f933117f699128b80c5eb2a', 1615017586, '/cosarchive/printthread.php?t=23414&explain=1', 0, 0 ,98, 23414, 0,0 ) Time before: 0.12871789932251 Memory Before: 1,504KB Time after: 0.1289849281311 Time taken: 0.00026702880859375 Memory After: 1,504KB