Including Functions.php

Time Before: 0.00588 seconds
Time After: 0.01517 seconds
Time Taken: 0.00929 seconds

Connect to Database on Server: 172.16.57.193

Time Before: 0.01523 seconds
Time After: 0.01740 seconds
Time Taken: 0.00216 seconds

SQL Query
SET @@sql_mode = ''

Time Before: 0.01773 seconds
Time After: 0.01787 seconds
Time Taken: 0.00014 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.01842 seconds
Time After: 0.01986 seconds
Time Taken: 0.00144 seconds

Time Before: 0.01792 seconds
Time After: 0.02172 seconds
Time Taken: 0.00381 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.02248 seconds
Time After: 0.02285 seconds
Time Taken: 0.00037 seconds

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.198.52.82'
	AND idhash = '0c5802ff5a3e097f9e4d6bb18c71edc5'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    314Using where

Time Before: 0.02358 seconds
Time After: 0.02383 seconds
Time Taken: 0.00025 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.02491 seconds
Time Taken: 0.00047 seconds

Time Before: 0.02312 seconds
Time After: 0.02503 seconds
Time Taken: 0.00192 seconds

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

Time Before: 0.02720 seconds
Time After: 0.02747 seconds
Time Taken: 0.00027 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.02833 seconds
Time After: 0.02878 seconds
Time Taken: 0.00045 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.02993 seconds
Time After: 0.03071 seconds
Time Taken: 0.00078 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.04290 seconds
Time After: 0.04332 seconds
Time Taken: 0.00042 seconds

Processing Module: Site Navigation
Finished processing module: Site Navigation

Time Before: 0.40218000
Time After:0.40291600
Time Taken: 0.000736

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

Time Before: 0.40294000
Time After:0.40953400
Time Taken: 0.006594

Processing Module: Search Forums
Finished processing module: Search Forums

Time Before: 0.40955300
Time After:0.40981900
Time Taken: 0.000266

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.05509 seconds
Time After: 0.05552 seconds
Time Taken: 0.00043 seconds

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

Time Before: 0.05583 seconds
Time After: 0.05601 seconds
Time Taken: 0.00018 seconds

Finished processing module: Random Member

Time Before: 0.40983400
Time After:0.41270500
Time Taken: 0.002871

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

Time Before: 0.05763 seconds
Time After: 0.05782 seconds
Time Taken: 0.00020 seconds

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

Time Before: 0.05820 seconds
Time After: 0.05840 seconds
Time Taken: 0.00019 seconds

Finished processing module: Download

Time Before: 0.41272300
Time After:0.41534500
Time Taken: 0.002622

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

Time Before: 0.41536300
Time After:0.47362200
Time Taken: 0.058259

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

Time Before: 0.47364400
Time After:0.47366100
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.47367200
Time After:0.47793000
Time Taken: 0.004258

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.12270 seconds
Time After: 0.12329 seconds
Time Taken: 0.00059 seconds

Finished processing module: Most Recent Topics

Time Before: 0.47794800
Time After:0.49442900
Time Taken: 0.016481

Processing Module: News Archive
Finished processing module: News Archive

Time Before: 0.49444800
Time After:0.49537600
Time Taken: 0.000928

Processing Module: Welcome Block
Finished processing module: Welcome Block

Time Before: 0.49539100
Time After:0.49634600
Time Taken: 0.000955

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

Time Before: 0.14088 seconds
Time After: 0.14136 seconds
Time Taken: 0.00048 seconds

Finished processing module: Online Users

Time Before: 0.49637500
Time After:0.49827700
Time Taken: 0.001902

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.14265 seconds
Time After: 0.14322 seconds
Time Taken: 0.00057 seconds

Finished processing module: Current Poll

Time Before: 0.49829300
Time After:0.50201600
Time Taken: 0.003723

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.14607 seconds
Time After: 0.14640 seconds
Time Taken: 0.00033 seconds

Finished processing module: Top Posters

Time Before: 0.50203200
Time After:0.50319500
Time Taken: 0.001163

Processing Module: Mini Calendar
Finished processing module: Mini Calendar

Time Before: 0.50321100
Time After:0.50912200
Time Taken: 0.005911

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

Time Before: 0.50914900
Time After:0.50940300
Time Taken: 0.000254

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

Time Before: 0.15349 seconds
Time After: 0.15376 seconds
Time Taken: 0.00026 seconds

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

Time Before: 0.15421 seconds
Time After: 0.15817 seconds
Time Taken: 0.00396 seconds

Finished processing module: Stats

Time Before: 0.50941800
Time After:0.51483800
Time Taken: 0.00542

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

Time Before: 0.16114 seconds
Time After: 0.16137 seconds
Time Taken: 0.00023 seconds

Page generated in 0.160139083862 seconds with 21 queries, spending 0.0144002437592 doing MySQL queries and 0.145738840103 doing PHP things.
Shutdown Queries:
DISABLED