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