Including Functions.php

Time Before: 0.00620 seconds
Time After: 0.01572 seconds
Time Taken: 0.00952 seconds

Connect to Database on Server: 172.16.57.193

Time Before: 0.01579 seconds
Time After: 0.01808 seconds
Time Taken: 0.00229 seconds

SQL Query
SET @@sql_mode = ''

Time Before: 0.01838 seconds
Time After: 0.01856 seconds
Time Taken: 0.00017 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.01918 seconds
Time After: 0.02098 seconds
Time Taken: 0.00181 seconds

Time Before: 0.01859 seconds
Time After: 0.02337 seconds
Time Taken: 0.00478 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.02425 seconds
Time After: 0.02456 seconds
Time Taken: 0.00031 seconds

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.81.68.240'
	AND idhash = '60c59d8f63a2818d332f2820c031c826'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    307Using where

Time Before: 0.02537 seconds
Time After: 0.02565 seconds
Time Taken: 0.00029 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.02636 seconds
Time After: 0.02691 seconds
Time Taken: 0.00055 seconds

Time Before: 0.02480 seconds
Time After: 0.02703 seconds
Time Taken: 0.00223 seconds

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

Time Before: 0.02951 seconds
Time After: 0.02980 seconds
Time Taken: 0.00029 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.03072 seconds
Time After: 0.03119 seconds
Time Taken: 0.00048 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.03254 seconds
Time After: 0.03364 seconds
Time Taken: 0.00110 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.04651 seconds
Time After: 0.04698 seconds
Time Taken: 0.00047 seconds

Processing Module: Site Navigation
Finished processing module: Site Navigation

Time Before: 0.71644800
Time After:0.71722100
Time Taken: 0.000773

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

Time Before: 0.71724100
Time After:0.72409500
Time Taken: 0.006854

Processing Module: Search Forums
Finished processing module: Search Forums

Time Before: 0.72411200
Time After:0.72438900
Time Taken: 0.000277

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.05915 seconds
Time After: 0.05964 seconds
Time Taken: 0.00049 seconds

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

Time Before: 0.05996 seconds
Time After: 0.06016 seconds
Time Taken: 0.00020 seconds

Finished processing module: Random Member

Time Before: 0.72440500
Time After:0.72759500
Time Taken: 0.00319

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

Time Before: 0.06199 seconds
Time After: 0.06226 seconds
Time Taken: 0.00027 seconds

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

Time Before: 0.06260 seconds
Time After: 0.06278 seconds
Time Taken: 0.00018 seconds

Finished processing module: Download

Time Before: 0.72761200
Time After:0.73041900
Time Taken: 0.002807

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

Time Before: 0.73043500
Time After:0.79423100
Time Taken: 0.063796

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

Time Before: 0.79425700
Time After:0.79428000
Time Taken: 2.3E-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.79429400
Time After:0.79899600
Time Taken: 0.004702

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.13328 seconds
Time After: 0.13389 seconds
Time Taken: 0.00060 seconds

Finished processing module: Most Recent Topics

Time Before: 0.79901900
Time After:0.81846800
Time Taken: 0.019449

Processing Module: News Archive
Finished processing module: News Archive

Time Before: 0.81848900
Time After:0.81963100
Time Taken: 0.001142

Processing Module: Welcome Block
Finished processing module: Welcome Block

Time Before: 0.81964900
Time After:0.82074200
Time Taken: 0.001093

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

Time Before: 0.15480 seconds
Time After: 0.15521 seconds
Time Taken: 0.00042 seconds

Finished processing module: Online Users

Time Before: 0.82077600
Time After:0.82274000
Time Taken: 0.001964

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.15655 seconds
Time After: 0.15718 seconds
Time Taken: 0.00063 seconds

Finished processing module: Current Poll

Time Before: 0.82275800
Time After:0.82692600
Time Taken: 0.004168

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.16039 seconds
Time After: 0.16072 seconds
Time Taken: 0.00034 seconds

Finished processing module: Top Posters

Time Before: 0.82694400
Time After:0.82820800
Time Taken: 0.001264

Processing Module: Mini Calendar
Finished processing module: Mini Calendar

Time Before: 0.82822500
Time After:0.83492300
Time Taken: 0.006698

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

Time Before: 0.83495300
Time After:0.83531100
Time Taken: 0.000358

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

Time Before: 0.16886 seconds
Time After: 0.16912 seconds
Time Taken: 0.00026 seconds

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

Time Before: 0.16962 seconds
Time After: 0.17369 seconds
Time Taken: 0.00407 seconds

Finished processing module: Stats

Time Before: 0.83533000
Time After:0.84113500
Time Taken: 0.005805

End call of global.php: 0.175259113312
SQL Query
INSERT IGNORE INTO session
	(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
	('9132787fff28f9906b9a5c745f516769', 0, '54.81.68.240', '60c59d8f63a2818d332f2820c031c826', 1527391075, '/index.php?explain=1', 0, 0, 0, 0, 0, 0, 0, 'CCBot/2.0 (http://commoncrawl.org/faq/)', 0, 0)

Time Before: 0.17676 seconds
Time After: 0.17698 seconds
Time Taken: 0.00021 seconds

Page generated in 0.175791025162 seconds with 21 queries, spending 0.0156002044678 doing MySQL queries and 0.160190820694 doing PHP things.
Shutdown Queries:
DISABLED