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 (112749, 83751, 96534, 103879, 96562, 36397, 107593, 19683, 132152, 128257, 105725, 135542, 68884, 72848, 110543, 133086, 132839, 20480, 99263, 57426, 101741, 59021, 133733, 130646, 59411, 123482, 83579, 121207, 110808, 46346, 44520, 48784, 52140, 135506, 122556, 107200, 95499, 132556, 62764, 117461, 87731, 54504, 112914, 47586, 125872, 49444, 23634, 83701, 94257, 94211, 107358, 61859, 93361, 63463, 116879, 67947, 125715, 84631, 99248, 52356, 66550, 120481, 122382, 35906, 96133, 49026, 124393, 112348, 97064, 67285, 113277, 38659, 112365, 49814, 32046, 52383, 51182, 120869, 105506, 86078, 45222, 74889, 85706, 125767, 98533, 110223, 106372, 117269, 111567, 84959, 108022, 101451, 25240, 38671, 112549, 108691, 95888, 77646, 91531, 57593, 106512, 52638, 134562, 102585, 69396, 66113, 96371, 84921, 59805, 50689, 127441, 125074, 64897, 70891, 109356, 94350, 54047, 65197, 85029, 77538, 64024, 100608, 131913, 59505, 133986, 115954, 61555, 74800, 57419, 117168, 105623, 133690, 67081, 85776, 71298, 54503, 88140, 86919, 56294, 82716, 58228, 133353, 118707, 71646, 65163, 119152, 97506, 101711, 63054, 72797, 129921, 87674, 64971, 61430, 37724, 69972, 61836, 133410, 84737, 91191, 112440, 78676, 28170, 94765, 66916, 129061, 122443, 116185, 96950, 59032, 103617, 52908, 47675, 44602, 61572, 133149, 67648, 47167, 110354, 121193, 79784, 121979, 41063, 91937, 132744, 94479, 83722, 118553, 135925, 43403, 106842, 64426, 94825, 91453, 120198, 33586, 60352, 65736, 58424, 45857, 53714, 106432, 125360, 135137, 73792, 120381, 79969, 94975, 79115, 34006, 55505, 133678, 88955, 79995, 125868, 69020, 30532, 113556, 45693, 123966, 94646, 109172, 47588, 52265, 56623, 93442, 71103, 47879, 52274, 89252, 84656, 40780, 109291, 114785, 136562, 95898, 79778, 108799, 131745, 88432, 65343, 129062, 53666, 62347, 43766, 90216, 41588, 101658, 99477, 19845, 123911, 100534, 68034, 72747, 127253, 74849, 66499, 121997, 49430, 114491, 88646, 41752, 24124, 37452, 90497, 103929, 120526, 113034, 116051, 131239, 7982, 72229, 126243, 104075, 68115, 65181, 92408, 74216, 63344, 126342, 85969, 57758, 80199, 63819, 47258, 100385, 132465, 30103, 101174, 119782, 80266, 51005, 97416, 85857, 91381, 55155, 86564, 65948, 84585, 119312)
Run Time: 0.010915
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: 1511, 0, 1713560868, 1713564468, [["thread",112749],["thread",83751],["thread",96534],["thread",103879],["thread",96562],["thread",36397],["thread",107593],["thread",19683],["thread",132152],["thread",128257],["thread",105725],["thread",135542],["thread",68884],["thread",72848],["thread",110543],["thread",133086],["thread",132839],["thread",20480],["thread",99263],["thread",57426],["thread",101741],["thread",59021],["thread",133733],["thread",130646],["thread",59411],["thread",123482],["thread",83579],["thread",121207],["thread",110808],["thread",46346],["thread",44520],["thread",48784],["thread",52140],["thread",135506],["thread",122556],["thread",107200],["thread",95499],["thread",132556],["thread",62764],["thread",117461],["thread",87731],["thread",54504],["thread",112914],["thread",47586],["thread",125872],["thread",49444],["thread",23634],["thread",83701],["thread",94257],["thread",94211],["thread",107358],["thread",61859],["thread",93361],["thread",63463],["thread",116879],["thread",67947],["thread",125715],["thread",84631],["thread",99248],["thread",52356],["thread",66550],["thread",120481],["thread",122382],["thread",35906],["thread",96133],["thread",49026],["thread",124393],["thread",112348],["thread",97064],["thread",67285],["thread",113277],["thread",38659],["thread",112365],["thread",49814],["thread",32046],["thread",52383],["thread",51182],["thread",120869],["thread",105506],["thread",86078],["thread",45222],["thread",74889],["thread",85706],["thread",125767],["thread",98533],["thread",110223],["thread",106372],["thread",117269],["thread",111567],["thread",84959],["thread",108022],["thread",101451],["thread",25240],["thread",38671],["thread",112549],["thread",108691],["thread",95888],["thread",77646],["thread",91531],["thread",57593],["thread",106512],["thread",52638],["thread",134562],["thread",102585],["thread",69396],["thread",66113],["thread",96371],["thread",84921],["thread",59805],["thread",50689],["thread",127441],["thread",125074],["thread",64897],["thread",70891],["thread",109356],["thread",94350],["thread",54047],["thread",65197],["thread",85029],["thread",77538],["thread",64024],["thread",100608],["thread",131913],["thread",59505],["thread",133986],["thread",115954],["thread",61555],["thread",74800],["thread",57419],["thread",117168],["thread",105623],["thread",133690],["thread",67081],["thread",85776],["thread",71298],["thread",54503],["thread",88140],["thread",86919],["thread",56294],["thread",82716],["thread",58228],["thread",133353],["thread",118707],["thread",71646],["thread",65163],["thread",119152],["thread",97506],["thread",101711],["thread",63054],["thread",72797],["thread",129921],["thread",87674],["thread",64971],["thread",61430],["thread",37724],["thread",69972],["thread",61836],["thread",133410],["thread",84737],["thread",91191],["thread",112440],["thread",78676],["thread",28170],["thread",94765],["thread",66916],["thread",129061],["thread",122443],["thread",116185],["thread",96950],["thread",59032],["thread",103617],["thread",52908],["thread",47675],["thread",44602],["thread",61572],["thread",133149],["thread",67648],["thread",47167],["thread",110354],["thread",121193],["thread",79784],["thread",121979],["thread",41063],["thread",91937],["thread",132744],["thread",94479],["thread",83722],["thread",118553],["thread",135925],["thread",43403],["thread",106842],["thread",64426],["thread",94825],["thread",91453],["thread",120198],["thread",33586],["thread",60352],["thread",65736],["thread",58424],["thread",45857],["thread",53714],["thread",106432],["thread",125360],["thread",135137],["thread",73792],["thread",120381],["thread",79969],["thread",94975],["thread",79115],["thread",34006],["thread",55505],["thread",133678],["thread",88955],["thread",79995],["thread",125868],["thread",69020],["thread",30532],["thread",113556],["thread",45693],["thread",123966],["thread",94646],["thread",109172],["thread",47588],["thread",52265],["thread",56623],["thread",93442],["thread",71103],["thread",47879],["thread",52274],["thread",89252],["thread",84656],["thread",40780],["thread",109291],["thread",114785],["thread",136562],["thread",95898],["thread",79778],["thread",108799],["thread",131745],["thread",88432],["thread",65343],["thread",129062],["thread",53666],["thread",62347],["thread",43766],["thread",90216],["thread",41588],["thread",101658],["thread",99477],["thread",19845],["thread",123911],["thread",100534],["thread",68034],["thread",72747],["thread",127253],["thread",74849],["thread",66499],["thread",121997],["thread",49430],["thread",114491],["thread",88646],["thread",41752],["thread",24124],["thread",37452],["thread",90497],["thread",103929],["thread",120526],["thread",113034],["thread",116051],["thread",131239],["thread",7982],["thread",72229],["thread",126243],["thread",104075],["thread",68115],["thread",65181],["thread",92408],["thread",74216],["thread",63344],["thread",126342],["thread",85969],["thread",57758],["thread",80199],["thread",63819],["thread",47258],["thread",100385],["thread",132465],["thread",30103],["thread",101174],["thread",119782],["thread",80266],["thread",51005],["thread",97416],["thread",85857],["thread",91381],["thread",55155],["thread",86564],["thread",65948],["thread",84585],["thread",119312]]
Run Time: 0.007294
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |