Including Functions.php

Time Before: 0.00629 seconds
Time After: 0.01566 seconds
Time Taken: 0.00938 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.01609 seconds
Time After: 0.01677 seconds
Time Taken: 0.00068 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.01697 seconds
Time After: 0.01705 seconds
Time Taken: 0.00008 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.01770 seconds
Time After: 0.01952 seconds
Time Taken: 0.00183 seconds

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

Time Before: 0.01710 seconds
Time After: 0.02521 seconds
Time Taken: 0.00811 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.68.65.185'
	AND idhash = 'd68f307a5c30b13cbdd7b1320e714b44'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refguest_lookup,user_activityguest_lookup145const,const,const2100.00 

Time Before: 0.02795 seconds
Time After: 0.02810 seconds
Time Taken: 0.00015 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.02908 seconds
Time After: 0.02963 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.02735 seconds
Time After: 0.02980 seconds
Time Taken: 0.00245 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.03233 seconds
Time After: 0.03247 seconds
Time Taken: 0.00014 seconds

Memory Before: 6,464.891 KB
Memory After: 6,465.234 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.03430 seconds
Time After: 0.03496 seconds
Time Taken: 0.00067 seconds

Memory Before: 6,619.773 KB
Memory After: 6,620.367 KB
Memory Used: 0.594 KB

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

Time Before: 0.04842 seconds
Time After: 0.04955 seconds
Time Taken: 0.00113 seconds

Memory Before: 7,682.414 KB
Memory After: 7,700.125 KB
Memory Used: 17.711 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.05075 seconds
Time After: 0.05208 seconds
Time Taken: 0.00132 seconds

Memory Before: 7,691.148 KB
Memory After: 7,717.992 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.06079 seconds
Time After: 0.06145 seconds
Time Taken: 0.00067 seconds

Memory Before: 8,958.758 KB
Memory After: 8,960.258 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.10193 seconds
Time After: 0.10206 seconds
Time Taken: 0.00012 seconds

Memory Before: 9,598.703 KB
Memory After: 9,599.211 KB
Memory Used: 0.508 KB

SQL Query
UPDATE cache
SET locktime = 1569010810
WHERE cacheid = 'forumblock.6dd8011c9e773fc51d87a47bd0a0d78e'

Time Before: 0.10214 seconds
Time After: 0.10235 seconds
Time Taken: 0.00021 seconds

Memory Before: 9,599.797 KB
Memory After: 9,600.102 KB
Memory Used: 0.305 KB

SQL Query
REPLACE INTO cache
SET cacheid = 'forumblock.6dd8011c9e773fc51d87a47bd0a0d78e',
	expires = 1569014410,
	created = 1569010810,
	locktime = 0,
	data = "",
	serialized = '0'

Time Before: 0.10244 seconds
Time After: 0.10260 seconds
Time Taken: 0.00017 seconds

Memory Before: 9,601.328 KB
Memory After: 9,601.391 KB
Memory Used: 0.063 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.10356 seconds
Time After: 0.10368 seconds
Time Taken: 0.00012 seconds

Memory Before: 9,669.852 KB
Memory After: 9,670.297 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.10453 seconds
Time After: 0.10470 seconds
Time Taken: 0.00017 seconds

Memory Before: 9,716.719 KB
Memory After: 9,717.188 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 > 1566418810
	
	AND blog.state IN('visible')
	AND blog.dateline <= 1569010810
	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.10569 seconds
Time After: 0.10612 seconds
Time Taken: 0.00043 seconds

Memory Before: 9,722.906 KB
Memory After: 9,722.336 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 > 1566418810
	
	AND blog.state IN('visible')
	AND blog.dateline <= 1569010810
	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.10701 seconds
Time After: 0.10742 seconds
Time Taken: 0.00041 seconds

Memory Before: 9,722.133 KB
Memory After: 9,721.563 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.10789 seconds
Time After: 0.10802 seconds
Time Taken: 0.00012 seconds

Memory Before: 9,721.148 KB
Memory After: 9,721.672 KB
Memory Used: 0.523 KB

SQL Query
UPDATE cache
SET locktime = 1569010810
WHERE cacheid = 'forumblock.ae69ee477b364d8c5f1ce70cabed208e'

Time Before: 0.10808 seconds
Time After: 0.10821 seconds
Time Taken: 0.00012 seconds

Memory Before: 9,721.977 KB
Memory After: 9,722.281 KB
Memory Used: 0.305 KB

SQL Query
REPLACE INTO cache
SET cacheid = 'forumblock.ae69ee477b364d8c5f1ce70cabed208e',
	expires = 1569014410,
	created = 1569010810,
	locktime = 0,
	data = "",
	serialized = '0'

Time Before: 0.10828 seconds
Time After: 0.10844 seconds
Time Taken: 0.00015 seconds

Memory Before: 9,722.586 KB
Memory After: 9,722.602 KB
Memory Used: 0.016 KB

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

Time Before: 0.10900 seconds
Time After: 0.10912 seconds
Time Taken: 0.00011 seconds

Memory Before: 9,727.781 KB
Memory After: 9,728.320 KB
Memory Used: 0.539 KB

SQL Query
UPDATE cache
SET locktime = 1569010810
WHERE cacheid = 'forumblock.1066d218eaa969b12c6f649fb5246c8a'

Time Before: 0.10919 seconds
Time After: 0.10935 seconds
Time Taken: 0.00016 seconds

Memory Before: 9,728.656 KB
Memory After: 9,728.961 KB
Memory Used: 0.305 KB

SQL Query
REPLACE INTO cache
SET cacheid = 'forumblock.1066d218eaa969b12c6f649fb5246c8a',
	expires = 1569014410,
	created = 1569010810,
	locktime = 0,
	data = "
\"free
", serialized = '0'

Time Before: 0.10942 seconds
Time After: 0.10957 seconds
Time Taken: 0.00014 seconds

Memory Before: 9,729.336 KB
Memory After: 9,729.313 KB
Memory Used: -0.023 KB

SQL Query
UPDATE session
SET lastactivity = 1569010810, location = '/forum.php?explain=1', badlocation = 0
WHERE sessionhash = '099a3e767c3d20279c31bdd76e4e12b0'

Time Before: 0.11437 seconds
Time After: 0.11459 seconds
Time Taken: 0.00022 seconds

Memory Before: 10,500.320 KB
Memory After: 10,500.539 KB
Memory Used: 0.219 KB

Page generated in 0.11338496208191 seconds with 23 queries, spending 0.0098788738250732 doing MySQL queries and 0.10350608825684 doing PHP things.
Shutdown Queries:
DISABLED