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 (124175, 112049, 87514, 51389, 52370, 124077, 60933, 100408, 133387, 117523, 33078, 85776, 134222, 105131, 76698, 81552, 116719, 108078, 73526, 71284, 50343, 93442, 118726, 102773, 56827, 86015, 40565, 107873, 86700, 92743, 16166, 7011, 94324, 56441, 47409, 61564, 4845, 33758, 43854, 105015, 82064, 115443, 54664, 44011, 83585, 65656, 110954, 87972, 77516, 53025, 81035, 14371, 57984, 108731, 85258, 47498, 76360, 63430, 60562, 125715, 83386, 136878, 48824, 79535, 64166, 108950, 64571, 86143, 126411, 104421, 136257, 78430, 24117, 97577, 42761, 53040, 91531, 112023, 127777, 98703, 109854, 91140, 23184, 126851, 128882, 10030, 129684, 19839, 60387, 50714, 61836, 90900, 124125, 52233, 77502, 120994, 129050, 65607, 29858, 54883, 66018, 83468, 63483, 115840, 127274, 85135, 52422, 135542, 114472, 128878, 33307, 58124, 25402, 44161, 105374, 43118, 110736, 115223, 4630, 93832, 41718, 58194, 87125, 77738, 136254, 67979, 18069, 79841, 112690, 112007, 71305, 103293, 129973, 53116, 78682, 90108, 77484, 89085, 57940, 64972, 112504, 122221, 131914, 88203, 70306, 125748, 57452, 112550, 47306, 66194, 72649, 117918, 91381, 120047, 66232, 70526, 25581, 87920, 73627, 38999, 83830, 41290, 99567, 114785, 67826, 111255, 105819, 119274, 52487, 84094, 63344, 92584, 91529, 128111, 70969, 135393, 41066, 119559, 129206, 87170, 133248, 89008, 92679, 101083, 80438, 61603, 26308, 111983, 113134, 74800, 100474, 97587, 103756, 86417, 50155, 64136, 56254, 59054, 128079, 18727, 132204, 116742, 98919, 129053, 67951, 81717, 84737, 87625, 101465, 99704, 48815, 63427, 74592, 114065, 71222, 63965, 100922, 79612, 117694, 59593, 75129, 65104, 54345, 70755, 94786, 25240, 113145, 126559, 97620, 66862, 37515, 65294, 118969, 32642, 82430, 37687, 688, 81874, 113287, 64699, 41588, 13081, 60479, 88946, 134158, 94211, 87902, 6881, 63819, 35559, 81876, 112817, 57698, 21593, 109912, 33790, 129094, 91903, 52206, 127545, 63256, 131745, 104148, 91480, 18386, 101765, 100511, 67315, 79675, 125075, 102501, 100173, 86177, 86133, 83547, 84925, 68246, 67665, 132928, 78978, 55121, 124393, 129508, 96640, 14797, 53964, 43271, 90389, 37148, 127028, 93303, 36997, 46254, 68115, 90916, 128147, 60244, 71902, 49942)
Run Time: 0.073514
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, 1715355983, 1715359583, {"0":["resource",36],"1":["thread",124175],"2":["thread",112049],"3":["thread",87514],"4":["thread",51389],"5":["thread",52370],"6":["thread",124077],"7":["thread",60933],"8":["thread",100408],"9":["thread",133387],"10":["thread",117523],"11":["thread",33078],"12":["thread",85776],"13":["thread",134222],"14":["thread",105131],"15":["thread",76698],"16":["thread",81552],"17":["thread",116719],"18":["thread",108078],"19":["thread",73526],"20":["thread",71284],"21":["thread",50343],"22":["thread",93442],"23":["thread",118726],"24":["thread",102773],"25":["thread",56827],"27":["thread",40565],"28":["thread",107873],"29":["thread",86700],"30":["thread",92743],"31":["thread",16166],"32":["thread",7011],"33":["thread",94324],"34":["thread",56441],"35":["thread",47409],"36":["thread",61564],"37":["thread",4845],"38":["thread",33758],"39":["thread",43854],"40":["thread",105015],"41":["thread",82064],"42":["thread",115443],"43":["thread",54664],"44":["thread",44011],"45":["thread",83585],"46":["thread",65656],"47":["thread",110954],"48":["thread",87972],"49":["thread",77516],"50":["thread",53025],"51":["thread",81035],"52":["thread",14371],"53":["thread",57984],"54":["thread",108731],"55":["thread",85258],"56":["thread",47498],"57":["thread",76360],"58":["thread",63430],"59":["thread",60562],"60":["thread",125715],"61":["thread",83386],"62":["thread",136878],"63":["thread",48824],"64":["thread",79535],"65":["thread",64166],"66":["thread",108950],"67":["thread",64571],"68":["thread",86143],"69":["thread",126411],"70":["thread",104421],"71":["thread",136257],"72":["thread",78430],"73":["thread",24117],"74":["thread",97577],"75":["thread",42761],"76":["thread",53040],"77":["thread",91531],"78":["thread",112023],"79":["thread",127777],"80":["thread",98703],"81":["thread",109854],"82":["thread",91140],"83":["thread",23184],"84":["thread",126851],"85":["thread",128882],"86":["thread",10030],"87":["thread",129684],"88":["thread",19839],"89":["thread",60387],"90":["thread",50714],"91":["thread",61836],"92":["thread",90900],"93":["thread",124125],"94":["thread",52233],"95":["thread",77502],"96":["thread",120994],"97":["thread",129050],"98":["thread",65607],"99":["thread",29858],"100":["thread",54883],"101":["thread",66018],"102":["thread",83468],"103":["thread",63483],"104":["thread",115840],"105":["thread",127274],"106":["thread",85135],"107":["thread",52422],"108":["thread",135542],"109":["thread",114472],"110":["thread",128878],"111":["thread",33307],"112":["thread",58124],"113":["thread",25402],"114":["thread",44161],"115":["thread",105374],"116":["thread",43118],"117":["thread",110736],"118":["thread",115223],"119":["thread",4630],"120":["thread",93832],"121":["thread",41718],"122":["thread",58194],"123":["thread",87125],"124":["thread",77738],"125":["thread",136254],"126":["thread",67979],"127":["thread",18069],"128":["thread",79841],"129":["thread",112690],"130":["thread",112007],"131":["thread",71305],"132":["thread",103293],"133":["thread",129973],"134":["thread",53116],"135":["thread",78682],"136":["thread",90108],"137":["thread",77484],"138":["thread",89085],"139":["thread",57940],"140":["thread",64972],"141":["thread",112504],"142":["thread",122221],"143":["thread",131914],"144":["thread",88203],"145":["thread",70306],"146":["thread",125748],"147":["thread",57452],"148":["thread",112550],"149":["thread",47306],"150":["thread",66194],"151":["thread",72649],"152":["thread",117918],"153":["thread",91381],"154":["thread",120047],"155":["thread",66232],"156":["thread",70526],"157":["thread",25581],"158":["thread",87920],"159":["thread",73627],"160":["thread",38999],"161":["thread",83830],"162":["thread",41290],"163":["thread",99567],"164":["thread",114785],"165":["thread",67826],"166":["thread",111255],"167":["thread",105819],"168":["thread",119274],"169":["thread",52487],"170":["thread",84094],"171":["thread",63344],"172":["thread",92584],"173":["thread",91529],"174":["thread",128111],"175":["thread",70969],"176":["thread",135393],"177":["thread",41066],"178":["thread",119559],"179":["thread",129206],"180":["thread",87170],"181":["thread",133248],"182":["thread",89008],"183":["thread",92679],"184":["thread",101083],"185":["thread",80438],"186":["thread",61603],"187":["thread",26308],"188":["thread",111983],"189":["thread",113134],"190":["thread",74800],"191":["thread",100474],"192":["thread",97587],"193":["thread",103756],"194":["thread",86417],"195":["thread",50155],"196":["thread",64136],"197":["thread",56254],"198":["thread",59054],"199":["thread",128079],"200":["thread",18727],"201":["thread",132204],"202":["thread",116742],"203":["thread",98919],"204":["thread",129053],"205":["thread",67951],"206":["thread",81717],"207":["thread",84737],"208":["thread",87625],"209":["thread",101465],"210":["thread",99704],"211":["thread",48815],"212":["thread",63427],"213":["thread",74592],"214":["thread",114065],"215":["thread",71222],"216":["thread",63965],"217":["thread",100922],"218":["thread",79612],"219":["thread",117694],"220":["thread",59593],"221":["thread",75129],"222":["thread",65104],"223":["thread",54345],"224":["thread",70755],"225":["thread",94786],"226":["thread",25240],"227":["thread",113145],"228":["thread",126559],"229":["thread",97620],"230":["thread",66862],"231":["thread",37515],"232":["thread",65294],"233":["thread",118969],"234":["thread",32642],"235":["thread",82430],"236":["thread",37687],"237":["thread",688],"238":["thread",81874],"239":["thread",113287],"240":["thread",64699],"241":["thread",41588],"242":["thread",13081],"243":["thread",60479],"244":["thread",88946],"245":["thread",134158],"246":["thread",94211],"247":["thread",87902],"248":["thread",6881],"249":["thread",63819],"250":["thread",35559],"251":["thread",81876],"252":["thread",112817],"253":["thread",57698],"254":["thread",21593],"255":["thread",109912],"256":["thread",33790],"257":["thread",129094],"258":["thread",91903],"259":["thread",52206],"260":["thread",127545],"261":["thread",63256],"262":["thread",131745],"263":["thread",104148],"264":["thread",91480],"265":["thread",18386],"266":["thread",101765],"267":["thread",100511],"268":["thread",67315],"269":["thread",79675],"270":["thread",125075],"271":["thread",102501],"272":["thread",100173],"273":["thread",86177],"274":["thread",86133],"275":["thread",83547],"276":["thread",84925],"277":["thread",68246],"278":["thread",67665],"279":["thread",132928],"280":["thread",78978],"281":["thread",55121],"282":["thread",124393],"283":["thread",129508],"284":["thread",96640],"285":["thread",14797],"286":["thread",53964],"287":["thread",43271],"288":["thread",90389],"289":["thread",37148],"290":["thread",127028],"291":["thread",93303],"292":["thread",36997],"293":["thread",46254],"294":["thread",68115],"295":["thread",90916],"296":["thread",128147],"297":["thread",60244],"298":["thread",71902],"299":["thread",49942]}
Run Time: 0.015299
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 |