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 (97545, 49016, 70541, 98091, 83319, 23714, 79712, 97900, 86403, 136123, 81848, 16854, 16562, 136532, 115383, 63483, 86080, 14949, 91937, 17100, 74851, 80830, 88856, 109841, 100065, 91812, 98779, 64952, 121014, 55781, 121245, 95944, 40751, 70636, 84398, 132495, 90228, 80265, 40748, 131064, 64872, 44000, 106702, 25615, 21222, 41002, 76818, 104857, 17983, 123748, 40779, 126589, 59524, 61830, 98447, 121806, 94211, 60138, 105255, 55944, 84250, 100615, 58504, 80728, 119414, 43431, 51389, 25925, 110951, 133690, 79784, 58502, 116764, 120171, 94414, 88037, 66698, 124956, 98293, 49393, 107886, 58414, 53700, 97671, 133161, 96877, 58606, 113297, 80403, 37941, 68440, 49543, 61237, 67711, 110170, 73690, 53478, 135968, 112007, 102252, 100922, 101141, 123621, 110627, 98253, 131300, 70916, 102052, 69499, 53803, 133678, 61250, 105459, 133418, 123389, 79501, 40780, 119441, 129705, 45857, 84989, 80401, 62946, 29371, 72366, 59158, 62883, 43653, 113650, 89883, 36537, 52908, 65145, 61892, 105916, 57755, 35684, 105305, 30691, 61836, 97962, 126675, 70727, 101657, 107362, 65830, 103565, 65336, 83701, 36386, 24015, 123966, 49526, 71369, 135316, 115119, 72602, 96179, 78978, 66470, 61023, 57523, 55245, 50023, 135506, 109163, 66018, 123741, 95841, 121235, 35188, 63825, 123330, 4426, 58226, 104061, 113034, 84044, 39556, 18644, 128676, 114055, 127186, 39476, 100212, 123866, 61572, 96306, 102689, 89021, 74706, 44159, 117777, 91760, 71765, 136189, 132745, 94645, 86288, 109291, 78923, 26708, 58084, 76353, 25563, 75809, 56190, 44035, 52903, 69185, 115608, 104075, 96304, 120635, 62737, 70895, 40367, 68421, 113895, 65155, 71681, 23436, 134716, 122373, 52043, 79289, 100551, 113277, 68737, 124959, 86078, 112417, 127077, 103892, 56895, 36653, 13370, 82525, 107257, 85158, 112254, 64831, 88044, 57992, 77494, 100082, 68647, 129751, 69374, 64835, 44648, 127830, 96271, 74151, 110675, 66407, 37504, 44025, 58416, 126337, 45881, 48713, 127788, 46504, 87513, 35970, 115203, 75418, 69044, 62521, 58636, 113299, 133682, 99377, 62977, 58257, 54504, 76847, 71222, 126416, 124257, 58057, 77911, 106961, 82095, 98072, 61174, 115030, 118686, 64540, 96273, 42035, 110064, 114067, 106562, 46088, 45735, 19866, 129459, 61544)
Run Time: 0.007774
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: 1434, 0, 1713557956, 1713561556, [["thread",97545],["thread",49016],["thread",70541],["thread",98091],["thread",83319],["thread",23714],["thread",79712],["thread",97900],["thread",86403],["thread",136123],["thread",81848],["thread",16854],["thread",16562],["thread",136532],["thread",115383],["thread",63483],["thread",86080],["thread",14949],["thread",91937],["thread",17100],["thread",74851],["thread",80830],["thread",88856],["thread",109841],["thread",100065],["thread",91812],["thread",98779],["thread",64952],["thread",121014],["thread",55781],["thread",121245],["thread",95944],["thread",40751],["thread",70636],["thread",84398],["thread",132495],["thread",90228],["thread",80265],["thread",40748],["thread",131064],["thread",64872],["thread",44000],["thread",106702],["thread",25615],["thread",21222],["thread",41002],["thread",76818],["thread",104857],["thread",17983],["thread",123748],["thread",40779],["thread",126589],["thread",59524],["thread",61830],["thread",98447],["thread",121806],["thread",94211],["thread",60138],["thread",105255],["thread",55944],["thread",84250],["thread",100615],["thread",58504],["thread",80728],["thread",119414],["thread",43431],["thread",51389],["thread",25925],["thread",110951],["thread",133690],["thread",79784],["thread",58502],["thread",116764],["thread",120171],["thread",94414],["thread",88037],["thread",66698],["thread",124956],["thread",98293],["thread",49393],["thread",107886],["thread",58414],["thread",53700],["thread",97671],["thread",133161],["thread",96877],["thread",58606],["thread",113297],["thread",80403],["thread",37941],["thread",68440],["thread",49543],["thread",61237],["thread",67711],["thread",110170],["thread",73690],["thread",53478],["thread",135968],["thread",112007],["thread",102252],["thread",100922],["thread",101141],["thread",123621],["thread",110627],["thread",98253],["thread",131300],["thread",70916],["thread",102052],["thread",69499],["thread",53803],["thread",133678],["thread",61250],["thread",105459],["thread",133418],["thread",123389],["thread",79501],["thread",40780],["thread",119441],["thread",129705],["thread",45857],["thread",84989],["thread",80401],["thread",62946],["thread",29371],["thread",72366],["thread",59158],["thread",62883],["thread",43653],["thread",113650],["thread",89883],["thread",36537],["thread",52908],["thread",65145],["thread",61892],["thread",105916],["thread",57755],["thread",35684],["thread",105305],["thread",30691],["thread",61836],["thread",97962],["thread",126675],["thread",70727],["thread",101657],["thread",107362],["thread",65830],["thread",103565],["thread",65336],["thread",83701],["thread",36386],["thread",24015],["thread",123966],["thread",49526],["thread",71369],["thread",135316],["thread",115119],["thread",72602],["thread",96179],["thread",78978],["thread",66470],["thread",61023],["thread",57523],["thread",55245],["thread",50023],["thread",135506],["thread",109163],["thread",66018],["thread",123741],["thread",95841],["thread",121235],["thread",35188],["thread",63825],["thread",123330],["thread",4426],["thread",58226],["thread",104061],["thread",113034],["thread",84044],["thread",39556],["thread",18644],["thread",128676],["thread",114055],["thread",127186],["thread",39476],["thread",100212],["thread",123866],["thread",61572],["thread",96306],["thread",102689],["thread",89021],["thread",74706],["thread",44159],["thread",117777],["thread",91760],["thread",71765],["thread",136189],["thread",132745],["thread",94645],["thread",86288],["thread",109291],["thread",78923],["thread",26708],["thread",58084],["thread",76353],["thread",25563],["thread",75809],["thread",56190],["thread",44035],["thread",52903],["thread",69185],["thread",115608],["thread",104075],["thread",96304],["thread",120635],["thread",62737],["thread",70895],["thread",40367],["thread",68421],["thread",113895],["thread",65155],["thread",71681],["thread",23436],["thread",134716],["thread",122373],["thread",52043],["thread",79289],["thread",100551],["thread",113277],["thread",68737],["thread",124959],["thread",86078],["thread",112417],["thread",127077],["thread",103892],["thread",56895],["thread",36653],["thread",13370],["thread",82525],["thread",107257],["thread",85158],["thread",112254],["thread",64831],["thread",88044],["thread",57992],["thread",77494],["thread",100082],["thread",68647],["thread",129751],["thread",69374],["thread",64835],["thread",44648],["thread",127830],["thread",96271],["thread",74151],["thread",110675],["thread",66407],["thread",37504],["thread",44025],["thread",58416],["thread",126337],["thread",45881],["thread",48713],["thread",127788],["thread",46504],["thread",87513],["thread",35970],["thread",115203],["thread",75418],["thread",69044],["thread",62521],["thread",58636],["thread",113299],["thread",133682],["thread",99377],["thread",62977],["thread",58257],["thread",54504],["thread",76847],["thread",71222],["thread",126416],["thread",124257],["thread",58057],["thread",77911],["thread",106961],["thread",82095],["thread",98072],["thread",61174],["thread",115030],["thread",118686],["thread",64540],["thread",96273],["thread",42035],["thread",110064],["thread",114067],["thread",106562],["thread",46088],["thread",45735],["thread",19866],["thread",129459],["thread",61544]]
Run Time: 0.003150
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.000064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |