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 (135360, 42338, 87688, 83407, 132392, 55677, 73627, 67947, 125463, 110534, 70218, 64356, 82466, 135542, 86575, 90497, 73404, 54128, 73119, 108165, 79115, 21589, 118204, 131887, 62065, 94656, 58955, 79938, 95877, 72010, 85194, 100922, 121841, 78284, 59178, 127905, 44322, 55100, 112639, 128882, 88604, 38670, 116441, 90424, 61489, 61646, 113430, 92444, 76718, 38659, 132327, 44981, 85271, 50171, 41992, 55781, 87844, 101011, 103090, 61256, 69595, 37794, 125137, 65343, 86166, 135379, 40270, 21258, 103518, 35989, 86177, 121046, 97817, 79767, 94865, 109412, 121824, 87103, 67727, 132216, 55487, 35876, 66916, 135081, 114069, 57540, 66550, 130662, 68800, 36466, 87324, 61964, 68550, 110680, 104903, 122274, 119893, 69972, 50744, 105863, 112424, 122821, 60509, 62602, 71873, 91326, 86607, 48150, 35372, 71741, 62982, 69711, 66489, 82695, 62239, 92706, 64952, 51818, 100474, 125380, 59749, 119786, 63318, 58334, 124716, 96555, 30691, 83009, 111805, 121586, 90208, 92202, 131592, 108522, 120530, 43608, 132158, 134567, 128482, 101711, 102757, 45210, 100511, 23441, 92705, 110928, 130920, 119363, 116456, 44157, 131655, 85586, 127398, 68688, 42789, 93256, 61122, 125055, 113299, 97394, 71646, 100352, 133243, 132139, 67542, 86288, 125138, 130221, 108799, 136528, 103879, 82303, 112418, 60893, 62192, 33949, 92777, 69139, 117109, 47718, 75685, 124068, 96271, 135948, 38338, 59513, 57306, 62737, 119781, 132638, 131106, 91397, 82525, 52943, 64136, 80701, 80013, 54372, 58719, 101374, 110187, 61183, 61026, 61165, 72366, 87584, 112785, 41971, 71956, 85012, 136189, 130223, 130607, 22596, 41959, 92684, 106626, 105007, 19848, 86801, 109934, 26026, 80014, 92458, 58956, 108996, 98470, 117386, 92430, 132021, 115385, 87369, 7982, 57559, 57664, 136555, 99263, 121806, 71586, 127864, 132169, 78846, 91229, 112803, 106082, 94451, 115949, 122217, 122982, 67577, 83751, 123867, 44130, 112404, 50195, 88966, 90939, 113242, 21770, 46805, 84822, 54637, 72842, 115418, 113116, 85105, 70099, 37698, 62946, 121994, 82569, 121210, 117547, 91531, 55919, 78456, 115430, 132775, 78682, 115650, 109022, 82197, 93442, 94123, 30584, 65223, 23346, 55799, 90248, 86443, 128525, 115121, 87972, 102760, 126225, 74457, 77406, 85817, 92492, 81453)
Run Time: 0.029540
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: 1865, 0, 1714171709, 1714175309, {"0":["thread",135360],"1":["thread",42338],"2":["thread",87688],"3":["thread",83407],"4":["thread",132392],"5":["thread",55677],"6":["thread",73627],"7":["thread",67947],"8":["thread",125463],"9":["thread",110534],"10":["thread",70218],"11":["thread",64356],"12":["thread",82466],"13":["thread",135542],"14":["thread",86575],"15":["thread",90497],"16":["thread",73404],"17":["thread",54128],"18":["thread",73119],"19":["thread",108165],"20":["thread",79115],"21":["thread",21589],"22":["thread",118204],"23":["thread",131887],"24":["thread",62065],"25":["thread",94656],"26":["thread",58955],"27":["thread",79938],"28":["thread",95877],"29":["thread",72010],"30":["thread",85194],"31":["thread",100922],"32":["thread",121841],"33":["thread",78284],"34":["thread",59178],"35":["thread",127905],"36":["thread",44322],"37":["thread",55100],"38":["thread",112639],"39":["thread",128882],"40":["thread",88604],"41":["thread",38670],"42":["thread",116441],"43":["thread",90424],"44":["thread",61489],"45":["thread",61646],"46":["thread",113430],"47":["thread",92444],"48":["thread",76718],"49":["thread",38659],"50":["thread",132327],"51":["thread",44981],"52":["thread",85271],"53":["thread",50171],"54":["thread",41992],"55":["thread",55781],"56":["thread",87844],"57":["thread",101011],"58":["thread",103090],"59":["thread",61256],"60":["thread",69595],"61":["thread",37794],"62":["thread",125137],"63":["thread",65343],"64":["thread",86166],"65":["thread",135379],"66":["thread",40270],"67":["thread",21258],"68":["thread",103518],"69":["thread",35989],"70":["thread",86177],"71":["thread",121046],"72":["thread",97817],"73":["thread",79767],"74":["thread",94865],"75":["thread",109412],"76":["thread",121824],"77":["thread",87103],"78":["thread",67727],"79":["thread",132216],"80":["thread",55487],"81":["thread",35876],"82":["thread",66916],"83":["thread",135081],"84":["thread",114069],"85":["thread",57540],"86":["thread",66550],"87":["thread",130662],"88":["thread",68800],"89":["thread",36466],"90":["thread",87324],"91":["thread",61964],"92":["thread",68550],"93":["thread",110680],"94":["thread",104903],"95":["thread",122274],"96":["thread",119893],"97":["thread",69972],"98":["thread",50744],"99":["thread",105863],"100":["thread",112424],"101":["thread",122821],"102":["thread",60509],"103":["thread",62602],"104":["thread",71873],"105":["thread",91326],"106":["thread",86607],"107":["thread",48150],"108":["thread",35372],"109":["thread",71741],"110":["thread",62982],"111":["thread",69711],"112":["thread",66489],"113":["thread",82695],"114":["thread",62239],"115":["thread",92706],"116":["thread",64952],"117":["thread",51818],"118":["thread",100474],"119":["thread",125380],"120":["thread",59749],"121":["thread",119786],"122":["thread",63318],"123":["thread",58334],"124":["thread",124716],"125":["thread",96555],"126":["thread",30691],"127":["thread",83009],"128":["thread",111805],"129":["thread",121586],"130":["thread",90208],"131":["thread",92202],"132":["thread",131592],"133":["thread",108522],"134":["thread",120530],"135":["thread",43608],"136":["thread",132158],"137":["thread",134567],"138":["thread",128482],"139":["thread",101711],"140":["thread",102757],"141":["thread",45210],"142":["thread",100511],"143":["thread",23441],"144":["thread",92705],"145":["thread",110928],"146":["thread",130920],"147":["thread",119363],"148":["thread",116456],"149":["thread",44157],"150":["thread",131655],"151":["thread",85586],"152":["thread",127398],"153":["thread",68688],"154":["thread",42789],"155":["thread",93256],"156":["thread",61122],"157":["thread",125055],"158":["thread",113299],"159":["thread",97394],"160":["thread",71646],"161":["thread",100352],"162":["thread",133243],"163":["thread",132139],"164":["thread",67542],"165":["thread",86288],"166":["thread",125138],"167":["thread",130221],"168":["thread",108799],"169":["thread",136528],"170":["thread",103879],"171":["thread",82303],"172":["thread",112418],"173":["thread",60893],"174":["thread",62192],"175":["thread",33949],"176":["thread",92777],"177":["thread",69139],"178":["thread",117109],"179":["thread",47718],"180":["thread",75685],"181":["thread",124068],"182":["thread",96271],"183":["thread",135948],"184":["thread",38338],"185":["thread",59513],"186":["thread",57306],"187":["thread",62737],"188":["thread",119781],"189":["thread",132638],"190":["thread",131106],"191":["thread",91397],"192":["thread",82525],"193":["thread",52943],"194":["thread",64136],"195":["thread",80701],"196":["thread",80013],"197":["thread",54372],"198":["thread",58719],"199":["thread",101374],"200":["thread",110187],"201":["thread",61183],"202":["thread",61026],"203":["thread",61165],"204":["thread",72366],"205":["thread",87584],"206":["thread",112785],"207":["thread",41971],"208":["thread",71956],"209":["thread",85012],"210":["thread",136189],"211":["thread",130223],"212":["thread",130607],"213":["thread",22596],"215":["thread",92684],"216":["thread",106626],"217":["thread",105007],"218":["thread",19848],"219":["thread",86801],"220":["thread",109934],"221":["thread",26026],"222":["thread",80014],"223":["thread",92458],"224":["thread",58956],"225":["thread",108996],"226":["thread",98470],"227":["thread",117386],"228":["thread",92430],"229":["thread",132021],"230":["thread",115385],"231":["thread",87369],"232":["thread",7982],"233":["thread",57559],"234":["thread",57664],"235":["thread",136555],"236":["thread",99263],"237":["thread",121806],"238":["thread",71586],"239":["thread",127864],"240":["thread",132169],"241":["thread",78846],"242":["thread",91229],"243":["thread",112803],"244":["thread",106082],"245":["thread",94451],"246":["thread",115949],"247":["thread",122217],"248":["thread",122982],"249":["thread",67577],"250":["thread",83751],"251":["thread",123867],"252":["thread",44130],"253":["thread",112404],"254":["thread",50195],"255":["thread",88966],"256":["thread",90939],"257":["thread",113242],"258":["thread",21770],"259":["thread",46805],"260":["thread",84822],"261":["thread",54637],"262":["thread",72842],"263":["thread",115418],"264":["thread",113116],"265":["thread",85105],"266":["thread",70099],"267":["thread",37698],"268":["thread",62946],"269":["thread",121994],"270":["thread",82569],"271":["thread",121210],"272":["thread",117547],"273":["thread",91531],"274":["thread",55919],"275":["thread",78456],"276":["thread",115430],"277":["thread",132775],"278":["thread",78682],"279":["thread",115650],"280":["thread",109022],"281":["thread",82197],"282":["thread",93442],"283":["thread",94123],"284":["thread",30584],"285":["thread",65223],"286":["thread",23346],"287":["thread",55799],"288":["thread",90248],"289":["thread",86443],"290":["thread",128525],"291":["thread",115121],"292":["thread",87972],"293":["thread",102760],"294":["thread",126225],"295":["thread",74457],"296":["thread",77406],"297":["thread",85817],"298":["thread",92492],"299":["thread",81453]}
Run Time: 0.003047
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |