Page Time: 0.6804s

Memory: 9.2008 MB (Peak: 27.8508 MB)

Queries (37, time: 0.0933s, 13.7%)

1. SELECT cache_value
   FROM xf_permission_combination
   WHERE permission_combination_id = ?

   Params: 1
   Run Time: 0.000299

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

2. SELECT thread.*
   	,
   		user.gender, user.avatar_date, user.gravatar,
   		NULL AS thread_read_date,
   		0 AS thread_is_watched
   FROM xf_thread AS thread
   
   		LEFT JOIN xf_user AS user ON
   			(user.user_id = thread.user_id)
   WHERE thread.thread_id = ?

   Params: 174786
   Run Time: 0.003752

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	thread	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1

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: 109
   Run Time: 0.000595

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	forum	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	node	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	permission	const	PRIMARY	PRIMARY	85	const,const,const	1

4. SELECT node.*, forum.*
   	
   FROM xf_forum AS forum
   INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
   
   INNER JOIN xf_thread AS thread ON
   	(thread.node_id = forum.node_id)
   WHERE (thread.thread_id = 174786)
    LIMIT 1

   Run Time: 0.001073

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	thread	const	PRIMARY,node_id_last_post_date,node_id_sticky_last_post_date	PRIMARY	4	const	1
   SIMPLE	forum	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	node	const	PRIMARY	PRIMARY	4	const	1

5. SELECT *
   	FROM EWRporta_options
   WHERE option_id = ?

   Params: recentnews_forum
   Run Time: 0.000354

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	EWRporta_options	const	PRIMARY	PRIMARY	152	const	1

6. SELECT *
   	FROM EWRporta_promotes
   WHERE thread_id = ?

   Params: 174786
   Run Time: 0.000512

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE								Impossible WHERE noticed after reading const tables

7. SELECT post.*
   	,
   		user.*, IF(user.username IS NULL, post.username, user.username) AS username,
   		user_profile.*,
   		0 AS like_date, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 1) as dark_postrating_1_count
   , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 14) as dark_postrating_14_count
   , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 2) as dark_postrating_2_count
   , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 3) as dark_postrating_3_count
   , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 4) as dark_postrating_4_count
   , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 6) as dark_postrating_6_count
   , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 8) as dark_postrating_8_count
   , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 12) as dark_postrating_12_count
   , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 13) as dark_postrating_13_count
   
   		,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (1,2,4,6,8)) as positive_rating_count
   	
   		,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (14,12,13)) as negative_rating_count
   	
   		,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (3)) as neutral_rating_count
   	,
   pr2.rating
   FROM xf_post AS post
   
   		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 dark_postrating pr2 ON (post.post_id = pr2.post_id and pr2.user_id = 0)
   WHERE post.thread_id = ?
   	 AND (post.position >= 0 AND post.position < 40) 
   	AND (post.message_state IN ('visible'))
   ORDER BY post.position ASC, post.post_date ASC

   Params: 174786
   Run Time: 0.050855

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   PRIMARY	post	ref	thread_id_post_date,thread_id_position	thread_id_post_date	4	const	9	Using where; Using filesort
   PRIMARY	user	eq_ref	PRIMARY	PRIMARY	4	valvetime_forums.post.user_id	1
   PRIMARY	user_profile	eq_ref	PRIMARY	PRIMARY	4	valvetime_forums.post.user_id	1
   PRIMARY	pr2	eq_ref	post_id_user_id,post_id_rating,user_id_rating	post_id_user_id	8	valvetime_forums.post.post_id,const	1
   DEPENDENT SUBQUERY	dark_postrating_count	eq_ref	user_id_rating	user_id_rating	8	valvetime_forums.post.user_id,const	1
   DEPENDENT SUBQUERY	dark_postrating_count	ref	user_id_rating	user_id_rating	4	valvetime_forums.post.user_id	1	Using index condition
   DEPENDENT SUBQUERY	dark_postrating_count	ref	user_id_rating	user_id_rating	4	valvetime_forums.post.user_id	1	Using index condition
   DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.post.post_id,const	1	Using index
   DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.post.post_id,const	1	Using index
   DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.post.post_id,const	1	Using index
   DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.post.post_id,const	1	Using index
   DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.post.post_id,const	1	Using index
   DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.post.post_id,const	1	Using index
   DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.post.post_id,const	1	Using index
   DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.post.post_id,const	1	Using index
   DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.post.post_id,const	1	Using index

8. INSERT DELAYED INTO xf_thread_view
   	(thread_id)
   VALUES
   	(?)

   Params: 174786
   Run Time: 0.000293

9. SELECT *
   FROM xf_node
   WHERE lft < ? AND rgt > ?
   ORDER BY lft ASC

   Params: 80, 81
   Run Time: 0.000354

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_node	ALL	lft				56	Using where; Using filesort

10. SELECT *
    	FROM EWRporta_options
    WHERE option_id = ?

    Params: recentnews_forum
    Run Time: 0.000332

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	EWRporta_options	const	PRIMARY	PRIMARY	152	const	1

11. SELECT *
    	FROM EWRporta_promotes
    WHERE thread_id = ?

    Params: 174786
    Run Time: 0.000227

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

12. INSERT INTO xf_session_activity
    	(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date)
    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)

    Params: 0, 839937191, 839937191, XenForo_ControllerPublic_Thread, Index, valid, thread_id=174786, 1371648531
    Run Time: 0.000274

13. SELECT *
    FROM kingk_bbcm
    ORDER BY tag

    Run Time: 0.000605

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	kingk_bbcm	ALL					11	Using filesort

14. SELECT *
    	FROM EWRporta_layouts
    WHERE layout_id = ?

    Params: thread-174786
    Run Time: 0.000437

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

15. SELECT *
    	FROM EWRporta_layouts
    WHERE layout_id = ?

    Params: thread-forum-109
    Run Time: 0.000239

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

16. SELECT *
    	FROM EWRporta_layouts
    WHERE layout_id = ?

    Params: thread
    Run Time: 0.000216

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	EWRporta_layouts	const	PRIMARY	PRIMARY	77	const	1

17. SELECT *, 'disabled' AS position
    	FROM EWRporta_blocks
    WHERE active = 1
    ORDER BY block_id ASC

    Run Time: 0.000369

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	EWRporta_blocks	index		PRIMARY	77		14	Using where

18. SELECT * FROM EWRporta_caches

    Run Time: 0.000370

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	EWRporta_caches	ALL					8

19. SELECT * FROM EWRporta_options

    Run Time: 0.000432

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	EWRporta_options	ALL					37

20. SELECT thread.*
    	,
    	user.*, thread.username AS username,
    	node.title AS node_title,
    	NULL AS thread_read_date,
    	0 AS thread_is_watched,
    	0 AS user_post_count,
    permission.cache_value AS node_permission_cache, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 1) as dark_postrating_1_count, 1 as dark_postrating_has_fetched_max
    , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 14) as dark_postrating_14_count, 1 as dark_postrating_has_fetched_max
    , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 2) as dark_postrating_2_count, 1 as dark_postrating_has_fetched_max
    , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 3) as dark_postrating_3_count, 1 as dark_postrating_has_fetched_max
    , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 4) as dark_postrating_4_count, 1 as dark_postrating_has_fetched_max
    , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 6) as dark_postrating_6_count, 1 as dark_postrating_has_fetched_max
    , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 8) as dark_postrating_8_count, 1 as dark_postrating_has_fetched_max
    , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 12) as dark_postrating_12_count, 1 as dark_postrating_has_fetched_max
    , (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = thread.first_post_id and pr.rating = 13) as dark_postrating_13_count, 1 as dark_postrating_has_fetched_max
    
    FROM xf_thread AS thread
    
    	LEFT JOIN xf_user AS user ON
    		(user.user_id = thread.user_id)
    	LEFT JOIN xf_node AS node ON
    		(node.node_id = thread.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 = thread.node_id)
    WHERE (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1371562131) AND thread.node_id IN ('32', '127', '88', '5', '101', '112', '61', '96', '78', '103', '120', '50', '66', '86', '129', '8', '109', '83', '6', '75')
    ORDER BY thread.last_post_date DESC
     LIMIT 6

    Run Time: 0.005392

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    PRIMARY	thread	range	node_id_last_post_date,node_id_sticky_last_post_date,last_post_date	last_post_date	4		9	Using where
    PRIMARY	user	eq_ref	PRIMARY	PRIMARY	4	valvetime_forums.thread.user_id	1
    PRIMARY	node	eq_ref	PRIMARY	PRIMARY	4	valvetime_forums.thread.node_id	1
    PRIMARY	permission	eq_ref	PRIMARY	PRIMARY	85	const,const,valvetime_forums.thread.node_id	1	Using where
    DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.thread.first_post_id,const	1	Using index
    DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.thread.first_post_id,const	1	Using index
    DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.thread.first_post_id,const	1	Using index
    DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.thread.first_post_id,const	1	Using index
    DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.thread.first_post_id,const	1	Using index
    DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.thread.first_post_id,const	1	Using index
    DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.thread.first_post_id,const	1	Using index
    DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.thread.first_post_id,const	1	Using index
    DEPENDENT SUBQUERY	pr	ref	post_id_rating	post_id_rating	8	valvetime_forums.thread.first_post_id,const	1	Using index

21. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 32
    Run Time: 0.000222

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	85	const,const,const	1

22. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 8
    Run Time: 0.000238

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	85	const,const,const	1

23. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 6
    Run Time: 0.000213

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	85	const,const,const	1

24. SELECT session_activity.*
    	,
    	user.*,
    	user_profile.*,
    	user_option.*
    		,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,2,4,6,8)) as positive_rating_count
    	
    		,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (14,12,13)) as negative_rating_count
    	
    		,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (3)) as neutral_rating_count
    	
    FROM xf_session_activity AS session_activity
    
    	LEFT JOIN xf_user AS user ON
    		(user.user_id = session_activity.user_id)
    	LEFT JOIN xf_user_profile AS user_profile ON
    		(user_profile.user_id = user.user_id)
    	LEFT JOIN xf_user_option AS user_option ON
    		(user_option.user_id = user.user_id)
    WHERE (session_activity.view_date > 1371647631)
    ORDER BY session_activity.view_date DESC

    Run Time: 0.021780

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    PRIMARY	session_activity	ALL	view_date				7723	Using where; Using filesort
    PRIMARY	user	eq_ref	PRIMARY	PRIMARY	4	valvetime_forums.session_activity.user_id	1
    PRIMARY	user_profile	eq_ref	PRIMARY	PRIMARY	4	valvetime_forums.user.user_id	1	Using where
    PRIMARY	user_option	eq_ref	PRIMARY	PRIMARY	4	valvetime_forums.user.user_id	1	Using where
    DEPENDENT SUBQUERY	dark_postrating_count	eq_ref	user_id_rating	user_id_rating	8	valvetime_forums.user.user_id,const	1
    DEPENDENT SUBQUERY	dark_postrating_count	ref	user_id_rating	user_id_rating	4	valvetime_forums.user.user_id	1	Using index condition
    DEPENDENT SUBQUERY	dark_postrating_count	ref	user_id_rating	user_id_rating	4	valvetime_forums.user.user_id	1	Using index condition

25. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('page_nav', 'bdtagme_tag', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'EWRblock_RecentThreads', 'EWRblock_Twitter', 'EWRblock_FaceBook', 'EWRblock_OnlineUsers', 'EWRblock_BoardTotals', 'EWRblock_AdSidebar')
    	AND style_id = ?
    	AND language_id = ?

    Params: 9, 1
    Run Time: 0.000337

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	range	PRIMARY	PRIMARY	160		13	Using where

26. SELECT page_name FROM EWRcarta_pages WHERE page_slug = 'index'

    Run Time: 0.000179

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	EWRcarta_pages	const	page_slug	page_slug	302	const	1

27. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('cts_thread_tools', 'forumwatch_thread_view', 'thread_view', 'nat_childlinks')
    	AND style_id = ?
    	AND language_id = ?

    Params: 9, 1
    Run Time: 0.000358

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	range	PRIMARY	PRIMARY	160		4	Using where

28. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('home')

    Params: 1
    Run Time: 0.000207

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_phrase_compiled	const	PRIMARY	PRIMARY	231	const,const	1

29. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('EWRporta_Navtabs', 'steam_navtabs', 'EWRcarta_Navtabs', 'steam_login_bar_item', 'steam_navigation_visitor_tab_link', 'steam_account_wrapper_sidebar_settings', 'steam_message_user_info', 'steam_js', 'steamstats_js', 'steam_member_view_info', 'steam_message_content', 'steam_helper_criteria_privs', 'steam_member_card_info', 'steam_footer', 'steam_public_index', 'steam_public_owned', 'steam_public_played', 'steam_public_recent', 'wf_hook_moderator_bar', 'wf_revealer', 'forumwatch_navigation_tabs_forums', 'attachmentviewer_navigation_tabs_forums', 'attachmentviewer_navigation_visitor_tab', 'bdtagme_PAGE_CONTAINER', 'PAGE_CONTAINER', 'EWRporta_Custom_Top')
    	AND style_id = ?
    	AND language_id = ?

    Params: 9, 1
    Run Time: 0.000447

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	range	PRIMARY	PRIMARY	160		26	Using where

30. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('dark_postrating_message_user_info')
    	AND style_id = ?
    	AND language_id = ?

    Params: 9, 1
    Run Time: 0.000284

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	160	const,const,const	1

31. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('dark_postrating')
    	AND style_id = ?
    	AND language_id = ?

    Params: 9, 1
    Run Time: 0.000273

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	160	const,const,const	1

32. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('quick_reply_preview')
    	AND style_id = ?
    	AND language_id = ?

    Params: 9, 1
    Run Time: 0.000276

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	160	const,const,const	1

33. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('preview')

    Params: 1
    Run Time: 0.000232

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_phrase_compiled	const	PRIMARY	PRIMARY	231	const,const	1

34. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('bbcm_js')
    	AND style_id = ?
    	AND language_id = ?

    Params: 9, 1
    Run Time: 0.000259

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	160	const,const,const	1

35. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('MobileIcons_Links')
    	AND style_id = ?
    	AND language_id = ?

    Params: 9, 1
    Run Time: 0.000374

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	160	const,const,const	1

36. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('BrowserUpdate')
    	AND style_id = ?
    	AND language_id = ?

    Params: 9, 1
    Run Time: 0.000265

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	160	const,const,const	1

37. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('social_connect_status_editor')
    	AND style_id = ?
    	AND language_id = ?

    Params: 9, 1
    Run Time: 0.000341

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	160	const,const,const	1

Included Files (228, 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.php
17. library/XenForo/Model/DataRegistry.php
18. library/XenForo/CodeEvent.php
19. library/Zend/Cache.php
20. library/Zend/Cache/Backend/Memcached.php
21. library/Zend/Cache/Backend/ExtendedInterface.php
22. library/Zend/Cache/Backend/Interface.php
23. library/Zend/Cache/Backend.php
24. library/Zend/Cache/Core.php
25. library/XenForo/Options.php
26. library/XenForo/Link.php
27. library/XenForo/Template/Helper/Core.php
28. library/EnableDebugFromAdminHome/Listener.php
29. library/EWRporta/Listener/Init.php
30. library/EWRcarta/Listener/Init.php
31. library/XenForo/DataWriter/User.php
32. library/XenForo/DataWriter.php
33. library/WidgetFramework/Listener.php
34. library/WidgetFramework/Core.php
35. library/WhoHasVisited/Listener.php
36. library/WidgetFramework/Model/Widget.php
37. library/AddOnInstaller/Listener.php
38. library/AttachmentViewer/Listener.php
39. library/bdTagMe/Listener.php
40. library/ForumWatch/Listener.php
41. library/Waindigo/UserGroups/Listener/LoadClassModel.php
42. library/Waindigo/Listener/LoadClass.php
43. library/Waindigo/Listener/LoadClass/20121129.php
44. library/TMS/Listener/Listener.php
45. library/EWRcarta/Listener/Model.php
46. library/Tapatalk/Listener/LoadClassModel.php
47. library/Waindigo/AdminImages/Listener/LoadClassModel.php
48. library/vb4ToXf11/Listener/ExtendModel.php
49. library/EWRporta/Listener/Model.php
50. library/FetchThreadsQueryFix/Listener.php
51. library/AddOnBuilder/Listener.php
52. library/Dc/SmileyManager/EventListener.php
53. library/SocialConnect/Listener.php
54. library/Dark/PostRating/EventListener.php
55. library/WidgetFramework/WidgetRenderer.php
56. library/WidgetFramework/WidgetRenderer/Empty.php
57. library/XenForo/Input.php
58. library/WidgetFramework/WidgetRenderer/Template.php
59. library/WidgetFramework/WidgetRenderer/OnlineStaff.php
60. library/WidgetFramework/WidgetRenderer/OnlineUsers.php
61. library/WhoHasVisited/WidgetRenderer/WhoHasVisited.php
62. library/WidgetFramework/WidgetRenderer/RecentStatus.php
63. library/WidgetFramework/WidgetRenderer/Birthday.php
64. library/WidgetFramework/WidgetRenderer/Stats.php
65. library/WidgetFramework/WidgetRenderer/ShareThisPage.php
66. library/Steam/Listener.php
67. library/bdTagMe/Template/Helper.php
68. library/HtmlCustomTitles/Listener.php
69. library/RouteChanger/Listen.php
70. library/RouteChanger/Route/Static.php
71. library/XenForo/Router.php
72. library/XenForo/Route/ResponseSuffix.php
73. library/XenForo/Route/Interface.php
74. library/XenForo/Route/Prefix.php
75. library/XenForo/Route/Prefix/Threads.php
76. library/EWRporta/Listener/Route.php
77. library/EWRporta/Route/Thread.php
78. library/XenForo/RouteMatch.php
79. library/NodesAsTabs/Listen.php
80. library/XenForo/ControllerPublic/Thread.php
81. library/XenForo/ControllerPublic/Abstract.php
82. library/XenForo/Controller.php
83. library/Tac/FoolBotHoneyPot/Listener.php
84. library/ChangeThreadStarter/Listener.php
85. library/XenMerge/Listen.php
86. library/KingK/BbCodeManager/EventListener/BbCode.php
87. library/Waindigo/UserGroups/Listener/LoadClassController.php
88. library/ResetPasswordFromACP/Listener.php
89. library/Ragtek/ContactThread/EventListener/CreateThread.php
90. library/Sedo/FixTiny/Listener/ControllerPublic.php
91. library/EWRporta/Listener/Controller.php
92. library/Social/Listener.php
93. library/CustomImgCaptcha/Listener.php
94. library/Sedo/MarkitUpIntegrator/Listener/LoadClassController.php
95. library/ChangeThreadStarter/ControllerPublic/Thread.php
96. library/NodesAsTabs/ControllerPublic/Thread.php
97. library/WidgetFramework/Extend/ControllerPublic/Thread.php
98. library/ForumWatch/Extend/ControllerPublic/Thread.php
99. library/EWRporta/ControllerPublic/Thread.php
100. library/XenForo/Session.php
101. library/Zend/Db.php
102. library/Zend/Db/Adapter/Mysqli.php
103. library/Zend/Db/Adapter/Abstract.php
104. library/Zend/Db/Select.php
105. library/Zend/Db/Expr.php
106. library/Zend/Db/Profiler.php
107. library/Zend/Db/Statement/Mysqli.php
108. library/Zend/Db/Statement.php
109. library/Zend/Db/Statement/Interface.php
110. library/XenForo/Visitor.php
111. library/XenForo/Model/User.php
112. library/bdTagMe/XenForo/Model/User.php
113. library/ForumWatch/Extend/Model/User.php
114. library/WidgetFramework/Extend/Model/User.php
115. library/Dark/PostRating/Model/User.php
116. library/Zend/Db/Profiler/Query.php
117. library/XenForo/Permission.php
118. library/XenForo/Phrase.php
119. library/XenForo/Locale.php
120. library/EWRporta/Model/Perms.php
121. library/Sedo/FixTiny/Listener/ControllerPreDispatch.php
122. library/Sedo/MarkitUpIntegrator/Listener/ControllerPreDispatch.php
123. library/XenForo/ControllerHelper/ForumThreadPost.php
124. library/XenForo/ControllerHelper/Abstract.php
125. library/XenForo/Model/Thread.php
126. library/WidgetFramework/Extend/Model/Thread.php
127. library/FetchThreadsQueryFix/Model/Thread.php
128. library/Dark/PostRating/Model/Thread.php
129. library/Dark/PostRating/Model.php
130. library/XenForo/Model/Forum.php
131. library/ForumWatch/Extend/Model/Forum.php
132. library/XenForo/Helper/String.php
133. library/XenForo/Model/Post.php
134. library/bdTagMe/XenForo/Model/Post.php
135. library/ForumWatch/Extend/Model/Post.php
136. library/EWRcarta/Model/Post.php
137. library/EWRporta/Model/Post.php
138. library/Dark/PostRating/Model/Post.php
139. library/EWRporta/Model/Promotes.php
140. library/XenForo/Model/Attachment.php
141. library/AttachmentViewer/XenForo/Model/Attachment.php
142. library/Waindigo/AdminImages/Model/Attachment.php
143. library/EWRporta/Model/Attachment.php
144. library/XenForo/Model/Node.php
145. library/Tapatalk/Model/Node.php
146. library/XenForo/Route/Prefix/Categories.php
147. library/XenForo/Route/Prefix/Forums.php
148. library/XenForo/ControllerResponse/View.php
149. library/XenForo/ControllerResponse/Abstract.php
150. library/XenForo/Helper/Cookie.php
151. library/NodesAsTabs/Model/Options.php
152. library/XenForo/ViewRenderer/HtmlPublic.php
153. library/XenForo/ViewRenderer/Abstract.php
154. library/XenForo/Template/Public.php
155. library/XenForo/Template/Abstract.php
156. library/XenForo/ViewPublic/Thread/View.php
157. library/XenForo/ViewPublic/Base.php
158. library/XenForo/View.php
159. library/EWRporta/Listener/ViewPublic.php
160. library/MeCommand/Listener.php
161. library/ControlNoFollow/Listener.php
162. library/Sedo/FixTiny/Listener/ViewPublic.php
163. library/DigitalPointAdPositioning/Listener/LoadClassView.php
164. library/DescriptionContentRss/Listener.php
165. library/EWRporta/ViewPublic/Custom.php
166. library/MeCommand/ViewPublic/Thread/View.php
167. library/ControlNoFollow/ViewPublic/Thread/View.php
168. library/DigitalPointAdPositioning/ViewPublic/Thread/View.php
169. library/XenForo/BbCode/Parser.php
170. library/XenForo/BbCode/Formatter/Base.php
171. library/EWRporta/Listener/BbCode.php
172. library/Sedo/FixTiny/Listener/BbCode.php
173. library/EWRcarta/Listener/BbCode.php
174. library/MeCommand/BbCode/Formatter/Base.php
175. library/EWRporta/BbCode/Formatter.php
176. library/KingK/BbCodeManager/BbCode/Formatter/Base.php
177. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
178. library/EWRcarta/BbCode/Formatter.php
179. library/KingK/BbCodeManager/Model/CustomBbCode.php
180. library/bdTagMe/Option.php
181. library/XenForo/ViewPublic/Helper/Message.php
182. library/XenForo/BbCode/TextWrapper.php
183. library/EWRporta/Model/Blocks.php
184. library/EWRporta/Model/Layouts.php
185. library/EWRporta/Model/Caches.php
186. library/EWRporta/Model/Options.php
187. library/EWRporta/Block/RecentThreads.php
188. library/XenForo/Model/PermissionCache.php
189. library/XenForo/Helper/Discussion.php
190. library/Sedo/MarkitUpIntegrator/Listener/PreloadTemplates.php
191. library/KingK/BbCodeManager/EventListener/Templates/Preloader.php
192. library/ResponsiveDesign/Listener.php
193. library/EWRporta/Block/Twitter.php
194. library/EWRporta/Block/OnlineUsers.php
195. library/XenForo/Model/Session.php
196. library/Dark/PostRating/Model/Session.php
197. library/EWRporta/Block/BoardTotals.php
198. library/quickReplyPreview/Listen.php
199. library/ToggleME/Listener.php
200. library/EWRporta/Route/Portal.php
201. library/RouteChanger/Route/Prefix/1.php
202. library/XenForo/Route/Prefix/Index.php
203. library/XenForo/Route/Prefix/Members.php
204. library/bdTagMe/XenForo/Route/Prefix/Members.php
205. library/EWRporta/Listener/NavTabs.php
206. library/EWRcarta/Listener/NavTabs.php
207. library/EWRcarta/Model/Perms.php
208. library/EWRcarta/Model/Lists.php
209. library/EWRcarta/Route/Wiki.php
210. library/RouteChanger/Route/Prefix/0.php
211. library/NodesAsTabs/NavTabs.php
212. library/XenForo/Route/Prefix/Pages.php
213. library/bdTagMe/Engine.php
214. library/Tapatalk/EventListener/Hook.php
215. library/KingK/BbCodeManager/EventListener/Templates/InitEditorGrid.php
216. library/WidgetFramework/Option.php
217. library/DigitalPointAdPositioning/Listener/TemplateHook.php
218. library/ModUnread/Listeners/ModBarListener.php
219. library/EWRcarta/Listener/Template.php
220. library/Sedo/FixTiny/Listener/Templates.php
221. library/EWRporta/Listener/Template.php
222. library/MobileIcons/Listen.php
223. library/BrowserUpdate/Listen.php
224. library/Sedo/MarkitUpIntegrator/Listener/Templates.php
225. library/XenForo/Route/Prefix/Posts.php
226. library/HtmlCustomTitles/Template/Helper/Core.php
227. library/XenForo/Debug.php
228. library/XenForo/ViewRenderer/Json.php