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 (5099, 131013, 129088, 40287, 125079, 135493, 99983, 109202, 122701, 98655, 43605, 75961, 126103, 118361, 132292, 120953, 128493, 107264, 5148, 133052, 111642, 133982, 132132, 108339, 108166, 31303, 60909, 117831, 103569, 129557, 129515, 81601, 129941, 31054, 119287, 119432, 122464, 130165, 878, 2125, 103177, 25836, 44654, 108266, 123048, 136436, 124230, 130733, 114964, 132736, 114309, 1435, 42307, 134631, 127701, 115181, 130197, 102243, 131662, 114369, 125818, 121490, 127356, 106657, 114689, 114290, 123353, 124279, 122269, 129381, 1542, 2059, 134057, 134776, 116589, 38504, 48437, 130576, 124766, 1290, 134073, 121534, 107423, 1291, 131552, 1293, 130777, 1019, 64944, 135119, 124585, 43018, 126772, 130736, 134968, 124402, 62572, 125991, 120770, 132767, 132470, 130815, 128300, 785, 124283, 23950, 134113, 1289, 125115, 123901, 532, 122332, 122958, 1213, 1018, 1216, 666, 135790, 134836, 67219, 135528, 104649, 126086, 130201, 108406, 118599, 117551, 7336, 119284, 117991, 98659, 125815, 1284, 1020, 90485, 108087, 61382, 134257, 46746, 89842, 130200, 31126, 130249, 1214, 126382, 77631, 110394, 119285, 124706, 64208, 126724, 125188, 130580, 130468, 7650, 1989, 114873, 107377, 125454, 62976, 111013, 2000, 119241, 131277, 45880, 85075, 118321, 62862, 1011, 132822, 128421, 124555, 114611, 129607, 30609, 129084, 118185, 1541, 846, 105366, 122463, 106555, 102737, 133267, 130424, 127637, 125189, 31298, 116162, 57037, 127565, 128054, 125764, 135362, 130202, 130198, 122496, 888, 118955, 136265, 119471, 31953, 131661, 119789, 103530, 107408, 121633, 124228, 105796, 1292, 104027, 100987, 130101, 1954, 46995, 124575, 127902, 115413, 107666, 64627, 889, 47715, 123296, 134384, 115597, 62874, 105057, 704, 115836, 132604, 130176, 124325, 2393, 133806, 121619, 129085, 132919, 131354, 109602, 131314, 119474, 116636, 44881, 128609, 121620, 115147, 118488, 1953, 124041, 130981, 130208, 35290, 120814, 88425, 35289, 125957, 107492, 124784, 2058, 131461, 2061, 19451, 135561, 18614, 118220, 121200, 62434, 106505, 129858, 108068, 109582, 107204, 132620, 118589, 104459, 130389, 115109, 66323, 128276, 130986, 42469, 121183, 130427, 1983, 130035, 1295, 64647, 108205, 108489, 1285, 114177, 121274, 30652, 61881, 134150, 130281, 124782, 63672, 126834, 105439)
Run Time: 0.005693
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: 444, 0, 1713556325, 1713559925, [["thread",5099],["thread",131013],["thread",129088],["thread",40287],["thread",125079],["thread",135493],["thread",99983],["thread",109202],["thread",122701],["thread",98655],["thread",43605],["thread",75961],["thread",126103],["thread",118361],["thread",132292],["thread",120953],["thread",128493],["thread",107264],["thread",5148],["thread",133052],["thread",111642],["thread",133982],["thread",132132],["thread",108339],["thread",108166],["thread",31303],["thread",60909],["thread",117831],["thread",103569],["thread",129557],["thread",129515],["thread",81601],["thread",129941],["thread",31054],["thread",119287],["thread",119432],["thread",122464],["thread",130165],["thread",878],["thread",2125],["thread",103177],["thread",25836],["thread",44654],["thread",108266],["thread",123048],["thread",136436],["thread",124230],["thread",130733],["thread",114964],["thread",132736],["thread",114309],["thread",1435],["thread",42307],["thread",134631],["thread",127701],["thread",115181],["thread",130197],["thread",102243],["thread",131662],["thread",114369],["thread",125818],["thread",121490],["thread",127356],["thread",106657],["thread",114689],["thread",114290],["thread",123353],["thread",124279],["thread",122269],["thread",129381],["thread",1542],["thread",2059],["thread",134057],["thread",134776],["thread",116589],["thread",38504],["thread",48437],["thread",130576],["thread",124766],["thread",1290],["thread",134073],["thread",121534],["thread",107423],["thread",1291],["thread",131552],["thread",1293],["thread",130777],["thread",1019],["thread",64944],["thread",135119],["thread",124585],["thread",43018],["thread",126772],["thread",130736],["thread",134968],["thread",124402],["thread",62572],["thread",125991],["thread",120770],["thread",132767],["thread",132470],["thread",130815],["thread",128300],["thread",785],["thread",124283],["thread",23950],["thread",134113],["thread",1289],["thread",125115],["thread",123901],["thread",532],["thread",122332],["thread",122958],["thread",1213],["thread",1018],["thread",1216],["thread",666],["thread",135790],["thread",134836],["thread",67219],["thread",135528],["thread",104649],["thread",126086],["thread",130201],["thread",108406],["thread",118599],["thread",117551],["thread",7336],["thread",119284],["thread",117991],["thread",98659],["thread",125815],["thread",1284],["thread",1020],["thread",90485],["thread",108087],["thread",61382],["thread",134257],["thread",46746],["thread",89842],["thread",130200],["thread",31126],["thread",130249],["thread",1214],["thread",126382],["thread",77631],["thread",110394],["thread",119285],["thread",124706],["thread",64208],["thread",126724],["thread",125188],["thread",130580],["thread",130468],["thread",7650],["thread",1989],["thread",114873],["thread",107377],["thread",125454],["thread",62976],["thread",111013],["thread",2000],["thread",119241],["thread",131277],["thread",45880],["thread",85075],["thread",118321],["thread",62862],["thread",1011],["thread",132822],["thread",128421],["thread",124555],["thread",114611],["thread",129607],["thread",30609],["thread",129084],["thread",118185],["thread",1541],["thread",846],["thread",105366],["thread",122463],["thread",106555],["thread",102737],["thread",133267],["thread",130424],["thread",127637],["thread",125189],["thread",31298],["thread",116162],["thread",57037],["thread",127565],["thread",128054],["thread",125764],["thread",135362],["thread",130202],["thread",130198],["thread",122496],["thread",888],["thread",118955],["thread",136265],["thread",119471],["thread",31953],["thread",131661],["thread",119789],["thread",103530],["thread",107408],["thread",121633],["thread",124228],["thread",105796],["thread",1292],["thread",104027],["thread",100987],["thread",130101],["thread",1954],["thread",46995],["thread",124575],["thread",127902],["thread",115413],["thread",107666],["thread",64627],["thread",889],["thread",47715],["thread",123296],["thread",134384],["thread",115597],["thread",62874],["thread",105057],["thread",704],["thread",115836],["thread",132604],["thread",130176],["thread",124325],["thread",2393],["thread",133806],["thread",121619],["thread",129085],["thread",132919],["thread",131354],["thread",109602],["thread",131314],["thread",119474],["thread",116636],["thread",44881],["thread",128609],["thread",121620],["thread",115147],["thread",118488],["thread",1953],["thread",124041],["thread",130981],["thread",130208],["thread",35290],["thread",120814],["thread",88425],["thread",35289],["thread",125957],["thread",107492],["thread",124784],["thread",2058],["thread",131461],["thread",2061],["thread",19451],["thread",135561],["thread",18614],["thread",118220],["thread",121200],["thread",62434],["thread",106505],["thread",129858],["thread",108068],["thread",109582],["thread",107204],["thread",132620],["thread",118589],["thread",104459],["thread",130389],["thread",115109],["thread",66323],["thread",128276],["thread",130986],["thread",42469],["thread",121183],["thread",130427],["thread",1983],["thread",130035],["thread",1295],["thread",64647],["thread",108205],["thread",108489],["thread",1285],["thread",114177],["thread",121274],["thread",30652],["thread",61881],["thread",134150],["thread",130281],["thread",124782],["thread",63672],["thread",126834],["thread",105439]]
Run Time: 0.002804
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.000079
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |