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 (9891, 81910, 95791, 67108, 102841, 109480, 120166, 120880, 103953, 107695, 86320, 116136, 92344, 84323, 136036, 115667, 43963, 109736, 117644, 92297, 102900, 34537, 87468, 83008, 90879, 103817, 93960, 87144, 116132, 97860, 115158, 47223, 26891, 126724, 84960, 35675, 73052, 135883, 122103, 124419, 107802, 79405, 114164, 105721, 1388, 113828, 115747, 31044, 116120, 39143, 81755, 33308, 33072, 90992, 81471, 875, 1704, 953, 107853, 84817, 84829, 77808, 112357, 28078, 107177, 107031, 94465, 106161, 106400, 30244, 107629, 98381, 135269, 116218, 84689, 107723, 80357, 86866, 118563, 97414, 2335, 114462, 94361, 1979, 87292, 116788, 85112, 106877, 81321, 116948, 935, 129652, 100325, 836, 35657, 104739, 102408, 34025, 123895, 96940, 107448, 111087, 124460, 84557, 33394, 34024, 29815, 50033, 76326, 115707, 26854, 126563, 99108, 83781, 84939, 34130, 57307, 116631, 80862, 115475, 104164, 110477, 117011, 929, 52542, 106262, 97291, 95905, 107553, 100079, 55904, 99337, 123582, 2055, 33309, 38890, 88357, 102003, 81300, 90079, 96765, 116906, 51402, 105805, 84141, 87248, 96850, 33067, 89823, 89270, 121042, 74410, 106259, 115017, 65513, 107835, 79476, 64725, 80359, 117044, 30458, 106287, 116599, 134687, 62534, 34026, 841, 80917, 32258, 115717, 91014, 114547, 85386, 112570, 124821, 88088, 34814, 35601, 104785, 76439, 838, 92063, 1028, 726, 62607, 98115, 106125, 35243, 108622, 123234, 34541, 91179, 104531, 95218, 87749, 29638, 115993, 34730, 80928, 129969, 89351, 98479, 125113, 47156, 87982, 33365, 104199, 111652, 106229, 105809, 116287, 116853, 882, 96076, 35466, 82106, 103181, 130759, 99743, 93243, 77304, 1393, 103755, 91466, 104395, 116663, 828, 113962, 104646, 89786, 84024, 93790, 35467, 98897, 106945, 115953, 84464, 107353, 87320, 121772, 86157, 101227, 108735, 1984, 128095, 88349, 105988, 77070, 125351, 106025, 126086, 35533, 116311, 1455, 128674, 110336, 123521, 112515, 121755, 100306, 112502, 126766, 116758, 116899, 115540, 118175, 116057, 1398, 107104, 41025, 115788, 57079, 34536, 47455, 27012, 97614, 124420, 110332, 80280, 114113, 97324, 125531, 102515, 35473, 35465, 114359, 104309, 33029, 90457, 89715, 29637, 115595, 106709, 86549, 109331, 92285, 2273, 30251, 30243)
Run Time: 0.011505
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, 1714177056, 1714180656, [["tinhte_xentag_forum",64],["thread",9891],["thread",81910],["thread",95791],["thread",67108],["thread",102841],["thread",109480],["thread",120166],["thread",120880],["thread",103953],["thread",107695],["thread",86320],["thread",116136],["thread",92344],["thread",84323],["thread",136036],["thread",115667],["thread",43963],["thread",109736],["thread",117644],["thread",92297],["thread",102900],["thread",34537],["thread",87468],["thread",83008],["thread",90879],["thread",103817],["thread",93960],["thread",87144],["thread",116132],["thread",97860],["thread",115158],["thread",47223],["thread",26891],["thread",126724],["thread",84960],["thread",35675],["thread",73052],["thread",135883],["thread",122103],["thread",124419],["thread",107802],["thread",79405],["thread",114164],["thread",105721],["thread",1388],["thread",113828],["thread",115747],["thread",31044],["thread",116120],["thread",39143],["thread",81755],["thread",33308],["thread",33072],["thread",90992],["thread",81471],["thread",875],["thread",1704],["thread",953],["thread",107853],["thread",84817],["thread",84829],["thread",77808],["thread",112357],["thread",28078],["thread",107177],["thread",107031],["thread",94465],["thread",106161],["thread",106400],["thread",30244],["thread",107629],["thread",98381],["thread",135269],["thread",116218],["thread",84689],["thread",107723],["thread",80357],["thread",86866],["thread",118563],["thread",97414],["thread",2335],["thread",114462],["thread",94361],["thread",1979],["thread",87292],["thread",116788],["thread",85112],["thread",106877],["thread",81321],["thread",116948],["thread",935],["thread",129652],["thread",100325],["thread",836],["thread",35657],["thread",104739],["thread",102408],["thread",34025],["thread",123895],["thread",96940],["thread",107448],["thread",111087],["thread",124460],["thread",84557],["thread",33394],["thread",34024],["thread",29815],["thread",50033],["thread",76326],["thread",115707],["thread",26854],["thread",126563],["thread",99108],["thread",83781],["thread",84939],["thread",34130],["thread",57307],["thread",116631],["thread",80862],["thread",115475],["thread",104164],["thread",110477],["thread",117011],["thread",929],["thread",52542],["thread",106262],["thread",97291],["thread",95905],["thread",107553],["thread",100079],["thread",55904],["thread",99337],["thread",123582],["thread",2055],["thread",33309],["thread",38890],["thread",88357],["thread",102003],["thread",81300],["thread",90079],["thread",96765],["thread",116906],["thread",51402],["thread",105805],["thread",84141],["thread",87248],["thread",96850],["thread",33067],["thread",89823],["thread",89270],["thread",121042],["thread",74410],["thread",106259],["thread",115017],["thread",65513],["thread",107835],["thread",79476],["thread",64725],["thread",80359],["thread",117044],["thread",30458],["thread",106287],["thread",116599],["thread",134687],["thread",62534],["thread",34026],["thread",841],["thread",80917],["thread",32258],["thread",115717],["thread",91014],["thread",114547],["thread",85386],["thread",112570],["thread",124821],["thread",88088],["thread",34814],["thread",35601],["thread",104785],["thread",76439],["thread",838],["thread",92063],["thread",1028],["thread",726],["thread",62607],["thread",98115],["thread",106125],["thread",35243],["thread",108622],["thread",123234],["thread",34541],["thread",91179],["thread",104531],["thread",95218],["thread",87749],["thread",29638],["thread",115993],["thread",34730],["thread",80928],["thread",129969],["thread",89351],["thread",98479],["thread",125113],["thread",47156],["thread",87982],["thread",33365],["thread",104199],["thread",111652],["thread",106229],["thread",105809],["thread",116287],["thread",116853],["thread",882],["thread",96076],["thread",35466],["thread",82106],["thread",103181],["thread",130759],["thread",99743],["thread",93243],["thread",77304],["thread",1393],["thread",103755],["thread",91466],["thread",104395],["thread",116663],["thread",828],["thread",113962],["thread",104646],["thread",89786],["thread",84024],["thread",93790],["thread",35467],["thread",98897],["thread",106945],["thread",115953],["thread",84464],["thread",107353],["thread",87320],["thread",121772],["thread",86157],["thread",101227],["thread",108735],["thread",1984],["thread",128095],["thread",88349],["thread",105988],["thread",77070],["thread",125351],["thread",106025],["thread",126086],["thread",35533],["thread",116311],["thread",1455],["thread",128674],["thread",110336],["thread",123521],["thread",112515],["thread",121755],["thread",100306],["thread",112502],["thread",126766],["thread",116758],["thread",116899],["thread",115540],["thread",118175],["thread",116057],["thread",1398],["thread",107104],["thread",41025],["thread",115788],["thread",57079],["thread",34536],["thread",47455],["thread",27012],["thread",97614],["thread",124420],["thread",110332],["thread",80280],["thread",114113],["thread",97324],["thread",125531],["thread",102515],["thread",35473],["thread",35465],["thread",114359],["thread",104309],["thread",33029],["thread",90457],["thread",89715],["thread",29637],["thread",115595],["thread",106709],["thread",86549],["thread",109331],["thread",92285],["thread",2273],["thread",30251],["thread",30243]]
Run Time: 0.001514
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.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |