Page Time: 0.8449s

Memory: 14.2019 MB (Peak: 16.2779 MB)

Queries (39, time: 0.0210s, 2.5%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000141
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  2. SELECT thread.*
    	,
    		user.gender, user.avatar_date, user.gravatar,
    		NULL AS thread_read_date,
    		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: 31649
    Run Time: 0.000640
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
    SIMPLEuserconstPRIMARYPRIMARY4const1 
  3. 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.000296
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  4. 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.*,
    		signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
    		0 AS like_date, session.view_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
    	,
    pr2.rating, 
    	pr.*, post.post_id
    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_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 OUTER JOIN xf_session_activity AS session ON post.user_id = session.user_id
    LEFT JOIN dark_postrating pr2 ON (post.post_id = pr2.post_id and pr2.user_id = 0)
    LEFT JOIN (
    select 
    pivot_pr.post_id
    , sum(case when pivot_pr.rating = 1 then 1 else 0 end) dark_postrating_1_count
    , sum(case when pivot_pr.rating = 14 then 1 else 0 end) dark_postrating_14_count
    , sum(case when pivot_pr.rating = 2 then 1 else 0 end) dark_postrating_2_count
    , sum(case when pivot_pr.rating = 3 then 1 else 0 end) dark_postrating_3_count
    , sum(case when pivot_pr.rating = 4 then 1 else 0 end) dark_postrating_4_count
    , sum(case when pivot_pr.rating = 5 then 1 else 0 end) dark_postrating_5_count
    , sum(case when pivot_pr.rating = 6 then 1 else 0 end) dark_postrating_6_count
    , sum(case when pivot_pr.rating = 7 then 1 else 0 end) dark_postrating_7_count
    , sum(case when pivot_pr.rating = 8 then 1 else 0 end) dark_postrating_8_count
    , sum(case when pivot_pr.rating = 9 then 1 else 0 end) dark_postrating_9_count
    , sum(case when pivot_pr.rating = 10 then 1 else 0 end) dark_postrating_10_count
    , sum(case when pivot_pr.rating = 11 then 1 else 0 end) dark_postrating_11_count
    , sum(case when pivot_pr.rating = 12 then 1 else 0 end) dark_postrating_12_count
    , sum(case when pivot_pr.rating = 13 then 1 else 0 end) dark_postrating_13_count
    
    		
    from dark_postrating pivot_pr 
    use index (`post_id_rating`)
    left join xf_post pivot_post on (pivot_pr.post_id = pivot_post.post_id)
    where pivot_post.thread_id = 31649
    group by pivot_pr.post_id
    ) pr on (pr.post_id = post.post_id)
    
    
    WHERE post.thread_id = ?
    	 AND (post.position >= 25 AND post.position < 50) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 31649
    Run Time: 0.005065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 24Using where; Using temporary; Using filesort
    PRIMARYbb_code_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.post_id1 
    PRIMARYusereq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYuser_profileeq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYsignature_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.user_id1 
    PRIMARYsessionALLPRIMARY   222 
    PRIMARYpr2eq_refpost_id_user_id,post_id_rating,user_id_ratingpost_id_user_id8packerfo_maindb.post.post_id,const1 
    PRIMARY<derived5>ALL    10 
    DERIVEDpivot_postrefPRIMARY,thread_id_post_date,thread_id_positionthread_id_position4 164Using where; Using index; Using temporary; Using filesort
    DERIVEDpivot_prrefpost_id_ratingpost_id_rating4packerfo_maindb.pivot_post.post_id2Using index
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
  5. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 31649
    Run Time: 0.000193
  6. UPDATE xf_session_activity
    SET xf_session_activity.view_count = xf_session_activity.view_count + 1
    WHERE ip = ? AND user_id = 0
    Params: 6[]
    Run Time: 0.000812
  7. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 31649
    Run Time: 0.000820
  8. SELECT thread.*
    	
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 31649
    Run Time: 0.000340
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
  9. 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.000308
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  10. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 31649
    Run Time: 0.000120
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_ignore_threadrefuser_threaduser_thread8const,const1 
  11. SELECT view_count
    FROM xf_session_activity
    WHERE ip = ? AND user_id = 0
    Params: 6[]
    Run Time: 0.000264
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityALLPRIMARY   222Using where
  12. 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, 6[], 6[], XenForo_ControllerPublic_Thread, Index, valid, thread_id=31649&page=2, 1408552328,
    Run Time: 0.000150
  13. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('Tickets', 'Schedule', 'Draft')
    Params: 1
    Run Time: 0.000130
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 3Using where
  14. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('offline')
    Params: 1
    Run Time: 0.000145
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY106const,const1 
  15. 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, 401892, a:1:{i:0;s:407:"It's easy to spot a bandwagon fan. When the team is losing, they are the fans you are looking for because they are nowhere to be found. They're usually the first to jump on the bandwagon and also the first to jump off if things go wrong. Look who is around when the team is 4-12, who is still wearing their gear with pride. It comes down to simple loyalty. Bandwagon fans are only loyal to the winning side.";}, 1406210135, 1408552328
    Run Time: 0.000482
  16. 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, 401893, a:1:{i:0;s:141:"No one can ever accuse me of being a bandwagonner ... I hit Dick Butkus in the helmet with an ice ball (come on...I was only 13 at the time).";}, 1406210135, 1408552328
    Run Time: 0.000444
  17. 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, 401894, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"Forget Favre, post: 401805, member: 2006";s:8:"original";a:2:{i:0;s:50:"[quote="Forget Favre, post: 401805, member: 2006"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:464:"We could start a list. You just might be a Green Bay Packers bandwagon fan.... If anyone who is part of this forum and isn't active at least 3-4 times a week. If you give that fan a poke. Blood red? Bandwagon fan. If you did not burn your Brett Favre jersey when he went to the Vikings. If you cannot point out Green Bay on a map. Blindfolded. If you think that Lambeau Field is named after a corporation or product. If you have a tattoo of another football team.";}}i:1;s:215:" The "like" came in after the bleed red comment. I did not burn my Favre jersey, but I did throw it away. My roommate, a Vikings fan, noticed it and asked if he could have is. Vikings fans.... they have no pride!";}, 1406210135, 1408552328
    Run Time: 0.000457
  18. 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, 401896, a:1:{i:0;s:366:"When the Packers were losing in '05 and '09, I wore my Green and Gold even more proudly, while right now I wear it but not quite as often because I get self-conscious of people thinking that I am a bandwagon fan! Kinda crazy, but thats the way I am. I couldn't believe all the frickin Packers stuff I saw the day after the SB. Where were all these people before?!";}, 1406210135, 1408552328
    Run Time: 0.000450
  19. 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, 401898, a:1:{i:0;s:72:"If I was a fair weather fan I don't think I'd still be a KU football fan";}, 1406210135, 1408552328
    Run Time: 0.000357
  20. 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, 401900, a:1:{i:0;s:372:"If the only Packer gear they own is from the last 2 years. I'm mighty suspicious of the Beef O'Brady's crowd here. The bar was BUZZING with Packer fans this past week, yet 70-80% of the crowd were wearing some sort of Super Bowl paraphernalia. Don't get me wrong, I've spent nearly $300 on Super Bowl shenanigans over the last 10 months, but I have a jersey for Sundays :P";}, 1406210135, 1408552328
    Run Time: 0.000540
  21. 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, 401903, a:6:{i:0;s:314:"I feel I have no room to talk, since I've only been a fan for four years (I've watched them since 2007), but my parents are diehards, if that counts for anything. I've only missed one Packers game since 2007 though, even during 2008, and that was the Packers-Rams game of this year. That was because I overslept. ";i:1;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"slaughter25, post: 401789, member: 3912";s:8:"original";a:2:{i:0;s:49:"[quote="slaughter25, post: 401789, member: 3912"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:204:"Ask them who was the QB before brett favre, or who invented the Lambeau Leap, or whats the greatest catch in MNF history. Pretty much anyone who has been following the team for 10+ years should know that.";}}i:2;s:500:" I'll name 5 QBs before Favre. Don Majkowski Lynn Dickey Babe Parilli Tobin Rote Steve Bartkowski (Starr's replacement in the 60s) Leroy Butler invented the Lambeau Leap. I believe it was during a game in 1993 against the Los Angeles Raiders when Reggie White caused the Raiders' QB to fumble. He picked it up himself, but was pushed out of bounds, so he lateraled the ball to Butler, who ran it in for a TD, and jumped into the stands. The greatest MNF catch in the history of football is this: ";i:3;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[media=youtube]";i:1;s:8:"[/media]";}s:8:"children";a:1:{i:0;s:11:"m_dQrqiFIKI";}}}}i:4;s:1:" ";i:5;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:50:"I still own a videotape of the original broadcast.";}}}, 1406210135, 1408552328
    Run Time: 0.000452
  22. 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, 401915, a:1:{i:0;s:141:"I always get a lot of hate because Im from Chicago, but my Dad was a Pack fan since 1966 (when he was born) so I liked all the teams he does.";}, 1406210135, 1408552328
    Run Time: 0.000446
  23. 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, 401939, a:1:{i:0;s:45:"you are a bandwagoner if you are a Farve fan";}, 1406210135, 1408552328
    Run Time: 0.000402
  24. 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, 401950, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"cheesehurdler, post: 401903, member: 3981";s:8:"original";a:2:{i:0;s:51:"[quote="cheesehurdler, post: 401903, member: 3981"]";i:1;s:8:"[/quote]";}s:8:"children";a:5:{i:0;s:814:"I feel I have no room to talk, since I've only been a fan for four years (I've watched them since 2007), but my parents are diehards, if that counts for anything. I've only missed one Packers game since 2007 though, even during 2008, and that was the Packers-Rams game of this year. That was because I overslept. I'll name 5 QBs before Favre. Don Majkowski Lynn Dickey Babe Parilli Tobin Rote Steve Bartkowski (Starr's replacement in the 60s) Leroy Butler invented the Lambeau Leap. I believe it was during a game in 1993 against the Los Angeles Raiders when Reggie White caused the Raiders' QB to fumble. He picked it up himself, but was pushed out of bounds, so he lateraled the ball to Butler, who ran it in for a TD, and jumped into the stands. The greatest MNF catch in the history of football is this: ";i:1;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[media=youtube]";i:1;s:8:"[/media]";}s:8:"children";a:1:{i:0;s:11:"m_dQrqiFIKI";}}}}i:2;s:1:" ";i:3;a:4:{s:3:"tag";s:4:"left";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LEFT]";i:1;s:7:"[/LEFT]";}s:8:"children";a:1:{i:0;s:50:"I still own a videotape of the original broadcast.";}}i:4;s:1:" ";}}i:1;s:42:" Ummmm, I think you mean Zeke Bratkowski.";}, 1406210135, 1408552328
    Run Time: 0.000562
  25. 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, 401955, a:1:{i:0;s:212:"Funny San Diego fans calling Packers fans "Bandwagon fans." They're the most flippant, indifferent fans of any fanbase out there. Even die hard Chargers fans will tell you that about the majority of their "fans."";}, 1406210135, 1408552328
    Run Time: 0.000437
  26. 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, 401970, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:31:"weeds, post: 401893, member: 39";s:8:"original";a:2:{i:0;s:41:"[quote="weeds, post: 401893, member: 39"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:141:"No one can ever accuse me of being a bandwagonner ... I hit Dick Butkus in the helmet with an ice ball (come on...I was only 13 at the time).";}}i:1;s:37:" I would love to have seen that. LOL";}, 1406210135, 1408552328
    Run Time: 0.000451
  27. 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, 401975, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"Forget Favre, post: 401805, member: 2006";s:8:"original";a:2:{i:0;s:50:"[quote="Forget Favre, post: 401805, member: 2006"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:152:"We could start a list. You just might be a Green Bay Packers bandwagon fan.... If you did not burn your Brett Favre jersey when he went to the Vikings.";}}i:1;s:150:" Hilarious! My mom boxed and mailed hers up, and honestly paid to ship it directly to his house in Mississippi! Does that count instead of burning it?";}, 1406210135, 1408552328
    Run Time: 0.000457
  28. 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, 401985, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"FrankRizzo, post: 401975, member: 2232";s:8:"original";a:2:{i:0;s:48:"[quote="FrankRizzo, post: 401975, member: 2232"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:149:"Hilarious! My mom boxed and mailed hers up, and honestly paid to ship it directly to his house in Mississippi! Does that count instead of burning it?";}}i:1;s:97:" Man I wish I would of thought of that!! lol... I wonder how much stuff he got sent to him?!?!!!";}, 1406210135, 1408552328
    Run Time: 0.000549
  29. 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, 401989, a:1:{i:0;s:471:"Bandwagon fans don't bother me. Better late than never. I know they will be gone to the next big thing when the time comes, so be it. I feel bad for these people. The fun for me is the build up of a champion. Watching these young players come in from college and take their lumps. Playing hard and smart and becoming impact players. We watched them develop and there is a certain satisfaction and sweetness to that. The bandwagon folks will never experience that.";}, 1406210135, 1408552328
    Run Time: 0.000454
  30. 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, 401990, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"AmishMafia, post: 401989, member: 2846";s:8:"original";a:2:{i:0;s:48:"[quote="AmishMafia, post: 401989, member: 2846"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:463:"Bandwagon fans don't bother me. Better late than never. I know they will be gone to the next big thing when the time comes, so be it. I feel bad for these people. The fun for me is the build up of a champion. Watching these young players come in from college and take their lumps. Playing hard and smart and becoming impact players. We watched them develop and there is a certain satisfaction and sweetness to that. The bandwagon folks will never experience that.";}}i:1;s:19:" Excellent post!:)";}, 1406210135, 1408552328
    Run Time: 0.000471
  31. 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, 402007, a:1:{i:0;s:1894:"First you have to be able to distinguish what being casual fan is, in comparison to a diehard fan. The diehard fan will know everything about the team dating back to the 1930's or it's inception. The Casual fan knows who most of the players are on the team currently, most of the legends and iconic players but won't know who the backup punter was on the 1982 packers team or a lot of the historical and intricate trivia about the team. Most Casual fans tends to be fairweather, but that doesn't mean they aren't fans necessarily. To be honest, I'm a fairweather Phillies fan (even though I don't particularly care for baseball) and only will pay attention to the team if they are doing well or are in the playoffs, I know most of the players, some of the coaches but really nothing beyond that. I grew up outside Philly so I'm kind of a Phillies fan by default. My dad is the big Packers fan and naturally past it on to me, but even he was never as hardcore about it as I am. Sometimes over the internet it's harder to spot the bangwagoners because of the ease of access to information. Within 3 minutes of searching I can answer all your test questions. In real life it's easier. It's also timing. Usually a team that is showing promise, doing well, or is projected to do well, or has a history of doing well will acquire the most bandwagon fans. That's why no team in the NFL has more bandwagon fans that the Steelers, always do well, have a history of doing well, family owned, do things the right way, 6 titles, "lunch pail team" even though there isn't a Steel factory left standing in Pittsburgh. I cannot express how much I hate the Steelers and their fanbase and I'm glad we beat them in the SB. I know a ton of Steelers fans around here in the philly area. I once quizzed some idiot wearing a Steel Curtain t-shirt. He couldn't even name 4 players on the 1975 Steelers defense.";}, 1406210135, 1408552328
    Run Time: 0.000527
  32. 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, 402009, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"peteralan71, post: 401894, member: 5418";s:8:"original";a:2:{i:0;s:49:"[quote="peteralan71, post: 401894, member: 5418"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:211:"The "like" came in after the bleed red comment. I did not burn my Favre jersey, but I did throw it away. My roommate, a Vikings fan, noticed it and asked if he could have is. Vikings fans.... they have no pride!";}}i:1;s:40:" You take football way too serious brah";}, 1406210135, 1408552328
    Run Time: 0.000402
  33. 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, 402011, a:1:{i:0;s:346:"Yeah, my friend were driving around San Diego and saw a lot of Packer fans walking down the street. He insisted bandwagon fans wore replica jerseys instead of buying the authentic ones. LOL. I reminded him I don't have any jerseys and I damn sure ain't a bandwagoner. I have my heart broken many a time by this team even though I am fairly young.";}, 1406210135, 1408552328
    Run Time: 0.000407
  34. 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, 402012, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"Southpaw, post: 402007, member: 5186";s:8:"original";a:2:{i:0;s:46:"[quote="Southpaw, post: 402007, member: 5186"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:1894:"First you have to be able to distinguish what being casual fan is, in comparison to a diehard fan. The diehard fan will know everything about the team dating back to the 1930's or it's inception. The Casual fan knows who most of the players are on the team currently, most of the legends and iconic players but won't know who the backup punter was on the 1982 packers team or a lot of the historical and intricate trivia about the team. Most Casual fans tends to be fairweather, but that doesn't mean they aren't fans necessarily. To be honest, I'm a fairweather Phillies fan (even though I don't particularly care for baseball) and only will pay attention to the team if they are doing well or are in the playoffs, I know most of the players, some of the coaches but really nothing beyond that. I grew up outside Philly so I'm kind of a Phillies fan by default. My dad is the big Packers fan and naturally past it on to me, but even he was never as hardcore about it as I am. Sometimes over the internet it's harder to spot the bangwagoners because of the ease of access to information. Within 3 minutes of searching I can answer all your test questions. In real life it's easier. It's also timing. Usually a team that is showing promise, doing well, or is projected to do well, or has a history of doing well will acquire the most bandwagon fans. That's why no team in the NFL has more bandwagon fans that the Steelers, always do well, have a history of doing well, family owned, do things the right way, 6 titles, "lunch pail team" even though there isn't a Steel factory left standing in Pittsburgh. I cannot express how much I hate the Steelers and their fanbase and I'm glad we beat them in the SB. I know a ton of Steelers fans around here in the philly area. I once quizzed some idiot wearing a Steel Curtain t-shirt. He couldn't even name 4 players on the 1975 Steelers defense.";}}i:1;s:158:" It also depends on how old one is as well. I became a fan when Reggie came from Philly which was in '93 (I was 13). But it's been green/gold ever since then.";}, 1406210135, 1408552328
    Run Time: 0.000454
  35. 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, 402013, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"nurse_sa, post: 401828, member: 5584";s:8:"original";a:2:{i:0;s:46:"[quote="nurse_sa, post: 401828, member: 5584"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:757:"hahaha wow ALBERT Rodgers! I got questioned a lot at the San Diego game by Chargers fans and a few Packers fans about my reasons on why I was a GB fan. Big mistake on their part. I talked forever at times leaving a few Chargers people giving up and just walking away, one GB fan had no idea who Bart Starr was, and when I mentioned to a supposed long-time Packers fan about how sad I was when Reggie White died he looked at me like "who the hell is that?" We all have our reasons. I have my father to thank. He would throw in a couple of Vince Lombardi's quotes throughout my childhood, he kept me on my toes about what was going on in the NFL, and he always told me that there was nothing wrong with being a girl and loving the Green Bay Packers. :inlove:";}}i:1;s:697:" Yeah I had somebody make the mistake of claiming I only became a fan of the team after they won this past Super Bowl. Well, he got cussed out for that comment. LOL. My history of being a Packers fan is only over 18 years but I have been disappointed several times (SB loss to the Broncos, Ray Rhodes as coach (oyvey!), 4th and 26, Terrell Owens catching the game winning TD after he had fumbled a couple of plays earlier (which the Pack did not review), the good, the bad, and the ugly that is Brett Favre, Mike Sherman as coach, 4-12 and 8-8 seasons...yeah). Heck there are pics of me in high school rocking Packers sweatshirts and t-shirts so please don't use the word, "bandwagoner" around me.";}, 1406210135, 1408552328
    Run Time: 0.000583
  36. 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, 402017, a:1:{i:0;s:465:"Doesn't really matter to me to be honest. If they bought an Aaron Rodgers Jersey and thought his name was Antonio whatever, he's showing support for the team I love and is rooting for them to win, that's all that counts at the end of it. If the person isn't claiming to be a die hard then why should anyone being giving them the Green Bay IQ test to prove otherwise? The ones who matter will stick tight and when things get rough we will see "fans" get weeded out.";}, 1406210135, 1408552328
    Run Time: 0.000478
  37. 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, 402020, a:2:{i:0;s:84:"The reaction of this little old lady is a perfect representation of bandwagon fans: ";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[media=youtube]";i:1;s:8:"[/media]";}s:8:"children";a:1:{i:0;s:11:"V8F5wFtPwpg";}}}, 1406210135, 1408552328
    Run Time: 0.000463
  38. 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, 402021, a:1:{i:0;s:172:"I have a friend at work , I think he is in his late 50's, he was born in Racine,,,,,,he does not know the name of the head coach. But he does"root for the team that is 8-0"";}, 1406210135, 1408552328
    Run Time: 0.000435
  39. 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, 402023, a:1:{i:0;s:36:"WHAT? He can't name Mark McCarthy?!?";}, 1406210135, 1408552328
    Run Time: 0.000407

Included Files (172, XenForo Classes: 65)

  1. index.php
  2. library/XenForo/Autoloader.php
  3. library/XenForo/Application.php
  4. library/Zend/Registry.php
  5. library/Lgpl/utf8.php
  6. library/Zend/Config.php
  7. library/config.php
  8. library/XenForo/FrontController.php
  9. library/XenForo/Dependencies/Public.php
  10. library/XenForo/Dependencies/Abstract.php
  11. library/Zend/Controller/Request/Http.php
  12. library/Zend/Controller/Request/Abstract.php
  13. library/Zend/Uri.php
  14. library/Zend/Controller/Response/Http.php
  15. library/Zend/Controller/Response/Abstract.php
  16. library/XenForo/Model/DataRegistry.php
  17. library/XenForo/Model.php
  18. library/Zend/Cache.php
  19. library/Zend/Cache/Backend/Memcached.php
  20. library/Zend/Cache/Backend/ExtendedInterface.php
  21. library/Zend/Cache/Backend/Interface.php
  22. library/Zend/Cache/Backend.php
  23. library/Zend/Cache/Core.php
  24. library/XenForo/CodeEvent.php
  25. library/XenForo/Options.php
  26. library/XenForo/Link.php
  27. library/XenForo/Template/Helper/Core.php
  28. library/sonnb/XenGallery/Listener.php
  29. library/bdTagMe/Listener.php
  30. library/bdTagMe/Helper/Template.php
  31. library/BannedAvatar/Listener.php
  32. library/XenForo/Router.php
  33. library/XenForo/Route/Filter.php
  34. library/XenForo/Route/Interface.php
  35. library/XenForo/Route/ResponseSuffix.php
  36. library/XenForo/Route/Prefix.php
  37. library/XenForo/Route/Prefix/Threads.php
  38. library/EWRporta/Listener/Route.php
  39. library/EWRporta/Route/Thread.php
  40. library/XenForo/RouteMatch.php
  41. library/XenForo/ControllerPublic/Thread.php
  42. library/XenForo/ControllerPublic/Abstract.php
  43. library/XenForo/Controller.php
  44. library/ModerateCountry/RegisterListener.php
  45. library/MailChimp/Listener.php
  46. library/AddOnInstaller/Listener.php
  47. library/SportsNetwork/Listener.php
  48. library/EWRporta/Listener/Controller.php
  49. library/Dark/PostRating/EventListener.php
  50. library/Nobita/IgnoreThread/Listener.php
  51. library/Nobita/LimitGuestThreadPageView/Listener.php
  52. library/SportsNetwork/ControllerPublic/Thread.php
  53. library/EWRporta/ControllerPublic/Thread.php
  54. library/sonnb/XenGallery/XenForo/ControllerPublic/Thread.php
  55. library/Nobita/IgnoreThread/ControllerPublic/Thread.php
  56. library/Nobita/LimitGuestThreadPageView/ControllerPublic/Thread.php
  57. library/XenForo/Input.php
  58. library/XenForo/Session.php
  59. library/Zend/Db.php
  60. library/Zend/Db/Adapter/Mysqli.php
  61. library/Zend/Db/Adapter/Abstract.php
  62. library/Zend/Db/Select.php
  63. library/Zend/Db/Expr.php
  64. library/Zend/Db/Profiler.php
  65. library/Zend/Db/Statement/Mysqli.php
  66. library/Zend/Db/Statement.php
  67. library/Zend/Db/Statement/Interface.php
  68. library/XenForo/Helper/Ip.php
  69. library/XenForo/Visitor.php
  70. library/XenForo/Model/User.php
  71. library/Waindigo/JoinUserGroup/Listener/LoadClass.php
  72. library/Waindigo/Listener/LoadClass.php
  73. library/Waindigo/Listener/LoadClass/20131003.php
  74. library/Asp/OnlineStatus/Plugin/Plugin.php
  75. library/EWRporta/Listener/Model.php
  76. library/Dark/TaigaChat/EventListener/Listener.php
  77. library/sonnbThreadMassActions/Listener.php
  78. library/Waindigo/JoinUserGroup/Extend/XenForo/Model/User.php
  79. library/Dark/PostRating/Model/User.php
  80. library/sonnb/XenGallery/XenForo/Model/User.php
  81. library/bdTagMe/XenForo/Model/User.php
  82. library/Zend/Db/Profiler/Query.php
  83. library/XenForo/Permission.php
  84. library/XenForo/Phrase.php
  85. library/XenForo/Locale.php
  86. library/EWRporta/Model/Perms.php
  87. library/Waindigo/JoinUserGroup/Listener/ControllerPreDispatch.php
  88. library/Waindigo/Listener/ControllerPreDispatch.php
  89. library/Waindigo/Listener/ControllerPreDispatch/20140603.php
  90. library/Waindigo/Listener/Template/20140101.php
  91. library/Waindigo/Listener/TemplateHook/20130522.php
  92. library/Waindigo/Listener/TemplateCreate/20130522.php
  93. library/Waindigo/Listener/InitDependencies.php
  94. library/Waindigo/Listener/InitDependencies/20140401.php
  95. library/XenForo/Model/Session.php
  96. library/Dark/PostRating/Model/Session.php
  97. library/Dark/TaigaChat/Model/SessionOverride.php
  98. library/Nobita/LimitGuestThreadPageView/Model/Session.php
  99. library/XenForo/ControllerHelper/ForumThreadPost.php
  100. library/XenForo/ControllerHelper/Abstract.php
  101. library/XenForo/Model/Thread.php
  102. library/BannedAvatar/Helper.php
  103. library/Dark/PostRating/Model/Thread.php
  104. library/Nobita/IgnoreThread/Model/Thread.php
  105. library/Nobita/LimitGuestThreadPageView/Model/Thread.php
  106. library/sonnbThreadMassActions/Model/Thread.php
  107. library/Dark/PostRating/Model.php
  108. library/XenForo/Model/Forum.php
  109. library/XenForo/Helper/String.php
  110. library/XenForo/Helper/Discussion.php
  111. library/XenForo/Model/Post.php
  112. library/Asp/OnlineStatus/Model/AspPost.php
  113. library/EWRporta/Model/Post.php
  114. library/Dark/PostRating/Model/Post.php
  115. library/sonnbThreadMassActions/Model/Post.php
  116. library/Nobita/LimitGuestThreadPageView/Engine.php
  117. library/XenForo/Model/Attachment.php
  118. library/EWRporta/Model/Attachment.php
  119. library/XenForo/Model/Node.php
  120. library/Nobita/IgnoreThread/Model/Node.php
  121. library/XenForo/Route/Prefix/Categories.php
  122. library/XenForo/Route/Prefix/Forums.php
  123. library/XenForo/ControllerResponse/View.php
  124. library/XenForo/ControllerResponse/Abstract.php
  125. library/Nobita/IgnoreThread/Model/IgnoreThread.php
  126. library/XenForo/Helper/Cookie.php
  127. library/XenForo/ViewRenderer/HtmlPublic.php
  128. library/XenForo/ViewRenderer/Abstract.php
  129. library/XenForo/Template/Public.php
  130. library/XenForo/Template/Abstract.php
  131. library/XenForo/ViewPublic/Thread/View.php
  132. library/XenForo/ViewPublic/Base.php
  133. library/XenForo/View.php
  134. library/EWRporta/Listener/ViewPublic.php
  135. library/EWRporta/ViewPublic/Custom.php
  136. library/XenForo/BbCode/Parser.php
  137. library/XenForo/BbCode/Formatter/Base.php
  138. library/EWRporta/Listener/BbCode.php
  139. library/EWRporta/BbCode/Formatter.php
  140. library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
  141. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
  142. library/XenForo/ViewPublic/Helper/Message.php
  143. library/XenForo/BbCode/TextWrapper.php
  144. library/WhoHasVisited/Listener.php
  145. library/Waindigo/JoinUserGroup/Listener/TemplateCreate.php
  146. library/XenForo/Route/Prefix/Members.php
  147. library/bdTagMe/XenForo/Route/Prefix/Members.php
  148. library/EWRporta/Listener/NavTabs.php
  149. library/ExternalPages/Listeners/Navigation.php
  150. library/ExternalPages/Route/Prefix/En.php
  151. library/Dark/TaigaChat/EventListener/NavigationTabs.php
  152. library/XenForo/Template/FileHandler.php
  153. library/XenForo/Helper/File.php
  154. internal_data/templates/S.7,L.1,thread_view.php
  155. library/SeparateStickyAndNormal/Listener.php
  156. library/EWRporta/Listener/Template.php
  157. library/EWRporta/Model/Promotes.php
  158. library/Waindigo/JoinUserGroup/Listener/TemplateHook.php
  159. internal_data/templates/S.7,L.1,ignore_thread_tool.php
  160. internal_data/templates/S.7,L.1,page_nav.php
  161. library/XenForo/Route/Prefix/Posts.php
  162. library/XenForo/Model/Avatar.php
  163. internal_data/templates/S.7,L.1,RT_UserOnlineRibbon.php
  164. internal_data/templates/S.7,L.1,dark_postrating_message_user_info.php
  165. library/XenForo/ViewPublic/Helper/User.php
  166. library/XenForo/Model/UserField.php
  167. internal_data/templates/S.7,L.1,dark_postrating.php
  168. internal_data/templates/S.7,L.1,bb_code_tag_quote.php
  169. library/XenForo/Helper/Criteria.php
  170. library/XenForo/Debug.php
  171. internal_data/templates/S.7,L.1,PAGE_CONTAINER.php
  172. library/XenForo/ViewRenderer/Json.php