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 (67688, 22162, 133057, 49447, 125315, 125360, 99247, 98200, 85651, 103493, 120036, 134601, 66356, 10030, 116396, 66147, 126539, 120378, 130623, 113992, 91869, 132222, 65650, 109172, 123741, 100839, 130524, 78495, 64535, 115998, 134726, 79883, 116075, 116328, 114682, 38604, 78298, 104949, 104540, 101083, 87166, 133733, 97259, 124241, 93412, 70464, 65745, 126979, 53043, 111140, 58006, 134857, 131251, 127759, 116274, 42854, 84958, 66940, 229, 107619, 119883, 105663, 110943, 52285, 55475, 82215, 115981, 42706, 45331, 86015, 90486, 120382, 98120, 126553, 126767, 58750, 124762, 43346, 74830, 92706, 83367, 111255, 119058, 127538, 68700, 86012, 63431, 50230, 123554, 58242, 8298, 93086, 71647, 75424, 87788, 133386, 84282, 123635, 118474, 130616, 128878, 100941, 18881, 102501, 86351, 129061, 35372, 65237, 78491, 91943, 52771, 59138, 28757, 45517, 94076, 65493, 113472, 97724, 83223, 122951, 48281, 122073, 73928, 43943, 61482, 117232, 43985, 106611, 103551, 28732, 91419, 46959, 125075, 63430, 82796, 112914, 106109, 119882, 100337, 56558, 52140, 129690, 133324, 61313, 7543, 109115, 73871, 72835, 65561, 56786, 67081, 66199, 55747, 83319, 113807, 29015, 83725, 69575, 43756, 16237, 60243, 74208, 71475, 115203, 134686, 102197, 95418, 61691, 127243, 122602, 132158, 94444, 65890, 115381, 68677, 134906, 130936, 66382, 96743, 113974, 115205, 113613, 96522, 81689, 23915, 73416, 61530, 107873, 94260, 118193, 57325, 105569, 99045, 12400, 82027, 98543, 130646, 58925, 81073, 67294, 59246, 49212, 19543, 44226, 73406, 63065, 60990, 128775, 79289, 78707, 73628, 45023, 121117, 123650, 90916, 93233, 4630, 106815, 56330, 55823, 100064, 66268, 114534, 100175, 125074, 101145, 50186, 70494, 45883, 81492, 43584, 80242, 67104, 104381, 131741, 58988, 59037, 17546, 122559, 116522, 124442, 101192, 70713, 65544, 85818, 57425, 124219, 56262, 129059, 98024, 110951, 94237, 80632, 113181, 111259, 69750, 88835, 47814, 104869, 129053, 131238, 120023, 64897, 44225, 83835, 47433, 53410, 119610, 58777, 97759, 41117, 132148, 131905, 90071, 49251, 112823, 127477, 113864, 118038, 117634, 115106, 126973, 111403, 94539, 78196, 52621, 126567, 60745, 89150, 62259, 107294, 74958, 87126, 58701, 135987, 101108, 118584, 73454, 60131, 89463)
Run Time: 0.007681
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: 683, 0, 1713417704, 1713421304, {"0":["thread",67688],"1":["thread",22162],"2":["thread",133057],"3":["thread",49447],"4":["thread",125315],"5":["thread",125360],"6":["thread",99247],"7":["thread",98200],"8":["thread",85651],"9":["thread",103493],"10":["thread",120036],"11":["thread",134601],"12":["thread",66356],"13":["thread",10030],"14":["thread",116396],"15":["thread",66147],"16":["thread",126539],"17":["thread",120378],"18":["thread",130623],"19":["thread",113992],"20":["thread",91869],"21":["thread",132222],"22":["thread",65650],"23":["thread",109172],"24":["thread",123741],"25":["thread",100839],"26":["thread",130524],"27":["thread",78495],"28":["thread",64535],"29":["thread",115998],"30":["thread",134726],"31":["thread",79883],"32":["thread",116075],"33":["thread",116328],"34":["thread",114682],"35":["thread",38604],"36":["thread",78298],"37":["thread",104949],"38":["thread",104540],"39":["thread",101083],"40":["thread",87166],"41":["thread",133733],"42":["thread",97259],"43":["thread",124241],"44":["thread",93412],"45":["thread",70464],"46":["thread",65745],"47":["thread",126979],"48":["thread",53043],"49":["thread",111140],"50":["thread",58006],"51":["thread",134857],"52":["thread",131251],"53":["thread",127759],"54":["thread",116274],"55":["thread",42854],"56":["thread",84958],"57":["thread",66940],"58":["thread",229],"59":["thread",107619],"60":["thread",119883],"61":["thread",105663],"62":["thread",110943],"63":["thread",52285],"64":["thread",55475],"65":["thread",82215],"66":["thread",115981],"67":["thread",42706],"68":["thread",45331],"70":["thread",90486],"71":["thread",120382],"72":["thread",98120],"73":["thread",126553],"74":["thread",126767],"75":["thread",58750],"76":["thread",124762],"77":["thread",43346],"78":["thread",74830],"79":["thread",92706],"80":["thread",83367],"81":["thread",111255],"82":["thread",119058],"83":["thread",127538],"84":["thread",68700],"85":["thread",86012],"86":["thread",63431],"87":["thread",50230],"88":["thread",123554],"89":["thread",58242],"90":["thread",8298],"91":["thread",93086],"92":["thread",71647],"93":["thread",75424],"94":["thread",87788],"95":["thread",133386],"96":["thread",84282],"97":["thread",123635],"98":["thread",118474],"99":["thread",130616],"100":["thread",128878],"101":["thread",100941],"102":["thread",18881],"103":["thread",102501],"104":["thread",86351],"105":["thread",129061],"106":["thread",35372],"107":["thread",65237],"108":["thread",78491],"109":["thread",91943],"110":["thread",52771],"111":["thread",59138],"112":["thread",28757],"113":["thread",45517],"114":["thread",94076],"115":["thread",65493],"116":["thread",113472],"117":["thread",97724],"118":["thread",83223],"119":["thread",122951],"120":["thread",48281],"121":["thread",122073],"122":["thread",73928],"123":["thread",43943],"124":["thread",61482],"125":["thread",117232],"126":["thread",43985],"127":["thread",106611],"128":["thread",103551],"129":["thread",28732],"130":["thread",91419],"131":["thread",46959],"132":["thread",125075],"133":["thread",63430],"134":["thread",82796],"135":["thread",112914],"136":["thread",106109],"137":["thread",119882],"138":["thread",100337],"139":["thread",56558],"140":["thread",52140],"141":["thread",129690],"142":["thread",133324],"143":["thread",61313],"144":["thread",7543],"145":["thread",109115],"146":["thread",73871],"147":["thread",72835],"148":["thread",65561],"149":["thread",56786],"150":["thread",67081],"151":["thread",66199],"152":["thread",55747],"153":["thread",83319],"154":["thread",113807],"155":["thread",29015],"156":["thread",83725],"157":["thread",69575],"158":["thread",43756],"159":["thread",16237],"160":["thread",60243],"161":["thread",74208],"162":["thread",71475],"163":["thread",115203],"164":["thread",134686],"165":["thread",102197],"166":["thread",95418],"167":["thread",61691],"168":["thread",127243],"169":["thread",122602],"170":["thread",132158],"171":["thread",94444],"172":["thread",65890],"173":["thread",115381],"174":["thread",68677],"175":["thread",134906],"176":["thread",130936],"177":["thread",66382],"178":["thread",96743],"179":["thread",113974],"180":["thread",115205],"181":["thread",113613],"182":["thread",96522],"183":["thread",81689],"184":["thread",23915],"185":["thread",73416],"186":["thread",61530],"187":["thread",107873],"188":["thread",94260],"189":["thread",118193],"190":["thread",57325],"191":["thread",105569],"192":["thread",99045],"193":["thread",12400],"194":["thread",82027],"195":["thread",98543],"196":["thread",130646],"197":["thread",58925],"198":["thread",81073],"199":["thread",67294],"200":["thread",59246],"201":["thread",49212],"202":["thread",19543],"203":["thread",44226],"204":["thread",73406],"205":["thread",63065],"206":["thread",60990],"207":["thread",128775],"208":["thread",79289],"209":["thread",78707],"210":["thread",73628],"211":["thread",45023],"212":["thread",121117],"213":["thread",123650],"214":["thread",90916],"215":["thread",93233],"216":["thread",4630],"217":["thread",106815],"218":["thread",56330],"219":["thread",55823],"220":["thread",100064],"221":["thread",66268],"222":["thread",114534],"223":["thread",100175],"224":["thread",125074],"225":["thread",101145],"226":["thread",50186],"227":["thread",70494],"228":["thread",45883],"229":["thread",81492],"230":["thread",43584],"231":["thread",80242],"232":["thread",67104],"233":["thread",104381],"234":["thread",131741],"235":["thread",58988],"236":["thread",59037],"237":["thread",17546],"238":["thread",122559],"239":["thread",116522],"240":["thread",124442],"241":["thread",101192],"242":["thread",70713],"243":["thread",65544],"244":["thread",85818],"245":["thread",57425],"246":["thread",124219],"247":["thread",56262],"248":["thread",129059],"249":["thread",98024],"250":["thread",110951],"251":["thread",94237],"252":["thread",80632],"253":["thread",113181],"254":["thread",111259],"255":["thread",69750],"256":["thread",88835],"257":["thread",47814],"258":["thread",104869],"259":["thread",129053],"260":["thread",131238],"261":["thread",120023],"262":["thread",64897],"263":["thread",44225],"264":["thread",83835],"265":["thread",47433],"266":["thread",53410],"267":["thread",119610],"268":["thread",58777],"269":["thread",97759],"270":["thread",41117],"271":["thread",132148],"272":["thread",131905],"273":["thread",90071],"274":["thread",49251],"275":["thread",112823],"276":["thread",127477],"277":["thread",113864],"278":["thread",118038],"279":["thread",117634],"280":["thread",115106],"281":["thread",126973],"282":["thread",111403],"283":["thread",94539],"284":["thread",78196],"285":["thread",52621],"286":["thread",126567],"287":["thread",60745],"288":["thread",89150],"289":["thread",62259],"290":["thread",107294],"291":["thread",74958],"292":["thread",87126],"293":["thread",58701],"294":["thread",135987],"295":["thread",101108],"296":["thread",118584],"297":["thread",73454],"298":["thread",60131],"299":["thread",89463]}
Run Time: 0.001887
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.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |