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 (99577, 111859, 121380, 39421, 61364, 123034, 73998, 83367, 116850, 65872, 92684, 101612, 106291, 90208, 112942, 102997, 61237, 122982, 133205, 126296, 120208, 86403, 61217, 87138, 34364, 110543, 63239, 133233, 89252, 62506, 93256, 119274, 76571, 125174, 131672, 70461, 129094, 105007, 70921, 109600, 120997, 85776, 116459, 82968, 132127, 85825, 107518, 124931, 84235, 107362, 92303, 132456, 102441, 91638, 103131, 113687, 63162, 112366, 100955, 49713, 58504, 124125, 127077, 53748, 127338, 107283, 72672, 87166, 130868, 72624, 109958, 135379, 56630, 97889, 50761, 79612, 47038, 70067, 122421, 127593, 132195, 65736, 91531, 85605, 114939, 91841, 102853, 96558, 38659, 107652, 94339, 96790, 52598, 38670, 95499, 133243, 87195, 59367, 69595, 41718, 40521, 70363, 92968, 41971, 117441, 113529, 93384, 74132, 99719, 68440, 121014, 61572, 77925, 102151, 83835, 86426, 84507, 94211, 111978, 100965, 99479, 114783, 24607, 66500, 66554, 66518, 83547, 101835, 102404, 106961, 58636, 48412, 56286, 125229, 67921, 81061, 55835, 85994, 60988, 46439, 135782, 95062, 112208, 94645, 62065, 23961, 55010, 128503, 96382, 124055, 72602, 116213, 71681, 39550, 57806, 60894, 122420, 91397, 134158, 32046, 123811, 119621, 133354, 24773, 60455, 135796, 59156, 108528, 121221, 64591, 127708, 52997, 132725, 33078, 83009, 37767, 119636, 116297, 61026, 100534, 127747, 67542, 64861, 48375, 52370, 113490, 83579, 110020, 44159, 89085, 125076, 87477, 136071, 114491, 122556, 87535, 83239, 26922, 85777, 133066, 101197, 74964, 79995, 74566, 70306, 89700, 40096, 134539, 108675, 128701, 120779, 69141, 103293, 44649, 107120, 119363, 41998, 97708, 71743, 25563, 97363, 131410, 78058, 86989, 47451, 39147, 98230, 91576, 101711, 56895, 135747, 47501, 112165, 111837, 121658, 60497, 98513, 99559, 17232, 65294, 103290, 55215, 102773, 122224, 83407, 95691, 86028, 69401, 77168, 88228, 80802, 79888, 67022, 109753, 131424, 100739, 84230, 136076, 91747, 66538, 101465, 90497, 93272, 46645, 68192, 61567, 56254, 84250, 57737, 108697, 131392, 113456, 82460, 100732, 68777, 93911, 133161, 108957, 61836, 115608, 118588, 56414, 123706, 113081, 85079, 85081, 69792, 98447, 126511, 132139, 94479, 88703, 52419, 125368, 113612, 132392, 87229, 98520, 61165, 111414)
Run Time: 0.007997
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: 1450, 0, 1713586407, 1713590007, [["thread",99577],["thread",111859],["thread",121380],["thread",39421],["thread",61364],["thread",123034],["thread",73998],["thread",83367],["thread",116850],["thread",65872],["thread",92684],["thread",101612],["thread",106291],["thread",90208],["thread",112942],["thread",102997],["thread",61237],["thread",122982],["thread",133205],["thread",126296],["thread",120208],["thread",86403],["thread",61217],["thread",87138],["thread",34364],["thread",110543],["thread",63239],["thread",133233],["thread",89252],["thread",62506],["thread",93256],["thread",119274],["thread",76571],["thread",125174],["thread",131672],["thread",70461],["thread",129094],["thread",105007],["thread",70921],["thread",109600],["thread",120997],["thread",85776],["thread",116459],["thread",82968],["thread",132127],["thread",85825],["thread",107518],["thread",124931],["thread",84235],["thread",107362],["thread",92303],["thread",132456],["thread",102441],["thread",91638],["thread",103131],["thread",113687],["thread",63162],["thread",112366],["thread",100955],["thread",49713],["thread",58504],["thread",124125],["thread",127077],["thread",53748],["thread",127338],["thread",107283],["thread",72672],["thread",87166],["thread",130868],["thread",72624],["thread",109958],["thread",135379],["thread",56630],["thread",97889],["thread",50761],["thread",79612],["thread",47038],["thread",70067],["thread",122421],["thread",127593],["thread",132195],["thread",65736],["thread",91531],["thread",85605],["thread",114939],["thread",91841],["thread",102853],["thread",96558],["thread",38659],["thread",107652],["thread",94339],["thread",96790],["thread",52598],["thread",38670],["thread",95499],["thread",133243],["thread",87195],["thread",59367],["thread",69595],["thread",41718],["thread",40521],["thread",70363],["thread",92968],["thread",41971],["thread",117441],["thread",113529],["thread",93384],["thread",74132],["thread",99719],["thread",68440],["thread",121014],["thread",61572],["thread",77925],["thread",102151],["thread",83835],["thread",86426],["thread",84507],["thread",94211],["thread",111978],["thread",100965],["thread",99479],["thread",114783],["thread",24607],["thread",66500],["thread",66554],["thread",66518],["thread",83547],["thread",101835],["thread",102404],["thread",106961],["thread",58636],["thread",48412],["thread",56286],["thread",125229],["thread",67921],["thread",81061],["thread",55835],["thread",85994],["thread",60988],["thread",46439],["thread",135782],["thread",95062],["thread",112208],["thread",94645],["thread",62065],["thread",23961],["thread",55010],["thread",128503],["thread",96382],["thread",124055],["thread",72602],["thread",116213],["thread",71681],["thread",39550],["thread",57806],["thread",60894],["thread",122420],["thread",91397],["thread",134158],["thread",32046],["thread",123811],["thread",119621],["thread",133354],["thread",24773],["thread",60455],["thread",135796],["thread",59156],["thread",108528],["thread",121221],["thread",64591],["thread",127708],["thread",52997],["thread",132725],["thread",33078],["thread",83009],["thread",37767],["thread",119636],["thread",116297],["thread",61026],["thread",100534],["thread",127747],["thread",67542],["thread",64861],["thread",48375],["thread",52370],["thread",113490],["thread",83579],["thread",110020],["thread",44159],["thread",89085],["thread",125076],["thread",87477],["thread",136071],["thread",114491],["thread",122556],["thread",87535],["thread",83239],["thread",26922],["thread",85777],["thread",133066],["thread",101197],["thread",74964],["thread",79995],["thread",74566],["thread",70306],["thread",89700],["thread",40096],["thread",134539],["thread",108675],["thread",128701],["thread",120779],["thread",69141],["thread",103293],["thread",44649],["thread",107120],["thread",119363],["thread",41998],["thread",97708],["thread",71743],["thread",25563],["thread",97363],["thread",131410],["thread",78058],["thread",86989],["thread",47451],["thread",39147],["thread",98230],["thread",91576],["thread",101711],["thread",56895],["thread",135747],["thread",47501],["thread",112165],["thread",111837],["thread",121658],["thread",60497],["thread",98513],["thread",99559],["thread",17232],["thread",65294],["thread",103290],["thread",55215],["thread",102773],["thread",122224],["thread",83407],["thread",95691],["thread",86028],["thread",69401],["thread",77168],["thread",88228],["thread",80802],["thread",79888],["thread",67022],["thread",109753],["thread",131424],["thread",100739],["thread",84230],["thread",136076],["thread",91747],["thread",66538],["thread",101465],["thread",90497],["thread",93272],["thread",46645],["thread",68192],["thread",61567],["thread",56254],["thread",84250],["thread",57737],["thread",108697],["thread",131392],["thread",113456],["thread",82460],["thread",100732],["thread",68777],["thread",93911],["thread",133161],["thread",108957],["thread",61836],["thread",115608],["thread",118588],["thread",56414],["thread",123706],["thread",113081],["thread",85079],["thread",85081],["thread",69792],["thread",98447],["thread",126511],["thread",132139],["thread",94479],["thread",88703],["thread",52419],["thread",125368],["thread",113612],["thread",132392],["thread",87229],["thread",98520],["thread",61165],["thread",111414]]
Run Time: 0.007491
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.000075
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |