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 (92779, 129392, 106251, 122767, 125619, 126190, 18457, 120014, 25752, 52256, 1561, 108068, 47587, 126538, 132408, 75407, 110485, 119778, 128678, 97103, 106394, 121622, 1653, 101860, 124706, 108982, 110328, 120953, 131949, 116788, 114909, 113001, 120157, 133398, 43150, 129903, 116120, 104347, 1013, 74575, 108861, 121673, 122489, 120898, 104507, 118899, 135689, 129434, 134611, 102485, 45848, 132884, 135625, 1008, 121493, 1690, 115092, 1304, 39595, 120411, 994, 102487, 137005, 126010, 90349, 115395, 108257, 118295, 128735, 128062, 125849, 113853, 119502, 130530, 122093, 46133, 134893, 51888, 1278, 113363, 131662, 134223, 127861, 108905, 136803, 134836, 88641, 2055, 79200, 62867, 108735, 132509, 1999, 64890, 107495, 105366, 2001, 26152, 130786, 107297, 121674, 15466, 49242, 825, 48981, 86797, 119869, 867, 124347, 67524, 110365, 129341, 135325, 129096, 2529, 114463, 53813, 32039, 118095, 123062, 129172, 121097, 115499, 128109, 121322, 127340, 109387, 122185, 110705, 47336, 25831, 119222, 125588, 128193, 122841, 119541, 53725, 71727, 102507, 2334, 58336, 137281, 46661, 134595, 130568, 135491, 26841, 46336, 131013, 133807, 115206, 4347, 121490, 1446, 132470, 126487, 126050, 114688, 123132, 113633, 133491, 134347, 135340, 107022, 131588, 116663, 125594, 134861, 132343, 123953, 118626, 16732, 107728, 132582, 128297, 114291, 118695, 20041, 95219, 90784, 1001, 131585, 51966, 64689, 122316, 119544, 106679, 112464, 130165, 126653, 137158, 47236, 122312, 2009, 121197, 131381, 1269, 104506, 68612, 109612, 394, 971, 1356, 33410, 108444, 131550, 134863, 117265, 120034, 890, 23174, 1562, 104635, 134707, 127618, 115181, 1485, 125038, 1020, 48227, 117831, 972, 127828, 123162, 128290, 133443, 109033, 124025, 137161, 122679, 119439, 137155, 128400, 132420, 119408, 113857, 118697, 106848, 2345, 13856, 108113, 34987, 128254, 127432, 108596, 117219, 134403, 111810, 134249, 65348, 122305, 2316, 25722, 126856, 48255, 121565, 120046, 126468, 106817, 135222, 125979, 121698, 129380, 970, 107312, 988, 50712, 2307, 122522, 122701, 89842, 105184, 128305, 87241, 132234, 127234, 129502, 18651, 125277, 18565, 17365, 135044, 2053, 67810, 117356, 123139, 49170, 25209, 83746, 121417, 123610, 116809, 121962, 122965, 35500, 17385, 123442)
Run Time: 0.264551
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 297 | 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: 420, 0, 1715452345, 1715455945, [["resource",30],["resource",20],["tinhte_xentag_forum",64],["thread",92779],["thread",129392],["thread",106251],["thread",122767],["thread",125619],["thread",126190],["thread",18457],["thread",120014],["thread",25752],["thread",52256],["thread",1561],["thread",108068],["thread",47587],["thread",126538],["thread",132408],["thread",75407],["thread",110485],["thread",119778],["thread",128678],["thread",97103],["thread",106394],["thread",121622],["thread",1653],["thread",101860],["thread",124706],["thread",108982],["thread",110328],["thread",120953],["thread",131949],["thread",116788],["thread",114909],["thread",113001],["thread",120157],["thread",133398],["thread",43150],["thread",129903],["thread",116120],["thread",104347],["thread",1013],["thread",74575],["thread",108861],["thread",121673],["thread",122489],["thread",120898],["thread",104507],["thread",118899],["thread",135689],["thread",129434],["thread",134611],["thread",102485],["thread",45848],["thread",132884],["thread",135625],["thread",1008],["thread",121493],["thread",1690],["thread",115092],["thread",1304],["thread",39595],["thread",120411],["thread",994],["thread",102487],["thread",137005],["thread",126010],["thread",90349],["thread",115395],["thread",108257],["thread",118295],["thread",128735],["thread",128062],["thread",125849],["thread",113853],["thread",119502],["thread",130530],["thread",122093],["thread",46133],["thread",134893],["thread",51888],["thread",1278],["thread",113363],["thread",131662],["thread",134223],["thread",127861],["thread",108905],["thread",136803],["thread",134836],["thread",88641],["thread",2055],["thread",79200],["thread",62867],["thread",108735],["thread",132509],["thread",1999],["thread",64890],["thread",107495],["thread",105366],["thread",2001],["thread",26152],["thread",130786],["thread",107297],["thread",121674],["thread",15466],["thread",49242],["thread",825],["thread",48981],["thread",86797],["thread",119869],["thread",867],["thread",124347],["thread",67524],["thread",110365],["thread",129341],["thread",135325],["thread",129096],["thread",2529],["thread",114463],["thread",53813],["thread",32039],["thread",118095],["thread",123062],["thread",129172],["thread",121097],["thread",115499],["thread",128109],["thread",121322],["thread",127340],["thread",109387],["thread",122185],["thread",110705],["thread",47336],["thread",25831],["thread",119222],["thread",125588],["thread",128193],["thread",122841],["thread",119541],["thread",53725],["thread",71727],["thread",102507],["thread",2334],["thread",58336],["thread",137281],["thread",46661],["thread",134595],["thread",130568],["thread",135491],["thread",26841],["thread",46336],["thread",131013],["thread",133807],["thread",115206],["thread",4347],["thread",121490],["thread",1446],["thread",132470],["thread",126487],["thread",126050],["thread",114688],["thread",123132],["thread",113633],["thread",133491],["thread",134347],["thread",135340],["thread",107022],["thread",131588],["thread",116663],["thread",125594],["thread",134861],["thread",132343],["thread",123953],["thread",118626],["thread",16732],["thread",107728],["thread",132582],["thread",128297],["thread",114291],["thread",118695],["thread",20041],["thread",95219],["thread",90784],["thread",1001],["thread",131585],["thread",51966],["thread",64689],["thread",122316],["thread",119544],["thread",106679],["thread",112464],["thread",130165],["thread",126653],["thread",137158],["thread",47236],["thread",122312],["thread",2009],["thread",121197],["thread",131381],["thread",1269],["thread",104506],["thread",68612],["thread",109612],["thread",394],["thread",971],["thread",1356],["thread",33410],["thread",108444],["thread",131550],["thread",134863],["thread",117265],["thread",120034],["thread",890],["thread",23174],["thread",1562],["thread",104635],["thread",134707],["thread",127618],["thread",115181],["thread",1485],["thread",125038],["thread",1020],["thread",48227],["thread",117831],["thread",972],["thread",127828],["thread",123162],["thread",128290],["thread",133443],["thread",109033],["thread",124025],["thread",137161],["thread",122679],["thread",119439],["thread",137155],["thread",128400],["thread",132420],["thread",119408],["thread",113857],["thread",118697],["thread",106848],["thread",2345],["thread",13856],["thread",108113],["thread",34987],["thread",128254],["thread",127432],["thread",108596],["thread",117219],["thread",134403],["thread",111810],["thread",134249],["thread",65348],["thread",122305],["thread",2316],["thread",25722],["thread",126856],["thread",48255],["thread",121565],["thread",120046],["thread",126468],["thread",106817],["thread",135222],["thread",125979],["thread",121698],["thread",129380],["thread",970],["thread",107312],["thread",988],["thread",50712],["thread",2307],["thread",122522],["thread",122701],["thread",89842],["thread",105184],["thread",128305],["thread",87241],["thread",132234],["thread",127234],["thread",129502],["thread",18651],["thread",125277],["thread",18565],["thread",17365],["thread",135044],["thread",2053],["thread",67810],["thread",117356],["thread",123139],["thread",49170],["thread",25209],["thread",83746],["thread",121417],["thread",123610],["thread",116809],["thread",121962],["thread",122965],["thread",35500],["thread",17385],["thread",123442]]
Run Time: 0.043320
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.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |