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 (99661, 117078, 67951, 85886, 127274, 91921, 47998, 90813, 87977, 37575, 89739, 24612, 70067, 88676, 105344, 53213, 121720, 63044, 73785, 57291, 64928, 60562, 72059, 127612, 110454, 98401, 81564, 78502, 9512, 86015, 103552, 120333, 86934, 49880, 56299, 130428, 70611, 62740, 66749, 76062, 85325, 126630, 49872, 65680, 49881, 59883, 126530, 110551, 56917, 83830, 93630, 123966, 98953, 45130, 136562, 135860, 37447, 135968, 108078, 133086, 106062, 93568, 92792, 133215, 112254, 83509, 133020, 98358, 96662, 47675, 36092, 56827, 44189, 79841, 93442, 118063, 88213, 82716, 17037, 44322, 43657, 8563, 78923, 35643, 91943, 66717, 109068, 135070, 26587, 85408, 125512, 105159, 115930, 87731, 53517, 133574, 135782, 132487, 97549, 65343, 93031, 53039, 85209, 107200, 53601, 77436, 49899, 55365, 60141, 60933, 87170, 131047, 93493, 70630, 84561, 109076, 132392, 124876, 60244, 117694, 126883, 90718, 59600, 45733, 67727, 39244, 91735, 37199, 106478, 67165, 83751, 126662, 126584, 59021, 78430, 80240, 105131, 103046, 71616, 125050, 64280, 106831, 58033, 60916, 113472, 6228, 71222, 58633, 75029, 120123, 88946, 129094, 128268, 47306, 114908, 80476, 124282, 97587, 94001, 18386, 25615, 125803, 80014, 89847, 79675, 71956, 36997, 85401, 56021, 118188, 126342, 109160, 113561, 85572, 52845, 45881, 125294, 83547, 70994, 64698, 54230, 109258, 116045, 95067, 128882, 99615, 3884, 39605, 54883, 85994, 79460, 123465, 118325, 37871, 135748, 55561, 32682, 130563, 53064, 124381, 62716, 125903, 70461, 103528, 79924, 93903, 41290, 127028, 66147, 122878, 70494, 135104, 127909, 83725, 29015, 107641, 52206, 116256, 109176, 59246, 59466, 136518, 54774, 97795, 58242, 56999, 1505, 122982, 68119, 123050, 84700, 44688, 83585, 124077, 129504, 113506, 110819, 91381, 96179, 80680, 101443, 46254, 106269, 94337, 113788, 120813, 131914, 67979, 55155, 79938, 110569, 66232, 108352, 119770, 135102, 44621, 40778, 84921, 55827, 122073, 133733, 82964, 125715, 58997, 73237, 53318, 128111, 71646, 92614, 39210, 90186, 121979, 19353, 61830, 124106, 103164, 35440, 123021, 80728, 106594, 133600, 59417, 92848, 128257, 113430, 18816, 95768, 108039, 128178, 60463, 89814, 44166, 47849, 60893, 19710, 7011, 54115, 124175, 77069)
Run Time: 0.044966
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 299 | 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: 697, 0, 1715586100, 1715589700, {"0":["resource",36],"1":["thread",99661],"2":["thread",117078],"3":["thread",67951],"4":["thread",85886],"5":["thread",127274],"6":["thread",91921],"7":["thread",47998],"8":["thread",90813],"9":["thread",87977],"10":["thread",37575],"11":["thread",89739],"12":["thread",24612],"13":["thread",70067],"14":["thread",88676],"15":["thread",105344],"16":["thread",53213],"17":["thread",121720],"18":["thread",63044],"19":["thread",73785],"20":["thread",57291],"21":["thread",64928],"22":["thread",60562],"23":["thread",72059],"24":["thread",127612],"25":["thread",110454],"26":["thread",98401],"27":["thread",81564],"28":["thread",78502],"29":["thread",9512],"31":["thread",103552],"32":["thread",120333],"33":["thread",86934],"34":["thread",49880],"35":["thread",56299],"36":["thread",130428],"37":["thread",70611],"38":["thread",62740],"39":["thread",66749],"40":["thread",76062],"41":["thread",85325],"42":["thread",126630],"43":["thread",49872],"44":["thread",65680],"45":["thread",49881],"46":["thread",59883],"47":["thread",126530],"48":["thread",110551],"49":["thread",56917],"50":["thread",83830],"51":["thread",93630],"52":["thread",123966],"53":["thread",98953],"54":["thread",45130],"55":["thread",136562],"56":["thread",135860],"57":["thread",37447],"58":["thread",135968],"59":["thread",108078],"60":["thread",133086],"61":["thread",106062],"62":["thread",93568],"63":["thread",92792],"64":["thread",133215],"65":["thread",112254],"66":["thread",83509],"67":["thread",133020],"68":["thread",98358],"69":["thread",96662],"70":["thread",47675],"71":["thread",36092],"72":["thread",56827],"73":["thread",44189],"74":["thread",79841],"75":["thread",93442],"76":["thread",118063],"77":["thread",88213],"78":["thread",82716],"79":["thread",17037],"80":["thread",44322],"81":["thread",43657],"82":["thread",8563],"83":["thread",78923],"84":["thread",35643],"85":["thread",91943],"86":["thread",66717],"87":["thread",109068],"88":["thread",135070],"89":["thread",26587],"90":["thread",85408],"91":["thread",125512],"92":["thread",105159],"93":["thread",115930],"94":["thread",87731],"95":["thread",53517],"96":["thread",133574],"97":["thread",135782],"98":["thread",132487],"99":["thread",97549],"100":["thread",65343],"101":["thread",93031],"102":["thread",53039],"103":["thread",85209],"104":["thread",107200],"105":["thread",53601],"106":["thread",77436],"107":["thread",49899],"108":["thread",55365],"109":["thread",60141],"110":["thread",60933],"111":["thread",87170],"112":["thread",131047],"113":["thread",93493],"114":["thread",70630],"115":["thread",84561],"116":["thread",109076],"117":["thread",132392],"118":["thread",124876],"119":["thread",60244],"120":["thread",117694],"121":["thread",126883],"122":["thread",90718],"123":["thread",59600],"124":["thread",45733],"125":["thread",67727],"126":["thread",39244],"127":["thread",91735],"128":["thread",37199],"129":["thread",106478],"130":["thread",67165],"131":["thread",83751],"132":["thread",126662],"133":["thread",126584],"134":["thread",59021],"135":["thread",78430],"136":["thread",80240],"137":["thread",105131],"138":["thread",103046],"139":["thread",71616],"140":["thread",125050],"141":["thread",64280],"142":["thread",106831],"143":["thread",58033],"144":["thread",60916],"145":["thread",113472],"146":["thread",6228],"147":["thread",71222],"148":["thread",58633],"149":["thread",75029],"150":["thread",120123],"151":["thread",88946],"152":["thread",129094],"153":["thread",128268],"154":["thread",47306],"155":["thread",114908],"156":["thread",80476],"157":["thread",124282],"158":["thread",97587],"159":["thread",94001],"160":["thread",18386],"161":["thread",25615],"162":["thread",125803],"163":["thread",80014],"164":["thread",89847],"165":["thread",79675],"166":["thread",71956],"167":["thread",36997],"168":["thread",85401],"169":["thread",56021],"170":["thread",118188],"171":["thread",126342],"172":["thread",109160],"173":["thread",113561],"174":["thread",85572],"175":["thread",52845],"176":["thread",45881],"177":["thread",125294],"178":["thread",83547],"179":["thread",70994],"180":["thread",64698],"181":["thread",54230],"182":["thread",109258],"183":["thread",116045],"184":["thread",95067],"185":["thread",128882],"186":["thread",99615],"187":["thread",3884],"188":["thread",39605],"189":["thread",54883],"190":["thread",85994],"191":["thread",79460],"192":["thread",123465],"193":["thread",118325],"194":["thread",37871],"195":["thread",135748],"196":["thread",55561],"197":["thread",32682],"198":["thread",130563],"199":["thread",53064],"200":["thread",124381],"201":["thread",62716],"202":["thread",125903],"203":["thread",70461],"204":["thread",103528],"205":["thread",79924],"206":["thread",93903],"207":["thread",41290],"208":["thread",127028],"209":["thread",66147],"210":["thread",122878],"211":["thread",70494],"212":["thread",135104],"213":["thread",127909],"214":["thread",83725],"215":["thread",29015],"216":["thread",107641],"217":["thread",52206],"218":["thread",116256],"219":["thread",109176],"220":["thread",59246],"221":["thread",59466],"222":["thread",136518],"223":["thread",54774],"224":["thread",97795],"225":["thread",58242],"226":["thread",56999],"227":["thread",1505],"228":["thread",122982],"229":["thread",68119],"230":["thread",123050],"231":["thread",84700],"232":["thread",44688],"233":["thread",83585],"234":["thread",124077],"235":["thread",129504],"236":["thread",113506],"237":["thread",110819],"238":["thread",91381],"239":["thread",96179],"240":["thread",80680],"241":["thread",101443],"242":["thread",46254],"243":["thread",106269],"244":["thread",94337],"245":["thread",113788],"246":["thread",120813],"247":["thread",131914],"248":["thread",67979],"249":["thread",55155],"250":["thread",79938],"251":["thread",110569],"252":["thread",66232],"253":["thread",108352],"254":["thread",119770],"255":["thread",135102],"256":["thread",44621],"257":["thread",40778],"258":["thread",84921],"259":["thread",55827],"260":["thread",122073],"261":["thread",133733],"262":["thread",82964],"263":["thread",125715],"264":["thread",58997],"265":["thread",73237],"266":["thread",53318],"267":["thread",128111],"268":["thread",71646],"269":["thread",92614],"270":["thread",39210],"271":["thread",90186],"272":["thread",121979],"273":["thread",19353],"274":["thread",61830],"275":["thread",124106],"276":["thread",103164],"277":["thread",35440],"278":["thread",123021],"279":["thread",80728],"280":["thread",106594],"281":["thread",133600],"282":["thread",59417],"283":["thread",92848],"284":["thread",128257],"285":["thread",113430],"286":["thread",18816],"287":["thread",95768],"288":["thread",108039],"289":["thread",128178],"290":["thread",60463],"291":["thread",89814],"292":["thread",44166],"293":["thread",47849],"294":["thread",60893],"295":["thread",19710],"296":["thread",7011],"297":["thread",54115],"298":["thread",124175],"299":["thread",77069]}
Run Time: 0.108938
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.000085
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |