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 (95244, 95093, 127426, 92713, 107091, 95522, 99841, 119477, 74551, 66394, 87169, 71425, 94053, 68405, 84300, 99839, 135056, 102022, 71411, 89203, 132529, 94976, 104616, 72777, 65594, 62127, 90191, 135527, 97195, 77253, 88764, 93987, 88451, 93044, 57015, 67405, 115591, 85840, 116482, 102605, 135061, 65036, 70837, 84232, 66729, 64976, 89691, 134651, 88938, 90364, 91678, 95833, 82118, 110179, 102056, 134270, 109489, 115460, 124745, 130377, 107898, 50476, 66756, 95687, 116243, 73711, 126434, 91385, 128001, 80209, 120510, 109949, 77255, 95565, 133830, 124091, 135030, 106551, 114979, 57448, 125355, 95736, 71020, 119571, 101165, 122863, 88413, 123317, 109422, 96058, 94369, 85510, 101758, 72302, 109982, 88772, 109067, 107343, 69265, 72461, 130852, 89632, 127122, 74462, 113261, 118020, 123293, 99449, 72874, 91106, 96243, 114882, 104877, 77252, 71713, 102796, 64939, 130938, 92349, 119597, 133609, 76025, 110574, 88906, 123623, 71412, 135065, 95850, 107896, 69962, 109391, 85852, 88652, 68715, 119145, 101885, 93714, 73476, 126158, 129991, 122416, 88163, 106620, 117913, 125571, 66755, 118730, 108531, 135032, 78718, 64988, 89061, 45320, 116544, 100321, 83693, 68615, 99541, 89585, 135806, 88492, 90076, 122812, 100684, 117240, 132920, 64344, 100819, 25327, 90997, 66731, 74933, 69249, 132423, 74319, 126970, 95485, 107930, 106171, 133447, 64938, 100585, 115727, 80412, 92674, 125659, 111521, 108554, 103872, 72681, 98663, 99952, 116584, 90021, 74932, 118699, 89698, 80213, 66732, 85689, 102015, 107894, 88761, 77897, 135048, 87693, 112381, 99838, 73422, 102281, 129993, 95947, 126076, 126157, 72594, 55983, 80307, 108971, 90138, 85591, 108598, 127958, 68716, 79248, 47028, 135627, 105472, 101444, 74233, 94967, 89251, 130449, 85687, 73329, 91909, 89244, 108897, 95123, 116916, 95795, 71594, 76824, 84559, 110126, 96860, 122792, 106266, 112777, 117670, 66433, 100780, 122458, 91899, 123069, 106553, 45394, 122372, 99687, 119291, 74835, 94273, 135153, 75371, 114720, 101810, 127965, 106761, 100745, 119369, 101672, 91565, 74930, 112019, 120925, 134524, 99951, 99502, 89703, 122134, 134915, 94710, 121538, 84877, 127942, 109758, 77630, 131514, 118346, 76875, 110000, 71707, 113188, 125168, 77694, 117962, 116516, 97402, 134231, 91607, 115626)
Run Time: 0.021451
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: 9835, 0, 1714061023, 1714064623, [["thread",95244],["thread",95093],["thread",127426],["thread",92713],["thread",107091],["thread",95522],["thread",99841],["thread",119477],["thread",74551],["thread",66394],["thread",87169],["thread",71425],["thread",94053],["thread",68405],["thread",84300],["thread",99839],["thread",135056],["thread",102022],["thread",71411],["thread",89203],["thread",132529],["thread",94976],["thread",104616],["thread",72777],["thread",65594],["thread",62127],["thread",90191],["thread",135527],["thread",97195],["thread",77253],["thread",88764],["thread",93987],["thread",88451],["thread",93044],["thread",57015],["thread",67405],["thread",115591],["thread",85840],["thread",116482],["thread",102605],["thread",135061],["thread",65036],["thread",70837],["thread",84232],["thread",66729],["thread",64976],["thread",89691],["thread",134651],["thread",88938],["thread",90364],["thread",91678],["thread",95833],["thread",82118],["thread",110179],["thread",102056],["thread",134270],["thread",109489],["thread",115460],["thread",124745],["thread",130377],["thread",107898],["thread",50476],["thread",66756],["thread",95687],["thread",116243],["thread",73711],["thread",126434],["thread",91385],["thread",128001],["thread",80209],["thread",120510],["thread",109949],["thread",77255],["thread",95565],["thread",133830],["thread",124091],["thread",135030],["thread",106551],["thread",114979],["thread",57448],["thread",125355],["thread",95736],["thread",71020],["thread",119571],["thread",101165],["thread",122863],["thread",88413],["thread",123317],["thread",109422],["thread",96058],["thread",94369],["thread",85510],["thread",101758],["thread",72302],["thread",109982],["thread",88772],["thread",109067],["thread",107343],["thread",69265],["thread",72461],["thread",130852],["thread",89632],["thread",127122],["thread",74462],["thread",113261],["thread",118020],["thread",123293],["thread",99449],["thread",72874],["thread",91106],["thread",96243],["thread",114882],["thread",104877],["thread",77252],["thread",71713],["thread",102796],["thread",64939],["thread",130938],["thread",92349],["thread",119597],["thread",133609],["thread",76025],["thread",110574],["thread",88906],["thread",123623],["thread",71412],["thread",135065],["thread",95850],["thread",107896],["thread",69962],["thread",109391],["thread",85852],["thread",88652],["thread",68715],["thread",119145],["thread",101885],["thread",93714],["thread",73476],["thread",126158],["thread",129991],["thread",122416],["thread",88163],["thread",106620],["thread",117913],["thread",125571],["thread",66755],["thread",118730],["thread",108531],["thread",135032],["thread",78718],["thread",64988],["thread",89061],["thread",45320],["thread",116544],["thread",100321],["thread",83693],["thread",68615],["thread",99541],["thread",89585],["thread",135806],["thread",88492],["thread",90076],["thread",122812],["thread",100684],["thread",117240],["thread",132920],["thread",64344],["thread",100819],["thread",25327],["thread",90997],["thread",66731],["thread",74933],["thread",69249],["thread",132423],["thread",74319],["thread",126970],["thread",95485],["thread",107930],["thread",106171],["thread",133447],["thread",64938],["thread",100585],["thread",115727],["thread",80412],["thread",92674],["thread",125659],["thread",111521],["thread",108554],["thread",103872],["thread",72681],["thread",98663],["thread",99952],["thread",116584],["thread",90021],["thread",74932],["thread",118699],["thread",89698],["thread",80213],["thread",66732],["thread",85689],["thread",102015],["thread",107894],["thread",88761],["thread",77897],["thread",135048],["thread",87693],["thread",112381],["thread",99838],["thread",73422],["thread",102281],["thread",129993],["thread",95947],["thread",126076],["thread",126157],["thread",72594],["thread",55983],["thread",80307],["thread",108971],["thread",90138],["thread",85591],["thread",108598],["thread",127958],["thread",68716],["thread",79248],["thread",47028],["thread",135627],["thread",105472],["thread",101444],["thread",74233],["thread",94967],["thread",89251],["thread",130449],["thread",85687],["thread",73329],["thread",91909],["thread",89244],["thread",108897],["thread",95123],["thread",116916],["thread",95795],["thread",71594],["thread",76824],["thread",84559],["thread",110126],["thread",96860],["thread",122792],["thread",106266],["thread",112777],["thread",117670],["thread",66433],["thread",100780],["thread",122458],["thread",91899],["thread",123069],["thread",106553],["thread",45394],["thread",122372],["thread",99687],["thread",119291],["thread",74835],["thread",94273],["thread",135153],["thread",75371],["thread",114720],["thread",101810],["thread",127965],["thread",106761],["thread",100745],["thread",119369],["thread",101672],["thread",91565],["thread",74930],["thread",112019],["thread",120925],["thread",134524],["thread",99951],["thread",99502],["thread",89703],["thread",122134],["thread",134915],["thread",94710],["thread",121538],["thread",84877],["thread",127942],["thread",109758],["thread",77630],["thread",131514],["thread",118346],["thread",76875],["thread",110000],["thread",71707],["thread",113188],["thread",125168],["thread",77694],["thread",117962],["thread",116516],["thread",97402],["thread",134231],["thread",91607],["thread",115626]]
Run Time: 0.001987
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 |