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 (97459, 74405, 77335, 98464, 46750, 97177, 82817, 99767, 79651, 86635, 98143, 76770, 54616, 100896, 97466, 71723, 67035, 111865, 100460, 49557, 114059, 127029, 66582, 98972, 35291, 80273, 100977, 63302, 50259, 66976, 67489, 101212, 111862, 96404, 78278, 93606, 64553, 62278, 46316, 86547, 78004, 48652, 92805, 112693, 98462, 66967, 97931, 69902, 125756, 80959, 92812, 111711, 99147, 35602, 79653, 38989, 39234, 52916, 81736, 97461, 87777, 112143, 98382, 112145, 96771, 82281, 97822, 48531, 73216, 78315, 113008, 76638, 66841, 116437, 35608, 97789, 127653, 49559, 46393, 88137, 99150, 107456, 67471, 101867, 97547, 98400, 112220, 97718, 101535, 50414, 97975, 50412, 101406, 51212, 101259, 100979, 65037, 34792, 79441, 61226, 78836, 118615, 116903, 35607, 78385, 116483, 65374, 97796, 50258, 92995, 70238, 96978, 80780, 41164, 96866, 100325, 101208, 35204, 72616, 113001, 51270, 97715, 98061, 98558, 34790, 67180, 92816, 97104, 81737, 90160, 46314, 71530, 104265, 86808, 116422, 99613, 51266, 77523, 78468, 103322, 77332, 116510, 77162, 98390, 77589, 112209, 76546, 102442, 76651, 97264, 98479, 80274, 76547, 80275, 95800, 76359, 87879, 97312, 66575, 95197, 88266, 33984, 107960, 98460, 112439, 111969, 98613, 62690, 33986, 102628, 97266, 101730, 79640, 50415, 101412, 67162, 90502, 62178, 88189, 102829, 76428, 35603, 93230, 97496, 122328, 51263, 52631, 68763, 66641, 76545, 97189, 81744, 126175, 98060, 49560, 98057, 91796, 98618, 79586, 92975, 61979, 86752, 121422, 97091, 86638, 85635, 93041, 98610, 96985, 63157, 69923, 90343, 72514, 70684, 71982, 98514, 50042, 116454, 89616, 126007, 102558, 98381, 98946, 99161, 92755, 35605, 86362, 99085, 49558, 99700, 79745, 73662, 52962, 96580, 89071, 80126, 53831, 91296, 107356, 65963, 111867, 113493, 67106, 97935, 98392, 97825, 80215, 112216, 50256, 72372, 112725)
Run Time: 0.005145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 251 | 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: 9372, 0, 1713578779, 1713582379, [["thread",97459],["thread",74405],["thread",77335],["thread",98464],["thread",46750],["thread",97177],["thread",82817],["thread",99767],["thread",79651],["thread",86635],["thread",98143],["thread",76770],["thread",54616],["thread",100896],["thread",97466],["thread",71723],["thread",67035],["thread",111865],["thread",100460],["thread",49557],["thread",114059],["thread",127029],["thread",66582],["thread",98972],["thread",35291],["thread",80273],["thread",100977],["thread",63302],["thread",50259],["thread",66976],["thread",67489],["thread",101212],["thread",111862],["thread",96404],["thread",78278],["thread",93606],["thread",64553],["thread",62278],["thread",46316],["thread",86547],["thread",78004],["thread",48652],["thread",92805],["thread",112693],["thread",98462],["thread",66967],["thread",97931],["thread",69902],["thread",125756],["thread",80959],["thread",92812],["thread",111711],["thread",99147],["thread",35602],["thread",79653],["thread",38989],["thread",39234],["thread",52916],["thread",81736],["thread",97461],["thread",87777],["thread",112143],["thread",98382],["thread",112145],["thread",96771],["thread",82281],["thread",97822],["thread",48531],["thread",73216],["thread",78315],["thread",113008],["thread",76638],["thread",66841],["thread",116437],["thread",35608],["thread",97789],["thread",127653],["thread",49559],["thread",46393],["thread",88137],["thread",99150],["thread",107456],["thread",67471],["thread",101867],["thread",97547],["thread",98400],["thread",112220],["thread",97718],["thread",101535],["thread",50414],["thread",97975],["thread",50412],["thread",101406],["thread",51212],["thread",101259],["thread",100979],["thread",65037],["thread",34792],["thread",79441],["thread",61226],["thread",78836],["thread",118615],["thread",116903],["thread",35607],["thread",78385],["thread",116483],["thread",65374],["thread",97796],["thread",50258],["thread",92995],["thread",70238],["thread",96978],["thread",80780],["thread",41164],["thread",96866],["thread",100325],["thread",101208],["thread",35204],["thread",72616],["thread",113001],["thread",51270],["thread",97715],["thread",98061],["thread",98558],["thread",34790],["thread",67180],["thread",92816],["thread",97104],["thread",81737],["thread",90160],["thread",46314],["thread",71530],["thread",104265],["thread",86808],["thread",116422],["thread",99613],["thread",51266],["thread",77523],["thread",78468],["thread",103322],["thread",77332],["thread",116510],["thread",77162],["thread",98390],["thread",77589],["thread",112209],["thread",76546],["thread",102442],["thread",76651],["thread",97264],["thread",98479],["thread",80274],["thread",76547],["thread",80275],["thread",95800],["thread",76359],["thread",87879],["thread",97312],["thread",66575],["thread",95197],["thread",88266],["thread",33984],["thread",107960],["thread",98460],["thread",112439],["thread",111969],["thread",98613],["thread",62690],["thread",33986],["thread",102628],["thread",97266],["thread",101730],["thread",79640],["thread",50415],["thread",101412],["thread",67162],["thread",90502],["thread",62178],["thread",88189],["thread",102829],["thread",76428],["thread",35603],["thread",93230],["thread",97496],["thread",122328],["thread",51263],["thread",52631],["thread",68763],["thread",66641],["thread",76545],["thread",97189],["thread",81744],["thread",126175],["thread",98060],["thread",49560],["thread",98057],["thread",91796],["thread",98618],["thread",79586],["thread",92975],["thread",61979],["thread",86752],["thread",121422],["thread",97091],["thread",86638],["thread",85635],["thread",93041],["thread",98610],["thread",96985],["thread",63157],["thread",69923],["thread",90343],["thread",72514],["thread",70684],["thread",71982],["thread",98514],["thread",50042],["thread",116454],["thread",89616],["thread",126007],["thread",102558],["thread",98381],["thread",98946],["thread",99161],["thread",92755],["thread",35605],["thread",86362],["thread",99085],["thread",49558],["thread",99700],["thread",79745],["thread",73662],["thread",52962],["thread",96580],["thread",89071],["thread",80126],["thread",53831],["thread",91296],["thread",107356],["thread",65963],["thread",111867],["thread",113493],["thread",67106],["thread",97935],["thread",98392],["thread",97825],["thread",80215],["thread",112216],["thread",50256],["thread",72372],["thread",112725]]
Run Time: 0.001071
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.000092
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |