SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT thread.* , user.gender, user.avatar_date, user.gravatar, NULL AS thread_read_date, 0 AS thread_reply_banned, 0 AS thread_is_watched, '' AS draft_message, NULL AS draft_extra, IF(rate.count IS NULL, 0, rate.count) AS thread_rate_count, IF(rate.sum IS NULL, 0, rate.sum) AS thread_rate_sum, IF(rate.avg IS NULL, 0, rate.avg) AS thread_rate_avg FROM xf_thread AS thread LEFT JOIN xf_user AS user ON (user.user_id = thread.user_id) LEFT JOIN tr_thread_rate AS rate ON (rate.thread_id = thread.thread_id) WHERE thread.thread_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT DISTINCT content_id FROM xf_tag_content WHERE tag_id IN ( SELECT tag_id FROM xf_tag_content WHERE content_id = 24795 AND content_type = "thread" ) AND content_id <> 24795 AND content_type = "thread" ORDER BY content_id DESC LIMIT 90
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
PRIMARY | xf_tag_content | ref | content_type_id_tag,tag_id_content_date | content_type_id_tag | 31 | const,const | 1 | Using where; Using index; Using temporary; Using filesort |
PRIMARY | xf_tag_content | ref | content_type_id_tag,tag_id_content_date | tag_id_content_date | 4 | dembuon_vn_d58b.xf_tag_content.tag_id | 3 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)