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 (98691, 97012, 30382, 60153, 91692, 40295, 90335, 101121, 36476, 79216, 94639, 60573, 45702, 80756, 49401, 78782, 96727, 72403, 90370, 71211, 56326, 50512, 50089, 33832, 92290, 91691, 116310, 32214, 57114, 98969, 35385, 130063, 111567, 48910, 43204, 46272, 88993, 88683, 12810, 119923, 91631, 121509, 24098, 23483, 89932, 79101, 33022, 99517, 97228, 89982, 36142, 81075, 100230, 42847, 30968, 89134, 34068, 81972, 93639, 89895, 39123, 120943, 68334, 77511, 78794, 56541, 131367, 82709, 50567, 72909, 57802, 56611, 93901, 33095, 93848, 63665, 90383, 80187, 100239, 40327, 110818, 90686, 78304, 23079, 80606, 124176, 33064, 32983, 45505, 120597, 130250, 103870, 100992, 97248, 97741, 33138, 108709, 93716, 130858, 68162, 38567, 68012, 99584, 97271, 56424, 104859, 96158, 26871, 19672, 101728, 17107, 97540, 90017, 99901, 48297, 27543, 50110, 78118, 99805, 101710, 99439, 72575, 115240, 114786, 108044, 80337, 132502, 110518, 27778, 32994, 134913, 77726, 126652, 90897, 20243, 57881, 37113, 58328, 84284, 89923, 90994, 99755, 78200, 17596, 120550, 1331, 28905, 62765, 114564, 41158, 82640, 80469, 24855, 71764, 118874, 93583, 42321, 34723, 94458, 129591, 56965, 93607, 63303, 38175, 77771, 387, 60564, 57990, 72346, 28463, 128008, 56551, 41675, 98022, 56191, 49702, 77534, 131812, 101497, 14904, 72087, 90217, 82843, 59104, 79424, 84290, 107225, 90870, 28213, 130857, 57364, 67752, 104419, 24227, 54831, 100472, 64695, 76683, 60808, 130072, 102406, 93108, 81620, 99850, 91904, 89425, 4977, 120537, 115234, 59121, 32943, 14058, 100685, 127184, 97140, 35084, 88596, 57886, 82142, 89918, 58928, 41613, 49211, 81081, 92105, 76716, 16927, 34799, 48833, 130882, 56426, 100149, 72910, 34065, 124526, 100360, 68152, 29025, 97365, 101294, 45291, 122347, 9382, 118172, 119364, 100686, 27580, 35496, 35812, 53427, 42353, 105383)
Run Time: 0.007216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 252 | 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: 57, 0, 1713403760, 1713407360, [["thread",98691],["thread",97012],["thread",30382],["thread",60153],["thread",91692],["thread",40295],["thread",90335],["thread",101121],["thread",36476],["thread",79216],["thread",94639],["thread",60573],["thread",45702],["thread",80756],["thread",49401],["thread",78782],["thread",96727],["thread",72403],["thread",90370],["thread",71211],["thread",56326],["thread",50512],["thread",50089],["thread",33832],["thread",92290],["thread",91691],["thread",116310],["thread",32214],["thread",57114],["thread",98969],["thread",35385],["thread",130063],["thread",111567],["thread",48910],["thread",43204],["thread",46272],["thread",88993],["thread",88683],["thread",12810],["thread",119923],["thread",91631],["thread",121509],["thread",24098],["thread",23483],["thread",89932],["thread",79101],["thread",33022],["thread",99517],["thread",97228],["thread",89982],["thread",36142],["thread",81075],["thread",100230],["thread",42847],["thread",30968],["thread",89134],["thread",34068],["thread",81972],["thread",93639],["thread",89895],["thread",39123],["thread",120943],["thread",68334],["thread",77511],["thread",78794],["thread",56541],["thread",131367],["thread",82709],["thread",50567],["thread",72909],["thread",57802],["thread",56611],["thread",93901],["thread",33095],["thread",93848],["thread",63665],["thread",90383],["thread",80187],["thread",100239],["thread",40327],["thread",110818],["thread",90686],["thread",78304],["thread",23079],["thread",80606],["thread",124176],["thread",33064],["thread",32983],["thread",45505],["thread",120597],["thread",130250],["thread",103870],["thread",100992],["thread",97248],["thread",97741],["thread",33138],["thread",108709],["thread",93716],["thread",130858],["thread",68162],["thread",38567],["thread",68012],["thread",99584],["thread",97271],["thread",56424],["thread",104859],["thread",96158],["thread",26871],["thread",19672],["thread",101728],["thread",17107],["thread",97540],["thread",90017],["thread",99901],["thread",48297],["thread",27543],["thread",50110],["thread",78118],["thread",99805],["thread",101710],["thread",99439],["thread",72575],["thread",115240],["thread",114786],["thread",108044],["thread",80337],["thread",132502],["thread",110518],["thread",27778],["thread",32994],["thread",134913],["thread",77726],["thread",126652],["thread",90897],["thread",20243],["thread",57881],["thread",37113],["thread",58328],["thread",84284],["thread",89923],["thread",90994],["thread",99755],["thread",78200],["thread",17596],["thread",120550],["thread",1331],["thread",28905],["thread",62765],["thread",114564],["thread",41158],["thread",82640],["thread",80469],["thread",24855],["thread",71764],["thread",118874],["thread",93583],["thread",42321],["thread",34723],["thread",94458],["thread",129591],["thread",56965],["thread",93607],["thread",63303],["thread",38175],["thread",77771],["thread",387],["thread",60564],["thread",57990],["thread",72346],["thread",28463],["thread",128008],["thread",56551],["thread",41675],["thread",98022],["thread",56191],["thread",49702],["thread",77534],["thread",131812],["thread",101497],["thread",14904],["thread",72087],["thread",90217],["thread",82843],["thread",59104],["thread",79424],["thread",84290],["thread",107225],["thread",90870],["thread",28213],["thread",130857],["thread",57364],["thread",67752],["thread",104419],["thread",24227],["thread",54831],["thread",100472],["thread",64695],["thread",76683],["thread",60808],["thread",130072],["thread",102406],["thread",93108],["thread",81620],["thread",99850],["thread",91904],["thread",89425],["thread",4977],["thread",120537],["thread",115234],["thread",59121],["thread",32943],["thread",14058],["thread",100685],["thread",127184],["thread",97140],["thread",35084],["thread",88596],["thread",57886],["thread",82142],["thread",89918],["thread",58928],["thread",41613],["thread",49211],["thread",81081],["thread",92105],["thread",76716],["thread",16927],["thread",34799],["thread",48833],["thread",130882],["thread",56426],["thread",100149],["thread",72910],["thread",34065],["thread",124526],["thread",100360],["thread",68152],["thread",29025],["thread",97365],["thread",101294],["thread",45291],["thread",122347],["thread",9382],["thread",118172],["thread",119364],["thread",100686],["thread",27580],["thread",35496],["thread",35812],["thread",53427],["thread",42353],["thread",105383]]
Run Time: 0.001173
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 |