Including Functions.php

Time Before: 0.00342 seconds
Time After: 0.00897 seconds
Time Taken: 0.00554 seconds

Memory Before: 2,003.734 KB
Memory After: 3,445.969 KB
Memory Used: 1,442.234 KB

Connect to Database on Server: localhost

Time Before: 0.00908 seconds
Time After: 0.00985 seconds
Time Taken: 0.00076 seconds

Memory Before: 3,445.836 KB
Memory After: 3,446.625 KB
Memory Used: 0.789 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','adv_modules','adv_portal_cale','adv_portal_home','adv_portal_opts','adv_portal_page','adv_portal_pars','adv_portal_stat','attachmentcache','bbcodecache','birthdaycache','eventcache','iconcache','maxloggedin','prefixcache','ranks','tagcloud','smiliecache','userstats')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastoreALLPRIMARY   40Using where

Time Before: 0.01039 seconds
Time After: 0.01083 seconds
Time Taken: 0.00045 seconds

Memory Before: 3,449.695 KB
Memory After: 3,450.406 KB
Memory Used: 0.711 KB

Time Before: 0.00996 seconds
Time After: 0.01264 seconds
Time Taken: 0.00268 seconds

Memory Before: 3,446.125 KB
Memory After: 4,567.203 KB
Memory Used: 1,121.078 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.226.4.91'
	AND idhash = '96191aa142dec71bc713b0b56e2b4f4f'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    5030Using where

Time Before: 0.01347 seconds
Time After: 0.01453 seconds
Time Taken: 0.00106 seconds

Memory Before: 4,617.375 KB
Memory After: 4,618.000 KB
Memory Used: 0.625 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_adv_portal AS phrasegroup_adv_portal,
			phrasegroup_calendar AS phrasegroup_calendar,
			phrasegroup_postbit AS phrasegroup_postbit,
			phrasegroup_prefix AS phrasegroup_prefix,
			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 = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguagesystemPRIMARY   1 

Time Before: 0.01500 seconds
Time After: 0.01521 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,627.602 KB
Memory After: 4,628.227 KB
Memory Used: 0.625 KB

Time Before: 0.01312 seconds
Time After: 0.01532 seconds
Time Taken: 0.00219 seconds

Memory Before: 4,613.586 KB
Memory After: 4,672.492 KB
Memory Used: 58.906 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 166 AND userselect = 1)
	OR styleid = 166
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstylesystemPRIMARY   1 

Time Before: 0.01815 seconds
Time After: 0.01827 seconds
Time Taken: 0.00012 seconds

Memory Before: 4,914.750 KB
Memory After: 4,915.367 KB
Memory Used: 0.617 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (10302,10311,0,10314,10315,10319,9857,10306,10327,10320,10323,10321,10322,10330,10329,10060,10316,10317,10318,9790,9788,9790,9784,10326,10324,10325,10310,10309,10307,10308,9815,10328,10303,10304,10305,0,10313,10255,10250,10256,9759,9758,9760,9755,9754,10031,9982,9983,9984,9985,10251,10254,10263,10004,10005,10006,10007,10205,10268,10267,10269,10272)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 60Using index condition

Time Before: 0.01896 seconds
Time After: 0.01942 seconds
Time Taken: 0.00047 seconds

Memory Before: 5,090.055 KB
Memory After: 5,090.680 KB
Memory Used: 0.625 KB

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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmoderatorALLuserid_forumid   12 
1SIMPLEusereq_refPRIMARYPRIMARY4corvette_forums.moderator.userid1 

Time Before: 0.02429 seconds
Time After: 0.02451 seconds
Time Taken: 0.00022 seconds

Memory Before: 6,051.906 KB
Memory After: 6,052.531 KB
Memory Used: 0.625 KB

End call of global.php: 0.0260479450226
Processing Module: Site Navigation
Time Before: 0.02614
Time After: 0.02656
Time Taken: 0.00042

Memory Before: 5,791.250 KB
Memory After: 5,807.188 KB
Memory Used: 15.938 KB

Site Navigation module generated in 0.00042 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00042 doing PHP things.

Processing Module: Online Users
SQL Query
SELECT session.userid, username, usergroupid, (user.options & 512) AS invisible, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity > 1558617476
	
ORDER BY username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    5030Using where; Using temporary; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4corvette_forums.session.userid1 

Time Before: 0.02746 seconds
Time After: 0.02925 seconds
Time Taken: 0.00179 seconds

Memory Before: 5,887.867 KB
Memory After: 5,888.586 KB
Memory Used: 0.719 KB

Time Before: 0.02667
Time After: 0.03051
Time Taken: 0.00384

Memory Before: 5,808.531 KB
Memory After: 5,816.734 KB
Memory Used: 8.203 KB

Online Users module generated in 0.00384 seconds with 1 queries.
0.00179 seconds doing MySQL queries and 0.00205 doing PHP things.

Processing Module: Buddy List
Time Before: 0.03061
Time After: 0.03100
Time Taken: 0.00040

Memory Before: 5,819.844 KB
Memory After: 5,820.305 KB
Memory Used: 0.461 KB

Buddy List module generated in 0.00040 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00040 doing PHP things.

Processing Module: Search Forums
Time Before: 0.03109
Time After: 0.03124
Time Taken: 0.00015

Memory Before: 5,820.305 KB
Memory After: 5,822.805 KB
Memory Used: 2.500 KB

Search Forums module generated in 0.00015 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00015 doing PHP things.

