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 (45353, 133733, 65931, 105330, 29109, 85081, 133324, 136137, 85775, 106594, 72304, 108395, 73016, 125074, 80653, 18346, 130417, 98703, 45243, 124808, 65506, 45476, 82873, 19839, 108128, 118988, 68906, 136532, 98854, 103709, 99704, 63372, 77935, 7749, 70736, 60700, 132775, 88046, 60745, 89606, 57035, 61250, 83071, 28172, 84230, 110830, 53318, 109127, 86355, 98711, 110569, 95262, 126396, 123928, 47622, 113430, 85634, 69139, 126211, 133861, 49628, 33299, 42085, 62946, 61407, 60448, 58932, 130809, 131696, 77069, 14104, 85328, 41992, 77516, 74706, 72797, 48281, 90570, 44520, 52154, 58997, 49881, 55294, 64305, 79906, 80558, 77105, 82481, 65888, 58684, 93568, 55709, 43526, 113087, 53115, 66018, 66407, 41386, 126156, 88970, 56021, 92679, 100958, 24117, 116494, 96110, 35906, 63800, 123621, 59853, 101765, 688, 86143, 56895, 53044, 111414, 36923, 126029, 72295, 60479, 85972, 57071, 59021, 43373, 77308, 87149, 110586, 102550, 18069, 82584, 28289, 48753, 61026, 74800, 13853, 127274, 35188, 78707, 52550, 34478, 3970, 54692, 47127, 38769, 47849, 109172, 116719, 122878, 62630, 48824, 109854, 81091, 135542, 64897, 81567, 93302, 67689, 54404, 27596, 125715, 100243, 64062, 97138, 102785, 118188, 66052, 42059, 82603, 59066, 57992, 121245, 132985, 60141, 37871, 95292, 108687, 71929, 72848, 106831, 108750, 43319, 86934, 47406, 96662, 123921, 91897, 52638, 14371, 26598, 112120, 103916, 98718, 127601, 52684, 106027, 78677, 68731, 56729, 93303, 46564, 91747, 112334, 117186, 6691, 58775, 79130, 81334, 91927, 94905, 122378, 99532, 59647, 111835, 126243, 61965, 106842, 73191, 80013, 99513, 53025, 91419, 60894, 43463, 107749, 74828, 105883, 66229, 91903, 83386, 84296, 58352, 84702, 37515, 121380, 7763, 107184, 84105, 40444, 35122, 97780, 115430, 106269, 98543, 95566, 38997, 136452, 55827, 120715, 99008, 92282, 52440, 133986, 123456, 112262, 104177, 91791, 121193, 79710, 92076, 73871, 47584, 104857, 65711, 82762, 79770, 111983, 81092, 134060, 89457, 48379, 81552, 98940, 56040, 111753, 44189, 113785, 700, 89367, 100059, 65680, 99380, 124549, 4980, 88803, 38670, 64387, 133410, 114785, 86133, 122212, 99441, 93365, 90703, 45952, 125754, 91632, 75623, 62828, 23601)
Run Time: 0.640022
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, 1715919205, 1715922805, {"0":["resource",36],"1":["thread",45353],"2":["thread",133733],"3":["thread",65931],"4":["thread",105330],"5":["thread",29109],"6":["thread",85081],"7":["thread",133324],"8":["thread",136137],"9":["thread",85775],"10":["thread",106594],"11":["thread",72304],"12":["thread",108395],"13":["thread",73016],"14":["thread",125074],"15":["thread",80653],"16":["thread",18346],"17":["thread",130417],"18":["thread",98703],"19":["thread",45243],"20":["thread",124808],"21":["thread",65506],"22":["thread",45476],"23":["thread",82873],"24":["thread",19839],"25":["thread",108128],"26":["thread",118988],"27":["thread",68906],"28":["thread",136532],"29":["thread",98854],"30":["thread",103709],"31":["thread",99704],"32":["thread",63372],"33":["thread",77935],"34":["thread",7749],"35":["thread",70736],"36":["thread",60700],"37":["thread",132775],"38":["thread",88046],"39":["thread",60745],"40":["thread",89606],"41":["thread",57035],"42":["thread",61250],"43":["thread",83071],"44":["thread",28172],"45":["thread",84230],"46":["thread",110830],"47":["thread",53318],"48":["thread",109127],"49":["thread",86355],"50":["thread",98711],"51":["thread",110569],"52":["thread",95262],"53":["thread",126396],"54":["thread",123928],"55":["thread",47622],"56":["thread",113430],"57":["thread",85634],"58":["thread",69139],"59":["thread",126211],"60":["thread",133861],"61":["thread",49628],"62":["thread",33299],"63":["thread",42085],"64":["thread",62946],"65":["thread",61407],"66":["thread",60448],"67":["thread",58932],"68":["thread",130809],"69":["thread",131696],"70":["thread",77069],"71":["thread",14104],"72":["thread",85328],"73":["thread",41992],"74":["thread",77516],"75":["thread",74706],"76":["thread",72797],"77":["thread",48281],"78":["thread",90570],"79":["thread",44520],"80":["thread",52154],"81":["thread",58997],"82":["thread",49881],"83":["thread",55294],"84":["thread",64305],"85":["thread",79906],"86":["thread",80558],"87":["thread",77105],"88":["thread",82481],"89":["thread",65888],"90":["thread",58684],"91":["thread",93568],"92":["thread",55709],"93":["thread",43526],"94":["thread",113087],"95":["thread",53115],"96":["thread",66018],"97":["thread",66407],"98":["thread",41386],"99":["thread",126156],"100":["thread",88970],"101":["thread",56021],"102":["thread",92679],"103":["thread",100958],"104":["thread",24117],"105":["thread",116494],"106":["thread",96110],"107":["thread",35906],"108":["thread",63800],"109":["thread",123621],"110":["thread",59853],"111":["thread",101765],"112":["thread",688],"113":["thread",86143],"114":["thread",56895],"115":["thread",53044],"116":["thread",111414],"117":["thread",36923],"118":["thread",126029],"119":["thread",72295],"120":["thread",60479],"121":["thread",85972],"122":["thread",57071],"123":["thread",59021],"124":["thread",43373],"125":["thread",77308],"126":["thread",87149],"127":["thread",110586],"128":["thread",102550],"129":["thread",18069],"130":["thread",82584],"131":["thread",28289],"132":["thread",48753],"133":["thread",61026],"134":["thread",74800],"135":["thread",13853],"136":["thread",127274],"137":["thread",35188],"138":["thread",78707],"139":["thread",52550],"140":["thread",34478],"141":["thread",3970],"142":["thread",54692],"143":["thread",47127],"144":["thread",38769],"145":["thread",47849],"146":["thread",109172],"147":["thread",116719],"148":["thread",122878],"149":["thread",62630],"150":["thread",48824],"151":["thread",109854],"152":["thread",81091],"153":["thread",135542],"154":["thread",64897],"155":["thread",81567],"156":["thread",93302],"157":["thread",67689],"158":["thread",54404],"159":["thread",27596],"160":["thread",125715],"161":["thread",100243],"162":["thread",64062],"163":["thread",97138],"164":["thread",102785],"165":["thread",118188],"166":["thread",66052],"167":["thread",42059],"168":["thread",82603],"169":["thread",59066],"170":["thread",57992],"171":["thread",121245],"172":["thread",132985],"173":["thread",60141],"174":["thread",37871],"175":["thread",95292],"176":["thread",108687],"177":["thread",71929],"178":["thread",72848],"179":["thread",106831],"180":["thread",108750],"181":["thread",43319],"182":["thread",86934],"183":["thread",47406],"184":["thread",96662],"185":["thread",123921],"186":["thread",91897],"187":["thread",52638],"188":["thread",14371],"189":["thread",26598],"190":["thread",112120],"191":["thread",103916],"192":["thread",98718],"193":["thread",127601],"194":["thread",52684],"195":["thread",106027],"196":["thread",78677],"197":["thread",68731],"198":["thread",56729],"199":["thread",93303],"200":["thread",46564],"201":["thread",91747],"202":["thread",112334],"203":["thread",117186],"204":["thread",6691],"205":["thread",58775],"206":["thread",79130],"207":["thread",81334],"208":["thread",91927],"209":["thread",94905],"210":["thread",122378],"211":["thread",99532],"212":["thread",59647],"213":["thread",111835],"214":["thread",126243],"215":["thread",61965],"216":["thread",106842],"217":["thread",73191],"218":["thread",80013],"219":["thread",99513],"220":["thread",53025],"221":["thread",91419],"222":["thread",60894],"223":["thread",43463],"224":["thread",107749],"225":["thread",74828],"226":["thread",105883],"227":["thread",66229],"228":["thread",91903],"229":["thread",83386],"230":["thread",84296],"231":["thread",58352],"232":["thread",84702],"233":["thread",37515],"234":["thread",121380],"235":["thread",7763],"236":["thread",107184],"237":["thread",84105],"238":["thread",40444],"239":["thread",35122],"240":["thread",97780],"241":["thread",115430],"242":["thread",106269],"243":["thread",98543],"244":["thread",95566],"245":["thread",38997],"246":["thread",136452],"247":["thread",55827],"248":["thread",120715],"249":["thread",99008],"250":["thread",92282],"251":["thread",52440],"252":["thread",133986],"253":["thread",123456],"254":["thread",112262],"255":["thread",104177],"256":["thread",91791],"257":["thread",121193],"258":["thread",79710],"259":["thread",92076],"260":["thread",73871],"261":["thread",47584],"262":["thread",104857],"263":["thread",65711],"264":["thread",82762],"265":["thread",79770],"266":["thread",111983],"267":["thread",81092],"268":["thread",134060],"269":["thread",89457],"270":["thread",48379],"271":["thread",81552],"272":["thread",98940],"273":["thread",56040],"274":["thread",111753],"275":["thread",44189],"276":["thread",113785],"277":["thread",700],"278":["thread",89367],"280":["thread",65680],"281":["thread",99380],"282":["thread",124549],"283":["thread",4980],"284":["thread",88803],"285":["thread",38670],"286":["thread",64387],"287":["thread",133410],"288":["thread",114785],"289":["thread",86133],"290":["thread",122212],"291":["thread",99441],"292":["thread",93365],"293":["thread",90703],"294":["thread",45952],"295":["thread",125754],"296":["thread",91632],"297":["thread",75623],"298":["thread",62828],"299":["thread",23601]}
Run Time: 0.037063
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.000076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |