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 (58860, 86358, 51360, 86796, 46727, 96272, 111470, 62742, 54325, 42056, 57009, 22867, 123556, 60287, 85543, 66432, 110182, 64444, 64110, 70111, 113178, 84195, 41970, 55955, 29514, 66055, 83445, 68054, 87717, 77287, 59652, 50174, 54658, 51525, 57919, 80200, 50802, 86405, 62677, 98267, 47045, 95879, 100119, 54273, 61611, 73231, 105923, 61503, 86456, 58225, 60819, 83150, 88914, 56018, 87284, 45902, 58004, 95880, 50145, 88934, 84971, 79854, 63076, 64462, 116038, 37399, 71642, 46269, 42874, 91112, 98901, 87723, 52887, 86632, 61664, 52047, 121840, 57142, 85129, 71791, 26313, 91933, 67745, 68123, 63138, 83690, 102163, 82664, 128804, 99251, 99190, 67534, 88488, 80918, 62266, 105857, 48109, 73562, 63394, 23504, 80477, 43579, 111625, 80455, 83398, 80190, 36963, 106314, 55009, 44807, 87839, 80051, 66460, 87608, 74661, 113379, 61050, 100223, 53885, 91643, 63789, 83929, 110408, 64648, 48480, 14949, 4579, 64158, 111107, 77063, 78510, 109292, 61428, 52856, 95973, 61069, 108261, 96665, 58949, 69820, 95148, 64155, 103555, 66130, 28001, 74996, 81503, 87598, 30498, 57393, 72558, 30456, 55788, 82789, 44165, 63877, 74776, 67032, 74060, 65920, 52830, 65663, 88952, 65973, 108191, 96241, 82717, 62561, 65059, 66347, 86882, 35218, 67148, 82567, 42038, 67949, 86802, 123839, 85076, 78961, 66987, 114863, 52558, 86731, 92112, 97613, 86702, 93563, 45330, 72191, 86290, 58644, 108991, 54627, 109095, 67506, 103757, 92961, 55643, 62272, 93619, 56037, 60471, 47808, 77707, 98717, 77343, 64773, 71911, 107951, 102795, 81908, 117305, 80532, 85956, 95591, 97731, 81763, 57011, 65907, 67137, 108521, 67574, 59968, 87930, 61244, 50787, 69045, 90651, 66708, 77916, 64170, 92526, 67225, 45264, 79972, 87052, 92759, 44563, 63189, 84192, 108133, 87355, 57648, 67854, 79014, 91741, 86511, 36903, 53756, 45372, 81798, 123439, 134183, 118007, 87132, 70161, 52060, 85987, 61792, 68273, 50547, 91082, 75041, 49991, 109776, 88471, 77641, 91021, 72448, 70536, 70492, 49954, 85751, 97198, 83074, 75495, 70987, 111599, 71771, 70867, 86446, 104035, 61397, 109804, 73976, 84065, 66109, 58464, 89064, 42008, 73503, 100514, 63540, 40943, 69862, 43712, 30844, 87418, 110554)
Run Time: 0.058260
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: 3437, 0, 1715411162, 1715414762, [["thread",58860],["thread",86358],["thread",51360],["thread",86796],["thread",46727],["thread",96272],["thread",111470],["thread",62742],["thread",54325],["thread",42056],["thread",57009],["thread",22867],["thread",123556],["thread",60287],["thread",85543],["thread",66432],["thread",110182],["thread",64444],["thread",64110],["thread",70111],["thread",113178],["thread",84195],["thread",41970],["thread",55955],["thread",29514],["thread",66055],["thread",83445],["thread",68054],["thread",87717],["thread",77287],["thread",59652],["thread",50174],["thread",54658],["thread",51525],["thread",57919],["thread",80200],["thread",50802],["thread",86405],["thread",62677],["thread",98267],["thread",47045],["thread",95879],["thread",100119],["thread",54273],["thread",61611],["thread",73231],["thread",105923],["thread",61503],["thread",86456],["thread",58225],["thread",60819],["thread",83150],["thread",88914],["thread",56018],["thread",87284],["thread",45902],["thread",58004],["thread",95880],["thread",50145],["thread",88934],["thread",84971],["thread",79854],["thread",63076],["thread",64462],["thread",116038],["thread",37399],["thread",71642],["thread",46269],["thread",42874],["thread",91112],["thread",98901],["thread",87723],["thread",52887],["thread",86632],["thread",61664],["thread",52047],["thread",121840],["thread",57142],["thread",85129],["thread",71791],["thread",26313],["thread",91933],["thread",67745],["thread",68123],["thread",63138],["thread",83690],["thread",102163],["thread",82664],["thread",128804],["thread",99251],["thread",99190],["thread",67534],["thread",88488],["thread",80918],["thread",62266],["thread",105857],["thread",48109],["thread",73562],["thread",63394],["thread",23504],["thread",80477],["thread",43579],["thread",111625],["thread",80455],["thread",83398],["thread",80190],["thread",36963],["thread",106314],["thread",55009],["thread",44807],["thread",87839],["thread",80051],["thread",66460],["thread",87608],["thread",74661],["thread",113379],["thread",61050],["thread",100223],["thread",53885],["thread",91643],["thread",63789],["thread",83929],["thread",110408],["thread",64648],["thread",48480],["thread",14949],["thread",4579],["thread",64158],["thread",111107],["thread",77063],["thread",78510],["thread",109292],["thread",61428],["thread",52856],["thread",95973],["thread",61069],["thread",108261],["thread",96665],["thread",58949],["thread",69820],["thread",95148],["thread",64155],["thread",103555],["thread",66130],["thread",28001],["thread",74996],["thread",81503],["thread",87598],["thread",30498],["thread",57393],["thread",72558],["thread",30456],["thread",55788],["thread",82789],["thread",44165],["thread",63877],["thread",74776],["thread",67032],["thread",74060],["thread",65920],["thread",52830],["thread",65663],["thread",88952],["thread",65973],["thread",108191],["thread",96241],["thread",82717],["thread",62561],["thread",65059],["thread",66347],["thread",86882],["thread",35218],["thread",67148],["thread",82567],["thread",42038],["thread",67949],["thread",86802],["thread",123839],["thread",85076],["thread",78961],["thread",66987],["thread",114863],["thread",52558],["thread",86731],["thread",92112],["thread",97613],["thread",86702],["thread",93563],["thread",45330],["thread",72191],["thread",86290],["thread",58644],["thread",108991],["thread",54627],["thread",109095],["thread",67506],["thread",103757],["thread",92961],["thread",55643],["thread",62272],["thread",93619],["thread",56037],["thread",60471],["thread",47808],["thread",77707],["thread",98717],["thread",77343],["thread",64773],["thread",71911],["thread",107951],["thread",102795],["thread",81908],["thread",117305],["thread",80532],["thread",85956],["thread",95591],["thread",97731],["thread",81763],["thread",57011],["thread",65907],["thread",67137],["thread",108521],["thread",67574],["thread",59968],["thread",87930],["thread",61244],["thread",50787],["thread",69045],["thread",90651],["thread",66708],["thread",77916],["thread",64170],["thread",92526],["thread",67225],["thread",45264],["thread",79972],["thread",87052],["thread",92759],["thread",44563],["thread",63189],["thread",84192],["thread",108133],["thread",87355],["thread",57648],["thread",67854],["thread",79014],["thread",91741],["thread",86511],["thread",36903],["thread",53756],["thread",45372],["thread",81798],["thread",123439],["thread",134183],["thread",118007],["thread",87132],["thread",70161],["thread",52060],["thread",85987],["thread",61792],["thread",68273],["thread",50547],["thread",91082],["thread",75041],["thread",49991],["thread",109776],["thread",88471],["thread",77641],["thread",91021],["thread",72448],["thread",70536],["thread",70492],["thread",49954],["thread",85751],["thread",97198],["thread",83074],["thread",75495],["thread",70987],["thread",111599],["thread",71771],["thread",70867],["thread",86446],["thread",104035],["thread",61397],["thread",109804],["thread",73976],["thread",84065],["thread",66109],["thread",58464],["thread",89064],["thread",42008],["thread",73503],["thread",100514],["thread",63540],["thread",40943],["thread",69862],["thread",43712],["thread",30844],["thread",87418],["thread",110554]]
Run Time: 0.067744
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.050998
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |