SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routesPublic', 'routeFiltersIn', 'routeFiltersOut', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'trophyUserTitles', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')Run Time: 0.000491
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using index condition |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000165
| 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.000241
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | user_field | ALL | | | | | 19 | Using where; Using filesort |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 3a325730611ecf245c08cb3a5d013edd, a:9:{s:12:"sessionStart";i:1524461794;s:2:"ip";i:1796616435;s:9:"userAgent";s:39:"CCBot/2.0 (http://commoncrawl.org/faq/)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";b:0;s:13:"isDiscouraged";b:0;s:16:"registrationTime";i:1524461794;s:15:"registrationKey";s:32:"342441a582937291b6c937121c6c72ad";}, 1524465394
Run Time: 0.000132
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, 1796616435, 1796616435, Vtorio_ControllerPublic_Register, Index, valid, , 1524461794,
Run Time: 0.000092
SELECT *
FROM xf_captcha_question
WHERE active = 1
ORDER BY RAND()
Run Time: 0.000434
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_captcha_question | ref | active | active | 1 | const | 2 | Using temporary; Using filesort |
INSERT INTO `xf_captcha_log` (`hash`, `captcha_type`, `captcha_data`, `captcha_date`) VALUES (?, ?, ?, ?)
Params: 97b4112f4fbfa92dfd02f60e5eda10df8415be00, Question, 3, 1524461794
Run Time: 0.000108
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('utc_1100_american_samoa', 'utc_1100_apia_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_0400_falkland_islands', 'utc_0330_newfoundland', 'utc_0300_buenos_aires', 'utc_0300_san_luis', 'utc_0300_argentina', '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_amman', 'utc_plus_0200_beirut', 'utc_plus_0200_cairo', 'utc_plus_0200_jerusalem', 'utc_plus_0200_minsk', 'utc_plus_0200_gaza', 'utc_plus_0200_syria', 'utc_plus_0300_baghdad', 'utc_plus_0300_kaliningrad', 'utc_plus_0330_tehran', 'utc_plus_0400_moscow', 'utc_plus_0400_abu_dhabi', 'utc_plus_0400_yerevan', 'utc_plus_0400_baku', 'utc_plus_0400_mauritius', 'utc_plus_0430_kabul', 'utc_plus_0500_tashkent', 'utc_plus_0530_chennai', 'utc_plus_0545_kathmandu', 'utc_plus_0600_astana', 'utc_plus_0600_ekaterinburg', 'utc_plus_0600_almaty', 'utc_plus_0630_yangon', 'utc_plus_0700_bangkok', 'utc_plus_0700_novosibirsk', 'utc_plus_0800_beijing', 'utc_plus_0800_krasnoyarsk', 'utc_plus_0800_kuala_lumpur', 'utc_plus_0800_perth', 'utc_plus_0900_irkutsk', 'utc_plus_0900_tokyo', 'utc_plus_0900_seoul', 'utc_plus_0930_adelaide', 'utc_plus_0930_darwin', 'utc_plus_1000_brisbane', 'utc_plus_1000_sydney', 'utc_plus_1000_yakutsk', 'utc_plus_1100_solomon_is', 'utc_plus_1100_vladivostok', 'utc_plus_1130_norfolk_island', 'utc_plus_1200_anadyr', 'utc_plus_1200_auckland', 'utc_plus_1200_fiji', 'utc_plus_1200_magadan', 'utc_plus_1245_chatham_islands', 'utc_plus_1300_nukualofa', 'utc_plus_1400_kiritimati', 'user_field_business_sphere_desc', 'user_field_city_desc', 'user_field_company_post_desc', 'user_field_fio_desc', 'user_field_company_name_desc', 'user_field_company_phone_desc')Params: 2
Run Time: 0.001167
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 81 | | 99 | Using index condition |