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.001070
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: b88941bad8bde0a6c1dd146e1cc91de5, 1580167312
Run Time: 0.000185
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000157
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
last_post_user.gender AS last_post_gender,
last_post_user.avatar_date AS last_post_avatar_date,
last_post_user.gravatar AS last_post_gravatar,
IF(last_post_user.username IS NULL, thread.last_post_username, last_post_user.username) AS last_post_username,
node.title AS node_title, node.node_name,
forum.*,
forum.last_post_id AS forum_last_post_id,
forum.last_post_date AS forum_last_post_date,
forum.last_post_user_id AS forum_last_post_user_id,
forum.last_post_username AS forum_last_post_username,
forum.last_thread_title AS forum_last_thread_title,
thread.last_post_id,
thread.last_post_date,
thread.last_post_user_id,
thread.last_post_username,
NULL AS thread_read_date,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread FORCE INDEX (last_post_date)
LEFT JOIN xf_user AS last_post_user ON
(last_post_user.user_id = thread.last_post_user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_forum AS forum ON
(forum.node_id = thread.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1577575312) AND (forum.find_new = 1))
ORDER BY thread.last_post_date DESC
LIMIT 10Run Time: 0.000529
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | range | last_post_date | last_post_date | 4 | | 1865 | Using index condition; Using where |
| SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | homebrewtalk_xf2.thread.node_id | 1 | Using where |
| SIMPLE | last_post_user | eq_ref | PRIMARY | PRIMARY | 4 | homebrewtalk_xf2.thread.last_post_user_id | 1 | |
| SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | homebrewtalk_xf2.thread.node_id | 1 | |
| SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,homebrewtalk_xf2.thread.node_id | 1 | Using where |
SELECT *
FROM xf_node
WHERE display_in_list = 1
ORDER BY lft ASC
Run Time: 0.000377
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_node | ALL | display_in_list | | | | 79 | 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.000335
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 83 | Using where |
SELECT forum.*
,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE forum.node_id IN (41, 279, 39, 14, 163, 36, 282, 244, 37, 164, 12, 11, 170, 235, 51, 252, 253, 254, 255, 257, 258, 35, 128, 127, 92, 84, 25, 30, 32, 167, 281, 60, 62, 72, 76, 80, 79, 81, 284, 38, 16, 239, 174, 285, 130, 56, 249, 172, 19, 45, 5, 262, 173, 177, 178, 179, 180, 181, 182, 183, 234)
Run Time: 0.000502
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | forum | ALL | PRIMARY | | | | 67 | Using where |
| SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | homebrewtalk_xf2.forum.node_id | 1 | Using index |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1580166412)
ORDER BY session_activity.view_date DESC
Run Time: 0.003285
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | range | view_date | view_date | 4 | | 764 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | homebrewtalk_xf2.session_activity.user_id | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000152
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = 'b88941bad8bde0a6c1dd146e1cc91de5')
Params: 1580170912
Run Time: 0.003161
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_Forum, Index, valid, node_name=, 1580167312,
Run Time: 0.001574
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'xengallery_bb_code_tag_gallery', 'node_forum_level_2', 'node_category_level_1', 'node_forum_level_n', 'wf_widget_wrapper', 'wf_widget_threads', 'wf_widget_online_users', 'wf_widget_stats', 'forum_list', 'xengallery_tab_links', 'wf_hook_moderator_bar', 'wf_revealer', 'xcfw_copyright', 'xcxt_headinclude', 'xcxt_trading_preferences_link_list', 'xcxt_visitor_panel_addon', 'xengallery_comments_block', 'xengallery_media_block_items', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?Params: 2, 1
Run Time: 0.000809
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 20 | Using where |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1580166412)
ORDER BY session_activity.view_date DESC
Run Time: 0.003415
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | range | view_date | view_date | 4 | | 764 | Using where |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | homebrewtalk_xf2.session_activity.user_id | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000156
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_forum_list')Run Time: 0.000212
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: b88941bad8bde0a6c1dd146e1cc91de5, 1580167312
Run Time: 0.000169
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000193
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: b88941bad8bde0a6c1dd146e1cc91de5, 1580167312
Run Time: 0.000159
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
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 session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: b88941bad8bde0a6c1dd146e1cc91de5, 1580167312
Run Time: 0.000160
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000193
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT prefix.*
FROM xf_thread_prefix AS prefix
WHERE 1=1
ORDER BY prefix.materialized_order
Run Time: 0.000463
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | prefix | ALL | | | | | 171 | Using filesort |
SELECT *
FROM xf_thread_prefix_group
WHERE prefix_group_id = ?
Params: 2
Run Time: 0.000147
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_thread_prefix_group | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_thread_prefix_group
WHERE prefix_group_id = ?
Params: 3
Run Time: 0.000131
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_thread_prefix_group | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_thread_prefix_group
WHERE prefix_group_id = ?
Params: 1
Run Time: 0.000132
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_thread_prefix_group | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_thread_prefix_group
WHERE prefix_group_id = ?
Params: 4
Run Time: 0.000124
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_thread_prefix_group | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_thread_prefix_group
WHERE prefix_group_id = ?
Params: 5
Run Time: 0.000118
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_thread_prefix_group | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Woot! Nice tutorial, PP!
It drives me absolutely bonkers when people mention the number of pages in a thread, or reference a post on page X in a thread. LOL I don’t understand why anyone would want to only have 10 posts per page. I have mine set to 160, and it’s glorious!
Of all the threads to screenshot in the Multiquote section…
But how do i write in all caps?
@ol-hazza
You must be clever
Think of how much time can be saved by not searching and just expecting Yooper to answer my basic questions instead.
It also wasn’t mentioned about uploading photos,etc to sites like photobucket to then upload here. Then I can insert pics or videos anywhere in the text with fewer clicks.
@unionrdr
Right, thanks. Actually, you can upload them right here on HBT. Just click My Account -> My Gallery to get started. You can create subfolders to organize your pics. Once uploaded, you can post links to these pics onto other sites, too. It’s just like photobucket, etc. The problem with photobucket and similar is that if you close your account there or move the pics then the links become broken and your HBT thread will be messed up. You’ll see a lot of threads like that on HBT, where the pictures are gone.
I have a ton of pics in my Gallery. It works great. Try it!
Thanks for the tutorial! I learned a few things. I don’t know how StittsvilleJames got 160 posts per page, though. The most I see available are 40, or forum default.
“The moderators are sitting here in the top floor of the HBT building.”
I knew it! I am sure there’s a beer cave full of rare crafts and donated homebrews, plus lots of cigars, sausage, and a nice sink to wet shave in.
Great tips, with the time we all spend on HBT it is nice to know we are efficiently navigating things.
Would be nice to be able to send PMs to more then one person and not have to wait a minute to send them. I run the NE grain buy and it takes a solid 2 hours to send PMs to people when the buy is over.
@crazyirishman34
Post your suggestions here: http://www.homebrewtalk.com/f22/
To address a thought in the original post, these all work whether or not you’re a supporting member
The search options are more browser dependent. I have a flavor of Firefox that only has the option for a custom google search but no dropdown carrot. While the flavor of chromium I use, has the dropdown, but there is no option for a custom google search. I usually just resetrict my search in the address bar with “site:” boolean (i.e., beer site:homebrewtalk.com)
@passedpawn
just tell meeeee!!!!!
@ol-hazza
The ALL CAPS trick?
@Passedpawn
Not knowing is the 17th most frustrating thing to ever happen to me
@ol-hazza
17th? Pfft.
If you want to type in all caps, you must have some non-caps text before it.
Try typing anything, then changing it’s color to white. Then type your all-caps text. The white stuff will be invisible to most people.
@passedpawn- Good point. I’ll have to try that one. Just tried it, And no personal folders of mine show up?
@unionrdr
Click the “Add New Album” button to create a subfolder
Another note worthy trick that is used too rarely is the subscribe/unsubscribe option under “thread tools.” Too many times I see posts consisting only of “subscribed.”