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 (122624, 127322, 19157, 77307, 1942, 147176, 148039, 119098, 122576, 23929, 1949, 59735, 88961, 58045, 108611, 1747, 102272, 1962, 129936, 37689, 1751, 79144, 44509, 109158, 27194, 12988, 76971, 7334, 140473, 1375, 1522, 93984, 24528, 105735, 1825, 147761, 51878, 50267, 49669, 117747, 129730, 1817, 2842, 77306, 102639, 75225, 102708, 34249, 141901, 1911, 1809, 119389, 25262, 1845, 45651, 8318, 119583, 101295, 102605, 84336, 1741, 80315, 115135, 140500, 55954, 45689, 121638, 39816, 1972, 1740, 8670, 94584, 111831, 77012, 1967, 123264, 57771, 145417, 103028, 102589, 32250, 75835, 1912, 34018, 2507, 1518, 29536, 38435, 91128, 102803, 8499, 120874, 144294, 22685, 146966, 1742, 108753, 84338, 104662, 75477, 60440, 1784, 108085, 2026, 107776, 147951, 119026, 108724, 126506, 42116, 60239, 18634, 127203, 69376, 34142, 1519, 128087, 141173, 121442, 14542, 132660, 33545, 10559, 29492, 37537, 98939, 1948, 102253, 83734, 86100, 121066, 123785, 62366, 93949, 85130, 120212, 57015, 101437, 83230, 907, 110973, 3893, 1941, 19608, 53523, 103048, 13325, 40256, 112310, 2891, 44016, 1674, 82176, 108874, 1933, 2513, 133150, 20942, 139480, 1951, 466, 124100, 142733, 140191, 106521, 123721, 25189, 5998, 98249, 1120, 2536, 7517, 78999, 3744, 72078, 81314, 142282, 54970, 7320, 81254, 24619, 38519, 145791, 126648, 103874, 64481, 132423, 60558, 1922, 146708, 71116, 25921, 27895, 85563, 56268, 87037, 143813, 38900, 95842, 104922, 3288, 1806, 1229, 1404, 104040, 30284, 1750, 2728, 53676, 1767, 122165, 139304, 1901, 1154, 1758, 95433, 3545, 147819, 41643, 64937, 55925, 24933, 518, 68940, 82660, 122188, 32308, 147147, 19650, 98929, 2037, 81761, 1940, 1804, 2510, 105423, 1908, 34712, 1970, 98016, 2721, 86008, 148519, 134231, 142172, 128842, 1530, 66675, 1844, 2517, 61064, 2518, 2521, 116201, 143025, 38240, 67714, 1913, 126629, 144338, 35384, 54166, 2772, 2490, 141137, 1787, 134875, 96860, 145418, 124858, 61131, 131320, 136852, 84077, 91198, 101945, 112247, 98612, 11057, 56735, 45855, 73828, 147593, 86728, 147671, 1829, 148964, 77147, 27956, 85131, 71972, 56390, 1925, 1743, 100235, 1715, 1934, 76938, 101947, 103014)
Run Time: 0.009124
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: 142, 0, 1751416007, 1751419607, [["thread",122624],["thread",127322],["thread",19157],["thread",77307],["thread",1942],["thread",147176],["thread",148039],["thread",119098],["thread",122576],["thread",23929],["thread",1949],["thread",59735],["thread",88961],["thread",58045],["thread",108611],["thread",1747],["thread",102272],["thread",1962],["thread",129936],["thread",37689],["thread",1751],["thread",79144],["thread",44509],["thread",109158],["thread",27194],["thread",12988],["thread",76971],["thread",7334],["thread",140473],["thread",1375],["thread",1522],["thread",93984],["thread",24528],["thread",105735],["thread",1825],["thread",147761],["thread",51878],["thread",50267],["thread",49669],["thread",117747],["thread",129730],["thread",1817],["thread",2842],["thread",77306],["thread",102639],["thread",75225],["thread",102708],["thread",34249],["thread",141901],["thread",1911],["thread",1809],["thread",119389],["thread",25262],["thread",1845],["thread",45651],["thread",8318],["thread",119583],["thread",101295],["thread",102605],["thread",84336],["thread",1741],["thread",80315],["thread",115135],["thread",140500],["thread",55954],["thread",45689],["thread",121638],["thread",39816],["thread",1972],["thread",1740],["thread",8670],["thread",94584],["thread",111831],["thread",77012],["thread",1967],["thread",123264],["thread",57771],["thread",145417],["thread",103028],["thread",102589],["thread",32250],["thread",75835],["thread",1912],["thread",34018],["thread",2507],["thread",1518],["thread",29536],["thread",38435],["thread",91128],["thread",102803],["thread",8499],["thread",120874],["thread",144294],["thread",22685],["thread",146966],["thread",1742],["thread",108753],["thread",84338],["thread",104662],["thread",75477],["thread",60440],["thread",1784],["thread",108085],["thread",2026],["thread",107776],["thread",147951],["thread",119026],["thread",108724],["thread",126506],["thread",42116],["thread",60239],["thread",18634],["thread",127203],["thread",69376],["thread",34142],["thread",1519],["thread",128087],["thread",141173],["thread",121442],["thread",14542],["thread",132660],["thread",33545],["thread",10559],["thread",29492],["thread",37537],["thread",98939],["thread",1948],["thread",102253],["thread",83734],["thread",86100],["thread",121066],["thread",123785],["thread",62366],["thread",93949],["thread",85130],["thread",120212],["thread",57015],["thread",101437],["thread",83230],["thread",907],["thread",110973],["thread",3893],["thread",1941],["thread",19608],["thread",53523],["thread",103048],["thread",13325],["thread",40256],["thread",112310],["thread",2891],["thread",44016],["thread",1674],["thread",82176],["thread",108874],["thread",1933],["thread",2513],["thread",133150],["thread",20942],["thread",139480],["thread",1951],["thread",466],["thread",124100],["thread",142733],["thread",140191],["thread",106521],["thread",123721],["thread",25189],["thread",5998],["thread",98249],["thread",1120],["thread",2536],["thread",7517],["thread",78999],["thread",3744],["thread",72078],["thread",81314],["thread",142282],["thread",54970],["thread",7320],["thread",81254],["thread",24619],["thread",38519],["thread",145791],["thread",126648],["thread",103874],["thread",64481],["thread",132423],["thread",60558],["thread",1922],["thread",146708],["thread",71116],["thread",25921],["thread",27895],["thread",85563],["thread",56268],["thread",87037],["thread",143813],["thread",38900],["thread",95842],["thread",104922],["thread",3288],["thread",1806],["thread",1229],["thread",1404],["thread",104040],["thread",30284],["thread",1750],["thread",2728],["thread",53676],["thread",1767],["thread",122165],["thread",139304],["thread",1901],["thread",1154],["thread",1758],["thread",95433],["thread",3545],["thread",147819],["thread",41643],["thread",64937],["thread",55925],["thread",24933],["thread",518],["thread",68940],["thread",82660],["thread",122188],["thread",32308],["thread",147147],["thread",19650],["thread",98929],["thread",2037],["thread",81761],["thread",1940],["thread",1804],["thread",2510],["thread",105423],["thread",1908],["thread",34712],["thread",1970],["thread",98016],["thread",2721],["thread",86008],["thread",148519],["thread",134231],["thread",142172],["thread",128842],["thread",1530],["thread",66675],["thread",1844],["thread",2517],["thread",61064],["thread",2518],["thread",2521],["thread",116201],["thread",143025],["thread",38240],["thread",67714],["thread",1913],["thread",126629],["thread",144338],["thread",35384],["thread",54166],["thread",2772],["thread",2490],["thread",141137],["thread",1787],["thread",134875],["thread",96860],["thread",145418],["thread",124858],["thread",61131],["thread",131320],["thread",136852],["thread",84077],["thread",91198],["thread",101945],["thread",112247],["thread",98612],["thread",11057],["thread",56735],["thread",45855],["thread",73828],["thread",147593],["thread",86728],["thread",147671],["thread",1829],["thread",148964],["thread",77147],["thread",27956],["thread",85131],["thread",71972],["thread",56390],["thread",1925],["thread",1743],["thread",100235],["thread",1715],["thread",1934],["thread",76938],["thread",101947],["thread",103014]]
Run Time: 0.043348
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.035122
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |