SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.000370
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 36 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000099
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
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 488863
Run Time: 0.000163
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: 3
Run Time: 0.000186
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 >= 340 AND post.position < 360)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 488863
Run Time: 0.001643
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 | | 20 | Using index condition; Using where; Using filesort |
SIMPLE | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,cowboyszone.post.post_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | cowboyszone.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | cowboyszone.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | cowboyszone.post.user_id | 1 | |
SIMPLE | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,cowboyszone.post.user_id | 1 | Using where |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | cowboyszone.post.user_id,func | 1 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 488863
Run Time: 0.000055
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 71ea9ac172bbb0e270401d245a5c5969, , 1656509239
Run Time: 0.000111
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, , , XenForo_ControllerPublic_Thread, Index, valid, thread_id=488863&page=18, 1656505639,
Run Time: 0.000058
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', 'thread_view', 'dark_taigachat', 'dark_taigachat_list', 'siropu_custom_tabs_child_list', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 1
Run Time: 0.000254
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 12 | Using where |
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, 11451998, a:1:{i:0;s:28:"Seattle offense is horrible.";}, 1616548147, 1656505639
Run Time: 0.001139
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, 11451999, a:1:{i:0;s:77:"So where is Russell Wilson playing next year?
I say he's going to the Giants";}, 1616548147, 1656505639
Run Time: 0.000633
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, 11452000, a:1:{i:0;s:137:"Yo Russ is alll OUT. He’s done in Seattle and yes I k ow he’s not healthy but he won’t be a seahawk next year.. oh 1st down run lol";}, 1616548147, 1656505639
Run Time: 0.000250
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, 11452001, a:1:{i:0;s:24:"Just keep running, Russ.";}, 1616548147, 1656505639
Run Time: 0.000233
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, 11452002, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"jazzcat22, post: 11451970, member: 1069";s:8:"original";a:2:{i:0;s:49:"[QUOTE="jazzcat22, post: 11451970, member: 1069"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:120:"we should be concerned.
They win tonight, and next week, and we lose Thursday, then they Beat us, they are in 1st place.";}}i:1;s:314:"
If they do, then they deserve it, so I'm not concerned. It means nothing for this team to back into the playoffs. What we want is ahead of us, we just have to seize it. So that's my way of saying, I don't care what Washington does, only what we do. If we get the job done, there's no way Washington can catch us.";}, 1616548147, 1656505639
Run Time: 0.000239
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, 11452003, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"Romo_To_Dez, post: 11451972, member: 29020";s:8:"original";a:2:{i:0;s:52:"[QUOTE="Romo_To_Dez, post: 11451972, member: 29020"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:116:"Eagles fans want him, but would they be a much better situation for Russel than the one is has in Seattle right now?";}}i:1;s:159:"
I have no clue if it's a better situation..I don't think he would want to go there. I mean, Philly is Philly. Ciara might steer that thing to a better market.";}, 1616548147, 1656505639
Run Time: 0.002115
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, 11452005, a:1:{i:0;s:29:"Where are these throws going?";}, 1616548147, 1656505639
Run Time: 0.000214
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, 11452006, a:1:{i:0;s:27:"No P.I. on metcalf?
what ?";}, 1616548147, 1656505639
Run Time: 0.000408
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, 11452007, a:1:{i:0;s:56:"Wilson looked at Metcalf all the way on that…bad play.";}, 1616548147, 1656505639
Run Time: 0.000233
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, 11452008, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"Direwolf63, post: 11451999, member: 418";s:8:"original";a:2:{i:0;s:49:"[QUOTE="Direwolf63, post: 11451999, member: 418"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:77:"So where is Russell Wilson playing next year?
I say he's going to the Giants";}}i:1;s:73:"
Nah they have too much to rebuild, I’m thinking New Orleans or Denver.";}, 1616548147, 1656505639
Run Time: 0.000232
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, 11452010, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"Direwolf63, post: 11451999, member: 418";s:8:"original";a:2:{i:0;s:49:"[QUOTE="Direwolf63, post: 11451999, member: 418"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:77:"So where is Russell Wilson playing next year?
I say he's going to the Giants";}}i:1;s:16:"
Philly or WFT.";}, 1616548147, 1656505639
Run Time: 0.000291
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, 11452011, a:1:{i:0;s:57:"Russ got hurt and forgot how to play football. Crazy lol.";}, 1616548147, 1656505639
Run Time: 0.000529
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, 11452013, a:1:{i:0;s:71:"I mean there are men WIDE open every drive and Russ is missing the read";}, 1616548147, 1656505639
Run Time: 0.000247
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, 11452014, a:1:{i:0;s:80:"WFT looking at their new QB play right now .
Russel is going to the foreskins .";}, 1616548147, 1656505639
Run Time: 0.000228
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, 11452015, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"JayFord, post: 11452013, member: 40406";s:8:"original";a:2:{i:0;s:48:"[QUOTE="JayFord, post: 11452013, member: 40406"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:71:"I mean there are men WIDE open every drive and Russ is missing the read";}}i:1;s:25:"
Shhhh only Dak does that";}, 1616548147, 1656505639
Run Time: 0.000208
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, 11452016, a:1:{i:0;s:249:"This is a prime example of why not to get all worked up over playing a 1st place schedule. Dallas gets the 3rd place schedule and gets ‘zona while WFT plays the 1st place schedule and gets a putrid Seattle team. The NFL is a year to year league.";}, 1616548147, 1656505639
Run Time: 0.000205
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, 11452017, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:45:"Bob-Lillys-War, post: 11452014, member: 40263";s:8:"original";a:2:{i:0;s:55:"[QUOTE="Bob-Lillys-War, post: 11452014, member: 40263"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:80:"WFT looking at their new QB play right now .
Russel is going to the foreskins .";}}i:1;s:10:"
:muttley:";}, 1616548147, 1656505639
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, 11452018, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"jazzcat22, post: 11451994, member: 1069";s:8:"original";a:2:{i:0;s:49:"[QUOTE="jazzcat22, post: 11451994, member: 1069"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:206:"Yes, as I consider that game as a must win. Especially if WFT wins tonight. actually I consider the next 3 games as must wins.
Beat NO to get back on track. Then beat WFT and NYG as they are division games.";}}i:1;s:164:"
If the Cowboys come out and beat the Saints, especially in dominant fashion then that will calm down talks about the WFT coming back to win the division a little.";}, 1616548147, 1656505639
Run Time: 0.000203
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, 11452019, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:35:"Jake, post: 11451958, member: 39211";s:8:"original";a:2:{i:0;s:45:"[QUOTE="Jake, post: 11451958, member: 39211"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:289:"He's got no running game, a bad offensive line, and the WFT have had the ball for over 30 of the game's first 45 minutes.
He's completed over 60% of his passes, when he's had time to throw them.
But thank you for reminding me how this fan base blames the QB for games like last Thursday.";}}i:1;s:335:"
This game is nothing like last Thursday. Dak missed open guys but he still moved the ball. Russ can't even manage a first down. Yes the protection has been bad but he still can't throw an accurate pass.
And he's part of the reason the skins have had the ball all game. If u can't get a first down on offense that tends to happen";}, 1616548147, 1656505639
Run Time: 0.000197
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, 11452020, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"Direwolf63, post: 11451999, member: 418";s:8:"original";a:2:{i:0;s:49:"[QUOTE="Direwolf63, post: 11451999, member: 418"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:77:"So where is Russell Wilson playing next year?
I say he's going to the Giants";}}i:1;s:15:"
Cowboys backup";}, 1616548147, 1656505639
Run Time: 0.000195