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.000346
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.000083
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: 488549
Run Time: 0.000176
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.000174
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 >= 40 AND post.position < 60)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 488549
Run Time: 0.001542
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: 488549
Run Time: 0.000043
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 3560d790d8e0c1cea8910fd30e085994, , 1653737264
Run Time: 0.000105
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=488549&page=3, 1653733664,
Run Time: 0.000059
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.000243
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, 11436024, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"loublue22, post: 11434896, member: 25723";s:8:"original";a:2:{i:0;s:50:"[QUOTE="loublue22, post: 11434896, member: 25723"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:45:"he's like ninth on the "reasons we lost" list";}}i:1;s:9:"
Agreed.";}, 1616548147, 1653733664
Run Time: 0.000671
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, 11436050, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"dlobell, post: 11435997, member: 22830";s:8:"original";a:2:{i:0;s:48:"[QUOTE="dlobell, post: 11435997, member: 22830"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:74:"Get real dude! The extra point I’ll give you, the 59 yard field goal, no";}}i:1;s:174:"
His nickname is "Greg the Leg" because he's supposed to have the best leg in the NFL. If you can't trust him to make a 59-yarder OR an extra point, why is he on the roster?";}, 1616548147, 1653733664
Run Time: 0.000373
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, 11436059, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"rocyaice, post: 11436003, member: 21160";s:8:"original";a:2:{i:0;s:49:"[QUOTE="rocyaice, post: 11436003, member: 21160"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:68:"I get it. I am too. Pissed off at the refs, the Cowboys....everbody.";}}i:1;s:121:"
All teams I like suck right now. All I have are the 70s and 90s memories, I'll just hold on to those. F the Joneses btw.";}, 1616548147, 1653733664
Run Time: 0.000220
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, 11436067, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"DOUBLE WING, post: 11436050, member: 28954";s:8:"original";a:2:{i:0;s:52:"[QUOTE="DOUBLE WING, post: 11436050, member: 28954"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:172:"His nickname is "Greg the Leg" because he's supposed to have the best leg in the NFL. If you can't trust him to make a 59-yarder OR an extra point, why is he on the roster?";}}i:1;s:75:"
I don't care what FG kicker you are a 59 yard FG is a 50/50 thing at best";}, 1616548147, 1653733664
Run Time: 0.000315
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, 11436092, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"Smith22, post: 11435929, member: 139";s:8:"original";a:2:{i:0;s:46:"[QUOTE="Smith22, post: 11435929, member: 139"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:189:"Did you see the Ravens last week? Lost their QB and #1 WR before the game, lost 3 RBs before the season started along with their #1 CB. Good teams find a way. Heck, the raiders found a way.";}}i:1;s:76:"
Ravens and the Cowboys both have 7 wins. I don't see much difference there.";}, 1616548147, 1653733664
Run Time: 0.000396
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, 11436104, a:1:{i:0;s:260:"Now this is a thread I can get behind. I'm so over him. I never, ever trust him when he is lining up to make a kick. Can't even make an extra point. Look over at the Raiders and here is a kicker I've never heard of nailing everything.
I'm done with Zuerlein.";}, 1616548147, 1653733664
Run Time: 0.000183
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, 11436113, a:1:{i:0;s:158:"Nobody is blaming him for the 59 yarder. They're blaming him for missing an easy extra point. If he can't make routine kicks like that, why is he on the team?";}, 1616548147, 1653733664
Run Time: 0.000180
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, 11436145, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"nightrain, post: 11435640, member: 39940";s:8:"original";a:2:{i:0;s:50:"[QUOTE="nightrain, post: 11435640, member: 39940"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:131:"Well, let's see how things go with Gregory, Cooper, Dlaw, Lamb and maybe even Gallimore in the lineup before we throw the towel in.";}}i:1;s:121:"
I hope the rest of the league thinks the Cowboys are hype, and all of those guys come in and go to work in the playoffs.";}, 1616548147, 1653733664
Run Time: 0.000181
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, 11436181, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"Doomsday, post: 11436067, member: 121";s:8:"original";a:2:{i:0;s:47:"[QUOTE="Doomsday, post: 11436067, member: 121"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:73:"I don't care what FG kicker you are a 59 yard FG is a 50/50 thing at best";}}i:1;s:318:"
I'm not trying to tell you that a 59-yard kick is easy. But if your calling card is your deep kicking ability, you should be counted on to make that.
I can live with that miss by itself, but when you couple it with a missed extra point, that's a level of incompetency you can't have from a kicker on a playoff team.";}, 1616548147, 1653733664
Run Time: 0.000361
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, 11436183, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"nightrain, post: 11436092, member: 39940";s:8:"original";a:2:{i:0;s:50:"[QUOTE="nightrain, post: 11436092, member: 39940"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:75:"Ravens and the Cowboys both have 7 wins. I don't see much difference there.";}}i:1;s:88:"
They beat the chiefs and the broncos without their #1 CB, plus countless other players.";}, 1616548147, 1653733664
Run Time: 0.000183
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, 11436203, a:1:{i:0;s:78:"Two games this year… this game and Tampa Bay are on him. I’d let him walk.";}, 1616548147, 1653733664
Run Time: 0.000254
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, 11436581, a:1:{i:0;s:249:"Agree. Inconsistency and field goal kicker are not 2 words you want associated with one another.
Somebody else earlier this year called hum 50-50 Greg and I agreed.
I do not feel confident on PATs or FG attempts.
Bout the same as a coin toss.
jmo";}, 1616548147, 1653733664
Run Time: 0.000236
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, 11436756, a:1:{i:0;s:56:"Him missing extra points is reason enough. Fire him now.";}, 1616548147, 1653733664
Run Time: 0.000409
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, 11436822, a:1:{i:0;s:55:"The difference in Kickers won the game for the Raiders.";}, 1616548147, 1653733664
Run Time: 0.000229
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, 11436845, a:1:{i:0;s:164:"This team ain't running anywhere.
It's done.
ZERO leadership.
Zero coaching.
Zero playoff wins.
It's the same old crap and Daks now part of the losing culture";}, 1616548147, 1653733664
Run Time: 0.000224
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, 11437031, a:1:{i:0;s:756:"Zeurlein cost us the Tampa Bay game and this one for sure. Because he missed the xtra point, the Boys later went for two and failed, thus losing a second point they should have had.
Why was there no free safety helping Anthony Brown cover Desean Jackson, who especially torments the Boys?
If next week we have Gregory and DLAW back on defense and Cee Dee and Amari back on offfense, I can see the team possibly going 5-1 to end up 12-5.
If we did not draft Micah Parsons, we would be 4-7 at best.
Why did not Dak pass well earlier in he game. He can't come back to win all the time. Why can't this team take the ball to start the game and score and put the opposition on its heels. The OL is not opening holes anymore. The offense is struggling.";}, 1616548147, 1653733664
Run Time: 0.000230
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, 11437073, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"grgnfg420, post: 11434967, member: 4395";s:8:"original";a:2:{i:0;s:49:"[QUOTE="grgnfg420, post: 11434967, member: 4395"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:23:"Cut Anthony brown first";}}i:1;s:34:"
Or demote him, but who's next up?";}, 1616548147, 1653733664
Run Time: 0.000253
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, 11437093, a:1:{i:0;s:24:"What about the other 52?";}, 1616548147, 1653733664
Run Time: 0.000410
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, 11437099, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:45:"SFloridaCowboy, post: 11437031, member: 41372";s:8:"original";a:2:{i:0;s:55:"[QUOTE="SFloridaCowboy, post: 11437031, member: 41372"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:755:"Zeurlein cost us the Tampa Bay game and this one for sure. Because he missed the xtra point, the Boys later went for two and failed, thus losing a second point they should have had.
Why was there no free safety helping Anthony Brown cover Desean Jackson, who especially torments the Boys?
If next week we have Gregory and DLAW back on defense and Cee Dee and Amari back on offfense, I can see the team possibly going 5-1 to end up 12-5.
If we did not draft Micah Parsons, we would be 4-7 at best.
Why did not Dak pass well earlier in he game. He can't come back to win all the time. Why can't this team take the ball to start the game and score and put the opposition on its heels. The OL is not opening holes anymore. The offense is struggling.";}}i:1;s:106:"
Take a look at the defense to why we lost. No defense should give up 36, even if the refs handed them 23.";}, 1616548147, 1653733664
Run Time: 0.000282
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, 11437246, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"SwensonDC, post: 11435547, member: 36367";s:8:"original";a:2:{i:0;s:50:"[QUOTE="SwensonDC, post: 11435547, member: 36367"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:254:"Absolutely. We also win the Tampa Bay game if not for him.
I don't understand how you consistently Miss extra points almost every single game. What's the problem? Well he needs to figure it out when his *** gets sent home for good. I'm sick of his ****.";}}i:1;s:124:"
I don’t understand how you miss extra points and short field goals that have directly lost 2 games and still have a job.";}, 1616548147, 1653733664
Run Time: 0.000240