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 (64016, 88189, 107682, 134459, 129521, 114791, 84962, 107259, 136539, 115718, 110258, 117534, 137182, 121350, 131079, 74130, 128288, 49934, 114256, 135077, 114205, 132238, 86438, 14491, 115863, 126753, 113808, 41623, 125711, 127370, 42963, 133976, 123909, 21155, 136006, 126259, 1268, 137146, 3871, 1043, 86292, 129647, 126734, 133059, 111370, 135807, 113622, 100338, 29792, 112641, 130867, 104472, 133785, 123979, 111300, 134788, 33997, 121747, 3067, 106987, 104188, 105289, 107911, 94950, 127162, 117703, 121710, 130176, 128328, 113724, 110757, 88283, 119354, 129405, 93821, 124741, 102999, 118593, 115720, 134578, 112033, 115176, 123174, 108768, 133911, 125802, 123750, 131418, 106863, 121083, 135923, 125979, 841, 9131, 127986, 19329, 95488, 77355, 78985, 133815, 17519, 106127, 135244, 115206, 124764, 62975, 128306, 132648, 68969, 117663, 126653, 116644, 131866, 110008, 68584, 120064, 136212, 108001, 106698, 65384, 135169, 116550, 118899, 100291, 119649, 125548, 112222, 136980, 136236, 127003, 47225, 134851, 1617, 108470, 67559, 68961, 969, 112380, 115627, 115262, 117085, 110913, 115417, 135532, 129545, 124186, 121873, 121273, 81560, 122803, 89676, 127269, 126278, 131162, 105730, 131026, 131535, 112895, 131663, 124141, 78004, 106829, 5432, 111702, 114808, 33954, 47395, 122668, 128526, 132411, 129171, 107379, 124988, 134809, 11935, 122447, 112428, 136357, 118306, 15087, 121007, 58671, 123347, 136672, 116206, 61285, 47242, 134541, 86603, 109253, 129894, 128879, 132329, 129083, 104745, 134947, 104759, 7080, 103344, 33612, 114158, 124885, 128407, 129134, 131940, 864, 132671, 85547, 120108, 111235, 134568, 121934, 124726, 136065, 60050, 67597, 22202, 133985, 99108, 123922, 122508, 115076, 104734, 132184, 68372, 88823, 117854, 115935, 120340, 129605, 1237, 128336, 42773, 110524, 61240, 35277, 131543, 129335, 86291, 125831, 130900, 123626, 133096, 133797, 2323, 105888, 131138, 136630, 121097, 6431, 127211, 90049, 1247, 118656, 132207, 73325, 111680, 134638, 119925, 115022, 136796, 121655, 124121, 133714, 128138, 64951, 115667, 133729, 1499, 133453, 132047, 108592, 113930, 134196, 135062, 127486, 2343, 115090, 122499, 108119, 114260, 114662, 81327, 109150, 129494, 113227, 127938, 132369, 134023, 110364, 109313, 133887, 80457, 51184, 100636, 128109, 126807, 126488)
Run Time: 0.340991
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 298 | 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: 8, 0, 1715574518, 1715578118, [["tinhte_xentag_forum",64],["tinhte_xentag_forum",65],["thread",64016],["thread",88189],["thread",107682],["thread",134459],["thread",129521],["thread",114791],["thread",84962],["thread",107259],["thread",136539],["thread",115718],["thread",110258],["thread",117534],["thread",137182],["thread",121350],["thread",131079],["thread",74130],["thread",128288],["thread",49934],["thread",114256],["thread",135077],["thread",114205],["thread",132238],["thread",86438],["thread",14491],["thread",115863],["thread",126753],["thread",113808],["thread",41623],["thread",125711],["thread",127370],["thread",42963],["thread",133976],["thread",123909],["thread",21155],["thread",136006],["thread",126259],["thread",1268],["thread",137146],["thread",3871],["thread",1043],["thread",86292],["thread",129647],["thread",126734],["thread",133059],["thread",111370],["thread",135807],["thread",113622],["thread",100338],["thread",29792],["thread",112641],["thread",130867],["thread",104472],["thread",133785],["thread",123979],["thread",111300],["thread",134788],["thread",33997],["thread",121747],["thread",3067],["thread",106987],["thread",104188],["thread",105289],["thread",107911],["thread",94950],["thread",127162],["thread",117703],["thread",121710],["thread",130176],["thread",128328],["thread",113724],["thread",110757],["thread",88283],["thread",119354],["thread",129405],["thread",93821],["thread",124741],["thread",102999],["thread",118593],["thread",115720],["thread",134578],["thread",112033],["thread",115176],["thread",123174],["thread",108768],["thread",133911],["thread",125802],["thread",123750],["thread",131418],["thread",106863],["thread",121083],["thread",135923],["thread",125979],["thread",841],["thread",9131],["thread",127986],["thread",19329],["thread",95488],["thread",77355],["thread",78985],["thread",133815],["thread",17519],["thread",106127],["thread",135244],["thread",115206],["thread",124764],["thread",62975],["thread",128306],["thread",132648],["thread",68969],["thread",117663],["thread",126653],["thread",116644],["thread",131866],["thread",110008],["thread",68584],["thread",120064],["thread",136212],["thread",108001],["thread",106698],["thread",65384],["thread",135169],["thread",116550],["thread",118899],["thread",100291],["thread",119649],["thread",125548],["thread",112222],["thread",136980],["thread",136236],["thread",127003],["thread",47225],["thread",134851],["thread",1617],["thread",108470],["thread",67559],["thread",68961],["thread",969],["thread",112380],["thread",115627],["thread",115262],["thread",117085],["thread",110913],["thread",115417],["thread",135532],["thread",129545],["thread",124186],["thread",121873],["thread",121273],["thread",81560],["thread",122803],["thread",89676],["thread",127269],["thread",126278],["thread",131162],["thread",105730],["thread",131026],["thread",131535],["thread",112895],["thread",131663],["thread",124141],["thread",78004],["thread",106829],["thread",5432],["thread",111702],["thread",114808],["thread",33954],["thread",47395],["thread",122668],["thread",128526],["thread",132411],["thread",129171],["thread",107379],["thread",124988],["thread",134809],["thread",11935],["thread",122447],["thread",112428],["thread",136357],["thread",118306],["thread",15087],["thread",121007],["thread",58671],["thread",123347],["thread",136672],["thread",116206],["thread",61285],["thread",47242],["thread",134541],["thread",86603],["thread",109253],["thread",129894],["thread",128879],["thread",132329],["thread",129083],["thread",104745],["thread",134947],["thread",104759],["thread",7080],["thread",103344],["thread",33612],["thread",114158],["thread",124885],["thread",128407],["thread",129134],["thread",131940],["thread",864],["thread",132671],["thread",85547],["thread",120108],["thread",111235],["thread",134568],["thread",121934],["thread",124726],["thread",136065],["thread",60050],["thread",67597],["thread",22202],["thread",133985],["thread",99108],["thread",123922],["thread",122508],["thread",115076],["thread",104734],["thread",132184],["thread",68372],["thread",88823],["thread",117854],["thread",115935],["thread",120340],["thread",129605],["thread",1237],["thread",128336],["thread",42773],["thread",110524],["thread",61240],["thread",35277],["thread",131543],["thread",129335],["thread",86291],["thread",125831],["thread",130900],["thread",123626],["thread",133096],["thread",133797],["thread",2323],["thread",105888],["thread",131138],["thread",136630],["thread",121097],["thread",6431],["thread",127211],["thread",90049],["thread",1247],["thread",118656],["thread",132207],["thread",73325],["thread",111680],["thread",134638],["thread",119925],["thread",115022],["thread",136796],["thread",121655],["thread",124121],["thread",133714],["thread",128138],["thread",64951],["thread",115667],["thread",133729],["thread",1499],["thread",133453],["thread",132047],["thread",108592],["thread",113930],["thread",134196],["thread",135062],["thread",127486],["thread",2343],["thread",115090],["thread",122499],["thread",108119],["thread",114260],["thread",114662],["thread",81327],["thread",109150],["thread",129494],["thread",113227],["thread",127938],["thread",132369],["thread",134023],["thread",110364],["thread",109313],["thread",133887],["thread",80457],["thread",51184],["thread",100636],["thread",128109],["thread",126807],["thread",126488]]
Run Time: 0.083446
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.000106
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |