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 (130409, 57778, 114397, 135216, 128325, 132177, 131646, 130146, 116672, 131651, 130714, 57905, 133190, 133775, 71981, 46746, 132306, 132383, 131133, 131429, 8042, 129371, 127844, 65066, 53327, 131518, 131682, 131312, 133603, 130486, 133133, 133046, 132637, 131535, 133044, 2279, 101314, 128138, 134342, 134560, 66532, 13970, 129955, 129533, 130850, 128976, 129105, 129954, 128553, 2276, 131227, 132525, 114604, 2273, 47241, 133062, 131308, 53059, 131872, 129960, 2145, 135276, 132129, 132752, 132724, 106561, 25257, 41670, 131640, 134788, 132955, 131132, 129054, 2267, 63751, 128859, 130926, 128581, 130362, 130074, 128873, 135108, 2266, 132951, 36688, 131306, 44365, 52675, 135910, 131559, 129642, 132634, 131935, 47221, 135559, 113276, 132355, 128436, 128774, 128840, 119290, 81461, 131683, 49958, 63369, 129593, 129677, 104306, 129362, 129842, 2274, 131723, 9673, 132307, 132781, 132974, 131931, 128935, 131778, 90944, 2265, 131874, 129736, 99028, 132795, 128405, 132430, 132072, 68831, 47362, 2269, 44889, 47154, 2277, 128459, 91500, 33664, 131789, 129179, 131985, 131426, 130010, 129764, 128829, 132427, 129171, 135469, 128720, 132524, 130462, 132807, 97554, 132501, 100441, 132232, 130975, 57999, 75070, 46744, 133432, 128251, 129072, 45790, 128221, 130485, 35094, 133702, 131493, 2146, 129302, 133583, 128333, 132260, 10427, 128380, 16386, 41669, 131199, 135284, 130321, 101562, 132837, 129984, 136789, 129980, 131635, 128922, 121194, 132438, 131483, 101153, 133081, 130874, 136178, 130495, 132054, 136184, 130814, 129150, 130604, 136960, 135988, 131438, 16771, 129676, 132163, 132055, 50548, 131721, 129875, 64261, 47277, 133703, 128797, 136817, 128790, 130073, 25817, 46773, 49963, 135554, 135882, 129846, 129927, 45665, 129583, 55878, 76832, 133114, 136787, 133034, 25249, 52420, 135856, 114447, 132516, 132220, 131041, 47363, 135075, 130899, 103316, 128537, 47357, 9788, 128661, 55657, 106239, 135866, 47359, 5788, 47568, 128603, 134346, 118827, 132028, 131468, 115018, 129937, 123128, 56085, 128733, 129180, 63837, 130633, 114404, 47721, 130089, 106411, 130780, 135125, 130881, 129784, 113336, 131361, 130556, 137034, 100773, 134824, 132759, 131023, 51945, 128767, 132782, 132189, 129887, 129149, 35411, 133382, 132088, 131494, 49657, 136009, 129796, 128369, 133246, 131104, 131965, 132932)
Run Time: 0.481488
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: 41, 0, 1715200677, 1715204277, [["tinhte_xentag_forum",65],["thread",130409],["thread",57778],["thread",114397],["thread",135216],["thread",128325],["thread",132177],["thread",131646],["thread",130146],["thread",116672],["thread",131651],["thread",130714],["thread",57905],["thread",133190],["thread",133775],["thread",71981],["thread",46746],["thread",132306],["thread",132383],["thread",131133],["thread",131429],["thread",8042],["thread",129371],["thread",127844],["thread",65066],["thread",53327],["thread",131518],["thread",131682],["thread",131312],["thread",133603],["thread",130486],["thread",133133],["thread",133046],["thread",132637],["thread",131535],["thread",133044],["thread",2279],["thread",101314],["thread",128138],["thread",134342],["thread",134560],["thread",66532],["thread",13970],["thread",129955],["thread",129533],["thread",130850],["thread",128976],["thread",129105],["thread",129954],["thread",128553],["thread",2276],["thread",131227],["thread",132525],["thread",114604],["thread",2273],["thread",47241],["thread",133062],["thread",131308],["thread",53059],["thread",131872],["thread",129960],["thread",2145],["thread",135276],["thread",132129],["thread",132752],["thread",132724],["thread",106561],["thread",25257],["thread",41670],["thread",131640],["thread",134788],["thread",132955],["thread",131132],["thread",129054],["thread",2267],["thread",63751],["thread",128859],["thread",130926],["thread",128581],["thread",130362],["thread",130074],["thread",128873],["thread",135108],["thread",2266],["thread",132951],["thread",36688],["thread",131306],["thread",44365],["thread",52675],["thread",135910],["thread",131559],["thread",129642],["thread",132634],["thread",131935],["thread",47221],["thread",135559],["thread",113276],["thread",132355],["thread",128436],["thread",128774],["thread",128840],["thread",119290],["thread",81461],["thread",131683],["thread",49958],["thread",63369],["thread",129593],["thread",129677],["thread",104306],["thread",129362],["thread",129842],["thread",2274],["thread",131723],["thread",9673],["thread",132307],["thread",132781],["thread",132974],["thread",131931],["thread",128935],["thread",131778],["thread",90944],["thread",2265],["thread",131874],["thread",129736],["thread",99028],["thread",132795],["thread",128405],["thread",132430],["thread",132072],["thread",68831],["thread",47362],["thread",2269],["thread",44889],["thread",47154],["thread",2277],["thread",128459],["thread",91500],["thread",33664],["thread",131789],["thread",129179],["thread",131985],["thread",131426],["thread",130010],["thread",129764],["thread",128829],["thread",132427],["thread",129171],["thread",135469],["thread",128720],["thread",132524],["thread",130462],["thread",132807],["thread",97554],["thread",132501],["thread",100441],["thread",132232],["thread",130975],["thread",57999],["thread",75070],["thread",46744],["thread",133432],["thread",128251],["thread",129072],["thread",45790],["thread",128221],["thread",130485],["thread",35094],["thread",133702],["thread",131493],["thread",2146],["thread",129302],["thread",133583],["thread",128333],["thread",132260],["thread",10427],["thread",128380],["thread",16386],["thread",41669],["thread",131199],["thread",135284],["thread",130321],["thread",101562],["thread",132837],["thread",129984],["thread",136789],["thread",129980],["thread",131635],["thread",128922],["thread",121194],["thread",132438],["thread",131483],["thread",101153],["thread",133081],["thread",130874],["thread",136178],["thread",130495],["thread",132054],["thread",136184],["thread",130814],["thread",129150],["thread",130604],["thread",136960],["thread",135988],["thread",131438],["thread",16771],["thread",129676],["thread",132163],["thread",132055],["thread",50548],["thread",131721],["thread",129875],["thread",64261],["thread",47277],["thread",133703],["thread",128797],["thread",136817],["thread",128790],["thread",130073],["thread",25817],["thread",46773],["thread",49963],["thread",135554],["thread",135882],["thread",129846],["thread",129927],["thread",45665],["thread",129583],["thread",55878],["thread",76832],["thread",133114],["thread",136787],["thread",133034],["thread",25249],["thread",52420],["thread",135856],["thread",114447],["thread",132516],["thread",132220],["thread",131041],["thread",47363],["thread",135075],["thread",130899],["thread",103316],["thread",128537],["thread",47357],["thread",9788],["thread",128661],["thread",55657],["thread",106239],["thread",135866],["thread",47359],["thread",5788],["thread",47568],["thread",128603],["thread",134346],["thread",118827],["thread",132028],["thread",131468],["thread",115018],["thread",129937],["thread",123128],["thread",56085],["thread",128733],["thread",129180],["thread",63837],["thread",130633],["thread",114404],["thread",47721],["thread",130089],["thread",106411],["thread",130780],["thread",135125],["thread",130881],["thread",129784],["thread",113336],["thread",131361],["thread",130556],["thread",137034],["thread",100773],["thread",134824],["thread",132759],["thread",131023],["thread",51945],["thread",128767],["thread",132782],["thread",132189],["thread",129887],["thread",129149],["thread",35411],["thread",133382],["thread",132088],["thread",131494],["thread",49657],["thread",136009],["thread",129796],["thread",128369],["thread",133246],["thread",131104],["thread",131965],["thread",132932]]
Run Time: 0.051172
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.036319
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |