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 (134373, 77816, 132219, 117426, 111361, 60180, 135789, 69808, 84715, 120462, 105208, 130975, 80842, 100453, 131167, 135274, 101228, 25915, 84638, 132077, 130813, 135563, 136028, 106779, 119596, 134223, 125408, 63666, 121067, 130486, 135855, 118907, 117046, 20752, 100215, 121177, 134888, 76559, 136834, 127528, 132930, 133488, 136410, 134571, 133223, 111134, 114118, 113571, 92344, 128421, 123907, 126899, 102420, 108063, 126181, 68642, 82758, 97404, 133613, 117416, 97311, 121546, 62162, 134228, 110756, 51945, 129871, 130090, 62093, 65883, 77678, 135777, 96610, 120433, 114756, 131275, 66024, 116855, 128630, 86549, 134702, 119858, 124408, 122336, 122632, 135535, 126522, 132691, 100550, 78562, 61912, 24430, 51133, 56105, 80970, 129998, 66683, 75340, 120557, 136723, 133957, 83554, 30271, 119751, 117406, 85411, 120162, 117333, 76651, 130200, 131041, 29815, 80126, 70725, 84817, 68807, 123142, 120752, 134957, 133392, 120016, 133763, 117464, 130874, 99871, 64284, 134827, 100737, 69579, 62766, 123046, 34333, 109573, 83647, 17897, 127283, 118480, 132504, 114726, 64208, 113024, 117044, 124214, 103758, 121270, 119531, 122697, 131240, 137266, 119069, 133809, 125871, 129426, 120064, 97105, 128316, 103810, 135270, 135576, 68410, 61765, 118436, 60238, 135320, 135301, 132468, 132704, 120676, 133143, 96137, 132269, 55699, 112643, 137077, 51220, 73543, 65364, 132268, 132291, 24850, 132604, 120807, 46305, 136273, 132292, 87321, 130990, 91833, 100479, 73462, 90320, 113865, 101881, 136239, 43726, 98550, 118727, 131607, 80036, 134920, 98855, 108769, 128108, 117021, 133367, 119836, 90923, 77728, 77660, 109409, 116738, 135144, 127530, 117279, 132822, 94892, 118876, 122698, 85339, 134163, 112421, 84704, 132267, 85911, 123242, 120034, 75535, 120897, 76330, 131543, 85004, 93585, 72548, 118715, 99089, 102230, 60770, 137122, 69584, 135420, 131645, 136980, 135286, 122557, 76446, 88930, 103706, 132006, 74865, 124960, 98998, 33847, 106913, 96855, 113256, 96420, 101239, 91132, 77369, 58241, 75823, 78334, 124279, 125979, 126427, 122618, 58023, 136684, 79168, 120696, 134586, 99655, 32324, 107660, 120058, 131114, 108537, 57138, 97470, 108753, 106646, 134783, 136045, 128470, 134257, 77386, 137113, 137282, 132421, 63274, 137159, 125387, 110917, 74181, 122770, 72806, 129111, 67793, 133052, 131162)
Run Time: 0.076076
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, 1715504585, 1715508185, [["thread",134373],["thread",77816],["thread",132219],["thread",117426],["thread",111361],["thread",60180],["thread",135789],["thread",69808],["thread",84715],["thread",120462],["thread",105208],["thread",130975],["thread",80842],["thread",100453],["thread",131167],["thread",135274],["thread",101228],["thread",25915],["thread",84638],["thread",132077],["thread",130813],["thread",135563],["thread",136028],["thread",106779],["thread",119596],["thread",134223],["thread",125408],["thread",63666],["thread",121067],["thread",130486],["thread",135855],["thread",118907],["thread",117046],["thread",20752],["thread",100215],["thread",121177],["thread",134888],["thread",76559],["thread",136834],["thread",127528],["thread",132930],["thread",133488],["thread",136410],["thread",134571],["thread",133223],["thread",111134],["thread",114118],["thread",113571],["thread",92344],["thread",128421],["thread",123907],["thread",126899],["thread",102420],["thread",108063],["thread",126181],["thread",68642],["thread",82758],["thread",97404],["thread",133613],["thread",117416],["thread",97311],["thread",121546],["thread",62162],["thread",134228],["thread",110756],["thread",51945],["thread",129871],["thread",130090],["thread",62093],["thread",65883],["thread",77678],["thread",135777],["thread",96610],["thread",120433],["thread",114756],["thread",131275],["thread",66024],["thread",116855],["thread",128630],["thread",86549],["thread",134702],["thread",119858],["thread",124408],["thread",122336],["thread",122632],["thread",135535],["thread",126522],["thread",132691],["thread",100550],["thread",78562],["thread",61912],["thread",24430],["thread",51133],["thread",56105],["thread",80970],["thread",129998],["thread",66683],["thread",75340],["thread",120557],["thread",136723],["thread",133957],["thread",83554],["thread",30271],["thread",119751],["thread",117406],["thread",85411],["thread",120162],["thread",117333],["thread",76651],["thread",130200],["thread",131041],["thread",29815],["thread",80126],["thread",70725],["thread",84817],["thread",68807],["thread",123142],["thread",120752],["thread",134957],["thread",133392],["thread",120016],["thread",133763],["thread",117464],["thread",130874],["thread",99871],["thread",64284],["thread",134827],["thread",100737],["thread",69579],["thread",62766],["thread",123046],["thread",34333],["thread",109573],["thread",83647],["thread",17897],["thread",127283],["thread",118480],["thread",132504],["thread",114726],["thread",64208],["thread",113024],["thread",117044],["thread",124214],["thread",103758],["thread",121270],["thread",119531],["thread",122697],["thread",131240],["thread",137266],["thread",119069],["thread",133809],["thread",125871],["thread",129426],["thread",120064],["thread",97105],["thread",128316],["thread",103810],["thread",135270],["thread",135576],["thread",68410],["thread",61765],["thread",118436],["thread",60238],["thread",135320],["thread",135301],["thread",132468],["thread",132704],["thread",120676],["thread",133143],["thread",96137],["thread",132269],["thread",55699],["thread",112643],["thread",137077],["thread",51220],["thread",73543],["thread",65364],["thread",132268],["thread",132291],["thread",24850],["thread",132604],["thread",120807],["thread",46305],["thread",136273],["thread",132292],["thread",87321],["thread",130990],["thread",91833],["thread",100479],["thread",73462],["thread",90320],["thread",113865],["thread",101881],["thread",136239],["thread",43726],["thread",98550],["thread",118727],["thread",131607],["thread",80036],["thread",134920],["thread",98855],["thread",108769],["thread",128108],["thread",117021],["thread",133367],["thread",119836],["thread",90923],["thread",77728],["thread",77660],["thread",109409],["thread",116738],["thread",135144],["thread",127530],["thread",117279],["thread",132822],["thread",94892],["thread",118876],["thread",122698],["thread",85339],["thread",134163],["thread",112421],["thread",84704],["thread",132267],["thread",85911],["thread",123242],["thread",120034],["thread",75535],["thread",120897],["thread",76330],["thread",131543],["thread",85004],["thread",93585],["thread",72548],["thread",118715],["thread",99089],["thread",102230],["thread",60770],["thread",137122],["thread",69584],["thread",135420],["thread",131645],["thread",136980],["thread",135286],["thread",122557],["thread",76446],["thread",88930],["thread",103706],["thread",132006],["thread",74865],["thread",124960],["thread",98998],["thread",33847],["thread",106913],["thread",96855],["thread",113256],["thread",96420],["thread",101239],["thread",91132],["thread",77369],["thread",58241],["thread",75823],["thread",78334],["thread",124279],["thread",125979],["thread",126427],["thread",122618],["thread",58023],["thread",136684],["thread",79168],["thread",120696],["thread",134586],["thread",99655],["thread",32324],["thread",107660],["thread",120058],["thread",131114],["thread",108537],["thread",57138],["thread",97470],["thread",108753],["thread",106646],["thread",134783],["thread",136045],["thread",128470],["thread",134257],["thread",77386],["thread",137113],["thread",137282],["thread",132421],["thread",63274],["thread",137159],["thread",125387],["thread",110917],["thread",74181],["thread",122770],["thread",72806],["thread",129111],["thread",67793],["thread",133052],["thread",131162]]
Run Time: 0.033612
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 |