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 (89867, 92180, 102175, 72095, 103040, 93132, 89211, 92286, 101095, 71919, 103859, 129931, 82435, 100148, 70604, 68591, 106382, 124875, 73020, 110500, 100402, 103374, 105558, 67559, 100770, 92170, 95540, 115398, 92215, 116064, 105044, 107612, 108581, 91308, 99581, 67457, 96690, 88795, 81940, 92258, 103402, 82668, 93576, 69479, 109102, 91301, 106226, 73080, 91403, 67786, 88414, 106166, 108064, 106331, 110594, 67309, 108267, 109183, 107568, 84178, 86229, 100881, 42088, 49072, 131958, 103470, 107289, 109251, 107212, 67783, 70884, 120143, 104394, 119391, 107882, 91915, 95457, 88810, 96608, 92256, 91013, 53818, 111614, 106010, 82252, 67450, 68027, 100630, 91493, 95293, 97446, 107136, 97172, 101630, 106275, 71958, 88283, 72801, 90049, 88051, 98025, 87207, 106928, 97444, 70302, 107323, 87814, 92203, 108210, 96533, 95215, 131182, 93498, 70335, 95330, 102316, 108592, 88368, 97505, 110571, 94326, 94823, 106434, 93127, 92592, 105818, 103150, 100829, 98831, 100497, 107071, 107313, 103352, 87726, 118233, 49244, 87871, 107723, 81937, 72288, 93143, 98039, 109253, 80346, 111036, 92020, 74063, 105781, 64913, 71461, 111573, 104910, 91433, 109190, 94312, 115306, 73726, 91231, 77526, 94762, 100315, 96460, 90373, 95731, 130164, 93246, 102410, 94815, 24872, 72371, 110659, 93292, 50847, 115899, 107757, 107338, 108117, 88512, 67590, 111005, 88357, 95280, 102789, 61946, 100953, 89074, 103796, 123376, 105612, 108333, 84116, 68486, 105896, 89475, 112402, 67102, 107319, 104045, 101099, 72483, 67414, 70610, 85667, 108123, 107981, 120125, 72009, 86305, 81536, 102993, 49905, 73325, 91615, 88606, 105868, 92174, 68875, 83613, 89551, 75203, 52014, 107806, 92010, 103399, 102304, 108296, 105361, 97383, 74360, 66861, 96326, 121728, 66393, 109434, 67557, 108988, 88982, 85621, 104281, 59602, 70850, 84368, 99110, 129934, 72721, 102596, 68028, 101101, 72737, 90142, 88817, 63861, 109490, 108190, 96902, 114615, 107658)
Run Time: 0.012688
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: 5615, 0, 1714049554, 1714053154, [["thread",89867],["thread",92180],["thread",102175],["thread",72095],["thread",103040],["thread",93132],["thread",89211],["thread",92286],["thread",101095],["thread",71919],["thread",103859],["thread",129931],["thread",82435],["thread",100148],["thread",70604],["thread",68591],["thread",106382],["thread",124875],["thread",73020],["thread",110500],["thread",100402],["thread",103374],["thread",105558],["thread",67559],["thread",100770],["thread",92170],["thread",95540],["thread",115398],["thread",92215],["thread",116064],["thread",105044],["thread",107612],["thread",108581],["thread",91308],["thread",99581],["thread",67457],["thread",96690],["thread",88795],["thread",81940],["thread",92258],["thread",103402],["thread",82668],["thread",93576],["thread",69479],["thread",109102],["thread",91301],["thread",106226],["thread",73080],["thread",91403],["thread",67786],["thread",88414],["thread",106166],["thread",108064],["thread",106331],["thread",110594],["thread",67309],["thread",108267],["thread",109183],["thread",107568],["thread",84178],["thread",86229],["thread",100881],["thread",42088],["thread",49072],["thread",131958],["thread",103470],["thread",107289],["thread",109251],["thread",107212],["thread",67783],["thread",70884],["thread",120143],["thread",104394],["thread",119391],["thread",107882],["thread",91915],["thread",95457],["thread",88810],["thread",96608],["thread",92256],["thread",91013],["thread",53818],["thread",111614],["thread",106010],["thread",82252],["thread",67450],["thread",68027],["thread",100630],["thread",91493],["thread",95293],["thread",97446],["thread",107136],["thread",97172],["thread",101630],["thread",106275],["thread",71958],["thread",88283],["thread",72801],["thread",90049],["thread",88051],["thread",98025],["thread",87207],["thread",106928],["thread",97444],["thread",70302],["thread",107323],["thread",87814],["thread",92203],["thread",108210],["thread",96533],["thread",95215],["thread",131182],["thread",93498],["thread",70335],["thread",95330],["thread",102316],["thread",108592],["thread",88368],["thread",97505],["thread",110571],["thread",94326],["thread",94823],["thread",106434],["thread",93127],["thread",92592],["thread",105818],["thread",103150],["thread",100829],["thread",98831],["thread",100497],["thread",107071],["thread",107313],["thread",103352],["thread",87726],["thread",118233],["thread",49244],["thread",87871],["thread",107723],["thread",81937],["thread",72288],["thread",93143],["thread",98039],["thread",109253],["thread",80346],["thread",111036],["thread",92020],["thread",74063],["thread",105781],["thread",64913],["thread",71461],["thread",111573],["thread",104910],["thread",91433],["thread",109190],["thread",94312],["thread",115306],["thread",73726],["thread",91231],["thread",77526],["thread",94762],["thread",100315],["thread",96460],["thread",90373],["thread",95731],["thread",130164],["thread",93246],["thread",102410],["thread",94815],["thread",24872],["thread",72371],["thread",110659],["thread",93292],["thread",50847],["thread",115899],["thread",107757],["thread",107338],["thread",108117],["thread",88512],["thread",67590],["thread",111005],["thread",88357],["thread",95280],["thread",102789],["thread",61946],["thread",100953],["thread",89074],["thread",103796],["thread",123376],["thread",105612],["thread",108333],["thread",84116],["thread",68486],["thread",105896],["thread",89475],["thread",112402],["thread",67102],["thread",107319],["thread",104045],["thread",101099],["thread",72483],["thread",67414],["thread",70610],["thread",85667],["thread",108123],["thread",107981],["thread",120125],["thread",72009],["thread",86305],["thread",81536],["thread",102993],["thread",49905],["thread",73325],["thread",91615],["thread",88606],["thread",105868],["thread",92174],["thread",68875],["thread",83613],["thread",89551],["thread",75203],["thread",52014],["thread",107806],["thread",92010],["thread",103399],["thread",102304],["thread",108296],["thread",105361],["thread",97383],["thread",74360],["thread",66861],["thread",96326],["thread",121728],["thread",66393],["thread",109434],["thread",67557],["thread",108988],["thread",88982],["thread",85621],["thread",104281],["thread",59602],["thread",70850],["thread",84368],["thread",99110],["thread",129934],["thread",72721],["thread",102596],["thread",68028],["thread",101101],["thread",72737],["thread",90142],["thread",88817],["thread",63861],["thread",109490],["thread",108190],["thread",96902],["thread",114615],["thread",107658]]
Run Time: 0.002829
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |