Including Functions.php

Time Before: 0.00528 seconds
Time After: 0.01359 seconds
Time Taken: 0.00831 seconds

Memory Before: 1,809.766 KB
Memory After: 3,054.828 KB
Memory Used: 1,245.063 KB

Connect to Database on Server: localhost

Time Before: 0.01395 seconds
Time After: 0.01447 seconds
Time Taken: 0.00052 seconds

Memory Before: 3,054.766 KB
Memory After: 3,055.719 KB
Memory Used: 0.953 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01467 seconds
Time After: 0.01474 seconds
Time Taken: 0.00006 seconds

Memory Before: 3,056.453 KB
Memory After: 3,057.016 KB
Memory Used: 0.563 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('iconcache','mailqueue','prefixcache','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY152 19100.00Using index condition

Time Before: 0.01533 seconds
Time After: 0.01679 seconds
Time Taken: 0.00146 seconds

Memory Before: 3,060.320 KB
Memory After: 3,061.219 KB
Memory Used: 0.898 KB

Time Before: 0.01481 seconds
Time After: 0.02128 seconds
Time Taken: 0.00647 seconds

Memory Before: 3,056.266 KB
Memory After: 5,524.922 KB
Memory Used: 2,468.656 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '172.69.62.201'
	AND idhash = '95915f54ca099c3b45dfa346131a3ac0'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refguest_lookup,user_activityguest_lookup145const,const,const2100.00 

Time Before: 0.02380 seconds
Time After: 0.02395 seconds
Time Taken: 0.00014 seconds

Memory Before: 6,122.594 KB
Memory After: 6,123.039 KB
Memory Used: 0.445 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_forumdisplay AS phrasegroup_forumdisplay,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroupinfo AS lang_phrasegroupinfo,
			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 = 8
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLElanguage constPRIMARYPRIMARY2const1100.00 

Time Before: 0.02474 seconds
Time After: 0.02524 seconds
Time Taken: 0.00050 seconds

Memory Before: 6,137.109 KB
Memory After: 6,137.078 KB
Memory Used: -0.031 KB

Time Before: 0.02328 seconds
Time After: 0.02539 seconds
Time Taken: 0.00211 seconds

Memory Before: 6,114.547 KB
Memory After: 6,230.680 KB
Memory Used: 116.133 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 7 AND userselect = 1)
	OR styleid = 7
ORDER BY styleid ASC
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

Time Before: 0.02938 seconds
Time After: 0.02974 seconds
Time Taken: 0.00036 seconds

Memory Before: 6,716.852 KB
Memory After: 6,717.445 KB
Memory Used: 0.594 KB

End call of global.php: 0.030937910079956
SQL Query
SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEmoderator ALLuserid_forumid   48100.00 
1SIMPLEuser eq_refPRIMARYPRIMARY4whitefor_b1.moderator.userid1100.00 

Time Before: 0.03330 seconds
Time After: 0.03381 seconds
Time Taken: 0.00051 seconds

Memory Before: 7,617.523 KB
Memory After: 7,621.281 KB
Memory Used: 3.758 KB

SQL Query
SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
	user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
	
FROM forum AS forum

LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEforum ALL    181100.00 
1SIMPLEuser eq_refPRIMARYPRIMARY4whitefor_b1.forum.lastposterid1100.00 
1SIMPLEuserlist eq_refPRIMARY,userid,relationidPRIMARY9const,whitefor_b1.user.userid,const1100.00 

Time Before: 0.03470 seconds
Time After: 0.03588 seconds
Time Taken: 0.00118 seconds

Memory Before: 7,738.555 KB
Memory After: 7,765.398 KB
Memory Used: 26.844 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (5723,11436,11824,11826,11825,11447,11448,11444,11446,11443,11445,11439,11914,11864,11814,11923,11933,11874,11944,0,0,5728,5722,8390,5355,5727,5725,5361,5729,5730,5731,11630,11926,11576,11580,11577,11578,11579,11942,0,0,11905,11907,11600,11601,11603,11604,11827,11869,11868,11918,11870,11427,11426,11430)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 52100.00Using index condition

Time Before: 0.03920 seconds
Time After: 0.03985 seconds
Time Taken: 0.00065 seconds

Memory Before: 8,595.969 KB
Memory After: 8,597.391 KB
Memory Used: 1.422 KB

SQL Query
SELECT user.username, (user.options & 512) AS invisible, user.usergroupid,
	session.userid, session.inforum, session.lastactivity, session.badlocation,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1571068543
ORDER BY lastactivity DESC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession rangelast_activitylast_activity4 86100.00Using where
1SIMPLEuser eq_refPRIMARYPRIMARY4whitefor_b1.session.userid1100.00 

Time Before: 0.04489 seconds
Time After: 0.04534 seconds
Time Taken: 0.00045 seconds

Memory Before: 8,911.383 KB
Memory After: 8,919.078 KB
Memory Used: 7.695 KB

SQL Query
SELECT
	announcement.announcementid, startdate, title, announcement.views,
	user.username, user.userid, user.usertitle, user.customtitle, user.usergroupid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
	
	
FROM announcement AS announcement

LEFT JOIN user AS user ON(user.userid = announcement.userid)

WHERE startdate <= 1571069443
	AND enddate >= 1571069443
	AND forumid IN (296,166,297,-1)
	
ORDER BY startdate DESC, announcement.announcementid DESC
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEannouncement rangeforumid,enddateenddate6 322.22Using index condition; Using filesort
1SIMPLEuser eq_refPRIMARYPRIMARY4whitefor_b1.announcement.userid1100.00 

Time Before: 0.05135 seconds
Time After: 0.05155 seconds
Time Taken: 0.00020 seconds

Memory Before: 9,064.375 KB
Memory After: 9,064.445 KB
Memory Used: 0.070 KB

SQL Query
SELECT COUNT(*) AS threads

FROM thread AS thread


WHERE thread.forumid = 296
	AND sticky = 0
	
	 AND visible = 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEthread refforumid,forumid_lastpostforumid6const,const,const1100.00Using index

Time Before: 0.05200 seconds
Time After: 0.05213 seconds
Time Taken: 0.00013 seconds

Memory Before: 9,068.992 KB
Memory After: 9,069.469 KB
Memory Used: 0.477 KB

SQL Query
SELECT COUNT(*) AS newthread
FROM thread AS thread


WHERE thread.forumid = 296
	AND thread.lastpost > 1571069443
	AND open <> 10
	AND sticky = 0
	
	 AND visible = 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEthread rangeforumid,forumid_lastpost,lastpostforumid10 190.00Using index condition; Using where

Time Before: 0.05245 seconds
Time After: 0.05259 seconds
Time Taken: 0.00013 seconds

Memory Before: 9,069.703 KB
Memory After: 9,070.141 KB
Memory Used: 0.438 KB

SQL Query
SELECT thread.threadid, lastpost, open
FROM thread AS thread
WHERE forumid = 296
	AND sticky = 1
	
	 AND visible = 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEthread refforumid,forumid_lastpostforumid6const,const,const1100.00 

Time Before: 0.05289 seconds
Time After: 0.05300 seconds
Time Taken: 0.00012 seconds

Memory Before: 9,069.750 KB
Memory After: 9,070.188 KB
Memory Used: 0.438 KB

SQL Query
SELECT  thread.threadid,
	thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views
	
FROM thread AS thread


WHERE forumid = 296
	AND sticky = 0
	
	 AND visible = 1 
	
	
	
	
ORDER BY sticky DESC, lastpost DESC
LIMIT 0, 30
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEthread refforumid,forumid_lastpostforumid6const,const,const1100.00Using where

Time Before: 0.05336 seconds
Time After: 0.05350 seconds
Time Taken: 0.00014 seconds

Memory Before: 9,071.531 KB
Memory After: 9,071.758 KB
Memory Used: 0.227 KB

SQL Query
SELECT 
	IF(votenum >= 1, votenum, 0) AS votenum,
	IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
 post.pagetext AS preview,
	thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
	thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
	thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount, user.userid,
	user.membergroupids, user.infractiongroupids, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
	user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
	
	
	
	
	
	
FROM thread AS thread
	LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
	LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)
	
	
	
	
	LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
	
	
	
WHERE thread.threadid IN (0) 
ORDER BY thread.sticky DESC, lastpost DESC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

Time Before: 0.05398 seconds
Time After: 0.05422 seconds
Time Taken: 0.00023 seconds

Memory Before: 9,075.766 KB
Memory After: 9,075.063 KB
Memory Used: -0.703 KB

SQL Query
INSERT IGNORE INTO session
	(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
	('9c5c02251410e50c10046a48b4af27f4', 0, '172.69.62.201', '95915f54ca099c3b45dfa346131a3ac0', 1571069443, 'forumdisplay.php?f=296', 0, 0, 0, 296, 0, 0, 0, 'CCBot/2.0 (https://commoncrawl.org/faq/)', 0, 0, 0, '')

Time Before: 0.05793 seconds
Time After: 0.05808 seconds
Time Taken: 0.00014 seconds

Memory Before: 9,540.727 KB
Memory After: 9,540.680 KB
Memory Used: -0.047 KB

Page generated in 0.056167125701904 seconds with 16 queries, spending 0.0069501399993896 doing MySQL queries and 0.049216985702515 doing PHP things.
Shutdown Queries:
DISABLED