Including Functions.php

Time Before: 0.00075 seconds
Time After: 0.00085 seconds
Time Taken: 0.00010 seconds

Memory Before: 425.750 KB
Memory After: 435.805 KB
Memory Used: 10.055 KB

Connect to Database on Server: localhost

Time Before: 0.00091 seconds
Time After: 0.04666 seconds
Time Taken: 0.04575 seconds

Memory Before: 435.742 KB
Memory After: 436.656 KB
Memory Used: 0.914 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('attachmentcache','cron','profilefield','loadcache','noticecache','tagcloud','iconcache')
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY52 7100.00Using index condition

Time Before: 0.06390 seconds
Time After: 0.07070 seconds
Time Taken: 0.00680 seconds

Memory Before: 933.211 KB
Memory After: 934.016 KB
Memory Used: 0.805 KB

Time Before: 0.05157 seconds
Time After: 0.07084 seconds
Time Taken: 0.01927 seconds

Memory Before: 436.359 KB
Memory After: 965.055 KB
Memory Used: 528.695 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE sessionhash = 'afe0cd8147010ba4c54be8e34442736b'
	AND lastactivity > 1718306395
	AND idhash = 'dbfb2ef7083464d940e6f4ce4e878845'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

Time Before: 0.08831 seconds
Time After: 0.09644 seconds
Time Taken: 0.00813 seconds

Memory Before: 982.234 KB
Memory After: 982.648 KB
Memory Used: 0.414 KB

SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '18.118.142.60'
	AND idhash = 'dbfb2ef7083464d940e6f4ce4e878845'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession ALL    241920.10Using where

Time Before: 0.10162 seconds
Time After: 0.10508 seconds
Time Taken: 0.00346 seconds

Memory Before: 983.102 KB
Memory After: 983.539 KB
Memory Used: 0.438 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_search AS phrasegroup_search,
			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 systemPRIMARY   1100.00 

Time Before: 0.11236 seconds
Time After: 0.11497 seconds
Time Taken: 0.00261 seconds

Memory Before: 994.750 KB
Memory After: 994.797 KB
Memory Used: 0.047 KB

Time Before: 0.07098 seconds
Time After: 0.11508 seconds
Time Taken: 0.04410 seconds

Memory Before: 976.891 KB
Memory After: 1,037.484 KB
Memory Used: 60.594 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 5 AND userselect = 1)
	OR styleid = 5
ORDER BY styleid ASC
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

Time Before: 0.13792 seconds
Time After: 0.15160 seconds
Time Taken: 0.01369 seconds

Memory Before: 1,170.672 KB
Memory After: 1,171.258 KB
Memory Used: 0.586 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (18819,18838,18848,10350,7917,14226,18406,18405,18407,18402,18401,18678,14225,7055,18631,18632,18898,18901,18910,18651,18652,18653,18654,18852,18915,18914,18916,18919,18925)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 29100.00Using index condition

Time Before: 0.18597 seconds
Time After: 0.19257 seconds
Time Taken: 0.00661 seconds

Memory Before: 1,350.750 KB
Memory After: 1,351.789 KB
Memory Used: 1.039 KB

End call of global.php: 0.25063610076904
SQL Query
SELECT *
FROM tag
WHERE tagtext = 'data'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtag consttagtexttagtext302const1100.00 

Time Before: 0.27109 seconds
Time After: 0.27130 seconds
Time Taken: 0.00021 seconds

Memory Before: 1,497.797 KB
Memory After: 1,498.383 KB
Memory Used: 0.586 KB

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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEmoderator ALLuserid_forumid   40100.00 
1SIMPLEuser eq_refPRIMARYPRIMARY4psfantasy-forums.moderator.userid1100.00 

Time Before: 0.30507 seconds
Time After: 0.30925 seconds
Time Taken: 0.00418 seconds

Memory Before: 1,511.133 KB
Memory After: 1,514.336 KB
Memory Used: 3.203 KB

SQL Query
SELECT thread.threadid, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views
FROM thread AS thread
INNER JOIN tagthread AS tagthread ON
	(tagthread.tagid = 7 AND tagthread.threadid = thread.threadid)


WHERE thread.forumid IN(5, 7, 1, 2, 19, 4, 8, 26, 9, 10, 24, 11, 12, 13, 14, 18, 22, 29, 15, 16)
	
	AND thread.visible = 1
	AND thread.sticky IN (0, 1)
	AND thread.open <> 10
	
	
ORDER BY lastpost DESC
LIMIT 500
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtagthread refPRIMARY,threadidPRIMARY4const1100.00Using index; Using temporary; Using filesort
1SIMPLEthread eq_refPRIMARY,forumid,catorderPRIMARY4psfantasy-forums.tagthread.threadid186.90Using where

Time Before: 0.35374 seconds
Time After: 0.35573 seconds
Time Taken: 0.00199 seconds

Memory Before: 1,605.922 KB
Memory After: 1,606.039 KB
Memory Used: 0.117 KB

SQL Query
INSERT INTO tagsearch (tagid, dateline) VALUES (7, 1718309995)

Time Before: 0.36489 seconds
Time After: 0.37489 seconds
Time Taken: 0.00999 seconds

Memory Before: 1,604.586 KB
Memory After: 1,604.930 KB
Memory Used: 0.344 KB

SQL Query
SELECT
	thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
	thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
	thread.prefixid, thread.taglist, hiddencount, deletedcount
	, post.pagetext AS preview
	
	
	
FROM thread AS thread
	
	
	LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
	
	
WHERE thread.threadid IN (9595)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEthread constPRIMARYPRIMARY4const1100.00 
1SIMPLEpost constPRIMARYPRIMARY4const1100.00 

Time Before: 0.38387 seconds
Time After: 0.38420 seconds
Time Taken: 0.00033 seconds

Memory Before: 1,607.688 KB
Memory After: 1,607.883 KB
Memory Used: 0.195 KB

PsFantasy.com Forums Database Error
Database Error Database error
The PsFantasy.com Forums database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the forums.psfantasy.com home page, then try to open another page.
  • Click the Back button to try another link.
The forums.psfantasy.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.