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 (136631, 134208, 117790, 118326, 129212, 134778, 79793, 137254, 136449, 135937, 137070, 132881, 131109, 136239, 135386, 124051, 134603, 46994, 60762, 124411, 80823, 71946, 99802, 129633, 81109, 58432, 131227, 136736, 129539, 133783, 132527, 136838, 134845, 130300, 129271, 80726, 135274, 84382, 42119, 134401, 119744, 129014, 47152, 68644, 120896, 118683, 136724, 136901, 137186, 135349, 133941, 135384, 113396, 135812, 135022, 135163, 130152, 41300, 134992, 76425, 108229, 134943, 90809, 137327, 134466, 127269, 136242, 107661, 130985, 76702, 131506, 135186, 135383, 96097, 113930, 129278, 134874, 135369, 90224, 135164, 134957, 137151, 133788, 129256, 134040, 133534, 111185, 129073, 136483, 135452, 125026, 132315, 131719, 134425, 136035, 70077, 133017, 113793, 71119, 131992, 100748, 134462, 124102, 131312, 136209, 133201, 135614, 93755, 137204, 135656, 134834, 90605, 134272, 133955, 131346, 130032, 135691, 80345, 132087, 122253, 84551, 88845, 110477, 124628, 79907, 135708, 131306, 133692, 81569, 133562, 64069, 133620, 97307, 136867, 122822, 110385, 136881, 136129, 135436, 137284, 133675, 129629, 69652, 121418, 129757, 115752, 135144, 136314, 136260, 136043, 133144, 43934, 126414, 132588, 135008, 134083, 131011, 79178, 137169, 132318, 133129, 124468, 111440, 131828, 69579, 133245, 136599, 90484, 125070, 68310, 135263, 79510, 71540, 133559, 133458, 133372, 134900, 133584, 135820, 115498, 135395, 41287, 133537, 110258, 110537, 136084, 136511, 128333, 119159, 60771, 132587, 112177, 134237, 132611, 124343, 129781, 68303, 128581, 134139, 92253, 136356, 133961, 125372, 132368, 131783, 133136, 133802, 135259, 43937, 96068, 96433, 131787, 101383, 81200, 131023, 135236, 133797, 118825, 134236, 131790, 124305, 129614, 114654, 129025, 43930, 121032, 128459, 135173, 137096, 135294, 131195, 103341, 60764, 80534, 95830, 69731, 79748, 129270, 117597, 60843, 137282, 136274, 99074, 137093, 136187, 124704, 122483, 132494, 132369, 111827, 81756, 132709, 135864, 86320, 121281, 130481, 129736, 137268, 134432, 134421, 133360, 135128, 114020, 80754, 130881, 135182, 132004, 136393, 136150, 130604, 135199, 129244, 130297, 136520, 133471, 97675, 121016, 132366, 136030, 129106, 96248, 133951, 132586, 98097, 135785, 127671, 133163, 129216, 131167, 131458, 113223, 130823, 129405, 128859, 135262, 128774, 60673, 70027, 136255, 130073)
Run Time: 0.261327
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: 4298, 0, 1715556932, 1715560532, [["thread",136631],["thread",134208],["thread",117790],["thread",118326],["thread",129212],["thread",134778],["thread",79793],["thread",137254],["thread",136449],["thread",135937],["thread",137070],["thread",132881],["thread",131109],["thread",136239],["thread",135386],["thread",124051],["thread",134603],["thread",46994],["thread",60762],["thread",124411],["thread",80823],["thread",71946],["thread",99802],["thread",129633],["thread",81109],["thread",58432],["thread",131227],["thread",136736],["thread",129539],["thread",133783],["thread",132527],["thread",136838],["thread",134845],["thread",130300],["thread",129271],["thread",80726],["thread",135274],["thread",84382],["thread",42119],["thread",134401],["thread",119744],["thread",129014],["thread",47152],["thread",68644],["thread",120896],["thread",118683],["thread",136724],["thread",136901],["thread",137186],["thread",135349],["thread",133941],["thread",135384],["thread",113396],["thread",135812],["thread",135022],["thread",135163],["thread",130152],["thread",41300],["thread",134992],["thread",76425],["thread",108229],["thread",134943],["thread",90809],["thread",137327],["thread",134466],["thread",127269],["thread",136242],["thread",107661],["thread",130985],["thread",76702],["thread",131506],["thread",135186],["thread",135383],["thread",96097],["thread",113930],["thread",129278],["thread",134874],["thread",135369],["thread",90224],["thread",135164],["thread",134957],["thread",137151],["thread",133788],["thread",129256],["thread",134040],["thread",133534],["thread",111185],["thread",129073],["thread",136483],["thread",135452],["thread",125026],["thread",132315],["thread",131719],["thread",134425],["thread",136035],["thread",70077],["thread",133017],["thread",113793],["thread",71119],["thread",131992],["thread",100748],["thread",134462],["thread",124102],["thread",131312],["thread",136209],["thread",133201],["thread",135614],["thread",93755],["thread",137204],["thread",135656],["thread",134834],["thread",90605],["thread",134272],["thread",133955],["thread",131346],["thread",130032],["thread",135691],["thread",80345],["thread",132087],["thread",122253],["thread",84551],["thread",88845],["thread",110477],["thread",124628],["thread",79907],["thread",135708],["thread",131306],["thread",133692],["thread",81569],["thread",133562],["thread",64069],["thread",133620],["thread",97307],["thread",136867],["thread",122822],["thread",110385],["thread",136881],["thread",136129],["thread",135436],["thread",137284],["thread",133675],["thread",129629],["thread",69652],["thread",121418],["thread",129757],["thread",115752],["thread",135144],["thread",136314],["thread",136260],["thread",136043],["thread",133144],["thread",43934],["thread",126414],["thread",132588],["thread",135008],["thread",134083],["thread",131011],["thread",79178],["thread",137169],["thread",132318],["thread",133129],["thread",124468],["thread",111440],["thread",131828],["thread",69579],["thread",133245],["thread",136599],["thread",90484],["thread",125070],["thread",68310],["thread",135263],["thread",79510],["thread",71540],["thread",133559],["thread",133458],["thread",133372],["thread",134900],["thread",133584],["thread",135820],["thread",115498],["thread",135395],["thread",41287],["thread",133537],["thread",110258],["thread",110537],["thread",136084],["thread",136511],["thread",128333],["thread",119159],["thread",60771],["thread",132587],["thread",112177],["thread",134237],["thread",132611],["thread",124343],["thread",129781],["thread",68303],["thread",128581],["thread",134139],["thread",92253],["thread",136356],["thread",133961],["thread",125372],["thread",132368],["thread",131783],["thread",133136],["thread",133802],["thread",135259],["thread",43937],["thread",96068],["thread",96433],["thread",131787],["thread",101383],["thread",81200],["thread",131023],["thread",135236],["thread",133797],["thread",118825],["thread",134236],["thread",131790],["thread",124305],["thread",129614],["thread",114654],["thread",129025],["thread",43930],["thread",121032],["thread",128459],["thread",135173],["thread",137096],["thread",135294],["thread",131195],["thread",103341],["thread",60764],["thread",80534],["thread",95830],["thread",69731],["thread",79748],["thread",129270],["thread",117597],["thread",60843],["thread",137282],["thread",136274],["thread",99074],["thread",137093],["thread",136187],["thread",124704],["thread",122483],["thread",132494],["thread",132369],["thread",111827],["thread",81756],["thread",132709],["thread",135864],["thread",86320],["thread",121281],["thread",130481],["thread",129736],["thread",137268],["thread",134432],["thread",134421],["thread",133360],["thread",135128],["thread",114020],["thread",80754],["thread",130881],["thread",135182],["thread",132004],["thread",136393],["thread",136150],["thread",130604],["thread",135199],["thread",129244],["thread",130297],["thread",136520],["thread",133471],["thread",97675],["thread",121016],["thread",132366],["thread",136030],["thread",129106],["thread",96248],["thread",133951],["thread",132586],["thread",98097],["thread",135785],["thread",127671],["thread",133163],["thread",129216],["thread",131167],["thread",131458],["thread",113223],["thread",130823],["thread",129405],["thread",128859],["thread",135262],["thread",128774],["thread",60673],["thread",70027],["thread",136255],["thread",130073]]
Run Time: 0.012632
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.000107
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |