Page Time: 0.2965s

Memory: 6.7066 MB (Peak: 8.1630 MB)

Queries (40, time: 0.0721s, 24.3%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000218
    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: 21648
    Run Time: 0.003869
    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: 10
    Run Time: 0.000645
    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: 21648
    Run Time: 0.004410
    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: 21648
    Run Time: 0.001381
    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 >= 150 AND post.position < 175) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 21648
    Run Time: 0.006064
    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: 21648
    Run Time: 0.000208
  8. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 21648
    Run Time: 0.002985
  9. SELECT thread.*
    	,
    		0 AS thread_reply_banned
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 21648
    Run Time: 0.000732
    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: 10
    Run Time: 0.003390
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  11. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 21648
    Run Time: 0.000345
    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: 21648
    Run Time: 0.001586
    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: 21648
    Run Time: 0.001287
    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=21648&page=7, 1469315101,
    Run Time: 0.001239
  15. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('freepro_menu_tickets', 'freepro_menu_schedule', 'freepro_menu_roster', 'freepro_menu_draft')
    Params: 1
    Run Time: 0.000174
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 4Using where
  16. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 294749, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:28:"VersusTheMoose, post: 294747";s:8:"original";a:2:{i:0;s:38:"[quote="VersusTheMoose, post: 294747"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:175:"I never said it was a clean hit, I said I agreed with he NHL that is wasn't worthy of a suspension. He was comparing it to a clean hit, so of course there will be differences.";}}i:1;s:1167:" I'm not saying Torres meant to injure Seabrook. He didn't leave his feet or lead with the elbow. But the problem is how the NHL explained their decision. The rule says the head cannot be the principle point of contact and in that case it was. But again, Campbell says in the release about the video of a defenseman and forward coming together face to face and deeming it legal. This wasn't the case in the Torres hit at all. He then said the rule was not intended for shoulder to head hits but yet in the video they issued to teams, there are 2 examples of shoulder to head hits that they deemed illegal. So basically the league referring to a play that was nowhere near similar outside of the area it occurred in doesn't validate their decision at all. And Campbel saying what the "intentions' of a rule were or were not leaves far too much room for an endless number of interpretations. And with that comes the convenient bailout loopholes for the NHL when they'd rather not make a tough call on an issue. I think Bob McKenzie said it best. The way the rule is writen, what is considered a legal hit and what is an illegal hit is more complex than ever.";}, 1466975802, 1469315101
    Run Time: 0.001034
  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, 294750, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:19:"JJP41, post: 294749";s:8:"original";a:2:{i:0;s:29:"[quote="JJP41, post: 294749"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:147:"I think Bob McKenzie said it best. The way the rule is writen, what is considered a legal hit and what is an illegal hit is more complex than ever.";}}i:1;s:304:" We can at least agree on that. I think Campbell was defensive because he knew his decision was going to be controversial and you can see it in his wording. I'm glad he is stepping down just because the league needs to start off fresh next year as they do more to eliminate headshots from the game.";}, 1466975802, 1469315101
    Run Time: 0.000926
  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, 294751, a:1:{i:0;s:226:"[ame=http://www.youtube.com/watch?v=nxLs-g9lPEc&feature=player_embedded]YouTube - ‪Michael Ryder Questionable Hit on Blair Jones - ECF Game #5 2011‬&rlm;[/ame] Didn't see this until today, not even a penalty called. :huh:";}, 1466975802, 1469315101
    Run Time: 0.005021
  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, 294752, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:28:"VersusTheMoose, post: 294750";s:8:"original";a:2:{i:0;s:38:"[quote="VersusTheMoose, post: 294750"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:299:"We can at least agree on that. I think Campbell was defensive because he knew his decision was going to be controversial and you can see it in his wording. I'm glad he is stepping down just because the league needs to start off fresh next year as they do more to eliminate headshots from the game.";}}i:1;s:296:" I don't know. The NHL went out of their way to publicly profess they would be cracking down on head hits but a lot of people wonder how serious they really are, obviously myself included. And I think we can both agree there is no consistency on their part when it comes to disciplining them.";}, 1466975802, 1469315101
    Run Time: 0.000888
  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, 294753, a:1:{i:0;s:233:"I think that video I just posted shows there is little consistency. I do think it is a tough job and no matter who is reviewing these hits and what rules they implement there will always be questionable hits people debate days after.";}, 1466975802, 1469315101
    Run Time: 0.001224
  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, 294754, a:1:{i:0;s:455:"8-1. 4-0. Getting closer! But seriously the Bruins are simply out classing the Canucks in all three zones. What shocks me is the fact they are getting beat at their own game. They are being out passed, and when the tempo ramps up they cannot keep up with the Bruins. Lu is letting everything in and the power play that is suppose to be their bread and butter has dried up. Obviously needs to turn around quick if they want a chance winning this series.";}, 1466975802, 1469315101
    Run Time: 0.000979
  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, 294755, a:1:{i:0;s:148:"Big win tonight, the Canucks were the better team tonight and deserved the win. Lu responded and had a huge night. ******' right Lappy. Go 'Nucks.";}, 1466975802, 1469315101
    Run Time: 0.000911
  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, 294756, a:1:{i:0;s:964:"Congrats Moose! You guys are one step closer! I watched that game closely, Canucks played well, they earned that shutout after the Bruins coming off of two high scoring games. That's hard to do. I want to say of the Bruins, they still have an incredibly good team! This series is not over yet. My heart is still telling me Canucks in game 6, possibly Bruins take them to OT in dramatic fashion, but looking at both these teams... Wow. Just wow. This is such an exciting series. No clearly established winner, both teams have shined with brilliance... just game after game of awesome hockey. As a hockey fan, I delight in a series such as this. I can say that a little easier because (sadly) my team isn't in it so I'm not having a meltdown right now over the series. But I think no matter if your team is in it or not, we all as hockey fans can appreciate this series. I'll be rather sad to see it end. Still, Canucks in game 6 take the Cup in OT. Sorry Bruins...";}, 1466975802, 1469315101
    Run Time: 0.000975
  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, 294757, a:1:{i:0;s:170:"5-2 but the Canucks put up a decent showing and the game was much closer than the score. All comes down to game 7 in Vancouver. Should be an interesting Wednesday night.";}, 1466975802, 1469315101
    Run Time: 0.000908
  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, 294758, a:1:{i:0;s:152:"Freakin game 7!!! I was so sure it would end last night too!!! These Bruins are tough, but so are the Canucks! This is gonna be epic on Wednesday night!";}, 1466975802, 1469315101
    Run Time: 0.001066
  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, 294759, a:2:{i:0;s:2172:"I can't stand so many players on the Canucks its not even funny. Their entire top line are some of the biggest whiners/divers I've ever seen. none of the antics they pull belong in this league. Burrows' actions all series have been bush league to say the least. The Canucks are just soft. They are getting pounded and are not responding in the slightest bit. Kesler got drilled in game 2 and has done nothing since. The Sedins get repeatedly beat on and do nothing in response. Burrows exaggerates every time hes touched and bites players. Moose, idk how you can say putting fingers near someones mouth and you should expect to be bitten. ABSOLUTELY NOT. there is something called a face wash in hockey and it happens every skirmish in every game. only dirty/douchey players would ever bite down on someones finger. the fact that he wasnt suspended for game 2 is a complete joke. Luongo is massively overrated. 15 goals allowed in 3 games. pulled for the 4th time, benched for a game against the Hawks. I find it hilarious the people that try and defend him. he is a meh goalie on a very above average team which he is trying his very best to lose this series for. Keep putting on those massive pads and dropping to your knees Luongo! Really shows off your athleticism. pffttt. Oh and not to mention runs his mouth after game 5 about how he would have stopped the goal Thomas let in, then proceeds to let in 3 softies in game 6. not only that but his justification for the comment was that he hasnt heard Thomas say anything nice about him, seriously Luongo, get over yourself. 18-7 lead in goals for the Bruins and they forced a game 7. three very close games in Canada and three blowouts in Boston. Almost impossible to predict who wins and it would be unheard of for a team to play so badly in a series on the road and still win. As much as i don't want it to happen i think VAN is gonna pull it out. We'll see though. Thomas has been consistent and solid. If Boston can bring their physical game to VAN then i could see them stealing the cup. oh and i would LOVE overtime. Now with the Sedins guaranteeing victory i hope even more for Boston to crush their dreams ";i:1;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:60:"http://img.photobucket.com/albums/v466/brg/MARCHYCOINS-1.gif";}}}, 1466975802, 1469315101
    Run Time: 0.001991
  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, 294760, a:1:{i:0;s:385:"If the Canucks are soft, if Lu is overrated, if Thomas is a brick wall, they should easily be able to beat the 'Nucks on their own ice Wednesday night, but yet you doubt it yourself. A face wash does not and never will involve fingers in the mouth of another player. I love that Daniel made the prediction, now he just has to man up and back it up with his play on Wednesday night.";}, 1466975802, 1469315101
    Run Time: 0.001295
  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, 294761, a:1:{i:0;s:241:"What I cannot believe is the team letting Thornton shoot a puck at Lu in the pregame skate, or how Daniel let Marchand use his head as a punching bag (with the ref starring right at them). That makes me nervous for game 7 more than anything.";}, 1466975802, 1469315101
    Run Time: 0.006042
  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, 294762, a:1:{i:0;s:299:"Sad to see Raymond is not able to play in game 7. Hope he is 100% for next season because if his hands ever catch up to his feet the Canucks have another star in the making. Hamhuis is a possibly, I doubt he will play and if he does I question how effective he will be but it is something positive.";}, 1466975802, 1469315101
    Run Time: 0.001093
  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, 294763, a:1:{i:0;s:1804:"all the things i've listed are most definitely true. why the Bruins didn't easily take care of this series comes down to simple logic. The Canucks are an incredibly deep and talented team and when at home, the Bruins have had extreme difficulty matching up with all this talent. Has Luongo played well at home? yes he most definitely has, but in each of those games how many really legit/strong scoring chances did the Bruins forwards create? not many memorable ones. Off the top of my head, the only time in VAN the Bruins generated good chances/offense was period 2 of game 2, and they scored 2 goals. Now when you switch the setting over to Boston, the forwards are flying, creating chances, and destroying Luongo. Why is this? they are the home team, getting the last change, getting the match ups they want. Its the same story for Vancouver in Boston as it is Boston in Vancouver, neither coach/team has been able to solve the match ups the home team presents. Which is why i am not confident in Boston winning a game 7, and why this series has gone 7 games. Which leads me to believe that if Boston can play the physical game that they had at home in Vancouver, they will greatly up their chances. They know that the games in Vancouver all could have gone their way which has to instill loads of confidence. if they can score on Luongo early it could get very ugly. Also, there is zero, zero, zero, zero, ways to justify Burrows' bite. Any form of justification is an excuse. what he did was dirty, and bush league. It does not belong in the NHL and Burrows is certainly establishing a poor reputation around the NHL. Saying Bergeron all but deserved it for putting his hand on his face is nothing short of a biased opinion, an opinion which you will find yourself among the vast vast minority.";}, 1466975802, 1469315101
    Run Time: 0.001361
  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, 294764, a:1:{i:0;s:463:"I agree with most of what you are saying in regards to Burrows but you simply do not stick your finger in the mouth of another man, period. Bergeron is at some fault in my mind, you are allowed to believe whatever you wish. Yes, the first goal is obviously important and whoever is a more physical team will have a huge edge, nothing Earth shattering there. The big question for me is does Lu have one more great game left? He better because I know Thomas does.";}, 1466975802, 1469315101
    Run Time: 0.001030
  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, 294765, a:1:{i:0;s:1415:"Game 7 tonight!!! I can't wait for it, you just know this is gonna be an intense game. I'm still pulling for the Canucks but the thing that worries me a little bit is the Bruins have been outscoring the Canucks.... by quite a bit. If the Bruins open up another 3 - 4 goal lead and the Canucks have no answer, I fear the Bruins may take this. The Canucks have a huge advantage with being at home though, so that evens things out a lot. Hopefully the Canucks can tighten down their goaltending, they simply cannot allow the Bruins to score that much on them. Moose, what on earth was going on with the goalies in those games? Do you think it was the fault of the goalies or a breakdown in D. A lot gets blamed on the goalies when in fact it has more to do with inadequate defense, inability to clear zone, .... I used to play goalie and there was nothing I loved more than a defenseman who did his job well, it made things a hell of a lot easier. I'm just trying to figure out what is going on with the Canucks here. I really think they should of had this series wrapped up at game 6. Whatever occurred during those high scoring games had led the Canucks to a game 7 and could land up costing them the Cup. I think the Canucks should win this game tonight, they are at home... if they can find a way to keep the Bruins out of their zone and out of their net. We know they are capable of doing it, just look to game 5!";}, 1466975802, 1469315101
    Run Time: 0.001218
  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, 294766, a:1:{i:0;s:1128:"It was both bad goal tending and the defense being caught napping for a good part of the three road game disasters. Lu let in goals he shouldn't have, no doubt, but the defense put him in a bad position a good portion of those those games. Lu is one of the best in the world when he is on his game (and he often is), but he is such an emotional player I have always thought that worked against him and his ability to be as consistent as other top guys. The keys to the game are simple to me, can Edler bounce and shut down guys in our zone while punishing bodies in the neutral zone? Will Lu be able to put game 6 out of his mind and play big in the biggest game of his life? And will the twins back up their words (because one speaks for the other) and play up to their talent? So many careers will fairly, or unfairly be defined by tonight's game. Not only that a cup would even legitimize the Canuck franchise and it would make sure the team would never leave the city of Vancouver. Personally it would mean June 15th, 2011 would be just as sweet a memory as February 6th, 2011 was. Nerves are already shot. Go 'Nucks.";}, 1466975802, 1469315101
    Run Time: 0.001092
  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, 294767, a:1:{i:0;s:1272:"well all but over tonight, 3-0 going into the 3rd. I wouldn't be posting if i wasn't confident in the score holding up. HILARIOUS that Sedin guarantees victory, and then is lazy and commits mental errors like taking care of your man off a face off leading to the first goal. Not to mention he and his brother are -3 in the game. Some blame towards Luongo on the first one, i feel like he was off his angle when the puck was passed into that cluster and eventually one-timed into the corner. Don't think he had much chance though. 2nd goal was pretty much all his fault, you can't let a point shot that you see clearly hit you in the chest and drop for a perfect rebound. 3rd goal was a weird play but gotta keep that puck in front of you! i really feel like those blowouts are taking their effect in this game. The Bruins all have their legs and are winning races to pucks. The Canucks look slow and tired. Clearly the ability to "rest" their players when they held massive leads are helping Boston tonight. Ultimately, its looking like Loluongo is choking in the biggest game of his career and all is right in the world! The team that has a massive lead on aggregate is proving they deserve it. Can't wait to hear about the destruction and riots in Vancouver tonight!";}, 1466975802, 1469315101
    Run Time: 0.001561
  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, 294768, a:1:{i:0;s:114:"The better team won the game and won the series, doesn't make it hurt any less. Maybe next year. Maybe. /Drunk.";}, 1466975802, 1469315101
    Run Time: 0.004009
  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, 294769, a:1:{i:0;s:1394:"Luongos inconsistencies, bruins physicality, and the Canucks injuries on D are the three main contributions to the Bruins cup wins. You could just feel and see that the Canucks were hurting that game, especially their defense. The Bruins forwards were first to pucks all night long and kept the hitting up, very impressive road game from them. The only player that deserves any credit from the Canucks tonight is Kesler. From the interview before puck drop you just knew he was gonna be in the game, and he seemed like the only one who was. The Sedins were a joke this series, only a couple points each and very few of those points had any significance. He should be ashamed of himself for predicting a win then contributing nothing all game (-4 on the night). I would flat out be embarrassed to have a teammate like Burrows. ALL SERIES he was exaggerating and diving and did again in the third period tonight. Even Pierre made mention of how the Bruins players were yelling at him to drop the act and end the game with some respect. All in all the Bruins have shocked lots of people in the hockey world. Many believed this was the Canucks series, but their lack of physicality was their downfall. Bruins quite literally beat them. Edit: As i expected in my earlier post, there are many, many, reports of violence and rioting in Vancouver. Some has resulted in serious injuries...ridiculous.";}, 1466975802, 1469315101
    Run Time: 0.001474
  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, 294770, a:1:{i:0;s:385:"Kesler was a beast, battling through whatever injury he had and still had a solid game and even had some jump. If the Sedins had the heart he did the series wouldn't have been close, HE has absolutely nothing to be ashamed of. Not happy about the Vancouver "fans" rioting in the streets, hopefully no one gets seriously hurt and the police take care of it and arrest anyone involved.";}, 1466975802, 1469315101
    Run Time: 0.001059
  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, 294771, a:1:{i:0;s:1444:"Congrats to the Bruins! That was an awesome series. I was pulling for the Canucks but after watching the first period, I knew that it was not to be. I can tell by the way the Canucks just seemed to be lagging and as JC said, injuries on D just took their toll. The Bruins were fierce on the attack and the Canucks, though outshooting the Bruins, had no answer. Boston has one hell of a goalie in Thompson, they have an incredible future with him. It was also nice, at least for me, to see former Flyer Mark Recchi finally get his Stanley Cup after such a long career. As for the Canucks, may they not hang there heads in shame but look to the future they have when they pull all they have together. Lu is already awesome, he will only improve with time. Kesler is just beyond awesome, I felt worse for him after the Bruins won it than all the other Canucks combined. His pure emotion just broke my heart. The Sedin twins can only hope to be the player that Kesler is now. If they ever do, beware of the Canucks! I really enjoyed that series, both teams should be proud of themselves for making the journey and being a part of it. I think that's one of the best series I've seen in a long time. It wasn't always pretty, bad hits, biting fingers.... but at least you can't say it wasn't interesting. Congrats again to the Bruins and fans as well as the Canucks and fans! They are both awesome teams and they both deserved to be in that series.";}, 1466975802, 1469315101
    Run Time: 0.000950
  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, 294772, a:1:{i:0;s:660:"Days after and I am still not sure how to feel. Anywho. Salo should be back and at a discount, I'll be happy to have the vet return for one more run. Bieksa sounds like he will stay, knowing he will be taking less money then he could get on the open market because he wants a cup and loves playing in Vancouver. Ehrhoff on the other hand could walk, but hopefully with the money they saved with Salo they might be able to get something done. The core is in place, and while they need and hopefully will add some grit this off season the team is set to make another deep run next year. Always next year. Thank God for the Packers and their new shiny rings.";}, 1466975802, 1469315101
    Run Time: 0.001164
  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, 294773, a:2:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:46:"http://tsn.ca/nhl/story/?id=370169#YourCallTop";s:8:"original";a:2:{i:0;s:52:"[url=http://tsn.ca/nhl/story/?id=370169#YourCallTop]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:46:"Bieksa signs five-year, $23M deal with Canucks";}}i:1;s:160:" Solid signing, he would have easily got 5.5-6+ as a free agent. Now to shove the same deal down Ehrhoff's throat or let him walk (preferably without the NTC).";}, 1466975802, 1469315101
    Run Time: 0.004282

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