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

Params: 10, 1

Run Time: 0.000141

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 *
FROM `xf_widgetframework_cache`
WHERE cache_id IN ('forum_view_pc1', 'forum_view')

Run Time: 0.000426

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 > 1519273065)
ORDER BY session_activity.view_date DESC