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 (92987, 116632, 1049, 75747, 1580, 68241, 59143, 36032, 96728, 92053, 83466, 59802, 7270, 90597, 96135, 86139, 118437, 9303, 26883, 109143, 10700, 76618, 65673, 93616, 2936, 63315, 60087, 1221, 1525, 86944, 9066, 58927, 46544, 52597, 91074, 3101, 27707, 67846, 122022, 87377, 35340, 65691, 86007, 65517, 108580, 5217, 114847, 8513, 32149, 62406, 85430, 106536, 67400, 69063, 127102, 37161, 108354, 69707, 60427, 22858, 80186, 33835, 38579, 65525, 86964, 77778, 37117, 1579, 59118, 97443, 82378, 33960, 35409, 1581, 59281, 50202, 2832, 59629, 87185, 13681, 51844, 59589, 70425, 75762, 103994, 88318, 77902, 76619, 80553, 33823, 131702, 75512, 86656, 10549, 97635, 90925, 65428, 30241, 1952, 366, 16638, 65810, 38115, 102000, 25311, 89543, 109544, 105341, 3392, 64774, 60039, 59345, 89702, 80844, 1717, 68758, 84792, 103158, 77222, 34034, 5509, 62902, 7146, 4923, 8417, 118435, 62292, 111053, 22651, 34053, 82057, 114171, 109179, 65488, 51959, 102834, 116846, 79937, 116998, 1052, 95781, 2147, 8554, 65512, 51878, 86570, 27723, 73018, 88237, 70258, 65758, 75053, 82686, 2639, 59772, 99606, 62472, 86634, 109546, 116925, 23903, 93320, 96444, 82062, 94636, 82086, 62985, 91251, 33834, 82030, 80992, 23494, 108477, 72790, 108519, 85528, 111566, 1155, 98568, 51632, 61343, 51227, 108493, 86550, 62397, 103947, 109937, 63136, 4509, 7479, 33969, 22558, 65648, 108231, 85539, 7406, 69199, 91443, 7118, 2864, 86786, 118468, 87182, 118387, 92835, 23650, 100489, 1188, 51924, 62408, 5669, 87944, 85615, 75025, 69823, 88833, 1139, 87569, 118521, 108419, 80832, 63267, 61275, 95427, 87748, 1135, 68190, 108713, 90835, 10469, 79401, 22626, 114172, 113055, 87137, 81890, 99866, 61581, 32559, 72727, 643, 125935, 85770, 50049, 108839, 110449, 119512, 98492, 33983, 63560, 67562, 80165, 88464, 86707, 80754, 114646, 16785)
Run Time: 0.019678
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 257 | 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: 10, 0, 1713624667, 1713628267, [["thread",92987],["thread",116632],["thread",1049],["thread",75747],["thread",1580],["thread",68241],["thread",59143],["thread",36032],["thread",96728],["thread",92053],["thread",83466],["thread",59802],["thread",7270],["thread",90597],["thread",96135],["thread",86139],["thread",118437],["thread",9303],["thread",26883],["thread",109143],["thread",10700],["thread",76618],["thread",65673],["thread",93616],["thread",2936],["thread",63315],["thread",60087],["thread",1221],["thread",1525],["thread",86944],["thread",9066],["thread",58927],["thread",46544],["thread",52597],["thread",91074],["thread",3101],["thread",27707],["thread",67846],["thread",122022],["thread",87377],["thread",35340],["thread",65691],["thread",86007],["thread",65517],["thread",108580],["thread",5217],["thread",114847],["thread",8513],["thread",32149],["thread",62406],["thread",85430],["thread",106536],["thread",67400],["thread",69063],["thread",127102],["thread",37161],["thread",108354],["thread",69707],["thread",60427],["thread",22858],["thread",80186],["thread",33835],["thread",38579],["thread",65525],["thread",86964],["thread",77778],["thread",37117],["thread",1579],["thread",59118],["thread",97443],["thread",82378],["thread",33960],["thread",35409],["thread",1581],["thread",59281],["thread",50202],["thread",2832],["thread",59629],["thread",87185],["thread",13681],["thread",51844],["thread",59589],["thread",70425],["thread",75762],["thread",103994],["thread",88318],["thread",77902],["thread",76619],["thread",80553],["thread",33823],["thread",131702],["thread",75512],["thread",86656],["thread",10549],["thread",97635],["thread",90925],["thread",65428],["thread",30241],["thread",1952],["thread",366],["thread",16638],["thread",65810],["thread",38115],["thread",102000],["thread",25311],["thread",89543],["thread",109544],["thread",105341],["thread",3392],["thread",64774],["thread",60039],["thread",59345],["thread",89702],["thread",80844],["thread",1717],["thread",68758],["thread",84792],["thread",103158],["thread",77222],["thread",34034],["thread",5509],["thread",62902],["thread",7146],["thread",4923],["thread",8417],["thread",118435],["thread",62292],["thread",111053],["thread",22651],["thread",34053],["thread",82057],["thread",114171],["thread",109179],["thread",65488],["thread",51959],["thread",102834],["thread",116846],["thread",79937],["thread",116998],["thread",1052],["thread",95781],["thread",2147],["thread",8554],["thread",65512],["thread",51878],["thread",86570],["thread",27723],["thread",73018],["thread",88237],["thread",70258],["thread",65758],["thread",75053],["thread",82686],["thread",2639],["thread",59772],["thread",99606],["thread",62472],["thread",86634],["thread",109546],["thread",116925],["thread",23903],["thread",93320],["thread",96444],["thread",82062],["thread",94636],["thread",82086],["thread",62985],["thread",91251],["thread",33834],["thread",82030],["thread",80992],["thread",23494],["thread",108477],["thread",72790],["thread",108519],["thread",85528],["thread",111566],["thread",1155],["thread",98568],["thread",51632],["thread",61343],["thread",51227],["thread",108493],["thread",86550],["thread",62397],["thread",103947],["thread",109937],["thread",63136],["thread",4509],["thread",7479],["thread",33969],["thread",22558],["thread",65648],["thread",108231],["thread",85539],["thread",7406],["thread",69199],["thread",91443],["thread",7118],["thread",2864],["thread",86786],["thread",118468],["thread",87182],["thread",118387],["thread",92835],["thread",23650],["thread",100489],["thread",1188],["thread",51924],["thread",62408],["thread",5669],["thread",87944],["thread",85615],["thread",75025],["thread",69823],["thread",88833],["thread",1139],["thread",87569],["thread",118521],["thread",108419],["thread",80832],["thread",63267],["thread",61275],["thread",95427],["thread",87748],["thread",1135],["thread",68190],["thread",108713],["thread",90835],["thread",10469],["thread",79401],["thread",22626],["thread",114172],["thread",113055],["thread",87137],["thread",81890],["thread",99866],["thread",61581],["thread",32559],["thread",72727],["thread",643],["thread",125935],["thread",85770],["thread",50049],["thread",108839],["thread",110449],["thread",119512],["thread",98492],["thread",33983],["thread",63560],["thread",67562],["thread",80165],["thread",88464],["thread",86707],["thread",80754],["thread",114646],["thread",16785]]
Run Time: 0.001084
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.000076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |