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 (113813, 59559, 40216, 83729, 125944, 36712, 50308, 435, 49217, 130739, 73774, 89439, 125352, 100526, 36019, 71425, 97192, 50175, 97667, 95887, 88572, 72750, 136054, 105121, 55887, 90887, 88291, 102919, 16191, 128030, 87548, 60939, 108403, 61778, 48652, 47729, 124942, 57868, 50420, 65751, 48835, 25078, 88381, 87024, 596, 102611, 38186, 706, 22315, 118953, 80742, 24639, 117484, 114203, 71740, 103794, 52643, 61697, 131495, 41081, 59512, 48059, 33730, 79646, 119300, 73275, 49672, 131427, 116823, 120288, 78527, 105536, 67261, 76627, 70225, 21695, 76381, 39165, 63254, 51347, 39897, 133463, 88286, 51780, 79809, 129565, 12788, 98859, 74740, 125344, 41014, 117227, 101772, 86314, 76119, 776, 54622, 129692, 85223, 111761, 61832, 128843, 100193, 134680, 53324, 86901, 80275, 112509, 57489, 34201, 45578, 121242, 121807, 120585, 127453, 86054, 84534, 108411, 72567, 127752, 125677, 77965, 19206, 38435, 98418, 95424, 60443, 33028, 122076, 98050, 114904, 42230, 95487, 55886, 5944, 135313, 56333, 1988, 76088, 76645, 40873, 90235, 96964, 93135, 85695, 130695, 76978, 89057, 77567, 128446, 103486, 130860, 119381, 87176, 119748, 63169, 131937, 24359, 87782, 93577, 60485, 85395, 119640, 86520, 88778, 122124, 104646, 874, 113603, 55816, 114788, 57228, 112312, 39965, 95408, 111401, 117425, 58878, 18267, 97010, 54947, 86309, 93302, 96552, 134993, 93565, 94260, 116041, 22693, 4856, 56158, 64588, 131315, 40468, 125434, 95135, 51761, 94826, 57737, 104427, 68029, 107933, 133338, 56130, 99857, 60078, 80436, 129238, 91325, 75388, 131073, 10083, 94673, 78804, 56588, 119221, 58879, 871, 49517, 128356, 113822, 36569, 104371, 119435, 55837, 110856, 127512, 94559, 83394, 58864, 88534, 53197, 124811, 85210, 120665, 87626, 109152, 7357, 61304, 95756, 45541, 102469, 90397, 93664, 85764, 57822, 121708, 128319, 125657, 114528, 55607, 52368, 127908, 6606, 56127, 93905, 61359, 822, 79926, 52178, 872, 50230, 60319, 103036, 89644, 125223, 77381, 119362, 56382, 89415, 84853, 128802, 91156, 71039, 64149, 94660, 120683, 131459, 95535, 90781, 63859, 81351, 84906, 69021, 124085, 53742, 125442, 120211, 111792, 119816, 104542, 62793, 94361, 83594, 69675, 10931, 73739, 44324, 66465, 14995)
Run Time: 0.377014
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 300 | 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: 20, 0, 1715339777, 1715343377, [["thread",113813],["thread",59559],["thread",40216],["thread",83729],["thread",125944],["thread",36712],["thread",50308],["thread",435],["thread",49217],["thread",130739],["thread",73774],["thread",89439],["thread",125352],["thread",100526],["thread",36019],["thread",71425],["thread",97192],["thread",50175],["thread",97667],["thread",95887],["thread",88572],["thread",72750],["thread",136054],["thread",105121],["thread",55887],["thread",90887],["thread",88291],["thread",102919],["thread",16191],["thread",128030],["thread",87548],["thread",60939],["thread",108403],["thread",61778],["thread",48652],["thread",47729],["thread",124942],["thread",57868],["thread",50420],["thread",65751],["thread",48835],["thread",25078],["thread",88381],["thread",87024],["thread",596],["thread",102611],["thread",38186],["thread",706],["thread",22315],["thread",118953],["thread",80742],["thread",24639],["thread",117484],["thread",114203],["thread",71740],["thread",103794],["thread",52643],["thread",61697],["thread",131495],["thread",41081],["thread",59512],["thread",48059],["thread",33730],["thread",79646],["thread",119300],["thread",73275],["thread",49672],["thread",131427],["thread",116823],["thread",120288],["thread",78527],["thread",105536],["thread",67261],["thread",76627],["thread",70225],["thread",21695],["thread",76381],["thread",39165],["thread",63254],["thread",51347],["thread",39897],["thread",133463],["thread",88286],["thread",51780],["thread",79809],["thread",129565],["thread",12788],["thread",98859],["thread",74740],["thread",125344],["thread",41014],["thread",117227],["thread",101772],["thread",86314],["thread",76119],["thread",776],["thread",54622],["thread",129692],["thread",85223],["thread",111761],["thread",61832],["thread",128843],["thread",100193],["thread",134680],["thread",53324],["thread",86901],["thread",80275],["thread",112509],["thread",57489],["thread",34201],["thread",45578],["thread",121242],["thread",121807],["thread",120585],["thread",127453],["thread",86054],["thread",84534],["thread",108411],["thread",72567],["thread",127752],["thread",125677],["thread",77965],["thread",19206],["thread",38435],["thread",98418],["thread",95424],["thread",60443],["thread",33028],["thread",122076],["thread",98050],["thread",114904],["thread",42230],["thread",95487],["thread",55886],["thread",5944],["thread",135313],["thread",56333],["thread",1988],["thread",76088],["thread",76645],["thread",40873],["thread",90235],["thread",96964],["thread",93135],["thread",85695],["thread",130695],["thread",76978],["thread",89057],["thread",77567],["thread",128446],["thread",103486],["thread",130860],["thread",119381],["thread",87176],["thread",119748],["thread",63169],["thread",131937],["thread",24359],["thread",87782],["thread",93577],["thread",60485],["thread",85395],["thread",119640],["thread",86520],["thread",88778],["thread",122124],["thread",104646],["thread",874],["thread",113603],["thread",55816],["thread",114788],["thread",57228],["thread",112312],["thread",39965],["thread",95408],["thread",111401],["thread",117425],["thread",58878],["thread",18267],["thread",97010],["thread",54947],["thread",86309],["thread",93302],["thread",96552],["thread",134993],["thread",93565],["thread",94260],["thread",116041],["thread",22693],["thread",4856],["thread",56158],["thread",64588],["thread",131315],["thread",40468],["thread",125434],["thread",95135],["thread",51761],["thread",94826],["thread",57737],["thread",104427],["thread",68029],["thread",107933],["thread",133338],["thread",56130],["thread",99857],["thread",60078],["thread",80436],["thread",129238],["thread",91325],["thread",75388],["thread",131073],["thread",10083],["thread",94673],["thread",78804],["thread",56588],["thread",119221],["thread",58879],["thread",871],["thread",49517],["thread",128356],["thread",113822],["thread",36569],["thread",104371],["thread",119435],["thread",55837],["thread",110856],["thread",127512],["thread",94559],["thread",83394],["thread",58864],["thread",88534],["thread",53197],["thread",124811],["thread",85210],["thread",120665],["thread",87626],["thread",109152],["thread",7357],["thread",61304],["thread",95756],["thread",45541],["thread",102469],["thread",90397],["thread",93664],["thread",85764],["thread",57822],["thread",121708],["thread",128319],["thread",125657],["thread",114528],["thread",55607],["thread",52368],["thread",127908],["thread",6606],["thread",56127],["thread",93905],["thread",61359],["thread",822],["thread",79926],["thread",52178],["thread",872],["thread",50230],["thread",60319],["thread",103036],["thread",89644],["thread",125223],["thread",77381],["thread",119362],["thread",56382],["thread",89415],["thread",84853],["thread",128802],["thread",91156],["thread",71039],["thread",64149],["thread",94660],["thread",120683],["thread",131459],["thread",95535],["thread",90781],["thread",63859],["thread",81351],["thread",84906],["thread",69021],["thread",124085],["thread",53742],["thread",125442],["thread",120211],["thread",111792],["thread",119816],["thread",104542],["thread",62793],["thread",94361],["thread",83594],["thread",69675],["thread",10931],["thread",73739],["thread",44324],["thread",66465],["thread",14995]]
Run Time: 0.065485
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.000097
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |