SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000286
| 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: 24606
Run Time: 0.000902
| 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: 20
Run Time: 0.000440
| 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
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (1,2,4,5,6,7,8,10)) as positive_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (14,11,12,13)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (3,9)) as neutral_rating_count
,
pr_cache.rating_cache,
pr2.rating
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)
left join dark_postrating_post_cache pr_cache ON (post.post_id = pr_cache.post_id)
left join dark_postrating pr2 on (post.post_id = pr2.post_id and pr2.user_id = 0)
WHERE post.thread_id = ?
AND (post.position >= 375 AND post.position < 400)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASCParams: 24606
Run Time: 0.003031
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 9 | Using where; Using filesort |
| PRIMARY | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,packerfo_maindb.post.post_id | 1 | |
| PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | packerfo_maindb.post.user_id | 1 | |
| PRIMARY | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | packerfo_maindb.post.user_id | 1 | |
| PRIMARY | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | packerfo_maindb.post.user_id | 1 | |
| PRIMARY | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,packerfo_maindb.post.user_id | 1 | |
| PRIMARY | session_activity | ref | PRIMARY | PRIMARY | 4 | packerfo_maindb.post.user_id | 11 | |
| PRIMARY | pr_cache | eq_ref | PRIMARY | PRIMARY | 4 | packerfo_maindb.post.post_id | 1 | |
| PRIMARY | pr2 | eq_ref | post_id_user_id,post_id_rating,user_id_rating | post_id_user_id | 8 | packerfo_maindb.post.post_id,const | 1 | |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | packerfo_maindb.post.user_id | 4 | Using where |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | packerfo_maindb.post.user_id | 4 | Using where |
| DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | packerfo_maindb.post.user_id | 4 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 24606
Run Time: 0.000185
UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 24606
Run Time: 0.000828
UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 24606
Run Time: 0.000203
SELECT thread.*
,
0 AS thread_reply_banned
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 24606
Run Time: 0.000332
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache
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: 20
Run Time: 0.000277
| 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 *
FROM xf_ignore_thread
WHERE user_id = ?
AND thread_id = ?
Params: 0, 24606
Run Time: 0.000105
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_ignore_thread | ref | user_thread | user_thread | 8 | const,const | 1 | |
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=24606&page=16, 1425663389,
Run Time: 0.000160
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('Tickets', 'Schedule', 'Draft')Params: 1
Run Time: 0.000119
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 3 | 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, 483513, a:3:{i:0;s:529:"I still can't be too angry about not trading a 3rd for Lynch. Sure, NOW we can look at it and ask, "Who would you rather have, Green or Lynch?" and it's a pretty easy solution, but we didn't know who that 3rd was we declined the trade.
A second, bigger question: Who would you rather pay? Lynch's 7.5 million per year or Green's 0.63 million per year?
Would we be better with Lynch? Yes. Could we afford to have resigned him this last off-season? We're probably going to lose Jennings because we can't afford him and the ";i:1;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:6:"really";}}i:2;s:90:" important guys (Rodgers and Matthews). Who would we have to let go because we got Lynch?";}, 1425574816, 1425663389
Run Time: 0.000499
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, 483515, a:1:{i:0;s:155:"I don't worry about the finances.
Ted has a way of working those things out okay.
We even had money to pay Driver this year, and he's just a cheerleader.";}, 1425574816, 1425663389
Run Time: 0.000297
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, 483517, a:1:{i:0;s:956:"It is real easy to 2nd guess TT after the fact.
Marshawn had a history of suspicious behavior; weapons charges; a suspension; and an issue with an abandoned vehicle: there was reasonable character doubts and year long suspension possibilities.
Perhaps he has turned his life around, just hasn't gotten caught, or takes more precautions, I don't know. But things could have turned out much differently - he could have had another DUI and been out of the league.
In hind sight, yes! I would love to have Lynch on the Packers. But, I don't fault TT in not pulling that trigger. If we could do hindsite, we should have traded Favre to the Vikes for the right to draft Peterson. We may have a few more Lombardis in the case.
But then again, we did win one Superbowl and that is no easy task. Maybe with Lynch we don't develop/get Starks. Maybe we don't win that one. In 2nd Hind Sight - I still don't sign Lynch and am proud and accept our Lombardi.";}, 1425574816, 1425663389
Run Time: 0.000363
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, 483520, a:17:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"FrankRizzo, post: 483515, member: 2232";s:8:"original";a:2:{i:0;s:48:"[quote="FrankRizzo, post: 483515, member: 2232"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:33:"I don't worry about the finances.";}}i:1;s:1:" ";i:2;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"3";s:8:"original";a:2:{i:0;s:8:"[SIZE=3]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"arial";s:8:"original";a:2:{i:0;s:12:"[FONT=arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:20:"But Thompson has to.";}}}}i:3;s:1:"
";i:4;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"FrankRizzo, post: 483515, member: 2232";s:8:"original";a:2:{i:0;s:48:"[quote="FrankRizzo, post: 483515, member: 2232"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:47:"Ted has a way of working those things out okay.";}}i:5;s:1:" ";i:6;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"3";s:8:"original";a:2:{i:0;s:8:"[SIZE=3]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"arial";s:8:"original";a:2:{i:0;s:12:"[FONT=arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:155:"So do you expect him to be able to extend Rodgers, Matthews, Raji, Jennings, and Finley? Or are at least one of those contracts not likely to work out OK? ";}}}}i:7;s:1:"
";i:8;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"FrankRizzo, post: 483515, member: 2232";s:8:"original";a:2:{i:0;s:48:"[quote="FrankRizzo, post: 483515, member: 2232"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:71:"We even had money to pay Driver this year, and he's just a cheerleader.";}}i:9;s:1:" ";i:10;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"3";s:8:"original";a:2:{i:0;s:8:"[SIZE=3]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"arial";s:8:"original";a:2:{i:0;s:12:"[FONT=arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:179:"Like every other human, Thompson makes mistakes and keeping Driver this season turned out to be a $2.3M mistake. At least there aren't any cap consequences for the 2013 cap year. ";}}}}i:11;s:1:"
";i:12;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"3";s:8:"original";a:2:{i:0;s:8:"[SIZE=3]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"arial";s:8:"original";a:2:{i:0;s:12:"[FONT=arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:29:"- - - - - - - - - - - - - - -";}}}}i:13;s:1:"
";i:14;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"3";s:8:"original";a:2:{i:0;s:8:"[SIZE=3]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"arial";s:8:"original";a:2:{i:0;s:12:"[FONT=arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:114:"Regarding Lynch: If only the Packers had won Super Bowl XLV, we wouldn't have to re- re- rehash this. ... Oh wait.";}}}}i:15;s:3:"
";i:16;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"3";s:8:"original";a:2:{i:0;s:8:"[SIZE=3]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:5:"arial";s:8:"original";a:2:{i:0;s:12:"[FONT=arial]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:381:"Seriously at the time I advocated the Packers signing the veteran RB they had rated the best among those available. Starks had been hurt for almost all of his senior year in college plus most of the 2010 season and I didn't think they should count on him for the late season push to the playoffs and then for the playoff run. I was wrong: The Packers won it all with Starks at RB. ";}}}}}, 1425574816, 1425663389
Run Time: 0.000479
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, 483529, a:1:{i:0;s:48:"I know Lynch is a good RB but we Younger RB IMO.";}, 1425574816, 1425663389
Run Time: 0.000328
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, 483530, a:1:{i:0;s:73:"To be honest, I wish you had. That dude is a monster in the NFC West. :(";}, 1425574816, 1425663389
Run Time: 0.000442
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, 483601, a:1:{i:0;s:271:"/sigh How many times are we going to keep having this exact discussion? We didn't sign Lynch. We also won the Super Bowl, without Lynch. Also, we wouldn't have been able to afford the new deal he signed for without having to mortgage someone else.
Can we move on now?";}, 1425574816, 1425663389
Run Time: 0.000380
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, 483648, a:1:{i:0;s:104:"dear god. this goes along with the Chris Johnson for Finley trade thread. Just let these threads die.";}, 1425574816, 1425663389
Run Time: 0.000295
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, 483686, a:1:{i:0;s:69:"Bury this stupid thread. How long do you want to beat his dead horse?";}, 1425574816, 1425663389
Run Time: 0.000279
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, 483687, a:1:{i:0;s:36:"Can we get this thread locked maybe?";}, 1425574816, 1425663389
Run Time: 0.000298