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 (91326, 43271, 63762, 113085, 122540, 84183, 68289, 68778, 93272, 48909, 73119, 94451, 87119, 72602, 108941, 65181, 44339, 23470, 59417, 92303, 87972, 41290, 94166, 79704, 25563, 77047, 109571, 67365, 87603, 70690, 45247, 84020, 73931, 20684, 66838, 42035, 41713, 66543, 131556, 67542, 61544, 84250, 64952, 98549, 108957, 16315, 90168, 71241, 21281, 115030, 43766, 56546, 121221, 72527, 70218, 55799, 115650, 55677, 64861, 125138, 82695, 68406, 95276, 95691, 107498, 77168, 79549, 91747, 79784, 25632, 84752, 23253, 113612, 74800, 131424, 51962, 97942, 91666, 43403, 95355, 108522, 54637, 71743, 57419, 72842, 60535, 48654, 36537, 124068, 118062, 94645, 42085, 54794, 86169, 61364, 94479, 83450, 70893, 87016, 84959, 80091, 57311, 106291, 30466, 91381, 86443, 87900, 39046, 94329, 91638, 113071, 124125, 39556, 103736, 115504, 88969, 79995, 29311, 91941, 56370, 62305, 92684, 57540, 89751, 67665, 59848, 41718, 87679, 86048, 90508, 67727, 102936, 61830, 82116, 108528, 87166, 98098, 87821, 84507, 63804, 120092, 51729, 23507, 135602, 24996, 70546, 21479, 71681, 49713, 66431, 84651, 47038, 37983, 66026, 40868, 88064, 101790, 107518, 89561, 41998, 66008, 119496, 73846, 96454, 58715, 113529, 101711, 125368, 99559, 121586, 101374, 114238, 55524, 83424, 84656, 63272, 87688, 80558, 108374, 55255, 109395, 70306, 87844, 60954, 32046, 93031, 93256, 95062, 94257, 100955, 13003, 111978, 84611, 108398, 89739, 100363, 125987, 91453, 83061, 62816, 69111, 110223, 51082, 106840, 84450, 107862, 83751, 53332, 23426, 81888, 103744, 86579, 84822, 125658, 69972, 51535, 61646, 21589, 82979, 98091, 64747, 108527, 85825, 35906, 33179, 58956, 90389, 93442, 61665, 23346, 53957, 59757, 68399, 123463, 91345, 53832, 55026, 112165, 84094, 53115, 90208, 121207, 95898, 69293, 40252, 113838, 105007, 106414, 103293, 71741, 66440, 86521, 113116, 97313, 106961, 100408, 110636, 87535, 53116, 69595, 85081, 101835, 79680, 84524, 95185, 75169, 72747, 113895, 57127, 113873, 61081, 85605, 79363, 95302, 95939, 62192, 95499, 112270, 71646, 91480, 70099, 90996, 121228, 59315, 66118, 79900, 26830, 113081, 60455, 61555, 72624, 87159, 105380, 108380, 125539, 101174, 22596, 96382, 86584, 87195)
Run Time: 0.007816
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: 5273, 0, 1713574857, 1713578457, [["thread",91326],["thread",43271],["thread",63762],["thread",113085],["thread",122540],["thread",84183],["thread",68289],["thread",68778],["thread",93272],["thread",48909],["thread",73119],["thread",94451],["thread",87119],["thread",72602],["thread",108941],["thread",65181],["thread",44339],["thread",23470],["thread",59417],["thread",92303],["thread",87972],["thread",41290],["thread",94166],["thread",79704],["thread",25563],["thread",77047],["thread",109571],["thread",67365],["thread",87603],["thread",70690],["thread",45247],["thread",84020],["thread",73931],["thread",20684],["thread",66838],["thread",42035],["thread",41713],["thread",66543],["thread",131556],["thread",67542],["thread",61544],["thread",84250],["thread",64952],["thread",98549],["thread",108957],["thread",16315],["thread",90168],["thread",71241],["thread",21281],["thread",115030],["thread",43766],["thread",56546],["thread",121221],["thread",72527],["thread",70218],["thread",55799],["thread",115650],["thread",55677],["thread",64861],["thread",125138],["thread",82695],["thread",68406],["thread",95276],["thread",95691],["thread",107498],["thread",77168],["thread",79549],["thread",91747],["thread",79784],["thread",25632],["thread",84752],["thread",23253],["thread",113612],["thread",74800],["thread",131424],["thread",51962],["thread",97942],["thread",91666],["thread",43403],["thread",95355],["thread",108522],["thread",54637],["thread",71743],["thread",57419],["thread",72842],["thread",60535],["thread",48654],["thread",36537],["thread",124068],["thread",118062],["thread",94645],["thread",42085],["thread",54794],["thread",86169],["thread",61364],["thread",94479],["thread",83450],["thread",70893],["thread",87016],["thread",84959],["thread",80091],["thread",57311],["thread",106291],["thread",30466],["thread",91381],["thread",86443],["thread",87900],["thread",39046],["thread",94329],["thread",91638],["thread",113071],["thread",124125],["thread",39556],["thread",103736],["thread",115504],["thread",88969],["thread",79995],["thread",29311],["thread",91941],["thread",56370],["thread",62305],["thread",92684],["thread",57540],["thread",89751],["thread",67665],["thread",59848],["thread",41718],["thread",87679],["thread",86048],["thread",90508],["thread",67727],["thread",102936],["thread",61830],["thread",82116],["thread",108528],["thread",87166],["thread",98098],["thread",87821],["thread",84507],["thread",63804],["thread",120092],["thread",51729],["thread",23507],["thread",135602],["thread",24996],["thread",70546],["thread",21479],["thread",71681],["thread",49713],["thread",66431],["thread",84651],["thread",47038],["thread",37983],["thread",66026],["thread",40868],["thread",88064],["thread",101790],["thread",107518],["thread",89561],["thread",41998],["thread",66008],["thread",119496],["thread",73846],["thread",96454],["thread",58715],["thread",113529],["thread",101711],["thread",125368],["thread",99559],["thread",121586],["thread",101374],["thread",114238],["thread",55524],["thread",83424],["thread",84656],["thread",63272],["thread",87688],["thread",80558],["thread",108374],["thread",55255],["thread",109395],["thread",70306],["thread",87844],["thread",60954],["thread",32046],["thread",93031],["thread",93256],["thread",95062],["thread",94257],["thread",100955],["thread",13003],["thread",111978],["thread",84611],["thread",108398],["thread",89739],["thread",100363],["thread",125987],["thread",91453],["thread",83061],["thread",62816],["thread",69111],["thread",110223],["thread",51082],["thread",106840],["thread",84450],["thread",107862],["thread",83751],["thread",53332],["thread",23426],["thread",81888],["thread",103744],["thread",86579],["thread",84822],["thread",125658],["thread",69972],["thread",51535],["thread",61646],["thread",21589],["thread",82979],["thread",98091],["thread",64747],["thread",108527],["thread",85825],["thread",35906],["thread",33179],["thread",58956],["thread",90389],["thread",93442],["thread",61665],["thread",23346],["thread",53957],["thread",59757],["thread",68399],["thread",123463],["thread",91345],["thread",53832],["thread",55026],["thread",112165],["thread",84094],["thread",53115],["thread",90208],["thread",121207],["thread",95898],["thread",69293],["thread",40252],["thread",113838],["thread",105007],["thread",106414],["thread",103293],["thread",71741],["thread",66440],["thread",86521],["thread",113116],["thread",97313],["thread",106961],["thread",100408],["thread",110636],["thread",87535],["thread",53116],["thread",69595],["thread",85081],["thread",101835],["thread",79680],["thread",84524],["thread",95185],["thread",75169],["thread",72747],["thread",113895],["thread",57127],["thread",113873],["thread",61081],["thread",85605],["thread",79363],["thread",95302],["thread",95939],["thread",62192],["thread",95499],["thread",112270],["thread",71646],["thread",91480],["thread",70099],["thread",90996],["thread",121228],["thread",59315],["thread",66118],["thread",79900],["thread",26830],["thread",113081],["thread",60455],["thread",61555],["thread",72624],["thread",87159],["thread",105380],["thread",108380],["thread",125539],["thread",101174],["thread",22596],["thread",96382],["thread",86584],["thread",87195]]
Run Time: 0.000930
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.000085
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |