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 (93107, 93505, 87760, 40164, 96944, 90044, 110130, 94770, 92982, 83343, 92716, 101307, 93839, 96414, 96040, 93096, 91569, 93239, 96410, 88539, 97885, 75374, 94340, 119015, 93410, 82891, 79647, 126469, 82178, 91290, 85025, 100468, 88166, 99315, 100651, 90833, 72325, 100096, 93057, 78034, 90004, 91769, 83099, 72608, 94631, 75147, 100466, 90967, 97230, 95193, 92666, 104675, 92918, 80968, 90030, 77423, 83158, 103397, 75012, 89001, 75508, 83622, 89342, 95674, 76013, 88441, 125730, 98302, 88284, 100660, 94275, 84886, 125541, 97884, 91442, 84577, 93327, 102238, 84363, 97293, 104844, 88250, 81084, 72312, 90607, 90261, 87846, 93330, 92676, 87896, 97194, 74796, 92911, 88057, 87551, 91478, 83470, 129664, 91994, 85531, 93062, 119183, 91310, 93294, 92407, 92702, 90713, 90949, 88372, 91785, 99972, 90818, 100112, 96407, 93036, 83962, 90005, 94167, 97224, 97128, 95378, 87831, 99508, 98213, 88830, 87527, 76204, 125757, 98895, 86332, 94500, 87712, 99734, 103100, 95520, 82529, 89093, 84582, 86911, 89250, 90483, 94380, 88681, 79635, 88541, 91770, 93751, 82503, 97289, 92085, 89660, 100285, 100286, 97378, 95030, 93074, 90563, 87589, 95196, 75844, 81922, 88068, 86349, 88782, 92124, 85847, 83752, 99736, 86134, 96951, 88569, 103105, 94163, 88904, 99886, 72696, 89484, 132497, 97326, 78650, 90816, 90954, 103359, 82984, 87239, 91431, 90710, 90687, 93740, 96048, 72555, 90415, 95679, 125908, 99308, 124891, 103232, 98791, 91230, 90024, 89008, 83129, 76925, 85123, 93763, 92043, 81198, 93094, 88030, 90001, 85739, 88131, 84753, 87542, 100165, 95192, 87916, 82190, 120990, 92669, 97689, 93203, 90015, 78319, 88010, 89190, 93369, 95904, 54204, 88932, 91160, 80462, 88696, 87148, 87653, 74497, 83567, 92784, 75414, 89687, 95060, 97484, 86025, 98436, 79194, 87424, 88076, 93288, 97314, 96949, 82704, 98825, 94510, 90679, 89066, 81154, 93844, 80607, 40525, 77770, 81401, 90738, 99728)
Run Time: 0.007692
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 263 | 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: 27942, 0, 1714925498, 1714929098, [["thread",93107],["thread",93505],["thread",87760],["thread",40164],["thread",96944],["thread",90044],["thread",110130],["thread",94770],["thread",92982],["thread",83343],["thread",92716],["thread",101307],["thread",93839],["thread",96414],["thread",96040],["thread",93096],["thread",91569],["thread",93239],["thread",96410],["thread",88539],["thread",97885],["thread",75374],["thread",94340],["thread",119015],["thread",93410],["thread",82891],["thread",79647],["thread",126469],["thread",82178],["thread",91290],["thread",85025],["thread",100468],["thread",88166],["thread",99315],["thread",100651],["thread",90833],["thread",72325],["thread",100096],["thread",93057],["thread",78034],["thread",90004],["thread",91769],["thread",83099],["thread",72608],["thread",94631],["thread",75147],["thread",100466],["thread",90967],["thread",97230],["thread",95193],["thread",92666],["thread",104675],["thread",92918],["thread",80968],["thread",90030],["thread",77423],["thread",83158],["thread",103397],["thread",75012],["thread",89001],["thread",75508],["thread",83622],["thread",89342],["thread",95674],["thread",76013],["thread",88441],["thread",125730],["thread",98302],["thread",88284],["thread",100660],["thread",94275],["thread",84886],["thread",125541],["thread",97884],["thread",91442],["thread",84577],["thread",93327],["thread",102238],["thread",84363],["thread",97293],["thread",104844],["thread",88250],["thread",81084],["thread",72312],["thread",90607],["thread",90261],["thread",87846],["thread",93330],["thread",92676],["thread",87896],["thread",97194],["thread",74796],["thread",92911],["thread",88057],["thread",87551],["thread",91478],["thread",83470],["thread",129664],["thread",91994],["thread",85531],["thread",93062],["thread",119183],["thread",91310],["thread",93294],["thread",92407],["thread",92702],["thread",90713],["thread",90949],["thread",88372],["thread",91785],["thread",99972],["thread",90818],["thread",100112],["thread",96407],["thread",93036],["thread",83962],["thread",90005],["thread",94167],["thread",97224],["thread",97128],["thread",95378],["thread",87831],["thread",99508],["thread",98213],["thread",88830],["thread",87527],["thread",76204],["thread",125757],["thread",98895],["thread",86332],["thread",94500],["thread",87712],["thread",99734],["thread",103100],["thread",95520],["thread",82529],["thread",89093],["thread",84582],["thread",86911],["thread",89250],["thread",90483],["thread",94380],["thread",88681],["thread",79635],["thread",88541],["thread",91770],["thread",93751],["thread",82503],["thread",97289],["thread",92085],["thread",89660],["thread",100285],["thread",100286],["thread",97378],["thread",95030],["thread",93074],["thread",90563],["thread",87589],["thread",95196],["thread",75844],["thread",81922],["thread",88068],["thread",86349],["thread",88782],["thread",92124],["thread",85847],["thread",83752],["thread",99736],["thread",86134],["thread",96951],["thread",88569],["thread",103105],["thread",94163],["thread",88904],["thread",99886],["thread",72696],["thread",89484],["thread",132497],["thread",97326],["thread",78650],["thread",90816],["thread",90954],["thread",103359],["thread",82984],["thread",87239],["thread",91431],["thread",90710],["thread",90687],["thread",93740],["thread",96048],["thread",72555],["thread",90415],["thread",95679],["thread",125908],["thread",99308],["thread",124891],["thread",103232],["thread",98791],["thread",91230],["thread",90024],["thread",89008],["thread",83129],["thread",76925],["thread",85123],["thread",93763],["thread",92043],["thread",81198],["thread",93094],["thread",88030],["thread",90001],["thread",85739],["thread",88131],["thread",84753],["thread",87542],["thread",100165],["thread",95192],["thread",87916],["thread",82190],["thread",120990],["thread",92669],["thread",97689],["thread",93203],["thread",90015],["thread",78319],["thread",88010],["thread",89190],["thread",93369],["thread",95904],["thread",54204],["thread",88932],["thread",91160],["thread",80462],["thread",88696],["thread",87148],["thread",87653],["thread",74497],["thread",83567],["thread",92784],["thread",75414],["thread",89687],["thread",95060],["thread",97484],["thread",86025],["thread",98436],["thread",79194],["thread",87424],["thread",88076],["thread",93288],["thread",97314],["thread",96949],["thread",82704],["thread",98825],["thread",94510],["thread",90679],["thread",89066],["thread",81154],["thread",93844],["thread",80607],["thread",40525],["thread",77770],["thread",81401],["thread",90738],["thread",99728]]
Run Time: 0.019270
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.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |