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 (120612, 131802, 113585, 28112, 79258, 83717, 123804, 58426, 83381, 99608, 118826, 99765, 114931, 74891, 79260, 117790, 96433, 76462, 109376, 121777, 122771, 67152, 58431, 77613, 111051, 107086, 84639, 65110, 108906, 113958, 1364, 66769, 107730, 99867, 96645, 58419, 89265, 68310, 102030, 122275, 72046, 129056, 96809, 135622, 75813, 96001, 118639, 89719, 99385, 101948, 109784, 88664, 58387, 109442, 1365, 74128, 90545, 73177, 66689, 98935, 134395, 92581, 127405, 119159, 122770, 71615, 101400, 82074, 75734, 108229, 80466, 104401, 1402, 79376, 66279, 85246, 42119, 65835, 366, 119418, 91336, 75092, 96104, 92035, 113784, 110088, 131593, 125538, 114877, 22421, 71402, 66617, 102166, 84634, 118540, 37801, 97238, 110892, 117715, 97594, 64371, 101808, 95487, 133883, 68528, 78216, 79441, 123847, 74409, 60770, 90320, 88258, 136642, 98143, 74519, 99915, 69128, 60240, 76994, 71750, 96528, 80730, 121920, 65578, 96977, 1401, 126585, 90484, 73299, 73473, 112433, 118326, 95997, 96615, 114742, 68757, 80457, 75812, 79693, 77262, 84453, 70653, 70027, 124496, 137177, 74064, 69855, 78584, 72958, 123596, 117638, 92513, 76544, 128877, 101918, 77701, 129624, 71601, 91958, 106311, 109302, 822, 104434, 81297, 75869, 108168, 132284, 109774, 76886, 113498, 74183, 129855, 95753, 47341, 123613, 86943, 62502, 122253, 96368, 1379, 97960, 130333, 123042, 106717, 98855, 37748, 77810, 75953, 97653, 28518, 66936, 74509, 78160, 110155, 123583, 114741, 121988, 105371, 120559, 84435, 90649, 96034, 85530, 91187, 77700, 80345, 75576, 91727, 68552, 55772, 89165, 76513, 65869, 96603, 106461, 104649, 60771, 104704, 105892, 64578, 67992, 66226, 123283, 70407, 106762, 74249, 104602, 133993, 79907, 106646, 64531, 110384, 115079, 96476, 103667, 85432, 95012, 89411, 78535, 77525, 1358, 114403, 134984, 79558, 124614, 94316, 100741, 130477, 83107, 34574, 100494, 77386, 128800, 81109, 68419, 109955, 4722, 64850, 109398, 135176, 123813, 97623, 112112, 95670, 65319, 123340, 94355, 80038, 95274, 135576, 13591, 61048, 88526, 111441, 121123, 88377, 132103, 75337, 114463, 123282, 111154, 112473, 122182, 129604, 105104, 110023, 99498, 123098, 131611, 74506, 74126, 90670, 77678, 112529, 84161, 114133, 116035, 76185, 68535, 123044)
Run Time: 0.328455
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: 5, 0, 1715417820, 1715421420, [["thread",120612],["thread",131802],["thread",113585],["thread",28112],["thread",79258],["thread",83717],["thread",123804],["thread",58426],["thread",83381],["thread",99608],["thread",118826],["thread",99765],["thread",114931],["thread",74891],["thread",79260],["thread",117790],["thread",96433],["thread",76462],["thread",109376],["thread",121777],["thread",122771],["thread",67152],["thread",58431],["thread",77613],["thread",111051],["thread",107086],["thread",84639],["thread",65110],["thread",108906],["thread",113958],["thread",1364],["thread",66769],["thread",107730],["thread",99867],["thread",96645],["thread",58419],["thread",89265],["thread",68310],["thread",102030],["thread",122275],["thread",72046],["thread",129056],["thread",96809],["thread",135622],["thread",75813],["thread",96001],["thread",118639],["thread",89719],["thread",99385],["thread",101948],["thread",109784],["thread",88664],["thread",58387],["thread",109442],["thread",1365],["thread",74128],["thread",90545],["thread",73177],["thread",66689],["thread",98935],["thread",134395],["thread",92581],["thread",127405],["thread",119159],["thread",122770],["thread",71615],["thread",101400],["thread",82074],["thread",75734],["thread",108229],["thread",80466],["thread",104401],["thread",1402],["thread",79376],["thread",66279],["thread",85246],["thread",42119],["thread",65835],["thread",366],["thread",119418],["thread",91336],["thread",75092],["thread",96104],["thread",92035],["thread",113784],["thread",110088],["thread",131593],["thread",125538],["thread",114877],["thread",22421],["thread",71402],["thread",66617],["thread",102166],["thread",84634],["thread",118540],["thread",37801],["thread",97238],["thread",110892],["thread",117715],["thread",97594],["thread",64371],["thread",101808],["thread",95487],["thread",133883],["thread",68528],["thread",78216],["thread",79441],["thread",123847],["thread",74409],["thread",60770],["thread",90320],["thread",88258],["thread",136642],["thread",98143],["thread",74519],["thread",99915],["thread",69128],["thread",60240],["thread",76994],["thread",71750],["thread",96528],["thread",80730],["thread",121920],["thread",65578],["thread",96977],["thread",1401],["thread",126585],["thread",90484],["thread",73299],["thread",73473],["thread",112433],["thread",118326],["thread",95997],["thread",96615],["thread",114742],["thread",68757],["thread",80457],["thread",75812],["thread",79693],["thread",77262],["thread",84453],["thread",70653],["thread",70027],["thread",124496],["thread",137177],["thread",74064],["thread",69855],["thread",78584],["thread",72958],["thread",123596],["thread",117638],["thread",92513],["thread",76544],["thread",128877],["thread",101918],["thread",77701],["thread",129624],["thread",71601],["thread",91958],["thread",106311],["thread",109302],["thread",822],["thread",104434],["thread",81297],["thread",75869],["thread",108168],["thread",132284],["thread",109774],["thread",76886],["thread",113498],["thread",74183],["thread",129855],["thread",95753],["thread",47341],["thread",123613],["thread",86943],["thread",62502],["thread",122253],["thread",96368],["thread",1379],["thread",97960],["thread",130333],["thread",123042],["thread",106717],["thread",98855],["thread",37748],["thread",77810],["thread",75953],["thread",97653],["thread",28518],["thread",66936],["thread",74509],["thread",78160],["thread",110155],["thread",123583],["thread",114741],["thread",121988],["thread",105371],["thread",120559],["thread",84435],["thread",90649],["thread",96034],["thread",85530],["thread",91187],["thread",77700],["thread",80345],["thread",75576],["thread",91727],["thread",68552],["thread",55772],["thread",89165],["thread",76513],["thread",65869],["thread",96603],["thread",106461],["thread",104649],["thread",60771],["thread",104704],["thread",105892],["thread",64578],["thread",67992],["thread",66226],["thread",123283],["thread",70407],["thread",106762],["thread",74249],["thread",104602],["thread",133993],["thread",79907],["thread",106646],["thread",64531],["thread",110384],["thread",115079],["thread",96476],["thread",103667],["thread",85432],["thread",95012],["thread",89411],["thread",78535],["thread",77525],["thread",1358],["thread",114403],["thread",134984],["thread",79558],["thread",124614],["thread",94316],["thread",100741],["thread",130477],["thread",83107],["thread",34574],["thread",100494],["thread",77386],["thread",128800],["thread",81109],["thread",68419],["thread",109955],["thread",4722],["thread",64850],["thread",109398],["thread",135176],["thread",123813],["thread",97623],["thread",112112],["thread",95670],["thread",65319],["thread",123340],["thread",94355],["thread",80038],["thread",95274],["thread",135576],["thread",13591],["thread",61048],["thread",88526],["thread",111441],["thread",121123],["thread",88377],["thread",132103],["thread",75337],["thread",114463],["thread",123282],["thread",111154],["thread",112473],["thread",122182],["thread",129604],["thread",105104],["thread",110023],["thread",99498],["thread",123098],["thread",131611],["thread",74506],["thread",74126],["thread",90670],["thread",77678],["thread",112529],["thread",84161],["thread",114133],["thread",116035],["thread",76185],["thread",68535],["thread",123044]]
Run Time: 0.057702
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.000731
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |