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 (110154, 123460, 121668, 79671, 69915, 92811, 37175, 48718, 104474, 78714, 73630, 125500, 72246, 113173, 100616, 59670, 131485, 75764, 108675, 4971, 97251, 56403, 109624, 55757, 66499, 34896, 45857, 134993, 122351, 55184, 50017, 23477, 107425, 101174, 86843, 7499, 120043, 49950, 130629, 50818, 8758, 75610, 113591, 65300, 83407, 126559, 119727, 52148, 115679, 104451, 112942, 127353, 98230, 33372, 33393, 27757, 9846, 93609, 61157, 52917, 95303, 83835, 65626, 50406, 68958, 123481, 97445, 85315, 68440, 95049, 65336, 125172, 13295, 113456, 30043, 132839, 99688, 36426, 52218, 80995, 95308, 79077, 135106, 132415, 67090, 98114, 121245, 67736, 39362, 34578, 25463, 68849, 128422, 57696, 94237, 14833, 131398, 69293, 90487, 33959, 125237, 85732, 128019, 67046, 73324, 108411, 51831, 108495, 37244, 126896, 92041, 123232, 79906, 115218, 96134, 74411, 75947, 127871, 48851, 71336, 136753, 92421, 132340, 130008, 67365, 97392, 38287, 10588, 33342, 113371, 65976, 68665, 131627, 27827, 105962, 126716, 82054, 85337, 53424, 68008, 98934, 74300, 73634, 79458, 61411, 88689, 101868, 84237, 62973, 123002, 27491, 97606, 127982, 134583, 38249, 101403, 74202, 68065, 93910, 126411, 50014, 87160, 15311, 94709, 43044, 115119, 75339, 57886, 80629, 122693, 119638, 65807, 110662, 133370, 126553, 121021, 72059, 76707, 79048, 65245, 112549, 92842, 94153, 14745, 13987, 39471, 99799, 64900, 54149, 118605, 117112, 23217, 38466, 103231, 114790, 127632, 45863, 74209, 128263, 95503, 84667, 111903, 76550, 121151, 126399, 127255, 96314, 118962, 58685, 116213, 126426, 76275, 119543, 127300, 17089, 62982, 120356, 44859, 100178, 35509, 119547, 38251, 114563, 13802, 99539, 38155, 116297, 131157, 93213, 96001, 88223, 50605, 47919, 33217, 60517, 121219, 121380, 4981, 66431, 28728, 124891, 130643, 62606, 94397, 111144, 122478, 28476, 82473, 122871, 117231, 107732, 110107, 96868, 56243, 103042, 58456, 110833, 43569, 45094, 38160, 64159, 95336, 84968, 59467, 126624, 4305, 71973, 117184, 128021, 57153, 127815, 73905, 132191, 48231, 132568, 129728, 118063, 35694, 119528, 109037, 126396, 65858, 120093, 117179, 119926, 33854, 16989, 89457, 80941, 112478, 52255, 110629, 37751, 119183, 37143, 82709, 119421, 110518, 114832, 127557)
Run Time: 0.014775
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: 1346, 0, 1714166742, 1714170342, [["thread",110154],["thread",123460],["thread",121668],["thread",79671],["thread",69915],["thread",92811],["thread",37175],["thread",48718],["thread",104474],["thread",78714],["thread",73630],["thread",125500],["thread",72246],["thread",113173],["thread",100616],["thread",59670],["thread",131485],["thread",75764],["thread",108675],["thread",4971],["thread",97251],["thread",56403],["thread",109624],["thread",55757],["thread",66499],["thread",34896],["thread",45857],["thread",134993],["thread",122351],["thread",55184],["thread",50017],["thread",23477],["thread",107425],["thread",101174],["thread",86843],["thread",7499],["thread",120043],["thread",49950],["thread",130629],["thread",50818],["thread",8758],["thread",75610],["thread",113591],["thread",65300],["thread",83407],["thread",126559],["thread",119727],["thread",52148],["thread",115679],["thread",104451],["thread",112942],["thread",127353],["thread",98230],["thread",33372],["thread",33393],["thread",27757],["thread",9846],["thread",93609],["thread",61157],["thread",52917],["thread",95303],["thread",83835],["thread",65626],["thread",50406],["thread",68958],["thread",123481],["thread",97445],["thread",85315],["thread",68440],["thread",95049],["thread",65336],["thread",125172],["thread",13295],["thread",113456],["thread",30043],["thread",132839],["thread",99688],["thread",36426],["thread",52218],["thread",80995],["thread",95308],["thread",79077],["thread",135106],["thread",132415],["thread",67090],["thread",98114],["thread",121245],["thread",67736],["thread",39362],["thread",34578],["thread",25463],["thread",68849],["thread",128422],["thread",57696],["thread",94237],["thread",14833],["thread",131398],["thread",69293],["thread",90487],["thread",33959],["thread",125237],["thread",85732],["thread",128019],["thread",67046],["thread",73324],["thread",108411],["thread",51831],["thread",108495],["thread",37244],["thread",126896],["thread",92041],["thread",123232],["thread",79906],["thread",115218],["thread",96134],["thread",74411],["thread",75947],["thread",127871],["thread",48851],["thread",71336],["thread",136753],["thread",92421],["thread",132340],["thread",130008],["thread",67365],["thread",97392],["thread",38287],["thread",10588],["thread",33342],["thread",113371],["thread",65976],["thread",68665],["thread",131627],["thread",27827],["thread",105962],["thread",126716],["thread",82054],["thread",85337],["thread",53424],["thread",68008],["thread",98934],["thread",74300],["thread",73634],["thread",79458],["thread",61411],["thread",88689],["thread",101868],["thread",84237],["thread",62973],["thread",123002],["thread",27491],["thread",97606],["thread",127982],["thread",134583],["thread",38249],["thread",101403],["thread",74202],["thread",68065],["thread",93910],["thread",126411],["thread",50014],["thread",87160],["thread",15311],["thread",94709],["thread",43044],["thread",115119],["thread",75339],["thread",57886],["thread",80629],["thread",122693],["thread",119638],["thread",65807],["thread",110662],["thread",133370],["thread",126553],["thread",121021],["thread",72059],["thread",76707],["thread",79048],["thread",65245],["thread",112549],["thread",92842],["thread",94153],["thread",14745],["thread",13987],["thread",39471],["thread",99799],["thread",64900],["thread",54149],["thread",118605],["thread",117112],["thread",23217],["thread",38466],["thread",103231],["thread",114790],["thread",127632],["thread",45863],["thread",74209],["thread",128263],["thread",95503],["thread",84667],["thread",111903],["thread",76550],["thread",121151],["thread",126399],["thread",127255],["thread",96314],["thread",118962],["thread",58685],["thread",116213],["thread",126426],["thread",76275],["thread",119543],["thread",127300],["thread",17089],["thread",62982],["thread",120356],["thread",44859],["thread",100178],["thread",35509],["thread",119547],["thread",38251],["thread",114563],["thread",13802],["thread",99539],["thread",38155],["thread",116297],["thread",131157],["thread",93213],["thread",96001],["thread",88223],["thread",50605],["thread",47919],["thread",33217],["thread",60517],["thread",121219],["thread",121380],["thread",4981],["thread",66431],["thread",28728],["thread",124891],["thread",130643],["thread",62606],["thread",94397],["thread",111144],["thread",122478],["thread",28476],["thread",82473],["thread",122871],["thread",117231],["thread",107732],["thread",110107],["thread",96868],["thread",56243],["thread",103042],["thread",58456],["thread",110833],["thread",43569],["thread",45094],["thread",38160],["thread",64159],["thread",95336],["thread",84968],["thread",59467],["thread",126624],["thread",4305],["thread",71973],["thread",117184],["thread",128021],["thread",57153],["thread",127815],["thread",73905],["thread",132191],["thread",48231],["thread",132568],["thread",129728],["thread",118063],["thread",35694],["thread",119528],["thread",109037],["thread",126396],["thread",65858],["thread",120093],["thread",117179],["thread",119926],["thread",33854],["thread",16989],["thread",89457],["thread",80941],["thread",112478],["thread",52255],["thread",110629],["thread",37751],["thread",119183],["thread",37143],["thread",82709],["thread",119421],["thread",110518],["thread",114832],["thread",127557]]
Run Time: 0.001443
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.000076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |