SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | 39 | Using where |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('nfDiscordConfigured')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
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 `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`username` IN ('Matt Derrick'))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | username | username | 202 | const | 1 |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.* FROM `xf_forum` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | 57 | |||||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_forum.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,squattheplanet.xf_node_Node_1.node_id | 1 | Using where |
SELECT search_index.content_type, search_index.content_id FROM xf_search_index AS search_index WHERE MATCH(search_index.title, search_index.metadata) AGAINST ('+_md_thread_19253 -_md_node_17 -_md_node_34 -_md_node_49 -_md_node_81 -_md_node_84 -_md_node_225 -_md_node_354 -_md_node_387 -_md_node_430 -_md_node_431 -_md_node_461 -_md_node_462 -_md_hidden_1 +_md_user_1 +(_md_content_post _md_content_thread)' IN BOOLEAN MODE) ORDER BY search_index.item_date DESC LIMIT 250
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | search_index | fulltext | title_metadata | title_metadata | 0 | 1 | Using where; Using filesort |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?