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 (124208, 83627, 34536, 97703, 69475, 35671, 107289, 77872, 33365, 69047, 86304, 92346, 106960, 87775, 102316, 9296, 105691, 35545, 69104, 89985, 69268, 100497, 128470, 71358, 89211, 68057, 71521, 92309, 119922, 102789, 86585, 80454, 72944, 77374, 71483, 126448, 106480, 69643, 119925, 105896, 71660, 76520, 78908, 119531, 118782, 108405, 112406, 34907, 105236, 89398, 71420, 69348, 79828, 13176, 87998, 91596, 86939, 68220, 89734, 87328, 88628, 79668, 96734, 119482, 99631, 33323, 35675, 86229, 101630, 35672, 33653, 107682, 69748, 92592, 88656, 77781, 94227, 95297, 33351, 126236, 94371, 82840, 80365, 68973, 72038, 69414, 96735, 72040, 33408, 89267, 96503, 122452, 108333, 94815, 99943, 73911, 35240, 69750, 89259, 85547, 69895, 77247, 69215, 34020, 69580, 83704, 77280, 79418, 89874, 91585, 71961, 90328, 107911, 69345, 67314, 87820, 77948, 104394, 90125, 93769, 69479, 108042, 35546, 107539, 35757, 33334, 102041, 80391, 95731, 69639, 69861, 70604, 98064, 100949, 85253, 54244, 102949, 89302, 68960, 103150, 81599, 86701, 87104, 108393, 107491, 88976, 81426, 99110, 100148, 95717, 112268, 106948, 63667, 80581, 85895, 68229, 34539, 87342, 88051, 103352, 69097, 84401, 100829, 112514, 68544, 106275, 89647, 69716, 100402, 92990, 84124, 33406, 87238, 86827, 108423, 34026, 43979, 34535, 69604, 129931, 69309, 89731, 82193, 107259, 96608, 90127, 68825, 90923, 107110, 94312, 72044, 82997, 88754, 40429, 81284, 129120, 96663, 70957, 82668, 82012, 88599, 33281, 71013, 103718, 33612, 68037, 95114, 107658, 108294, 69622, 34537, 97773, 116180, 88476, 90174, 89512, 77951, 101423, 113126, 95001, 86537, 101991, 69229, 102993, 87871, 95954, 107208, 77355, 35609, 87426, 34541, 93328, 13780, 69194, 70962, 34025, 104322, 107823, 40431, 92130, 107884, 88320, 92999, 108299, 96557, 134858, 107981, 69564, 104906, 108298, 88414, 68080, 94823, 70818, 72721, 87815, 33077, 89074, 71205, 68843, 40432, 105414, 86278, 77401, 33320, 107266, 97172, 104045, 96162, 108267, 86821, 76968, 85249, 104551, 86684, 69384, 72288, 68519, 81606, 89006, 81153, 135685, 78145, 85335, 88041, 113012, 107673, 68221, 88079, 101480, 89009, 34730, 135686, 91362, 36967, 92180, 97868, 92012, 87763, 34538)
Run Time: 0.037919
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: 8789, 0, 1711679285, 1711682885, [["thread",124208],["thread",83627],["thread",34536],["thread",97703],["thread",69475],["thread",35671],["thread",107289],["thread",77872],["thread",33365],["thread",69047],["thread",86304],["thread",92346],["thread",106960],["thread",87775],["thread",102316],["thread",9296],["thread",105691],["thread",35545],["thread",69104],["thread",89985],["thread",69268],["thread",100497],["thread",128470],["thread",71358],["thread",89211],["thread",68057],["thread",71521],["thread",92309],["thread",119922],["thread",102789],["thread",86585],["thread",80454],["thread",72944],["thread",77374],["thread",71483],["thread",126448],["thread",106480],["thread",69643],["thread",119925],["thread",105896],["thread",71660],["thread",76520],["thread",78908],["thread",119531],["thread",118782],["thread",108405],["thread",112406],["thread",34907],["thread",105236],["thread",89398],["thread",71420],["thread",69348],["thread",79828],["thread",13176],["thread",87998],["thread",91596],["thread",86939],["thread",68220],["thread",89734],["thread",87328],["thread",88628],["thread",79668],["thread",96734],["thread",119482],["thread",99631],["thread",33323],["thread",35675],["thread",86229],["thread",101630],["thread",35672],["thread",33653],["thread",107682],["thread",69748],["thread",92592],["thread",88656],["thread",77781],["thread",94227],["thread",95297],["thread",33351],["thread",126236],["thread",94371],["thread",82840],["thread",80365],["thread",68973],["thread",72038],["thread",69414],["thread",96735],["thread",72040],["thread",33408],["thread",89267],["thread",96503],["thread",122452],["thread",108333],["thread",94815],["thread",99943],["thread",73911],["thread",35240],["thread",69750],["thread",89259],["thread",85547],["thread",69895],["thread",77247],["thread",69215],["thread",34020],["thread",69580],["thread",83704],["thread",77280],["thread",79418],["thread",89874],["thread",91585],["thread",71961],["thread",90328],["thread",107911],["thread",69345],["thread",67314],["thread",87820],["thread",77948],["thread",104394],["thread",90125],["thread",93769],["thread",69479],["thread",108042],["thread",35546],["thread",107539],["thread",35757],["thread",33334],["thread",102041],["thread",80391],["thread",95731],["thread",69639],["thread",69861],["thread",70604],["thread",98064],["thread",100949],["thread",85253],["thread",54244],["thread",102949],["thread",89302],["thread",68960],["thread",103150],["thread",81599],["thread",86701],["thread",87104],["thread",108393],["thread",107491],["thread",88976],["thread",81426],["thread",99110],["thread",100148],["thread",95717],["thread",112268],["thread",106948],["thread",63667],["thread",80581],["thread",85895],["thread",68229],["thread",34539],["thread",87342],["thread",88051],["thread",103352],["thread",69097],["thread",84401],["thread",100829],["thread",112514],["thread",68544],["thread",106275],["thread",89647],["thread",69716],["thread",100402],["thread",92990],["thread",84124],["thread",33406],["thread",87238],["thread",86827],["thread",108423],["thread",34026],["thread",43979],["thread",34535],["thread",69604],["thread",129931],["thread",69309],["thread",89731],["thread",82193],["thread",107259],["thread",96608],["thread",90127],["thread",68825],["thread",90923],["thread",107110],["thread",94312],["thread",72044],["thread",82997],["thread",88754],["thread",40429],["thread",81284],["thread",129120],["thread",96663],["thread",70957],["thread",82668],["thread",82012],["thread",88599],["thread",33281],["thread",71013],["thread",103718],["thread",33612],["thread",68037],["thread",95114],["thread",107658],["thread",108294],["thread",69622],["thread",34537],["thread",97773],["thread",116180],["thread",88476],["thread",90174],["thread",89512],["thread",77951],["thread",101423],["thread",113126],["thread",95001],["thread",86537],["thread",101991],["thread",69229],["thread",102993],["thread",87871],["thread",95954],["thread",107208],["thread",77355],["thread",35609],["thread",87426],["thread",34541],["thread",93328],["thread",13780],["thread",69194],["thread",70962],["thread",34025],["thread",104322],["thread",107823],["thread",40431],["thread",92130],["thread",107884],["thread",88320],["thread",92999],["thread",108299],["thread",96557],["thread",134858],["thread",107981],["thread",69564],["thread",104906],["thread",108298],["thread",88414],["thread",68080],["thread",94823],["thread",70818],["thread",72721],["thread",87815],["thread",33077],["thread",89074],["thread",71205],["thread",68843],["thread",40432],["thread",105414],["thread",86278],["thread",77401],["thread",33320],["thread",107266],["thread",97172],["thread",104045],["thread",96162],["thread",108267],["thread",86821],["thread",76968],["thread",85249],["thread",104551],["thread",86684],["thread",69384],["thread",72288],["thread",68519],["thread",81606],["thread",89006],["thread",81153],["thread",135685],["thread",78145],["thread",85335],["thread",88041],["thread",113012],["thread",107673],["thread",68221],["thread",88079],["thread",101480],["thread",89009],["thread",34730],["thread",135686],["thread",91362],["thread",36967],["thread",92180],["thread",97868],["thread",92012],["thread",87763],["thread",34538]]
Run Time: 0.027284
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.032219
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |