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 (76292, 109398, 129903, 61547, 65764, 124040, 64284, 110122, 120770, 113711, 72486, 118929, 106966, 132258, 132060, 124368, 68535, 135044, 120888, 79693, 92513, 113878, 121546, 129392, 121028, 127509, 119255, 136683, 114663, 126301, 115008, 132663, 130561, 122048, 68133, 90613, 71514, 114541, 113970, 95535, 119429, 110155, 128714, 121152, 114896, 81192, 87995, 108168, 123357, 115468, 122549, 119570, 123353, 118847, 120399, 124604, 64460, 97636, 133092, 133540, 108972, 131284, 136429, 120571, 80520, 128772, 129395, 115007, 125745, 120034, 129434, 120022, 130520, 76110, 130986, 123347, 119734, 129928, 58429, 67795, 128382, 3652, 132796, 94355, 116099, 137168, 123613, 137158, 135185, 117309, 118983, 80534, 72946, 70540, 84080, 136576, 123426, 136036, 116555, 133417, 114661, 117104, 65262, 114920, 107995, 81960, 120730, 125106, 107664, 135175, 110384, 132284, 135204, 83105, 130167, 107584, 64178, 112793, 118681, 131515, 112964, 113824, 66484, 98027, 1365, 123590, 96646, 96097, 125203, 126247, 114756, 33656, 133881, 115739, 79178, 132266, 90792, 84851, 107396, 108618, 65502, 114741, 121416, 129624, 130274, 106866, 133288, 71027, 120046, 119284, 119730, 107855, 122140, 63671, 112112, 119384, 85156, 1388, 74865, 120519, 136950, 118332, 132509, 113831, 70351, 121628, 109514, 90834, 127541, 134978, 83892, 120110, 122185, 95830, 118904, 112650, 131026, 126737, 129454, 130511, 130113, 132032, 129367, 115787, 828, 110232, 130678, 129831, 105120, 129490, 115325, 60922, 99967, 96032, 120100, 121081, 90790, 129963, 123096, 113316, 134466, 131540, 110023, 132674, 88903, 120949, 15537, 69255, 1360, 87394, 105704, 104226, 120159, 105877, 75869, 120886, 120058, 116440, 119689, 74058, 106646, 71574, 83102, 83164, 117895, 129592, 120411, 60762, 62099, 134572, 116156, 93170, 121920, 130546, 129590, 115516, 122040, 102952, 131181, 131989, 120846, 9046, 123710, 127932, 115728, 53854, 96645, 127451, 126410, 134892, 120453, 129170, 3605, 118626, 3910, 125707, 124153, 77009, 129714, 99300, 74716, 67917, 66937, 118658, 97396, 113074, 111051, 73462, 130046, 438, 118498, 81169, 121898, 80557, 84859, 95752, 120114, 127446, 93966, 135396, 132168, 76442, 124585, 113321, 126231, 136613, 83429, 130503, 132691, 126314, 102420, 113860, 80726, 120666, 115987, 135912, 115657, 136221, 431, 113651)
Run Time: 0.012952
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: 21, 0, 1715235469, 1715239069, [["thread",76292],["thread",109398],["thread",129903],["thread",61547],["thread",65764],["thread",124040],["thread",64284],["thread",110122],["thread",120770],["thread",113711],["thread",72486],["thread",118929],["thread",106966],["thread",132258],["thread",132060],["thread",124368],["thread",68535],["thread",135044],["thread",120888],["thread",79693],["thread",92513],["thread",113878],["thread",121546],["thread",129392],["thread",121028],["thread",127509],["thread",119255],["thread",136683],["thread",114663],["thread",126301],["thread",115008],["thread",132663],["thread",130561],["thread",122048],["thread",68133],["thread",90613],["thread",71514],["thread",114541],["thread",113970],["thread",95535],["thread",119429],["thread",110155],["thread",128714],["thread",121152],["thread",114896],["thread",81192],["thread",87995],["thread",108168],["thread",123357],["thread",115468],["thread",122549],["thread",119570],["thread",123353],["thread",118847],["thread",120399],["thread",124604],["thread",64460],["thread",97636],["thread",133092],["thread",133540],["thread",108972],["thread",131284],["thread",136429],["thread",120571],["thread",80520],["thread",128772],["thread",129395],["thread",115007],["thread",125745],["thread",120034],["thread",129434],["thread",120022],["thread",130520],["thread",76110],["thread",130986],["thread",123347],["thread",119734],["thread",129928],["thread",58429],["thread",67795],["thread",128382],["thread",3652],["thread",132796],["thread",94355],["thread",116099],["thread",137168],["thread",123613],["thread",137158],["thread",135185],["thread",117309],["thread",118983],["thread",80534],["thread",72946],["thread",70540],["thread",84080],["thread",136576],["thread",123426],["thread",136036],["thread",116555],["thread",133417],["thread",114661],["thread",117104],["thread",65262],["thread",114920],["thread",107995],["thread",81960],["thread",120730],["thread",125106],["thread",107664],["thread",135175],["thread",110384],["thread",132284],["thread",135204],["thread",83105],["thread",130167],["thread",107584],["thread",64178],["thread",112793],["thread",118681],["thread",131515],["thread",112964],["thread",113824],["thread",66484],["thread",98027],["thread",1365],["thread",123590],["thread",96646],["thread",96097],["thread",125203],["thread",126247],["thread",114756],["thread",33656],["thread",133881],["thread",115739],["thread",79178],["thread",132266],["thread",90792],["thread",84851],["thread",107396],["thread",108618],["thread",65502],["thread",114741],["thread",121416],["thread",129624],["thread",130274],["thread",106866],["thread",133288],["thread",71027],["thread",120046],["thread",119284],["thread",119730],["thread",107855],["thread",122140],["thread",63671],["thread",112112],["thread",119384],["thread",85156],["thread",1388],["thread",74865],["thread",120519],["thread",136950],["thread",118332],["thread",132509],["thread",113831],["thread",70351],["thread",121628],["thread",109514],["thread",90834],["thread",127541],["thread",134978],["thread",83892],["thread",120110],["thread",122185],["thread",95830],["thread",118904],["thread",112650],["thread",131026],["thread",126737],["thread",129454],["thread",130511],["thread",130113],["thread",132032],["thread",129367],["thread",115787],["thread",828],["thread",110232],["thread",130678],["thread",129831],["thread",105120],["thread",129490],["thread",115325],["thread",60922],["thread",99967],["thread",96032],["thread",120100],["thread",121081],["thread",90790],["thread",129963],["thread",123096],["thread",113316],["thread",134466],["thread",131540],["thread",110023],["thread",132674],["thread",88903],["thread",120949],["thread",15537],["thread",69255],["thread",1360],["thread",87394],["thread",105704],["thread",104226],["thread",120159],["thread",105877],["thread",75869],["thread",120886],["thread",120058],["thread",116440],["thread",119689],["thread",74058],["thread",106646],["thread",71574],["thread",83102],["thread",83164],["thread",117895],["thread",129592],["thread",120411],["thread",60762],["thread",62099],["thread",134572],["thread",116156],["thread",93170],["thread",121920],["thread",130546],["thread",129590],["thread",115516],["thread",122040],["thread",102952],["thread",131181],["thread",131989],["thread",120846],["thread",9046],["thread",123710],["thread",127932],["thread",115728],["thread",53854],["thread",96645],["thread",127451],["thread",126410],["thread",134892],["thread",120453],["thread",129170],["thread",3605],["thread",118626],["thread",3910],["thread",125707],["thread",124153],["thread",77009],["thread",129714],["thread",99300],["thread",74716],["thread",67917],["thread",66937],["thread",118658],["thread",97396],["thread",113074],["thread",111051],["thread",73462],["thread",130046],["thread",438],["thread",118498],["thread",81169],["thread",121898],["thread",80557],["thread",84859],["thread",95752],["thread",120114],["thread",127446],["thread",93966],["thread",135396],["thread",132168],["thread",76442],["thread",124585],["thread",113321],["thread",126231],["thread",136613],["thread",83429],["thread",130503],["thread",132691],["thread",126314],["thread",102420],["thread",113860],["thread",80726],["thread",120666],["thread",115987],["thread",135912],["thread",115657],["thread",136221],["thread",431],["thread",113651]]
Run Time: 0.042606
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.000115
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |