SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.000640
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000307
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
Run Time: 0.000399
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 94 | Using where; Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000292
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 242 | Using where |
SELECT prefix.*
FROM xf_thread_prefix AS prefix
WHERE 1=1
ORDER BY prefix.materialized_order
Run Time: 0.000222
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | prefix | ALL | | | | | 1 | Using filesort |
SELECT field.*
FROM xf_thread_field AS field
WHERE 1=1
ORDER BY field.materialized_order
Run Time: 0.000390
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 90 | Using filesort |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 748804aaa7c66dcc7c6722b189b8b55d, a:6:{s:12:"sessionStart";i:1713566370;s:2:"ip";b:0;s:11:"sessionCsrf";s:16:"Kv6b1rz1TFBrU8at";s:9:"userAgent";s:103:"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;}, 1713569970
Run Time: 0.000295
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
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),
robot_key = VALUES(robot_key)
Params: 0, , , XenForo_ControllerPublic_Search, Index, valid, , 1713566370,
Run Time: 0.000205
SELECT node.*
FROM xf_node AS node
WHERE node.node_id = ?
Params: 17
Run Time: 0.000259
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'search_form_post', 'wf_home_navtab_links', 'mkdgCatalog_Links', 'Counters', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.000259
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 8 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('thread_field_label_desc', 'thread_field_model_Acura_desc', 'thread_field_model_Alfa_Romeo_desc', 'thread_field_model_Alpina_desc', 'thread_field_model_Aston_Martin_desc', 'thread_field_model_Audi_desc', 'thread_field_model_Bentley_desc', 'thread_field_model_BMW_desc', 'thread_field_model_Bugatti_desc', 'thread_field_model_Cadillac_desc', 'thread_field_model_Chery_desc', 'thread_field_model_Chevrolet_desc', 'thread_field_model_Chrysler_desc', 'thread_field_model_Citroen_desc', 'thread_field_model_Dacia_desc', 'thread_field_model_Daewoo_desc', 'thread_field_model_Daihatsu_desc', 'thread_field_model_Daimler_desc', 'thread_field_model_Dodge_desc', 'thread_field_model_Ferrari_desc', 'thread_field_model_Fiat_desc', 'thread_field_model_Ford_desc', 'thread_field_model_gaz_desc', 'thread_field_model_Geely_desc', 'thread_field_model_GMC_desc', 'thread_field_model_Great_Wall_desc', 'thread_field_model_Honda_desc', 'thread_field_model_Hummer_desc', 'thread_field_model_Hyundai_desc', 'thread_field_model_Infiniti_desc', 'thread_field_model_Isuzu_desc', 'thread_field_model_Jaguar_desc', 'thread_field_model_Jeep_desc', 'thread_field_model_Kia_desc', 'thread_field_model_Lamborghini_desc', 'thread_field_model_Lancia_desc', 'thread_field_model_Land_Rover_desc', 'thread_field_model_Lexus_desc', 'thread_field_model_Lincoln_desc', 'thread_field_model_Lotus_desc', 'thread_field_model_Maserati_desc', 'thread_field_model_Maybach_desc', 'thread_field_model_Mazda_desc', 'thread_field_model_Mercedes_desc', 'thread_field_model_Mercury_desc', 'thread_field_model_Mini_desc', 'thread_field_model_Mitsubishi_desc', 'thread_field_model_moscvitch_desc', 'thread_field_model_Nissan_desc', 'thread_field_model_Opel_desc', 'thread_field_model_Peugeot_desc', 'thread_field_model_Pontiac_desc', 'thread_field_model_Porsche_desc', 'thread_field_model_Renault_desc', 'thread_field_model_Rolls_Royce_desc', 'thread_field_model_Rover_desc', 'thread_field_model_Saab_desc', 'thread_field_model_SEAT_desc', 'thread_field_model_seaz_desc', 'thread_field_model_Skoda_desc', 'thread_field_model_Smart_desc', 'thread_field_model_SsangYong_desc', 'thread_field_model_Subaru_desc', 'thread_field_model_Suzuki_desc', 'thread_field_model_tagaz_desc', 'thread_field_model_Toyota_desc', 'thread_field_model_uaz_desc', 'thread_field_model_vaz_desc', 'thread_field_model_Volkswagen_desc', 'thread_field_model_Volvo_desc', 'thread_field_model_zaz_desc', 'thread_field_price_desc', 'thread_field_year_desc', 'thread_field_body_desc', 'thread_field_drive_desc', 'thread_field_color_desc', 'thread_field_engine_desc', 'thread_field_fuel_desc', 'thread_field_power_desc', 'thread_field_interior_desc', 'thread_field_gearbox_desc', 'thread_field_region_desc', 'thread_field_wheel_type_desc', 'thread_field_wheel_season_desc', 'catalog')
Params: 2
Run Time: 0.000224
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 85 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('mkdg_waindigo_create_thread_customfields')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.000123
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('mkdgCatalog_TopLinks')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.000128
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('MKDG_navigation_visitor_tab_top')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.000128
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |