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.000237
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 37 | Using where |
SELECT *
FROM xf_tag
WHERE tag_id IN (364, 351, 365, 359, 363, 360, 451, 358, 362, 467, 1510, 468, 452, 919, 918, 519, 346, 387, 388, 366, 386, 921, 361, 674, 390, 389, 347, 373, 162, 1163, 454, 469, 1054, 369, 520, 577, 350, 1961, 1423, 2246, 920, 1707, 163, 352, 587, 1509, 1391, 915, 680, 1424, 2111, 1558, 1717, 914, 1536, 2244, 1426, 1202, 2849, 741, 723, 578, 1705, 2269, 164, 549, 1492, 2268, 671, 740, 1706, 2309, 902, 453, 2276, 1345, 1344, 1043, 2271, 2242, 1390, 1346, 2270, 2245, 379, 1421, 1557, 2272, 708, 704, 1244, 391, 2241, 1059, 916, 551, 377, 2758, 2275, 2274)
ORDER BY tag
Run Time: 0.001463
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | range | PRIMARY | PRIMARY | 4 | | 100 | Using index condition; Using filesort |
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, "̮n, "̮n, XenForo_ControllerPublic_Tag, Index, valid, , 1653813071,
Run Time: 0.000136