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 (109764, 123328, 49315, 44512, 39918, 63187, 52431, 116323, 32453, 95810, 47238, 134479, 102203, 46511, 1696, 116162, 46188, 21057, 117337, 124180, 115233, 105085, 136311, 110333, 130274, 110589, 135119, 18114, 120247, 39555, 1711, 123545, 25131, 30244, 111370, 65457, 46887, 131191, 122370, 133424, 103963, 133417, 120016, 19036, 134478, 125930, 89733, 70851, 47062, 115595, 130559, 131797, 118680, 127309, 123505, 115684, 53626, 106739, 134988, 133416, 18459, 1065, 25915, 35243, 104327, 32231, 17149, 115362, 6464, 1297, 114185, 2049, 122246, 63815, 88769, 118750, 52095, 89395, 122332, 108492, 124806, 124278, 952, 117623, 17897, 122385, 131926, 110365, 61080, 115158, 72318, 133428, 48723, 130528, 122965, 119259, 114955, 2315, 74569, 1457, 47564, 121712, 133411, 126653, 114906, 130527, 50085, 116815, 41913, 129134, 101968, 132252, 61194, 114415, 122121, 136448, 108077, 125876, 1248, 50473, 128005, 109608, 75407, 61894, 46919, 123550, 128108, 132704, 131615, 2355, 135358, 134264, 130265, 47872, 5431, 49242, 1181, 121553, 129301, 2051, 130201, 131890, 125994, 114547, 62607, 17380, 115821, 136270, 121059, 107452, 120175, 133408, 135044, 133718, 118765, 115476, 61326, 108203, 49955, 119619, 121622, 111001, 394, 39681, 134166, 128062, 126856, 126864, 122522, 42479, 123268, 126917, 126497, 87538, 120242, 17365, 134239, 134278, 124283, 4728, 1287, 817, 130530, 88648, 110426, 128381, 130435, 124720, 127241, 19147, 61222, 105499, 118477, 114935, 54002, 118417, 111359, 106000, 118332, 105686, 130733, 103812, 122140, 2525, 888, 130178, 119474, 1092, 115523, 52270, 49620, 57844, 114146, 106863, 19457, 124888, 26726, 107446, 40417, 72789, 60979, 107553, 118858, 4880, 120557, 127337, 87827, 133398, 109723, 127553, 106305, 53967, 64198, 131729, 127643, 104624, 120514, 109319, 120626, 75370, 125707, 1290, 1433, 988, 46426, 114734, 83185, 1483, 5897, 130792, 1634, 118692, 58339, 125342, 2149, 125065, 51440, 122558, 63502, 135670, 128943, 129807, 119515, 1434, 104295, 129607, 132008, 2290, 70665, 104584, 127618, 109812, 46174, 74210, 114374, 128909, 129883, 121770, 121417, 128201, 119535, 119217, 130703, 58279, 121853, 118548, 1273, 97370, 123415, 129242, 107101, 19266, 34810, 16377, 1411, 123738, 113811)
Run Time: 0.008040
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, 1713509733, 1713513333, [["resource",30],["resource",20],["tinhte_xentag_forum",64],["thread",109764],["thread",123328],["thread",49315],["thread",44512],["thread",39918],["thread",63187],["thread",52431],["thread",116323],["thread",32453],["thread",95810],["thread",47238],["thread",134479],["thread",102203],["thread",46511],["thread",1696],["thread",116162],["thread",46188],["thread",21057],["thread",117337],["thread",124180],["thread",115233],["thread",105085],["thread",136311],["thread",110333],["thread",130274],["thread",110589],["thread",135119],["thread",18114],["thread",120247],["thread",39555],["thread",1711],["thread",123545],["thread",25131],["thread",30244],["thread",111370],["thread",65457],["thread",46887],["thread",131191],["thread",122370],["thread",133424],["thread",103963],["thread",133417],["thread",120016],["thread",19036],["thread",134478],["thread",125930],["thread",89733],["thread",70851],["thread",47062],["thread",115595],["thread",130559],["thread",131797],["thread",118680],["thread",127309],["thread",123505],["thread",115684],["thread",53626],["thread",106739],["thread",134988],["thread",133416],["thread",18459],["thread",1065],["thread",25915],["thread",35243],["thread",104327],["thread",32231],["thread",17149],["thread",115362],["thread",6464],["thread",1297],["thread",114185],["thread",2049],["thread",122246],["thread",63815],["thread",88769],["thread",118750],["thread",52095],["thread",89395],["thread",122332],["thread",108492],["thread",124806],["thread",124278],["thread",952],["thread",117623],["thread",17897],["thread",122385],["thread",131926],["thread",110365],["thread",61080],["thread",115158],["thread",72318],["thread",133428],["thread",48723],["thread",130528],["thread",122965],["thread",119259],["thread",114955],["thread",2315],["thread",74569],["thread",1457],["thread",47564],["thread",121712],["thread",133411],["thread",126653],["thread",114906],["thread",130527],["thread",50085],["thread",116815],["thread",41913],["thread",129134],["thread",101968],["thread",132252],["thread",61194],["thread",114415],["thread",122121],["thread",136448],["thread",108077],["thread",125876],["thread",1248],["thread",50473],["thread",128005],["thread",109608],["thread",75407],["thread",61894],["thread",46919],["thread",123550],["thread",128108],["thread",132704],["thread",131615],["thread",2355],["thread",135358],["thread",134264],["thread",130265],["thread",47872],["thread",5431],["thread",49242],["thread",1181],["thread",121553],["thread",129301],["thread",2051],["thread",130201],["thread",131890],["thread",125994],["thread",114547],["thread",62607],["thread",17380],["thread",115821],["thread",136270],["thread",121059],["thread",107452],["thread",120175],["thread",133408],["thread",135044],["thread",133718],["thread",118765],["thread",115476],["thread",61326],["thread",108203],["thread",49955],["thread",119619],["thread",121622],["thread",111001],["thread",394],["thread",39681],["thread",134166],["thread",128062],["thread",126856],["thread",126864],["thread",122522],["thread",42479],["thread",123268],["thread",126917],["thread",126497],["thread",87538],["thread",120242],["thread",17365],["thread",134239],["thread",134278],["thread",124283],["thread",4728],["thread",1287],["thread",817],["thread",130530],["thread",88648],["thread",110426],["thread",128381],["thread",130435],["thread",124720],["thread",127241],["thread",19147],["thread",61222],["thread",105499],["thread",118477],["thread",114935],["thread",54002],["thread",118417],["thread",111359],["thread",106000],["thread",118332],["thread",105686],["thread",130733],["thread",103812],["thread",122140],["thread",2525],["thread",888],["thread",130178],["thread",119474],["thread",1092],["thread",115523],["thread",52270],["thread",49620],["thread",57844],["thread",114146],["thread",106863],["thread",19457],["thread",124888],["thread",26726],["thread",107446],["thread",40417],["thread",72789],["thread",60979],["thread",107553],["thread",118858],["thread",4880],["thread",120557],["thread",127337],["thread",87827],["thread",133398],["thread",109723],["thread",127553],["thread",106305],["thread",53967],["thread",64198],["thread",131729],["thread",127643],["thread",104624],["thread",120514],["thread",109319],["thread",120626],["thread",75370],["thread",125707],["thread",1290],["thread",1433],["thread",988],["thread",46426],["thread",114734],["thread",83185],["thread",1483],["thread",5897],["thread",130792],["thread",1634],["thread",118692],["thread",58339],["thread",125342],["thread",2149],["thread",125065],["thread",51440],["thread",122558],["thread",63502],["thread",135670],["thread",128943],["thread",129807],["thread",119515],["thread",1434],["thread",104295],["thread",129607],["thread",132008],["thread",2290],["thread",70665],["thread",104584],["thread",127618],["thread",109812],["thread",46174],["thread",74210],["thread",114374],["thread",128909],["thread",129883],["thread",121770],["thread",121417],["thread",128201],["thread",119535],["thread",119217],["thread",130703],["thread",58279],["thread",121853],["thread",118548],["thread",1273],["thread",97370],["thread",123415],["thread",129242],["thread",107101],["thread",19266],["thread",34810],["thread",16377],["thread",1411],["thread",123738],["thread",113811]]
Run Time: 0.001019
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.000085
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |