SELECT *
FROM xf_tag
WHERE tag_id IN (54, 221, 43, 51, 48, 400, 203, 2, 11, 152, 277, 63, 7, 89, 478, 10, 732, 619, 81, 586, 184, 143, 111, 916, 157, 34, 183, 169, 154, 186, 106, 211, 391, 231, 852, 76, 788, 769, 287, 333, 30, 243, 681, 854, 624, 205, 548, 676, 209, 360, 940, 202, 1, 1600, 153, 200, 283, 92, 1375, 1359, 45, 2520, 450, 141, 165, 836, 220, 4, 1320, 158, 113, 94, 1155, 25, 623, 599, 737, 185, 181, 1394, 875, 634, 103, 226, 195, 90, 82, 5087, 2723, 874, 363, 561, 1651, 97, 49, 5018, 1022, 53, 301, 843)
ORDER BY tag
Run Time: 0.000917
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | range | PRIMARY | PRIMARY | 4 | | 100 | Using where; 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, , , XenForo_ControllerPublic_Tag, Index, valid, , 1714890713,
Run Time: 0.000100
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'tag_search', 'nflj_showcase_tab_links', 'xcxt_navtabs', 'waindigo_you_are_using_as_user_loginasuser', 'waindigo_moderator_bar_loginasuser', 'dark_postrating', 'dark_postrating_member', 'dark_postrating_member_totals', 'message_user_info_extra', 'user_criteria_content', 'thread_list_item_icon_key', 'dark_postrating_member_notable_tabs', 'dark_postrating_account_wrapper', 'dark_postrating_navigation_visitor_tab', 'dark_postrating_visitor_panel', 'dark_postrating_member_card', 'dark_postrating_member_info', 'dark_postrating_message_user_info', 'xcfw_copyright', 'xcxt_headinclude', 'xcxt_trading_preferences_link_list', 'xcxt_visitor_panel_addon', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000120
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 24 | Using where |