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 (108638, 121983, 676, 81879, 81079, 44593, 78600, 80913, 75152, 95911, 81984, 498, 127240, 100518, 12972, 760, 88271, 12223, 93732, 80635, 121577, 76618, 81871, 83606, 77009, 60946, 61790, 112736, 12571, 79068, 109171, 80053, 108591, 78311, 81862, 102177, 74752, 121760, 79447, 79911, 78529, 80152, 74123, 87076, 80915, 74162, 44511, 82706, 80863, 81951, 1169, 109443, 100756, 380, 78252, 74267, 131803, 83050, 473, 607, 128709, 45409, 50054, 83527, 33376, 83440, 75034, 78309, 78411, 98688, 75540, 80098, 77743, 77022, 80480, 103681, 94507, 78546, 76697, 99040, 89552, 71901, 111911, 101590, 119862, 109020, 81434, 75790, 121652, 82135, 81965, 44464, 75849, 121004, 102481, 75160, 78135, 436, 111481, 103461, 79278, 97235, 121814, 69734, 82347, 114214, 51087, 97619, 80537, 80368, 78138, 105265, 831, 81810, 78583, 74952, 78123, 83739, 81406, 95244, 75306, 128663, 82886, 75266, 78698, 109484, 128610, 79420, 52765, 121584, 80898, 78675, 78266, 81998, 83340, 75514, 79261, 1874, 120521, 77019, 94111, 76976, 618, 115604, 83675, 120363, 123495, 81683, 136055, 124498, 75767, 78234, 130058, 93286, 112901, 86558, 114971, 98811, 78272, 84559, 94615, 81447, 51293, 78263, 128837, 762, 101327, 29939, 75986, 94763, 79137, 104685, 78573, 78302, 77805, 117827, 98978, 97717, 104428, 82661, 92069, 103428, 80964, 1190, 91894, 77233, 77043, 78191, 75906, 81493, 117483, 78464, 45333, 121106, 75501, 93699, 87632, 78339, 93552, 80867, 103304, 96869, 50285, 74866, 99188, 90076, 91373, 93426, 49939, 121320, 95873, 74969, 120051, 65088, 95983, 85216, 74761, 12060, 109748, 98561, 115779, 121374, 115349, 78717, 49860, 80019, 101093, 81294, 66751, 97124, 119227, 120263, 25689, 94537, 82018, 115106, 100414, 93066, 78149, 80900, 129882, 103300, 123881, 78329, 76834, 94470, 49768, 79709, 66720, 103313, 81517, 116543, 115347, 67398, 83563, 86470, 51109, 76039, 100516, 85580, 11323, 78295, 44589, 115644, 89039, 76288, 105262, 74670, 99245, 83764, 121305, 51576, 110239, 97143, 125942, 78799, 82136, 122402, 81953, 84394, 116676, 100721, 81523, 107523, 92167, 134740, 47918, 91427, 84911, 107617, 94423, 76625, 80877, 96094, 316, 103596, 25849, 77477, 12164, 95090)
Run Time: 0.122097
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: 61, 0, 1715442145, 1715445745, [["thread",108638],["thread",121983],["thread",676],["thread",81879],["thread",81079],["thread",44593],["thread",78600],["thread",80913],["thread",75152],["thread",95911],["thread",81984],["thread",498],["thread",127240],["thread",100518],["thread",12972],["thread",760],["thread",88271],["thread",12223],["thread",93732],["thread",80635],["thread",121577],["thread",76618],["thread",81871],["thread",83606],["thread",77009],["thread",60946],["thread",61790],["thread",112736],["thread",12571],["thread",79068],["thread",109171],["thread",80053],["thread",108591],["thread",78311],["thread",81862],["thread",102177],["thread",74752],["thread",121760],["thread",79447],["thread",79911],["thread",78529],["thread",80152],["thread",74123],["thread",87076],["thread",80915],["thread",74162],["thread",44511],["thread",82706],["thread",80863],["thread",81951],["thread",1169],["thread",109443],["thread",100756],["thread",380],["thread",78252],["thread",74267],["thread",131803],["thread",83050],["thread",473],["thread",607],["thread",128709],["thread",45409],["thread",50054],["thread",83527],["thread",33376],["thread",83440],["thread",75034],["thread",78309],["thread",78411],["thread",98688],["thread",75540],["thread",80098],["thread",77743],["thread",77022],["thread",80480],["thread",103681],["thread",94507],["thread",78546],["thread",76697],["thread",99040],["thread",89552],["thread",71901],["thread",111911],["thread",101590],["thread",119862],["thread",109020],["thread",81434],["thread",75790],["thread",121652],["thread",82135],["thread",81965],["thread",44464],["thread",75849],["thread",121004],["thread",102481],["thread",75160],["thread",78135],["thread",436],["thread",111481],["thread",103461],["thread",79278],["thread",97235],["thread",121814],["thread",69734],["thread",82347],["thread",114214],["thread",51087],["thread",97619],["thread",80537],["thread",80368],["thread",78138],["thread",105265],["thread",831],["thread",81810],["thread",78583],["thread",74952],["thread",78123],["thread",83739],["thread",81406],["thread",95244],["thread",75306],["thread",128663],["thread",82886],["thread",75266],["thread",78698],["thread",109484],["thread",128610],["thread",79420],["thread",52765],["thread",121584],["thread",80898],["thread",78675],["thread",78266],["thread",81998],["thread",83340],["thread",75514],["thread",79261],["thread",1874],["thread",120521],["thread",77019],["thread",94111],["thread",76976],["thread",618],["thread",115604],["thread",83675],["thread",120363],["thread",123495],["thread",81683],["thread",136055],["thread",124498],["thread",75767],["thread",78234],["thread",130058],["thread",93286],["thread",112901],["thread",86558],["thread",114971],["thread",98811],["thread",78272],["thread",84559],["thread",94615],["thread",81447],["thread",51293],["thread",78263],["thread",128837],["thread",762],["thread",101327],["thread",29939],["thread",75986],["thread",94763],["thread",79137],["thread",104685],["thread",78573],["thread",78302],["thread",77805],["thread",117827],["thread",98978],["thread",97717],["thread",104428],["thread",82661],["thread",92069],["thread",103428],["thread",80964],["thread",1190],["thread",91894],["thread",77233],["thread",77043],["thread",78191],["thread",75906],["thread",81493],["thread",117483],["thread",78464],["thread",45333],["thread",121106],["thread",75501],["thread",93699],["thread",87632],["thread",78339],["thread",93552],["thread",80867],["thread",103304],["thread",96869],["thread",50285],["thread",74866],["thread",99188],["thread",90076],["thread",91373],["thread",93426],["thread",49939],["thread",121320],["thread",95873],["thread",74969],["thread",120051],["thread",65088],["thread",95983],["thread",85216],["thread",74761],["thread",12060],["thread",109748],["thread",98561],["thread",115779],["thread",121374],["thread",115349],["thread",78717],["thread",49860],["thread",80019],["thread",101093],["thread",81294],["thread",66751],["thread",97124],["thread",119227],["thread",120263],["thread",25689],["thread",94537],["thread",82018],["thread",115106],["thread",100414],["thread",93066],["thread",78149],["thread",80900],["thread",129882],["thread",103300],["thread",123881],["thread",78329],["thread",76834],["thread",94470],["thread",49768],["thread",79709],["thread",66720],["thread",103313],["thread",81517],["thread",116543],["thread",115347],["thread",67398],["thread",83563],["thread",86470],["thread",51109],["thread",76039],["thread",100516],["thread",85580],["thread",11323],["thread",78295],["thread",44589],["thread",115644],["thread",89039],["thread",76288],["thread",105262],["thread",74670],["thread",99245],["thread",83764],["thread",121305],["thread",51576],["thread",110239],["thread",97143],["thread",125942],["thread",78799],["thread",82136],["thread",122402],["thread",81953],["thread",84394],["thread",116676],["thread",100721],["thread",81523],["thread",107523],["thread",92167],["thread",134740],["thread",47918],["thread",91427],["thread",84911],["thread",107617],["thread",94423],["thread",76625],["thread",80877],["thread",96094],["thread",316],["thread",103596],["thread",25849],["thread",77477],["thread",12164],["thread",95090]]
Run Time: 0.087366
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.030743
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |