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 (71483, 70957, 73325, 69414, 69348, 87347, 71958, 76923, 77087, 72040, 71389, 82840, 68734, 86262, 77355, 63869, 88512, 91239, 108299, 69771, 70177, 80970, 72580, 72097, 79431, 79588, 112197, 44415, 81489, 92203, 86946, 69976, 95552, 68202, 44367, 70696, 86679, 73124, 68723, 67783, 95001, 83704, 108080, 84897, 67786, 85532, 81688, 98913, 68960, 61538, 94235, 68486, 67997, 68725, 87280, 53029, 109333, 71105, 107823, 108189, 70962, 107717, 49905, 121239, 87814, 69604, 69720, 73724, 77374, 69580, 67941, 78971, 68020, 82668, 79587, 65471, 113805, 87117, 79362, 104951, 67102, 76536, 81501, 73726, 72027, 78936, 78977, 108033, 88445, 71213, 55033, 92156, 86268, 68782, 73179, 68462, 67211, 88235, 72714, 85621, 68832, 80794, 66361, 55510, 70675, 107489, 67875, 100576, 77948, 89647, 79125, 126019, 75985, 87526, 88817, 74491, 86721, 93159, 68201, 69622, 91013, 93141, 71618, 80129, 80862, 66192, 80792, 72044, 95725, 84916, 109585, 66540, 69903, 68986, 88357, 90373, 70835, 90049, 102852, 65064, 80396, 68733, 70431, 43979, 71017, 103174, 69861, 52635, 71359, 78477, 70631, 42254, 89867, 93003, 86868, 73125, 71660, 107673, 87246, 69895, 71420, 108300, 70846, 74644, 70243, 72038, 93726, 84303, 68875, 79649, 73553, 108584, 80280, 97614, 70302, 68038, 68588, 77917, 135641, 24491, 84368, 104247, 72944, 68591, 90889, 75475, 69539, 103402, 93961, 128688, 68752, 127196, 76517, 69906, 58753, 69836, 88283, 81560, 100497, 84308, 101095, 67607, 71421, 73080, 95482, 78089, 72737, 75203, 82106, 69195, 74156, 108159, 84178, 82259, 81485, 64046, 93335, 74072, 78985, 71466, 86552, 102041, 73911, 108239, 84655, 69143, 69051, 82438, 106819, 68464, 69373, 122524, 42794, 109045, 61761, 70367, 68699, 69000, 67760, 92174, 91585, 71294, 76113, 83913, 72483, 70498, 92150, 107911, 86952, 77503, 78989, 74454, 116908, 68264, 124757, 72553, 71712, 50847, 94823, 108063, 69226, 71221, 71919, 72697, 86148, 70335, 87981, 83250, 67590, 110869, 73020, 73960, 103396, 71013, 73328, 71622, 99631, 86140, 66859, 80966, 83781, 79328, 44414, 80398, 44371, 124217, 70082, 77591, 89259, 68467, 81515, 68466, 50838, 75352, 68930, 73551, 68965, 72233, 74596, 73023)
Run Time: 0.011801
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: 5617, 0, 1713506679, 1713510279, [["thread",71483],["thread",70957],["thread",73325],["thread",69414],["thread",69348],["thread",87347],["thread",71958],["thread",76923],["thread",77087],["thread",72040],["thread",71389],["thread",82840],["thread",68734],["thread",86262],["thread",77355],["thread",63869],["thread",88512],["thread",91239],["thread",108299],["thread",69771],["thread",70177],["thread",80970],["thread",72580],["thread",72097],["thread",79431],["thread",79588],["thread",112197],["thread",44415],["thread",81489],["thread",92203],["thread",86946],["thread",69976],["thread",95552],["thread",68202],["thread",44367],["thread",70696],["thread",86679],["thread",73124],["thread",68723],["thread",67783],["thread",95001],["thread",83704],["thread",108080],["thread",84897],["thread",67786],["thread",85532],["thread",81688],["thread",98913],["thread",68960],["thread",61538],["thread",94235],["thread",68486],["thread",67997],["thread",68725],["thread",87280],["thread",53029],["thread",109333],["thread",71105],["thread",107823],["thread",108189],["thread",70962],["thread",107717],["thread",49905],["thread",121239],["thread",87814],["thread",69604],["thread",69720],["thread",73724],["thread",77374],["thread",69580],["thread",67941],["thread",78971],["thread",68020],["thread",82668],["thread",79587],["thread",65471],["thread",113805],["thread",87117],["thread",79362],["thread",104951],["thread",67102],["thread",76536],["thread",81501],["thread",73726],["thread",72027],["thread",78936],["thread",78977],["thread",108033],["thread",88445],["thread",71213],["thread",55033],["thread",92156],["thread",86268],["thread",68782],["thread",73179],["thread",68462],["thread",67211],["thread",88235],["thread",72714],["thread",85621],["thread",68832],["thread",80794],["thread",66361],["thread",55510],["thread",70675],["thread",107489],["thread",67875],["thread",100576],["thread",77948],["thread",89647],["thread",79125],["thread",126019],["thread",75985],["thread",87526],["thread",88817],["thread",74491],["thread",86721],["thread",93159],["thread",68201],["thread",69622],["thread",91013],["thread",93141],["thread",71618],["thread",80129],["thread",80862],["thread",66192],["thread",80792],["thread",72044],["thread",95725],["thread",84916],["thread",109585],["thread",66540],["thread",69903],["thread",68986],["thread",88357],["thread",90373],["thread",70835],["thread",90049],["thread",102852],["thread",65064],["thread",80396],["thread",68733],["thread",70431],["thread",43979],["thread",71017],["thread",103174],["thread",69861],["thread",52635],["thread",71359],["thread",78477],["thread",70631],["thread",42254],["thread",89867],["thread",93003],["thread",86868],["thread",73125],["thread",71660],["thread",107673],["thread",87246],["thread",69895],["thread",71420],["thread",108300],["thread",70846],["thread",74644],["thread",70243],["thread",72038],["thread",93726],["thread",84303],["thread",68875],["thread",79649],["thread",73553],["thread",108584],["thread",80280],["thread",97614],["thread",70302],["thread",68038],["thread",68588],["thread",77917],["thread",135641],["thread",24491],["thread",84368],["thread",104247],["thread",72944],["thread",68591],["thread",90889],["thread",75475],["thread",69539],["thread",103402],["thread",93961],["thread",128688],["thread",68752],["thread",127196],["thread",76517],["thread",69906],["thread",58753],["thread",69836],["thread",88283],["thread",81560],["thread",100497],["thread",84308],["thread",101095],["thread",67607],["thread",71421],["thread",73080],["thread",95482],["thread",78089],["thread",72737],["thread",75203],["thread",82106],["thread",69195],["thread",74156],["thread",108159],["thread",84178],["thread",82259],["thread",81485],["thread",64046],["thread",93335],["thread",74072],["thread",78985],["thread",71466],["thread",86552],["thread",102041],["thread",73911],["thread",108239],["thread",84655],["thread",69143],["thread",69051],["thread",82438],["thread",106819],["thread",68464],["thread",69373],["thread",122524],["thread",42794],["thread",109045],["thread",61761],["thread",70367],["thread",68699],["thread",69000],["thread",67760],["thread",92174],["thread",91585],["thread",71294],["thread",76113],["thread",83913],["thread",72483],["thread",70498],["thread",92150],["thread",107911],["thread",86952],["thread",77503],["thread",78989],["thread",74454],["thread",116908],["thread",68264],["thread",124757],["thread",72553],["thread",71712],["thread",50847],["thread",94823],["thread",108063],["thread",69226],["thread",71221],["thread",71919],["thread",72697],["thread",86148],["thread",70335],["thread",87981],["thread",83250],["thread",67590],["thread",110869],["thread",73020],["thread",73960],["thread",103396],["thread",71013],["thread",73328],["thread",71622],["thread",99631],["thread",86140],["thread",66859],["thread",80966],["thread",83781],["thread",79328],["thread",44414],["thread",80398],["thread",44371],["thread",124217],["thread",70082],["thread",77591],["thread",89259],["thread",68467],["thread",81515],["thread",68466],["thread",50838],["thread",75352],["thread",68930],["thread",73551],["thread",68965],["thread",72233],["thread",74596],["thread",73023]]
Run Time: 0.008560
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.000130
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |