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 (129723, 68700, 64867, 117441, 89533, 124125, 85706, 104063, 79763, 23961, 125138, 115978, 86924, 84656, 133678, 27754, 66499, 120160, 77925, 95594, 64171, 127982, 96197, 63804, 68777, 104445, 109610, 40895, 122850, 95499, 61779, 129027, 100445, 74964, 84659, 107873, 40270, 63162, 95614, 48713, 63692, 38134, 100448, 71445, 124733, 95464, 90734, 131131, 131106, 94211, 112165, 62065, 36652, 113192, 102621, 136843, 59757, 44610, 64305, 90389, 83976, 108586, 118102, 61446, 114973, 84230, 65626, 114954, 83450, 95302, 112208, 85012, 106953, 58412, 101711, 122687, 96063, 118748, 126512, 119371, 97340, 97313, 36637, 114563, 91666, 84235, 106890, 84020, 59156, 113430, 70363, 99065, 33721, 124282, 93272, 131491, 90108, 103744, 116355, 127712, 113456, 100790, 107283, 121813, 113529, 99627, 127338, 97278, 89510, 84688, 95924, 115030, 48654, 114067, 101797, 111729, 105000, 116329, 52461, 71743, 41971, 71681, 105007, 82716, 129520, 121245, 121756, 120092, 39759, 63033, 121993, 103868, 133387, 45881, 68885, 83395, 128701, 125668, 127253, 97650, 91309, 109645, 110629, 90730, 97363, 129615, 79130, 71064, 76571, 46439, 131929, 37640, 57755, 109395, 110636, 87712, 133652, 44488, 116330, 65607, 83547, 127772, 83425, 132953, 86564, 64831, 76847, 36840, 83367, 86354, 125721, 121286, 48375, 132854, 70541, 40367, 65948, 63483, 98513, 112983, 127843, 83835, 125208, 87972, 102752, 113570, 125192, 80007, 110553, 126022, 84598, 38210, 62773, 60455, 122212, 47822, 126511, 56740, 87878, 105313, 118863, 59315, 70306, 93302, 54775, 69937, 58341, 132375, 102668, 125885, 85875, 83239, 91326, 69220, 100172, 61964, 49276, 71789, 102441, 113490, 87535, 86169, 103736, 103616, 86938, 75610, 58033, 67165, 82456, 132610, 70893, 84250, 106291, 69792, 83319, 48116, 68217, 41718, 105344, 79115, 109584, 38079, 70734, 48281, 42059, 87190, 82116, 67727, 54372, 84218, 92333, 105305, 99833, 99477, 60497, 98197, 84651, 96689, 55155, 49393, 87195, 109934, 117064, 100147, 67993, 82968, 83751, 61026, 82979, 113674, 62630, 107652, 100277, 102649, 133066, 96306, 91457, 89252, 111983, 57214, 131745, 135968, 123095, 129751, 50195, 102865, 117462, 126472, 132970, 87625, 84219, 80024, 47941, 75685, 70093, 132982, 113228, 93152, 125078, 64861)
Run Time: 0.009344
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: 4548, 0, 1714195028, 1714198628, [["thread",129723],["thread",68700],["thread",64867],["thread",117441],["thread",89533],["thread",124125],["thread",85706],["thread",104063],["thread",79763],["thread",23961],["thread",125138],["thread",115978],["thread",86924],["thread",84656],["thread",133678],["thread",27754],["thread",66499],["thread",120160],["thread",77925],["thread",95594],["thread",64171],["thread",127982],["thread",96197],["thread",63804],["thread",68777],["thread",104445],["thread",109610],["thread",40895],["thread",122850],["thread",95499],["thread",61779],["thread",129027],["thread",100445],["thread",74964],["thread",84659],["thread",107873],["thread",40270],["thread",63162],["thread",95614],["thread",48713],["thread",63692],["thread",38134],["thread",100448],["thread",71445],["thread",124733],["thread",95464],["thread",90734],["thread",131131],["thread",131106],["thread",94211],["thread",112165],["thread",62065],["thread",36652],["thread",113192],["thread",102621],["thread",136843],["thread",59757],["thread",44610],["thread",64305],["thread",90389],["thread",83976],["thread",108586],["thread",118102],["thread",61446],["thread",114973],["thread",84230],["thread",65626],["thread",114954],["thread",83450],["thread",95302],["thread",112208],["thread",85012],["thread",106953],["thread",58412],["thread",101711],["thread",122687],["thread",96063],["thread",118748],["thread",126512],["thread",119371],["thread",97340],["thread",97313],["thread",36637],["thread",114563],["thread",91666],["thread",84235],["thread",106890],["thread",84020],["thread",59156],["thread",113430],["thread",70363],["thread",99065],["thread",33721],["thread",124282],["thread",93272],["thread",131491],["thread",90108],["thread",103744],["thread",116355],["thread",127712],["thread",113456],["thread",100790],["thread",107283],["thread",121813],["thread",113529],["thread",99627],["thread",127338],["thread",97278],["thread",89510],["thread",84688],["thread",95924],["thread",115030],["thread",48654],["thread",114067],["thread",101797],["thread",111729],["thread",105000],["thread",116329],["thread",52461],["thread",71743],["thread",41971],["thread",71681],["thread",105007],["thread",82716],["thread",129520],["thread",121245],["thread",121756],["thread",120092],["thread",39759],["thread",63033],["thread",121993],["thread",103868],["thread",133387],["thread",45881],["thread",68885],["thread",83395],["thread",128701],["thread",125668],["thread",127253],["thread",97650],["thread",91309],["thread",109645],["thread",110629],["thread",90730],["thread",97363],["thread",129615],["thread",79130],["thread",71064],["thread",76571],["thread",46439],["thread",131929],["thread",37640],["thread",57755],["thread",109395],["thread",110636],["thread",87712],["thread",133652],["thread",44488],["thread",116330],["thread",65607],["thread",83547],["thread",127772],["thread",83425],["thread",132953],["thread",86564],["thread",64831],["thread",76847],["thread",36840],["thread",83367],["thread",86354],["thread",125721],["thread",121286],["thread",48375],["thread",132854],["thread",70541],["thread",40367],["thread",65948],["thread",63483],["thread",98513],["thread",112983],["thread",127843],["thread",83835],["thread",125208],["thread",87972],["thread",102752],["thread",113570],["thread",125192],["thread",80007],["thread",110553],["thread",126022],["thread",84598],["thread",38210],["thread",62773],["thread",60455],["thread",122212],["thread",47822],["thread",126511],["thread",56740],["thread",87878],["thread",105313],["thread",118863],["thread",59315],["thread",70306],["thread",93302],["thread",54775],["thread",69937],["thread",58341],["thread",132375],["thread",102668],["thread",125885],["thread",85875],["thread",83239],["thread",91326],["thread",69220],["thread",100172],["thread",61964],["thread",49276],["thread",71789],["thread",102441],["thread",113490],["thread",87535],["thread",86169],["thread",103736],["thread",103616],["thread",86938],["thread",75610],["thread",58033],["thread",67165],["thread",82456],["thread",132610],["thread",70893],["thread",84250],["thread",106291],["thread",69792],["thread",83319],["thread",48116],["thread",68217],["thread",41718],["thread",105344],["thread",79115],["thread",109584],["thread",38079],["thread",70734],["thread",48281],["thread",42059],["thread",87190],["thread",82116],["thread",67727],["thread",54372],["thread",84218],["thread",92333],["thread",105305],["thread",99833],["thread",99477],["thread",60497],["thread",98197],["thread",84651],["thread",96689],["thread",55155],["thread",49393],["thread",87195],["thread",109934],["thread",117064],["thread",100147],["thread",67993],["thread",82968],["thread",83751],["thread",61026],["thread",82979],["thread",113674],["thread",62630],["thread",107652],["thread",100277],["thread",102649],["thread",133066],["thread",96306],["thread",91457],["thread",89252],["thread",111983],["thread",57214],["thread",131745],["thread",135968],["thread",123095],["thread",129751],["thread",50195],["thread",102865],["thread",117462],["thread",126472],["thread",132970],["thread",87625],["thread",84219],["thread",80024],["thread",47941],["thread",75685],["thread",70093],["thread",132982],["thread",113228],["thread",93152],["thread",125078],["thread",64861]]
Run Time: 0.001204
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.000215
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |