SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('styles')
Run Time: 0.000635
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000080
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra,
0 AS thread_is_ignored, 0 AS thread_ignore_news_feed,
0 AS thread_ignore_new_posts, 0 AS thread_ignore_forum_view
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 48665
Run Time: 0.000286
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
WHERE node.node_id = ?
Params: 8
Run Time: 0.000163
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT post.*
,
bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
session_activity.view_date AS last_view_date,
0 AS like_date
FROM xf_post AS post
LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE post.thread_id = ?
AND (post.position >= 250 AND post.position < 300)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 48665
Run Time: 0.017721
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 50 | Using index condition; Using where; Using filesort |
SIMPLE | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,themainb_tmb_new.post.post_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | themainb_tmb_new.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | themainb_tmb_new.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | themainb_tmb_new.post.user_id | 1 | |
SIMPLE | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,themainb_tmb_new.post.user_id | 1 | Using where |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | themainb_tmb_new.post.user_id,func | 1 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 48665
Run Time: 0.000103
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, Qa%, Qa%, XenForo_ControllerPublic_Thread, Index, valid, thread_id=48665&page=6, 1711627072,
Run Time: 0.000141
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000034
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | no matching row in const table |
SELECT *
FROM uix_node_layout
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | uix_node_layout | ALL | | | | | 2 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000034
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | no matching row in const table |
SELECT node.*,
node_field.uix_node_icons,
node_field.uix_styling,
node_field.collapsed,
node_field.inheritClass
FROM xf_node AS node
LEFT JOIN uix_node_fields AS node_field ON (node.node_id = node_field.node_id)
Run Time: 0.000092
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | ALL | | | | | 38 | |
SIMPLE | node_field | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (Block Nested Loop) |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'BRATI_thread_icon', 'BRATI_thread_icon_edit', 'thread_view', 'addm_navigation', 'BRSTI_navigation_tabs_members', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 16, 1
Run Time: 0.000330
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 13 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('addm_donations')
Params: 1
Run Time: 0.000031
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT sport_team.*
FROM xf_brivium_sport_team AS sport_team
WHERE (sport_team.active = 1)
ORDER BY sport_team.title ASC
Run Time: 0.000118
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | sport_team | ALL | active | | | | 429 | Using where; Using filesort |
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6006114, a:1:{i:0;s:68:"Missed this one somehow.
Liverpool and Houston Dynamo for me please";}, 1702743702, 1711627072
Run Time: 0.000422
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6046135, a:1:{i:0;s:24:"Tottenham Hotspur please";}, 1702743702, 1711627072
Run Time: 0.000360
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6054707, a:1:{i:0;s:67:"in order of importance: PSV, Liverpool, Valencia and AS Roma for me";}, 1702743702, 1711627072
Run Time: 0.000441
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6056034, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"Jesus Shuttlesworth, post: 4987043";s:8:"original";a:2:{i:0;s:44:"[quote="Jesus Shuttlesworth, post: 4987043"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:24:"Remove me from Tottenham";}}i:1;s:2:"
";i:2;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"Jesus Shuttlesworth, post: 6046135";s:8:"original";a:2:{i:0;s:44:"[quote="Jesus Shuttlesworth, post: 6046135"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:24:"Tottenham Hotspur please";}}i:3;s:18:"
This fucking guy";}, 1702743702, 1711627072
Run Time: 0.000426
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6057045, a:1:{i:0;s:10:"christ lol";}, 1702743702, 1711627072
Run Time: 0.000582
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6160669, a:1:{i:0;s:60:"Hey put me down for Manchester United
please, and thank you";}, 1702743702, 1711627072
Run Time: 0.000592
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6161528, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:21:"Wicket, post: 6054707";s:8:"original";a:2:{i:0;s:31:"[quote="Wicket, post: 6054707"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:67:"in order of importance: PSV, Liverpool, Valencia and AS Roma for me";}}i:1;s:5:"
bump";}, 1702743702, 1711627072
Run Time: 0.000467
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6163735, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:21:"Wicket, post: 6161528";s:8:"original";a:2:{i:0;s:31:"[quote="Wicket, post: 6161528"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:4:"bump";}}i:1;s:19:"
I like your style";}, 1702743702, 1711627072
Run Time: 0.000490
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6166180, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:22:"El_Pato, post: 6163735";s:8:"original";a:2:{i:0;s:32:"[quote="El_Pato, post: 6163735"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:17:"I like your style";}}i:1;s:12:"
:heythere:";}, 1702743702, 1711627072
Run Time: 0.000448
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6284908, a:1:{i:0;s:7:"updated";}, 1702743702, 1711627072
Run Time: 0.000475
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6285566, a:1:{i:0;s:28:"Can I just be a fan of Mick?";}, 1702743702, 1711627072
Run Time: 0.000542
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6349127, a:2:{i:0;s:11:"hey...uh...";i:1;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[SIZE=1]";i:1;s:7:"[/SIZE]";}s:8:"children";a:2:{i:0;s:10:"chelsea. ";i:1;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"7";s:8:"original";a:2:{i:0;s:8:"[SIZE=7]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;s:11:"SPORTING KC";}}}}}, 1702743702, 1711627072
Run Time: 0.000511
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6389559, a:1:{i:0;s:19:"FC Dallas, Everton.";}, 1702743702, 1711627072
Run Time: 0.000368
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6389919, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:30:"scoops lukeahan, post: 6389559";s:8:"original";a:2:{i:0;s:40:"[quote="scoops lukeahan, post: 6389559"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:19:"FC Dallas, Everton.";}}i:1;s:11:"
this hurts";}, 1702743702, 1711627072
Run Time: 0.000436
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6389988, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"broXcore, post: 6389919";s:8:"original";a:2:{i:0;s:33:"[quote="broXcore, post: 6389919"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:10:"this hurts";}}i:1;s:123:"
screw him, he had his chance, and is passing on the opportunity to win championships
oh, and kansas city bbq > texas bbq";}, 1702743702, 1711627072
Run Time: 0.000372
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390101, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"ochoseis, post: 6389988";s:8:"original";a:2:{i:0;s:33:"[quote="ochoseis, post: 6389988"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:121:"screw him, he had his chance, and is passing on the opportunity to win championships
oh, and kansas city bbq > texas bbq";}}i:1;s:85:"
I will construct a new back deck for your house and then cover it with crazy glue
";i:2;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"broXcore, post: 6389919";s:8:"original";a:2:{i:0;s:33:"[quote="broXcore, post: 6389919"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:10:"this hurts";}}i:3;s:37:"
FWIW Spurs made my top 3:justsayin:";}, 1702743702, 1711627072
Run Time: 0.000478
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390144, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"broXcore, post: 6385047";s:8:"original";a:2:{i:0;s:33:"[quote="broXcore, post: 6385047"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:88:"america is obviously my number one, but i like to root for italy when they don't play us";}}i:1;s:83:"
I mean, I'm sorry, but I feel like this quote vindicates my decision:awesomeface:";}, 1702743702, 1711627072
Run Time: 0.000421
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390149, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:30:"scoops lukeahan, post: 6390144";s:8:"original";a:2:{i:0;s:40:"[quote="scoops lukeahan, post: 6390144"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:81:"I mean, I'm sorry, but I feel like this quote vindicates my decision:awesomeface:";}}i:1;s:26:"
That's quite harsh, sir.";}, 1702743702, 1711627072
Run Time: 0.000593
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390150, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:18:"514, post: 6390149";s:8:"original";a:2:{i:0;s:28:"[quote="514, post: 6390149"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:24:"That's quite harsh, sir.";}}i:1;s:116:"
I know, but man. That's like rooting for Duke basketball whenever EMAW isn't playing.
much <3 for broX regardless";}, 1702743702, 1711627072
Run Time: 0.000550
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390151, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:30:"scoops lukeahan, post: 6390150";s:8:"original";a:2:{i:0;s:40:"[quote="scoops lukeahan, post: 6390150"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:114:"I know, but man. That's like rooting for Duke basketball whenever EMAW isn't playing.
much <3 for broX regardless";}}i:1;s:57:"
That's ridiculous.
Italy never had that fag JJ Redick.";}, 1702743702, 1711627072
Run Time: 0.000422
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390153, a:3:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:18:"514, post: 6390151";s:8:"original";a:2:{i:0;s:28:"[quote="514, post: 6390151"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:55:"That's ridiculous.
Italy never had that fag JJ Redick.";}}i:1;s:38:"
This guy more than makes up for it
";i:2;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[media=youtube]";i:1;s:8:"[/media]";}s:8:"children";a:1:{i:0;s:11:"jOzqaodDmTk";}}}, 1702743702, 1711627072
Run Time: 0.000413
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390155, a:1:{i:0;s:35:"Marco Materazzi is a fucking saint.";}, 1702743702, 1711627072
Run Time: 0.000429
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390157, a:1:{i:0;s:8:":edmond:";}, 1702743702, 1711627072
Run Time: 0.000339
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390160, a:3:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[URL]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:42:"http://www.youtube.com/watch?v=zPeYWA27Q2A";}}i:1;s:188:"
The awe-inspiring and flowing locks, pearly white boots and sublime delivery of Pirlo...
combined with...
the graceful and effortless elevation and powerful finishing of Materazzi...
";i:2;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"3";s:8:"original";a:2:{i:0;s:8:"[SIZE=3]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"arial";s:8:"original";a:2:{i:0;s:12:"[FONT=arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#222222";s:8:"original";a:2:{i:0;s:15:"[COLOR=#222222]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:12:"Forza Italia";}}}}}}}, 1702743702, 1711627072
Run Time: 0.000340
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390165, a:1:{i:0;s:35:"Marco Materazzi was the bagman iyam";}, 1702743702, 1711627072
Run Time: 0.000329
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6390381, a:1:{i:0;s:8:"team 514";}, 1702743702, 1711627072
Run Time: 0.000416
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6392593, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"broXcore, post: 6390381";s:8:"original";a:2:{i:0;s:33:"[quote="broXcore, post: 6390381"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:8:"team 514";}}i:1;s:2:"
";i:2;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:46:"http://goemaw.com/forum/Smileys/goEMAW/eek.png";}}i:3;s:47:"
well, at least your second team isn't Mexico.";}, 1702743702, 1711627072
Run Time: 0.000526
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6407066, a:3:{i:0;s:14:"i had no idea ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:54:"http://www.the-mainboard.com/index.php?members/514.70/";s:8:"original";a:2:{i:0;s:62:"[URL='http://www.the-mainboard.com/index.php?members/514.70/']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:3:"514";}}i:2;s:40:" was a raging homosexual until this page";}, 1702743702, 1711627072
Run Time: 0.005395
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6407111, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:26:"andres 3000, post: 6407066";s:8:"original";a:2:{i:0;s:36:"[quote="andres 3000, post: 6407066"]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;s:14:"i had no idea ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:54:"http://www.the-mainboard.com/index.php?members/514.70/";s:8:"original";a:2:{i:0;s:62:"[URL='http://www.the-mainboard.com/index.php?members/514.70/']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:3:"514";}}i:2;s:40:" was a raging homosexual until this page";}}i:1;s:34:"
woah man that's crossing the line";}, 1702743702, 1711627072
Run Time: 0.003865
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6407120, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"broXcore, post: 6407003";s:8:"original";a:2:{i:0;s:33:"[quote="broXcore, post: 6407003"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:22:"team italian americans";}}i:1;s:148:"
Well this explains things.
I'll root for Norway whenever we're not playing them I guess. Kinda find it hard to root for the Brits or Germans tho.";}, 1702743702, 1711627072
Run Time: 0.003983
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6407124, a:1:{i:0;s:2:":<";}, 1702743702, 1711627072
Run Time: 0.003779
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6407128, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"broXcore, post: 6407124";s:8:"original";a:2:{i:0;s:33:"[quote="broXcore, post: 6407124"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:2:":<";}}i:1;s:11:"
whaaaaat?";}, 1702743702, 1711627072
Run Time: 0.004043
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6407295, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:26:"andres 3000, post: 6407066";s:8:"original";a:2:{i:0;s:36:"[quote="andres 3000, post: 6407066"]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;s:14:"i had no idea ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:54:"http://www.the-mainboard.com/index.php?members/514.70/";s:8:"original";a:2:{i:0;s:62:"[URL='http://www.the-mainboard.com/index.php?members/514.70/']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:3:"514";}}i:2;s:40:" was a raging homosexual until this page";}}i:1;s:16:"
cut me deep D:";}, 1702743702, 1711627072
Run Time: 0.002014
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6407380, a:1:{i:0;s:28:"Arsenal
Please & Thank you.";}, 1702743702, 1711627072
Run Time: 0.001025
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6559038, a:1:{i:0;s:52:"Burnley (English Championship) and Borussia Dortmund";}, 1702743702, 1711627072
Run Time: 0.000571
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6565180, a:1:{i:0;s:41:"A wild Burnley fan appears. Outstanding.";}, 1702743702, 1711627072
Run Time: 0.000433
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6571706, a:1:{i:0;s:7:"Indeed.";}, 1702743702, 1711627072
Run Time: 0.000421
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6645319, a:1:{i:0;s:200:"Going to start following Celtic b/c they're Everton's sister squad (unless they go Championship League/EPL), Werder Bremen (hope I can find them on ESPN3), and Barca (just too goddamned fun to watch).";}, 1702743702, 1711627072
Run Time: 0.000512
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6645683, a:2:{i:0;s:87:"i see that tottenham is still listed as tottenheim
what are we going to do about this ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:57:"http://www.the-mainboard.com/index.php?members/taques.45/";s:8:"original";a:2:{i:0;s:65:"[URL='http://www.the-mainboard.com/index.php?members/taques.45/']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:6:"Taques";}}}, 1702743702, 1711627072
Run Time: 0.000437
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6649237, a:3:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"broXcore, post: 6645683";s:8:"original";a:2:{i:0;s:33:"[quote="broXcore, post: 6645683"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:50:"i see that tottenham is still listed as tottenheim";}}i:1;s:2:"
";i:2;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:61:"http://the-mainboard.com/data/avatars/l/1/1055.jpg?1312806730";}}}, 1702743702, 1711627072
Run Time: 0.000427
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6661986, a:1:{i:0;s:61:"Europe- Fulham
MLS-San Jose Earthquakes
Mexico- Club Irapuato";}, 1702743702, 1711627072
Run Time: 0.000436
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6662268, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"mc415, post: 6661986";s:8:"original";a:2:{i:0;s:30:"[quote="mc415, post: 6661986"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:61:"Europe- Fulham
MLS-San Jose Earthquakes
Mexico- Club Irapuato";}}i:1;s:50:"
Fucking why on that last one. What is the point?";}, 1702743702, 1711627072
Run Time: 0.000434
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6662548, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:30:"prerecordedlive, post: 6662268";s:8:"original";a:2:{i:0;s:40:"[quote="prerecordedlive, post: 6662268"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:48:"Fucking why on that last one. What is the point?";}}i:1;s:52:"
Some people follow the league south of the border.";}, 1702743702, 1711627072
Run Time: 0.000325
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6662789, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:30:"prerecordedlive, post: 6662268";s:8:"original";a:2:{i:0;s:40:"[quote="prerecordedlive, post: 6662268"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:48:"Fucking why on that last one. What is the point?";}}i:1;s:183:"
because its my mother's hometown, when i lived in Mexico for 3 years I went to everyone of their home games and their home stadium is where i witnessed Russia v Belgium in the 86 WC";}, 1702743702, 1711627072
Run Time: 0.000442
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6663034, a:1:{i:0;s:3:":-|";}, 1702743702, 1711627072
Run Time: 0.000420
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6678910, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:23:"broXcore, post: 6645683";s:8:"original";a:2:{i:0;s:33:"[quote="broXcore, post: 6645683"]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;s:87:"i see that tottenham is still listed as tottenheim
what are we going to do about this ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:57:"http://www.the-mainboard.com/index.php?members/taques.45/";s:8:"original";a:2:{i:0;s:65:"[URL='http://www.the-mainboard.com/index.php?members/taques.45/']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:6:"Taques";}}}}i:1;s:35:"
I don't see the issue, personally";}, 1702743702, 1711627072
Run Time: 0.000313
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6678917, a:1:{i:0;s:106:"that did remind me to change west ham back to their original name since they are no longer jew thanks brox";}, 1702743702, 1711627072
Run Time: 0.000323
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6685883, a:1:{i:0;s:10:"Arsenal FC";}, 1702743702, 1711627072
Run Time: 0.000321
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6689855, a:1:{i:0;s:38:"wait, we have two stoke fans? :ohnoes:";}, 1702743702, 1711627072
Run Time: 0.000306
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 6691008, a:1:{i:0;s:39:"Put me down for Red Bulls and Tottenham";}, 1702743702, 1711627072
Run Time: 0.000315
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('xenfans_popular_forumstab_link', 'xenfans_popular_footer_link', 'navigation')
AND style_id = ?
AND language_id = ?
Params: 16, 1
Run Time: 0.000106
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 3 | Using where |