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 (76832, 34541, 35674, 109198, 110032, 96104, 58277, 101877, 126453, 121458, 127936, 109295, 107179, 70122, 113023, 82840, 101874, 109542, 105896, 115311, 130290, 136894, 85339, 100773, 80390, 77948, 137318, 85359, 70253, 93769, 111162, 85253, 67447, 121423, 67450, 108988, 126429, 35471, 78618, 71262, 127172, 120583, 86681, 128301, 134784, 109437, 112787, 128246, 68544, 89958, 88996, 105695, 94979, 135560, 83164, 91351, 109942, 124232, 121211, 75919, 117005, 67309, 106703, 111765, 123710, 124010, 127044, 134297, 72040, 76587, 86792, 133767, 81235, 88615, 72044, 106819, 88656, 90039, 107023, 111631, 116309, 71179, 67455, 121489, 85361, 67795, 132793, 66302, 35673, 127575, 91609, 121933, 114501, 90809, 114788, 109249, 74510, 111811, 137277, 91792, 68221, 135563, 96370, 115452, 71069, 94815, 119768, 123022, 70493, 99031, 126685, 107379, 92999, 68957, 133118, 119077, 112862, 95008, 107945, 88320, 136600, 115899, 71221, 108770, 40431, 121083, 91142, 40443, 82627, 76794, 85895, 65814, 106331, 67607, 83163, 136987, 78908, 86651, 106735, 109253, 111328, 70894, 121016, 119948, 88823, 90132, 112564, 81832, 118728, 67211, 116731, 81200, 66846, 35672, 91540, 129398, 119009, 136596, 122855, 131128, 103498, 121494, 105558, 130962, 83627, 88079, 107076, 83861, 73722, 109150, 67760, 78622, 85669, 116421, 40394, 116718, 69652, 84734, 102909, 16788, 87910, 133315, 130071, 108356, 123591, 107282, 132593, 103374, 62112, 106204, 65346, 66878, 85356, 70649, 72095, 129034, 68728, 86530, 63861, 70314, 122899, 70466, 70631, 58987, 72553, 109604, 69716, 100578, 62109, 85547, 62386, 105414, 101255, 108887, 79510, 99110, 99089, 107840, 60082, 76381, 87803, 61229, 90580, 107521, 125521, 75952, 35284, 109824, 121160, 69565, 121787, 70712, 107028, 107357, 33308, 35351, 100441, 125285, 95087, 116658, 70263, 103718, 67160, 106111, 115306, 89580, 61363, 100712, 135168, 89874, 131029, 76520, 136411, 106226, 81317, 95215, 119614, 90181, 89512, 91799, 87277, 68229, 109648, 76139, 84454, 131425, 77690, 79065, 59425, 134912, 118213, 63148, 116778, 67072, 57138, 62400, 40587, 95629, 105236, 95357, 114773, 90125, 124793, 67803, 88377, 112908, 33315, 90308, 105172, 115612, 68114, 107981, 106885, 96663, 100497, 94968, 69117, 89267, 72595, 108634)
Run Time: 0.170021
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, 1715444886, 1715448486, [["thread",76832],["thread",34541],["thread",35674],["thread",109198],["thread",110032],["thread",96104],["thread",58277],["thread",101877],["thread",126453],["thread",121458],["thread",127936],["thread",109295],["thread",107179],["thread",70122],["thread",113023],["thread",82840],["thread",101874],["thread",109542],["thread",105896],["thread",115311],["thread",130290],["thread",136894],["thread",85339],["thread",100773],["thread",80390],["thread",77948],["thread",137318],["thread",85359],["thread",70253],["thread",93769],["thread",111162],["thread",85253],["thread",67447],["thread",121423],["thread",67450],["thread",108988],["thread",126429],["thread",35471],["thread",78618],["thread",71262],["thread",127172],["thread",120583],["thread",86681],["thread",128301],["thread",134784],["thread",109437],["thread",112787],["thread",128246],["thread",68544],["thread",89958],["thread",88996],["thread",105695],["thread",94979],["thread",135560],["thread",83164],["thread",91351],["thread",109942],["thread",124232],["thread",121211],["thread",75919],["thread",117005],["thread",67309],["thread",106703],["thread",111765],["thread",123710],["thread",124010],["thread",127044],["thread",134297],["thread",72040],["thread",76587],["thread",86792],["thread",133767],["thread",81235],["thread",88615],["thread",72044],["thread",106819],["thread",88656],["thread",90039],["thread",107023],["thread",111631],["thread",116309],["thread",71179],["thread",67455],["thread",121489],["thread",85361],["thread",67795],["thread",132793],["thread",66302],["thread",35673],["thread",127575],["thread",91609],["thread",121933],["thread",114501],["thread",90809],["thread",114788],["thread",109249],["thread",74510],["thread",111811],["thread",137277],["thread",91792],["thread",68221],["thread",135563],["thread",96370],["thread",115452],["thread",71069],["thread",94815],["thread",119768],["thread",123022],["thread",70493],["thread",99031],["thread",126685],["thread",107379],["thread",92999],["thread",68957],["thread",133118],["thread",119077],["thread",112862],["thread",95008],["thread",107945],["thread",88320],["thread",136600],["thread",115899],["thread",71221],["thread",108770],["thread",40431],["thread",121083],["thread",91142],["thread",40443],["thread",82627],["thread",76794],["thread",85895],["thread",65814],["thread",106331],["thread",67607],["thread",83163],["thread",136987],["thread",78908],["thread",86651],["thread",106735],["thread",109253],["thread",111328],["thread",70894],["thread",121016],["thread",119948],["thread",88823],["thread",90132],["thread",112564],["thread",81832],["thread",118728],["thread",67211],["thread",116731],["thread",81200],["thread",66846],["thread",35672],["thread",91540],["thread",129398],["thread",119009],["thread",136596],["thread",122855],["thread",131128],["thread",103498],["thread",121494],["thread",105558],["thread",130962],["thread",83627],["thread",88079],["thread",107076],["thread",83861],["thread",73722],["thread",109150],["thread",67760],["thread",78622],["thread",85669],["thread",116421],["thread",40394],["thread",116718],["thread",69652],["thread",84734],["thread",102909],["thread",16788],["thread",87910],["thread",133315],["thread",130071],["thread",108356],["thread",123591],["thread",107282],["thread",132593],["thread",103374],["thread",62112],["thread",106204],["thread",65346],["thread",66878],["thread",85356],["thread",70649],["thread",72095],["thread",129034],["thread",68728],["thread",86530],["thread",63861],["thread",70314],["thread",122899],["thread",70466],["thread",70631],["thread",58987],["thread",72553],["thread",109604],["thread",69716],["thread",100578],["thread",62109],["thread",85547],["thread",62386],["thread",105414],["thread",101255],["thread",108887],["thread",79510],["thread",99110],["thread",99089],["thread",107840],["thread",60082],["thread",76381],["thread",87803],["thread",61229],["thread",90580],["thread",107521],["thread",125521],["thread",75952],["thread",35284],["thread",109824],["thread",121160],["thread",69565],["thread",121787],["thread",70712],["thread",107028],["thread",107357],["thread",33308],["thread",35351],["thread",100441],["thread",125285],["thread",95087],["thread",116658],["thread",70263],["thread",103718],["thread",67160],["thread",106111],["thread",115306],["thread",89580],["thread",61363],["thread",100712],["thread",135168],["thread",89874],["thread",131029],["thread",76520],["thread",136411],["thread",106226],["thread",81317],["thread",95215],["thread",119614],["thread",90181],["thread",89512],["thread",91799],["thread",87277],["thread",68229],["thread",109648],["thread",76139],["thread",84454],["thread",131425],["thread",77690],["thread",79065],["thread",59425],["thread",134912],["thread",118213],["thread",63148],["thread",116778],["thread",67072],["thread",57138],["thread",62400],["thread",40587],["thread",95629],["thread",105236],["thread",95357],["thread",114773],["thread",90125],["thread",124793],["thread",67803],["thread",88377],["thread",112908],["thread",33315],["thread",90308],["thread",105172],["thread",115612],["thread",68114],["thread",107981],["thread",106885],["thread",96663],["thread",100497],["thread",94968],["thread",69117],["thread",89267],["thread",72595],["thread",108634]]
Run Time: 0.032018
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 |