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.000291
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: 491645
Run Time: 0.000157
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.000205
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 >= 20 AND post.position < 40)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 491645
Run Time: 0.000817
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 | | 11 | 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: 491645
Run Time: 0.000051
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 0911e27d70ca2174f155a9eedcc1e0d4, , 1660130010
Run Time: 0.000119
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=491645&page=2, 1660126410,
Run Time: 0.000063
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.000245
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, 11627875, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:31:"Dale, post: 11627870, member: 3";s:8:"original";a:2:{i:0;s:41:"[QUOTE="Dale, post: 11627870, member: 3"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:267:"Completely agree. If Dak has a lot of trash happening around his legs early in the game, I'll be concerned about his ability to remain poised. And you couldn't be more right about avoiding 3rd-and-long's. Penalties are our biggest enemy in that regard, in my opinion.";}}i:1;s:525:"
yeah the penalties and negative plays on 2nd down have killed us. Early in the year we were routinely in 3&4 3&5 etc and even when we had a 3&9 the offense was so potent we could capitalize. We aren’t that same offense tho right now and while we definitely will pick up some penalties- hopefully they are few and far between.
just usually you can tell by how dak looks back there, like you mentioned the more trash back there the worse it is for us. This team could wreck a game with their d line so we have to be ready.";}, 1616548147, 1660126410
Run Time: 0.000677
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, 11627876, a:1:{i:0;s:256:"The most overlooked thing that matters most
1)What the coaching staff has prepared for / schemes
Then
2) Establishing the run game.
3) Stopping their run game
4) OL/DL play
Dak Is the least of my concerns honestly....well this game. It's all about the OL";}, 1616548147, 1660126410
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, 11627906, a:1:{i:0;s:90:"If the refs are throwing flags on ticky tack fouls. Yes, I believe the league fixes games.";}, 1616548147, 1660126410
Run Time: 0.000261
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, 11627910, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"Tangle_Foot, post: 11627763, member: 39949";s:8:"original";a:2:{i:0;s:52:"[QUOTE="Tangle_Foot, post: 11627763, member: 39949"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:16:"The lead :laugh:";}}i:1;s:17:"
...by 14 points!";}, 1616548147, 1660126410
Run Time: 0.000298
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, 11627915, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:47:"daboyzruleperiod, post: 11627806, member: 34768";s:8:"original";a:2:{i:0;s:57:"[QUOTE="daboyzruleperiod, post: 11627806, member: 34768"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:33:"No drops & No extra point misses!";}}i:1;s:38:"
No misses in the first half, period!!";}, 1616548147, 1660126410
Run Time: 0.000518
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, 11627919, a:1:{i:0;s:333:"Definitely winning the battle in the trenches. The games the Cowboys have lost this season things started going wrong early. We have to avoid a bad start. We can’t allow San Francisco to jump on us from the get go. If we come out sputtering on offense it’s probably going to lead to a long day. We need to come out looking sharp.";}, 1616548147, 1660126410
Run Time: 0.000272
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, 11628052, a:1:{i:0;s:162:"Our Oline play. I think it’s the biggest key to the game. Can we open running lanes? Can we keep Dak relatively clean and give him time for some deep passes?";}, 1616548147, 1660126410
Run Time: 0.000213
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, 11628062, a:1:{i:0;s:499:"We have to be able to stop their run game cannot be getting gashed for 8 or 10 yd at a shot.
We need our line to be strong enough to establish a running game where we can get at least four or five yards a carrying.
Just can't be rushing Zeke into the line for 2 yd or no gain got to have something better than that for the playoffs.
No drive killing penalties.
I would love to say the kicker has to make all his reasonable distance field goals and extra points but I believe that's a bridge too far";}, 1616548147, 1660126410
Run Time: 0.000424
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, 11628067, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"Hardline, post: 11627857, member: 34872";s:8:"original";a:2:{i:0;s:49:"[QUOTE="Hardline, post: 11627857, member: 34872"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:168:"1A. Establish the run
1B. Stop the run
2. Dak to start throwing accurate catchable passes.
3. The inevitable drive killing flags that are going to come out against us.";}}i:1;s:172:"
This is it in a nutshell. If Dallas can't run and SF can run this game is over. Because Dak is going to be put in too many 3rd and 7+ and he has a conversion rate of 17%.";}, 1616548147, 1660126410
Run Time: 0.000207
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, 11628071, a:1:{i:0;s:206:"Dak and the receivers on the same page.
Dak making quick reads and decisions.
Sticking to the run even if it gets stopped.
No mistakes/turnovers on offense
A bunch of penalties that kill or sustain a drive.";}, 1616548147, 1660126410
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, 11628074, a:1:{i:0;s:61:"The ghosts of John Madden and Don Meredith in the booths...:)";}, 1616548147, 1660126410
Run Time: 0.000200