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 (80791, 42619, 84768, 104657, 92690, 65860, 16823, 52128, 68861, 106185, 130370, 42613, 106087, 50671, 47129, 103742, 23672, 129915, 39306, 72629, 48370, 72865, 63405, 38426, 106575, 118289, 135668, 61078, 86020, 136424, 2672, 61919, 69049, 17873, 57652, 114516, 9512, 133147, 40937, 135487, 128446, 96925, 65290, 132195, 85590, 4835, 26239, 87490, 85683, 91946, 56523, 65788, 25018, 108235, 91102, 67829, 41162, 116041, 43222, 126048, 92406, 116328, 69466, 21624, 89195, 67252, 79348, 135688, 98784, 56363, 9001, 46982, 78467, 55237, 57073, 87547, 124348, 1608, 102386, 115923, 98029, 98301, 51383, 59247, 31811, 70902, 124734, 105779, 123975, 1325, 68756, 60495, 25141, 63336, 48122, 116330, 79241, 124682, 6535, 113127, 134779, 50313, 134610, 93007, 9119, 116067, 44595, 68096, 132692, 122546, 68342, 84240, 52667, 93121, 60233, 37001, 75052, 132176, 98114, 26999, 6193, 48455, 110320, 125746, 126345, 105883, 62770, 129247, 60888, 43500, 67185, 31913, 109985, 65718, 101369, 65521, 86189, 60504, 124761, 78182, 75112, 20513, 84981, 7491, 52330, 48567, 95470, 52721, 84425, 107412, 106141, 88757, 56180, 54194, 62358, 110436, 102755, 25904, 70994, 14856, 83917, 73058, 87799, 130114, 128310, 124254, 6204, 57102, 105331, 69630, 2218, 115970, 53517, 28563, 74349, 52697, 123955, 22157, 88603, 45966, 94653, 106921, 19229, 102434, 60594, 57108, 73301, 110361, 109485, 135000, 33728, 73492, 64971, 52760, 123051, 61676, 69402, 46538, 101440, 131487, 106152, 22315, 40228, 68801, 89504, 49495, 53397, 56034, 14640, 72296, 103561, 134545, 88311, 46748, 116932, 89675, 69478, 65632, 63838, 131016, 89152, 67273, 133407, 134147, 46420, 24322, 112088, 50534, 116225, 32705, 57849, 53735, 78032, 2079, 66465, 119977, 100840, 131027, 51407, 40972, 43391, 128771, 53601, 107001, 104859, 42086, 62334, 100339, 61305, 71382, 79675, 108670, 121925, 125217, 106006, 110808, 75778, 130839, 36668, 72601, 115227, 46399, 71201, 105428, 93428, 123948, 17396, 64151, 120552, 6675, 60293, 46550, 87973, 38128, 107469, 61407, 128856, 53400, 23601, 102672, 81919, 45162, 99015, 56359, 55754, 92202, 58118, 49686, 52618, 2617, 72398, 46342, 85781, 125304, 6656, 67149, 64505, 76669)
Run Time: 0.014589
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 298 | 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: 120, 0, 1715602075, 1715605675, [["tinhte_xentag_forum",75],["tinhte_xentag_forum",210],["thread",80791],["thread",42619],["thread",84768],["thread",104657],["thread",92690],["thread",65860],["thread",16823],["thread",52128],["thread",68861],["thread",106185],["thread",130370],["thread",42613],["thread",106087],["thread",50671],["thread",47129],["thread",103742],["thread",23672],["thread",129915],["thread",39306],["thread",72629],["thread",48370],["thread",72865],["thread",63405],["thread",38426],["thread",106575],["thread",118289],["thread",135668],["thread",61078],["thread",86020],["thread",136424],["thread",2672],["thread",61919],["thread",69049],["thread",17873],["thread",57652],["thread",114516],["thread",9512],["thread",133147],["thread",40937],["thread",135487],["thread",128446],["thread",96925],["thread",65290],["thread",132195],["thread",85590],["thread",4835],["thread",26239],["thread",87490],["thread",85683],["thread",91946],["thread",56523],["thread",65788],["thread",25018],["thread",108235],["thread",91102],["thread",67829],["thread",41162],["thread",116041],["thread",43222],["thread",126048],["thread",92406],["thread",116328],["thread",69466],["thread",21624],["thread",89195],["thread",67252],["thread",79348],["thread",135688],["thread",98784],["thread",56363],["thread",9001],["thread",46982],["thread",78467],["thread",55237],["thread",57073],["thread",87547],["thread",124348],["thread",1608],["thread",102386],["thread",115923],["thread",98029],["thread",98301],["thread",51383],["thread",59247],["thread",31811],["thread",70902],["thread",124734],["thread",105779],["thread",123975],["thread",1325],["thread",68756],["thread",60495],["thread",25141],["thread",63336],["thread",48122],["thread",116330],["thread",79241],["thread",124682],["thread",6535],["thread",113127],["thread",134779],["thread",50313],["thread",134610],["thread",93007],["thread",9119],["thread",116067],["thread",44595],["thread",68096],["thread",132692],["thread",122546],["thread",68342],["thread",84240],["thread",52667],["thread",93121],["thread",60233],["thread",37001],["thread",75052],["thread",132176],["thread",98114],["thread",26999],["thread",6193],["thread",48455],["thread",110320],["thread",125746],["thread",126345],["thread",105883],["thread",62770],["thread",129247],["thread",60888],["thread",43500],["thread",67185],["thread",31913],["thread",109985],["thread",65718],["thread",101369],["thread",65521],["thread",86189],["thread",60504],["thread",124761],["thread",78182],["thread",75112],["thread",20513],["thread",84981],["thread",7491],["thread",52330],["thread",48567],["thread",95470],["thread",52721],["thread",84425],["thread",107412],["thread",106141],["thread",88757],["thread",56180],["thread",54194],["thread",62358],["thread",110436],["thread",102755],["thread",25904],["thread",70994],["thread",14856],["thread",83917],["thread",73058],["thread",87799],["thread",130114],["thread",128310],["thread",124254],["thread",6204],["thread",57102],["thread",105331],["thread",69630],["thread",2218],["thread",115970],["thread",53517],["thread",28563],["thread",74349],["thread",52697],["thread",123955],["thread",22157],["thread",88603],["thread",45966],["thread",94653],["thread",106921],["thread",19229],["thread",102434],["thread",60594],["thread",57108],["thread",73301],["thread",110361],["thread",109485],["thread",135000],["thread",33728],["thread",73492],["thread",64971],["thread",52760],["thread",123051],["thread",61676],["thread",69402],["thread",46538],["thread",101440],["thread",131487],["thread",106152],["thread",22315],["thread",40228],["thread",68801],["thread",89504],["thread",49495],["thread",53397],["thread",56034],["thread",14640],["thread",72296],["thread",103561],["thread",134545],["thread",88311],["thread",46748],["thread",116932],["thread",89675],["thread",69478],["thread",65632],["thread",63838],["thread",131016],["thread",89152],["thread",67273],["thread",133407],["thread",134147],["thread",46420],["thread",24322],["thread",112088],["thread",50534],["thread",116225],["thread",32705],["thread",57849],["thread",53735],["thread",78032],["thread",2079],["thread",66465],["thread",119977],["thread",100840],["thread",131027],["thread",51407],["thread",40972],["thread",43391],["thread",128771],["thread",53601],["thread",107001],["thread",104859],["thread",42086],["thread",62334],["thread",100339],["thread",61305],["thread",71382],["thread",79675],["thread",108670],["thread",121925],["thread",125217],["thread",106006],["thread",110808],["thread",75778],["thread",130839],["thread",36668],["thread",72601],["thread",115227],["thread",46399],["thread",71201],["thread",105428],["thread",93428],["thread",123948],["thread",17396],["thread",64151],["thread",120552],["thread",6675],["thread",60293],["thread",46550],["thread",87973],["thread",38128],["thread",107469],["thread",61407],["thread",128856],["thread",53400],["thread",23601],["thread",102672],["thread",81919],["thread",45162],["thread",99015],["thread",56359],["thread",55754],["thread",92202],["thread",58118],["thread",49686],["thread",52618],["thread",2617],["thread",72398],["thread",46342],["thread",85781],["thread",125304],["thread",6656],["thread",67149],["thread",64505],["thread",76669]]
Run Time: 0.000896
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.000085
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |