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 (72288, 49719, 71359, 48216, 77917, 70369, 76240, 73551, 48054, 47274, 104014, 58241, 72038, 58253, 133561, 65835, 125521, 104209, 82647, 74665, 75786, 76411, 46184, 75073, 51837, 72944, 74890, 44371, 46624, 77070, 47361, 102363, 72006, 70696, 69398, 63672, 126057, 84070, 73724, 51270, 33954, 83730, 88205, 46407, 82118, 77361, 50435, 47558, 71105, 46190, 71420, 47290, 80668, 73917, 79766, 104207, 86144, 50438, 86464, 5127, 52930, 87383, 48286, 82246, 24436, 46564, 122064, 79260, 48449, 52027, 69372, 37740, 76139, 113808, 74644, 82571, 47711, 85845, 46813, 66861, 81481, 77365, 69776, 80357, 71622, 53309, 57265, 45056, 126028, 60760, 74891, 48510, 99983, 59477, 84464, 64192, 59583, 52455, 40105, 104069, 94426, 74409, 51658, 80520, 76995, 46294, 76057, 77971, 122817, 49655, 420, 82646, 77951, 44888, 81000, 77295, 81782, 2293, 64162, 44806, 58119, 46522, 25920, 74125, 80396, 112672, 48308, 118225, 46747, 48559, 73763, 73822, 48943, 78838, 76100, 58818, 71461, 95051, 38090, 97614, 74023, 74244, 72238, 48128, 47568, 44803, 64998, 45218, 88201, 94759, 80745, 64277, 47788, 49958, 86262, 118224, 58339, 79745, 47224, 104215, 73470, 82412, 86295, 44805, 83913, 119577, 70373, 85667, 84116, 44440, 79690, 102321, 47922, 37142, 74130, 58252, 94757, 44557, 77701, 37566, 118674, 90006, 44370, 73916, 119576, 75578, 71244, 73823, 87031, 62278, 77056, 68062, 67042, 87028, 47221, 67062, 71466, 77972, 47152, 83704, 104081, 81027, 58173, 44889, 57164, 80517, 59833, 50033, 81688, 61731, 88592, 65638, 46528, 115137, 47156, 104162, 4487, 124459, 61678, 44558, 85496, 46243, 94804, 85793, 44556, 99743, 62216, 81489, 76465, 61445, 52029, 83546, 80155, 80842, 48942, 48357, 74247, 75475, 52022, 58239, 73722, 56047, 79125, 47783, 69934, 83557, 48467, 104357, 82406, 77554, 80038, 76113, 81515, 74608, 119565, 69115, 78448, 77804, 74181, 72009, 84485, 74019, 71998, 83011, 51529, 51220, 98384, 47276, 46412, 49374, 104071, 81090, 86893, 77394, 103821, 96707, 86891, 72638, 83211, 21260, 119841, 89838, 52632, 77418, 46770, 48511, 76513, 130288, 49761, 86278, 47784, 84024, 80359, 86147, 61677, 79581, 48554, 72483, 81069, 83718)
Run Time: 0.009711
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 300 | 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: 6, 0, 1713442636, 1713446236, [["thread",72288],["thread",49719],["thread",71359],["thread",48216],["thread",77917],["thread",70369],["thread",76240],["thread",73551],["thread",48054],["thread",47274],["thread",104014],["thread",58241],["thread",72038],["thread",58253],["thread",133561],["thread",65835],["thread",125521],["thread",104209],["thread",82647],["thread",74665],["thread",75786],["thread",76411],["thread",46184],["thread",75073],["thread",51837],["thread",72944],["thread",74890],["thread",44371],["thread",46624],["thread",77070],["thread",47361],["thread",102363],["thread",72006],["thread",70696],["thread",69398],["thread",63672],["thread",126057],["thread",84070],["thread",73724],["thread",51270],["thread",33954],["thread",83730],["thread",88205],["thread",46407],["thread",82118],["thread",77361],["thread",50435],["thread",47558],["thread",71105],["thread",46190],["thread",71420],["thread",47290],["thread",80668],["thread",73917],["thread",79766],["thread",104207],["thread",86144],["thread",50438],["thread",86464],["thread",5127],["thread",52930],["thread",87383],["thread",48286],["thread",82246],["thread",24436],["thread",46564],["thread",122064],["thread",79260],["thread",48449],["thread",52027],["thread",69372],["thread",37740],["thread",76139],["thread",113808],["thread",74644],["thread",82571],["thread",47711],["thread",85845],["thread",46813],["thread",66861],["thread",81481],["thread",77365],["thread",69776],["thread",80357],["thread",71622],["thread",53309],["thread",57265],["thread",45056],["thread",126028],["thread",60760],["thread",74891],["thread",48510],["thread",99983],["thread",59477],["thread",84464],["thread",64192],["thread",59583],["thread",52455],["thread",40105],["thread",104069],["thread",94426],["thread",74409],["thread",51658],["thread",80520],["thread",76995],["thread",46294],["thread",76057],["thread",77971],["thread",122817],["thread",49655],["thread",420],["thread",82646],["thread",77951],["thread",44888],["thread",81000],["thread",77295],["thread",81782],["thread",2293],["thread",64162],["thread",44806],["thread",58119],["thread",46522],["thread",25920],["thread",74125],["thread",80396],["thread",112672],["thread",48308],["thread",118225],["thread",46747],["thread",48559],["thread",73763],["thread",73822],["thread",48943],["thread",78838],["thread",76100],["thread",58818],["thread",71461],["thread",95051],["thread",38090],["thread",97614],["thread",74023],["thread",74244],["thread",72238],["thread",48128],["thread",47568],["thread",44803],["thread",64998],["thread",45218],["thread",88201],["thread",94759],["thread",80745],["thread",64277],["thread",47788],["thread",49958],["thread",86262],["thread",118224],["thread",58339],["thread",79745],["thread",47224],["thread",104215],["thread",73470],["thread",82412],["thread",86295],["thread",44805],["thread",83913],["thread",119577],["thread",70373],["thread",85667],["thread",84116],["thread",44440],["thread",79690],["thread",102321],["thread",47922],["thread",37142],["thread",74130],["thread",58252],["thread",94757],["thread",44557],["thread",77701],["thread",37566],["thread",118674],["thread",90006],["thread",44370],["thread",73916],["thread",119576],["thread",75578],["thread",71244],["thread",73823],["thread",87031],["thread",62278],["thread",77056],["thread",68062],["thread",67042],["thread",87028],["thread",47221],["thread",67062],["thread",71466],["thread",77972],["thread",47152],["thread",83704],["thread",104081],["thread",81027],["thread",58173],["thread",44889],["thread",57164],["thread",80517],["thread",59833],["thread",50033],["thread",81688],["thread",61731],["thread",88592],["thread",65638],["thread",46528],["thread",115137],["thread",47156],["thread",104162],["thread",4487],["thread",124459],["thread",61678],["thread",44558],["thread",85496],["thread",46243],["thread",94804],["thread",85793],["thread",44556],["thread",99743],["thread",62216],["thread",81489],["thread",76465],["thread",61445],["thread",52029],["thread",83546],["thread",80155],["thread",80842],["thread",48942],["thread",48357],["thread",74247],["thread",75475],["thread",52022],["thread",58239],["thread",73722],["thread",56047],["thread",79125],["thread",47783],["thread",69934],["thread",83557],["thread",48467],["thread",104357],["thread",82406],["thread",77554],["thread",80038],["thread",76113],["thread",81515],["thread",74608],["thread",119565],["thread",69115],["thread",78448],["thread",77804],["thread",74181],["thread",72009],["thread",84485],["thread",74019],["thread",71998],["thread",83011],["thread",51529],["thread",51220],["thread",98384],["thread",47276],["thread",46412],["thread",49374],["thread",104071],["thread",81090],["thread",86893],["thread",77394],["thread",103821],["thread",96707],["thread",86891],["thread",72638],["thread",83211],["thread",21260],["thread",119841],["thread",89838],["thread",52632],["thread",77418],["thread",46770],["thread",48511],["thread",76513],["thread",130288],["thread",49761],["thread",86278],["thread",47784],["thread",84024],["thread",80359],["thread",86147],["thread",61677],["thread",79581],["thread",48554],["thread",72483],["thread",81069],["thread",83718]]
Run Time: 0.002020
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.000064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |