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 (82913, 105787, 61308, 110244, 62570, 50225, 128540, 96958, 84027, 52460, 109947, 66009, 104963, 127078, 49326, 61106, 94581, 38017, 87862, 96037, 125298, 123101, 111214, 134179, 108156, 103025, 54410, 115735, 102330, 92926, 116560, 44072, 116997, 93991, 121601, 128515, 91542, 105187, 95408, 103250, 109625, 61627, 680, 36540, 94938, 106439, 105279, 127026, 44855, 114156, 115168, 111740, 98357, 35669, 98544, 94741, 105815, 91174, 115266, 117499, 64613, 104518, 128034, 57932, 8405, 13026, 86625, 113187, 121508, 102295, 96479, 70192, 91843, 80432, 95405, 43105, 97145, 100859, 111841, 98050, 98171, 124344, 97063, 80461, 73141, 58262, 80849, 54078, 64708, 105599, 122292, 111684, 61832, 93610, 133071, 93157, 110876, 36525, 88647, 102667, 107276, 50003, 97738, 101610, 69796, 103786, 7103, 106142, 117412, 69769, 94654, 68381, 116446, 102763, 71542, 111532, 12222, 87575, 122885, 107331, 85223, 61353, 107131, 55493, 91870, 58646, 109432, 114436, 87122, 106366, 106425, 123672, 51299, 99203, 91950, 102635, 123834, 114930, 109786, 106249, 119718, 106523, 65972, 93285, 126571, 64719, 61104, 39364, 12471, 127972, 65571, 109873, 109626, 42758, 72129, 132386, 127049, 106956, 82781, 77836, 104243, 66710, 123640, 99231, 127913, 126321, 12911, 127369, 98250, 107831, 105551, 76566, 59279, 105212, 62084, 74609, 114442, 62336, 103459, 127304, 94874, 80612, 101342, 67139, 91512, 128123, 69858, 107354, 126670, 128164, 76606, 111230, 111224, 98883, 61267, 48320, 16605, 59402, 97083, 92241, 109342, 89838, 98763, 105554, 67503, 105276, 105137, 57506, 25884, 60965, 56496, 89656, 62351, 691, 10116, 65793, 83512, 104737, 85109, 9816, 99201, 99288, 94068, 59200, 58467, 76205, 96049, 93843, 67257, 50612, 68082, 36795, 115479, 106846, 77845, 105418, 58177, 111133, 73933, 102885, 60347, 108232, 115321, 6351, 128002, 103133, 96789, 63341, 110702, 101916, 104817, 42792, 116874, 115405, 104042, 96367, 100142, 62517, 109836, 5338, 129513, 118291, 49722, 109598, 118612, 102827, 102162, 126866, 81439, 55801, 110532, 102165, 104650, 107063, 104825, 105958, 113208, 115796, 113289, 104230, 128037, 99660, 123836, 82308, 97438, 106168, 66248, 129408, 44252, 112095, 113611, 107557, 60466, 129964, 52636, 127648, 110094)
Run Time: 0.004743
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 297 | 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: 197, 0, 1713538751, 1713542351, [["tinhte_xentag_forum",45],["tinhte_xentag_forum",46],["tinhte_xentag_forum",47],["thread",82913],["thread",105787],["thread",61308],["thread",110244],["thread",62570],["thread",50225],["thread",128540],["thread",96958],["thread",84027],["thread",52460],["thread",109947],["thread",66009],["thread",104963],["thread",127078],["thread",49326],["thread",61106],["thread",94581],["thread",38017],["thread",87862],["thread",96037],["thread",125298],["thread",123101],["thread",111214],["thread",134179],["thread",108156],["thread",103025],["thread",54410],["thread",115735],["thread",102330],["thread",92926],["thread",116560],["thread",44072],["thread",116997],["thread",93991],["thread",121601],["thread",128515],["thread",91542],["thread",105187],["thread",95408],["thread",103250],["thread",109625],["thread",61627],["thread",680],["thread",36540],["thread",94938],["thread",106439],["thread",105279],["thread",127026],["thread",44855],["thread",114156],["thread",115168],["thread",111740],["thread",98357],["thread",35669],["thread",98544],["thread",94741],["thread",105815],["thread",91174],["thread",115266],["thread",117499],["thread",64613],["thread",104518],["thread",128034],["thread",57932],["thread",8405],["thread",13026],["thread",86625],["thread",113187],["thread",121508],["thread",102295],["thread",96479],["thread",70192],["thread",91843],["thread",80432],["thread",95405],["thread",43105],["thread",97145],["thread",100859],["thread",111841],["thread",98050],["thread",98171],["thread",124344],["thread",97063],["thread",80461],["thread",73141],["thread",58262],["thread",80849],["thread",54078],["thread",64708],["thread",105599],["thread",122292],["thread",111684],["thread",61832],["thread",93610],["thread",133071],["thread",93157],["thread",110876],["thread",36525],["thread",88647],["thread",102667],["thread",107276],["thread",50003],["thread",97738],["thread",101610],["thread",69796],["thread",103786],["thread",7103],["thread",106142],["thread",117412],["thread",69769],["thread",94654],["thread",68381],["thread",116446],["thread",102763],["thread",71542],["thread",111532],["thread",12222],["thread",87575],["thread",122885],["thread",107331],["thread",85223],["thread",61353],["thread",107131],["thread",55493],["thread",91870],["thread",58646],["thread",109432],["thread",114436],["thread",87122],["thread",106366],["thread",106425],["thread",123672],["thread",51299],["thread",99203],["thread",91950],["thread",102635],["thread",123834],["thread",114930],["thread",109786],["thread",106249],["thread",119718],["thread",106523],["thread",65972],["thread",93285],["thread",126571],["thread",64719],["thread",61104],["thread",39364],["thread",12471],["thread",127972],["thread",65571],["thread",109873],["thread",109626],["thread",42758],["thread",72129],["thread",132386],["thread",127049],["thread",106956],["thread",82781],["thread",77836],["thread",104243],["thread",66710],["thread",123640],["thread",99231],["thread",127913],["thread",126321],["thread",12911],["thread",127369],["thread",98250],["thread",107831],["thread",105551],["thread",76566],["thread",59279],["thread",105212],["thread",62084],["thread",74609],["thread",114442],["thread",62336],["thread",103459],["thread",127304],["thread",94874],["thread",80612],["thread",101342],["thread",67139],["thread",91512],["thread",128123],["thread",69858],["thread",107354],["thread",126670],["thread",128164],["thread",76606],["thread",111230],["thread",111224],["thread",98883],["thread",61267],["thread",48320],["thread",16605],["thread",59402],["thread",97083],["thread",92241],["thread",109342],["thread",89838],["thread",98763],["thread",105554],["thread",67503],["thread",105276],["thread",105137],["thread",57506],["thread",25884],["thread",60965],["thread",56496],["thread",89656],["thread",62351],["thread",691],["thread",10116],["thread",65793],["thread",83512],["thread",104737],["thread",85109],["thread",9816],["thread",99201],["thread",99288],["thread",94068],["thread",59200],["thread",58467],["thread",76205],["thread",96049],["thread",93843],["thread",67257],["thread",50612],["thread",68082],["thread",36795],["thread",115479],["thread",106846],["thread",77845],["thread",105418],["thread",58177],["thread",111133],["thread",73933],["thread",102885],["thread",60347],["thread",108232],["thread",115321],["thread",6351],["thread",128002],["thread",103133],["thread",96789],["thread",63341],["thread",110702],["thread",101916],["thread",104817],["thread",42792],["thread",116874],["thread",115405],["thread",104042],["thread",96367],["thread",100142],["thread",62517],["thread",109836],["thread",5338],["thread",129513],["thread",118291],["thread",49722],["thread",109598],["thread",118612],["thread",102827],["thread",102162],["thread",126866],["thread",81439],["thread",55801],["thread",110532],["thread",102165],["thread",104650],["thread",107063],["thread",104825],["thread",105958],["thread",113208],["thread",115796],["thread",113289],["thread",104230],["thread",128037],["thread",99660],["thread",123836],["thread",82308],["thread",97438],["thread",106168],["thread",66248],["thread",129408],["thread",44252],["thread",112095],["thread",113611],["thread",107557],["thread",60466],["thread",129964],["thread",52636],["thread",127648],["thread",110094]]
Run Time: 0.001381
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.000065
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |