SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT session_activity.* , user.*, user_profile.*, user_option.* FROM xf_session_activity AS session_activity LEFT JOIN xf_user AS user ON (user.user_id = session_activity.user_id) LEFT JOIN xf_user_profile AS user_profile ON (user_profile.user_id = user.user_id) LEFT JOIN xf_user_option AS user_option ON (user_option.user_id = user.user_id) WHERE (session_activity.view_date > 1614991772) ORDER BY session_activity.view_date DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | session_activity | ALL | view_date | 342 | Using where; Using filesort | |||
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | smsmast_xenforo.session_activity.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | smsmast_xenforo.user.user_id | 1 | Using where |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | smsmast_xenforo.user.user_id | 1 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('home', 'dark_shoutbox', 'media')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 231 | 3 | Using where |