SELECT COUNT(*) AS total
FROM EWRrio_streams
LEFT JOIN EWRrio_games ON (EWRrio_games.game_id = EWRrio_streams.game_id)

Run Time: 0.000084

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

EWRrio_streams

ALL

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 (92, 93, 95, 89)
ORDER BY node.lft
ASC

SELECT count_given as rating_count, rating, 1 as given
FROM dark_postrating_count
WHERE user_id = ?
UNION
SELECT count_received as rating_count, rating, 0 as given
FROM dark_postrating_count
WHERE user_id = ?
ORDER BY rating_count desc, rating asc

SELECT count_given as rating_count, rating, 1 as given
FROM dark_postrating_count
WHERE user_id = ?
UNION
SELECT count_received as rating_count, rating, 0 as given
FROM dark_postrating_count
WHERE user_id = ?
ORDER BY rating_count desc, rating asc

Params: 835, 835

Run Time: 0.000084

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

PRIMARY

dark_postrating_count

ref

user_id_rating

user_id_rating

4

const

1

UNION

dark_postrating_count

ref

user_id_rating

user_id_rating

4

const

1

UNION RESULT

<union1,2>

ALL

Using filesort

SELECT COUNT(*)
FROM xf_liked_content
WHERE like_user_id = ?

Params: 835

Run Time: 0.000062

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_liked_content

ref

like_user_content_type_id

like_user_content_type_id

4

const

1

Using index

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