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 (103920, 84752, 88480, 73454, 107707, 99906, 115529, 122996, 57071, 106477, 87349, 105284, 115981, 54059, 72828, 87795, 111055, 51005, 90566, 119607, 127204, 56445, 87421, 108160, 128802, 125023, 116315, 94523, 128761, 53014, 49212, 128843, 56599, 52572, 125344, 62952, 132608, 39886, 73675, 95809, 52760, 114500, 94980, 48111, 61564, 134991, 54742, 122165, 63780, 109653, 21588, 124609, 48370, 103436, 95810, 115472, 91705, 47658, 127908, 97678, 107918, 89504, 84015, 14561, 64681, 36857, 70310, 21716, 85818, 115485, 107913, 101160, 62180, 101055, 60131, 105848, 126767, 124319, 126075, 99627, 127131, 97292, 78298, 112591, 124033, 81693, 32370, 14695, 51552, 105285, 48830, 87509, 23288, 135104, 49791, 68840, 124539, 113274, 52325, 106746, 133020, 107968, 86384, 119621, 128006, 113756, 115487, 126713, 87782, 133004, 108355, 116513, 128940, 41180, 89301, 73786, 91419, 60244, 74799, 71219, 19540, 129238, 105819, 97612, 44320, 79969, 62812, 39897, 90497, 128704, 89367, 64698, 89299, 111952, 75410, 103756, 52659, 62847, 55237, 101839, 124649, 128988, 48530, 103995, 123000, 95120, 119420, 52618, 74815, 16985, 52780, 63800, 104839, 123626, 108403, 85426, 41359, 127203, 96841, 93759, 110214, 117513, 70521, 14640, 113205, 36066, 107302, 52776, 48946, 22596, 61609, 131239, 67346, 85754, 73416, 104271, 88054, 80603, 127538, 115484, 109934, 47500, 58297, 115482, 60022, 134116, 121380, 125352, 49363, 97553, 127909, 65438, 127950, 92561, 53683, 124219, 125143, 89781, 16237, 16009, 136747, 61567, 33145, 76698, 52624, 119610, 124203, 93302, 85577, 52718, 44226, 114908, 84718, 57559, 44157, 103423, 41386, 88098, 90386, 128356, 59011, 90058, 128307, 94101, 38131, 73785, 41157, 26587, 69830, 52383, 109152, 98219, 87818, 18932, 36841, 87856, 85308, 131350, 49276, 83830, 127842, 55193, 87786, 103608, 40521, 126594, 81629, 76066, 124549, 74538, 125803, 88183, 78152, 78684, 115480, 49454, 117530, 72679, 56522, 113297, 91826, 113181, 85563, 52394, 91738, 91337, 69834, 21281, 36377, 52626, 124762, 30225, 66807, 58795, 83161, 61572, 127601, 105179, 112817, 52933, 85651, 58698, 48708, 135070, 59084, 52612, 77047, 45803, 42854, 85325)
Run Time: 0.026357
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 290 | 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: 1390, 0, 1714109209, 1714112809, [["thread",103920],["thread",84752],["thread",88480],["thread",73454],["thread",107707],["thread",99906],["thread",115529],["thread",122996],["thread",57071],["thread",106477],["thread",87349],["thread",105284],["thread",115981],["thread",54059],["thread",72828],["thread",87795],["thread",111055],["thread",51005],["thread",90566],["thread",119607],["thread",127204],["thread",56445],["thread",87421],["thread",108160],["thread",128802],["thread",125023],["thread",116315],["thread",94523],["thread",128761],["thread",53014],["thread",49212],["thread",128843],["thread",56599],["thread",52572],["thread",125344],["thread",62952],["thread",132608],["thread",39886],["thread",73675],["thread",95809],["thread",52760],["thread",114500],["thread",94980],["thread",48111],["thread",61564],["thread",134991],["thread",54742],["thread",122165],["thread",63780],["thread",109653],["thread",21588],["thread",124609],["thread",48370],["thread",103436],["thread",95810],["thread",115472],["thread",91705],["thread",47658],["thread",127908],["thread",97678],["thread",107918],["thread",89504],["thread",84015],["thread",14561],["thread",64681],["thread",36857],["thread",70310],["thread",21716],["thread",85818],["thread",115485],["thread",107913],["thread",101160],["thread",62180],["thread",101055],["thread",60131],["thread",105848],["thread",126767],["thread",124319],["thread",126075],["thread",99627],["thread",127131],["thread",97292],["thread",78298],["thread",112591],["thread",124033],["thread",81693],["thread",32370],["thread",14695],["thread",51552],["thread",105285],["thread",48830],["thread",87509],["thread",23288],["thread",135104],["thread",49791],["thread",68840],["thread",124539],["thread",113274],["thread",52325],["thread",106746],["thread",133020],["thread",107968],["thread",86384],["thread",119621],["thread",128006],["thread",113756],["thread",115487],["thread",126713],["thread",87782],["thread",133004],["thread",108355],["thread",116513],["thread",128940],["thread",41180],["thread",89301],["thread",73786],["thread",91419],["thread",60244],["thread",74799],["thread",71219],["thread",19540],["thread",129238],["thread",105819],["thread",97612],["thread",44320],["thread",79969],["thread",62812],["thread",39897],["thread",90497],["thread",128704],["thread",89367],["thread",64698],["thread",89299],["thread",111952],["thread",75410],["thread",103756],["thread",52659],["thread",62847],["thread",55237],["thread",101839],["thread",124649],["thread",128988],["thread",48530],["thread",103995],["thread",123000],["thread",95120],["thread",119420],["thread",52618],["thread",74815],["thread",16985],["thread",52780],["thread",63800],["thread",104839],["thread",123626],["thread",108403],["thread",85426],["thread",41359],["thread",127203],["thread",96841],["thread",93759],["thread",110214],["thread",117513],["thread",70521],["thread",14640],["thread",113205],["thread",36066],["thread",107302],["thread",52776],["thread",48946],["thread",22596],["thread",61609],["thread",131239],["thread",67346],["thread",85754],["thread",73416],["thread",104271],["thread",88054],["thread",80603],["thread",127538],["thread",115484],["thread",109934],["thread",47500],["thread",58297],["thread",115482],["thread",60022],["thread",134116],["thread",121380],["thread",125352],["thread",49363],["thread",97553],["thread",127909],["thread",65438],["thread",127950],["thread",92561],["thread",53683],["thread",124219],["thread",125143],["thread",89781],["thread",16237],["thread",16009],["thread",136747],["thread",61567],["thread",33145],["thread",76698],["thread",52624],["thread",119610],["thread",124203],["thread",93302],["thread",85577],["thread",52718],["thread",44226],["thread",114908],["thread",84718],["thread",57559],["thread",44157],["thread",103423],["thread",41386],["thread",88098],["thread",90386],["thread",128356],["thread",59011],["thread",90058],["thread",128307],["thread",94101],["thread",38131],["thread",73785],["thread",41157],["thread",26587],["thread",69830],["thread",52383],["thread",109152],["thread",98219],["thread",87818],["thread",18932],["thread",36841],["thread",87856],["thread",85308],["thread",131350],["thread",49276],["thread",83830],["thread",127842],["thread",55193],["thread",87786],["thread",103608],["thread",40521],["thread",126594],["thread",81629],["thread",76066],["thread",124549],["thread",74538],["thread",125803],["thread",88183],["thread",78152],["thread",78684],["thread",115480],["thread",49454],["thread",117530],["thread",72679],["thread",56522],["thread",113297],["thread",91826],["thread",113181],["thread",85563],["thread",52394],["thread",91738],["thread",91337],["thread",69834],["thread",21281],["thread",36377],["thread",52626],["thread",124762],["thread",30225],["thread",66807],["thread",58795],["thread",83161],["thread",61572],["thread",127601],["thread",105179],["thread",112817],["thread",52933],["thread",85651],["thread",58698],["thread",48708],["thread",135070],["thread",59084],["thread",52612],["thread",77047],["thread",45803],["thread",42854],["thread",85325]]
Run Time: 0.001172
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.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |