SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000120
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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.attachment_id = ?
Params: 53179
Run Time: 0.000395
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | data | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT comment.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.*, post.user_id AS post_user_id, post.username AS post_username, post.post_date AS post_post_date, post.message AS post_message,
comment.*,
node.title AS node_title, node.node_name,
user.*, IF(user.username IS NULL, comment.username, user.username) AS username,
user_profile.*,
user_option.*,
permission.cache_value AS node_permission_cache
FROM xf_brivium_post_comment AS comment
INNER JOIN xf_post AS post ON
(post.post_id = comment.post_id)
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = comment.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = comment.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = comment.user_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)
WHERE comment.comment_id = ?
Params: 80139
Run Time: 0.002102
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | comment | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | post | const | PRIMARY,thread_id_post_date,thread_id_position | PRIMARY | 4 | const | 1 | |
SIMPLE | thread | const | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'error', 'wf_hook_footer', 'wf_hook_moderator_bar', 'dark_taigachat', 'dark_taigachat_list', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 7, 1
Run Time: 0.000200
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 7 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('attachment_cannot_be_shown_at_this_time')
Params: 1
Run Time: 0.000109
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |