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 (63236, 113256, 83554, 132418, 115440, 97923, 113958, 39823, 68153, 86982, 71653, 100530, 136225, 133136, 72958, 75337, 123282, 112650, 112275, 133981, 118832, 97629, 115646, 110023, 120495, 113914, 117362, 71752, 55280, 113834, 100806, 118912, 71750, 97307, 127229, 58430, 76028, 115594, 90320, 124935, 83974, 115491, 97628, 73117, 127215, 65869, 132527, 93556, 112253, 113316, 128800, 127025, 77918, 122275, 132955, 108229, 107634, 73300, 129351, 96528, 129378, 97386, 104803, 72946, 132884, 104885, 128716, 111727, 115387, 113527, 79849, 127231, 132093, 129180, 135858, 90200, 118829, 115079, 133894, 58429, 76442, 99802, 120949, 126356, 111917, 94316, 89889, 122506, 74980, 108455, 96104, 129602, 97653, 108036, 132624, 68807, 110385, 134984, 129592, 126357, 124496, 81109, 74865, 108188, 97675, 81299, 57396, 66005, 109001, 44353, 96001, 57391, 23128, 113651, 118540, 96354, 58428, 132461, 103215, 115434, 69255, 116939, 131584, 89890, 70407, 67136, 113610, 105877, 133529, 100416, 75092, 114410, 129590, 131659, 131111, 98097, 66937, 104886, 129624, 109791, 74809, 124092, 110076, 69886, 86943, 90613, 111441, 96595, 70852, 124368, 123141, 44345, 114091, 108075, 112758, 126515, 71021, 129604, 90182, 79907, 80345, 131657, 132284, 108302, 68546, 102033, 44348, 68427, 98847, 96732, 131802, 132448, 133132, 132104, 119731, 128379, 92548, 121920, 70660, 71751, 133212, 42119, 133113, 114742, 112965, 93401, 66936, 76836, 132003, 131713, 122773, 80726, 131593, 110609, 68552, 76188, 79793, 135869, 121921, 127149, 113764, 132618, 57643, 97464, 60843, 44347, 26513, 106041, 112435, 123673, 114691, 127405, 80164, 117511, 67677, 47341, 134614, 129349, 119174, 68435, 112179, 110155, 111637, 97807, 108906, 90922, 91425, 112433, 118715, 115530, 122666, 110249, 131611, 115492, 116279, 130552, 84161, 88526, 97667, 115675, 72486, 134047, 111455, 115008, 129810, 92008, 125862, 114741, 114931, 125859, 106762, 61366, 135868, 121777, 107614, 113186, 127232, 90028, 109813, 123597, 112994, 126410, 85260, 117790, 132796, 72986, 118326, 71119, 118876, 71946, 44349, 106068, 65887, 132699, 122510, 91122, 66279, 94355, 91482, 120494, 122799, 73620, 61125, 113028, 73299, 61021, 113765, 66299, 136201, 130499, 122512, 113508, 91336, 67787, 109376, 123590, 68992, 91929, 122770, 134395)
Run Time: 0.014769
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: 15973, 0, 1713577731, 1713581331, [["thread",63236],["thread",113256],["thread",83554],["thread",132418],["thread",115440],["thread",97923],["thread",113958],["thread",39823],["thread",68153],["thread",86982],["thread",71653],["thread",100530],["thread",136225],["thread",133136],["thread",72958],["thread",75337],["thread",123282],["thread",112650],["thread",112275],["thread",133981],["thread",118832],["thread",97629],["thread",115646],["thread",110023],["thread",120495],["thread",113914],["thread",117362],["thread",71752],["thread",55280],["thread",113834],["thread",100806],["thread",118912],["thread",71750],["thread",97307],["thread",127229],["thread",58430],["thread",76028],["thread",115594],["thread",90320],["thread",124935],["thread",83974],["thread",115491],["thread",97628],["thread",73117],["thread",127215],["thread",65869],["thread",132527],["thread",93556],["thread",112253],["thread",113316],["thread",128800],["thread",127025],["thread",77918],["thread",122275],["thread",132955],["thread",108229],["thread",107634],["thread",73300],["thread",129351],["thread",96528],["thread",129378],["thread",97386],["thread",104803],["thread",72946],["thread",132884],["thread",104885],["thread",128716],["thread",111727],["thread",115387],["thread",113527],["thread",79849],["thread",127231],["thread",132093],["thread",129180],["thread",135858],["thread",90200],["thread",118829],["thread",115079],["thread",133894],["thread",58429],["thread",76442],["thread",99802],["thread",120949],["thread",126356],["thread",111917],["thread",94316],["thread",89889],["thread",122506],["thread",74980],["thread",108455],["thread",96104],["thread",129602],["thread",97653],["thread",108036],["thread",132624],["thread",68807],["thread",110385],["thread",134984],["thread",129592],["thread",126357],["thread",124496],["thread",81109],["thread",74865],["thread",108188],["thread",97675],["thread",81299],["thread",57396],["thread",66005],["thread",109001],["thread",44353],["thread",96001],["thread",57391],["thread",23128],["thread",113651],["thread",118540],["thread",96354],["thread",58428],["thread",132461],["thread",103215],["thread",115434],["thread",69255],["thread",116939],["thread",131584],["thread",89890],["thread",70407],["thread",67136],["thread",113610],["thread",105877],["thread",133529],["thread",100416],["thread",75092],["thread",114410],["thread",129590],["thread",131659],["thread",131111],["thread",98097],["thread",66937],["thread",104886],["thread",129624],["thread",109791],["thread",74809],["thread",124092],["thread",110076],["thread",69886],["thread",86943],["thread",90613],["thread",111441],["thread",96595],["thread",70852],["thread",124368],["thread",123141],["thread",44345],["thread",114091],["thread",108075],["thread",112758],["thread",126515],["thread",71021],["thread",129604],["thread",90182],["thread",79907],["thread",80345],["thread",131657],["thread",132284],["thread",108302],["thread",68546],["thread",102033],["thread",44348],["thread",68427],["thread",98847],["thread",96732],["thread",131802],["thread",132448],["thread",133132],["thread",132104],["thread",119731],["thread",128379],["thread",92548],["thread",121920],["thread",70660],["thread",71751],["thread",133212],["thread",42119],["thread",133113],["thread",114742],["thread",112965],["thread",93401],["thread",66936],["thread",76836],["thread",132003],["thread",131713],["thread",122773],["thread",80726],["thread",131593],["thread",110609],["thread",68552],["thread",76188],["thread",79793],["thread",135869],["thread",121921],["thread",127149],["thread",113764],["thread",132618],["thread",57643],["thread",97464],["thread",60843],["thread",44347],["thread",26513],["thread",106041],["thread",112435],["thread",123673],["thread",114691],["thread",127405],["thread",80164],["thread",117511],["thread",67677],["thread",47341],["thread",134614],["thread",129349],["thread",119174],["thread",68435],["thread",112179],["thread",110155],["thread",111637],["thread",97807],["thread",108906],["thread",90922],["thread",91425],["thread",112433],["thread",118715],["thread",115530],["thread",122666],["thread",110249],["thread",131611],["thread",115492],["thread",116279],["thread",130552],["thread",84161],["thread",88526],["thread",97667],["thread",115675],["thread",72486],["thread",134047],["thread",111455],["thread",115008],["thread",129810],["thread",92008],["thread",125862],["thread",114741],["thread",114931],["thread",125859],["thread",106762],["thread",61366],["thread",135868],["thread",121777],["thread",107614],["thread",113186],["thread",127232],["thread",90028],["thread",109813],["thread",123597],["thread",112994],["thread",126410],["thread",85260],["thread",117790],["thread",132796],["thread",72986],["thread",118326],["thread",71119],["thread",118876],["thread",71946],["thread",44349],["thread",106068],["thread",65887],["thread",132699],["thread",122510],["thread",91122],["thread",66279],["thread",94355],["thread",91482],["thread",120494],["thread",122799],["thread",73620],["thread",61125],["thread",113028],["thread",73299],["thread",61021],["thread",113765],["thread",66299],["thread",136201],["thread",130499],["thread",122512],["thread",113508],["thread",91336],["thread",67787],["thread",109376],["thread",123590],["thread",68992],["thread",91929],["thread",122770],["thread",134395]]
Run Time: 0.000878
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.000065
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |