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 * FROM phc_kwm_slugs WHERE slug = ? LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT * FROM `xf_widget` WHERE `widget_page_id` = 0 ORDER BY display_order ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_widget | ALL | 17 | Using where; Using filesort |
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 > 1717435659) 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 | 2274 | Using where; Using filesort | |||
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 |