Processing Module: Current Poll
SQL Query
SELECT poll.*, thread.pollid, open, threadid, replycount, forumid 
FROM poll AS poll
INNER JOIN thread AS thread USING (pollid)

WHERE open <> 10 AND visible = 1
 AND thread.forumid NOT IN(50,55,48,40,57,56,69,8,58,59,66,67,68) AND poll.dateline > 1556061476 AND active = 1
ORDER BY poll.dateline DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpollrangePRIMARY,datelinedateline4 2Using index condition; Using where
1SIMPLEthreadrefpollid,forumidpollid4corvette_forums.poll.pollid77Using where

Time Before: 0.03219 seconds
Time After: 0.03243 seconds
Time Taken: 0.00024 seconds

Memory Before: 5,894.617 KB
Memory After: 5,895.336 KB
Memory Used: 0.719 KB

Time Before: 0.03133
Time After: 0.03249
Time Taken: 0.00116

Memory Before: 5,824.102 KB
Memory After: 5,824.914 KB
Memory Used: 0.813 KB

Current Poll module generated in 0.00116 seconds with 1 queries.
0.00024 seconds doing MySQL queries and 0.00092 doing PHP things.

Processing Module: Welcome Block
Time Before: 0.03261
Time After: 0.03306
Time Taken: 0.00046

Memory Before: 5,824.648 KB
Memory After: 5,828.609 KB
Memory Used: 3.961 KB

Welcome Block module generated in 0.00046 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00046 doing PHP things.

Processing Module: News
Time Before: 0.03316
Time After: 0.03473
Time Taken: 0.00158

Memory Before: 5,830.602 KB
Memory After: 5,951.883 KB
Memory Used: 121.281 KB

News module generated in 0.00158 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00158 doing PHP things.

Processing Module: Recent Threads
SQL Query
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, thread.lastpostid, pollid, thread.forumid, thread.open, sticky
, thread.iconid AS threadiconid, iconpath AS threadiconpath, post.pagetext AS preview, thread.attach
FROM thread as thread
 LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE open != 10
	AND thread.visible = 1 AND thread.lastpost > 1556061476
	 AND thread.forumid NOT IN(50,55,48,40,57,56,69,8,58,59,66,67,68)
ORDER BY lastpost DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrangeforumid,lastpostlastpost4 21Using index condition; Using where
1SIMPLEiconeq_refPRIMARYPRIMARY2corvette_forums.thread.iconid1 
1SIMPLEposteq_refPRIMARYPRIMARY4corvette_forums.thread.firstpostid1 

Time Before: 0.03576 seconds
Time After: 0.03614 seconds
Time Taken: 0.00038 seconds

Memory Before: 6,047.438 KB
Memory After: 6,048.148 KB
Memory Used: 0.711 KB

Time Before: 0.03483
Time After: 0.03864
Time Taken: 0.00382

Memory Before: 5,951.883 KB
Memory After: 5,980.703 KB
Memory Used: 28.820 KB

Recent Threads module generated in 0.00382 seconds with 1 queries.
0.00038 seconds doing MySQL queries and 0.00344 doing PHP things.

Processing Module: Mini Calendar
Time Before: 0.03874
Time After: 0.04204
Time Taken: 0.00331

Memory Before: 5,988.813 KB
Memory After: 6,478.359 KB
Memory Used: 489.547 KB

Mini Calendar module generated in 0.00331 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00331 doing PHP things.

Processing Module: Stats
SQL Query
SELECT threadcount, replycount
FROM forum
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumALL    49 

Time Before: 0.04252 seconds
Time After: 0.04264 seconds
Time Taken: 0.00012 seconds

Memory Before: 6,516.125 KB
Memory After: 6,516.844 KB
Memory Used: 0.719 KB

SQL Query
SELECT userid, username, posts FROM user WHERE userid = '362'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 

Time Before: 0.04299 seconds
Time After: 0.04307 seconds
Time Taken: 0.00008 seconds

Memory Before: 6,516.602 KB
Memory After: 6,517.227 KB
Memory Used: 0.625 KB

Time Before: 0.04213
Time After: 0.04328
Time Taken: 0.00115

Memory Before: 6,481.992 KB
Memory After: 6,482.359 KB
Memory Used: 0.367 KB

Stats module generated in 0.00115 seconds with 2 queries.
0.00020 seconds doing MySQL queries and 0.00094 doing PHP things.

Processing Module: News Archive
Time Before: 0.04338
Time After: 0.04450
Time Taken: 0.00112

Memory Before: 6,483.320 KB
Memory After: 6,475.742 KB
Memory Used: -7.578 KB

News Archive module generated in 0.00112 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00112 doing PHP things.

Processing Module: Today's Birthdays
Time Before: 0.04460
Time After: 0.04485
Time Taken: 0.00025

Memory Before: 6,475.664 KB
Memory After: 6,476.898 KB
Memory Used: 1.234 KB

Today's Birthdays module generated in 0.00025 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00025 doing PHP things.

Page generated in 0.0455460548401 seconds with 11 queries, spending 0.00590682029724 doing MySQL queries and 0.0396392345428 doing PHP things.
Shutdown Queries:

SQL Query
UPDATE session
SET lastactivity = 1558653476, location = '/?explain=1', inforum = 0, inthread = 0, badlocation = 0
WHERE sessionhash = '1fe42fb7830652df5bf3fb3b3692b462'

Time Before: 0.04618 seconds
Time After: 0.04631 seconds
Time Taken: 0.00013 seconds

Memory Before: 6,716.328 KB
Memory After: 6,716.930 KB
Memory Used: 0.602 KB