Page Time: 0.1796s

Memory: 6.6987 MB (Peak: 8.1668 MB)

Queries (40, time: 0.0350s, 19.5%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000238
    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_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: 37622
    Run Time: 0.000860
    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.000452
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  4. SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
    FROM EWRporta2_articles
    	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    WHERE EWRporta2_articles.thread_id = ?
    Params: 37622
    Run Time: 0.001546
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  5. SELECT EWRporta2_articles.*, EWRporta2_authors.*, xf_thread.*, xf_post.*, xf_user.*
    FROM xf_thread
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_articles ON (EWRporta2_articles.thread_id = xf_thread.thread_id)
    WHERE xf_thread.thread_id = ?
    Params: 37622
    Run Time: 0.000922
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_postconstPRIMARYPRIMARY4const1 
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLEEWRporta2_authorsconstPRIMARYPRIMARY4const0unique row not found
    SIMPLEEWRporta2_articlesconstPRIMARYPRIMARY4const0unique row not found
  6. 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 AND session_activity.unique_key = CAST(post.user_id AS BINARY))
    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 >= 25 AND post.position < 50) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 37622
    Run Time: 0.003880
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 24Using where; 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 
    PRIMARYuser_privacyeq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYsignature_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.user_id1 
    PRIMARYsession_activityeq_refPRIMARYPRIMARY22packerfo_maindb.post.user_id,func1 
    PRIMARYpr_cacheeq_refPRIMARYPRIMARY4packerfo_maindb.post.post_id1 
    PRIMARYpr2eq_refpost_id_user_id,post_id_rating,user_id_ratingpost_id_user_id8packerfo_maindb.post.post_id,const1 
    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
  7. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 37622
    Run Time: 0.000259
  8. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 37622
    Run Time: 0.002202
  9. SELECT thread.*
    	,
    		0 AS thread_reply_banned
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 37622
    Run Time: 0.000580
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
  10. 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.000323
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  11. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 37622
    Run Time: 0.000189
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_ignore_threadrefuser_threaduser_thread8const,const1 
  12. SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
    FROM EWRporta2_articles
    	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    WHERE EWRporta2_articles.thread_id = ?
    Params: 37622
    Run Time: 0.001069
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  13. SELECT EWRporta2_articles.*, EWRporta2_authors.*, xf_thread.*, xf_post.*, xf_user.*
    FROM xf_thread
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_articles ON (EWRporta2_articles.thread_id = xf_thread.thread_id)
    WHERE xf_thread.thread_id = ?
    Params: 37622
    Run Time: 0.000905
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_postconstPRIMARYPRIMARY4const1 
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLEEWRporta2_authorsconstPRIMARYPRIMARY4const0unique row not found
    SIMPLEEWRporta2_articlesconstPRIMARYPRIMARY4const0unique row not found
  14. 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=37622&page=2, 1464423197,
    Run Time: 0.000917
  15. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('freepro_menu_tickets', 'freepro_menu_schedule', 'freepro_menu_roster', 'freepro_menu_draft')
    Params: 1
    Run Time: 0.000153
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 4Using where
  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, 454379, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"GeeDogWarrior, post: 454335, member: 4409";s:8:"original";a:2:{i:0;s:51:"[quote="GeeDogWarrior, post: 454335, member: 4409"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:302:"Sluggish Run Game for basically his entire Career starting. Awful to Average Olines... Mostly crap defenses....(except for 2010) Usually the youngest team in the league... crappy special teams his first 3 years. Only games I recall him "choking" were that Bucs game in 2009 and that Jags game in 2008.";}}i:1;s:71:" That wide open Jennings play in OT against the cards still haunts me.";}, 1458829234, 1464423197
    Run Time: 0.001029
  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, 454389, a:1:{i:0;s:307:"Could have been becuase our defense "couldn't stop a nose bleed" last year. I was a little bothered when Clay said in a post game interview, "When you have an offense this good it's ok to make some mistakes on defense." I hope they all don't seriously think that. Especially after looking back on last year.";}, 1458829234, 1464423197
    Run Time: 0.001149
  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, 454397, a:6:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"ivo610, post: 454379, member: 2128";s:8:"original";a:2:{i:0;s:44:"[quote="ivo610, post: 454379, member: 2128"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:69:"That wide open Jennings play in OT against the cards still haunts me.";}}i:1;s:449:" Me too. That was a golden signature historical play right there for him to grab. To end a historical game. And he overfired (or Jennings couldn't find that extra gear to go get it). Then right afterwards, the historical gaffe to end the game. Now on a positive note to deflect the 4th quarter criticism of Rodgers: Tiger Woods has NEVER, not even once, won a major when he didn't already have the lead, or share of the lead, heading into the 4th ";i:2;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:7:"quarter";}}i:3;s:17:". Or 4th & final ";i:4;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:5:"round";}}i:5;s:185:" in this case, as they call them in the game of golf. Every single one of Tiger's majors (I think 14), he's had the lead heading into Sunday's final rounds. Now that's a front-runner.";}, 1458829234, 1464423197
    Run Time: 0.001032
  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, 454400, a:1:{i:0;s:2031:"The stats are what the stats are and the writer certainly is entitled to his opinion. My feelings are that the writer stumbled across that particular set of statistics and decided to write a story that supports a belief that he held prior to actually sitting down at his keyboard. I'm not one to put a whole lot of stock in obscure numbers that are bent, twisted and shaped to support a presupposition because I deal with numbers and stats on a daily basis. I am proud to say that I can sandbag line-item budgeting with the best of 'em (I'll just keep saying that because it justifies my existence and because I keep saying it, it just HAS to be true). Seems as though Jack Vainisi always beats me to the punch, which is a good thing because he's a helluva lot more fluent than I, but I'd like to add that THIS particular gripe against Rodgers is not new. I recall vividly the '08 Carolina game where Rodgers couldn't bring the Pack back for a THIRD time in the fourth quarter -- and the Green Bay/Appleton and Milwaukee beat writers were going to town on him. I recall telling my son on the way home from the game almost exactly what was going to be in the morning papers. Rodgers is at the top of his position ... now starts the systematic disassembly of the player. They (mainstream media and now, the proverbial blogosphere) need something to write and by gawd, if it's on the internet, it just has to be accurate ... right? Incorporating last years' two losses as failed 4th quarter comeback opportunities is almost as ludicrous and it is laughable - in that in both games ... the Packers were defeated by teams that played better and were better prepared to play that day...and make no mistake, they were beat both times. They didn't lose...they were beat. In summation, my opinion is this: An article based on the writer's personal presupposition/observation with selective supporting stats doesn't make an idea correct. It only makes for an interesting "read" and good topic for discussion - which is always good.";}, 1458829234, 1464423197
    Run Time: 0.000762
  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, 454407, a:1:{i:0;s:85:"Numbers lie, stats can be very misleading, especially in the wrong or lack of context";}, 1458829234, 1464423197
    Run Time: 0.000670
  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, 454434, a:1:{i:0;s:338:"Tiger Woods, again, failed to make a 4th quarter rally today, and now has won a total of zero majors in his life when starting the 4th round not leading. But Ernie Els made a great comeback for the British Open win. Meanwhile Rodgers, and now Sterling Sharpe, just made birdies in Tahoe at the #AAC, the great celebrity golf tournament.";}, 1458829234, 1464423197
    Run Time: 0.000616
  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, 461839, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"HyponGrey, post: 454407, member: 6441";s:8:"original";a:2:{i:0;s:47:"[quote="HyponGrey, post: 454407, member: 6441"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:85:"Numbers lie, stats can be very misleading, especially in the wrong or lack of context";}}i:1;s:720:" Well, they lied again today then because Rodgers had the ball in his hands TWO times in the 4th quarter needing to score to TIE, and he did not come thru either time. That is a fact. The fact is the first time it was 100% his fault with a Brian Brohm-like Int right to Navarro Bowman. The second time it was mostly the offensive line's fault, primarily Bulaga and then TJ Lang. Rodgers had no prayer with those 2 failing like they did on the final series. Rodgers had a nice drive until that point and might have led us to a score if not for Bulaga and Lang letting Ahmad Brooks get right in after Rodgers. Combined those 2, and we had another 1 in the "L" column of this particular study that they had showed us.";}, 1458829234, 1464423197
    Run Time: 0.000670
  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, 462006, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"ivo610, post: 453338, member: 2128";s:8:"original";a:2:{i:0;s:44:"[quote="ivo610, post: 453338, member: 2128"]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:104:"http://coldhardfootballfacts.com/Articles/11_5420_Aaron_Rodgers%3A_Mr._Irrelevant_in_fourth_quarter.html";s:8:"original";a:2:{i:0;s:112:"[URL='http://coldhardfootballfacts.com/Articles/11_5420_Aaron_Rodgers%3A_Mr._Irrelevant_in_fourth_quarter.html']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:102:"http://coldhardfootballfacts.com/Articles/11_5420_Aaron_Rodgers:_Mr._Irrelevant_in_fourth_quarter.html";}}i:1;s:164:" A) please read the entire article before commenting B) Some quality points about our QB, but I fully expect this to become less of an issue as the years go on.";}}i:1;s:69:" B) Today wull surely make it more of an issue, not less of an issue.";}, 1458829234, 1464423197
    Run Time: 0.000826
  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, 462022, a:1:{i:0;s:99:"I think Aaron will someday have his big drive in the postseason to shut people up about this stuff.";}, 1458829234, 1464423197
    Run Time: 0.000873
  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, 462093, a:1:{i:0;s:160:"But, but, how can anyone blame a "system Quarterback" for a lack of 4th quarter comebacks??? Wouldn't the blame rest on the "system" and not the QB? :whistling:";}, 1458829234, 1464423197
    Run Time: 0.000800
  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, 462258, a:1:{i:0;s:388:"Teams win, teams lose. Starr is mentioned by many as one of the greatest, if not the greatest, QBs of all time ONLY because his teams won 5 Championships. No. 4 is mentioned not because of Championships, but because of personal stats, which resulted in his teams winning one Championship. I'd like to see Rogers more on the Starr side of ranking than the fantasy side. Time will tell.";}, 1458829234, 1464423197
    Run Time: 0.000839
  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, 462409, a:1:{i:0;s:574:"All these negative points being brought up about the guy...Shheeesh....C'mon guys, it's not like we have Kevin Kolb as our starting QB. Cut the man some damn slack here. He is an MVP QB. He helped win us a superbowl He is an efficiant passer He set an all time record for QB rating He was voted #1 player in the NFL by his peers He is a generally nice guy, not some c0ck sucker like Brady He is generous by passing the ball to everyone, not bias like some QB's He takes blame for mistakes, does not pass the buck Stop trashing the guy and just BE GLAD HE IS ON OUR TEAM.";}, 1458829234, 1464423197
    Run Time: 0.000719
  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, 462430, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"Oshkoshpackfan, post: 462409, member: 6906";s:8:"original";a:2:{i:0;s:52:"[quote="Oshkoshpackfan, post: 462409, member: 6906"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:574:"All these negative points being brought up about the guy...Shheeesh....C'mon guys, it's not like we have Kevin Kolb as our starting QB. Cut the man some damn slack here. He is an MVP QB. He helped win us a superbowl He is an efficiant passer He set an all time record for QB rating He was voted #1 player in the NFL by his peers He is a generally nice guy, not some c0ck sucker like Brady He is generous by passing the ball to everyone, not bias like some QB's He takes blame for mistakes, does not pass the buck Stop trashing the guy and just BE GLAD HE IS ON OUR TEAM.";}}i:1;s:196:" I didnt see anyone trashing him, more or less just looking at the facts. The record in the 4th isnt great but hopefully should turn around. Manning has the most though and only has 1 ring...";}, 1458829234, 1464423197
    Run Time: 0.000992
  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, 466689, a:1:{i:0;s:10:"Rodgers +1";}, 1458829234, 1464423197
    Run Time: 0.000797
  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, 466813, a:1:{i:0;s:528:"Yeah, let's just give attention to jealous, butthurt morons that can't stand Rodgers success and are grasping at straws trying to find criticism against him. He won us a Superbowl. Got us to 15-1 last year. He threw for 4 TD's yesterday. Seriously, shutup already. He's the most talented QB in the league, and will keep GB in contention for years to come. I'm so sick of these people that are obviously so desperate to find something wrong with Rodgers that they come up with these pathetic little critiques. Stuff it, people.";}, 1458829234, 1464423197
    Run Time: 0.000684
  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, 466834, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"IamAthimble, post: 466813, member: 6322";s:8:"original";a:2:{i:0;s:49:"[quote="IamAthimble, post: 466813, member: 6322"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:528:"Yeah, let's just give attention to jealous, butthurt morons that can't stand Rodgers success and are grasping at straws trying to find criticism against him. He won us a Superbowl. Got us to 15-1 last year. He threw for 4 TD's yesterday. Seriously, shutup already. He's the most talented QB in the league, and will keep GB in contention for years to come. I'm so sick of these people that are obviously so desperate to find something wrong with Rodgers that they come up with these pathetic little critiques. Stuff it, people.";}}i:1;s:491:" I find it amusing myself. The 4th. quarter comeback stat is a dubious proposition, to be sure. The data samples are small to begin with, and it helps to be trailing by a small margin in the 4th. quarter with regularity, which is obviously not the objective. The king of FQCs in recent years is Matt Ryan (another one yesterday), and he has not won squat yet. FQCs are dramatic, they're good for business, good for the highlight reels, and give the analysts something to chatter about.";}, 1458829234, 1464423197
    Run Time: 0.000751
  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, 466918, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"HardRightEdge, post: 466689, member: 6804";s:8:"original";a:2:{i:0;s:51:"[quote="HardRightEdge, post: 466689, member: 6804"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:10:"Rodgers +1";}}i:1;s:138:" I thought back to this stupid article immediately. I also thought back to it when the Fail Mary call gave him another -1 instead of +1.";}, 1458829234, 1464423197
    Run Time: 0.000708
  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, 473977, a:1:{i:0;s:45:"Bringing this back as it was a 4th q comeback";}, 1458829234, 1464423197
    Run Time: 0.000718
  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, 473983, a:1:{i:0;s:27:"We are so lucky to have AR.";}, 1458829234, 1464423197
    Run Time: 0.000913
  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, 473995, a:1:{i:0;s:2803:"Actually, DET was Rodgers' 4th. comeback in the 4th. quarter this season. Unfortunately, we did not hold that lead in 2 of them. SEA: 16 plays, 82 yards, 1 yd. TD run by Benson with 8:44 left on clock NO: 7 plays, 57 yards, 11 yd. TD pass to Nelson with 7:00 left on clock IND: 2 plays, 49 yards, 8 yd. TD pass to Jones with 4:30 left on clock DET: 6 plays, 83 yards, 22 yd. TD pass to Cobb with 1:55 left on clock This microcosm illustrates the several meaningful flaws in the 4th. quarter comeback WIN stat: 1. Opportunity: In order to rack up a lot of 4th. quarter comeback wins, you need to be trailing in the 4th. quarter with some regularity. This is clearly not the objective of the first 3+ quarters of play. Further, the deficit needs to be manageable...that deficit going into the 4th. needs to be narrow on a regular basis to rack up those wins. Rodgers has had opportunities this season. Last season the Pack held the lead going into the 4th. in all 15 of Rodgers' starts. So, you need to have a good enough team to keep you close (2012 Packers), but no so explosive as to consistently hold the lead into the 4th. (2011 Packers). 2. QB is not the only player on the field: In the IND comeback drive, 41 of those yards came on Green's scamper. You have to give Rodgers credit for getting the ball in the end zone, but it's not quite the same thing as a sustained passing drive. 3. QB does not Play D: IND goes 13 plays, 81 yards to take back the lead with 0:34 left on the clock. This fact, oddly, goes underappreciated. Having a clutch D that holds late leads gets you the W. 4. Sh*t Happens, to the Good: NO's Hartley misses a 48 yd. FG to take back the lead with 2:49 left on the clock. 5. Sh*t Happens, to the Bad: Seattle. In the final analysis, the sample size is too small and the circumstances of each game having enough peculiarities to render the bare stats meaningless. The only way to make sense of this stat is to look at each game individually and establish a QB point system to allocate QB responsibility for wins and losses in those circumstances. That would be so highly subjective as to have little credibility, and game tape review so time consuming as to render it nearly impossible. QB Rating, on the other hand, takes in 1000's of plays over a career for a meaningful sample size, and has a demonstrated high correlation to winning. This is not to say leading a 4th. quarter winning drive is meaningless; only that career stats measuring this are meaningless. Nobody is going to remember Matt Ryan's gaudy comeback stats over the last few seasons since it did not buy a single playoff win. Everybody remembers "The Catch". And which would you rather have...a 19 game winning streak without trailing in the 4th. quarter or Ryan's comeback stats?";}, 1458829234, 1464423197
    Run Time: 0.000902
  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, 474076, a:1:{i:0;s:610:"The 4th quarter comeback stat is largely one of the biggest jokes in all of sports stats. To me it's relatively meaningless. So, what, Eli Manning is somehow better than Rodgers because he's led more 4th quarter comebacks? He doesn't get dinged for playing badly the first three quarters? Rodgers doesn't get credit for not having to lead a 4th quarter comeback most of the time? And how about all of the 2nd and 3rd quarter comeback victories Rodgers' has led? No credit for that either? Given a choice, I'll take winning in the 2nd and 3rd quarter over having to come from behind in the 4th to get the win.";}, 1458829234, 1464423197
    Run Time: 0.000753
  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, 474090, a:1:{i:0;s:638:"I did some surfing prior to the Lions game and I saw it in several posts that Stafford had the best 4th quarter QB rating. Lions fans were hanging their hats on that. I get it but it sure doesn't mean much does it? Stats are nice to look at but they sure as heck aren't useful for forecasting future play. If they were - everybody with a calculator would win in Vegas. I'll take the best quarterback rating in the history of the league over a 4th quarter rating all day. That's a joke of course. Would anybody take any other QB in the NFL over this Rodgers? It's 60 minutes of game time. you have to produce in all of them to be the best.";}, 1458829234, 1464423197
    Run Time: 0.000667
  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, 474098, a:1:{i:0;s:453:"In my opinion, having a bunch of 4th qtr comebacks is not a good stat at all. It means that for the first 3 qtrs you couldn't get it done well enough to have a lead going into the 4th. While I know sometimes sh!t happens outside of the QB's control and you have to try to play catch up, but a stat like Eli has that says he is the king of 4th qtr comebacks is just like the stat for Favre having the most INT's, neither are a good stat....to me that is.";}, 1458829234, 1464423197
    Run Time: 0.000787
  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, 477151, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"HardRightEdge, post: 473995, member: 6804";s:8:"original";a:2:{i:0;s:51:"[quote="HardRightEdge, post: 473995, member: 6804"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:416:"Actually, DET was Rodgers' 4th. comeback in the 4th. quarter this season. Unfortunately, we did not hold that lead in 2 of them. SEA: 16 plays, 82 yards, 1 yd. TD run by Benson with 8:44 left on clock NO: 7 plays, 57 yards, 11 yd. TD pass to Nelson with 7:00 left on clock IND: 2 plays, 49 yards, 8 yd. TD pass to Jones with 4:30 left on clock DET: 6 plays, 83 yards, 22 yd. TD pass to Cobb with 1:55 left on clock";}}i:1;s:275:" OK...I found it. Rodgers now has five games this season with a 4th. quarter drive that took the lead; the D failed to hold the lead in two of them. I'll update the list for future reference: DET: 7 plays, 41 yards., 14 yard TD run by Harris with 10:45 left on the clock.";}, 1458829234, 1464423197
    Run Time: 0.001176
  40. 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, 477233, a:1:{i:0;s:186:"Pretty stoooooopid article. Obviously AR needs to throw more picks in the early part of games so he can qualify for more comebacks. And then he must play more safety to defend our lead.";}, 1458829234, 1464423197
    Run Time: 0.000688

Included Files (154, XenForo Classes: 63)

  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/FreePro/Listener.php
  29. library/bdTagMe/Listener.php
  30. library/bdTagMe/Helper/Template.php
  31. library/bdTagMe/ShippableHelper/Updater.php
  32. library/bdTagMe/Option.php
  33. library/sonnb/XenGallery/Listener.php
  34. library/EWRporta2/Listener/Init.php
  35. library/XenForo/Router.php
  36. library/XenForo/Route/Filter.php
  37. library/XenForo/Route/Interface.php
  38. library/XenForo/Route/ResponseSuffix.php
  39. library/XenForo/Route/Prefix.php
  40. library/XenForo/Route/Prefix/Threads.php
  41. library/XenForo/RouteMatch.php
  42. library/XenForo/ControllerPublic/Thread.php
  43. library/XenForo/ControllerPublic/Abstract.php
  44. library/XenForo/Controller.php
  45. library/ModerateCountry/RegisterListener.php
  46. library/EWRporta2/Widget/Listener/ArticlesMain.php
  47. library/Nobita/IgnoreThread/Listener.php
  48. library/Dark/PostRating/EventListener.php
  49. library/EWRporta2/Listener/Controller.php
  50. library/FreePro/XenForo/ControllerPublic/Thread.php
  51. library/Nobita/IgnoreThread/ControllerPublic/Thread.php
  52. library/sonnb/XenGallery/XenForo/ControllerPublic/Thread.php
  53. library/EWRporta2/ControllerPublic/Thread.php
  54. library/XenForo/Input.php
  55. library/XenForo/Session.php
  56. library/Zend/Db.php
  57. library/Zend/Db/Adapter/Mysqli.php
  58. library/Zend/Db/Adapter/Abstract.php
  59. library/Zend/Db/Select.php
  60. library/Zend/Db/Expr.php
  61. library/Zend/Db/Profiler.php
  62. library/Zend/Db/Statement/Mysqli.php
  63. library/Zend/Db/Statement.php
  64. library/Zend/Db/Statement/Interface.php
  65. library/XenForo/Helper/Ip.php
  66. library/XenForo/Visitor.php
  67. library/XenForo/Model/User.php
  68. library/ThemeHouse/JoinUserGroup/Listener/LoadClass.php
  69. library/ThemeHouse/Listener/LoadClass.php
  70. library/ThemeHouse/Listener/LoadClass/20150518.php
  71. library/Dark/TaigaChat/EventListener/Listener.php
  72. library/sonnbThreadMassActions/Listener.php
  73. library/EWRporta2/Listener/Model.php
  74. library/ThemeHouse/JoinUserGroup/Extend/XenForo/Model/User.php
  75. library/Dark/PostRating/Model/User.php
  76. library/bdTagMe/XenForo/Model/User.php
  77. library/sonnb/XenGallery/XenForo/Model/User.php
  78. library/EWRporta2/Model/User.php
  79. library/Zend/Db/Profiler/Query.php
  80. library/XenForo/Permission.php
  81. library/XenForo/Helper/Php.php
  82. library/XenForo/Phrase.php
  83. library/XenForo/Locale.php
  84. library/Sedo/DetectBrowser/Listener/Visitor.php
  85. library/Sedo/DetectBrowser/Helper/MobileDetect.php
  86. library/EWRporta2/Model/Perms.php
  87. library/ThemeHouse/JoinUserGroup/Listener/ControllerPreDispatch.php
  88. library/ThemeHouse/Listener/ControllerPreDispatch.php
  89. library/ThemeHouse/Listener/ControllerPreDispatch/20150911.php
  90. library/UnreadPostCount/Listener.php
  91. library/XenForo/ControllerHelper/ForumThreadPost.php
  92. library/XenForo/ControllerHelper/Abstract.php
  93. library/XenForo/Model/Thread.php
  94. library/Nobita/IgnoreThread/Model/Thread.php
  95. library/Dark/PostRating/Model/Thread.php
  96. library/sonnbThreadMassActions/Model/Thread.php
  97. library/UnreadPostCount/Model/Thread.php
  98. library/Dark/PostRating/Model.php
  99. library/XenForo/Model/Forum.php
  100. library/XenForo/Helper/String.php
  101. library/XenForo/Helper/Discussion.php
  102. library/XenForo/Model/Post.php
  103. library/Dark/PostRating/Model/Post.php
  104. library/sonnbThreadMassActions/Model/Post.php
  105. library/EWRporta2/Model/Post.php
  106. library/EWRporta2/Model/Articles.php
  107. library/XenForo/Model/Attachment.php
  108. library/XenForo/Model/Node.php
  109. library/Nobita/IgnoreThread/Model/Node.php
  110. library/XenForo/Route/Prefix/Categories.php
  111. library/XenForo/Route/Prefix/Forums.php
  112. library/XenForo/ControllerResponse/View.php
  113. library/XenForo/ControllerResponse/Abstract.php
  114. library/Nobita/IgnoreThread/Model/IgnoreThread.php
  115. library/XenForo/Helper/Cookie.php
  116. library/XenForo/ViewRenderer/HtmlPublic.php
  117. library/XenForo/ViewRenderer/Abstract.php
  118. library/XenForo/Template/Public.php
  119. library/XenForo/Template/Abstract.php
  120. library/XenForo/ViewPublic/Thread/View.php
  121. library/XenForo/ViewPublic/Base.php
  122. library/XenForo/View.php
  123. library/EWRporta2/Listener/ViewPublic.php
  124. library/XenForo/BbCode/Parser.php
  125. library/XenForo/BbCode/Formatter/Base.php
  126. library/EWRporta2/Listener/BbCode.php
  127. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
  128. library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
  129. library/EWRporta2/BbCode/Formatter.php
  130. library/XenForo/ViewPublic/Helper/Message.php
  131. library/XenForo/BbCode/TextWrapper.php
  132. library/WhoHasVisited/Listener.php
  133. library/XenForo/Route/Prefix/Members.php
  134. library/bdTagMe/XenForo/Route/Prefix/Members.php
  135. library/Dark/TaigaChat/EventListener/NavigationTabs.php
  136. library/EWRporta2/Listener/NavTabs.php
  137. library/XenForo/Template/FileHandler.php
  138. library/XenForo/Helper/File.php
  139. internal_data/templates/S.7,L.1,thread_view.php
  140. library/SeparateStickyAndNormal/Listener.php
  141. library/EWRporta2/Listener/Template.php
  142. internal_data/templates/S.7,L.1,ignore_thread_tool.php
  143. internal_data/templates/S.7,L.1,page_nav.php
  144. library/XenForo/Route/Prefix/Posts.php
  145. library/XenForo/Model/Avatar.php
  146. internal_data/templates/S.7,L.1,dark_postrating_message_user_info.php
  147. internal_data/templates/S.7,L.1,bb_code_tag_quote.php
  148. internal_data/templates/S.7,L.1,dark_postrating.php
  149. library/XenForo/Helper/Criteria.php
  150. library/XenForo/Debug.php
  151. internal_data/templates/S.7,L.1,PAGE_CONTAINER.php
  152. library/FreePro/Helper.php
  153. internal_data/templates/S.7,L.1,EWRporta2_Navtabs.php
  154. library/XenForo/ViewRenderer/Json.php