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 (134594, 113973, 128966, 46919, 124278, 134632, 80229, 115112, 126201, 123932, 1538, 58053, 2326, 131641, 119835, 106867, 35745, 122460, 127057, 890, 106793, 124070, 112502, 124283, 34935, 1086, 120247, 65559, 126008, 71057, 133117, 135033, 134724, 131347, 129145, 38607, 129831, 50473, 108257, 115246, 134264, 131731, 106957, 133411, 126455, 131015, 991, 1486, 124666, 118185, 119432, 126831, 2306, 123307, 115801, 63504, 64032, 134946, 115110, 120513, 1474, 126475, 21057, 128543, 126582, 132620, 112999, 61619, 98992, 51201, 1297, 106739, 127786, 866, 18680, 117820, 111459, 72716, 39838, 115458, 134893, 106482, 122953, 111325, 1540, 111991, 42773, 72615, 108757, 122841, 123442, 44657, 122499, 2702, 6648, 107564, 129119, 106471, 63323, 2292, 118698, 121483, 117092, 118932, 131391, 130788, 135580, 11991, 21157, 2336, 2350, 914, 17803, 123929, 58224, 89321, 1114, 51658, 132624, 114758, 15958, 106877, 114042, 79200, 123566, 126023, 125503, 100650, 118477, 135241, 121165, 127404, 117965, 125203, 52469, 7650, 18633, 48352, 129894, 134110, 48228, 107452, 119088, 1058, 111412, 47851, 64636, 1248, 120814, 2333, 25253, 111865, 115823, 120022, 19266, 122122, 122040, 33395, 117915, 131433, 104972, 65244, 15691, 52109, 106508, 126163, 51210, 107193, 394, 121572, 135744, 129489, 104701, 107533, 131795, 119428, 1984, 121791, 125966, 106325, 44353, 18330, 116268, 1295, 93524, 131771, 5764, 123434, 58482, 121429, 77589, 134136, 109744, 131587, 600, 109696, 134262, 122962, 132558, 114734, 110785, 134525, 132170, 126323, 108216, 5107, 115244, 114415, 104566, 2442, 63501, 128345, 1323, 119879, 18565, 126522, 66323, 128807, 126526, 47236, 125995, 134586, 116906, 130952, 110984, 117449, 128293, 34938, 1639, 135674, 89611, 120807, 1628, 106125, 134148, 118465, 134498, 1056, 122776, 105936, 52077, 63186, 1001, 118701, 63262, 62638, 129409, 103530, 111193, 1020, 6127, 120390, 100100, 126435, 126326, 16973, 51284, 128943, 122110, 119619, 135889, 116218, 113673, 123001, 133484, 107677, 114893, 50464, 23109, 44347, 135159, 118783, 117870, 109847, 134890, 1255, 132027, 130281, 118576, 102243, 107680, 134902, 2524, 2331, 119704, 134111, 104581, 106378, 127101, 133501, 47872, 134841, 127356, 123230, 127187, 131152, 124878)
Run Time: 0.017707
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 297 | 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: 420, 0, 1711661192, 1711664792, [["resource",30],["resource",20],["tinhte_xentag_forum",64],["thread",134594],["thread",113973],["thread",128966],["thread",46919],["thread",124278],["thread",134632],["thread",80229],["thread",115112],["thread",126201],["thread",123932],["thread",1538],["thread",58053],["thread",2326],["thread",131641],["thread",119835],["thread",106867],["thread",35745],["thread",122460],["thread",127057],["thread",890],["thread",106793],["thread",124070],["thread",112502],["thread",124283],["thread",34935],["thread",1086],["thread",120247],["thread",65559],["thread",126008],["thread",71057],["thread",133117],["thread",135033],["thread",134724],["thread",131347],["thread",129145],["thread",38607],["thread",129831],["thread",50473],["thread",108257],["thread",115246],["thread",134264],["thread",131731],["thread",106957],["thread",133411],["thread",126455],["thread",131015],["thread",991],["thread",1486],["thread",124666],["thread",118185],["thread",119432],["thread",126831],["thread",2306],["thread",123307],["thread",115801],["thread",63504],["thread",64032],["thread",134946],["thread",115110],["thread",120513],["thread",1474],["thread",126475],["thread",21057],["thread",128543],["thread",126582],["thread",132620],["thread",112999],["thread",61619],["thread",98992],["thread",51201],["thread",1297],["thread",106739],["thread",127786],["thread",866],["thread",18680],["thread",117820],["thread",111459],["thread",72716],["thread",39838],["thread",115458],["thread",134893],["thread",106482],["thread",122953],["thread",111325],["thread",1540],["thread",111991],["thread",42773],["thread",72615],["thread",108757],["thread",122841],["thread",123442],["thread",44657],["thread",122499],["thread",2702],["thread",6648],["thread",107564],["thread",129119],["thread",106471],["thread",63323],["thread",2292],["thread",118698],["thread",121483],["thread",117092],["thread",118932],["thread",131391],["thread",130788],["thread",135580],["thread",11991],["thread",21157],["thread",2336],["thread",2350],["thread",914],["thread",17803],["thread",123929],["thread",58224],["thread",89321],["thread",1114],["thread",51658],["thread",132624],["thread",114758],["thread",15958],["thread",106877],["thread",114042],["thread",79200],["thread",123566],["thread",126023],["thread",125503],["thread",100650],["thread",118477],["thread",135241],["thread",121165],["thread",127404],["thread",117965],["thread",125203],["thread",52469],["thread",7650],["thread",18633],["thread",48352],["thread",129894],["thread",134110],["thread",48228],["thread",107452],["thread",119088],["thread",1058],["thread",111412],["thread",47851],["thread",64636],["thread",1248],["thread",120814],["thread",2333],["thread",25253],["thread",111865],["thread",115823],["thread",120022],["thread",19266],["thread",122122],["thread",122040],["thread",33395],["thread",117915],["thread",131433],["thread",104972],["thread",65244],["thread",15691],["thread",52109],["thread",106508],["thread",126163],["thread",51210],["thread",107193],["thread",394],["thread",121572],["thread",135744],["thread",129489],["thread",104701],["thread",107533],["thread",131795],["thread",119428],["thread",1984],["thread",121791],["thread",125966],["thread",106325],["thread",44353],["thread",18330],["thread",116268],["thread",1295],["thread",93524],["thread",131771],["thread",5764],["thread",123434],["thread",58482],["thread",121429],["thread",77589],["thread",134136],["thread",109744],["thread",131587],["thread",600],["thread",109696],["thread",134262],["thread",122962],["thread",132558],["thread",114734],["thread",110785],["thread",134525],["thread",132170],["thread",126323],["thread",108216],["thread",5107],["thread",115244],["thread",114415],["thread",104566],["thread",2442],["thread",63501],["thread",128345],["thread",1323],["thread",119879],["thread",18565],["thread",126522],["thread",66323],["thread",128807],["thread",126526],["thread",47236],["thread",125995],["thread",134586],["thread",116906],["thread",130952],["thread",110984],["thread",117449],["thread",128293],["thread",34938],["thread",1639],["thread",135674],["thread",89611],["thread",120807],["thread",1628],["thread",106125],["thread",134148],["thread",118465],["thread",134498],["thread",1056],["thread",122776],["thread",105936],["thread",52077],["thread",63186],["thread",1001],["thread",118701],["thread",63262],["thread",62638],["thread",129409],["thread",103530],["thread",111193],["thread",1020],["thread",6127],["thread",120390],["thread",100100],["thread",126435],["thread",126326],["thread",16973],["thread",51284],["thread",128943],["thread",122110],["thread",119619],["thread",135889],["thread",116218],["thread",113673],["thread",123001],["thread",133484],["thread",107677],["thread",114893],["thread",50464],["thread",23109],["thread",44347],["thread",135159],["thread",118783],["thread",117870],["thread",109847],["thread",134890],["thread",1255],["thread",132027],["thread",130281],["thread",118576],["thread",102243],["thread",107680],["thread",134902],["thread",2524],["thread",2331],["thread",119704],["thread",134111],["thread",104581],["thread",106378],["thread",127101],["thread",133501],["thread",47872],["thread",134841],["thread",127356],["thread",123230],["thread",127187],["thread",131152],["thread",124878]]
Run Time: 0.030534
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.000088
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |