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.000845
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.000119
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.000159
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: dark_postrating_ratings
Run Time: 0.000112
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT user.*
,
user_profile.*,
user_option.*,
user_privacy.*,
permission_combination.cache_value AS global_permission_cache,
IF (session_activity.view_date IS NULL, user.last_activity, session_activity.view_date) AS effective_last_activity,
session_activity.view_date, session_activity.controller_name, session_activity.controller_action, session_activity.params, session_activity.ip,
0 AS following_0
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,3,4,5)) as positive_rating_count
, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,3,4,5)), 0)) as positive_rating_count_incl_likes
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (7,8,9,10,11,12)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (13)) as neutral_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
LEFT JOIN xf_permission_combination AS permission_combination ON
(permission_combination.permission_combination_id = user.permission_combination_id)
LEFT JOIN xf_session_activity AS session_activity ON
(session_activity.user_id = user.user_id AND session_activity.unique_key = CAST(user.user_id AS BINARY))
WHERE user.user_id = ?
Params: 217
Run Time: 0.001782
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
PRIMARY | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
PRIMARY | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
PRIMARY | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
PRIMARY | permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
PRIMARY | session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 0 | unique row not found |
SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 4 | |
SUBQUERY | dark_postrating_count | const | user_id_rating | user_id_rating | 8 | const,const | 1 | |
SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 6 | Using index condition |
SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 6 | Using index condition |
SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 6 | Using index condition |
SELECT COUNT(*)
FROM xf_profile_post AS profile_post
WHERE (profile_post.profile_user_id = 217) AND (profile_post.message_state IN ('visible'))
Run Time: 0.000231
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | profile_post | ref | profile_user_id_post_date | profile_user_id_post_date | 4 | const | 2 | Using where |
SELECT profile_post.*
,
posting_user.*,
IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username,
0 AS like_date
FROM xf_profile_post AS profile_post
LEFT JOIN xf_user AS posting_user ON
(posting_user.user_id = profile_post.user_id)
WHERE (profile_post.profile_user_id = 217) AND (profile_post.message_state IN ('visible'))
ORDER BY profile_post.post_date DESC
LIMIT 25
Run Time: 0.000654
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | profile_post | ref | profile_user_id_post_date | profile_user_id_post_date | 4 | const | 2 | Using where |
SIMPLE | posting_user | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.profile_post.user_id | 1 | |
SELECT user_field.*
,
field_value.field_value
FROM xf_user_field AS user_field
LEFT JOIN xf_user_field_value AS field_value ON
(field_value.field_id = user_field.field_id AND field_value.user_id = 217)
WHERE (user_field.display_group <> 'preferences' AND user_field.viewable_profile = 1)
ORDER BY user_field.display_group, user_field.display_order
Run Time: 0.000471
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_field | ALL | display_group_order | | | | 10 | Using where; Using filesort |
SIMPLE | field_value | eq_ref | PRIMARY,field_id | PRIMARY | 31 | const,sculptan_base.user_field.field_id | 1 | |
SELECT COUNT(*)
FROM xf_user_follow
WHERE follow_user_id = ?
Params: 217
Run Time: 0.000162
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_follow | ref | follow_user_id | follow_user_id | 4 | const | 1 | Using index |
SELECT user.*,
user_profile.*,
user_option.*
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,3,4,5)) as positive_rating_count
, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,3,4,5)), 0)) as positive_rating_count_incl_likes
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (7,8,9,10,11,12)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (13)) as neutral_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
FROM xf_user_follow AS user_follow
INNER JOIN xf_user AS user ON
(user.user_id = user_follow.user_id)
INNER JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
INNER JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
WHERE user_follow.follow_user_id = ?
ORDER BY RAND()
LIMIT 6
Params: 217
Run Time: 0.001625
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | user_follow | ref | PRIMARY,follow_user_id | follow_user_id | 4 | const | 1 | Using index; Using temporary; Using filesort |
PRIMARY | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.user_follow.user_id | 1 | |
PRIMARY | user_option | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.user_follow.user_id | 1 | |
PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.user_follow.user_id | 1 | |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | sculptan_base.user.user_id | 1 | |
DEPENDENT SUBQUERY | dark_postrating_count | eq_ref | user_id_rating | user_id_rating | 8 | sculptan_base.user.user_id,const | 1 | |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | sculptan_base.user.user_id | 1 | Using index condition |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | sculptan_base.user.user_id | 1 | Using index condition |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | sculptan_base.user.user_id | 1 | Using index condition |
SELECT
(SELECT COUNT(p1.organizer_vote)
FROM `estcs_participant` AS p1
LEFT JOIN `estcs_shopping` AS s1 ON (p1.shopping_id = s1.shopping_id)
WHERE s1.organizer_id = ? AND s1.stage = 'closed' AND p1.organizer_vote > 0) AS organizer_vote_sum,
(SELECT COUNT(p2.organizer_vote)
FROM `estcs_participant` AS p2
LEFT JOIN `estcs_shopping` AS s2 ON (p2.shopping_id = s2.shopping_id)
WHERE s2.organizer_id = ? AND s2.stage = 'closed') AS organizer_vote_total,
(SELECT COUNT(s3.shopping_id)
FROM `estcs_shopping` AS s3
WHERE s3.organizer_id = ? AND s3.stage = 'closed') AS organizer_shoppings_total,
(SELECT COUNT(p4.vote)
FROM `estcs_participant` AS p4
LEFT JOIN `estcs_shopping` AS s4 ON (p4.shopping_id = s4.shopping_id)
WHERE p4.user_id = ? AND s4.stage = 'closed' AND p4.vote > 0 AND p4.is_additional = 0) AS participant_vote_sum,
(SELECT COUNT(p5.vote)
FROM `estcs_participant` AS p5
LEFT JOIN `estcs_shopping` AS s5 ON (p5.shopping_id = s5.shopping_id)
WHERE p5.user_id = ? AND s5.stage = 'closed' AND p5.is_additional = 0) AS participant_vote_total,
(SELECT COUNT(s6.shopping_id)
FROM `estcs_shopping` AS s6
LEFT JOIN `estcs_participant` AS p6 ON (p6.shopping_id = s6.shopping_id)
WHERE p6.user_id = ? AND s6.stage = 'closed' AND p6.is_additional = 0) AS participant_shoppings_total
Params: 217, 217, 217, 217, 217, 217
Run Time: 0.000491
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | | | | | | | | No tables used |
SUBQUERY | s6 | ALL | PRIMARY | | | | 5 | Using where |
SUBQUERY | p6 | eq_ref | PRIMARY | PRIMARY | 8 | sculptan_base.s6.shopping_id,const | 1 | Using where |
SUBQUERY | s5 | ALL | PRIMARY | | | | 5 | Using where |
SUBQUERY | p5 | eq_ref | PRIMARY | PRIMARY | 8 | sculptan_base.s5.shopping_id,const | 1 | Using where |
SUBQUERY | s4 | ALL | PRIMARY | | | | 5 | Using where |
SUBQUERY | p4 | eq_ref | PRIMARY | PRIMARY | 8 | sculptan_base.s4.shopping_id,const | 1 | Using where |
SUBQUERY | s3 | ALL | | | | | 5 | Using where |
SUBQUERY | s2 | ALL | PRIMARY | | | | 5 | Using where |
SUBQUERY | p2 | ref | PRIMARY | PRIMARY | 4 | sculptan_base.s2.shopping_id | 3 | |
SUBQUERY | s1 | ALL | PRIMARY | | | | 5 | Using where |
SUBQUERY | p1 | ref | PRIMARY | PRIMARY | 4 | sculptan_base.s1.shopping_id | 3 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: ec8ebc247c2e5cdd8fe0640c5a87bc81, , 1714182578
Run Time: 0.000212
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_Member, Member, valid, user_id=217, 1714178978,
Run Time: 0.000425
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'xengallery_bb_code_tag_gallery', 'member_view', 'notice_cookies', 'oxy_news_nav_tab', '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', 'xengallery_comments_block', 'xengallery_media_block_items', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 14, 2
Run Time: 0.000257
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 27 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('user_field_user_fio_desc', 'user_field_Work_to_order_desc', 'user_field_Work_to_paint_desc', 'user_field_3D_Work_to_order_desc', 'user_field_Vk_desc', 'user_field_Ok_desc', 'user_field_icq_desc', 'user_field_skype_desc', 'user_field_facebook_desc', 'user_field_twitter_desc', 'MMOCS_my_buys')
Params: 2
Run Time: 0.000091
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 11 | Using where |
SELECT count_given as rating_count, rating, 1 as given
FROM dark_postrating_count
WHERE user_id = ?
UNION
SELECT count_received as rating_count, rating, 0 as given
FROM dark_postrating_count
WHERE user_id = ?
ORDER BY rating_count desc, rating asc
Params: 217, 217
Run Time: 0.000476
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 4 | |
UNION | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 4 | |
UNION RESULT | <union1,2> | ALL | | | | | | Using filesort |
SELECT COUNT(*)
FROM xf_liked_content
WHERE like_user_id = ?
Params: 217
Run Time: 0.000249
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_liked_content | ref | like_user_content_type_id | like_user_content_type_id | 4 | const | 240 | Using index |
SELECT count_given as rating_count, rating, 1 as given
FROM dark_postrating_count
WHERE user_id = ?
UNION
SELECT count_received as rating_count, rating, 0 as given
FROM dark_postrating_count
WHERE user_id = ?
ORDER BY rating_count desc, rating asc
Params: 217, 217
Run Time: 0.000109
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 4 | |
UNION | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 4 | |
UNION RESULT | <union1,2> | ALL | | | | | | Using filesort |
SELECT COUNT(*)
FROM xf_liked_content
WHERE like_user_id = ?
Params: 217
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_liked_content | ref | like_user_content_type_id | like_user_content_type_id | 4 | const | 240 | Using index |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('notices')
AND style_id = ?
AND language_id = ?
Params: 14, 2
Run Time: 0.000114
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('wf_widget_wrapper')
AND style_id = ?
AND language_id = ?
Params: 14, 2
Run Time: 0.000102
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |