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 (59600, 93568, 37700, 99281, 83547, 85306, 106196, 100551, 73998, 69139, 127784, 84925, 93880, 18657, 116827, 122073, 106936, 82713, 96304, 25081, 59868, 124661, 135253, 93302, 101736, 112496, 133020, 122224, 135796, 125252, 87167, 75623, 57013, 80830, 58628, 108380, 134116, 23470, 64083, 96246, 94240, 99559, 66957, 93176, 68274, 19001, 118915, 87016, 65465, 97138, 51412, 40868, 64699, 45353, 64714, 78430, 89367, 132487, 103354, 94257, 108941, 98072, 24005, 13370, 113134, 63825, 40410, 123034, 103046, 57824, 116148, 98959, 52003, 64515, 79608, 24613, 45134, 85431, 98086, 97980, 76072, 85345, 122540, 58665, 47552, 92651, 99719, 55944, 59853, 107200, 37687, 91937, 103565, 127545, 96382, 113895, 94786, 108351, 62521, 132888, 52550, 104540, 121228, 97766, 93871, 79841, 59158, 114492, 62740, 100408, 76253, 56130, 109291, 91618, 109076, 68604, 64911, 109864, 85505, 46645, 85325, 52155, 112682, 121849, 97133, 49605, 111139, 99740, 50746, 93180, 70921, 92076, 47792, 132095, 113111, 59406, 49600, 63239, 87039, 76419, 56173, 38855, 108165, 87479, 112640, 113788, 26064, 126079, 95061, 34858, 24996, 4755, 73191, 57637, 86869, 62523, 72624, 86323, 26131, 55890, 66118, 66466, 96133, 85155, 16651, 113785, 81927, 57523, 86487, 51389, 107417, 53116, 135983, 61415, 83021, 121891, 68289, 61891, 69868, 7982, 117675, 99377, 26250, 81909, 66137, 97107, 129897, 58607, 94673, 63762, 92521, 57019, 115223, 29371, 104203, 74457, 112749, 67069, 111805, 86902, 48565, 98260, 131401, 19334, 110170, 113852, 134551, 86255, 60204, 83544, 96273, 41001, 90435, 94001, 93442, 65304, 22596, 126746, 30489, 48412, 89085, 90245, 90486, 95185, 120994, 65155, 107149, 118552, 58194, 79115, 49631, 38853, 61722, 57591, 23440, 108483, 67873, 128374, 100474, 68906, 68578, 123232, 21258, 51431, 87229, 63912, 5600, 120333, 35272, 97229, 128307, 78978, 79500, 91022, 96606, 106136, 74870, 111259, 121223, 125174, 81080, 98447, 26830, 127777, 121380, 70765, 49772, 44339, 113684, 68406, 35876, 72747, 123811, 133004, 51364, 77481, 82064, 67299, 94682, 16529, 98401, 56243, 20869, 124931, 101436, 115954, 125081, 90389, 106933, 116147, 89847, 97945, 108226, 110728, 70783, 68440, 54794, 94746, 36762, 91327)
Run Time: 0.042440
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: 1512, 0, 1711717525, 1711721125, {"0":["thread",59600],"1":["thread",93568],"2":["thread",37700],"3":["thread",99281],"4":["thread",83547],"5":["thread",85306],"6":["thread",106196],"7":["thread",100551],"8":["thread",73998],"9":["thread",69139],"10":["thread",127784],"11":["thread",84925],"12":["thread",93880],"13":["thread",18657],"14":["thread",116827],"15":["thread",122073],"16":["thread",106936],"17":["thread",82713],"18":["thread",96304],"19":["thread",25081],"20":["thread",59868],"21":["thread",124661],"22":["thread",135253],"23":["thread",93302],"24":["thread",101736],"25":["thread",112496],"26":["thread",133020],"27":["thread",122224],"28":["thread",135796],"29":["thread",125252],"30":["thread",87167],"31":["thread",75623],"32":["thread",57013],"33":["thread",80830],"34":["thread",58628],"35":["thread",108380],"36":["thread",134116],"37":["thread",23470],"38":["thread",64083],"39":["thread",96246],"40":["thread",94240],"41":["thread",99559],"42":["thread",66957],"43":["thread",93176],"44":["thread",68274],"45":["thread",19001],"46":["thread",118915],"47":["thread",87016],"48":["thread",65465],"49":["thread",97138],"50":["thread",51412],"51":["thread",40868],"52":["thread",64699],"53":["thread",45353],"54":["thread",64714],"55":["thread",78430],"56":["thread",89367],"57":["thread",132487],"58":["thread",103354],"59":["thread",94257],"60":["thread",108941],"61":["thread",98072],"62":["thread",24005],"63":["thread",13370],"64":["thread",113134],"65":["thread",63825],"66":["thread",40410],"67":["thread",123034],"68":["thread",103046],"70":["thread",116148],"71":["thread",98959],"72":["thread",52003],"73":["thread",64515],"74":["thread",79608],"75":["thread",24613],"76":["thread",45134],"77":["thread",85431],"78":["thread",98086],"79":["thread",97980],"80":["thread",76072],"81":["thread",85345],"82":["thread",122540],"83":["thread",58665],"84":["thread",47552],"85":["thread",92651],"86":["thread",99719],"87":["thread",55944],"88":["thread",59853],"89":["thread",107200],"90":["thread",37687],"91":["thread",91937],"92":["thread",103565],"93":["thread",127545],"94":["thread",96382],"95":["thread",113895],"96":["thread",94786],"97":["thread",108351],"98":["thread",62521],"99":["thread",132888],"100":["thread",52550],"101":["thread",104540],"102":["thread",121228],"103":["thread",97766],"104":["thread",93871],"105":["thread",79841],"106":["thread",59158],"107":["thread",114492],"108":["thread",62740],"109":["thread",100408],"110":["thread",76253],"111":["thread",56130],"112":["thread",109291],"113":["thread",91618],"114":["thread",109076],"115":["thread",68604],"116":["thread",64911],"117":["thread",109864],"118":["thread",85505],"119":["thread",46645],"120":["thread",85325],"121":["thread",52155],"122":["thread",112682],"123":["thread",121849],"124":["thread",97133],"125":["thread",49605],"126":["thread",111139],"127":["thread",99740],"128":["thread",50746],"129":["thread",93180],"130":["thread",70921],"131":["thread",92076],"132":["thread",47792],"133":["thread",132095],"134":["thread",113111],"135":["thread",59406],"136":["thread",49600],"137":["thread",63239],"138":["thread",87039],"139":["thread",76419],"140":["thread",56173],"141":["thread",38855],"142":["thread",108165],"143":["thread",87479],"144":["thread",112640],"145":["thread",113788],"146":["thread",26064],"147":["thread",126079],"148":["thread",95061],"149":["thread",34858],"150":["thread",24996],"151":["thread",4755],"152":["thread",73191],"153":["thread",57637],"154":["thread",86869],"155":["thread",62523],"156":["thread",72624],"157":["thread",86323],"158":["thread",26131],"159":["thread",55890],"160":["thread",66118],"161":["thread",66466],"162":["thread",96133],"163":["thread",85155],"164":["thread",16651],"165":["thread",113785],"166":["thread",81927],"167":["thread",57523],"168":["thread",86487],"169":["thread",51389],"170":["thread",107417],"171":["thread",53116],"172":["thread",135983],"173":["thread",61415],"174":["thread",83021],"175":["thread",121891],"176":["thread",68289],"177":["thread",61891],"178":["thread",69868],"179":["thread",7982],"180":["thread",117675],"181":["thread",99377],"182":["thread",26250],"183":["thread",81909],"184":["thread",66137],"185":["thread",97107],"186":["thread",129897],"187":["thread",58607],"188":["thread",94673],"189":["thread",63762],"190":["thread",92521],"191":["thread",57019],"192":["thread",115223],"193":["thread",29371],"194":["thread",104203],"195":["thread",74457],"196":["thread",112749],"197":["thread",67069],"198":["thread",111805],"199":["thread",86902],"200":["thread",48565],"201":["thread",98260],"202":["thread",131401],"203":["thread",19334],"204":["thread",110170],"205":["thread",113852],"206":["thread",134551],"207":["thread",86255],"208":["thread",60204],"209":["thread",83544],"210":["thread",96273],"211":["thread",41001],"212":["thread",90435],"213":["thread",94001],"214":["thread",93442],"215":["thread",65304],"216":["thread",22596],"217":["thread",126746],"218":["thread",30489],"219":["thread",48412],"220":["thread",89085],"221":["thread",90245],"222":["thread",90486],"223":["thread",95185],"224":["thread",120994],"225":["thread",65155],"226":["thread",107149],"227":["thread",118552],"228":["thread",58194],"229":["thread",79115],"230":["thread",49631],"231":["thread",38853],"232":["thread",61722],"233":["thread",57591],"234":["thread",23440],"235":["thread",108483],"236":["thread",67873],"237":["thread",128374],"238":["thread",100474],"239":["thread",68906],"240":["thread",68578],"241":["thread",123232],"242":["thread",21258],"243":["thread",51431],"244":["thread",87229],"245":["thread",63912],"246":["thread",5600],"247":["thread",120333],"248":["thread",35272],"249":["thread",97229],"250":["thread",128307],"251":["thread",78978],"252":["thread",79500],"253":["thread",91022],"254":["thread",96606],"255":["thread",106136],"256":["thread",74870],"257":["thread",111259],"258":["thread",121223],"259":["thread",125174],"260":["thread",81080],"261":["thread",98447],"262":["thread",26830],"263":["thread",127777],"264":["thread",121380],"265":["thread",70765],"266":["thread",49772],"267":["thread",44339],"268":["thread",113684],"269":["thread",68406],"270":["thread",35876],"271":["thread",72747],"272":["thread",123811],"273":["thread",133004],"274":["thread",51364],"275":["thread",77481],"276":["thread",82064],"277":["thread",67299],"278":["thread",94682],"279":["thread",16529],"280":["thread",98401],"281":["thread",56243],"282":["thread",20869],"283":["thread",124931],"284":["thread",101436],"285":["thread",115954],"286":["thread",125081],"287":["thread",90389],"288":["thread",106933],"289":["thread",116147],"290":["thread",89847],"291":["thread",97945],"292":["thread",108226],"293":["thread",110728],"294":["thread",70783],"295":["thread",68440],"296":["thread",54794],"297":["thread",94746],"298":["thread",36762],"299":["thread",91327]}
Run Time: 0.034153
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.000119
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |