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 (97158, 4980, 133387, 35435, 83386, 133733, 97010, 96043, 44320, 98401, 94329, 63430, 61787, 80404, 55475, 106142, 86974, 69227, 136027, 12779, 75035, 70067, 95691, 92968, 100904, 62732, 45441, 68440, 86938, 50538, 42503, 88863, 44322, 56740, 100040, 58558, 71039, 41006, 104271, 67165, 23389, 64747, 133625, 50671, 108981, 131680, 76407, 68352, 38659, 71226, 54212, 134225, 131064, 82162, 135968, 49791, 98157, 36066, 135379, 93288, 56568, 105438, 87579, 61239, 134513, 87788, 60894, 115998, 70363, 129108, 87782, 83367, 95756, 80791, 80993, 128309, 96614, 81693, 58275, 89978, 36180, 34708, 105493, 75939, 87195, 57425, 51800, 695, 87119, 98293, 93911, 125944, 132392, 64719, 83658, 66500, 92935, 60306, 89980, 48111, 52510, 88436, 100444, 103306, 126579, 61940, 67384, 107468, 108586, 84235, 89484, 53940, 62065, 85577, 79784, 84822, 96845, 87818, 114775, 87509, 88065, 19540, 64389, 62271, 66379, 58588, 98152, 90498, 116225, 68146, 83830, 87492, 90208, 131679, 105088, 75065, 67018, 83976, 61104, 59320, 98920, 51125, 72034, 7596, 73330, 115443, 50043, 64698, 66468, 100513, 96621, 96558, 67710, 103995, 109342, 17583, 70005, 72474, 90389, 100008, 92896, 85994, 115144, 86575, 133690, 68050, 67651, 56084, 109565, 135214, 89457, 133557, 89318, 102853, 95753, 44757, 60147, 95120, 84440, 56827, 116563, 86012, 68034, 123971, 109714, 79302, 96542, 69420, 99532, 87072, 82716, 61359, 54664, 48102, 109946, 119655, 93451, 101790, 93740, 134703, 54236, 24082, 30076, 78434, 40937, 71981, 125411, 48206, 85972, 58406, 133354, 80880, 97641, 90523, 96560, 131350, 68711, 71259, 113710, 86276, 113992, 67542, 125368, 112005, 87972, 110692, 63859, 38079, 80007, 106152, 105159, 67895, 89995, 111729, 87568, 95580, 83010, 59733, 58404, 45881, 69733, 62111, 58194, 96536, 115624, 105926, 71181, 43528, 105529, 66407, 36308, 27619, 95355, 68998, 91311, 110793, 107001, 105623, 101342, 73226, 83239, 68115, 109377, 54775, 105279, 95499, 36405, 105112, 125053, 58504, 71101, 79402, 37405, 105848, 85886, 61832, 84969, 60353, 63162, 92416, 102768, 62773, 125767, 95378, 122042, 92533, 106816, 80925, 41998, 125365, 80148, 110819, 91823, 88228, 67672, 116315, 97071, 114438, 51847, 45489)
Run Time: 0.033661
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: 1472, 0, 1714020019, 1714023619, {"0":["thread",97158],"1":["thread",4980],"2":["thread",133387],"3":["thread",35435],"4":["thread",83386],"5":["thread",133733],"6":["thread",97010],"7":["thread",96043],"8":["thread",44320],"9":["thread",98401],"10":["thread",94329],"11":["thread",63430],"12":["thread",61787],"13":["thread",80404],"14":["thread",55475],"15":["thread",106142],"16":["thread",86974],"17":["thread",69227],"18":["thread",136027],"19":["thread",12779],"20":["thread",75035],"21":["thread",70067],"22":["thread",95691],"23":["thread",92968],"24":["thread",100904],"25":["thread",62732],"26":["thread",45441],"27":["thread",68440],"28":["thread",86938],"29":["thread",50538],"30":["thread",42503],"31":["thread",88863],"32":["thread",44322],"33":["thread",56740],"34":["thread",100040],"35":["thread",58558],"36":["thread",71039],"37":["thread",41006],"38":["thread",104271],"39":["thread",67165],"40":["thread",23389],"41":["thread",64747],"42":["thread",133625],"43":["thread",50671],"44":["thread",108981],"45":["thread",131680],"46":["thread",76407],"47":["thread",68352],"48":["thread",38659],"49":["thread",71226],"50":["thread",54212],"51":["thread",134225],"52":["thread",131064],"53":["thread",82162],"54":["thread",135968],"55":["thread",49791],"56":["thread",98157],"57":["thread",36066],"58":["thread",135379],"59":["thread",93288],"60":["thread",56568],"61":["thread",105438],"62":["thread",87579],"63":["thread",61239],"64":["thread",134513],"65":["thread",87788],"66":["thread",60894],"67":["thread",115998],"68":["thread",70363],"69":["thread",129108],"70":["thread",87782],"71":["thread",83367],"72":["thread",95756],"73":["thread",80791],"74":["thread",80993],"75":["thread",128309],"76":["thread",96614],"77":["thread",81693],"78":["thread",58275],"80":["thread",36180],"81":["thread",34708],"82":["thread",105493],"83":["thread",75939],"84":["thread",87195],"85":["thread",57425],"86":["thread",51800],"87":["thread",695],"88":["thread",87119],"89":["thread",98293],"90":["thread",93911],"91":["thread",125944],"92":["thread",132392],"93":["thread",64719],"94":["thread",83658],"95":["thread",66500],"96":["thread",92935],"97":["thread",60306],"98":["thread",89980],"99":["thread",48111],"100":["thread",52510],"101":["thread",88436],"102":["thread",100444],"103":["thread",103306],"104":["thread",126579],"105":["thread",61940],"106":["thread",67384],"107":["thread",107468],"108":["thread",108586],"109":["thread",84235],"110":["thread",89484],"111":["thread",53940],"112":["thread",62065],"113":["thread",85577],"114":["thread",79784],"115":["thread",84822],"116":["thread",96845],"117":["thread",87818],"118":["thread",114775],"119":["thread",87509],"120":["thread",88065],"121":["thread",19540],"122":["thread",64389],"123":["thread",62271],"124":["thread",66379],"125":["thread",58588],"126":["thread",98152],"127":["thread",90498],"128":["thread",116225],"129":["thread",68146],"130":["thread",83830],"131":["thread",87492],"132":["thread",90208],"133":["thread",131679],"134":["thread",105088],"135":["thread",75065],"136":["thread",67018],"137":["thread",83976],"138":["thread",61104],"139":["thread",59320],"140":["thread",98920],"141":["thread",51125],"142":["thread",72034],"143":["thread",7596],"144":["thread",73330],"145":["thread",115443],"146":["thread",50043],"147":["thread",64698],"148":["thread",66468],"149":["thread",100513],"150":["thread",96621],"151":["thread",96558],"152":["thread",67710],"153":["thread",103995],"154":["thread",109342],"155":["thread",17583],"156":["thread",70005],"157":["thread",72474],"158":["thread",90389],"159":["thread",100008],"160":["thread",92896],"161":["thread",85994],"162":["thread",115144],"163":["thread",86575],"164":["thread",133690],"165":["thread",68050],"166":["thread",67651],"167":["thread",56084],"168":["thread",109565],"169":["thread",135214],"170":["thread",89457],"171":["thread",133557],"172":["thread",89318],"173":["thread",102853],"174":["thread",95753],"175":["thread",44757],"176":["thread",60147],"177":["thread",95120],"178":["thread",84440],"179":["thread",56827],"180":["thread",116563],"181":["thread",86012],"182":["thread",68034],"183":["thread",123971],"184":["thread",109714],"185":["thread",79302],"186":["thread",96542],"187":["thread",69420],"188":["thread",99532],"189":["thread",87072],"190":["thread",82716],"191":["thread",61359],"192":["thread",54664],"193":["thread",48102],"194":["thread",109946],"195":["thread",119655],"196":["thread",93451],"197":["thread",101790],"198":["thread",93740],"199":["thread",134703],"200":["thread",54236],"201":["thread",24082],"202":["thread",30076],"203":["thread",78434],"204":["thread",40937],"205":["thread",71981],"206":["thread",125411],"207":["thread",48206],"208":["thread",85972],"209":["thread",58406],"210":["thread",133354],"211":["thread",80880],"212":["thread",97641],"213":["thread",90523],"214":["thread",96560],"215":["thread",131350],"216":["thread",68711],"217":["thread",71259],"218":["thread",113710],"219":["thread",86276],"220":["thread",113992],"221":["thread",67542],"222":["thread",125368],"223":["thread",112005],"224":["thread",87972],"225":["thread",110692],"226":["thread",63859],"227":["thread",38079],"228":["thread",80007],"229":["thread",106152],"230":["thread",105159],"231":["thread",67895],"232":["thread",89995],"233":["thread",111729],"234":["thread",87568],"235":["thread",95580],"236":["thread",83010],"237":["thread",59733],"238":["thread",58404],"239":["thread",45881],"240":["thread",69733],"241":["thread",62111],"242":["thread",58194],"243":["thread",96536],"244":["thread",115624],"245":["thread",105926],"246":["thread",71181],"247":["thread",43528],"248":["thread",105529],"249":["thread",66407],"250":["thread",36308],"251":["thread",27619],"252":["thread",95355],"253":["thread",68998],"254":["thread",91311],"255":["thread",110793],"256":["thread",107001],"257":["thread",105623],"258":["thread",101342],"259":["thread",73226],"260":["thread",83239],"261":["thread",68115],"262":["thread",109377],"263":["thread",54775],"264":["thread",105279],"265":["thread",95499],"266":["thread",36405],"267":["thread",105112],"268":["thread",125053],"269":["thread",58504],"270":["thread",71101],"271":["thread",79402],"272":["thread",37405],"273":["thread",105848],"274":["thread",85886],"275":["thread",61832],"276":["thread",84969],"277":["thread",60353],"278":["thread",63162],"279":["thread",92416],"280":["thread",102768],"281":["thread",62773],"282":["thread",125767],"283":["thread",95378],"284":["thread",122042],"285":["thread",92533],"286":["thread",106816],"287":["thread",80925],"288":["thread",41998],"289":["thread",125365],"290":["thread",80148],"291":["thread",110819],"292":["thread",91823],"293":["thread",88228],"294":["thread",67672],"295":["thread",116315],"296":["thread",97071],"297":["thread",114438],"298":["thread",51847],"299":["thread",45489]}
Run Time: 0.001893
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.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |