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 (34538, 35671, 108042, 95001, 69047, 102993, 68957, 68229, 92999, 87426, 103150, 72044, 85547, 100576, 88656, 69309, 107682, 107539, 89211, 90174, 119925, 35657, 69783, 119482, 92012, 68572, 87871, 96503, 95717, 70817, 108405, 136249, 97773, 96734, 105236, 106382, 89734, 83163, 77355, 96608, 108298, 66393, 86304, 134858, 40429, 107673, 101480, 89259, 135685, 88561, 100402, 69229, 100829, 104551, 102041, 83704, 34024, 131685, 94371, 69861, 68973, 69345, 94823, 107884, 104322, 69643, 116180, 108423, 33406, 76520, 69716, 72095, 107911, 71389, 129934, 69639, 87915, 107313, 88758, 106275, 77948, 103040, 69414, 99943, 37078, 71358, 40432, 34541, 77401, 33653, 68960, 93769, 88628, 33077, 34539, 84124, 69475, 35673, 96557, 79828, 90923, 76968, 70957, 135686, 88368, 108294, 70818, 72038, 107208, 92180, 77280, 71420, 69215, 80365, 107136, 69564, 80581, 70604, 87238, 68037, 35546, 101991, 101423, 68825, 105691, 87820, 103374, 89074, 34020, 87328, 78908, 103718, 33323, 99631, 108393, 96735, 82840, 33365, 97505, 79668, 92346, 106948, 85249, 33334, 107338, 35609, 43979, 107110, 34730, 54244, 106960, 35545, 113126, 34907, 87104, 89647, 107491, 108267, 96162, 34026, 86821, 77872, 88754, 92309, 89267, 86827, 118782, 83627, 69720, 82646, 88051, 68220, 103352, 89731, 81426, 68221, 91129, 77374, 89985, 70962, 33322, 13780, 89398, 93886, 129120, 81153, 107981, 95297, 93221, 92990, 34536, 73911, 72721, 101630, 107289, 89006, 71205, 107259, 100949, 112406, 85253, 69895, 85895, 93328, 88414, 95110, 99183, 34025, 108299, 34535, 119531, 69097, 89512, 94319, 89009, 88041, 68519, 69384, 69348, 81284, 33612, 87763, 86701, 69479, 126236, 88079, 94312, 92481, 68843, 80312, 102316, 102949, 108333, 88320, 95954, 85335, 108458, 82193, 106716, 81599, 82997, 105896, 90125, 112514, 96663, 88976, 77951, 77781, 100497, 69268, 71013, 33281, 113012, 96460, 33408, 91132, 86229, 112268, 92130, 102789, 77787, 80454, 124208, 79418, 69750, 88982, 35674, 97172, 33320, 105414, 88599, 78145, 80391, 81606, 91585, 87775, 77989, 119922, 69580, 13176, 95731, 82668, 82012, 9296, 106480, 86278, 35675, 103881, 68057, 90127, 97868, 90328, 69194, 77247, 99110, 87342, 94227, 69748, 84401, 71961)
Run Time: 0.008468
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, 1713541495, 1713545095, [["thread",34538],["thread",35671],["thread",108042],["thread",95001],["thread",69047],["thread",102993],["thread",68957],["thread",68229],["thread",92999],["thread",87426],["thread",103150],["thread",72044],["thread",85547],["thread",100576],["thread",88656],["thread",69309],["thread",107682],["thread",107539],["thread",89211],["thread",90174],["thread",119925],["thread",35657],["thread",69783],["thread",119482],["thread",92012],["thread",68572],["thread",87871],["thread",96503],["thread",95717],["thread",70817],["thread",108405],["thread",136249],["thread",97773],["thread",96734],["thread",105236],["thread",106382],["thread",89734],["thread",83163],["thread",77355],["thread",96608],["thread",108298],["thread",66393],["thread",86304],["thread",134858],["thread",40429],["thread",107673],["thread",101480],["thread",89259],["thread",135685],["thread",88561],["thread",100402],["thread",69229],["thread",100829],["thread",104551],["thread",102041],["thread",83704],["thread",34024],["thread",131685],["thread",94371],["thread",69861],["thread",68973],["thread",69345],["thread",94823],["thread",107884],["thread",104322],["thread",69643],["thread",116180],["thread",108423],["thread",33406],["thread",76520],["thread",69716],["thread",72095],["thread",107911],["thread",71389],["thread",129934],["thread",69639],["thread",87915],["thread",107313],["thread",88758],["thread",106275],["thread",77948],["thread",103040],["thread",69414],["thread",99943],["thread",37078],["thread",71358],["thread",40432],["thread",34541],["thread",77401],["thread",33653],["thread",68960],["thread",93769],["thread",88628],["thread",33077],["thread",34539],["thread",84124],["thread",69475],["thread",35673],["thread",96557],["thread",79828],["thread",90923],["thread",76968],["thread",70957],["thread",135686],["thread",88368],["thread",108294],["thread",70818],["thread",72038],["thread",107208],["thread",92180],["thread",77280],["thread",71420],["thread",69215],["thread",80365],["thread",107136],["thread",69564],["thread",80581],["thread",70604],["thread",87238],["thread",68037],["thread",35546],["thread",101991],["thread",101423],["thread",68825],["thread",105691],["thread",87820],["thread",103374],["thread",89074],["thread",34020],["thread",87328],["thread",78908],["thread",103718],["thread",33323],["thread",99631],["thread",108393],["thread",96735],["thread",82840],["thread",33365],["thread",97505],["thread",79668],["thread",92346],["thread",106948],["thread",85249],["thread",33334],["thread",107338],["thread",35609],["thread",43979],["thread",107110],["thread",34730],["thread",54244],["thread",106960],["thread",35545],["thread",113126],["thread",34907],["thread",87104],["thread",89647],["thread",107491],["thread",108267],["thread",96162],["thread",34026],["thread",86821],["thread",77872],["thread",88754],["thread",92309],["thread",89267],["thread",86827],["thread",118782],["thread",83627],["thread",69720],["thread",82646],["thread",88051],["thread",68220],["thread",103352],["thread",89731],["thread",81426],["thread",68221],["thread",91129],["thread",77374],["thread",89985],["thread",70962],["thread",33322],["thread",13780],["thread",89398],["thread",93886],["thread",129120],["thread",81153],["thread",107981],["thread",95297],["thread",93221],["thread",92990],["thread",34536],["thread",73911],["thread",72721],["thread",101630],["thread",107289],["thread",89006],["thread",71205],["thread",107259],["thread",100949],["thread",112406],["thread",85253],["thread",69895],["thread",85895],["thread",93328],["thread",88414],["thread",95110],["thread",99183],["thread",34025],["thread",108299],["thread",34535],["thread",119531],["thread",69097],["thread",89512],["thread",94319],["thread",89009],["thread",88041],["thread",68519],["thread",69384],["thread",69348],["thread",81284],["thread",33612],["thread",87763],["thread",86701],["thread",69479],["thread",126236],["thread",88079],["thread",94312],["thread",92481],["thread",68843],["thread",80312],["thread",102316],["thread",102949],["thread",108333],["thread",88320],["thread",95954],["thread",85335],["thread",108458],["thread",82193],["thread",106716],["thread",81599],["thread",82997],["thread",105896],["thread",90125],["thread",112514],["thread",96663],["thread",88976],["thread",77951],["thread",77781],["thread",100497],["thread",69268],["thread",71013],["thread",33281],["thread",113012],["thread",96460],["thread",33408],["thread",91132],["thread",86229],["thread",112268],["thread",92130],["thread",102789],["thread",77787],["thread",80454],["thread",124208],["thread",79418],["thread",69750],["thread",88982],["thread",35674],["thread",97172],["thread",33320],["thread",105414],["thread",88599],["thread",78145],["thread",80391],["thread",81606],["thread",91585],["thread",87775],["thread",77989],["thread",119922],["thread",69580],["thread",13176],["thread",95731],["thread",82668],["thread",82012],["thread",9296],["thread",106480],["thread",86278],["thread",35675],["thread",103881],["thread",68057],["thread",90127],["thread",97868],["thread",90328],["thread",69194],["thread",77247],["thread",99110],["thread",87342],["thread",94227],["thread",69748],["thread",84401],["thread",71961]]
Run Time: 0.001166
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |