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 (99046, 67094, 86702, 98549, 128878, 19543, 69404, 90145, 71678, 44411, 132670, 95567, 71928, 103518, 56367, 79969, 24613, 68778, 100573, 73944, 52551, 80206, 90303, 50303, 30466, 85706, 39421, 44886, 7733, 51880, 62963, 102404, 63659, 123866, 53207, 132127, 51248, 46645, 47123, 94888, 81567, 85305, 115385, 23403, 21479, 87217, 89404, 62009, 117168, 43320, 35139, 102231, 122271, 69711, 98303, 109078, 86343, 67365, 105543, 90967, 71112, 74841, 87474, 33078, 54543, 99111, 55790, 35983, 32046, 26568, 23237, 114069, 80403, 91229, 79287, 22834, 90916, 133555, 119786, 77865, 37452, 47038, 112418, 106432, 84397, 49881, 97549, 120333, 84015, 117064, 63819, 69572, 23490, 52093, 132426, 112510, 106925, 115307, 97900, 102853, 128059, 69568, 100229, 55537, 73113, 6228, 76508, 101443, 112404, 54372, 131655, 90813, 60926, 64645, 109275, 54503, 122012, 64187, 47034, 108483, 100313, 53447, 38079, 51603, 55563, 82154, 55155, 33272, 59505, 89085, 49495, 85765, 46370, 23255, 124295, 41204, 37983, 111798, 68908, 114492, 117151, 66949, 69575, 48412, 113085, 84440, 125658, 126045, 112348, 104956, 67947, 76253, 129077, 79884, 84432, 101312, 122180, 30142, 77126, 95614, 51607, 62521, 82028, 56260, 54387, 78682, 71789, 46564, 109841, 85981, 126983, 51082, 66265, 48156, 109794, 86443, 133149, 55075, 82713, 26065, 74583, 91531, 86629, 49447, 66175, 82583, 76419, 64083, 58226, 125473, 121502, 79645, 89035, 26830, 123706, 65212, 129859, 39486, 72641, 95057, 104707, 107417, 112749, 72747, 96203, 56330, 128401, 56264, 135378, 58808, 71488, 98072, 92873, 94257, 38659, 110675, 104845, 22727, 21643, 86769, 118204, 118008, 98806, 24114, 71392, 106372, 76891, 97394, 51247, 105863, 108992, 66973, 68976, 62828, 56623, 73928, 111501, 134986, 64305, 70095, 57169, 102666, 121993, 23436, 91922, 68289, 84761, 93365, 94975, 17089, 23523, 124094, 65993, 32370, 73792, 104389, 136337, 89561, 43382, 87821, 85401, 121997, 79241, 65343, 124489, 61313, 96791, 132202, 87348, 82116, 35982, 88361, 121995, 50422, 51530, 70896, 88854, 66339, 80831, 70280, 52481, 36923, 126426, 103046, 62065, 130920, 62698, 67727, 136512, 110257, 126079, 92384, 102426, 62946, 37516, 61372, 86599, 100352, 77911, 136640)
Run Time: 0.016759
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: 1172, 0, 1714063095, 1714066695, {"0":["thread",99046],"1":["thread",67094],"2":["thread",86702],"3":["thread",98549],"4":["thread",128878],"5":["thread",19543],"6":["thread",69404],"7":["thread",90145],"8":["thread",71678],"9":["thread",44411],"10":["thread",132670],"11":["thread",95567],"12":["thread",71928],"13":["thread",103518],"14":["thread",56367],"15":["thread",79969],"16":["thread",24613],"17":["thread",68778],"18":["thread",100573],"19":["thread",73944],"20":["thread",52551],"21":["thread",80206],"22":["thread",90303],"23":["thread",50303],"24":["thread",30466],"25":["thread",85706],"26":["thread",39421],"27":["thread",44886],"28":["thread",7733],"29":["thread",51880],"30":["thread",62963],"31":["thread",102404],"32":["thread",63659],"33":["thread",123866],"34":["thread",53207],"35":["thread",132127],"36":["thread",51248],"37":["thread",46645],"38":["thread",47123],"39":["thread",94888],"40":["thread",81567],"41":["thread",85305],"42":["thread",115385],"43":["thread",23403],"44":["thread",21479],"45":["thread",87217],"46":["thread",89404],"47":["thread",62009],"48":["thread",117168],"49":["thread",43320],"50":["thread",35139],"51":["thread",102231],"52":["thread",122271],"53":["thread",69711],"54":["thread",98303],"55":["thread",109078],"56":["thread",86343],"57":["thread",67365],"58":["thread",105543],"59":["thread",90967],"60":["thread",71112],"61":["thread",74841],"62":["thread",87474],"63":["thread",33078],"64":["thread",54543],"65":["thread",99111],"66":["thread",55790],"67":["thread",35983],"68":["thread",32046],"69":["thread",26568],"70":["thread",23237],"71":["thread",114069],"72":["thread",80403],"73":["thread",91229],"74":["thread",79287],"75":["thread",22834],"76":["thread",90916],"77":["thread",133555],"78":["thread",119786],"79":["thread",77865],"80":["thread",37452],"81":["thread",47038],"82":["thread",112418],"83":["thread",106432],"84":["thread",84397],"85":["thread",49881],"86":["thread",97549],"87":["thread",120333],"88":["thread",84015],"89":["thread",117064],"90":["thread",63819],"91":["thread",69572],"92":["thread",23490],"93":["thread",52093],"94":["thread",132426],"95":["thread",112510],"96":["thread",106925],"97":["thread",115307],"98":["thread",97900],"99":["thread",102853],"100":["thread",128059],"101":["thread",69568],"102":["thread",100229],"103":["thread",55537],"104":["thread",73113],"105":["thread",6228],"106":["thread",76508],"107":["thread",101443],"108":["thread",112404],"109":["thread",54372],"110":["thread",131655],"111":["thread",90813],"112":["thread",60926],"113":["thread",64645],"114":["thread",109275],"115":["thread",54503],"116":["thread",122012],"117":["thread",64187],"118":["thread",47034],"119":["thread",108483],"120":["thread",100313],"121":["thread",53447],"122":["thread",38079],"123":["thread",51603],"124":["thread",55563],"125":["thread",82154],"126":["thread",55155],"127":["thread",33272],"128":["thread",59505],"129":["thread",89085],"130":["thread",49495],"131":["thread",85765],"132":["thread",46370],"133":["thread",23255],"134":["thread",124295],"135":["thread",41204],"136":["thread",37983],"137":["thread",111798],"138":["thread",68908],"139":["thread",114492],"140":["thread",117151],"141":["thread",66949],"142":["thread",69575],"143":["thread",48412],"144":["thread",113085],"145":["thread",84440],"146":["thread",125658],"147":["thread",126045],"148":["thread",112348],"149":["thread",104956],"150":["thread",67947],"151":["thread",76253],"152":["thread",129077],"153":["thread",79884],"154":["thread",84432],"155":["thread",101312],"156":["thread",122180],"157":["thread",30142],"158":["thread",77126],"159":["thread",95614],"160":["thread",51607],"161":["thread",62521],"162":["thread",82028],"163":["thread",56260],"164":["thread",54387],"165":["thread",78682],"166":["thread",71789],"167":["thread",46564],"168":["thread",109841],"169":["thread",85981],"170":["thread",126983],"171":["thread",51082],"172":["thread",66265],"173":["thread",48156],"174":["thread",109794],"175":["thread",86443],"176":["thread",133149],"177":["thread",55075],"178":["thread",82713],"179":["thread",26065],"180":["thread",74583],"181":["thread",91531],"182":["thread",86629],"183":["thread",49447],"184":["thread",66175],"185":["thread",82583],"186":["thread",76419],"187":["thread",64083],"188":["thread",58226],"189":["thread",125473],"190":["thread",121502],"191":["thread",79645],"192":["thread",89035],"193":["thread",26830],"194":["thread",123706],"196":["thread",129859],"197":["thread",39486],"198":["thread",72641],"199":["thread",95057],"200":["thread",104707],"201":["thread",107417],"202":["thread",112749],"203":["thread",72747],"204":["thread",96203],"205":["thread",56330],"206":["thread",128401],"207":["thread",56264],"208":["thread",135378],"209":["thread",58808],"210":["thread",71488],"211":["thread",98072],"212":["thread",92873],"213":["thread",94257],"214":["thread",38659],"215":["thread",110675],"216":["thread",104845],"217":["thread",22727],"218":["thread",21643],"219":["thread",86769],"220":["thread",118204],"221":["thread",118008],"222":["thread",98806],"223":["thread",24114],"224":["thread",71392],"225":["thread",106372],"226":["thread",76891],"227":["thread",97394],"228":["thread",51247],"229":["thread",105863],"230":["thread",108992],"231":["thread",66973],"232":["thread",68976],"233":["thread",62828],"234":["thread",56623],"235":["thread",73928],"236":["thread",111501],"237":["thread",134986],"238":["thread",64305],"239":["thread",70095],"240":["thread",57169],"241":["thread",102666],"242":["thread",121993],"243":["thread",23436],"244":["thread",91922],"245":["thread",68289],"246":["thread",84761],"247":["thread",93365],"248":["thread",94975],"249":["thread",17089],"250":["thread",23523],"251":["thread",124094],"252":["thread",65993],"253":["thread",32370],"254":["thread",73792],"255":["thread",104389],"256":["thread",136337],"257":["thread",89561],"258":["thread",43382],"259":["thread",87821],"260":["thread",85401],"261":["thread",121997],"262":["thread",79241],"263":["thread",65343],"264":["thread",124489],"265":["thread",61313],"266":["thread",96791],"267":["thread",132202],"268":["thread",87348],"269":["thread",82116],"270":["thread",35982],"271":["thread",88361],"272":["thread",121995],"273":["thread",50422],"274":["thread",51530],"275":["thread",70896],"276":["thread",88854],"277":["thread",66339],"278":["thread",80831],"279":["thread",70280],"280":["thread",52481],"281":["thread",36923],"282":["thread",126426],"283":["thread",103046],"284":["thread",62065],"285":["thread",130920],"286":["thread",62698],"287":["thread",67727],"288":["thread",136512],"289":["thread",110257],"290":["thread",126079],"291":["thread",92384],"292":["thread",102426],"293":["thread",62946],"294":["thread",37516],"295":["thread",61372],"296":["thread",86599],"297":["thread",100352],"298":["thread",77911],"299":["thread",136640]}
Run Time: 0.006839
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.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |