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 (112147, 100369, 85892, 122129, 64277, 125944, 122076, 107574, 105365, 128358, 90892, 83093, 99171, 77567, 117270, 3477, 82663, 90895, 129238, 71854, 94450, 61832, 125521, 112397, 127544, 120219, 61721, 57228, 95162, 92805, 41169, 122457, 95839, 69020, 86309, 38134, 124942, 95756, 61458, 95740, 94418, 56568, 131073, 53409, 29851, 58491, 119412, 103765, 64723, 108345, 54119, 78750, 51455, 134703, 111703, 28062, 131495, 95065, 2919, 5944, 3869, 95295, 25277, 105424, 52780, 77259, 69705, 111055, 124697, 86670, 90904, 100536, 566, 87782, 95885, 125282, 44656, 55505, 104485, 24940, 84853, 56127, 61313, 48790, 94826, 53324, 113813, 14640, 57737, 16184, 67551, 71982, 16322, 81358, 541, 53163, 95135, 57548, 2785, 90241, 113578, 88294, 75973, 127453, 104740, 72078, 127705, 55733, 99857, 66762, 97667, 58336, 128613, 93135, 98052, 19540, 120594, 101642, 4473, 121364, 111873, 74977, 58424, 117907, 39012, 115321, 53197, 57655, 49741, 94927, 5168, 66791, 112177, 52152, 37213, 116968, 131317, 59276, 89200, 120576, 68653, 79926, 86246, 57805, 130648, 56306, 57257, 49217, 13045, 103486, 102988, 52417, 46123, 29455, 84563, 99874, 70249, 100845, 64961, 126713, 128319, 48059, 46340, 93789, 97573, 61778, 125657, 106773, 80513, 133798, 103317, 20464, 106415, 47993, 69675, 11179, 51756, 91087, 125023, 28316, 70674, 70723, 51317, 121708, 101110, 52783, 52825, 55816, 72567, 1419, 106309, 97270, 71429, 52511, 128761, 100590, 52932, 121772, 518, 92219, 101905, 105610, 133314, 61104, 59512, 92832, 100979, 92276, 40240, 130960, 61576, 50534, 46653, 98510, 91156, 23913, 78454, 108197, 83683, 95887, 125524, 85754, 135961, 54031, 77965, 9601, 50427, 36227, 536, 45151, 57868, 37205, 55209, 80282, 108337, 57019, 98338, 126031, 117918, 47658, 86901, 52390, 75997, 62307, 63615, 69598, 100193, 88287, 72187, 58690, 108828, 110856, 90928, 104646, 120283, 83658, 107269, 96964, 109388, 48122, 83863, 18267, 114500, 21374, 116192, 126553, 95705, 130676, 94305, 83092, 111833, 1524, 104621, 119084, 110045, 57492, 73492, 86276, 78813, 126378, 114128, 26263, 106865, 83729, 98690, 2101, 64588, 49720, 66901, 61359, 127908, 133697, 113539, 30533, 98925, 33730, 16178, 96249, 128309, 19429)
Run Time: 0.016562
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: 20, 0, 1713984986, 1713988586, [["thread",112147],["thread",100369],["thread",85892],["thread",122129],["thread",64277],["thread",125944],["thread",122076],["thread",107574],["thread",105365],["thread",128358],["thread",90892],["thread",83093],["thread",99171],["thread",77567],["thread",117270],["thread",3477],["thread",82663],["thread",90895],["thread",129238],["thread",71854],["thread",94450],["thread",61832],["thread",125521],["thread",112397],["thread",127544],["thread",120219],["thread",61721],["thread",57228],["thread",95162],["thread",92805],["thread",41169],["thread",122457],["thread",95839],["thread",69020],["thread",86309],["thread",38134],["thread",124942],["thread",95756],["thread",61458],["thread",95740],["thread",94418],["thread",56568],["thread",131073],["thread",53409],["thread",29851],["thread",58491],["thread",119412],["thread",103765],["thread",64723],["thread",108345],["thread",54119],["thread",78750],["thread",51455],["thread",134703],["thread",111703],["thread",28062],["thread",131495],["thread",95065],["thread",2919],["thread",5944],["thread",3869],["thread",95295],["thread",25277],["thread",105424],["thread",52780],["thread",77259],["thread",69705],["thread",111055],["thread",124697],["thread",86670],["thread",90904],["thread",100536],["thread",566],["thread",87782],["thread",95885],["thread",125282],["thread",44656],["thread",55505],["thread",104485],["thread",24940],["thread",84853],["thread",56127],["thread",61313],["thread",48790],["thread",94826],["thread",53324],["thread",113813],["thread",14640],["thread",57737],["thread",16184],["thread",67551],["thread",71982],["thread",16322],["thread",81358],["thread",541],["thread",53163],["thread",95135],["thread",57548],["thread",2785],["thread",90241],["thread",113578],["thread",88294],["thread",75973],["thread",127453],["thread",104740],["thread",72078],["thread",127705],["thread",55733],["thread",99857],["thread",66762],["thread",97667],["thread",58336],["thread",128613],["thread",93135],["thread",98052],["thread",19540],["thread",120594],["thread",101642],["thread",4473],["thread",121364],["thread",111873],["thread",74977],["thread",58424],["thread",117907],["thread",39012],["thread",115321],["thread",53197],["thread",57655],["thread",49741],["thread",94927],["thread",5168],["thread",66791],["thread",112177],["thread",52152],["thread",37213],["thread",116968],["thread",131317],["thread",59276],["thread",89200],["thread",120576],["thread",68653],["thread",79926],["thread",86246],["thread",57805],["thread",130648],["thread",56306],["thread",57257],["thread",49217],["thread",13045],["thread",103486],["thread",102988],["thread",52417],["thread",46123],["thread",29455],["thread",84563],["thread",99874],["thread",70249],["thread",100845],["thread",64961],["thread",126713],["thread",128319],["thread",48059],["thread",46340],["thread",93789],["thread",97573],["thread",61778],["thread",125657],["thread",106773],["thread",80513],["thread",133798],["thread",103317],["thread",20464],["thread",106415],["thread",47993],["thread",69675],["thread",11179],["thread",51756],["thread",91087],["thread",125023],["thread",28316],["thread",70674],["thread",70723],["thread",51317],["thread",121708],["thread",101110],["thread",52783],["thread",52825],["thread",55816],["thread",72567],["thread",1419],["thread",106309],["thread",97270],["thread",71429],["thread",52511],["thread",128761],["thread",100590],["thread",52932],["thread",121772],["thread",518],["thread",92219],["thread",101905],["thread",105610],["thread",133314],["thread",61104],["thread",59512],["thread",92832],["thread",100979],["thread",92276],["thread",40240],["thread",130960],["thread",61576],["thread",50534],["thread",46653],["thread",98510],["thread",91156],["thread",23913],["thread",78454],["thread",108197],["thread",83683],["thread",95887],["thread",125524],["thread",85754],["thread",135961],["thread",54031],["thread",77965],["thread",9601],["thread",50427],["thread",36227],["thread",536],["thread",45151],["thread",57868],["thread",37205],["thread",55209],["thread",80282],["thread",108337],["thread",57019],["thread",98338],["thread",126031],["thread",117918],["thread",47658],["thread",86901],["thread",52390],["thread",75997],["thread",62307],["thread",63615],["thread",69598],["thread",100193],["thread",88287],["thread",72187],["thread",58690],["thread",108828],["thread",110856],["thread",90928],["thread",104646],["thread",120283],["thread",83658],["thread",107269],["thread",96964],["thread",109388],["thread",48122],["thread",83863],["thread",18267],["thread",114500],["thread",21374],["thread",116192],["thread",126553],["thread",95705],["thread",130676],["thread",94305],["thread",83092],["thread",111833],["thread",1524],["thread",104621],["thread",119084],["thread",110045],["thread",57492],["thread",73492],["thread",86276],["thread",78813],["thread",126378],["thread",114128],["thread",26263],["thread",106865],["thread",83729],["thread",98690],["thread",2101],["thread",64588],["thread",49720],["thread",66901],["thread",61359],["thread",127908],["thread",133697],["thread",113539],["thread",30533],["thread",98925],["thread",33730],["thread",16178],["thread",96249],["thread",128309],["thread",19429]]
Run Time: 0.001629
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.000101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |