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.000722
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.000120
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.000082
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000088
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
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.000325
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 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 (3, 5, 10, 11, 12, 4, 13, 14, 15, 16, 17, 29, 18, 19, 20, 21, 22, 28, 23, 1, 2, 24, 25, 27, 7, 8, 6, 9, 26, 30, 31, 32, 33, 34, 35)
ORDER BY RAND() LIMIT 6
Run Time: 0.001447
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 (3, 5, 10, 11, 12, 4, 13, 14, 15, 16, 17, 29, 18, 19, 20, 21, 22, 28, 23, 1, 2, 24, 25, 27, 7, 8, 6, 9, 26, 30, 31, 32, 33, 34, 35)) AND (resource.resource_state IN ('visible')) AND resource.guest_hidden != 1
ORDER BY resource.last_update DESC
LIMIT 20 OFFSET 40
Run Time: 0.001439
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | category_last_update,category_rating_weighted | | | | 166 | 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.*
,
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 (3, 5, 10, 11, 12, 4, 13, 14, 15, 16, 17, 29, 18, 19, 20, 21, 22, 28, 23, 1, 2, 24, 25, 27, 7, 8, 6, 9, 26, 30, 31, 32, 33, 34, 35)) 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.000628
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | category_last_update,category_rating_weighted | | | | 166 | 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 rating.*
,
resource.*, resource.title AS resource_title,
resource.user_id AS resource_user_id,
IF(resource_user.username IS NULL, resource.username, resource_user.username) AS resource_username,
resource_user.gender AS resource_gender,
resource_user.avatar_date AS resource_avatar_date,
resource_user.gravatar AS resource_gravatar,
rating.user_id,
category.*, category.last_update AS category_last_update, resource.last_update,
user.*, user_profile.*,
permission.cache_value AS category_permission_cache
FROM xf_resource_rating AS rating
INNER JOIN xf_resource AS resource ON
(resource.resource_id = rating.resource_id)
LEFT JOIN xf_user AS resource_user ON
(resource_user.user_id = resource.user_id)
INNER JOIN xf_resource_category AS category ON
(category.resource_category_id = resource.resource_category_id)
INNER JOIN xf_user AS user ON
(user.user_id = rating.user_id)
INNER JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = rating.user_id)
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.resource_category_id)
WHERE (resource.resource_category_id IN (3, 5, 10, 11, 12, 4, 13, 14, 15, 16, 17, 29, 18, 19, 20, 21, 22, 28, 23, 1, 2, 24, 25, 27, 7, 8, 6, 9, 26, 30, 31, 32, 33, 34, 35)) AND (rating.rating_state IN ('visible')) AND (rating.is_review = 1) AND (rating.rating_date > 1709043370)
ORDER BY rating.rating_date DESC
LIMIT 5
Run Time: 0.000626
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | rating | range | user_id,resource_id_rating_date,rating_date | rating_date | 4 | | 1 | Using index condition; Using where |
SIMPLE | resource | eq_ref | PRIMARY,category_last_update,category_rating_weighted | PRIMARY | 4 | forum_onligamez_ru.rating.resource_id | 1 | Using where |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.resource_category_id | 1 | Using where |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum_onligamez_ru.resource.resource_category_id | 1 | Using where |
SIMPLE | resource_user | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.resource.user_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.rating.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.rating.user_id | 1 | |
SELECT user.*, user_profile.*
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user.user_id = user_profile.user_id)
WHERE user.resource_count > 0
AND user.is_banned = 0
ORDER BY user.resource_count DESC
LIMIT 5
Run Time: 0.000337
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | resource_count | resource_count | 4 | | 38 | Using index condition; Using where |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | forum_onligamez_ru.user.user_id | 1 | |
SELECT resource_field.*
FROM xf_resource_field AS resource_field
WHERE 1=1
ORDER BY resource_field.display_group, resource_field.display_order
Run Time: 0.000198
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource_field | ALL | | | | | 14 | Using filesort |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: ba5d764a158f90894efb108d0f6c8474, , 1711638970
Run Time: 0.000094
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, Index, valid, , 1711635370,
Run Time: 0.000043
SELECT page_name FROM EWRcarta_pages WHERE page_slug = 'index'
Run Time: 0.000071
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.000449
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 137 | Using where |