Page Time: 0.1272s

Memory: 6.2515 MB (Peak: 7.6667 MB)

Queries (27, time: 0.0284s, 22.3%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000165
    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: 33963
    Run Time: 0.000504
    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: 22
    Run Time: 0.000298
    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: 33963
    Run Time: 0.001090
    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: 33963
    Run Time: 0.000801
    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: 33963
    Run Time: 0.004641
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 11Using 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: 33963
    Run Time: 0.000196
  8. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 33963
    Run Time: 0.001040
  9. SELECT thread.*
    	,
    		0 AS thread_reply_banned
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 33963
    Run Time: 0.000535
    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: 22
    Run Time: 0.000268
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  11. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 33963
    Run Time: 0.000192
    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: 33963
    Run Time: 0.001737
    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: 33963
    Run Time: 0.000806
    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, 2 , 2 , XenForo_ControllerPublic_Thread, Index, valid, thread_id=33963&page=2, 1461895314,
    Run Time: 0.000487
  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.000174
    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, 421144, a:1:{i:0;s:474:"Given that the Lions had four 4th qtr comebacks this season, and the fact that they were moving the ball up and down the field in big chucks against the Saints D the entire game, I call what the Saints did securing the win. Now if the Saints would've tried punching it in the endzone on their very last possession of the game (which they could've very easily done), THAT would've been unnecessarily running up the score.....this is the big leagues guys, quit your whining...";}, 1458829234, 1461895314
    Run Time: 0.001113
  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, 421161, a:1:{i:0;s:338:"i dont think the saints were running up the score. had a 1st and goal at the one with 2 min. left and knelt on the ball; hardly running up the score. brees was taken out at the end of the 3rd quarter in the colts game and the saints did not attempt a pass (even on third and longs) in the 4th quarter. dont know what the big deal is...";}, 1458829234, 1461895314
    Run Time: 0.001046
  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, 421297, a:1:{i:0;s:2238:"Ok, time to clear a couple things up. I made this post last night drunk and kinda angry. Not at the Saints, but at the Lions for absolutely botching EVERY opportunity the Saints tried so hard to give them. Brees throws 3 picks and the Lions catch zero of them, the refs take a TD away from the Lions on a fumble recovery, etc. It was clear that the Lions were on par with the Saints in their own dome but once they stopped capitalizing on opportunities and leaving WRs so wide open that it was actually a little weird, it got out of hand. I wasn't actually referring to the drive with a 10 point lead, that is understandable and expected. What I was referring to was the last drive when they did NOT score. They were trying with everything they had to score again before the 2:00 warning to accomplish nothing other than stats. Run the clock out with 3:00 left or take shots in the endzone? Hmm.. I am positive Flynn or A-Rod would have been handing it to Kuhn/Starks/Grant/Saine on that drive, as would all the other playoff teams. Just because they failed to score and knelt when they had to doesn't mean they didn't try to score with everything they had before default kneeling time. Maybe it wasn't as bad as I initially thought when I was buzzed up and annoyed, that's a real possibility. But one thing is for sure, #9 is the most deserving MVP of all time, the Most Valuable Padder. But, in the end, I don't really give a crap and would have never even consider making this post sober (sorry for the unnecessary drama lol). I wish they would have scored 100 points and set every single season playoff record in history, it would just be that much more hilarious to watch them get beat on the road like they do close to 50% of the time anyway. And for the record, Flynn still had a better game against this team last week regardless, with nothing other than pride and a multi-million $$ contract on the line, HA! That is all. P.S. GO SAINTS next week I'd love nothing more than to shove a beating down their throats. If you can't beat/don't want to play the top competition, you're in the wrong sport. Legends will be cemented in stone and crow will be eaten, when the Saints come to town, and march home beaten. GO PACK";}, 1458829234, 1461895314
    Run Time: 0.001044
  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, 421300, a:1:{i:0;s:314:"Oh, as for the scar on his face, lol, I think it was a big birth mark that he had removed and now it looks way worse than it did before. I'd rather have a natural birthmark than a giant scar, but I'm not going to pick on a guy for something he was born with. I'm sure the ladies don't mind it so why should I?? lol";}, 1458829234, 1461895314
    Run Time: 0.001129
  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, 421344, a:1:{i:0;s:274:"Are you seriously restoring to actually wanting Brees to get hurt? Making fun of how he looks with a helmet or what he has on his face? WOW. So much for the Saints fan base being "dumb" and "annoying," .... Geez!! Bring on the GIANTS!!! That's all I care about right now!!";}, 1458829234, 1461895314
    Run Time: 0.000856
  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, 421370, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"cheesehead1285, post: 421297, member: 1524";s:8:"original";a:2:{i:0;s:52:"[quote="cheesehead1285, post: 421297, member: 1524"]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;s:2:" ";i:1;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}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:1:{i:0;s:175:"P.S. GO SAINTS next week I'd love nothing more than to shove a beating down their throats. If you can't beat/don't want to play the top competition, you're in the wrong sport.";}}}}i:2;s:121:" Legends will be cemented in stone and crow will be eaten, when the Saints come to town, and march home beaten. GO PACK";}}i:1;s:190:" So, if this is how you really feel why were you in such a drunken rage last night when Detroit did not knock the Saints out of the playoffs? Sorry but your story just does not add up.";}, 1458829234, 1461895314
    Run Time: 0.001134
  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, 421460, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"morningwood, post: 421370, member: 2110";s:8:"original";a:2:{i:0;s:49:"[quote="morningwood, post: 421370, member: 2110"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:183:"So, if this is how you really feel why were you in such a drunken rage last night when Detroit did not knock the Saints out of the playoffs? Sorry but your story just does not add up.";}}i:1;s:428:" Because it would have been great, just like the Steelers loss to the Broncos was great! WAAAAYYY less people than you think are worried about playing your mediocre road team. I would much rather play the Saints in Lambeau than the Giants. The Giants have a scary pass rush and can play lights out in the cold and on the road. The Saints are borderline pushovers away from their own dome. Facts are facts, ask Marshawn Lynch..";}, 1458829234, 1461895314
    Run Time: 0.004561
  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, 421499, a:1:{i:0;s:488:"Facts are facts, and the fact is you're scared. That's the reason you were pulling for the Lions and we both know it. You can now pretend that you want to play the best opponent possible, but your anxiety over the Saints advancing is inconsistent with the new belief system to which you claim to adhere. And hey, if it makes you rest easier to think the Saints are going to be anywhere close to a pushover then knock yourself out. I enjoy watching you play mind games on yourself.";}, 1458829234, 1461895314
    Run Time: 0.000958
  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, 421535, a:1:{i:0;s:1216:"Again with the story of Brees padding his stats... From the splits on NFL.com: Brees has 7% of his yards when up 16 or more points. Rodgers has 12%. Brees has 11% of his TDs when up 16 or more points. Rodgers has 18%. Brees has 52% of his yards when winning and 54% of his TDs. Rodgers has 65% and 71% respectively. Brees has 21% of his yards, 24% of TDs in the 4th quarter. Rodgers has 19%/22%. Brees has 42% of his yards, 50% of TDs in the second half. Rodgers has 49%/49%. Brees has 0 interceptions when up 16 or more. Rodgers has 3. Brees got pulled from 4 games when leading, same as Rodgers (not counting the Detroit game when Rodgers did not play). Brees missed 41:41 from games he was pulled. Rodgers missed 38:15. The Saints were winning by an average margin of 28.5 when Brees got pulled. The Packers were up by a 27.5 average. Rodgers had a great year -- MVP great -- as did the Packers. I don't see the need to try and denigrate Brees' achivements or talk about "padding stats" when it's a game of professionals paid to stop the other team, as well as when one player/team is called out for doing so and others ignored (usually the player/team that is the favorite of the one calling the others out).";}, 1458829234, 1461895314
    Run Time: 0.000807
  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, 421688, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"morningwood, post: 421499, member: 2110";s:8:"original";a:2:{i:0;s:49:"[quote="morningwood, post: 421499, member: 2110"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:482:"Facts are facts, and the fact is you're scared. That's the reason you were pulling for the Lions and we both know it. You can now pretend that you want to play the best opponent possible, but your anxiety over the Saints advancing is inconsistent with the new belief system to which you claim to adhere. And hey, if it makes you rest easier to think the Saints are going to be anywhere close to a pushover then knock yourself out. I enjoy watching you play mind games on yourself.";}}i:1;s:318:" The fact is I'm more scared about the Giants right now than the Saints because we actually have to play the Giants. But I'm not scared of the Giants either. They're a good team and they're hot right now and I'm looking foward to a good game. If we get past the Giants I'll worry about the Saints....or the 9ers.";}, 1458829234, 1461895314
    Run Time: 0.000850
  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, 424363, a:6:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"V Chip, post: 421535, member: 6091";s:8:"original";a:2:{i:0;s:44:"[quote="V Chip, post: 421535, member: 6091"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:1216:"Again with the story of Brees padding his stats... From the splits on NFL.com: Brees has 7% of his yards when up 16 or more points. Rodgers has 12%. Brees has 11% of his TDs when up 16 or more points. Rodgers has 18%. Brees has 52% of his yards when winning and 54% of his TDs. Rodgers has 65% and 71% respectively. Brees has 21% of his yards, 24% of TDs in the 4th quarter. Rodgers has 19%/22%. Brees has 42% of his yards, 50% of TDs in the second half. Rodgers has 49%/49%. Brees has 0 interceptions when up 16 or more. Rodgers has 3. Brees got pulled from 4 games when leading, same as Rodgers (not counting the Detroit game when Rodgers did not play). Brees missed 41:41 from games he was pulled. Rodgers missed 38:15. The Saints were winning by an average margin of 28.5 when Brees got pulled. The Packers were up by a 27.5 average. Rodgers had a great year -- MVP great -- as did the Packers. I don't see the need to try and denigrate Brees' achivements or talk about "padding stats" when it's a game of professionals paid to stop the other team, as well as when one player/team is called out for doing so and others ignored (usually the player/team that is the favorite of the one calling the others out).";}}i:1;s:178:" Brees has multi int games..Rodgers had none, for me that is more telling for MV, then any other int stats Trying to figure out where your stats came from but found this ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:63:"http://www.nfl.com/player/aaronrodgers/2506363/situationalstats";}}i:3;s:158:" Rodgers ahead by 9 to 16 points- tosses 69 times 4th q, tossed 98 times Margin +15 tossed it 125 times 4th q with in 7 points, tossed 36 times ";i:4;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:60:"http://www.nfl.com/player/drewbrees/2504775/situationalstats";}}i:5;s:146:" Brees ahead 9 to 16 points, tossed 86 times 4th q tossed 163 times Margin +15 tossed it 224 times 4th q with in 7 points, tossed 75 times";}, 1458829234, 1461895314
    Run Time: 0.001195
  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, 424445, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"longtimefan, post: 424363, member: 145";s:8:"original";a:2:{i:0;s:48:"[quote="longtimefan, post: 424363, member: 145"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:105:"Brees has multi int games..Rodgers had none, for me that is more telling for MV, then any other int stats";}}i:1;s:290:" I wasn't using INT stats, I was debunking the oft-repeated incorrect statement "Brees Pads his Stats." If one is trying to pad stats when ahead by a big margin, you would see larger numbers of everything -- yards, TDs, attempts, interceptions. It's one more part of the overall picture. ";i:2;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"longtimefan, post: 424363, member: 145";s:8:"original";a:2:{i:0;s:48:"[quote="longtimefan, post: 424363, member: 145"]";i:1;s:8:"[/quote]";}s:8:"children";a:4:{i:0;s:63:"Trying to figure out where your stats came from but found this ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:63:"http://www.nfl.com/player/aaronrodgers/2506363/situationalstats";}}i:2;s:3:" ";i:3;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:60:"http://www.nfl.com/player/drewbrees/2504775/situationalstats";}}}}i:3;s:751:" That's where they are from. There's one category not listed which is up by 16 or more, so I took the total of "ahead 1-8" and "ahead 9-16" and subtracted that from "ahead" to get the remaining portion; ahead 16+. I hadn't done attempts but those show the same type of results: Brees has 8% of his attempts when winning by 16+; Rodgers has 14%. Brees has 20% of passes when winning by 8+; Rodgers has 28%. Brees has 51% of his attempts when winning; Rodgers has 65%. Brees has 23% of his attempts in the 4th quarter; Rodgers has 20%. They both have 45% of their attempts in the second half. The "Margin" stats are based off the ending game score, not the situation of the game so I found them a bit useless in a discussion about "padding stats."";}, 1458829234, 1461895314
    Run Time: 0.000803

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,dark_postrating.php
  148. internal_data/templates/S.7,L.1,bb_code_tag_quote.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