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.000358
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.000105
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: 485243
Run Time: 0.000179
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: 59
Run Time: 0.000211
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 >= 120 AND post.position < 140)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 485243
Run Time: 0.003691
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 | | 22 | 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: 485243
Run Time: 0.000064
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d0c9aa9348731a41f935207c9726d802, , 1656607130
Run Time: 0.000133
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=485243&page=7, 1656603530,
Run Time: 0.000074
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.000335
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, 11250066, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"rambo2, post: 11249603, member: 39518";s:8:"original";a:2:{i:0;s:47:"[QUOTE="rambo2, post: 11249603, member: 39518"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:181:"This team is nothing like the teams of years past. They have already used 30 different players on defense. When was the last time that had a player intercept 5 passes in a season?";}}i:1;s:696:"
In the last 20 years the cowboys have had 4 teams with defenses in the top 10 in points allowed and 7 in the top 10 in yards allowed....they still are not a shut down defense but they are much improved.
We are 4 games in and directionally look much better, but we have seen the cowboys get off to strong starts many times before and blow it in the first round.
Again, my point is this team has to show that it has the metal to win a divisional game or its not much different from what we have seen over the past decade...teams that are good in the regular season, dominant even at times, but that can't win when it really counts.
I'm optimistic, but that's what I need to see to fully buy in";}, 1616548147, 1656603530
Run Time: 0.001163
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, 11250198, a:1:{i:0;s:118:"As soon as I see Giants fans smashing their TVs and crying on YouTube, then I will know that the Cowboys are for real.";}, 1616548147, 1656603530
Run Time: 0.000543
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, 11250204, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:35:"Clove, post: 11247783, member: 5051";s:8:"original";a:2:{i:0;s:45:"[QUOTE="Clove, post: 11247783, member: 5051"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:180:"Oline - check
QB - check
RBs - check
coach- check
OC - check
WRs - check
Dline - check
DBs - check
kicker - 50/50
owner - negative
8 out of ten means we're a contender.";}}i:1;s:168:"
Can I ask... if everything is a check according to you then why is owner negative?.. wouldn't the owner be responsible for all the checks.. that's a contradiction no?";}, 1616548147, 1656603530
Run Time: 0.000311
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, 11250207, a:1:{i:0;s:108:"For real? If that means playoffs I am already convinced. If that means SB maybe 10 wins in a row will do it.";}, 1616548147, 1656603530
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, 11250604, a:1:{i:0;s:64:"If I see Jerry Jones hoist the Lombardi at the podium.
:muttley:";}, 1616548147, 1656603530
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, 11250894, a:2:{i:0;s:185:"I will start to believe when the team begins to release over paid, under performing players and starts to get rid of the sense of entitlement that’s held this team back for too long.
";i:1;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:131:"https://media0.giphy.com/media/uVDChxhD3FOuqpQOba/giphy.gif?cid=5e2148860zlp1ev62zfxx6pof5s1hihqclqtzroki64yb8xw&rid=giphy.gif&ct=g";}}}, 1616548147, 1656603530
Run Time: 0.000237
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, 11250929, a:1:{i:0;s:41:"This thread just got interesting:popcorn:";}, 1616548147, 1656603530
Run Time: 0.000245
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, 11250968, a:1:{i:0;s:67:"I believe already ! Defense needs to keep improving but they got me";}, 1616548147, 1656603530
Run Time: 0.000242
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, 11250979, a:1:{i:0;s:38:"If they actually released Jaylon Smith";}, 1616548147, 1656603530
Run Time: 0.000820
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, 11251133, a:1:{i:0;s:22:"If they keep winning !";}, 1616548147, 1656603530
Run Time: 0.000270
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, 11251150, a:1:{i:0;s:34:"Beat KC in KC. Then I'll believe.";}, 1616548147, 1656603530
Run Time: 0.000260
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, 11251151, a:1:{i:0;s:353:"I’m mostly convinced, still somewhat pending time and more proof.
We finally have good safety and DT play. We haven’t had that combo since 2007, and you just can’t win without that.
Not saying we will win the super bowl, but we look like a team that can survive the playoffs.
We still have a massive Achilles heel with our kicker and HC though.";}, 1616548147, 1656603530
Run Time: 0.000300
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, 11251164, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"sjmike, post: 11247779, member: 3636";s:8:"original";a:2:{i:0;s:46:"[QUOTE="sjmike, post: 11247779, member: 3636"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:562:"What will it take to convince you that the Cowboys are for real this season? I know that nobody wants to jump the gun and get their hearts broken when they falter at the end of the season, but is their a point where you say to yourself that this is the year?? For me, I think it would be winning the next 3 before the bye, including the Vikings game in their house. That would lead up to the bye and would give them alot of momentum towards the rest of the season. Of course, beating KC and then the Raiders on Thanksgiving would be a cherry on top. Go Cowboys!!";}}i:1;s:53:"
Jaylon Smith getting cut......................wait?";}, 1616548147, 1656603530
Run Time: 0.000632
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, 11251166, a:1:{i:0;s:37:"The release of Jaylon today for sure.";}, 1616548147, 1656603530
Run Time: 0.000260
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, 11251232, a:1:{i:0;s:108:"Not just giving a vet a spot on the team and trying to sell me that he deserves it. Oh dang, I'ma believer!!";}, 1616548147, 1656603530
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, 11251517, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"iRepDatStar, post: 11250204, member: 34796";s:8:"original";a:2:{i:0;s:52:"[QUOTE="iRepDatStar, post: 11250204, member: 34796"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:166:"Can I ask... if everything is a check according to you then why is owner negative?.. wouldn't the owner be responsible for all the checks.. that's a contradiction no?";}}i:1;s:18:"
Because 25 years.";}, 1616548147, 1656603530
Run Time: 0.000551
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, 11251522, a:1:{i:0;s:322:"Some games where we dominate. Have not seen that and most SB champs dominate at least some games in a season.We win a lot on flags and lucky turn overs which is fine as long as it is against good teams.
We need to walk away with a win on occasion. Every game with Cowboys has me puckered up in 4th quarter.
42-12 in 4th.";}, 1616548147, 1656603530
Run Time: 0.000263
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, 11251534, a:1:{i:0;s:100:"It happened yesterday when Jimmy Johnson talked about us being legit SB contenders. That will work!";}, 1616548147, 1656603530
Run Time: 0.000285
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, 11251581, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"sjmike, post: 11247779, member: 3636";s:8:"original";a:2:{i:0;s:46:"[QUOTE="sjmike, post: 11247779, member: 3636"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:562:"What will it take to convince you that the Cowboys are for real this season? I know that nobody wants to jump the gun and get their hearts broken when they falter at the end of the season, but is their a point where you say to yourself that this is the year?? For me, I think it would be winning the next 3 before the bye, including the Vikings game in their house. That would lead up to the bye and would give them alot of momentum towards the rest of the season. Of course, beating KC and then the Raiders on Thanksgiving would be a cherry on top. Go Cowboys!!";}}i:1;s:292:"
It depends on what you mean "for real" Winning the division? Winning a playoff game? Superbowl? They are for real if you are talking about wining their division or a playoff game. We have seen this before where they start out looking great even winning 13 games and chocking in the playoffs.";}, 1616548147, 1656603530
Run Time: 0.000277
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, 11251936, a:1:{i:0;s:133:"Definitely looks like the team thinks they're for real by releasing Jaylon. If you don't perform, you're out of here, contract or not";}, 1616548147, 1656603530
Run Time: 0.000541