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 (1291, 134198, 122263, 88087, 129283, 121022, 44881, 132020, 11840, 137048, 48311, 128114, 126563, 124666, 111299, 121031, 77871, 108575, 127774, 126919, 133558, 107863, 135207, 120284, 114044, 131615, 47715, 136790, 115720, 133000, 130092, 127616, 102818, 13877, 123949, 109923, 80119, 132309, 115023, 66802, 108864, 112998, 113240, 49095, 71294, 118783, 111519, 135267, 130284, 132343, 127383, 130681, 115500, 48215, 113399, 115162, 132524, 819, 21248, 111148, 130434, 48557, 15473, 130502, 131927, 116322, 1107, 118728, 130441, 75383, 110977, 132182, 133320, 137389, 130545, 115588, 117995, 1437, 116478, 123953, 1617, 105033, 124411, 129648, 36434, 130409, 107564, 20991, 124238, 76411, 133042, 366, 45411, 123186, 120393, 125906, 92315, 134381, 133798, 45329, 61687, 2055, 125256, 67625, 132085, 99631, 130146, 107682, 118392, 115431, 130012, 137157, 111359, 135503, 92040, 128682, 111393, 108462, 110240, 107230, 133101, 128413, 129877, 120176, 125374, 33700, 131191, 89437, 45893, 113947, 115259, 69000, 137203, 1111, 113883, 114714, 117145, 122094, 130301, 137290, 104168, 125080, 135539, 118348, 133498, 130018, 61224, 72837, 120068, 136583, 120462, 111162, 120551, 132089, 100781, 106779, 137167, 104624, 83479, 130485, 111328, 104178, 70911, 134648, 131826, 129780, 122802, 135141, 104759, 131545, 133922, 133316, 134886, 136920, 47713, 30808, 135972, 45482, 134388, 15466, 100953, 11336, 107028, 109762, 133845, 121726, 80959, 131965, 62997, 3071, 71213, 126625, 135960, 129667, 134053, 51599, 134092, 130915, 111870, 127896, 135335, 116671, 136043, 106149, 812, 113986, 136272, 122477, 62572, 110348, 115783, 129455, 134603, 123216, 76399, 123913, 133814, 128124, 109525, 116440, 601, 105931, 966, 134909, 51400, 38988, 135516, 79446, 13780, 67108, 129519, 131355, 133906, 115215, 5093, 126289, 128399, 70530, 126623, 129720, 108447, 15977, 438, 126754, 121067, 131198, 136050, 76096, 108382, 132022, 86751, 130850, 111710, 121033, 1178, 126626, 134819, 123675, 136634, 133188, 128883, 23020, 107023, 103996, 64087, 62095, 80897, 123345, 115801, 125214, 48376, 92870, 125123, 115723, 121145, 133523, 34024, 86522, 119231, 36646, 89819, 135849, 133537, 100876, 131751, 51270, 121159, 104278, 133519, 116169, 32652, 122014, 1359, 87293, 89259, 18330, 105686, 105427)
Run Time: 0.010630
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 298 | 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: 8, 0, 1715919092, 1715922692, [["tinhte_xentag_forum",64],["tinhte_xentag_forum",65],["thread",1291],["thread",134198],["thread",122263],["thread",88087],["thread",129283],["thread",121022],["thread",44881],["thread",132020],["thread",11840],["thread",137048],["thread",48311],["thread",128114],["thread",126563],["thread",124666],["thread",111299],["thread",121031],["thread",77871],["thread",108575],["thread",127774],["thread",126919],["thread",133558],["thread",107863],["thread",135207],["thread",120284],["thread",114044],["thread",131615],["thread",47715],["thread",136790],["thread",115720],["thread",133000],["thread",130092],["thread",127616],["thread",102818],["thread",13877],["thread",123949],["thread",109923],["thread",80119],["thread",132309],["thread",115023],["thread",66802],["thread",108864],["thread",112998],["thread",113240],["thread",49095],["thread",71294],["thread",118783],["thread",111519],["thread",135267],["thread",130284],["thread",132343],["thread",127383],["thread",130681],["thread",115500],["thread",48215],["thread",113399],["thread",115162],["thread",132524],["thread",819],["thread",21248],["thread",111148],["thread",130434],["thread",48557],["thread",15473],["thread",130502],["thread",131927],["thread",116322],["thread",1107],["thread",118728],["thread",130441],["thread",75383],["thread",110977],["thread",132182],["thread",133320],["thread",137389],["thread",130545],["thread",115588],["thread",117995],["thread",1437],["thread",116478],["thread",123953],["thread",1617],["thread",105033],["thread",124411],["thread",129648],["thread",36434],["thread",130409],["thread",107564],["thread",20991],["thread",124238],["thread",76411],["thread",133042],["thread",366],["thread",45411],["thread",123186],["thread",120393],["thread",125906],["thread",92315],["thread",134381],["thread",133798],["thread",45329],["thread",61687],["thread",2055],["thread",125256],["thread",67625],["thread",132085],["thread",99631],["thread",130146],["thread",107682],["thread",118392],["thread",115431],["thread",130012],["thread",137157],["thread",111359],["thread",135503],["thread",92040],["thread",128682],["thread",111393],["thread",108462],["thread",110240],["thread",107230],["thread",133101],["thread",128413],["thread",129877],["thread",120176],["thread",125374],["thread",33700],["thread",131191],["thread",89437],["thread",45893],["thread",113947],["thread",115259],["thread",69000],["thread",137203],["thread",1111],["thread",113883],["thread",114714],["thread",117145],["thread",122094],["thread",130301],["thread",137290],["thread",104168],["thread",125080],["thread",135539],["thread",118348],["thread",133498],["thread",130018],["thread",61224],["thread",72837],["thread",120068],["thread",136583],["thread",120462],["thread",111162],["thread",120551],["thread",132089],["thread",100781],["thread",106779],["thread",137167],["thread",104624],["thread",83479],["thread",130485],["thread",111328],["thread",104178],["thread",70911],["thread",134648],["thread",131826],["thread",129780],["thread",122802],["thread",135141],["thread",104759],["thread",131545],["thread",133922],["thread",133316],["thread",134886],["thread",136920],["thread",47713],["thread",30808],["thread",135972],["thread",45482],["thread",134388],["thread",15466],["thread",100953],["thread",11336],["thread",107028],["thread",109762],["thread",133845],["thread",121726],["thread",80959],["thread",131965],["thread",62997],["thread",3071],["thread",71213],["thread",126625],["thread",135960],["thread",129667],["thread",134053],["thread",51599],["thread",134092],["thread",130915],["thread",111870],["thread",127896],["thread",135335],["thread",116671],["thread",136043],["thread",106149],["thread",812],["thread",113986],["thread",136272],["thread",122477],["thread",62572],["thread",110348],["thread",115783],["thread",129455],["thread",134603],["thread",123216],["thread",76399],["thread",123913],["thread",133814],["thread",128124],["thread",109525],["thread",116440],["thread",601],["thread",105931],["thread",966],["thread",134909],["thread",51400],["thread",38988],["thread",135516],["thread",79446],["thread",13780],["thread",67108],["thread",129519],["thread",131355],["thread",133906],["thread",115215],["thread",5093],["thread",126289],["thread",128399],["thread",70530],["thread",126623],["thread",129720],["thread",108447],["thread",15977],["thread",438],["thread",126754],["thread",121067],["thread",131198],["thread",136050],["thread",76096],["thread",108382],["thread",132022],["thread",86751],["thread",130850],["thread",111710],["thread",121033],["thread",1178],["thread",126626],["thread",134819],["thread",123675],["thread",136634],["thread",133188],["thread",128883],["thread",23020],["thread",107023],["thread",103996],["thread",64087],["thread",62095],["thread",80897],["thread",123345],["thread",115801],["thread",125214],["thread",48376],["thread",92870],["thread",125123],["thread",115723],["thread",121145],["thread",133523],["thread",34024],["thread",86522],["thread",119231],["thread",36646],["thread",89819],["thread",135849],["thread",133537],["thread",100876],["thread",131751],["thread",51270],["thread",121159],["thread",104278],["thread",133519],["thread",116169],["thread",32652],["thread",122014],["thread",1359],["thread",87293],["thread",89259],["thread",18330],["thread",105686],["thread",105427]]
Run Time: 0.075908
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |