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 (114800, 46192, 86333, 64261, 116408, 78042, 93182, 75073, 101066, 55033, 87405, 33445, 132921, 49834, 84080, 37489, 66540, 70757, 52938, 112587, 63748, 91135, 27012, 128424, 13269, 35234, 113966, 120570, 87981, 45672, 90758, 109480, 132756, 128069, 122225, 111282, 67447, 61086, 76950, 119653, 89427, 87814, 74850, 112460, 105024, 7399, 103124, 109187, 10743, 16463, 85049, 35048, 95457, 86954, 70262, 63369, 48382, 120674, 103816, 86353, 116620, 76699, 120707, 125602, 118891, 74614, 98158, 116415, 24203, 28984, 53262, 127174, 88810, 136473, 112380, 113924, 33859, 55156, 84050, 92161, 34109, 120611, 135241, 117637, 124538, 115087, 88283, 119066, 128296, 12878, 46487, 115059, 75472, 84715, 64379, 130096, 111700, 132254, 128708, 131274, 111305, 119878, 132258, 77087, 110321, 95453, 83267, 67443, 13425, 104627, 117371, 126295, 82078, 124168, 63226, 80937, 25215, 49462, 115016, 109741, 118565, 3680, 68580, 123085, 111894, 92075, 106883, 88224, 132221, 85116, 33588, 76399, 112692, 79565, 93914, 25695, 124739, 69117, 110946, 110673, 87726, 115345, 108578, 126302, 125346, 122255, 93894, 121011, 105388, 75475, 90049, 95915, 1476, 117854, 107123, 125538, 89961, 108420, 94512, 127236, 6492, 111036, 116379, 15906, 87489, 91301, 91308, 125011, 57982, 78282, 118872, 60760, 67314, 71346, 111591, 134589, 120206, 105589, 53037, 126072, 45761, 108394, 65835, 111559, 105246, 8595, 70421, 131538, 106203, 101808, 132217, 56049, 119383, 71187, 63849, 127233, 112427, 13221, 126080, 10427, 86925, 76100, 128407, 124945, 112086, 87494, 119850, 69717, 33878, 105315, 72795, 131416, 108418, 69665, 103629, 128024, 107035, 111086, 87562, 46184, 70298, 34105, 109164, 119334, 126006, 132398, 69372, 125002, 132264, 70464, 85391, 94367, 83610, 44384, 110886, 104546, 132297, 84913, 54097, 66511, 125376, 53256, 48304, 38819, 117373, 83727, 10265, 67960, 78572, 109858, 72045, 119848, 72049, 109075, 63225, 127173, 112689, 57959, 64308, 110619, 112030, 71160, 119877, 125845, 11834, 112585, 132154, 105722, 88817, 105948, 33471, 87238, 109260, 49837, 69222, 105695, 3249, 117518, 69342, 105811, 107061, 90151, 64380, 122238, 131161, 108002, 136006, 110181, 68192, 62622, 49340, 134219, 67001, 49836, 64043, 69408, 84506, 135718, 27007, 5553)
Run Time: 0.014699
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: 738, 0, 1713505302, 1713508902, [["thread",114800],["thread",46192],["thread",86333],["thread",64261],["thread",116408],["thread",78042],["thread",93182],["thread",75073],["thread",101066],["thread",55033],["thread",87405],["thread",33445],["thread",132921],["thread",49834],["thread",84080],["thread",37489],["thread",66540],["thread",70757],["thread",52938],["thread",112587],["thread",63748],["thread",91135],["thread",27012],["thread",128424],["thread",13269],["thread",35234],["thread",113966],["thread",120570],["thread",87981],["thread",45672],["thread",90758],["thread",109480],["thread",132756],["thread",128069],["thread",122225],["thread",111282],["thread",67447],["thread",61086],["thread",76950],["thread",119653],["thread",89427],["thread",87814],["thread",74850],["thread",112460],["thread",105024],["thread",7399],["thread",103124],["thread",109187],["thread",10743],["thread",16463],["thread",85049],["thread",35048],["thread",95457],["thread",86954],["thread",70262],["thread",63369],["thread",48382],["thread",120674],["thread",103816],["thread",86353],["thread",116620],["thread",76699],["thread",120707],["thread",125602],["thread",118891],["thread",74614],["thread",98158],["thread",116415],["thread",24203],["thread",28984],["thread",53262],["thread",127174],["thread",88810],["thread",136473],["thread",112380],["thread",113924],["thread",33859],["thread",55156],["thread",84050],["thread",92161],["thread",34109],["thread",120611],["thread",135241],["thread",117637],["thread",124538],["thread",115087],["thread",88283],["thread",119066],["thread",128296],["thread",12878],["thread",46487],["thread",115059],["thread",75472],["thread",84715],["thread",64379],["thread",130096],["thread",111700],["thread",132254],["thread",128708],["thread",131274],["thread",111305],["thread",119878],["thread",132258],["thread",77087],["thread",110321],["thread",95453],["thread",83267],["thread",67443],["thread",13425],["thread",104627],["thread",117371],["thread",126295],["thread",82078],["thread",124168],["thread",63226],["thread",80937],["thread",25215],["thread",49462],["thread",115016],["thread",109741],["thread",118565],["thread",3680],["thread",68580],["thread",123085],["thread",111894],["thread",92075],["thread",106883],["thread",88224],["thread",132221],["thread",85116],["thread",33588],["thread",76399],["thread",112692],["thread",79565],["thread",93914],["thread",25695],["thread",124739],["thread",69117],["thread",110946],["thread",110673],["thread",87726],["thread",115345],["thread",108578],["thread",126302],["thread",125346],["thread",122255],["thread",93894],["thread",121011],["thread",105388],["thread",75475],["thread",90049],["thread",95915],["thread",1476],["thread",117854],["thread",107123],["thread",125538],["thread",89961],["thread",108420],["thread",94512],["thread",127236],["thread",6492],["thread",111036],["thread",116379],["thread",15906],["thread",87489],["thread",91301],["thread",91308],["thread",125011],["thread",57982],["thread",78282],["thread",118872],["thread",60760],["thread",67314],["thread",71346],["thread",111591],["thread",134589],["thread",120206],["thread",105589],["thread",53037],["thread",126072],["thread",45761],["thread",108394],["thread",65835],["thread",111559],["thread",105246],["thread",8595],["thread",70421],["thread",131538],["thread",106203],["thread",101808],["thread",132217],["thread",56049],["thread",119383],["thread",71187],["thread",63849],["thread",127233],["thread",112427],["thread",13221],["thread",126080],["thread",10427],["thread",86925],["thread",76100],["thread",128407],["thread",124945],["thread",112086],["thread",87494],["thread",119850],["thread",69717],["thread",33878],["thread",105315],["thread",72795],["thread",131416],["thread",108418],["thread",69665],["thread",103629],["thread",128024],["thread",107035],["thread",111086],["thread",87562],["thread",46184],["thread",70298],["thread",34105],["thread",109164],["thread",119334],["thread",126006],["thread",132398],["thread",69372],["thread",125002],["thread",132264],["thread",70464],["thread",85391],["thread",94367],["thread",83610],["thread",44384],["thread",110886],["thread",104546],["thread",132297],["thread",84913],["thread",54097],["thread",66511],["thread",125376],["thread",53256],["thread",48304],["thread",38819],["thread",117373],["thread",83727],["thread",10265],["thread",67960],["thread",78572],["thread",109858],["thread",72045],["thread",119848],["thread",72049],["thread",109075],["thread",63225],["thread",127173],["thread",112689],["thread",57959],["thread",64308],["thread",110619],["thread",112030],["thread",71160],["thread",119877],["thread",125845],["thread",11834],["thread",112585],["thread",132154],["thread",105722],["thread",88817],["thread",105948],["thread",33471],["thread",87238],["thread",109260],["thread",49837],["thread",69222],["thread",105695],["thread",3249],["thread",117518],["thread",69342],["thread",105811],["thread",107061],["thread",90151],["thread",64380],["thread",122238],["thread",131161],["thread",108002],["thread",136006],["thread",110181],["thread",68192],["thread",62622],["thread",49340],["thread",134219],["thread",67001],["thread",49836],["thread",64043],["thread",69408],["thread",84506],["thread",135718],["thread",27007],["thread",5553]]
Run Time: 0.002768
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.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |