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

Params: 28, 1

Run Time: 0.000238

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 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: 2389, 2389

Run Time: 0.000684

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

PRIMARY

dark_postrating_count

ref

user_id_rating,user_id

user_id_rating

4

const

15

UNION

dark_postrating_count

ref

user_id_rating,user_id

user_id_rating

4

const

15

UNION RESULT

<union1,2>

ALL

Using filesort

SELECT COUNT(*)
FROM xf_liked_content
WHERE like_user_id = ?

Params: 2389

Run Time: 0.000765

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

1425

Using index

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