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 (88067, 128846, 123127, 117242, 123559, 119903, 104274, 107413, 129214, 91704, 114466, 115358, 115976, 122890, 123705, 103535, 114566, 123698, 117067, 113981, 86389, 129041, 115564, 120539, 119185, 87693, 122591, 119889, 78976, 115083, 116999, 104214, 110405, 120852, 83843, 115534, 90926, 87560, 119625, 103985, 129488, 122035, 116920, 115977, 122818, 75703, 114253, 110439, 83167, 122043, 84232, 98202, 98034, 105095, 114336, 115850, 83965, 123700, 122062, 121852, 89562, 121196, 78812, 122337, 89935, 91119, 97019, 76015, 121102, 117956, 117726, 114513, 117835, 130720, 68694, 120919, 119064, 114139, 119866, 119664, 122737, 117409, 117872, 129205, 99528, 93066, 83955, 92155, 67342, 122579, 114687, 98938, 123069, 107144, 119186, 115714, 116726, 104881, 97706, 116851, 118467, 122787, 105508, 69452, 123081, 106231, 109845, 83963, 119901, 130191, 115208, 117320, 115851, 121879, 121822, 121125, 77809, 114511, 103717, 124063, 78565, 111239, 95952, 89552, 104082, 106436, 114137, 122859, 121969, 75429, 122995, 122089, 119059, 98018, 123908, 103660, 117992, 102336, 121135, 124858, 97921, 122276, 122047, 114465, 129932, 120435, 119561, 103367, 93334, 120080, 99781, 130327, 132285, 69618, 110931, 124834, 50407, 130554, 102725, 117334, 106557, 62355, 111563, 117850, 107070, 96648, 77843, 119299, 116766, 114910, 123511, 84300, 92662, 115883, 81377, 121415, 120413, 131708, 122156, 121606, 114399, 109062, 109531, 70520, 136262, 117501, 117707, 103931, 115639, 120041, 93120, 128745, 122959, 101984, 83548, 93873, 78751, 88521, 1753, 120219, 105562, 113429, 114317, 120460, 117391, 118590, 114904, 123193, 90919, 84052, 117873, 117537, 123378, 71767, 115433, 104486, 119228, 118006, 74303, 89598, 121968, 128872, 105251, 119239, 485, 77838, 85908, 113492, 103872, 124814, 72585, 102588, 121930, 121868, 114294, 97632, 96764, 124805, 83536, 117876, 76860, 69340, 87532, 119717, 122130, 68468, 114362, 113830, 116877, 115537, 116774, 126158, 122123, 115760, 77910, 117277, 125109, 115473, 136383, 132742, 100242, 129199, 119417, 90814, 117403, 122163, 95386, 100236, 113972, 114421, 76136, 102120, 119651, 90027, 117435, 98019, 107656, 69316, 106284, 104574, 117922, 122320, 120271)
Run Time: 0.041789
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 283 | 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: 18686, 0, 1715146624, 1715150224, [["thread",88067],["thread",128846],["thread",123127],["thread",117242],["thread",123559],["thread",119903],["thread",104274],["thread",107413],["thread",129214],["thread",91704],["thread",114466],["thread",115358],["thread",115976],["thread",122890],["thread",123705],["thread",103535],["thread",114566],["thread",123698],["thread",117067],["thread",113981],["thread",86389],["thread",129041],["thread",115564],["thread",120539],["thread",119185],["thread",87693],["thread",122591],["thread",119889],["thread",78976],["thread",115083],["thread",116999],["thread",104214],["thread",110405],["thread",120852],["thread",83843],["thread",115534],["thread",90926],["thread",87560],["thread",119625],["thread",103985],["thread",129488],["thread",122035],["thread",116920],["thread",115977],["thread",122818],["thread",75703],["thread",114253],["thread",110439],["thread",83167],["thread",122043],["thread",84232],["thread",98202],["thread",98034],["thread",105095],["thread",114336],["thread",115850],["thread",83965],["thread",123700],["thread",122062],["thread",121852],["thread",89562],["thread",121196],["thread",78812],["thread",122337],["thread",89935],["thread",91119],["thread",97019],["thread",76015],["thread",121102],["thread",117956],["thread",117726],["thread",114513],["thread",117835],["thread",130720],["thread",68694],["thread",120919],["thread",119064],["thread",114139],["thread",119866],["thread",119664],["thread",122737],["thread",117409],["thread",117872],["thread",129205],["thread",99528],["thread",93066],["thread",83955],["thread",92155],["thread",67342],["thread",122579],["thread",114687],["thread",98938],["thread",123069],["thread",107144],["thread",119186],["thread",115714],["thread",116726],["thread",104881],["thread",97706],["thread",116851],["thread",118467],["thread",122787],["thread",105508],["thread",69452],["thread",123081],["thread",106231],["thread",109845],["thread",83963],["thread",119901],["thread",130191],["thread",115208],["thread",117320],["thread",115851],["thread",121879],["thread",121822],["thread",121125],["thread",77809],["thread",114511],["thread",103717],["thread",124063],["thread",78565],["thread",111239],["thread",95952],["thread",89552],["thread",104082],["thread",106436],["thread",114137],["thread",122859],["thread",121969],["thread",75429],["thread",122995],["thread",122089],["thread",119059],["thread",98018],["thread",123908],["thread",103660],["thread",117992],["thread",102336],["thread",121135],["thread",124858],["thread",97921],["thread",122276],["thread",122047],["thread",114465],["thread",129932],["thread",120435],["thread",119561],["thread",103367],["thread",93334],["thread",120080],["thread",99781],["thread",130327],["thread",132285],["thread",69618],["thread",110931],["thread",124834],["thread",50407],["thread",130554],["thread",102725],["thread",117334],["thread",106557],["thread",62355],["thread",111563],["thread",117850],["thread",107070],["thread",96648],["thread",77843],["thread",119299],["thread",116766],["thread",114910],["thread",123511],["thread",84300],["thread",92662],["thread",115883],["thread",81377],["thread",121415],["thread",120413],["thread",131708],["thread",122156],["thread",121606],["thread",114399],["thread",109062],["thread",109531],["thread",70520],["thread",136262],["thread",117501],["thread",117707],["thread",103931],["thread",115639],["thread",120041],["thread",93120],["thread",128745],["thread",122959],["thread",101984],["thread",83548],["thread",93873],["thread",78751],["thread",88521],["thread",1753],["thread",120219],["thread",105562],["thread",113429],["thread",114317],["thread",120460],["thread",117391],["thread",118590],["thread",114904],["thread",123193],["thread",90919],["thread",84052],["thread",117873],["thread",117537],["thread",123378],["thread",71767],["thread",115433],["thread",104486],["thread",119228],["thread",118006],["thread",74303],["thread",89598],["thread",121968],["thread",128872],["thread",105251],["thread",119239],["thread",485],["thread",77838],["thread",85908],["thread",113492],["thread",103872],["thread",124814],["thread",72585],["thread",102588],["thread",121930],["thread",121868],["thread",114294],["thread",97632],["thread",96764],["thread",124805],["thread",83536],["thread",117876],["thread",76860],["thread",69340],["thread",87532],["thread",119717],["thread",122130],["thread",68468],["thread",114362],["thread",113830],["thread",116877],["thread",115537],["thread",116774],["thread",126158],["thread",122123],["thread",115760],["thread",77910],["thread",117277],["thread",125109],["thread",115473],["thread",136383],["thread",132742],["thread",100242],["thread",129199],["thread",119417],["thread",90814],["thread",117403],["thread",122163],["thread",95386],["thread",100236],["thread",113972],["thread",114421],["thread",76136],["thread",102120],["thread",119651],["thread",90027],["thread",117435],["thread",98019],["thread",107656],["thread",69316],["thread",106284],["thread",104574],["thread",117922],["thread",122320],["thread",120271]]
Run Time: 0.001484
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.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |