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 (131939, 134548, 129937, 47150, 123853, 129716, 133382, 120438, 130757, 103946, 131330, 133453, 134761, 130617, 134999, 130229, 136960, 121754, 64823, 132406, 81832, 132072, 44889, 110957, 132206, 73233, 110893, 128098, 131093, 131646, 128581, 104014, 129880, 70459, 129984, 130850, 126654, 133814, 133923, 130364, 110960, 136481, 135217, 128733, 2265, 136473, 136911, 131902, 134008, 115077, 105820, 2276, 47363, 126548, 64885, 46196, 135330, 128100, 106588, 133380, 132055, 49657, 130345, 136952, 133062, 132634, 133581, 130747, 135469, 135512, 78306, 69422, 47156, 123883, 134342, 132006, 91227, 115236, 131041, 131493, 134880, 132410, 129524, 127050, 47221, 135516, 130154, 130495, 127981, 131454, 137354, 38909, 64821, 123699, 128271, 129305, 132446, 132189, 71310, 132260, 130473, 85740, 133466, 105152, 131853, 132666, 129771, 80869, 130715, 123675, 105592, 131072, 65363, 110314, 135554, 130447, 131328, 130129, 104207, 119722, 130633, 136871, 64276, 130267, 131735, 110990, 123430, 100057, 131426, 134741, 85379, 132883, 69079, 136985, 135216, 131935, 127743, 132930, 90046, 126692, 136937, 137360, 128697, 131551, 134790, 44968, 135732, 131312, 133639, 132724, 131872, 130018, 126546, 128080, 131965, 123431, 135988, 133904, 131094, 46744, 128859, 133388, 134927, 134785, 64820, 137041, 131265, 2279, 130769, 131451, 134813, 113778, 122620, 129293, 133775, 128424, 130462, 133583, 128726, 132383, 67902, 132581, 129455, 130899, 119614, 136178, 128963, 135121, 134800, 122094, 76920, 133870, 137419, 131946, 76315, 131658, 135774, 131126, 117040, 131788, 128922, 47241, 131195, 63459, 129202, 131327, 133838, 62386, 64922, 130108, 128227, 135913, 132427, 135064, 135585, 130009, 131851, 119677, 135513, 131717, 136825, 63126, 137382, 116288, 2275, 130929, 131199, 118155, 128138, 131985, 134750, 133658, 136926, 135147, 133855, 133264, 62738, 135552, 131104, 136804, 132821, 131723, 130150, 133282, 132459, 118392, 132613, 124488, 133293, 129519, 135284, 71303, 129296, 131932, 61229, 135312, 134849, 127847, 133280, 133323, 61441, 129842, 115261, 130649, 135882, 128364, 86843, 123599, 125221, 90758, 128230, 131188, 135069, 133872, 136032, 131945, 134622, 128204, 131429, 128375, 46746, 131684, 128935, 129150, 135855, 131132, 130500, 130351, 127225, 134820, 129020, 2278, 129038, 129846, 135742, 130275, 133756, 130217, 127986, 128673)
Run Time: 0.150111
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: 40, 0, 1715911315, 1715914915, [["thread",131939],["thread",134548],["thread",129937],["thread",47150],["thread",123853],["thread",129716],["thread",133382],["thread",120438],["thread",130757],["thread",103946],["thread",131330],["thread",133453],["thread",134761],["thread",130617],["thread",134999],["thread",130229],["thread",136960],["thread",121754],["thread",64823],["thread",132406],["thread",81832],["thread",132072],["thread",44889],["thread",110957],["thread",132206],["thread",73233],["thread",110893],["thread",128098],["thread",131093],["thread",131646],["thread",128581],["thread",104014],["thread",129880],["thread",70459],["thread",129984],["thread",130850],["thread",126654],["thread",133814],["thread",133923],["thread",130364],["thread",110960],["thread",136481],["thread",135217],["thread",128733],["thread",2265],["thread",136473],["thread",136911],["thread",131902],["thread",134008],["thread",115077],["thread",105820],["thread",2276],["thread",47363],["thread",126548],["thread",64885],["thread",46196],["thread",135330],["thread",128100],["thread",106588],["thread",133380],["thread",132055],["thread",49657],["thread",130345],["thread",136952],["thread",133062],["thread",132634],["thread",133581],["thread",130747],["thread",135469],["thread",135512],["thread",78306],["thread",69422],["thread",47156],["thread",123883],["thread",134342],["thread",132006],["thread",91227],["thread",115236],["thread",131041],["thread",131493],["thread",134880],["thread",132410],["thread",129524],["thread",127050],["thread",47221],["thread",135516],["thread",130154],["thread",130495],["thread",127981],["thread",131454],["thread",137354],["thread",38909],["thread",64821],["thread",123699],["thread",128271],["thread",129305],["thread",132446],["thread",132189],["thread",71310],["thread",132260],["thread",130473],["thread",85740],["thread",133466],["thread",105152],["thread",131853],["thread",132666],["thread",129771],["thread",80869],["thread",130715],["thread",123675],["thread",105592],["thread",131072],["thread",65363],["thread",110314],["thread",135554],["thread",130447],["thread",131328],["thread",130129],["thread",104207],["thread",119722],["thread",130633],["thread",136871],["thread",64276],["thread",130267],["thread",131735],["thread",110990],["thread",123430],["thread",100057],["thread",131426],["thread",134741],["thread",85379],["thread",132883],["thread",69079],["thread",136985],["thread",135216],["thread",131935],["thread",127743],["thread",132930],["thread",90046],["thread",126692],["thread",136937],["thread",137360],["thread",128697],["thread",131551],["thread",134790],["thread",44968],["thread",135732],["thread",131312],["thread",133639],["thread",132724],["thread",131872],["thread",130018],["thread",126546],["thread",128080],["thread",131965],["thread",123431],["thread",135988],["thread",133904],["thread",131094],["thread",46744],["thread",128859],["thread",133388],["thread",134927],["thread",134785],["thread",64820],["thread",137041],["thread",131265],["thread",2279],["thread",130769],["thread",131451],["thread",134813],["thread",113778],["thread",122620],["thread",129293],["thread",133775],["thread",128424],["thread",130462],["thread",133583],["thread",128726],["thread",132383],["thread",67902],["thread",132581],["thread",129455],["thread",130899],["thread",119614],["thread",136178],["thread",128963],["thread",135121],["thread",134800],["thread",122094],["thread",76920],["thread",133870],["thread",137419],["thread",131946],["thread",76315],["thread",131658],["thread",135774],["thread",131126],["thread",117040],["thread",131788],["thread",128922],["thread",47241],["thread",131195],["thread",63459],["thread",129202],["thread",131327],["thread",133838],["thread",62386],["thread",64922],["thread",130108],["thread",128227],["thread",135913],["thread",132427],["thread",135064],["thread",135585],["thread",130009],["thread",131851],["thread",119677],["thread",135513],["thread",131717],["thread",136825],["thread",63126],["thread",137382],["thread",116288],["thread",2275],["thread",130929],["thread",131199],["thread",118155],["thread",128138],["thread",131985],["thread",134750],["thread",133658],["thread",136926],["thread",135147],["thread",133855],["thread",133264],["thread",62738],["thread",135552],["thread",131104],["thread",136804],["thread",132821],["thread",131723],["thread",130150],["thread",133282],["thread",132459],["thread",118392],["thread",132613],["thread",124488],["thread",133293],["thread",129519],["thread",135284],["thread",71303],["thread",129296],["thread",131932],["thread",61229],["thread",135312],["thread",134849],["thread",127847],["thread",133280],["thread",133323],["thread",61441],["thread",129842],["thread",115261],["thread",130649],["thread",135882],["thread",128364],["thread",86843],["thread",123599],["thread",125221],["thread",90758],["thread",128230],["thread",131188],["thread",135069],["thread",133872],["thread",136032],["thread",131945],["thread",134622],["thread",128204],["thread",131429],["thread",128375],["thread",46746],["thread",131684],["thread",128935],["thread",129150],["thread",135855],["thread",131132],["thread",130500],["thread",130351],["thread",127225],["thread",134820],["thread",129020],["thread",2278],["thread",129038],["thread",129846],["thread",135742],["thread",130275],["thread",133756],["thread",130217],["thread",127986],["thread",128673]]
Run Time: 0.007021
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |