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 (86757, 83508, 51212, 115013, 43018, 117524, 96255, 69908, 86587, 112500, 96436, 92289, 134475, 69903, 42479, 86526, 123284, 118689, 100881, 125967, 89939, 116097, 103851, 85359, 122453, 69115, 105308, 95446, 118816, 122474, 114708, 117970, 69976, 131448, 70163, 110912, 106549, 131772, 113123, 133873, 78359, 109100, 68464, 2361, 130647, 15906, 80293, 124315, 113044, 94978, 79605, 134221, 81157, 120929, 124039, 135744, 74342, 113230, 109354, 30592, 73340, 110913, 34414, 113043, 35610, 33371, 10434, 68723, 133037, 15381, 131575, 96193, 108875, 68782, 126451, 1959, 122550, 38434, 70631, 124621, 117491, 110421, 118221, 34381, 66302, 122080, 136820, 120244, 72044, 113039, 119943, 123252, 121605, 110338, 119447, 68734, 63050, 130949, 83451, 96258, 123156, 14488, 68505, 109867, 7780, 117756, 90506, 118927, 121467, 117719, 118014, 123905, 123158, 68830, 122786, 110151, 119735, 6153, 122817, 38446, 70818, 109368, 74863, 121955, 104948, 58686, 123543, 123718, 127540, 42469, 67891, 131190, 117816, 23533, 126030, 133140, 120606, 109331, 124580, 84423, 60809, 58994, 110339, 30802, 126024, 64004, 123227, 124302, 122728, 69564, 120862, 113307, 68038, 96214, 121728, 30607, 85954, 6057, 117545, 46291, 122319, 12659, 70650, 68544, 131621, 125777, 126144, 109054, 123766, 61882, 123630, 92315, 136606, 119076, 112828, 117087, 126448, 66861, 103190, 57999, 65068, 103961, 56771, 113271, 117510, 96988, 117621, 108674, 85361, 71359, 131294, 67557, 106123, 103016, 125186, 109707, 106635, 10032, 22864, 115374, 62820, 56912, 72040, 118407, 117909, 73710, 69226, 33351, 108313, 117504, 34020, 122209, 86153, 120999, 121913, 71358, 126527, 69175, 72771, 116445, 111072, 117627, 116476, 117682, 98926, 120958, 122186, 122324, 105337, 21349, 109579, 121406, 113871, 112146, 122661, 95897, 121150, 117440, 1133, 90513, 135020, 39036, 79508, 135021, 75604, 134325, 68733, 87500, 110506, 94118, 88965, 81568, 126455, 115325, 130732, 68481, 92822, 68965, 81817, 124459, 69983, 71660, 34531, 136775, 73877, 72095, 126066, 90626, 77401, 123039, 44384, 113437, 121900, 126092, 119498, 136328, 101833, 83841, 104455, 119402, 75549, 68843, 123153, 43327, 42497, 131573, 86758, 49911, 121918, 96161, 92725, 115301, 132015, 117576, 30965, 122177, 123196, 111288, 117453, 60982)
Run Time: 0.012222
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: 641, 0, 1714100677, 1714104277, [["thread",86757],["thread",83508],["thread",51212],["thread",115013],["thread",43018],["thread",117524],["thread",96255],["thread",69908],["thread",86587],["thread",112500],["thread",96436],["thread",92289],["thread",134475],["thread",69903],["thread",42479],["thread",86526],["thread",123284],["thread",118689],["thread",100881],["thread",125967],["thread",89939],["thread",116097],["thread",103851],["thread",85359],["thread",122453],["thread",69115],["thread",105308],["thread",95446],["thread",118816],["thread",122474],["thread",114708],["thread",117970],["thread",69976],["thread",131448],["thread",70163],["thread",110912],["thread",106549],["thread",131772],["thread",113123],["thread",133873],["thread",78359],["thread",109100],["thread",68464],["thread",2361],["thread",130647],["thread",15906],["thread",80293],["thread",124315],["thread",113044],["thread",94978],["thread",79605],["thread",134221],["thread",81157],["thread",120929],["thread",124039],["thread",135744],["thread",74342],["thread",113230],["thread",109354],["thread",30592],["thread",73340],["thread",110913],["thread",34414],["thread",113043],["thread",35610],["thread",33371],["thread",10434],["thread",68723],["thread",133037],["thread",15381],["thread",131575],["thread",96193],["thread",108875],["thread",68782],["thread",126451],["thread",1959],["thread",122550],["thread",38434],["thread",70631],["thread",124621],["thread",117491],["thread",110421],["thread",118221],["thread",34381],["thread",66302],["thread",122080],["thread",136820],["thread",120244],["thread",72044],["thread",113039],["thread",119943],["thread",123252],["thread",121605],["thread",110338],["thread",119447],["thread",68734],["thread",63050],["thread",130949],["thread",83451],["thread",96258],["thread",123156],["thread",14488],["thread",68505],["thread",109867],["thread",7780],["thread",117756],["thread",90506],["thread",118927],["thread",121467],["thread",117719],["thread",118014],["thread",123905],["thread",123158],["thread",68830],["thread",122786],["thread",110151],["thread",119735],["thread",6153],["thread",122817],["thread",38446],["thread",70818],["thread",109368],["thread",74863],["thread",121955],["thread",104948],["thread",58686],["thread",123543],["thread",123718],["thread",127540],["thread",42469],["thread",67891],["thread",131190],["thread",117816],["thread",23533],["thread",126030],["thread",133140],["thread",120606],["thread",109331],["thread",124580],["thread",84423],["thread",60809],["thread",58994],["thread",110339],["thread",30802],["thread",126024],["thread",64004],["thread",123227],["thread",124302],["thread",122728],["thread",69564],["thread",120862],["thread",113307],["thread",68038],["thread",96214],["thread",121728],["thread",30607],["thread",85954],["thread",6057],["thread",117545],["thread",46291],["thread",122319],["thread",12659],["thread",70650],["thread",68544],["thread",131621],["thread",125777],["thread",126144],["thread",109054],["thread",123766],["thread",61882],["thread",123630],["thread",92315],["thread",136606],["thread",119076],["thread",112828],["thread",117087],["thread",126448],["thread",66861],["thread",103190],["thread",57999],["thread",65068],["thread",103961],["thread",56771],["thread",113271],["thread",117510],["thread",96988],["thread",117621],["thread",108674],["thread",85361],["thread",71359],["thread",131294],["thread",67557],["thread",106123],["thread",103016],["thread",125186],["thread",109707],["thread",106635],["thread",10032],["thread",22864],["thread",115374],["thread",62820],["thread",56912],["thread",72040],["thread",118407],["thread",117909],["thread",73710],["thread",69226],["thread",33351],["thread",108313],["thread",117504],["thread",34020],["thread",122209],["thread",86153],["thread",120999],["thread",121913],["thread",71358],["thread",126527],["thread",69175],["thread",72771],["thread",116445],["thread",111072],["thread",117627],["thread",116476],["thread",117682],["thread",98926],["thread",120958],["thread",122186],["thread",122324],["thread",105337],["thread",21349],["thread",109579],["thread",121406],["thread",113871],["thread",112146],["thread",122661],["thread",95897],["thread",121150],["thread",117440],["thread",1133],["thread",90513],["thread",135020],["thread",39036],["thread",79508],["thread",135021],["thread",75604],["thread",134325],["thread",68733],["thread",87500],["thread",110506],["thread",94118],["thread",88965],["thread",81568],["thread",126455],["thread",115325],["thread",130732],["thread",68481],["thread",92822],["thread",68965],["thread",81817],["thread",124459],["thread",69983],["thread",71660],["thread",34531],["thread",136775],["thread",73877],["thread",72095],["thread",126066],["thread",90626],["thread",77401],["thread",123039],["thread",44384],["thread",113437],["thread",121900],["thread",126092],["thread",119498],["thread",136328],["thread",101833],["thread",83841],["thread",104455],["thread",119402],["thread",75549],["thread",68843],["thread",123153],["thread",43327],["thread",42497],["thread",131573],["thread",86758],["thread",49911],["thread",121918],["thread",96161],["thread",92725],["thread",115301],["thread",132015],["thread",117576],["thread",30965],["thread",122177],["thread",123196],["thread",111288],["thread",117453],["thread",60982]]
Run Time: 0.002119
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.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |