Including Functions.php

Time Before: 0.00584 seconds
Time After: 0.01513 seconds
Time Taken: 0.00928 seconds

Connect to Database on Server: 172.16.57.193

Time Before: 0.01519 seconds
Time After: 0.01735 seconds
Time Taken: 0.00216 seconds

SQL Query
SET @@sql_mode = ''

Time Before: 0.01767 seconds
Time After: 0.01783 seconds
Time Taken: 0.00016 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.01857 seconds
Time After: 0.01982 seconds
Time Taken: 0.00126 seconds

Time Before: 0.01786 seconds
Time After: 0.02163 seconds
Time Taken: 0.00377 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.02242 seconds
Time After: 0.02267 seconds
Time Taken: 0.00026 seconds

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.227.127.109'
	AND idhash = '16b36dfa0e42514118d1efb07c938e17'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    428Using where

Time Before: 0.02351 seconds
Time After: 0.02379 seconds
Time Taken: 0.00028 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.02444 seconds
Time After: 0.02503 seconds
Time Taken: 0.00059 seconds

Time Before: 0.02299 seconds
Time After: 0.02517 seconds
Time Taken: 0.00218 seconds

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

Time Before: 0.02737 seconds
Time After: 0.02758 seconds
Time Taken: 0.00021 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.02838 seconds
Time After: 0.02871 seconds
Time Taken: 0.00034 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.02986 seconds
Time After: 0.03058 seconds
Time Taken: 0.00072 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.04289 seconds
Time After: 0.04334 seconds
Time Taken: 0.00045 seconds

Processing Module: Site Navigation
Finished processing module: Site Navigation

Time Before: 0.99822000
Time After:0.99892300
Time Taken: 0.000703

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

Time Before: 0.99894200
Time After:0.00582200
Time Taken: -0.99312

Processing Module: Search Forums
Finished processing module: Search Forums

Time Before: 0.00583900
Time After:0.00608600
Time Taken: 0.000247

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.05548 seconds
Time After: 0.05583 seconds
Time Taken: 0.00036 seconds

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

Time Before: 0.05615 seconds
Time After: 0.05637 seconds
Time Taken: 0.00022 seconds

Finished processing module: Random Member

Time Before: 0.00610000
Time After:0.00903400
Time Taken: 0.002934

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

Time Before: 0.05804 seconds
Time After: 0.05828 seconds
Time Taken: 0.00024 seconds

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

Time Before: 0.05864 seconds
Time After: 0.05881 seconds
Time Taken: 0.00017 seconds

Finished processing module: Download

Time Before: 0.00905000
Time After:0.01183300
Time Taken: 0.002783

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

Time Before: 0.01184900
Time After:0.06896100
Time Taken: 0.057112

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

Time Before: 0.06898200
Time After:0.06899900
Time Taken: 1.7E-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.06901000
Time After:0.07299700
Time Taken: 0.003987

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.12178 seconds
Time After: 0.12229 seconds
Time Taken: 0.00051 seconds

Finished processing module: Most Recent Topics

Time Before: 0.07302000
Time After:0.09073800
Time Taken: 0.017718

Processing Module: News Archive
Finished processing module: News Archive

Time Before: 0.09075900
Time After:0.09195600
Time Taken: 0.001197

Processing Module: Welcome Block
Finished processing module: Welcome Block

Time Before: 0.09197700
Time After:0.09314200
Time Taken: 0.001165

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

Time Before: 0.14447 seconds
Time After: 0.14493 seconds
Time Taken: 0.00046 seconds

Finished processing module: Online Users

Time Before: 0.09317400
Time After:0.09788800
Time Taken: 0.004714

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.14641 seconds
Time After: 0.14694 seconds
Time Taken: 0.00053 seconds

Finished processing module: Current Poll

Time Before: 0.09790600
Time After:0.10188500
Time Taken: 0.003979

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.15001 seconds
Time After: 0.15031 seconds
Time Taken: 0.00030 seconds

Finished processing module: Top Posters

Time Before: 0.10190300
Time After:0.10310400
Time Taken: 0.001201

Processing Module: Mini Calendar
Finished processing module: Mini Calendar

Time Before: 0.10312100
Time After:0.10909300
Time Taken: 0.005972

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

Time Before: 0.10912100
Time After:0.10941300
Time Taken: 0.000292

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

Time Before: 0.15753 seconds
Time After: 0.15774 seconds
Time Taken: 0.00022 seconds

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

Time Before: 0.15815 seconds
Time After: 0.16190 seconds
Time Taken: 0.00375 seconds

Finished processing module: Stats

Time Before: 0.10943300
Time After:0.11456000
Time Taken: 0.005127

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

Time Before: 0.16470 seconds
Time After: 0.16494 seconds
Time Taken: 0.00024 seconds

Page generated in 0.163734912872 seconds with 21 queries, spending 0.0135741233826 doing MySQL queries and 0.15016078949 doing PHP things.
Shutdown Queries:
DISABLED