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 (63613, 130447, 118729, 9205, 129583, 78613, 74286, 129928, 61693, 114662, 137211, 136489, 130486, 128879, 62110, 79322, 128098, 131781, 130968, 131703, 128957, 47278, 106832, 135749, 107624, 132580, 134132, 87442, 135985, 111163, 130408, 135591, 120540, 130653, 64824, 133133, 69808, 123401, 136183, 128873, 131572, 136336, 131096, 107657, 131682, 88029, 131945, 127452, 129676, 136181, 64467, 131178, 128620, 128859, 79504, 131267, 130296, 92075, 125221, 137041, 70582, 130381, 129034, 37565, 120233, 64192, 132407, 62766, 114277, 130293, 136994, 131626, 130899, 128673, 115236, 129669, 128670, 129455, 47359, 23566, 127355, 135210, 131946, 47274, 136817, 128369, 131185, 123740, 98759, 53652, 130485, 94387, 131069, 132615, 132072, 83595, 110957, 130975, 120982, 121494, 135936, 137092, 133206, 111388, 131571, 130295, 1622, 132289, 62544, 81959, 135069, 90423, 129642, 57825, 132024, 65361, 68249, 131312, 134811, 122397, 135553, 113276, 67952, 125341, 130150, 115077, 121083, 136018, 120885, 128405, 131853, 128333, 128697, 133124, 136956, 136121, 119677, 121445, 129722, 131468, 131648, 130091, 131640, 136787, 129764, 107801, 127696, 136768, 130633, 133910, 131455, 96981, 134332, 131481, 71069, 102648, 128423, 121273, 134788, 132581, 131915, 94720, 84350, 94725, 116988, 122259, 129139, 130650, 131567, 136050, 46745, 110960, 128325, 129030, 134965, 62457, 128380, 70175, 94189, 132543, 130969, 125502, 133192, 121350, 63461, 134900, 96320, 70949, 63144, 88771, 68580, 137053, 133603, 127402, 129296, 47276, 128033, 120438, 69987, 127246, 130604, 133702, 131346, 127916, 134608, 127575, 89865, 123416, 130077, 129236, 130730, 136091, 130267, 135554, 131199, 83052, 64048, 68759, 94568, 134813, 45790, 131162, 129700, 134784, 131559, 114404, 121492, 128628, 133282, 133597, 127266, 114488, 85721, 136342, 96366, 131104, 131012, 135330, 136192, 134083, 70259, 95681, 131720, 79971, 109396, 64468, 128379, 132459, 68320, 63126, 120676, 100600, 133840, 132427, 137127, 131360, 134850, 135852, 111511, 122620, 132260, 131723, 104028, 67795, 118476, 63727, 130472, 131932, 129020, 132794, 61594, 101392, 126819, 96492, 132410, 131068, 116537, 131856, 130009, 130457, 131752, 130780, 126846, 129180, 61441, 132659, 123680, 136491, 94924, 135984, 129305, 124220, 134750, 58277, 136125, 131965, 38092, 136825, 130881, 133872)
Run Time: 0.323947
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 300 | 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: 850, 0, 1715300195, 1715303795, [["thread",63613],["thread",130447],["thread",118729],["thread",9205],["thread",129583],["thread",78613],["thread",74286],["thread",129928],["thread",61693],["thread",114662],["thread",137211],["thread",136489],["thread",130486],["thread",128879],["thread",62110],["thread",79322],["thread",128098],["thread",131781],["thread",130968],["thread",131703],["thread",128957],["thread",47278],["thread",106832],["thread",135749],["thread",107624],["thread",132580],["thread",134132],["thread",87442],["thread",135985],["thread",111163],["thread",130408],["thread",135591],["thread",120540],["thread",130653],["thread",64824],["thread",133133],["thread",69808],["thread",123401],["thread",136183],["thread",128873],["thread",131572],["thread",136336],["thread",131096],["thread",107657],["thread",131682],["thread",88029],["thread",131945],["thread",127452],["thread",129676],["thread",136181],["thread",64467],["thread",131178],["thread",128620],["thread",128859],["thread",79504],["thread",131267],["thread",130296],["thread",92075],["thread",125221],["thread",137041],["thread",70582],["thread",130381],["thread",129034],["thread",37565],["thread",120233],["thread",64192],["thread",132407],["thread",62766],["thread",114277],["thread",130293],["thread",136994],["thread",131626],["thread",130899],["thread",128673],["thread",115236],["thread",129669],["thread",128670],["thread",129455],["thread",47359],["thread",23566],["thread",127355],["thread",135210],["thread",131946],["thread",47274],["thread",136817],["thread",128369],["thread",131185],["thread",123740],["thread",98759],["thread",53652],["thread",130485],["thread",94387],["thread",131069],["thread",132615],["thread",132072],["thread",83595],["thread",110957],["thread",130975],["thread",120982],["thread",121494],["thread",135936],["thread",137092],["thread",133206],["thread",111388],["thread",131571],["thread",130295],["thread",1622],["thread",132289],["thread",62544],["thread",81959],["thread",135069],["thread",90423],["thread",129642],["thread",57825],["thread",132024],["thread",65361],["thread",68249],["thread",131312],["thread",134811],["thread",122397],["thread",135553],["thread",113276],["thread",67952],["thread",125341],["thread",130150],["thread",115077],["thread",121083],["thread",136018],["thread",120885],["thread",128405],["thread",131853],["thread",128333],["thread",128697],["thread",133124],["thread",136956],["thread",136121],["thread",119677],["thread",121445],["thread",129722],["thread",131468],["thread",131648],["thread",130091],["thread",131640],["thread",136787],["thread",129764],["thread",107801],["thread",127696],["thread",136768],["thread",130633],["thread",133910],["thread",131455],["thread",96981],["thread",134332],["thread",131481],["thread",71069],["thread",102648],["thread",128423],["thread",121273],["thread",134788],["thread",132581],["thread",131915],["thread",94720],["thread",84350],["thread",94725],["thread",116988],["thread",122259],["thread",129139],["thread",130650],["thread",131567],["thread",136050],["thread",46745],["thread",110960],["thread",128325],["thread",129030],["thread",134965],["thread",62457],["thread",128380],["thread",70175],["thread",94189],["thread",132543],["thread",130969],["thread",125502],["thread",133192],["thread",121350],["thread",63461],["thread",134900],["thread",96320],["thread",70949],["thread",63144],["thread",88771],["thread",68580],["thread",137053],["thread",133603],["thread",127402],["thread",129296],["thread",47276],["thread",128033],["thread",120438],["thread",69987],["thread",127246],["thread",130604],["thread",133702],["thread",131346],["thread",127916],["thread",134608],["thread",127575],["thread",89865],["thread",123416],["thread",130077],["thread",129236],["thread",130730],["thread",136091],["thread",130267],["thread",135554],["thread",131199],["thread",83052],["thread",64048],["thread",68759],["thread",94568],["thread",134813],["thread",45790],["thread",131162],["thread",129700],["thread",134784],["thread",131559],["thread",114404],["thread",121492],["thread",128628],["thread",133282],["thread",133597],["thread",127266],["thread",114488],["thread",85721],["thread",136342],["thread",96366],["thread",131104],["thread",131012],["thread",135330],["thread",136192],["thread",134083],["thread",70259],["thread",95681],["thread",131720],["thread",79971],["thread",109396],["thread",64468],["thread",128379],["thread",132459],["thread",68320],["thread",63126],["thread",120676],["thread",100600],["thread",133840],["thread",132427],["thread",137127],["thread",131360],["thread",134850],["thread",135852],["thread",111511],["thread",122620],["thread",132260],["thread",131723],["thread",104028],["thread",67795],["thread",118476],["thread",63727],["thread",130472],["thread",131932],["thread",129020],["thread",132794],["thread",61594],["thread",101392],["thread",126819],["thread",96492],["thread",132410],["thread",131068],["thread",116537],["thread",131856],["thread",130009],["thread",130457],["thread",131752],["thread",130780],["thread",126846],["thread",129180],["thread",61441],["thread",132659],["thread",123680],["thread",136491],["thread",94924],["thread",135984],["thread",129305],["thread",124220],["thread",134750],["thread",58277],["thread",136125],["thread",131965],["thread",38092],["thread",136825],["thread",130881],["thread",133872]]
Run Time: 0.007628
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.000079
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |