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 (116490, 88610, 61458, 57932, 111684, 89215, 91899, 122876, 52749, 19956, 59675, 89882, 64825, 12471, 67257, 52754, 61106, 13026, 73330, 87770, 17928, 130917, 114438, 66009, 9305, 117288, 69485, 87176, 123672, 126571, 64719, 69649, 68711, 81708, 7596, 64149, 56106, 19792, 61110, 14675, 105464, 64695, 107836, 33566, 39219, 123101, 38127, 76665, 106329, 81970, 110357, 91020, 90329, 110532, 38730, 56169, 58351, 95470, 92241, 110168, 69769, 128034, 70741, 124126, 113539, 99107, 91940, 133299, 70607, 65972, 90009, 71943, 36339, 100744, 96542, 45194, 113451, 61778, 37843, 73933, 122795, 103176, 135662, 105752, 44072, 48310, 56997, 110876, 61456, 117855, 16744, 99921, 38387, 83797, 106160, 90751, 45488, 65011, 62351, 65317, 93058, 74609, 66436, 23887, 61588, 104042, 57133, 90504, 72105, 72129, 128088, 90685, 89163, 67408, 122853, 87093, 63140, 109625, 103786, 115710, 72626, 58275, 82573, 61104, 60079, 63366, 62084, 70130, 71415, 109598, 89656, 64961, 52762, 90904, 127442, 52746, 90494, 91266, 57506, 56084, 81107, 128123, 114876, 57040, 98920, 39269, 52745, 125365, 87122, 59840, 100185, 95927, 36414, 127401, 123598, 18476, 112871, 52748, 93838, 102529, 62891, 77836, 126255, 64588, 51971, 61787, 90665, 56797, 83742, 51674, 36223, 35953, 80612, 62341, 114433, 111190, 130501, 66513, 106381, 43236, 105093, 63608, 113315, 80325, 109873, 99754, 111751, 90411, 92367, 78589, 76763, 95298, 37405, 52744, 42550, 66825, 69858, 24247, 106366, 104232, 70770, 63830, 61590, 75401, 51961, 109715, 67503, 685, 121225, 36689, 36019, 60128, 107525, 59364, 93843, 60565, 77874, 65704, 66710, 58558, 104825, 89079, 61916, 63644, 62570, 23196, 107242, 91542, 100142, 108217, 73141, 89995, 131192, 61832, 36227, 102502, 123771, 127799, 37205, 72224, 94289, 78586, 111841, 589, 97415, 89274, 66248, 58844, 85096, 96026, 39090, 52757, 61643, 23913, 114701, 29079, 100859, 79252, 52747, 92079, 49332, 62133, 105138, 70715, 62136, 125605, 73128, 112398, 38106, 59558, 68082, 112095, 134703, 6244, 113507, 128066, 39364, 86941, 95300, 128309, 113376, 124727, 71969, 37742, 90395, 85223, 116950, 106142, 97818, 89164, 103451, 47604, 86625, 63408, 52751, 54410, 128378)
Run Time: 0.021170
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: 774, 0, 1714121761, 1714125361, [["tinhte_xentag_forum",44],["tinhte_xentag_forum",45],["tinhte_xentag_forum",47],["thread",116490],["thread",88610],["thread",61458],["thread",57932],["thread",111684],["thread",89215],["thread",91899],["thread",122876],["thread",52749],["thread",19956],["thread",59675],["thread",89882],["thread",64825],["thread",12471],["thread",67257],["thread",52754],["thread",61106],["thread",13026],["thread",73330],["thread",87770],["thread",17928],["thread",130917],["thread",114438],["thread",66009],["thread",9305],["thread",117288],["thread",69485],["thread",87176],["thread",123672],["thread",126571],["thread",64719],["thread",69649],["thread",68711],["thread",81708],["thread",7596],["thread",64149],["thread",56106],["thread",19792],["thread",61110],["thread",14675],["thread",105464],["thread",64695],["thread",107836],["thread",33566],["thread",39219],["thread",123101],["thread",38127],["thread",76665],["thread",106329],["thread",81970],["thread",110357],["thread",91020],["thread",90329],["thread",110532],["thread",38730],["thread",56169],["thread",58351],["thread",95470],["thread",92241],["thread",110168],["thread",69769],["thread",128034],["thread",70741],["thread",124126],["thread",113539],["thread",99107],["thread",91940],["thread",133299],["thread",70607],["thread",65972],["thread",90009],["thread",71943],["thread",36339],["thread",100744],["thread",96542],["thread",45194],["thread",113451],["thread",61778],["thread",37843],["thread",73933],["thread",122795],["thread",103176],["thread",135662],["thread",105752],["thread",44072],["thread",48310],["thread",56997],["thread",110876],["thread",61456],["thread",117855],["thread",16744],["thread",99921],["thread",38387],["thread",83797],["thread",106160],["thread",90751],["thread",45488],["thread",65011],["thread",62351],["thread",65317],["thread",93058],["thread",74609],["thread",66436],["thread",23887],["thread",61588],["thread",104042],["thread",57133],["thread",90504],["thread",72105],["thread",72129],["thread",128088],["thread",90685],["thread",89163],["thread",67408],["thread",122853],["thread",87093],["thread",63140],["thread",109625],["thread",103786],["thread",115710],["thread",72626],["thread",58275],["thread",82573],["thread",61104],["thread",60079],["thread",63366],["thread",62084],["thread",70130],["thread",71415],["thread",109598],["thread",89656],["thread",64961],["thread",52762],["thread",90904],["thread",127442],["thread",52746],["thread",90494],["thread",91266],["thread",57506],["thread",56084],["thread",81107],["thread",128123],["thread",114876],["thread",57040],["thread",98920],["thread",39269],["thread",52745],["thread",125365],["thread",87122],["thread",59840],["thread",100185],["thread",95927],["thread",36414],["thread",127401],["thread",123598],["thread",18476],["thread",112871],["thread",52748],["thread",93838],["thread",102529],["thread",62891],["thread",77836],["thread",126255],["thread",64588],["thread",51971],["thread",61787],["thread",90665],["thread",56797],["thread",83742],["thread",51674],["thread",36223],["thread",35953],["thread",80612],["thread",62341],["thread",114433],["thread",111190],["thread",130501],["thread",66513],["thread",106381],["thread",43236],["thread",105093],["thread",63608],["thread",113315],["thread",80325],["thread",109873],["thread",99754],["thread",111751],["thread",90411],["thread",92367],["thread",78589],["thread",76763],["thread",95298],["thread",37405],["thread",52744],["thread",42550],["thread",66825],["thread",69858],["thread",24247],["thread",106366],["thread",104232],["thread",70770],["thread",63830],["thread",61590],["thread",75401],["thread",51961],["thread",109715],["thread",67503],["thread",685],["thread",121225],["thread",36689],["thread",36019],["thread",60128],["thread",107525],["thread",59364],["thread",93843],["thread",60565],["thread",77874],["thread",65704],["thread",66710],["thread",58558],["thread",104825],["thread",89079],["thread",61916],["thread",63644],["thread",62570],["thread",23196],["thread",107242],["thread",91542],["thread",100142],["thread",108217],["thread",73141],["thread",89995],["thread",131192],["thread",61832],["thread",36227],["thread",102502],["thread",123771],["thread",127799],["thread",37205],["thread",72224],["thread",94289],["thread",78586],["thread",111841],["thread",589],["thread",97415],["thread",89274],["thread",66248],["thread",58844],["thread",85096],["thread",96026],["thread",39090],["thread",52757],["thread",61643],["thread",23913],["thread",114701],["thread",29079],["thread",100859],["thread",79252],["thread",52747],["thread",92079],["thread",49332],["thread",62133],["thread",105138],["thread",70715],["thread",62136],["thread",125605],["thread",73128],["thread",112398],["thread",38106],["thread",59558],["thread",68082],["thread",112095],["thread",134703],["thread",6244],["thread",113507],["thread",128066],["thread",39364],["thread",86941],["thread",95300],["thread",128309],["thread",113376],["thread",124727],["thread",71969],["thread",37742],["thread",90395],["thread",85223],["thread",116950],["thread",106142],["thread",97818],["thread",89164],["thread",103451],["thread",47604],["thread",86625],["thread",63408],["thread",52751],["thread",54410],["thread",128378]]
Run Time: 0.002711
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.000117
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |