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 (40481, 68235, 66611, 64734, 70536, 97616, 68735, 69181, 79783, 67068, 67343, 87659, 43075, 60508, 66708, 44118, 53876, 49435, 41061, 66577, 78211, 107795, 40414, 88191, 103719, 63936, 64542, 70443, 41105, 42910, 65667, 51750, 40250, 63285, 69627, 40131, 66077, 68224, 94154, 64560, 61907, 41541, 67818, 57879, 46719, 65828, 39377, 37412, 72610, 70006, 67021, 63807, 69155, 45481, 74477, 102273, 77373, 84832, 71354, 71003, 74859, 92009, 71661, 66075, 46727, 116455, 69840, 72734, 102980, 97333, 65474, 40921, 96591, 90211, 68732, 57154, 74189, 64240, 66492, 94099, 70986, 70592, 66559, 68197, 65877, 41386, 37709, 57587, 63750, 67537, 71004, 39969, 90872, 66716, 39023, 88568, 39163, 52942, 65766, 66724, 40129, 63623, 66837, 41211, 73285, 67440, 58215, 68984, 67494, 75047, 61261, 85751, 70061, 68738, 97979, 110809, 55724, 64019, 35326, 42723, 70981, 102472, 63465, 70361, 68388, 112317, 63631, 69875, 60393, 65737, 71253, 112703, 92110, 39748, 61839, 70098, 96995, 41407, 86501, 82492, 63740, 68006, 67555, 79234, 68657, 57512, 70799, 21125, 66501, 34721, 74724, 60121, 65823, 50366, 71386, 70483, 64930, 50315, 74200, 63536, 71490, 70547, 37907, 67483, 32384, 64838, 52008, 105303, 43073, 62837, 84588, 111462, 101222, 64977, 28038, 74797, 40275, 64570, 81564, 48711, 63484, 74384, 68541, 70920, 64539, 52087, 45911, 61413, 101759, 64546, 66350, 64508, 75216, 80011, 65832, 69332, 71428, 35862, 104462, 33742, 47334, 42280, 100538, 64934, 55154, 67860, 64768, 40035, 62703, 31434, 68570, 61553, 85666, 74963, 73550, 53784, 57130, 24300, 55544, 67182, 48647, 39344, 71523, 66469, 60396, 40751, 66953, 101144, 69071, 62871, 86050, 52508, 52551, 46734, 66819, 66597, 65696, 66022, 49178, 64866, 80630, 71251, 68766, 79970, 69344, 39988, 65944, 59650, 81331, 40219, 50851, 105810, 36050, 45448, 66360, 71629, 98300, 40557, 71577, 130958, 63557, 38850, 115943, 65469, 64282, 64547, 62966, 7609, 26075, 41040, 90938, 58340, 24150, 71157, 63428, 104224, 70014, 32484, 71590, 45133, 113976, 69349, 50673, 40114, 40900, 64845, 49259, 45686, 68471, 115740, 64532, 63343, 59224, 63012, 70703, 64782, 64206, 43375, 78290, 65709)
Run Time: 0.007658
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: 1389, 0, 1713909734, 1713913334, [["thread",40481],["thread",68235],["thread",66611],["thread",64734],["thread",70536],["thread",97616],["thread",68735],["thread",69181],["thread",79783],["thread",67068],["thread",67343],["thread",87659],["thread",43075],["thread",60508],["thread",66708],["thread",44118],["thread",53876],["thread",49435],["thread",41061],["thread",66577],["thread",78211],["thread",107795],["thread",40414],["thread",88191],["thread",103719],["thread",63936],["thread",64542],["thread",70443],["thread",41105],["thread",42910],["thread",65667],["thread",51750],["thread",40250],["thread",63285],["thread",69627],["thread",40131],["thread",66077],["thread",68224],["thread",94154],["thread",64560],["thread",61907],["thread",41541],["thread",67818],["thread",57879],["thread",46719],["thread",65828],["thread",39377],["thread",37412],["thread",72610],["thread",70006],["thread",67021],["thread",63807],["thread",69155],["thread",45481],["thread",74477],["thread",102273],["thread",77373],["thread",84832],["thread",71354],["thread",71003],["thread",74859],["thread",92009],["thread",71661],["thread",66075],["thread",46727],["thread",116455],["thread",69840],["thread",72734],["thread",102980],["thread",97333],["thread",65474],["thread",40921],["thread",96591],["thread",90211],["thread",68732],["thread",57154],["thread",74189],["thread",64240],["thread",66492],["thread",94099],["thread",70986],["thread",70592],["thread",66559],["thread",68197],["thread",65877],["thread",41386],["thread",37709],["thread",57587],["thread",63750],["thread",67537],["thread",71004],["thread",39969],["thread",90872],["thread",66716],["thread",39023],["thread",88568],["thread",39163],["thread",52942],["thread",65766],["thread",66724],["thread",40129],["thread",63623],["thread",66837],["thread",41211],["thread",73285],["thread",67440],["thread",58215],["thread",68984],["thread",67494],["thread",75047],["thread",61261],["thread",85751],["thread",70061],["thread",68738],["thread",97979],["thread",110809],["thread",55724],["thread",64019],["thread",35326],["thread",42723],["thread",70981],["thread",102472],["thread",63465],["thread",70361],["thread",68388],["thread",112317],["thread",63631],["thread",69875],["thread",60393],["thread",65737],["thread",71253],["thread",112703],["thread",92110],["thread",39748],["thread",61839],["thread",70098],["thread",96995],["thread",41407],["thread",86501],["thread",82492],["thread",63740],["thread",68006],["thread",67555],["thread",79234],["thread",68657],["thread",57512],["thread",70799],["thread",21125],["thread",66501],["thread",34721],["thread",74724],["thread",60121],["thread",65823],["thread",50366],["thread",71386],["thread",70483],["thread",64930],["thread",50315],["thread",74200],["thread",63536],["thread",71490],["thread",70547],["thread",37907],["thread",67483],["thread",32384],["thread",64838],["thread",52008],["thread",105303],["thread",43073],["thread",62837],["thread",84588],["thread",111462],["thread",101222],["thread",64977],["thread",28038],["thread",74797],["thread",40275],["thread",64570],["thread",81564],["thread",48711],["thread",63484],["thread",74384],["thread",68541],["thread",70920],["thread",64539],["thread",52087],["thread",45911],["thread",61413],["thread",101759],["thread",64546],["thread",66350],["thread",64508],["thread",75216],["thread",80011],["thread",65832],["thread",69332],["thread",71428],["thread",35862],["thread",104462],["thread",33742],["thread",47334],["thread",42280],["thread",100538],["thread",64934],["thread",55154],["thread",67860],["thread",64768],["thread",40035],["thread",62703],["thread",31434],["thread",68570],["thread",61553],["thread",85666],["thread",74963],["thread",73550],["thread",53784],["thread",57130],["thread",24300],["thread",55544],["thread",67182],["thread",48647],["thread",39344],["thread",71523],["thread",66469],["thread",60396],["thread",40751],["thread",66953],["thread",101144],["thread",69071],["thread",62871],["thread",86050],["thread",52508],["thread",52551],["thread",46734],["thread",66819],["thread",66597],["thread",65696],["thread",66022],["thread",49178],["thread",64866],["thread",80630],["thread",71251],["thread",68766],["thread",79970],["thread",69344],["thread",39988],["thread",65944],["thread",59650],["thread",81331],["thread",40219],["thread",50851],["thread",105810],["thread",36050],["thread",45448],["thread",66360],["thread",71629],["thread",98300],["thread",40557],["thread",71577],["thread",130958],["thread",63557],["thread",38850],["thread",115943],["thread",65469],["thread",64282],["thread",64547],["thread",62966],["thread",7609],["thread",26075],["thread",41040],["thread",90938],["thread",58340],["thread",24150],["thread",71157],["thread",63428],["thread",104224],["thread",70014],["thread",32484],["thread",71590],["thread",45133],["thread",113976],["thread",69349],["thread",50673],["thread",40114],["thread",40900],["thread",64845],["thread",49259],["thread",45686],["thread",68471],["thread",115740],["thread",64532],["thread",63343],["thread",59224],["thread",63012],["thread",70703],["thread",64782],["thread",64206],["thread",43375],["thread",78290],["thread",65709]]
Run Time: 0.001801
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.000117
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |