Including Functions.php

Time Before: 0.00500 seconds
Time After: 0.01300 seconds
Time Taken: 0.00800 seconds

Connect to Database on Server:

Time Before: 0.01306 seconds
Time After: 0.01506 seconds
Time Taken: 0.00200 seconds

SQL Query
SET @@sql_mode = ''

Time Before: 0.01532 seconds
Time After: 0.01545 seconds
Time Taken: 0.00013 seconds

Datastore Setup
SQL Query
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','adv_modules','adv_portal_opts','adv_portal_page','adv_portal_tpst','attachmentcache','bbcodecache','birthdaycache','eventcache','iconcache','maxloggedin','rankphp','smiliecache','userstats')
1SIMPLEdatastorerangePRIMARYPRIMARY52 24Using index condition

Time Before: 0.01599 seconds
Time After: 0.01712 seconds
Time Taken: 0.00114 seconds

Time Before: 0.01548 seconds
Time After: 0.01932 seconds
Time Taken: 0.00384 seconds

SQL Query
FROM datastore
WHERE title IN ('gallery_c_cache','adv_gallery_opt','gallery_ugroups','ppg_stats')
1SIMPLEdatastorerangePRIMARYPRIMARY52 4Using index condition

Time Before: 0.02013 seconds
Time After: 0.02039 seconds
Time Taken: 0.00026 seconds

Session Handling
SQL Query
FROM session
WHERE userid = 0
	AND host = ''
	AND idhash = 'c2e2cec10a0283a15fd4d6926b70705f'
1SIMPLEsessionALL    223Using where

Time Before: 0.03670 seconds
Time After: 0.05225 seconds
Time Taken: 0.01555 seconds

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

Time Before: 0.06797 seconds
Time After: 0.06871 seconds
Time Taken: 0.00074 seconds

Time Before: 0.02059 seconds
Time After: 0.06884 seconds
Time Taken: 0.04825 seconds

SQL Query
SELECT * FROM adv_pages WHERE name = 'home' AND active = 1

Time Before: 0.07126 seconds
Time After: 0.07162 seconds
Time Taken: 0.00036 seconds

SQL Query
FROM style
WHERE (styleid = 2 AND userselect = 1)
	OR styleid = 2
ORDER BY styleid ASC

Time Before: 0.07254 seconds
Time After: 0.07317 seconds
Time Taken: 0.00063 seconds

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (1599,406,0,410,411,412,421,907,1345,1366,909,910,415,414,423,1213,416,887,417,420,418,419,912,911,405,404,402,403,1044,422,901,1504,906,891,889,1153,1323,1326,1335,1172,1173,1174,1175,1286,1340,1339,1341,1344,929,930,931,932,933,934,935,936,937,938,939,942,940,941,943,944,1583,1582,1589,1580,1587,1581,1588,1584,1577,1590,1578,1585,1579,1586)
1SIMPLEtemplaterangePRIMARYPRIMARY4 78Using index condition

Time Before: 0.07442 seconds
Time After: 0.07574 seconds
Time Taken: 0.00132 seconds

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)
1SIMPLEmoderatorALLuserid   77 

Time Before: 0.08809 seconds
Time After: 0.08858 seconds
Time Taken: 0.00048 seconds

Processing Module: Site Navigation
Finished processing module: Site Navigation

Time Before: 0.22333200
Time After:0.22427000
Time Taken: 0.000938

Processing Module: Top Photo Rating
Finished processing module: Top Photo Rating

Time Before: 0.22429100
Time After:0.23272100
Time Taken: 0.00843

Processing Module: Search Forums
Finished processing module: Search Forums

Time Before: 0.23274300
Time After:0.23307700
Time Taken: 0.000334

Processing Module: Random Member
SQL Query
SELECT userid, dateline, height, width
FROM customavatar
1SIMPLEcustomavatarALL    150Using temporary; Using filesort

Time Before: 0.10281 seconds
Time After: 0.10322 seconds
Time Taken: 0.00041 seconds

SQL Query
SELECT profilepicrevision,username, joindate,usertitle
FROM user
WHERE userid = 1536

Time Before: 0.10356 seconds
Time After: 0.10380 seconds
Time Taken: 0.00024 seconds

Finished processing module: Random Member

Time Before: 0.23309400
Time After:0.23659400
Time Taken: 0.0035

Processing Module: Download
SQL Query
SELECT * FROM dl_main
1SIMPLEdl_mainsystem    1 

Time Before: 0.10573 seconds
Time After: 0.10599 seconds
Time Taken: 0.00025 seconds

SQL Query
SELECT `latestall`, `popularall`, `contriball` FROM dl_main
1SIMPLEdl_mainsystem    1 

Time Before: 0.10633 seconds
Time After: 0.10650 seconds
Time Taken: 0.00016 seconds

Finished processing module: Download

Time Before: 0.23661400
Time After:0.23950100
Time Taken: 0.002887

Processing Module: Last P.A. and Attachment
Finished processing module: Last P.A. and Attachment

Time Before: 0.23952300
Time After:0.30364400
Time Taken: 0.064121

Processing Module: Custom Page Content
Finished processing module: Custom Page Content

Time Before: 0.30366900
Time After:0.30369300
Time Taken: 2.4E-005

Processing Module: Last Model Railroad and last Real Train Picture
Finished processing module: Last Model Railroad and last Real Train Picture

Time Before: 0.30370700
Time After:0.30873900
Time Taken: 0.005032

Processing Module: Most Recent Topics
SQL Query

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

	, post.pagetext AS preview

FROM thread as thread 
	LEFT JOIN post AS post ON (post.postid = thread.firstpostid)

WHERE open != 10 AND thread.visible = 1 

AND thread.forumid IN(5,33,34,3,4,26,24,38,36,37,6,7,8,9,39,35,12,40,41,19,13,14,15,16,17,20,21,22,42,43,44,45,27,28,29,30,31,32)

ORDER BY lastpost DESC
1SIMPLEthreadindexforumidlastpost6 23Using where

Time Before: 0.17771 seconds
Time After: 0.17837 seconds
Time Taken: 0.00066 seconds

Finished processing module: Most Recent Topics

Time Before: 0.30876400
Time After:0.33027400
Time Taken: 0.02151

Processing Module: News Archive
Finished processing module: News Archive

Time Before: 0.33030400
Time After:0.33156700
Time Taken: 0.001263

Processing Module: Welcome Block
Finished processing module: Welcome Block

Time Before: 0.33158700
Time After:0.33272900
Time Taken: 0.001142

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 > 1521565862
ORDER BY invisible ASC, username ASC
1SIMPLEsessionALL    223Using where; Using temporary; Using filesort

Time Before: 0.20144 seconds
Time After: 0.20202 seconds
Time Taken: 0.00058 seconds

Finished processing module: Online Users

Time Before: 0.33276600
Time After:0.33512900
Time Taken: 0.002363

Processing Module: Current Poll
SQL Query
SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public 
FROM poll AS poll
INNER JOIN thread AS thread USING (pollid)

WHERE open <> 10 AND visible = 1 AND active = 1

ORDER BY poll.dateline DESC
1SIMPLEpollALLPRIMARY   51Using where; Using filesort
1SIMPLEthreadrefpollidpollid4hscale.poll.pollid19Using where

Time Before: 0.20361 seconds
Time After: 0.20430 seconds
Time Taken: 0.00068 seconds

Finished processing module: Current Poll

Time Before: 0.33515500
Time After:0.33968900
Time Taken: 0.004534

Processing Module: Top Posters
SQL Query
1SIMPLEuserindex posts4 5 

Time Before: 0.20774 seconds
Time After: 0.20812 seconds
Time Taken: 0.00037 seconds

Finished processing module: Top Posters

Time Before: 0.33971100
Time After:0.34106400
Time Taken: 0.001353

Processing Module: Mini Calendar
Finished processing module: Mini Calendar

Time Before: 0.34108500
Time After:0.34996900
Time Taken: 0.008884

Processing Module: Today's Birthdays
Finished processing module: Today's Birthdays

Time Before: 0.35000500
Time After:0.35031700
Time Taken: 0.000312

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

Time Before: 0.21843 seconds
Time After: 0.21869 seconds
Time Taken: 0.00025 seconds

SQL Query
SELECT username, posts, userid FROM user ORDER BY posts DESC
1SIMPLEuserALL    2249Using filesort

Time Before: 0.21929 seconds
Time After: 0.22625 seconds
Time Taken: 0.00696 seconds

Finished processing module: Stats

Time Before: 0.35033500
Time After:0.35907400
Time Taken: 0.008739

End call of global.php: 0.227880954742
SQL Query
UPDATE session
SET lastactivity = 1521567662, location = '/index.php?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'bd7f57bfefc7d1f43f530feca1e1a175'

Time Before: 0.22952 seconds
Time After: 0.22995 seconds
Time Taken: 0.00043 seconds

Page generated in 0.228441953659 seconds with 21 queries, spending 0.0338213443756 doing MySQL queries and 0.194620609283 doing PHP things.
Shutdown Queries: