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 (71934, 46408, 76416, 80515, 76396, 63935, 69903, 74126, 86471, 86891, 86144, 71958, 40105, 61444, 56005, 113808, 44369, 65638, 58710, 81869, 41587, 72616, 46522, 96574, 132899, 75472, 47783, 69965, 80037, 79476, 65777, 81515, 77527, 81305, 69906, 119577, 73125, 48554, 111869, 76096, 50033, 74023, 86473, 38086, 86893, 47788, 76399, 112386, 47911, 129928, 73023, 82259, 58173, 48128, 85108, 71105, 46186, 86140, 46564, 75352, 82231, 47540, 76139, 66902, 72553, 431, 58253, 47290, 72027, 44414, 73833, 83613, 109302, 71961, 100488, 72595, 46196, 51540, 67960, 44803, 101849, 119841, 77972, 88105, 37740, 74570, 52029, 39140, 57164, 95246, 75203, 87145, 52025, 98913, 82668, 51660, 63712, 85447, 77804, 80179, 79727, 71813, 84323, 811, 45056, 65835, 47569, 46524, 46995, 49719, 47912, 84938, 89838, 36071, 74179, 48357, 112671, 83730, 119562, 73763, 74245, 57655, 72288, 46747, 70374, 68062, 74181, 47570, 92013, 72097, 72371, 77917, 49760, 47568, 62030, 57999, 48052, 77554, 77066, 103810, 81501, 122065, 71483, 47207, 51133, 99743, 48306, 46618, 90006, 81027, 63672, 46184, 84905, 44371, 49576, 95053, 74183, 71420, 51529, 47218, 49961, 95901, 73551, 37219, 69908, 60238, 69195, 77424, 73470, 51837, 82648, 72735, 86497, 82646, 75073, 84116, 70696, 87009, 44474, 47157, 73722, 82118, 81192, 46619, 87403, 77301, 51662, 80036, 9888, 82252, 44556, 45218, 48559, 97668, 119560, 71712, 103997, 76411, 59477, 79258, 47235, 46624, 48286, 10216, 131710, 70493, 46294, 74130, 47357, 58252, 93603, 124459, 47276, 84897, 84366, 74128, 80928, 87256, 47964, 50436, 44441, 45925, 64593, 104081, 74125, 111131, 62216, 44889, 79362, 48509, 52027, 52519, 122777, 122064, 85789, 75823, 80792, 81782, 21260, 77262, 77056, 47156, 52542, 72483, 77723, 76514, 46296, 71589, 58119, 80937, 70847, 48511, 47694, 73726, 88592, 46876, 75155, 77810, 76118, 71221, 46813, 48555, 57143, 77302, 44890, 74182, 60012, 44413, 58450, 77808, 126016, 48467, 83250, 70029, 70431, 47715, 72784, 76465, 59833, 82595, 57265, 86278, 86464, 47672, 86814, 102447, 67042, 44888, 77974, 46521, 104315, 44654, 82840, 77504, 71998, 48215, 48216, 73553, 84655, 104069)
Run Time: 0.005524
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: 6, 0, 1714190318, 1714193918, [["thread",71934],["thread",46408],["thread",76416],["thread",80515],["thread",76396],["thread",63935],["thread",69903],["thread",74126],["thread",86471],["thread",86891],["thread",86144],["thread",71958],["thread",40105],["thread",61444],["thread",56005],["thread",113808],["thread",44369],["thread",65638],["thread",58710],["thread",81869],["thread",41587],["thread",72616],["thread",46522],["thread",96574],["thread",132899],["thread",75472],["thread",47783],["thread",69965],["thread",80037],["thread",79476],["thread",65777],["thread",81515],["thread",77527],["thread",81305],["thread",69906],["thread",119577],["thread",73125],["thread",48554],["thread",111869],["thread",76096],["thread",50033],["thread",74023],["thread",86473],["thread",38086],["thread",86893],["thread",47788],["thread",76399],["thread",112386],["thread",47911],["thread",129928],["thread",73023],["thread",82259],["thread",58173],["thread",48128],["thread",85108],["thread",71105],["thread",46186],["thread",86140],["thread",46564],["thread",75352],["thread",82231],["thread",47540],["thread",76139],["thread",66902],["thread",72553],["thread",431],["thread",58253],["thread",47290],["thread",72027],["thread",44414],["thread",73833],["thread",83613],["thread",109302],["thread",71961],["thread",100488],["thread",72595],["thread",46196],["thread",51540],["thread",67960],["thread",44803],["thread",101849],["thread",119841],["thread",77972],["thread",88105],["thread",37740],["thread",74570],["thread",52029],["thread",39140],["thread",57164],["thread",95246],["thread",75203],["thread",87145],["thread",52025],["thread",98913],["thread",82668],["thread",51660],["thread",63712],["thread",85447],["thread",77804],["thread",80179],["thread",79727],["thread",71813],["thread",84323],["thread",811],["thread",45056],["thread",65835],["thread",47569],["thread",46524],["thread",46995],["thread",49719],["thread",47912],["thread",84938],["thread",89838],["thread",36071],["thread",74179],["thread",48357],["thread",112671],["thread",83730],["thread",119562],["thread",73763],["thread",74245],["thread",57655],["thread",72288],["thread",46747],["thread",70374],["thread",68062],["thread",74181],["thread",47570],["thread",92013],["thread",72097],["thread",72371],["thread",77917],["thread",49760],["thread",47568],["thread",62030],["thread",57999],["thread",48052],["thread",77554],["thread",77066],["thread",103810],["thread",81501],["thread",122065],["thread",71483],["thread",47207],["thread",51133],["thread",99743],["thread",48306],["thread",46618],["thread",90006],["thread",81027],["thread",63672],["thread",46184],["thread",84905],["thread",44371],["thread",49576],["thread",95053],["thread",74183],["thread",71420],["thread",51529],["thread",47218],["thread",49961],["thread",95901],["thread",73551],["thread",37219],["thread",69908],["thread",60238],["thread",69195],["thread",77424],["thread",73470],["thread",51837],["thread",82648],["thread",72735],["thread",86497],["thread",82646],["thread",75073],["thread",84116],["thread",70696],["thread",87009],["thread",44474],["thread",47157],["thread",73722],["thread",82118],["thread",81192],["thread",46619],["thread",87403],["thread",77301],["thread",51662],["thread",80036],["thread",9888],["thread",82252],["thread",44556],["thread",45218],["thread",48559],["thread",97668],["thread",119560],["thread",71712],["thread",103997],["thread",76411],["thread",59477],["thread",79258],["thread",47235],["thread",46624],["thread",48286],["thread",10216],["thread",131710],["thread",70493],["thread",46294],["thread",74130],["thread",47357],["thread",58252],["thread",93603],["thread",124459],["thread",47276],["thread",84897],["thread",84366],["thread",74128],["thread",80928],["thread",87256],["thread",47964],["thread",50436],["thread",44441],["thread",45925],["thread",64593],["thread",104081],["thread",74125],["thread",111131],["thread",62216],["thread",44889],["thread",79362],["thread",48509],["thread",52027],["thread",52519],["thread",122777],["thread",122064],["thread",85789],["thread",75823],["thread",80792],["thread",81782],["thread",21260],["thread",77262],["thread",77056],["thread",47156],["thread",52542],["thread",72483],["thread",77723],["thread",76514],["thread",46296],["thread",71589],["thread",58119],["thread",80937],["thread",70847],["thread",48511],["thread",47694],["thread",73726],["thread",88592],["thread",46876],["thread",75155],["thread",77810],["thread",76118],["thread",71221],["thread",46813],["thread",48555],["thread",57143],["thread",77302],["thread",44890],["thread",74182],["thread",60012],["thread",44413],["thread",58450],["thread",77808],["thread",126016],["thread",48467],["thread",83250],["thread",70029],["thread",70431],["thread",47715],["thread",72784],["thread",76465],["thread",59833],["thread",82595],["thread",57265],["thread",86278],["thread",86464],["thread",47672],["thread",86814],["thread",102447],["thread",67042],["thread",44888],["thread",77974],["thread",46521],["thread",104315],["thread",44654],["thread",82840],["thread",77504],["thread",71998],["thread",48215],["thread",48216],["thread",73553],["thread",84655],["thread",104069]]
Run Time: 0.001575
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.000076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |