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 (62864, 114230, 135865, 132047, 106229, 131581, 129412, 100325, 133875, 89641, 35397, 97935, 135996, 86344, 131799, 117615, 79651, 129410, 97590, 108511, 132474, 132265, 131652, 122020, 109983, 91371, 72787, 133974, 81136, 67908, 75916, 64087, 62727, 110236, 126977, 132332, 108900, 125635, 87152, 86638, 64659, 115105, 86866, 77422, 132042, 52973, 68016, 104530, 108944, 126066, 75092, 95535, 109943, 129137, 74403, 135183, 96515, 133553, 103589, 131722, 133113, 126067, 103964, 112637, 87989, 116173, 82172, 132519, 75668, 76998, 115500, 132351, 80700, 116511, 98611, 65535, 130699, 87383, 46044, 115216, 130698, 72289, 119404, 64787, 97909, 68787, 133469, 45369, 127150, 132650, 116705, 133470, 71344, 96346, 133273, 129884, 66484, 133739, 48643, 121800, 132651, 52632, 81776, 106446, 97104, 103759, 110851, 133308, 79558, 115687, 61505, 130034, 105589, 61754, 104458, 132818, 116995, 88508, 71706, 130700, 98693, 123174, 49710, 130470, 86805, 132645, 132212, 68558, 89018, 135322, 109951, 123094, 82531, 45786, 97905, 121203, 104315, 77724, 131833, 89273, 117816, 90320, 120840, 115790, 133729, 97461, 127629, 55915, 126104, 104069, 89157, 127929, 39349, 66172, 72449, 117520, 105120, 103832, 64043, 62376, 94361, 35292, 73543, 84907, 103230, 126696, 124072, 86891, 105914, 109907, 11915, 82072, 82051, 125099, 110219, 129945, 114429, 66324, 75927, 99613, 67221, 97466, 133689, 127706, 76292, 104357, 70865, 114013, 86364, 67366, 133474, 130474, 110037, 67133, 51999, 95291, 66300, 76041, 66490, 104867, 133010, 62861, 103741, 51220, 131725, 111517, 111790, 102001, 46393, 130496, 128000, 66586, 81766, 133987, 86160, 103529, 90596, 97822, 72287, 86471, 83102, 120236, 100650, 88252, 56298, 117676, 70477, 102064, 85287, 67219, 60453, 61379, 61762, 104402, 67222, 86425, 38909, 133228, 96402, 132753, 98618, 115546, 53325, 46543, 123969, 114243, 48069, 131393, 133967, 76164, 81605, 119310, 133160, 89642, 98246, 132665, 84453, 130322, 75917, 130560, 47985, 92493, 88644, 89719, 130185, 47852, 86464, 135325, 105884, 86473, 83133, 88258, 116472, 131728, 105166, 134157, 126859, 66591, 132629, 129818, 88205, 81543, 130900, 116470, 117711, 122501, 33986, 91378, 82174, 133477, 67909, 121987, 77424, 132600, 104268, 132393, 72263, 47855, 53617, 105587)
Run Time: 0.014102
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: 8935, 0, 1711665853, 1711669453, [["thread",62864],["thread",114230],["thread",135865],["thread",132047],["thread",106229],["thread",131581],["thread",129412],["thread",100325],["thread",133875],["thread",89641],["thread",35397],["thread",97935],["thread",135996],["thread",86344],["thread",131799],["thread",117615],["thread",79651],["thread",129410],["thread",97590],["thread",108511],["thread",132474],["thread",132265],["thread",131652],["thread",122020],["thread",109983],["thread",91371],["thread",72787],["thread",133974],["thread",81136],["thread",67908],["thread",75916],["thread",64087],["thread",62727],["thread",110236],["thread",126977],["thread",132332],["thread",108900],["thread",125635],["thread",87152],["thread",86638],["thread",64659],["thread",115105],["thread",86866],["thread",77422],["thread",132042],["thread",52973],["thread",68016],["thread",104530],["thread",108944],["thread",126066],["thread",75092],["thread",95535],["thread",109943],["thread",129137],["thread",74403],["thread",135183],["thread",96515],["thread",133553],["thread",103589],["thread",131722],["thread",133113],["thread",126067],["thread",103964],["thread",112637],["thread",87989],["thread",116173],["thread",82172],["thread",132519],["thread",75668],["thread",76998],["thread",115500],["thread",132351],["thread",80700],["thread",116511],["thread",98611],["thread",65535],["thread",130699],["thread",87383],["thread",46044],["thread",115216],["thread",130698],["thread",72289],["thread",119404],["thread",64787],["thread",97909],["thread",68787],["thread",133469],["thread",45369],["thread",127150],["thread",132650],["thread",116705],["thread",133470],["thread",71344],["thread",96346],["thread",133273],["thread",129884],["thread",66484],["thread",133739],["thread",48643],["thread",121800],["thread",132651],["thread",52632],["thread",81776],["thread",106446],["thread",97104],["thread",103759],["thread",110851],["thread",133308],["thread",79558],["thread",115687],["thread",61505],["thread",130034],["thread",105589],["thread",61754],["thread",104458],["thread",132818],["thread",116995],["thread",88508],["thread",71706],["thread",130700],["thread",98693],["thread",123174],["thread",49710],["thread",130470],["thread",86805],["thread",132645],["thread",132212],["thread",68558],["thread",89018],["thread",135322],["thread",109951],["thread",123094],["thread",82531],["thread",45786],["thread",97905],["thread",121203],["thread",104315],["thread",77724],["thread",131833],["thread",89273],["thread",117816],["thread",90320],["thread",120840],["thread",115790],["thread",133729],["thread",97461],["thread",127629],["thread",55915],["thread",126104],["thread",104069],["thread",89157],["thread",127929],["thread",39349],["thread",66172],["thread",72449],["thread",117520],["thread",105120],["thread",103832],["thread",64043],["thread",62376],["thread",94361],["thread",35292],["thread",73543],["thread",84907],["thread",103230],["thread",126696],["thread",124072],["thread",86891],["thread",105914],["thread",109907],["thread",11915],["thread",82072],["thread",82051],["thread",125099],["thread",110219],["thread",129945],["thread",114429],["thread",66324],["thread",75927],["thread",99613],["thread",67221],["thread",97466],["thread",133689],["thread",127706],["thread",76292],["thread",104357],["thread",70865],["thread",114013],["thread",86364],["thread",67366],["thread",133474],["thread",130474],["thread",110037],["thread",67133],["thread",51999],["thread",95291],["thread",66300],["thread",76041],["thread",66490],["thread",104867],["thread",133010],["thread",62861],["thread",103741],["thread",51220],["thread",131725],["thread",111517],["thread",111790],["thread",102001],["thread",46393],["thread",130496],["thread",128000],["thread",66586],["thread",81766],["thread",133987],["thread",86160],["thread",103529],["thread",90596],["thread",97822],["thread",72287],["thread",86471],["thread",83102],["thread",120236],["thread",100650],["thread",88252],["thread",56298],["thread",117676],["thread",70477],["thread",102064],["thread",85287],["thread",67219],["thread",60453],["thread",61379],["thread",61762],["thread",104402],["thread",67222],["thread",86425],["thread",38909],["thread",133228],["thread",96402],["thread",132753],["thread",98618],["thread",115546],["thread",53325],["thread",46543],["thread",123969],["thread",114243],["thread",48069],["thread",131393],["thread",133967],["thread",76164],["thread",81605],["thread",119310],["thread",133160],["thread",89642],["thread",98246],["thread",132665],["thread",84453],["thread",130322],["thread",75917],["thread",130560],["thread",47985],["thread",92493],["thread",88644],["thread",89719],["thread",130185],["thread",47852],["thread",86464],["thread",135325],["thread",105884],["thread",86473],["thread",83133],["thread",88258],["thread",116472],["thread",131728],["thread",105166],["thread",134157],["thread",126859],["thread",66591],["thread",132629],["thread",129818],["thread",88205],["thread",81543],["thread",130900],["thread",116470],["thread",117711],["thread",122501],["thread",33986],["thread",91378],["thread",82174],["thread",133477],["thread",67909],["thread",121987],["thread",77424],["thread",132600],["thread",104268],["thread",132393],["thread",72263],["thread",47855],["thread",53617],["thread",105587]]
Run Time: 0.026191
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |