Page Time: 0.1180s

Memory: 6.4764 MB (Peak: 7.1438 MB)

Queries (37, time: 0.0183s, 15.5%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000184
    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: 37404
    Run Time: 0.000621
    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.000418
    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.*,
    		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)
    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: 37404
    Run Time: 0.005132
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 27Using 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_activityrefPRIMARYPRIMARY4packerfo_maindb.post.user_id11 
    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
  5. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 37404
    Run Time: 0.000164
  6. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 37404
    Run Time: 0.000710
  7. UPDATE xf_thread SET hot_count = hot_count + 1 WHERE thread_id = 37404
    Run Time: 0.000220
  8. SELECT thread.*
    	,
    		0 AS thread_reply_banned
    FROM xf_thread AS thread
    
    WHERE thread.thread_id = ?
    Params: 37404
    Run Time: 0.000271
    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.000256
    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.000120
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_ignore_threadrefuser_threaduser_thread8const,const1 
  11. 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=37404&page=7, 1425627080,
    Run Time: 0.000166
  12. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('Tickets', 'Schedule', 'Draft')
    Params: 1
    Run Time: 0.000101
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 3Using where
  13. 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, 470655, a:1:{i:0;s:268:"I work as a dispatcher at the alarm room in Kaiserslautern. So I often get in touch with the ramstein tower.... Me and the other guy were corresponding in English. Medical Issues!!!! AFTER the complete call he asked me if I could speak some german.... Funny laugh too.";}, 1425574816, 1425627080
    Run Time: 0.000495
  14. 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, 470739, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:42:"Mighty Mike 77, post: 470638, member: 5968";s:8:"original";a:2:{i:0;s:52:"[quote="Mighty Mike 77, post: 470638, member: 5968"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:256:"They do play that system since 2 very successful years. You give up the fourth guy to fill the gaps in midfield, and you got an additional guy for the attack. It's very aggressive, and carrys some risk, as you've seen. You are wide open to fast attacks....";}}i:1;s:477:" Hey Mike, sorry, but usually BVB plays with 4 players on the back line. (Schmelzer, Subotic, Hummels, Pisczek) As you described it - they gave up the fourth guy to fill the gaps in the midfield and to create more midfield support for the offense but this was indeed the first time they played a 3-4-3. It didn't work and that's why Klopp changed back to the original back line after 30 minutes. Interested in more football tactics ? Then this article could be worth a look ;) ";i:2;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:109:"http://bundesligafanatic.com/borussia-dortmund-1-2-schalke-klopps-tactical-experiment-backfires-on-derby-day/";}}i:3;s:158:" Anyway, I am still mad about the fact that HSV could have signed Klopp, he signed with Dortmund instead and we all know what happenend since then. :rolleyes:";}, 1425574816, 1425627080
    Run Time: 0.000321
  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, 470762, a:1:{i:0;s:226:"I don't think so... In fact, I believe they switched from 4 to 3 defenders once in a while but not for the complete game, depending on the opponent and the game.... I think it's fishing for alibis because of the rivalry loss.";}, 1425574816, 1425627080
    Run Time: 0.000284
  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, 471223, a:1:{i:0;s:96:"Should be an easy match for Hamburg. Watching it now. Sent from my Kindle Fire using Tapatalk 2";}, 1425574816, 1425627080
    Run Time: 0.000298
  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, 471242, a:1:{i:0;s:193:"Nessie; Hamburg had a good win today. Adler looked good. Vandervaart didn't do much, but he didn't have to with the way Augsburg played. Augsburg seems afraid to finish...not much of an attack.";}, 1425574816, 1425627080
    Run Time: 0.000341
  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, 471244, a:1:{i:0;s:506:"Hey Croak, just checked the result a few minutes ago and I must admit that I was a little afraid that they would lose again. I will read the match report later on kicker website and maybe I can find a video on youtube. So it looks like you are enjoying watching Bundesliga? ;) I just returned from Lambeau Field, watched the players coming back from the practice field, took some nice pictures. I will post some of them later. @PackerFan71- I will post them in our --more or less- "private" EPL thread ;)";}, 1425574816, 1425627080
    Run Time: 0.000342
  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, 471246, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"mhnessie, post: 471244, member: 4324";s:8:"original";a:2:{i:0;s:46:"[quote="mhnessie, post: 471244, member: 4324"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:506:"Hey Croak, just checked the result a few minutes ago and I must admit that I was a little afraid that they would lose again. I will read the match report later on kicker website and maybe I can find a video on youtube. So it looks like you are enjoying watching Bundesliga? ;) I just returned from Lambeau Field, watched the players coming back from the practice field, took some nice pictures. I will post some of them later. @PackerFan71- I will post them in our --more or less- "private" EPL thread ;)";}}i:1;s:248:" Yeah, I'm enjoying watching these games. I also watch Bundesliga Magazine and Hallo Bundesliga. Lambeau is the best and most unique NFL experience that you will ever find. I hope you enjoy it immensely. Sent from my Kindle Fire using Tapatalk 2";}, 1425574816, 1425627080
    Run Time: 0.000342
  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, 471342, a:1:{i:0;s:117:"Nessie, you picked a heck of a weekend, weather wise, to visit the States. Sent from my Kindle Fire using Tapatalk 2";}, 1425574816, 1425627080
    Run Time: 0.000329
  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, 471345, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Croak, post: 471342, member: 2367";s:8:"original";a:2:{i:0;s:43:"[quote="Croak, post: 471342, member: 2367"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:118:"Nessie, you picked a heck of a weekend, weather wise, to visit the States. Sent from my Kindle Fire using Tapatalk 2";}}i:1;s:531:" Yepp, that's true, very sunny - could have been worse ;) Did you check the fixtures for next weekend, Croak ? Hamburg plays Bayern on Saturday. :sneaky: I will be back in Germany but unfortunately can't go to the game because the newborn daughter of my sister will be christened (is this right in english ?) So I have to be there and I gave away my tickets. But first Bayern has to beat Bayer Leverkusen tomorrow. My prediction is a 2-0 for Bayern, we should talk about the Hamburg-Bayern game after Bayern played Leverkusen ;)";}, 1425574816, 1425627080
    Run Time: 0.000452
  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, 471407, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"mhnessie, post: 471345, member: 4324";s:8:"original";a:2:{i:0;s:46:"[quote="mhnessie, post: 471345, member: 4324"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:530:"Yepp, that's true, very sunny - could have been worse ;) Did you check the fixtures for next weekend, Croak ? Hamburg plays Bayern on Saturday. :sneaky: I will be back in Germany but unfortunately can't go to the game because the newborn daughter of my sister will be christened (is this right in english ?) So I have to be there and I gave away my tickets. But first Bayern has to beat Bayer Leverkusen tomorrow. My prediction is a 2-0 for Bayern, we should talk about the Hamburg-Bayern game after Bayern played Leverkusen ;)";}}i:1;s:151:" I wasn't thinking about the Hamburg game yet. Leverkusen has me worried. Hamburg should be a cake walk. :D Sent from my Kindle Fire using Tapatalk 2";}, 1425574816, 1425627080
    Run Time: 0.000346
  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, 471448, a:1:{i:0;s:193:"Leverkusen. Their young goalie is good. For Bayern, that back line still has problems....not a big fan of Boateng. He's often beaten by his opponents. Sent from my Kindle Fire using Tapatalk 2";}, 1425574816, 1425627080
    Run Time: 0.000318
  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, 472533, a:1:{i:0;s:52:"Hey Nessie; did you go to the game in Hamburg today?";}, 1425574816, 1425627080
    Run Time: 0.000968
  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, 472573, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Croak, post: 472533, member: 2367";s:8:"original";a:2:{i:0;s:43:"[quote="Croak, post: 472533, member: 2367"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:52:"Hey Nessie; did you go to the game in Hamburg today?";}}i:1;s:251:" Hi Croak, no, unfortunately not because of the christening of my niece. I had to sell the tickets. But congrats for an easy 3-0 win, Bayern is not in reach for us. Did you watch the game, could you enjoy watching a game of your favorite team ? :)";}, 1425574816, 1425627080
    Run Time: 0.000337
  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, 473026, a:1:{i:0;s:427:"I watched. I have it recorded and showed some of it to my son when he came home from college this weekend. When he was little he dreamed of playing for FCB. But he was asked to work out with the Baltimore "Blast". He chose to go to college instead. In the beginning of the match it looked like Hamburg was going to give Bayern a rough time, then it just seemed like they eased up or they started playing on their heels a lot.";}, 1425574816, 1425627080
    Run Time: 0.000323
  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, 473126, a:1:{i:0;s:220:"I just read that Mario Gomez is close to returning for Bayern. Let's see that makes it, Pizzaro, Manzukic, Martinez, Gomez, Müller. Maybe Bayern ought to switch to a 3-2-5. ;) Sent from my Kindle Fire using Tapatalk 2";}, 1425574816, 1425627080
    Run Time: 0.000303
  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, 473175, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Croak, post: 473126, member: 2367";s:8:"original";a:2:{i:0;s:43:"[quote="Croak, post: 473126, member: 2367"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:220:"I just read that Mario Gomez is close to returning for Bayern. Let's see that makes it, Pizzaro, Manzukic, Martinez, Gomez, Müller. Maybe Bayern ought to switch to a 3-2-5. ;) Sent from my Kindle Fire using Tapatalk 2";}}i:1;s:257:" Yepp, will back on Tuesday, will be exciting to see who will be benched by Heynckes. ;) Martinez is a midfielder and Müller can play both, midfielder and forward, so could be possible that at least 4 of them will find their place in the starting lineup.";}, 1425574816, 1425627080
    Run Time: 0.000296
  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, 473592, a:4:{i:0;s:224:"Maybe interesting for you, Croak ? ARD will broadcast the DFB Pokal game (last sixteen round) between Augsburg and Bayern on Free-TV. Kickoff will be 20.30 on Dec. 18 th., ususally they provide a Livestream on their website ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:17:"http://www.ard.de";s:8:"original";a:2:{i:0;s:25:"[url="http://www.ard.de"]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:10:"www.ard.de";}}i:2;s:3:" ";i:3;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:119:"http://www.kicker.de/news/fussball/dfbpokal/startseite/577764/artikel_dortmund-und-der-fcb-werden-live-uebertragen.html";}}}, 1425574816, 1425627080
    Run Time: 0.000304
  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, 473807, a:1:{i:0;s:93:"What a chilly afternoon at the HSV stadium and what a horrible game...at least we won 1-0. ;)";}, 1425574816, 1425627080
    Run Time: 0.000306
  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, 473829, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"mhnessie, post: 473807, member: 4324";s:8:"original";a:2:{i:0;s:46:"[quote="mhnessie, post: 473807, member: 4324"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:93:"What a chilly afternoon at the HSV stadium and what a horrible game...at least we won 1-0. ;)";}}i:1;s:137:" That's better than what Bayern did against Nuremburg. That was a physical nasty match. :mad: Sent from my Kindle Fire using Tapatalk 2";}, 1425574816, 1425627080
    Run Time: 0.000286
  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, 474416, a:3:{i:0;s:53:"Just bought me the new 11 Freunde, guess why ?! ;) ";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:43:"http://imageshack.us/a/img24/9616/vdvws.jpg";}}i:2;s:347:" Headline hits the nail on the head - he is like a saviour (german: Erloeser) for us ! :D I don't want to think about what could have happenend if we hadn't sign him. Hamburg plays @ Dusseldorf tonight, on Tuesday we play Schalke @ home, tough games. Bayern plays Hannover on Saturday and Freiburg on Wednesday, I think they will win both games.";}, 1425574816, 1425627080
    Run Time: 0.000284
  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, 474481, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"mhnessie, post: 474416, member: 4324";s:8:"original";a:2:{i:0;s:46:"[quote="mhnessie, post: 474416, member: 4324"]";i:1;s:8:"[/quote]";}s:8:"children";a:6:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:47:"Just bought me the new 11 Freunde, guess why ?!";}}i:1;s:6:" ;) ";i:2;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:43:"http://imageshack.us/a/img24/9616/vdvws.jpg";}}i:3;s:92:" Headline hits the nail on the head - he is like a saviour (german: Erloeser) for us ! :D ";i:4;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:76:"I don't want to think about what could have happenend if we hadn't sign him.";}}i:5;s:179:" Hamburg plays @ Dusseldorf tonight, on Tuesday we play Schalke @ home, tough games. Bayern plays Hannover on Saturday and Freiburg on Wednesday, I think they will win both games.";}}i:1;s:369:" No idea?:) He seems to be the classic example of a one man team, in a (postive sense) or at least the inspiration for the others anyway. Gianfrancio Zola was similar at Chelsea. Just seen the Highlights of HSVs last game 1-0 a hint of offside for the goal nessie? lol who cares, a win is a win nice to see it when a decision by a ref going your teams way for once.;)";}, 1425574816, 1425627080
    Run Time: 0.000329
  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, 474503, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:39:"PackerFan71, post: 474481, member: 6273";s:8:"original";a:2:{i:0;s:49:"[quote="PackerFan71, post: 474481, member: 6273"]";i:1;s:8:"[/quote]";}s:8:"children";a:3:{i:0;s:178:"No idea?:) He seems to be the classic example of a one man team, in a (postive sense) or at least the inspiration for the others anyway. Gianfrancio Zola was similar at Chelsea. ";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:85:"Just seen the Highlights of HSVs last game 1-0 a hint of offside for the goal nessie?";}}i:2;s:103:" lol who cares, a win is a win nice to see it when a decision by a ref going your teams way for once.;)";}}i:1;s:565:" Well, I doubt there where any "Highlights" at all :D Yesterday evening they lost at Dusseldorf and allowed Dusseldorf the first Bundesliga win after 17 years.:mad: PackerFan71, we talked about Chelsea and the lack of continuity, something we also know very good in Hamburg. But I doubt that our manager Thorsten Fink is the right one, no progress is made, no goalscoring chances are created, what the hell do they practice during the week ? :rolleyes: Btw - vdVaart is injured, he has a torn muscle fibre, looks like the first half of the season is over for him :(";}, 1425574816, 1425627080
    Run Time: 0.000317
  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, 474576, a:1:{i:0;s:375:"And Gomez makes his first home appearance after his injury. Within 27 seconds he scores. The crowd went wild. The fans in Munich were singing something to the tune of what we in the States call "Roll out the Barrell". Anyone know what words they were singing? The sound on the Tv was muted too much to distinguish the actual words. Sent from my Kindle Fire using Tapatalk 2";}, 1425574816, 1425627080
    Run Time: 0.001365
  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, 474863, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Croak, post: 474576, member: 2367";s:8:"original";a:2:{i:0;s:43:"[quote="Croak, post: 474576, member: 2367"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:377:"And Gomez makes his first home appearance after his injury. Within 27 seconds he scores. The crowd went wild. The fans in Munich were singing something to the tune of what we in the States call "Roll out the Barrell". Anyone know what words they were singing? The sound on the Tv was muted too much to distinguish the actual words. Sent from my Kindle Fire using Tapatalk 2";}}i:1;s:246:" Hmm, I haven't seen the highlights of the game but the tune of what you call "Roll out the Barrel" is "Rosamunde" here in Germany. Very often they simply sing "FC Bayern, schalalalalalala..." to that tune....and that doesn't mean anything ! ;)";}, 1425574816, 1425627080
    Run Time: 0.000306
  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, 474990, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"mhnessie, post: 474503, member: 4324";s:8:"original";a:2:{i:0;s:46:"[quote="mhnessie, post: 474503, member: 4324"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:564:"Well, I doubt there where any "Highlights" at all :D Yesterday evening they lost at Dusseldorf and allowed Dusseldorf the first Bundesliga win after 17 years.:mad: PackerFan71, we talked about Chelsea and the lack of continuity, something we also know very good in Hamburg. But I doubt that our manager Thorsten Fink is the right one, no progress is made, no goalscoring chances are created, what the hell do they practice during the week ? :rolleyes: Btw - vdVaart is injured, he has a torn muscle fibre, looks like the first half of the season is over for him :(";}}i:1;s:293:" I saw the highlights of the Dusseldorf game two dissalowed goals for HSV? very frustrating and as you said vdVarrt getting hurt. What a bummer hope its not for too long. Who within reason would you have as HSV coach if you could get them? Roll out the Barrel thats real retro, love it.:tup:";}, 1425574816, 1425627080
    Run Time: 0.000301

Included Files (156, XenForo Classes: 62)

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