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 (51330, 110045, 119331, 133557, 59311, 35070, 66659, 125572, 133321, 113567, 63882, 84090, 72996, 118372, 95364, 63094, 56253, 110868, 132030, 102054, 85844, 132892, 66737, 101073, 103095, 126431, 43358, 98327, 108030, 110320, 134289, 113734, 91341, 17698, 116014, 129108, 60424, 69552, 73693, 103829, 61621, 42502, 116353, 99582, 88230, 61906, 41540, 95194, 81025, 52893, 68144, 27189, 78915, 57795, 87087, 121694, 121859, 115655, 60807, 62403, 59129, 102349, 46890, 62797, 82436, 125179, 67982, 107236, 38116, 49661, 116685, 114160, 99049, 58976, 57107, 120059, 80138, 119951, 85590, 61372, 110464, 100695, 116063, 42492, 77270, 103553, 66827, 132890, 37152, 42111, 116810, 122105, 87336, 24938, 110730, 96724, 118687, 72936, 85032, 105527, 86071, 132614, 37250, 122574, 110379, 59429, 124897, 57243, 61562, 11768, 116917, 70833, 91684, 76522, 31072, 128339, 134590, 92209, 51325, 103379, 48991, 128281, 69980, 62710, 41378, 105929, 120089, 72495, 132887, 134302, 86451, 32317, 108630, 112509, 104693, 63975, 75783, 86245, 116080, 92533, 110371, 63919, 57776, 25418, 71761, 89558, 84058, 109670, 61472, 67286, 49005, 69137, 72865, 105802, 68576, 112147, 62398, 28742, 133199, 60727, 74774, 72587, 63968, 108292, 69570, 71345, 80545, 71762, 96786, 62315, 101163, 97270, 58128, 97279, 99689, 113615, 57054, 49279, 67538, 43895, 60312, 66389, 21767, 74048, 103607, 132579, 121049, 106356, 64151, 114018, 40216, 51296, 115964, 113919, 105629, 66162, 76248, 70836, 61078, 37686, 66308, 110361, 70419, 40736, 103663, 60885, 78379, 89765, 66048, 43781, 128389, 35418, 59018, 47413, 105670, 89748, 21648, 58680, 71684, 110815, 92064, 54742, 107088, 134986, 103017, 123166, 80694, 104640, 104228, 111367, 46262, 71381, 92431, 74714, 62756, 116863, 94674, 56510, 79983, 54589, 103172, 74556, 108108, 68577, 65329, 118851, 19410, 115065, 52869, 66148, 95017, 40570, 115483, 35632, 69314, 105548, 116168, 118290, 113875, 50596, 44015, 104376, 66465, 48972, 84858, 95764, 53271, 109161, 60595, 93472, 91852, 99273, 92418, 101296, 84510, 119304, 112323, 86276, 58543, 55049, 59461, 57004, 68420, 60438, 58447, 111435, 86234, 89735, 40652, 121949, 87496, 62220, 62255, 101979, 74382, 61448, 129114, 56801, 62208, 32370)
Run Time: 0.014221
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: 1830, 0, 1711718965, 1711722565, [["thread",51330],["thread",110045],["thread",119331],["thread",133557],["thread",59311],["thread",35070],["thread",66659],["thread",125572],["thread",133321],["thread",113567],["thread",63882],["thread",84090],["thread",72996],["thread",118372],["thread",95364],["thread",63094],["thread",56253],["thread",110868],["thread",132030],["thread",102054],["thread",85844],["thread",132892],["thread",66737],["thread",101073],["thread",103095],["thread",126431],["thread",43358],["thread",98327],["thread",108030],["thread",110320],["thread",134289],["thread",113734],["thread",91341],["thread",17698],["thread",116014],["thread",129108],["thread",60424],["thread",69552],["thread",73693],["thread",103829],["thread",61621],["thread",42502],["thread",116353],["thread",99582],["thread",88230],["thread",61906],["thread",41540],["thread",95194],["thread",81025],["thread",52893],["thread",68144],["thread",27189],["thread",78915],["thread",57795],["thread",87087],["thread",121694],["thread",121859],["thread",115655],["thread",60807],["thread",62403],["thread",59129],["thread",102349],["thread",46890],["thread",62797],["thread",82436],["thread",125179],["thread",67982],["thread",107236],["thread",38116],["thread",49661],["thread",116685],["thread",114160],["thread",99049],["thread",58976],["thread",57107],["thread",120059],["thread",80138],["thread",119951],["thread",85590],["thread",61372],["thread",110464],["thread",100695],["thread",116063],["thread",42492],["thread",77270],["thread",103553],["thread",66827],["thread",132890],["thread",37152],["thread",42111],["thread",116810],["thread",122105],["thread",87336],["thread",24938],["thread",110730],["thread",96724],["thread",118687],["thread",72936],["thread",85032],["thread",105527],["thread",86071],["thread",132614],["thread",37250],["thread",122574],["thread",110379],["thread",59429],["thread",124897],["thread",57243],["thread",61562],["thread",11768],["thread",116917],["thread",70833],["thread",91684],["thread",76522],["thread",31072],["thread",128339],["thread",134590],["thread",92209],["thread",51325],["thread",103379],["thread",48991],["thread",128281],["thread",69980],["thread",62710],["thread",41378],["thread",105929],["thread",120089],["thread",72495],["thread",132887],["thread",134302],["thread",86451],["thread",32317],["thread",108630],["thread",112509],["thread",104693],["thread",63975],["thread",75783],["thread",86245],["thread",116080],["thread",92533],["thread",110371],["thread",63919],["thread",57776],["thread",25418],["thread",71761],["thread",89558],["thread",84058],["thread",109670],["thread",61472],["thread",67286],["thread",49005],["thread",69137],["thread",72865],["thread",105802],["thread",68576],["thread",112147],["thread",62398],["thread",28742],["thread",133199],["thread",60727],["thread",74774],["thread",72587],["thread",63968],["thread",108292],["thread",69570],["thread",71345],["thread",80545],["thread",71762],["thread",96786],["thread",62315],["thread",101163],["thread",97270],["thread",58128],["thread",97279],["thread",99689],["thread",113615],["thread",57054],["thread",49279],["thread",67538],["thread",43895],["thread",60312],["thread",66389],["thread",21767],["thread",74048],["thread",103607],["thread",132579],["thread",121049],["thread",106356],["thread",64151],["thread",114018],["thread",40216],["thread",51296],["thread",115964],["thread",113919],["thread",105629],["thread",66162],["thread",76248],["thread",70836],["thread",61078],["thread",37686],["thread",66308],["thread",110361],["thread",70419],["thread",40736],["thread",103663],["thread",60885],["thread",78379],["thread",89765],["thread",66048],["thread",43781],["thread",128389],["thread",35418],["thread",59018],["thread",47413],["thread",105670],["thread",89748],["thread",21648],["thread",58680],["thread",71684],["thread",110815],["thread",92064],["thread",54742],["thread",107088],["thread",134986],["thread",103017],["thread",123166],["thread",80694],["thread",104640],["thread",104228],["thread",111367],["thread",46262],["thread",71381],["thread",92431],["thread",74714],["thread",62756],["thread",116863],["thread",94674],["thread",56510],["thread",79983],["thread",54589],["thread",103172],["thread",74556],["thread",108108],["thread",68577],["thread",65329],["thread",118851],["thread",19410],["thread",115065],["thread",52869],["thread",66148],["thread",95017],["thread",40570],["thread",115483],["thread",35632],["thread",69314],["thread",105548],["thread",116168],["thread",118290],["thread",113875],["thread",50596],["thread",44015],["thread",104376],["thread",66465],["thread",48972],["thread",84858],["thread",95764],["thread",53271],["thread",109161],["thread",60595],["thread",93472],["thread",91852],["thread",99273],["thread",92418],["thread",101296],["thread",84510],["thread",119304],["thread",112323],["thread",86276],["thread",58543],["thread",55049],["thread",59461],["thread",57004],["thread",68420],["thread",60438],["thread",58447],["thread",111435],["thread",86234],["thread",89735],["thread",40652],["thread",121949],["thread",87496],["thread",62220],["thread",62255],["thread",101979],["thread",74382],["thread",61448],["thread",129114],["thread",56801],["thread",62208],["thread",32370]]
Run Time: 0.040919
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.009970
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |