Page Time: 0.3767s

Memory: 13.5405 MB (Peak: 14.5430 MB)

Queries (98, time: 0.2071s, 55.0%)

SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')

Run Time: 0.000540

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

```
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
```
Run Time: 0.000154
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_data_registry range PRIMARY PRIMARY 27 2 Using where
```
SELECT active FROM xf_addon WHERE addon_id = 'NodesAsTabs'
```
Run Time: 0.000144
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_addon const PRIMARY PRIMARY 27 const 1
```
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
```
Params: 1
Run Time: 0.000104
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_combination const PRIMARY PRIMARY 4 const 1

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_data_registry	range	PRIMARY	PRIMARY	27		2	Using where

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_addon	const	PRIMARY	PRIMARY	27	const	1

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

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,
		0 AS xfa_extmod_trban_conf
FROM xf_thread AS thread

		LEFT JOIN xf_user AS user ON
			(user.user_id = thread.user_id)
WHERE thread.thread_id = ?

Params: 48574

Run Time: 0.000558

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

SELECT node.*, forum.*
	,
	permission.cache_value AS node_permission_cache,
		NULL AS forum_read_date,
forum_ban_conf, IF(forum_ban.forum_ban_user_id IS NULL, 0,
	IF(forum_ban.forum_ban_expiry_date IS NULL OR forum_ban.forum_ban_expiry_date > 1566601075, 1, 0)) AS forum_banned
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)
LEFT JOIN xfa_extmod_forum_ban AS forum_ban
	ON (forum_ban.forum_ban_node_id = forum.node_id
	AND forum_ban.forum_ban_user_id = 0)
WHERE node.node_id = ?

Params: 43

Run Time: 0.000578

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	35	const,const,const	1
SIMPLE	forum_ban	const	node_id,user_id	node_id	8	const,const	0	unique row not found

SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
FROM EWRporta2_articles
	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
WHERE EWRporta2_articles.thread_id = ?

Params: 48574

Run Time: 0.001099

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

SELECT post.*
	,
		user.*, IF(user.username IS NULL, post.username, user.username) AS username,
		user_profile.*,
		user_privacy.*,
		session_activity.view_date AS last_view_date,
		0 AS like_date
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 xf_user_privacy AS user_privacy ON
			(user_privacy.user_id = post.user_id)
		LEFT JOIN xf_session_activity AS session_activity ON
			(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE post.thread_id = ?
	 AND (post.position >= 0 AND post.position < 20) 
	AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC

Params: 48574

Run Time: 0.001021

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	post	ref	thread_id_post_date,thread_id_position	thread_id_post_date	4	const	3	Using where; Using filesort
SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	db25061_47.post.user_id	1
SIMPLE	user_profile	eq_ref	PRIMARY	PRIMARY	4	db25061_47.post.user_id	1
SIMPLE	user_privacy	eq_ref	PRIMARY	PRIMARY	4	db25061_47.post.user_id	1
SIMPLE	session_activity	eq_ref	PRIMARY	PRIMARY	22	db25061_47.post.user_id,func	1	Using where

                SELECT permission_combination_id, cache_value
                FROM xf_permission_combination AS permission_combination
                WHERE permission_combination_id in (?,?)

Params: 2, 122

Run Time: 0.000122

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

INSERT DELAYED INTO xf_thread_view
	(thread_id)
VALUES
	(?)

Params: 48574

Run Time: 0.000113

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,
		0 AS xfa_extmod_trban_conf
FROM xf_thread AS thread

		LEFT JOIN xf_user AS user ON
			(user.user_id = thread.user_id)
WHERE thread.thread_id = ?

Params: 48574

Run Time: 0.000241

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

SELECT node.*, forum.*
	,
	permission.cache_value AS node_permission_cache,
		NULL AS forum_read_date,
forum_ban_conf, IF(forum_ban.forum_ban_user_id IS NULL, 0,
	IF(forum_ban.forum_ban_expiry_date IS NULL OR forum_ban.forum_ban_expiry_date > 1566601075, 1, 0)) AS forum_banned
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)
LEFT JOIN xfa_extmod_forum_ban AS forum_ban
	ON (forum_ban.forum_ban_node_id = forum.node_id
	AND forum_ban.forum_ban_user_id = 0)
WHERE node.node_id = ?

Params: 43

Run Time: 0.000228

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	35	const,const,const	1
SIMPLE	forum_ban	const	node_id,user_id	node_id	8	const,const	0	unique row not found

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,
		0 AS xfa_extmod_trban_conf
FROM xf_thread AS thread

		LEFT JOIN xf_user AS user ON
			(user.user_id = thread.user_id)
WHERE thread.thread_id = ?

Params: 48574

Run Time: 0.000185

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

SELECT node.*, forum.*
	,
	permission.cache_value AS node_permission_cache,
		NULL AS forum_read_date,
forum_ban_conf, IF(forum_ban.forum_ban_user_id IS NULL, 0,
	IF(forum_ban.forum_ban_expiry_date IS NULL OR forum_ban.forum_ban_expiry_date > 1566601075, 1, 0)) AS forum_banned
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)
LEFT JOIN xfa_extmod_forum_ban AS forum_ban
	ON (forum_ban.forum_ban_node_id = forum.node_id
	AND forum_ban.forum_ban_user_id = 0)
WHERE node.node_id = ?

Params: 43

Run Time: 0.000217

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	35	const,const,const	1
SIMPLE	forum_ban	const	node_id,user_id	node_id	8	const,const	0	unique row not found

SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
FROM EWRporta2_articles
	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
WHERE EWRporta2_articles.thread_id = ?

Params: 48574

Run Time: 0.000494

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

SELECT post.*
	,
		user.*, IF(user.username IS NULL, post.username, user.username) AS username,
		user_profile.*,
		user_privacy.*,
		session_activity.view_date AS last_view_date,
		0 AS like_date
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 xf_user_privacy AS user_privacy ON
			(user_privacy.user_id = post.user_id)
		LEFT JOIN xf_session_activity AS session_activity ON
			(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE post.thread_id = ?
	 AND (post.position >= 0 AND post.position < 1) 
	AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC

Params: 48574

Run Time: 0.000812

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	post	range	thread_id_post_date,thread_id_position	thread_id_position	8		1	Using index condition; Using where; Using filesort
SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	db25061_47.post.user_id	1
SIMPLE	user_profile	eq_ref	PRIMARY	PRIMARY	4	db25061_47.post.user_id	1
SIMPLE	user_privacy	eq_ref	PRIMARY	PRIMARY	4	db25061_47.post.user_id	1
SIMPLE	session_activity	eq_ref	PRIMARY	PRIMARY	22	db25061_47.post.user_id,func	1	Using where

INSERT INTO `xf_advog_log` (`log_date`, `user_id`, `content_id`, `message`) VALUES (?, ?, ?, ?)

Params: 1566601075, 0, 48574, Loaded cache and it was valid. Tasks finished!

Run Time: 0.000164

```
SELECT * FROM EWRporta2_features WHERE thread_id = ?
```
Params: 48574
Run Time: 0.000171
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE Impossible WHERE noticed after reading const tables

SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
FROM EWRporta2_articles
	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
WHERE EWRporta2_articles.thread_id = ?

Params: 48574

Run Time: 0.000540

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

```
SELECT *
FROM xf_node

ORDER BY lft ASC
```
Run Time: 0.000167
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_node ALL 75 Using filesort
```
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = 'node'
```
Params: 1
Run Time: 0.000150
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_cache_content ref PRIMARY PRIMARY 31 const,const 76 Using where
```
SELECT params
FROM xf_session_activity
WHERE user_id = ?
AND controller_action = 'CreateThread'
```
Params: 0
Run Time: 0.000366
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_session_activity ref PRIMARY PRIMARY 4 const 524 Using where

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_node	ALL					75	Using filesort

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_permission_cache_content	ref	PRIMARY	PRIMARY	31	const,const	76	Using where

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_session_activity	ref	PRIMARY	PRIMARY	4	const	524	Using where

SELECT xf_thread.thread_id, 
xf_thread.node_id,
xf_thread.title, 
xf_thread.reply_count,
xf_thread.view_count, 
xf_thread.username, 
xf_thread.post_date,
xf_thread.last_post_date, 
xf_thread.last_post_user_id, 
xf_thread.last_post_username, 
xf_thread.prefix_id, 			 
xf_node.title AS nodeTitle, 
xf_user.user_id, 
xf_user.gender, 
xf_user.avatar_date	
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
WHERE xf_thread.title LIKE '%Deferred%'
AND xf_thread.title LIKE '%Compensation%'
AND xf_thread.title LIKE '%Entgeltumwandlung%'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND xf_thread.post_date >= ?
AND (xf_thread.node_id = 4 OR xf_thread.node_id = 8 OR xf_thread.node_id = 9 OR xf_thread.node_id = 34 OR xf_thread.node_id = 22 OR xf_thread.node_id = 24 OR xf_thread.node_id = 3 OR xf_thread.node_id = 40 OR xf_thread.node_id = 16 OR xf_thread.node_id = 30 OR xf_thread.node_id = 29 OR xf_thread.node_id = 28 OR xf_thread.node_id = 25 OR xf_thread.node_id = 89 OR xf_thread.node_id = 7 OR xf_thread.node_id = 23 OR xf_thread.node_id = 43 OR xf_thread.node_id = 11 OR xf_thread.node_id = 35 OR xf_thread.node_id = 36 OR xf_thread.node_id = 37 OR xf_thread.node_id = 47 OR xf_thread.node_id = 38 OR xf_thread.node_id = 90 OR xf_thread.node_id = 26 OR xf_thread.node_id = 19 OR xf_thread.node_id = 27 OR xf_thread.node_id = 33 OR xf_thread.node_id = 46 OR xf_thread.node_id = 45 OR xf_thread.node_id = 31 OR xf_thread.node_id = 32 OR xf_thread.node_id = 10 OR xf_thread.node_id = 17 OR xf_thread.node_id = 48 OR xf_thread.node_id = 44 OR xf_thread.node_id = 41 OR xf_thread.node_id = 21 OR xf_thread.node_id = 20 OR xf_thread.node_id = 5 OR xf_thread.node_id = 14 OR xf_thread.node_id = 13 OR xf_thread.node_id = 93 OR xf_thread.node_id = 18 OR xf_thread.node_id = 54 OR xf_thread.node_id = 68 OR xf_thread.node_id = 69 OR xf_thread.node_id = 71 OR xf_thread.node_id = 72 OR xf_thread.node_id = 73 OR xf_thread.node_id = 82 OR xf_thread.node_id = 84 OR xf_thread.node_id = 86 OR xf_thread.node_id = 74 OR xf_thread.node_id = 75 OR xf_thread.node_id = 78 OR xf_thread.node_id = 79 OR xf_thread.node_id = 80 OR xf_thread.node_id = 92 OR xf_thread.node_id = 77 OR xf_thread.node_id = 76 OR xf_thread.node_id = 70 OR xf_thread.node_id = 64 OR xf_thread.node_id = 66 OR xf_thread.node_id = 67 OR xf_thread.node_id = 81 OR xf_thread.node_id = 87 OR xf_thread.node_id = 85 OR xf_thread.node_id = 60)
AND xf_thread.thread_id <> '48574'

AND (xf_thread.node_id <> 8 AND xf_thread.node_id <> 9 AND xf_thread.node_id <> 34 AND xf_thread.node_id <> 22 AND xf_thread.node_id <> 24 AND xf_thread.node_id <> 10 AND xf_thread.node_id <> 17 AND xf_thread.node_id <> 48 AND xf_thread.node_id <> 14 AND xf_thread.node_id <> 13 AND xf_thread.node_id <> 18 AND xf_thread.node_id <> 12 AND xf_thread.node_id <> 15 AND xf_thread.node_id <> 39)
ORDER BY xf_thread.post_date DESC
LIMIT ?

Params: 0, 5

Run Time: 0.045920

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_thread	range	PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_date	post_date	4		14625	Using index condition; Using where
SIMPLE	xf_node	eq_ref	PRIMARY	PRIMARY	4	db25061_47.xf_thread.node_id	1
SIMPLE	xf_user	eq_ref	PRIMARY	PRIMARY	4	db25061_47.xf_thread.user_id	1

SELECT xf_thread.thread_id, 
xf_thread.node_id,
xf_thread.title, 
xf_thread.reply_count,
xf_thread.view_count, 
xf_thread.username, 
xf_thread.post_date,
xf_thread.last_post_date, 
xf_thread.last_post_user_id, 
xf_thread.last_post_username, 
xf_thread.prefix_id, 			 
xf_node.title AS nodeTitle, 
xf_user.user_id, 
xf_user.gender, 
xf_user.avatar_date	
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
WHERE xf_thread.title LIKE '%Deferred%'
AND xf_thread.title LIKE '%Compensation%'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND xf_thread.post_date >= ?
AND (xf_thread.node_id = 4 OR xf_thread.node_id = 8 OR xf_thread.node_id = 9 OR xf_thread.node_id = 34 OR xf_thread.node_id = 22 OR xf_thread.node_id = 24 OR xf_thread.node_id = 3 OR xf_thread.node_id = 40 OR xf_thread.node_id = 16 OR xf_thread.node_id = 30 OR xf_thread.node_id = 29 OR xf_thread.node_id = 28 OR xf_thread.node_id = 25 OR xf_thread.node_id = 89 OR xf_thread.node_id = 7 OR xf_thread.node_id = 23 OR xf_thread.node_id = 43 OR xf_thread.node_id = 11 OR xf_thread.node_id = 35 OR xf_thread.node_id = 36 OR xf_thread.node_id = 37 OR xf_thread.node_id = 47 OR xf_thread.node_id = 38 OR xf_thread.node_id = 90 OR xf_thread.node_id = 26 OR xf_thread.node_id = 19 OR xf_thread.node_id = 27 OR xf_thread.node_id = 33 OR xf_thread.node_id = 46 OR xf_thread.node_id = 45 OR xf_thread.node_id = 31 OR xf_thread.node_id = 32 OR xf_thread.node_id = 10 OR xf_thread.node_id = 17 OR xf_thread.node_id = 48 OR xf_thread.node_id = 44 OR xf_thread.node_id = 41 OR xf_thread.node_id = 21 OR xf_thread.node_id = 20 OR xf_thread.node_id = 5 OR xf_thread.node_id = 14 OR xf_thread.node_id = 13 OR xf_thread.node_id = 93 OR xf_thread.node_id = 18 OR xf_thread.node_id = 54 OR xf_thread.node_id = 68 OR xf_thread.node_id = 69 OR xf_thread.node_id = 71 OR xf_thread.node_id = 72 OR xf_thread.node_id = 73 OR xf_thread.node_id = 82 OR xf_thread.node_id = 84 OR xf_thread.node_id = 86 OR xf_thread.node_id = 74 OR xf_thread.node_id = 75 OR xf_thread.node_id = 78 OR xf_thread.node_id = 79 OR xf_thread.node_id = 80 OR xf_thread.node_id = 92 OR xf_thread.node_id = 77 OR xf_thread.node_id = 76 OR xf_thread.node_id = 70 OR xf_thread.node_id = 64 OR xf_thread.node_id = 66 OR xf_thread.node_id = 67 OR xf_thread.node_id = 81 OR xf_thread.node_id = 87 OR xf_thread.node_id = 85 OR xf_thread.node_id = 60)
AND xf_thread.thread_id <> '48574'

AND (xf_thread.node_id <> 8 AND xf_thread.node_id <> 9 AND xf_thread.node_id <> 34 AND xf_thread.node_id <> 22 AND xf_thread.node_id <> 24 AND xf_thread.node_id <> 10 AND xf_thread.node_id <> 17 AND xf_thread.node_id <> 48 AND xf_thread.node_id <> 14 AND xf_thread.node_id <> 13 AND xf_thread.node_id <> 18 AND xf_thread.node_id <> 12 AND xf_thread.node_id <> 15 AND xf_thread.node_id <> 39)

ORDER BY xf_thread.post_date DESC
LIMIT ?

Params: 0, 5

Run Time: 0.045548

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_thread	range	PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_date	post_date	4		14625	Using index condition; Using where
SIMPLE	xf_node	eq_ref	PRIMARY	PRIMARY	4	db25061_47.xf_thread.node_id	1
SIMPLE	xf_user	eq_ref	PRIMARY	PRIMARY	4	db25061_47.xf_thread.user_id	1

SELECT xf_thread.thread_id, 
xf_thread.node_id,
xf_thread.title, 
xf_thread.reply_count,
xf_thread.view_count, 
xf_thread.username, 
xf_thread.post_date,
xf_thread.last_post_date, 
xf_thread.last_post_user_id, 
xf_thread.last_post_username, 
xf_thread.prefix_id, 			 
xf_node.title AS nodeTitle, 
xf_user.user_id, 
xf_user.gender, 
xf_user.avatar_date		
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
WHERE xf_thread.title LIKE '%Deferred%'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND xf_thread.post_date >= ?
AND (xf_thread.node_id = 4 OR xf_thread.node_id = 8 OR xf_thread.node_id = 9 OR xf_thread.node_id = 34 OR xf_thread.node_id = 22 OR xf_thread.node_id = 24 OR xf_thread.node_id = 3 OR xf_thread.node_id = 40 OR xf_thread.node_id = 16 OR xf_thread.node_id = 30 OR xf_thread.node_id = 29 OR xf_thread.node_id = 28 OR xf_thread.node_id = 25 OR xf_thread.node_id = 89 OR xf_thread.node_id = 7 OR xf_thread.node_id = 23 OR xf_thread.node_id = 43 OR xf_thread.node_id = 11 OR xf_thread.node_id = 35 OR xf_thread.node_id = 36 OR xf_thread.node_id = 37 OR xf_thread.node_id = 47 OR xf_thread.node_id = 38 OR xf_thread.node_id = 90 OR xf_thread.node_id = 26 OR xf_thread.node_id = 19 OR xf_thread.node_id = 27 OR xf_thread.node_id = 33 OR xf_thread.node_id = 46 OR xf_thread.node_id = 45 OR xf_thread.node_id = 31 OR xf_thread.node_id = 32 OR xf_thread.node_id = 10 OR xf_thread.node_id = 17 OR xf_thread.node_id = 48 OR xf_thread.node_id = 44 OR xf_thread.node_id = 41 OR xf_thread.node_id = 21 OR xf_thread.node_id = 20 OR xf_thread.node_id = 5 OR xf_thread.node_id = 14 OR xf_thread.node_id = 13 OR xf_thread.node_id = 93 OR xf_thread.node_id = 18 OR xf_thread.node_id = 54 OR xf_thread.node_id = 68 OR xf_thread.node_id = 69 OR xf_thread.node_id = 71 OR xf_thread.node_id = 72 OR xf_thread.node_id = 73 OR xf_thread.node_id = 82 OR xf_thread.node_id = 84 OR xf_thread.node_id = 86 OR xf_thread.node_id = 74 OR xf_thread.node_id = 75 OR xf_thread.node_id = 78 OR xf_thread.node_id = 79 OR xf_thread.node_id = 80 OR xf_thread.node_id = 92 OR xf_thread.node_id = 77 OR xf_thread.node_id = 76 OR xf_thread.node_id = 70 OR xf_thread.node_id = 64 OR xf_thread.node_id = 66 OR xf_thread.node_id = 67 OR xf_thread.node_id = 81 OR xf_thread.node_id = 87 OR xf_thread.node_id = 85 OR xf_thread.node_id = 60)
AND xf_thread.thread_id <> '48574'

AND (xf_thread.node_id <> 8 AND xf_thread.node_id <> 9 AND xf_thread.node_id <> 34 AND xf_thread.node_id <> 22 AND xf_thread.node_id <> 24 AND xf_thread.node_id <> 10 AND xf_thread.node_id <> 17 AND xf_thread.node_id <> 48 AND xf_thread.node_id <> 14 AND xf_thread.node_id <> 13 AND xf_thread.node_id <> 18 AND xf_thread.node_id <> 12 AND xf_thread.node_id <> 15 AND xf_thread.node_id <> 39)


ORDER BY xf_thread.post_date DESC
LIMIT ?

Params: 0, 5

Run Time: 0.045620

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_thread	range	PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_date	post_date	4		14625	Using index condition; Using where
SIMPLE	xf_node	eq_ref	PRIMARY	PRIMARY	4	db25061_47.xf_thread.node_id	1
SIMPLE	xf_user	eq_ref	PRIMARY	PRIMARY	4	db25061_47.xf_thread.user_id	1

SELECT xf_thread.thread_id, 
xf_thread.node_id,
xf_thread.title, 
xf_thread.reply_count,
xf_thread.view_count, 
xf_thread.username, 
xf_thread.post_date, 
xf_thread.last_post_date, 
xf_thread.last_post_user_id, 
xf_thread.last_post_username, 
xf_thread.prefix_id, 			 
xf_node.title AS nodeTitle, 
xf_user.user_id, 
xf_user.gender, 
xf_user.avatar_date		
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
WHERE xf_thread.title LIKE '%Compensation%'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND xf_thread.post_date >= ?
AND (xf_thread.node_id = 4 OR xf_thread.node_id = 8 OR xf_thread.node_id = 9 OR xf_thread.node_id = 34 OR xf_thread.node_id = 22 OR xf_thread.node_id = 24 OR xf_thread.node_id = 3 OR xf_thread.node_id = 40 OR xf_thread.node_id = 16 OR xf_thread.node_id = 30 OR xf_thread.node_id = 29 OR xf_thread.node_id = 28 OR xf_thread.node_id = 25 OR xf_thread.node_id = 89 OR xf_thread.node_id = 7 OR xf_thread.node_id = 23 OR xf_thread.node_id = 43 OR xf_thread.node_id = 11 OR xf_thread.node_id = 35 OR xf_thread.node_id = 36 OR xf_thread.node_id = 37 OR xf_thread.node_id = 47 OR xf_thread.node_id = 38 OR xf_thread.node_id = 90 OR xf_thread.node_id = 26 OR xf_thread.node_id = 19 OR xf_thread.node_id = 27 OR xf_thread.node_id = 33 OR xf_thread.node_id = 46 OR xf_thread.node_id = 45 OR xf_thread.node_id = 31 OR xf_thread.node_id = 32 OR xf_thread.node_id = 10 OR xf_thread.node_id = 17 OR xf_thread.node_id = 48 OR xf_thread.node_id = 44 OR xf_thread.node_id = 41 OR xf_thread.node_id = 21 OR xf_thread.node_id = 20 OR xf_thread.node_id = 5 OR xf_thread.node_id = 14 OR xf_thread.node_id = 13 OR xf_thread.node_id = 93 OR xf_thread.node_id = 18 OR xf_thread.node_id = 54 OR xf_thread.node_id = 68 OR xf_thread.node_id = 69 OR xf_thread.node_id = 71 OR xf_thread.node_id = 72 OR xf_thread.node_id = 73 OR xf_thread.node_id = 82 OR xf_thread.node_id = 84 OR xf_thread.node_id = 86 OR xf_thread.node_id = 74 OR xf_thread.node_id = 75 OR xf_thread.node_id = 78 OR xf_thread.node_id = 79 OR xf_thread.node_id = 80 OR xf_thread.node_id = 92 OR xf_thread.node_id = 77 OR xf_thread.node_id = 76 OR xf_thread.node_id = 70 OR xf_thread.node_id = 64 OR xf_thread.node_id = 66 OR xf_thread.node_id = 67 OR xf_thread.node_id = 81 OR xf_thread.node_id = 87 OR xf_thread.node_id = 85 OR xf_thread.node_id = 60)
AND xf_thread.thread_id <> '48574'

AND (xf_thread.node_id <> 8 AND xf_thread.node_id <> 9 AND xf_thread.node_id <> 34 AND xf_thread.node_id <> 22 AND xf_thread.node_id <> 24 AND xf_thread.node_id <> 10 AND xf_thread.node_id <> 17 AND xf_thread.node_id <> 48 AND xf_thread.node_id <> 14 AND xf_thread.node_id <> 13 AND xf_thread.node_id <> 18 AND xf_thread.node_id <> 12 AND xf_thread.node_id <> 15 AND xf_thread.node_id <> 39)



ORDER BY xf_thread.post_date DESC
LIMIT ?

Params: 0, 5

Run Time: 0.045240

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_thread	range	PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_date	post_date	4		14625	Using index condition; Using where
SIMPLE	xf_node	eq_ref	PRIMARY	PRIMARY	4	db25061_47.xf_thread.node_id	1
SIMPLE	xf_user	eq_ref	PRIMARY	PRIMARY	4	db25061_47.xf_thread.user_id	1

INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)

Params: 8d23f8464db0475106eb1e8af800e33e, , 1566604675

Run Time: 0.000167

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=48574, 1566601075,

Run Time: 0.000198

```
SELECT *
	FROM EWRporta2_layouts
WHERE (layout_template = ?
	)
	AND active = 1
ORDER BY layout_priority ASC
```
Params: thread_view
Run Time: 0.000112
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE EWRporta2_layouts ref layout_template layout_template 302 const 1 Using index condition; Using where; Using filesort

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	EWRporta2_layouts	ref	layout_template	layout_template	302	const	1	Using index condition; Using where; Using filesort

SELECT EWRporta2_widlinks.*, EWRporta2_widgets.widget_values, EWRporta2_widopts.widopt_values,
	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.widopt_id, 0) AS widopt_id,
	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.locked, EWRporta2_widgets.locked) AS locked,
	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.display, EWRporta2_widgets.display) AS display,
	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.groups, EWRporta2_widgets.groups) AS groups,
	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.ctime, EWRporta2_widgets.ctime) AS ctime,
	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.cdate, EWRporta2_widgets.cdate) AS cdate,
	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.cache, EWRporta2_widgets.cache) AS cache
FROM EWRporta2_widlinks
	INNER JOIN EWRporta2_widgets ON (EWRporta2_widgets.widget_id = EWRporta2_widlinks.widget_id)
	LEFT JOIN EWRporta2_widopts ON (EWRporta2_widopts.widopt_id = EWRporta2_widlinks.widopt_id)
WHERE layout_id = ?
	AND EWRporta2_widgets.active = 1
ORDER by widlink_order

Params: thread_view

Run Time: 0.000249

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	EWRporta2_widlinks	ref	layout_id,widget_id	layout_id	302	const	20	Using index condition; Using where; Using filesort
SIMPLE	EWRporta2_widopts	eq_ref	PRIMARY	PRIMARY	4	db25061_47.EWRporta2_widlinks.widopt_id	1
SIMPLE	EWRporta2_widgets	eq_ref	PRIMARY	PRIMARY	302	db25061_47.EWRporta2_widlinks.widget_id	1	Using where

```
SELECT *
FROM bbm
ORDER BY tag
```
Run Time: 0.000333
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE bbm ALL 4 Using filesort
```
SELECT *
FROM xf_poll
WHERE poll_id = ?
```
Params: 0
Run Time: 0.000124
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE Impossible WHERE noticed after reading const tables

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	bbm	ALL					4	Using filesort

SELECT thread.*
	,
	user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
	last_post_user.gender AS last_post_gender,
	last_post_user.avatar_date AS last_post_avatar_date,
	last_post_user.gravatar AS last_post_gravatar,
	IF(last_post_user.username IS NULL, thread.last_post_username, last_post_user.username) AS last_post_username,
	node.title AS node_title, node.node_name,
	forum.*,
	forum.last_post_id AS forum_last_post_id,
	forum.last_post_date AS forum_last_post_date,
	forum.last_post_user_id AS forum_last_post_user_id,
	forum.last_post_username AS forum_last_post_username,
	forum.last_thread_title AS forum_last_thread_title,
	thread.last_post_id,
	thread.last_post_date,
	thread.last_post_user_id,
	thread.last_post_username,
	NULL AS thread_read_date,
	0 AS thread_is_watched,
	0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread

	LEFT JOIN xf_user AS user ON
		(user.user_id = thread.user_id)
	LEFT JOIN xf_user AS last_post_user ON
		(last_post_user.user_id = thread.last_post_user_id)
	LEFT JOIN xf_node AS node ON
		(node.node_id = thread.node_id)
	LEFT JOIN xf_forum AS forum ON
		(forum.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_type <> 'redirect') AND (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1565996275) AND (forum.find_new = 1) AND 1=1 AND thread.node_id IN ('24', '3', '40', '49', '16', '30', '29', '28', '25', '89', '7', '23', '43', '11', '35', '36', '37', '47', '38', '90', '26', '19', '27', '33', '46', '45', '31', '32', '10', '17', '48', '44', '41', '21', '20')
ORDER BY thread.last_post_date DESC
 LIMIT 20

Run Time: 0.001395

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	thread	range	node_id_last_post_date,node_id_sticky_state_last_post,last_post_date	last_post_date	4		73	Using index condition; Using where
SIMPLE	forum	eq_ref	PRIMARY	PRIMARY	4	db25061_47.thread.node_id	1	Using where
SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	db25061_47.thread.user_id	1
SIMPLE	last_post_user	eq_ref	PRIMARY	PRIMARY	4	db25061_47.thread.last_post_user_id	1
SIMPLE	node	eq_ref	PRIMARY	PRIMARY	4	db25061_47.thread.node_id	1
SIMPLE	permission	eq_ref	PRIMARY	PRIMARY	35	const,const,db25061_47.thread.node_id	1	Using where

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 16, 0

Run Time: 0.000082

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

```
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
```
Params: 1, node, 16
Run Time: 0.000075
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_cache_content const PRIMARY PRIMARY 35 const,const,const 1

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 7, 0

Run Time: 0.000073

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

```
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
```
Params: 1, node, 7
Run Time: 0.000074
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_cache_content const PRIMARY PRIMARY 35 const,const,const 1

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 11, 0

Run Time: 0.000070

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

```
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
```
Params: 1, node, 11
Run Time: 0.000067
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_cache_content const PRIMARY PRIMARY 35 const,const,const 1

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 21, 0

Run Time: 0.000069

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

```
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
```
Params: 1, node, 21
Run Time: 0.000070
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_cache_content const PRIMARY PRIMARY 35 const,const,const 1

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 37, 0

Run Time: 0.000069

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

```
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
```
Params: 1, node, 37
Run Time: 0.000068
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_cache_content const PRIMARY PRIMARY 35 const,const,const 1

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 43, 0

Run Time: 0.000069

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 16, 0

Run Time: 0.000069

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 31, 0

Run Time: 0.000069

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

```
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
```
Params: 1, node, 31
Run Time: 0.000068
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_cache_content const PRIMARY PRIMARY 35 const,const,const 1

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 43, 0

Run Time: 0.000069

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 43, 0

Run Time: 0.000069

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 11, 0

Run Time: 0.000069

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 16, 0

Run Time: 0.000069

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 11, 0

Run Time: 0.000068

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 7, 0

Run Time: 0.000070

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 11, 0

Run Time: 0.000068

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 30, 0

Run Time: 0.000072

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

```
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
```
Params: 1, node, 30
Run Time: 0.000068
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_cache_content const PRIMARY PRIMARY 35 const,const,const 1

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 11, 0

Run Time: 0.000068

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 21, 0

Run Time: 0.000069

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 7, 0

Run Time: 0.000077

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

    				SELECT forum_ban_expiry_date,forum_ban_conf
    				FROM xfa_extmod_forum_ban
    				WHERE forum_ban_user_id = ?
    					AND forum_ban_user_id = ?

Params: 28, 0

Run Time: 0.000070

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

```
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
	AND content_type = ?
	AND content_id = ?
```
Params: 1, node, 28
Run Time: 0.000068
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_cache_content const PRIMARY PRIMARY 35 const,const,const 1

                   SELECT content.*
                        ,
			album.category_id, album.album_state, album.album_type,
			album.content_count, album.photo_count, album.video_count, album.audio_count,
			album.album_privacy, album.album_location,
			album.cover_content_id, album.cover_content_type,
			album.latest_content_ids, album.latest_photo_ids, album.latest_video_ids, album.latest_audio_ids,
			album.album_date, album.album_updated_date,

			album.title AS album_title, album.description AS album_description,
			album.user_id AS album_user_id, album.username AS album_username,
			album.comment_count AS album_comment_count, 
			album.view_count AS album_view_count,
			album.likes AS album_likes, album.like_users AS album_like_users,
			album.latest_comment_ids AS album_latest_comment_ids,
			album.collection_id AS album_collection_id,

			category.category_privacy
			,
					0 AS following_0,
			IF(user.username IS NULL, content.username, user.username) AS username, user.avatar_date, user.gravatar,
			content_data.*,
			0 AS following_0
                   FROM `sonnb_xengallery_content` AS content
                    	
			INNER JOIN `sonnb_xengallery_album` AS album ON
				(album.album_id = content.album_id)

			LEFT JOIN `sonnb_xengallery_category` AS category ON
				(album.category_id = category.category_id)
			LEFT JOIN `xf_user` AS user ON
				(user.user_id = content.user_id)
			INNER JOIN `sonnb_xengallery_content_data` AS content_data ON
				(content.content_data_id = content_data.content_data_id)
                   WHERE (content.content_type = 'photo') AND (album.category_id = '1') AND (content.content_state = 'visible')
                    	ORDER BY content.view_count DESC, content.position ASC
                	 LIMIT 18

Run Time: 0.000464

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	album	ref	PRIMARY,category_update_date	category_update_date	4	const	46	Using temporary; Using filesort
SIMPLE	category	eq_ref	PRIMARY	PRIMARY	4	db25061_47.album.category_id	1
SIMPLE	content	ref	album_id_position	album_id_position	4	db25061_47.album.album_id	7	Using where
SIMPLE	content_data	eq_ref	PRIMARY,content_type_id	PRIMARY	4	db25061_47.content.content_data_id	1
SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	db25061_47.content.user_id	1

SELECT options.*, node.*,
	permission.cache_value AS node_permission_cache
FROM nat_options AS options
INNER JOIN xf_node AS node
	ON (node.node_id = options.node_id)
LEFT JOIN xf_permission_cache_content AS permission
	ON (permission.permission_combination_id = ?
	AND permission.content_type = 'node'
	AND permission.content_id = options.node_id)
WHERE nat_display_tab = 1
ORDER BY options.nat_display_order
ASC

Params: 1

Run Time: 0.000277

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	options	ALL	node_id				45	Using where; Using filesort
SIMPLE	node	eq_ref	PRIMARY	PRIMARY	4	db25061_47.options.node_id	1
SIMPLE	permission	eq_ref	PRIMARY	PRIMARY	35	const,const,db25061_47.options.node_id	1	Using where

SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
	permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
	ON (permission.permission_combination_id = ?
	AND permission.content_type = 'node'
	AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (68, 69, 71, 72, 73)
ORDER BY node.lft
ASC

Params: 1

Run Time: 0.000135

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	node	range	PRIMARY	PRIMARY	4		5	Using where; Using filesort
SIMPLE	permission	eq_ref	PRIMARY	PRIMARY	35	const,const,db25061_47.node.node_id	1	Using where
SIMPLE	options	eq_ref	node_id	node_id	4	db25061_47.node.node_id	1

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'quattro_bbcode_xtable', 'bbm_viewer_content_protected', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'sonnb_xengallery_bbcode_photo', 'sonnb_xengallery_bbcode_video', 'sonnb_xengallery_bbcode_album', 'doublepost_bb_code_tag', '__bbm_tool_template', 'EWRwidget_PollBlock', 'EWRwidget_RawHtml', 'EWRwidget_Threads', 'EWRwidget_FbLikeBox', 'EWRwidget_TwTimeline', 'EWRwidget_sonnbXenGalleryPhoto', 'thread_view', 'nat_childlinks')
	AND style_id = ?
	AND language_id = ?

Params: 2, 4

Run Time: 0.000535

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

```
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
	AND title IN ('atendo2_calendar', 'ld_nav_title')
```
Params: 4
Run Time: 0.000086
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_phrase_compiled range PRIMARY PRIMARY 106 2 Using where

SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
	permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
	ON (permission.permission_combination_id = ?
	AND permission.content_type = 'node'
	AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (66, 67, 81, 87, 85, 60)
ORDER BY node.lft
ASC

Params: 1

Run Time: 0.000149

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	node	range	PRIMARY	PRIMARY	4		6	Using where; Using filesort
SIMPLE	permission	eq_ref	PRIMARY	PRIMARY	35	const,const,db25061_47.node.node_id	1	Using where
SIMPLE	options	eq_ref	node_id	node_id	4	db25061_47.node.node_id	1

SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
	permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
	ON (permission.permission_combination_id = ?
	AND permission.content_type = 'node'
	AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (75, 78, 79, 80, 92, 77, 76)
ORDER BY node.lft
ASC

Params: 1

Run Time: 0.000144

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	node	range	PRIMARY	PRIMARY	4		7	Using where; Using filesort
SIMPLE	permission	eq_ref	PRIMARY	PRIMARY	35	const,const,db25061_47.node.node_id	1	Using where
SIMPLE	options	eq_ref	node_id	node_id	4	db25061_47.node.node_id	1

SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
	permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
	ON (permission.permission_combination_id = ?
	AND permission.content_type = 'node'
	AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (84, 86)
ORDER BY node.lft
ASC

Params: 1

Run Time: 0.000135

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	node	range	PRIMARY	PRIMARY	4		2	Using where; Using filesort
SIMPLE	permission	eq_ref	PRIMARY	PRIMARY	35	const,const,db25061_47.node.node_id	1	Using where
SIMPLE	options	eq_ref	node_id	node_id	4	db25061_47.node.node_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000609

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('notice_cookies', 'EWRporta2_Navtabs', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', 'sonnb_xengallery_navbar_template', 'dark_taigachat_links', 'EWRatendo2_Navtabs', 'nat_linkstemplate', 'ld_sub_nav', 'sonnb_xengallery_nav_visitor', 'dark_taigachat', 'dark_taigachat_list', 'GritterNotifications', 'PAGE_CONTAINER', 'waindigo_thread_view_tabs_library')
	AND style_id = ?
	AND language_id = ?

Params: 2, 4

Run Time: 0.000264

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

```
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('ld_thread_view_tools_links')
	AND style_id = ?
	AND language_id = ?
```
Params: 2, 4
Run Time: 0.000080
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_template_compiled const PRIMARY PRIMARY 60 const,const,const 1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000432

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000390

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000384

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000371

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000361

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000356

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000365

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000357

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000353

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000350

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000358

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000352

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000348

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000361

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

```
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbm_js')
	AND style_id = ?
	AND language_id = ?
```
Params: 2, 4
Run Time: 0.000120
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_template_compiled const PRIMARY PRIMARY 60 const,const,const 1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000422

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000404

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000433

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000515

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000378

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000425

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000399

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000440

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

SELECT advertisement.*
	,
		zone.*,
		zone.name AS zone_name,
		purchase.*
FROM admon_advertisement AS advertisement
	
		LEFT JOIN admon_advertisement_zone AS zone ON
			(zone.zone_id = advertisement.advertisement_zone)
		LEFT JOIN admon_advertisement_purchase AS purchase ON
			(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1566601075 AND advertisement.end_date > 1566601075))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))

Run Time: 0.000373

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	advertisement	ALL					1	Using where
SIMPLE	zone	eq_ref	PRIMARY	PRIMARY	52	db25061_47.advertisement.advertisement_zone	1	Using where
SIMPLE	purchase	eq_ref	PRIMARY	PRIMARY	4	db25061_47.advertisement.purchase_id	1

```
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRAFR_navigation_tabs_link')
	AND style_id = ?
	AND language_id = ?
```
Params: 2, 4
Run Time: 0.000086
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_template_compiled const PRIMARY PRIMARY 60 const,const,const 1
```
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('nat_bodyjs')
	AND style_id = ?
	AND language_id = ?
```
Params: 2, 4
Run Time: 0.000092
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_template_compiled const PRIMARY PRIMARY 60 const,const,const 1

Included Files (263, XenForo Classes: 75)

index.php
library/XenForo/Autoloader.php
library/XenForo/Application.php
library/Zend/Registry.php
library/Lgpl/utf8.php
library/Zend/Config.php
library/config.php
library/XenForo/FrontController.php
library/XenForo/Dependencies/Public.php
library/XenForo/Dependencies/Abstract.php
library/Zend/Controller/Request/Http.php
library/Zend/Controller/Request/Abstract.php
library/Zend/Uri.php
library/Zend/Controller/Response/Http.php
library/Zend/Controller/Response/Abstract.php
library/XenForo/Model/DataRegistry.php
library/XenForo/Model.php
library/Zend/Db.php
library/Zend/Db/Adapter/Mysqli.php
library/Zend/Db/Adapter/Abstract.php
library/Zend/Db/Select.php
library/Zend/Db/Expr.php
library/Zend/Db/Profiler.php
library/Zend/Db/Statement/Mysqli.php
library/Zend/Db/Statement.php
library/Zend/Db/Statement/Interface.php
library/Zend/Db/Profiler/Query.php
library/XenForo/CodeEvent.php
library/XenForo/Options.php
library/XenForo/Link.php
library/XenForo/Template/Helper/Core.php
library/phc/EUCookie/Listener/Listener.php
library/XenForo/ControllerPublic/Abstract.php
library/XenForo/Controller.php
library/phc/EUCookie/Extend/XenForo/Helper/Cookie.php
library/phc/LinkDirectory/Listener/Listener.php
library/EWRatendo2/Listener/Init.php
library/TPUSigPic/Listener.php
library/Waindigo/Listener/InitDependencies.php
library/Waindigo/Listener/InitDependencies/20150106.php
library/XenDACH/GDPR/Listener.php
library/Waindigo/Listener/ControllerPreDispatch/20150106.php
library/EWRporta2/Listener/Init.php
library/XFA/ExtendedModeration/Proxy.php
library/Brivium/BriviumHelper/EventListeners.php
library/Brivium/BriviumHelper/1010071/EventListeners.php
library/TMS/Listener.php
library/sonnb/XenGallery/Listener.php
library/bdPaygate/Listener.php
library/Dark/TaigaChat/EventListener/Listener.php
library/phc/HideLinks/Listener/Listener.php
library/BBM/Listeners/AllInOne.php
library/Waindigo/Library/Listener/InitDependencies.php
library/XenForo/CacheRebuilder/Abstract.php
library/NodesAsTabs/Listen.php
library/Audentio/AdManager/Listener/CodeEvent.php
library/bdPaygate/ShippableHelper/Updater.php
library/bdPaygate/Option.php
library/Sedo/TinyQuattro/Listener/AllInOne.php
library/XenForo/Router.php
library/XenForo/Route/Filter.php
library/XenForo/Route/Interface.php
library/XenForo/Route/ResponseSuffix.php
library/XenForo/Route/Prefix.php
library/XenForo/Route/Prefix/Threads.php
library/XenForo/RouteMatch.php
library/BBM/Protection/Helper/ContentProtection.php
library/XenForo/ControllerPublic/Thread.php
library/Waindigo/Library/Listener/LoadClass.php
library/Waindigo/Listener/LoadClass.php
library/Waindigo/Listener/LoadClass/20150106.php
library/TagEss/Listener.php
library/WMTech/UserSelfDeleteLite/Listener.php
library/LimitLanguageUsage/Static.php
library/sonnbSmilesBulkImporter/Listener.php
library/EWRatendo2/Listener/Controller.php
library/EndlessHorizon/AdvOG/Listener.php
library/WMTech/DoublePost/Listener.php
library/EWRporta2/Listener/Controller.php
library/RainDD/UserActivity/Listener.php
library/Andy/SimilarThreads/Listener.php
library/ChangeThreadStarter/Listener.php
library/HidePollResults/Listener.php
library/Waindigo/Library/Extend/XenForo/ControllerPublic/Thread.php
library/Audentio/AdManager/Extend/XenForo/ControllerPublic/Thread.php
library/TagEss/XenForo/ControllerPublic/Thread.php
library/phc/LinkDirectory/Extend/XenForo/ControllerPublic/Thread.php
library/Brivium/AdvancedRules/ControllerPublic/Thread.php
library/sonnb/XenGallery/XenForo/ControllerPublic/Thread.php
library/NodesAsTabs/ControllerPublic/Thread.php
library/EWRatendo2/ControllerPublic/Thread.php
library/EndlessHorizon/AdvOG/ControllerPublic/Thread.php
library/WMTech/DoublePost/ControllerPublic/Thread.php
library/EWRporta2/ControllerPublic/Thread.php
library/XFA/ExtendedModeration/ControllerPublic/Thread.php
library/RainDD/UserActivity/Controller/ThreadViewers.php
library/RainDD/UserActivity/Controller/ThreadReaders.php
library/Andy/SimilarThreads/ControllerPublic/Thread.php
library/ChangeThreadStarter/ControllerPublic/Thread.php
library/HidePollResults/ControllerPublic/Thread.php
library/XenForo/Input.php
library/XenForo/Session.php
library/XenForo/Helper/Ip.php
library/XenForo/Visitor.php
library/XenForo/Model/User.php
library/EWRporta2/Listener/Model.php
library/SV/CanWarnStaff/Listener.php
library/sonnb/XenGallery/XenForo/Model/User.php
library/EWRporta2/Model/User.php
library/XFA/ExtendedModeration/Model/User.php
library/SV/CanWarnStaff/XenForo/Model/User.php
library/XenForo/Permission.php
library/XenForo/Helper/Php.php
library/XenForo/Phrase.php
library/XenForo/Locale.php
library/XFA/ExtendedModeration/Visitor.php
library/EWRatendo2/Model/Perms.php
library/EWRporta2/Model/Perms.php
library/GritterNotifications/Listener.php
library/UnreadPostCount/Listener.php
library/TemplateSyntax/Listen.php
library/XenForo/ControllerHelper/ForumThreadPost.php
library/XenForo/ControllerHelper/Abstract.php
library/XenForo/Model/Thread.php
library/Waindigo/IgnoreNewPosts/Listener/LoadClass.php
library/Waindigo/IgnoreNewPosts/Extend/XenForo/Model/Thread.php
library/Waindigo/Library/Extend/XenForo/Model/Thread.php
library/bdPaygate/XenForo/Model/Thread.php
library/XFA/ExtendedModeration/Model/Thread.php
library/UnreadPostCount/Model/Thread.php
library/SV/CanWarnStaff/XenForo/Model/Thread.php
library/TagEss/XenForo/Model/Thread.php
library/XenForo/Model/Forum.php
library/XFA/ExtendedModeration/Model/Forum.php
library/XenForo/Helper/String.php
library/XenForo/Model/Post.php
library/phc/HideLinks/Extend/Model/Post.php
library/EWRporta2/Model/Post.php
library/XFA/ExtendedModeration/Model/Post.php
library/SV/CanWarnStaff/XenForo/Model/Post.php
library/EWRporta2/Model/Articles.php
library/XenForo/Model/Attachment.php
library/XFA/ExtendedModeration/Model/Attachment.php
library/XenForo/Model/Node.php
library/XenForo/Route/Prefix/Categories.php
library/XenForo/Route/Prefix/Forums.php
library/XenForo/ControllerResponse/View.php
library/XenForo/ControllerResponse/Abstract.php
library/EndlessHorizon/AdvOG/Model/Log.php
library/EWRporta2/Model/Features.php
library/Andy/SimilarThreads/Model.php
library/XenForo/NodeHandler/Category.php
library/XenForo/NodeHandler/Abstract.php
library/XenForo/NodeHandler/Forum.php
library/Waindigo/Library/NodeHandler/Library.php
library/XenForo/NodeHandler/LinkForum.php
library/XenForo/NodeHandler/Page.php
library/XenForo/Model/Category.php
library/Waindigo/Library/Model/Library.php
library/XenForo/Model/LinkForum.php
library/XenForo/Model/Page.php
library/XenForo/Db.php
library/NodesAsTabs/API.php
library/NodesAsTabs/Model/Options.php
library/XenForo/ViewRenderer/HtmlPublic.php
library/XenForo/ViewRenderer/Abstract.php
library/XenForo/Template/Public.php
library/XenForo/Template/Abstract.php
library/XenForo/ViewPublic/Thread/View.php
library/XenForo/ViewPublic/Base.php
library/XenForo/View.php
library/EWRporta2/Listener/ViewPublic.php
library/ControlNoFollow/Listener.php
library/EWRporta2/ViewPublic/Global.php
library/ControlNoFollow/ViewPublic/Thread/View.php
library/phc/HideLinks/Extend/ViewPublic/Threads.php
library/EWRporta2/Model/Layouts.php
library/EWRporta2/Model/Widlinks.php
library/XenForo/BbCode/Parser.php
library/XenForo/BbCode/Formatter/Base.php
library/Waindigo/KeywordReplace/Listener/LoadClass.php
library/EWRatendo2/Listener/BbCode.php
library/EWRporta2/Listener/BbCode.php
library/Waindigo/KeywordReplace/Extend/XenForo/BbCode/Formatter/Base.php
library/Audentio/AdManager/Extend/XenForo/BbCode/Formatter/Base.php
library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
library/phc/HideLinks/Extend/BbCode/Formatter/Base.php
library/EWRatendo2/BbCode/Formatter.php
library/WMTech/DoublePost/BbCode/Formatter/Base.php
library/TPUSigPic/BbCodeFormatterBase.php
library/EWRporta2/BbCode/Formatter.php
library/BBM/BbCode/Formatter/Base.php
library/Sedo/TinyQuattro/BbCode/Formatter/Base.php
library/BBM/Helper/Bbm.php
library/BBM/Model/BbCodes.php
library/Sedo/TinyQuattro/Helper/Quattro.php
library/Sedo/TinyQuattro/Helper/BbCodes.php
library/rellect/AdblockDetector/Listener/Hook.php
library/XFA/ExtendedModeration/Template.php
library/EWRporta2/Widget/PollBlock.php
library/XenForo/Model/Poll.php
library/HidePollResults/Model/Poll.php
library/EWRporta2/Widget/Threads.php
library/XenForo/Model/PermissionCache.php
library/XenForo/Helper/Discussion.php
library/EWRporta2/Widget/TwTimeline.php
library/EWRporta2/Widget/sonnbXenGalleryPhoto.php
library/sonnb/XenGallery/Model/Content.php
library/sonnb/XenGallery/Model/Abstract.php
library/sonnb/XenGallery/Model/Photo.php
library/sonnb/XenGallery/Model/Collection.php
library/sonnb/XenGallery/Route/Prefix/XenGallery.php
library/sonnb/XenGallery/Model/ContentData.php
library/sonnb/XenGallery/Model/Video.php
library/sonnb/XenGallery/Model/Album.php
library/sonnb/XenGallery/Model/Category.php
library/sonnb/XenGallery/Model/Gallery.php
library/XenForo/ViewPublic/Helper/Message.php
library/XenForo/BbCode/TextWrapper.php
library/phc/HideLinks/Helper/Helper.php
library/phc/HideLinks/Model/HideLinks.php
library/Waindigo/KeywordReplace/Helper/String.php
library/Audentio/AdManager/Helper/String.php
library/Audentio/AdManager/Model/Advertisement.php
library/XenForo/Route/Prefix/Members.php
library/memberMap/Listener/Navigation.php
library/memberMap/Model/ViewMap.php
library/EWRporta2/Listener/NavTabs.php
library/XenDACH/GDPR/Listener/LegalPolicy.php
library/Dark/TaigaChat/EventListener/NavigationTabs.php
library/EWRatendo2/Listener/NavTabs.php
library/phc/LinkDirectory/Model/Links.php
library/phc/LinkDirectory/Route/Prefix/LD.php
library/NodesAsTabs/NavTabs.php
library/XenForo/Route/Prefix/LinkForums.php
library/ITM/ctSSB/Listener.php
library/SolidMean/ForumBackup/Listener/Template.php
library/Waindigo/Library/Listener/TemplatePostRender.php
library/Waindigo/Listener/TemplatePostRender.php
library/Waindigo/Listener/TemplatePostRender/20140711.php
library/Waindigo/Listener/Template.php
library/Waindigo/Listener/Template/20141020.php
library/Waindigo/Library/Route/Prefix/Libraries.php
library/XenForo/Route/Prefix/Pages.php
library/rellect/AdblockDetector/Model/AdBlock.php
library/Sedo/TinyQuattro/Listener/Templates/Preloader.php
library/XenForo/Route/Prefix/Tags.php
library/Brivium/AdvancedRules/Listener.php
library/EWRporta2/Listener/Template.php
library/XenFacil/BirthdayGreetings/Listener/Listener.php
library/Waindigo/Library/Listener/TemplateHook.php
library/Waindigo/Listener/TemplateHook.php
library/Waindigo/Listener/TemplateHook/20141020.php
library/Audentio/AdManager/Template/Helper/Core.php
library/XenForo/Route/Prefix/Posts.php
library/XenForo/Model/Avatar.php
library/XenForo/Helper/Criteria.php
library/XenForo/Debug.php
library/BBM/Helper/BbCodes.php
library/BBM/Listeners/Templates/Public.php
library/XenForo/ViewRenderer/Json.php
library/GritterNotifications/Template/Callback.php
library/GritterNotifications/Model/Notification.php