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 (83682, 11221, 98236, 45655, 129107, 96869, 84394, 75637, 78583, 79404, 436, 78607, 75497, 117239, 115106, 790, 81447, 51576, 112901, 44464, 83293, 75817, 98928, 858, 78302, 82698, 45409, 77018, 121814, 92069, 132362, 83440, 86838, 108367, 747, 115604, 45333, 55187, 81881, 89079, 74917, 123079, 80643, 74613, 95315, 49939, 107523, 1886, 123495, 75071, 95983, 95090, 81103, 78513, 45175, 99574, 78416, 76625, 66736, 125190, 78658, 79564, 95244, 121984, 79530, 79349, 75380, 79981, 103313, 74265, 32779, 45066, 120295, 78309, 125942, 75620, 79271, 91427, 25781, 120051, 65268, 75465, 1881, 75160, 498, 67398, 77238, 107198, 111911, 81829, 120454, 120372, 100622, 612, 93583, 78381, 77144, 75301, 124498, 91709, 80098, 105942, 1884, 78866, 50727, 83057, 89552, 120400, 66721, 81690, 104154, 82325, 128093, 75051, 106533, 83853, 49835, 52765, 94467, 81951, 110239, 90735, 70346, 47918, 85093, 115349, 78336, 78656, 78550, 80866, 105133, 113176, 74217, 51141, 93066, 79779, 75369, 77043, 113961, 119888, 81523, 75409, 81434, 108954, 128837, 74751, 120470, 123569, 65058, 74928, 75608, 74110, 50363, 84275, 73212, 114214, 103428, 120296, 97202, 49816, 896, 74162, 100249, 72839, 80911, 96411, 129882, 11323, 74542, 90414, 112411, 118347, 87632, 77019, 78407, 49999, 82920, 85212, 79261, 1190, 76764, 79269, 74547, 75034, 81998, 72778, 81984, 121584, 75767, 78272, 94092, 78329, 93732, 78314, 75906, 93738, 81119, 75323, 74966, 75194, 104326, 75285, 44589, 76472, 134713, 122360, 90516, 109491, 125700, 1195, 81664, 81946, 92525, 74835, 74816, 76828, 117483, 80459, 101327, 118703, 77139, 77437, 1882, 79876, 82070, 72302, 82370, 93236, 74670, 76507, 111648, 83411, 95873, 80368, 121571, 98623, 121679, 83848, 107777, 74602, 88419, 75413, 74817, 107643, 82725, 89333, 104498, 81981, 95489, 97252, 123881, 11332, 100414, 85217, 75476, 80228, 74981, 114971, 618, 473, 81517, 76686, 83542, 121305, 76619, 91758, 74761, 81532, 102481, 82061, 78252, 76259, 79331, 80537, 76675, 61561, 73329, 79447, 12060, 88271, 81487, 79914, 78698, 80095, 1230, 92167, 92103, 93468, 80877, 78719, 121912, 77544, 50153, 51117, 78311, 94423, 81701, 79278, 120727, 82706)
Run Time: 0.018944
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: 61, 0, 1715925651, 1715929251, {"0":["thread",83682],"1":["thread",11221],"2":["thread",98236],"3":["thread",45655],"4":["thread",129107],"5":["thread",96869],"6":["thread",84394],"7":["thread",75637],"8":["thread",78583],"10":["thread",436],"11":["thread",78607],"12":["thread",75497],"13":["thread",117239],"14":["thread",115106],"15":["thread",790],"16":["thread",81447],"17":["thread",51576],"18":["thread",112901],"19":["thread",44464],"20":["thread",83293],"21":["thread",75817],"22":["thread",98928],"23":["thread",858],"24":["thread",78302],"25":["thread",82698],"26":["thread",45409],"27":["thread",77018],"28":["thread",121814],"29":["thread",92069],"30":["thread",132362],"31":["thread",83440],"32":["thread",86838],"33":["thread",108367],"34":["thread",747],"35":["thread",115604],"36":["thread",45333],"37":["thread",55187],"38":["thread",81881],"39":["thread",89079],"40":["thread",74917],"41":["thread",123079],"42":["thread",80643],"43":["thread",74613],"44":["thread",95315],"45":["thread",49939],"46":["thread",107523],"47":["thread",1886],"48":["thread",123495],"49":["thread",75071],"50":["thread",95983],"51":["thread",95090],"52":["thread",81103],"53":["thread",78513],"54":["thread",45175],"55":["thread",99574],"56":["thread",78416],"57":["thread",76625],"58":["thread",66736],"59":["thread",125190],"60":["thread",78658],"61":["thread",79564],"62":["thread",95244],"63":["thread",121984],"64":["thread",79530],"65":["thread",79349],"66":["thread",75380],"67":["thread",79981],"68":["thread",103313],"69":["thread",74265],"70":["thread",32779],"71":["thread",45066],"72":["thread",120295],"73":["thread",78309],"74":["thread",125942],"75":["thread",75620],"76":["thread",79271],"77":["thread",91427],"78":["thread",25781],"79":["thread",120051],"80":["thread",65268],"81":["thread",75465],"82":["thread",1881],"83":["thread",75160],"84":["thread",498],"85":["thread",67398],"86":["thread",77238],"87":["thread",107198],"88":["thread",111911],"89":["thread",81829],"90":["thread",120454],"91":["thread",120372],"92":["thread",100622],"93":["thread",612],"94":["thread",93583],"95":["thread",78381],"96":["thread",77144],"97":["thread",75301],"98":["thread",124498],"99":["thread",91709],"100":["thread",80098],"101":["thread",105942],"102":["thread",1884],"103":["thread",78866],"104":["thread",50727],"105":["thread",83057],"106":["thread",89552],"107":["thread",120400],"108":["thread",66721],"109":["thread",81690],"110":["thread",104154],"111":["thread",82325],"112":["thread",128093],"113":["thread",75051],"114":["thread",106533],"115":["thread",83853],"116":["thread",49835],"117":["thread",52765],"118":["thread",94467],"119":["thread",81951],"120":["thread",110239],"121":["thread",90735],"122":["thread",70346],"123":["thread",47918],"124":["thread",85093],"125":["thread",115349],"126":["thread",78336],"127":["thread",78656],"128":["thread",78550],"129":["thread",80866],"130":["thread",105133],"131":["thread",113176],"132":["thread",74217],"133":["thread",51141],"134":["thread",93066],"135":["thread",79779],"136":["thread",75369],"137":["thread",77043],"138":["thread",113961],"139":["thread",119888],"140":["thread",81523],"141":["thread",75409],"142":["thread",81434],"143":["thread",108954],"144":["thread",128837],"145":["thread",74751],"146":["thread",120470],"147":["thread",123569],"148":["thread",65058],"149":["thread",74928],"150":["thread",75608],"151":["thread",74110],"152":["thread",50363],"153":["thread",84275],"154":["thread",73212],"155":["thread",114214],"156":["thread",103428],"157":["thread",120296],"158":["thread",97202],"159":["thread",49816],"160":["thread",896],"161":["thread",74162],"162":["thread",100249],"163":["thread",72839],"164":["thread",80911],"165":["thread",96411],"166":["thread",129882],"167":["thread",11323],"168":["thread",74542],"169":["thread",90414],"170":["thread",112411],"171":["thread",118347],"172":["thread",87632],"173":["thread",77019],"174":["thread",78407],"175":["thread",49999],"176":["thread",82920],"177":["thread",85212],"178":["thread",79261],"179":["thread",1190],"180":["thread",76764],"181":["thread",79269],"182":["thread",74547],"183":["thread",75034],"184":["thread",81998],"185":["thread",72778],"186":["thread",81984],"187":["thread",121584],"188":["thread",75767],"189":["thread",78272],"190":["thread",94092],"191":["thread",78329],"192":["thread",93732],"193":["thread",78314],"194":["thread",75906],"195":["thread",93738],"196":["thread",81119],"197":["thread",75323],"198":["thread",74966],"199":["thread",75194],"200":["thread",104326],"201":["thread",75285],"202":["thread",44589],"203":["thread",76472],"204":["thread",134713],"205":["thread",122360],"206":["thread",90516],"207":["thread",109491],"208":["thread",125700],"209":["thread",1195],"210":["thread",81664],"211":["thread",81946],"212":["thread",92525],"213":["thread",74835],"214":["thread",74816],"215":["thread",76828],"216":["thread",117483],"217":["thread",80459],"218":["thread",101327],"219":["thread",118703],"220":["thread",77139],"221":["thread",77437],"222":["thread",1882],"223":["thread",79876],"224":["thread",82070],"225":["thread",72302],"226":["thread",82370],"227":["thread",93236],"228":["thread",74670],"229":["thread",76507],"230":["thread",111648],"231":["thread",83411],"232":["thread",95873],"233":["thread",80368],"234":["thread",121571],"235":["thread",98623],"236":["thread",121679],"237":["thread",83848],"238":["thread",107777],"239":["thread",74602],"240":["thread",88419],"241":["thread",75413],"242":["thread",74817],"243":["thread",107643],"244":["thread",82725],"245":["thread",89333],"246":["thread",104498],"247":["thread",81981],"248":["thread",95489],"249":["thread",97252],"250":["thread",123881],"251":["thread",11332],"252":["thread",100414],"253":["thread",85217],"254":["thread",75476],"255":["thread",80228],"256":["thread",74981],"257":["thread",114971],"258":["thread",618],"259":["thread",473],"260":["thread",81517],"261":["thread",76686],"262":["thread",83542],"263":["thread",121305],"264":["thread",76619],"265":["thread",91758],"266":["thread",74761],"267":["thread",81532],"268":["thread",102481],"269":["thread",82061],"270":["thread",78252],"271":["thread",76259],"272":["thread",79331],"273":["thread",80537],"274":["thread",76675],"275":["thread",61561],"276":["thread",73329],"277":["thread",79447],"278":["thread",12060],"279":["thread",88271],"280":["thread",81487],"281":["thread",79914],"282":["thread",78698],"283":["thread",80095],"284":["thread",1230],"285":["thread",92167],"286":["thread",92103],"287":["thread",93468],"288":["thread",80877],"289":["thread",78719],"290":["thread",121912],"291":["thread",77544],"292":["thread",50153],"293":["thread",51117],"294":["thread",78311],"295":["thread",94423],"296":["thread",81701],"297":["thread",79278],"298":["thread",120727],"299":["thread",82706]}
Run Time: 0.038871
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.003464
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |