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 (40270, 69512, 82525, 58033, 67544, 112404, 119437, 37700, 99881, 109022, 88432, 65223, 44322, 122422, 94479, 57540, 87166, 66550, 68800, 91397, 125658, 60893, 61668, 117441, 87324, 113715, 59259, 132638, 76718, 64128, 82183, 64571, 83177, 52550, 109584, 43403, 128572, 43766, 106082, 96371, 67910, 103744, 69792, 66561, 110958, 81507, 132597, 96337, 57664, 97817, 70337, 51743, 24996, 77171, 87844, 23866, 90497, 79460, 58401, 128525, 68688, 102768, 104083, 94451, 111728, 72689, 58319, 72747, 132532, 71743, 79115, 79704, 63790, 21589, 95499, 100474, 123921, 104193, 132169, 58628, 92492, 38659, 65017, 104060, 91531, 44130, 87103, 90215, 125705, 123867, 101676, 117503, 55487, 125927, 58404, 44157, 129048, 109934, 109377, 86101, 87369, 52943, 132139, 28737, 75661, 45268, 99263, 128882, 48909, 132327, 99535, 70218, 127905, 110548, 67542, 54637, 7982, 135081, 91447, 41992, 125668, 41079, 35989, 62065, 88044, 85094, 43364, 67554, 69139, 126225, 58684, 61256, 124716, 112424, 64356, 29302, 61026, 111284, 48606, 64136, 59128, 131089, 124068, 61964, 113674, 86564, 84507, 128569, 123052, 93442, 117721, 91326, 45711, 82569, 97980, 86934, 67947, 68386, 124649, 71741, 131336, 58334, 41290, 105863, 61666, 95877, 135542, 61122, 81453, 62003, 61410, 90762, 56370, 100161, 41971, 62165, 81091, 105387, 48150, 112418, 123689, 48472, 58715, 61489, 116441, 71369, 113116, 75623, 69972, 72010, 101658, 73705, 93273, 102915, 71789, 100955, 110534, 135697, 67727, 118461, 52434, 117708, 130964, 119781, 112366, 55010, 86177, 55799, 71956, 78991, 54504, 38670, 94123, 83751, 85825, 67242, 54009, 115578, 127864, 115650, 83611, 59417, 135741, 61364, 121595, 124645, 62239, 90424, 103090, 66571, 59600, 85194, 85634, 123411, 106626, 101832, 77406, 123690, 127398, 127338, 44603, 37698, 87584, 88228, 69260, 79767, 58956, 128255, 64952, 60874, 125138, 113378, 105007, 71646, 126100, 133347, 128685)
Run Time: 0.020913
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 257 | 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: 5321, 0, 1714132379, 1714135979, [["thread",40270],["thread",69512],["thread",82525],["thread",58033],["thread",67544],["thread",112404],["thread",119437],["thread",37700],["thread",99881],["thread",109022],["thread",88432],["thread",65223],["thread",44322],["thread",122422],["thread",94479],["thread",57540],["thread",87166],["thread",66550],["thread",68800],["thread",91397],["thread",125658],["thread",60893],["thread",61668],["thread",117441],["thread",87324],["thread",113715],["thread",59259],["thread",132638],["thread",76718],["thread",64128],["thread",82183],["thread",64571],["thread",83177],["thread",52550],["thread",109584],["thread",43403],["thread",128572],["thread",43766],["thread",106082],["thread",96371],["thread",67910],["thread",103744],["thread",69792],["thread",66561],["thread",110958],["thread",81507],["thread",132597],["thread",96337],["thread",57664],["thread",97817],["thread",70337],["thread",51743],["thread",24996],["thread",77171],["thread",87844],["thread",23866],["thread",90497],["thread",79460],["thread",58401],["thread",128525],["thread",68688],["thread",102768],["thread",104083],["thread",94451],["thread",111728],["thread",72689],["thread",58319],["thread",72747],["thread",132532],["thread",71743],["thread",79115],["thread",79704],["thread",63790],["thread",21589],["thread",95499],["thread",100474],["thread",123921],["thread",104193],["thread",132169],["thread",58628],["thread",92492],["thread",38659],["thread",65017],["thread",104060],["thread",91531],["thread",44130],["thread",87103],["thread",90215],["thread",125705],["thread",123867],["thread",101676],["thread",117503],["thread",55487],["thread",125927],["thread",58404],["thread",44157],["thread",129048],["thread",109934],["thread",109377],["thread",86101],["thread",87369],["thread",52943],["thread",132139],["thread",28737],["thread",75661],["thread",45268],["thread",99263],["thread",128882],["thread",48909],["thread",132327],["thread",99535],["thread",70218],["thread",127905],["thread",110548],["thread",67542],["thread",54637],["thread",7982],["thread",135081],["thread",91447],["thread",41992],["thread",125668],["thread",41079],["thread",35989],["thread",62065],["thread",88044],["thread",85094],["thread",43364],["thread",67554],["thread",69139],["thread",126225],["thread",58684],["thread",61256],["thread",124716],["thread",112424],["thread",64356],["thread",29302],["thread",61026],["thread",111284],["thread",48606],["thread",64136],["thread",59128],["thread",131089],["thread",124068],["thread",61964],["thread",113674],["thread",86564],["thread",84507],["thread",128569],["thread",123052],["thread",93442],["thread",117721],["thread",91326],["thread",45711],["thread",82569],["thread",97980],["thread",86934],["thread",67947],["thread",68386],["thread",124649],["thread",71741],["thread",131336],["thread",58334],["thread",41290],["thread",105863],["thread",61666],["thread",95877],["thread",135542],["thread",61122],["thread",81453],["thread",62003],["thread",61410],["thread",90762],["thread",56370],["thread",100161],["thread",41971],["thread",62165],["thread",81091],["thread",105387],["thread",48150],["thread",112418],["thread",123689],["thread",48472],["thread",58715],["thread",61489],["thread",116441],["thread",71369],["thread",113116],["thread",75623],["thread",69972],["thread",72010],["thread",101658],["thread",73705],["thread",93273],["thread",102915],["thread",71789],["thread",100955],["thread",110534],["thread",135697],["thread",67727],["thread",118461],["thread",52434],["thread",117708],["thread",130964],["thread",119781],["thread",112366],["thread",55010],["thread",86177],["thread",55799],["thread",71956],["thread",78991],["thread",54504],["thread",38670],["thread",94123],["thread",83751],["thread",85825],["thread",67242],["thread",54009],["thread",115578],["thread",127864],["thread",115650],["thread",83611],["thread",59417],["thread",135741],["thread",61364],["thread",121595],["thread",124645],["thread",62239],["thread",90424],["thread",103090],["thread",66571],["thread",59600],["thread",85194],["thread",85634],["thread",123411],["thread",106626],["thread",101832],["thread",77406],["thread",123690],["thread",127398],["thread",127338],["thread",44603],["thread",37698],["thread",87584],["thread",88228],["thread",69260],["thread",79767],["thread",58956],["thread",128255],["thread",64952],["thread",60874],["thread",125138],["thread",113378],["thread",105007],["thread",71646],["thread",126100],["thread",133347],["thread",128685]]
Run Time: 0.002432
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.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |