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 (101874, 104395, 130007, 130928, 123521, 134260, 136632, 102008, 5877, 70757, 120500, 123728, 2330, 20342, 109157, 14174, 124214, 37337, 17380, 91227, 134394, 129676, 135302, 123884, 103838, 126527, 104822, 16717, 37613, 128904, 49171, 132648, 133040, 73925, 129543, 131423, 135832, 93011, 118755, 131796, 121011, 116112, 123920, 104249, 135202, 130997, 118513, 107624, 126638, 132232, 120918, 135518, 120206, 106203, 74999, 135130, 1017, 130945, 118266, 107878, 122532, 993, 128807, 120953, 128767, 1659, 77724, 2358, 126626, 130659, 127868, 115709, 100550, 109409, 93697, 122572, 132569, 132577, 38007, 117040, 113597, 51662, 135335, 136570, 112209, 48131, 104081, 118954, 134332, 103964, 133527, 129880, 129600, 123169, 44573, 133484, 135270, 62678, 129394, 111309, 136003, 2062, 131870, 134347, 88087, 63306, 105579, 116379, 110580, 134300, 135730, 136020, 84458, 81456, 131527, 131689, 124164, 128632, 121331, 107212, 90181, 134170, 124903, 115236, 120245, 127548, 136141, 36955, 118248, 108278, 134760, 58671, 80363, 114044, 130589, 133578, 132790, 123941, 129341, 89563, 133929, 2349, 112642, 126442, 114486, 133031, 103726, 123358, 111128, 2304, 118436, 118519, 121832, 133135, 133500, 108581, 130322, 105086, 104438, 131308, 127625, 132574, 54655, 135589, 128316, 112143, 129287, 126950, 130975, 108801, 984, 106805, 132192, 130129, 122244, 114321, 132179, 131683, 24030, 129564, 120627, 125638, 110260, 34803, 80997, 57208, 131425, 108087, 81649, 132699, 132862, 134962, 112412, 111490, 129301, 121839, 11991, 87117, 61224, 125193, 114311, 5656, 94012, 136508, 112304, 136414, 104467, 109621, 115217, 130604, 124419, 111763, 33997, 129558, 88924, 130019, 133112, 129646, 107807, 13556, 114339, 5842, 47872, 88937, 73551, 67559, 122760, 117144, 111611, 131581, 134404, 129109, 136184, 1242, 113986, 132433, 106075, 21349, 90911, 1393, 70957, 108447, 40427, 121781, 115642, 119869, 119361, 128296, 74988, 116375, 125799, 128095, 126291, 122110, 130528, 78936, 133745, 112895, 2065, 104978, 112564, 123599, 123414, 131902, 114624, 123906, 127844, 127234, 106706, 120013, 121539, 1259, 121624, 105373, 117881, 104646, 136274, 93328, 134547, 123147, 88857, 112502, 134457, 127237, 128407, 81516, 135934, 127150, 1035, 60019, 102047, 82854, 130474, 118407, 113001, 134075, 106622, 4817)
Run Time: 0.014162
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 298 | 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: 8, 0, 1713586110, 1713589710, [["tinhte_xentag_forum",64],["tinhte_xentag_forum",65],["thread",101874],["thread",104395],["thread",130007],["thread",130928],["thread",123521],["thread",134260],["thread",136632],["thread",102008],["thread",5877],["thread",70757],["thread",120500],["thread",123728],["thread",2330],["thread",20342],["thread",109157],["thread",14174],["thread",124214],["thread",37337],["thread",17380],["thread",91227],["thread",134394],["thread",129676],["thread",135302],["thread",123884],["thread",103838],["thread",126527],["thread",104822],["thread",16717],["thread",37613],["thread",128904],["thread",49171],["thread",132648],["thread",133040],["thread",73925],["thread",129543],["thread",131423],["thread",135832],["thread",93011],["thread",118755],["thread",131796],["thread",121011],["thread",116112],["thread",123920],["thread",104249],["thread",135202],["thread",130997],["thread",118513],["thread",107624],["thread",126638],["thread",132232],["thread",120918],["thread",135518],["thread",120206],["thread",106203],["thread",74999],["thread",135130],["thread",1017],["thread",130945],["thread",118266],["thread",107878],["thread",122532],["thread",993],["thread",128807],["thread",120953],["thread",128767],["thread",1659],["thread",77724],["thread",2358],["thread",126626],["thread",130659],["thread",127868],["thread",115709],["thread",100550],["thread",109409],["thread",93697],["thread",122572],["thread",132569],["thread",132577],["thread",38007],["thread",117040],["thread",113597],["thread",51662],["thread",135335],["thread",136570],["thread",112209],["thread",48131],["thread",104081],["thread",118954],["thread",134332],["thread",103964],["thread",133527],["thread",129880],["thread",129600],["thread",123169],["thread",44573],["thread",133484],["thread",135270],["thread",62678],["thread",129394],["thread",111309],["thread",136003],["thread",2062],["thread",131870],["thread",134347],["thread",88087],["thread",63306],["thread",105579],["thread",116379],["thread",110580],["thread",134300],["thread",135730],["thread",136020],["thread",84458],["thread",81456],["thread",131527],["thread",131689],["thread",124164],["thread",128632],["thread",121331],["thread",107212],["thread",90181],["thread",134170],["thread",124903],["thread",115236],["thread",120245],["thread",127548],["thread",136141],["thread",36955],["thread",118248],["thread",108278],["thread",134760],["thread",58671],["thread",80363],["thread",114044],["thread",130589],["thread",133578],["thread",132790],["thread",123941],["thread",129341],["thread",89563],["thread",133929],["thread",2349],["thread",112642],["thread",126442],["thread",114486],["thread",133031],["thread",103726],["thread",123358],["thread",111128],["thread",2304],["thread",118436],["thread",118519],["thread",121832],["thread",133135],["thread",133500],["thread",108581],["thread",130322],["thread",105086],["thread",104438],["thread",131308],["thread",127625],["thread",132574],["thread",54655],["thread",135589],["thread",128316],["thread",112143],["thread",129287],["thread",126950],["thread",130975],["thread",108801],["thread",984],["thread",106805],["thread",132192],["thread",130129],["thread",122244],["thread",114321],["thread",132179],["thread",131683],["thread",24030],["thread",129564],["thread",120627],["thread",125638],["thread",110260],["thread",34803],["thread",80997],["thread",57208],["thread",131425],["thread",108087],["thread",81649],["thread",132699],["thread",132862],["thread",134962],["thread",112412],["thread",111490],["thread",129301],["thread",121839],["thread",11991],["thread",87117],["thread",61224],["thread",125193],["thread",114311],["thread",5656],["thread",94012],["thread",136508],["thread",112304],["thread",136414],["thread",104467],["thread",109621],["thread",115217],["thread",130604],["thread",124419],["thread",111763],["thread",33997],["thread",129558],["thread",88924],["thread",130019],["thread",133112],["thread",129646],["thread",107807],["thread",13556],["thread",114339],["thread",5842],["thread",47872],["thread",88937],["thread",73551],["thread",67559],["thread",122760],["thread",117144],["thread",111611],["thread",131581],["thread",134404],["thread",129109],["thread",136184],["thread",1242],["thread",113986],["thread",132433],["thread",106075],["thread",21349],["thread",90911],["thread",1393],["thread",70957],["thread",108447],["thread",40427],["thread",121781],["thread",115642],["thread",119869],["thread",119361],["thread",128296],["thread",74988],["thread",116375],["thread",125799],["thread",128095],["thread",126291],["thread",122110],["thread",130528],["thread",78936],["thread",133745],["thread",112895],["thread",2065],["thread",104978],["thread",112564],["thread",123599],["thread",123414],["thread",131902],["thread",114624],["thread",123906],["thread",127844],["thread",127234],["thread",106706],["thread",120013],["thread",121539],["thread",1259],["thread",121624],["thread",105373],["thread",117881],["thread",104646],["thread",136274],["thread",93328],["thread",134547],["thread",123147],["thread",88857],["thread",112502],["thread",134457],["thread",127237],["thread",128407],["thread",81516],["thread",135934],["thread",127150],["thread",1035],["thread",60019],["thread",102047],["thread",82854],["thread",130474],["thread",118407],["thread",113001],["thread",134075],["thread",106622],["thread",4817]]
Run Time: 0.001031
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.000109
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |