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 (44857, 84700, 114494, 51383, 78595, 100175, 77468, 61372, 80249, 82796, 131810, 72878, 99008, 84416, 70521, 81689, 65452, 100267, 75586, 117523, 117306, 89489, 87421, 93759, 98453, 92901, 64900, 70896, 121482, 57652, 122378, 51767, 55282, 57742, 83199, 80435, 65759, 76356, 83870, 90215, 83030, 89522, 71082, 83120, 44650, 113125, 87324, 123105, 83319, 92576, 99525, 56391, 76081, 91737, 49777, 114537, 74592, 100311, 67513, 73862, 101661, 64953, 78624, 98401, 77166, 25039, 114439, 99834, 60425, 77452, 101760, 89645, 131230, 59123, 103199, 62448, 46067, 85248, 52685, 72089, 54593, 63456, 61024, 68440, 114460, 54030, 80787, 46530, 103179, 65577, 58140, 90682, 57073, 67343, 64618, 98943, 69711, 94414, 51407, 64507, 80831, 73846, 24082, 76825, 67198, 81073, 65561, 67509, 91826, 84203, 51726, 95439, 90384, 126477, 47860, 74055, 51414, 2143, 63004, 54823, 103751, 117608, 87786, 101903, 101035, 54081, 98434, 86848, 63310, 84537, 90718, 77555, 62931, 52422, 102762, 99461, 38643, 98567, 56017, 64092, 102462, 49436, 71495, 94912, 74895, 96274, 98397, 77484, 83407, 60860, 63644, 65711, 99158, 15152, 45328, 82525, 129420, 82615, 56393, 85738, 71652, 64793, 83425, 66356, 124769, 67479, 101851, 59356, 63587, 61641, 62184, 74583, 132495, 99238, 70871, 76353, 122362, 81564, 72296, 79837, 81567, 80438, 51567, 56330, 68064, 64699, 114373, 117517, 114506, 72237, 88062, 99935, 64705, 89504, 119058, 102396, 134115, 72875, 55154, 114578, 101773, 57013, 53964, 134222, 85251, 97648, 2227, 77473, 60207, 83044, 63192, 81334, 53478, 98273, 70556, 48404, 97577, 98884, 99209, 99302, 96343, 49432, 44460, 127278, 60233, 39377, 88916, 98967, 112317, 114474, 46719, 79526, 84170, 61836, 84539, 60145, 91752, 98113, 72295, 135106, 20418, 98915, 129059, 63193, 74859, 107632, 52206, 88268, 63737, 94221, 54285, 81807, 77617, 106988, 125375, 79324, 90188, 61879, 80905, 52284, 97996, 86012, 76244, 93302, 60189, 70448, 87353, 119196, 91342, 70611, 65438, 89780, 97323, 64978, 127153, 99611, 103136, 21643, 48468, 59293, 76300, 79874, 82766, 110217, 20454, 70713, 127279, 100582, 100125, 122318, 59316, 131428, 81492, 45023, 73975, 97407, 66402, 107785, 55281, 59945)
Run Time: 0.027117
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: 11962, 0, 1714137253, 1714140853, [["thread",44857],["thread",84700],["thread",114494],["thread",51383],["thread",78595],["thread",100175],["thread",77468],["thread",61372],["thread",80249],["thread",82796],["thread",131810],["thread",72878],["thread",99008],["thread",84416],["thread",70521],["thread",81689],["thread",65452],["thread",100267],["thread",75586],["thread",117523],["thread",117306],["thread",89489],["thread",87421],["thread",93759],["thread",98453],["thread",92901],["thread",64900],["thread",70896],["thread",121482],["thread",57652],["thread",122378],["thread",51767],["thread",55282],["thread",57742],["thread",83199],["thread",80435],["thread",65759],["thread",76356],["thread",83870],["thread",90215],["thread",83030],["thread",89522],["thread",71082],["thread",83120],["thread",44650],["thread",113125],["thread",87324],["thread",123105],["thread",83319],["thread",92576],["thread",99525],["thread",56391],["thread",76081],["thread",91737],["thread",49777],["thread",114537],["thread",74592],["thread",100311],["thread",67513],["thread",73862],["thread",101661],["thread",64953],["thread",78624],["thread",98401],["thread",77166],["thread",25039],["thread",114439],["thread",99834],["thread",60425],["thread",77452],["thread",101760],["thread",89645],["thread",131230],["thread",59123],["thread",103199],["thread",62448],["thread",46067],["thread",85248],["thread",52685],["thread",72089],["thread",54593],["thread",63456],["thread",61024],["thread",68440],["thread",114460],["thread",54030],["thread",80787],["thread",46530],["thread",103179],["thread",65577],["thread",58140],["thread",90682],["thread",57073],["thread",67343],["thread",64618],["thread",98943],["thread",69711],["thread",94414],["thread",51407],["thread",64507],["thread",80831],["thread",73846],["thread",24082],["thread",76825],["thread",67198],["thread",81073],["thread",65561],["thread",67509],["thread",91826],["thread",84203],["thread",51726],["thread",95439],["thread",90384],["thread",126477],["thread",47860],["thread",74055],["thread",51414],["thread",2143],["thread",63004],["thread",54823],["thread",103751],["thread",117608],["thread",87786],["thread",101903],["thread",101035],["thread",54081],["thread",98434],["thread",86848],["thread",63310],["thread",84537],["thread",90718],["thread",77555],["thread",62931],["thread",52422],["thread",102762],["thread",99461],["thread",38643],["thread",98567],["thread",56017],["thread",64092],["thread",102462],["thread",49436],["thread",71495],["thread",94912],["thread",74895],["thread",96274],["thread",98397],["thread",77484],["thread",83407],["thread",60860],["thread",63644],["thread",65711],["thread",99158],["thread",15152],["thread",45328],["thread",82525],["thread",129420],["thread",82615],["thread",56393],["thread",85738],["thread",71652],["thread",64793],["thread",83425],["thread",66356],["thread",124769],["thread",67479],["thread",101851],["thread",59356],["thread",63587],["thread",61641],["thread",62184],["thread",74583],["thread",132495],["thread",99238],["thread",70871],["thread",76353],["thread",122362],["thread",81564],["thread",72296],["thread",79837],["thread",81567],["thread",80438],["thread",51567],["thread",56330],["thread",68064],["thread",64699],["thread",114373],["thread",117517],["thread",114506],["thread",72237],["thread",88062],["thread",99935],["thread",64705],["thread",89504],["thread",119058],["thread",102396],["thread",134115],["thread",72875],["thread",55154],["thread",114578],["thread",101773],["thread",57013],["thread",53964],["thread",134222],["thread",85251],["thread",97648],["thread",2227],["thread",77473],["thread",60207],["thread",83044],["thread",63192],["thread",81334],["thread",53478],["thread",98273],["thread",70556],["thread",48404],["thread",97577],["thread",98884],["thread",99209],["thread",99302],["thread",96343],["thread",49432],["thread",44460],["thread",127278],["thread",60233],["thread",39377],["thread",88916],["thread",98967],["thread",112317],["thread",114474],["thread",46719],["thread",79526],["thread",84170],["thread",61836],["thread",84539],["thread",60145],["thread",91752],["thread",98113],["thread",72295],["thread",135106],["thread",20418],["thread",98915],["thread",129059],["thread",63193],["thread",74859],["thread",107632],["thread",52206],["thread",88268],["thread",63737],["thread",94221],["thread",54285],["thread",81807],["thread",77617],["thread",106988],["thread",125375],["thread",79324],["thread",90188],["thread",61879],["thread",80905],["thread",52284],["thread",97996],["thread",86012],["thread",76244],["thread",93302],["thread",60189],["thread",70448],["thread",87353],["thread",119196],["thread",91342],["thread",70611],["thread",65438],["thread",89780],["thread",97323],["thread",64978],["thread",127153],["thread",99611],["thread",103136],["thread",21643],["thread",48468],["thread",59293],["thread",76300],["thread",79874],["thread",82766],["thread",110217],["thread",20454],["thread",70713],["thread",127279],["thread",100582],["thread",100125],["thread",122318],["thread",59316],["thread",131428],["thread",81492],["thread",45023],["thread",73975],["thread",97407],["thread",66402],["thread",107785],["thread",55281],["thread",59945]]
Run Time: 0.001776
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.000087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |