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 (96330, 102141, 109390, 107141, 26131, 41180, 85505, 95438, 94709, 82666, 82028, 110793, 66440, 26999, 52512, 91529, 90497, 66838, 106955, 126842, 51535, 18386, 84298, 124477, 108403, 127227, 56623, 106933, 113876, 48713, 79884, 25341, 82027, 136424, 69972, 113785, 75334, 41839, 94825, 91937, 62740, 114303, 98190, 66969, 89606, 56781, 80242, 79608, 104072, 66940, 85029, 56040, 102619, 125486, 111316, 109047, 80194, 107873, 93086, 125844, 61564, 107324, 49580, 88741, 25581, 91190, 55823, 15311, 99530, 45942, 79841, 80349, 94217, 60290, 57664, 58194, 78175, 129050, 125375, 53746, 91327, 56087, 61572, 119325, 130128, 44299, 30988, 25239, 100611, 128257, 89234, 30921, 129074, 83497, 98533, 98532, 109055, 112814, 133686, 89941, 73153, 33728, 116742, 116513, 108395, 102773, 33950, 113145, 59084, 72296, 96640, 91457, 26250, 49856, 36397, 117617, 101380, 41066, 59032, 49814, 61599, 129053, 112669, 66147, 89085, 93361, 108453, 86794, 60492, 51625, 68953, 115504, 58636, 30374, 73931, 35898, 132053, 114472, 126004, 126224, 86323, 93568, 102197, 88490, 92635, 66353, 67277, 39468, 24474, 86012, 32174, 16442, 29371, 83836, 8506, 102414, 48244, 56827, 79770, 14640, 92690, 78608, 58936, 34753, 73690, 79883, 36857, 107696, 127664, 19710, 112049, 57718, 59790, 7982, 67242, 128208, 86015, 133248, 88925, 128422, 70896, 92333, 72651, 50404, 133483, 136452, 99033, 41128, 94786, 43463, 76508, 64587, 55359, 136350, 106145, 70455, 85778, 92439, 86520, 83096, 117503, 90486, 97767, 53833, 96562, 125276, 96406, 95258, 101192, 60888, 100991, 25402, 94662, 85368, 80880, 66375, 134942, 65492, 119533, 37447, 27727, 84071, 64856, 30542, 78599, 66951, 20550, 90216, 96950, 98280, 36349, 34006, 24682, 34708, 79211, 127482, 32971, 56107, 90245, 40437, 59916, 73215, 68578, 76423, 70005, 121888, 126178, 106824, 126847, 67306, 73733, 26489, 101753, 94869, 94704, 60329, 105533, 76706, 113693, 14316, 44159, 107150, 64540, 111726, 81874, 79924, 69335, 62764, 126029, 74031, 45220, 53165, 118325, 111691, 12080, 86602, 78920, 109038, 121982, 49444, 78682, 127028, 59791, 70546, 17419, 96401, 69833, 37543, 85741, 72438, 74525, 22727, 80149, 78603, 66148, 89871, 62716, 61567, 114553, 91311)
Run Time: 0.029843
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: 1360, 0, 1714026006, 1714029606, {"0":["thread",96330],"1":["thread",102141],"2":["thread",109390],"3":["thread",107141],"4":["thread",26131],"5":["thread",41180],"6":["thread",85505],"7":["thread",95438],"8":["thread",94709],"9":["thread",82666],"10":["thread",82028],"11":["thread",110793],"12":["thread",66440],"13":["thread",26999],"14":["thread",52512],"15":["thread",91529],"16":["thread",90497],"17":["thread",66838],"18":["thread",106955],"19":["thread",126842],"20":["thread",51535],"21":["thread",18386],"22":["thread",84298],"23":["thread",124477],"24":["thread",108403],"25":["thread",127227],"26":["thread",56623],"27":["thread",106933],"28":["thread",113876],"29":["thread",48713],"30":["thread",79884],"31":["thread",25341],"32":["thread",82027],"33":["thread",136424],"34":["thread",69972],"35":["thread",113785],"36":["thread",75334],"37":["thread",41839],"38":["thread",94825],"39":["thread",91937],"40":["thread",62740],"41":["thread",114303],"42":["thread",98190],"43":["thread",66969],"44":["thread",89606],"45":["thread",56781],"46":["thread",80242],"47":["thread",79608],"48":["thread",104072],"49":["thread",66940],"50":["thread",85029],"51":["thread",56040],"52":["thread",102619],"53":["thread",125486],"54":["thread",111316],"55":["thread",109047],"56":["thread",80194],"57":["thread",107873],"58":["thread",93086],"59":["thread",125844],"60":["thread",61564],"61":["thread",107324],"62":["thread",49580],"63":["thread",88741],"64":["thread",25581],"65":["thread",91190],"66":["thread",55823],"67":["thread",15311],"68":["thread",99530],"69":["thread",45942],"70":["thread",79841],"71":["thread",80349],"72":["thread",94217],"73":["thread",60290],"74":["thread",57664],"75":["thread",58194],"76":["thread",78175],"77":["thread",129050],"78":["thread",125375],"79":["thread",53746],"80":["thread",91327],"81":["thread",56087],"82":["thread",61572],"83":["thread",119325],"84":["thread",130128],"85":["thread",44299],"86":["thread",30988],"87":["thread",25239],"88":["thread",100611],"89":["thread",128257],"90":["thread",89234],"91":["thread",30921],"92":["thread",129074],"93":["thread",83497],"94":["thread",98533],"95":["thread",98532],"96":["thread",109055],"97":["thread",112814],"98":["thread",133686],"99":["thread",89941],"100":["thread",73153],"101":["thread",33728],"102":["thread",116742],"103":["thread",116513],"104":["thread",108395],"105":["thread",102773],"106":["thread",33950],"107":["thread",113145],"108":["thread",59084],"109":["thread",72296],"110":["thread",96640],"111":["thread",91457],"112":["thread",26250],"113":["thread",49856],"114":["thread",36397],"115":["thread",117617],"116":["thread",101380],"117":["thread",41066],"118":["thread",59032],"119":["thread",49814],"120":["thread",61599],"121":["thread",129053],"122":["thread",112669],"123":["thread",66147],"124":["thread",89085],"125":["thread",93361],"126":["thread",108453],"127":["thread",86794],"128":["thread",60492],"129":["thread",51625],"130":["thread",68953],"131":["thread",115504],"132":["thread",58636],"133":["thread",30374],"134":["thread",73931],"135":["thread",35898],"136":["thread",132053],"137":["thread",114472],"138":["thread",126004],"139":["thread",126224],"140":["thread",86323],"141":["thread",93568],"142":["thread",102197],"143":["thread",88490],"144":["thread",92635],"145":["thread",66353],"146":["thread",67277],"147":["thread",39468],"148":["thread",24474],"149":["thread",86012],"150":["thread",32174],"151":["thread",16442],"152":["thread",29371],"153":["thread",83836],"154":["thread",8506],"155":["thread",102414],"156":["thread",48244],"157":["thread",56827],"158":["thread",79770],"159":["thread",14640],"160":["thread",92690],"161":["thread",78608],"162":["thread",58936],"163":["thread",34753],"164":["thread",73690],"165":["thread",79883],"166":["thread",36857],"167":["thread",107696],"168":["thread",127664],"169":["thread",19710],"170":["thread",112049],"171":["thread",57718],"172":["thread",59790],"173":["thread",7982],"174":["thread",67242],"175":["thread",128208],"177":["thread",133248],"178":["thread",88925],"179":["thread",128422],"180":["thread",70896],"181":["thread",92333],"182":["thread",72651],"183":["thread",50404],"184":["thread",133483],"185":["thread",136452],"186":["thread",99033],"187":["thread",41128],"188":["thread",94786],"189":["thread",43463],"190":["thread",76508],"191":["thread",64587],"192":["thread",55359],"193":["thread",136350],"194":["thread",106145],"195":["thread",70455],"196":["thread",85778],"197":["thread",92439],"198":["thread",86520],"199":["thread",83096],"200":["thread",117503],"201":["thread",90486],"202":["thread",97767],"203":["thread",53833],"204":["thread",96562],"205":["thread",125276],"206":["thread",96406],"207":["thread",95258],"208":["thread",101192],"209":["thread",60888],"210":["thread",100991],"211":["thread",25402],"212":["thread",94662],"213":["thread",85368],"214":["thread",80880],"215":["thread",66375],"216":["thread",134942],"217":["thread",65492],"218":["thread",119533],"219":["thread",37447],"220":["thread",27727],"221":["thread",84071],"222":["thread",64856],"223":["thread",30542],"224":["thread",78599],"225":["thread",66951],"226":["thread",20550],"227":["thread",90216],"228":["thread",96950],"229":["thread",98280],"230":["thread",36349],"231":["thread",34006],"232":["thread",24682],"233":["thread",34708],"234":["thread",79211],"235":["thread",127482],"236":["thread",32971],"237":["thread",56107],"238":["thread",90245],"239":["thread",40437],"240":["thread",59916],"241":["thread",73215],"242":["thread",68578],"243":["thread",76423],"244":["thread",70005],"245":["thread",121888],"246":["thread",126178],"247":["thread",106824],"248":["thread",126847],"249":["thread",67306],"250":["thread",73733],"251":["thread",26489],"252":["thread",101753],"253":["thread",94869],"254":["thread",94704],"255":["thread",60329],"256":["thread",105533],"257":["thread",76706],"258":["thread",113693],"259":["thread",14316],"260":["thread",44159],"261":["thread",107150],"262":["thread",64540],"263":["thread",111726],"264":["thread",81874],"265":["thread",79924],"266":["thread",69335],"267":["thread",62764],"268":["thread",126029],"269":["thread",74031],"270":["thread",45220],"271":["thread",53165],"272":["thread",118325],"273":["thread",111691],"274":["thread",12080],"275":["thread",86602],"276":["thread",78920],"277":["thread",109038],"278":["thread",121982],"279":["thread",49444],"280":["thread",78682],"281":["thread",127028],"282":["thread",59791],"283":["thread",70546],"284":["thread",17419],"285":["thread",96401],"286":["thread",69833],"287":["thread",37543],"288":["thread",85741],"289":["thread",72438],"290":["thread",74525],"291":["thread",22727],"292":["thread",80149],"293":["thread",78603],"294":["thread",66148],"295":["thread",89871],"296":["thread",62716],"297":["thread",61567],"298":["thread",114553],"299":["thread",91311]}
Run Time: 0.003253
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 |