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 (86801, 76255, 133921, 107872, 104084, 112270, 98062, 56827, 54692, 107696, 60689, 120903, 125076, 63780, 89298, 19540, 56955, 48375, 125349, 132640, 64515, 64747, 86487, 107149, 72672, 55837, 101658, 124462, 113852, 5600, 59156, 136284, 106430, 80658, 98711, 52253, 90208, 42854, 95750, 71741, 88123, 35643, 13370, 58956, 63374, 68440, 84020, 90681, 72438, 91705, 79938, 107731, 50491, 127454, 129738, 19001, 37834, 58502, 47409, 81080, 47822, 57659, 44599, 92521, 63115, 40254, 73998, 71082, 55835, 64108, 61217, 41663, 65169, 102231, 33711, 117441, 106961, 87788, 119741, 61487, 129467, 134539, 128785, 125037, 101443, 88490, 120994, 59801, 30622, 87229, 45210, 66118, 57876, 133120, 98072, 67365, 94624, 55461, 68342, 125978, 42274, 68953, 96306, 82968, 94339, 103494, 55799, 128166, 128208, 62452, 60698, 133233, 51258, 83611, 95691, 123370, 69499, 66137, 91457, 52556, 93303, 122424, 135796, 62523, 125174, 62668, 43118, 94451, 85274, 129827, 51962, 77171, 92122, 106933, 103819, 21408, 89234, 88076, 36618, 113529, 70996, 83835, 66164, 59551, 80793, 41590, 117604, 37605, 96010, 124257, 87554, 78668, 59757, 36652, 82796, 24005, 66940, 68246, 122180, 124769, 96063, 73526, 41002, 55709, 65961, 127593, 50651, 125229, 82027, 96696, 115030, 121426, 97292, 117028, 113674, 106145, 126821, 84708, 18069, 54774, 51088, 77456, 58504, 24612, 125192, 45134, 70893, 92848, 48592, 46645, 59503, 79139, 55237, 112469, 81091, 60520, 122687, 54404, 110895, 127028, 133885, 72234, 49526, 57591, 104389, 97889, 112634, 102151, 85950, 91087, 40252, 71681, 128286, 39473, 127077, 57008, 99413, 99567, 126115, 46439, 86607, 88062, 50230, 60189, 58866, 38079, 123689, 57806, 57489, 97759, 56895, 85875, 61023, 86989, 60015, 44105, 132053, 90230, 132731, 127772, 113397, 61940, 68998, 104652, 128239, 83870, 85306, 121982, 53189, 96246, 66698, 110825, 86938, 91841, 57460, 54348, 90996, 32995, 34645, 100458, 52154, 132195, 107784, 101058, 131400, 125694, 65807, 76081, 26853, 68858, 104203, 134029, 97259, 118062, 78175, 57655, 61779, 98513, 54503, 133387, 52659, 96371, 86924, 69122, 43042, 57208, 62737, 82138, 105330, 61665, 96382, 74830, 132725, 59378, 123841, 135968, 56306, 129800, 128676, 103920)
Run Time: 0.007064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 300 | 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: 1338, 0, 1713586765, 1713590365, [["thread",86801],["thread",76255],["thread",133921],["thread",107872],["thread",104084],["thread",112270],["thread",98062],["thread",56827],["thread",54692],["thread",107696],["thread",60689],["thread",120903],["thread",125076],["thread",63780],["thread",89298],["thread",19540],["thread",56955],["thread",48375],["thread",125349],["thread",132640],["thread",64515],["thread",64747],["thread",86487],["thread",107149],["thread",72672],["thread",55837],["thread",101658],["thread",124462],["thread",113852],["thread",5600],["thread",59156],["thread",136284],["thread",106430],["thread",80658],["thread",98711],["thread",52253],["thread",90208],["thread",42854],["thread",95750],["thread",71741],["thread",88123],["thread",35643],["thread",13370],["thread",58956],["thread",63374],["thread",68440],["thread",84020],["thread",90681],["thread",72438],["thread",91705],["thread",79938],["thread",107731],["thread",50491],["thread",127454],["thread",129738],["thread",19001],["thread",37834],["thread",58502],["thread",47409],["thread",81080],["thread",47822],["thread",57659],["thread",44599],["thread",92521],["thread",63115],["thread",40254],["thread",73998],["thread",71082],["thread",55835],["thread",64108],["thread",61217],["thread",41663],["thread",65169],["thread",102231],["thread",33711],["thread",117441],["thread",106961],["thread",87788],["thread",119741],["thread",61487],["thread",129467],["thread",134539],["thread",128785],["thread",125037],["thread",101443],["thread",88490],["thread",120994],["thread",59801],["thread",30622],["thread",87229],["thread",45210],["thread",66118],["thread",57876],["thread",133120],["thread",98072],["thread",67365],["thread",94624],["thread",55461],["thread",68342],["thread",125978],["thread",42274],["thread",68953],["thread",96306],["thread",82968],["thread",94339],["thread",103494],["thread",55799],["thread",128166],["thread",128208],["thread",62452],["thread",60698],["thread",133233],["thread",51258],["thread",83611],["thread",95691],["thread",123370],["thread",69499],["thread",66137],["thread",91457],["thread",52556],["thread",93303],["thread",122424],["thread",135796],["thread",62523],["thread",125174],["thread",62668],["thread",43118],["thread",94451],["thread",85274],["thread",129827],["thread",51962],["thread",77171],["thread",92122],["thread",106933],["thread",103819],["thread",21408],["thread",89234],["thread",88076],["thread",36618],["thread",113529],["thread",70996],["thread",83835],["thread",66164],["thread",59551],["thread",80793],["thread",41590],["thread",117604],["thread",37605],["thread",96010],["thread",124257],["thread",87554],["thread",78668],["thread",59757],["thread",36652],["thread",82796],["thread",24005],["thread",66940],["thread",68246],["thread",122180],["thread",124769],["thread",96063],["thread",73526],["thread",41002],["thread",55709],["thread",65961],["thread",127593],["thread",50651],["thread",125229],["thread",82027],["thread",96696],["thread",115030],["thread",121426],["thread",97292],["thread",117028],["thread",113674],["thread",106145],["thread",126821],["thread",84708],["thread",18069],["thread",54774],["thread",51088],["thread",77456],["thread",58504],["thread",24612],["thread",125192],["thread",45134],["thread",70893],["thread",92848],["thread",48592],["thread",46645],["thread",59503],["thread",79139],["thread",55237],["thread",112469],["thread",81091],["thread",60520],["thread",122687],["thread",54404],["thread",110895],["thread",127028],["thread",133885],["thread",72234],["thread",49526],["thread",57591],["thread",104389],["thread",97889],["thread",112634],["thread",102151],["thread",85950],["thread",91087],["thread",40252],["thread",71681],["thread",128286],["thread",39473],["thread",127077],["thread",57008],["thread",99413],["thread",99567],["thread",126115],["thread",46439],["thread",86607],["thread",88062],["thread",50230],["thread",60189],["thread",58866],["thread",38079],["thread",123689],["thread",57806],["thread",57489],["thread",97759],["thread",56895],["thread",85875],["thread",61023],["thread",86989],["thread",60015],["thread",44105],["thread",132053],["thread",90230],["thread",132731],["thread",127772],["thread",113397],["thread",61940],["thread",68998],["thread",104652],["thread",128239],["thread",83870],["thread",85306],["thread",121982],["thread",53189],["thread",96246],["thread",66698],["thread",110825],["thread",86938],["thread",91841],["thread",57460],["thread",54348],["thread",90996],["thread",32995],["thread",34645],["thread",100458],["thread",52154],["thread",132195],["thread",107784],["thread",101058],["thread",131400],["thread",125694],["thread",65807],["thread",76081],["thread",26853],["thread",68858],["thread",104203],["thread",134029],["thread",97259],["thread",118062],["thread",78175],["thread",57655],["thread",61779],["thread",98513],["thread",54503],["thread",133387],["thread",52659],["thread",96371],["thread",86924],["thread",69122],["thread",43042],["thread",57208],["thread",62737],["thread",82138],["thread",105330],["thread",61665],["thread",96382],["thread",74830],["thread",132725],["thread",59378],["thread",123841],["thread",135968],["thread",56306],["thread",129800],["thread",128676],["thread",103920]]
Run Time: 0.007996
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 |