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.000821
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_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000134
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brcCurrencies', 'brcEvents')
Run Time: 0.000087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: b4b3affbe0dab7e34888d0e62af71184, 1716137822
Run Time: 0.000112
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.000087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT resource_category.*
,
permission.cache_value AS category_permission_cache,
0 AS category_is_watched
FROM xf_resource_category AS resource_category
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'resource_category'
AND permission.content_id = resource_category.resource_category_id)
WHERE resource_category.resource_category_id = ?
Params: 3
Run Time: 0.000160
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource_category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT resource_category.*
,
permission.cache_value AS category_permission_cache
FROM xf_resource_category AS resource_category
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'resource_category'
AND permission.content_id = resource_category.resource_category_id)
ORDER BY resource_category.lft
Run Time: 0.000357
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource_category | ALL | | | | | 35 | Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum_onligamez_ru.resource_category.resource_category_id | 1 | Using where |
SELECT COUNT(*)
FROM xf_resource AS resource
WHERE (resource.resource_category_id IN (5, 4, 1, 10, 11, 12, 13, 14, 15, 16, 17, 29, 18, 19, 20, 21, 22, 28, 23, 2, 24, 25, 27, 7, 8, 6, 9, 26, 3)) AND (resource.resource_state IN ('visible')) AND resource.guest_hidden != 1
Run Time: 0.000275
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | category_last_update,category_rating_weighted | | | | 165 | Using where |
SELECT resource.*
,
category.*, category.last_update AS category_last_update, resource.last_update,
version.version_string,
version.release_date,
version.download_url,
version.rating_count AS version_rating_count,
version.rating_sum AS version_rating_sum,
version.download_count AS version_download_count,
user.*, user_profile.*, IF(user.username IS NULL, resource.username, user.username) AS username,
feature.feature_date
FROM xf_resource AS resource
LEFT JOIN xf_resource_category AS category ON
(category.resource_category_id = resource.resource_category_id)
LEFT JOIN xf_resource_version AS version ON
(version.resource_version_id = resource.current_version_id)
LEFT JOIN xf_user AS user ON
(user.user_id = resource.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = resource.user_id)
LEFT JOIN xf_resource_feature AS feature ON
(feature.resource_id = resource.resource_id)
WHERE (resource.resource_category_id IN (5, 4, 1, 10, 11, 12, 13, 14, 15, 16, 17, 29, 18, 19, 20, 21, 22, 28, 23, 2, 24, 25, 27, 7, 8, 6, 9, 26, 3)) AND (resource.resource_state IN ('visible')) AND resource.guest_hidden != 1
ORDER BY resource.last_update DESC
LIMIT 20 OFFSET 40
Run Time: 0.001594
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | category_last_update,category_rating_weighted | | | | 165 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.resource_category_id | 1 | Using where |
SIMPLE | version | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.current_version_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.user_id | 1 | |
SIMPLE | feature | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.resource_id | 1 | |
SELECT resource.*,
feature.feature_date
,
category.*, category.last_update AS category_last_update, resource.last_update,
version.version_string,
version.release_date,
version.download_url,
version.rating_count AS version_rating_count,
version.rating_sum AS version_rating_sum,
version.download_count AS version_download_count,
user.*, user_profile.*, IF(user.username IS NULL, resource.username, user.username) AS username
FROM xf_resource_feature AS feature
INNER JOIN xf_resource AS resource ON (resource.resource_id = feature.resource_id)
LEFT JOIN xf_resource_category AS category ON
(category.resource_category_id = resource.resource_category_id)
LEFT JOIN xf_resource_version AS version ON
(version.resource_version_id = resource.current_version_id)
LEFT JOIN xf_user AS user ON
(user.user_id = resource.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = resource.user_id)
WHERE resource.resource_category_id IN (5, 4, 1, 10, 11, 12, 13, 14, 15, 16, 17, 29, 18, 19, 20, 21, 22, 28, 23, 2, 24, 25, 27, 7, 8, 6, 9, 26, 3)
ORDER BY RAND() LIMIT 6
Run Time: 0.001229
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | feature | index | PRIMARY | feature_date | 4 | | 6 | Using index; Using temporary; Using filesort |
SIMPLE | resource | eq_ref | PRIMARY,category_last_update,category_rating_weighted | PRIMARY | 4 | forum_onligamez_ru.feature.resource_id | 1 | Using where |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.resource_category_id | 1 | Using where |
SIMPLE | version | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.current_version_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.user_id | 1 | |
SELECT resource.*
,
category.*, category.last_update AS category_last_update, resource.last_update,
version.version_string,
version.release_date,
version.download_url,
version.rating_count AS version_rating_count,
version.rating_sum AS version_rating_sum,
version.download_count AS version_download_count,
user.*, user_profile.*, IF(user.username IS NULL, resource.username, user.username) AS username,
feature.feature_date
FROM xf_resource AS resource
LEFT JOIN xf_resource_category AS category ON
(category.resource_category_id = resource.resource_category_id)
LEFT JOIN xf_resource_version AS version ON
(version.resource_version_id = resource.current_version_id)
LEFT JOIN xf_user AS user ON
(user.user_id = resource.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = resource.user_id)
LEFT JOIN xf_resource_feature AS feature ON
(feature.resource_id = resource.resource_id)
WHERE (resource.resource_category_id IN (5, 4, 1, 10, 11, 12, 13, 14, 15, 16, 17, 29, 18, 19, 20, 21, 22, 28, 23, 2, 24, 25, 27, 7, 8, 6, 9, 26, 3)) AND (resource.resource_state IN ('visible')) AND resource.guest_hidden != 1
ORDER BY resource.rating_weighted DESC, resource.last_update DESC
LIMIT 5
Run Time: 0.000664
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | category_last_update,category_rating_weighted | | | | 165 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.resource_category_id | 1 | Using where |
SIMPLE | version | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.current_version_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.user_id | 1 | |
SIMPLE | feature | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.resource_id | 1 | |
SELECT field.*
,
rcf.field_id, rcf.resource_category_id
FROM xf_resource_field AS field
INNER JOIN xf_resource_field_category AS rcf ON
(rcf.field_id = field.field_id)
WHERE (rcf.resource_category_id = 3)
ORDER BY field.materialized_order
Run Time: 0.000240
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | rcf | ref | PRIMARY,resource_category_id | resource_category_id | 4 | const | 1 | Using index; Using temporary; Using filesort |
SIMPLE | field | eq_ref | PRIMARY | PRIMARY | 27 | forum_onligamez_ru.rcf.field_id | 1 | |
SELECT *
FROM xf_brivium_metadata
WHERE content_type = ? AND content_id = ?
Params: resource_category, 3
Run Time: 0.020829
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_brivium_metadata | ALL | | | | | 131897 | Using where |
UPDATE `xf_session` SET `expiry_date` = ?, `session_data` = ? WHERE (session_id = 'b4b3affbe0dab7e34888d0e62af71184')
Params: 1716141422,
Run Time: 0.000144
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, , , XenResource_ControllerPublic_Resource, Category, valid, resource_category_id=3, 1716137822,
Run Time: 0.000056
SELECT page_name FROM EWRcarta_pages WHERE page_slug = 'index'
Run Time: 0.000100
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRcarta_pages | const | page_slug | page_slug | 302 | const | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('BRC_action_login', 'BRC_action_login_description', 'BRC_action_exchange', 'BRC_action_exchange_description', 'BRC_action_transfer', 'BRC_action_transfer_description', 'BRC_action_withdraw', 'BRC_action_withdraw_description', 'BRC_action_steal', 'BRC_action_steal_description', 'BRC_action_paypalPayment', 'BRC_action_paypalPayment_description', 'BRC_action_paypalPaymentRe', 'BRC_action_paypalPaymentRe_description', 'BRC_action_registration', 'BRC_action_registration_description', 'BRC_action_facebookAssociate', 'BRC_action_facebookAssociate_description', 'BRC_action_facebookDisassociate', 'BRC_action_facebookDisassociate_description', 'BRC_action_twitterAssociate', 'BRC_action_twitterAssociate_description', 'BRC_action_twitterDisassociate', 'BRC_action_twitterDisassociate_description', 'BRC_action_googleAssociate', 'BRC_action_googleAssociate_description', 'BRC_action_googleDisassociate', 'BRC_action_googleDisassociate_description', 'BRC_action_birthday', 'BRC_action_birthday_description', 'BRC_action_importVbb', 'BRC_action_importVbb_description', 'BRC_action_interest', 'BRC_action_interest_description', 'BRC_action_updateFullProfile', 'BRC_action_updateFullProfile_description', 'BRC_action_updateFullProfileRe', 'BRC_action_updateFullProfileRe_description', 'BRC_action_uploadAvatar', 'BRC_action_uploadAvatar_description', 'BRC_action_uploadAvatarRe', 'BRC_action_uploadAvatarRe_description', 'BRC_action_updateStatus', 'BRC_action_updateStatus_description', 'BRC_action_follow', 'BRC_action_follow_description', 'BRC_action_followRe', 'BRC_action_followRe_description', 'BRC_action_getFollower', 'BRC_action_getFollower_description', 'BRC_action_getFollowerRe', 'BRC_action_getFollowerRe_description', 'BRC_action_profilePost', 'BRC_action_profilePost_description', 'BRC_action_getProfilePost', 'BRC_action_getProfilePost_description', 'BRC_action_likeProfilePost', 'BRC_action_likeProfilePost_description', 'BRC_action_likeProfilePostRe', 'BRC_action_likeProfilePostRe_description', 'BRC_action_receiveProfilePostLike', 'BRC_action_receiveProfilePostLike_description', 'BRC_action_receiveProfilePostLikeRe', 'BRC_action_receiveProfilePostLikeRe_description', 'BRC_action_createConversation', 'BRC_action_createConversation_description', 'BRC_action_createConversationRe', 'BRC_action_createConversationRe_description', 'BRC_action_receiveConversation', 'BRC_action_receiveConversation_description', 'BRC_action_replyConversation', 'BRC_action_replyConversation_description', 'BRC_action_conversationGetReply', 'BRC_action_conversationGetReply_description', 'BRC_action_trophyReward', 'BRC_action_trophyReward_description', 'BRC_action_dailyReward', 'BRC_action_dailyReward_description', 'BRC_action_salary', 'BRC_action_salary_description', 'BRC_action_createNewThread', 'BRC_action_createNewThread_description', 'BRC_action_threadDeleted', 'BRC_action_threadDeleted_description', 'BRC_action_threadGetReply', 'BRC_action_threadGetReply_description', 'BRC_action_threadViewed', 'BRC_action_threadViewed_description', 'BRC_action_readThread', 'BRC_action_readThread_description', 'BRC_action_watchThread', 'BRC_action_watchThread_description', 'BRC_action_watchThreadRe', 'BRC_action_watchThreadRe_description', 'BRC_action_threadGetWatched', 'BRC_action_threadGetWatched_description', 'BRC_action_threadGetWatchedRe', 'BRC_action_threadGetWatchedRe_description', 'BRC_action_createNewPoll', 'BRC_action_createNewPoll_description', 'BRC_action_votePoll', 'BRC_action_votePoll_description', 'BRC_action_pollGetVote', 'BRC_action_pollGetVote_description', 'BRC_action_threadSticky', 'BRC_action_threadSticky_description', 'BRC_action_threadStickyRe', 'BRC_action_threadStickyRe_description', 'BRC_action_newPost', 'BRC_action_newPost_description', 'BRC_action_postDeleted', 'BRC_action_postDeleted_description', 'BRC_action_uploadAttachment', 'BRC_action_uploadAttachment_description', 'BRC_action_uploadAttachmentRe', 'BRC_action_uploadAttachmentRe_description', 'BRC_action_downloadAttachment', 'BRC_action_downloadAttachment_description', 'BRC_action_attachmentDownloaded', 'BRC_action_attachmentDownloaded_description', 'BRC_action_likePost', 'BRC_action_likePost_description', 'BRC_action_likePostRe', 'BRC_action_likePostRe_description', 'BRC_action_receivePostLike', 'BRC_action_receivePostLike_description', 'BRC_action_receivePostLikeRe', 'BRC_action_receivePostLikeRe_description', 'BRC_action_reportPost', 'BRC_action_reportPost_description', 'BRC_action_postReported', 'BRC_action_postReported_description', 'BRC_action_BRCIPurchaseUserUpgrade', 'BRC_action_BRCIPurchaseUserUpgrade_explain', 'BRC_action_paygatePayment', 'BRC_action_paygatePayment_description', 'addm_donations')
Params: 2
Run Time: 0.000471
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 137 | Using where |