Page Time: 0.1539s

Memory: 6.5816 MB (Peak: 8.0211 MB)

Queries (35, time: 0.0299s, 19.4%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000139
    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: 45975
    Run Time: 0.000879
    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.000268
    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: 45975
    Run Time: 0.001079
    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: 45975
    Run Time: 0.000732
    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 >= 0 AND post.position < 25) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 45975
    Run Time: 0.003930
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 19Using 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. SELECT attachment.*,
    	data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
    FROM xf_attachment AS attachment
    INNER JOIN xf_attachment_data AS data ON
    	(data.data_id = attachment.data_id)
    WHERE attachment.content_type = ?
    	AND attachment.content_id IN (509350, 509653)
    ORDER BY attachment.content_id, attachment.attach_date
    Params: post
    Run Time: 0.000619
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEattachmentrangecontent_type_id_datecontent_type_id_date31 2Using where
    SIMPLEdataeq_refPRIMARYPRIMARY4packerfo_maindb.attachment.data_id1 
  8. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 45975
    Run Time: 0.000169
  9. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 45975
    Run Time: 0.001006
  10. SELECT thread.*
    	,
    		0 AS thread_reply_banned
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 45975
    Run Time: 0.000381
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
  11. 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.000251
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  12. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 45975
    Run Time: 0.000388
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_ignore_threadrefuser_threaduser_thread8const,const1 
  13. 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: 45975
    Run Time: 0.000807
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  14. 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: 45975
    Run Time: 0.000710
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_postconstPRIMARYPRIMARY4const1 
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLEEWRporta2_authorsconstPRIMARYPRIMARY4const0unique row not found
    SIMPLEEWRporta2_articlesconstPRIMARYPRIMARY4const0unique row not found
  15. 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=45975, 1462285717,
    Run Time: 0.000508
  16. 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.000116
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 4Using where
  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, 509267, a:3:{i:0;s:645:"Like the practice squad, there is some misconception here. I couldn't find a thread, and figured it would be nice to have one in the archives like the Practice Squad explanation. Players that have participated in any Training Camp practices (July+) or exhibition games are ineligible for the PUP. Once they participate in TC they cannot be placed on the PUP list to start the season; they must go to IR, be released, or be kept on the active roster. The maximum number of players at any time under any circumstance is 90. That means that any reserve player (suspended, PUP, IR, NFI, etc) counts against the offseason roster. Once you cut to 75 ";i:1;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:6:"ACTIVE";}}i:2;s:868:" players, reserves are counted as inactive, and therefore do not count against any active roster, but still count against the total 90 man roster. PUP lasts for 6 weeks, after which point teams have a 3 week window to determine whether they want to activate the player to the active roster, send the player to IR, or simply release him. During the three week period the player is allowed to practice with the team. Players on PUP and IR are not allowed to participate in practice. Players on IR are only eligible to be designated for return if they counted against the 53 man active roster. If a Team has 90 men total on a roster, and wishes to place another player on injured reserve, they must release a player currently inactive player in order to do so. If that player is currently designated as an injured player, he must be released through an injury settlement.";}, 1458829234, 1462285717
    Run Time: 0.001011
  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, 509274, a:1:{i:0;s:579:"That's right, fair or not if a player is on the practice field for one play during TC and gets hurt, he's ineligible for the PUP list. BTW, the reason "a lot" of players show up on the PUP list the first day of TC, even if they're expected to be healthy enough to practice sometime during TC is just in case they can't, they can be put on the PUP list for the regular season. BTW II, in another thread someone mentioned that perhaps Hayward would be headed to the PUP list. But he's ineligible and will be kept on the roster even if he can't play for the first couple/few weeks.";}, 1458829234, 1462285717
    Run Time: 0.000816
  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, 509294, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"ThxJackVainisi, post: 509274, member: 4300";s:8:"original";a:2:{i:0;s:52:"[quote="ThxJackVainisi, post: 509274, member: 4300"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:203:"BTW II, in another thread someone mentioned that perhaps Hayward would be headed to the PUP list. But he's ineligible and will be kept on the roster even if he can't play for the first couple/few weeks.";}}i:1;s:132:"That was me! As soon as I saw HyponGrey's post I knew it had something to do with my Heyward post. I stand corrected. I was confused";}, 1458829234, 1462285717
    Run Time: 0.000994
  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, 509311, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"El Guapo, post: 509294, member: 5830";s:8:"original";a:2:{i:0;s:46:"[quote="El Guapo, post: 509294, member: 5830"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:132:"That was me! As soon as I saw HyponGrey's post I knew it had something to do with my Heyward post. I stand corrected. I was confused";}}i:1;s:169:" Lol, it's alright, you weren't the only one, and you won't be the last. Earlier I read about Tramon and Johnson heading to PUP. I just wanted something here to link to.";}, 1458829234, 1462285717
    Run Time: 0.000853
  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, 509350, a:3:{i:0;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:4:"2240";}}i:1;s:3:" ";i:2;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"7";s:8:"original";a:2:{i:0;s:8:"[SIZE=7]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#ff0000";s:8:"original";a:2:{i:0;s:15:"[COLOR=#ff0000]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:19:"I like the pups !!!";}}}}}}}, 1458829234, 1462285717
    Run Time: 0.001191
  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, 509384, a:1:{i:0;s:187:"PUP guys do not count against the salary cap. The "even one practice" PUP provision, while a blunt instrument, seems to be designed to prevent teams from stashing players for future use.";}, 1458829234, 1462285717
    Run Time: 0.001005
  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, 509617, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"Smokeychedder, post: 509350, member: 6672";s:8:"original";a:2:{i:0;s:51:"[quote="Smokeychedder, post: 509350, member: 6672"]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:4:"2240";}}i:1;s:3:" ";i:2;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"7";s:8:"original";a:2:{i:0;s:8:"[SIZE=7]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:14:"rgb(255, 0, 0)";s:8:"original";a:2:{i:0;s:22:"[COLOR=rgb(255, 0, 0)]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:19:"I like the pups !!!";}}}}}}}}i:1;s:184:" Oh, man. If I was talking to her, it would actually hurt my eyes to keep them aimed at the appropriate height. I mean... try doing it just looking at the photo! It's challenging.";}, 1458829234, 1462285717
    Run Time: 0.000878
  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, 509619, a:3:{i:0;s:230:"Also, I was wrong, even I had a misconception. I was informed that the maximum number of players at any time under any circumstance is 90. That means that any reserve player counts against the offseason roster. Once you cut to 75 ";i:1;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:6:"ACTIVE";}}i:2;s:146:" players, reserves are counted as inactive, and therefore do not count against any active roster, but still count against the total 90 man roster.";}, 1458829234, 1462285717
    Run Time: 0.000912
  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, 509625, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"HyponGrey, post: 509619, member: 6441";s:8:"original";a:2:{i:0;s:47:"[quote="HyponGrey, post: 509619, member: 6441"]";i:1;s:8:"[/quote]";}s:8:"children";a:4:{i:0;s:230:"Also, I was wrong, even I had a misconception. I was informed that the maximum number of players at any time under any circumstance is 90. That means that any reserve player counts against the offseason roster. Once you cut to 75 ";i:1;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:6:"ACTIVE";}}i:2;s:98:" players, reserves are counted as inactive, and therefore do not count against any active roster, ";i:3;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:48:"but still count against the total 90 man roster.";}}}}i:1;s:511:" Additional Note: I mentioned earlier that PUP guys do not count against the cap. Neither do IR guys. You have to pay them their contracted salaries, but no cap hit. Our $10 million in cap space will now expand. "but still count against the total 90 man roster"...as in carried over to the 90 man roster next off season provided they are not released in the interim. The 90 man roster exists only between the start of the free agent period or thereabouts and now...Tuesday after the 3rd. exhibition game.";}, 1458829234, 1462285717
    Run Time: 0.000874
  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, 509626, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"HardRightEdge, post: 509625, member: 6804";s:8:"original";a:2:{i:0;s:51:"[quote="HardRightEdge, post: 509625, member: 6804"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:462:"Additional Note: I mentioned earlier that PUP guys do not count against the cap. Neither do IR guys. You have to pay them their contracted salaries, but no cap hit. "but still count against the total 90 man roster"...as in carried over to the 90 man roster next off season provided they are not released in the interim. The 90 man roster exists only between the start of the free agent period or thereabouts and now...Tuesday after the 3rd. exhibition game.";}}i:1;s:72:" That's nice. Generally you pay it, you cap it. Even the Practice Squad.";}, 1458829234, 1462285717
    Run Time: 0.000945
  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, 509628, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"HyponGrey, post: 509626, member: 6441";s:8:"original";a:2:{i:0;s:47:"[quote="HyponGrey, post: 509626, member: 6441"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:71:"That's nice. Generally you pay it, you cap it. Even the Practice Squad.";}}i:1;s:227:" I don't think PS counts toward the cap either except in some rare circumstance where a PS guy happens to make more than the rookie minimum. The cap is based on the top 51 cap hits which are almost always on the 53 man roster.";}, 1458829234, 1462285717
    Run Time: 0.000926
  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, 509629, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"HardRightEdge, post: 509628, member: 6804";s:8:"original";a:2:{i:0;s:51:"[quote="HardRightEdge, post: 509628, member: 6804"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:226:"I don't think PS counts toward the cap either except in some rare circumstance where a PS guy happens to make more than the rookie minimum. The cap is based on the top 51 cap hits which are almost always on the 53 man roster.";}}i:1;s:246:" Top 51 only applies to the preseason. According to the new CBA after the final cut down, top 51 is no longer applicable, and everything counts against your cap. Granted, the sum total of non player salaries is negligible. That does include PSers";}, 1458829234, 1462285717
    Run Time: 0.000799
  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, 509639, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"HyponGrey, post: 509629, member: 6441";s:8:"original";a:2:{i:0;s:47:"[quote="HyponGrey, post: 509629, member: 6441"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:245:"Top 51 only applies to the preseason. According to the new CBA after the final cut down, top 51 is no longer applicable, and everything counts against your cap. Granted, the sum total of non player salaries is negligible. That does include PSers";}}i:1;s:697:" I stand corrected...it does appear that PUP and IR guys count against the cap under the new CBA. I see conflicting reports on PS...one SBNation piece from 2012 says "no", another from 2013 says "yes". Not a big deal as you say...most PS guys get something like $9,400 per game. The PUP / IR treatment puts a different ding job on things. If we replace 8 PUP / IR players plus add 2 players to the cap figure in going from 51 to 53, and all of those replacements make only the rookie minimum of $405,000 straight cash, that's a $4 million cut into the $10 million cap space recently reported. That doesn't leave much cushion for an in-season extension or two or some grizzled emergency vets.";}, 1458829234, 1462285717
    Run Time: 0.000808
  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, 509640, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"HardRightEdge, post: 509639, member: 6804";s:8:"original";a:2:{i:0;s:51:"[quote="HardRightEdge, post: 509639, member: 6804"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:695:"I stand corrected...it does appear that PUP and IR guys count against the cap under the new CBA. I see conflicting reports on PS...one SBNation piece from 2012 says "no", another from 2013 says "yes". Not a big deal as you say...most PS guys get something like $9,400 per game. The PUP / IR treatment puts a different ding job on things. If we replace 8 PUP / IR players plus add 2 players to the cap figure in going from 51 to 53, and all of those replacements make only the rookie minimum of $405,000 straight cash, that's a $4 million cut into the $10 million cap space recently reported. That doesn't leave much cushion for an in-season extension or two or some grizzled emergency vets.";}}i:1;s:171:" And here they thought they were protecting veterans by making rookies cheaper. Most players left will probably come cheap anyway. The cap reveals all about a team though.";}, 1458829234, 1462285717
    Run Time: 0.000989
  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, 509641, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"Smokeychedder, post: 509350, member: 6672";s:8:"original";a:2:{i:0;s:51:"[quote="Smokeychedder, post: 509350, member: 6672"]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;s:1:" ";i:1;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"7";s:8:"original";a:2:{i:0;s:8:"[SIZE=7]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#ff0000";s:8:"original";a:2:{i:0;s:15:"[COLOR=#ff0000]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:19:"I like the pups !!!";}}}}}}}}i:1;s:6:" Fake.";}, 1458829234, 1462285717
    Run Time: 0.000993
  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, 509647, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"HyponGrey, post: 509641, member: 6441";s:8:"original";a:2:{i:0;s:47:"[quote="HyponGrey, post: 509641, member: 6441"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:5:"Fake.";}}i:1;s:13:" Who Cares !";}, 1458829234, 1462285717
    Run Time: 0.000833
  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, 509648, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"HyponGrey, post: 509640, member: 6441";s:8:"original";a:2:{i:0;s:47:"[quote="HyponGrey, post: 509640, member: 6441"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:170:"And here they thought they were protecting veterans by making rookies cheaper. Most players left will probably come cheap anyway. The cap reveals all about a team though.";}}i:1;s:1026:" I'm not sure what they were thinking, but the affects are as follows: 1) It makes draft picks more valuable because it makes rookies a lot cheaper...it's a 1/2 off sale (or more) compared to 2010. 2) Salary inflation is still in place for the elite players...rookie savings are flowing to the top. 3) With the salary cap peaking in 2009 at $129 million actual / $136 million adjusted compared to this year's $123 million before carryovers and adjustments, the overall player pie has shrunk. 4) Something had to give...and it's the mass of vets in the middle of the pack who are impacted...solid starters and valued reserves/role players who are not stars are going for a lot less than just a few years ago. It seemed to take GMs until this past off season to make the calculation, but there were a lot of mid-tier and aging vets going for cheaper prices in free agency than in the past. There seemed to be overlooked value in the middle ground as a consequence...particularly at safety as noted in earlier discussions.";}, 1458829234, 1462285717
    Run Time: 0.001080
  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, 509651, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"Smokeychedder, post: 509647, member: 6672";s:8:"original";a:2:{i:0;s:51:"[quote="Smokeychedder, post: 509647, member: 6672"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:11:"Who Cares !";}}i:1;s:126:" I do. Silicone feels wrong. And it moves as a unit instead of a wave like natural does. This conversation devolved quickly...";}, 1458829234, 1462285717
    Run Time: 0.000977
  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, 509653, a:2:{i:0;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:4:"2246";}}i:1;s:48:" OK, let's get serious about this thread now !";}, 1458829234, 1462285717
    Run Time: 0.001031

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/Model/Post.php
  102. library/Dark/PostRating/Model/Post.php
  103. library/sonnbThreadMassActions/Model/Post.php
  104. library/EWRporta2/Model/Post.php
  105. library/EWRporta2/Model/Articles.php
  106. library/XenForo/Model/Attachment.php
  107. library/XenForo/Route/Prefix/Attachments.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. library/XenForo/Route/Prefix/Posts.php
  144. library/XenForo/Model/Avatar.php
  145. internal_data/templates/S.7,L.1,dark_postrating_message_user_info.php
  146. internal_data/templates/S.7,L.1,dark_postrating.php
  147. internal_data/templates/S.7,L.1,bb_code_tag_quote.php
  148. internal_data/templates/S.7,L.1,bb_code_tag_attach.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