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