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 (103461, 89425, 36930, 59937, 111833, 89346, 17992, 105553, 105382, 57926, 76948, 98845, 89253, 95970, 129947, 76793, 114508, 122835, 34603, 3720, 8685, 76671, 27096, 113550, 52674, 63529, 51215, 114413, 36924, 401, 127775, 114058, 60262, 70892, 14264, 114730, 134514, 127525, 129938, 76494, 112257, 103873, 105529, 113939, 128273, 121041, 88953, 49884, 111484, 106935, 128034, 92416, 81818, 55383, 65391, 75399, 79300, 128614, 60166, 58082, 114426, 66660, 27769, 78377, 108810, 113053, 940, 86941, 87227, 65451, 105394, 115104, 33391, 3226, 109607, 42072, 113004, 107814, 98271, 53107, 88355, 46912, 123993, 132296, 123991, 130679, 106035, 99649, 63443, 78813, 80138, 52074, 50863, 109821, 91404, 34397, 45023, 98999, 113160, 36532, 132339, 111231, 60528, 56663, 48711, 132280, 79041, 57617, 48278, 36920, 105097, 89175, 34738, 30069, 7334, 53140, 123373, 66562, 70309, 56541, 61089, 108301, 82961, 112456, 57649, 495, 72845, 79744, 113721, 78380, 111864, 115844, 60466, 108280, 111439, 97432, 49956, 49540, 111038, 114898, 117457, 54103, 58440, 111502, 69796, 46831, 115200, 69367, 71784, 107365, 87501, 60572, 53104, 127026, 51566, 50622, 128057, 106485, 126056, 71573, 37923, 54031, 107694, 75509, 129619, 116235, 3469, 19349, 119787, 38736, 100480, 64783, 56056, 79997, 133299, 56956, 64853, 85365, 107195, 95046, 80011, 71474, 78379, 61353, 66045, 44405, 73749, 105125, 60033, 110664, 94684, 117475, 86222, 97098, 115671, 105576, 70511, 99401, 107477, 32707, 85831, 36689, 19956, 13259, 112735, 37205, 49634, 94771, 71499, 55372, 108690, 18007, 4625, 71542, 114458, 88353, 106822, 95322, 29557, 104913, 50616, 58363, 73206, 72409, 108304, 20996, 27155, 73804, 56958, 126089, 66931, 55640, 61649, 77620, 81647, 688, 47712, 53117, 36921, 90180, 72362, 94400, 57958, 131763, 55890, 7920, 45387, 93531, 11652, 115672, 111594, 113742, 130579, 696, 23913, 117791, 107676, 95305, 135709, 115103, 123101, 133071, 110142, 102385, 60364, 96637, 90040, 88978, 107813, 718, 77022, 69427, 109342)
Run Time: 0.005623
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 273 | 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: 3689, 0, 1711692370, 1711695970, {"0":["tinhte_xentag_forum",36],"1":["thread",103461],"2":["thread",89425],"3":["thread",36930],"4":["thread",59937],"5":["thread",111833],"6":["thread",89346],"7":["thread",17992],"8":["thread",105553],"9":["thread",105382],"10":["thread",57926],"11":["thread",76948],"12":["thread",98845],"13":["thread",89253],"14":["thread",95970],"15":["thread",129947],"16":["thread",76793],"17":["thread",114508],"18":["thread",122835],"19":["thread",34603],"20":["thread",3720],"21":["thread",8685],"22":["thread",76671],"23":["thread",27096],"24":["thread",113550],"25":["thread",52674],"26":["thread",63529],"27":["thread",51215],"28":["thread",114413],"29":["thread",36924],"30":["thread",401],"31":["thread",127775],"32":["thread",114058],"33":["thread",60262],"34":["thread",70892],"35":["thread",14264],"36":["thread",114730],"37":["thread",134514],"38":["thread",127525],"39":["thread",129938],"40":["thread",76494],"41":["thread",112257],"42":["thread",103873],"43":["thread",105529],"44":["thread",113939],"45":["thread",128273],"46":["thread",121041],"47":["thread",88953],"48":["thread",49884],"49":["thread",111484],"50":["thread",106935],"51":["thread",128034],"52":["thread",92416],"53":["thread",81818],"54":["thread",55383],"55":["thread",65391],"56":["thread",75399],"57":["thread",79300],"58":["thread",128614],"59":["thread",60166],"60":["thread",58082],"61":["thread",114426],"62":["thread",66660],"63":["thread",27769],"64":["thread",78377],"65":["thread",108810],"66":["thread",113053],"67":["thread",940],"68":["thread",86941],"69":["thread",87227],"70":["thread",65451],"71":["thread",105394],"72":["thread",115104],"73":["thread",33391],"74":["thread",3226],"75":["thread",109607],"76":["thread",42072],"77":["thread",113004],"78":["thread",107814],"79":["thread",98271],"80":["thread",53107],"81":["thread",88355],"82":["thread",46912],"83":["thread",123993],"84":["thread",132296],"85":["thread",123991],"86":["thread",130679],"87":["thread",106035],"88":["thread",99649],"89":["thread",63443],"90":["thread",78813],"91":["thread",80138],"92":["thread",52074],"93":["thread",50863],"94":["thread",109821],"95":["thread",91404],"96":["thread",34397],"97":["thread",45023],"98":["thread",98999],"99":["thread",113160],"100":["thread",36532],"101":["thread",132339],"102":["thread",111231],"103":["thread",60528],"104":["thread",56663],"105":["thread",48711],"106":["thread",132280],"107":["thread",79041],"108":["thread",57617],"109":["thread",48278],"110":["thread",36920],"111":["thread",105097],"112":["thread",89175],"113":["thread",34738],"114":["thread",30069],"115":["thread",7334],"116":["thread",53140],"117":["thread",123373],"118":["thread",66562],"119":["thread",70309],"120":["thread",56541],"121":["thread",61089],"122":["thread",108301],"123":["thread",82961],"124":["thread",112456],"125":["thread",57649],"126":["thread",495],"127":["thread",72845],"128":["thread",79744],"129":["thread",113721],"130":["thread",78380],"131":["thread",111864],"132":["thread",115844],"133":["thread",60466],"134":["thread",108280],"135":["thread",111439],"136":["thread",97432],"137":["thread",49956],"138":["thread",49540],"139":["thread",111038],"140":["thread",114898],"141":["thread",117457],"142":["thread",54103],"143":["thread",58440],"144":["thread",111502],"145":["thread",69796],"146":["thread",46831],"147":["thread",115200],"148":["thread",69367],"149":["thread",71784],"150":["thread",107365],"151":["thread",87501],"152":["thread",60572],"153":["thread",53104],"154":["thread",127026],"155":["thread",51566],"156":["thread",50622],"157":["thread",128057],"158":["thread",106485],"159":["thread",126056],"161":["thread",37923],"162":["thread",54031],"163":["thread",107694],"164":["thread",75509],"165":["thread",129619],"166":["thread",116235],"167":["thread",3469],"168":["thread",19349],"169":["thread",119787],"170":["thread",38736],"171":["thread",100480],"172":["thread",64783],"173":["thread",56056],"174":["thread",79997],"175":["thread",133299],"176":["thread",56956],"177":["thread",64853],"178":["thread",85365],"179":["thread",107195],"180":["thread",95046],"181":["thread",80011],"182":["thread",71474],"183":["thread",78379],"184":["thread",61353],"185":["thread",66045],"186":["thread",44405],"187":["thread",73749],"188":["thread",105125],"189":["thread",60033],"190":["thread",110664],"191":["thread",94684],"192":["thread",117475],"193":["thread",86222],"194":["thread",97098],"195":["thread",115671],"196":["thread",105576],"197":["thread",70511],"198":["thread",99401],"199":["thread",107477],"200":["thread",32707],"201":["thread",85831],"202":["thread",36689],"203":["thread",19956],"204":["thread",13259],"205":["thread",112735],"206":["thread",37205],"207":["thread",49634],"208":["thread",94771],"209":["thread",71499],"210":["thread",55372],"211":["thread",108690],"212":["thread",18007],"213":["thread",4625],"214":["thread",71542],"215":["thread",114458],"216":["thread",88353],"217":["thread",106822],"218":["thread",95322],"219":["thread",29557],"220":["thread",104913],"221":["thread",50616],"222":["thread",58363],"223":["thread",73206],"224":["thread",72409],"225":["thread",108304],"226":["thread",20996],"227":["thread",27155],"228":["thread",73804],"229":["thread",56958],"230":["thread",126089],"231":["thread",66931],"232":["thread",55640],"233":["thread",61649],"234":["thread",77620],"235":["thread",81647],"236":["thread",688],"237":["thread",47712],"238":["thread",53117],"239":["thread",36921],"240":["thread",90180],"241":["thread",72362],"242":["thread",94400],"243":["thread",57958],"244":["thread",131763],"245":["thread",55890],"246":["thread",7920],"247":["thread",45387],"248":["thread",93531],"249":["thread",11652],"250":["thread",115672],"251":["thread",111594],"252":["thread",113742],"253":["thread",130579],"254":["thread",696],"255":["thread",23913],"256":["thread",117791],"257":["thread",107676],"258":["thread",95305],"259":["thread",135709],"260":["thread",115103],"261":["thread",123101],"262":["thread",133071],"263":["thread",110142],"264":["thread",102385],"265":["thread",60364],"266":["thread",96637],"267":["thread",90040],"268":["thread",88978],"269":["thread",107813],"270":["thread",718],"271":["thread",77022],"272":["thread",69427],"273":["thread",109342]}
Run Time: 0.022294
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.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |