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 (142270, 86144, 86893, 84178, 104209, 101849, 50033, 122678, 46564, 48311, 78392, 49958, 77418, 535, 74244, 62216, 74408, 77056, 73917, 84366, 74409, 85785, 48216, 74024, 71958, 46521, 44370, 71421, 76057, 48128, 89838, 47152, 58806, 73916, 64277, 74665, 57778, 75578, 129928, 48451, 48511, 74503, 74181, 47235, 47042, 47154, 49654, 51133, 73915, 81192, 77840, 72027, 51663, 104309, 81688, 72616, 82595, 46994, 73080, 84024, 67042, 70493, 47361, 71244, 82300, 66902, 47223, 73124, 49962, 115115, 79578, 84469, 47288, 102321, 80794, 118674, 72617, 79125, 70373, 44889, 45053, 73023, 75823, 72483, 109302, 52025, 83999, 83008, 72095, 135269, 61677, 44890, 46407, 47218, 363, 58183, 111184, 44888, 52780, 132899, 83267, 389, 70125, 113552, 21598, 420, 73551, 102640, 96574, 59141, 80988, 79766, 79581, 46415, 59136, 84485, 62278, 101147, 85667, 51945, 24436, 70431, 47357, 46744, 58387, 96707, 87383, 61731, 82571, 72097, 69698, 136170, 74608, 71934, 95051, 80359, 81782, 21260, 48300, 47276, 73761, 47788, 71785, 47785, 124297, 126780, 57265, 52519, 124459, 19659, 47363, 64593, 76995, 75197, 69745, 74051, 73125, 70305, 47081, 77917, 86814, 67960, 104260, 51540, 75784, 122777, 811, 85108, 48577, 73827, 84938, 47156, 74410, 48942, 80155, 69115, 2293, 72009, 104261, 73759, 50437, 95689, 65638, 81305, 44414, 75472, 46624, 75352, 49655, 103810, 48555, 77424, 119577, 95053, 82252, 43842, 71519, 19709, 72635, 45218, 82668, 80398, 74505, 52542, 99983, 80928, 92123, 123913, 85845, 80037, 75985, 77991, 126016, 62241, 53309, 47278, 59880, 76185, 104215, 78486, 46747, 48557, 47221, 79745, 590, 57164, 139262, 111131, 71389, 38088, 51270, 49963, 80937, 77422, 69970, 86471, 118224, 46668, 104357, 80683, 74251, 125521, 77361, 66905, 106474, 46876, 60240, 81069, 96069, 79328, 76399, 126057, 66361, 47008, 81000, 48554, 69372, 79260, 51660, 50439, 431, 47711, 78977, 47207, 49960, 50435, 44891, 85441, 87009, 86262, 63935, 104315, 58119, 59477, 80842, 68062, 71189, 61678, 26267, 115137, 47359, 52022, 82647, 74020, 78160, 81485, 73765, 77499, 74182, 70029, 87256, 47270, 74863, 95197, 77723, 86162, 132213, 64043, 65835, 85447)
Run Time: 0.062855
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: 6, 0, 1752588249, 1752591849, {"0":["thread",142270],"1":["thread",86144],"2":["thread",86893],"3":["thread",84178],"4":["thread",104209],"5":["thread",101849],"6":["thread",50033],"7":["thread",122678],"8":["thread",46564],"9":["thread",48311],"10":["thread",78392],"11":["thread",49958],"12":["thread",77418],"13":["thread",535],"14":["thread",74244],"15":["thread",62216],"16":["thread",74408],"17":["thread",77056],"18":["thread",73917],"19":["thread",84366],"20":["thread",74409],"21":["thread",85785],"22":["thread",48216],"23":["thread",74024],"24":["thread",71958],"25":["thread",46521],"26":["thread",44370],"27":["thread",71421],"28":["thread",76057],"29":["thread",48128],"30":["thread",89838],"31":["thread",47152],"32":["thread",58806],"33":["thread",73916],"34":["thread",64277],"35":["thread",74665],"36":["thread",57778],"37":["thread",75578],"38":["thread",129928],"39":["thread",48451],"40":["thread",48511],"41":["thread",74503],"42":["thread",74181],"43":["thread",47235],"44":["thread",47042],"45":["thread",47154],"46":["thread",49654],"47":["thread",51133],"48":["thread",73915],"49":["thread",81192],"50":["thread",77840],"51":["thread",72027],"52":["thread",51663],"53":["thread",104309],"54":["thread",81688],"55":["thread",72616],"56":["thread",82595],"57":["thread",46994],"58":["thread",73080],"59":["thread",84024],"60":["thread",67042],"61":["thread",70493],"62":["thread",47361],"63":["thread",71244],"64":["thread",82300],"65":["thread",66902],"66":["thread",47223],"67":["thread",73124],"68":["thread",49962],"69":["thread",115115],"70":["thread",79578],"71":["thread",84469],"72":["thread",47288],"73":["thread",102321],"74":["thread",80794],"75":["thread",118674],"76":["thread",72617],"77":["thread",79125],"78":["thread",70373],"79":["thread",44889],"80":["thread",45053],"81":["thread",73023],"82":["thread",75823],"83":["thread",72483],"84":["thread",109302],"85":["thread",52025],"86":["thread",83999],"87":["thread",83008],"88":["thread",72095],"89":["thread",135269],"90":["thread",61677],"91":["thread",44890],"92":["thread",46407],"93":["thread",47218],"95":["thread",58183],"96":["thread",111184],"97":["thread",44888],"98":["thread",52780],"99":["thread",132899],"100":["thread",83267],"101":["thread",389],"102":["thread",70125],"103":["thread",113552],"104":["thread",21598],"105":["thread",420],"106":["thread",73551],"107":["thread",102640],"108":["thread",96574],"109":["thread",59141],"110":["thread",80988],"111":["thread",79766],"112":["thread",79581],"113":["thread",46415],"114":["thread",59136],"115":["thread",84485],"116":["thread",62278],"117":["thread",101147],"118":["thread",85667],"119":["thread",51945],"120":["thread",24436],"121":["thread",70431],"122":["thread",47357],"123":["thread",46744],"124":["thread",58387],"125":["thread",96707],"126":["thread",87383],"127":["thread",61731],"128":["thread",82571],"129":["thread",72097],"130":["thread",69698],"131":["thread",136170],"132":["thread",74608],"133":["thread",71934],"134":["thread",95051],"135":["thread",80359],"136":["thread",81782],"137":["thread",21260],"138":["thread",48300],"139":["thread",47276],"140":["thread",73761],"141":["thread",47788],"142":["thread",71785],"143":["thread",47785],"144":["thread",124297],"145":["thread",126780],"146":["thread",57265],"147":["thread",52519],"148":["thread",124459],"149":["thread",19659],"150":["thread",47363],"151":["thread",64593],"152":["thread",76995],"153":["thread",75197],"154":["thread",69745],"155":["thread",74051],"156":["thread",73125],"157":["thread",70305],"158":["thread",47081],"159":["thread",77917],"160":["thread",86814],"161":["thread",67960],"162":["thread",104260],"163":["thread",51540],"164":["thread",75784],"165":["thread",122777],"166":["thread",811],"167":["thread",85108],"168":["thread",48577],"169":["thread",73827],"170":["thread",84938],"171":["thread",47156],"172":["thread",74410],"173":["thread",48942],"174":["thread",80155],"175":["thread",69115],"176":["thread",2293],"177":["thread",72009],"178":["thread",104261],"179":["thread",73759],"180":["thread",50437],"181":["thread",95689],"182":["thread",65638],"183":["thread",81305],"184":["thread",44414],"185":["thread",75472],"186":["thread",46624],"187":["thread",75352],"188":["thread",49655],"189":["thread",103810],"190":["thread",48555],"191":["thread",77424],"192":["thread",119577],"193":["thread",95053],"194":["thread",82252],"195":["thread",43842],"196":["thread",71519],"197":["thread",19709],"198":["thread",72635],"199":["thread",45218],"200":["thread",82668],"201":["thread",80398],"202":["thread",74505],"203":["thread",52542],"204":["thread",99983],"205":["thread",80928],"206":["thread",92123],"207":["thread",123913],"208":["thread",85845],"209":["thread",80037],"210":["thread",75985],"211":["thread",77991],"212":["thread",126016],"213":["thread",62241],"214":["thread",53309],"215":["thread",47278],"216":["thread",59880],"217":["thread",76185],"218":["thread",104215],"219":["thread",78486],"220":["thread",46747],"221":["thread",48557],"222":["thread",47221],"223":["thread",79745],"224":["thread",590],"225":["thread",57164],"226":["thread",139262],"227":["thread",111131],"228":["thread",71389],"229":["thread",38088],"230":["thread",51270],"231":["thread",49963],"232":["thread",80937],"233":["thread",77422],"234":["thread",69970],"235":["thread",86471],"236":["thread",118224],"237":["thread",46668],"238":["thread",104357],"239":["thread",80683],"240":["thread",74251],"241":["thread",125521],"242":["thread",77361],"243":["thread",66905],"244":["thread",106474],"245":["thread",46876],"246":["thread",60240],"247":["thread",81069],"248":["thread",96069],"249":["thread",79328],"250":["thread",76399],"251":["thread",126057],"252":["thread",66361],"253":["thread",47008],"254":["thread",81000],"255":["thread",48554],"256":["thread",69372],"257":["thread",79260],"258":["thread",51660],"259":["thread",50439],"260":["thread",431],"261":["thread",47711],"262":["thread",78977],"263":["thread",47207],"264":["thread",49960],"265":["thread",50435],"266":["thread",44891],"267":["thread",85441],"268":["thread",87009],"269":["thread",86262],"270":["thread",63935],"271":["thread",104315],"272":["thread",58119],"273":["thread",59477],"274":["thread",80842],"275":["thread",68062],"276":["thread",71189],"277":["thread",61678],"278":["thread",26267],"279":["thread",115137],"280":["thread",47359],"281":["thread",52022],"282":["thread",82647],"283":["thread",74020],"284":["thread",78160],"285":["thread",81485],"286":["thread",73765],"287":["thread",77499],"288":["thread",74182],"289":["thread",70029],"290":["thread",87256],"291":["thread",47270],"292":["thread",74863],"293":["thread",95197],"294":["thread",77723],"295":["thread",86162],"296":["thread",132213],"297":["thread",64043],"298":["thread",65835],"299":["thread",85447]}
Run Time: 0.066804
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: 1
Run Time: 0.013810
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |