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 (93737, 826, 56359, 55197, 58349, 83093, 67034, 86143, 3890, 133669, 87579, 74641, 64986, 56743, 124358, 93847, 112075, 16177, 119533, 7400, 50615, 63714, 59393, 81425, 63921, 136135, 112358, 50029, 69402, 48569, 60886, 70242, 124599, 66791, 89184, 666, 111136, 119084, 94418, 125523, 59501, 96020, 10038, 124638, 114486, 114230, 94632, 86246, 71345, 73655, 87376, 69091, 79915, 80244, 73615, 72881, 111513, 97857, 3455, 120287, 110887, 121568, 122526, 105793, 67667, 64352, 102592, 84401, 79870, 62430, 22758, 45701, 102350, 11065, 51724, 114816, 128635, 6134, 74178, 84006, 37219, 89032, 803, 636, 68529, 105906, 52793, 100991, 126029, 804, 50884, 117556, 115860, 53103, 864, 127310, 91399, 114504, 90241, 124736, 79371, 124583, 124713, 65825, 93670, 2855, 56112, 111057, 71784, 124462, 91840, 91579, 106307, 116647, 84214, 98633, 125798, 60939, 99683, 5584, 95188, 10335, 8149, 24231, 420, 80312, 102916, 81226, 72606, 77097, 107972, 98930, 69274, 59591, 91156, 82193, 125402, 64026, 70560, 124607, 128028, 51374, 75489, 110765, 119362, 111187, 29048, 116981, 125046, 3610, 10806, 111703, 58936, 857, 107852, 51579, 98845, 63287, 88090, 112570, 113615, 46973, 90362, 24823, 45646, 76415, 59512, 83884, 110955, 21639, 135822, 73582, 65544, 96367, 67081, 112177, 73421, 63722, 77603, 84115, 50267, 34518, 119481, 82844, 69634, 131071, 59603, 95863, 125034, 51761, 802, 59084, 89829, 127849, 64978, 52581, 65935, 127739, 74382, 96536, 14404, 54579, 80717, 99028, 109739, 862, 52054, 93807, 818, 88976, 56730, 69630, 102537, 10804, 68791, 56808, 95470, 76114, 133557, 52085, 10793, 92188, 102882, 49152, 101015, 91018, 94329, 54757, 78879, 33491, 3321, 35927, 105992, 66517, 102988, 32805, 116600, 44459, 49578, 91418, 86670, 124189, 97697, 129565, 69287, 124519, 83775, 62400, 75077, 74353, 125404, 100441, 82012, 124304, 65358, 85249, 18508, 49536, 91308, 105424, 87133, 65852, 125572, 92395, 120904)
Run Time: 0.017419
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 265 | 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: 438, 0, 1714025390, 1714028990, [["thread",93737],["thread",826],["thread",56359],["thread",55197],["thread",58349],["thread",83093],["thread",67034],["thread",86143],["thread",3890],["thread",133669],["thread",87579],["thread",74641],["thread",64986],["thread",56743],["thread",124358],["thread",93847],["thread",112075],["thread",16177],["thread",119533],["thread",7400],["thread",50615],["thread",63714],["thread",59393],["thread",81425],["thread",63921],["thread",136135],["thread",112358],["thread",50029],["thread",69402],["thread",48569],["thread",60886],["thread",70242],["thread",124599],["thread",66791],["thread",89184],["thread",666],["thread",111136],["thread",119084],["thread",94418],["thread",125523],["thread",59501],["thread",96020],["thread",10038],["thread",124638],["thread",114486],["thread",114230],["thread",94632],["thread",86246],["thread",71345],["thread",73655],["thread",87376],["thread",69091],["thread",79915],["thread",80244],["thread",73615],["thread",72881],["thread",111513],["thread",97857],["thread",3455],["thread",120287],["thread",110887],["thread",121568],["thread",122526],["thread",105793],["thread",67667],["thread",64352],["thread",102592],["thread",84401],["thread",79870],["thread",62430],["thread",22758],["thread",45701],["thread",102350],["thread",11065],["thread",51724],["thread",114816],["thread",128635],["thread",6134],["thread",74178],["thread",84006],["thread",37219],["thread",89032],["thread",803],["thread",636],["thread",68529],["thread",105906],["thread",52793],["thread",100991],["thread",126029],["thread",804],["thread",50884],["thread",117556],["thread",115860],["thread",53103],["thread",864],["thread",127310],["thread",91399],["thread",114504],["thread",90241],["thread",124736],["thread",79371],["thread",124583],["thread",124713],["thread",65825],["thread",93670],["thread",2855],["thread",56112],["thread",111057],["thread",71784],["thread",124462],["thread",91840],["thread",91579],["thread",106307],["thread",116647],["thread",84214],["thread",98633],["thread",125798],["thread",60939],["thread",99683],["thread",5584],["thread",95188],["thread",10335],["thread",8149],["thread",24231],["thread",420],["thread",80312],["thread",102916],["thread",81226],["thread",72606],["thread",77097],["thread",107972],["thread",98930],["thread",69274],["thread",59591],["thread",91156],["thread",82193],["thread",125402],["thread",64026],["thread",70560],["thread",124607],["thread",128028],["thread",51374],["thread",75489],["thread",110765],["thread",119362],["thread",111187],["thread",29048],["thread",116981],["thread",125046],["thread",3610],["thread",10806],["thread",111703],["thread",58936],["thread",857],["thread",107852],["thread",51579],["thread",98845],["thread",63287],["thread",88090],["thread",112570],["thread",113615],["thread",46973],["thread",90362],["thread",24823],["thread",45646],["thread",76415],["thread",59512],["thread",83884],["thread",110955],["thread",21639],["thread",135822],["thread",73582],["thread",65544],["thread",96367],["thread",67081],["thread",112177],["thread",73421],["thread",63722],["thread",77603],["thread",84115],["thread",50267],["thread",34518],["thread",119481],["thread",82844],["thread",69634],["thread",131071],["thread",59603],["thread",95863],["thread",125034],["thread",51761],["thread",802],["thread",59084],["thread",89829],["thread",127849],["thread",64978],["thread",52581],["thread",65935],["thread",127739],["thread",74382],["thread",96536],["thread",14404],["thread",54579],["thread",80717],["thread",99028],["thread",109739],["thread",862],["thread",52054],["thread",93807],["thread",818],["thread",88976],["thread",56730],["thread",69630],["thread",102537],["thread",10804],["thread",68791],["thread",56808],["thread",95470],["thread",76114],["thread",133557],["thread",52085],["thread",10793],["thread",92188],["thread",102882],["thread",49152],["thread",101015],["thread",91018],["thread",94329],["thread",54757],["thread",78879],["thread",33491],["thread",3321],["thread",35927],["thread",105992],["thread",66517],["thread",102988],["thread",32805],["thread",116600],["thread",44459],["thread",49578],["thread",91418],["thread",86670],["thread",124189],["thread",97697],["thread",129565],["thread",69287],["thread",124519],["thread",83775],["thread",62400],["thread",75077],["thread",74353],["thread",125404],["thread",100441],["thread",82012],["thread",124304],["thread",65358],["thread",85249],["thread",18508],["thread",49536],["thread",91308],["thread",105424],["thread",87133],["thread",65852],["thread",125572],["thread",92395],["thread",120904]]
Run Time: 0.003546
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |