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
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
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
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')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxdatastore | range | PRIMARY | PRIMARY | 50 | 18 | Using 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
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.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
SELECT * FROM rxsession WHERE userid = 0 AND host = '172.71.190.16' AND idhash = '289c129501afdd0cf46d0fd2bedf8a1f' 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.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
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxlanguage | system | PRIMARY | 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
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.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
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'vb_types.types'
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.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
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.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
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\";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:\"\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\nFollow @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:\"\";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
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'forumblock.7166129774bf76162c1e50ecf5676aa8'
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.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
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)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | rxtemplate | range | PRIMARY | PRIMARY | 4 | 65 | Using 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
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.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
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'forumblock.40e7ad94afacbee2e44b9b7384a76cd0'
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.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
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'forumblock.aa9431b777b27af03622ece2c024a466'
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.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
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'forumblock.bae1e0dfbae192b45b7ced3092a25f89'
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.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
SELECT data, expires, locktime, serialized FROM rxcache WHERE cacheid = 'forumblock.d4290e27a7eb11481137c1a17fe38416'
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.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
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.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
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.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
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\";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:\"\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\nFollow @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:\"\";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
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.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
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'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | package | ALL | PRIMARY | 1 | ||||
1 | SIMPLE | product | eq_ref | PRIMARY | PRIMARY | 27 | 03forums.package.productid | 1 | Using where |
1 | SIMPLE | contenttype | ALL | packageclass | 18 | Using 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
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | hvquestion | index | PRIMARY | 4 | 1 | Using temporary; Using filesort | ||
1 | SIMPLE | hvanswer | ref | questionid | questionid | 4 | 03forums.hvquestion.questionid | 1 | Using 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
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
SELECT text, languageid, special FROM rxphrase AS phrase LEFT JOIN rxphrasetype USING (fieldname) WHERE phrase.fieldname = 'hvquestion' AND varname = 'question4'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | phrase | ref | name_lang_type | name_lang_type | 252 | const | 1 | Using index condition |
1 | SIMPLE | rxphrasetype | const | PRIMARY | PRIMARY | 20 | const | 1 | Using 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
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'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | package | ALL | PRIMARY | 1 | ||||
1 | SIMPLE | product | eq_ref | PRIMARY | PRIMARY | 27 | 03forums.package.productid | 1 | Using where |
1 | SIMPLE | contenttype | ALL | packageclass | 18 | Using 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
SELECT tagsearch.tagid, COUNT(*) AS searchcount FROM rxtagsearch AS tagsearch WHERE tagsearch.dateline > 1735106771 GROUP BY tagsearch.tagid ORDER BY searchcount DESC LIMIT 70
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | tagsearch | range | dateline | dateline | 4 | 5773 | Using 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
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)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | tag | index | PRIMARY | tagtext | 102 | 137 | Using 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
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
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