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 (31181, 118333, 108109, 104189, 136573, 126576, 58168, 99527, 93930, 136442, 82072, 129288, 119310, 97466, 90320, 111396, 136217, 129911, 86309, 115881, 136191, 129003, 48162, 115737, 132573, 130695, 117711, 89880, 133153, 89178, 79558, 129398, 86337, 54616, 122209, 52974, 76631, 82055, 98573, 114667, 51393, 120606, 88881, 135175, 85287, 92493, 131799, 76221, 125293, 35397, 110180, 137121, 74519, 133060, 69931, 117044, 72054, 129303, 72232, 131953, 11914, 126021, 134157, 61020, 121530, 98392, 67129, 76350, 99967, 132461, 116651, 90899, 116451, 63573, 117550, 132956, 71608, 95338, 51270, 82445, 133881, 133776, 48165, 88513, 84938, 67909, 70125, 79257, 132800, 81762, 118866, 47330, 97953, 67709, 116472, 45786, 127629, 52632, 61492, 132299, 136445, 99666, 49710, 53854, 137329, 132818, 84000, 123844, 136268, 109943, 135819, 67797, 62380, 86659, 113333, 115191, 122695, 136267, 69084, 104069, 89547, 126216, 83124, 46316, 38909, 116645, 132046, 129080, 97905, 132884, 75927, 110136, 118719, 67924, 125954, 89719, 99060, 105034, 64857, 135993, 105505, 66520, 51997, 75862, 125292, 133477, 91143, 51660, 67133, 43604, 105814, 127233, 100588, 79745, 133729, 136293, 121570, 116395, 134092, 65618, 91833, 136888, 133741, 105805, 117676, 133490, 132934, 107722, 127994, 72552, 109058, 105914, 117051, 136296, 82051, 61762, 128926, 77003, 122501, 130680, 67501, 130469, 67461, 137117, 89388, 42894, 124418, 67659, 86385, 67366, 129975, 114243, 121900, 133916, 104315, 125756, 129334, 110238, 130430, 104822, 131728, 109954, 86893, 72616, 103335, 111515, 114356, 113568, 86925, 91985, 50007, 54219, 48342, 132048, 80700, 52344, 127177, 81755, 109174, 133967, 105139, 137057, 39508, 122873, 84907, 135989, 95778, 136148, 62330, 20428, 129521, 132824, 95775, 130474, 88507, 121605, 76992, 135366, 86638, 117383, 53617, 69939, 133987, 66324, 132035, 133470, 134128, 131309, 95701, 126529, 110677, 86545, 105715, 129893, 90808, 132288, 118305, 73462, 67468, 64043, 106468, 132572, 132894, 87383, 133688, 132582, 62759, 105665, 85516, 74862, 117621, 86285, 87152, 132650, 127556, 88088, 136757, 104966, 132474, 75916, 75917, 98210, 123234, 109324, 98611, 134016, 119864, 51346, 5853, 125635, 98824, 67251, 73601, 48253, 117416, 131356, 74865, 134799, 104162, 81776)
Run Time: 0.129306
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: 8935, 0, 1715502829, 1715506429, [["thread",31181],["thread",118333],["thread",108109],["thread",104189],["thread",136573],["thread",126576],["thread",58168],["thread",99527],["thread",93930],["thread",136442],["thread",82072],["thread",129288],["thread",119310],["thread",97466],["thread",90320],["thread",111396],["thread",136217],["thread",129911],["thread",86309],["thread",115881],["thread",136191],["thread",129003],["thread",48162],["thread",115737],["thread",132573],["thread",130695],["thread",117711],["thread",89880],["thread",133153],["thread",89178],["thread",79558],["thread",129398],["thread",86337],["thread",54616],["thread",122209],["thread",52974],["thread",76631],["thread",82055],["thread",98573],["thread",114667],["thread",51393],["thread",120606],["thread",88881],["thread",135175],["thread",85287],["thread",92493],["thread",131799],["thread",76221],["thread",125293],["thread",35397],["thread",110180],["thread",137121],["thread",74519],["thread",133060],["thread",69931],["thread",117044],["thread",72054],["thread",129303],["thread",72232],["thread",131953],["thread",11914],["thread",126021],["thread",134157],["thread",61020],["thread",121530],["thread",98392],["thread",67129],["thread",76350],["thread",99967],["thread",132461],["thread",116651],["thread",90899],["thread",116451],["thread",63573],["thread",117550],["thread",132956],["thread",71608],["thread",95338],["thread",51270],["thread",82445],["thread",133881],["thread",133776],["thread",48165],["thread",88513],["thread",84938],["thread",67909],["thread",70125],["thread",79257],["thread",132800],["thread",81762],["thread",118866],["thread",47330],["thread",97953],["thread",67709],["thread",116472],["thread",45786],["thread",127629],["thread",52632],["thread",61492],["thread",132299],["thread",136445],["thread",99666],["thread",49710],["thread",53854],["thread",137329],["thread",132818],["thread",84000],["thread",123844],["thread",136268],["thread",109943],["thread",135819],["thread",67797],["thread",62380],["thread",86659],["thread",113333],["thread",115191],["thread",122695],["thread",136267],["thread",69084],["thread",104069],["thread",89547],["thread",126216],["thread",83124],["thread",46316],["thread",38909],["thread",116645],["thread",132046],["thread",129080],["thread",97905],["thread",132884],["thread",75927],["thread",110136],["thread",118719],["thread",67924],["thread",125954],["thread",89719],["thread",99060],["thread",105034],["thread",64857],["thread",135993],["thread",105505],["thread",66520],["thread",51997],["thread",75862],["thread",125292],["thread",133477],["thread",91143],["thread",51660],["thread",67133],["thread",43604],["thread",105814],["thread",127233],["thread",100588],["thread",79745],["thread",133729],["thread",136293],["thread",121570],["thread",116395],["thread",134092],["thread",65618],["thread",91833],["thread",136888],["thread",133741],["thread",105805],["thread",117676],["thread",133490],["thread",132934],["thread",107722],["thread",127994],["thread",72552],["thread",109058],["thread",105914],["thread",117051],["thread",136296],["thread",82051],["thread",61762],["thread",128926],["thread",77003],["thread",122501],["thread",130680],["thread",67501],["thread",130469],["thread",67461],["thread",137117],["thread",89388],["thread",42894],["thread",124418],["thread",67659],["thread",86385],["thread",67366],["thread",129975],["thread",114243],["thread",121900],["thread",133916],["thread",104315],["thread",125756],["thread",129334],["thread",110238],["thread",130430],["thread",104822],["thread",131728],["thread",109954],["thread",86893],["thread",72616],["thread",103335],["thread",111515],["thread",114356],["thread",113568],["thread",86925],["thread",91985],["thread",50007],["thread",54219],["thread",48342],["thread",132048],["thread",80700],["thread",52344],["thread",127177],["thread",81755],["thread",109174],["thread",133967],["thread",105139],["thread",137057],["thread",39508],["thread",122873],["thread",84907],["thread",135989],["thread",95778],["thread",136148],["thread",62330],["thread",20428],["thread",129521],["thread",132824],["thread",95775],["thread",130474],["thread",88507],["thread",121605],["thread",76992],["thread",135366],["thread",86638],["thread",117383],["thread",53617],["thread",69939],["thread",133987],["thread",66324],["thread",132035],["thread",133470],["thread",134128],["thread",131309],["thread",95701],["thread",126529],["thread",110677],["thread",86545],["thread",105715],["thread",129893],["thread",90808],["thread",132288],["thread",118305],["thread",73462],["thread",67468],["thread",64043],["thread",106468],["thread",132572],["thread",132894],["thread",87383],["thread",133688],["thread",132582],["thread",62759],["thread",105665],["thread",85516],["thread",74862],["thread",117621],["thread",86285],["thread",87152],["thread",132650],["thread",127556],["thread",88088],["thread",136757],["thread",104966],["thread",132474],["thread",75916],["thread",75917],["thread",98210],["thread",123234],["thread",109324],["thread",98611],["thread",134016],["thread",119864],["thread",51346],["thread",5853],["thread",125635],["thread",98824],["thread",67251],["thread",73601],["thread",48253],["thread",117416],["thread",131356],["thread",74865],["thread",134799],["thread",104162],["thread",81776]]
Run Time: 0.003649
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.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |