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 (69976, 130860, 58344, 123774, 84366, 118340, 67447, 89475, 124519, 125521, 130763, 68591, 105875, 80280, 109824, 96663, 107288, 101809, 67062, 105922, 54314, 124583, 121489, 77170, 66305, 98748, 133330, 84080, 75589, 111639, 80391, 112699, 131798, 50263, 112268, 70672, 68782, 118872, 119740, 125257, 73179, 91362, 112061, 134297, 111036, 127827, 79125, 125123, 74863, 90142, 127044, 134043, 86598, 121787, 81437, 68515, 17913, 67174, 61761, 65560, 123280, 106028, 78448, 114816, 77591, 111763, 125402, 126236, 83613, 126660, 124678, 82106, 105864, 119030, 84308, 94426, 71618, 127068, 111056, 24490, 116546, 59923, 77401, 122732, 124607, 132178, 95457, 66840, 119443, 101991, 93680, 88283, 44366, 76416, 87133, 33323, 70371, 90127, 86148, 69000, 70373, 71378, 131422, 40429, 135018, 100949, 34730, 94543, 129111, 103718, 112176, 93795, 84307, 124358, 84469, 14900, 123365, 88599, 122658, 121928, 120365, 127175, 120551, 109772, 71377, 124638, 110238, 97446, 68752, 136234, 69969, 96061, 93253, 33308, 112536, 66540, 112075, 126181, 90512, 136394, 73726, 125553, 44805, 124538, 95088, 29815, 92999, 124945, 68467, 111703, 44845, 34539, 119444, 88561, 124392, 112427, 79590, 66267, 105811, 67997, 135148, 69610, 85793, 111362, 107493, 71379, 53935, 130149, 77917, 119568, 88238, 34537, 111187, 125971, 88629, 133240, 85895, 76118, 127936, 82997, 83704, 80970, 111134, 120387, 110889, 69612, 129929, 71376, 108375, 90439, 71466, 82012, 66802, 111005, 131418, 68486, 69384, 77385, 79588, 123806, 69143, 84369, 69788, 119925, 78793, 119188, 79649, 86868, 71464, 95459, 69564, 118336, 113813, 124470, 80966, 116421, 85720, 107861, 121821, 34233, 129228, 122879, 70712, 117626, 95114, 106716, 69934, 105292, 75588, 134039, 98930, 70431, 84124, 124179, 66426, 112560, 80792, 105753, 97080, 106247, 107857, 135240, 33314, 77520, 87116, 81426, 127069, 71519, 85259, 40432, 110571, 34274, 81677, 86701, 88235, 87763, 125543, 81778, 72597, 84141, 132069, 111057, 93341, 86144, 71359, 81069, 118795, 93245, 111301, 104414, 83163, 87791, 122091, 81606, 68588, 66453, 67786, 80923, 77554, 124157, 118739, 92740, 124189, 109604, 61674, 118565, 72009, 29632, 82646, 69539, 130760, 127127, 77280, 128280, 83782, 124217, 132264, 113818, 96557, 66361)
Run Time: 0.035323
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: 7673, 0, 1713853548, 1713857148, [["thread",69976],["thread",130860],["thread",58344],["thread",123774],["thread",84366],["thread",118340],["thread",67447],["thread",89475],["thread",124519],["thread",125521],["thread",130763],["thread",68591],["thread",105875],["thread",80280],["thread",109824],["thread",96663],["thread",107288],["thread",101809],["thread",67062],["thread",105922],["thread",54314],["thread",124583],["thread",121489],["thread",77170],["thread",66305],["thread",98748],["thread",133330],["thread",84080],["thread",75589],["thread",111639],["thread",80391],["thread",112699],["thread",131798],["thread",50263],["thread",112268],["thread",70672],["thread",68782],["thread",118872],["thread",119740],["thread",125257],["thread",73179],["thread",91362],["thread",112061],["thread",134297],["thread",111036],["thread",127827],["thread",79125],["thread",125123],["thread",74863],["thread",90142],["thread",127044],["thread",134043],["thread",86598],["thread",121787],["thread",81437],["thread",68515],["thread",17913],["thread",67174],["thread",61761],["thread",65560],["thread",123280],["thread",106028],["thread",78448],["thread",114816],["thread",77591],["thread",111763],["thread",125402],["thread",126236],["thread",83613],["thread",126660],["thread",124678],["thread",82106],["thread",105864],["thread",119030],["thread",84308],["thread",94426],["thread",71618],["thread",127068],["thread",111056],["thread",24490],["thread",116546],["thread",59923],["thread",77401],["thread",122732],["thread",124607],["thread",132178],["thread",95457],["thread",66840],["thread",119443],["thread",101991],["thread",93680],["thread",88283],["thread",44366],["thread",76416],["thread",87133],["thread",33323],["thread",70371],["thread",90127],["thread",86148],["thread",69000],["thread",70373],["thread",71378],["thread",131422],["thread",40429],["thread",135018],["thread",100949],["thread",34730],["thread",94543],["thread",129111],["thread",103718],["thread",112176],["thread",93795],["thread",84307],["thread",124358],["thread",84469],["thread",14900],["thread",123365],["thread",88599],["thread",122658],["thread",121928],["thread",120365],["thread",127175],["thread",120551],["thread",109772],["thread",71377],["thread",124638],["thread",110238],["thread",97446],["thread",68752],["thread",136234],["thread",69969],["thread",96061],["thread",93253],["thread",33308],["thread",112536],["thread",66540],["thread",112075],["thread",126181],["thread",90512],["thread",136394],["thread",73726],["thread",125553],["thread",44805],["thread",124538],["thread",95088],["thread",29815],["thread",92999],["thread",124945],["thread",68467],["thread",111703],["thread",44845],["thread",34539],["thread",119444],["thread",88561],["thread",124392],["thread",112427],["thread",79590],["thread",66267],["thread",105811],["thread",67997],["thread",135148],["thread",69610],["thread",85793],["thread",111362],["thread",107493],["thread",71379],["thread",53935],["thread",130149],["thread",77917],["thread",119568],["thread",88238],["thread",34537],["thread",111187],["thread",125971],["thread",88629],["thread",133240],["thread",85895],["thread",76118],["thread",127936],["thread",82997],["thread",83704],["thread",80970],["thread",111134],["thread",120387],["thread",110889],["thread",69612],["thread",129929],["thread",71376],["thread",108375],["thread",90439],["thread",71466],["thread",82012],["thread",66802],["thread",111005],["thread",131418],["thread",68486],["thread",69384],["thread",77385],["thread",79588],["thread",123806],["thread",69143],["thread",84369],["thread",69788],["thread",119925],["thread",78793],["thread",119188],["thread",79649],["thread",86868],["thread",71464],["thread",95459],["thread",69564],["thread",118336],["thread",113813],["thread",124470],["thread",80966],["thread",116421],["thread",85720],["thread",107861],["thread",121821],["thread",34233],["thread",129228],["thread",122879],["thread",70712],["thread",117626],["thread",95114],["thread",106716],["thread",69934],["thread",105292],["thread",75588],["thread",134039],["thread",98930],["thread",70431],["thread",84124],["thread",124179],["thread",66426],["thread",112560],["thread",80792],["thread",105753],["thread",97080],["thread",106247],["thread",107857],["thread",135240],["thread",33314],["thread",77520],["thread",87116],["thread",81426],["thread",127069],["thread",71519],["thread",85259],["thread",40432],["thread",110571],["thread",34274],["thread",81677],["thread",86701],["thread",88235],["thread",87763],["thread",125543],["thread",81778],["thread",72597],["thread",84141],["thread",132069],["thread",111057],["thread",93341],["thread",86144],["thread",71359],["thread",81069],["thread",118795],["thread",93245],["thread",111301],["thread",104414],["thread",83163],["thread",87791],["thread",122091],["thread",81606],["thread",68588],["thread",66453],["thread",67786],["thread",80923],["thread",77554],["thread",124157],["thread",118739],["thread",92740],["thread",124189],["thread",109604],["thread",61674],["thread",118565],["thread",72009],["thread",29632],["thread",82646],["thread",69539],["thread",130760],["thread",127127],["thread",77280],["thread",128280],["thread",83782],["thread",124217],["thread",132264],["thread",113818],["thread",96557],["thread",66361]]
Run Time: 0.005747
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.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |