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 xf_node WHERE display_in_list = 1 ORDER BY lft ASC
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_node | ref | display_in_list | display_in_list | 1 | const | 16 | Using where |
SELECT cache_value
FROM xf_permission_cache_content_type
WHERE permission_combination_id = ?
AND content_type = 'node'| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_permission_cache_content_type | const | PRIMARY | PRIMARY | 81 | const,const | 1 |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
INSERT INTO xf_session_activity (user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date) VALUES (?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE ip = VALUES(ip), controller_name = VALUES(controller_name), controller_action = VALUES(controller_action), view_state = VALUES(view_state), params = VALUES(params), view_date = VALUES(view_date)
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'quick_navigation_menu', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | 3 | Using where |