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 (31229, 111281, 17695, 85563, 92629, 2869, 83235, 116403, 88428, 8690, 12123, 9117, 123499, 128704, 37417, 33810, 6795, 55166, 83015, 1814, 32308, 1376, 5407, 44016, 67003, 124242, 1375, 26901, 1899, 59735, 1680, 1377, 24733, 79144, 2488, 115187, 101043, 1932, 1806, 24510, 82176, 111033, 37826, 76160, 1760, 28237, 61064, 13824, 76119, 2721, 114272, 45652, 68513, 11824, 90930, 1598, 8381, 75542, 31118, 1534, 1849, 39816, 55411, 954, 518, 1949, 121825, 84312, 4890, 96447, 1852, 7777, 74246, 53976, 20579, 2755, 55954, 113868, 7518, 100193, 2021, 67123, 72418, 1789, 2485, 1782, 82768, 96424, 28028, 96532, 101295, 1826, 128562, 1378, 66557, 57746, 71300, 67109, 101006, 24007, 34249, 1673, 5583, 67306, 93209, 1784, 99775, 6801, 128146, 42628, 112260, 128087, 86103, 135065, 1756, 66762, 75571, 1422, 37093, 109158, 17632, 64339, 124858, 1848, 90146, 53676, 106886, 51285, 1797, 108874, 1839, 2500, 126678, 125786, 1924, 76978, 55393, 67233, 25262, 23562, 93984, 1803, 1389, 2536, 110663, 1232, 7117, 8987, 1956, 1154, 104318, 95433, 94584, 90453, 21983, 78031, 71972, 110271, 52084, 15212, 74726, 2548, 33802, 20777, 127549, 1763, 27753, 50465, 75526, 45651, 2785, 54161, 76971, 27070, 107769, 15646, 112247, 27910, 124363, 80269, 1514, 2018, 77008, 1900, 130209, 74151, 82416, 27649, 2087, 77307, 1847, 7334, 28095, 66956, 82917, 54310, 38707, 74587, 21761, 1836, 11392, 99541, 1736, 72416, 1821, 2921, 55920, 85851, 102605, 24619, 48813, 104922, 117747, 77253, 54167, 134270, 1903, 113903, 2490, 1781, 12857, 2504, 115257, 79735, 19456, 126506, 88521, 2140, 74974, 14984, 105658, 34561, 82013, 17150, 1610, 3455, 15967, 96649, 1834, 116358, 55044, 116536, 2736, 2088, 84335, 2076, 46288, 2513, 1838, 85850, 51420, 1948, 107571, 84486, 20211, 27869, 1509, 35384, 1857, 76773, 19593, 956, 19669, 129238, 71480, 2503, 94966, 84077, 57413, 109640, 94000, 1922, 75477, 95096, 45791, 2022, 80535, 106100, 108724, 123688, 81491, 5998, 1914, 133150, 2517, 76645, 1846, 127849, 14602, 84482, 1788, 95466, 79977, 1510, 91636, 15333, 77426, 1945, 80034, 1967)
Run Time: 0.008236
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, 1713498055, 1713501655, {"0":["thread",31229],"1":["thread",111281],"2":["thread",17695],"3":["thread",85563],"4":["thread",92629],"5":["thread",2869],"6":["thread",83235],"7":["thread",116403],"8":["thread",88428],"9":["thread",8690],"10":["thread",12123],"11":["thread",9117],"12":["thread",123499],"13":["thread",128704],"14":["thread",37417],"15":["thread",33810],"16":["thread",6795],"17":["thread",55166],"18":["thread",83015],"19":["thread",1814],"20":["thread",32308],"21":["thread",1376],"22":["thread",5407],"23":["thread",44016],"24":["thread",67003],"25":["thread",124242],"26":["thread",1375],"27":["thread",26901],"28":["thread",1899],"29":["thread",59735],"30":["thread",1680],"31":["thread",1377],"32":["thread",24733],"33":["thread",79144],"34":["thread",2488],"35":["thread",115187],"36":["thread",101043],"37":["thread",1932],"38":["thread",1806],"39":["thread",24510],"40":["thread",82176],"41":["thread",111033],"42":["thread",37826],"43":["thread",76160],"44":["thread",1760],"45":["thread",28237],"46":["thread",61064],"47":["thread",13824],"48":["thread",76119],"49":["thread",2721],"50":["thread",114272],"51":["thread",45652],"52":["thread",68513],"53":["thread",11824],"54":["thread",90930],"55":["thread",1598],"56":["thread",8381],"57":["thread",75542],"58":["thread",31118],"60":["thread",1849],"61":["thread",39816],"62":["thread",55411],"63":["thread",954],"64":["thread",518],"65":["thread",1949],"66":["thread",121825],"67":["thread",84312],"68":["thread",4890],"69":["thread",96447],"70":["thread",1852],"71":["thread",7777],"72":["thread",74246],"73":["thread",53976],"74":["thread",20579],"75":["thread",2755],"76":["thread",55954],"77":["thread",113868],"78":["thread",7518],"79":["thread",100193],"80":["thread",2021],"81":["thread",67123],"82":["thread",72418],"83":["thread",1789],"84":["thread",2485],"85":["thread",1782],"86":["thread",82768],"87":["thread",96424],"88":["thread",28028],"89":["thread",96532],"90":["thread",101295],"91":["thread",1826],"92":["thread",128562],"93":["thread",1378],"94":["thread",66557],"95":["thread",57746],"96":["thread",71300],"97":["thread",67109],"98":["thread",101006],"99":["thread",24007],"100":["thread",34249],"101":["thread",1673],"102":["thread",5583],"103":["thread",67306],"104":["thread",93209],"105":["thread",1784],"106":["thread",99775],"107":["thread",6801],"108":["thread",128146],"109":["thread",42628],"110":["thread",112260],"111":["thread",128087],"112":["thread",86103],"113":["thread",135065],"114":["thread",1756],"115":["thread",66762],"116":["thread",75571],"117":["thread",1422],"118":["thread",37093],"119":["thread",109158],"120":["thread",17632],"121":["thread",64339],"122":["thread",124858],"123":["thread",1848],"124":["thread",90146],"125":["thread",53676],"126":["thread",106886],"127":["thread",51285],"128":["thread",1797],"129":["thread",108874],"130":["thread",1839],"131":["thread",2500],"132":["thread",126678],"133":["thread",125786],"134":["thread",1924],"135":["thread",76978],"136":["thread",55393],"137":["thread",67233],"138":["thread",25262],"139":["thread",23562],"140":["thread",93984],"141":["thread",1803],"142":["thread",1389],"143":["thread",2536],"144":["thread",110663],"145":["thread",1232],"146":["thread",7117],"147":["thread",8987],"148":["thread",1956],"149":["thread",1154],"150":["thread",104318],"151":["thread",95433],"152":["thread",94584],"153":["thread",90453],"154":["thread",21983],"155":["thread",78031],"156":["thread",71972],"157":["thread",110271],"158":["thread",52084],"159":["thread",15212],"160":["thread",74726],"161":["thread",2548],"162":["thread",33802],"163":["thread",20777],"164":["thread",127549],"165":["thread",1763],"166":["thread",27753],"167":["thread",50465],"168":["thread",75526],"169":["thread",45651],"170":["thread",2785],"171":["thread",54161],"172":["thread",76971],"173":["thread",27070],"174":["thread",107769],"175":["thread",15646],"176":["thread",112247],"177":["thread",27910],"178":["thread",124363],"179":["thread",80269],"180":["thread",1514],"181":["thread",2018],"182":["thread",77008],"183":["thread",1900],"184":["thread",130209],"185":["thread",74151],"186":["thread",82416],"187":["thread",27649],"188":["thread",2087],"189":["thread",77307],"190":["thread",1847],"191":["thread",7334],"192":["thread",28095],"193":["thread",66956],"194":["thread",82917],"195":["thread",54310],"196":["thread",38707],"197":["thread",74587],"198":["thread",21761],"199":["thread",1836],"200":["thread",11392],"201":["thread",99541],"202":["thread",1736],"203":["thread",72416],"204":["thread",1821],"205":["thread",2921],"206":["thread",55920],"207":["thread",85851],"208":["thread",102605],"209":["thread",24619],"210":["thread",48813],"211":["thread",104922],"212":["thread",117747],"213":["thread",77253],"214":["thread",54167],"215":["thread",134270],"216":["thread",1903],"217":["thread",113903],"218":["thread",2490],"219":["thread",1781],"220":["thread",12857],"221":["thread",2504],"222":["thread",115257],"223":["thread",79735],"224":["thread",19456],"225":["thread",126506],"226":["thread",88521],"227":["thread",2140],"228":["thread",74974],"229":["thread",14984],"230":["thread",105658],"231":["thread",34561],"232":["thread",82013],"233":["thread",17150],"234":["thread",1610],"235":["thread",3455],"236":["thread",15967],"237":["thread",96649],"238":["thread",1834],"239":["thread",116358],"240":["thread",55044],"241":["thread",116536],"242":["thread",2736],"243":["thread",2088],"244":["thread",84335],"245":["thread",2076],"246":["thread",46288],"247":["thread",2513],"248":["thread",1838],"249":["thread",85850],"250":["thread",51420],"251":["thread",1948],"252":["thread",107571],"253":["thread",84486],"254":["thread",20211],"255":["thread",27869],"256":["thread",1509],"257":["thread",35384],"258":["thread",1857],"259":["thread",76773],"260":["thread",19593],"261":["thread",956],"262":["thread",19669],"263":["thread",129238],"264":["thread",71480],"265":["thread",2503],"266":["thread",94966],"267":["thread",84077],"268":["thread",57413],"269":["thread",109640],"270":["thread",94000],"271":["thread",1922],"272":["thread",75477],"273":["thread",95096],"274":["thread",45791],"275":["thread",2022],"276":["thread",80535],"277":["thread",106100],"278":["thread",108724],"279":["thread",123688],"280":["thread",81491],"281":["thread",5998],"282":["thread",1914],"283":["thread",133150],"284":["thread",2517],"285":["thread",76645],"286":["thread",1846],"287":["thread",127849],"288":["thread",14602],"289":["thread",84482],"290":["thread",1788],"291":["thread",95466],"292":["thread",79977],"293":["thread",1510],"294":["thread",91636],"295":["thread",15333],"296":["thread",77426],"297":["thread",1945],"298":["thread",80034],"299":["thread",1967]}
Run Time: 0.001265
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.000064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |