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 (31801, 56294, 73741, 74405, 54141, 125255, 29870, 48478, 78003, 132321, 98424, 66249, 84579, 89386, 44691, 106444, 85332, 19981, 21454, 822, 57164, 67088, 41913, 36859, 78754, 68012, 49015, 11066, 108805, 40613, 56130, 133463, 43699, 38355, 7596, 62968, 59603, 56298, 57822, 88063, 21628, 37755, 76563, 34421, 16599, 97764, 40871, 45005, 82409, 87121, 48279, 72205, 16613, 57591, 104397, 30597, 31996, 120213, 58739, 102872, 58339, 36896, 132377, 45250, 64588, 60837, 57013, 96193, 133824, 3890, 83128, 69553, 69222, 76978, 34457, 94940, 96845, 94594, 87498, 62179, 124038, 5127, 71978, 53072, 85188, 107412, 25093, 76070, 133720, 55887, 96213, 135956, 74641, 74359, 36397, 51201, 59169, 51592, 90663, 57659, 88511, 56177, 51929, 88791, 33197, 78789, 25276, 81396, 67500, 15009, 57460, 126531, 43399, 94433, 53976, 57806, 27753, 36377, 68365, 59904, 60340, 23968, 118873, 16622, 57655, 50034, 61899, 18792, 61267, 102989, 57228, 85336, 65351, 118497, 86308, 93621, 91576, 56545, 74171, 65374, 132337, 51208, 44597, 119179, 57071, 56608, 84609, 105112, 77006, 104371, 91704, 21767, 57155, 41823, 37790, 70360, 15514, 57737, 56998, 47098, 94193, 58219, 15765, 121041, 100193, 36466, 29956, 96017, 87158, 34763, 91602, 23131, 100462, 93367, 57489, 58424, 55816, 124909, 16807, 57805, 57652, 106958, 97415, 96479, 62732, 49045, 114069, 55890, 56243, 76233, 47252, 57868, 48917, 28795, 120493, 122645, 122702, 57064, 47209, 89318, 71565, 55837, 55835, 57893, 59733, 86219, 68418, 17939, 46866, 58244, 18208, 77024, 52688, 80221, 132324, 55244, 3526, 99589, 56173, 119147, 45623, 55310, 89032, 49720, 36669, 114623, 82632, 52148, 132742, 37630, 26499, 71763, 56306, 57492, 14950, 825, 87677, 91983, 107364, 60558, 12123, 131144, 66465, 61977, 34382, 13637, 122254, 58336, 59898, 44808, 70794, 666, 34524, 37405, 9754, 80224, 91018, 106249, 96258, 26470, 67152, 42575, 49797, 63025, 115722, 57208, 60685, 76905, 54621, 61995, 56568, 59861, 46816, 96161)
Run Time: 0.016686
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 274 | 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: 457, 0, 1714170526, 1714174126, [["thread",31801],["thread",56294],["thread",73741],["thread",74405],["thread",54141],["thread",125255],["thread",29870],["thread",48478],["thread",78003],["thread",132321],["thread",98424],["thread",66249],["thread",84579],["thread",89386],["thread",44691],["thread",106444],["thread",85332],["thread",19981],["thread",21454],["thread",822],["thread",57164],["thread",67088],["thread",41913],["thread",36859],["thread",78754],["thread",68012],["thread",49015],["thread",11066],["thread",108805],["thread",40613],["thread",56130],["thread",133463],["thread",43699],["thread",38355],["thread",7596],["thread",62968],["thread",59603],["thread",56298],["thread",57822],["thread",88063],["thread",21628],["thread",37755],["thread",76563],["thread",34421],["thread",16599],["thread",97764],["thread",40871],["thread",45005],["thread",82409],["thread",87121],["thread",48279],["thread",72205],["thread",16613],["thread",57591],["thread",104397],["thread",30597],["thread",31996],["thread",120213],["thread",58739],["thread",102872],["thread",58339],["thread",36896],["thread",132377],["thread",45250],["thread",64588],["thread",60837],["thread",57013],["thread",96193],["thread",133824],["thread",3890],["thread",83128],["thread",69553],["thread",69222],["thread",76978],["thread",34457],["thread",94940],["thread",96845],["thread",94594],["thread",87498],["thread",62179],["thread",124038],["thread",5127],["thread",71978],["thread",53072],["thread",85188],["thread",107412],["thread",25093],["thread",76070],["thread",133720],["thread",55887],["thread",96213],["thread",135956],["thread",74641],["thread",74359],["thread",36397],["thread",51201],["thread",59169],["thread",51592],["thread",90663],["thread",57659],["thread",88511],["thread",56177],["thread",51929],["thread",88791],["thread",33197],["thread",78789],["thread",25276],["thread",81396],["thread",67500],["thread",15009],["thread",57460],["thread",126531],["thread",43399],["thread",94433],["thread",53976],["thread",57806],["thread",27753],["thread",36377],["thread",68365],["thread",59904],["thread",60340],["thread",23968],["thread",118873],["thread",16622],["thread",57655],["thread",50034],["thread",61899],["thread",18792],["thread",61267],["thread",102989],["thread",57228],["thread",85336],["thread",65351],["thread",118497],["thread",86308],["thread",93621],["thread",91576],["thread",56545],["thread",74171],["thread",65374],["thread",132337],["thread",51208],["thread",44597],["thread",119179],["thread",57071],["thread",56608],["thread",84609],["thread",105112],["thread",77006],["thread",104371],["thread",91704],["thread",21767],["thread",57155],["thread",41823],["thread",37790],["thread",70360],["thread",15514],["thread",57737],["thread",56998],["thread",47098],["thread",94193],["thread",58219],["thread",15765],["thread",121041],["thread",100193],["thread",36466],["thread",29956],["thread",96017],["thread",87158],["thread",34763],["thread",91602],["thread",23131],["thread",100462],["thread",93367],["thread",57489],["thread",58424],["thread",55816],["thread",124909],["thread",16807],["thread",57805],["thread",57652],["thread",106958],["thread",97415],["thread",96479],["thread",62732],["thread",49045],["thread",114069],["thread",55890],["thread",56243],["thread",76233],["thread",47252],["thread",57868],["thread",48917],["thread",28795],["thread",120493],["thread",122645],["thread",122702],["thread",57064],["thread",47209],["thread",89318],["thread",71565],["thread",55837],["thread",55835],["thread",57893],["thread",59733],["thread",86219],["thread",68418],["thread",17939],["thread",46866],["thread",58244],["thread",18208],["thread",77024],["thread",52688],["thread",80221],["thread",132324],["thread",55244],["thread",3526],["thread",99589],["thread",56173],["thread",119147],["thread",45623],["thread",55310],["thread",89032],["thread",49720],["thread",36669],["thread",114623],["thread",82632],["thread",52148],["thread",132742],["thread",37630],["thread",26499],["thread",71763],["thread",56306],["thread",57492],["thread",14950],["thread",825],["thread",87677],["thread",91983],["thread",107364],["thread",60558],["thread",12123],["thread",131144],["thread",66465],["thread",61977],["thread",34382],["thread",13637],["thread",122254],["thread",58336],["thread",59898],["thread",44808],["thread",70794],["thread",666],["thread",34524],["thread",37405],["thread",9754],["thread",80224],["thread",91018],["thread",106249],["thread",96258],["thread",26470],["thread",67152],["thread",42575],["thread",49797],["thread",63025],["thread",115722],["thread",57208],["thread",60685],["thread",76905],["thread",54621],["thread",61995],["thread",56568],["thread",59861],["thread",46816],["thread",96161]]
Run Time: 0.003349
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |