Including Functions.php

Time Before: 0.00643 seconds
Time After: 0.01459 seconds
Time Taken: 0.00816 seconds

Memory Before: 1,731.117 KB
Memory After: 2,976.008 KB
Memory Used: 1,244.891 KB

Connect to Database on Server: localhost

Time Before: 0.01495 seconds
Time After: 0.01585 seconds
Time Taken: 0.00090 seconds

Memory Before: 2,975.945 KB
Memory After: 2,976.898 KB
Memory Used: 0.953 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01622 seconds
Time After: 0.01638 seconds
Time Taken: 0.00016 seconds

Memory Before: 2,977.633 KB
Memory After: 2,978.188 KB
Memory Used: 0.555 KB

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

Time Before: 0.01760 seconds
Time After: 0.02093 seconds
Time Taken: 0.00333 seconds

Memory Before: 2,981.648 KB
Memory After: 2,982.617 KB
Memory Used: 0.969 KB

Time Before: 0.01651 seconds
Time After: 0.02914 seconds
Time Taken: 0.01264 seconds

Memory Before: 2,977.438 KB
Memory After: 5,468.141 KB
Memory Used: 2,490.703 KB

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

Time Before: 0.03185 seconds
Time After: 0.03201 seconds
Time Taken: 0.00016 seconds

Memory Before: 6,061.906 KB
Memory After: 6,062.516 KB
Memory Used: 0.609 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_activitystream AS phrasegroup_activitystream,
			phrasegroup_holiday AS phrasegroup_holiday,
			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.03286 seconds
Time After: 0.03339 seconds
Time Taken: 0.00053 seconds

Memory Before: 6,074.875 KB
Memory After: 6,074.875 KB
Memory Used: 0.000 KB

Time Before: 0.03119 seconds
Time After: 0.03358 seconds
Time Taken: 0.00239 seconds

Memory Before: 6,054.281 KB
Memory After: 6,161.531 KB
Memory Used: 107.250 KB

SQL Query
SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,
	calendar.calendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON
	(calendarpermission.calendarid = calendar.calendarid AND
		usergroupid IN (1))
ORDER BY displayorder ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcalendar system    1100.00 
1SIMPLEcalendarpermission systemcalendarid,usergroupid   00.00const row not found

Time Before: 0.03623 seconds
Time After: 0.03636 seconds
Time Taken: 0.00012 seconds

Memory Before: 6,464.922 KB
Memory After: 6,465.266 KB
Memory Used: 0.344 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.03827 seconds
Time After: 0.03863 seconds
Time Taken: 0.00037 seconds

Memory Before: 6,619.766 KB
Memory After: 6,620.359 KB
Memory Used: 0.594 KB

End call of global.php: 0.039982080459595
SQL Query
SELECT
	user.username, (user.options & 512) AS invisible, user.usergroupid, user.lastvisit,
	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 > 1563552426
	
ORDER BY username ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession rangelast_activitylast_activity4 60100.00Using where; Using temporary; Using filesort
1SIMPLEuser eq_refPRIMARYPRIMARY4whitefor_b1.session.userid1100.00 

Time Before: 0.04345 seconds
Time After: 0.04395 seconds
Time Taken: 0.00050 seconds

Memory Before: 7,682.430 KB
Memory After: 7,688.875 KB
Memory Used: 6.445 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.04464 seconds
Time After: 0.04568 seconds
Time Taken: 0.00104 seconds

Memory Before: 7,690.516 KB
Memory After: 7,717.359 KB
Memory Used: 26.844 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (5720,5721,11368,11369,11370,11372,11373,11374,11375,11371,9571,11442,11448,11443,11444,11445,11446,11447,11793,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 56100.00Using index condition

Time Before: 0.05312 seconds
Time After: 0.05377 seconds
Time Taken: 0.00064 seconds

Memory Before: 8,956.977 KB
Memory After: 8,958.477 KB
Memory Used: 1.500 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'forumblock.6dd8011c9e773fc51d87a47bd0a0d78e'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

Time Before: 0.08409 seconds
Time After: 0.08421 seconds
Time Taken: 0.00012 seconds

Memory Before: 9,596.594 KB
Memory After: 9,597.102 KB
Memory Used: 0.508 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'forumblock.07893df291f2b7df6773f75ed700d38d'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

Time Before: 0.08516 seconds
Time After: 0.08526 seconds
Time Taken: 0.00010 seconds

Memory Before: 9,665.539 KB
Memory After: 9,665.984 KB
Memory Used: 0.445 KB

SQL Query
SELECT bm.userid, bm.permissions, bm.type, user.username
FROM blog_moderator AS bm
INNER JOIN user AS user USING (userid)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

Time Before: 0.08600 seconds
Time After: 0.08613 seconds
Time Taken: 0.00012 seconds

Memory Before: 9,712.594 KB
Memory After: 9,713.063 KB
Memory Used: 0.469 KB

SQL Query
SELECT blog.blogid, blog.comments_visible as replycount, blog.title, blog.lastcomment, blog.lastcommenter, blog.postedby_userid, blog.postedby_username, blog.dateline,
	blog_text.blogtextid, blog_text.pagetext AS message,
	blog_user.title as blogtitle, blog_user.description as blogdescription,
	user.*
	,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM blog AS blog
INNER JOIN blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
INNER JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
INNER JOIN user AS user ON (blog.userid = user.userid)
LEFT JOIN blog_categoryuser AS cu ON (cu.blogid = blog.blogid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
	
	
	 AND blog.dateline > 1560961326
	
	AND blog.state IN('visible')
	AND blog.dateline <= 1563553326
	AND blog.pending = 0
	AND options_guest & 1
	AND ~blog.options & 8
ORDER BY blog.dateline DESC
LIMIT 0,5
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcu systemPRIMARY   00.00const row not found
1SIMPLEavatar systemPRIMARY   00.00const row not found
1SIMPLEblog rangedateline,state,userid,pendingdateline4 15.00Using index condition; Using where
1SIMPLEblog_user eq_refPRIMARYPRIMARY4whitefor_b1.blog.userid1100.00Using where
1SIMPLEblog_text eq_refPRIMARYPRIMARY4whitefor_b1.blog.firstblogtextid1100.00 
1SIMPLEuser eq_refPRIMARYPRIMARY4whitefor_b1.blog.userid1100.00 
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4whitefor_b1.blog.userid1100.00 

Time Before: 0.08704 seconds
Time After: 0.08742 seconds
Time Taken: 0.00038 seconds

Memory Before: 9,718.781 KB
Memory After: 9,718.211 KB
Memory Used: -0.570 KB

SQL Query
SELECT blog.blogid, blog.comments_visible as replycount, blog.title, blog.lastcomment, blog.lastcommenter, blog.postedby_userid, blog.postedby_username, blog.dateline,
	blog_text.blogtextid, blog_text.pagetext AS message,
	blog_user.title as blogtitle, blog_user.description as blogdescription,
	user.*
	,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM blog AS blog
INNER JOIN blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
INNER JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
INNER JOIN user AS user ON (blog.userid = user.userid)
LEFT JOIN blog_categoryuser AS cu ON (cu.blogid = blog.blogid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
	
	
	 AND blog.dateline > 1560961326
	
	AND blog.state IN('visible')
	AND blog.dateline <= 1563553326
	AND blog.pending = 0
	AND options_guest & 1
	AND ~blog.options & 8
ORDER BY blog.dateline DESC
LIMIT 0,5
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcu systemPRIMARY   00.00const row not found
1SIMPLEavatar systemPRIMARY   00.00const row not found
1SIMPLEblog rangedateline,state,userid,pendingdateline4 15.00Using index condition; Using where
1SIMPLEblog_user eq_refPRIMARYPRIMARY4whitefor_b1.blog.userid1100.00Using where
1SIMPLEblog_text eq_refPRIMARYPRIMARY4whitefor_b1.blog.firstblogtextid1100.00 
1SIMPLEuser eq_refPRIMARYPRIMARY4whitefor_b1.blog.userid1100.00 
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4whitefor_b1.blog.userid1100.00 

Time Before: 0.08821 seconds
Time After: 0.08858 seconds
Time Taken: 0.00036 seconds

Memory Before: 9,718.203 KB
Memory After: 9,717.633 KB
Memory Used: -0.570 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'forumblock.ae69ee477b364d8c5f1ce70cabed208e'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

Time Before: 0.08903 seconds
Time After: 0.08914 seconds
Time Taken: 0.00011 seconds

Memory Before: 9,717.219 KB
Memory After: 9,717.742 KB
Memory Used: 0.523 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'forumblock.1066d218eaa969b12c6f649fb5246c8a'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

Time Before: 0.08969 seconds
Time After: 0.08980 seconds
Time Taken: 0.00011 seconds

Memory Before: 9,723.461 KB
Memory After: 9,723.984 KB
Memory Used: 0.523 KB

SQL Query
UPDATE session
SET lastactivity = 1563553326, location = '/forum.php?explain=1', inforum = 0, badlocation = 0
WHERE sessionhash = 'aee1d9b72659a3bc76b3c40651908915'

Time Before: 0.09411 seconds
Time After: 0.09436 seconds
Time Taken: 0.00025 seconds

Memory Before: 10,495.297 KB
Memory After: 10,495.523 KB
Memory Used: 0.227 KB

Page generated in 0.093167066574097 seconds with 17 queries, spending 0.0093204975128174 doing MySQL queries and 0.083846569061279 doing PHP things.
Shutdown Queries:
DISABLED