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 (43568, 18483, 52773, 126089, 113742, 54680, 106624, 62546, 133239, 65103, 77588, 106547, 80138, 107694, 130445, 89127, 100979, 107927, 116093, 55176, 53356, 133306, 18424, 73582, 124892, 99862, 99104, 136135, 71104, 130386, 68050, 127813, 124076, 122690, 45236, 41284, 63730, 86529, 53622, 85844, 110741, 100792, 73631, 95553, 108021, 74090, 106304, 72606, 114730, 52314, 81566, 54798, 58550, 72306, 113939, 78333, 98271, 111402, 110765, 45432, 71931, 65074, 68909, 20998, 43901, 86743, 61916, 78202, 63324, 75939, 134514, 123735, 77620, 61002, 90397, 91072, 112257, 124857, 16809, 80623, 80393, 106751, 53101, 6134, 89594, 76527, 122191, 89346, 54621, 50863, 110412, 50267, 119481, 74256, 71542, 88353, 88787, 84858, 5043, 28004, 88843, 105966, 28044, 132031, 84791, 57070, 130326, 46475, 111793, 36905, 72362, 93381, 74194, 109651, 17843, 70309, 54031, 107579, 74119, 53117, 78286, 70892, 102276, 106485, 103212, 109842, 51771, 113458, 61440, 117516, 124646, 53993, 63957, 95323, 116792, 71277, 20996, 66228, 51765, 123678, 106531, 117631, 128479, 98329, 75077, 84115, 112191, 84804, 23344, 91156, 63947, 109210, 74428, 110718, 111502, 90572, 110999, 90040, 73504, 7664, 56568, 100976, 119857, 114058, 110721, 102199, 112990, 116735, 111270, 117457, 80734, 51214, 40588, 96591, 91404, 89650, 128339, 401, 2099, 53640, 54061, 121225, 37742, 51761, 106645, 42072, 128614, 84090, 119362, 107382, 90659, 92441, 124262, 77058, 91018, 129569, 33354, 110766, 98999, 124978, 20712, 120595, 123638, 93670, 23746, 82305, 86102, 119100, 108798, 127376, 52074, 74205, 103990, 108053, 77048, 65029, 34457, 121117, 87050, 82699, 136558, 29048, 101433, 36867, 126321, 116489, 27028, 84663, 23913, 111508, 124344, 105600, 80860, 126056, 110575, 35777, 103233, 99001, 26370, 73438, 54161, 121692, 70297, 106741, 103692, 106576, 86071, 86316, 106113, 130374, 22555, 89707, 23630, 51439, 5580, 88821, 113761, 23396, 2003, 84091, 71048, 39758, 75654, 6255, 112748, 80851, 73613, 107019, 87300, 130501, 89667, 110226, 14995, 92149, 52674, 45387, 34397, 78928, 105960, 54849, 106710, 19956, 125001, 124458, 62341, 106697, 106822, 112456, 114351, 93467, 71148, 90124, 108534, 112284, 110664, 79158, 27769, 105175, 75729)
Run Time: 0.018539
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: 1145, 0, 1713891468, 1713895068, [["tinhte_xentag_forum",50],["thread",43568],["thread",18483],["thread",52773],["thread",126089],["thread",113742],["thread",54680],["thread",106624],["thread",62546],["thread",133239],["thread",65103],["thread",77588],["thread",106547],["thread",80138],["thread",107694],["thread",130445],["thread",89127],["thread",100979],["thread",107927],["thread",116093],["thread",55176],["thread",53356],["thread",133306],["thread",18424],["thread",73582],["thread",124892],["thread",99862],["thread",99104],["thread",136135],["thread",71104],["thread",130386],["thread",68050],["thread",127813],["thread",124076],["thread",122690],["thread",45236],["thread",41284],["thread",63730],["thread",86529],["thread",53622],["thread",85844],["thread",110741],["thread",100792],["thread",73631],["thread",95553],["thread",108021],["thread",74090],["thread",106304],["thread",72606],["thread",114730],["thread",52314],["thread",81566],["thread",54798],["thread",58550],["thread",72306],["thread",113939],["thread",78333],["thread",98271],["thread",111402],["thread",110765],["thread",45432],["thread",71931],["thread",65074],["thread",68909],["thread",20998],["thread",43901],["thread",86743],["thread",61916],["thread",78202],["thread",63324],["thread",75939],["thread",134514],["thread",123735],["thread",77620],["thread",61002],["thread",90397],["thread",91072],["thread",112257],["thread",124857],["thread",16809],["thread",80623],["thread",80393],["thread",106751],["thread",53101],["thread",6134],["thread",89594],["thread",76527],["thread",122191],["thread",89346],["thread",54621],["thread",50863],["thread",110412],["thread",50267],["thread",119481],["thread",74256],["thread",71542],["thread",88353],["thread",88787],["thread",84858],["thread",5043],["thread",28004],["thread",88843],["thread",105966],["thread",28044],["thread",132031],["thread",84791],["thread",57070],["thread",130326],["thread",46475],["thread",111793],["thread",36905],["thread",72362],["thread",93381],["thread",74194],["thread",109651],["thread",17843],["thread",70309],["thread",54031],["thread",107579],["thread",74119],["thread",53117],["thread",78286],["thread",70892],["thread",102276],["thread",106485],["thread",103212],["thread",109842],["thread",51771],["thread",113458],["thread",61440],["thread",117516],["thread",124646],["thread",53993],["thread",63957],["thread",95323],["thread",116792],["thread",71277],["thread",20996],["thread",66228],["thread",51765],["thread",123678],["thread",106531],["thread",117631],["thread",128479],["thread",98329],["thread",75077],["thread",84115],["thread",112191],["thread",84804],["thread",23344],["thread",91156],["thread",63947],["thread",109210],["thread",74428],["thread",110718],["thread",111502],["thread",90572],["thread",110999],["thread",90040],["thread",73504],["thread",7664],["thread",56568],["thread",100976],["thread",119857],["thread",114058],["thread",110721],["thread",102199],["thread",112990],["thread",116735],["thread",111270],["thread",117457],["thread",80734],["thread",51214],["thread",40588],["thread",96591],["thread",91404],["thread",89650],["thread",128339],["thread",401],["thread",2099],["thread",53640],["thread",54061],["thread",121225],["thread",37742],["thread",51761],["thread",106645],["thread",42072],["thread",128614],["thread",84090],["thread",119362],["thread",107382],["thread",90659],["thread",92441],["thread",124262],["thread",77058],["thread",91018],["thread",129569],["thread",33354],["thread",110766],["thread",98999],["thread",124978],["thread",20712],["thread",120595],["thread",123638],["thread",93670],["thread",23746],["thread",82305],["thread",86102],["thread",119100],["thread",108798],["thread",127376],["thread",52074],["thread",74205],["thread",103990],["thread",108053],["thread",77048],["thread",65029],["thread",34457],["thread",121117],["thread",87050],["thread",82699],["thread",136558],["thread",29048],["thread",101433],["thread",36867],["thread",126321],["thread",116489],["thread",27028],["thread",84663],["thread",23913],["thread",111508],["thread",124344],["thread",105600],["thread",80860],["thread",126056],["thread",110575],["thread",35777],["thread",103233],["thread",99001],["thread",26370],["thread",73438],["thread",54161],["thread",121692],["thread",70297],["thread",106741],["thread",103692],["thread",106576],["thread",86071],["thread",86316],["thread",106113],["thread",130374],["thread",22555],["thread",89707],["thread",23630],["thread",51439],["thread",5580],["thread",88821],["thread",113761],["thread",23396],["thread",2003],["thread",84091],["thread",71048],["thread",39758],["thread",75654],["thread",6255],["thread",112748],["thread",80851],["thread",73613],["thread",107019],["thread",87300],["thread",130501],["thread",89667],["thread",110226],["thread",14995],["thread",92149],["thread",52674],["thread",45387],["thread",34397],["thread",78928],["thread",105960],["thread",54849],["thread",106710],["thread",19956],["thread",125001],["thread",124458],["thread",62341],["thread",106697],["thread",106822],["thread",112456],["thread",114351],["thread",93467],["thread",71148],["thread",90124],["thread",108534],["thread",112284],["thread",110664],["thread",79158],["thread",27769],["thread",105175],["thread",75729]]
Run Time: 0.001705
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |