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 (45003, 16365, 74219, 36924, 7204, 97883, 52425, 83067, 91473, 69196, 85220, 40220, 633, 102690, 88440, 77043, 98980, 93236, 96008, 96114, 634, 79169, 115335, 57717, 39452, 131235, 56813, 64545, 119723, 80916, 49973, 56648, 115502, 105849, 81457, 24772, 107063, 96189, 29273, 75146, 76878, 57947, 52754, 78662, 80610, 498, 80492, 63007, 23071, 79513, 82600, 78464, 59605, 106475, 61605, 9540, 107594, 75670, 59852, 33466, 83295, 87516, 84054, 132761, 752, 134773, 48878, 115795, 51733, 119365, 84361, 89628, 106148, 78279, 11161, 122164, 117827, 83293, 52762, 24320, 74869, 120541, 85296, 12164, 51459, 51894, 52749, 99029, 79620, 83325, 119953, 17514, 96760, 11246, 29548, 79383, 116543, 39656, 61813, 91261, 11323, 100414, 127388, 68019, 99980, 1874, 38791, 83243, 129104, 23887, 63277, 51370, 11786, 115527, 80600, 83573, 37128, 84466, 117485, 79804, 59831, 33463, 76067, 2699, 114320, 69853, 10516, 80961, 41131, 78263, 99770, 46026, 80289, 97337, 75907, 110527, 129824, 52745, 52751, 110242, 27594, 96429, 58159, 121576, 81067, 38898, 76803, 78149, 79280, 17320, 618, 78928, 15961, 36930, 80294, 55734, 60913, 74970, 37100, 35734, 80487, 101629, 92233, 29000, 12343, 59582, 76958, 27339, 36532, 8288, 89721, 78123, 117848, 78498, 125291, 96516, 56444, 102191, 75081, 12569, 89482, 61034, 51141, 79909, 11818, 100961, 78229, 44298, 66370, 76662, 88387, 52757, 84278, 44182, 95656, 95456, 86442, 41340, 12060, 52307, 114608, 52670, 87147, 82444, 380, 120522, 95826, 36144, 11332, 72551, 36921, 1195, 12562, 82318, 127961, 72562, 105859, 36920, 105942, 83527, 82976, 52744, 94044, 77462, 95792, 78573, 77946, 46151, 129376, 12654, 762, 123350, 50014, 94720, 79151, 1735, 78493, 83333, 43236, 1430, 71079, 12571, 101162, 79296, 80323, 110530, 124541, 80877, 1122, 7481, 43381, 95530, 119087, 93996, 83768, 97185, 119705, 89922, 89466, 23143, 73777, 78580, 115314, 95946, 51676, 51243, 78698, 87444, 80233, 68257, 36008, 52747, 62509, 60025, 33467, 7170, 78675, 84087, 104326, 29555, 99526, 117490, 130919, 81079, 120427, 123249, 95716, 85580, 74357, 82418, 337, 104498, 127471, 50920, 131289, 95861, 77005, 79873, 16945)
Run Time: 0.044626
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 299 | 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: 105, 0, 1713886368, 1713889968, [["tinhte_xentag_forum",45],["thread",45003],["thread",16365],["thread",74219],["thread",36924],["thread",7204],["thread",97883],["thread",52425],["thread",83067],["thread",91473],["thread",69196],["thread",85220],["thread",40220],["thread",633],["thread",102690],["thread",88440],["thread",77043],["thread",98980],["thread",93236],["thread",96008],["thread",96114],["thread",634],["thread",79169],["thread",115335],["thread",57717],["thread",39452],["thread",131235],["thread",56813],["thread",64545],["thread",119723],["thread",80916],["thread",49973],["thread",56648],["thread",115502],["thread",105849],["thread",81457],["thread",24772],["thread",107063],["thread",96189],["thread",29273],["thread",75146],["thread",76878],["thread",57947],["thread",52754],["thread",78662],["thread",80610],["thread",498],["thread",80492],["thread",63007],["thread",23071],["thread",79513],["thread",82600],["thread",78464],["thread",59605],["thread",106475],["thread",61605],["thread",9540],["thread",107594],["thread",75670],["thread",59852],["thread",33466],["thread",83295],["thread",87516],["thread",84054],["thread",132761],["thread",752],["thread",134773],["thread",48878],["thread",115795],["thread",51733],["thread",119365],["thread",84361],["thread",89628],["thread",106148],["thread",78279],["thread",11161],["thread",122164],["thread",117827],["thread",83293],["thread",52762],["thread",24320],["thread",74869],["thread",120541],["thread",85296],["thread",12164],["thread",51459],["thread",51894],["thread",52749],["thread",99029],["thread",79620],["thread",83325],["thread",119953],["thread",17514],["thread",96760],["thread",11246],["thread",29548],["thread",79383],["thread",116543],["thread",39656],["thread",61813],["thread",91261],["thread",11323],["thread",100414],["thread",127388],["thread",68019],["thread",99980],["thread",1874],["thread",38791],["thread",83243],["thread",129104],["thread",23887],["thread",63277],["thread",51370],["thread",11786],["thread",115527],["thread",80600],["thread",83573],["thread",37128],["thread",84466],["thread",117485],["thread",79804],["thread",59831],["thread",33463],["thread",76067],["thread",2699],["thread",114320],["thread",69853],["thread",10516],["thread",80961],["thread",41131],["thread",78263],["thread",99770],["thread",46026],["thread",80289],["thread",97337],["thread",75907],["thread",110527],["thread",129824],["thread",52745],["thread",52751],["thread",110242],["thread",27594],["thread",96429],["thread",58159],["thread",121576],["thread",81067],["thread",38898],["thread",76803],["thread",78149],["thread",79280],["thread",17320],["thread",618],["thread",78928],["thread",15961],["thread",36930],["thread",80294],["thread",55734],["thread",60913],["thread",74970],["thread",37100],["thread",35734],["thread",80487],["thread",101629],["thread",92233],["thread",29000],["thread",12343],["thread",59582],["thread",76958],["thread",27339],["thread",36532],["thread",8288],["thread",89721],["thread",78123],["thread",117848],["thread",78498],["thread",125291],["thread",96516],["thread",56444],["thread",102191],["thread",75081],["thread",12569],["thread",89482],["thread",61034],["thread",51141],["thread",79909],["thread",11818],["thread",100961],["thread",78229],["thread",44298],["thread",66370],["thread",76662],["thread",88387],["thread",52757],["thread",84278],["thread",44182],["thread",95656],["thread",95456],["thread",86442],["thread",41340],["thread",12060],["thread",52307],["thread",114608],["thread",52670],["thread",87147],["thread",82444],["thread",380],["thread",120522],["thread",95826],["thread",36144],["thread",11332],["thread",72551],["thread",36921],["thread",1195],["thread",12562],["thread",82318],["thread",127961],["thread",72562],["thread",105859],["thread",36920],["thread",105942],["thread",83527],["thread",82976],["thread",52744],["thread",94044],["thread",77462],["thread",95792],["thread",78573],["thread",77946],["thread",46151],["thread",129376],["thread",12654],["thread",762],["thread",123350],["thread",50014],["thread",94720],["thread",79151],["thread",1735],["thread",78493],["thread",83333],["thread",43236],["thread",1430],["thread",71079],["thread",12571],["thread",101162],["thread",79296],["thread",80323],["thread",110530],["thread",124541],["thread",80877],["thread",1122],["thread",7481],["thread",43381],["thread",95530],["thread",119087],["thread",93996],["thread",83768],["thread",97185],["thread",119705],["thread",89922],["thread",89466],["thread",23143],["thread",73777],["thread",78580],["thread",115314],["thread",95946],["thread",51676],["thread",51243],["thread",78698],["thread",87444],["thread",80233],["thread",68257],["thread",36008],["thread",52747],["thread",62509],["thread",60025],["thread",33467],["thread",7170],["thread",78675],["thread",84087],["thread",104326],["thread",29555],["thread",99526],["thread",117490],["thread",130919],["thread",81079],["thread",120427],["thread",123249],["thread",95716],["thread",85580],["thread",74357],["thread",82418],["thread",337],["thread",104498],["thread",127471],["thread",50920],["thread",131289],["thread",95861],["thread",77005],["thread",79873],["thread",16945]]
Run Time: 0.005381
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |