Including Functions.php

Time Before: 0.00597 seconds
Time After: 0.01535 seconds
Time Taken: 0.00938 seconds

Connect to Database on Server: 172.16.57.193

Time Before: 0.01541 seconds
Time After: 0.01765 seconds
Time Taken: 0.00223 seconds

SQL Query
SET @@sql_mode = ''

Time Before: 0.01791 seconds
Time After: 0.01810 seconds
Time Taken: 0.00019 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.01867 seconds
Time After: 0.01971 seconds
Time Taken: 0.00104 seconds

Time Before: 0.01814 seconds
Time After: 0.02192 seconds
Time Taken: 0.00378 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.02282 seconds
Time After: 0.02311 seconds
Time Taken: 0.00028 seconds

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.198.170.159'
	AND idhash = 'e5db426d40ac4168fb7f5bef587e0452'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    265Using where

Time Before: 0.02385 seconds
Time After: 0.02414 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.02478 seconds
Time After: 0.02533 seconds
Time Taken: 0.00055 seconds

Time Before: 0.02334 seconds
Time After: 0.02546 seconds
Time Taken: 0.00212 seconds

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

Time Before: 0.02783 seconds
Time After: 0.02806 seconds
Time Taken: 0.00023 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.02896 seconds
Time After: 0.02934 seconds
Time Taken: 0.00038 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.03066 seconds
Time After: 0.03157 seconds
Time Taken: 0.00091 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.04553 seconds
Time After: 0.04596 seconds
Time Taken: 0.00043 seconds

Processing Module: Site Navigation
Finished processing module: Site Navigation

Time Before: 0.88974100
Time After:0.89043600
Time Taken: 0.000695

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

Time Before: 0.89045700
Time After:0.89800700
Time Taken: 0.00755

Processing Module: Search Forums
Finished processing module: Search Forums

Time Before: 0.89802400
Time After:0.89843700
Time Taken: 0.000413

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.05884 seconds
Time After: 0.05923 seconds
Time Taken: 0.00039 seconds

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

Time Before: 0.05971 seconds
Time After: 0.05990 seconds
Time Taken: 0.00020 seconds

Finished processing module: Random Member

Time Before: 0.89845100
Time After:0.90145300
Time Taken: 0.003002

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

Time Before: 0.06152 seconds
Time After: 0.06171 seconds
Time Taken: 0.00019 seconds

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

Time Before: 0.06207 seconds
Time After: 0.06226 seconds
Time Taken: 0.00018 seconds

Finished processing module: Download

Time Before: 0.90146900
Time After:0.90397600
Time Taken: 0.002507

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

Time Before: 0.90399200
Time After:0.97449600
Time Taken: 0.070504

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

Time Before: 0.97451800
Time After:0.97453600
Time Taken: 1.8E-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.97454800
Time After:0.97906800
Time Taken: 0.00452

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.13906 seconds
Time After: 0.13968 seconds
Time Taken: 0.00062 seconds

Finished processing module: Most Recent Topics

Time Before: 0.97908600
Time After:0.99614900
Time Taken: 0.017063

Processing Module: News Archive
Finished processing module: News Archive

Time Before: 0.99616900
Time After:0.99714100
Time Taken: 0.000972

Processing Module: Welcome Block
Finished processing module: Welcome Block

Time Before: 0.99715700
Time After:0.99816000
Time Taken: 0.001003

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

Time Before: 0.15795 seconds
Time After: 0.15853 seconds
Time Taken: 0.00059 seconds

Finished processing module: Online Users

Time Before: 0.99819100
Time After:0.00034800
Time Taken: -0.997843

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.15996 seconds
Time After: 0.16059 seconds
Time Taken: 0.00063 seconds

Finished processing module: Current Poll

Time Before: 0.00036400
Time After:0.00421300
Time Taken: 0.003849

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.16345 seconds
Time After: 0.16379 seconds
Time Taken: 0.00034 seconds

Finished processing module: Top Posters

Time Before: 0.00423000
Time After:0.00542300
Time Taken: 0.001193

Processing Module: Mini Calendar
Finished processing module: Mini Calendar

Time Before: 0.00544000
Time After:0.01109500
Time Taken: 0.005655

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

Time Before: 0.01112300
Time After:0.01161600
Time Taken: 0.000493

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

Time Before: 0.17103 seconds
Time After: 0.17128 seconds
Time Taken: 0.00025 seconds

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

Time Before: 0.17176 seconds
Time After: 0.17638 seconds
Time Taken: 0.00462 seconds

Finished processing module: Stats

Time Before: 0.01165300
Time After:0.01794600
Time Taken: 0.006293

End call of global.php: 0.178230047226
SQL Query
INSERT IGNORE INTO session
	(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
	('587ea343d4018ba925ffd3cec5fa9727', 0, '54.198.170.159', 'e5db426d40ac4168fb7f5bef587e0452', 1531840726, '/index.php?explain=1', 0, 0, 0, 0, 0, 0, 0, 'CCBot/2.0 (http://commoncrawl.org/faq/)', 0, 0)

Time Before: 0.17988 seconds
Time After: 0.18011 seconds
Time Taken: 0.00024 seconds

Page generated in 0.178788900375 seconds with 21 queries, spending 0.0150227546692 doing MySQL queries and 0.163766145706 doing PHP things.
Shutdown Queries:
DISABLED