SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000188
| 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: 21869
Run Time: 0.000566
| 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: 21
Run Time: 0.000297
| 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 >= 200 AND post.position < 225)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASCParams: 21869
Run Time: 0.003041
| 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: 21869
Run Time: 0.000185
UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 21869
Run Time: 0.000861
UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 21869
Run Time: 0.000233
SELECT thread.*
,
0 AS thread_reply_banned
FROM xf_thread AS thread
WHERE thread.thread_id = ?
Params: 21869
Run Time: 0.000304
| 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: 21
Run Time: 0.000256
| 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, 21869
Run Time: 0.000149
| 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=21869&page=9, 1425581098,
Run Time: 0.000214
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('Tickets', 'Schedule', 'Draft')Params: 1
Run Time: 0.000103
| 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, 297117, a:1:{i:0;s:91:"All I can say about this game is,
Without the Packers, the Bears would never have won.";}, 1425574816, 1425581098
Run Time: 0.001454
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, 297118, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"Irish-Sweetness, post: 297115";s:8:"original";a:2:{i:0;s:39:"[quote="Irish-Sweetness, post: 297115"]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;s:40:"Losing the close ones is what keeps you ";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:3:"out";}}i:2;s:67:" of the playoffs. We'll lay the smack down in Lambeau too remember.";}}i:1;s:124:"
We had 18 penalties and lost to you by 3. Cutler is still an average QB, he was bailed out of a few picks don't you think?";}, 1425574816, 1425581098
Run Time: 0.000491
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, 297119, a:1:{i:0;s:540:"Hey everyone. First time poster here.
Is frustrating watching such good team with such talent autodestroy like that.
Specially whe the bears outmatched the pack only in 2 things (turns out it were 2 very important things)
1. Special teams, we looked a little 2009 there and were truly outplayed, specially at the punting side.
2. Discipline, 18 penalties for 152 yrds is simply ridiculous, and it sort of shows lack of leadership from the coaching staff.
The NFL had to go back about forty years to see the penalty record that was broken.";}, 1425574816, 1425581098
Run Time: 0.000458
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, 297120, a:1:{i:0;s:545:"Hey everyone. First time poster here.
Is frustrating watching such good team with such talent autodestroy like that.
Specially whe the bears outmatched the pack only in 2 things (turns out it were 2 very important things)
1. Special teams, we looked a little 2009 there and were truly outplayed, specially at the punting side.
2. Discipline, 18 penalties for 152 yrds is simply ridiculous, and it sort of shows lack of leadership from the coaching staff.
The NFL had to go back about forty years to see the penalty record that was broken.";}, 1425574816, 1425581098
Run Time: 0.000400
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, 297121, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"Irish-Sweetness, post: 297114";s:8:"original";a:2:{i:0;s:39:"[quote="Irish-Sweetness, post: 297114"]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;s:20:"Matthews ? Who? Oh, ";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:10:"hairstyle ";}}i:2;s:64:".... didn't see much of him, no. 3-0. BEar Down fudgers ! Sweet.";}}i:1;s:66:"
Hello my Sweetness. Tell me, do you know of such a thing called ";i:2;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:7:"holding";}}i:3;s:945:"? It's a remarkable thing, you should look into it. I guess your O-Linesmen couldn't beat him one on one or two on one (even worse) so they had to resort to holding. Once they saw they weren't being called on it, they of course, continued to do it. Clever Bears, very clever. But it's not going to work at Lambeau Field. It also makes me question the manhood of several of those players. I think their coach should send them to a Woman's Football League for a few weeks, it would help. There were several other uncalled penalties in this game. Note to the refs: If you want to give the home team some leniency, next time try not to make it so obvious. 18 flags are excessive, even with the ones that were legit. You think somebodies gonna notice that?
But don't worry, Sweetness, hush little darling, don't say a word, and never mind that noise you heard, it's just the Beast under your bed.....
Now bring us those Lions!!! :chisux: :detsux:";}, 1425574816, 1425581098
Run Time: 0.000412
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, 297122, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"Kitten, post: 297121";s:8:"original";a:2:{i:0;s:30:"[quote="Kitten, post: 297121"]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;s:64:"Hello my Sweetness. Tell me, do you know of such a thing called ";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:7:"holding";}}i:2;s:945:"? It's a remarkable thing, you should look into it. I guess your O-Linesmen couldn't beat him one on one or two on one (even worse) so they had to resort to holding. Once they saw they weren't being called on it, they of course, continued to do it. Clever Bears, very clever. But it's not going to work at Lambeau Field. It also makes me question the manhood of several of those players. I think their coach should send them to a Woman's Football League for a few weeks, it would help. There were several other uncalled penalties in this game. Note to the refs: If you want to give the home team some leniency, next time try not to make it so obvious. 18 flags are excessive, even with the ones that were legit. You think somebodies gonna notice that?
But don't worry, Sweetness, hush little darling, don't say a word, and never mind that noise you heard, it's just the Beast under your bed.....
Now bring us those Lions!!! :chisux: :detsux:";}}i:1;s:141:"
Too be honest, there was A LOT more holding from your offensive line (i.e. Tauscher) than anything else, from what I saw at least...so yeah";}, 1425574816, 1425581098
Run Time: 0.000468
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, 297123, a:3:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:25:"MNVIKES4EVA, post: 297122";s:8:"original";a:2:{i:0;s:35:"[quote="MNVIKES4EVA, post: 297122"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:139:"Too be honest, there was A LOT more holding from your offensive line (i.e. Tauscher) than anything else, from what I saw at least...so yeah";}}i:1;s:220:"
Holding, on MNVIKES4EVA! 10 yard penalty. ;)
Say what you will but all those penalties were sheer madness. I hope those refs arms are sore from throwing so many flags so they won't want to throw as many this Sunday. ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:47:"http://www.packerforum.com/members/mnvikes4eva/";s:8:"original";a:2:{i:0;s:55:"[URL="http://www.packerforum.com/members/mnvikes4eva/"]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#FF5EBD";s:8:"original";a:2:{i:0;s:15:"[COLOR=#FF5EBD]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;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:0:{}}}}}}}, 1425574816, 1425581098
Run Time: 0.000387
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, 297124, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:25:"MNVIKES4EVA, post: 297122";s:8:"original";a:2:{i:0;s:35:"[quote="MNVIKES4EVA, post: 297122"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:139:"Too be honest, there was A LOT more holding from your offensive line (i.e. Tauscher) than anything else, from what I saw at least...so yeah";}}i:1;s:280:"
Every one of them but 2 deserved.
Now, if the bears committed some holding that weren't called, that's another issue...
Clifton and Tauscher were getting beaten by INSIDE moves. That means they were clearly cheating to the outside not to get beat by speed rushes. Innexcusable.";}, 1425574816, 1425581098
Run Time: 0.000389
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, 297125, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:25:"MNVIKES4EVA, post: 297122";s:8:"original";a:2:{i:0;s:35:"[quote="MNVIKES4EVA, post: 297122"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:139:"Too be honest, there was A LOT more holding from your offensive line (i.e. Tauscher) than anything else, from what I saw at least...so yeah";}}i:1;s:60:"
2-1 > 1-2
Worry about the Viqueen's problems.:star-wars2:";}, 1425574816, 1425581098
Run Time: 0.000466
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, 297126, a:1:{i:0;s:192:"Did the Bears give us any respect?
I remember Arizona in the playoffs after they won saying that we played awesome.
But then again I guess that's a divisional game...we all hate eachother aha.";}, 1425574816, 1425581098
Run Time: 0.000505