Page Time: 0.8403s

Memory: 11.8440 MB (Peak: 13.2494 MB)

Queries (40, time: 0.0297s, 3.5%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000148
    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: 37404
    Run Time: 0.000445
    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.000287
    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 = 37404
    group by pivot_pr.post_id
    ) pr on (pr.post_id = post.post_id)
    
    
    WHERE post.thread_id = ?
    	 AND (post.position >= 1025 AND post.position < 1050) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 37404
    Run Time: 0.012206
    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   223 
    PRIMARYpr2eq_refpost_id_user_id,post_id_rating,user_id_ratingpost_id_user_id8packerfo_maindb.post.post_id,const1 
    PRIMARY<derived5>ALL    513 
    DERIVEDpivot_postrefPRIMARY,thread_id_post_date,thread_id_positionthread_id_position4 2554Using 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: 37404
    Run Time: 0.000142
  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.000735
  7. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 37404
    Run Time: 0.002510
  8. SELECT thread.*
    	
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 37404
    Run Time: 0.000331
    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: 10
    Run Time: 0.000321
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  10. SELECT *
    FROM xf_ignore_thread
    WHERE user_id = ?
    	AND thread_id = ?
    Params: 0, 37404
    Run Time: 0.000114
    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.000227
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityALLPRIMARY   223Using 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=37404&page=42, 1408552337,
    Run Time: 0.000122
  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.000104
    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, 510053, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"PackerFan71, post: 509991, member: 6273";s:8:"original";a:2:{i:0;s:49:"[quote="PackerFan71, post: 509991, member: 6273"]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;s:320:"In all honesty i have no issues with FCB they are doing what they do, good luck to them. However this guy takes the biscuit. ''Mourinho talks too much? '' why shouldn't he? he's done nothing wrong unlike this clown. How he is still able to give interviews is an embarrassment to the whole judiciary in Germany. :mad: ";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[media=youtube]";i:1;s:8:"[/media]";}s:8:"children";a:1:{i:0;s:11:"TxTLUJCqPYo";}}}}i:1;s:211:" I still think Mourinho was right. Bayern is going to get their backsides handed to them on a platter today by Chelsea. This IS NOT Jupp's team anymore. I'm still waiting to see the supposed "Guardiola Genius".";}, 1406210135, 1408552337
    Run Time: 0.000677
  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, 510054, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"PackerFan71, post: 510035, member: 6273";s:8:"original";a:2:{i:0;s:49:"[quote="PackerFan71, post: 510035, member: 6273"]";i:1;s:8:"[/quote]";}s:8:"children";a:6:{i:0;s:87:"It surprised me that FCB still have such an individual as him, there's loyalty and then";i:1;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:23:" there's being a crook.";}}i:2;s:117:" :rolleyes: Ha no i got a Q on the webby i found it on what he said on the clip. Id still like to learn though. :) ";i:3;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:24:"Actions speak louder. ;)";}}i:4;s:1:" ";i:5;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:35:"http://www.gifti.me/i/z4jsFUdfW.gif";}}}}i:1;s:470:" Indeed, but many people still think tax evasion is a trivial offence. :rolleyes: I guess thats why he still can do his job at Bayern but as soon as he would find guilty and sentenced to prison or a heavy fine they will get rid of him. Some partners like Audi had already demanded his demission but didnt find a mayority in the supervisory board . Yeah, lets see what happens tonight, I hope for an exciting game :) I havent checked yet if aired on TV..... :confused:";}, 1406210135, 1408552337
    Run Time: 0.000509
  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, 510064, a:1:{i:0;s:267:"I just hope its a decent game whatever the result. If i'm honest though id prefer we had time off instead for league preparation etc. :rolleyes: Edit : what do you know its on TV here, ill watch a little bit of it no and doubt then get bored very quickly. :whistling:";}, 1406210135, 1408552337
    Run Time: 0.000467
  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, 510082, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"PackerFan71, post: 510064, member: 6273";s:8:"original";a:2:{i:0;s:49:"[quote="PackerFan71, post: 510064, member: 6273"]";i:1;s:8:"[/quote]";}s:8:"children";a:5:{i:0;s:71:"I just hope its a decent game whatever the result. If i'm honest though";i:1;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:1:" ";}}i:2;s:80:"id prefer we had time off instead for league preparation etc. :rolleyes: Edit : ";i:3;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:32:"what do you know its on TV here,";}}i:4;s:83:" ill watch a little bit of it no and doubt then get bored very quickly. :whistling:";}}i:1;s:146:" Here on Free TV as well. :eek: I think I'll give it a try , at least for a few minutes though its more a friendly than a real Championship match.";}, 1406210135, 1408552337
    Run Time: 0.000524
  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, 510083, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"mhnessie, post: 510082, member: 4324";s:8:"original";a:2:{i:0;s:46:"[quote="mhnessie, post: 510082, member: 4324"]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;s:94:"Here on Free TV as well. :eek: I think I'll give it a try , at least for a few minutes though ";i:1;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:51:"its more a friendly than a real Championship match.";}}}}i:1;s:70:" Bottom line thats all it is, i'm only really worried about injuries.";}, 1406210135, 1408552337
    Run Time: 0.000421
  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, 510085, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Croak, post: 510053, member: 2367";s:8:"original";a:2:{i:0;s:43:"[quote="Croak, post: 510053, member: 2367"]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;s:152:"I still think Mourinho was right. Bayern is going to get their backsides handed to them on a platter today by Chelsea. This IS NOT Jupp's team anymore. ";i:1;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:57:"I'm still waiting to see the supposed "Guardiola Genius".";}}}}i:1;s:187:" As I wrote before - I wouldnt be surprised if Pep fails but Im of the opinion that its too early to evaluate his performance. Be patient, Croak - Im sure things will get better soon. ;)";}, 1406210135, 1408552337
    Run Time: 0.000419
  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, 510095, a:1:{i:0;s:35:"Why the heck is Rafinha starting???";}, 1406210135, 1408552337
    Run Time: 0.000412
  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, 510100, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Croak, post: 510095, member: 2367";s:8:"original";a:2:{i:0;s:43:"[quote="Croak, post: 510095, member: 2367"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:35:"Why the heck is Rafinha starting???";}}i:1;s:48:" Who would you start instead, Croak ? Contento ?";}, 1406210135, 1408552337
    Run Time: 0.000432
  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, 510103, a:1:{i:0;s:33:"Wow - nice, 1-0 Chelsea. Torres !";}, 1406210135, 1408552337
    Run Time: 0.000445
  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, 510106, a:1:{i:0;s:39:"Are Schweini and Martinez both injured?";}, 1406210135, 1408552337
    Run Time: 0.000442
  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, 510108, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Croak, post: 510106, member: 2367";s:8:"original";a:2:{i:0;s:43:"[quote="Croak, post: 510106, member: 2367"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:39:"Are Schweini and Martinez both injured?";}}i:1;s:51:" Nope....Schweini is injured, Martinez on the bench";}, 1406210135, 1408552337
    Run Time: 0.000448
  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, 510112, a:1:{i:0;s:368:"Rafinha is a fine backup, but I don't think he's up to starting level. I think giving Pep this team was like putting Michael Schumacher in the turret of a Panzerkampfwagen and telling him to make it perform like a Ferrarri. I also think Gomez' size would have been helpful against a guy like Luiz. Mandzukic is good at crying but he can't out muscle someone like Luiz.";}, 1406210135, 1408552337
    Run Time: 0.000453
  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, 510113, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"mhnessie, post: 510108, member: 4324";s:8:"original";a:2:{i:0;s:46:"[quote="mhnessie, post: 510108, member: 4324"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:50:"Nope....Schweini is injured, Martinez on the bench";}}i:1;s:62:" 40 Million Euro is a lot to pay someone to sit on the bench.";}, 1406210135, 1408552337
    Run Time: 0.000390
  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, 510129, a:1:{i:0;s:158:"Omg i only watched the first 5 mins of this and they are still playing?! hurry up Munchen get it over and done with we are down to ten men!!!!!:eek::rolleyes:";}, 1406210135, 1408552337
    Run Time: 0.000414
  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, 510137, a:1:{i:0;s:157:"Aww sheesh. I've got mixed emotions. I'm glad Bayern won ugly, but I feel bad for Lukaku. I always feel bad for the guy that has to be the goat in penalties.";}, 1406210135, 1408552337
    Run Time: 0.000455
  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, 510138, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Croak, post: 510137, member: 2367";s:8:"original";a:2:{i:0;s:43:"[quote="Croak, post: 510137, member: 2367"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:157:"Aww sheesh. I've got mixed emotions. I'm glad Bayern won ugly, but I feel bad for Lukaku. I always feel bad for the guy that has to be the goat in penalties.";}}i:1;s:214:" Hehe just watched 5 at beginning and the last 15. Utter indifference on my part im afraid. :) nothing wrong with winning ugly. But you have an unfair advantage in that department with Ribery on your team. :laugh:";}, 1406210135, 1408552337
    Run Time: 0.000443
  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, 510153, a:3:{i:0;s:123:"I should be the coach at Bayern. ;) Look who was listed at the "flop of the match" and the "top of the match" for Bayern. ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:77:"http://www.goal.com/en-us/match/108413/bayern-vs-chelsea/lineup-stats?ICID=OP";}}i:2;s:230:" And I gotta give big :tup: to Cech. He was a beast in goal or this match might never have been close. And 7 yellow cards on Chelsea. One article wrote that is normal for a Mourinho team against a Guardiola team. Is this true?";}, 1406210135, 1408552337
    Run Time: 0.000451
  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, 510156, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Croak, post: 510153, member: 2367";s:8:"original";a:2:{i:0;s:43:"[quote="Croak, post: 510153, member: 2367"]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;s:123:"I should be the coach at Bayern. ;) Look who was listed at the "flop of the match" and the "top of the match" for Bayern. ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:77:"http://www.goal.com/en-us/match/108413/bayern-vs-chelsea/lineup-stats?ICID=OP";}}i:2;s:228:" And I gotta give big :tup: to Cech. He was a beast in goal or this match might never have been close. And 7 yellow cards on Chelsea. One article wrote that is normal for a Mourinho team against a Guardiola team. Is this true?";}}i:1;s:585:" I don't really get the Ribery hype he's ok but hes no Falcao. I'm quite pleased with the way things are going at Chelsea, yeah ok we lost in tonights little kickabout but things are on the up now for us. The Champions League is where its at, looking forward to it. Cech is the best keeper we have had his record speaks for itself. They say they like each other on a professional level but in game there is no quarter or love lost. Its a Barca v Madrid thing. Guardiolas got a little bit to do to turn FCB into Barca MKII. Not going to happen is it? pragmatism will overrule fantasy.";}, 1406210135, 1408552337
    Run Time: 0.000430
  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, 510159, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"PackerFan71, post: 510156, member: 6273";s:8:"original";a:2:{i:0;s:49:"[quote="PackerFan71, post: 510156, member: 6273"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:583:"I don't really get the Ribery hype he's ok but hes no Falcao. I'm quite pleased with the way things are going at Chelsea, yeah ok we lost in tonights little kickabout but things are on the up now for us. The Champions League is where its at, looking forward to it. Cech is the best keeper we have had his record speaks for itself. They say they like each other on a professional level but in game there is no quarter or love lost. Its a Barca v Madrid thing. Guardiolas got a little bit to do to turn FCB into Barca MKII. Not going to happen is it? pragmatism will overrule fantasy.";}}i:1;s:178:" Ribery is good but I think his team makes him that way. Whereas guys like Messi make his team good. See the difference? Sent from my Kindle Fire using Xparent Green Tapatalk 2";}, 1406210135, 1408552337
    Run Time: 0.000549
  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, 510163, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Croak, post: 510159, member: 2367";s:8:"original";a:2:{i:0;s:43:"[quote="Croak, post: 510159, member: 2367"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:176:"Ribery is good but I think his team makes him that way. Whereas guys like Messi make his team good. See the difference? Sent from my Kindle Fire using Xparent Green Tapatalk 2";}}i:1;s:100:" Messi and Ribery? theres no comparison between them, one is a Worker Drone the other is an Artist.";}, 1406210135, 1408552337
    Run Time: 0.000426
  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, 510189, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"PackerFan71, post: 510163, member: 6273";s:8:"original";a:2:{i:0;s:49:"[quote="PackerFan71, post: 510163, member: 6273"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:98:"Messi and Ribery? theres no comparison between them, one is a Worker Drone the other is an Artist.";}}i:1;s:379:" No argument here. I wonder if Ribery would be the same playing for a team like say....Freiburg? When you have Mueller, Robben, Schweinsteiger, Kroos and company working with you it has to make your job easier. Ribery is a scrapper who occasionally takes the bullet shot, but often is the beneficiary of a good feeder. Messi, he can dazzle an opponent and strike with lightning.";}, 1406210135, 1408552337
    Run Time: 0.000487
  36. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('online')
    Params: 1
    Run Time: 0.000159
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY106const,const1 
  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, 510192, a:1:{i:0;s:522:"There are European Soccer Forums dedicated to soccer. Football is a game played in the USA. Soccer in America ranks somewhere between girls Field Hockey and Shuffleboard. Why does this thread persist in an American Football Forum. Are you just using it as a more or less place to post about soccer conversations away from the crowded European Soccer Forums. I really don't mind you're using an American Football Forum to talk about European Soccer, I just wonder why do you come to a Football Forum to discuss soccer ?";}, 1406210135, 1408552337
    Run Time: 0.000459
  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, 510203, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"Smokeychedder, post: 510192, member: 6672";s:8:"original";a:2:{i:0;s:51:"[quote="Smokeychedder, post: 510192, member: 6672"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:522:"There are European Soccer Forums dedicated to soccer. Football is a game played in the USA. Soccer in America ranks somewhere between girls Field Hockey and Shuffleboard. Why does this thread persist in an American Football Forum. Are you just using it as a more or less place to post about soccer conversations away from the crowded European Soccer Forums. I really don't mind you're using an American Football Forum to talk about European Soccer, I just wonder why do you come to a Football Forum to discuss soccer ?";}}i:1;s:155:" You and I just recently talked about music......on a football forum ? Its just another thread on the forum. I say this in a friendly way to you because ";i:2;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:3:"you";}}i:3;s:213:" seem a decent guy okay ? I cant understand why people come over to a thread they are not interested in. There are more sports in the world than American Football, and all these guys are Packer fans too mate :tup:";}, 1406210135, 1408552337
    Run Time: 0.000511
  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, 510204, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:41:"Smokeychedder, post: 510192, member: 6672";s:8:"original";a:2:{i:0;s:51:"[quote="Smokeychedder, post: 510192, member: 6672"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:522:"There are European Soccer Forums dedicated to soccer. Football is a game played in the USA. Soccer in America ranks somewhere between girls Field Hockey and Shuffleboard. Why does this thread persist in an American Football Forum. Are you just using it as a more or less place to post about soccer conversations away from the crowded European Soccer Forums. I really don't mind you're using an American Football Forum to talk about European Soccer, I just wonder why do you come to a Football Forum to discuss soccer ?";}}i:1;s:211:" We are all Packer Fans we can talk about anything we like, are you suggesting that we censor ourselves just because we like something that you don't? Its not the first time you have posted something like this.";}, 1406210135, 1408552337
    Run Time: 0.000533
  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, 510210, a:1:{i:0;s:490:"I couldnt have said it any better than Bill or PackerFan71. ;) Indeed we are all Packer Fans and football/soccer is just another interest we share beside beeing die-hard Packer fans. So following your thoughts and reasoning, Smokey, means we had to shut down all topics and subforums that arent related to football. Wouldnt it be boring ? ;) And dont forget - there is a world outside the US, soccer is called football outside your country and arguably the most popular sport worldwide :p;)";}, 1406210135, 1408552337
    Run Time: 0.000550

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. library/XenForo/ViewPublic/Helper/User.php
  166. library/XenForo/Model/UserField.php
  167. internal_data/templates/S.7,L.1,bb_code_tag_quote.php
  168. internal_data/templates/S.7,L.1,dark_postrating.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