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 (2025, 76978, 2028, 1935, 21947, 21943, 21931, 20934, 2019, 93284, 76225, 91864, 2024, 2806, 94660, 44016, 62847, 2023, 78454, 10267, 84336, 76431, 29615, 2022, 71362, 52040, 2487, 1928, 76052, 4280, 76775, 1922, 95695, 20948, 2742, 2021, 21950, 1421, 1504, 118395, 76218, 131127, 35384, 74444, 12123, 20426, 1157, 20874, 6897, 89559, 71371, 42198, 10335, 21956, 6801, 82286, 1570, 76643, 48913, 75993, 21263, 83601, 49454, 1898, 21917, 24510, 9139, 129497, 129626, 69340, 62284, 133456, 1529, 12837, 51998, 2488, 1419, 21926, 2093, 41549, 101058, 62596, 1518, 56885, 8625, 5630, 130621, 101040, 24940, 2094, 42147, 2763, 908, 7330, 62117, 75924, 21983, 74375, 1918, 541, 974, 76565, 2091, 78588, 2090, 88566, 1600, 1404, 976, 21938, 3890, 1150, 1936, 119583, 25052, 51946, 34763, 19392, 1589, 47184, 130590, 2037, 96487, 42116, 121066, 2100, 19298, 21942, 107366, 1931, 83140, 49971, 80315, 21979, 105991, 76567, 2705, 53411, 25314, 954, 1264, 21986, 60927, 8670, 942, 68513, 36897, 39908, 74151, 21922, 28237, 58576, 1521, 54697, 72170, 80290, 1531, 128988, 87683, 19658, 21981, 8775, 2088, 1149, 11158, 51231, 1532, 111624, 1603, 55361, 9348, 2027, 757, 62600, 39439, 36859, 129499, 1968, 111033, 5998, 63056, 40362, 66891, 20936, 20678, 40397, 4950, 1919, 418, 20522, 72963, 4159, 488, 21948, 24942, 1530, 2092, 2095, 57064, 78112, 907, 1527, 21998, 901, 19372, 76430, 67018, 57259, 129238, 2513, 1610, 10268, 12857, 1924, 76644, 1838, 2535, 18817, 68438, 21941, 98018, 21628, 1417, 82236, 83594, 756, 44318, 21952, 7518, 90663, 1967, 21925, 77214, 20028, 1830, 52303, 1416, 5407, 23947, 957, 61748, 76227, 61210, 1120, 2018, 1138, 117905, 21980, 75904, 2089, 20947, 1263, 21957, 63058, 109341, 21946, 955, 82829, 8381, 109337, 47953, 3251, 10834, 76645, 1933, 2020, 1528, 129432, 89935, 75440, 21913, 21985, 1301, 10519, 82663, 76060, 2490, 113695, 5511, 112081, 1422, 24528, 1934, 25297, 2026, 7517, 33604, 2489, 1517, 48842, 20943, 133173, 19531, 83964, 2087, 8500, 121218, 23225, 21984, 20937)
Run Time: 0.011252
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: 62, 0, 1713453076, 1713456676, [["thread",2025],["thread",76978],["thread",2028],["thread",1935],["thread",21947],["thread",21943],["thread",21931],["thread",20934],["thread",2019],["thread",93284],["thread",76225],["thread",91864],["thread",2024],["thread",2806],["thread",94660],["thread",44016],["thread",62847],["thread",2023],["thread",78454],["thread",10267],["thread",84336],["thread",76431],["thread",29615],["thread",2022],["thread",71362],["thread",52040],["thread",2487],["thread",1928],["thread",76052],["thread",4280],["thread",76775],["thread",1922],["thread",95695],["thread",20948],["thread",2742],["thread",2021],["thread",21950],["thread",1421],["thread",1504],["thread",118395],["thread",76218],["thread",131127],["thread",35384],["thread",74444],["thread",12123],["thread",20426],["thread",1157],["thread",20874],["thread",6897],["thread",89559],["thread",71371],["thread",42198],["thread",10335],["thread",21956],["thread",6801],["thread",82286],["thread",1570],["thread",76643],["thread",48913],["thread",75993],["thread",21263],["thread",83601],["thread",49454],["thread",1898],["thread",21917],["thread",24510],["thread",9139],["thread",129497],["thread",129626],["thread",69340],["thread",62284],["thread",133456],["thread",1529],["thread",12837],["thread",51998],["thread",2488],["thread",1419],["thread",21926],["thread",2093],["thread",41549],["thread",101058],["thread",62596],["thread",1518],["thread",56885],["thread",8625],["thread",5630],["thread",130621],["thread",101040],["thread",24940],["thread",2094],["thread",42147],["thread",2763],["thread",908],["thread",7330],["thread",62117],["thread",75924],["thread",21983],["thread",74375],["thread",1918],["thread",541],["thread",974],["thread",76565],["thread",2091],["thread",78588],["thread",2090],["thread",88566],["thread",1600],["thread",1404],["thread",976],["thread",21938],["thread",3890],["thread",1150],["thread",1936],["thread",119583],["thread",25052],["thread",51946],["thread",34763],["thread",19392],["thread",1589],["thread",47184],["thread",130590],["thread",2037],["thread",96487],["thread",42116],["thread",121066],["thread",2100],["thread",19298],["thread",21942],["thread",107366],["thread",1931],["thread",83140],["thread",49971],["thread",80315],["thread",21979],["thread",105991],["thread",76567],["thread",2705],["thread",53411],["thread",25314],["thread",954],["thread",1264],["thread",21986],["thread",60927],["thread",8670],["thread",942],["thread",68513],["thread",36897],["thread",39908],["thread",74151],["thread",21922],["thread",28237],["thread",58576],["thread",1521],["thread",54697],["thread",72170],["thread",80290],["thread",1531],["thread",128988],["thread",87683],["thread",19658],["thread",21981],["thread",8775],["thread",2088],["thread",1149],["thread",11158],["thread",51231],["thread",1532],["thread",111624],["thread",1603],["thread",55361],["thread",9348],["thread",2027],["thread",757],["thread",62600],["thread",39439],["thread",36859],["thread",129499],["thread",1968],["thread",111033],["thread",5998],["thread",63056],["thread",40362],["thread",66891],["thread",20936],["thread",20678],["thread",40397],["thread",4950],["thread",1919],["thread",418],["thread",20522],["thread",72963],["thread",4159],["thread",488],["thread",21948],["thread",24942],["thread",1530],["thread",2092],["thread",2095],["thread",57064],["thread",78112],["thread",907],["thread",1527],["thread",21998],["thread",901],["thread",19372],["thread",76430],["thread",67018],["thread",57259],["thread",129238],["thread",2513],["thread",1610],["thread",10268],["thread",12857],["thread",1924],["thread",76644],["thread",1838],["thread",2535],["thread",18817],["thread",68438],["thread",21941],["thread",98018],["thread",21628],["thread",1417],["thread",82236],["thread",83594],["thread",756],["thread",44318],["thread",21952],["thread",7518],["thread",90663],["thread",1967],["thread",21925],["thread",77214],["thread",20028],["thread",1830],["thread",52303],["thread",1416],["thread",5407],["thread",23947],["thread",957],["thread",61748],["thread",76227],["thread",61210],["thread",1120],["thread",2018],["thread",1138],["thread",117905],["thread",21980],["thread",75904],["thread",2089],["thread",20947],["thread",1263],["thread",21957],["thread",63058],["thread",109341],["thread",21946],["thread",955],["thread",82829],["thread",8381],["thread",109337],["thread",47953],["thread",3251],["thread",10834],["thread",76645],["thread",1933],["thread",2020],["thread",1528],["thread",129432],["thread",89935],["thread",75440],["thread",21913],["thread",21985],["thread",1301],["thread",10519],["thread",82663],["thread",76060],["thread",2490],["thread",113695],["thread",5511],["thread",112081],["thread",1422],["thread",24528],["thread",1934],["thread",25297],["thread",2026],["thread",7517],["thread",33604],["thread",2489],["thread",1517],["thread",48842],["thread",20943],["thread",133173],["thread",19531],["thread",83964],["thread",2087],["thread",8500],["thread",121218],["thread",23225],["thread",21984],["thread",20937]]
Run Time: 0.002180
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.000064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |