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 (68201, 83913, 128992, 68782, 115941, 76118, 70133, 91585, 110250, 86821, 44806, 97172, 46965, 103399, 78977, 44366, 98025, 71618, 102596, 81489, 83163, 88758, 88802, 70675, 66305, 83267, 106434, 68505, 66840, 46995, 86229, 113227, 81688, 113445, 72040, 96891, 77591, 82668, 112564, 57590, 89551, 133767, 136614, 82246, 95114, 71660, 71461, 92740, 66302, 99043, 69268, 111765, 90459, 95725, 68776, 84366, 109824, 68733, 86140, 71420, 79727, 106382, 113805, 84897, 66878, 78089, 103177, 44332, 74644, 68038, 71958, 104551, 72038, 107911, 122532, 68790, 108610, 132711, 65075, 76416, 92150, 127142, 67062, 47354, 93788, 72838, 102410, 107884, 99684, 106819, 68202, 71421, 65064, 70835, 68734, 79125, 75197, 97015, 94319, 78448, 62030, 44367, 90721, 99631, 72027, 90889, 68723, 78989, 43879, 74863, 47694, 78602, 84423, 72553, 135227, 84485, 85621, 68843, 82252, 81515, 131815, 68839, 65560, 104394, 102226, 65232, 82840, 135791, 110955, 44804, 63869, 114256, 85667, 105241, 110556, 89563, 100576, 96663, 86144, 68080, 102304, 84178, 87342, 135168, 75203, 120742, 71389, 92010, 79328, 116171, 107491, 44803, 73722, 80794, 70846, 100953, 71712, 71785, 123493, 105236, 86295, 105414, 70498, 109437, 84124, 99108, 105699, 83704, 69398, 44805, 71483, 84368, 82646, 106723, 109228, 69226, 81501, 105691, 80391, 68588, 80966, 80398, 75549, 70371, 67607, 72044, 87763, 86552, 80792, 128347, 84308, 93680, 79362, 69934, 77554, 68264, 134043, 44371, 83613, 92130, 69115, 82259, 78145, 86262, 86268, 107882, 83627, 44558, 66846, 113818, 44414, 91465, 81426, 83250, 92990, 94823, 66361, 86684, 128732, 120365, 76411, 105111, 71359, 99110, 68725, 68464, 67912, 78985, 84369, 84655, 65728, 107757, 68779, 73325, 72595, 111499, 84116, 96975, 76690, 67457, 71244, 66861, 43838, 71221, 44364, 69564, 80396)
Run Time: 0.020564
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 247 | 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: 15246, 0, 1714053121, 1714056721, [["thread",68201],["thread",83913],["thread",128992],["thread",68782],["thread",115941],["thread",76118],["thread",70133],["thread",91585],["thread",110250],["thread",86821],["thread",44806],["thread",97172],["thread",46965],["thread",103399],["thread",78977],["thread",44366],["thread",98025],["thread",71618],["thread",102596],["thread",81489],["thread",83163],["thread",88758],["thread",88802],["thread",70675],["thread",66305],["thread",83267],["thread",106434],["thread",68505],["thread",66840],["thread",46995],["thread",86229],["thread",113227],["thread",81688],["thread",113445],["thread",72040],["thread",96891],["thread",77591],["thread",82668],["thread",112564],["thread",57590],["thread",89551],["thread",133767],["thread",136614],["thread",82246],["thread",95114],["thread",71660],["thread",71461],["thread",92740],["thread",66302],["thread",99043],["thread",69268],["thread",111765],["thread",90459],["thread",95725],["thread",68776],["thread",84366],["thread",109824],["thread",68733],["thread",86140],["thread",71420],["thread",79727],["thread",106382],["thread",113805],["thread",84897],["thread",66878],["thread",78089],["thread",103177],["thread",44332],["thread",74644],["thread",68038],["thread",71958],["thread",104551],["thread",72038],["thread",107911],["thread",122532],["thread",68790],["thread",108610],["thread",132711],["thread",65075],["thread",76416],["thread",92150],["thread",127142],["thread",67062],["thread",47354],["thread",93788],["thread",72838],["thread",102410],["thread",107884],["thread",99684],["thread",106819],["thread",68202],["thread",71421],["thread",65064],["thread",70835],["thread",68734],["thread",79125],["thread",75197],["thread",97015],["thread",94319],["thread",78448],["thread",62030],["thread",44367],["thread",90721],["thread",99631],["thread",72027],["thread",90889],["thread",68723],["thread",78989],["thread",43879],["thread",74863],["thread",47694],["thread",78602],["thread",84423],["thread",72553],["thread",135227],["thread",84485],["thread",85621],["thread",68843],["thread",82252],["thread",81515],["thread",131815],["thread",68839],["thread",65560],["thread",104394],["thread",102226],["thread",65232],["thread",82840],["thread",135791],["thread",110955],["thread",44804],["thread",63869],["thread",114256],["thread",85667],["thread",105241],["thread",110556],["thread",89563],["thread",100576],["thread",96663],["thread",86144],["thread",68080],["thread",102304],["thread",84178],["thread",87342],["thread",135168],["thread",75203],["thread",120742],["thread",71389],["thread",92010],["thread",79328],["thread",116171],["thread",107491],["thread",44803],["thread",73722],["thread",80794],["thread",70846],["thread",100953],["thread",71712],["thread",71785],["thread",123493],["thread",105236],["thread",86295],["thread",105414],["thread",70498],["thread",109437],["thread",84124],["thread",99108],["thread",105699],["thread",83704],["thread",69398],["thread",44805],["thread",71483],["thread",84368],["thread",82646],["thread",106723],["thread",109228],["thread",69226],["thread",81501],["thread",105691],["thread",80391],["thread",68588],["thread",80966],["thread",80398],["thread",75549],["thread",70371],["thread",67607],["thread",72044],["thread",87763],["thread",86552],["thread",80792],["thread",128347],["thread",84308],["thread",93680],["thread",79362],["thread",69934],["thread",77554],["thread",68264],["thread",134043],["thread",44371],["thread",83613],["thread",92130],["thread",69115],["thread",82259],["thread",78145],["thread",86262],["thread",86268],["thread",107882],["thread",83627],["thread",44558],["thread",66846],["thread",113818],["thread",44414],["thread",91465],["thread",81426],["thread",83250],["thread",92990],["thread",94823],["thread",66361],["thread",86684],["thread",128732],["thread",120365],["thread",76411],["thread",105111],["thread",71359],["thread",99110],["thread",68725],["thread",68464],["thread",67912],["thread",78985],["thread",84369],["thread",84655],["thread",65728],["thread",107757],["thread",68779],["thread",73325],["thread",72595],["thread",111499],["thread",84116],["thread",96975],["thread",76690],["thread",67457],["thread",71244],["thread",66861],["thread",43838],["thread",71221],["thread",44364],["thread",69564],["thread",80396]]
Run Time: 0.004796
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.000110
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |