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