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 (72009, 89321, 75073, 61444, 71483, 80988, 85441, 61761, 75472, 78989, 48216, 48465, 72095, 86497, 73328, 70305, 48511, 94426, 104209, 75954, 75352, 77591, 80037, 102447, 46192, 21260, 80391, 47788, 97080, 74703, 87145, 52542, 47278, 132213, 85793, 69944, 73827, 73960, 73553, 51658, 84485, 80668, 47223, 48218, 47224, 84464, 95689, 87403, 77840, 74130, 81192, 80398, 47362, 59833, 84178, 74249, 44891, 63935, 46528, 118224, 47924, 112672, 78160, 101849, 80842, 48053, 78602, 37142, 59134, 49657, 102321, 68062, 104162, 83267, 45219, 77424, 46770, 79328, 47235, 72553, 47042, 62030, 71934, 71958, 38086, 53015, 122678, 46615, 75985, 61677, 72616, 76330, 74610, 77499, 58252, 79336, 98384, 46193, 94837, 58241, 47006, 72737, 76513, 77361, 81515, 77070, 46415, 96427, 49960, 48212, 136170, 88377, 84369, 82072, 71919, 87031, 46813, 49373, 73020, 48052, 132899, 78572, 76096, 102977, 48943, 73124, 77842, 102640, 33954, 71389, 72784, 69906, 58818, 84116, 49654, 72040, 70125, 58173, 65835, 74131, 129928, 25920, 82758, 66361, 80359, 72617, 47694, 71466, 112386, 46184, 86295, 70029, 46624, 72027, 52632, 74505, 366, 62241, 20719, 48306, 79125, 84308, 38090, 46747, 63712, 49962, 79578, 47964, 56047, 73179, 35059, 77394, 77532, 71657, 84368, 78089, 77723, 48942, 80745, 43842, 126057, 73759, 49757, 71961, 79745, 62592, 81000, 103944, 77525, 44371, 44413, 72288, 71420, 58253, 70975, 82246, 79727, 82252, 124297, 47154, 77507, 49374, 61224, 83250, 80994, 58339, 74247, 88201, 74408, 46876, 58809, 50437, 80557, 72638, 104069, 74665, 46408, 67700, 122065, 102285, 74126, 88349, 77951, 48557, 84897, 72006, 47008, 59477, 61445, 37740, 76240, 79476, 48357, 76100, 88105, 77418, 47156, 73822, 389, 66902, 73830, 73551, 77971, 47710, 51663, 52873, 104380, 81069, 71105, 50438, 81066, 48344, 72483, 81849, 51540, 46247, 74570, 84366, 70696, 73833, 82231, 47540, 94483, 78392, 79690, 74890, 47218, 77504, 57143, 74125, 53309, 44369, 74503, 124459, 47740, 109302, 52455, 51660, 58450, 79362, 81485, 69970, 111869, 69698, 68101, 73125, 46750, 72714, 46294, 83718, 77301, 76416, 70431, 86162, 77087, 58710, 69398, 131710, 46744, 57655)
Run Time: 0.015152
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: 6, 0, 1714124841, 1714128441, [["thread",72009],["thread",89321],["thread",75073],["thread",61444],["thread",71483],["thread",80988],["thread",85441],["thread",61761],["thread",75472],["thread",78989],["thread",48216],["thread",48465],["thread",72095],["thread",86497],["thread",73328],["thread",70305],["thread",48511],["thread",94426],["thread",104209],["thread",75954],["thread",75352],["thread",77591],["thread",80037],["thread",102447],["thread",46192],["thread",21260],["thread",80391],["thread",47788],["thread",97080],["thread",74703],["thread",87145],["thread",52542],["thread",47278],["thread",132213],["thread",85793],["thread",69944],["thread",73827],["thread",73960],["thread",73553],["thread",51658],["thread",84485],["thread",80668],["thread",47223],["thread",48218],["thread",47224],["thread",84464],["thread",95689],["thread",87403],["thread",77840],["thread",74130],["thread",81192],["thread",80398],["thread",47362],["thread",59833],["thread",84178],["thread",74249],["thread",44891],["thread",63935],["thread",46528],["thread",118224],["thread",47924],["thread",112672],["thread",78160],["thread",101849],["thread",80842],["thread",48053],["thread",78602],["thread",37142],["thread",59134],["thread",49657],["thread",102321],["thread",68062],["thread",104162],["thread",83267],["thread",45219],["thread",77424],["thread",46770],["thread",79328],["thread",47235],["thread",72553],["thread",47042],["thread",62030],["thread",71934],["thread",71958],["thread",38086],["thread",53015],["thread",122678],["thread",46615],["thread",75985],["thread",61677],["thread",72616],["thread",76330],["thread",74610],["thread",77499],["thread",58252],["thread",79336],["thread",98384],["thread",46193],["thread",94837],["thread",58241],["thread",47006],["thread",72737],["thread",76513],["thread",77361],["thread",81515],["thread",77070],["thread",46415],["thread",96427],["thread",49960],["thread",48212],["thread",136170],["thread",88377],["thread",84369],["thread",82072],["thread",71919],["thread",87031],["thread",46813],["thread",49373],["thread",73020],["thread",48052],["thread",132899],["thread",78572],["thread",76096],["thread",102977],["thread",48943],["thread",73124],["thread",77842],["thread",102640],["thread",33954],["thread",71389],["thread",72784],["thread",69906],["thread",58818],["thread",84116],["thread",49654],["thread",72040],["thread",70125],["thread",58173],["thread",65835],["thread",74131],["thread",129928],["thread",25920],["thread",82758],["thread",66361],["thread",80359],["thread",72617],["thread",47694],["thread",71466],["thread",112386],["thread",46184],["thread",86295],["thread",70029],["thread",46624],["thread",72027],["thread",52632],["thread",74505],["thread",366],["thread",62241],["thread",20719],["thread",48306],["thread",79125],["thread",84308],["thread",38090],["thread",46747],["thread",63712],["thread",49962],["thread",79578],["thread",47964],["thread",56047],["thread",73179],["thread",35059],["thread",77394],["thread",77532],["thread",71657],["thread",84368],["thread",78089],["thread",77723],["thread",48942],["thread",80745],["thread",43842],["thread",126057],["thread",73759],["thread",49757],["thread",71961],["thread",79745],["thread",62592],["thread",81000],["thread",103944],["thread",77525],["thread",44371],["thread",44413],["thread",72288],["thread",71420],["thread",58253],["thread",70975],["thread",82246],["thread",79727],["thread",82252],["thread",124297],["thread",47154],["thread",77507],["thread",49374],["thread",61224],["thread",83250],["thread",80994],["thread",58339],["thread",74247],["thread",88201],["thread",74408],["thread",46876],["thread",58809],["thread",50437],["thread",80557],["thread",72638],["thread",104069],["thread",74665],["thread",46408],["thread",67700],["thread",122065],["thread",102285],["thread",74126],["thread",88349],["thread",77951],["thread",48557],["thread",84897],["thread",72006],["thread",47008],["thread",59477],["thread",61445],["thread",37740],["thread",76240],["thread",79476],["thread",48357],["thread",76100],["thread",88105],["thread",77418],["thread",47156],["thread",73822],["thread",389],["thread",66902],["thread",73830],["thread",73551],["thread",77971],["thread",47710],["thread",51663],["thread",52873],["thread",104380],["thread",81069],["thread",71105],["thread",50438],["thread",81066],["thread",48344],["thread",72483],["thread",81849],["thread",51540],["thread",46247],["thread",74570],["thread",84366],["thread",70696],["thread",73833],["thread",82231],["thread",47540],["thread",94483],["thread",78392],["thread",79690],["thread",74890],["thread",47218],["thread",77504],["thread",57143],["thread",74125],["thread",53309],["thread",44369],["thread",74503],["thread",124459],["thread",47740],["thread",109302],["thread",52455],["thread",51660],["thread",58450],["thread",79362],["thread",81485],["thread",69970],["thread",111869],["thread",69698],["thread",68101],["thread",73125],["thread",46750],["thread",72714],["thread",46294],["thread",83718],["thread",77301],["thread",76416],["thread",70431],["thread",86162],["thread",77087],["thread",58710],["thread",69398],["thread",131710],["thread",46744],["thread",57655]]
Run Time: 0.002124
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.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |