Including Functions.php

Time Before: 0.04042 seconds
Time After: 0.05649 seconds
Time Taken: 0.01607 seconds

Memory Before: 2,925.695 KB
Memory After: 4,875.633 KB
Memory Used: 1,949.938 KB

Connect to Database on Server: devskunkworksdb1.internetbrands.com

Time Before: 0.05673 seconds
Time After: 0.05849 seconds
Time Taken: 0.00176 seconds

Memory Before: 4,878.227 KB
Memory After: 4,880.719 KB
Memory Used: 2.492 KB

Datastore Setup
SQL Query
SELECT *
FROM sw_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smiliecache','bbcodecache','mailqueue','bookmarksitecache')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsw_datastorerangePRIMARYPRIMARY50 18Using where

Time Before: 0.06082 seconds
Time After: 0.06644 seconds
Time Taken: 0.00562 seconds

Memory Before: 4,891.742 KB
Memory After: 4,891.844 KB
Memory Used: 0.102 KB

Time Before: 0.05919 seconds
Time After: 0.06823 seconds
Time Taken: 0.00904 seconds

Memory Before: 4,881.703 KB
Memory After: 5,320.344 KB
Memory Used: 438.641 KB

Session Handling
SQL Query
SELECT *
FROM sw_session
WHERE userid = 0
	AND host = '172.16.247.5'
	AND idhash = '3352b39f30318a601a5970f1bf69768c'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsw_sessionALL    249Using where

Time Before: 0.08357 seconds
Time After: 0.08425 seconds
Time Taken: 0.00069 seconds

Memory Before: 5,814.320 KB
Memory After: 5,814.422 KB
Memory Used: 0.102 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_vbnexus AS phrasegroup_vbnexus,
			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 sw_language
WHERE languageid = 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsw_languagesystemPRIMARY   1 

Time Before: 0.08589 seconds
Time After: 0.08723 seconds
Time Taken: 0.00134 seconds

Memory Before: 5,824.453 KB
Memory After: 5,823.688 KB
Memory Used: -0.766 KB

Time Before: 0.08250 seconds
Time After: 0.08780 seconds
Time Taken: 0.00530 seconds

Memory Before: 5,804.273 KB
Memory After: 5,877.203 KB
Memory Used: 72.930 KB

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


editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory

FROM sw_post AS post

LEFT JOIN sw_editlog AS editlog ON (editlog.postid = post.postid)

WHERE post.postid = 450
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostconstPRIMARYPRIMARY4const1 
1SIMPLEeditlogconstPRIMARYPRIMARY4const0unique row not found

Time Before: 0.09249 seconds
Time After: 0.09298 seconds
Time Taken: 0.00049 seconds

Memory Before: 5,946.242 KB
Memory After: 5,946.344 KB
Memory Used: 0.102 KB

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



thread.*


FROM sw_thread AS thread






WHERE thread.threadid = 153
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadconstPRIMARYPRIMARY4const1 

Time Before: 0.09432 seconds
Time After: 0.09478 seconds
Time Taken: 0.00046 seconds

Memory Before: 5,950.672 KB
Memory After: 5,951.266 KB
Memory Used: 0.594 KB

SQL Query
SELECT *
FROM sw_style
WHERE (styleid = 1 AND userselect = 1)
	OR styleid = 1
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsw_styleconstPRIMARYPRIMARY2const1 

Time Before: 0.09593 seconds
Time After: 0.09672 seconds
Time Taken: 0.00080 seconds

Memory Before: 5,956.125 KB
Memory After: 5,956.711 KB
Memory Used: 0.586 KB

SQL Query
SELECT title, template
FROM sw_template
WHERE templateid IN (623,624,626,625,708,1114,740,741,743,750,749,908,923,909,910,912,911,914,916,917,918,920,922,646,648,650,652,950,952,955,956,953,951,1024,1025,902,901,903,907,905,1052,686,685,687,688,1135,1112,1118,621,620,622,617,616,893,844,845,846,847,1113,1116,1125,866,867,868,869,1067,1130,1129,1131,1134,1194)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsw_templaterangePRIMARYPRIMARY4 71Using where

Time Before: 0.09887 seconds
Time After: 0.10099 seconds
Time Taken: 0.00212 seconds

Memory Before: 6,109.398 KB
Memory After: 6,109.500 KB
Memory Used: 0.102 KB

SQL Query
SELECT * FROM sw_superpm_users WHERE userid = '0'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.10517 seconds
Time After: 0.10555 seconds
Time Taken: 0.00038 seconds

Memory Before: 6,254.898 KB
Memory After: 6,255.477 KB
Memory Used: 0.578 KB

SQL Query
UPDATE sw_session
SET lastactivity = 1283756057, location = '/vbnexus/showthread.php?p=450&explain=1'
WHERE sessionhash = '12f7869dc794008316cb1121188bc006'

Time Before: 0.12403 seconds
Time After: 0.12451 seconds
Time Taken: 0.00048 seconds

Memory Before: 6,824.875 KB
Memory After: 6,825.516 KB
Memory Used: 0.641 KB

Page generated in 0.11905407905579 seconds with 9 queries, spending 0.014135837554932 doing MySQL queries and 0.10491824150085 doing PHP things.
Shutdown Queries:
DISABLED