SELECT *
FROM `xf_widgetframework_cache`
WHERE cache_id IN ('thread_view_pc1', 'thread_view')

Run Time: 0.000191

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_widgetframework_cache

range

PRIMARY

PRIMARY

767

2

Using where

SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1521509430)
ORDER BY session_activity.view_date DESC

Run Time: 0.003159

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

session_activity

range

view_date

view_date

4

264

Using where

SIMPLE

user

eq_ref

PRIMARY

PRIMARY

4

gotitans.session_activity.user_id

1

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