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 (108219, 105503, 111233, 71628, 61757, 110842, 91485, 23305, 34356, 42278, 109151, 48685, 70218, 34388, 128685, 92041, 91309, 81819, 132419, 127712, 32877, 127567, 128422, 34570, 51479, 101424, 63742, 112160, 9080, 20148, 114162, 121729, 126218, 64610, 114954, 54478, 11114, 96696, 99539, 39586, 120017, 48282, 47406, 68849, 106647, 110753, 106535, 80650, 72059, 4312, 90762, 71743, 92724, 88679, 62982, 89814, 108453, 111449, 133020, 136081, 135957, 108495, 23389, 81309, 130646, 119003, 124295, 79900, 113045, 129125, 128513, 124661, 62061, 93945, 69098, 34099, 30115, 36226, 48347, 127253, 39105, 85079, 47502, 117177, 37524, 133678, 87945, 123719, 124035, 118962, 60546, 75067, 52512, 94241, 15475, 67966, 33299, 95691, 113715, 136424, 135782, 2719, 99813, 11748, 123822, 97708, 111529, 126770, 91031, 120614, 134579, 109305, 113111, 126952, 91095, 119839, 13993, 124037, 74979, 113081, 48665, 115119, 30659, 105126, 114479, 114565, 84183, 114067, 10842, 89720, 71902, 85570, 90508, 100281, 108528, 105226, 64928, 82587, 126004, 80518, 97075, 119636, 33404, 100922, 25800, 85377, 112942, 62528, 50448, 37749, 78098, 34432, 95161, 32396, 112580, 127186, 94645, 133410, 32953, 40550, 127328, 111177, 120722, 37246, 67476, 102734, 135867, 36137, 33723, 133625, 33919, 115218, 131120, 80149, 118864, 17203, 13623, 73640, 39428, 14747, 9016, 112298, 85408, 84170, 39320, 88190, 39469, 26391, 125137, 66499, 54284, 85969, 35684, 52949, 129827, 129520, 85596, 60034, 38951, 37774, 105565, 57426, 29738, 77110, 82466, 85792, 88139, 48225, 122378, 118580, 48796, 69514, 17089, 123232, 89800, 136257, 102950, 132169, 9367, 117721, 39783, 13046, 34447, 66518, 94153, 100330, 16458, 91812, 118524, 100385, 119733, 54858, 118588, 71873, 57013, 132240, 14107, 58823, 126225, 105533, 113670, 57737, 132327, 69557, 91030, 36384, 102553, 120415, 48757, 120801, 123438, 86817, 24802, 28490, 120412, 36331, 54950, 109571, 53549, 65180, 16388, 17533, 56699, 117694, 68700, 133513, 86703, 132477, 79329, 79680, 83771, 11430, 131392, 118063, 107985, 93910, 82088, 47460, 8592, 25739, 134993, 24386, 107214, 36700, 34686, 114492, 101657, 109317, 34406, 48503, 129859, 73352, 102475, 113684, 52954, 62479, 136512, 49598, 125927, 118484)
Run Time: 0.041093
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: 1349, 0, 1714034452, 1714038052, [["thread",108219],["thread",105503],["thread",111233],["thread",71628],["thread",61757],["thread",110842],["thread",91485],["thread",23305],["thread",34356],["thread",42278],["thread",109151],["thread",48685],["thread",70218],["thread",34388],["thread",128685],["thread",92041],["thread",91309],["thread",81819],["thread",132419],["thread",127712],["thread",32877],["thread",127567],["thread",128422],["thread",34570],["thread",51479],["thread",101424],["thread",63742],["thread",112160],["thread",9080],["thread",20148],["thread",114162],["thread",121729],["thread",126218],["thread",64610],["thread",114954],["thread",54478],["thread",11114],["thread",96696],["thread",99539],["thread",39586],["thread",120017],["thread",48282],["thread",47406],["thread",68849],["thread",106647],["thread",110753],["thread",106535],["thread",80650],["thread",72059],["thread",4312],["thread",90762],["thread",71743],["thread",92724],["thread",88679],["thread",62982],["thread",89814],["thread",108453],["thread",111449],["thread",133020],["thread",136081],["thread",135957],["thread",108495],["thread",23389],["thread",81309],["thread",130646],["thread",119003],["thread",124295],["thread",79900],["thread",113045],["thread",129125],["thread",128513],["thread",124661],["thread",62061],["thread",93945],["thread",69098],["thread",34099],["thread",30115],["thread",36226],["thread",48347],["thread",127253],["thread",39105],["thread",85079],["thread",47502],["thread",117177],["thread",37524],["thread",133678],["thread",87945],["thread",123719],["thread",124035],["thread",118962],["thread",60546],["thread",75067],["thread",52512],["thread",94241],["thread",15475],["thread",67966],["thread",33299],["thread",95691],["thread",113715],["thread",136424],["thread",135782],["thread",2719],["thread",99813],["thread",11748],["thread",123822],["thread",97708],["thread",111529],["thread",126770],["thread",91031],["thread",120614],["thread",134579],["thread",109305],["thread",113111],["thread",126952],["thread",91095],["thread",119839],["thread",13993],["thread",124037],["thread",74979],["thread",113081],["thread",48665],["thread",115119],["thread",30659],["thread",105126],["thread",114479],["thread",114565],["thread",84183],["thread",114067],["thread",10842],["thread",89720],["thread",71902],["thread",85570],["thread",90508],["thread",100281],["thread",108528],["thread",105226],["thread",64928],["thread",82587],["thread",126004],["thread",80518],["thread",97075],["thread",119636],["thread",33404],["thread",100922],["thread",25800],["thread",85377],["thread",112942],["thread",62528],["thread",50448],["thread",37749],["thread",78098],["thread",34432],["thread",95161],["thread",32396],["thread",112580],["thread",127186],["thread",94645],["thread",133410],["thread",32953],["thread",40550],["thread",127328],["thread",111177],["thread",120722],["thread",37246],["thread",67476],["thread",102734],["thread",135867],["thread",36137],["thread",33723],["thread",133625],["thread",33919],["thread",115218],["thread",131120],["thread",80149],["thread",118864],["thread",17203],["thread",13623],["thread",73640],["thread",39428],["thread",14747],["thread",9016],["thread",112298],["thread",85408],["thread",84170],["thread",39320],["thread",88190],["thread",39469],["thread",26391],["thread",125137],["thread",66499],["thread",54284],["thread",85969],["thread",35684],["thread",52949],["thread",129827],["thread",129520],["thread",85596],["thread",60034],["thread",38951],["thread",37774],["thread",105565],["thread",57426],["thread",29738],["thread",77110],["thread",82466],["thread",85792],["thread",88139],["thread",48225],["thread",122378],["thread",118580],["thread",48796],["thread",69514],["thread",17089],["thread",123232],["thread",89800],["thread",136257],["thread",102950],["thread",132169],["thread",9367],["thread",117721],["thread",39783],["thread",13046],["thread",34447],["thread",66518],["thread",94153],["thread",100330],["thread",16458],["thread",91812],["thread",118524],["thread",100385],["thread",119733],["thread",54858],["thread",118588],["thread",71873],["thread",57013],["thread",132240],["thread",14107],["thread",58823],["thread",126225],["thread",105533],["thread",113670],["thread",57737],["thread",132327],["thread",69557],["thread",91030],["thread",36384],["thread",102553],["thread",120415],["thread",48757],["thread",120801],["thread",123438],["thread",86817],["thread",24802],["thread",28490],["thread",120412],["thread",36331],["thread",54950],["thread",109571],["thread",53549],["thread",65180],["thread",16388],["thread",17533],["thread",56699],["thread",117694],["thread",68700],["thread",133513],["thread",86703],["thread",132477],["thread",79329],["thread",79680],["thread",83771],["thread",11430],["thread",131392],["thread",118063],["thread",107985],["thread",93910],["thread",82088],["thread",47460],["thread",8592],["thread",25739],["thread",134993],["thread",24386],["thread",107214],["thread",36700],["thread",34686],["thread",114492],["thread",101657],["thread",109317],["thread",34406],["thread",48503],["thread",129859],["thread",73352],["thread",102475],["thread",113684],["thread",52954],["thread",62479],["thread",136512],["thread",49598],["thread",125927],["thread",118484]]
Run Time: 0.002042
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 |