vBulletin

Datastore Setup

SQL Query

SELECT *
FROM rxdatastore
WHERE title IN ('iconcache','mailqueue','prefixcache','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxdatastore	range	PRIMARY	PRIMARY	50		19	Using where

Time Before: 0.08471 seconds
Time After: 0.08566 seconds
Time Taken: 0.00095 seconds

Memory Before: 680.297 KB
Memory After: 680.531 KB
Memory Used: 0.234 KB

Time Before: 0.08407 seconds
Time After: 0.08954 seconds
Time Taken: 0.00547 seconds

Memory Before: 676.281 KB
Memory After: 3,172.367 KB
Memory Used: 2,496.086 KB

SQL Query

SELECT *
FROM rxdatastore
WHERE title IN ('profilefield')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 0.09062 seconds
Time After: 0.09095 seconds
Time Taken: 0.00032 seconds

Memory Before: 3,660.211 KB
Memory After: 3,660.664 KB
Memory Used: 0.453 KB

Session Handling

SQL Query

SELECT *
FROM rxsession
WHERE userid = 0
	AND host = '172.70.134.26'
	AND idhash = '65220f753910b35bb8a7ee7ee7af3c61'
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxsession	ref	guest_lookup,user_activity	guest_lookup	51	const,const,const	2	Using where

Time Before: 0.09178 seconds
Time After: 0.09214 seconds
Time Taken: 0.00036 seconds

Memory Before: 3,680.477 KB
Memory After: 3,680.844 KB
Memory Used: 0.367 KB

SQL Query

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_forumdisplay AS phrasegroup_forumdisplay,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroupinfo AS lang_phrasegroupinfo,
			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 rxlanguage
WHERE languageid = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxlanguage	system	PRIMARY				1

Time Before: 0.09308 seconds
Time After: 0.09353 seconds
Time Taken: 0.00045 seconds

Memory Before: 3,691.633 KB
Memory After: 3,691.352 KB
Memory Used: -0.281 KB

Time Before: 0.09126 seconds
Time After: 0.09365 seconds
Time Taken: 0.00239 seconds

Memory Before: 3,673.016 KB
Memory After: 3,752.000 KB
Memory Used: 78.984 KB

SQL Query

SELECT *
FROM rxstyle
WHERE (styleid = 21 AND userselect = 1)
	OR styleid = 21
ORDER BY styleid ASC
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxstyle	const	PRIMARY	PRIMARY	2	const	1

Time Before: 0.09760 seconds
Time After: 0.09808 seconds
Time Taken: 0.00048 seconds

Memory Before: 4,261.836 KB
Memory After: 4,262.227 KB
Memory Used: 0.391 KB

SQL Query

SELECT block.*,
	blocktype.productid, blocktype.name AS blocktypename, blocktype.title AS blocktypetitle,
	blocktype.description as blocktypedescription, blocktype.allowcache
FROM rxblock AS block
LEFT JOIN rxblocktype AS blocktype ON (block.blocktypeid = blocktype.blocktypeid)
WHERE 1 AND block.active = 1 AND blocktype.productid IN ('vbulletin','evbs_sstab_advanced','everywhere_sidebar','glowhostspamomatic','hn_masspm','mpdevs_ae_detector','skimlinks','tapatalk','vsachatbox','')
ORDER BY block.displayorder, block.title

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	block	ALL	blocktypeid				7	Using where; Using temporary; Using filesort
1	SIMPLE	blocktype	ALL	PRIMARY,productid				6	Using where; Using join buffer (flat, BNL join)

Time Before: 0.10039 seconds
Time After: 0.10142 seconds
Time Taken: 0.00102 seconds

Memory Before: 4,869.766 KB
Memory After: 4,869.758 KB
Memory Used: -0.008 KB

SQL Query

REPLACE INTO rxdatastore
	(title, data, unserialize)
VALUES
	('activeblocks', 'a:5:{i:7;a:15:{s:7:\"blockid\";s:1:\"7\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:18:\"Dont miss a video!\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:1:\"0\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:327:\"a:3:{s:12:\"html_content\";s:226:\"Subscribe to RX on YouTube!
\r\n
\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:9:\"vbulletin\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:1;a:15:{s:7:\"blockid\";s:1:\"1\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:21:\"Visit our Advertisers\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"10\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:881:\"a:3:{s:12:\"html_content\";s:780:\"\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:5;a:15:{s:7:\"blockid\";s:1:\"5\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:17:\"Social Networking\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"20\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:500:\"a:3:{s:12:\"html_content\";s:399:\"Follow @RXMuscledotcom\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:3;a:15:{s:7:\"blockid\";s:1:\"3\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:16:\"Ask Dave Palumbo\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"40\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:503:\"a:3:{s:12:\"html_content\";s:402:\"Dave has built his reputation by helping others with his knowledge and experience. 
  Read More!
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:4;a:15:{s:7:\"blockid\";s:1:\"4\";s:11:\"blocktypeid\";s:1:\"5\";s:5:\"title\";s:21:\"Newly Replied Threads\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"60\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:162:\"a:5:{s:7:\"datecut\";s:2:\"30\";s:16:\"threads_forumids\";a:1:{i:0;i:2;}s:13:\"threads_limit\";s:1:\"5\";s:21:\"threads_titlemaxchars\";s:2:\"35\";s:12:\"threads_type\";s:1:\"1\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:7:\"threads\";s:14:\"blocktypetitle\";s:17:\"blocktype_threads\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}}', 1)

Time Before: 0.10161 seconds
Time After: 0.10216 seconds
Time Taken: 0.00055 seconds

Memory Before: 4,906.078 KB
Memory After: 4,901.477 KB
Memory Used: -4.602 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.d5e5613db50a6b4368acaca7beb2f539'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxcache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 0.10316 seconds
Time After: 0.10344 seconds
Time Taken: 0.00028 seconds

Memory Before: 4,962.234 KB
Memory After: 4,962.633 KB
Memory Used: 0.398 KB

SQL Query

SELECT title, template
FROM rxtemplate
WHERE templateid IN (1592,10683,11316,11318,11317,10939,10686,10936,10938,10935,10937,10931,11377,11443,11306,10728,10723,11387,11407,977,976,978,973,972,1595,4948,10720,10699,981,982,1600,11122,11396,11068,11072,11069,11070,11071,11426,0,0,11406,11367,11092,11093,11095,11096,11319,11438,11420,11370,11371,10919,10918,10922)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtemplate	range	PRIMARY	PRIMARY	4		54	Using where

Time Before: 0.10455 seconds
Time After: 0.10536 seconds
Time Taken: 0.00081 seconds

Memory Before: 5,134.813 KB
Memory After: 5,134.961 KB
Memory Used: 0.148 KB

SQL Query

SELECT template
FROM rxtemplate
WHERE templateid = 10863

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtemplate	const	PRIMARY	PRIMARY	4	const	1

Time Before: 0.11008 seconds
Time After: 0.11034 seconds
Time Taken: 0.00026 seconds

Memory Before: 5,331.039 KB
Memory After: 5,331.484 KB
Memory Used: 0.445 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.7e62ff5843fef40062d139513b2cab99'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxcache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 0.11103 seconds
Time After: 0.11118 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,332.695 KB
Memory After: 5,333.094 KB
Memory Used: 0.398 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.6c86bb7242cbc3fb949ab98f99fda5e4'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxcache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 0.11198 seconds
Time After: 0.11221 seconds
Time Taken: 0.00023 seconds

Memory Before: 5,340.383 KB
Memory After: 5,340.781 KB
Memory Used: 0.398 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.d79eea18ddf183d7114bd711d5846683'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxcache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 0.11305 seconds
Time After: 0.11335 seconds
Time Taken: 0.00030 seconds

Memory Before: 5,347.320 KB
Memory After: 5,347.719 KB
Memory Used: 0.398 KB

SQL Query

SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.19394085b66a32fe594509fbc7b3d2a2'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxcache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 0.11426 seconds
Time After: 0.11460 seconds
Time Taken: 0.00034 seconds

Memory Before: 5,370.320 KB
Memory After: 5,370.719 KB
Memory Used: 0.398 KB

SQL Query

SELECT template
FROM rxtemplate
WHERE templateid = 10867

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtemplate	const	PRIMARY	PRIMARY	4	const	1

Time Before: 0.11696 seconds
Time After: 0.11720 seconds
Time Taken: 0.00023 seconds

Memory Before: 5,586.422 KB
Memory After: 5,586.867 KB
Memory Used: 0.445 KB

SQL Query

SELECT block.*,
	blocktype.productid, blocktype.name AS blocktypename, blocktype.title AS blocktypetitle,
	blocktype.description as blocktypedescription, blocktype.allowcache
FROM rxblock AS block
LEFT JOIN rxblocktype AS blocktype ON (block.blocktypeid = blocktype.blocktypeid)
WHERE 1 AND block.active = 1 AND blocktype.productid IN ('vbulletin','evbs_sstab_advanced','everywhere_sidebar','glowhostspamomatic','hn_masspm','mpdevs_ae_detector','skimlinks','tapatalk','vsachatbox','')
ORDER BY block.displayorder, block.title

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	block	ALL	blocktypeid				7	Using where; Using temporary; Using filesort
1	SIMPLE	blocktype	ALL	PRIMARY,productid				6	Using where; Using join buffer (flat, BNL join)

Time Before: 0.11921 seconds
Time After: 0.12007 seconds
Time Taken: 0.00086 seconds

Memory Before: 5,535.992 KB
Memory After: 5,535.984 KB
Memory Used: -0.008 KB

SQL Query

REPLACE INTO rxdatastore
	(title, data, unserialize)
VALUES
	('activeblocks', 'a:5:{i:7;a:15:{s:7:\"blockid\";s:1:\"7\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:18:\"Dont miss a video!\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:1:\"0\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:327:\"a:3:{s:12:\"html_content\";s:226:\"Subscribe to RX on YouTube!
\r\n
\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:9:\"vbulletin\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:1;a:15:{s:7:\"blockid\";s:1:\"1\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:21:\"Visit our Advertisers\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"10\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:881:\"a:3:{s:12:\"html_content\";s:780:\"\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:5;a:15:{s:7:\"blockid\";s:1:\"5\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:17:\"Social Networking\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"20\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:500:\"a:3:{s:12:\"html_content\";s:399:\"Follow @RXMuscledotcom\r\n\r\n\r\n
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:3;a:15:{s:7:\"blockid\";s:1:\"3\";s:11:\"blocktypeid\";s:1:\"1\";s:5:\"title\";s:16:\"Ask Dave Palumbo\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"40\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:503:\"a:3:{s:12:\"html_content\";s:402:\"Dave has built his reputation by helping others with his knowledge and experience. 
  Read More!
\";s:13:\"html_template\";s:10:\"block_html\";s:9:\"html_type\";s:4:\"html\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:4:\"html\";s:14:\"blocktypetitle\";s:14:\"blocktype_html\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}i:4;a:15:{s:7:\"blockid\";s:1:\"4\";s:11:\"blocktypeid\";s:1:\"5\";s:5:\"title\";s:21:\"Newly Replied Threads\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:8:\"cachettl\";s:2:\"60\";s:12:\"displayorder\";s:2:\"60\";s:6:\"active\";s:1:\"1\";s:11:\"configcache\";s:162:\"a:5:{s:7:\"datecut\";s:2:\"30\";s:16:\"threads_forumids\";a:1:{i:0;i:2;}s:13:\"threads_limit\";s:1:\"5\";s:21:\"threads_titlemaxchars\";s:2:\"35\";s:12:\"threads_type\";s:1:\"1\";}\";s:7:\"product\";s:0:\"\";s:9:\"productid\";s:0:\"\";s:13:\"blocktypename\";s:7:\"threads\";s:14:\"blocktypetitle\";s:17:\"blocktype_threads\";s:20:\"blocktypedescription\";s:0:\"\";s:10:\"allowcache\";s:1:\"1\";}}', 1)

Time Before: 0.12022 seconds
Time After: 0.12084 seconds
Time Taken: 0.00062 seconds

Memory Before: 5,559.945 KB
Memory After: 5,555.344 KB
Memory Used: -4.602 KB

SQL Query

SELECT template
FROM rxtemplate
WHERE templateid = 2265

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rxtemplate	const	PRIMARY	PRIMARY	4	const	1

Time Before: 0.12167 seconds
Time After: 0.12201 seconds
Time Taken: 0.00034 seconds

Memory Before: 5,551.070 KB
Memory After: 5,551.516 KB
Memory Used: 0.445 KB

SQL Query

SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM rxmoderator AS moderator
INNER JOIN rxuser AS user USING(userid)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	moderator	ALL	userid_forumid				137
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	03forums.moderator.userid	1

Time Before: 0.12313 seconds
Time After: 0.12402 seconds
Time Taken: 0.00088 seconds

Memory Before: 5,608.367 KB
Memory After: 5,608.680 KB
Memory Used: 0.313 KB

SQL Query

SELECT forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
	user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
	
FROM rxforum AS forum

LEFT JOIN rxuser AS user ON (user.userid = forum.lastposterid)
LEFT JOIN rxuserlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	forum	ALL					229
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	03forums.forum.lastposterid	1
1	SIMPLE	userlist	eq_ref	PRIMARY,relationid,userid	PRIMARY	9	const,03forums.user.userid,const	1	Using where

Time Before: 0.12616 seconds
Time After: 0.12892 seconds
Time Taken: 0.00276 seconds

Memory Before: 5,935.500 KB
Memory After: 5,935.398 KB
Memory Used: -0.102 KB

SQL Query

SELECT
	announcement.announcementid, startdate, title, announcement.views,
	user.username, user.userid, user.usertitle, user.customtitle, user.usergroupid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
	
	
FROM rxannouncement AS announcement

LEFT JOIN rxuser AS user ON(user.userid = announcement.userid)

WHERE startdate <= 1679613574
	AND enddate >= 1679613574
	AND forumid IN (46,38,-1)
	
ORDER BY startdate DESC, announcement.announcementid DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	announcement	range	forumid,startdate	startdate	6		1	Using index condition; Using filesort
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	03forums.announcement.userid	1

Time Before: 0.14505 seconds
Time After: 0.14550 seconds
Time Taken: 0.00045 seconds

Memory Before: 6,945.453 KB
Memory After: 6,945.461 KB
Memory Used: 0.008 KB

SQL Query

SELECT COUNT(*) AS threads

FROM rxthread AS thread


WHERE thread.forumid = 46
	AND sticky = 0
	
	 AND visible = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	ref	forumid,forumid_lastpost	forumid	6	const,const,const	292	Using index

Time Before: 0.14645 seconds
Time After: 0.14697 seconds
Time Taken: 0.00052 seconds

Memory Before: 6,952.250 KB
Memory After: 6,952.641 KB
Memory Used: 0.391 KB

SQL Query

SELECT COUNT(*) AS newthread
FROM rxthread AS thread


WHERE thread.forumid = 46
	AND thread.lastpost > 1679613574
	AND open <> 10
	AND sticky = 0
	
	 AND visible = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	range	forumid,forumid_lastpost,lastpost	forumid	10		1	Using index condition; Using where

Time Before: 0.14763 seconds
Time After: 0.14798 seconds
Time Taken: 0.00036 seconds

Memory Before: 6,953.023 KB
Memory After: 6,953.352 KB
Memory Used: 0.328 KB

SQL Query

SELECT thread.threadid, lastpost, open
FROM rxthread AS thread
WHERE forumid = 46
	AND sticky = 1
	
	 AND visible = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	ref	forumid,forumid_lastpost	forumid	6	const,const,const	6

Time Before: 0.14860 seconds
Time After: 0.14940 seconds
Time Taken: 0.00080 seconds

Memory Before: 6,953.148 KB
Memory After: 6,953.523 KB
Memory Used: 0.375 KB

SQL Query

SELECT  thread.threadid,
	thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views
	
FROM rxthread AS thread


WHERE forumid = 46
	AND sticky = 0
	
	 AND visible = 1 
	
	
	
	
ORDER BY sticky DESC, lastpost DESC
LIMIT 0, 45

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	ref	forumid,forumid_lastpost	forumid	6	const,const,const	292	Using where

Time Before: 0.15001 seconds
Time After: 0.15386 seconds
Time Taken: 0.00385 seconds

Memory Before: 6,955.211 KB
Memory After: 6,955.367 KB
Memory Used: 0.156 KB

SQL Query

SELECT 
	IF(votenum >= 1, votenum, 0) AS votenum,
	IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
 
	thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
	thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
	thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount, user.userid,
	user.membergroupids, user.infractiongroupids, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
	user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
	
	
	
	
	
	
FROM rxthread AS thread
	LEFT JOIN rxuser AS user ON (user.userid = thread.lastposterid)
	LEFT JOIN rxuserlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)
	
	
	
	
	
	
	
	
WHERE thread.threadid IN (0,146761,145304,141946,140887,140208,138987,19510,137941,137332,132814,130980,130469,92516,121869,120997,117437,121218,120928,120588,119435,118336,118172,117986,117933,117828,116939,107499,115632,115051,114960,113671,113652,112454,70951,111858,111633,111604,111195,110891,110738,110289,110032,109834,108788,106974,15229,123699,129961,132811,62827,1905) 
ORDER BY thread.sticky DESC, lastpost DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	thread	range	PRIMARY	PRIMARY	4		52	Using where; Using filesort
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	03forums.thread.lastposterid	1
1	SIMPLE	userlist	eq_ref	PRIMARY,relationid,userid	PRIMARY	9	const,03forums.user.userid,const	1	Using where

Time Before: 0.15490 seconds
Time After: 0.15883 seconds
Time Taken: 0.00393 seconds

Memory Before: 6,959.930 KB
Memory After: 6,958.883 KB
Memory Used: -1.047 KB