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 (44145, 44593, 80982, 83698, 556, 44389, 107523, 116584, 76055, 57815, 77576, 34453, 47153, 75551, 130770, 74961, 98712, 75465, 44431, 36034, 5635, 67425, 45097, 80934, 44533, 45653, 43806, 38695, 75325, 91641, 45297, 51839, 80961, 45712, 76739, 3392, 116713, 44290, 112486, 43701, 43871, 82742, 114061, 75795, 77029, 44885, 81806, 45334, 45819, 76268, 108638, 70192, 36391, 78519, 56854, 80926, 70069, 44618, 44665, 74775, 75755, 47703, 3098, 117483, 44566, 75310, 78421, 44302, 41181, 9504, 45396, 84179, 45650, 107198, 45110, 108954, 45366, 83042, 115604, 44328, 45207, 44646, 81282, 77143, 70847, 44425, 76422, 37266, 108986, 81837, 37576, 45070, 15119, 82145, 34533, 81408, 45817, 45534, 74211, 45670, 45007, 79631, 44843, 34747, 78741, 81343, 44596, 32799, 77021, 80289, 81393, 45641, 52958, 44598, 76815, 126240, 57394, 25781, 44291, 44698, 116760, 75612, 7034, 45317, 79173, 36767, 111616, 112411, 44192, 80211, 98978, 78139, 83739, 81337, 13934, 108948, 116873, 107649, 45313, 45788, 56591, 76664, 44579, 44319, 44467, 691, 44799, 44227, 78400, 74501, 51078, 81438, 44403, 77305, 45568, 79435, 77311, 79868, 44609, 78967, 76463, 45631, 80203, 75074, 37106, 81812, 44795, 83764, 44611, 78425, 78638, 117650, 75631, 11276, 37466, 67302, 45659, 43782, 44185, 75923, 74934, 45887, 44629, 83699, 81722, 9919, 109233, 80459, 44124, 16228, 78814, 45284, 44009, 44684, 45570, 83682, 38133, 80600, 82689, 113889, 2030, 80232, 81328, 77233, 78643, 45699, 57345, 45391, 97118, 75531, 108938, 43896, 46675, 78631, 45798, 78881, 109247, 36062, 44306, 45175, 82490, 78164, 75837, 75038, 113961, 37438, 76809, 12911, 45322, 46047, 111791, 44468, 45845, 76230, 43848, 81104, 76364, 81403, 45713, 81094, 45349, 76570, 82266, 2543, 21736, 44492, 76488, 115106, 2740, 44939, 83593, 78808, 43717, 116543, 35970, 74232, 45613, 76557, 74222, 44449, 44780, 44500, 78511, 44373, 82361, 44980, 76688, 45923, 45002, 44962, 81785, 38722, 107516, 44000, 81046, 35717, 79864, 50083, 42678, 35679, 34844, 80294, 78142, 78179, 44674, 76301, 81078, 83561, 77906, 80673, 44964, 43960, 78493, 56458, 45303, 3508, 77927, 108967, 71835, 36182)
Run Time: 0.011766
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: 465, 0, 1713528818, 1713532418, [["thread",44145],["thread",44593],["thread",80982],["thread",83698],["thread",556],["thread",44389],["thread",107523],["thread",116584],["thread",76055],["thread",57815],["thread",77576],["thread",34453],["thread",47153],["thread",75551],["thread",130770],["thread",74961],["thread",98712],["thread",75465],["thread",44431],["thread",36034],["thread",5635],["thread",67425],["thread",45097],["thread",80934],["thread",44533],["thread",45653],["thread",43806],["thread",38695],["thread",75325],["thread",91641],["thread",45297],["thread",51839],["thread",80961],["thread",45712],["thread",76739],["thread",3392],["thread",116713],["thread",44290],["thread",112486],["thread",43701],["thread",43871],["thread",82742],["thread",114061],["thread",75795],["thread",77029],["thread",44885],["thread",81806],["thread",45334],["thread",45819],["thread",76268],["thread",108638],["thread",70192],["thread",36391],["thread",78519],["thread",56854],["thread",80926],["thread",70069],["thread",44618],["thread",44665],["thread",74775],["thread",75755],["thread",47703],["thread",3098],["thread",117483],["thread",44566],["thread",75310],["thread",78421],["thread",44302],["thread",41181],["thread",9504],["thread",45396],["thread",84179],["thread",45650],["thread",107198],["thread",45110],["thread",108954],["thread",45366],["thread",83042],["thread",115604],["thread",44328],["thread",45207],["thread",44646],["thread",81282],["thread",77143],["thread",70847],["thread",44425],["thread",76422],["thread",37266],["thread",108986],["thread",81837],["thread",37576],["thread",45070],["thread",15119],["thread",82145],["thread",34533],["thread",81408],["thread",45817],["thread",45534],["thread",74211],["thread",45670],["thread",45007],["thread",79631],["thread",44843],["thread",34747],["thread",78741],["thread",81343],["thread",44596],["thread",32799],["thread",77021],["thread",80289],["thread",81393],["thread",45641],["thread",52958],["thread",44598],["thread",76815],["thread",126240],["thread",57394],["thread",25781],["thread",44291],["thread",44698],["thread",116760],["thread",75612],["thread",7034],["thread",45317],["thread",79173],["thread",36767],["thread",111616],["thread",112411],["thread",44192],["thread",80211],["thread",98978],["thread",78139],["thread",83739],["thread",81337],["thread",13934],["thread",108948],["thread",116873],["thread",107649],["thread",45313],["thread",45788],["thread",56591],["thread",76664],["thread",44579],["thread",44319],["thread",44467],["thread",691],["thread",44799],["thread",44227],["thread",78400],["thread",74501],["thread",51078],["thread",81438],["thread",44403],["thread",77305],["thread",45568],["thread",79435],["thread",77311],["thread",79868],["thread",44609],["thread",78967],["thread",76463],["thread",45631],["thread",80203],["thread",75074],["thread",37106],["thread",81812],["thread",44795],["thread",83764],["thread",44611],["thread",78425],["thread",78638],["thread",117650],["thread",75631],["thread",11276],["thread",37466],["thread",67302],["thread",45659],["thread",43782],["thread",44185],["thread",75923],["thread",74934],["thread",45887],["thread",44629],["thread",83699],["thread",81722],["thread",9919],["thread",109233],["thread",80459],["thread",44124],["thread",16228],["thread",78814],["thread",45284],["thread",44009],["thread",44684],["thread",45570],["thread",83682],["thread",38133],["thread",80600],["thread",82689],["thread",113889],["thread",2030],["thread",80232],["thread",81328],["thread",77233],["thread",78643],["thread",45699],["thread",57345],["thread",45391],["thread",97118],["thread",75531],["thread",108938],["thread",43896],["thread",46675],["thread",78631],["thread",45798],["thread",78881],["thread",109247],["thread",36062],["thread",44306],["thread",45175],["thread",82490],["thread",78164],["thread",75837],["thread",75038],["thread",113961],["thread",37438],["thread",76809],["thread",12911],["thread",45322],["thread",46047],["thread",111791],["thread",44468],["thread",45845],["thread",76230],["thread",43848],["thread",81104],["thread",76364],["thread",81403],["thread",45713],["thread",81094],["thread",45349],["thread",76570],["thread",82266],["thread",2543],["thread",21736],["thread",44492],["thread",76488],["thread",115106],["thread",2740],["thread",44939],["thread",83593],["thread",78808],["thread",43717],["thread",116543],["thread",35970],["thread",74232],["thread",45613],["thread",76557],["thread",74222],["thread",44449],["thread",44780],["thread",44500],["thread",78511],["thread",44373],["thread",82361],["thread",44980],["thread",76688],["thread",45923],["thread",45002],["thread",44962],["thread",81785],["thread",38722],["thread",107516],["thread",44000],["thread",81046],["thread",35717],["thread",79864],["thread",50083],["thread",42678],["thread",35679],["thread",34844],["thread",80294],["thread",78142],["thread",78179],["thread",44674],["thread",76301],["thread",81078],["thread",83561],["thread",77906],["thread",80673],["thread",44964],["thread",43960],["thread",78493],["thread",56458],["thread",45303],["thread",3508],["thread",77927],["thread",108967],["thread",71835],["thread",36182]]
Run Time: 0.001523
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |