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 (53815, 85570, 93176, 36374, 50352, 23441, 65617, 74769, 40550, 133205, 117155, 101557, 53803, 106414, 119636, 72195, 37466, 6368, 42873, 53749, 30967, 35679, 125868, 105946, 56264, 108271, 42338, 68931, 93433, 113979, 110895, 53700, 87821, 55040, 129643, 66429, 65872, 37244, 106655, 96330, 58218, 80370, 92119, 90230, 83395, 64418, 100313, 118140, 91342, 53555, 40909, 100445, 57602, 101546, 64171, 45955, 96325, 71782, 53531, 14352, 103819, 98157, 63098, 105979, 94210, 66431, 36349, 101542, 121151, 96284, 93361, 106483, 108142, 111836, 126355, 79110, 120008, 135739, 86083, 128868, 117437, 38893, 115554, 111204, 115729, 132397, 66118, 88854, 122607, 102136, 107339, 85642, 23253, 110256, 133233, 32046, 83367, 53346, 106890, 23073, 19469, 80059, 105540, 72234, 68020, 134716, 26830, 66222, 37834, 11430, 49141, 127611, 57777, 69292, 47034, 36021, 51603, 87969, 81445, 113529, 107116, 34554, 118926, 102441, 104060, 86323, 83976, 98086, 106257, 121421, 70546, 42784, 76308, 129277, 98928, 121221, 79704, 59367, 95182, 43865, 108165, 64755, 25904, 72343, 103813, 111348, 114075, 86993, 118748, 62793, 43906, 120932, 73776, 59848, 71855, 60423, 65212, 51364, 95801, 127186, 107583, 58988, 109958, 119533, 75506, 99530, 79870, 108992, 69047, 105594, 118474, 95734, 92098, 70032, 72817, 23290, 92492, 86749, 98345, 44833, 96541, 70820, 111144, 73174, 79327, 128422, 136560, 52714, 47580, 92777, 109645, 65890, 44399, 70218, 124645, 110388, 87527, 76509, 97331, 118133, 74002, 7544, 129897, 55947, 125081, 117462, 104448, 127593, 123965, 37140, 37041, 129407, 106647, 110429, 57502, 68647, 90435, 72596, 69783, 46451, 131120, 62000, 52419, 97746, 45677, 67563, 56630, 63713, 128332, 78991, 98402, 79888, 39010, 106019, 54712, 90140, 98906, 88741, 101912, 130599, 101753, 90754, 88703, 111846, 66440, 134411, 110060, 122868, 99994, 61372, 116329, 125033, 104490, 110839, 53458, 84680, 127843, 84651, 83407, 122187, 129252, 132195, 88214, 81797, 88213, 125192, 116656, 70081, 119421, 50303, 37467, 115030, 134131, 129520, 66121, 125398, 120412, 125093, 24556, 128503, 71729, 135214, 117194, 69007, 23440, 95888, 108219, 133678, 72842, 44603, 36363, 128685, 128035, 116328, 127498, 123876, 132169, 114022, 68208, 48407)
Run Time: 0.027152
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: 1369, 0, 1714114068, 1714117668, {"0":["thread",53815],"1":["thread",85570],"2":["thread",93176],"3":["thread",36374],"4":["thread",50352],"5":["thread",23441],"6":["thread",65617],"7":["thread",74769],"8":["thread",40550],"9":["thread",133205],"10":["thread",117155],"11":["thread",101557],"12":["thread",53803],"13":["thread",106414],"14":["thread",119636],"15":["thread",72195],"16":["thread",37466],"17":["thread",6368],"18":["thread",42873],"19":["thread",53749],"20":["thread",30967],"21":["thread",35679],"22":["thread",125868],"23":["thread",105946],"24":["thread",56264],"25":["thread",108271],"26":["thread",42338],"27":["thread",68931],"28":["thread",93433],"29":["thread",113979],"30":["thread",110895],"31":["thread",53700],"32":["thread",87821],"33":["thread",55040],"34":["thread",129643],"35":["thread",66429],"36":["thread",65872],"37":["thread",37244],"38":["thread",106655],"39":["thread",96330],"40":["thread",58218],"41":["thread",80370],"42":["thread",92119],"43":["thread",90230],"44":["thread",83395],"45":["thread",64418],"46":["thread",100313],"47":["thread",118140],"48":["thread",91342],"49":["thread",53555],"50":["thread",40909],"51":["thread",100445],"52":["thread",57602],"53":["thread",101546],"54":["thread",64171],"55":["thread",45955],"56":["thread",96325],"57":["thread",71782],"58":["thread",53531],"59":["thread",14352],"60":["thread",103819],"61":["thread",98157],"62":["thread",63098],"63":["thread",105979],"64":["thread",94210],"65":["thread",66431],"66":["thread",36349],"67":["thread",101542],"68":["thread",121151],"69":["thread",96284],"70":["thread",93361],"71":["thread",106483],"72":["thread",108142],"73":["thread",111836],"74":["thread",126355],"75":["thread",79110],"76":["thread",120008],"77":["thread",135739],"78":["thread",86083],"79":["thread",128868],"80":["thread",117437],"81":["thread",38893],"82":["thread",115554],"83":["thread",111204],"84":["thread",115729],"85":["thread",132397],"86":["thread",66118],"87":["thread",88854],"88":["thread",122607],"89":["thread",102136],"90":["thread",107339],"91":["thread",85642],"92":["thread",23253],"93":["thread",110256],"94":["thread",133233],"95":["thread",32046],"96":["thread",83367],"97":["thread",53346],"98":["thread",106890],"99":["thread",23073],"100":["thread",19469],"101":["thread",80059],"102":["thread",105540],"103":["thread",72234],"104":["thread",68020],"105":["thread",134716],"106":["thread",26830],"107":["thread",66222],"108":["thread",37834],"109":["thread",11430],"110":["thread",49141],"111":["thread",127611],"112":["thread",57777],"113":["thread",69292],"114":["thread",47034],"115":["thread",36021],"116":["thread",51603],"117":["thread",87969],"118":["thread",81445],"119":["thread",113529],"120":["thread",107116],"121":["thread",34554],"122":["thread",118926],"123":["thread",102441],"124":["thread",104060],"125":["thread",86323],"126":["thread",83976],"127":["thread",98086],"128":["thread",106257],"129":["thread",121421],"130":["thread",70546],"131":["thread",42784],"132":["thread",76308],"133":["thread",129277],"134":["thread",98928],"135":["thread",121221],"136":["thread",79704],"137":["thread",59367],"138":["thread",95182],"139":["thread",43865],"140":["thread",108165],"141":["thread",64755],"142":["thread",25904],"143":["thread",72343],"144":["thread",103813],"145":["thread",111348],"146":["thread",114075],"147":["thread",86993],"148":["thread",118748],"149":["thread",62793],"150":["thread",43906],"151":["thread",120932],"152":["thread",73776],"153":["thread",59848],"154":["thread",71855],"155":["thread",60423],"157":["thread",51364],"158":["thread",95801],"159":["thread",127186],"160":["thread",107583],"161":["thread",58988],"162":["thread",109958],"163":["thread",119533],"164":["thread",75506],"165":["thread",99530],"166":["thread",79870],"167":["thread",108992],"168":["thread",69047],"169":["thread",105594],"170":["thread",118474],"171":["thread",95734],"172":["thread",92098],"173":["thread",70032],"174":["thread",72817],"175":["thread",23290],"176":["thread",92492],"177":["thread",86749],"178":["thread",98345],"179":["thread",44833],"180":["thread",96541],"181":["thread",70820],"182":["thread",111144],"183":["thread",73174],"184":["thread",79327],"185":["thread",128422],"186":["thread",136560],"187":["thread",52714],"188":["thread",47580],"189":["thread",92777],"190":["thread",109645],"191":["thread",65890],"192":["thread",44399],"193":["thread",70218],"194":["thread",124645],"195":["thread",110388],"196":["thread",87527],"197":["thread",76509],"198":["thread",97331],"199":["thread",118133],"200":["thread",74002],"201":["thread",7544],"202":["thread",129897],"203":["thread",55947],"204":["thread",125081],"205":["thread",117462],"206":["thread",104448],"207":["thread",127593],"208":["thread",123965],"209":["thread",37140],"210":["thread",37041],"211":["thread",129407],"212":["thread",106647],"213":["thread",110429],"214":["thread",57502],"215":["thread",68647],"216":["thread",90435],"217":["thread",72596],"218":["thread",69783],"219":["thread",46451],"220":["thread",131120],"221":["thread",62000],"222":["thread",52419],"223":["thread",97746],"224":["thread",45677],"225":["thread",67563],"226":["thread",56630],"227":["thread",63713],"228":["thread",128332],"229":["thread",78991],"230":["thread",98402],"231":["thread",79888],"232":["thread",39010],"233":["thread",106019],"234":["thread",54712],"235":["thread",90140],"236":["thread",98906],"237":["thread",88741],"238":["thread",101912],"239":["thread",130599],"240":["thread",101753],"241":["thread",90754],"242":["thread",88703],"243":["thread",111846],"244":["thread",66440],"245":["thread",134411],"246":["thread",110060],"247":["thread",122868],"248":["thread",99994],"249":["thread",61372],"250":["thread",116329],"251":["thread",125033],"252":["thread",104490],"253":["thread",110839],"254":["thread",53458],"255":["thread",84680],"256":["thread",127843],"257":["thread",84651],"258":["thread",83407],"259":["thread",122187],"260":["thread",129252],"261":["thread",132195],"262":["thread",88214],"263":["thread",81797],"264":["thread",88213],"265":["thread",125192],"266":["thread",116656],"267":["thread",70081],"268":["thread",119421],"269":["thread",50303],"270":["thread",37467],"271":["thread",115030],"272":["thread",134131],"273":["thread",129520],"274":["thread",66121],"275":["thread",125398],"276":["thread",120412],"277":["thread",125093],"278":["thread",24556],"279":["thread",128503],"280":["thread",71729],"281":["thread",135214],"282":["thread",117194],"283":["thread",69007],"284":["thread",23440],"285":["thread",95888],"286":["thread",108219],"287":["thread",133678],"288":["thread",72842],"289":["thread",44603],"290":["thread",36363],"291":["thread",128685],"292":["thread",128035],"293":["thread",116328],"294":["thread",127498],"295":["thread",123876],"296":["thread",132169],"297":["thread",114022],"298":["thread",68208],"299":["thread",48407]}
Run Time: 0.003678
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.000273
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |