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 (84077, 89670, 1921, 900, 1801, 132846, 118942, 2725, 1419, 132742, 488, 35046, 77897, 1715, 81225, 976, 15930, 1534, 27649, 113446, 77253, 96296, 1808, 98967, 119583, 95433, 77012, 137307, 102589, 131320, 55784, 53342, 15425, 6958, 2785, 15118, 28233, 115480, 1967, 72956, 76957, 34249, 86253, 2500, 36859, 117029, 78733, 83093, 1946, 11293, 8310, 82416, 60817, 1739, 89014, 128028, 37417, 80291, 21058, 56885, 76971, 108616, 59927, 6946, 24007, 101043, 133089, 20146, 136859, 126678, 27995, 61389, 1652, 873, 1769, 127131, 77562, 1765, 59528, 85455, 14602, 86508, 98929, 105735, 123264, 78109, 88521, 91128, 22482, 54970, 2024, 1774, 62366, 19456, 107342, 6897, 74375, 1790, 2666, 79069, 113643, 107571, 34213, 1839, 120668, 1745, 45651, 1373, 84336, 115257, 28469, 54468, 870, 44509, 1747, 116679, 29613, 1802, 2092, 11824, 106886, 3931, 127633, 2728, 1843, 18433, 18048, 80162, 6801, 37657, 50113, 128077, 1948, 109945, 82101, 57259, 126723, 94000, 57064, 116411, 111666, 111477, 37048, 24327, 26328, 1899, 2541, 130741, 8625, 8149, 2502, 106521, 2520, 1846, 55954, 86008, 32250, 112261, 123135, 63058, 61131, 14542, 67300, 70936, 128931, 112827, 87338, 63380, 2089, 76368, 2088, 125157, 1858, 121676, 5407, 69316, 98015, 1805, 2488, 111409, 120874, 1773, 11396, 23214, 1152, 119024, 88324, 134875, 128761, 38186, 1520, 6795, 1263, 77306, 24446, 1698, 134338, 1939, 132529, 1896, 1859, 1781, 1570, 24933, 7776, 1789, 112531, 1517, 112247, 135065, 1934, 1909, 65783, 76346, 82655, 58045, 51879, 114229, 1138, 101947, 86107, 55925, 49669, 21264, 79032, 15749, 129238, 32362, 91238, 1768, 2705, 1855, 11395, 77811, 84335, 1828, 30091, 126681, 104253, 123499, 20579, 1908, 53163, 2026, 43070, 125415, 3913, 88517, 21917, 119855, 1844, 1827, 122902, 83737, 1981, 76450, 2498, 90926, 1929, 102361, 1938, 84775, 2511, 19669, 2093, 1951, 28095, 67018, 1940, 128136, 53676, 7330, 107776, 1417, 110999, 15212, 1527, 91043, 103018, 122188, 11410, 54518, 75358, 67513, 89738, 24648, 64481, 84605, 110271, 104318, 16165, 102224, 12008, 90227, 54561, 67714, 12857, 110663, 1772, 1679)
Run Time: 0.018034
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: 142, 0, 1715925970, 1715929570, {"0":["thread",84077],"1":["thread",89670],"2":["thread",1921],"3":["thread",900],"4":["thread",1801],"5":["thread",132846],"6":["thread",118942],"7":["thread",2725],"8":["thread",1419],"9":["thread",132742],"10":["thread",488],"11":["thread",35046],"12":["thread",77897],"13":["thread",1715],"14":["thread",81225],"15":["thread",976],"16":["thread",15930],"18":["thread",27649],"19":["thread",113446],"20":["thread",77253],"21":["thread",96296],"22":["thread",1808],"23":["thread",98967],"24":["thread",119583],"25":["thread",95433],"26":["thread",77012],"27":["thread",137307],"28":["thread",102589],"29":["thread",131320],"30":["thread",55784],"31":["thread",53342],"32":["thread",15425],"33":["thread",6958],"34":["thread",2785],"35":["thread",15118],"36":["thread",28233],"37":["thread",115480],"38":["thread",1967],"39":["thread",72956],"40":["thread",76957],"41":["thread",34249],"42":["thread",86253],"43":["thread",2500],"44":["thread",36859],"45":["thread",117029],"46":["thread",78733],"47":["thread",83093],"48":["thread",1946],"49":["thread",11293],"50":["thread",8310],"51":["thread",82416],"52":["thread",60817],"53":["thread",1739],"54":["thread",89014],"55":["thread",128028],"56":["thread",37417],"57":["thread",80291],"58":["thread",21058],"59":["thread",56885],"60":["thread",76971],"61":["thread",108616],"62":["thread",59927],"63":["thread",6946],"64":["thread",24007],"65":["thread",101043],"66":["thread",133089],"67":["thread",20146],"68":["thread",136859],"69":["thread",126678],"70":["thread",27995],"71":["thread",61389],"72":["thread",1652],"73":["thread",873],"74":["thread",1769],"75":["thread",127131],"76":["thread",77562],"77":["thread",1765],"78":["thread",59528],"79":["thread",85455],"80":["thread",14602],"81":["thread",86508],"82":["thread",98929],"83":["thread",105735],"84":["thread",123264],"85":["thread",78109],"86":["thread",88521],"87":["thread",91128],"88":["thread",22482],"89":["thread",54970],"90":["thread",2024],"91":["thread",1774],"92":["thread",62366],"93":["thread",19456],"94":["thread",107342],"95":["thread",6897],"96":["thread",74375],"97":["thread",1790],"98":["thread",2666],"99":["thread",79069],"100":["thread",113643],"101":["thread",107571],"102":["thread",34213],"103":["thread",1839],"104":["thread",120668],"105":["thread",1745],"106":["thread",45651],"107":["thread",1373],"108":["thread",84336],"109":["thread",115257],"110":["thread",28469],"111":["thread",54468],"112":["thread",870],"113":["thread",44509],"114":["thread",1747],"115":["thread",116679],"116":["thread",29613],"117":["thread",1802],"118":["thread",2092],"119":["thread",11824],"120":["thread",106886],"121":["thread",3931],"122":["thread",127633],"123":["thread",2728],"124":["thread",1843],"125":["thread",18433],"126":["thread",18048],"127":["thread",80162],"128":["thread",6801],"129":["thread",37657],"130":["thread",50113],"131":["thread",128077],"132":["thread",1948],"133":["thread",109945],"134":["thread",82101],"135":["thread",57259],"136":["thread",126723],"137":["thread",94000],"138":["thread",57064],"139":["thread",116411],"140":["thread",111666],"141":["thread",111477],"142":["thread",37048],"143":["thread",24327],"144":["thread",26328],"145":["thread",1899],"146":["thread",2541],"147":["thread",130741],"148":["thread",8625],"149":["thread",8149],"150":["thread",2502],"151":["thread",106521],"152":["thread",2520],"153":["thread",1846],"154":["thread",55954],"155":["thread",86008],"156":["thread",32250],"157":["thread",112261],"158":["thread",123135],"159":["thread",63058],"160":["thread",61131],"161":["thread",14542],"162":["thread",67300],"163":["thread",70936],"164":["thread",128931],"165":["thread",112827],"166":["thread",87338],"167":["thread",63380],"168":["thread",2089],"169":["thread",76368],"170":["thread",2088],"171":["thread",125157],"172":["thread",1858],"173":["thread",121676],"174":["thread",5407],"175":["thread",69316],"176":["thread",98015],"177":["thread",1805],"178":["thread",2488],"179":["thread",111409],"180":["thread",120874],"181":["thread",1773],"182":["thread",11396],"183":["thread",23214],"184":["thread",1152],"185":["thread",119024],"186":["thread",88324],"187":["thread",134875],"188":["thread",128761],"189":["thread",38186],"190":["thread",1520],"191":["thread",6795],"192":["thread",1263],"193":["thread",77306],"194":["thread",24446],"195":["thread",1698],"196":["thread",134338],"197":["thread",1939],"198":["thread",132529],"199":["thread",1896],"200":["thread",1859],"201":["thread",1781],"202":["thread",1570],"203":["thread",24933],"204":["thread",7776],"205":["thread",1789],"206":["thread",112531],"207":["thread",1517],"208":["thread",112247],"209":["thread",135065],"210":["thread",1934],"211":["thread",1909],"212":["thread",65783],"213":["thread",76346],"214":["thread",82655],"215":["thread",58045],"216":["thread",51879],"217":["thread",114229],"218":["thread",1138],"219":["thread",101947],"220":["thread",86107],"221":["thread",55925],"222":["thread",49669],"223":["thread",21264],"224":["thread",79032],"225":["thread",15749],"226":["thread",129238],"227":["thread",32362],"228":["thread",91238],"229":["thread",1768],"230":["thread",2705],"231":["thread",1855],"232":["thread",11395],"233":["thread",77811],"234":["thread",84335],"235":["thread",1828],"236":["thread",30091],"237":["thread",126681],"238":["thread",104253],"239":["thread",123499],"240":["thread",20579],"241":["thread",1908],"242":["thread",53163],"243":["thread",2026],"244":["thread",43070],"245":["thread",125415],"246":["thread",3913],"247":["thread",88517],"248":["thread",21917],"249":["thread",119855],"250":["thread",1844],"251":["thread",1827],"252":["thread",122902],"253":["thread",83737],"254":["thread",1981],"255":["thread",76450],"256":["thread",2498],"257":["thread",90926],"258":["thread",1929],"259":["thread",102361],"260":["thread",1938],"261":["thread",84775],"262":["thread",2511],"263":["thread",19669],"264":["thread",2093],"265":["thread",1951],"266":["thread",28095],"267":["thread",67018],"268":["thread",1940],"269":["thread",128136],"270":["thread",53676],"271":["thread",7330],"272":["thread",107776],"273":["thread",1417],"274":["thread",110999],"275":["thread",15212],"276":["thread",1527],"277":["thread",91043],"278":["thread",103018],"279":["thread",122188],"280":["thread",11410],"281":["thread",54518],"282":["thread",75358],"283":["thread",67513],"284":["thread",89738],"285":["thread",24648],"286":["thread",64481],"287":["thread",84605],"288":["thread",110271],"289":["thread",104318],"290":["thread",16165],"291":["thread",102224],"292":["thread",12008],"293":["thread",90227],"294":["thread",54561],"295":["thread",67714],"296":["thread",12857],"297":["thread",110663],"298":["thread",1772],"299":["thread",1679]}
Run Time: 0.031554
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.000677
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |