Page Time: 0.1085s

Memory: 6.6888 MB (Peak: 8.1941 MB)

Queries (24, time: 0.0206s, 19.0%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000196
    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: 38576
    Run Time: 0.000472
    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: 32
    Run Time: 0.000258
    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: 38576
    Run Time: 0.001153
    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: 38576
    Run Time: 0.001632
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_postconstPRIMARYPRIMARY4const1 
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLEEWRporta2_authorsconstPRIMARYPRIMARY4const0unique row not found
    SIMPLEEWRporta2_articlesconstPRIMARYPRIMARY4const0unique row not found
  6. SELECT post.*
    	,
    thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
    thread.post_date AS thread_post_date,
    post.user_id, post.username, post.post_date,
    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
    
    INNER JOIN xf_thread AS thread ON
    	(thread.thread_id = post.thread_id)
    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.message_state IN ('visible'))
    	 AND (post.position >= 0 AND post.position < 25) )
    	OR post.post_id = thread.first_post_id)
    ORDER BY post.position ASC, post.post_date ASC
    Params: 38576
    Run Time: 0.002922
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYthreadconstPRIMARYPRIMARY4const1Using filesort
    PRIMARYpostrefPRIMARY,thread_id_post_date,thread_id_positionthread_id_post_date4const2Using where
    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 (459573)
    ORDER BY attachment.content_id, attachment.attach_date
    Params: post
    Run Time: 0.000418
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEattachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where
    SIMPLEdataeq_refPRIMARYPRIMARY4packerfo_maindb.attachment.data_id1 
  8. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 38576
    Run Time: 0.000181
  9. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 38576
    Run Time: 0.002293
  10. SELECT thread.*
    	,
    		0 AS thread_reply_banned
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 38576
    Run Time: 0.000467
    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: 32
    Run Time: 0.000397
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  12. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 38576
    Run Time: 0.000323
    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: 38576
    Run Time: 0.001276
    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: 38576
    Run Time: 0.000943
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_postconstPRIMARYPRIMARY4const1 
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLEEWRporta2_authorsconstPRIMARYPRIMARY4const0unique row not found
    SIMPLEEWRporta2_articlesconstPRIMARYPRIMARY4const0unique row not found
  15. 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 (459573)
    ORDER BY attachment.content_id, attachment.attach_date
    Params: post
    Run Time: 0.000161
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEattachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where
    SIMPLEdataeq_refPRIMARYPRIMARY4packerfo_maindb.attachment.data_id1 
  16. SELECT EWRporta2_catlinks.*, EWRporta2_categories.*, xf_user.*
    FROM EWRporta2_catlinks
    	INNER JOIN EWRporta2_categories ON (EWRporta2_categories.category_id = EWRporta2_catlinks.category_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = EWRporta2_catlinks.user_id)
    WHERE EWRporta2_catlinks.thread_id = ?
    	
    ORDER BY EWRporta2_categories.category_name
    Params: 38576
    Run Time: 0.001137
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta2_catlinksrefthread_idthread_id4const1Using temporary; Using filesort
    SIMPLEEWRporta2_categorieseq_refPRIMARYPRIMARY4packerfo_maindb.EWRporta2_catlinks.category_id1 
    SIMPLExf_usereq_refPRIMARYPRIMARY4packerfo_maindb.EWRporta2_catlinks.user_id1 
  17. 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=38576, 1464571013,
    Run Time: 0.000153
  18. SELECT *
    	FROM EWRporta2_layouts
    WHERE (layout_template = ?
    	OR layout_template = 'EWRporta2_ArticleList')
    	AND active = 1
    ORDER BY layout_priority ASC
    Params: EWRporta2_ArticleView
    Run Time: 0.000162
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta2_layoutsrangelayout_templatelayout_template302 2Using where; Using filesort
  19. SELECT EWRporta2_widlinks.*, EWRporta2_widgets.widget_values, EWRporta2_widopts.widopt_values,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.widopt_id, 0) AS widopt_id,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.locked, EWRporta2_widgets.locked) AS locked,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.display, EWRporta2_widgets.display) AS display,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.groups, EWRporta2_widgets.groups) AS groups,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.ctime, EWRporta2_widgets.ctime) AS ctime,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.cdate, EWRporta2_widgets.cdate) AS cdate,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.cache, EWRporta2_widgets.cache) AS cache
    FROM EWRporta2_widlinks
    	INNER JOIN EWRporta2_widgets ON (EWRporta2_widgets.widget_id = EWRporta2_widlinks.widget_id)
    	LEFT JOIN EWRporta2_widopts ON (EWRporta2_widopts.widopt_id = EWRporta2_widlinks.widopt_id)
    WHERE layout_id = ?
    	AND EWRporta2_widgets.active = 1
    ORDER by widlink_order
    Params: article_list
    Run Time: 0.000190
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta2_widlinksreflayout_id,widget_idlayout_id302const11Using where; Using filesort
    SIMPLEEWRporta2_widoptseq_refPRIMARYPRIMARY4packerfo_maindb.EWRporta2_widlinks.widopt_id1 
    SIMPLEEWRporta2_widgetseq_refPRIMARYPRIMARY302packerfo_maindb.EWRporta2_widlinks.widget_id1Using where
  20. SELECT thread.*
    	,
    	user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
    	last_post_user.gender AS last_post_gender,
    	last_post_user.avatar_date AS last_post_avatar_date,
    	last_post_user.gravatar AS last_post_gravatar,
    	IF(last_post_user.username IS NULL, thread.last_post_username, last_post_user.username) AS last_post_username,
    	node.title AS node_title, node.node_name,
    	forum.*,
    	forum.last_post_id AS forum_last_post_id,
    	forum.last_post_date AS forum_last_post_date,
    	forum.last_post_user_id AS forum_last_post_user_id,
    	forum.last_post_username AS forum_last_post_username,
    	forum.last_thread_title AS forum_last_thread_title,
    	thread.last_post_id,
    	thread.last_post_date,
    	thread.last_post_user_id,
    	thread.last_post_username,
    	NULL AS thread_read_date,
    	0 AS thread_is_watched,
    	0 AS user_post_count,
    permission.cache_value AS node_permission_cache,
    	pr_cache.rating_cache
    FROM xf_thread AS thread
    
    	LEFT JOIN xf_user AS user ON
    		(user.user_id = thread.user_id)
    	LEFT JOIN xf_user AS last_post_user ON
    		(last_post_user.user_id = thread.last_post_user_id)
    	LEFT JOIN xf_node AS node ON
    		(node.node_id = thread.node_id)
    	LEFT JOIN xf_forum AS forum ON
    		(forum.node_id = thread.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 = thread.node_id)
    	left join dark_postrating_post_cache pr_cache ON (thread.first_post_id = pr_cache.post_id)
    WHERE (thread.discussion_type <> 'redirect') AND (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1462151813) AND (forum.find_new = 1) AND 1=1
    ORDER BY thread.last_post_date DESC
     LIMIT 20
    Run Time: 0.001613
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadrangenode_id_last_post_date,last_post_date,node_id_sticky_state_last_postlast_post_date4 355Using where
    SIMPLEforumeq_refPRIMARYPRIMARY4packerfo_maindb.thread.node_id1Using where
    SIMPLEpermissioneq_refPRIMARYPRIMARY35const,const,packerfo_maindb.forum.node_id1 
    SIMPLEusereq_refPRIMARYPRIMARY4packerfo_maindb.thread.user_id1 
    SIMPLElast_post_usereq_refPRIMARYPRIMARY4packerfo_maindb.thread.last_post_user_id1 
    SIMPLEnodeeq_refPRIMARYPRIMARY4packerfo_maindb.thread.node_id1 
    SIMPLEpr_cacheeq_refPRIMARYPRIMARY4packerfo_maindb.thread.first_post_id1 
  21. SELECT session_activity.*
    	,
    	user.*
    FROM xf_session_activity AS session_activity
    
    	LEFT JOIN xf_user AS user ON
    		(user.user_id = session_activity.user_id)
    WHERE (session_activity.view_date > 1464570113)
    ORDER BY session_activity.view_date DESC
    Run Time: 0.000939
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEsession_activityrangeview_dateview_date4 36Using where
    SIMPLEusereq_refPRIMARYPRIMARY4packerfo_maindb.session_activity.user_id1 
  22. 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.000139
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 4Using where
  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, 459573, a:33:{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:"1880";}}i:1;s:1:" ";i:2;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:4:"13px";s:8:"original";a:2:{i:0;s:11:"[SIZE=13px]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:6:"Tahoma";s:8:"original";a:2:{i:0;s:13:"[FONT=Tahoma]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#222222";s:8:"original";a:2:{i:0;s:15:"[COLOR=#222222]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:24:"Kyle Terada-US PRESSWIRE";}}}}}}i:3;s:20:" By Travis Duncan ";i:4;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"2";s:8:"original";a:2:{i:0;s:8:"[SIZE=2]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;s:19:"Packer Forum writer";}}i:5;s:538:" Pete Morelli is the high school Principal at St. Mary's High School in Stockton, California. Carl Cheffers works in the car battery division of Johnson Controls Inc. Jeff Tripplette was a former Vice President at Duke Energy, specializing in risk management. Bill Leavy served as a San Jose Police and Firefighter for 27 years before he retired in 1996. Walt Anderson is a retired dentist from Sugarland, Texas. When not fine tuning his massive biceps, Ed Hochuli is a lawyer with the firm Jones, Skelton & Hochuli in Phoenix";i:6;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:4:"13px";s:8:"original";a:2:{i:0;s:11:"[SIZE=13px]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:10:"sans-serif";s:8:"original";a:2:{i:0;s:17:"[FONT=sans-serif]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#000000";s:8:"original";a:2:{i:0;s:15:"[COLOR=#000000]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"2";s:8:"original";a:2:{i:0;s:8:"[SIZE=2]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:10:"sans-serif";s:8:"original";a:2:{i:0;s:17:"[FONT=sans-serif]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#000000";s:8:"original";a:2:{i:0;s:15:"[COLOR=#000000]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:1:".";}}}}}}}}}}}}i:7;s:365:" Not that anyone was happy with these guys when they were officiating but you don't know what you have until it's gone. It was Leavy in last season's Packers-Giants playoff game who overturned a fumble call on Greg Jennings and ruled it down by contact. That was a favor for the Packers which ultimately didn't make a difference in the game. Leavy was however, ";i:8;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:198:"http://content.usatoday.com/communities/gameon/post/2012/01/tv-analysts-rip-atrocious-one-sided-refs-in-giants-packers-new-york-giants-fox-espn-green-bay-packers-referees-officiating-/1#.UDujZ9ZlTpY";s:8:"original";a:2:{i:0;s:206:"[URL='http://content.usatoday.com/communities/gameon/post/2012/01/tv-analysts-rip-atrocious-one-sided-refs-in-giants-packers-new-york-giants-fox-espn-green-bay-packers-referees-officiating-/1#.UDujZ9ZlTpY']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:53:"mercilessly criticized by the FOX TV crew and others.";}}i:9;s:741:" Call it a job hazard. Criticism of the referees is among the sacred duties of sports fandom. So criticism of replacement refs was to be expected, but most would agree the replacement referees are noticeably worst then the regulars. The lead negotiator for the NFL ref union, Mike Arnold, told ESPN, "It's not our job to judge the replacements, because their performance speaks for itself." Ouch. Is the performance of the replacements through three preseason games prompting the NFL to budge in secret negotiations with the referees union? We don't know. Not a word has been leaked to the general public or media one way or another at this point. Commissioner Roger Goodell did say last week concerning the replacement referees, "";i:10;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#000000";s:8:"original";a:2:{i:0;s:15:"[COLOR=#000000]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:43:"We think they’ll do a very credible job."";}}}}i:11;s:116:" The NFL is paying replacement referees $2,000 per game as opposed the $8,000 the regulars make, according to the ";i:12;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:10:"LA Times. ";}}i:13;s:1256:" Logically as the boos amplify you would think the NFL will give in meet the demands of the referees and move forward. But the NFL has leverage in this scenario for a lot of different reasons. The number one reason though is that the games will go on without the regular officials and that's all that matters. When a sport reaches a certain level or popularity and pedigree (and $9 billion in revenue), conversation about it only serves its interest, good or bad. The 16-game regular season could realistically be refereed by the inexperienced with a flurry of horrible non-calls, miss calls and game costing calls and we'll all still watch and be fans. The leverage in that sense is with the NFL. However, two other groups have a different perspective. The players and the owners. First and foremost the owners have a financial perspective. And the formula is usually pretty simple-winning teams generate more revenue. Tally enough game-changing miscues and before you know it every owner will be affected and on the horn with Goodell or the powers that be trying to get the regular guys like Huchuli and Morelli away from their desks and onto the field. Secondly, the chorus of boos is starting to amplify among NFL players. According to the ";i:14;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:8:"LA Times";}}i:15;s:135:" the NFL reminded coaches and players not to criticize replacement refs, but that didn't stop the Packers very own Charles Woodson who ";i:16;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:121:"http://content.usatoday.com/communities/thehuddle/post/2012/08/charles-woodson-bashes-nfl-replacement-refs/1#.UDubVdZlTpY";s:8:"original";a:2:{i:0;s:129:"[URL='http://content.usatoday.com/communities/thehuddle/post/2012/08/charles-woodson-bashes-nfl-replacement-refs/1#.UDubVdZlTpY']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:36:"had this to say to USA TODAY Sports:";}}i:17;s:3:" ";i:18;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:196:""They haven't been very good. That's the honest opinion. Before preseason started, I think you're optimistic. But it's almost like a young guy coming into the NFL. The game goes too fast for them.";}}i:19;s:3:" ";i:20;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:239:""There will be some things you normally wouldn't get away with. It's not that you'd be trying to get away with them, but you will because the official didn't see it or he didn't know to make the call. We need the (regular officials) back."";}}i:21;s:40:" Vikings punter Chris Kluwe tweeted, "";i:22;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#000000";s:8:"original";a:2:{i:0;s:15:"[COLOR=#000000]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:127:"The NFL really needs to kiss and make up with the refs. These replacements are horrible. Frankly, it’s kind of embarrassing."";}}}}i:23;s:53:" Tennessee Titans defensive coordinator Jerry Gray ";i:24;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:110:"http://www.jacksonsun.com/usatoday/article/830785&usatref=sportsmod?odyssey=mod%7Cnewswell%7Ctext%7CSports%7Cp";s:8:"original";a:2:{i:0;s:118:"[URL='http://www.jacksonsun.com/usatoday/article/830785&usatref=sportsmod?odyssey=mod%7Cnewswell%7Ctext%7CSports%7Cp']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:30:"allegedly called NFL officials";}}i:25;s:79:" "The Three Stooges" during a game last Thursday night. Of course the league ";i:26;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:5:"does ";}}i:27;s:109:"care about the quality of the officiating and that is also at the root of dispute with the referees union. ";i:28;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#000000";s:8:"original";a:2:{i:0;s:15:"[COLOR=#000000]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:216:"The NFL would like its referees to give up their day jobs and focus on officiating full-time. Given the plethora of their real world talent and other business pursuits, you could see why that might become a problem. ";}}}}i:29;s:3:" ";i:30;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#000000";s:8:"original";a:2:{i:0;s:15:"[COLOR=#000000]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:162:"Another issue in the dispute is the NFL's plan to add more crews and officials, meaning that certain crews and officials could be replaced, for poor performance. ";}}}}i:31;s:3:" ";i:32;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#000000";s:8:"original";a:2:{i:0;s:15:"[COLOR=#000000]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:104:"Goodell emphasized last week the NFL is prepared to start the regular season with replacement officials.";}}}}}, 1458829234, 1464571013
    Run Time: 0.001463
  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, 461262, a:1:{i:0;s:309:"Not quitting my day job as I enjoy working at Lambeau Field. Now the company I work for(DNC)is a different story. They're unorganized & have had several job fairs but are not able to hire the people needed. Therefore they must bus people in from the surrounding states to help us serve the fans. GO PACK GO!!!";}, 1458829234, 1464571013
    Run Time: 0.001690

Included Files (177, XenForo Classes: 64)

  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/EWRporta2/Model/Catlinks.php
  116. library/EWRporta2/Model/Categories.php
  117. library/XenForo/Helper/Cookie.php
  118. library/XenForo/ViewRenderer/HtmlPublic.php
  119. library/XenForo/ViewRenderer/Abstract.php
  120. library/XenForo/Template/Public.php
  121. library/XenForo/Template/Abstract.php
  122. library/EWRporta2/ViewPublic/ArticleView.php
  123. library/XenForo/ViewPublic/Base.php
  124. library/XenForo/View.php
  125. library/EWRporta2/Listener/ViewPublic.php
  126. library/EWRporta2/ViewPublic/Global.php
  127. library/EWRporta2/Model/Layouts.php
  128. library/EWRporta2/Model/Widlinks.php
  129. library/XenForo/BbCode/Parser.php
  130. library/XenForo/BbCode/Formatter/Base.php
  131. library/EWRporta2/Listener/BbCode.php
  132. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
  133. library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
  134. library/EWRporta2/BbCode/Formatter.php
  135. library/WhoHasVisited/Listener.php
  136. library/EWRporta2/Widget/Threads.php
  137. library/XenForo/Helper/Discussion.php
  138. library/EWRporta2/Widget/SocialCallout.php
  139. library/EWRporta2/Widget/UpcomingGame.php
  140. library/EWRporta2/Widget/CurrentStandings.php
  141. library/EWRporta2/Widget/UsersOnline.php
  142. library/XenForo/Model/Session.php
  143. library/Dark/PostRating/Model/Session.php
  144. library/Dark/TaigaChat/Model/SessionOverride.php
  145. library/EWRporta2/Widget/ForumStats.php
  146. library/XenForo/ViewPublic/Helper/Message.php
  147. library/XenForo/BbCode/TextWrapper.php
  148. library/XenForo/Route/Prefix/Members.php
  149. library/bdTagMe/XenForo/Route/Prefix/Members.php
  150. library/Dark/TaigaChat/EventListener/NavigationTabs.php
  151. library/EWRporta2/Listener/NavTabs.php
  152. library/XenForo/Template/FileHandler.php
  153. library/XenForo/Helper/File.php
  154. internal_data/templates/S.7,L.1,EWRporta2_ArticleView.php
  155. library/SeparateStickyAndNormal/Listener.php
  156. internal_data/templates/S.7,L.1,ignore_thread_tool.php
  157. library/EWRporta2/Listener/Template.php
  158. library/XenForo/Route/Prefix/Posts.php
  159. library/XenForo/Model/Avatar.php
  160. internal_data/templates/S.7,L.1,dark_postrating_message_user_info.php
  161. internal_data/templates/S.7,L.1,bb_code_tag_attach.php
  162. internal_data/templates/S.7,L.1,dark_postrating.php
  163. internal_data/templates/S.7,L.1,EWRwidget_AdBlockSideBarTop.php
  164. library/FreePro/Helper.php
  165. internal_data/templates/S.7,L.1,EWRwidget_Threads.php
  166. internal_data/templates/S.7,L.1,EWRwidget_EmailCallout.php
  167. internal_data/templates/S.7,L.1,EWRwidget_SocialCallout.php
  168. internal_data/templates/S.7,L.1,EWRwidget_AdBlockSideBarBottom.php
  169. internal_data/templates/S.7,L.1,EWRwidget_UpcomingGame.php
  170. internal_data/templates/S.7,L.1,EWRwidget_CurrentStandings.php
  171. internal_data/templates/S.7,L.1,EWRwidget_UsersOnline.php
  172. internal_data/templates/S.7,L.1,EWRwidget_ForumStats.php
  173. library/XenForo/Helper/Criteria.php
  174. library/XenForo/Debug.php
  175. internal_data/templates/S.7,L.1,PAGE_CONTAINER.php
  176. internal_data/templates/S.7,L.1,EWRporta2_Navtabs.php
  177. library/XenForo/ViewRenderer/Json.php