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 (81119, 103313, 91894, 50153, 66744, 25849, 76230, 592, 1218, 47918, 98042, 104970, 81657, 789, 44011, 83332, 79270, 103596, 77955, 134713, 79877, 91904, 79228, 74923, 51117, 120395, 85060, 80098, 102481, 316, 83648, 76288, 79873, 648, 121538, 74085, 109748, 123881, 76216, 104428, 81713, 91427, 81850, 89624, 115292, 72439, 117239, 95662, 100622, 79709, 83759, 75540, 78191, 81588, 115371, 65058, 97235, 82070, 83739, 75194, 78607, 51087, 76213, 78411, 123210, 74582, 79911, 78232, 112411, 99374, 105133, 78615, 78335, 101093, 74602, 80097, 114061, 109171, 134414, 81397, 79173, 98561, 93236, 74437, 79271, 83675, 116866, 90466, 92069, 121320, 83609, 50285, 81951, 608, 17853, 87076, 81805, 1884, 26960, 127733, 76714, 76999, 75760, 116380, 81079, 101786, 75986, 11221, 77921, 79981, 104154, 77022, 119887, 78339, 80095, 71901, 95531, 74752, 95025, 103461, 79169, 81879, 116501, 81231, 76713, 121577, 80911, 77238, 77298, 94576, 44502, 115349, 121616, 76755, 75632, 122402, 109760, 117502, 120400, 121571, 74816, 109547, 76639, 120215, 49835, 51141, 76025, 77041, 114446, 90076, 75323, 11332, 74917, 93520, 74981, 107648, 78314, 81984, 78407, 80016, 103363, 77089, 90814, 107523, 111898, 95489, 1276, 120124, 66720, 99587, 120512, 74670, 65268, 81981, 53235, 76259, 78259, 107643, 79296, 78769, 80056, 116781, 95855, 80537, 12060, 92631, 498, 55187, 83449, 74613, 116195, 51576, 93120, 123495, 117848, 76472, 123079, 120470, 44589, 80170, 74498, 78464, 93699, 78656, 89552, 72904, 107186, 98783, 105265, 78234, 33376, 119986, 81584, 95261, 95983, 93552, 107617, 1169, 78698, 81664, 128759, 896, 94467, 120218, 120103, 72778, 128636, 12569, 81965, 75262, 95090, 97124, 77018, 98154, 108591, 81690, 81527, 120296, 40715, 79291, 81551, 50649, 124498, 104094, 119888, 119929, 51091, 97717, 136055, 94411, 68834, 107777, 90331, 81808, 120521, 66721, 82023, 109688, 79420, 113961, 79471, 49939, 128663, 120396, 51126, 77340, 114214, 75497, 121557, 121679, 75514, 81393, 75465, 80633, 93732, 77467, 542, 116137, 81998, 904, 117199, 128791, 83563, 76764, 105921, 110099, 79404, 81487, 120363, 123732, 82744, 45333, 97373, 75483, 102177, 108967, 51238, 94668, 121063, 76531)
Run Time: 0.021094
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: 61, 0, 1713462697, 1713466297, {"0":["thread",81119],"1":["thread",103313],"2":["thread",91894],"3":["thread",50153],"4":["thread",66744],"5":["thread",25849],"6":["thread",76230],"7":["thread",592],"8":["thread",1218],"9":["thread",47918],"10":["thread",98042],"11":["thread",104970],"12":["thread",81657],"13":["thread",789],"14":["thread",44011],"15":["thread",83332],"16":["thread",79270],"17":["thread",103596],"18":["thread",77955],"19":["thread",134713],"20":["thread",79877],"21":["thread",91904],"22":["thread",79228],"23":["thread",74923],"24":["thread",51117],"25":["thread",120395],"26":["thread",85060],"27":["thread",80098],"28":["thread",102481],"29":["thread",316],"30":["thread",83648],"31":["thread",76288],"32":["thread",79873],"33":["thread",648],"34":["thread",121538],"35":["thread",74085],"36":["thread",109748],"37":["thread",123881],"38":["thread",76216],"39":["thread",104428],"40":["thread",81713],"41":["thread",91427],"42":["thread",81850],"43":["thread",89624],"44":["thread",115292],"45":["thread",72439],"46":["thread",117239],"47":["thread",95662],"48":["thread",100622],"49":["thread",79709],"50":["thread",83759],"51":["thread",75540],"52":["thread",78191],"53":["thread",81588],"54":["thread",115371],"55":["thread",65058],"56":["thread",97235],"57":["thread",82070],"58":["thread",83739],"59":["thread",75194],"60":["thread",78607],"61":["thread",51087],"62":["thread",76213],"63":["thread",78411],"64":["thread",123210],"65":["thread",74582],"66":["thread",79911],"67":["thread",78232],"68":["thread",112411],"69":["thread",99374],"70":["thread",105133],"71":["thread",78615],"72":["thread",78335],"73":["thread",101093],"74":["thread",74602],"75":["thread",80097],"76":["thread",114061],"77":["thread",109171],"78":["thread",134414],"79":["thread",81397],"80":["thread",79173],"81":["thread",98561],"82":["thread",93236],"83":["thread",74437],"84":["thread",79271],"85":["thread",83675],"86":["thread",116866],"87":["thread",90466],"88":["thread",92069],"89":["thread",121320],"90":["thread",83609],"91":["thread",50285],"92":["thread",81951],"93":["thread",608],"94":["thread",17853],"95":["thread",87076],"96":["thread",81805],"97":["thread",1884],"98":["thread",26960],"99":["thread",127733],"100":["thread",76714],"101":["thread",76999],"102":["thread",75760],"103":["thread",116380],"104":["thread",81079],"105":["thread",101786],"106":["thread",75986],"107":["thread",11221],"108":["thread",77921],"109":["thread",79981],"110":["thread",104154],"111":["thread",77022],"112":["thread",119887],"113":["thread",78339],"114":["thread",80095],"115":["thread",71901],"116":["thread",95531],"117":["thread",74752],"118":["thread",95025],"119":["thread",103461],"120":["thread",79169],"121":["thread",81879],"122":["thread",116501],"123":["thread",81231],"124":["thread",76713],"125":["thread",121577],"126":["thread",80911],"127":["thread",77238],"128":["thread",77298],"129":["thread",94576],"130":["thread",44502],"131":["thread",115349],"132":["thread",121616],"133":["thread",76755],"134":["thread",75632],"135":["thread",122402],"136":["thread",109760],"137":["thread",117502],"138":["thread",120400],"139":["thread",121571],"140":["thread",74816],"141":["thread",109547],"142":["thread",76639],"143":["thread",120215],"144":["thread",49835],"145":["thread",51141],"146":["thread",76025],"147":["thread",77041],"148":["thread",114446],"149":["thread",90076],"150":["thread",75323],"151":["thread",11332],"152":["thread",74917],"153":["thread",93520],"154":["thread",74981],"155":["thread",107648],"156":["thread",78314],"157":["thread",81984],"158":["thread",78407],"159":["thread",80016],"160":["thread",103363],"161":["thread",77089],"162":["thread",90814],"163":["thread",107523],"164":["thread",111898],"165":["thread",95489],"166":["thread",1276],"167":["thread",120124],"168":["thread",66720],"169":["thread",99587],"170":["thread",120512],"171":["thread",74670],"172":["thread",65268],"173":["thread",81981],"174":["thread",53235],"175":["thread",76259],"176":["thread",78259],"177":["thread",107643],"178":["thread",79296],"179":["thread",78769],"180":["thread",80056],"181":["thread",116781],"182":["thread",95855],"183":["thread",80537],"184":["thread",12060],"185":["thread",92631],"186":["thread",498],"187":["thread",55187],"188":["thread",83449],"189":["thread",74613],"190":["thread",116195],"191":["thread",51576],"192":["thread",93120],"193":["thread",123495],"194":["thread",117848],"195":["thread",76472],"196":["thread",123079],"197":["thread",120470],"198":["thread",44589],"199":["thread",80170],"200":["thread",74498],"201":["thread",78464],"202":["thread",93699],"203":["thread",78656],"204":["thread",89552],"205":["thread",72904],"206":["thread",107186],"207":["thread",98783],"208":["thread",105265],"209":["thread",78234],"210":["thread",33376],"211":["thread",119986],"212":["thread",81584],"213":["thread",95261],"214":["thread",95983],"215":["thread",93552],"216":["thread",107617],"217":["thread",1169],"218":["thread",78698],"219":["thread",81664],"220":["thread",128759],"221":["thread",896],"222":["thread",94467],"223":["thread",120218],"224":["thread",120103],"225":["thread",72778],"226":["thread",128636],"227":["thread",12569],"228":["thread",81965],"229":["thread",75262],"230":["thread",95090],"231":["thread",97124],"232":["thread",77018],"233":["thread",98154],"234":["thread",108591],"235":["thread",81690],"236":["thread",81527],"237":["thread",120296],"238":["thread",40715],"239":["thread",79291],"240":["thread",81551],"241":["thread",50649],"242":["thread",124498],"243":["thread",104094],"244":["thread",119888],"245":["thread",119929],"246":["thread",51091],"247":["thread",97717],"248":["thread",136055],"249":["thread",94411],"250":["thread",68834],"251":["thread",107777],"252":["thread",90331],"253":["thread",81808],"254":["thread",120521],"255":["thread",66721],"256":["thread",82023],"257":["thread",109688],"258":["thread",79420],"259":["thread",113961],"260":["thread",79471],"261":["thread",49939],"262":["thread",128663],"263":["thread",120396],"264":["thread",51126],"265":["thread",77340],"266":["thread",114214],"267":["thread",75497],"268":["thread",121557],"269":["thread",121679],"270":["thread",75514],"271":["thread",81393],"272":["thread",75465],"273":["thread",80633],"274":["thread",93732],"275":["thread",77467],"276":["thread",542],"277":["thread",116137],"278":["thread",81998],"279":["thread",904],"280":["thread",117199],"281":["thread",128791],"282":["thread",83563],"283":["thread",76764],"284":["thread",105921],"285":["thread",110099],"287":["thread",81487],"288":["thread",120363],"289":["thread",123732],"290":["thread",82744],"291":["thread",45333],"292":["thread",97373],"293":["thread",75483],"294":["thread",102177],"295":["thread",108967],"296":["thread",51238],"297":["thread",94668],"298":["thread",121063],"299":["thread",76531]}
Run Time: 0.001276
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 |