Page Time: 0.8222s

Memory: 11.8207 MB (Peak: 13.2116 MB)

Queries (41, time: 0.0516s, 6.3%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000145
    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_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: 40373
    Run Time: 0.000449
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
    SIMPLEuserconstPRIMARYPRIMARY4const0unique row not found
  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.000323
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  4. 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.*,
    		signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
    		0 AS like_date, session.view_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
    	,
    pr2.rating, 
    	pr.*, post.post_id
    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_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 OUTER JOIN xf_session_activity AS session ON post.user_id = session.user_id
    LEFT JOIN dark_postrating pr2 ON (post.post_id = pr2.post_id and pr2.user_id = 0)
    LEFT JOIN (
    select 
    pivot_pr.post_id
    , sum(case when pivot_pr.rating = 1 then 1 else 0 end) dark_postrating_1_count
    , sum(case when pivot_pr.rating = 14 then 1 else 0 end) dark_postrating_14_count
    , sum(case when pivot_pr.rating = 2 then 1 else 0 end) dark_postrating_2_count
    , sum(case when pivot_pr.rating = 3 then 1 else 0 end) dark_postrating_3_count
    , sum(case when pivot_pr.rating = 4 then 1 else 0 end) dark_postrating_4_count
    , sum(case when pivot_pr.rating = 5 then 1 else 0 end) dark_postrating_5_count
    , sum(case when pivot_pr.rating = 6 then 1 else 0 end) dark_postrating_6_count
    , sum(case when pivot_pr.rating = 7 then 1 else 0 end) dark_postrating_7_count
    , sum(case when pivot_pr.rating = 8 then 1 else 0 end) dark_postrating_8_count
    , sum(case when pivot_pr.rating = 9 then 1 else 0 end) dark_postrating_9_count
    , sum(case when pivot_pr.rating = 10 then 1 else 0 end) dark_postrating_10_count
    , sum(case when pivot_pr.rating = 11 then 1 else 0 end) dark_postrating_11_count
    , sum(case when pivot_pr.rating = 12 then 1 else 0 end) dark_postrating_12_count
    , sum(case when pivot_pr.rating = 13 then 1 else 0 end) dark_postrating_13_count
    
    		
    from dark_postrating pivot_pr 
    use index (`post_id_rating`)
    left join xf_post pivot_post on (pivot_pr.post_id = pivot_post.post_id)
    where pivot_post.thread_id = 40373
    group by pivot_pr.post_id
    ) pr on (pr.post_id = post.post_id)
    
    
    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: 40373
    Run Time: 0.035668
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 24Using where; Using temporary; 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 
    PRIMARYsignature_parse_cacheeq_refcontent_type_idcontent_type_id31const,packerfo_maindb.post.user_id1 
    PRIMARYsessionALLPRIMARY   243 
    PRIMARYpr2eq_refpost_id_user_id,post_id_rating,user_id_ratingpost_id_user_id8packerfo_maindb.post.post_id,const1 
    PRIMARY<derived5>ALL    8 
    DERIVEDpivot_postrefPRIMARY,thread_id_post_date,thread_id_positionthread_id_post_date4 27Using where; Using index; Using temporary; Using filesort
    DERIVEDpivot_prrefpost_id_ratingpost_id_rating4packerfo_maindb.pivot_post.post_id2Using index
    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
  5. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 40373
    Run Time: 0.000190
  6. UPDATE xf_session_activity
    SET xf_session_activity.view_count = xf_session_activity.view_count + 1
    WHERE ip = ? AND user_id = 0
    Params: ~
    Run Time: 0.001341
  7. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 40373
    Run Time: 0.000851
  8. SELECT thread.*
    	
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 40373
    Run Time: 0.000322
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
  9. 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.000301
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  10. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 40373
    Run Time: 0.000203
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_ignore_threadrefuser_threaduser_thread8const,const1 
  11. SELECT view_count
    FROM xf_session_activity
    WHERE ip = ? AND user_id = 0
    Params: ~
    Run Time: 0.000184
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityALLPRIMARY   243Using where
  12. 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=40373, 1409216733,
    Run Time: 0.000127
  13. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('Tickets', 'Schedule', 'Draft')
    Params: 1
    Run Time: 0.000110
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 3Using where
  14. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('offline')
    Params: 1
    Run Time: 0.000105
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY106const,const1 
  15. 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, 471482, a:1:{i:0;s:271:"Studs Randall Cobb a good TD Donald Driver finally seeing the endzone this season ST getting a block punt for a TD would be huge. Good Run D Duds. Aaron Rodgers very off today. General D was bad today. OL was having issues. Mason Crosby missing a easy FG.";}, 1406210135, 1409216733
    Run Time: 0.000451
  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, 471489, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"Lunchboxer, post: 471482, member: 3196";s:8:"original";a:2:{i:0;s:48:"[quote="Lunchboxer, post: 471482, member: 3196"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:59:"Studs ST getting a block punt for a TD would be huge. .";}}i:1;s:148:" They threw the graphic up there regarding last blocked punt for a TD was in 1990- I couldn't remember the last time they actually blocked a punt.";}, 1406210135, 1409216733
    Run Time: 0.000439
  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, 471492, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"Lunchboxer, post: 471482, member: 3196";s:8:"original";a:2:{i:0;s:48:"[quote="Lunchboxer, post: 471482, member: 3196"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:271:"Studs Randall Cobb a good TD Donald Driver finally seeing the endzone this season ST getting a block punt for a TD would be huge. Good Run D Duds. Aaron Rodgers very off today. General D was bad today. OL was having issues. Mason Crosby missing a easy FG.";}}i:1;s:193:" I'd have to agree with everything here. I'm not sure i'd call Rodgers a dud though. only mark on him was his fumble, which may have not "technically" been a fumble considering the tuck rule.";}, 1406210135, 1409216733
    Run Time: 0.000461
  18. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('online_invisible')
    Params: 1
    Run Time: 0.000148
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY106const,const1 
  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, 471494, a:1:{i:0;s:411:"Studs Brad Jones, CB's did a pretty decent job, Davon House-- sweet blocked punt, Cobb, Driver Duds RB's, Offensive Line, No pressure without blitz means defensive line is sucking the big one today, A-Rod had a negative performance, Mike McCarthy's playcalling, Mason Crosby-- three dud's in a row. Woodson's replacements struggled today. A mega turkey dud for Mason. Hope he gets his head out of his butt.";}, 1406210135, 1409216733
    Run Time: 0.000783
  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, 471495, a:1:{i:0;s:108:"What about Jerdroppal Paddlehands? His virus is starting to spread as 84 dropped a perfect pass as well....";}, 1406210135, 1409216733
    Run Time: 0.000433
  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, 471501, a:1:{i:0;s:640:"For duds, I would add whoever's decision it is to have Alex Green as the primary runner( McCarthy right?) instead of James Starks.Unless it's been determined that he isn't healthy enough for that duty, it just seems like theres so many times where Green utterly falls short, literally(tripping over people easily). Also, that fake/punt/audible/ pass play seemed like it was just a really poor idea. I get a fake, or just going for it outright, but shifting to an apparent passing formation with your punter behind center? I could be wrong, it may have been a good call and just poorly executed by the players, but it certainly looked bad.";}, 1406210135, 1409216733
    Run Time: 0.000491
  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, 471502, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"Lunchboxer, post: 471482, member: 3196";s:8:"original";a:2:{i:0;s:48:"[quote="Lunchboxer, post: 471482, member: 3196"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:271:"Studs Randall Cobb a good TD Donald Driver finally seeing the endzone this season ST getting a block punt for a TD would be huge. Good Run D Duds. Aaron Rodgers very off today. General D was bad today. OL was having issues. Mason Crosby missing a easy FG.";}}i:1;s:90:" I would like to add the special teams coach to studs/and the packer running back to duds.";}, 1406210135, 1409216733
    Run Time: 0.000506
  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, 471513, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"melvin dangerr, post: 471502, member: 7047";s:8:"original";a:2:{i:0;s:52:"[quote="melvin dangerr, post: 471502, member: 7047"]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"5";s:8:"original";a:2:{i:0;s:8:"[SIZE=5]";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:"#33cccc";s:8:"original";a:2:{i:0;s:15:"[COLOR=#33cccc]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:43:"I would like to add the special teams coach";}}}}i:1;s:46:" to studs/and the packer running back to duds.";}}i:1;s:282:" Absolutely. I have given that guy lots of flack. He deservers a lot of credit for the special teams good play. Wonder if that was McCarthy or Slocum who influenced that questionable fake field goal from 38. That was a black mark but still a winning special teams performance.";}, 1406210135, 1409216733
    Run Time: 0.000456
  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, 471519, a:3:{i:0;s:146:"Everybody can blame the Packers running backs. Sure Benson was doing nice earlier this year with these same linemen. But still, I just didn't see ";i:1;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:4:"any ";}}i:2;s:423:"holes to run through. Green is a guy who if given enough open holes, will bust one too. When you get hit in the backfield and dropped, that's more of the linemens fault then the runner. I don't know. I'm not saying Green played good today, but I don't think he deserves the bulk of the blame. He also has done a good job of holding on to the ball. Something the Jaguars couldn't say when Jennings fumbled in the red zone.";}, 1406210135, 1409216733
    Run Time: 0.000453
  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, 471520, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"bravesman18, post: 471501, member: 2212";s:8:"original";a:2:{i:0;s:49:"[quote="bravesman18, post: 471501, member: 2212"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:640:"For duds, I would add whoever's decision it is to have Alex Green as the primary runner( McCarthy right?) instead of James Starks.Unless it's been determined that he isn't healthy enough for that duty, it just seems like theres so many times where Green utterly falls short, literally(tripping over people easily). Also, that fake/punt/audible/ pass play seemed like it was just a really poor idea. I get a fake, or just going for it outright, but shifting to an apparent passing formation with your punter behind center? I could be wrong, it may have been a good call and just poorly executed by the players, but it certainly looked bad.";}}i:1;s:334:" The only thing that I can figure is that Green must have better ball security and probably the better 3rd down back. Starks looked good in his limited touches out there today. Green will fall sidways or backwards each time a defender hits him on outside runs. Starks simply needs more touches. The Alex Green show isn't a winner.";}, 1406210135, 1409216733
    Run Time: 0.000427
  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, 471521, a:6:{i:0;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:5:"Studs";}}}}i:1;s:25:": Driver Cobb Matthews ";i:2;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:4:"Duds";}}}}i:3;s:263:": Bulaga Sitton Saturday Lang Newhouse These guys are the softest run blockers I have ever seen time and time again in the NFL. They never get holes open, and they never get one of them to the second level to block LBs.... LBs always are to the LOS right away. ";i:4;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:11:"Other Duds:";}}}}i:5;s:490:" Crosby (I can't stand this guy anymore.... I want him replaced by next year or before). He's unclutch. DJ Williams. Easy big drop. 0-2 Rodgers was throwing to him. TE's.... Rodgers was 2-9 throwing to Finley, Crabtree, DJ. That's pitiful. Alex Green. I know there were never holes where they are supposed to be, but have the guts to cut back and look for lanes elswhere.... and on 3rd & 1, don't tackle yourself please. That's almost a turnover. Starks... another simple easy dropped pass.";}, 1406210135, 1409216733
    Run Time: 0.000555
  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, 471522, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"FrankRizzo, post: 471521, member: 2232";s:8:"original";a:2:{i:0;s:48:"[quote="FrankRizzo, post: 471521, member: 2232"]";i:1;s:8:"[/quote]";}s:8:"children";a:6:{i:0;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:5:"Studs";}}}}i:1;s:25:": Driver Cobb Matthews ";i:2;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:4:"Duds";}}}}i:3;s:263:": Bulaga Sitton Saturday Lang Newhouse These guys are the softest run blockers I have ever seen time and time again in the NFL. They never get holes open, and they never get one of them to the second level to block LBs.... LBs always are to the LOS right away. ";i:4;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:11:"Other Duds:";}}}}i:5;s:490:" Crosby (I can't stand this guy anymore.... I want him replaced by next year or before). He's unclutch. DJ Williams. Easy big drop. 0-2 Rodgers was throwing to him. TE's.... Rodgers was 2-9 throwing to Finley, Crabtree, DJ. That's pitiful. Alex Green. I know there were never holes where they are supposed to be, but have the guts to cut back and look for lanes elswhere.... and on 3rd & 1, don't tackle yourself please. That's almost a turnover. Starks... another simple easy dropped pass.";}}i:1;s:156:" The Pack did get a good 5 yard run at some point in the 2nd half. Of course they had to have a 6th offensive lineman in there to accomplish the feat. :(";}, 1406210135, 1409216733
    Run Time: 0.000411
  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, 471525, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"12theTruth, post: 471520, member: 5878";s:8:"original";a:2:{i:0;s:48:"[quote="12theTruth, post: 471520, member: 5878"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:331:"The only thing that I can figure is that Green must have better ball security and probably the better 3rd down back. Starks looked good in his limited touches out there today. Green will fall sidways or backwards each time a defender hits him on outside runs. Starks simply needs more touches. The Alex Green show isn't a winner.";}}i:1;s:108:" Agree, never saw a guy run into a pile where there is nothing and not try a little east to west running...";}, 1406210135, 1409216733
    Run Time: 0.000382
  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, 471529, a:1:{i:0;s:340:"We couldn't run the ball against a team that was surrending 150 yards per game rushing. We definitely need Benson. Crosby is a choker!! Playcalling and Rodgers. Throwing the ball deep into coverage and two fumbles. WTF Allowing 300 yards passing to Blaine Gabbart. plusses have already been listed i.e Driver, Cobb, House, and Matthews.";}, 1406210135, 1409216733
    Run Time: 0.000439
  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, 471530, a:1:{i:0;s:210:"Studs: Cobb, Matthews Duds: The defense looked like last year's last ranked defense, in big part to the pass rush taking a hit with Perry out, not to mention Shields/Woodson. WRs having trouble getting open";}, 1406210135, 1409216733
    Run Time: 0.000392
  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, 471532, a:1:{i:0;s:121:"I like alex green, but he just isnt an every down back to me. If we can get benson back for the playoffs it will be huge.";}, 1406210135, 1409216733
    Run Time: 0.000380
  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, 471542, a:1:{i:0;s:121:"Stud: Jermicheal Finley for also spreading his drop virus to the Jax recievers, they missed a lot of easy ones today:tup:";}, 1406210135, 1409216733
    Run Time: 0.000343
  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, 471544, a:1:{i:0;s:130:"Masthay seemed to be a dud today, he had a bad pass and a bad punt. MM probably isn't a happy camper, happy we won but thats it.";}, 1406210135, 1409216733
    Run Time: 0.000402
  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, 471567, a:1:{i:0;s:158:"The biggest improvement we can make to this team is a new OL coach. It has been the same for a few years, and you can't argue that there isn't talent there.";}, 1406210135, 1409216733
    Run Time: 0.000448
  35. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('online')
    Params: 1
    Run Time: 0.000133
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY106const,const1 
  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, 471593, a:2:{i:0;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;s:12:"For me its: ";}}i:1;s:157:" Studs: Packers Duds: Jags Our team hung in there, never gave up and found a way to pull off the win. The Jags got close but didn't manage to pull it off.";}, 1406210135, 1409216733
    Run Time: 0.000354
  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, 471594, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"FrankRizzo, post: 471521, member: 2232";s:8:"original";a:2:{i:0;s:48:"[quote="FrankRizzo, post: 471521, member: 2232"]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;s:1:" ";i:1;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:11:"Other Duds:";}}}}i:2;s:104:" Crosby (I can't stand this guy anymore.... I want him replaced by next year or before). He's unclutch. ";}}i:1;s:67:" Through the uprights means between them. Not literally through it.";}, 1406210135, 1409216733
    Run Time: 0.000304
  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, 471621, a:1:{i:0;s:536:"If we make the playoffs we will run against. A team who can play defense and get beat because we cannot run the darn ball. If Rodgers has a weaknesss its the fact he doesnt have the luxury of having a guy he can hand the ball off to to either milk the clock, or keep us out of long downs and distances. Hes forced to try and win the game by himself and as good as he is teams have found a way to slow down our offense. Defense hasnt shown they are good enough to take over a game...if we played someone good we loose todays game period.";}, 1406210135, 1409216733
    Run Time: 0.000406
  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, 471627, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"rodell330, post: 471621, member: 6676";s:8:"original";a:2:{i:0;s:47:"[quote="rodell330, post: 471621, member: 6676"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:536:"If we make the playoffs we will run against. A team who can play defense and get beat because we cannot run the darn ball. If Rodgers has a weaknesss its the fact he doesnt have the luxury of having a guy he can hand the ball off to to either milk the clock, or keep us out of long downs and distances. Hes forced to try and win the game by himself and as good as he is teams have found a way to slow down our offense. Defense hasnt shown they are good enough to take over a game...if we played someone good we loose todays game period.";}}i:1;s:459:" I'm not too discouraged after this game. We blew out the Texans a few weeks ago. Yes, they had no Cushing, but let's be fair, we had no Jennings on offense. I think we can make a deep playoff run if we can just get in. Sure, the offense struggled today, but keep in mind, our two best receivers were out and Jacksonville has a defense that can give any offense trouble. I have confidence in our defense when its mostly healthy, which wasn't the case today.";}, 1406210135, 1409216733
    Run Time: 0.000388
  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, 471662, a:1:{i:0;s:388:"Studs: Davon House, Brad Jones (after looking like a stick last week, he was much better yesterday). Duds: Mason Crosby. Get a new kicker, jesus this guy is a choker. The OL. Mediocre at pass blocking, awful at run bloking. Alex Green. Sorry, he's had 3 chances to prove himself now and whiffed on all 3. The Pass Rush. Did Gabbert get pressured at all, especially in the 2nd half?";}, 1406210135, 1409216733
    Run Time: 0.000530
  41. 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, 471665, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"Lunchboxer, post: 471482, member: 3196";s:8:"original";a:2:{i:0;s:48:"[quote="Lunchboxer, post: 471482, member: 3196"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:271:"Studs Randall Cobb a good TD Donald Driver finally seeing the endzone this season ST getting a block punt for a TD would be huge. Good Run D Duds. Aaron Rodgers very off today. General D was bad today. OL was having issues. Mason Crosby missing a easy FG.";}}i:1;s:218:" I agree...BUT....Driver caught a TD pass before this one, this was not his first. Still, It was a bad A$$ catch. One of the first couple games, DD caught a laser ball from Arod over the middle for about 15-20 yds.";}, 1406210135, 1409216733
    Run Time: 0.000394

Included Files (172, XenForo Classes: 65)

  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/sonnb/XenGallery/Listener.php
  29. library/bdTagMe/Listener.php
  30. library/bdTagMe/Helper/Template.php
  31. library/BannedAvatar/Listener.php
  32. library/XenForo/Router.php
  33. library/XenForo/Route/Filter.php
  34. library/XenForo/Route/Interface.php
  35. library/XenForo/Route/ResponseSuffix.php
  36. library/XenForo/Route/Prefix.php
  37. library/XenForo/Route/Prefix/Threads.php
  38. library/EWRporta/Listener/Route.php
  39. library/EWRporta/Route/Thread.php
  40. library/XenForo/RouteMatch.php
  41. library/XenForo/ControllerPublic/Thread.php
  42. library/XenForo/ControllerPublic/Abstract.php
  43. library/XenForo/Controller.php
  44. library/ModerateCountry/RegisterListener.php
  45. library/MailChimp/Listener.php
  46. library/AddOnInstaller/Listener.php
  47. library/SportsNetwork/Listener.php
  48. library/EWRporta/Listener/Controller.php
  49. library/Dark/PostRating/EventListener.php
  50. library/Nobita/IgnoreThread/Listener.php
  51. library/Nobita/LimitGuestThreadPageView/Listener.php
  52. library/SportsNetwork/ControllerPublic/Thread.php
  53. library/EWRporta/ControllerPublic/Thread.php
  54. library/sonnb/XenGallery/XenForo/ControllerPublic/Thread.php
  55. library/Nobita/IgnoreThread/ControllerPublic/Thread.php
  56. library/Nobita/LimitGuestThreadPageView/ControllerPublic/Thread.php
  57. library/XenForo/Input.php
  58. library/XenForo/Session.php
  59. library/Zend/Db.php
  60. library/Zend/Db/Adapter/Mysqli.php
  61. library/Zend/Db/Adapter/Abstract.php
  62. library/Zend/Db/Select.php
  63. library/Zend/Db/Expr.php
  64. library/Zend/Db/Profiler.php
  65. library/Zend/Db/Statement/Mysqli.php
  66. library/Zend/Db/Statement.php
  67. library/Zend/Db/Statement/Interface.php
  68. library/XenForo/Helper/Ip.php
  69. library/XenForo/Visitor.php
  70. library/XenForo/Model/User.php
  71. library/Waindigo/JoinUserGroup/Listener/LoadClass.php
  72. library/Waindigo/Listener/LoadClass.php
  73. library/Waindigo/Listener/LoadClass/20131003.php
  74. library/Asp/OnlineStatus/Plugin/Plugin.php
  75. library/EWRporta/Listener/Model.php
  76. library/Dark/TaigaChat/EventListener/Listener.php
  77. library/sonnbThreadMassActions/Listener.php
  78. library/Waindigo/JoinUserGroup/Extend/XenForo/Model/User.php
  79. library/Dark/PostRating/Model/User.php
  80. library/sonnb/XenGallery/XenForo/Model/User.php
  81. library/bdTagMe/XenForo/Model/User.php
  82. library/Zend/Db/Profiler/Query.php
  83. library/XenForo/Permission.php
  84. library/XenForo/Phrase.php
  85. library/XenForo/Locale.php
  86. library/EWRporta/Model/Perms.php
  87. library/Waindigo/JoinUserGroup/Listener/ControllerPreDispatch.php
  88. library/Waindigo/Listener/ControllerPreDispatch.php
  89. library/Waindigo/Listener/ControllerPreDispatch/20140603.php
  90. library/Waindigo/Listener/Template/20140101.php
  91. library/Waindigo/Listener/TemplateHook/20130522.php
  92. library/Waindigo/Listener/TemplateCreate/20130522.php
  93. library/Waindigo/Listener/InitDependencies.php
  94. library/Waindigo/Listener/InitDependencies/20140401.php
  95. library/XenForo/Model/Session.php
  96. library/Dark/PostRating/Model/Session.php
  97. library/Dark/TaigaChat/Model/SessionOverride.php
  98. library/Nobita/LimitGuestThreadPageView/Model/Session.php
  99. library/XenForo/ControllerHelper/ForumThreadPost.php
  100. library/XenForo/ControllerHelper/Abstract.php
  101. library/XenForo/Model/Thread.php
  102. library/BannedAvatar/Helper.php
  103. library/Dark/PostRating/Model/Thread.php
  104. library/Nobita/IgnoreThread/Model/Thread.php
  105. library/Nobita/LimitGuestThreadPageView/Model/Thread.php
  106. library/sonnbThreadMassActions/Model/Thread.php
  107. library/Dark/PostRating/Model.php
  108. library/XenForo/Model/Forum.php
  109. library/XenForo/Helper/String.php
  110. library/XenForo/Helper/Discussion.php
  111. library/XenForo/Model/Post.php
  112. library/Asp/OnlineStatus/Model/AspPost.php
  113. library/EWRporta/Model/Post.php
  114. library/Dark/PostRating/Model/Post.php
  115. library/sonnbThreadMassActions/Model/Post.php
  116. library/Nobita/LimitGuestThreadPageView/Engine.php
  117. library/XenForo/Model/Attachment.php
  118. library/EWRporta/Model/Attachment.php
  119. library/XenForo/Model/Node.php
  120. library/Nobita/IgnoreThread/Model/Node.php
  121. library/XenForo/Route/Prefix/Categories.php
  122. library/XenForo/Route/Prefix/Forums.php
  123. library/XenForo/ControllerResponse/View.php
  124. library/XenForo/ControllerResponse/Abstract.php
  125. library/Nobita/IgnoreThread/Model/IgnoreThread.php
  126. library/XenForo/Helper/Cookie.php
  127. library/XenForo/ViewRenderer/HtmlPublic.php
  128. library/XenForo/ViewRenderer/Abstract.php
  129. library/XenForo/Template/Public.php
  130. library/XenForo/Template/Abstract.php
  131. library/XenForo/ViewPublic/Thread/View.php
  132. library/XenForo/ViewPublic/Base.php
  133. library/XenForo/View.php
  134. library/EWRporta/Listener/ViewPublic.php
  135. library/EWRporta/ViewPublic/Custom.php
  136. library/XenForo/BbCode/Parser.php
  137. library/XenForo/BbCode/Formatter/Base.php
  138. library/EWRporta/Listener/BbCode.php
  139. library/EWRporta/BbCode/Formatter.php
  140. library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
  141. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
  142. library/XenForo/ViewPublic/Helper/Message.php
  143. library/XenForo/BbCode/TextWrapper.php
  144. library/WhoHasVisited/Listener.php
  145. library/Waindigo/JoinUserGroup/Listener/TemplateCreate.php
  146. library/XenForo/Route/Prefix/Members.php
  147. library/bdTagMe/XenForo/Route/Prefix/Members.php
  148. library/EWRporta/Listener/NavTabs.php
  149. library/ExternalPages/Listeners/Navigation.php
  150. library/ExternalPages/Route/Prefix/En.php
  151. library/Dark/TaigaChat/EventListener/NavigationTabs.php
  152. library/XenForo/Template/FileHandler.php
  153. library/XenForo/Helper/File.php
  154. internal_data/templates/S.7,L.1,thread_view.php
  155. library/SeparateStickyAndNormal/Listener.php
  156. library/EWRporta/Listener/Template.php
  157. library/EWRporta/Model/Promotes.php
  158. library/Waindigo/JoinUserGroup/Listener/TemplateHook.php
  159. internal_data/templates/S.7,L.1,ignore_thread_tool.php
  160. internal_data/templates/S.7,L.1,page_nav.php
  161. library/XenForo/Route/Prefix/Posts.php
  162. library/XenForo/Model/Avatar.php
  163. internal_data/templates/S.7,L.1,RT_UserOnlineRibbon.php
  164. internal_data/templates/S.7,L.1,dark_postrating_message_user_info.php
  165. internal_data/templates/S.7,L.1,dark_postrating.php
  166. library/XenForo/ViewPublic/Helper/User.php
  167. internal_data/templates/S.7,L.1,bb_code_tag_quote.php
  168. library/XenForo/Model/UserField.php
  169. library/XenForo/Helper/Criteria.php
  170. library/XenForo/Debug.php
  171. internal_data/templates/S.7,L.1,PAGE_CONTAINER.php
  172. library/XenForo/ViewRenderer/Json.php