SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
permission.cache_value AS node_permission_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_post AS post ON
(post.post_id = thread.first_post_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 thread.thread_id IN (88558, 33408, 116393, 105809, 45646, 89351, 117988, 91143, 98381, 33612, 114309, 123901, 98210, 32335, 841, 29637, 105865, 866, 132708, 1275, 129042, 107975, 116100, 35546, 47274, 1436, 87013, 47472, 86598, 131015, 116820, 76371, 126458, 109955, 79590, 32278, 34024, 106422, 106125, 4883, 73052, 84141, 123168, 104348, 119927, 875, 130759, 99534, 108622, 91614, 112515, 33070, 1399, 85789, 116597, 76042, 114661, 85108, 33334, 81300, 116558, 94716, 107712, 84829, 35467, 106703, 30063, 59880, 129361, 35434, 97443, 102294, 86158, 126216, 33558, 115500, 79476, 1704, 39182, 26855, 123521, 128033, 35545, 77808, 32938, 129377, 38590, 127057, 109731, 115362, 118136, 77301, 103370, 109697, 33077, 102892, 98166, 107788, 86147, 116875, 89823, 46413, 116269, 113828, 95222, 95219, 133561, 98382, 109206, 48387, 107345, 106637, 111049, 94361, 88357, 1998, 84817, 81481, 102421, 106433, 104374, 105474, 87373, 35610, 116102, 126724, 115888, 91372, 110336, 118618, 89988, 122474, 85383, 1398, 116057, 107920, 988, 103661, 51402, 102058, 89724, 86823, 61685, 77302, 47278, 102332, 94450, 125984, 76307, 83211, 90056, 1259, 94883, 102900, 98211, 99103, 47361, 98714, 106153, 52193, 31044, 135268, 114221, 30244, 84689, 93524, 79586, 99394, 47471, 98514, 91138, 123907, 97291, 2055, 840, 596, 97973, 33315, 107210, 88747, 1254, 118679, 64639, 35608, 99108, 103949, 106745, 98115, 122014, 103755, 2321, 77424, 87296, 82072, 116218, 109538, 100325, 86739, 101969, 84960, 116631, 1382, 2270, 34085, 1979, 115895, 99055, 107553, 67270, 1397, 104096, 103950, 122841, 118332, 112217, 32261, 54616, 125776, 128271, 47223, 107177, 104207, 62534, 116311, 104429, 115628, 121755, 122199, 27012, 34811, 88116, 116699, 134687, 106708, 81560, 34730, 910, 90422, 111611, 2273, 116553, 129454, 95446, 35393, 23424, 86603, 123874, 879, 1090, 863, 30964, 99161, 95791, 127770, 107789, 33072, 98897, 107353, 46813, 64725, 87538, 28078, 38945, 105814, 95221, 107816, 30963, 33316, 107677, 1460, 52678, 116467, 52632, 726, 99337, 82643, 130896, 33320, 111735, 91622, 35334, 97310, 105443, 102841, 124502, 109775, 107163, 47455, 953, 124279, 106724, 107008, 96346, 130498, 107672, 97374, 107193, 38944, 35468)
Run Time: 0.211711
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 299 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dembuon_vn_d58b.thread.node_id | 1 | Using where |
INSERT INTO xf_tag_result_cache
(tag_id, user_id, cache_date, expiry_date, results)
VALUES
(?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
cache_date = VALUES(cache_date),
expiry_date = VALUES(expiry_date),
results = VALUES(results)
Params: 367, 0, 1715615298, 1715618898, [["tinhte_xentag_forum",64],["thread",88558],["thread",33408],["thread",116393],["thread",105809],["thread",45646],["thread",89351],["thread",117988],["thread",91143],["thread",98381],["thread",33612],["thread",114309],["thread",123901],["thread",98210],["thread",32335],["thread",841],["thread",29637],["thread",105865],["thread",866],["thread",132708],["thread",1275],["thread",129042],["thread",107975],["thread",116100],["thread",35546],["thread",47274],["thread",1436],["thread",87013],["thread",47472],["thread",86598],["thread",131015],["thread",116820],["thread",76371],["thread",126458],["thread",109955],["thread",79590],["thread",32278],["thread",34024],["thread",106422],["thread",106125],["thread",4883],["thread",73052],["thread",84141],["thread",123168],["thread",104348],["thread",119927],["thread",875],["thread",130759],["thread",99534],["thread",108622],["thread",91614],["thread",112515],["thread",33070],["thread",1399],["thread",85789],["thread",116597],["thread",76042],["thread",114661],["thread",85108],["thread",33334],["thread",81300],["thread",116558],["thread",94716],["thread",107712],["thread",84829],["thread",35467],["thread",106703],["thread",30063],["thread",59880],["thread",129361],["thread",35434],["thread",97443],["thread",102294],["thread",86158],["thread",126216],["thread",33558],["thread",115500],["thread",79476],["thread",1704],["thread",39182],["thread",26855],["thread",123521],["thread",128033],["thread",35545],["thread",77808],["thread",32938],["thread",129377],["thread",38590],["thread",127057],["thread",109731],["thread",115362],["thread",118136],["thread",77301],["thread",103370],["thread",109697],["thread",33077],["thread",102892],["thread",98166],["thread",107788],["thread",86147],["thread",116875],["thread",89823],["thread",46413],["thread",116269],["thread",113828],["thread",95222],["thread",95219],["thread",133561],["thread",98382],["thread",109206],["thread",48387],["thread",107345],["thread",106637],["thread",111049],["thread",94361],["thread",88357],["thread",1998],["thread",84817],["thread",81481],["thread",102421],["thread",106433],["thread",104374],["thread",105474],["thread",87373],["thread",35610],["thread",116102],["thread",126724],["thread",115888],["thread",91372],["thread",110336],["thread",118618],["thread",89988],["thread",122474],["thread",85383],["thread",1398],["thread",116057],["thread",107920],["thread",988],["thread",103661],["thread",51402],["thread",102058],["thread",89724],["thread",86823],["thread",61685],["thread",77302],["thread",47278],["thread",102332],["thread",94450],["thread",125984],["thread",76307],["thread",83211],["thread",90056],["thread",1259],["thread",94883],["thread",102900],["thread",98211],["thread",99103],["thread",47361],["thread",98714],["thread",106153],["thread",52193],["thread",31044],["thread",135268],["thread",114221],["thread",30244],["thread",84689],["thread",93524],["thread",79586],["thread",99394],["thread",47471],["thread",98514],["thread",91138],["thread",123907],["thread",97291],["thread",2055],["thread",840],["thread",596],["thread",97973],["thread",33315],["thread",107210],["thread",88747],["thread",1254],["thread",118679],["thread",64639],["thread",35608],["thread",99108],["thread",103949],["thread",106745],["thread",98115],["thread",122014],["thread",103755],["thread",2321],["thread",77424],["thread",87296],["thread",82072],["thread",116218],["thread",109538],["thread",100325],["thread",86739],["thread",101969],["thread",84960],["thread",116631],["thread",1382],["thread",2270],["thread",34085],["thread",1979],["thread",115895],["thread",99055],["thread",107553],["thread",67270],["thread",1397],["thread",104096],["thread",103950],["thread",122841],["thread",118332],["thread",112217],["thread",32261],["thread",54616],["thread",125776],["thread",128271],["thread",47223],["thread",107177],["thread",104207],["thread",62534],["thread",116311],["thread",104429],["thread",115628],["thread",121755],["thread",122199],["thread",27012],["thread",34811],["thread",88116],["thread",116699],["thread",134687],["thread",106708],["thread",81560],["thread",34730],["thread",910],["thread",90422],["thread",111611],["thread",2273],["thread",116553],["thread",129454],["thread",95446],["thread",35393],["thread",23424],["thread",86603],["thread",123874],["thread",879],["thread",1090],["thread",863],["thread",30964],["thread",99161],["thread",95791],["thread",127770],["thread",107789],["thread",33072],["thread",98897],["thread",107353],["thread",46813],["thread",64725],["thread",87538],["thread",28078],["thread",38945],["thread",105814],["thread",95221],["thread",107816],["thread",30963],["thread",33316],["thread",107677],["thread",1460],["thread",52678],["thread",116467],["thread",52632],["thread",726],["thread",99337],["thread",82643],["thread",130896],["thread",33320],["thread",111735],["thread",91622],["thread",35334],["thread",97310],["thread",105443],["thread",102841],["thread",124502],["thread",109775],["thread",107163],["thread",47455],["thread",953],["thread",124279],["thread",106724],["thread",107008],["thread",96346],["thread",130498],["thread",107672],["thread",97374],["thread",107193],["thread",38944],["thread",35468]]
Run Time: 0.272067
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_updateHomepage', 'BRC_action_updateHomepage_description', 'BRC_action_updateAbout', 'BRC_action_updateAbout_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_AzuCloud', 'BRC_action_AzuCloud_explain', 'BRC_action_BRRS_referral', 'BRC_action_BRRS_referral_explain', 'BRC_action_BRRSBuyReferralTimes', 'BRC_action_BRCIPurchaseUserUpgrade', 'BRC_action_BRCIPurchaseUserUpgrade_explain', 'VNNET_action_NLATMPayment', 'VNNET_action_NLATMPayment_explain', 'BRC_action_getbbcodePay', 'BRC_action_getbbcodePay_explain', 'BRC_action_bbcodePay', 'BRC_action_bbcodePay_explain', 'ld_nav_title')
Params: 2
Run Time: 0.000080
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |