Page Time: 0.2037s

Memory: 6.6846 MB (Peak: 8.1339 MB)

Queries (40, time: 0.0411s, 20.2%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000221
    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: 13417
    Run Time: 0.001279
    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: 13
    Run Time: 0.000434
    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: 13417
    Run Time: 0.002552
    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: 13417
    Run Time: 0.001212
    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: 13417
    Run Time: 0.008939
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 24Using where; Using filesort
    PRIMARYbb_code_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.post_id1 
    PRIMARYusereq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYuser_profileeq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYuser_privacyeq_refPRIMARYPRIMARY4packerfo_maindb.post.user_id1 
    PRIMARYsignature_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.user_id1 
    PRIMARYsession_activityeq_refPRIMARYPRIMARY22packerfo_maindb.post.user_id,func1 
    PRIMARYpr_cacheeq_refPRIMARYPRIMARY4packerfo_maindb.post.post_id1 
    PRIMARYpr2eq_refpost_id_user_id,post_id_rating,user_id_ratingpost_id_user_id8packerfo_maindb.post.post_id,const1 
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4packerfo_maindb.post.user_id4Using where
  7. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 13417
    Run Time: 0.000219
  8. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 13417
    Run Time: 0.001061
  9. SELECT thread.*
    	,
    		0 AS thread_reply_banned
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 13417
    Run Time: 0.000410
    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: 13
    Run Time: 0.000415
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  11. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 13417
    Run Time: 0.000170
    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: 13417
    Run Time: 0.001148
    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: 13417
    Run Time: 0.000867
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_postconstPRIMARYPRIMARY4const1 
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLEEWRporta2_authorsconstPRIMARYPRIMARY4const0unique row not found
    SIMPLEEWRporta2_articlesconstPRIMARYPRIMARY4const0unique row not found
  14. INSERT INTO xf_session_activity
    	(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
    VALUES
    	(?, ?, ?, ?, ?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE
    	ip = VALUES(ip),
    	controller_name = VALUES(controller_name),
    	controller_action = VALUES(controller_action),
    	view_state = VALUES(view_state),
    	params = VALUES(params),
    	view_date = VALUES(view_date),
    	robot_key = VALUES(robot_key)
    Params: 0, , , XenForo_ControllerPublic_Thread, Index, valid, thread_id=13417&page=2, 1464287733,
    Run Time: 0.000769
  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.000201
    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, 217404, a:1:{i:0;s:58:"4PackGirl gets the best banner (or at least it's my fave).";}, 1458829234, 1464287733
    Run Time: 0.001255
  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, 217405, a:1:{i:0;s:39:"How about "Best Married Couple" :wink:";}, 1458829234, 1464287733
    Run Time: 0.000934
  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, 217406, a:1:{i:0;s:84:"Best forum member living in enemy territory (any NFL team city other than Green Bay)";}, 1458829234, 1464287733
    Run Time: 0.000874
  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, 217407, a:1:{i:0;s:267:"This does sound like a really neat idea. Problem is just organizing it, and then having a mod run this thing to ensure it actually gets done (cough*GM-thing-couple-years-back*cough*) in its entirety. I'll post a thread on this in the mods section *feels important*";}, 1458829234, 1464287733
    Run Time: 0.000771
  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, 217408, a:3:{i:0;s:28:"How is this for an award... ";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:45:"longest duration to fill out a interview form";}}i:2;s:18:".. :rotflmao:";}, 1458829234, 1464287733
    Run Time: 0.000698
  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, 217409, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"all about da packers";s:8:"original";a:2:{i:0;s:30:"[quote="all about da packers"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:267:"This does sound like a really neat idea. Problem is just organizing it, and then having a mod run this thing to ensure it actually gets done (cough*GM-thing-couple-years-back*cough*) in its entirety. I'll post a thread on this in the mods section *feels important*";}}i:1;s:210:" Nobody wants to hear you cry. If you people would have made me a moderator when you had the chance, I woulda headed it up. But now you have to, and I laugh at you. Bitterness, it's what's for dinner.";}, 1458829234, 1464287733
    Run Time: 0.000966
  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, 217410, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"all about da packers";s:8:"original";a:2:{i:0;s:30:"[quote="all about da packers"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:267:"This does sound like a really neat idea. Problem is just organizing it, and then having a mod run this thing to ensure it actually gets done (cough*GM-thing-couple-years-back*cough*) in its entirety. I'll post a thread on this in the mods section *feels important*";}}i:1;s:286:" I would like to see this get done. If there is any assistance needed, I have no problem lending a hand. Organizationally, you could first start by just running blind polls for all the categories. That would generate your results. Run them for a week and head for the Tromadz Lounge.";}, 1458829234, 1464287733
    Run Time: 0.000969
  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, 217411, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:56:"There could be an online ceremony in the Tromadz lounge.";}}i:1;s:1092:" The Tromdaz Lounge is reserved for drunken spaz fests. So, the awards must be on a Saturday not a work day. I think you have to nominate the possible award winners (Just Like The Academy Awards Does.) before the actual award show in the Tromdaz Lounge. I say we actually announce the awards in the Tromdaz Lounge. Just like the draft, the next award can be on the clock.... That way we all can bash the nominee's before Ryan opens the envelope and announces the winner. The entries for categories posted above are great.... Here are my ideas for categories. Instead of making it about members... make the awards about the POST. After all that is what this forum is about POSTS or THREADS. Packer Forum Rookie Post The Year. Most Original Post Of The Year. Best Response To A Post Award. Best Locked Thread Of The Year. Most Inspirational Post of the year. Most Confusing Post Of The year. Silliest Post Of The Year. Most Respected Non Packer Fan Troll Post Of The Year. Funniest Post Of The Year. Most Prolific (Came True) Post Of The Year.";}, 1458829234, 1464287733
    Run Time: 0.000858
  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, 217412, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:12:"Raider Pride";s:8:"original";a:2:{i:0;s:22:"[quote="Raider Pride"]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:56:"There could be an online ceremony in the Tromadz lounge.";}}i:1;s:1092:" The Tromdaz Lounge is reserved for drunken spaz fests. So, the awards must be on a Saturday not a work day. I think you have to nominate the possible award winners (Just Like The Academy Awards Does.) before the actual award show in the Tromdaz Lounge. I say we actually announce the awards in the Tromdaz Lounge. Just like the draft, the next award can be on the clock.... That way we all can bash the nominee's before Ryan opens the envelope and announces the winner. The entries for categories posted above are great.... Here are my ideas for categories. Instead of making it about members... make the awards about the POST. After all that is what this forum is about POSTS or THREADS. Packer Forum Rookie Post The Year. Most Original Post Of The Year. Best Response To A Post Award. Best Locked Thread Of The Year. Most Inspirational Post of the year. Most Confusing Post Of The year. Silliest Post Of The Year. Most Respected Non Packer Fan Troll Post Of The Year. Funniest Post Of The Year. Most Prolific (Came True) Post Of The Year.";}}i:1;s:255:" I agree with the nomination portion, you could just post nomination threads as well. I do think you need a combination of posts/posters however. I love the came true post, but that's alot of rumor sifting to be done. EDIT: Did we ever get Moss?";}, 1458829234, 1464287733
    Run Time: 0.000767
  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, 217413, a:1:{i:0;s:93:"i wouldn't want to go dig up old posts to find the nominees. i say we stick with the posters";}, 1458829234, 1464287733
    Run Time: 0.000747
  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, 217414, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:9:"bozz_2006";s:8:"original";a:2:{i:0;s:19:"[quote="bozz_2006"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:93:"i wouldn't want to go dig up old posts to find the nominees. i say we stick with the posters";}}i:1;s:217:" Thats what i was thinking.......i have enough trouble remembering day to day whats posted..........to try to find old ones (i don't even remember ones i myself posted last week) would be more then impossible for me.";}, 1458829234, 1464287733
    Run Time: 0.000789
  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, 217415, a:1:{i:0;s:46:"How about 'Best Member from Australia?' :wink:";}, 1458829234, 1464287733
    Run Time: 0.000743
  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, 217416, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:46:"How about 'Best Member from Australia?' :wink:";}}i:1;s:38:" best sig by an Australian teenager";}, 1458829234, 1464287733
    Run Time: 0.000801
  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, 217417, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"all about da packers";s:8:"original";a:2:{i:0;s:30:"[quote="all about da packers"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:267:"This does sound like a really neat idea. Problem is just organizing it, and then having a mod run this thing to ensure it actually gets done (cough*GM-thing-couple-years-back*cough*) in its entirety. I'll post a thread on this in the mods section *feels important*";}}i:1;s:128:" Would it be possible to add another extra button like there is for reporting a post, but it would be for nominating the post";}, 1458829234, 1464287733
    Run Time: 0.000775
  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, 217418, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:58:"4PackGirl gets the best banner (or at least it's my fave).";}}i:1;s:27:" thanks, zombie. :pals:";}, 1458829234, 1464287733
    Run Time: 0.000914
  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, 217419, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:12:"Zombieslayer";s:8:"original";a:2:{i:0;s:22:"[quote="Zombieslayer"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:58:"4PackGirl gets the best banner (or at least it's my fave).";}}i:1;s:27:" thanks, zombie. :pals:";}}i:1;s:85:" It could be even better minus a couple of G's and a ill placed banner. :twisted:";}, 1458829234, 1464287733
    Run Time: 0.000972
  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, 217420, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:83:" It could be even better minus a couple of G's and a ill placed banner. :twisted:";}}i:1;s:218:" Hmmm.......... natural blonde??? :wink: Seems to me that a long time ago 4packgirl said something about removing the aforementioned items from her sig. if the Packers had an oustanding winning season. :pop:";}, 1458829234, 1464287733
    Run Time: 0.000756
  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, 217421, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"all about da packers";s:8:"original";a:2:{i:0;s:30:"[quote="all about da packers"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:267:"This does sound like a really neat idea. Problem is just organizing it, and then having a mod run this thing to ensure it actually gets done (cough*GM-thing-couple-years-back*cough*) in its entirety. I'll post a thread on this in the mods section *feels important*";}}i:1;s:621:" It's not too hard. First: Have a thread to compile X amount of awards. (done) Second: PF.com staff chooses/selects X amount of worthy awards. Third: Post a thread for nominees for each award. This obviously would take up quite a few threads depending on the PF.com staff selection of awards. Perhaps create a sub forum of the atrium to keep it organized. Fourth: Post a thread of each award collecting nominees to X amount. Finally: Create a poll for each award with each of the X amount of nominees as options and set it whatever desired time frame. This can all be done via the forums with ease.";}, 1458829234, 1464287733
    Run Time: 0.000892
  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, 217422, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:128:" Would it be possible to add another extra button like there is for reporting a post, but it would be for nominating the post";}}i:1;s:40:" That is actually not a bad idea man.";}, 1458829234, 1464287733
    Run Time: 0.001036
  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, 217423, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"all about da packers";s:8:"original";a:2:{i:0;s:30:"[quote="all about da packers"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:267:"This does sound like a really neat idea. Problem is just organizing it, and then having a mod run this thing to ensure it actually gets done (cough*GM-thing-couple-years-back*cough*) in its entirety. I'll post a thread on this in the mods section *feels important*";}}i:1;s:340:" It's not too hard. Have a thread to compile X amount of awards. PF.com staff chooses/selects X amount of worthy awards. Post a thread for contestants for each award. Limit nominees to say 10. Then take the ten most voted for. Then make a poll for each award for a set time limit. All of this can be done via the forums.";}}i:1;s:54:" What he said, a couple of hours prep time at best.";}, 1458829234, 1464287733
    Run Time: 0.000780
  36. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 217424, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:340:" It's not too hard. Have a thread to compile X amount of awards. PF.com staff chooses/selects X amount of worthy awards. Post a thread for contestants for each award. Limit nominees to say 10. Then take the ten most voted for. Then make a poll for each award for a set time limit. All of this can be done via the forums.";}}i:1;s:413:" Yup, tripp suggested the same thing. The only thing is though that 10 nominees might be too much, I was thinking more like 4-5. Have few categories based around posters and not posts (at least not this time) like bozz said. There still a few minor things to work out (like deadline for the polls, etc.) but that is really nothing major. Winner would get special user title and/or sig to display.";}, 1458829234, 1464287733
    Run Time: 0.000929
  37. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 217425, a:1:{i:0;s:237:"Geez what a hiccup on the site there. I didn't read any posts after yours AADP so if I repeated someone, my apologizes. I tried editing my post like eight times, but the site kept lagging out. For some reason this site lags and hates me.";}, 1458829234, 1464287733
    Run Time: 0.000746
  38. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 217426, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:20:"all about da packers";s:8:"original";a:2:{i:0;s:30:"[quote="all about da packers"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:60:" Winner would get special user title and/or sig to display.";}}i:1;s:14:" Good idea.";}, 1458829234, 1464287733
    Run Time: 0.000654
  39. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 217427, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:126:" Would it be possible to add another extra button like there is for reporting a post, but it would be for nominating the post";}}i:1;s:284:" Yup that is what I was thinking too, but the only thing is that we'd have to define specific categories beforehand so members would be able to nominate posts. Categories like "best post of the year" and "funniest post of the year" would be given, but some more would be needed.";}, 1458829234, 1464287733
    Run Time: 0.000731
  40. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 217428, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[quote]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:237:"Geez what a hiccup on the site there. I didn't read any posts after yours AADP so if I repeated someone, my apologizes. I tried editing my post like eight times, but the site kept lagging out. For some reason this site lags and hates me.";}}i:1;s:46:" No worries, same thing happened to me. :-?";}, 1458829234, 1464287733
    Run Time: 0.000826

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