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 (114596, 19159, 122602, 5040, 123691, 39281, 123465, 38049, 89831, 98776, 86189, 27405, 74055, 109413, 109215, 45900, 17027, 102645, 47314, 65446, 115817, 119296, 98396, 130001, 37490, 18632, 73390, 74804, 135200, 72928, 76780, 105638, 85233, 61826, 130131, 18202, 116487, 105052, 88074, 30970, 101064, 59664, 104964, 124682, 134000, 105243, 88985, 132992, 119440, 125972, 112021, 81507, 14793, 110577, 45126, 104888, 80791, 125093, 110429, 58336, 41557, 80507, 73845, 98219, 132906, 47227, 84397, 72645, 62452, 134158, 38309, 83322, 36475, 30139, 77416, 75611, 120035, 121902, 127724, 110835, 59235, 99698, 122098, 78821, 109768, 90699, 71743, 4978, 65567, 86762, 78434, 36436, 93451, 95502, 54191, 33140, 89522, 92623, 71880, 132678, 98397, 69488, 46476, 117606, 66409, 36480, 71624, 105989, 94217, 129227, 56625, 46279, 16823, 85412, 85226, 100141, 71112, 108472, 109623, 122283, 118756, 127293, 103899, 46538, 125648, 105636, 56696, 118133, 37049, 81073, 55250, 52667, 131741, 39889, 72654, 67252, 48902, 118653, 104448, 71134, 121645, 65114, 99662, 102913, 127614, 54140, 130908, 32784, 134756, 98393, 87792, 128275, 50257, 91224, 69153, 72835, 25783, 96274, 45433, 73056, 62000, 53496, 48697, 126494, 58518, 119114, 48640, 85211, 91006, 86855, 121521, 116499, 127132, 119733, 37096, 40964, 125487, 67801, 58519, 83715, 93399, 45437, 52827, 114680, 120618, 121649, 7132, 60558, 118447, 94777, 18077, 53084, 108196, 84822, 84432, 72237, 42698, 78668, 90285, 104843, 92291, 30960, 21547, 80632, 105889, 98914, 111750, 53641, 63554, 82678, 93609, 34408, 134324, 65799, 93408, 33806, 127193, 115915, 94580, 34134, 55835, 47462, 124662, 49500, 89978, 104887, 90510, 125398, 104453, 106490, 51333, 46864, 92582, 124673, 135948, 89780, 101022, 117090, 87904, 122079, 121344, 65987, 102952, 85149, 98301, 46727, 67660, 84225, 39546, 84708, 128856, 57619, 71725, 50099, 99160, 58763, 52526, 39330, 84039, 62950, 46420, 88619, 126877, 125409, 37028, 117045, 91543, 38305, 107745, 81114, 104824, 88008, 96275, 85271, 135826, 73538, 12626, 131384, 68253, 116067, 132667, 109300, 56262, 56254, 73123, 40909, 89217, 88798, 97904, 4402, 72502, 22052, 106147, 87994, 7703, 128051, 107784, 28155, 62298, 37054)
Run Time: 0.044289
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: 1222, 0, 1711656267, 1711659867, {"0":["thread",114596],"1":["thread",19159],"2":["thread",122602],"3":["thread",5040],"4":["thread",123691],"5":["thread",39281],"6":["thread",123465],"7":["thread",38049],"8":["thread",89831],"9":["thread",98776],"10":["thread",86189],"11":["thread",27405],"12":["thread",74055],"13":["thread",109413],"14":["thread",109215],"15":["thread",45900],"16":["thread",17027],"17":["thread",102645],"18":["thread",47314],"19":["thread",65446],"20":["thread",115817],"21":["thread",119296],"22":["thread",98396],"23":["thread",130001],"24":["thread",37490],"25":["thread",18632],"26":["thread",73390],"27":["thread",74804],"28":["thread",135200],"29":["thread",72928],"30":["thread",76780],"31":["thread",105638],"32":["thread",85233],"33":["thread",61826],"34":["thread",130131],"35":["thread",18202],"36":["thread",116487],"37":["thread",105052],"38":["thread",88074],"39":["thread",30970],"40":["thread",101064],"41":["thread",59664],"42":["thread",104964],"43":["thread",124682],"44":["thread",134000],"45":["thread",105243],"46":["thread",88985],"47":["thread",132992],"48":["thread",119440],"49":["thread",125972],"50":["thread",112021],"51":["thread",81507],"52":["thread",14793],"53":["thread",110577],"54":["thread",45126],"55":["thread",104888],"56":["thread",80791],"57":["thread",125093],"58":["thread",110429],"59":["thread",58336],"60":["thread",41557],"61":["thread",80507],"62":["thread",73845],"63":["thread",98219],"64":["thread",132906],"65":["thread",47227],"66":["thread",84397],"67":["thread",72645],"68":["thread",62452],"69":["thread",134158],"70":["thread",38309],"71":["thread",83322],"72":["thread",36475],"73":["thread",30139],"74":["thread",77416],"75":["thread",75611],"76":["thread",120035],"77":["thread",121902],"78":["thread",127724],"79":["thread",110835],"80":["thread",59235],"81":["thread",99698],"82":["thread",122098],"83":["thread",78821],"84":["thread",109768],"85":["thread",90699],"86":["thread",71743],"87":["thread",4978],"88":["thread",65567],"89":["thread",86762],"90":["thread",78434],"91":["thread",36436],"92":["thread",93451],"93":["thread",95502],"94":["thread",54191],"95":["thread",33140],"96":["thread",89522],"97":["thread",92623],"98":["thread",71880],"99":["thread",132678],"100":["thread",98397],"101":["thread",69488],"102":["thread",46476],"103":["thread",117606],"104":["thread",66409],"105":["thread",36480],"106":["thread",71624],"107":["thread",105989],"108":["thread",94217],"109":["thread",129227],"110":["thread",56625],"111":["thread",46279],"112":["thread",16823],"113":["thread",85412],"114":["thread",85226],"115":["thread",100141],"116":["thread",71112],"117":["thread",108472],"118":["thread",109623],"119":["thread",122283],"120":["thread",118756],"121":["thread",127293],"122":["thread",103899],"123":["thread",46538],"124":["thread",125648],"125":["thread",105636],"126":["thread",56696],"127":["thread",118133],"128":["thread",37049],"129":["thread",81073],"130":["thread",55250],"131":["thread",52667],"132":["thread",131741],"133":["thread",39889],"134":["thread",72654],"135":["thread",67252],"136":["thread",48902],"137":["thread",118653],"138":["thread",104448],"139":["thread",71134],"140":["thread",121645],"141":["thread",65114],"142":["thread",99662],"143":["thread",102913],"144":["thread",127614],"145":["thread",54140],"146":["thread",130908],"147":["thread",32784],"148":["thread",134756],"149":["thread",98393],"150":["thread",87792],"151":["thread",128275],"152":["thread",50257],"153":["thread",91224],"154":["thread",69153],"155":["thread",72835],"156":["thread",25783],"157":["thread",96274],"158":["thread",45433],"159":["thread",73056],"160":["thread",62000],"161":["thread",53496],"162":["thread",48697],"163":["thread",126494],"164":["thread",58518],"165":["thread",119114],"166":["thread",48640],"167":["thread",85211],"168":["thread",91006],"169":["thread",86855],"170":["thread",121521],"171":["thread",116499],"172":["thread",127132],"173":["thread",119733],"174":["thread",37096],"175":["thread",40964],"176":["thread",125487],"177":["thread",67801],"178":["thread",58519],"179":["thread",83715],"180":["thread",93399],"181":["thread",45437],"182":["thread",52827],"183":["thread",114680],"184":["thread",120618],"185":["thread",121649],"186":["thread",7132],"187":["thread",60558],"188":["thread",118447],"189":["thread",94777],"190":["thread",18077],"191":["thread",53084],"192":["thread",108196],"193":["thread",84822],"194":["thread",84432],"195":["thread",72237],"196":["thread",42698],"197":["thread",78668],"198":["thread",90285],"199":["thread",104843],"200":["thread",92291],"201":["thread",30960],"202":["thread",21547],"203":["thread",80632],"204":["thread",105889],"205":["thread",98914],"206":["thread",111750],"207":["thread",53641],"208":["thread",63554],"209":["thread",82678],"210":["thread",93609],"211":["thread",34408],"212":["thread",134324],"213":["thread",65799],"214":["thread",93408],"215":["thread",33806],"216":["thread",127193],"217":["thread",115915],"218":["thread",94580],"219":["thread",34134],"220":["thread",55835],"221":["thread",47462],"222":["thread",124662],"223":["thread",49500],"225":["thread",104887],"226":["thread",90510],"227":["thread",125398],"228":["thread",104453],"229":["thread",106490],"230":["thread",51333],"231":["thread",46864],"232":["thread",92582],"233":["thread",124673],"234":["thread",135948],"235":["thread",89780],"236":["thread",101022],"237":["thread",117090],"238":["thread",87904],"239":["thread",122079],"240":["thread",121344],"241":["thread",65987],"242":["thread",102952],"243":["thread",85149],"244":["thread",98301],"245":["thread",46727],"246":["thread",67660],"247":["thread",84225],"248":["thread",39546],"249":["thread",84708],"250":["thread",128856],"251":["thread",57619],"252":["thread",71725],"253":["thread",50099],"254":["thread",99160],"255":["thread",58763],"256":["thread",52526],"257":["thread",39330],"258":["thread",84039],"259":["thread",62950],"260":["thread",46420],"261":["thread",88619],"262":["thread",126877],"263":["thread",125409],"264":["thread",37028],"265":["thread",117045],"266":["thread",91543],"267":["thread",38305],"268":["thread",107745],"269":["thread",81114],"270":["thread",104824],"271":["thread",88008],"272":["thread",96275],"273":["thread",85271],"274":["thread",135826],"275":["thread",73538],"276":["thread",12626],"277":["thread",131384],"278":["thread",68253],"279":["thread",116067],"280":["thread",132667],"281":["thread",109300],"282":["thread",56262],"283":["thread",56254],"284":["thread",73123],"285":["thread",40909],"286":["thread",89217],"287":["thread",88798],"288":["thread",97904],"289":["thread",4402],"290":["thread",72502],"291":["thread",22052],"292":["thread",106147],"293":["thread",87994],"294":["thread",7703],"295":["thread",128051],"296":["thread",107784],"297":["thread",28155],"298":["thread",62298],"299":["thread",37054]}
Run Time: 0.017438
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.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |