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