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 (87509, 87602, 61830, 60811, 118188, 125192, 135096, 110895, 67365, 94448, 96640, 122821, 55757, 83356, 96841, 71392, 114960, 70996, 57272, 121742, 105526, 83009, 122443, 125555, 68777, 88946, 131106, 52481, 58083, 44478, 119621, 80894, 90920, 70557, 59508, 133574, 130131, 124077, 89781, 94511, 37895, 97372, 112100, 56556, 57214, 69392, 98224, 94139, 41001, 128768, 125143, 79767, 87972, 69141, 60497, 119528, 60455, 108601, 111836, 12406, 101998, 91110, 85673, 85586, 105398, 83547, 59158, 104933, 80798, 107244, 74801, 64618, 110479, 118461, 116585, 58590, 112094, 113130, 59757, 81441, 111760, 109946, 111019, 92321, 74538, 69293, 58698, 821, 123366, 127611, 68191, 108626, 122422, 105432, 128482, 68550, 71743, 125972, 78603, 135983, 60648, 97962, 114491, 84759, 87840, 121292, 71101, 66854, 83061, 111807, 39897, 27573, 68901, 117036, 99627, 75717, 77047, 80007, 62602, 132456, 85764, 74, 62812, 60933, 69493, 78076, 129354, 54030, 56028, 73383, 119496, 34290, 93288, 101443, 56502, 107923, 110825, 48834, 131120, 80389, 128429, 86426, 47417, 79130, 79778, 114803, 115926, 52394, 65189, 105407, 65509, 73113, 82979, 90424, 110266, 131401, 49221, 97644, 95734, 100363, 99976, 103518, 65912, 97425, 111805, 121888, 83725, 83980, 95342, 39550, 105226, 112805, 48708, 81348, 78676, 67910, 489, 67710, 114545, 114891, 120621, 74226, 110214, 16191, 21716, 131741, 89847, 107125, 11411, 90566, 79410, 112639, 19062, 68571, 106483, 14358, 38853, 67090, 101083, 50114, 91480, 58033, 104800, 83491, 48640, 87334, 60217, 132426, 126248, 105305, 77130, 71568, 68604, 67161, 45761, 84688, 87348, 119607, 56558, 96110, 97612, 58080, 110177, 2254, 24422, 52933, 127712, 60267, 133365, 87067, 126847, 55444, 59054, 27776, 77652, 95526, 39010, 62003, 63659, 38855, 68516, 66499, 75035, 45803, 48654, 107373, 102703, 18634, 48379, 110242, 112591, 69098, 66807, 70546, 129615, 115088, 35940, 106815, 60167, 62305, 124175, 85990, 95537, 87124, 102592, 105543, 75745, 110256, 55322, 87568, 52422, 23290, 100027, 109740, 124867, 107016, 89306, 41386, 122570, 62199, 133588, 109565, 73119, 70690, 122167, 71895, 130464, 72848, 94211, 51075, 113045, 65607, 125156, 64014, 111588, 64145)
Run Time: 0.009195
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 296 | 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: 1355, 0, 1711716546, 1711720146, {"0":["resource",28],"1":["resource",26],"2":["resource",25],"3":["resource",24],"4":["thread",87509],"5":["thread",87602],"6":["thread",61830],"7":["thread",60811],"8":["thread",118188],"9":["thread",125192],"10":["thread",135096],"11":["thread",110895],"12":["thread",67365],"13":["thread",94448],"14":["thread",96640],"15":["thread",122821],"16":["thread",55757],"17":["thread",83356],"18":["thread",96841],"19":["thread",71392],"20":["thread",114960],"21":["thread",70996],"22":["thread",57272],"23":["thread",121742],"24":["thread",105526],"25":["thread",83009],"26":["thread",122443],"27":["thread",125555],"28":["thread",68777],"29":["thread",88946],"30":["thread",131106],"31":["thread",52481],"32":["thread",58083],"33":["thread",44478],"34":["thread",119621],"35":["thread",80894],"36":["thread",90920],"37":["thread",70557],"38":["thread",59508],"39":["thread",133574],"40":["thread",130131],"41":["thread",124077],"42":["thread",89781],"43":["thread",94511],"44":["thread",37895],"45":["thread",97372],"46":["thread",112100],"47":["thread",56556],"48":["thread",57214],"49":["thread",69392],"50":["thread",98224],"51":["thread",94139],"52":["thread",41001],"53":["thread",128768],"54":["thread",125143],"55":["thread",79767],"56":["thread",87972],"57":["thread",69141],"58":["thread",60497],"59":["thread",119528],"60":["thread",60455],"61":["thread",108601],"62":["thread",111836],"63":["thread",12406],"64":["thread",101998],"65":["thread",91110],"66":["thread",85673],"67":["thread",85586],"68":["thread",105398],"69":["thread",83547],"70":["thread",59158],"71":["thread",104933],"72":["thread",80798],"73":["thread",107244],"74":["thread",74801],"75":["thread",64618],"76":["thread",110479],"77":["thread",118461],"78":["thread",116585],"79":["thread",58590],"80":["thread",112094],"81":["thread",113130],"82":["thread",59757],"83":["thread",81441],"84":["thread",111760],"85":["thread",109946],"86":["thread",111019],"87":["thread",92321],"88":["thread",74538],"89":["thread",69293],"90":["thread",58698],"92":["thread",123366],"93":["thread",127611],"94":["thread",68191],"95":["thread",108626],"96":["thread",122422],"97":["thread",105432],"98":["thread",128482],"99":["thread",68550],"100":["thread",71743],"101":["thread",125972],"102":["thread",78603],"103":["thread",135983],"104":["thread",60648],"105":["thread",97962],"106":["thread",114491],"107":["thread",84759],"108":["thread",87840],"109":["thread",121292],"110":["thread",71101],"111":["thread",66854],"112":["thread",83061],"113":["thread",111807],"114":["thread",39897],"115":["thread",27573],"116":["thread",68901],"117":["thread",117036],"118":["thread",99627],"119":["thread",75717],"120":["thread",77047],"121":["thread",80007],"122":["thread",62602],"123":["thread",132456],"124":["thread",85764],"125":["thread",74],"126":["thread",62812],"127":["thread",60933],"128":["thread",69493],"129":["thread",78076],"130":["thread",129354],"131":["thread",54030],"132":["thread",56028],"133":["thread",73383],"134":["thread",119496],"135":["thread",34290],"136":["thread",93288],"137":["thread",101443],"138":["thread",56502],"139":["thread",107923],"140":["thread",110825],"141":["thread",48834],"142":["thread",131120],"143":["thread",80389],"144":["thread",128429],"145":["thread",86426],"146":["thread",47417],"147":["thread",79130],"148":["thread",79778],"149":["thread",114803],"150":["thread",115926],"151":["thread",52394],"152":["thread",65189],"153":["thread",105407],"154":["thread",65509],"155":["thread",73113],"156":["thread",82979],"157":["thread",90424],"158":["thread",110266],"159":["thread",131401],"160":["thread",49221],"161":["thread",97644],"162":["thread",95734],"163":["thread",100363],"164":["thread",99976],"165":["thread",103518],"166":["thread",65912],"167":["thread",97425],"168":["thread",111805],"169":["thread",121888],"170":["thread",83725],"171":["thread",83980],"172":["thread",95342],"173":["thread",39550],"174":["thread",105226],"175":["thread",112805],"176":["thread",48708],"177":["thread",81348],"178":["thread",78676],"179":["thread",67910],"180":["thread",489],"181":["thread",67710],"182":["thread",114545],"183":["thread",114891],"184":["thread",120621],"185":["thread",74226],"186":["thread",110214],"187":["thread",16191],"188":["thread",21716],"189":["thread",131741],"190":["thread",89847],"191":["thread",107125],"192":["thread",11411],"193":["thread",90566],"194":["thread",79410],"195":["thread",112639],"196":["thread",19062],"197":["thread",68571],"198":["thread",106483],"199":["thread",14358],"200":["thread",38853],"201":["thread",67090],"202":["thread",101083],"203":["thread",50114],"204":["thread",91480],"205":["thread",58033],"206":["thread",104800],"207":["thread",83491],"208":["thread",48640],"209":["thread",87334],"210":["thread",60217],"211":["thread",132426],"212":["thread",126248],"213":["thread",105305],"214":["thread",77130],"215":["thread",71568],"216":["thread",68604],"217":["thread",67161],"218":["thread",45761],"219":["thread",84688],"220":["thread",87348],"221":["thread",119607],"222":["thread",56558],"223":["thread",96110],"224":["thread",97612],"225":["thread",58080],"226":["thread",110177],"227":["thread",2254],"228":["thread",24422],"229":["thread",52933],"230":["thread",127712],"231":["thread",60267],"232":["thread",133365],"233":["thread",87067],"234":["thread",126847],"235":["thread",55444],"236":["thread",59054],"238":["thread",77652],"239":["thread",95526],"240":["thread",39010],"241":["thread",62003],"242":["thread",63659],"243":["thread",38855],"244":["thread",68516],"245":["thread",66499],"246":["thread",75035],"247":["thread",45803],"248":["thread",48654],"249":["thread",107373],"250":["thread",102703],"251":["thread",18634],"252":["thread",48379],"253":["thread",110242],"254":["thread",112591],"255":["thread",69098],"256":["thread",66807],"257":["thread",70546],"258":["thread",129615],"259":["thread",115088],"260":["thread",35940],"261":["thread",106815],"262":["thread",60167],"263":["thread",62305],"264":["thread",124175],"265":["thread",85990],"266":["thread",95537],"267":["thread",87124],"268":["thread",102592],"269":["thread",105543],"270":["thread",75745],"271":["thread",110256],"272":["thread",55322],"273":["thread",87568],"274":["thread",52422],"275":["thread",23290],"276":["thread",100027],"277":["thread",109740],"278":["thread",124867],"279":["thread",107016],"280":["thread",89306],"281":["thread",41386],"282":["thread",122570],"283":["thread",62199],"284":["thread",133588],"285":["thread",109565],"286":["thread",73119],"287":["thread",70690],"288":["thread",122167],"289":["thread",71895],"290":["thread",130464],"291":["thread",72848],"292":["thread",94211],"293":["thread",51075],"294":["thread",113045],"295":["thread",65607],"296":["thread",125156],"297":["thread",64014],"298":["thread",111588],"299":["thread",64145]}
Run Time: 0.014463
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 |