SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000147
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_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, , 1611443635, unknown
Run Time: 0.004995
SELECT *
FROM EWRporta_layouts
WHERE layout_id = ?
Params: portal
Run Time: 0.000168
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_layouts | const | PRIMARY | PRIMARY | 102 | const | 1 | |
SELECT *, 'disabled' AS position
FROM EWRporta_blocks
WHERE active = 1
ORDER BY block_id ASC
Run Time: 0.000187
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_blocks | index | | PRIMARY | 102 | | 9 | Using where |
SELECT * FROM EWRporta_caches
Run Time: 0.000103
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | ALL | | | | | 3 | |
SELECT * FROM EWRporta_options
Run Time: 0.000162
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_options | ALL | | | | | 20 | |
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 ('2') 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: 1611443635, 1611443635, 0, 4
Run Time: 0.099508
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 | | | | 68410 | Using where; Using temporary; Using filesort |
SIMPLE | EWRporta_promotes | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (hash join) |
SIMPLE | xf_node | eq_ref | PRIMARY | PRIMARY | 4 | skial.xf_thread.node_id | 1 | |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | skial.xf_thread.user_id | 1 | |
SIMPLE | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | skial.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: 90651
Run Time: 0.000246
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 | skial.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: 90357
Run Time: 0.000141
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 | skial.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: 90201
Run Time: 0.000125
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 | skial.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: 87277
Run Time: 0.000119
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 | skial.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 ('2') 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: 1611443635, 1611443635
Run Time: 0.038099
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 | | | | 68410 | Using where |
SIMPLE | EWRporta_promotes | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (hash join) |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count,
permission.cache_value AS node_permission_cache,
pr_cache.rating_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.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)
left join dark_postrating_post_cache pr_cache ON (thread.first_post_id = pr_cache.post_id)
WHERE (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1611270835) AND 1=1 AND thread.node_id IN ('1', '2', '4', '24', '82', '16', '42', '49', '88', '98', '18', '6', '27', '10', '63', '46', '86', '22', '12', '13', '14', '69', '73', '93', '38', '65', '101', '23', '57', '44', '72', '35', '41', '47', '51', '77', '34', '59', '70', '62', '96', '37', '50', '9', '33', '54', '40', '78', '48', '89', '55', '99', '39', '17')
ORDER BY thread.last_post_date DESC
LIMIT 5
Run Time: 0.001458
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | node_id_last_post_date,last_post_date,node_id_sticky_state_last_post | last_post_date | 4 | | 70 | Using index condition; Using where; Backward index scan |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | skial.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | skial.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,skial.thread.node_id | 1 | Using where |
SIMPLE | pr_cache | eq_ref | PRIMARY | PRIMARY | 4 | skial.thread.first_post_id | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 46
Run Time: 0.000150
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 13
Run Time: 0.000084
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 101
Run Time: 0.000100
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 38
Run Time: 0.000087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 4
Run Time: 0.000110
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
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 > 1611440035)
ORDER BY session_activity.view_date DESC
Run Time: 0.000897
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 257 | Using where; Backward index scan |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | skial.session_activity.user_id | 1 | |
SELECT * FROM
(SELECT p.*
FROM xf_user_status s
JOIN xf_profile_post p ON s.profile_post_id=p.profile_post_id
ORDER BY s.post_date DESC LIMIT 20) b
JOIN xf_user u ON u.user_id=b.user_id AND message_state='visible'
GROUP BY profile_user_id
ORDER BY post_date DESC
LIMIT ?
/*
SELECT *, IF(xf_user.username IS NULL, xf_profile_post.username, xf_user.username) AS username
FROM xf_profile_post
INNER JOIN (
SELECT profile_post_id FROM xf_profile_post
WHERE message_state = 'visible' AND profile_user_id = user_id
ORDER BY post_date DESC
) AS post2 USING (profile_post_id)
LEFT JOIN xf_user ON (xf_user.user_id = xf_profile_post.user_id)
GROUP BY profile_user_id
ORDER BY post_date DESC
LIMIT ?
*/
Params: 5
Run Time: 0.000592
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <derived2> | ALL | | | | | 20 | Using where; Using temporary; Using filesort |
PRIMARY | u | eq_ref | PRIMARY | PRIMARY | 4 | b.user_id | 1 | |
DERIVED | s | index | PRIMARY | post_date | 4 | | 20 | Backward index scan; Using index |
DERIVED | p | eq_ref | PRIMARY | PRIMARY | 4 | skial.s.profile_post_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bb_code_tag_vfchh', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'EWRblock_RecentNews', 'EWRblock_RecentThreads', 'EWRblock_OnlineUsers', 'EWRblock_BoardTotals', 'EWRblock_StatusUpdates', 'EWRblock_SkialServers', 'EWRporta_Portal', 'notice_cookies', 'EWRporta_Navtabs', 'rotating_ads_slider', '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', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 1
Run Time: 0.000318
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 32 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('home')
Params: 1
Run Time: 0.000111
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('dark_azucloud')
AND style_id = ?
AND language_id = ?
Params: 1, 1
Run Time: 0.000213
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |