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

Run Time: 0.000286

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 temporary; Using filesort

SELECT COUNT(*)
FROM xf_liked_content
WHERE like_user_id = ?

Params: 3303

Run Time: 0.000203

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

Run Time: 0.000181

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 temporary; Using filesort

SELECT COUNT(*)
FROM xf_liked_content
WHERE like_user_id = ?

Params: 3303

Run Time: 0.000133

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 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