Including Functions.php

Time Before: 0.00556 seconds
Time After: 0.01364 seconds
Time Taken: 0.00808 seconds

Memory Before: 1,731.023 KB
Memory After: 2,975.906 KB
Memory Used: 1,244.883 KB

Connect to Database on Server: localhost

Time Before: 0.01403 seconds
Time After: 0.01493 seconds
Time Taken: 0.00090 seconds

Memory Before: 2,975.844 KB
Memory After: 2,976.797 KB
Memory Used: 0.953 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01523 seconds
Time After: 0.01538 seconds
Time Taken: 0.00015 seconds

Memory Before: 2,977.531 KB
Memory After: 2,978.086 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.01628 seconds
Time After: 0.01814 seconds
Time Taken: 0.00186 seconds

Memory Before: 2,981.547 KB
Memory After: 2,982.516 KB
Memory Used: 0.969 KB

Time Before: 0.01548 seconds
Time After: 0.02368 seconds
Time Taken: 0.00820 seconds

Memory Before: 2,977.336 KB
Memory After: 5,468.023 KB
Memory Used: 2,490.688 KB

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

Time Before: 0.02662 seconds
Time After: 0.02680 seconds
Time Taken: 0.00017 seconds

Memory Before: 6,061.922 KB
Memory After: 6,062.531 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.02764 seconds
Time After: 0.02815 seconds
Time Taken: 0.00051 seconds

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

Time Before: 0.02597 seconds
Time After: 0.02834 seconds
Time Taken: 0.00237 seconds

Memory Before: 6,054.250 KB
Memory After: 6,161.539 KB
Memory Used: 107.289 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.03098 seconds
Time After: 0.03110 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.03316 seconds
Time After: 0.03366 seconds
Time Taken: 0.00050 seconds

Memory Before: 6,619.844 KB
Memory After: 6,620.438 KB
Memory Used: 0.594 KB

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

Time Before: 0.04026 seconds
Time After: 0.04074 seconds
Time Taken: 0.00048 seconds

Memory Before: 7,682.492 KB
Memory After: 7,688.938 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.04140 seconds
Time After: 0.04245 seconds
Time Taken: 0.00105 seconds

Memory Before: 7,689.383 KB
Memory After: 7,716.227 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.04976 seconds
Time After: 0.05037 seconds
Time Taken: 0.00061 seconds

Memory Before: 8,955.461 KB
Memory After: 8,956.961 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.08495 seconds
Time After: 0.08511 seconds
Time Taken: 0.00016 seconds

Memory Before: 9,595.031 KB
Memory After: 9,595.547 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.08633 seconds
Time After: 0.08649 seconds
Time Taken: 0.00016 seconds

Memory Before: 9,663.977 KB
Memory After: 9,664.445 KB
Memory Used: 0.469 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.08749 seconds
Time After: 0.08773 seconds
Time Taken: 0.00024 seconds

Memory Before: 9,711.055 KB
Memory After: 9,711.523 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 > 1556349134
	
	AND blog.state IN('visible')
	AND blog.dateline <= 1558941134
	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.08907 seconds
Time After: 0.08957 seconds
Time Taken: 0.00050 seconds

Memory Before: 9,717.242 KB
Memory After: 9,716.672 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 > 1556349134
	
	AND blog.state IN('visible')
	AND blog.dateline <= 1558941134
	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.09036 seconds
Time After: 0.09073 seconds
Time Taken: 0.00037 seconds

Memory Before: 9,716.664 KB
Memory After: 9,716.094 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.09119 seconds
Time After: 0.09129 seconds
Time Taken: 0.00011 seconds

Memory Before: 9,715.680 KB
Memory After: 9,716.203 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.09194 seconds
Time After: 0.09205 seconds
Time Taken: 0.00011 seconds

Memory Before: 9,721.945 KB
Memory After: 9,722.445 KB
Memory Used: 0.500 KB

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

Time Before: 0.09635 seconds
Time After: 0.09656 seconds
Time Taken: 0.00022 seconds

Memory Before: 10,494.820 KB
Memory After: 10,495.047 KB
Memory Used: 0.227 KB

Page generated in 0.095266819000244 seconds with 17 queries, spending 0.0082242488861084 doing MySQL queries and 0.087042570114136 doing PHP things.
Shutdown Queries:
DISABLED