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 (65038, 70096, 121091, 131905, 38373, 94329, 26728, 125887, 50406, 35589, 113017, 114790, 55574, 133705, 122240, 8622, 19228, 128046, 68478, 132404, 5818, 10470, 110828, 71893, 131816, 23089, 34153, 64507, 13195, 74842, 17600, 67852, 130854, 111903, 126943, 43555, 128973, 37828, 85095, 45865, 57153, 65247, 63742, 66181, 128122, 48222, 60322, 69361, 89193, 125931, 123519, 65266, 127416, 79056, 98819, 124558, 128435, 124869, 75056, 97626, 38431, 33959, 126405, 132700, 79671, 68630, 110465, 129841, 106476, 120562, 128281, 96754, 100308, 85726, 134839, 68665, 128480, 65861, 77984, 110823, 128995, 33376, 132706, 92744, 121339, 109788, 128198, 101595, 69216, 42515, 116858, 65246, 34319, 38826, 114334, 59592, 94260, 125146, 76707, 33155, 58595, 19213, 55373, 56258, 121021, 52397, 45870, 103473, 84771, 76781, 12248, 125922, 131888, 54028, 120024, 108411, 132203, 58189, 125316, 61707, 71416, 108913, 36940, 99694, 22188, 123753, 109340, 120036, 53620, 118636, 13987, 126395, 127759, 125280, 119840, 11409, 8661, 65297, 124809, 114085, 115834, 92811, 48792, 53629, 48094, 109082, 65217, 116596, 111034, 27655, 133414, 89188, 34547, 88633, 119979, 77735, 114682, 112135, 52708, 82268, 103669, 33330, 51371, 43225, 35494, 125195, 8663, 85508, 131469, 60278, 128139, 124939, 106039, 123580, 125141, 106273, 36107, 85642, 55368, 127985, 128021, 132044, 94922, 83566, 120618, 94397, 125020, 125067, 50507, 95210, 65303, 73079, 17083, 72998, 79987, 74202, 40507, 40229, 36158, 82714, 33157, 114745, 127990, 112441, 55184, 123544, 63065, 20898, 26548, 106828, 128489, 32681, 42682, 66635, 86657, 105893, 43228, 125315, 62930, 6054, 98820, 82332, 102956, 132890, 99131, 97057, 33372, 114534, 119843, 17080, 96596, 124762, 61157, 121149, 132635, 128165, 76242, 71015, 53901, 120940, 118193, 48084, 27799, 61740, 123744, 63272, 56137, 132579, 114162, 89026, 69464, 83745, 113163, 124998, 94396, 65321, 69704, 109823, 98120, 21920, 65238, 132667, 109248, 58571, 128545, 108250, 110970, 130047, 47765, 16235, 19279, 123650, 126897, 72454, 121495, 129721, 135422, 55360, 48947, 99799, 120960, 85596, 100275, 38536, 68632, 127810, 33869, 90594, 114855, 121062, 123600, 86027, 48664, 128239, 17546, 49735, 108452, 131085, 128518, 9268)
Run Time: 0.021871
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: 1421, 0, 1713609220, 1713612820, [["thread",65038],["thread",70096],["thread",121091],["thread",131905],["thread",38373],["thread",94329],["thread",26728],["thread",125887],["thread",50406],["thread",35589],["thread",113017],["thread",114790],["thread",55574],["thread",133705],["thread",122240],["thread",8622],["thread",19228],["thread",128046],["thread",68478],["thread",132404],["thread",5818],["thread",10470],["thread",110828],["thread",71893],["thread",131816],["thread",23089],["thread",34153],["thread",64507],["thread",13195],["thread",74842],["thread",17600],["thread",67852],["thread",130854],["thread",111903],["thread",126943],["thread",43555],["thread",128973],["thread",37828],["thread",85095],["thread",45865],["thread",57153],["thread",65247],["thread",63742],["thread",66181],["thread",128122],["thread",48222],["thread",60322],["thread",69361],["thread",89193],["thread",125931],["thread",123519],["thread",65266],["thread",127416],["thread",79056],["thread",98819],["thread",124558],["thread",128435],["thread",124869],["thread",75056],["thread",97626],["thread",38431],["thread",33959],["thread",126405],["thread",132700],["thread",79671],["thread",68630],["thread",110465],["thread",129841],["thread",106476],["thread",120562],["thread",128281],["thread",96754],["thread",100308],["thread",85726],["thread",134839],["thread",68665],["thread",128480],["thread",65861],["thread",77984],["thread",110823],["thread",128995],["thread",33376],["thread",132706],["thread",92744],["thread",121339],["thread",109788],["thread",128198],["thread",101595],["thread",69216],["thread",42515],["thread",116858],["thread",65246],["thread",34319],["thread",38826],["thread",114334],["thread",59592],["thread",94260],["thread",125146],["thread",76707],["thread",33155],["thread",58595],["thread",19213],["thread",55373],["thread",56258],["thread",121021],["thread",52397],["thread",45870],["thread",103473],["thread",84771],["thread",76781],["thread",12248],["thread",125922],["thread",131888],["thread",54028],["thread",120024],["thread",108411],["thread",132203],["thread",58189],["thread",125316],["thread",61707],["thread",71416],["thread",108913],["thread",36940],["thread",99694],["thread",22188],["thread",123753],["thread",109340],["thread",120036],["thread",53620],["thread",118636],["thread",13987],["thread",126395],["thread",127759],["thread",125280],["thread",119840],["thread",11409],["thread",8661],["thread",65297],["thread",124809],["thread",114085],["thread",115834],["thread",92811],["thread",48792],["thread",53629],["thread",48094],["thread",109082],["thread",65217],["thread",116596],["thread",111034],["thread",27655],["thread",133414],["thread",89188],["thread",34547],["thread",88633],["thread",119979],["thread",77735],["thread",114682],["thread",112135],["thread",52708],["thread",82268],["thread",103669],["thread",33330],["thread",51371],["thread",43225],["thread",35494],["thread",125195],["thread",8663],["thread",85508],["thread",131469],["thread",60278],["thread",128139],["thread",124939],["thread",106039],["thread",123580],["thread",125141],["thread",106273],["thread",36107],["thread",85642],["thread",55368],["thread",127985],["thread",128021],["thread",132044],["thread",94922],["thread",83566],["thread",120618],["thread",94397],["thread",125020],["thread",125067],["thread",50507],["thread",95210],["thread",65303],["thread",73079],["thread",17083],["thread",72998],["thread",79987],["thread",74202],["thread",40507],["thread",40229],["thread",36158],["thread",82714],["thread",33157],["thread",114745],["thread",127990],["thread",112441],["thread",55184],["thread",123544],["thread",63065],["thread",20898],["thread",26548],["thread",106828],["thread",128489],["thread",32681],["thread",42682],["thread",66635],["thread",86657],["thread",105893],["thread",43228],["thread",125315],["thread",62930],["thread",6054],["thread",98820],["thread",82332],["thread",102956],["thread",132890],["thread",99131],["thread",97057],["thread",33372],["thread",114534],["thread",119843],["thread",17080],["thread",96596],["thread",124762],["thread",61157],["thread",121149],["thread",132635],["thread",128165],["thread",76242],["thread",71015],["thread",53901],["thread",120940],["thread",118193],["thread",48084],["thread",27799],["thread",61740],["thread",123744],["thread",63272],["thread",56137],["thread",132579],["thread",114162],["thread",89026],["thread",69464],["thread",83745],["thread",113163],["thread",124998],["thread",94396],["thread",65321],["thread",69704],["thread",109823],["thread",98120],["thread",21920],["thread",65238],["thread",132667],["thread",109248],["thread",58571],["thread",128545],["thread",108250],["thread",110970],["thread",130047],["thread",47765],["thread",16235],["thread",19279],["thread",123650],["thread",126897],["thread",72454],["thread",121495],["thread",129721],["thread",135422],["thread",55360],["thread",48947],["thread",99799],["thread",120960],["thread",85596],["thread",100275],["thread",38536],["thread",68632],["thread",127810],["thread",33869],["thread",90594],["thread",114855],["thread",121062],["thread",123600],["thread",86027],["thread",48664],["thread",128239],["thread",17546],["thread",49735],["thread",108452],["thread",131085],["thread",128518],["thread",9268]]
Run Time: 0.002508
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.000064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |