Connecting to database
Time before: 0.00018000602722168
Memory Before: 259KB 
Time after: 0.00052595138549805
Time taken: 0.00034594535827637
Memory After: 268KB 


Query: SELECT title, data FROM datastore WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings', 'rankphp', 'smiliecache', 'bbcodecache', 'mailqueue', 'hidprofilecache') Time before: 0.00057601928710938 Memory Before: 269KB Time after: 0.0013799667358398 Time taken: 0.00080394744873047 Memory After: 308KB
table type possible_keys key key_len ref rows Extra
datastore  range  PRIMARY  PRIMARY  17    11  Using index condition 


Parsing functions.php
Time before: 0.0026609897613525
Memory Before: 985KB 
Time after:  0.0027689933776855
Time taken: 0.00010800361633301
Memory After: 990KB 


Query: SELECT * FROM session WHERE userid = 0 AND host = '172.68.65.161' AND idhash = 'f8b36a7088f11fd097b1f1ab14e9b8d1' LIMIT 1 Time before: 0.0028409957885742 Memory Before: 1,000KB Time after: 0.022300958633423 Time taken: 0.019459962844849 Memory After: 1,004KB
table type possible_keys key key_len ref rows Extra
session  ALL          32004  Using where 


Query:

		SELECT languageid,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_postbit AS phrasegroup_postbit,
			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.02271294593811
Memory Before: 1,007KB 
Time after: 0.023138999938965
Time taken: 0.00042605400085449
Memory After: 1,013KB 
table type possible_keys key key_len ref rows Extra
language  system  PRIMARY         


Processing sessions.php
Time before: 0.0028159618377686
Memory Before: 997KB 

End sessions.php processing
Time after:  0.023480892181396
Time taken: 0.020664930343628
Memory After: 1,049KB 


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.024391889572144 Memory Before: 1,180KB Time after: 0.024712085723877 Time taken: 0.0003201961517334 Memory After: 1,186KB
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.024960041046143
Memory Before: 1,190KB 
Time after: 0.02520489692688
Time taken: 0.0002448558807373
Memory After: 1,194KB 
table type possible_keys key key_len ref rows Extra
style  const  PRIMARY  PRIMARY  const   


Query:

			SELECT title, template
			FROM template
			WHERE templateid IN (4589,4804,4615,4616,4618,4623,1517,4711,4712,4714,4713,4715,0,4716,4717,4718,4720,4721,4528,4529,4530,1494,1521,4742,4745,4746,2996,2995,4704,4703,4705,4709,4707,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.025634050369263
Memory Before: 1,308KB 
Time after: 0.026464939117432
Time taken: 0.00083088874816895
Memory After: 1,311KB 
table type possible_keys key key_len ref rows Extra
template  range  PRIMARY  PRIMARY    57  Using index condition 


End call of global.php:  0.027442932128906


Query: SELECT threadid FROM thread AS thread LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread') WHERE forumid = 98 AND lastpost > 1076617128 AND visible = 1 AND open <> 10 AND deletionlog.primaryid IS NULL ORDER BY lastpost LIMIT 1 Time before: 0.027633905410767 Memory Before: 1,441KB Time after: 0.028060913085938 Time taken: 0.0004270076751709 Memory After: 1,442KB
table type possible_keys key key_len ref rows Extra
thread  ref  forumid  forumid  const,const  83  Using index condition; Using where; Using filesort 
deletionlog  eq_ref  PRIMARY  PRIMARY  cos_oldposts.thread.threadid,const  Using where; Not exists; Using index 


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 = 23423
		
Time before: 0.028810024261475
Memory Before: 1,444KB 
Time after: 0.029212951660156
Time taken: 0.00040292739868164
Memory After: 1,451KB 
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 forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
			FROM forum AS forum
			
Time before: 0.029573917388916
Memory Before: 1,454KB 
Time after: 0.029843091964722
Time taken: 0.00026917457580566
Memory After: 1,462KB 
table type possible_keys key key_len ref rows Extra
forum  ALL          67   


Query:

			SELECT postid FROM post AS post
			LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
			WHERE threadid = 23423 AND visible = 1 AND deletionlog.primaryid IS NULL
			ORDER BY dateline 
			LIMIT 0, 30
		
Time before: 0.030601978302002
Memory Before: 1,589KB 
Time after: 0.080621004104614
Time taken: 0.050019025802612
Memory After: 1,591KB 
table type possible_keys key key_len ref rows Extra
post  ref  threadid  threadid  const  Using where; Using filesort 
deletionlog  eq_ref  PRIMARY  PRIMARY  cos_oldposts.post.postid,const  Using where; Not exists; Using index 


Query:

		SELECT
			post.*, post.username AS postusername, post.ipaddress AS ip,
			user.*, userfield.*, usertextfield.*,
			icon.title as icontitle, icon.iconpath,
			avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
			
			
			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
			editlog.reason AS edit_reason,
			post_parsed.pagetext_html, post_parsed.hasimages,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
			, '' AS field15, '' AS field18, '' AS field19, '' AS field20, '' AS field21
		FROM post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		
		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
		WHERE post.postid IN (0,789286)
		ORDER BY dateline 
	
Time before: 0.081160068511963
Memory Before: 1,591KB 
Time after: 0.08181095123291
Time taken: 0.00065088272094727
Memory After: 1,617KB 
table type possible_keys key key_len ref rows Extra
icon  system  PRIMARY        const row not found 
avatar  system  PRIMARY        const row not found 
post_parsed  system  PRIMARY        const row not found 
post  range  PRIMARY  PRIMARY    Using index condition; Using filesort 
user  eq_ref  PRIMARY  PRIMARY  cos_oldposts.post.userid   
userfield  eq_ref  PRIMARY  PRIMARY  cos_oldposts.user.userid   
usertextfield  eq_ref  PRIMARY  PRIMARY  cos_oldposts.user.userid   
customavatar  eq_ref  PRIMARY  PRIMARY  cos_oldposts.user.userid   
editlog  eq_ref  PRIMARY  PRIMARY  cos_oldposts.post.postid   


Time after parsing all posts:  0.089093923568726
Memory After: 1,701KB 


Query: SELECT user.username, user.usergroupid, user.membergroupids, session.userid, session.inthread, session.lastactivity, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, IF(user.options & 512, 1, 0) AS invisible FROM session AS session LEFT JOIN user AS user ON(user.userid = session.userid) WHERE session.lastactivity > 1615140459 ORDER BY lastactivity DESC Time before: 0.089119911193848 Memory Before: 1,703KB Time after: 0.10744094848633 Time taken: 0.01832103729248 Memory After: 1,712KB
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.10951495 seconds with 12 queries,
spending 0.092521905899048 doing MySQL queries and 0.016993044100952 doing PHP things.


Shutdown Queries:

Query: INSERT INTO session (sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid ,inforum, inthread, incalendar, badlocation ) VALUES ('8893bc27399e6c16b77be261f3987079', 0, '172.68.65.161', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'f8b36a7088f11fd097b1f1ab14e9b8d1', 1615142259, '/cosarchive/showthread.php?t=23414&goto=nextnewest&explain=1', 0, 0 ,98, 23423, 0,0 ) Time before: 0.10987997055054 Memory Before: 1,960KB Time after: 0.11030697822571 Time taken: 0.0004270076751709 Memory After: 1,960KB
Query: INSERT INTO threadviews (threadid) VALUES (23423) Time before: 0.11035394668579 Memory Before: 1,960KB Time after: 0.12002897262573 Time taken: 0.0096750259399414 Memory After: 1,960KB