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.000792
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: convoMonitoringCounts
Run Time: 0.000223
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000152
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 4cc8dfa08bc5633642790680db47ce53, , 1714950251
Run Time: 0.000249
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, , , EWRporta_ControllerPublic_Portal, Index, valid, , 1714946651,
Run Time: 0.000107
SELECT *
FROM EWRporta_layouts
WHERE layout_id = ?
Params: portal
Run Time: 0.000154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_layouts | const | PRIMARY | PRIMARY | 77 | const | 1 | |
SELECT *, 'disabled' AS position
FROM EWRporta_blocks
WHERE active = 1
ORDER BY block_id ASC
Run Time: 0.000228
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_blocks | index | | PRIMARY | 77 | | 9 | Using where |
SELECT * FROM EWRporta_caches
Run Time: 0.000223
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | ALL | | | | | 1 | |
SELECT * FROM EWRporta_options
Run Time: 0.000192
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_options | ALL | | | | | 17 | |
SELECT xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count, xf_node.title AS node_title,
IF(xf_user.username IS NULL, xf_thread.username, xf_user.username) AS username,
IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) AS promote_date,
EWRporta_promotes.promote_icon, EWRporta_promotes.promote_data
FROM xf_thread
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
INNER JOIN xf_node ON (xf_node.node_id = xf_thread.node_id)
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE ( xf_thread.node_id IN ('78') OR EWRporta_promotes.promote_date < ? )
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
ORDER BY promote_date DESC
LIMIT ?, ?
Params: 1714946651, 1714946651, 0, 10
Run Time: 0.144300
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | node_id_last_post_date,node_id_sticky_state_last_post | | | | 23611 | Using where; Using temporary; Using filesort |
SIMPLE | xf_node | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.xf_thread.node_id | 1 | |
SIMPLE | EWRporta_promotes | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.xf_thread.user_id | 1 | |
SIMPLE | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.xf_thread.first_post_id | 1 | |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 38538
Run Time: 0.000318
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (425926)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000353
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 5 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.attachment.data_id | 1 | |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 38499
Run Time: 0.000178
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (425552)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000315
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 3 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.attachment.data_id | 1 | |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 38481
Run Time: 0.000176
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 38339
Run Time: 0.000173
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 38228
Run Time: 0.000172
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 38200
Run Time: 0.000190
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 38176
Run Time: 0.000142
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 38086
Run Time: 0.000148
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 38074
Run Time: 0.000187
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 38061
Run Time: 0.000174
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | xenforo.EWRporta_categories.category_id,const | 1 | Using index |
SELECT COUNT(*) AS total
FROM xf_thread
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE (xf_thread.node_id IN ('78') OR EWRporta_promotes.promote_date < ?)
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
Params: 1714946651, 1714946651
Run Time: 0.052462
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | node_id_last_post_date,node_id_sticky_state_last_post | | | | 23611 | Using where |
SIMPLE | EWRporta_promotes | eq_ref | PRIMARY | PRIMARY | 4 | xenforo.xf_thread.thread_id | 1 | Using where |
SELECT *
FROM EWRporta_caches
WHERE block_id = ?
Params: RecentNews
Run Time: 0.000244
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | const | PRIMARY | PRIMARY | 77 | const | 1 | |
SELECT *
FROM EWRporta_caches
WHERE block_id = ?
Params: RecentNews
Run Time: 0.000131
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | const | PRIMARY | PRIMARY | 77 | const | 1 | |
begin
Run Time: 0.000069
UPDATE `EWRporta_caches` SET `results` = ?, `date` = ? WHERE (block_id = 'RecentNews')
Params: a:2:{s:6:"option";a:9:{s:5:"forum";a:1:{i:0;s:2:"78";}s:8:"leftdate";s:1:"1";s:5:"limit";s:2:"10";s:7:"pagenav";s:1:"1";s:6:"social";s:1:"0";s:6:"sticky";s:1:"0";s:8:"truncate";s:4:"1000";s:7:"parseBB";b:1;s:5:"count";i:209;}s:10:"RecentNews";a:10:{i:0;a:67:{s:9:"thread_id";i:38538;s:7:"node_id";i:66;s:5:"title";s:46:"Mod Head Scavenger Hunt in the February Lobby!";s:11:"reply_count";i:11;s:10:"view_count";i:1408;s:7:"user_id";i:26817;s:8:"username";s:14:"WanderingLlama";s:9:"post_date";i:1706843402;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:425926;s:16:"first_post_likes";i:3;s:14:"last_post_date";i:1709073707;s:12:"last_post_id";i:426552;s:17:"last_post_user_id";i:26817;s:18:"last_post_username";s:14:"WanderingLlama";s:9:"prefix_id";i:0;s:4:"tags";s:6:"a:0:{}";s:5:"email";s:27:"chessprogrammer01@gmail.com";s:6:"gender";s:4:"male";s:12:"custom_title";s:15:"Wayfaring Drama";s:11:"language_id";i:1;s:8:"style_id";i:0;s:8:"timezone";s:15:"America/Phoenix";s:7:"visible";i:1;s:16:"activity_visible";i:0;s:13:"user_group_id";i:2;s:19:"secondary_group_ids";s:10:"4,16,19,20";s:22:"display_style_group_id";i:4;s:25:"permission_combination_id";i:195;s:13:"message_count";i:1455;s:20:"conversations_unread";i:0;s:13:"register_date";i:1452118099;s:13:"last_activity";i:1714938259;s:13:"trophy_points";i:1610;s:13:"alerts_unread";i:4;s:11:"avatar_date";i:0;s:12:"avatar_width";i:0;s:13:"avatar_height";i:0;s:8:"gravatar";s:44:"16b1f5950da74ba6910f8ef01964991e@minotar.net";s:10:"user_state";s:5:"valid";s:12:"is_moderator";i:1;s:8:"is_admin";i:1;s:9:"is_banned";i:0;s:10:"like_count";i:9437;s:14:"warning_points";i:0;s:8:"is_staff";i:1;s:17:"minecraft_profile";s:14:"WanderingLlama";s:7:"mc_uuid";s:32:"16b1f5950da74ba6910f8ef01964991e";s:14:"minecraft_uuid";s:36:"16b1f595-0da7-4ba6-910f-8ef01964991e";s:14:"minecraft_xuid";N;s:20:"minecraft_texture_id";N;s:23:"privacy_policy_accepted";i:0;s:14:"terms_accepted";i:0;s:7:"message";s:996:"Hello everyone! This new and improved February lobby will be full of fantastic fun! You will have a chance to win a mending elytra, shulker boxes, and 15 moderator heads in the February lobby scavenger hunt!
There are 15 moderator challenges that are scattered around the lobby, with a cool game or adventure for each one!
At the end of each challenge/adventure, click the sign saying that you found a moderator's head. You will get a token, which you can use to trade with villagers for any of the 15 moderator heads listed below, a shulker box, and a mending elytra!
The villager is located in the sunken shops next to the Hunger Games portal.
Depending on how the scavenger hunt is going, clues will be provided.
Always remember to push buttons, swim, and walk all around the lobby to find the entrances to each head quest.
You will now be able to get and store items in shulker boxes in the lobby!
Trade two tokens with the villager to get a shulker box.
At the purple/magenta beacon (a...";s:12:"attach_count";i:5;s:10:"node_title";s:13:"Announcements";s:12:"promote_date";i:1706843400;s:12:"promote_icon";s:6:"avatar";s:12:"promote_data";s:1:"0";s:10:"categories";a:0:{}s:5:"month";O:14:"XenForo_Phrase":4:{s:14:"