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 (64593, 20719, 97080, 47005, 81782, 49961, 86140, 77527, 61677, 71420, 93603, 62278, 57208, 95051, 48300, 86552, 74019, 47156, 86148, 47786, 36071, 50033, 73759, 82072, 77301, 96155, 82246, 50439, 81066, 74610, 119577, 47363, 44891, 84070, 57265, 78042, 47278, 56047, 98384, 60012, 71958, 80398, 52022, 66902, 46243, 49760, 78160, 48344, 71961, 71494, 79766, 72688, 104208, 122065, 113808, 85441, 126057, 77056, 96707, 82668, 71466, 49654, 71017, 115137, 77810, 61731, 44369, 70854, 91985, 74408, 84368, 47924, 81359, 77507, 58252, 37566, 75155, 96069, 68101, 78602, 78838, 49962, 129928, 97668, 58450, 125521, 59141, 44413, 59134, 40107, 47157, 58253, 78392, 59140, 79328, 96574, 51660, 51133, 44806, 51658, 73125, 74409, 47740, 47783, 98913, 76411, 71998, 48311, 77295, 420, 46408, 82647, 103944, 46190, 72009, 46668, 83613, 82259, 69970, 46186, 57655, 63712, 10216, 44474, 71421, 46415, 82840, 73830, 58339, 25920, 47912, 88201, 119565, 48449, 80683, 52027, 76513, 75472, 83913, 19709, 74249, 51540, 88592, 45219, 70029, 109302, 77504, 58710, 8181, 85108, 58119, 72027, 80155, 74570, 47361, 73551, 79336, 47218, 48451, 61203, 59142, 77840, 51663, 48286, 104207, 52542, 80037, 78989, 46184, 88377, 57999, 47359, 136170, 67960, 47788, 47008, 86385, 122064, 86814, 83011, 60760, 84485, 78977, 44804, 73470, 102640, 86497, 86162, 43842, 40105, 47540, 84639, 85793, 53015, 2293, 26267, 51270, 590, 51661, 104380, 37740, 76118, 77070, 104071, 111131, 73724, 102321, 89321, 57143, 82252, 47006, 44557, 77723, 83704, 76396, 83211, 48051, 74251, 47290, 81192, 124459, 73822, 71483, 72238, 86160, 71813, 115115, 77499, 126780, 70493, 73080, 46995, 84024, 70975, 10214, 46192, 76100, 72944, 80754, 19659, 132213, 73553, 76465, 73917, 47784, 47312, 82758, 77971, 47964, 45053, 69398, 122777, 45056, 77803, 48554, 104306, 77361, 81027, 47568, 79476, 46410, 47224, 86147, 74892, 131710, 44441, 76995, 86464, 47039, 47274, 46813, 47235, 58503, 389, 58336, 94759, 104165, 80842, 78115, 101849, 58173, 48215, 122817, 81069, 73761, 87145, 86262, 71618, 60238, 73912, 9889, 48511, 76057, 104261, 47362, 74890, 111184, 80517, 83730, 77701)
Run Time: 0.020446
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: 6, 0, 1714133650, 1714137250, [["thread",64593],["thread",20719],["thread",97080],["thread",47005],["thread",81782],["thread",49961],["thread",86140],["thread",77527],["thread",61677],["thread",71420],["thread",93603],["thread",62278],["thread",57208],["thread",95051],["thread",48300],["thread",86552],["thread",74019],["thread",47156],["thread",86148],["thread",47786],["thread",36071],["thread",50033],["thread",73759],["thread",82072],["thread",77301],["thread",96155],["thread",82246],["thread",50439],["thread",81066],["thread",74610],["thread",119577],["thread",47363],["thread",44891],["thread",84070],["thread",57265],["thread",78042],["thread",47278],["thread",56047],["thread",98384],["thread",60012],["thread",71958],["thread",80398],["thread",52022],["thread",66902],["thread",46243],["thread",49760],["thread",78160],["thread",48344],["thread",71961],["thread",71494],["thread",79766],["thread",72688],["thread",104208],["thread",122065],["thread",113808],["thread",85441],["thread",126057],["thread",77056],["thread",96707],["thread",82668],["thread",71466],["thread",49654],["thread",71017],["thread",115137],["thread",77810],["thread",61731],["thread",44369],["thread",70854],["thread",91985],["thread",74408],["thread",84368],["thread",47924],["thread",81359],["thread",77507],["thread",58252],["thread",37566],["thread",75155],["thread",96069],["thread",68101],["thread",78602],["thread",78838],["thread",49962],["thread",129928],["thread",97668],["thread",58450],["thread",125521],["thread",59141],["thread",44413],["thread",59134],["thread",40107],["thread",47157],["thread",58253],["thread",78392],["thread",59140],["thread",79328],["thread",96574],["thread",51660],["thread",51133],["thread",44806],["thread",51658],["thread",73125],["thread",74409],["thread",47740],["thread",47783],["thread",98913],["thread",76411],["thread",71998],["thread",48311],["thread",77295],["thread",420],["thread",46408],["thread",82647],["thread",103944],["thread",46190],["thread",72009],["thread",46668],["thread",83613],["thread",82259],["thread",69970],["thread",46186],["thread",57655],["thread",63712],["thread",10216],["thread",44474],["thread",71421],["thread",46415],["thread",82840],["thread",73830],["thread",58339],["thread",25920],["thread",47912],["thread",88201],["thread",119565],["thread",48449],["thread",80683],["thread",52027],["thread",76513],["thread",75472],["thread",83913],["thread",19709],["thread",74249],["thread",51540],["thread",88592],["thread",45219],["thread",70029],["thread",109302],["thread",77504],["thread",58710],["thread",8181],["thread",85108],["thread",58119],["thread",72027],["thread",80155],["thread",74570],["thread",47361],["thread",73551],["thread",79336],["thread",47218],["thread",48451],["thread",61203],["thread",59142],["thread",77840],["thread",51663],["thread",48286],["thread",104207],["thread",52542],["thread",80037],["thread",78989],["thread",46184],["thread",88377],["thread",57999],["thread",47359],["thread",136170],["thread",67960],["thread",47788],["thread",47008],["thread",86385],["thread",122064],["thread",86814],["thread",83011],["thread",60760],["thread",84485],["thread",78977],["thread",44804],["thread",73470],["thread",102640],["thread",86497],["thread",86162],["thread",43842],["thread",40105],["thread",47540],["thread",84639],["thread",85793],["thread",53015],["thread",2293],["thread",26267],["thread",51270],["thread",590],["thread",51661],["thread",104380],["thread",37740],["thread",76118],["thread",77070],["thread",104071],["thread",111131],["thread",73724],["thread",102321],["thread",89321],["thread",57143],["thread",82252],["thread",47006],["thread",44557],["thread",77723],["thread",83704],["thread",76396],["thread",83211],["thread",48051],["thread",74251],["thread",47290],["thread",81192],["thread",124459],["thread",73822],["thread",71483],["thread",72238],["thread",86160],["thread",71813],["thread",115115],["thread",77499],["thread",126780],["thread",70493],["thread",73080],["thread",46995],["thread",84024],["thread",70975],["thread",10214],["thread",46192],["thread",76100],["thread",72944],["thread",80754],["thread",19659],["thread",132213],["thread",73553],["thread",76465],["thread",73917],["thread",47784],["thread",47312],["thread",82758],["thread",77971],["thread",47964],["thread",45053],["thread",69398],["thread",122777],["thread",45056],["thread",77803],["thread",48554],["thread",104306],["thread",77361],["thread",81027],["thread",47568],["thread",79476],["thread",46410],["thread",47224],["thread",86147],["thread",74892],["thread",131710],["thread",44441],["thread",76995],["thread",86464],["thread",47039],["thread",47274],["thread",46813],["thread",47235],["thread",58503],["thread",389],["thread",58336],["thread",94759],["thread",104165],["thread",80842],["thread",78115],["thread",101849],["thread",58173],["thread",48215],["thread",122817],["thread",81069],["thread",73761],["thread",87145],["thread",86262],["thread",71618],["thread",60238],["thread",73912],["thread",9889],["thread",48511],["thread",76057],["thread",104261],["thread",47362],["thread",74890],["thread",111184],["thread",80517],["thread",83730],["thread",77701]]
Run Time: 0.003320
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 |