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.000487
| 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.000117
| 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: 487793
Run Time: 0.000201
| 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.000238
| 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 >= 100 AND post.position < 120)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASCParams: 487793
Run Time: 0.001495
| 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 | | 10 | 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: 487793
Run Time: 0.000058
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 37b077f68137331373f1462bd69affaf, , 1656718912
Run Time: 0.000143
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=487793&page=6, 1656715312,
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.000323
| 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, 11391145, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:44:"Lifetimeboyzfan, post: 11388800, member: 311";s:8:"original";a:2:{i:0;s:54:"[QUOTE="Lifetimeboyzfan, post: 11388800, member: 311"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:32:"We just won 43-3. Give it a rest";}}i:1;s:179:"
Just because a team dominates, does not mean there are areas the team needs to work on.
Smart teams look at their weaknesses and try to fix them regardless how much they win by.";}, 1616548147, 1656715312
Run Time: 0.001251
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, 11391158, a:1:{i:0;s:227:"He’s so garbage.
“huge gain by the Cowboys, but there’s a flag in the backfield”
Me: “holding on Connor ******* Williams sorry ass“
Ref: “Holding! Offense … number 52, repeat first down“
EVERY. DAMN. TIME!";}, 1616548147, 1656715312
Run Time: 0.000471
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, 11391332, a:1:{i:0;s:47:"Need to go back to drafting first round O line.";}, 1616548147, 1656715312
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, 11391340, a:1:{i:0;s:517:"Not only is he struggling but the refs are clearly looking at him more closely for penalties. Nate Newton made a good point a couple weeks ago saying that Connor needs to put about a 3-4 game stretch together of clean football to get off of the ref's radar. Apparently the refs watch the previous month or so of games to get a feel for each team's personnel, tendencies and such prior to officiating their game. Until Connor is able to clean things up over a stretch of games, he's going to be in the refs crosshairs.";}, 1616548147, 1656715312
Run Time: 0.000238
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, 11391345, a:1:{i:0;s:45:"This dude makes my imaginary dog bark :laugh:";}, 1616548147, 1656715312
Run Time: 0.000514
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, 11391476, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:45:"Captain43Crash, post: 11391145, member: 39788";s:8:"original";a:2:{i:0;s:55:"[QUOTE="Captain43Crash, post: 11391145, member: 39788"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:178:"Just because a team dominates, does not mean there are areas the team needs to work on.
Smart teams look at their weaknesses and try to fix them regardless how much they win by.";}}i:1;s:1899:"
just because a fan base believes what their eyes tell them and finds few sheep to get on board with narrative doesn't make it true.
lmao
ok keyboard gm....you are not payer evaluator you are fan , CW played 72 snaps last night and 2 of those penalties were questionable at best but his other what 69 snaps he was part of the big win..
the coaching STAFFS that plural the 4 OL Coaches all have put Cwill as a starter.
there's a reason he better then fans give him credit for lie old doug free and others..your opinions only matter to the 15 people that agree with you but as a NFL Professional staff they obviously dont agree..
CW is not an all pro hes not future HOF but as also not jag hes a starting oL and many are just guys , we cant have 5 Pro bowlers up there, players like Steele, biadsz, and Cwill compliment smith, martin and Collins..we are spoiled with all the great OL we have had here and believe every player needs to look like them..sorry that noit the case..you build a starting team which can consist of handful of stars or super stars but haver to have 40 others that fill necessary roles and CW is obviously filling his adequality enough that since hes been here no matter who the coaches are he keeps winning that position..
has to be good reason as they truly watch film, know the paly calls and reasonability's and who messed up plays and also see him in practice and also see his possible replacement, they obviously feel Conner is the best LG option on this team right now..
you all opinions are hollow and have no bite and really no real validity in the real NFL world..
hope you all feel better bashings players and trying hard to be internet gms , you are not....
sure he has flaws, hes not perfect but he the starter for good reason..get over it, most likely he gets big raise and another job somewhere else so you all will finally get your wish next season..";}, 1616548147, 1656715312
Run Time: 0.000294
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, 11391504, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"jwooten15, post: 11390323, member: 18660";s:8:"original";a:2:{i:0;s:50:"[QUOTE="jwooten15, post: 11390323, member: 18660"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:78:"He has more holding calls than 16 TEAMS do. He isn’t good, nor is he average";}}i:1;s:125:"
He had 4 penalties all of last year. Odds are we see his penalties start to retreat back to a normal number by seasons end.";}, 1616548147, 1656715312
Run Time: 0.000262
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, 11391678, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:49:"BleedSilverandBlue, post: 11390317, member: 41061";s:8:"original";a:2:{i:0;s:59:"[QUOTE="BleedSilverandBlue, post: 11390317, member: 41061"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:3:{i:0;s:569:"Williams isn't that bad. He's an average NFL offensive lineman. Have the penalties been a little out of control recently? Definitely. Getting that many penalties as a left guard is not sustainable long term for a starter. I think so many fans are out for #52 is because we have had an embarrassment of riches on the OL the last decade.
Looking at the situation objectively. Here is what the numbers say about Williams.
Penalties - 10 (worst in the NFL for guards)
Sacks Allowed - 1(31st in the NFL for guards)
PFF Grade 74.5 (upper quartile of starting NFL linemen)
";i:1;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:252:"I don't have a way to check his pass block and run block win rates so if anyone has a PFF subscription please feel free to add that in. I would imagine that they are not bad considering our overall win rates as an offense, but I cannot say for certain.";}}i:2;s:882:"
Basically the numbers support the opinion that he is an average-slightly above average guard that commits an extraordinary amount of penalties. The eye test also would confirm this. Do we need to try and get him to clean up the penalties? For sure. Holding penalties are drive killers. Should we look for an upgrade if at all possible? Yes, like always, but you tell me what teams are dealing starting caliber offensive linemen right now. OL is always a position of need around the league, and we are lucky to have two hall of famers (Smith, Martin), 3 average starters (Collins, Biadasz, Williams, McGovern) and a decent swing tackle (Steele) playing for us right now. There simply are not enough good offensive linemen to go around. I would not be opposed to giving McGovern a crack at the starting job, but maybe the coaching staff knows better than all of us fans on this one.";}}i:1;s:629:"
Pass - 73.4
Run - 71.1
Overall - 70.9
I'm not a huge PFF guy, but respect it as a tool. Interesting his overall is lower than both his run and pass...I would assume that means his overall grade accounts for the penalties as well. PFF has him as the #18 ranked G in the league. That wont make him a pro bowl player but its interesting to show CW vs the rest of the league. People who have issues with CW I don't think understand the state of offensive lines around the league. Tough to find guys who play well in both run blocking and pass pro. Easier to clean up the penalty issues than it is to teach a guy to pass block.";}, 1616548147, 1656715312
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, 11391774, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:45:"Captain43Crash, post: 11391145, member: 39788";s:8:"original";a:2:{i:0;s:55:"[QUOTE="Captain43Crash, post: 11391145, member: 39788"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:178:"Just because a team dominates, does not mean there are areas the team needs to work on.
Smart teams look at their weaknesses and try to fix them regardless how much they win by.";}}i:1;s:121:"
I get it. That’s probably best for coaches. It’s silly for a FAN to come in here whining after a 40 point blow out.";}, 1616548147, 1656715312
Run Time: 0.000238
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, 11391781, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:43:"ChronicCowboy, post: 11388708, member: 5280";s:8:"original";a:2:{i:0;s:53:"[QUOTE="ChronicCowboy, post: 11388708, member: 5280"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:444:"Has anyone ever seen a guy play so poorly and keep his job. He must have pictures of Jerry with call girls or something.
The coaches really need to consider playing Collins there and moving Steele back to RT when Tyron returns. The penalties and whiffs are going to keep happening and a play like that could cost the team a playoff game.
Is there anyone that thinks this guy should keep his job? Dudes in his fourth year for goodness sake.";}}i:1;s:98:"
I don’t think they have someone good enough to replace him. He had so many penalties yesterday.";}, 1616548147, 1656715312
Run Time: 0.000235