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 (656, 75686, 87011, 116647, 133975, 112875, 1134, 91045, 72278, 820, 114545, 135726, 4151, 87334, 78211, 703, 31837, 125644, 2077, 122803, 113567, 100215, 18301, 10705, 419, 734, 15527, 136109, 2107, 2103, 115088, 109396, 71559, 117476, 724, 830, 80545, 73244, 104933, 2082, 52137, 114803, 126377, 112862, 134821, 11411, 115928, 821, 8997, 71768, 56611, 136021, 40264, 30646, 1568, 2108, 113759, 109661, 136022, 1392, 2081, 678, 6896, 1493, 122663, 106303, 57886, 5481, 6381, 109921, 106644, 130290, 74510, 116799, 114475, 103085, 111162, 11, 465, 722, 113763, 75831, 78898, 80168, 2080, 135729, 37814, 87124, 75833, 113141, 135367, 20000, 437, 135852, 127575, 80212, 114797, 131892, 695, 24758, 9746, 39054, 2253, 87840, 468, 10456, 62895, 2255, 7655, 126543, 116863, 104376, 76753, 16966, 116917, 76817, 961, 414, 116192, 115601, 70557, 57377, 90382, 133331, 136596, 124709, 113524, 131096, 1494, 109499, 10469, 134784, 113572, 136600, 115926, 116789, 114982, 1595, 89285, 136023, 80694, 70948, 113368, 1223, 126103, 525, 104227, 894, 87067, 107088, 76401, 57468, 134215, 600, 114705, 1535, 134819, 116167, 33446, 109712, 72217, 80339, 14358, 96397, 128295, 135923, 2200, 29249, 78461, 135927, 668, 104303, 136630, 47713, 2258, 4283, 87987, 663, 111897, 78663, 129034, 1318, 62894, 2601, 105670, 106081, 74, 2163, 59512, 5557, 109617, 2695, 95460, 101981, 72899, 116780, 128624, 736, 2367, 113526, 1262, 134233, 115661, 76006, 36772, 112886, 1716, 135922, 136107, 46793, 109338, 48482, 114312, 114027, 129030, 130454, 123133, 2257, 73580, 829, 103097, 136598, 126081, 90337, 80533, 92849, 4845, 66749, 114094, 489, 93111, 10165, 109586, 114891, 2201, 129798, 77461, 116810, 117036, 102646, 109622, 67175, 40360, 88558, 69493, 35316, 3333, 119874, 50944, 125139, 667, 37902, 725, 115488, 136632, 67431, 81207, 134725, 95990, 114983, 1200, 78172, 113724, 26414, 122064, 117221, 67474, 134169, 131092, 1302, 69121, 98171, 29471, 103877, 67582, 18815, 733, 74808, 116685, 109911, 102542, 505, 63037, 897, 475, 30833, 5351, 115614, 136617, 116168, 122570, 1193, 115501, 3143, 738)
Run Time: 0.007585
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 295 | 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: 53, 0, 1714188984, 1714192584, {"0":["tinhte_xentag_forum",74],"1":["thread",656],"2":["thread",75686],"3":["thread",87011],"4":["thread",116647],"5":["thread",133975],"6":["thread",112875],"7":["thread",1134],"8":["thread",91045],"9":["thread",72278],"10":["thread",820],"11":["thread",114545],"12":["thread",135726],"13":["thread",4151],"14":["thread",87334],"15":["thread",78211],"16":["thread",703],"17":["thread",31837],"18":["thread",125644],"19":["thread",2077],"20":["thread",122803],"21":["thread",113567],"22":["thread",100215],"23":["thread",18301],"24":["thread",10705],"25":["thread",419],"26":["thread",734],"27":["thread",15527],"28":["thread",136109],"29":["thread",2107],"30":["thread",2103],"31":["thread",115088],"32":["thread",109396],"33":["thread",71559],"34":["thread",117476],"35":["thread",724],"36":["thread",830],"37":["thread",80545],"38":["thread",73244],"39":["thread",104933],"40":["thread",2082],"41":["thread",52137],"42":["thread",114803],"43":["thread",126377],"44":["thread",112862],"45":["thread",134821],"46":["thread",11411],"47":["thread",115928],"49":["thread",8997],"50":["thread",71768],"51":["thread",56611],"52":["thread",136021],"53":["thread",40264],"54":["thread",30646],"55":["thread",1568],"56":["thread",2108],"57":["thread",113759],"58":["thread",109661],"59":["thread",136022],"60":["thread",1392],"61":["thread",2081],"62":["thread",678],"63":["thread",6896],"64":["thread",1493],"65":["thread",122663],"66":["thread",106303],"67":["thread",57886],"68":["thread",5481],"69":["thread",6381],"70":["thread",109921],"71":["thread",106644],"72":["thread",130290],"73":["thread",74510],"74":["thread",116799],"75":["thread",114475],"76":["thread",103085],"77":["thread",111162],"78":["thread",11],"79":["thread",465],"80":["thread",722],"81":["thread",113763],"82":["thread",75831],"83":["thread",78898],"84":["thread",80168],"85":["thread",2080],"86":["thread",135729],"87":["thread",37814],"88":["thread",87124],"89":["thread",75833],"90":["thread",113141],"91":["thread",135367],"92":["thread",20000],"93":["thread",437],"94":["thread",135852],"95":["thread",127575],"96":["thread",80212],"97":["thread",114797],"98":["thread",131892],"99":["thread",695],"100":["thread",24758],"101":["thread",9746],"102":["thread",39054],"103":["thread",2253],"104":["thread",87840],"105":["thread",468],"106":["thread",10456],"107":["thread",62895],"108":["thread",2255],"109":["thread",7655],"110":["thread",126543],"111":["thread",116863],"112":["thread",104376],"113":["thread",76753],"114":["thread",16966],"115":["thread",116917],"116":["thread",76817],"117":["thread",961],"118":["thread",414],"119":["thread",116192],"120":["thread",115601],"121":["thread",70557],"122":["thread",57377],"123":["thread",90382],"124":["thread",133331],"125":["thread",136596],"126":["thread",124709],"127":["thread",113524],"128":["thread",131096],"129":["thread",1494],"130":["thread",109499],"131":["thread",10469],"132":["thread",134784],"133":["thread",113572],"134":["thread",136600],"135":["thread",115926],"136":["thread",116789],"137":["thread",114982],"138":["thread",1595],"139":["thread",89285],"140":["thread",136023],"141":["thread",80694],"142":["thread",70948],"143":["thread",113368],"144":["thread",1223],"145":["thread",126103],"146":["thread",525],"147":["thread",104227],"148":["thread",894],"149":["thread",87067],"150":["thread",107088],"151":["thread",76401],"152":["thread",57468],"153":["thread",134215],"154":["thread",600],"155":["thread",114705],"156":["thread",1535],"157":["thread",134819],"158":["thread",116167],"159":["thread",33446],"160":["thread",109712],"161":["thread",72217],"162":["thread",80339],"163":["thread",14358],"164":["thread",96397],"165":["thread",128295],"166":["thread",135923],"167":["thread",2200],"168":["thread",29249],"169":["thread",78461],"170":["thread",135927],"171":["thread",668],"172":["thread",104303],"173":["thread",136630],"174":["thread",47713],"175":["thread",2258],"176":["thread",4283],"177":["thread",87987],"178":["thread",663],"179":["thread",111897],"180":["thread",78663],"181":["thread",129034],"182":["thread",1318],"183":["thread",62894],"184":["thread",2601],"185":["thread",105670],"186":["thread",106081],"187":["thread",74],"188":["thread",2163],"189":["thread",59512],"190":["thread",5557],"191":["thread",109617],"192":["thread",2695],"193":["thread",95460],"194":["thread",101981],"195":["thread",72899],"196":["thread",116780],"197":["thread",128624],"198":["thread",736],"199":["thread",2367],"200":["thread",113526],"201":["thread",1262],"202":["thread",134233],"203":["thread",115661],"204":["thread",76006],"205":["thread",36772],"206":["thread",112886],"207":["thread",1716],"208":["thread",135922],"209":["thread",136107],"210":["thread",46793],"211":["thread",109338],"212":["thread",48482],"213":["thread",114312],"214":["thread",114027],"215":["thread",129030],"216":["thread",130454],"217":["thread",123133],"218":["thread",2257],"219":["thread",73580],"220":["thread",829],"221":["thread",103097],"222":["thread",136598],"223":["thread",126081],"224":["thread",90337],"225":["thread",80533],"226":["thread",92849],"227":["thread",4845],"228":["thread",66749],"229":["thread",114094],"230":["thread",489],"231":["thread",93111],"232":["thread",10165],"233":["thread",109586],"234":["thread",114891],"235":["thread",2201],"236":["thread",129798],"237":["thread",77461],"238":["thread",116810],"239":["thread",117036],"240":["thread",102646],"241":["thread",109622],"242":["thread",67175],"243":["thread",40360],"244":["thread",88558],"245":["thread",69493],"246":["thread",35316],"247":["thread",3333],"248":["thread",119874],"249":["thread",50944],"250":["thread",125139],"251":["thread",667],"252":["thread",37902],"253":["thread",725],"254":["thread",115488],"255":["thread",136632],"256":["thread",67431],"257":["thread",81207],"258":["thread",134725],"259":["thread",95990],"260":["thread",114983],"261":["thread",1200],"262":["thread",78172],"263":["thread",113724],"264":["thread",26414],"265":["thread",122064],"266":["thread",117221],"267":["thread",67474],"268":["thread",134169],"269":["thread",131092],"270":["thread",1302],"271":["thread",69121],"272":["thread",98171],"273":["thread",29471],"274":["thread",103877],"275":["thread",67582],"276":["thread",18815],"277":["thread",733],"278":["thread",74808],"279":["thread",116685],"280":["thread",109911],"281":["thread",102542],"282":["thread",505],"283":["thread",63037],"284":["thread",897],"285":["thread",475],"286":["thread",30833],"287":["thread",5351],"288":["thread",115614],"289":["thread",136617],"290":["thread",116168],"291":["thread",122570],"292":["thread",1193],"293":["thread",115501],"294":["thread",3143],"295":["thread",738]}
Run Time: 0.001355
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |