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 (118389, 135275, 122813, 120020, 134148, 129134, 116957, 94728, 121059, 136778, 123046, 119728, 136868, 135491, 122093, 72553, 130288, 71358, 130016, 136334, 49560, 127343, 119615, 130749, 131550, 134652, 134851, 83913, 134776, 134041, 74988, 118836, 121234, 132032, 68220, 121892, 71712, 134482, 129596, 129910, 71519, 135396, 117684, 135037, 129894, 137043, 130284, 127833, 84485, 119544, 122593, 118658, 83704, 128994, 119181, 130101, 129951, 135523, 123076, 119275, 122764, 119217, 122019, 79581, 135745, 114291, 125399, 131794, 132008, 88512, 123898, 125452, 129392, 124726, 137161, 122606, 86724, 117765, 132433, 132671, 133065, 120846, 123897, 125196, 136784, 134050, 104226, 53831, 128474, 126807, 103321, 133434, 73722, 128561, 124450, 126988, 135889, 86278, 121789, 115431, 137074, 50258, 82252, 78602, 123922, 132020, 136437, 125647, 120453, 134572, 135912, 92203, 49558, 129589, 122185, 77554, 122024, 68973, 135815, 136436, 122084, 135204, 130576, 129538, 121835, 120264, 125745, 121043, 52542, 134864, 134547, 125029, 129489, 123172, 121232, 135181, 119432, 132756, 119231, 104027, 120354, 73724, 134798, 136061, 133283, 121531, 133417, 81489, 122425, 130802, 132754, 120961, 132508, 92975, 128109, 130033, 136501, 129978, 123112, 122805, 130007, 116919, 130566, 73179, 128755, 80396, 136429, 71421, 131634, 135804, 130014, 133540, 132114, 129353, 130093, 132278, 137120, 49557, 120394, 114216, 135625, 129274, 106153, 75203, 121801, 127043, 126339, 125035, 105801, 119869, 87246, 73960, 78989, 135240, 87009, 136803, 124191, 125228, 127959, 73080, 129409, 110337, 119673, 132708, 118145, 129545, 120253, 72737, 120390, 123664, 132263, 130614, 134812, 121222, 130545, 119774, 123119, 130166, 83250, 136017, 118803, 134602, 126688, 72784, 75549, 119284, 73023, 132772, 123976, 73328, 122901, 120399, 117785, 121639, 128769, 105429, 122376, 71483, 83467, 120274, 119998, 135939, 121551, 118498, 113857, 136311, 71934, 130044, 105010, 80794, 129581, 130401, 134841, 130355, 118586, 129423, 130385, 136727, 120351, 120810, 130416, 131152, 121650, 111087, 132193, 130783, 137166, 130394, 122874, 122447, 124162, 132509, 122854, 117910, 122369, 132707, 134058, 122597, 130032, 117192, 122305, 99494, 116992, 71919, 131423, 121677, 79912, 134568, 75197, 101072, 123923, 130805, 134111, 120714, 132225, 131513, 127585, 134478, 128832, 123686)
Run Time: 0.184299
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: 16228, 0, 1715293516, 1715297116, [["thread",118389],["thread",135275],["thread",122813],["thread",120020],["thread",134148],["thread",129134],["thread",116957],["thread",94728],["thread",121059],["thread",136778],["thread",123046],["thread",119728],["thread",136868],["thread",135491],["thread",122093],["thread",72553],["thread",130288],["thread",71358],["thread",130016],["thread",136334],["thread",49560],["thread",127343],["thread",119615],["thread",130749],["thread",131550],["thread",134652],["thread",134851],["thread",83913],["thread",134776],["thread",134041],["thread",74988],["thread",118836],["thread",121234],["thread",132032],["thread",68220],["thread",121892],["thread",71712],["thread",134482],["thread",129596],["thread",129910],["thread",71519],["thread",135396],["thread",117684],["thread",135037],["thread",129894],["thread",137043],["thread",130284],["thread",127833],["thread",84485],["thread",119544],["thread",122593],["thread",118658],["thread",83704],["thread",128994],["thread",119181],["thread",130101],["thread",129951],["thread",135523],["thread",123076],["thread",119275],["thread",122764],["thread",119217],["thread",122019],["thread",79581],["thread",135745],["thread",114291],["thread",125399],["thread",131794],["thread",132008],["thread",88512],["thread",123898],["thread",125452],["thread",129392],["thread",124726],["thread",137161],["thread",122606],["thread",86724],["thread",117765],["thread",132433],["thread",132671],["thread",133065],["thread",120846],["thread",123897],["thread",125196],["thread",136784],["thread",134050],["thread",104226],["thread",53831],["thread",128474],["thread",126807],["thread",103321],["thread",133434],["thread",73722],["thread",128561],["thread",124450],["thread",126988],["thread",135889],["thread",86278],["thread",121789],["thread",115431],["thread",137074],["thread",50258],["thread",82252],["thread",78602],["thread",123922],["thread",132020],["thread",136437],["thread",125647],["thread",120453],["thread",134572],["thread",135912],["thread",92203],["thread",49558],["thread",129589],["thread",122185],["thread",77554],["thread",122024],["thread",68973],["thread",135815],["thread",136436],["thread",122084],["thread",135204],["thread",130576],["thread",129538],["thread",121835],["thread",120264],["thread",125745],["thread",121043],["thread",52542],["thread",134864],["thread",134547],["thread",125029],["thread",129489],["thread",123172],["thread",121232],["thread",135181],["thread",119432],["thread",132756],["thread",119231],["thread",104027],["thread",120354],["thread",73724],["thread",134798],["thread",136061],["thread",133283],["thread",121531],["thread",133417],["thread",81489],["thread",122425],["thread",130802],["thread",132754],["thread",120961],["thread",132508],["thread",92975],["thread",128109],["thread",130033],["thread",136501],["thread",129978],["thread",123112],["thread",122805],["thread",130007],["thread",116919],["thread",130566],["thread",73179],["thread",128755],["thread",80396],["thread",136429],["thread",71421],["thread",131634],["thread",135804],["thread",130014],["thread",133540],["thread",132114],["thread",129353],["thread",130093],["thread",132278],["thread",137120],["thread",49557],["thread",120394],["thread",114216],["thread",135625],["thread",129274],["thread",106153],["thread",75203],["thread",121801],["thread",127043],["thread",126339],["thread",125035],["thread",105801],["thread",119869],["thread",87246],["thread",73960],["thread",78989],["thread",135240],["thread",87009],["thread",136803],["thread",124191],["thread",125228],["thread",127959],["thread",73080],["thread",129409],["thread",110337],["thread",119673],["thread",132708],["thread",118145],["thread",129545],["thread",120253],["thread",72737],["thread",120390],["thread",123664],["thread",132263],["thread",130614],["thread",134812],["thread",121222],["thread",130545],["thread",119774],["thread",123119],["thread",130166],["thread",83250],["thread",136017],["thread",118803],["thread",134602],["thread",126688],["thread",72784],["thread",75549],["thread",119284],["thread",73023],["thread",132772],["thread",123976],["thread",73328],["thread",122901],["thread",120399],["thread",117785],["thread",121639],["thread",128769],["thread",105429],["thread",122376],["thread",71483],["thread",83467],["thread",120274],["thread",119998],["thread",135939],["thread",121551],["thread",118498],["thread",113857],["thread",136311],["thread",71934],["thread",130044],["thread",105010],["thread",80794],["thread",129581],["thread",130401],["thread",134841],["thread",130355],["thread",118586],["thread",129423],["thread",130385],["thread",136727],["thread",120351],["thread",120810],["thread",130416],["thread",131152],["thread",121650],["thread",111087],["thread",132193],["thread",130783],["thread",137166],["thread",130394],["thread",122874],["thread",122447],["thread",124162],["thread",132509],["thread",122854],["thread",117910],["thread",122369],["thread",132707],["thread",134058],["thread",122597],["thread",130032],["thread",117192],["thread",122305],["thread",99494],["thread",116992],["thread",71919],["thread",131423],["thread",121677],["thread",79912],["thread",134568],["thread",75197],["thread",101072],["thread",123923],["thread",130805],["thread",134111],["thread",120714],["thread",132225],["thread",131513],["thread",127585],["thread",134478],["thread",128832],["thread",123686]]
Run Time: 0.004714
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.000086
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |