Including Functions.php

Time Before: 0.00136 seconds
Time After: 0.00189 seconds
Time Taken: 0.00053 seconds

Memory Before: 690.063 KB
Memory After: 698.023 KB
Memory Used: 7.961 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00195 seconds
Time After: 0.50683 seconds
Time Taken: 0.50489 seconds

Memory Before: 697.961 KB
Memory After: 698.875 KB
Memory Used: 0.914 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smiliecache','bbcodecache','mailqueue','bookmarksitecache')
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY52 18100.00Using where

Time Before: 0.52736 seconds
Time After: 0.53137 seconds
Time Taken: 0.00400 seconds

Memory Before: 701.875 KB
Memory After: 702.852 KB
Memory Used: 0.977 KB

Time Before: 0.52164 seconds
Time After: 0.53301 seconds
Time Taken: 0.01136 seconds

Memory Before: 698.578 KB
Memory After: 1,730.711 KB
Memory Used: 1,032.133 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('banemail','dbtech_vbsecurity_actions','dbtech_vbsecurity_watchers','vs_dfp_cache')
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY52 4100.00Using where

Time Before: 0.53705 seconds
Time After: 0.53756 seconds
Time Taken: 0.00050 seconds

Memory Before: 1,861.992 KB
Memory After: 1,862.516 KB
Memory Used: 0.523 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.227.76.35'
	AND idhash = '3845663ecfe919f5efc39ab4f16260b1'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refuserid,idhash,hostidhash34const15.00Using where

Time Before: 0.53906 seconds
Time After: 0.53971 seconds
Time Taken: 0.00066 seconds

Memory Before: 1,879.148 KB
Memory After: 1,879.750 KB
Memory Used: 0.602 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_postbit AS phrasegroup_postbit,
			phrasegroup_showthread AS phrasegroup_showthread,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
			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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLElanguage constPRIMARYPRIMARY2const1100.00 

Time Before: 0.54104 seconds
Time After: 0.54410 seconds
Time Taken: 0.00306 seconds

Memory Before: 1,890.484 KB
Memory After: 1,890.383 KB
Memory Used: -0.102 KB

Time Before: 0.53765 seconds
Time After: 0.54421 seconds
Time Taken: 0.00656 seconds

Memory Before: 1,873.977 KB
Memory After: 1,956.555 KB
Memory Used: 82.578 KB

SQL Query
SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*


FROM thread AS thread






WHERE thread.threadid = 131441
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEthread constPRIMARYPRIMARY4const1100.00 

Time Before: 0.54706 seconds
Time After: 0.54749 seconds
Time Taken: 0.00044 seconds

Memory Before: 2,142.789 KB
Memory After: 2,143.461 KB
Memory Used: 0.672 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 15 AND userselect = 1)
	OR styleid = 15
ORDER BY styleid ASC
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARY,userselectPRIMARY2const1100.00 

Time Before: 0.55761 seconds
Time After: 0.55890 seconds
Time Taken: 0.00130 seconds

Memory Before: 2,285.070 KB
Memory After: 2,285.656 KB
Memory Used: 0.586 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (31626,33201,33217,33209,33873,37121,34129,34137,34153,34209,34201,35561,35593,35481,35489,35505,35497,35521,35537,35545,35553,35569,35585,33377,33393,33409,33425,31547,31548,35849,18241,35833,35817,36401,36409,35425,35417,35433,35465,35449,36625,33697,33689,33705,33713,30960,31553,30955,33177,33169,33185,31634,33137,35353,30961,34969,34977,34985,37113,37137,37209,35137,35145,35153,35161,36745,31543,31544,37257,37281,30372,31557,31558,32601,32617,32625,32609,32633,32593,29195,29192,29193,29194)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 83100.00Using where

Time Before: 0.56140 seconds
Time After: 0.56274 seconds
Time Taken: 0.00133 seconds

Memory Before: 2,460.508 KB
Memory After: 2,462.484 KB
Memory Used: 1.977 KB

SQL Query
SELECT threadid, title, dateline, lastpost, visible, open, postusername, postuserid	  
FROM thread AS thread
WHERE NOT ISNULL(threadid) AND forumid IN (12,31,39,6,44,20,32,40,2,1,3,47,48,10,28,41,9,17,33,51) AND visible = '1' AND open!='10'

ORDER BY lastpost DESC
LIMIT 0, 5
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEthread indexPRIMARY,forumidlastpost6 581.00Using where

Time Before: 0.89417 seconds
Time After: 0.89499 seconds
Time Taken: 0.00082 seconds

Memory Before: 3,789.383 KB
Memory After: 3,790.023 KB
Memory Used: 0.641 KB

SQL Query
SELECT title FROM style WHERE styleid = '15'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

Time Before: 0.90123 seconds
Time After: 0.90598 seconds
Time Taken: 0.00475 seconds

Memory Before: 3,798.289 KB
Memory After: 3,798.883 KB
Memory Used: 0.594 KB

SQL Query
SELECT template
FROM template
WHERE templateid = 32569
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate constPRIMARYPRIMARY4const1100.00 

Time Before: 0.91407 seconds
Time After: 0.91441 seconds
Time Taken: 0.00034 seconds

Memory Before: 3,842.758 KB
Memory After: 3,843.328 KB
Memory Used: 0.570 KB

SQL Query
SELECT tkey,tval FROM vstargets WHERE userid = 0
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEvstargets refPRIMARYPRIMARY4const1100.00 

Time Before: 0.91603 seconds
Time After: 0.91645 seconds
Time Taken: 0.00042 seconds

Memory Before: 3,848.648 KB
Memory After: 3,849.195 KB
Memory Used: 0.547 KB

End call of global.php: 0.91672706604004
SQL Query
SELECT post.postid
FROM post AS post

WHERE post.threadid = 131441
	AND post.visible = 1
	
	
ORDER BY post.dateline 
LIMIT 0, 15
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEpost refthreadidthreadid4const16010.00Using index condition; Using where; Using filesort

Time Before: 0.91952 seconds
Time After: 0.92071 seconds
Time Taken: 0.00119 seconds

Memory Before: 4,155.883 KB
Memory After: 4,156.563 KB
Memory Used: 0.680 KB

SQL Query
SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
	postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
	attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
FROM attachment
LEFT JOIN attachmenttype AS attachmenttype USING (extension)
WHERE postid IN (-1,1028105,1028113,1028121,1028217,1028249,1028281,1076210,1076225,1076233,1076241,1076466,1076642,1076650,1077026,1077034)
ORDER BY attachmentid
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEattachment rangepostidpostid4 15100.00Using index condition; Using filesort
1SIMPLEattachmenttype eq_refPRIMARYPRIMARY22wings900_com.attachment.extension1100.00 

Time Before: 0.92220 seconds
Time After: 0.92322 seconds
Time Taken: 0.00102 seconds

Memory Before: 4,158.195 KB
Memory After: 4,158.406 KB
Memory Used: 0.211 KB

SQL Query
SELECT
	post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
	user.*, userfield.*, usertextfield.*,
	icon.title as icontitle, icon.iconpath,
	avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
	
	
	editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
	editlog.reason AS edit_reason, editlog.hashistory,
	postparsed.pagetext_html, postparsed.hasimages,
	sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
	sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
	, '' AS field2, '' AS field3, '' AS field4, '' AS field5, '' AS field6, '' AS field7, '' AS field8, '' AS field9, '' AS field11, '' AS field13, '' AS field14
	
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

	
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 15 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 15 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
	
WHERE post.postid IN (0,1028105,1028113,1028121,1028217,1028249,1028281,1076210,1076225,1076233,1076241,1076466,1076642,1076650,1077026,1077034)
ORDER BY post.dateline
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEpost rangePRIMARYPRIMARY4 16100.00Using where; Using temporary; Using filesort
1SIMPLEuser eq_refPRIMARYPRIMARY4wings900_com.post.userid1100.00 
1SIMPLEuserfield eq_refPRIMARYPRIMARY4wings900_com.user.userid1100.00 
1SIMPLEusertextfield eq_refPRIMARYPRIMARY4wings900_com.user.userid1100.00 
1SIMPLEicon eq_refPRIMARYPRIMARY2wings900_com.post.iconid1100.00 
1SIMPLEavatar eq_refPRIMARYPRIMARY2wings900_com.user.avatarid1100.00Using where
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4wings900_com.user.userid1100.00 
1SIMPLEeditlog eq_refPRIMARYPRIMARY4wings900_com.post.postid1100.00 
1SIMPLEpostparsed ALLPRIMARY   1100.00Using where; Using join buffer (Block Nested Loop)
1SIMPLEsigparsed eq_refPRIMARYPRIMARY8wings900_com.user.userid,const,const1100.00 
1SIMPLEsigpic eq_refPRIMARYPRIMARY4wings900_com.post.userid1100.00 

Time Before: 0.92637 seconds
Time After: 0.93054 seconds
Time Taken: 0.00417 seconds

Memory Before: 4,168.133 KB
Memory After: 4,183.609 KB
Memory Used: 15.477 KB

Time after parsing all posts: 0.97260999679565 Memory After: 5,037KB
SQL Query
SELECT * FROM viglink_link_insertion ORDER BY id DESC;
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEviglink_link_insertion index PRIMARY4 1100.00 

Time Before: 0.97469 seconds
Time After: 0.97508 seconds
Time Taken: 0.00039 seconds

Memory Before: 5,115.203 KB
Memory After: 5,115.781 KB
Memory Used: 0.578 KB

SQL Query
SELECT title FROM style WHERE styleid = '15'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

Time Before: 0.97704 seconds
Time After: 0.97737 seconds
Time Taken: 0.00033 seconds

Memory Before: 5,122.977 KB
Memory After: 5,123.563 KB
Memory Used: 0.586 KB

SQL Query
SELECT title FROM style WHERE styleid = '15'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

Time Before: 0.98644 seconds
Time After: 0.98695 seconds
Time Taken: 0.00051 seconds

Memory Before: 5,799.453 KB
Memory After: 5,800.039 KB
Memory Used: 0.586 KB

SQL Query
UPDATE session
SET lastactivity = 1558431822, location = '/vb/showthread.php?t=131441', inforum = 9, inthread = 131441, incalendar = 0, badlocation = 0
WHERE sessionhash = 'b5478e4511ce9388ed383ce5d3fd1308'

Time Before: 1.03112 seconds
Time After: 2.00900 seconds
Time Taken: 0.97788 seconds

Memory Before: 6,132.219 KB
Memory After: 6,132.414 KB
Memory Used: 0.195 KB

SQL Query
UPDATE thread
SET views = views + 1
WHERE threadid = 131441

Time Before: 2.00909 seconds
Time After: 2.02250 seconds
Time Taken: 0.01341 seconds

Memory Before: 6,126.438 KB
Memory After: 6,126.781 KB
Memory Used: 0.344 KB

Page generated in 0.97870588302612 seconds with 27 queries, spending 1.5312905311584 doing MySQL queries and -0.55258464813232 doing PHP things.
Shutdown Queries:
DISABLED