Including Functions.php

Time Before: 0.00590 seconds
Time After: 0.01514 seconds
Time Taken: 0.00923 seconds

Connect to Database on Server: 172.16.57.193

Time Before: 0.01520 seconds
Time After: 0.01782 seconds
Time Taken: 0.00261 seconds

SQL Query
SET @@sql_mode = ''

Time Before: 0.01853 seconds
Time After: 0.01875 seconds
Time Taken: 0.00022 seconds

Datastore Setup
SQL Query
SELECT *
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')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 24Using index condition

Time Before: 0.02028 seconds
Time After: 0.02189 seconds
Time Taken: 0.00162 seconds

Time Before: 0.01886 seconds
Time After: 0.02401 seconds
Time Taken: 0.00516 seconds

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

Time Before: 0.02498 seconds
Time After: 0.02539 seconds
Time Taken: 0.00041 seconds

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.198.125.25'
	AND idhash = '56fab75a822ec2b541671a4621859076'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    556Using where

Time Before: 0.02615 seconds
Time After: 0.02646 seconds
Time Taken: 0.00031 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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguagesystemPRIMARY   1 

Time Before: 0.02718 seconds
Time After: 0.02786 seconds
Time Taken: 0.00069 seconds

Time Before: 0.02565 seconds
Time After: 0.02798 seconds
Time Taken: 0.00232 seconds

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

Time Before: 0.03021 seconds
Time After: 0.03055 seconds
Time Taken: 0.00035 seconds

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

Time Before: 0.03153 seconds
Time After: 0.03206 seconds
Time Taken: 0.00053 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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 78Using index condition

Time Before: 0.03353 seconds
Time After: 0.03502 seconds
Time Taken: 0.00149 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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmoderatorALLuserid   77 
1SIMPLEusereq_refPRIMARYPRIMARY4hscale.moderator.userid1 

Time Before: 0.05012 seconds
Time After: 0.05070 seconds
Time Taken: 0.00058 seconds

Processing Module: Site Navigation
Finished processing module: Site Navigation

Time Before: 0.63935700
Time After:0.64024700
Time Taken: 0.00089

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

Time Before: 0.64027200
Time After:0.65242800
Time Taken: 0.012156

Processing Module: Search Forums
Finished processing module: Search Forums

Time Before: 0.65244900
Time After:0.65277300
Time Taken: 0.000324

Processing Module: Random Member
SQL Query
SELECT userid, dateline, height, width
FROM customavatar
ORDER BY RAND() LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcustomavatarALL    150Using temporary; Using filesort

Time Before: 0.06932 seconds
Time After: 0.06987 seconds
Time Taken: 0.00054 seconds

SQL Query
SELECT profilepicrevision,username, joindate,usertitle
FROM user
WHERE userid = 874
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 

Time Before: 0.07030 seconds
Time After: 0.07046 seconds
Time Taken: 0.00017 seconds

Finished processing module: Random Member

Time Before: 0.65279000
Time After:0.65641600
Time Taken: 0.003626

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

Time Before: 0.07227 seconds
Time After: 0.07245 seconds
Time Taken: 0.00018 seconds

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

Time Before: 0.07310 seconds
Time After: 0.07332 seconds
Time Taken: 0.00022 seconds

Finished processing module: Download

Time Before: 0.65643600
Time After:0.65958000
Time Taken: 0.003144

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

Time Before: 0.65960000
Time After:0.73074800
Time Taken: 0.071148

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

Time Before: 0.73077200
Time After:0.73079200
Time Taken: 2E-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.73080400
Time After:0.73746800
Time Taken: 0.006664

Processing Module: Most Recent Topics
SQL Query
SELECT

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
LIMIT 20
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadindexforumidlastpost6 23Using where
1SIMPLEposteq_refPRIMARYPRIMARY4hscale.thread.firstpostid1 

Time Before: 0.15317 seconds
Time After: 0.15397 seconds
Time Taken: 0.00081 seconds

Finished processing module: Most Recent Topics

Time Before: 0.73748600
Time After:0.75576400
Time Taken: 0.018278

Processing Module: News Archive
Finished processing module: News Archive

Time Before: 0.75578200
Time After:0.75672000
Time Taken: 0.000938

Processing Module: Welcome Block
Finished processing module: Welcome Block

Time Before: 0.75673600
Time After:0.75914800
Time Taken: 0.002412

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 > 1542050013
ORDER BY invisible ASC, username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    556Using where; Using temporary; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4hscale.session.userid1 

Time Before: 0.17544 seconds
Time After: 0.17598 seconds
Time Taken: 0.00053 seconds

Finished processing module: Online Users

Time Before: 0.75922500
Time After:0.76213500
Time Taken: 0.00291

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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpollALLPRIMARY   51Using where; Using filesort
1SIMPLEthreadrefpollidpollid4hscale.poll.pollid19Using where

Time Before: 0.17754 seconds
Time After: 0.17885 seconds
Time Taken: 0.00131 seconds

Finished processing module: Current Poll

Time Before: 0.76215200
Time After:0.76688100
Time Taken: 0.004729

Processing Module: Top Posters
SQL Query
SELECT * FROM user ORDER BY posts DESC LIMIT 5
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserindex posts4 5 

Time Before: 0.18220 seconds
Time After: 0.18377 seconds
Time Taken: 0.00157 seconds

Finished processing module: Top Posters

Time Before: 0.76689900
Time After:0.76998400
Time Taken: 0.003085

Processing Module: Mini Calendar
Finished processing module: Mini Calendar

Time Before: 0.77000200
Time After:0.77623500
Time Taken: 0.006233

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

Time Before: 0.77629200
Time After:0.77656500
Time Taken: 0.000273

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

Time Before: 0.19214 seconds
Time After: 0.19252 seconds
Time Taken: 0.00038 seconds

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

Time Before: 0.19302 seconds
Time After: 0.21829 seconds
Time Taken: 0.02528 seconds

Finished processing module: Stats

Time Before: 0.77658200
Time After:0.80425400
Time Taken: 0.027672

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

Time Before: 0.22197 seconds
Time After: 0.22660 seconds
Time Taken: 0.00462 seconds

Page generated in 0.220742940903 seconds with 21 queries, spending 0.0446128845215 doing MySQL queries and 0.176130056381 doing PHP things.
Shutdown Queries:
DISABLED