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