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 (96768, 51038, 44325, 104657, 135860, 102795, 34291, 58464, 74831, 85543, 62623, 70357, 135677, 44165, 90841, 58360, 56850, 85428, 3089, 92112, 73231, 100124, 64917, 135428, 75495, 57919, 82348, 78510, 69045, 91112, 89060, 74996, 54658, 87355, 43858, 79674, 41970, 10180, 100514, 58644, 74661, 92518, 86188, 52045, 89795, 95982, 57576, 103915, 71436, 109462, 102934, 62022, 72407, 91933, 70867, 113835, 96827, 91477, 71042, 63824, 45159, 95474, 88488, 58798, 65105, 98599, 55066, 71477, 79711, 61244, 50041, 54231, 35218, 53289, 91384, 89379, 85034, 64444, 109681, 84025, 80647, 61428, 64321, 53885, 87723, 65059, 82025, 42038, 85129, 68424, 67654, 98267, 99659, 61501, 57312, 106590, 22867, 96177, 51525, 97111, 90342, 53239, 102163, 55536, 50802, 62266, 60146, 85461, 64697, 52383, 112721, 52641, 36903, 56218, 62447, 61612, 62884, 56048, 75887, 80112, 81763, 108191, 52575, 59224, 61741, 32911, 70845, 48456, 62121, 78939, 80909, 39028, 71771, 93050, 69818, 56929, 132847, 90562, 115740, 84223, 86643, 105006, 44563, 63076, 55687, 64462, 87326, 59426, 26408, 102590, 86290, 78328, 74963, 92759, 105002, 83720, 64170, 75664, 110983, 61213, 123839, 50705, 84784, 47045, 52558, 55613, 73143, 87205, 55786, 73024, 83380, 107367, 74654, 84584, 78620, 64193, 65973, 52660, 79638, 80455, 41961, 91051, 70486, 21620, 48843, 55062, 61393, 64793, 127751, 90234, 61558, 79547, 103336, 109776, 121840, 54868, 69928, 69946, 35126, 49432, 118766, 111599, 56340, 84600, 86457, 104782, 81764, 46269, 113609, 117305, 71639, 104035, 86796, 86702, 68341, 82841, 66109, 66537, 104855, 83918, 52279, 89590, 61503, 66566, 80415, 87266, 57805, 90442, 72670, 80929, 67047, 131749, 46396, 84441, 105195, 62980, 52830, 87604, 103302, 93563, 103094, 67745, 72723, 58838, 50938, 77063, 112899, 77068, 99235, 49436, 74894, 83929, 70536, 80477, 40746, 116862, 131460, 113178, 106302, 77408, 56470, 58949, 73874, 83150, 108521, 75415, 89699, 91741, 103413, 62405, 53747, 30844, 101343, 60001, 85684, 45995, 69109, 88588, 99021, 117859, 61397, 66025, 85076, 100665, 63540, 69721, 47808, 59918, 64281, 108884, 38740, 64002, 55009, 67534, 62742, 57092, 104567, 82887, 28066, 89900)
Run Time: 0.019624
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: 3437, 0, 1715928467, 1715932067, [["thread",96768],["thread",51038],["thread",44325],["thread",104657],["thread",135860],["thread",102795],["thread",34291],["thread",58464],["thread",74831],["thread",85543],["thread",62623],["thread",70357],["thread",135677],["thread",44165],["thread",90841],["thread",58360],["thread",56850],["thread",85428],["thread",3089],["thread",92112],["thread",73231],["thread",100124],["thread",64917],["thread",135428],["thread",75495],["thread",57919],["thread",82348],["thread",78510],["thread",69045],["thread",91112],["thread",89060],["thread",74996],["thread",54658],["thread",87355],["thread",43858],["thread",79674],["thread",41970],["thread",10180],["thread",100514],["thread",58644],["thread",74661],["thread",92518],["thread",86188],["thread",52045],["thread",89795],["thread",95982],["thread",57576],["thread",103915],["thread",71436],["thread",109462],["thread",102934],["thread",62022],["thread",72407],["thread",91933],["thread",70867],["thread",113835],["thread",96827],["thread",91477],["thread",71042],["thread",63824],["thread",45159],["thread",95474],["thread",88488],["thread",58798],["thread",65105],["thread",98599],["thread",55066],["thread",71477],["thread",79711],["thread",61244],["thread",50041],["thread",54231],["thread",35218],["thread",53289],["thread",91384],["thread",89379],["thread",85034],["thread",64444],["thread",109681],["thread",84025],["thread",80647],["thread",61428],["thread",64321],["thread",53885],["thread",87723],["thread",65059],["thread",82025],["thread",42038],["thread",85129],["thread",68424],["thread",67654],["thread",98267],["thread",99659],["thread",61501],["thread",57312],["thread",106590],["thread",22867],["thread",96177],["thread",51525],["thread",97111],["thread",90342],["thread",53239],["thread",102163],["thread",55536],["thread",50802],["thread",62266],["thread",60146],["thread",85461],["thread",64697],["thread",52383],["thread",112721],["thread",52641],["thread",36903],["thread",56218],["thread",62447],["thread",61612],["thread",62884],["thread",56048],["thread",75887],["thread",80112],["thread",81763],["thread",108191],["thread",52575],["thread",59224],["thread",61741],["thread",32911],["thread",70845],["thread",48456],["thread",62121],["thread",78939],["thread",80909],["thread",39028],["thread",71771],["thread",93050],["thread",69818],["thread",56929],["thread",132847],["thread",90562],["thread",115740],["thread",84223],["thread",86643],["thread",105006],["thread",44563],["thread",63076],["thread",55687],["thread",64462],["thread",87326],["thread",59426],["thread",26408],["thread",102590],["thread",86290],["thread",78328],["thread",74963],["thread",92759],["thread",105002],["thread",83720],["thread",64170],["thread",75664],["thread",110983],["thread",61213],["thread",123839],["thread",50705],["thread",84784],["thread",47045],["thread",52558],["thread",55613],["thread",73143],["thread",87205],["thread",55786],["thread",73024],["thread",83380],["thread",107367],["thread",74654],["thread",84584],["thread",78620],["thread",64193],["thread",65973],["thread",52660],["thread",79638],["thread",80455],["thread",41961],["thread",91051],["thread",70486],["thread",21620],["thread",48843],["thread",55062],["thread",61393],["thread",64793],["thread",127751],["thread",90234],["thread",61558],["thread",79547],["thread",103336],["thread",109776],["thread",121840],["thread",54868],["thread",69928],["thread",69946],["thread",35126],["thread",49432],["thread",118766],["thread",111599],["thread",56340],["thread",84600],["thread",86457],["thread",104782],["thread",81764],["thread",46269],["thread",113609],["thread",117305],["thread",71639],["thread",104035],["thread",86796],["thread",86702],["thread",68341],["thread",82841],["thread",66109],["thread",66537],["thread",104855],["thread",83918],["thread",52279],["thread",89590],["thread",61503],["thread",66566],["thread",80415],["thread",87266],["thread",57805],["thread",90442],["thread",72670],["thread",80929],["thread",67047],["thread",131749],["thread",46396],["thread",84441],["thread",105195],["thread",62980],["thread",52830],["thread",87604],["thread",103302],["thread",93563],["thread",103094],["thread",67745],["thread",72723],["thread",58838],["thread",50938],["thread",77063],["thread",112899],["thread",77068],["thread",99235],["thread",49436],["thread",74894],["thread",83929],["thread",70536],["thread",80477],["thread",40746],["thread",116862],["thread",131460],["thread",113178],["thread",106302],["thread",77408],["thread",56470],["thread",58949],["thread",73874],["thread",83150],["thread",108521],["thread",75415],["thread",89699],["thread",91741],["thread",103413],["thread",62405],["thread",53747],["thread",30844],["thread",101343],["thread",60001],["thread",85684],["thread",45995],["thread",69109],["thread",88588],["thread",99021],["thread",117859],["thread",61397],["thread",66025],["thread",85076],["thread",100665],["thread",63540],["thread",69721],["thread",47808],["thread",59918],["thread",64281],["thread",108884],["thread",38740],["thread",64002],["thread",55009],["thread",67534],["thread",62742],["thread",57092],["thread",104567],["thread",82887],["thread",28066],["thread",89900]]
Run Time: 0.022022
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.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |