Including Functions.php

Time Before: 0.00113 seconds
Time After: 0.00157 seconds
Time Taken: 0.00043 seconds

Memory Before: 586.859 KB
Memory After: 700.023 KB
Memory Used: 113.164 KB

Connect to Database on Server: www03.rxmuscle.ml.zerolag.com

Time Before: 0.00164 seconds
Time After: 0.00410 seconds
Time Taken: 0.00246 seconds

Memory Before: 700.023 KB
Memory After: 700.969 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00440 seconds
Time After: 0.00467 seconds
Time Taken: 0.00027 seconds

Memory Before: 701.664 KB
Memory After: 702.227 KB
Memory Used: 0.563 KB

Datastore Setup
SQL Query
SELECT *
FROM rxdatastore
WHERE title IN ('iconcache','searchcloud','routes','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxdatastorerangePRIMARYPRIMARY50 18Using where

Time Before: 0.00547 seconds
Time After: 0.00657 seconds
Time Taken: 0.00110 seconds

Memory Before: 705.445 KB
Memory After: 705.680 KB
Memory Used: 0.234 KB

Time Before: 0.00474 seconds
Time After: 0.01270 seconds
Time Taken: 0.00796 seconds

Memory Before: 701.438 KB
Memory After: 3,279.922 KB
Memory Used: 2,578.484 KB

SQL Query
SELECT *
FROM rxdatastore
WHERE title IN ('profilefield')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.01399 seconds
Time After: 0.01428 seconds
Time Taken: 0.00029 seconds

Memory Before: 3,741.477 KB
Memory After: 3,741.930 KB
Memory Used: 0.453 KB

Session Handling
SQL Query
SELECT *
FROM rxsession
WHERE userid = 0
	AND host = '172.71.190.16'
	AND idhash = '289c129501afdd0cf46d0fd2bedf8a1f'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxsessionrefguest_lookup,user_activityguest_lookup51const,const,const2Using where

Time Before: 0.01502 seconds
Time After: 0.01543 seconds
Time Taken: 0.00041 seconds

Memory Before: 3,755.867 KB
Memory After: 3,756.234 KB
Memory Used: 0.367 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroup_socialgroups AS phrasegroup_socialgroups,
			phrasegroup_prefix AS phrasegroup_prefix,
			phrasegroup_user AS phrasegroup_user,
			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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxlanguagesystemPRIMARY   1 

Time Before: 0.01632 seconds
Time After: 0.01690 seconds
Time Taken: 0.00058 seconds

Memory Before: 3,769.250 KB
Memory After: 3,768.852 KB
Memory Used: -0.398 KB

Time Before: 0.01444 seconds
Time After: 0.01707 seconds
Time Taken: 0.00263 seconds

Memory Before: 3,748.781 KB
Memory After: 3,893.531 KB
Memory Used: 144.750 KB

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

Time Before: 0.02441 seconds
Time After: 0.02477 seconds
Time Taken: 0.00037 seconds

Memory Before: 4,630.406 KB
Memory After: 4,630.797 KB
Memory Used: 0.391 KB

End call of global.php: 0.02667498588562
SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'vb_types.types'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.02895 seconds
Time After: 0.02915 seconds
Time Taken: 0.00020 seconds

Memory Before: 5,530.922 KB
Memory After: 5,531.352 KB
Memory Used: 0.430 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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEblockALLblocktypeid   7Using where; Using temporary; Using filesort
1SIMPLEblocktypeALLPRIMARY,productid   6Using where; Using join buffer (flat, BNL join)

Time Before: 0.03081 seconds
Time After: 0.03202 seconds
Time Taken: 0.00120 seconds

Memory Before: 5,683.188 KB
Memory After: 5,683.180 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\"Checkout\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\"Muscle\r\n\r\n\r\n
\r\n\r\n\r\n\"evolutionary.org\"\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\'s

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.03225 seconds
Time After: 0.04320 seconds
Time Taken: 0.01096 seconds

Memory Before: 5,719.438 KB
Memory After: 5,714.836 KB
Memory Used: -4.602 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.7166129774bf76162c1e50ecf5676aa8'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.04405 seconds
Time After: 0.04434 seconds
Time Taken: 0.00028 seconds

Memory Before: 5,730.398 KB
Memory After: 5,730.797 KB
Memory Used: 0.398 KB

SQL Query
SELECT title, template
FROM rxtemplate
WHERE templateid IN (0,11443,11183,11193,11196,11197,11195,11201,11199,11200,11202,11094,11097,11098,11316,11318,11317,11089,11306,11305,11285,11284,11184,11189,11190,11283,10949,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)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplaterangePRIMARYPRIMARY4 65Using where

Time Before: 0.04566 seconds
Time After: 0.04734 seconds
Time Taken: 0.00168 seconds

Memory Before: 5,907.953 KB
Memory After: 5,908.047 KB
Memory Used: 0.094 KB

SQL Query
SELECT template
FROM rxtemplate
WHERE templateid = 10863
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplateconstPRIMARYPRIMARY4const1 

Time Before: 0.05308 seconds
Time After: 0.05334 seconds
Time Taken: 0.00025 seconds

Memory Before: 6,126.961 KB
Memory After: 6,127.406 KB
Memory Used: 0.445 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.40e7ad94afacbee2e44b9b7384a76cd0'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.05400 seconds
Time After: 0.05428 seconds
Time Taken: 0.00028 seconds

Memory Before: 6,129.133 KB
Memory After: 6,129.531 KB
Memory Used: 0.398 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.aa9431b777b27af03622ece2c024a466'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.05504 seconds
Time After: 0.05531 seconds
Time Taken: 0.00027 seconds

Memory Before: 6,136.773 KB
Memory After: 6,137.172 KB
Memory Used: 0.398 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.bae1e0dfbae192b45b7ced3092a25f89'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.05608 seconds
Time After: 0.05636 seconds
Time Taken: 0.00028 seconds

Memory Before: 6,143.672 KB
Memory After: 6,144.070 KB
Memory Used: 0.398 KB

SQL Query
SELECT data, expires, locktime, serialized
FROM rxcache
WHERE cacheid = 'forumblock.d4290e27a7eb11481137c1a17fe38416'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxcacheconstPRIMARYPRIMARY66const1 

Time Before: 0.05721 seconds
Time After: 0.05748 seconds
Time Taken: 0.00027 seconds

Memory Before: 6,165.852 KB
Memory After: 6,166.250 KB
Memory Used: 0.398 KB

SQL Query
SELECT template
FROM rxtemplate
WHERE templateid = 10867
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplateconstPRIMARYPRIMARY4const1 

Time Before: 0.05918 seconds
Time After: 0.05943 seconds
Time Taken: 0.00025 seconds

Memory Before: 6,297.805 KB
Memory After: 6,298.250 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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEblockALLblocktypeid   7Using where; Using temporary; Using filesort
1SIMPLEblocktypeALLPRIMARY,productid   6Using where; Using join buffer (flat, BNL join)

Time Before: 0.06126 seconds
Time After: 0.06235 seconds
Time Taken: 0.00109 seconds

Memory Before: 6,268.992 KB
Memory After: 6,268.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\"Checkout\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\"Muscle\r\n\r\n\r\n
\r\n\r\n\r\n\"evolutionary.org\"\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\'s

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.06254 seconds
Time After: 0.07194 seconds
Time Taken: 0.00940 seconds

Memory Before: 6,292.945 KB
Memory After: 6,288.344 KB
Memory Used: -4.602 KB

SQL Query
SELECT template
FROM rxtemplate
WHERE templateid = 2265
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLErxtemplateconstPRIMARYPRIMARY4const1 

Time Before: 0.07267 seconds
Time After: 0.07291 seconds
Time Taken: 0.00024 seconds

Memory Before: 6,275.617 KB
Memory After: 6,276.063 KB
Memory Used: 0.445 KB

SQL Query
SELECT contenttype.contenttypeid AS itemid
	
FROM rxcontenttype AS contenttype
	INNER JOIN rxpackage AS package
	ON package.packageid = contenttype.packageid LEFT JOIN rxproduct AS product
	ON product.productid = package.productid 
WHERE
	1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin')  AND contenttype.cansearch = '1'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpackageALLPRIMARY   1 
1SIMPLEproducteq_refPRIMARYPRIMARY2703forums.package.productid1Using where
1SIMPLEcontenttypeALLpackageclass   18Using where; Using join buffer (flat, BNL join)

Time Before: 0.07427 seconds
Time After: 0.07522 seconds
Time Taken: 0.00095 seconds

Memory Before: 6,389.945 KB
Memory After: 6,390.102 KB
Memory Used: 0.156 KB

SQL Query
SELECT hvquestion.questionid, COUNT(*) AS answers
FROM rxhvquestion AS hvquestion
LEFT JOIN rxhvanswer AS hvanswer
	ON (hvquestion.questionid = hvanswer.questionid)
WHERE hvanswer.answerid IS NOT NULL
	OR hvquestion.regex <> ''
GROUP BY hvquestion.questionid
ORDER BY RAND()
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEhvquestionindex PRIMARY4 1Using temporary; Using filesort
1SIMPLEhvanswerrefquestionidquestionid403forums.hvquestion.questionid1Using where; Using index

Time Before: 0.07821 seconds
Time After: 0.07896 seconds
Time Taken: 0.00075 seconds

Memory Before: 6,853.508 KB
Memory After: 6,853.719 KB
Memory Used: 0.211 KB

SQL Query
INSERT INTO rxhumanverify
	(hash, answer, dateline)
VALUES
	('0dd98c004f612576dee85f19f019f7a6', '4', 1737698771)

Time Before: 0.07904 seconds
Time After: 0.08864 seconds
Time Taken: 0.00959 seconds

Memory Before: 6,853.273 KB
Memory After: 6,853.563 KB
Memory Used: 0.289 KB

SQL Query
SELECT text, languageid, special
FROM rxphrase AS phrase
LEFT JOIN rxphrasetype USING (fieldname)
WHERE phrase.fieldname = 'hvquestion'
	AND varname = 'question4'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserefname_lang_typename_lang_type252const1Using index condition
1SIMPLErxphrasetypeconstPRIMARYPRIMARY20const1Using where

Time Before: 0.08948 seconds
Time After: 0.09017 seconds
Time Taken: 0.00069 seconds

Memory Before: 6,853.906 KB
Memory After: 6,854.258 KB
Memory Used: 0.352 KB

SQL Query
SELECT contenttype.contenttypeid AS itemid
	
FROM rxcontenttype AS contenttype
	INNER JOIN rxpackage AS package
	ON package.packageid = contenttype.packageid LEFT JOIN rxproduct AS product
	ON product.productid = package.productid 
WHERE
	1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin')  AND contenttype.cantag = '1'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpackageALLPRIMARY   1 
1SIMPLEproducteq_refPRIMARYPRIMARY2703forums.package.productid1Using where
1SIMPLEcontenttypeALLpackageclass   18Using where; Using join buffer (flat, BNL join)

Time Before: 0.09125 seconds
Time After: 0.09162 seconds
Time Taken: 0.00036 seconds

Memory Before: 6,878.266 KB
Memory After: 6,878.414 KB
Memory Used: 0.148 KB

SQL Query
SELECT tagsearch.tagid, COUNT(*) AS searchcount
FROM rxtagsearch AS tagsearch
WHERE tagsearch.dateline > 1735106771
GROUP BY tagsearch.tagid
ORDER BY searchcount DESC
LIMIT 70
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtagsearchrangedatelinedateline4 5773Using index condition; Using temporary; Using filesort

Time Before: 0.09344 seconds
Time After: 0.11513 seconds
Time Taken: 0.02169 seconds

Memory Before: 6,893.891 KB
Memory After: 6,894.211 KB
Memory Used: 0.320 KB

SQL Query
SELECT tag.tagid, tag.tagtext
						FROM rxtag AS tag
					   WHERE tag.tagid IN (12,5,16,1,2,7,4,41,50,114,3,24,6,25,88,58,105,14,27,52,13,37,26,9,17,43,63,149,218,35,33,137,93,44,36,32,65,20,100,47,81,129,68,288,31,176,83,15,166,107,62,40,61,59,21,46,34,115,49,23,19,73,18,150,55,54,152,8,178,22)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtagindexPRIMARYtagtext102 137Using where; Using index

Time Before: 0.11591 seconds
Time After: 0.11651 seconds
Time Taken: 0.00059 seconds

Memory Before: 6,907.422 KB
Memory After: 6,907.648 KB
Memory Used: 0.227 KB

SQL Query
REPLACE INTO rxdatastore
	(title, data, unserialize)
VALUES
	('searchcloud', 'a:3:{s:4:\"tags\";a:70:{s:11:\"1legmonster\";a:5:{s:5:\"tagid\";s:2:\"20\";s:11:\"searchcount\";s:3:\"140\";s:7:\"tagtext\";s:11:\"1legmonster\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"1legmonster\";}s:18:\"700 rep challenge!\";a:5:{s:5:\"tagid\";s:2:\"21\";s:11:\"searchcount\";s:3:\"131\";s:7:\"tagtext\";s:18:\"700 rep challenge!\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:20:\"700+rep+challenge%21\";}s:19:\"2018 arnold classic\";a:5:{s:5:\"tagid\";s:2:\"55\";s:11:\"searchcount\";s:3:\"126\";s:7:\"tagtext\";s:19:\"2018 arnold classic\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:19:\"2018+arnold+classic\";}s:15:\"2018 mr olympia\";a:5:{s:5:\"tagid\";s:3:\"288\";s:11:\"searchcount\";s:3:\"137\";s:7:\"tagtext\";s:15:\"2018 mr olympia\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:15:\"2018+mr+olympia\";}s:10:\"ameen alai\";a:5:{s:5:\"tagid\";s:2:\"63\";s:11:\"searchcount\";s:3:\"146\";s:7:\"tagtext\";s:10:\"ameen alai\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"ameen+alai\";}s:14:\"andre ferguson\";a:5:{s:5:\"tagid\";s:3:\"176\";s:11:\"searchcount\";s:3:\"136\";s:7:\"tagtext\";s:14:\"andre ferguson\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"andre+ferguson\";}s:12:\"armwrestling\";a:5:{s:5:\"tagid\";s:2:\"18\";s:11:\"searchcount\";s:3:\"127\";s:7:\"tagtext\";s:12:\"armwrestling\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"armwrestling\";}s:19:\"arnold classic 2018\";a:5:{s:5:\"tagid\";s:3:\"107\";s:11:\"searchcount\";s:3:\"134\";s:7:\"tagtext\";s:19:\"arnold classic 2018\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:19:\"arnold+classic+2018\";}s:7:\"askdave\";a:5:{s:5:\"tagid\";s:2:\"26\";s:11:\"searchcount\";s:3:\"149\";s:7:\"tagtext\";s:7:\"askdave\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"askdave\";}s:12:\"bader boodai\";a:5:{s:5:\"tagid\";s:2:\"81\";s:11:\"searchcount\";s:3:\"138\";s:7:\"tagtext\";s:12:\"bader boodai\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"bader+boodai\";}s:9:\"big lenny\";a:5:{s:5:\"tagid\";s:2:\"50\";s:11:\"searchcount\";s:3:\"182\";s:7:\"tagtext\";s:9:\"big lenny\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:9:\"big+lenny\";}s:12:\"bodybuilding\";a:5:{s:5:\"tagid\";s:1:\"8\";s:11:\"searchcount\";s:3:\"124\";s:7:\"tagtext\";s:12:\"bodybuilding\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"bodybuilding\";}s:11:\"bostin loyd\";a:5:{s:5:\"tagid\";s:3:\"137\";s:11:\"searchcount\";s:3:\"144\";s:7:\"tagtext\";s:11:\"bostin loyd\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"bostin+loyd\";}s:10:\"brian shaw\";a:5:{s:5:\"tagid\";s:2:\"14\";s:11:\"searchcount\";s:3:\"154\";s:7:\"tagtext\";s:10:\"brian shaw\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"brian+shaw\";}s:5:\"carbs\";a:5:{s:5:\"tagid\";s:1:\"4\";s:11:\"searchcount\";s:3:\"210\";s:7:\"tagtext\";s:5:\"carbs\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:5:\"carbs\";}s:11:\"chris aceto\";a:5:{s:5:\"tagid\";s:2:\"44\";s:11:\"searchcount\";s:3:\"141\";s:7:\"tagtext\";s:11:\"chris aceto\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"chris+aceto\";}s:15:\"dallas mccarver\";a:5:{s:5:\"tagid\";s:2:\"34\";s:11:\"searchcount\";s:3:\"129\";s:7:\"tagtext\";s:15:\"dallas mccarver\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:15:\"dallas+mccarver\";}s:16:\"dana linn bailey\";a:5:{s:5:\"tagid\";s:2:\"32\";s:11:\"searchcount\";s:3:\"140\";s:7:\"tagtext\";s:16:\"dana linn bailey\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:16:\"dana+linn+bailey\";}s:13:\"daniel stisen\";a:5:{s:5:\"tagid\";s:3:\"115\";s:11:\"searchcount\";s:3:\"129\";s:7:\"tagtext\";s:13:\"daniel stisen\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"daniel+stisen\";}s:12:\"dave palumbo\";a:5:{s:5:\"tagid\";s:2:\"25\";s:11:\"searchcount\";s:3:\"160\";s:7:\"tagtext\";s:12:\"dave palumbo\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"dave+palumbo\";}s:8:\"deadlift\";a:5:{s:5:\"tagid\";s:2:\"17\";s:11:\"searchcount\";s:3:\"148\";s:7:\"tagtext\";s:8:\"deadlift\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:8:\"deadlift\";}s:13:\"dennis hopson\";a:5:{s:5:\"tagid\";s:2:\"93\";s:11:\"searchcount\";s:3:\"144\";s:7:\"tagtext\";s:13:\"dennis hopson\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:13:\"dennis+hopson\";}s:13:\"eugene mishin\";a:5:{s:5:\"tagid\";s:3:\"149\";s:11:\"searchcount\";s:3:\"146\";s:7:\"tagtext\";s:13:\"eugene mishin\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:13:\"eugene+mishin\";}s:3:\"fat\";a:5:{s:5:\"tagid\";s:1:\"5\";s:11:\"searchcount\";s:3:\"256\";s:7:\"tagtext\";s:3:\"fat\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:3:\"fat\";}s:20:\"finnish bodybuilding\";a:5:{s:5:\"tagid\";s:2:\"23\";s:11:\"searchcount\";s:3:\"128\";s:7:\"tagtext\";s:20:\"finnish bodybuilding\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:20:\"finnish+bodybuilding\";}s:4:\"food\";a:5:{s:5:\"tagid\";s:1:\"1\";s:11:\"searchcount\";s:3:\"217\";s:7:\"tagtext\";s:4:\"food\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:4:\"food\";}s:15:\"guilty pleasure\";a:5:{s:5:\"tagid\";s:2:\"19\";s:11:\"searchcount\";s:3:\"128\";s:7:\"tagtext\";s:15:\"guilty pleasure\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:15:\"guilty+pleasure\";}s:14:\"guy cisternino\";a:5:{s:5:\"tagid\";s:3:\"100\";s:11:\"searchcount\";s:3:\"140\";s:7:\"tagtext\";s:14:\"guy cisternino\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:14:\"guy+cisternino\";}s:4:\"ifbb\";a:5:{s:5:\"tagid\";s:1:\"7\";s:11:\"searchcount\";s:3:\"211\";s:7:\"tagtext\";s:4:\"ifbb\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:4:\"ifbb\";}s:9:\"iron rage\";a:5:{s:5:\"tagid\";s:2:\"88\";s:11:\"searchcount\";s:3:\"159\";s:7:\"tagtext\";s:9:\"iron rage\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"iron+rage\";}s:14:\"jimmy the bull\";a:5:{s:5:\"tagid\";s:2:\"59\";s:11:\"searchcount\";s:3:\"131\";s:7:\"tagtext\";s:14:\"jimmy the bull\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"jimmy+the+bull\";}s:11:\"john romano\";a:5:{s:5:\"tagid\";s:2:\"68\";s:11:\"searchcount\";s:3:\"137\";s:7:\"tagtext\";s:11:\"john romano\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:11:\"john+romano\";}s:10:\"kai greene\";a:5:{s:5:\"tagid\";s:2:\"37\";s:11:\"searchcount\";s:3:\"149\";s:7:\"tagtext\";s:10:\"kai greene\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"kai+greene\";}s:14:\"kamal elgargni\";a:5:{s:5:\"tagid\";s:2:\"65\";s:11:\"searchcount\";s:3:\"140\";s:7:\"tagtext\";s:14:\"kamal elgargni\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:14:\"kamal+elgargni\";}s:13:\"kevin levrone\";a:5:{s:5:\"tagid\";s:2:\"46\";s:11:\"searchcount\";s:3:\"130\";s:7:\"tagtext\";s:13:\"kevin levrone\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"kevin+levrone\";}s:12:\"larry wheels\";a:5:{s:5:\"tagid\";s:2:\"73\";s:11:\"searchcount\";s:3:\"127\";s:7:\"tagtext\";s:12:\"larry wheels\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"larry+wheels\";}s:10:\"lee priest\";a:5:{s:5:\"tagid\";s:2:\"52\";s:11:\"searchcount\";s:3:\"151\";s:7:\"tagtext\";s:10:\"lee priest\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"lee+priest\";}s:9:\"live with\";a:5:{s:5:\"tagid\";s:3:\"114\";s:11:\"searchcount\";s:3:\"168\";s:7:\"tagtext\";s:9:\"live with\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"live+with\";}s:11:\"matt jansen\";a:5:{s:5:\"tagid\";s:2:\"35\";s:11:\"searchcount\";s:3:\"145\";s:7:\"tagtext\";s:11:\"matt jansen\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"matt+jansen\";}s:11:\"matt porter\";a:5:{s:5:\"tagid\";s:2:\"36\";s:11:\"searchcount\";s:3:\"141\";s:7:\"tagtext\";s:11:\"matt porter\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"matt+porter\";}s:5:\"meals\";a:5:{s:5:\"tagid\";s:1:\"2\";s:11:\"searchcount\";s:3:\"215\";s:7:\"tagtext\";s:5:\"meals\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:5:\"meals\";}s:12:\"milos sarcev\";a:5:{s:5:\"tagid\";s:3:\"178\";s:11:\"searchcount\";s:3:\"123\";s:7:\"tagtext\";s:12:\"milos sarcev\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"milos+sarcev\";}s:14:\"nathan de asha\";a:5:{s:5:\"tagid\";s:3:\"166\";s:11:\"searchcount\";s:3:\"135\";s:7:\"tagtext\";s:14:\"nathan de asha\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"nathan+de+asha\";}s:13:\"nathan payton\";a:5:{s:5:\"tagid\";s:2:\"15\";s:11:\"searchcount\";s:3:\"136\";s:7:\"tagtext\";s:13:\"nathan payton\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"nathan+payton\";}s:12:\"nick trigili\";a:5:{s:5:\"tagid\";s:3:\"152\";s:11:\"searchcount\";s:3:\"124\";s:7:\"tagtext\";s:12:\"nick trigili\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"nick+trigili\";}s:10:\"nordic pro\";a:5:{s:5:\"tagid\";s:2:\"24\";s:11:\"searchcount\";s:3:\"165\";s:7:\"tagtext\";s:10:\"nordic pro\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"nordic+pro\";}s:3:\"npc\";a:5:{s:5:\"tagid\";s:2:\"12\";s:11:\"searchcount\";s:3:\"266\";s:7:\"tagtext\";s:3:\"npc\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:3:\"npc\";}s:7:\"npc2014\";a:5:{s:5:\"tagid\";s:2:\"13\";s:11:\"searchcount\";s:3:\"150\";s:7:\"tagtext\";s:7:\"npc2014\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"npc2014\";}s:10:\"phil heath\";a:5:{s:5:\"tagid\";s:3:\"218\";s:11:\"searchcount\";s:3:\"146\";s:7:\"tagtext\";s:10:\"phil heath\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"phil+heath\";}s:10:\"phoenixpro\";a:5:{s:5:\"tagid\";s:1:\"9\";s:11:\"searchcount\";s:3:\"148\";s:7:\"tagtext\";s:10:\"phoenixpro\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:10:\"phoenixpro\";}s:8:\"physique\";a:5:{s:5:\"tagid\";s:1:\"6\";s:11:\"searchcount\";s:3:\"160\";s:7:\"tagtext\";s:8:\"physique\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:8:\"physique\";}s:12:\"powerlifting\";a:5:{s:5:\"tagid\";s:2:\"33\";s:11:\"searchcount\";s:3:\"144\";s:7:\"tagtext\";s:12:\"powerlifting\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:12:\"powerlifting\";}s:7:\"protein\";a:5:{s:5:\"tagid\";s:1:\"3\";s:11:\"searchcount\";s:3:\"167\";s:7:\"tagtext\";s:7:\"protein\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"protein\";}s:12:\"robert timms\";a:5:{s:5:\"tagid\";s:2:\"61\";s:11:\"searchcount\";s:3:\"133\";s:7:\"tagtext\";s:12:\"robert timms\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"robert+timms\";}s:14:\"ronnie coleman\";a:5:{s:5:\"tagid\";s:2:\"47\";s:11:\"searchcount\";s:3:\"138\";s:7:\"tagtext\";s:14:\"ronnie coleman\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:14:\"ronnie+coleman\";}s:12:\"samir troudi\";a:5:{s:5:\"tagid\";s:2:\"49\";s:11:\"searchcount\";s:3:\"129\";s:7:\"tagtext\";s:12:\"samir troudi\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"samir+troudi\";}s:15:\"santiago aragon\";a:5:{s:5:\"tagid\";s:2:\"54\";s:11:\"searchcount\";s:3:\"125\";s:7:\"tagtext\";s:15:\"santiago aragon\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:15:\"santiago+aragon\";}s:9:\"sara back\";a:5:{s:5:\"tagid\";s:2:\"58\";s:11:\"searchcount\";s:3:\"157\";s:7:\"tagtext\";s:9:\"sara back\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"sara+back\";}s:14:\"shanique grant\";a:5:{s:5:\"tagid\";s:2:\"31\";s:11:\"searchcount\";s:3:\"137\";s:7:\"tagtext\";s:14:\"shanique grant\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"shanique+grant\";}s:12:\"shawn rhoden\";a:5:{s:5:\"tagid\";s:2:\"83\";s:11:\"searchcount\";s:3:\"136\";s:7:\"tagtext\";s:12:\"shawn rhoden\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"shawn+rhoden\";}s:11:\"steve kuclo\";a:5:{s:5:\"tagid\";s:2:\"41\";s:11:\"searchcount\";s:3:\"183\";s:7:\"tagtext\";s:11:\"steve kuclo\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:11:\"steve+kuclo\";}s:7:\"synthol\";a:5:{s:5:\"tagid\";s:2:\"27\";s:11:\"searchcount\";s:3:\"151\";s:7:\"tagtext\";s:7:\"synthol\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"synthol\";}s:15:\"terrence ruffin\";a:5:{s:5:\"tagid\";s:2:\"62\";s:11:\"searchcount\";s:3:\"134\";s:7:\"tagtext\";s:15:\"terrence ruffin\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:15:\"terrence+ruffin\";}s:9:\"tom platz\";a:5:{s:5:\"tagid\";s:2:\"43\";s:11:\"searchcount\";s:3:\"148\";s:7:\"tagtext\";s:9:\"tom platz\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"tom+platz\";}s:9:\"tony huge\";a:5:{s:5:\"tagid\";s:3:\"105\";s:11:\"searchcount\";s:3:\"154\";s:7:\"tagtext\";s:9:\"tony huge\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:9:\"tony+huge\";}s:15:\"victor martinez\";a:5:{s:5:\"tagid\";s:3:\"150\";s:11:\"searchcount\";s:3:\"126\";s:7:\"tagtext\";s:15:\"victor martinez\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:15:\"victor+martinez\";}s:14:\"wesley vissers\";a:5:{s:5:\"tagid\";s:3:\"129\";s:11:\"searchcount\";s:3:\"138\";s:7:\"tagtext\";s:14:\"wesley vissers\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:14:\"wesley+vissers\";}s:13:\"william bonac\";a:5:{s:5:\"tagid\";s:2:\"40\";s:11:\"searchcount\";s:3:\"133\";s:7:\"tagtext\";s:13:\"william bonac\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"william+bonac\";}s:21:\"worst in bodybuilding\";a:5:{s:5:\"tagid\";s:2:\"22\";s:11:\"searchcount\";s:3:\"119\";s:7:\"tagtext\";s:21:\"worst in bodybuilding\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:21:\"worst+in+bodybuilding\";}s:3:\"wsm\";a:5:{s:5:\"tagid\";s:2:\"16\";s:11:\"searchcount\";s:3:\"249\";s:7:\"tagtext\";s:3:\"wsm\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:3:\"wsm\";}}s:5:\"count\";i:70;s:8:\"dateline\";i:1737698771;}', 1)

Time Before: 0.11809 seconds
Time After: 0.12654 seconds
Time Taken: 0.00845 seconds

Memory Before: 6,980.352 KB
Memory After: 6,968.117 KB
Memory Used: -12.234 KB

SQL Query
INSERT IGNORE INTO rxsession
	(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
	('0406c79378fdba9225605c84d82f225a', 0, '172.71.190.16', '289c129501afdd0cf46d0fd2bedf8a1f', 1737698771, '/search.php?explain=1', 0, 0, 0, 0, 0, 0, 0, 'CCBot/2.0 (https://commoncrawl.org/faq/)', 0, 0, 0, '')

Time Before: 0.13851 seconds
Time After: 0.13874 seconds
Time Taken: 0.00022 seconds

Memory Before: 7,310.625 KB
Memory After: 7,310.578 KB
Memory Used: -0.047 KB

Page generated in 0.13733100891113 seconds with 29 queries, spending 0.075429677963257 doing MySQL queries and 0.061901330947876 doing PHP things.
Shutdown Queries:
DISABLED