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 (113812, 121843, 88073, 116427, 71995, 116186, 126447, 116285, 104204, 116108, 81218, 86161, 72328, 88280, 42336, 122156, 117006, 50117, 59441, 118343, 123244, 94848, 107881, 105325, 132211, 113380, 106484, 126740, 100624, 95377, 108135, 110179, 116246, 75166, 125933, 126147, 113041, 94636, 127558, 86948, 106405, 115152, 93298, 113302, 84029, 125899, 91947, 125455, 88961, 106172, 125317, 118492, 116242, 125563, 89737, 118502, 125181, 96126, 110472, 125471, 128167, 98189, 105065, 125877, 95760, 126540, 97947, 104514, 72281, 120151, 104852, 121231, 113409, 100324, 108756, 115843, 81881, 116188, 47734, 128647, 108057, 126235, 115958, 117639, 47089, 122284, 96184, 114716, 96759, 108322, 116175, 113377, 108501, 85609, 125760, 51356, 129688, 108790, 128618, 105341, 94173, 122013, 109798, 105118, 110588, 115745, 112110, 103163, 93658, 111132, 117670, 117280, 121820, 98733, 94239, 117187, 59925, 117217, 73978, 118445, 76717, 96547, 47174, 50112, 112626, 135680, 118467, 90635, 118767, 121147, 119190, 106021, 125309, 51867, 50116, 110488, 90991, 89244, 123668, 110690, 96188, 116113, 127626, 113386, 125493, 122711, 119360, 112777, 110351, 63942, 125182, 117214, 85761, 85973, 118354, 106221, 118015, 125443, 134410, 118778, 62760, 113896, 90717, 72722, 116081, 96279, 127559, 93215, 126880, 95335, 73082, 103195, 53968, 91964, 121809, 118258, 122193, 115126, 48807, 120528, 116960, 121930, 59439, 125761, 115220, 108612, 76828, 89253, 86922, 115749, 112978, 94174, 117282, 89050, 87936, 127007, 85689, 107649, 112269, 95546, 115581, 114060, 118229, 126888, 113580, 118027, 91942, 115263, 118324, 108243, 101940, 117212, 127636, 62070, 118352, 110587, 107234, 126963, 115084, 122062, 117939, 128366, 93717, 107516, 134853, 129958, 115197, 122234, 116313, 112993, 89277, 113696, 118335, 94448, 109540, 122314, 93939, 122118, 51735, 114556, 93340, 118491, 122832, 67015, 121740, 125528, 50347, 89081, 118297, 95771, 67076, 121879, 122204, 121436, 122306, 126609, 112728, 122988, 85607, 121638, 121614, 134224, 118273, 126304, 95055, 70471, 103203, 118177, 125706, 96181, 125544, 117973, 117926, 104565, 126421, 115113, 103732, 93940, 95921, 125199, 106797, 93415)
Run Time: 0.017863
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 282 | 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: 12454, 0, 1713876884, 1713880484, [["resource",11],["resource",10],["resource",9],["resource",8],["thread",113812],["thread",121843],["thread",88073],["thread",116427],["thread",71995],["thread",116186],["thread",126447],["thread",116285],["thread",104204],["thread",116108],["thread",81218],["thread",86161],["thread",72328],["thread",88280],["thread",42336],["thread",122156],["thread",117006],["thread",50117],["thread",59441],["thread",118343],["thread",123244],["thread",94848],["thread",107881],["thread",105325],["thread",132211],["thread",113380],["thread",106484],["thread",126740],["thread",100624],["thread",95377],["thread",108135],["thread",110179],["thread",116246],["thread",75166],["thread",125933],["thread",126147],["thread",113041],["thread",94636],["thread",127558],["thread",86948],["thread",106405],["thread",115152],["thread",93298],["thread",113302],["thread",84029],["thread",125899],["thread",91947],["thread",125455],["thread",88961],["thread",106172],["thread",125317],["thread",118492],["thread",116242],["thread",125563],["thread",89737],["thread",118502],["thread",125181],["thread",96126],["thread",110472],["thread",125471],["thread",128167],["thread",98189],["thread",105065],["thread",125877],["thread",95760],["thread",126540],["thread",97947],["thread",104514],["thread",72281],["thread",120151],["thread",104852],["thread",121231],["thread",113409],["thread",100324],["thread",108756],["thread",115843],["thread",81881],["thread",116188],["thread",47734],["thread",128647],["thread",108057],["thread",126235],["thread",115958],["thread",117639],["thread",47089],["thread",122284],["thread",96184],["thread",114716],["thread",96759],["thread",108322],["thread",116175],["thread",113377],["thread",108501],["thread",85609],["thread",125760],["thread",51356],["thread",129688],["thread",108790],["thread",128618],["thread",105341],["thread",94173],["thread",122013],["thread",109798],["thread",105118],["thread",110588],["thread",115745],["thread",112110],["thread",103163],["thread",93658],["thread",111132],["thread",117670],["thread",117280],["thread",121820],["thread",98733],["thread",94239],["thread",117187],["thread",59925],["thread",117217],["thread",73978],["thread",118445],["thread",76717],["thread",96547],["thread",47174],["thread",50112],["thread",112626],["thread",135680],["thread",118467],["thread",90635],["thread",118767],["thread",121147],["thread",119190],["thread",106021],["thread",125309],["thread",51867],["thread",50116],["thread",110488],["thread",90991],["thread",89244],["thread",123668],["thread",110690],["thread",96188],["thread",116113],["thread",127626],["thread",113386],["thread",125493],["thread",122711],["thread",119360],["thread",112777],["thread",110351],["thread",63942],["thread",125182],["thread",117214],["thread",85761],["thread",85973],["thread",118354],["thread",106221],["thread",118015],["thread",125443],["thread",134410],["thread",118778],["thread",62760],["thread",113896],["thread",90717],["thread",72722],["thread",116081],["thread",96279],["thread",127559],["thread",93215],["thread",126880],["thread",95335],["thread",73082],["thread",103195],["thread",53968],["thread",91964],["thread",121809],["thread",118258],["thread",122193],["thread",115126],["thread",48807],["thread",120528],["thread",116960],["thread",121930],["thread",59439],["thread",125761],["thread",115220],["thread",108612],["thread",76828],["thread",89253],["thread",86922],["thread",115749],["thread",112978],["thread",94174],["thread",117282],["thread",89050],["thread",87936],["thread",127007],["thread",85689],["thread",107649],["thread",112269],["thread",95546],["thread",115581],["thread",114060],["thread",118229],["thread",126888],["thread",113580],["thread",118027],["thread",91942],["thread",115263],["thread",118324],["thread",108243],["thread",101940],["thread",117212],["thread",127636],["thread",62070],["thread",118352],["thread",110587],["thread",107234],["thread",126963],["thread",115084],["thread",122062],["thread",117939],["thread",128366],["thread",93717],["thread",107516],["thread",134853],["thread",129958],["thread",115197],["thread",122234],["thread",116313],["thread",112993],["thread",89277],["thread",113696],["thread",118335],["thread",94448],["thread",109540],["thread",122314],["thread",93939],["thread",122118],["thread",51735],["thread",114556],["thread",93340],["thread",118491],["thread",122832],["thread",67015],["thread",121740],["thread",125528],["thread",50347],["thread",89081],["thread",118297],["thread",95771],["thread",67076],["thread",121879],["thread",122204],["thread",121436],["thread",122306],["thread",126609],["thread",112728],["thread",122988],["thread",85607],["thread",121638],["thread",121614],["thread",134224],["thread",118273],["thread",126304],["thread",95055],["thread",70471],["thread",103203],["thread",118177],["thread",125706],["thread",96181],["thread",125544],["thread",117973],["thread",117926],["thread",104565],["thread",126421],["thread",115113],["thread",103732],["thread",93940],["thread",95921],["thread",125199],["thread",106797],["thread",93415]]
Run Time: 0.004288
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.000111
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |