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 (131581, 125267, 132122, 131722, 69202, 26724, 132624, 126859, 99889, 129911, 133480, 125099, 133490, 131117, 126977, 128565, 121539, 125292, 126642, 131356, 133776, 77332, 132271, 129975, 130700, 132546, 72771, 110353, 123844, 130787, 135366, 132046, 130496, 130429, 134543, 133875, 135996, 124515, 133115, 132571, 83746, 133307, 134595, 123542, 133479, 133146, 132680, 95187, 134200, 133204, 136197, 127616, 123292, 106902, 136191, 132665, 134581, 132219, 117711, 99774, 126854, 112400, 112370, 134320, 129411, 129818, 132038, 70272, 130475, 132572, 66664, 83124, 134204, 131727, 135989, 114043, 135843, 132335, 132037, 63952, 135828, 132332, 129417, 136217, 130782, 130696, 129413, 133344, 136173, 129528, 125293, 130181, 133060, 131017, 130727, 135260, 134321, 133160, 132212, 126021, 132474, 134904, 132770, 134092, 133916, 94363, 102555, 124988, 132475, 132035, 126796, 129415, 133746, 110851, 133974, 82774, 103636, 112638, 132393, 132357, 131311, 129761, 110426, 73045, 130900, 115596, 130432, 133707, 124014, 132039, 130426, 134097, 123540, 133987, 116085, 134016, 134085, 124514, 109268, 130196, 133127, 135322, 125227, 114090, 73304, 128377, 133476, 132461, 132064, 110677, 122873, 73090, 132443, 134902, 132645, 135898, 133273, 133811, 127221, 133610, 127859, 133194, 132351, 133477, 129414, 123773, 131758, 94418, 116061, 114076, 123294, 133010, 131252, 132047, 129003, 133056, 130034, 116470, 63871, 124285, 113396, 126104, 121785, 135496, 124263, 131383, 123918, 133977, 133615, 112396, 122501, 133739, 122964, 129550, 131309, 128000, 136757, 134903, 130698, 130474, 136445, 113794, 95188, 135993, 116342, 136450, 129233, 136744, 131793, 129713, 95839, 123513, 132574, 135179, 133416, 17810, 131393, 130859, 133894, 133308, 133474, 124578, 76774, 130430, 93966, 133614, 113850, 124072, 134385, 130476, 132650, 136052, 114468, 132394, 134244, 129412, 133228, 127999, 133743, 112637, 127929, 129597, 95669, 131399, 132476, 129334, 136047, 132034, 116511, 133688, 133729, 133153, 126154, 132547, 130324, 103715, 128267, 132036, 135819, 38088, 133156, 129137, 133689, 132089, 132573, 133812, 63513, 123641, 136442, 132600, 134580, 111948, 126953, 129288, 128292, 133125, 124382, 129945, 94361, 117615, 68418, 94252, 131799, 123815, 131396, 133943, 127511, 130188, 133740, 134351, 131725, 132582, 134091, 132467, 66694, 132648, 72691, 134059, 133742, 126641)
Run Time: 0.005201
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: 3007, 0, 1713870309, 1713873909, [["thread",131581],["thread",125267],["thread",132122],["thread",131722],["thread",69202],["thread",26724],["thread",132624],["thread",126859],["thread",99889],["thread",129911],["thread",133480],["thread",125099],["thread",133490],["thread",131117],["thread",126977],["thread",128565],["thread",121539],["thread",125292],["thread",126642],["thread",131356],["thread",133776],["thread",77332],["thread",132271],["thread",129975],["thread",130700],["thread",132546],["thread",72771],["thread",110353],["thread",123844],["thread",130787],["thread",135366],["thread",132046],["thread",130496],["thread",130429],["thread",134543],["thread",133875],["thread",135996],["thread",124515],["thread",133115],["thread",132571],["thread",83746],["thread",133307],["thread",134595],["thread",123542],["thread",133479],["thread",133146],["thread",132680],["thread",95187],["thread",134200],["thread",133204],["thread",136197],["thread",127616],["thread",123292],["thread",106902],["thread",136191],["thread",132665],["thread",134581],["thread",132219],["thread",117711],["thread",99774],["thread",126854],["thread",112400],["thread",112370],["thread",134320],["thread",129411],["thread",129818],["thread",132038],["thread",70272],["thread",130475],["thread",132572],["thread",66664],["thread",83124],["thread",134204],["thread",131727],["thread",135989],["thread",114043],["thread",135843],["thread",132335],["thread",132037],["thread",63952],["thread",135828],["thread",132332],["thread",129417],["thread",136217],["thread",130782],["thread",130696],["thread",129413],["thread",133344],["thread",136173],["thread",129528],["thread",125293],["thread",130181],["thread",133060],["thread",131017],["thread",130727],["thread",135260],["thread",134321],["thread",133160],["thread",132212],["thread",126021],["thread",132474],["thread",134904],["thread",132770],["thread",134092],["thread",133916],["thread",94363],["thread",102555],["thread",124988],["thread",132475],["thread",132035],["thread",126796],["thread",129415],["thread",133746],["thread",110851],["thread",133974],["thread",82774],["thread",103636],["thread",112638],["thread",132393],["thread",132357],["thread",131311],["thread",129761],["thread",110426],["thread",73045],["thread",130900],["thread",115596],["thread",130432],["thread",133707],["thread",124014],["thread",132039],["thread",130426],["thread",134097],["thread",123540],["thread",133987],["thread",116085],["thread",134016],["thread",134085],["thread",124514],["thread",109268],["thread",130196],["thread",133127],["thread",135322],["thread",125227],["thread",114090],["thread",73304],["thread",128377],["thread",133476],["thread",132461],["thread",132064],["thread",110677],["thread",122873],["thread",73090],["thread",132443],["thread",134902],["thread",132645],["thread",135898],["thread",133273],["thread",133811],["thread",127221],["thread",133610],["thread",127859],["thread",133194],["thread",132351],["thread",133477],["thread",129414],["thread",123773],["thread",131758],["thread",94418],["thread",116061],["thread",114076],["thread",123294],["thread",133010],["thread",131252],["thread",132047],["thread",129003],["thread",133056],["thread",130034],["thread",116470],["thread",63871],["thread",124285],["thread",113396],["thread",126104],["thread",121785],["thread",135496],["thread",124263],["thread",131383],["thread",123918],["thread",133977],["thread",133615],["thread",112396],["thread",122501],["thread",133739],["thread",122964],["thread",129550],["thread",131309],["thread",128000],["thread",136757],["thread",134903],["thread",130698],["thread",130474],["thread",136445],["thread",113794],["thread",95188],["thread",135993],["thread",116342],["thread",136450],["thread",129233],["thread",136744],["thread",131793],["thread",129713],["thread",95839],["thread",123513],["thread",132574],["thread",135179],["thread",133416],["thread",17810],["thread",131393],["thread",130859],["thread",133894],["thread",133308],["thread",133474],["thread",124578],["thread",76774],["thread",130430],["thread",93966],["thread",133614],["thread",113850],["thread",124072],["thread",134385],["thread",130476],["thread",132650],["thread",136052],["thread",114468],["thread",132394],["thread",134244],["thread",129412],["thread",133228],["thread",127999],["thread",133743],["thread",112637],["thread",127929],["thread",129597],["thread",95669],["thread",131399],["thread",132476],["thread",129334],["thread",136047],["thread",132034],["thread",116511],["thread",133688],["thread",133729],["thread",133153],["thread",126154],["thread",132547],["thread",130324],["thread",103715],["thread",128267],["thread",132036],["thread",135819],["thread",38088],["thread",133156],["thread",129137],["thread",133689],["thread",132089],["thread",132573],["thread",133812],["thread",63513],["thread",123641],["thread",136442],["thread",132600],["thread",134580],["thread",111948],["thread",126953],["thread",129288],["thread",128292],["thread",133125],["thread",124382],["thread",129945],["thread",94361],["thread",117615],["thread",68418],["thread",94252],["thread",131799],["thread",123815],["thread",131396],["thread",133943],["thread",127511],["thread",130188],["thread",133740],["thread",134351],["thread",131725],["thread",132582],["thread",134091],["thread",132467],["thread",66694],["thread",132648],["thread",72691],["thread",134059],["thread",133742],["thread",126641]]
Run Time: 0.012205
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |