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 (52780, 11298, 70125, 85785, 74891, 94804, 71461, 78390, 76330, 118674, 57778, 87009, 46247, 50437, 79581, 72714, 69550, 73553, 104260, 46621, 46876, 71934, 57109, 119576, 44465, 123805, 51660, 48300, 50033, 47715, 44440, 49958, 44371, 82668, 45925, 63935, 74126, 47672, 40107, 46744, 72040, 104380, 47783, 85789, 82300, 79336, 80515, 46528, 91985, 126016, 46415, 86278, 88349, 76516, 50436, 51220, 98478, 51945, 45218, 77295, 47154, 52468, 81960, 59140, 77056, 71244, 48217, 47959, 98683, 48131, 83613, 85621, 48449, 72737, 80359, 95053, 48052, 59583, 48128, 83211, 86471, 67108, 9888, 59141, 51662, 64192, 67960, 58818, 74051, 135269, 68062, 112386, 35059, 53015, 73822, 87028, 76514, 52542, 82647, 63712, 49760, 86160, 46407, 2293, 58253, 72483, 36071, 86295, 52519, 104357, 33954, 82758, 74019, 77974, 78448, 71105, 84464, 71358, 83718, 46524, 71785, 124297, 104066, 71958, 100488, 71998, 118225, 45058, 72580, 73080, 58241, 81501, 73912, 79690, 77301, 52631, 38088, 40105, 77842, 73915, 47694, 72288, 77525, 47713, 80966, 81853, 77066, 80557, 71389, 47287, 111131, 58339, 25920, 83913, 80792, 104004, 84070, 73724, 61445, 59477, 58806, 94757, 58365, 47218, 85845, 37565, 73827, 86670, 67042, 63672, 46190, 86140, 80937, 71421, 48509, 101147, 44367, 98913, 51270, 48510, 75203, 77591, 69903, 102447, 61678, 75578, 59880, 104071, 70431, 70696, 71213, 81192, 72735, 124459, 73763, 76118, 48218, 47081, 46522, 44804, 47006, 74130, 88105, 46186, 74244, 71187, 47224, 46813, 68101, 81359, 78486, 74156, 69944, 75985, 47288, 70975, 66361, 72595, 71519, 78042, 73760, 49576, 85793, 77424, 48079, 83546, 119565, 47359, 47924, 46618, 48465, 72038, 74863, 77418, 112672, 70854, 47235, 49761, 48215, 80928, 80988, 48467, 79570, 73916, 78089, 95051, 97080, 47711, 75472, 77917, 85447, 44556, 85441, 59142, 74409, 102285, 46296, 119577, 363, 69965, 66861, 48559, 129928, 46192, 75155, 74024, 49960, 81869, 81481, 48306, 74503, 69934, 47039, 72635, 65835, 56047, 44891, 70373, 77991, 73328, 74665, 67062, 64277, 76411, 87383, 81489, 57779, 76399, 71420, 59134, 86464, 95901, 74182, 70082, 74251, 84000, 72617, 811, 61224, 46994)
Run Time: 0.176562
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, 1715397416, 1715401016, {"0":["thread",52780],"1":["thread",11298],"2":["thread",70125],"3":["thread",85785],"4":["thread",74891],"5":["thread",94804],"6":["thread",71461],"7":["thread",78390],"8":["thread",76330],"9":["thread",118674],"10":["thread",57778],"11":["thread",87009],"12":["thread",46247],"13":["thread",50437],"14":["thread",79581],"15":["thread",72714],"16":["thread",69550],"17":["thread",73553],"18":["thread",104260],"19":["thread",46621],"20":["thread",46876],"21":["thread",71934],"22":["thread",57109],"23":["thread",119576],"24":["thread",44465],"25":["thread",123805],"26":["thread",51660],"27":["thread",48300],"28":["thread",50033],"29":["thread",47715],"30":["thread",44440],"31":["thread",49958],"32":["thread",44371],"33":["thread",82668],"34":["thread",45925],"35":["thread",63935],"36":["thread",74126],"37":["thread",47672],"38":["thread",40107],"39":["thread",46744],"40":["thread",72040],"41":["thread",104380],"42":["thread",47783],"43":["thread",85789],"44":["thread",82300],"45":["thread",79336],"46":["thread",80515],"47":["thread",46528],"48":["thread",91985],"49":["thread",126016],"50":["thread",46415],"51":["thread",86278],"52":["thread",88349],"53":["thread",76516],"54":["thread",50436],"55":["thread",51220],"56":["thread",98478],"57":["thread",51945],"58":["thread",45218],"59":["thread",77295],"60":["thread",47154],"61":["thread",52468],"62":["thread",81960],"63":["thread",59140],"64":["thread",77056],"65":["thread",71244],"66":["thread",48217],"67":["thread",47959],"68":["thread",98683],"69":["thread",48131],"70":["thread",83613],"71":["thread",85621],"72":["thread",48449],"73":["thread",72737],"74":["thread",80359],"75":["thread",95053],"76":["thread",48052],"77":["thread",59583],"78":["thread",48128],"79":["thread",83211],"80":["thread",86471],"81":["thread",67108],"82":["thread",9888],"83":["thread",59141],"84":["thread",51662],"85":["thread",64192],"86":["thread",67960],"87":["thread",58818],"88":["thread",74051],"89":["thread",135269],"90":["thread",68062],"91":["thread",112386],"92":["thread",35059],"93":["thread",53015],"94":["thread",73822],"95":["thread",87028],"96":["thread",76514],"97":["thread",52542],"98":["thread",82647],"99":["thread",63712],"100":["thread",49760],"101":["thread",86160],"102":["thread",46407],"103":["thread",2293],"104":["thread",58253],"105":["thread",72483],"106":["thread",36071],"107":["thread",86295],"108":["thread",52519],"109":["thread",104357],"110":["thread",33954],"111":["thread",82758],"112":["thread",74019],"113":["thread",77974],"114":["thread",78448],"115":["thread",71105],"116":["thread",84464],"117":["thread",71358],"118":["thread",83718],"119":["thread",46524],"120":["thread",71785],"121":["thread",124297],"122":["thread",104066],"123":["thread",71958],"124":["thread",100488],"125":["thread",71998],"126":["thread",118225],"127":["thread",45058],"128":["thread",72580],"129":["thread",73080],"130":["thread",58241],"131":["thread",81501],"132":["thread",73912],"133":["thread",79690],"134":["thread",77301],"135":["thread",52631],"136":["thread",38088],"137":["thread",40105],"138":["thread",77842],"139":["thread",73915],"140":["thread",47694],"141":["thread",72288],"142":["thread",77525],"143":["thread",47713],"144":["thread",80966],"145":["thread",81853],"146":["thread",77066],"147":["thread",80557],"148":["thread",71389],"149":["thread",47287],"150":["thread",111131],"151":["thread",58339],"152":["thread",25920],"153":["thread",83913],"154":["thread",80792],"155":["thread",104004],"156":["thread",84070],"157":["thread",73724],"158":["thread",61445],"159":["thread",59477],"160":["thread",58806],"161":["thread",94757],"162":["thread",58365],"163":["thread",47218],"164":["thread",85845],"165":["thread",37565],"166":["thread",73827],"167":["thread",86670],"168":["thread",67042],"169":["thread",63672],"170":["thread",46190],"171":["thread",86140],"172":["thread",80937],"173":["thread",71421],"174":["thread",48509],"175":["thread",101147],"176":["thread",44367],"177":["thread",98913],"178":["thread",51270],"179":["thread",48510],"180":["thread",75203],"181":["thread",77591],"182":["thread",69903],"183":["thread",102447],"184":["thread",61678],"185":["thread",75578],"186":["thread",59880],"187":["thread",104071],"188":["thread",70431],"189":["thread",70696],"190":["thread",71213],"191":["thread",81192],"192":["thread",72735],"193":["thread",124459],"194":["thread",73763],"195":["thread",76118],"196":["thread",48218],"197":["thread",47081],"198":["thread",46522],"199":["thread",44804],"200":["thread",47006],"201":["thread",74130],"202":["thread",88105],"203":["thread",46186],"204":["thread",74244],"205":["thread",71187],"206":["thread",47224],"207":["thread",46813],"208":["thread",68101],"209":["thread",81359],"210":["thread",78486],"211":["thread",74156],"212":["thread",69944],"213":["thread",75985],"214":["thread",47288],"215":["thread",70975],"216":["thread",66361],"217":["thread",72595],"218":["thread",71519],"219":["thread",78042],"220":["thread",73760],"221":["thread",49576],"222":["thread",85793],"223":["thread",77424],"224":["thread",48079],"225":["thread",83546],"226":["thread",119565],"227":["thread",47359],"228":["thread",47924],"229":["thread",46618],"230":["thread",48465],"231":["thread",72038],"232":["thread",74863],"233":["thread",77418],"234":["thread",112672],"235":["thread",70854],"236":["thread",47235],"237":["thread",49761],"238":["thread",48215],"239":["thread",80928],"240":["thread",80988],"241":["thread",48467],"242":["thread",79570],"243":["thread",73916],"244":["thread",78089],"245":["thread",95051],"246":["thread",97080],"247":["thread",47711],"248":["thread",75472],"249":["thread",77917],"250":["thread",85447],"251":["thread",44556],"252":["thread",85441],"253":["thread",59142],"254":["thread",74409],"255":["thread",102285],"256":["thread",46296],"257":["thread",119577],"259":["thread",69965],"260":["thread",66861],"261":["thread",48559],"262":["thread",129928],"263":["thread",46192],"264":["thread",75155],"265":["thread",74024],"266":["thread",49960],"267":["thread",81869],"268":["thread",81481],"269":["thread",48306],"270":["thread",74503],"271":["thread",69934],"272":["thread",47039],"273":["thread",72635],"274":["thread",65835],"275":["thread",56047],"276":["thread",44891],"277":["thread",70373],"278":["thread",77991],"279":["thread",73328],"280":["thread",74665],"281":["thread",67062],"282":["thread",64277],"283":["thread",76411],"284":["thread",87383],"285":["thread",81489],"286":["thread",57779],"287":["thread",76399],"288":["thread",71420],"289":["thread",59134],"290":["thread",86464],"291":["thread",95901],"292":["thread",74182],"293":["thread",70082],"294":["thread",74251],"295":["thread",84000],"296":["thread",72617],"297":["thread",811],"298":["thread",61224],"299":["thread",46994]}
Run Time: 0.053771
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.000092
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |