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 (84246, 79441, 96163, 95910, 86364, 99392, 92898, 26325, 110076, 121988, 112793, 74985, 67136, 129572, 135621, 65887, 111334, 74865, 116939, 81459, 61293, 86943, 103776, 106913, 111440, 136199, 127844, 82964, 87394, 41285, 96615, 99967, 78216, 109795, 70653, 81136, 75576, 117458, 90545, 73299, 111734, 363, 118745, 1402, 95753, 106208, 105615, 96357, 73765, 133134, 75626, 93755, 42497, 131802, 68435, 123583, 13591, 67908, 97623, 109616, 96044, 127405, 110023, 97396, 111391, 79907, 90286, 103765, 122253, 108188, 1354, 127771, 81991, 114741, 132093, 99765, 97628, 37740, 81297, 134614, 58365, 134169, 109832, 95535, 107520, 126585, 125854, 16385, 68853, 76514, 83102, 97815, 114091, 68117, 95669, 137177, 79693, 83892, 67787, 89411, 37219, 85530, 109955, 23249, 101445, 67890, 68181, 69886, 92116, 66606, 108890, 96034, 97049, 95908, 128877, 62502, 74128, 76330, 107855, 59739, 88513, 66484, 68001, 61438, 118715, 33656, 123030, 66299, 127231, 72958, 137300, 74245, 92468, 135576, 101400, 113765, 65538, 80730, 129855, 68260, 98875, 87995, 69132, 74125, 91540, 73543, 21598, 108618, 91751, 105104, 105300, 96353, 67851, 112255, 114463, 97307, 1398, 72486, 73620, 107570, 113256, 76399, 81461, 96033, 70351, 107730, 1365, 67424, 94316, 438, 73470, 63772, 79442, 90530, 67475, 64850, 130548, 119560, 92513, 115594, 109573, 108277, 132284, 66617, 104803, 118704, 83193, 34500, 108036, 75737, 104434, 60238, 107147, 97653, 128800, 122542, 76240, 75145, 83164, 68757, 74809, 123804, 96528, 107614, 105103, 75784, 97629, 91956, 112649, 76513, 70077, 73823, 68303, 135230, 134975, 89265, 65923, 134089, 74406, 129573, 67318, 67839, 76702, 82001, 66226, 122771, 113784, 98385, 110892, 125862, 111332, 124932, 99915, 98538, 109471, 120077, 114742, 1360, 117456, 134984, 97302, 78535, 77394, 102420, 21337, 75578, 108229, 66683, 103667, 81169, 113028, 53327, 121020, 137134, 52207, 77525, 91336, 103768, 123673, 106762, 78376, 132005, 457, 69128, 137299, 66005, 68016, 115079, 118639, 92040, 72946, 822, 68528, 90809, 70477, 136201, 134892, 137175, 109357, 79849, 88477, 95666, 109572, 112112, 80457, 60762, 118829, 104593, 107844, 112281, 22151, 74051, 80058, 77361, 75198, 104649, 131109, 98143, 112965, 69558)
Run Time: 0.034256
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: 5, 0, 1716757158, 1716760758, {"0":["thread",84246],"1":["thread",79441],"2":["thread",96163],"3":["thread",95910],"4":["thread",86364],"5":["thread",99392],"6":["thread",92898],"7":["thread",26325],"8":["thread",110076],"9":["thread",121988],"10":["thread",112793],"11":["thread",74985],"12":["thread",67136],"13":["thread",129572],"14":["thread",135621],"15":["thread",65887],"16":["thread",111334],"17":["thread",74865],"18":["thread",116939],"19":["thread",81459],"20":["thread",61293],"21":["thread",86943],"22":["thread",103776],"23":["thread",106913],"24":["thread",111440],"25":["thread",136199],"26":["thread",127844],"27":["thread",82964],"28":["thread",87394],"29":["thread",41285],"30":["thread",96615],"31":["thread",99967],"32":["thread",78216],"33":["thread",109795],"34":["thread",70653],"35":["thread",81136],"36":["thread",75576],"37":["thread",117458],"38":["thread",90545],"39":["thread",73299],"40":["thread",111734],"42":["thread",118745],"43":["thread",1402],"44":["thread",95753],"45":["thread",106208],"46":["thread",105615],"47":["thread",96357],"48":["thread",73765],"49":["thread",133134],"50":["thread",75626],"51":["thread",93755],"52":["thread",42497],"53":["thread",131802],"54":["thread",68435],"55":["thread",123583],"56":["thread",13591],"57":["thread",67908],"58":["thread",97623],"59":["thread",109616],"60":["thread",96044],"61":["thread",127405],"62":["thread",110023],"63":["thread",97396],"64":["thread",111391],"65":["thread",79907],"66":["thread",90286],"67":["thread",103765],"68":["thread",122253],"69":["thread",108188],"70":["thread",1354],"71":["thread",127771],"72":["thread",81991],"73":["thread",114741],"74":["thread",132093],"75":["thread",99765],"76":["thread",97628],"77":["thread",37740],"78":["thread",81297],"79":["thread",134614],"80":["thread",58365],"81":["thread",134169],"82":["thread",109832],"83":["thread",95535],"84":["thread",107520],"85":["thread",126585],"86":["thread",125854],"87":["thread",16385],"88":["thread",68853],"89":["thread",76514],"90":["thread",83102],"91":["thread",97815],"92":["thread",114091],"93":["thread",68117],"94":["thread",95669],"95":["thread",137177],"96":["thread",79693],"97":["thread",83892],"98":["thread",67787],"99":["thread",89411],"100":["thread",37219],"101":["thread",85530],"102":["thread",109955],"103":["thread",23249],"104":["thread",101445],"105":["thread",67890],"106":["thread",68181],"107":["thread",69886],"108":["thread",92116],"109":["thread",66606],"110":["thread",108890],"111":["thread",96034],"112":["thread",97049],"113":["thread",95908],"114":["thread",128877],"115":["thread",62502],"116":["thread",74128],"117":["thread",76330],"118":["thread",107855],"119":["thread",59739],"120":["thread",88513],"121":["thread",66484],"122":["thread",68001],"123":["thread",61438],"124":["thread",118715],"125":["thread",33656],"126":["thread",123030],"127":["thread",66299],"128":["thread",127231],"129":["thread",72958],"130":["thread",137300],"131":["thread",74245],"132":["thread",92468],"133":["thread",135576],"134":["thread",101400],"135":["thread",113765],"136":["thread",65538],"137":["thread",80730],"138":["thread",129855],"139":["thread",68260],"140":["thread",98875],"141":["thread",87995],"142":["thread",69132],"143":["thread",74125],"144":["thread",91540],"145":["thread",73543],"146":["thread",21598],"147":["thread",108618],"148":["thread",91751],"149":["thread",105104],"150":["thread",105300],"151":["thread",96353],"152":["thread",67851],"153":["thread",112255],"154":["thread",114463],"155":["thread",97307],"156":["thread",1398],"157":["thread",72486],"158":["thread",73620],"159":["thread",107570],"160":["thread",113256],"161":["thread",76399],"162":["thread",81461],"163":["thread",96033],"164":["thread",70351],"165":["thread",107730],"166":["thread",1365],"167":["thread",67424],"168":["thread",94316],"169":["thread",438],"170":["thread",73470],"171":["thread",63772],"172":["thread",79442],"173":["thread",90530],"174":["thread",67475],"175":["thread",64850],"176":["thread",130548],"177":["thread",119560],"178":["thread",92513],"179":["thread",115594],"180":["thread",109573],"181":["thread",108277],"182":["thread",132284],"183":["thread",66617],"184":["thread",104803],"185":["thread",118704],"186":["thread",83193],"187":["thread",34500],"188":["thread",108036],"189":["thread",75737],"190":["thread",104434],"191":["thread",60238],"192":["thread",107147],"193":["thread",97653],"194":["thread",128800],"195":["thread",122542],"196":["thread",76240],"197":["thread",75145],"198":["thread",83164],"199":["thread",68757],"200":["thread",74809],"201":["thread",123804],"202":["thread",96528],"203":["thread",107614],"204":["thread",105103],"205":["thread",75784],"206":["thread",97629],"207":["thread",91956],"208":["thread",112649],"209":["thread",76513],"210":["thread",70077],"211":["thread",73823],"212":["thread",68303],"213":["thread",135230],"214":["thread",134975],"215":["thread",89265],"216":["thread",65923],"217":["thread",134089],"218":["thread",74406],"219":["thread",129573],"220":["thread",67318],"221":["thread",67839],"222":["thread",76702],"223":["thread",82001],"224":["thread",66226],"225":["thread",122771],"226":["thread",113784],"227":["thread",98385],"228":["thread",110892],"229":["thread",125862],"230":["thread",111332],"231":["thread",124932],"232":["thread",99915],"233":["thread",98538],"234":["thread",109471],"235":["thread",120077],"236":["thread",114742],"237":["thread",1360],"238":["thread",117456],"239":["thread",134984],"240":["thread",97302],"241":["thread",78535],"242":["thread",77394],"243":["thread",102420],"244":["thread",21337],"245":["thread",75578],"246":["thread",108229],"247":["thread",66683],"248":["thread",103667],"249":["thread",81169],"250":["thread",113028],"251":["thread",53327],"252":["thread",121020],"253":["thread",137134],"254":["thread",52207],"255":["thread",77525],"256":["thread",91336],"257":["thread",103768],"258":["thread",123673],"259":["thread",106762],"260":["thread",78376],"261":["thread",132005],"262":["thread",457],"263":["thread",69128],"264":["thread",137299],"265":["thread",66005],"266":["thread",68016],"267":["thread",115079],"268":["thread",118639],"269":["thread",92040],"270":["thread",72946],"271":["thread",822],"272":["thread",68528],"273":["thread",90809],"274":["thread",70477],"275":["thread",136201],"276":["thread",134892],"277":["thread",137175],"278":["thread",109357],"279":["thread",79849],"280":["thread",88477],"281":["thread",95666],"282":["thread",109572],"283":["thread",112112],"284":["thread",80457],"285":["thread",60762],"286":["thread",118829],"287":["thread",104593],"288":["thread",107844],"289":["thread",112281],"290":["thread",22151],"291":["thread",74051],"292":["thread",80058],"293":["thread",77361],"294":["thread",75198],"295":["thread",104649],"296":["thread",131109],"297":["thread",98143],"298":["thread",112965],"299":["thread",69558]}
Run Time: 0.000967
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |