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 (107429, 75637, 69365, 75051, 82706, 1190, 49860, 99188, 135030, 77805, 114207, 12164, 80902, 81667, 127946, 100518, 75160, 85220, 75270, 78252, 50285, 92902, 100456, 77549, 75906, 95636, 84394, 25606, 93732, 81998, 74512, 78234, 76686, 120470, 95315, 81953, 81584, 87624, 648, 105719, 97174, 93520, 103525, 100622, 74162, 100249, 78232, 121905, 81447, 77372, 120218, 89281, 75409, 109233, 78529, 119862, 98154, 78401, 109408, 44011, 98936, 94467, 81409, 74975, 134740, 61790, 107198, 75336, 473, 76499, 79981, 115349, 97143, 16651, 128791, 78479, 32502, 95983, 89333, 103681, 78607, 81981, 51207, 77640, 76230, 78138, 11221, 92069, 66955, 99040, 81806, 77144, 103300, 10516, 121616, 67398, 66742, 105921, 128837, 75071, 98623, 81600, 95530, 79272, 116866, 82725, 82022, 108954, 75707, 77018, 85212, 83789, 81951, 74542, 95873, 121912, 136055, 80635, 79879, 75331, 76256, 80885, 123732, 896, 91427, 79274, 116380, 53235, 108955, 81464, 51087, 83739, 77630, 127726, 109042, 50385, 83411, 79269, 81103, 104428, 105265, 90735, 43835, 93251, 107523, 101719, 115292, 76259, 78600, 608, 75266, 1224, 1164, 44464, 81664, 116501, 90414, 44511, 79261, 86838, 904, 79564, 63753, 119887, 791, 78658, 32108, 79296, 50054, 78411, 44589, 74312, 121063, 95451, 120320, 12569, 78559, 134713, 38696, 114846, 1885, 81805, 93738, 82070, 75323, 50467, 110239, 1884, 12972, 97009, 83848, 12571, 88271, 81829, 95309, 104498, 81393, 95090, 117199, 111481, 74307, 49816, 81294, 79291, 44597, 11332, 119929, 75897, 80633, 98978, 79270, 75790, 83664, 78866, 93468, 78673, 82023, 102481, 45914, 78583, 121374, 111721, 97619, 127470, 78717, 60946, 88174, 51109, 83675, 108896, 72839, 123495, 128610, 79068, 72302, 78318, 123882, 1265, 80152, 77839, 94531, 66720, 92090, 76507, 74969, 119986, 1883, 76813, 75760, 74835, 84911, 112411, 65088, 100547, 78030, 76671, 115779, 74866, 79876, 75306, 101093, 82135, 75653, 89378, 578, 121584, 50713, 108638, 80053, 127080, 74817, 82761, 88419, 74437, 112521, 79529, 760, 104094, 77019, 81588, 76158, 121538, 129107, 81432, 12654, 68834, 109491, 81055, 85060, 676, 121814, 113176, 79576, 109748, 25849, 115604, 125671, 87632, 80537, 79911)
Run Time: 0.917792
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: 61, 0, 1715919397, 1715922997, [["thread",107429],["thread",75637],["thread",69365],["thread",75051],["thread",82706],["thread",1190],["thread",49860],["thread",99188],["thread",135030],["thread",77805],["thread",114207],["thread",12164],["thread",80902],["thread",81667],["thread",127946],["thread",100518],["thread",75160],["thread",85220],["thread",75270],["thread",78252],["thread",50285],["thread",92902],["thread",100456],["thread",77549],["thread",75906],["thread",95636],["thread",84394],["thread",25606],["thread",93732],["thread",81998],["thread",74512],["thread",78234],["thread",76686],["thread",120470],["thread",95315],["thread",81953],["thread",81584],["thread",87624],["thread",648],["thread",105719],["thread",97174],["thread",93520],["thread",103525],["thread",100622],["thread",74162],["thread",100249],["thread",78232],["thread",121905],["thread",81447],["thread",77372],["thread",120218],["thread",89281],["thread",75409],["thread",109233],["thread",78529],["thread",119862],["thread",98154],["thread",78401],["thread",109408],["thread",44011],["thread",98936],["thread",94467],["thread",81409],["thread",74975],["thread",134740],["thread",61790],["thread",107198],["thread",75336],["thread",473],["thread",76499],["thread",79981],["thread",115349],["thread",97143],["thread",16651],["thread",128791],["thread",78479],["thread",32502],["thread",95983],["thread",89333],["thread",103681],["thread",78607],["thread",81981],["thread",51207],["thread",77640],["thread",76230],["thread",78138],["thread",11221],["thread",92069],["thread",66955],["thread",99040],["thread",81806],["thread",77144],["thread",103300],["thread",10516],["thread",121616],["thread",67398],["thread",66742],["thread",105921],["thread",128837],["thread",75071],["thread",98623],["thread",81600],["thread",95530],["thread",79272],["thread",116866],["thread",82725],["thread",82022],["thread",108954],["thread",75707],["thread",77018],["thread",85212],["thread",83789],["thread",81951],["thread",74542],["thread",95873],["thread",121912],["thread",136055],["thread",80635],["thread",79879],["thread",75331],["thread",76256],["thread",80885],["thread",123732],["thread",896],["thread",91427],["thread",79274],["thread",116380],["thread",53235],["thread",108955],["thread",81464],["thread",51087],["thread",83739],["thread",77630],["thread",127726],["thread",109042],["thread",50385],["thread",83411],["thread",79269],["thread",81103],["thread",104428],["thread",105265],["thread",90735],["thread",43835],["thread",93251],["thread",107523],["thread",101719],["thread",115292],["thread",76259],["thread",78600],["thread",608],["thread",75266],["thread",1224],["thread",1164],["thread",44464],["thread",81664],["thread",116501],["thread",90414],["thread",44511],["thread",79261],["thread",86838],["thread",904],["thread",79564],["thread",63753],["thread",119887],["thread",791],["thread",78658],["thread",32108],["thread",79296],["thread",50054],["thread",78411],["thread",44589],["thread",74312],["thread",121063],["thread",95451],["thread",120320],["thread",12569],["thread",78559],["thread",134713],["thread",38696],["thread",114846],["thread",1885],["thread",81805],["thread",93738],["thread",82070],["thread",75323],["thread",50467],["thread",110239],["thread",1884],["thread",12972],["thread",97009],["thread",83848],["thread",12571],["thread",88271],["thread",81829],["thread",95309],["thread",104498],["thread",81393],["thread",95090],["thread",117199],["thread",111481],["thread",74307],["thread",49816],["thread",81294],["thread",79291],["thread",44597],["thread",11332],["thread",119929],["thread",75897],["thread",80633],["thread",98978],["thread",79270],["thread",75790],["thread",83664],["thread",78866],["thread",93468],["thread",78673],["thread",82023],["thread",102481],["thread",45914],["thread",78583],["thread",121374],["thread",111721],["thread",97619],["thread",127470],["thread",78717],["thread",60946],["thread",88174],["thread",51109],["thread",83675],["thread",108896],["thread",72839],["thread",123495],["thread",128610],["thread",79068],["thread",72302],["thread",78318],["thread",123882],["thread",1265],["thread",80152],["thread",77839],["thread",94531],["thread",66720],["thread",92090],["thread",76507],["thread",74969],["thread",119986],["thread",1883],["thread",76813],["thread",75760],["thread",74835],["thread",84911],["thread",112411],["thread",65088],["thread",100547],["thread",78030],["thread",76671],["thread",115779],["thread",74866],["thread",79876],["thread",75306],["thread",101093],["thread",82135],["thread",75653],["thread",89378],["thread",578],["thread",121584],["thread",50713],["thread",108638],["thread",80053],["thread",127080],["thread",74817],["thread",82761],["thread",88419],["thread",74437],["thread",112521],["thread",79529],["thread",760],["thread",104094],["thread",77019],["thread",81588],["thread",76158],["thread",121538],["thread",129107],["thread",81432],["thread",12654],["thread",68834],["thread",109491],["thread",81055],["thread",85060],["thread",676],["thread",121814],["thread",113176],["thread",79576],["thread",109748],["thread",25849],["thread",115604],["thread",125671],["thread",87632],["thread",80537],["thread",79911]]
Run Time: 0.286584
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.000134
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |