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 (135746, 132309, 63871, 134532, 110599, 110447, 115156, 80581, 121423, 118697, 128511, 87442, 113902, 127935, 134405, 133785, 133666, 122901, 135596, 116731, 122460, 125859, 78231, 81027, 119565, 130202, 80010, 75073, 117623, 118587, 107323, 136509, 69808, 136221, 123029, 121598, 70262, 114955, 133516, 129604, 136302, 88930, 67787, 127408, 66447, 126136, 116890, 135523, 135217, 130593, 86063, 130074, 121775, 135769, 134178, 116431, 112632, 109347, 127402, 111391, 97608, 113985, 61923, 62162, 130495, 74502, 104260, 110104, 129419, 65980, 136776, 122716, 123044, 109730, 129378, 134462, 111511, 44356, 112255, 118471, 121851, 98671, 115723, 123422, 81339, 134455, 75488, 134459, 69142, 103124, 134393, 135287, 113256, 136419, 134737, 61635, 111976, 134679, 133925, 129807, 125302, 121568, 118271, 76005, 125871, 65080, 134719, 110330, 123883, 131162, 58786, 66300, 108095, 128632, 84638, 34130, 100484, 120591, 85645, 112421, 123738, 116414, 97049, 101423, 133285, 35673, 119942, 135340, 34107, 61444, 126656, 135814, 134914, 132704, 87235, 135882, 32324, 66279, 76699, 73299, 67677, 72046, 106981, 130996, 109870, 132754, 125439, 132796, 121159, 88079, 48304, 115413, 124659, 128320, 63245, 119272, 130178, 75718, 132093, 91314, 99385, 127728, 136482, 70256, 134589, 131476, 61921, 112766, 127996, 120132, 132883, 94999, 136689, 69323, 118966, 78836, 136404, 115322, 86108, 131657, 131654, 134769, 135193, 126019, 98975, 112459, 127025, 108487, 87321, 118466, 60845, 135912, 74944, 100041, 126604, 82012, 102395, 136377, 135790, 132580, 89074, 117935, 86684, 129110, 131882, 119181, 135155, 90605, 69801, 78127, 134401, 111968, 34188, 132606, 118983, 55424, 111665, 125056, 84937, 124298, 112220, 70948, 134542, 132712, 135729, 12270, 128470, 125709, 132192, 82377, 136446, 97454, 122771, 68535, 84132, 131653, 121458, 45099, 133714, 120500, 101968, 132524, 76078, 133503, 110544, 48217, 133775, 61811, 124903, 54790, 131046, 131274, 108628, 130431, 123929, 129590, 128338, 131539, 123014, 78477, 112514, 136781, 91609, 134511, 55699, 106717, 134912, 113759, 132276, 108718, 30247, 64276, 131429, 134975, 48673, 135229, 131457, 89910, 105870, 120462, 93603, 109942, 121769, 113498, 117487, 82369, 127170, 133732, 124368, 131796, 126336, 85713, 116324, 118220, 131804, 77687, 121137, 134233, 69343, 114124)
Run Time: 0.013358
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: 1671, 0, 1714043297, 1714046897, [["thread",135746],["thread",132309],["thread",63871],["thread",134532],["thread",110599],["thread",110447],["thread",115156],["thread",80581],["thread",121423],["thread",118697],["thread",128511],["thread",87442],["thread",113902],["thread",127935],["thread",134405],["thread",133785],["thread",133666],["thread",122901],["thread",135596],["thread",116731],["thread",122460],["thread",125859],["thread",78231],["thread",81027],["thread",119565],["thread",130202],["thread",80010],["thread",75073],["thread",117623],["thread",118587],["thread",107323],["thread",136509],["thread",69808],["thread",136221],["thread",123029],["thread",121598],["thread",70262],["thread",114955],["thread",133516],["thread",129604],["thread",136302],["thread",88930],["thread",67787],["thread",127408],["thread",66447],["thread",126136],["thread",116890],["thread",135523],["thread",135217],["thread",130593],["thread",86063],["thread",130074],["thread",121775],["thread",135769],["thread",134178],["thread",116431],["thread",112632],["thread",109347],["thread",127402],["thread",111391],["thread",97608],["thread",113985],["thread",61923],["thread",62162],["thread",130495],["thread",74502],["thread",104260],["thread",110104],["thread",129419],["thread",65980],["thread",136776],["thread",122716],["thread",123044],["thread",109730],["thread",129378],["thread",134462],["thread",111511],["thread",44356],["thread",112255],["thread",118471],["thread",121851],["thread",98671],["thread",115723],["thread",123422],["thread",81339],["thread",134455],["thread",75488],["thread",134459],["thread",69142],["thread",103124],["thread",134393],["thread",135287],["thread",113256],["thread",136419],["thread",134737],["thread",61635],["thread",111976],["thread",134679],["thread",133925],["thread",129807],["thread",125302],["thread",121568],["thread",118271],["thread",76005],["thread",125871],["thread",65080],["thread",134719],["thread",110330],["thread",123883],["thread",131162],["thread",58786],["thread",66300],["thread",108095],["thread",128632],["thread",84638],["thread",34130],["thread",100484],["thread",120591],["thread",85645],["thread",112421],["thread",123738],["thread",116414],["thread",97049],["thread",101423],["thread",133285],["thread",35673],["thread",119942],["thread",135340],["thread",34107],["thread",61444],["thread",126656],["thread",135814],["thread",134914],["thread",132704],["thread",87235],["thread",135882],["thread",32324],["thread",66279],["thread",76699],["thread",73299],["thread",67677],["thread",72046],["thread",106981],["thread",130996],["thread",109870],["thread",132754],["thread",125439],["thread",132796],["thread",121159],["thread",88079],["thread",48304],["thread",115413],["thread",124659],["thread",128320],["thread",63245],["thread",119272],["thread",130178],["thread",75718],["thread",132093],["thread",91314],["thread",99385],["thread",127728],["thread",136482],["thread",70256],["thread",134589],["thread",131476],["thread",61921],["thread",112766],["thread",127996],["thread",120132],["thread",132883],["thread",94999],["thread",136689],["thread",69323],["thread",118966],["thread",78836],["thread",136404],["thread",115322],["thread",86108],["thread",131657],["thread",131654],["thread",134769],["thread",135193],["thread",126019],["thread",98975],["thread",112459],["thread",127025],["thread",108487],["thread",87321],["thread",118466],["thread",60845],["thread",135912],["thread",74944],["thread",100041],["thread",126604],["thread",82012],["thread",102395],["thread",136377],["thread",135790],["thread",132580],["thread",89074],["thread",117935],["thread",86684],["thread",129110],["thread",131882],["thread",119181],["thread",135155],["thread",90605],["thread",69801],["thread",78127],["thread",134401],["thread",111968],["thread",34188],["thread",132606],["thread",118983],["thread",55424],["thread",111665],["thread",125056],["thread",84937],["thread",124298],["thread",112220],["thread",70948],["thread",134542],["thread",132712],["thread",135729],["thread",12270],["thread",128470],["thread",125709],["thread",132192],["thread",82377],["thread",136446],["thread",97454],["thread",122771],["thread",68535],["thread",84132],["thread",131653],["thread",121458],["thread",45099],["thread",133714],["thread",120500],["thread",101968],["thread",132524],["thread",76078],["thread",133503],["thread",110544],["thread",48217],["thread",133775],["thread",61811],["thread",124903],["thread",54790],["thread",131046],["thread",131274],["thread",108628],["thread",130431],["thread",123929],["thread",129590],["thread",128338],["thread",131539],["thread",123014],["thread",78477],["thread",112514],["thread",136781],["thread",91609],["thread",134511],["thread",55699],["thread",106717],["thread",134912],["thread",113759],["thread",132276],["thread",108718],["thread",30247],["thread",64276],["thread",131429],["thread",134975],["thread",48673],["thread",135229],["thread",131457],["thread",89910],["thread",105870],["thread",120462],["thread",93603],["thread",109942],["thread",121769],["thread",113498],["thread",117487],["thread",82369],["thread",127170],["thread",133732],["thread",124368],["thread",131796],["thread",126336],["thread",85713],["thread",116324],["thread",118220],["thread",131804],["thread",77687],["thread",121137],["thread",134233],["thread",69343],["thread",114124]]
Run Time: 0.013555
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |