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 (89165, 141095, 139229, 145074, 127291, 105399, 146906, 148745, 126831, 128807, 108490, 130842, 109249, 115751, 116099, 128209, 78726, 70360, 130281, 148762, 143548, 98737, 67709, 111222, 68363, 98655, 133647, 75475, 138065, 129170, 30305, 132177, 125954, 142504, 137182, 138747, 145695, 142369, 81247, 140739, 126590, 125357, 140282, 108154, 142438, 146158, 113999, 111637, 129549, 114624, 146616, 87699, 75552, 143106, 139767, 137067, 131015, 125849, 123132, 148145, 106252, 148780, 130850, 111254, 93861, 130742, 73325, 120964, 129831, 69558, 107760, 146646, 108283, 133288, 131682, 97878, 128466, 134938, 140520, 69939, 111020, 130790, 149087, 141389, 104559, 113526, 129629, 142763, 147320, 116553, 145659, 105426, 130461, 146246, 132026, 144523, 133383, 119906, 137996, 26891, 140288, 134886, 115261, 122707, 56819, 118997, 112714, 126193, 97529, 123546, 145144, 116415, 108438, 145895, 134058, 130519, 115606, 127290, 132332, 47730, 117101, 138316, 132082, 135962, 136206, 149151, 68973, 10206, 115620, 124041, 124576, 134650, 69222, 144815, 137545, 139041, 74644, 118135, 139857, 139981, 148971, 115683, 126295, 121647, 145639, 136184, 138740, 130427, 140490, 123528, 131052, 143258, 50864, 131551, 91187, 139179, 135236, 97594, 149293, 128399, 148579, 95740, 64415, 116395, 124134, 145332, 133125, 40427, 136328, 127085, 120344, 78283, 121498, 95915, 144586, 130962, 108158, 128738, 135183, 145440, 122635, 139395, 144878, 130139, 73614, 108909, 141570, 130173, 134968, 133559, 107712, 115491, 149128, 106468, 143918, 95375, 24443, 143457, 135207, 112219, 72580, 141680, 139380, 127289, 133820, 144448, 149048, 145564, 133458, 87596, 142031, 146610, 108602, 120010, 107977, 128080, 147818, 125564, 134759, 58432, 132287, 133540, 54359, 132472, 140055, 144917, 117854, 132596, 121535, 63998, 130823, 25722, 138982, 92391, 123673, 113963, 71376, 139778, 102420, 142790, 103536, 5319, 120602, 137101, 115709, 149178, 140705, 138535, 145149, 103478, 82051, 132978, 133951, 100129, 72044, 128510, 126977, 124450, 40599, 112982, 68728, 112461, 69750, 133618, 66491, 128391, 146965, 130527, 138681, 141272, 75686, 64470, 141898, 146244, 142653, 142389, 148639, 139590, 127456, 143966, 132870, 138420, 77568, 122569, 148023, 148298, 136150, 139392, 146752, 62755, 145714, 124437)
Run Time: 0.061437
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 292 | 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: 711, 0, 1751426293, 1751429893, [["resource",32],["resource",30],["resource",29],["resource",27],["resource",23],["resource",22],["resource",21],["resource",20],["thread",89165],["thread",141095],["thread",139229],["thread",145074],["thread",127291],["thread",105399],["thread",146906],["thread",148745],["thread",126831],["thread",128807],["thread",108490],["thread",130842],["thread",109249],["thread",115751],["thread",116099],["thread",128209],["thread",78726],["thread",70360],["thread",130281],["thread",148762],["thread",143548],["thread",98737],["thread",67709],["thread",111222],["thread",68363],["thread",98655],["thread",133647],["thread",75475],["thread",138065],["thread",129170],["thread",30305],["thread",132177],["thread",125954],["thread",142504],["thread",137182],["thread",138747],["thread",145695],["thread",142369],["thread",81247],["thread",140739],["thread",126590],["thread",125357],["thread",140282],["thread",108154],["thread",142438],["thread",146158],["thread",113999],["thread",111637],["thread",129549],["thread",114624],["thread",146616],["thread",87699],["thread",75552],["thread",143106],["thread",139767],["thread",137067],["thread",131015],["thread",125849],["thread",123132],["thread",148145],["thread",106252],["thread",148780],["thread",130850],["thread",111254],["thread",93861],["thread",130742],["thread",73325],["thread",120964],["thread",129831],["thread",69558],["thread",107760],["thread",146646],["thread",108283],["thread",133288],["thread",131682],["thread",97878],["thread",128466],["thread",134938],["thread",140520],["thread",69939],["thread",111020],["thread",130790],["thread",149087],["thread",141389],["thread",104559],["thread",113526],["thread",129629],["thread",142763],["thread",147320],["thread",116553],["thread",145659],["thread",105426],["thread",130461],["thread",146246],["thread",132026],["thread",144523],["thread",133383],["thread",119906],["thread",137996],["thread",26891],["thread",140288],["thread",134886],["thread",115261],["thread",122707],["thread",56819],["thread",118997],["thread",112714],["thread",126193],["thread",97529],["thread",123546],["thread",145144],["thread",116415],["thread",108438],["thread",145895],["thread",134058],["thread",130519],["thread",115606],["thread",127290],["thread",132332],["thread",47730],["thread",117101],["thread",138316],["thread",132082],["thread",135962],["thread",136206],["thread",149151],["thread",68973],["thread",10206],["thread",115620],["thread",124041],["thread",124576],["thread",134650],["thread",69222],["thread",144815],["thread",137545],["thread",139041],["thread",74644],["thread",118135],["thread",139857],["thread",139981],["thread",148971],["thread",115683],["thread",126295],["thread",121647],["thread",145639],["thread",136184],["thread",138740],["thread",130427],["thread",140490],["thread",123528],["thread",131052],["thread",143258],["thread",50864],["thread",131551],["thread",91187],["thread",139179],["thread",135236],["thread",97594],["thread",149293],["thread",128399],["thread",148579],["thread",95740],["thread",64415],["thread",116395],["thread",124134],["thread",145332],["thread",133125],["thread",40427],["thread",136328],["thread",127085],["thread",120344],["thread",78283],["thread",121498],["thread",95915],["thread",144586],["thread",130962],["thread",108158],["thread",128738],["thread",135183],["thread",145440],["thread",122635],["thread",139395],["thread",144878],["thread",130139],["thread",73614],["thread",108909],["thread",141570],["thread",130173],["thread",134968],["thread",133559],["thread",107712],["thread",115491],["thread",149128],["thread",106468],["thread",143918],["thread",95375],["thread",24443],["thread",143457],["thread",135207],["thread",112219],["thread",72580],["thread",141680],["thread",139380],["thread",127289],["thread",133820],["thread",144448],["thread",149048],["thread",145564],["thread",133458],["thread",87596],["thread",142031],["thread",146610],["thread",108602],["thread",120010],["thread",107977],["thread",128080],["thread",147818],["thread",125564],["thread",134759],["thread",58432],["thread",132287],["thread",133540],["thread",54359],["thread",132472],["thread",140055],["thread",144917],["thread",117854],["thread",132596],["thread",121535],["thread",63998],["thread",130823],["thread",25722],["thread",138982],["thread",92391],["thread",123673],["thread",113963],["thread",71376],["thread",139778],["thread",102420],["thread",142790],["thread",103536],["thread",5319],["thread",120602],["thread",137101],["thread",115709],["thread",149178],["thread",140705],["thread",138535],["thread",145149],["thread",103478],["thread",82051],["thread",132978],["thread",133951],["thread",100129],["thread",72044],["thread",128510],["thread",126977],["thread",124450],["thread",40599],["thread",112982],["thread",68728],["thread",112461],["thread",69750],["thread",133618],["thread",66491],["thread",128391],["thread",146965],["thread",130527],["thread",138681],["thread",141272],["thread",75686],["thread",64470],["thread",141898],["thread",146244],["thread",142653],["thread",142389],["thread",148639],["thread",139590],["thread",127456],["thread",143966],["thread",132870],["thread",138420],["thread",77568],["thread",122569],["thread",148023],["thread",148298],["thread",136150],["thread",139392],["thread",146752],["thread",62755],["thread",145714],["thread",124437]]
Run Time: 0.212667
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: 1
Run Time: 0.000143
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |