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 (134702, 68992, 130462, 137159, 135434, 92544, 133854, 132312, 135938, 135610, 84011, 68546, 60709, 133361, 117597, 131570, 134504, 124844, 123750, 137038, 136207, 134852, 128697, 135394, 132997, 133200, 135971, 90525, 136316, 135699, 132366, 137208, 121032, 127259, 61547, 134778, 135063, 133782, 130825, 135631, 132368, 135844, 122001, 124628, 128098, 128246, 65538, 133925, 136849, 65887, 128462, 71754, 130730, 137146, 136209, 133522, 71119, 134706, 132494, 60771, 128361, 79181, 137426, 131270, 133815, 132988, 93556, 130757, 125366, 134007, 112908, 128579, 43933, 136414, 67136, 117838, 133383, 134992, 135780, 58428, 111253, 47341, 136239, 52223, 128466, 128380, 135411, 125372, 129216, 85260, 96060, 46747, 99394, 135937, 115592, 129633, 136771, 136228, 90308, 134305, 75734, 137033, 133227, 135581, 123840, 131719, 133783, 98198, 135713, 121901, 132314, 133745, 130301, 131457, 132316, 137205, 84551, 119744, 136088, 134578, 110477, 134061, 126889, 130302, 134400, 132369, 133952, 90476, 112177, 131308, 84204, 136043, 136039, 65925, 79748, 133976, 135274, 67677, 69855, 135986, 135150, 69132, 137245, 97923, 130300, 131023, 134370, 137453, 101678, 129384, 133143, 89890, 109302, 134873, 134170, 135928, 91929, 120013, 136362, 80682, 133134, 103776, 131126, 135572, 137282, 131807, 75769, 75812, 133135, 135078, 129916, 136025, 129536, 23262, 135384, 134421, 134290, 129220, 135589, 133617, 80754, 130874, 44441, 134516, 130772, 137144, 137154, 136312, 134483, 128460, 132669, 136224, 135522, 90605, 133604, 126194, 75243, 134460, 137297, 131828, 133305, 69971, 129014, 109774, 121778, 123182, 96044, 121278, 136216, 131133, 137093, 134272, 136492, 129212, 126414, 133800, 133672, 129106, 96248, 47157, 132004, 130074, 133859, 130481, 134765, 135682, 73620, 54747, 92959, 95830, 131306, 57643, 136634, 66029, 136401, 137338, 133835, 135373, 129025, 127272, 115903, 129320, 133295, 135387, 135435, 133773, 133714, 134093, 71402, 118797, 133910, 134301, 137247, 135163, 134250, 131164, 76981, 95912, 121505, 122253, 132577, 77918, 130849, 68303, 133059, 137335, 134714, 136601, 137461, 125485, 133848, 133203, 128100, 137454, 98935, 68261, 135432, 102130, 135814, 133325, 135347, 119662, 111012, 125830, 133576, 134099, 136902, 121899, 135202, 130303, 135470, 129109, 133559, 71946, 133793, 125439, 96032, 136995, 133618, 134966)
Run Time: 0.273653
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: 4298, 0, 1715923238, 1715926838, [["thread",134702],["thread",68992],["thread",130462],["thread",137159],["thread",135434],["thread",92544],["thread",133854],["thread",132312],["thread",135938],["thread",135610],["thread",84011],["thread",68546],["thread",60709],["thread",133361],["thread",117597],["thread",131570],["thread",134504],["thread",124844],["thread",123750],["thread",137038],["thread",136207],["thread",134852],["thread",128697],["thread",135394],["thread",132997],["thread",133200],["thread",135971],["thread",90525],["thread",136316],["thread",135699],["thread",132366],["thread",137208],["thread",121032],["thread",127259],["thread",61547],["thread",134778],["thread",135063],["thread",133782],["thread",130825],["thread",135631],["thread",132368],["thread",135844],["thread",122001],["thread",124628],["thread",128098],["thread",128246],["thread",65538],["thread",133925],["thread",136849],["thread",65887],["thread",128462],["thread",71754],["thread",130730],["thread",137146],["thread",136209],["thread",133522],["thread",71119],["thread",134706],["thread",132494],["thread",60771],["thread",128361],["thread",79181],["thread",137426],["thread",131270],["thread",133815],["thread",132988],["thread",93556],["thread",130757],["thread",125366],["thread",134007],["thread",112908],["thread",128579],["thread",43933],["thread",136414],["thread",67136],["thread",117838],["thread",133383],["thread",134992],["thread",135780],["thread",58428],["thread",111253],["thread",47341],["thread",136239],["thread",52223],["thread",128466],["thread",128380],["thread",135411],["thread",125372],["thread",129216],["thread",85260],["thread",96060],["thread",46747],["thread",99394],["thread",135937],["thread",115592],["thread",129633],["thread",136771],["thread",136228],["thread",90308],["thread",134305],["thread",75734],["thread",137033],["thread",133227],["thread",135581],["thread",123840],["thread",131719],["thread",133783],["thread",98198],["thread",135713],["thread",121901],["thread",132314],["thread",133745],["thread",130301],["thread",131457],["thread",132316],["thread",137205],["thread",84551],["thread",119744],["thread",136088],["thread",134578],["thread",110477],["thread",134061],["thread",126889],["thread",130302],["thread",134400],["thread",132369],["thread",133952],["thread",90476],["thread",112177],["thread",131308],["thread",84204],["thread",136043],["thread",136039],["thread",65925],["thread",79748],["thread",133976],["thread",135274],["thread",67677],["thread",69855],["thread",135986],["thread",135150],["thread",69132],["thread",137245],["thread",97923],["thread",130300],["thread",131023],["thread",134370],["thread",137453],["thread",101678],["thread",129384],["thread",133143],["thread",89890],["thread",109302],["thread",134873],["thread",134170],["thread",135928],["thread",91929],["thread",120013],["thread",136362],["thread",80682],["thread",133134],["thread",103776],["thread",131126],["thread",135572],["thread",137282],["thread",131807],["thread",75769],["thread",75812],["thread",133135],["thread",135078],["thread",129916],["thread",136025],["thread",129536],["thread",23262],["thread",135384],["thread",134421],["thread",134290],["thread",129220],["thread",135589],["thread",133617],["thread",80754],["thread",130874],["thread",44441],["thread",134516],["thread",130772],["thread",137144],["thread",137154],["thread",136312],["thread",134483],["thread",128460],["thread",132669],["thread",136224],["thread",135522],["thread",90605],["thread",133604],["thread",126194],["thread",75243],["thread",134460],["thread",137297],["thread",131828],["thread",133305],["thread",69971],["thread",129014],["thread",109774],["thread",121778],["thread",123182],["thread",96044],["thread",121278],["thread",136216],["thread",131133],["thread",137093],["thread",134272],["thread",136492],["thread",129212],["thread",126414],["thread",133800],["thread",133672],["thread",129106],["thread",96248],["thread",47157],["thread",132004],["thread",130074],["thread",133859],["thread",130481],["thread",134765],["thread",135682],["thread",73620],["thread",54747],["thread",92959],["thread",95830],["thread",131306],["thread",57643],["thread",136634],["thread",66029],["thread",136401],["thread",137338],["thread",133835],["thread",135373],["thread",129025],["thread",127272],["thread",115903],["thread",129320],["thread",133295],["thread",135387],["thread",135435],["thread",133773],["thread",133714],["thread",134093],["thread",71402],["thread",118797],["thread",133910],["thread",134301],["thread",137247],["thread",135163],["thread",134250],["thread",131164],["thread",76981],["thread",95912],["thread",121505],["thread",122253],["thread",132577],["thread",77918],["thread",130849],["thread",68303],["thread",133059],["thread",137335],["thread",134714],["thread",136601],["thread",137461],["thread",125485],["thread",133848],["thread",133203],["thread",128100],["thread",137454],["thread",98935],["thread",68261],["thread",135432],["thread",102130],["thread",135814],["thread",133325],["thread",135347],["thread",119662],["thread",111012],["thread",125830],["thread",133576],["thread",134099],["thread",136902],["thread",121899],["thread",135202],["thread",130303],["thread",135470],["thread",129109],["thread",133559],["thread",71946],["thread",133793],["thread",125439],["thread",96032],["thread",136995],["thread",133618],["thread",134966]]
Run Time: 0.056811
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.047826
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |