Page Time: 0.6099s

Memory: 11.0759 MB (Peak: 12.3122 MB)

Queries (31, time: 0.0296s, 4.9%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000161
    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: 3766
    Run Time: 0.000605
    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: 22
    Run Time: 0.000294
    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 = 3766
    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: 3766
    Run Time: 0.003785
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARY<derived5>system    0const row not found
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 16Using 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   284 
    PRIMARYpr2eq_refpost_id_user_id,post_id_rating,user_id_ratingpost_id_user_id8packerfo_maindb.post.post_id,const1 
    DERIVEDpivot_postrefPRIMARY,thread_id_post_date,thread_id_positionthread_id_post_date4 17Using 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: 3766
    Run Time: 0.000225
  6. UPDATE xf_session_activity
    SET xf_session_activity.view_count = xf_session_activity.view_count + 1
    WHERE ip = ? AND user_id = 0
    Params: 6¦”½
    Run Time: 0.000449
  7. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 3766
    Run Time: 0.000465
  8. SELECT thread.*
    	
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 3766
    Run Time: 0.000406
    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: 22
    Run Time: 0.000306
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  10. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 3766
    Run Time: 0.000241
    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: 6¦”½
    Run Time: 0.000242
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityALLPRIMARY   284Using 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, 6¦”½, 6¦”½, XenForo_ControllerPublic_Thread, Index, valid, thread_id=3766, 1409415122,
    Run Time: 0.000150
  13. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('Tickets', 'Schedule', 'Draft')
    Params: 1
    Run Time: 0.000143
    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.000129
    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, 49184, a:2:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:44:"http://story.scout.com/a.z?s=61&p=2&c=502864";s:8:"original";a:2:{i:0;s:52:"[url="http://story.scout.com/a.z?s=61&p=2&c=502864"]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:44:"http://story.scout.com/a.z?s=61&p=2&c=502864";}}i:1;s:1696:" Breaking News: Agreement on CBA on the Way? By TFY Draft Preview Date: Feb 25, 2006 Breaking news about the CBA and the 2006 salary cap! An NFL source has told Scout.com that the 2006 salary cap will be announced on Monday, February 27. 2006's cap, according to this source, will be $95 million. This is on the high end of what was expected - most estimates were anywhere from $92 to $95 million. Atlanta Falcons GM Rich McKay, who co-chairs the Competition Committee and has long been a major player in league matters, talked to the media on Saturday about the possible extension to the Collective Bargaining Agreement that would greatly affect how cap money is spent. McKay said that the teams remain hopeful that there will be an extension, despite Player’s Association head Gene Upshaw's recent comments that agents should negotiate as if there will be no extension. McKay also said that without a new deal, the March 3 free agency deadline will not be pushed back. McKay said that it would be "extremely difficult" to operate without an extension. Without a cap, McKay said that the "tricks of the trade" will all drop into this year's cap, affecting cap room. Contracts would only be able to be four years long and he thinks trades will be less likely because of accelerated bonuses. He also expects free agency would be slower. But in late-breaking news on this matter, Seahawks.NET has been informed by our Scout.com source at the Combine that members of one NFL organization are telling their staff that there is a very strong chance that the CBA will be extended by the deadline. Significant recent progress has been made, according to our source.";}, 1406210135, 1409415122
    Run Time: 0.002667
  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, 49185, a:1:{i:0;s:77:"Even if it doesn't get done, its not going to be as horrendous as many think.";}, 1406210135, 1409415122
    Run Time: 0.000658
  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, 49186, a:1:{i:0;s:79:"Well as long as ther is no strike or anything crazy like that I should be happy";}, 1406210135, 1409415122
    Run Time: 0.000588
  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, 49187, a:1:{i:0;s:72:"If the salary cap ends, then so does the Green Bay Packers Organization.";}, 1406210135, 1409415122
    Run Time: 0.000579
  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, 49188, a:1:{i:0;s:83:"If salary cap ends oh my god i think i might die Do u think that could happen?";}, 1406210135, 1409415122
    Run Time: 0.000637
  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, 49189, a:1:{i:0;s:620:"I don't think they would let it happen Gopack.........too many teams would suffer. And if there is NO chance for any team but the "rich" ones to win the super bowl, the NFL would die. And NO team wants that. So i think it will all get done. Back in the 1970's and earlier, it didn't matter as much how rich you were, cause the salarys of the players were not so rediculous. You could keep a good team together for years, cause no one would pay insane amounts of cash to lure players away. Now, if you are on a super bowl team, everyone wants to "buy" you onto your team. It makes it REALLY hard to remain a winning team.";}, 1406210135, 1409415122
    Run Time: 0.002684
  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, 49190, a:1:{i:0;s:717:"With taxpayers footing the bill for many of the new stadiums why should the players at this point think that they should get the extra revenue generated from taxpayer investment. They put none of their capital into it they now want to extract revenue from investments they did not make. Those who invested(the taxpayers) should reap any benefit. Any team "needing" a new stadium like the Vikings and 49'ers now really don't know what to build. The Colts have plans based on old system and could be building a stadium for the wrong agreement. The Cardinals just built one based on the old rules. At least for now the Packer Pro Shop and Fanfest money won't be shared with the low revenue Vikings.";}, 1406210135, 1409415122
    Run Time: 0.000553
  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, 49191, a:1:{i:0;s:84:"They couldn't make an agreement today, but the deadline has been extended to Sunday.";}, 1406210135, 1409415122
    Run Time: 0.000536
  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, 49192, a:1:{i:0;s:65:"I hate this I want free agency to strat to see what the pack does";}, 1406210135, 1409415122
    Run Time: 0.000561
  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, 49193, a:1:{i:0;s:20:"I can't wait either!";}, 1406210135, 1409415122
    Run Time: 0.006135
  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, 49194, a:1:{i:0;s:96:"but i dont care that much because only 7 days until i go to heavan aka lambeau field for fanfest";}, 1406210135, 1409415122
    Run Time: 0.000565
  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, 49195, a:1:{i:0;s:240:"Yup Gopack!!! I will be there too! You will have to watch for me. I have LONG blonde hair, and now sport a mostly grey beard. I will probably wear either my GOLD Packer jersey, or my Fan Fest shirt. If you see me, come on up and say HELLO!";}, 1406210135, 1409415122
    Run Time: 0.000604
  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, 49196, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:7:"cheesey";s:8:"original";a:2:{i:0;s:15:"[quote=cheesey]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:620:"I don't think they would let it happen Gopack.........too many teams would suffer. And if there is NO chance for any team but the "rich" ones to win the super bowl, the NFL would die. And NO team wants that. So i think it will all get done. Back in the 1970's and earlier, it didn't matter as much how rich you were, cause the salarys of the players were not so rediculous. You could keep a good team together for years, cause no one would pay insane amounts of cash to lure players away. Now, if you are on a super bowl team, everyone wants to "buy" you onto your team. It makes it REALLY hard to remain a winning team.";}}i:1;s:455:" You hit it right on the head cheesey. Back in the good old days the owners were rich but not filthy rich like some owners are now nor were they as foolish as some of these guys now. There a re a select few that have more money than they know what to do with and want to live vicariously through the best players they can buy. The old type owners like Rooney, Mara and Halas were football people that didn't believe in just throwing money around.";}, 1406210135, 1409415122
    Run Time: 0.002388
  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, 49197, a:1:{i:0;s:143:"lol and that's why they hated the AFL in those days, as Vince Lombardi said he had to pay guys more than he wanted because of the stinkin' AFL!";}, 1406210135, 1409415122
    Run Time: 0.000622
  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, 49198, a:1:{i:0;s:40:"I heard they broke off talks again today";}, 1406210135, 1409415122
    Run Time: 0.001142
  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, 49199, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:9:"yooperfan";s:8:"original";a:2:{i:0;s:17:"[quote=yooperfan]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:7:"cheesey";s:8:"original";a:2:{i:0;s:15:"[quote=cheesey]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:620:"I don't think they would let it happen Gopack.........too many teams would suffer. And if there is NO chance for any team but the "rich" ones to win the super bowl, the NFL would die. And NO team wants that. So i think it will all get done. Back in the 1970's and earlier, it didn't matter as much how rich you were, cause the salarys of the players were not so rediculous. You could keep a good team together for years, cause no one would pay insane amounts of cash to lure players away. Now, if you are on a super bowl team, everyone wants to "buy" you onto your team. It makes it REALLY hard to remain a winning team.";}}i:1;s:449:" You hit it right on the head cheesey. Back in the good old days the owners were rich but not filthy rich like some owners are now nor were they as foolish as some of these guys now. There a re a select few that have more money than they know what to do with and want to live vicariously through the best players they can buy. The old type owners like Rooney, Mara and Halas were football people that didn't believe in just throwing money around.";}}i:1;s:285:" HOW TRUE Yooper! Guys like Jones of the Cowboys, and Daniel Snyder of Washington try to BUY Super Bowls. They would push out the small market guys (like us) without a cap. If it doesn't get done, the players AND owners are slitting their own throats. I hope they arn't THAT stupid.";}, 1406210135, 1409415122
    Run Time: 0.000572
  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, 49200, a:1:{i:0;s:125:"I'd hate that to happen. The way it is today, every team has a chance, and the season harbors surprises so does the playoffs.";}, 1406210135, 1409415122
    Run Time: 0.000531

Included Files (170, XenForo Classes: 64)

  1. index.php
  2. library/XenForo/Autoloader.php
  3. library/XenForo/Application.php
  4. library/Zend/Registry.php
  5. library/Lgpl/utf8.php
  6. library/Zend/Config.php
  7. library/config.php
  8. library/XenForo/FrontController.php
  9. library/XenForo/Dependencies/Public.php
  10. library/XenForo/Dependencies/Abstract.php
  11. library/Zend/Controller/Request/Http.php
  12. library/Zend/Controller/Request/Abstract.php
  13. library/Zend/Uri.php
  14. library/Zend/Controller/Response/Http.php
  15. library/Zend/Controller/Response/Abstract.php
  16. library/XenForo/Model/DataRegistry.php
  17. library/XenForo/Model.php
  18. library/Zend/Cache.php
  19. library/Zend/Cache/Backend/Memcached.php
  20. library/Zend/Cache/Backend/ExtendedInterface.php
  21. library/Zend/Cache/Backend/Interface.php
  22. library/Zend/Cache/Backend.php
  23. library/Zend/Cache/Core.php
  24. library/XenForo/CodeEvent.php
  25. library/XenForo/Options.php
  26. library/XenForo/Link.php
  27. library/XenForo/Template/Helper/Core.php
  28. library/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/Model/Post.php
  111. library/Asp/OnlineStatus/Model/AspPost.php
  112. library/EWRporta/Model/Post.php
  113. library/Dark/PostRating/Model/Post.php
  114. library/sonnbThreadMassActions/Model/Post.php
  115. library/Nobita/LimitGuestThreadPageView/Engine.php
  116. library/XenForo/Model/Attachment.php
  117. library/EWRporta/Model/Attachment.php
  118. library/XenForo/Model/Node.php
  119. library/Nobita/IgnoreThread/Model/Node.php
  120. library/XenForo/Route/Prefix/Categories.php
  121. library/XenForo/Route/Prefix/Forums.php
  122. library/XenForo/ControllerResponse/View.php
  123. library/XenForo/ControllerResponse/Abstract.php
  124. library/Nobita/IgnoreThread/Model/IgnoreThread.php
  125. library/XenForo/Helper/Cookie.php
  126. library/XenForo/ViewRenderer/HtmlPublic.php
  127. library/XenForo/ViewRenderer/Abstract.php
  128. library/XenForo/Template/Public.php
  129. library/XenForo/Template/Abstract.php
  130. library/XenForo/ViewPublic/Thread/View.php
  131. library/XenForo/ViewPublic/Base.php
  132. library/XenForo/View.php
  133. library/EWRporta/Listener/ViewPublic.php
  134. library/EWRporta/ViewPublic/Custom.php
  135. library/XenForo/BbCode/Parser.php
  136. library/XenForo/BbCode/Formatter/Base.php
  137. library/EWRporta/Listener/BbCode.php
  138. library/EWRporta/BbCode/Formatter.php
  139. library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
  140. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
  141. library/XenForo/ViewPublic/Helper/Message.php
  142. library/XenForo/BbCode/TextWrapper.php
  143. library/WhoHasVisited/Listener.php
  144. library/Waindigo/JoinUserGroup/Listener/TemplateCreate.php
  145. library/XenForo/Route/Prefix/Members.php
  146. library/bdTagMe/XenForo/Route/Prefix/Members.php
  147. library/EWRporta/Listener/NavTabs.php
  148. library/ExternalPages/Listeners/Navigation.php
  149. library/ExternalPages/Route/Prefix/En.php
  150. library/Dark/TaigaChat/EventListener/NavigationTabs.php
  151. library/XenForo/Template/FileHandler.php
  152. library/XenForo/Helper/File.php
  153. internal_data/templates/S.7,L.1,thread_view.php
  154. library/SeparateStickyAndNormal/Listener.php
  155. library/EWRporta/Listener/Template.php
  156. library/EWRporta/Model/Promotes.php
  157. library/Waindigo/JoinUserGroup/Listener/TemplateHook.php
  158. internal_data/templates/S.7,L.1,ignore_thread_tool.php
  159. library/XenForo/Route/Prefix/Posts.php
  160. library/XenForo/Model/Avatar.php
  161. internal_data/templates/S.7,L.1,RT_UserOnlineRibbon.php
  162. internal_data/templates/S.7,L.1,dark_postrating_message_user_info.php
  163. library/XenForo/ViewPublic/Helper/User.php
  164. internal_data/templates/S.7,L.1,dark_postrating.php
  165. library/XenForo/Model/UserField.php
  166. internal_data/templates/S.7,L.1,bb_code_tag_quote.php
  167. library/XenForo/Helper/Criteria.php
  168. library/XenForo/Debug.php
  169. internal_data/templates/S.7,L.1,PAGE_CONTAINER.php
  170. library/XenForo/ViewRenderer/Json.php