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 (127826, 44161, 19928, 58684, 14640, 36397, 34515, 75482, 135748, 46279, 56584, 59066, 47127, 61313, 63800, 85250, 59851, 134539, 110890, 20544, 61217, 81927, 70921, 89404, 106953, 37053, 79906, 19334, 126243, 84094, 83175, 77101, 86700, 51647, 43319, 98470, 61338, 99857, 127475, 64144, 79675, 91360, 69396, 57447, 44989, 48684, 57291, 82183, 122212, 47849, 97549, 80476, 65500, 110698, 130809, 58143, 90497, 123651, 129206, 107501, 56729, 9016, 62740, 85765, 89959, 118188, 48534, 127724, 52003, 60259, 106027, 11284, 114491, 112334, 112094, 136453, 77468, 51726, 47792, 65550, 115245, 41006, 103090, 53116, 83161, 124130, 110824, 129094, 96717, 42151, 72759, 124876, 65680, 57752, 52845, 103668, 83497, 39897, 35559, 78430, 90389, 95062, 76904, 57127, 88916, 56299, 79598, 12547, 65713, 77308, 95331, 49631, 59503, 79841, 92113, 53310, 53748, 80201, 68953, 19839, 90945, 44438, 66862, 58502, 109973, 94665, 89021, 93880, 68426, 81453, 25580, 118796, 119321, 65824, 107283, 106746, 91903, 55674, 86177, 102619, 133921, 96236, 97138, 44836, 85328, 134117, 52809, 82836, 98091, 103528, 58812, 89371, 116352, 47749, 91419, 69556, 59593, 68683, 76493, 115430, 50888, 104248, 105179, 63965, 81334, 74801, 84105, 99263, 59714, 37575, 41729, 110635, 107873, 84718, 131554, 108675, 44189, 108078, 85408, 83751, 32169, 104908, 81483, 52155, 44320, 87920, 107185, 29109, 125348, 92792, 116355, 47487, 63033, 47620, 92567, 71569, 18069, 32953, 105947, 28189, 132970, 125055, 48034, 42085, 126649, 57452, 77788, 70969, 53229, 104540, 38998, 112504, 118686, 84230, 67727, 59508, 100826, 81564, 104425, 91820, 124426, 107417, 121574, 90570, 67951, 134275, 109909, 125135, 62259, 114785, 110968, 58702, 18727, 85094, 71284, 66477, 132556, 3970, 101797, 75129, 134559, 89980, 30688, 121806, 99567, 132985, 102997, 85068, 55255, 117078, 13046, 102426, 109022, 135542, 105819, 102649, 53165, 133924, 116213, 47498, 86060, 112510, 130993, 112496, 59417, 109127, 60698, 43042, 62812, 99281, 51729, 78621, 115907, 49026, 53650, 119687, 69324, 47306, 124594, 58352, 89062, 59857, 82716, 73786, 46254, 71467, 75215, 67873, 86355, 54115, 52617, 114683, 84761, 57071, 132928, 80311, 62358, 86653, 100474)
Run Time: 0.022316
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: 697, 0, 1714154308, 1714157908, [["resource",36],["thread",127826],["thread",44161],["thread",19928],["thread",58684],["thread",14640],["thread",36397],["thread",34515],["thread",75482],["thread",135748],["thread",46279],["thread",56584],["thread",59066],["thread",47127],["thread",61313],["thread",63800],["thread",85250],["thread",59851],["thread",134539],["thread",110890],["thread",20544],["thread",61217],["thread",81927],["thread",70921],["thread",89404],["thread",106953],["thread",37053],["thread",79906],["thread",19334],["thread",126243],["thread",84094],["thread",83175],["thread",77101],["thread",86700],["thread",51647],["thread",43319],["thread",98470],["thread",61338],["thread",99857],["thread",127475],["thread",64144],["thread",79675],["thread",91360],["thread",69396],["thread",57447],["thread",44989],["thread",48684],["thread",57291],["thread",82183],["thread",122212],["thread",47849],["thread",97549],["thread",80476],["thread",65500],["thread",110698],["thread",130809],["thread",58143],["thread",90497],["thread",123651],["thread",129206],["thread",107501],["thread",56729],["thread",9016],["thread",62740],["thread",85765],["thread",89959],["thread",118188],["thread",48534],["thread",127724],["thread",52003],["thread",60259],["thread",106027],["thread",11284],["thread",114491],["thread",112334],["thread",112094],["thread",136453],["thread",77468],["thread",51726],["thread",47792],["thread",65550],["thread",115245],["thread",41006],["thread",103090],["thread",53116],["thread",83161],["thread",124130],["thread",110824],["thread",129094],["thread",96717],["thread",42151],["thread",72759],["thread",124876],["thread",65680],["thread",57752],["thread",52845],["thread",103668],["thread",83497],["thread",39897],["thread",35559],["thread",78430],["thread",90389],["thread",95062],["thread",76904],["thread",57127],["thread",88916],["thread",56299],["thread",79598],["thread",12547],["thread",65713],["thread",77308],["thread",95331],["thread",49631],["thread",59503],["thread",79841],["thread",92113],["thread",53310],["thread",53748],["thread",80201],["thread",68953],["thread",19839],["thread",90945],["thread",44438],["thread",66862],["thread",58502],["thread",109973],["thread",94665],["thread",89021],["thread",93880],["thread",68426],["thread",81453],["thread",25580],["thread",118796],["thread",119321],["thread",65824],["thread",107283],["thread",106746],["thread",91903],["thread",55674],["thread",86177],["thread",102619],["thread",133921],["thread",96236],["thread",97138],["thread",44836],["thread",85328],["thread",134117],["thread",52809],["thread",82836],["thread",98091],["thread",103528],["thread",58812],["thread",89371],["thread",116352],["thread",47749],["thread",91419],["thread",69556],["thread",59593],["thread",68683],["thread",76493],["thread",115430],["thread",50888],["thread",104248],["thread",105179],["thread",63965],["thread",81334],["thread",74801],["thread",84105],["thread",99263],["thread",59714],["thread",37575],["thread",41729],["thread",110635],["thread",107873],["thread",84718],["thread",131554],["thread",108675],["thread",44189],["thread",108078],["thread",85408],["thread",83751],["thread",32169],["thread",104908],["thread",81483],["thread",52155],["thread",44320],["thread",87920],["thread",107185],["thread",29109],["thread",125348],["thread",92792],["thread",116355],["thread",47487],["thread",63033],["thread",47620],["thread",92567],["thread",71569],["thread",18069],["thread",32953],["thread",105947],["thread",28189],["thread",132970],["thread",125055],["thread",48034],["thread",42085],["thread",126649],["thread",57452],["thread",77788],["thread",70969],["thread",53229],["thread",104540],["thread",38998],["thread",112504],["thread",118686],["thread",84230],["thread",67727],["thread",59508],["thread",100826],["thread",81564],["thread",104425],["thread",91820],["thread",124426],["thread",107417],["thread",121574],["thread",90570],["thread",67951],["thread",134275],["thread",109909],["thread",125135],["thread",62259],["thread",114785],["thread",110968],["thread",58702],["thread",18727],["thread",85094],["thread",71284],["thread",66477],["thread",132556],["thread",3970],["thread",101797],["thread",75129],["thread",134559],["thread",89980],["thread",30688],["thread",121806],["thread",99567],["thread",132985],["thread",102997],["thread",85068],["thread",55255],["thread",117078],["thread",13046],["thread",102426],["thread",109022],["thread",135542],["thread",105819],["thread",102649],["thread",53165],["thread",133924],["thread",116213],["thread",47498],["thread",86060],["thread",112510],["thread",130993],["thread",112496],["thread",59417],["thread",109127],["thread",60698],["thread",43042],["thread",62812],["thread",99281],["thread",51729],["thread",78621],["thread",115907],["thread",49026],["thread",53650],["thread",119687],["thread",69324],["thread",47306],["thread",124594],["thread",58352],["thread",89062],["thread",59857],["thread",82716],["thread",73786],["thread",46254],["thread",71467],["thread",75215],["thread",67873],["thread",86355],["thread",54115],["thread",52617],["thread",114683],["thread",84761],["thread",57071],["thread",132928],["thread",80311],["thread",62358],["thread",86653],["thread",100474]]
Run Time: 0.002778
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |