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 (103534, 114381, 130354, 119448, 135062, 136930, 130842, 132862, 128274, 129781, 129326, 133692, 129054, 136208, 116288, 124388, 129268, 128576, 135935, 115592, 133578, 122482, 123856, 126868, 129302, 122707, 127158, 130119, 110477, 134960, 131265, 133581, 126381, 130057, 128582, 137201, 128790, 125372, 131536, 133731, 131070, 129278, 134574, 130217, 127578, 137280, 133943, 132281, 128697, 133550, 135121, 127225, 127938, 114788, 128617, 127511, 131262, 80062, 131267, 135063, 129282, 129019, 111074, 134007, 112592, 132288, 135960, 125600, 134757, 134842, 118865, 133377, 129455, 113028, 110446, 111525, 136068, 114158, 133203, 127947, 132116, 136237, 137067, 104081, 134799, 133279, 113930, 120934, 136490, 129271, 131451, 134488, 129288, 135989, 82173, 130408, 131072, 128243, 134198, 129276, 135448, 131829, 135998, 135982, 134299, 135874, 131637, 87328, 133264, 83832, 132573, 124480, 126548, 130650, 121778, 134865, 136316, 134200, 129623, 136825, 131097, 134425, 123673, 137460, 136090, 137389, 123492, 126546, 135934, 124052, 137071, 134170, 135591, 136565, 98831, 132467, 131728, 137461, 135800, 136929, 133916, 135824, 110228, 88615, 133539, 135324, 115077, 125799, 94274, 78419, 97666, 134386, 115026, 123816, 134638, 130900, 135327, 134216, 123757, 135848, 137454, 132393, 122369, 91276, 130714, 133688, 111635, 135209, 129273, 131996, 113276, 135080, 133766, 130039, 83124, 78256, 136594, 85625, 118704, 135515, 129886, 132084, 111730, 136393, 125549, 111061, 123555, 128547, 124418, 134134, 117145, 135485, 130188, 121782, 132298, 136952, 133860, 133498, 132494, 126492, 129842, 111948, 135486, 112584, 132335, 126550, 135210, 118799, 136494, 135346, 130750, 136796, 134383, 134802, 127929, 97299, 123680, 133277, 136953, 134332, 130322, 78280, 130433, 125211, 137121, 130820, 114076, 134097, 136627, 123145, 134093, 114120, 130028, 133228, 128375, 128522, 133362, 119647, 129521, 135182, 95892, 129980, 80754, 114240, 134822, 133739, 90822, 128240, 124551, 111487, 130949, 125072, 136932, 130473, 133985, 131311, 137208, 115118, 115530, 129715, 130795, 109506, 134132, 106883, 137289, 130111, 119546, 129335, 135064, 135614, 132035, 79903, 134823, 129887, 98734, 129006, 121541, 134430, 131079, 137360, 135984, 133980, 122873, 130828, 133040, 88750, 110231, 135993, 127866, 136973, 129017, 133634, 129633, 128929, 135846, 60343, 133476, 134237, 77564, 130700)
Run Time: 0.078059
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: 29790, 0, 1715923382, 1715926982, [["thread",103534],["thread",114381],["thread",130354],["thread",119448],["thread",135062],["thread",136930],["thread",130842],["thread",132862],["thread",128274],["thread",129781],["thread",129326],["thread",133692],["thread",129054],["thread",136208],["thread",116288],["thread",124388],["thread",129268],["thread",128576],["thread",135935],["thread",115592],["thread",133578],["thread",122482],["thread",123856],["thread",126868],["thread",129302],["thread",122707],["thread",127158],["thread",130119],["thread",110477],["thread",134960],["thread",131265],["thread",133581],["thread",126381],["thread",130057],["thread",128582],["thread",137201],["thread",128790],["thread",125372],["thread",131536],["thread",133731],["thread",131070],["thread",129278],["thread",134574],["thread",130217],["thread",127578],["thread",137280],["thread",133943],["thread",132281],["thread",128697],["thread",133550],["thread",135121],["thread",127225],["thread",127938],["thread",114788],["thread",128617],["thread",127511],["thread",131262],["thread",80062],["thread",131267],["thread",135063],["thread",129282],["thread",129019],["thread",111074],["thread",134007],["thread",112592],["thread",132288],["thread",135960],["thread",125600],["thread",134757],["thread",134842],["thread",118865],["thread",133377],["thread",129455],["thread",113028],["thread",110446],["thread",111525],["thread",136068],["thread",114158],["thread",133203],["thread",127947],["thread",132116],["thread",136237],["thread",137067],["thread",104081],["thread",134799],["thread",133279],["thread",113930],["thread",120934],["thread",136490],["thread",129271],["thread",131451],["thread",134488],["thread",129288],["thread",135989],["thread",82173],["thread",130408],["thread",131072],["thread",128243],["thread",134198],["thread",129276],["thread",135448],["thread",131829],["thread",135998],["thread",135982],["thread",134299],["thread",135874],["thread",131637],["thread",87328],["thread",133264],["thread",83832],["thread",132573],["thread",124480],["thread",126548],["thread",130650],["thread",121778],["thread",134865],["thread",136316],["thread",134200],["thread",129623],["thread",136825],["thread",131097],["thread",134425],["thread",123673],["thread",137460],["thread",136090],["thread",137389],["thread",123492],["thread",126546],["thread",135934],["thread",124052],["thread",137071],["thread",134170],["thread",135591],["thread",136565],["thread",98831],["thread",132467],["thread",131728],["thread",137461],["thread",135800],["thread",136929],["thread",133916],["thread",135824],["thread",110228],["thread",88615],["thread",133539],["thread",135324],["thread",115077],["thread",125799],["thread",94274],["thread",78419],["thread",97666],["thread",134386],["thread",115026],["thread",123816],["thread",134638],["thread",130900],["thread",135327],["thread",134216],["thread",123757],["thread",135848],["thread",137454],["thread",132393],["thread",122369],["thread",91276],["thread",130714],["thread",133688],["thread",111635],["thread",135209],["thread",129273],["thread",131996],["thread",113276],["thread",135080],["thread",133766],["thread",130039],["thread",83124],["thread",78256],["thread",136594],["thread",85625],["thread",118704],["thread",135515],["thread",129886],["thread",132084],["thread",111730],["thread",136393],["thread",125549],["thread",111061],["thread",123555],["thread",128547],["thread",124418],["thread",134134],["thread",117145],["thread",135485],["thread",130188],["thread",121782],["thread",132298],["thread",136952],["thread",133860],["thread",133498],["thread",132494],["thread",126492],["thread",129842],["thread",111948],["thread",135486],["thread",112584],["thread",132335],["thread",126550],["thread",135210],["thread",118799],["thread",136494],["thread",135346],["thread",130750],["thread",136796],["thread",134383],["thread",134802],["thread",127929],["thread",97299],["thread",123680],["thread",133277],["thread",136953],["thread",134332],["thread",130322],["thread",78280],["thread",130433],["thread",125211],["thread",137121],["thread",130820],["thread",114076],["thread",134097],["thread",136627],["thread",123145],["thread",134093],["thread",114120],["thread",130028],["thread",133228],["thread",128375],["thread",128522],["thread",133362],["thread",119647],["thread",129521],["thread",135182],["thread",95892],["thread",129980],["thread",80754],["thread",114240],["thread",134822],["thread",133739],["thread",90822],["thread",128240],["thread",124551],["thread",111487],["thread",130949],["thread",125072],["thread",136932],["thread",130473],["thread",133985],["thread",131311],["thread",137208],["thread",115118],["thread",115530],["thread",129715],["thread",130795],["thread",109506],["thread",134132],["thread",106883],["thread",137289],["thread",130111],["thread",119546],["thread",129335],["thread",135064],["thread",135614],["thread",132035],["thread",79903],["thread",134823],["thread",129887],["thread",98734],["thread",129006],["thread",121541],["thread",134430],["thread",131079],["thread",137360],["thread",135984],["thread",133980],["thread",122873],["thread",130828],["thread",133040],["thread",88750],["thread",110231],["thread",135993],["thread",127866],["thread",136973],["thread",129017],["thread",133634],["thread",129633],["thread",128929],["thread",135846],["thread",60343],["thread",133476],["thread",134237],["thread",77564],["thread",130700]]
Run Time: 0.184041
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.001035
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |