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 (121618, 111635, 135560, 128272, 112235, 95008, 106204, 131183, 99534, 106275, 33308, 93240, 81936, 85359, 91892, 91653, 6555, 117105, 69195, 88456, 94090, 55638, 122778, 123022, 67603, 82012, 132395, 100508, 108190, 72040, 64821, 126485, 67072, 92404, 111328, 88656, 132113, 121350, 86792, 65966, 105767, 105111, 112352, 64817, 97634, 127800, 103152, 72288, 81060, 58430, 104227, 99706, 105557, 76628, 68729, 121494, 72038, 113023, 83063, 114947, 128910, 40431, 99109, 87014, 108592, 85339, 102308, 100497, 117786, 111379, 104984, 60242, 89074, 88476, 94407, 86130, 87941, 107945, 89904, 81618, 86069, 82193, 74850, 126391, 86681, 124848, 34024, 68114, 97505, 113924, 111839, 61759, 123871, 85253, 106331, 109401, 121786, 119867, 118441, 107587, 127679, 77250, 108234, 81151, 135922, 70122, 102999, 136617, 89302, 105612, 75749, 69448, 118121, 133570, 121492, 116278, 103150, 60082, 109198, 69745, 92045, 103352, 75243, 120125, 103470, 107521, 119009, 86711, 91142, 108657, 71359, 108680, 101033, 79542, 87426, 129518, 88996, 119948, 109434, 81638, 66305, 107704, 108490, 66159, 100829, 132070, 120914, 80028, 130224, 73722, 90132, 106891, 118213, 79510, 127575, 86759, 133142, 131029, 87871, 126685, 111267, 103801, 133710, 109490, 82646, 68080, 108767, 88175, 89731, 69579, 133188, 121489, 65068, 108375, 89211, 79903, 81456, 93388, 69716, 79668, 84281, 99631, 89885, 112991, 121083, 103381, 70894, 125521, 101890, 110703, 110031, 77781, 69200, 125845, 135312, 112664, 80717, 66918, 114774, 66453, 114840, 128424, 101991, 71294, 106530, 127507, 126061, 131128, 107911, 120583, 100949, 111499, 106716, 78908, 103534, 105241, 109102, 70631, 87347, 82300, 17757, 114557, 104394, 90039, 133767, 78618, 123359, 86949, 58023, 136546, 105539, 69117, 103859, 68807, 95052, 101833, 115863, 78753, 105563, 80137, 69000, 89734, 122396, 108610, 136697, 128243, 77247, 72371, 85834, 69976, 110788, 77082, 65080, 90174, 88320, 104900, 33281, 83005, 70373, 107379, 121346, 77660, 71483, 123874, 136600, 90530, 106434, 99043, 118348, 127044, 108970, 92592, 88561, 126429, 107489, 107289, 91351, 90125, 109542, 109228, 124488, 63126, 122842, 113021, 81235, 121016, 70675, 77465, 116654, 81212, 123133, 113126, 108488, 83876, 117702, 112699, 70030, 112751, 59130, 111881)
Run Time: 0.015001
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: 2560, 0, 1713933680, 1713937280, [["thread",121618],["thread",111635],["thread",135560],["thread",128272],["thread",112235],["thread",95008],["thread",106204],["thread",131183],["thread",99534],["thread",106275],["thread",33308],["thread",93240],["thread",81936],["thread",85359],["thread",91892],["thread",91653],["thread",6555],["thread",117105],["thread",69195],["thread",88456],["thread",94090],["thread",55638],["thread",122778],["thread",123022],["thread",67603],["thread",82012],["thread",132395],["thread",100508],["thread",108190],["thread",72040],["thread",64821],["thread",126485],["thread",67072],["thread",92404],["thread",111328],["thread",88656],["thread",132113],["thread",121350],["thread",86792],["thread",65966],["thread",105767],["thread",105111],["thread",112352],["thread",64817],["thread",97634],["thread",127800],["thread",103152],["thread",72288],["thread",81060],["thread",58430],["thread",104227],["thread",99706],["thread",105557],["thread",76628],["thread",68729],["thread",121494],["thread",72038],["thread",113023],["thread",83063],["thread",114947],["thread",128910],["thread",40431],["thread",99109],["thread",87014],["thread",108592],["thread",85339],["thread",102308],["thread",100497],["thread",117786],["thread",111379],["thread",104984],["thread",60242],["thread",89074],["thread",88476],["thread",94407],["thread",86130],["thread",87941],["thread",107945],["thread",89904],["thread",81618],["thread",86069],["thread",82193],["thread",74850],["thread",126391],["thread",86681],["thread",124848],["thread",34024],["thread",68114],["thread",97505],["thread",113924],["thread",111839],["thread",61759],["thread",123871],["thread",85253],["thread",106331],["thread",109401],["thread",121786],["thread",119867],["thread",118441],["thread",107587],["thread",127679],["thread",77250],["thread",108234],["thread",81151],["thread",135922],["thread",70122],["thread",102999],["thread",136617],["thread",89302],["thread",105612],["thread",75749],["thread",69448],["thread",118121],["thread",133570],["thread",121492],["thread",116278],["thread",103150],["thread",60082],["thread",109198],["thread",69745],["thread",92045],["thread",103352],["thread",75243],["thread",120125],["thread",103470],["thread",107521],["thread",119009],["thread",86711],["thread",91142],["thread",108657],["thread",71359],["thread",108680],["thread",101033],["thread",79542],["thread",87426],["thread",129518],["thread",88996],["thread",119948],["thread",109434],["thread",81638],["thread",66305],["thread",107704],["thread",108490],["thread",66159],["thread",100829],["thread",132070],["thread",120914],["thread",80028],["thread",130224],["thread",73722],["thread",90132],["thread",106891],["thread",118213],["thread",79510],["thread",127575],["thread",86759],["thread",133142],["thread",131029],["thread",87871],["thread",126685],["thread",111267],["thread",103801],["thread",133710],["thread",109490],["thread",82646],["thread",68080],["thread",108767],["thread",88175],["thread",89731],["thread",69579],["thread",133188],["thread",121489],["thread",65068],["thread",108375],["thread",89211],["thread",79903],["thread",81456],["thread",93388],["thread",69716],["thread",79668],["thread",84281],["thread",99631],["thread",89885],["thread",112991],["thread",121083],["thread",103381],["thread",70894],["thread",125521],["thread",101890],["thread",110703],["thread",110031],["thread",77781],["thread",69200],["thread",125845],["thread",135312],["thread",112664],["thread",80717],["thread",66918],["thread",114774],["thread",66453],["thread",114840],["thread",128424],["thread",101991],["thread",71294],["thread",106530],["thread",127507],["thread",126061],["thread",131128],["thread",107911],["thread",120583],["thread",100949],["thread",111499],["thread",106716],["thread",78908],["thread",103534],["thread",105241],["thread",109102],["thread",70631],["thread",87347],["thread",82300],["thread",17757],["thread",114557],["thread",104394],["thread",90039],["thread",133767],["thread",78618],["thread",123359],["thread",86949],["thread",58023],["thread",136546],["thread",105539],["thread",69117],["thread",103859],["thread",68807],["thread",95052],["thread",101833],["thread",115863],["thread",78753],["thread",105563],["thread",80137],["thread",69000],["thread",89734],["thread",122396],["thread",108610],["thread",136697],["thread",128243],["thread",77247],["thread",72371],["thread",85834],["thread",69976],["thread",110788],["thread",77082],["thread",65080],["thread",90174],["thread",88320],["thread",104900],["thread",33281],["thread",83005],["thread",70373],["thread",107379],["thread",121346],["thread",77660],["thread",71483],["thread",123874],["thread",136600],["thread",90530],["thread",106434],["thread",99043],["thread",118348],["thread",127044],["thread",108970],["thread",92592],["thread",88561],["thread",126429],["thread",107489],["thread",107289],["thread",91351],["thread",90125],["thread",109542],["thread",109228],["thread",124488],["thread",63126],["thread",122842],["thread",113021],["thread",81235],["thread",121016],["thread",70675],["thread",77465],["thread",116654],["thread",81212],["thread",123133],["thread",113126],["thread",108488],["thread",83876],["thread",117702],["thread",112699],["thread",70030],["thread",112751],["thread",59130],["thread",111881]]
Run Time: 0.001369
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.000101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |