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.000219
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.000081
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user_field.*
FROM xf_user_field AS user_field
WHERE (user_field.required = 1 OR user_field.show_registration = 1)
ORDER BY user_field.display_group, user_field.display_order
Run Time: 0.000119
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_field | ALL | | | | | 4 | Using where; Using filesort |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 427024dcf39b51d840b3d851e7b7ad10, , 1713494622
Run Time: 0.000122
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_Register, Index, valid, , 1713451422,
Run Time: 0.000070
SELECT *
FROM xf_captcha_question
WHERE active = 1
ORDER BY RAND()
Run Time: 0.000495
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_captcha_question | ref | active | active | 1 | const | 1 | Using temporary; Using filesort |
INSERT INTO `xf_captcha_log` (`hash`, `captcha_type`, `captcha_data`, `captcha_date`) VALUES (?, ?, ?, ?)
Params: 752f5ef5f28177ba916e2ae82f6382988e183718, Question, 1, 1713451422
Run Time: 0.001907
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'captcha_question', 'register_form', 'siropu_custom_tabs_child_list', 'dark_taigachat', 'dark_taigachat_list', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000140
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 7 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('user_field_uydu_alicisi_desc', 'utc_1100_american_samoa', 'utc_1000_hawaii', 'utc_0930_marquesas_islands', 'utc_0900_alaska', 'utc_0800_pacific_time', 'utc_0800_baja_california', 'utc_0800_tijuana', 'utc_0700_mountain_time', 'utc_0700_chihuahua', 'utc_0700_arizona', 'utc_0600_central_time', 'utc_0600_saskatchewan', 'utc_0600_guadalajara', 'utc_0600_easter_island', 'utc_0500_eastern_time', 'utc_0500_cuba', 'utc_0500_bogota', 'utc_0430_caracas', 'utc_0400_atlantic_time_canada', 'utc_0400_atlantic_time_goose_bay', 'utc_0400_asuncion', 'utc_0400_santiago', 'utc_0400_cuiaba', 'utc_0400_georgetown', 'utc_0330_newfoundland', 'utc_0300_buenos_aires', 'utc_0300_san_luis', 'utc_0300_argentina', 'utc_0300_falkland_islands', 'utc_0300_greenland', 'utc_0300_montevideo', 'utc_0300_brasilia', 'utc_0300_miquelon', 'utc_0200_mid_atlantic', 'utc_0100_cape_verde', 'utc_0100_azores', 'utc_dublin', 'utc_casablanca', 'utc_monrovia', 'utc_plus_0100_central_european_time', 'utc_plus_0100_west_central_africa', 'utc_plus_0100_windhoek', 'utc_plus_0100_tunis', 'utc_plus_0200_eastern_european_time', 'utc_plus_0200_south_africa_standard_time', 'utc_plus_0200_kaliningrad', 'utc_plus_0200_amman', 'utc_plus_0200_beirut', 'utc_plus_0200_cairo', 'utc_plus_0200_jerusalem', 'utc_plus_0200_gaza', 'utc_plus_0200_syria', 'utc_plus_0300_moscow', 'utc_plus_0300_minsk', 'utc_plus_0300_baghdad', 'utc_plus_0330_tehran', 'utc_plus_0400_abu_dhabi', 'utc_plus_0400_yerevan', 'utc_plus_0400_baku', 'utc_plus_0400_mauritius', 'utc_plus_0430_kabul', 'utc_plus_0500_ekaterinburg', 'utc_plus_0500_tashkent', 'utc_plus_0530_chennai', 'utc_plus_0545_kathmandu', 'utc_plus_0600_novosibirsk', 'utc_plus_0600_astana', 'utc_plus_0600_almaty', 'utc_plus_0630_yangon', 'utc_plus_0700_krasnoyarsk', 'utc_plus_0700_bangkok', 'utc_plus_0800_irkutsk', 'utc_plus_0800_beijing', 'utc_plus_0800_kuala_lumpur', 'utc_plus_0800_perth', 'utc_plus_0900_yakutsk', 'utc_plus_0900_tokyo', 'utc_plus_0900_seoul', 'utc_plus_0930_adelaide', 'utc_plus_0930_darwin', 'utc_plus_1000_vladivostok', 'utc_plus_1000_magadan', 'utc_plus_1000_brisbane', 'utc_plus_1000_sydney', 'utc_plus_1100_solomon_is', 'utc_plus_1130_norfolk_island', 'utc_plus_1200_anadyr', 'utc_plus_1200_auckland', 'utc_plus_1200_fiji', 'utc_plus_1245_chatham_islands', 'utc_plus_1300_nukualofa', 'utc_plus_1300_apia_samoa', 'utc_plus_1400_kiritimati', 'please_leave_this_field_blank')
Params: 2
Run Time: 0.000095
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 95 | Using where |