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

Run Time: 0.000969

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

session_activity

range

view_date

view_date

4

20

Using where

SIMPLE

user

eq_ref

PRIMARY

PRIMARY

4

isoft_biz_b67c.session_activity.user_id

1

SELECT data_value
FROM xf_data_registry
WHERE data_key = ?

Params: boardTotals

Run Time: 0.000084

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_data_registry

const

PRIMARY

PRIMARY

27

const

1

SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('members_online_now', 'forum_statistics')