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 (61720, 103950, 76765, 135044, 114617, 81910, 35499, 112672, 84142, 116853, 36646, 118175, 37078, 129454, 87468, 123037, 81755, 95643, 63302, 45646, 52105, 22163, 106721, 37083, 936, 57278, 35606, 110336, 120066, 80052, 91179, 97496, 111735, 80923, 863, 97362, 131015, 123168, 67700, 122245, 35322, 99394, 117008, 79586, 115394, 1384, 34535, 51837, 114547, 98462, 104531, 108321, 124439, 116039, 106595, 108461, 128033, 95218, 35255, 30244, 535, 129361, 51402, 93790, 35657, 114113, 880, 86823, 44082, 39143, 104499, 75516, 101268, 96765, 87982, 79476, 33445, 102388, 114462, 52678, 135269, 128462, 35673, 123043, 116631, 76270, 76545, 47220, 106025, 103953, 97413, 33320, 33315, 97815, 134687, 116436, 89046, 126458, 33558, 89786, 91420, 59880, 85795, 103406, 113825, 82072, 78197, 81226, 104739, 34538, 1255, 77803, 87144, 115500, 108192, 117132, 115858, 47223, 97291, 107677, 102289, 123901, 91466, 114309, 64639, 115681, 77070, 97973, 868, 105749, 116132, 55423, 38944, 106706, 130498, 950, 116597, 30250, 107666, 126206, 120166, 95518, 34812, 106984, 1566, 123907, 95275, 112032, 106740, 116100, 118613, 93362, 13780, 108727, 94450, 104781, 1398, 107789, 98166, 887, 34539, 114057, 125151, 107835, 96859, 116550, 106125, 81756, 33028, 125113, 87865, 107946, 32261, 46813, 124420, 126834, 89351, 35608, 102140, 47569, 96185, 115717, 35500, 107554, 92344, 47694, 78971, 93116, 115734, 124821, 97499, 126639, 84942, 76371, 87508, 2266, 93141, 127057, 131152, 76373, 1449, 35603, 26858, 80121, 122596, 122473, 86522, 83781, 77006, 101227, 62534, 29637, 115667, 102066, 107888, 90070, 86492, 35323, 102329, 100079, 84689, 116578, 89715, 43605, 117126, 875, 125065, 107210, 122018, 86739, 596, 1704, 123298, 107138, 88075, 76770, 86664, 95901, 125351, 95222, 1275, 1246, 47568, 35932, 85379, 84070, 87184, 55336, 86441, 94815, 103181, 104348, 35468, 112217, 135914, 76960, 108622, 112502, 108163, 88420, 54499, 54359, 33314, 1979, 115458, 33072, 111736, 891, 109955, 135130, 85383, 80917, 34531, 33412, 124460, 116699, 72164, 98121, 89045, 9891, 95570, 102001, 83008, 106259, 67314, 116472, 35610, 107975, 65279, 1402, 111376, 107660, 127728, 35393, 35240, 119924, 1696, 127573, 87009)
Run Time: 0.438570
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 299 | 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: 367, 0, 1715923402, 1715927002, [["tinhte_xentag_forum",64],["thread",61720],["thread",103950],["thread",76765],["thread",135044],["thread",114617],["thread",81910],["thread",35499],["thread",112672],["thread",84142],["thread",116853],["thread",36646],["thread",118175],["thread",37078],["thread",129454],["thread",87468],["thread",123037],["thread",81755],["thread",95643],["thread",63302],["thread",45646],["thread",52105],["thread",22163],["thread",106721],["thread",37083],["thread",936],["thread",57278],["thread",35606],["thread",110336],["thread",120066],["thread",80052],["thread",91179],["thread",97496],["thread",111735],["thread",80923],["thread",863],["thread",97362],["thread",131015],["thread",123168],["thread",67700],["thread",122245],["thread",35322],["thread",99394],["thread",117008],["thread",79586],["thread",115394],["thread",1384],["thread",34535],["thread",51837],["thread",114547],["thread",98462],["thread",104531],["thread",108321],["thread",124439],["thread",116039],["thread",106595],["thread",108461],["thread",128033],["thread",95218],["thread",35255],["thread",30244],["thread",535],["thread",129361],["thread",51402],["thread",93790],["thread",35657],["thread",114113],["thread",880],["thread",86823],["thread",44082],["thread",39143],["thread",104499],["thread",75516],["thread",101268],["thread",96765],["thread",87982],["thread",79476],["thread",33445],["thread",102388],["thread",114462],["thread",52678],["thread",135269],["thread",128462],["thread",35673],["thread",123043],["thread",116631],["thread",76270],["thread",76545],["thread",47220],["thread",106025],["thread",103953],["thread",97413],["thread",33320],["thread",33315],["thread",97815],["thread",134687],["thread",116436],["thread",89046],["thread",126458],["thread",33558],["thread",89786],["thread",91420],["thread",59880],["thread",85795],["thread",103406],["thread",113825],["thread",82072],["thread",78197],["thread",81226],["thread",104739],["thread",34538],["thread",1255],["thread",77803],["thread",87144],["thread",115500],["thread",108192],["thread",117132],["thread",115858],["thread",47223],["thread",97291],["thread",107677],["thread",102289],["thread",123901],["thread",91466],["thread",114309],["thread",64639],["thread",115681],["thread",77070],["thread",97973],["thread",868],["thread",105749],["thread",116132],["thread",55423],["thread",38944],["thread",106706],["thread",130498],["thread",950],["thread",116597],["thread",30250],["thread",107666],["thread",126206],["thread",120166],["thread",95518],["thread",34812],["thread",106984],["thread",1566],["thread",123907],["thread",95275],["thread",112032],["thread",106740],["thread",116100],["thread",118613],["thread",93362],["thread",13780],["thread",108727],["thread",94450],["thread",104781],["thread",1398],["thread",107789],["thread",98166],["thread",887],["thread",34539],["thread",114057],["thread",125151],["thread",107835],["thread",96859],["thread",116550],["thread",106125],["thread",81756],["thread",33028],["thread",125113],["thread",87865],["thread",107946],["thread",32261],["thread",46813],["thread",124420],["thread",126834],["thread",89351],["thread",35608],["thread",102140],["thread",47569],["thread",96185],["thread",115717],["thread",35500],["thread",107554],["thread",92344],["thread",47694],["thread",78971],["thread",93116],["thread",115734],["thread",124821],["thread",97499],["thread",126639],["thread",84942],["thread",76371],["thread",87508],["thread",2266],["thread",93141],["thread",127057],["thread",131152],["thread",76373],["thread",1449],["thread",35603],["thread",26858],["thread",80121],["thread",122596],["thread",122473],["thread",86522],["thread",83781],["thread",77006],["thread",101227],["thread",62534],["thread",29637],["thread",115667],["thread",102066],["thread",107888],["thread",90070],["thread",86492],["thread",35323],["thread",102329],["thread",100079],["thread",84689],["thread",116578],["thread",89715],["thread",43605],["thread",117126],["thread",875],["thread",125065],["thread",107210],["thread",122018],["thread",86739],["thread",596],["thread",1704],["thread",123298],["thread",107138],["thread",88075],["thread",76770],["thread",86664],["thread",95901],["thread",125351],["thread",95222],["thread",1275],["thread",1246],["thread",47568],["thread",35932],["thread",85379],["thread",84070],["thread",87184],["thread",55336],["thread",86441],["thread",94815],["thread",103181],["thread",104348],["thread",35468],["thread",112217],["thread",135914],["thread",76960],["thread",108622],["thread",112502],["thread",108163],["thread",88420],["thread",54499],["thread",54359],["thread",33314],["thread",1979],["thread",115458],["thread",33072],["thread",111736],["thread",891],["thread",109955],["thread",135130],["thread",85383],["thread",80917],["thread",34531],["thread",33412],["thread",124460],["thread",116699],["thread",72164],["thread",98121],["thread",89045],["thread",9891],["thread",95570],["thread",102001],["thread",83008],["thread",106259],["thread",67314],["thread",116472],["thread",35610],["thread",107975],["thread",65279],["thread",1402],["thread",111376],["thread",107660],["thread",127728],["thread",35393],["thread",35240],["thread",119924],["thread",1696],["thread",127573],["thread",87009]]
Run Time: 0.015327
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.000085
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |