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 (105400, 64918, 89130, 132619, 135016, 70871, 75084, 105155, 49617, 127063, 92180, 116563, 105339, 106654, 136564, 99137, 98732, 51951, 80046, 100260, 87358, 38134, 115009, 97560, 56710, 22606, 34937, 68714, 55304, 108437, 82471, 132203, 110744, 56489, 46936, 125406, 108568, 38532, 99216, 56743, 134936, 125053, 55396, 52164, 39585, 117899, 52997, 51052, 68565, 71422, 135930, 63838, 67334, 115020, 116383, 96694, 47589, 104707, 32113, 83320, 90635, 2623, 103469, 51871, 40869, 18903, 114018, 30974, 91551, 77987, 64646, 125049, 61407, 135809, 78937, 103036, 77773, 49931, 38428, 135000, 86765, 71059, 50237, 110735, 11877, 123102, 68246, 104621, 105793, 96413, 118289, 56947, 103312, 56789, 95688, 72023, 64879, 70537, 118217, 19928, 77686, 124495, 120056, 71495, 122016, 117589, 75587, 75441, 55697, 31915, 36669, 26012, 54619, 59391, 78213, 23641, 99582, 113683, 43383, 101184, 70760, 51775, 50721, 119329, 97231, 69489, 55763, 45321, 104136, 70328, 88835, 89926, 55203, 108208, 51053, 117691, 103829, 52185, 51620, 91370, 103572, 130213, 87579, 75188, 38807, 49386, 57334, 77657, 118344, 121829, 33076, 131524, 85125, 120283, 95998, 91402, 77710, 86152, 60123, 74714, 87487, 91753, 127512, 30082, 57093, 92936, 53910, 105311, 96035, 16693, 30552, 118398, 133780, 80366, 90893, 68402, 116293, 45852, 84956, 57136, 97445, 63758, 128803, 66141, 86214, 72878, 57499, 116229, 63386, 57767, 100167, 50628, 73519, 111178, 42537, 49926, 86143, 43056, 93870, 85514, 117297, 47249, 117656, 25498, 77161, 94624, 107468, 133314, 106118, 51929, 45291, 26015, 45151, 69356, 114855, 105331, 112915, 94405, 65345, 38546, 103659, 60449, 86624, 87854, 134640, 81127, 97476, 51500, 71242, 48251, 32841, 54258, 96434, 101370, 51468, 103415, 106575, 123937, 57094, 105559, 89075, 70946, 62684, 125629, 122124, 60312, 114125, 12774, 102387, 74138, 125201, 52348, 68583, 106006, 36188, 113413, 59423, 112727, 64505, 64953, 69675, 85779, 68151, 103987, 51723, 73530, 121847, 45323, 66106, 111439, 102592, 64927, 44856, 53273)
Run Time: 0.015226
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: 1163, 0, 1714181717, 1714185317, [["thread",105400],["thread",64918],["thread",89130],["thread",132619],["thread",135016],["thread",70871],["thread",75084],["thread",105155],["thread",49617],["thread",127063],["thread",92180],["thread",116563],["thread",105339],["thread",106654],["thread",136564],["thread",99137],["thread",98732],["thread",51951],["thread",80046],["thread",100260],["thread",87358],["thread",38134],["thread",115009],["thread",97560],["thread",56710],["thread",22606],["thread",34937],["thread",68714],["thread",55304],["thread",108437],["thread",82471],["thread",132203],["thread",110744],["thread",56489],["thread",46936],["thread",125406],["thread",108568],["thread",38532],["thread",99216],["thread",56743],["thread",134936],["thread",125053],["thread",55396],["thread",52164],["thread",39585],["thread",117899],["thread",52997],["thread",51052],["thread",68565],["thread",71422],["thread",135930],["thread",63838],["thread",67334],["thread",115020],["thread",116383],["thread",96694],["thread",47589],["thread",104707],["thread",32113],["thread",83320],["thread",90635],["thread",2623],["thread",103469],["thread",51871],["thread",40869],["thread",18903],["thread",114018],["thread",30974],["thread",91551],["thread",77987],["thread",64646],["thread",125049],["thread",61407],["thread",135809],["thread",78937],["thread",103036],["thread",77773],["thread",49931],["thread",38428],["thread",135000],["thread",86765],["thread",71059],["thread",50237],["thread",110735],["thread",11877],["thread",123102],["thread",68246],["thread",104621],["thread",105793],["thread",96413],["thread",118289],["thread",56947],["thread",103312],["thread",56789],["thread",95688],["thread",72023],["thread",64879],["thread",70537],["thread",118217],["thread",19928],["thread",77686],["thread",124495],["thread",120056],["thread",71495],["thread",122016],["thread",117589],["thread",75587],["thread",75441],["thread",55697],["thread",31915],["thread",36669],["thread",26012],["thread",54619],["thread",59391],["thread",78213],["thread",23641],["thread",99582],["thread",113683],["thread",43383],["thread",101184],["thread",70760],["thread",51775],["thread",50721],["thread",119329],["thread",97231],["thread",69489],["thread",55763],["thread",45321],["thread",104136],["thread",70328],["thread",88835],["thread",89926],["thread",55203],["thread",108208],["thread",51053],["thread",117691],["thread",103829],["thread",52185],["thread",51620],["thread",91370],["thread",103572],["thread",130213],["thread",87579],["thread",75188],["thread",38807],["thread",49386],["thread",57334],["thread",77657],["thread",118344],["thread",121829],["thread",33076],["thread",131524],["thread",85125],["thread",120283],["thread",95998],["thread",91402],["thread",77710],["thread",86152],["thread",60123],["thread",74714],["thread",87487],["thread",91753],["thread",127512],["thread",30082],["thread",57093],["thread",92936],["thread",53910],["thread",105311],["thread",96035],["thread",16693],["thread",30552],["thread",118398],["thread",133780],["thread",80366],["thread",90893],["thread",68402],["thread",116293],["thread",45852],["thread",84956],["thread",57136],["thread",97445],["thread",63758],["thread",128803],["thread",66141],["thread",86214],["thread",72878],["thread",57499],["thread",116229],["thread",63386],["thread",57767],["thread",100167],["thread",50628],["thread",73519],["thread",111178],["thread",42537],["thread",49926],["thread",86143],["thread",43056],["thread",93870],["thread",85514],["thread",117297],["thread",47249],["thread",117656],["thread",25498],["thread",77161],["thread",94624],["thread",107468],["thread",133314],["thread",106118],["thread",51929],["thread",45291],["thread",26015],["thread",45151],["thread",69356],["thread",114855],["thread",105331],["thread",112915],["thread",94405],["thread",65345],["thread",38546],["thread",103659],["thread",60449],["thread",86624],["thread",87854],["thread",134640],["thread",81127],["thread",97476],["thread",51500],["thread",71242],["thread",48251],["thread",32841],["thread",54258],["thread",96434],["thread",101370],["thread",51468],["thread",103415],["thread",106575],["thread",123937],["thread",57094],["thread",105559],["thread",89075],["thread",70946],["thread",62684],["thread",125629],["thread",122124],["thread",60312],["thread",114125],["thread",12774],["thread",102387],["thread",74138],["thread",125201],["thread",52348],["thread",68583],["thread",106006],["thread",36188],["thread",113413],["thread",59423],["thread",112727],["thread",64505],["thread",64953],["thread",69675],["thread",85779],["thread",68151],["thread",103987],["thread",51723],["thread",73530],["thread",121847],["thread",45323],["thread",66106],["thread",111439],["thread",102592],["thread",64927],["thread",44856],["thread",53273]]
Run Time: 0.001748
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |