Including Functions.php

Time Before: 0.00533 seconds
Time After: 0.01324 seconds
Time Taken: 0.00791 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.01336 seconds
Time After: 0.01389 seconds
Time Taken: 0.00054 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.01406 seconds
Time After: 0.01412 seconds
Time Taken: 0.00006 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.01462 seconds
Time After: 0.01616 seconds
Time Taken: 0.00154 seconds

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

Time Before: 0.01416 seconds
Time After: 0.02109 seconds
Time Taken: 0.00693 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.63.12'
	AND idhash = 'a6d7a3185b58f43234493d3a9b6cec37'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refguest_lookup,user_activityguest_lookup145const,const,const2100.00 

Time Before: 0.02364 seconds
Time After: 0.02379 seconds
Time Taken: 0.00015 seconds

Memory Before: 6,061.906 KB
Memory After: 6,062.523 KB
Memory Used: 0.617 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.02463 seconds
Time After: 0.02517 seconds
Time Taken: 0.00055 seconds

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

Time Before: 0.02306 seconds
Time After: 0.02537 seconds
Time Taken: 0.00231 seconds

Memory Before: 6,054.281 KB
Memory After: 6,161.539 KB
Memory Used: 107.258 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.02808 seconds
Time After: 0.02820 seconds
Time Taken: 0.00012 seconds

Memory Before: 6,464.867 KB
Memory After: 6,465.211 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.03007 seconds
Time After: 0.03043 seconds
Time Taken: 0.00036 seconds

Memory Before: 6,619.750 KB
Memory After: 6,620.344 KB
Memory Used: 0.594 KB

End call of global.php: 0.031764984130859
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 > 1574415103
	
ORDER BY username ASC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession rangelast_activitylast_activity4 147100.00Using where; Using temporary; Using filesort
1SIMPLEuser eq_refPRIMARYPRIMARY4whitefor_b1.session.userid1100.00 

Time Before: 0.03514 seconds
Time After: 0.03675 seconds
Time Taken: 0.00161 seconds

Memory Before: 7,682.422 KB
Memory After: 7,717.227 KB
Memory Used: 34.805 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.03820 seconds
Time After: 0.03932 seconds
Time Taken: 0.00112 seconds

Memory Before: 7,695.789 KB
Memory After: 7,722.633 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.04650 seconds
Time After: 0.04712 seconds
Time Taken: 0.00062 seconds

Memory Before: 8,968.891 KB
Memory After: 8,970.391 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.07734 seconds
Time After: 0.07745 seconds
Time Taken: 0.00011 seconds

Memory Before: 9,608.773 KB
Memory After: 9,609.289 KB
Memory Used: 0.516 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.07835 seconds
Time After: 0.07844 seconds
Time Taken: 0.00009 seconds

Memory Before: 9,677.703 KB
Memory After: 9,678.188 KB
Memory Used: 0.484 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.07915 seconds
Time After: 0.07928 seconds
Time Taken: 0.00012 seconds

Memory Before: 9,724.781 KB
Memory After: 9,725.250 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 > 1571824003
	
	AND blog.state IN('visible')
	AND blog.dateline <= 1574416003
	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.08012 seconds
Time After: 0.08048 seconds
Time Taken: 0.00037 seconds

Memory Before: 9,730.969 KB
Memory After: 9,730.398 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 > 1571824003
	
	AND blog.state IN('visible')
	AND blog.dateline <= 1574416003
	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.08126 seconds
Time After: 0.08160 seconds
Time Taken: 0.00035 seconds

Memory Before: 9,730.391 KB
Memory After: 9,729.820 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.08202 seconds
Time After: 0.08213 seconds
Time Taken: 0.00011 seconds

Memory Before: 9,729.406 KB
Memory After: 9,729.945 KB
Memory Used: 0.539 KB

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

Time Before: 0.08261 seconds
Time After: 0.08271 seconds
Time Taken: 0.00010 seconds

Memory Before: 9,735.648 KB
Memory After: 9,736.188 KB
Memory Used: 0.539 KB

SQL Query
UPDATE session
SET lastactivity = 1574416003, location = '/forum.php?explain=1', badlocation = 0
WHERE sessionhash = '70d2dc07a53d84e0990c875b799ec91c'

Time Before: 0.08693 seconds
Time After: 0.08711 seconds
Time Taken: 0.00018 seconds

Memory Before: 10,508.797 KB
Memory After: 10,509.016 KB
Memory Used: 0.219 KB

Page generated in 0.085975170135498 seconds with 17 queries, spending 0.008115291595459 doing MySQL queries and 0.077859878540039 doing PHP things.
Shutdown Queries:
DISABLED