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 (96214, 120465, 20827, 38436, 135530, 136758, 126072, 122263, 84253, 117005, 63662, 19829, 82884, 118891, 121316, 113084, 68572, 128828, 86292, 45218, 130633, 128996, 109526, 87013, 61271, 133603, 132192, 137058, 119948, 47922, 135687, 106209, 132634, 107023, 67902, 44332, 48840, 137146, 119563, 20752, 92696, 121273, 132897, 45276, 1401, 120695, 63112, 70335, 135535, 133668, 84373, 48331, 128460, 78383, 43875, 101106, 131312, 126761, 133995, 61972, 61898, 129927, 134934, 130074, 130495, 135470, 131985, 127182, 133077, 104208, 100057, 111328, 135174, 134431, 62363, 136398, 2145, 6555, 109200, 121270, 55424, 104309, 106290, 47224, 63855, 129677, 132006, 121468, 112575, 133525, 123186, 16386, 128296, 107143, 61903, 1574, 137159, 116007, 124793, 86361, 101910, 8050, 62377, 134366, 70072, 106133, 15526, 127465, 70725, 123625, 122967, 10524, 112176, 47575, 71485, 106779, 130321, 103173, 131645, 122855, 111557, 115188, 105474, 69430, 46746, 131493, 133819, 106310, 128405, 47363, 63365, 93182, 128157, 101153, 125853, 127006, 110234, 62063, 134529, 104014, 131902, 81153, 63421, 108592, 69584, 134363, 66415, 65364, 62755, 137265, 65361, 135469, 8042, 126667, 37451, 58696, 136960, 135125, 129736, 70257, 49101, 78595, 132486, 44556, 135024, 61438, 115612, 126846, 120393, 109499, 130408, 120910, 137094, 3862, 123169, 99156, 135193, 133774, 53341, 12536, 107853, 42853, 38633, 106929, 118441, 135187, 126984, 136588, 12310, 61443, 130850, 136446, 131041, 105760, 68358, 121991, 105545, 135638, 63215, 105875, 21242, 130689, 132752, 45701, 127939, 101276, 61273, 124460, 103708, 131360, 130925, 128140, 43825, 131826, 136366, 46305, 112699, 135468, 116878, 133887, 111670, 47357, 129980, 123280, 106852, 133809, 102906, 62766, 2133, 76384, 133620, 60310, 130481, 134826, 107657, 63721, 92014, 135216, 133604, 126061, 133576, 128673, 134769, 135799, 126673, 135186, 130555, 64101, 134139, 137203, 13877, 810, 137135, 134290, 81580, 129305, 36679, 116945, 28011, 135436, 119407, 131804, 114708, 104618, 116129, 136719, 108436, 107803, 130133, 62386, 96185, 134346, 132540, 44415, 126408, 134468, 135022, 5844, 136508, 44890, 130447, 131778, 117162, 2134, 135199, 127200, 11523, 90423, 64751, 85519, 135801, 47991, 110428, 134272, 108732, 128992, 42228, 129984, 107773)
Run Time: 0.058019
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 299 | 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: 31, 0, 1715441730, 1715445330, [["tinhte_xentag_forum",65],["thread",96214],["thread",120465],["thread",20827],["thread",38436],["thread",135530],["thread",136758],["thread",126072],["thread",122263],["thread",84253],["thread",117005],["thread",63662],["thread",19829],["thread",82884],["thread",118891],["thread",121316],["thread",113084],["thread",68572],["thread",128828],["thread",86292],["thread",45218],["thread",130633],["thread",128996],["thread",109526],["thread",87013],["thread",61271],["thread",133603],["thread",132192],["thread",137058],["thread",119948],["thread",47922],["thread",135687],["thread",106209],["thread",132634],["thread",107023],["thread",67902],["thread",44332],["thread",48840],["thread",137146],["thread",119563],["thread",20752],["thread",92696],["thread",121273],["thread",132897],["thread",45276],["thread",1401],["thread",120695],["thread",63112],["thread",70335],["thread",135535],["thread",133668],["thread",84373],["thread",48331],["thread",128460],["thread",78383],["thread",43875],["thread",101106],["thread",131312],["thread",126761],["thread",133995],["thread",61972],["thread",61898],["thread",129927],["thread",134934],["thread",130074],["thread",130495],["thread",135470],["thread",131985],["thread",127182],["thread",133077],["thread",104208],["thread",100057],["thread",111328],["thread",135174],["thread",134431],["thread",62363],["thread",136398],["thread",2145],["thread",6555],["thread",109200],["thread",121270],["thread",55424],["thread",104309],["thread",106290],["thread",47224],["thread",63855],["thread",129677],["thread",132006],["thread",121468],["thread",112575],["thread",133525],["thread",123186],["thread",16386],["thread",128296],["thread",107143],["thread",61903],["thread",1574],["thread",137159],["thread",116007],["thread",124793],["thread",86361],["thread",101910],["thread",8050],["thread",62377],["thread",134366],["thread",70072],["thread",106133],["thread",15526],["thread",127465],["thread",70725],["thread",123625],["thread",122967],["thread",10524],["thread",112176],["thread",47575],["thread",71485],["thread",106779],["thread",130321],["thread",103173],["thread",131645],["thread",122855],["thread",111557],["thread",115188],["thread",105474],["thread",69430],["thread",46746],["thread",131493],["thread",133819],["thread",106310],["thread",128405],["thread",47363],["thread",63365],["thread",93182],["thread",128157],["thread",101153],["thread",125853],["thread",127006],["thread",110234],["thread",62063],["thread",134529],["thread",104014],["thread",131902],["thread",81153],["thread",63421],["thread",108592],["thread",69584],["thread",134363],["thread",66415],["thread",65364],["thread",62755],["thread",137265],["thread",65361],["thread",135469],["thread",8042],["thread",126667],["thread",37451],["thread",58696],["thread",136960],["thread",135125],["thread",129736],["thread",70257],["thread",49101],["thread",78595],["thread",132486],["thread",44556],["thread",135024],["thread",61438],["thread",115612],["thread",126846],["thread",120393],["thread",109499],["thread",130408],["thread",120910],["thread",137094],["thread",3862],["thread",123169],["thread",99156],["thread",135193],["thread",133774],["thread",53341],["thread",12536],["thread",107853],["thread",42853],["thread",38633],["thread",106929],["thread",118441],["thread",135187],["thread",126984],["thread",136588],["thread",12310],["thread",61443],["thread",130850],["thread",136446],["thread",131041],["thread",105760],["thread",68358],["thread",121991],["thread",105545],["thread",135638],["thread",63215],["thread",105875],["thread",21242],["thread",130689],["thread",132752],["thread",45701],["thread",127939],["thread",101276],["thread",61273],["thread",124460],["thread",103708],["thread",131360],["thread",130925],["thread",128140],["thread",43825],["thread",131826],["thread",136366],["thread",46305],["thread",112699],["thread",135468],["thread",116878],["thread",133887],["thread",111670],["thread",47357],["thread",129980],["thread",123280],["thread",106852],["thread",133809],["thread",102906],["thread",62766],["thread",2133],["thread",76384],["thread",133620],["thread",60310],["thread",130481],["thread",134826],["thread",107657],["thread",63721],["thread",92014],["thread",135216],["thread",133604],["thread",126061],["thread",133576],["thread",128673],["thread",134769],["thread",135799],["thread",126673],["thread",135186],["thread",130555],["thread",64101],["thread",134139],["thread",137203],["thread",13877],["thread",810],["thread",137135],["thread",134290],["thread",81580],["thread",129305],["thread",36679],["thread",116945],["thread",28011],["thread",135436],["thread",119407],["thread",131804],["thread",114708],["thread",104618],["thread",116129],["thread",136719],["thread",108436],["thread",107803],["thread",130133],["thread",62386],["thread",96185],["thread",134346],["thread",132540],["thread",44415],["thread",126408],["thread",134468],["thread",135022],["thread",5844],["thread",136508],["thread",44890],["thread",130447],["thread",131778],["thread",117162],["thread",2134],["thread",135199],["thread",127200],["thread",11523],["thread",90423],["thread",64751],["thread",85519],["thread",135801],["thread",47991],["thread",110428],["thread",134272],["thread",108732],["thread",128992],["thread",42228],["thread",129984],["thread",107773]]
Run Time: 0.099169
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.000275
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |