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 (131807, 131727, 130354, 129005, 126159, 131828, 130473, 135907, 128964, 133694, 133950, 135364, 134467, 134042, 135064, 135182, 128958, 134331, 134963, 130263, 128292, 134429, 124343, 130769, 131070, 131536, 132182, 133922, 131603, 123920, 129237, 132184, 135327, 133766, 132039, 134430, 134277, 130076, 131187, 112219, 135448, 133581, 131188, 123941, 134388, 135592, 129610, 129746, 136018, 134016, 123218, 129604, 125837, 122829, 127452, 124453, 135874, 134300, 129543, 135066, 134316, 135982, 133049, 133413, 125211, 133125, 133159, 132214, 129597, 131704, 131069, 129613, 135585, 126550, 131808, 134424, 132024, 130379, 131851, 133756, 134930, 131262, 134439, 128010, 130750, 132022, 123680, 135933, 134097, 134844, 128361, 132983, 129878, 135116, 130653, 128330, 135731, 125221, 131068, 124001, 128710, 129975, 129202, 130324, 134198, 136011, 133814, 135960, 134503, 123984, 135482, 135797, 133201, 128288, 118729, 130091, 135063, 133836, 132999, 133857, 130034, 132034, 132000, 129742, 133040, 132871, 130294, 131452, 129949, 130472, 132042, 129491, 133200, 135675, 130039, 133472, 126544, 126245, 116279, 128778, 133911, 131855, 135510, 133388, 130748, 135229, 135283, 131567, 131328, 128428, 131011, 133380, 131718, 133329, 133912, 131833, 133619, 130018, 135295, 128080, 133815, 133985, 131725, 134301, 129669, 126874, 135737, 135712, 134737, 133897, 132800, 135433, 131924, 125485, 135552, 135383, 134638, 122822, 124480, 120899, 135710, 135261, 124051, 128363, 129756, 130349, 135157, 134081, 128104, 118798, 135024, 129722, 135768, 130821, 131456, 33847, 129271, 133230, 135871, 134216, 134083, 134008, 133537, 129169, 131717, 135206, 127235, 133991, 129133, 126692, 131793, 129595, 134336, 127050, 132047, 129594, 134672, 130463, 129668, 131117, 130229, 134120, 131009, 133453, 114327, 131530, 133466, 132573, 132299, 135455, 136032, 135921, 135069, 134757, 133127, 135485, 129131, 130318, 135009, 130150, 133730, 134202, 132656, 129256, 131703, 133872, 135047, 131326, 133788, 118837, 128464, 130352, 131528, 129335, 132709, 136035, 124134, 133056, 131481, 130746, 135588, 134426, 134333, 135572, 132335, 134955, 133590, 133728, 133377, 123886, 134241, 131098, 132173, 132572, 134381, 113352, 131648, 131185, 128413, 129216, 136050, 135432, 134874, 122483, 131853, 135972, 133320, 131716, 135207, 133156, 126658, 130057, 129911, 130652, 130364, 135115, 134778, 131571, 116058, 125372)
Run Time: 0.135835
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: 9269, 0, 1711725129, 1711728729, [["thread",131807],["thread",131727],["thread",130354],["thread",129005],["thread",126159],["thread",131828],["thread",130473],["thread",135907],["thread",128964],["thread",133694],["thread",133950],["thread",135364],["thread",134467],["thread",134042],["thread",135064],["thread",135182],["thread",128958],["thread",134331],["thread",134963],["thread",130263],["thread",128292],["thread",134429],["thread",124343],["thread",130769],["thread",131070],["thread",131536],["thread",132182],["thread",133922],["thread",131603],["thread",123920],["thread",129237],["thread",132184],["thread",135327],["thread",133766],["thread",132039],["thread",134430],["thread",134277],["thread",130076],["thread",131187],["thread",112219],["thread",135448],["thread",133581],["thread",131188],["thread",123941],["thread",134388],["thread",135592],["thread",129610],["thread",129746],["thread",136018],["thread",134016],["thread",123218],["thread",129604],["thread",125837],["thread",122829],["thread",127452],["thread",124453],["thread",135874],["thread",134300],["thread",129543],["thread",135066],["thread",134316],["thread",135982],["thread",133049],["thread",133413],["thread",125211],["thread",133125],["thread",133159],["thread",132214],["thread",129597],["thread",131704],["thread",131069],["thread",129613],["thread",135585],["thread",126550],["thread",131808],["thread",134424],["thread",132024],["thread",130379],["thread",131851],["thread",133756],["thread",134930],["thread",131262],["thread",134439],["thread",128010],["thread",130750],["thread",132022],["thread",123680],["thread",135933],["thread",134097],["thread",134844],["thread",128361],["thread",132983],["thread",129878],["thread",135116],["thread",130653],["thread",128330],["thread",135731],["thread",125221],["thread",131068],["thread",124001],["thread",128710],["thread",129975],["thread",129202],["thread",130324],["thread",134198],["thread",136011],["thread",133814],["thread",135960],["thread",134503],["thread",123984],["thread",135482],["thread",135797],["thread",133201],["thread",128288],["thread",118729],["thread",130091],["thread",135063],["thread",133836],["thread",132999],["thread",133857],["thread",130034],["thread",132034],["thread",132000],["thread",129742],["thread",133040],["thread",132871],["thread",130294],["thread",131452],["thread",129949],["thread",130472],["thread",132042],["thread",129491],["thread",133200],["thread",135675],["thread",130039],["thread",133472],["thread",126544],["thread",126245],["thread",116279],["thread",128778],["thread",133911],["thread",131855],["thread",135510],["thread",133388],["thread",130748],["thread",135229],["thread",135283],["thread",131567],["thread",131328],["thread",128428],["thread",131011],["thread",133380],["thread",131718],["thread",133329],["thread",133912],["thread",131833],["thread",133619],["thread",130018],["thread",135295],["thread",128080],["thread",133815],["thread",133985],["thread",131725],["thread",134301],["thread",129669],["thread",126874],["thread",135737],["thread",135712],["thread",134737],["thread",133897],["thread",132800],["thread",135433],["thread",131924],["thread",125485],["thread",135552],["thread",135383],["thread",134638],["thread",122822],["thread",124480],["thread",120899],["thread",135710],["thread",135261],["thread",124051],["thread",128363],["thread",129756],["thread",130349],["thread",135157],["thread",134081],["thread",128104],["thread",118798],["thread",135024],["thread",129722],["thread",135768],["thread",130821],["thread",131456],["thread",33847],["thread",129271],["thread",133230],["thread",135871],["thread",134216],["thread",134083],["thread",134008],["thread",133537],["thread",129169],["thread",131717],["thread",135206],["thread",127235],["thread",133991],["thread",129133],["thread",126692],["thread",131793],["thread",129595],["thread",134336],["thread",127050],["thread",132047],["thread",129594],["thread",134672],["thread",130463],["thread",129668],["thread",131117],["thread",130229],["thread",134120],["thread",131009],["thread",133453],["thread",114327],["thread",131530],["thread",133466],["thread",132573],["thread",132299],["thread",135455],["thread",136032],["thread",135921],["thread",135069],["thread",134757],["thread",133127],["thread",135485],["thread",129131],["thread",130318],["thread",135009],["thread",130150],["thread",133730],["thread",134202],["thread",132656],["thread",129256],["thread",131703],["thread",133872],["thread",135047],["thread",131326],["thread",133788],["thread",118837],["thread",128464],["thread",130352],["thread",131528],["thread",129335],["thread",132709],["thread",136035],["thread",124134],["thread",133056],["thread",131481],["thread",130746],["thread",135588],["thread",134426],["thread",134333],["thread",135572],["thread",132335],["thread",134955],["thread",133590],["thread",133728],["thread",133377],["thread",123886],["thread",134241],["thread",131098],["thread",132173],["thread",132572],["thread",134381],["thread",113352],["thread",131648],["thread",131185],["thread",128413],["thread",129216],["thread",136050],["thread",135432],["thread",134874],["thread",122483],["thread",131853],["thread",135972],["thread",133320],["thread",131716],["thread",135207],["thread",133156],["thread",126658],["thread",130057],["thread",129911],["thread",130652],["thread",130364],["thread",135115],["thread",134778],["thread",131571],["thread",116058],["thread",125372]]
Run Time: 0.042971
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.000109
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |