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 (127711, 134682, 135730, 131068, 131468, 45375, 136091, 132289, 135512, 132022, 128642, 128163, 136184, 124296, 132781, 131535, 131682, 137314, 132752, 134560, 128274, 110957, 132580, 129773, 38909, 51945, 133121, 122339, 125802, 134930, 67799, 130321, 134332, 131188, 115236, 133838, 132712, 135779, 132055, 131133, 129455, 132126, 135075, 86077, 122829, 131167, 106513, 130267, 129371, 123853, 49963, 68320, 131007, 137024, 64922, 134082, 129580, 133581, 135080, 135488, 135913, 65363, 130604, 131723, 135357, 133264, 130473, 49958, 130409, 79949, 135910, 123675, 136695, 130481, 127947, 129880, 110893, 132189, 69079, 106203, 134346, 136565, 131164, 130653, 131743, 132088, 133847, 132184, 135731, 131717, 128100, 127625, 133266, 136033, 132666, 134929, 130472, 70530, 132232, 131827, 121685, 130954, 130074, 536, 135513, 130351, 23168, 124929, 130994, 130748, 132794, 33847, 133025, 135921, 131012, 131453, 105820, 22987, 5788, 47363, 130881, 129954, 64817, 130463, 128922, 131265, 85379, 131454, 127743, 135866, 134927, 133603, 131853, 136985, 106588, 128174, 5466, 129183, 136020, 62383, 131626, 135264, 133323, 129784, 112584, 137211, 123152, 131456, 128697, 47154, 76110, 10861, 128423, 135774, 80869, 136106, 129948, 130133, 128829, 136343, 131619, 131919, 68831, 136812, 130485, 132500, 136489, 135145, 132438, 123883, 132578, 127981, 124551, 129491, 130447, 133388, 136825, 131093, 128364, 128628, 135295, 132735, 118476, 135934, 123215, 47274, 64468, 136717, 127847, 79168, 125341, 97908, 126492, 134811, 2279, 128999, 119657, 37489, 131571, 90746, 136481, 47241, 130750, 131483, 133904, 118405, 127609, 128330, 128369, 133583, 114381, 127916, 130587, 131788, 85740, 136491, 90046, 45000, 133380, 136921, 136789, 44653, 124480, 98056, 130495, 128363, 137051, 105592, 70517, 123677, 125221, 126197, 131635, 88080, 130556, 107803, 135855, 131800, 132072, 129361, 65361, 128379, 113790, 129716, 120899, 124134, 127800, 127737, 128603, 67902, 132782, 131649, 136955, 130349, 135482, 131684, 135079, 71281, 126546, 61951, 128436, 47561, 132544, 64273, 128720, 131826, 129212, 128098, 129202, 2278, 131939, 130108, 91227, 131132, 76315, 131735, 123941, 29793, 131572, 129296, 132917, 136002, 128840, 92188, 131104, 128581, 108663, 135276, 128509, 133293, 132185, 128325, 131690, 46196, 62738, 2269, 107801, 118532, 131262, 132071)
Run Time: 0.027750
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: 40, 0, 1715458897, 1715462497, [["thread",127711],["thread",134682],["thread",135730],["thread",131068],["thread",131468],["thread",45375],["thread",136091],["thread",132289],["thread",135512],["thread",132022],["thread",128642],["thread",128163],["thread",136184],["thread",124296],["thread",132781],["thread",131535],["thread",131682],["thread",137314],["thread",132752],["thread",134560],["thread",128274],["thread",110957],["thread",132580],["thread",129773],["thread",38909],["thread",51945],["thread",133121],["thread",122339],["thread",125802],["thread",134930],["thread",67799],["thread",130321],["thread",134332],["thread",131188],["thread",115236],["thread",133838],["thread",132712],["thread",135779],["thread",132055],["thread",131133],["thread",129455],["thread",132126],["thread",135075],["thread",86077],["thread",122829],["thread",131167],["thread",106513],["thread",130267],["thread",129371],["thread",123853],["thread",49963],["thread",68320],["thread",131007],["thread",137024],["thread",64922],["thread",134082],["thread",129580],["thread",133581],["thread",135080],["thread",135488],["thread",135913],["thread",65363],["thread",130604],["thread",131723],["thread",135357],["thread",133264],["thread",130473],["thread",49958],["thread",130409],["thread",79949],["thread",135910],["thread",123675],["thread",136695],["thread",130481],["thread",127947],["thread",129880],["thread",110893],["thread",132189],["thread",69079],["thread",106203],["thread",134346],["thread",136565],["thread",131164],["thread",130653],["thread",131743],["thread",132088],["thread",133847],["thread",132184],["thread",135731],["thread",131717],["thread",128100],["thread",127625],["thread",133266],["thread",136033],["thread",132666],["thread",134929],["thread",130472],["thread",70530],["thread",132232],["thread",131827],["thread",121685],["thread",130954],["thread",130074],["thread",536],["thread",135513],["thread",130351],["thread",23168],["thread",124929],["thread",130994],["thread",130748],["thread",132794],["thread",33847],["thread",133025],["thread",135921],["thread",131012],["thread",131453],["thread",105820],["thread",22987],["thread",5788],["thread",47363],["thread",130881],["thread",129954],["thread",64817],["thread",130463],["thread",128922],["thread",131265],["thread",85379],["thread",131454],["thread",127743],["thread",135866],["thread",134927],["thread",133603],["thread",131853],["thread",136985],["thread",106588],["thread",128174],["thread",5466],["thread",129183],["thread",136020],["thread",62383],["thread",131626],["thread",135264],["thread",133323],["thread",129784],["thread",112584],["thread",137211],["thread",123152],["thread",131456],["thread",128697],["thread",47154],["thread",76110],["thread",10861],["thread",128423],["thread",135774],["thread",80869],["thread",136106],["thread",129948],["thread",130133],["thread",128829],["thread",136343],["thread",131619],["thread",131919],["thread",68831],["thread",136812],["thread",130485],["thread",132500],["thread",136489],["thread",135145],["thread",132438],["thread",123883],["thread",132578],["thread",127981],["thread",124551],["thread",129491],["thread",130447],["thread",133388],["thread",136825],["thread",131093],["thread",128364],["thread",128628],["thread",135295],["thread",132735],["thread",118476],["thread",135934],["thread",123215],["thread",47274],["thread",64468],["thread",136717],["thread",127847],["thread",79168],["thread",125341],["thread",97908],["thread",126492],["thread",134811],["thread",2279],["thread",128999],["thread",119657],["thread",37489],["thread",131571],["thread",90746],["thread",136481],["thread",47241],["thread",130750],["thread",131483],["thread",133904],["thread",118405],["thread",127609],["thread",128330],["thread",128369],["thread",133583],["thread",114381],["thread",127916],["thread",130587],["thread",131788],["thread",85740],["thread",136491],["thread",90046],["thread",45000],["thread",133380],["thread",136921],["thread",136789],["thread",44653],["thread",124480],["thread",98056],["thread",130495],["thread",128363],["thread",137051],["thread",105592],["thread",70517],["thread",123677],["thread",125221],["thread",126197],["thread",131635],["thread",88080],["thread",130556],["thread",107803],["thread",135855],["thread",131800],["thread",132072],["thread",129361],["thread",65361],["thread",128379],["thread",113790],["thread",129716],["thread",120899],["thread",124134],["thread",127800],["thread",127737],["thread",128603],["thread",67902],["thread",132782],["thread",131649],["thread",136955],["thread",130349],["thread",135482],["thread",131684],["thread",135079],["thread",71281],["thread",126546],["thread",61951],["thread",128436],["thread",47561],["thread",132544],["thread",64273],["thread",128720],["thread",131826],["thread",129212],["thread",128098],["thread",129202],["thread",2278],["thread",131939],["thread",130108],["thread",91227],["thread",131132],["thread",76315],["thread",131735],["thread",123941],["thread",29793],["thread",131572],["thread",129296],["thread",132917],["thread",136002],["thread",128840],["thread",92188],["thread",131104],["thread",128581],["thread",108663],["thread",135276],["thread",128509],["thread",133293],["thread",132185],["thread",128325],["thread",131690],["thread",46196],["thread",62738],["thread",2269],["thread",107801],["thread",118532],["thread",131262],["thread",132071]]
Run Time: 0.088405
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.004143
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |