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 (127496, 131108, 137154, 135387, 134244, 135700, 134351, 133423, 117838, 136442, 135841, 132035, 136224, 137211, 133707, 135547, 137015, 132316, 129258, 133691, 129916, 129243, 131570, 136595, 111094, 134321, 131869, 125428, 134457, 135126, 133563, 128582, 135955, 134888, 134639, 131101, 132659, 137271, 128227, 127625, 129139, 134005, 129645, 136810, 134211, 135262, 81200, 135591, 133305, 132317, 137146, 134852, 129193, 129295, 117040, 130423, 135769, 136177, 136570, 61292, 128135, 111525, 131692, 133610, 133280, 133918, 132372, 136348, 134627, 130971, 132025, 136973, 135582, 133446, 121240, 133490, 135174, 136902, 129293, 135682, 132851, 137115, 111242, 136404, 134483, 115062, 134761, 133952, 136750, 105210, 122339, 136398, 135872, 113930, 133987, 134323, 135780, 131786, 129417, 133422, 134511, 134053, 135121, 134613, 124119, 133308, 119546, 133847, 135898, 132954, 122001, 133478, 129412, 131907, 133164, 136191, 134028, 130475, 135390, 136272, 133459, 130680, 137312, 133342, 132394, 134082, 135954, 122094, 136799, 137290, 136974, 132733, 134837, 135369, 133000, 133143, 129773, 136645, 131781, 136548, 132048, 111397, 136705, 126576, 133144, 136083, 136344, 133323, 132988, 113834, 132571, 132476, 133793, 129528, 135385, 114662, 133389, 136217, 133325, 134290, 136593, 134515, 133645, 129003, 135589, 135553, 132036, 124026, 136088, 133137, 137033, 132588, 133842, 136028, 133746, 132647, 131451, 136096, 136725, 131267, 133578, 134313, 119448, 132318, 137092, 134799, 126154, 132314, 136074, 133522, 133974, 125635, 137100, 134488, 133362, 126535, 127706, 129286, 87240, 136489, 135646, 129013, 115498, 114202, 136070, 96065, 128329, 113872, 115786, 127993, 115261, 136343, 132649, 120896, 133965, 115437, 136834, 129270, 70865, 108903, 136125, 135800, 128904, 134421, 133361, 136112, 133194, 133810, 134120, 116291, 135417, 134350, 133859, 128383, 136981, 137284, 130322, 136218, 136926, 133458, 135656, 128595, 120191, 136915, 133476, 136481, 135031, 134811, 124515, 135003, 137245, 124963, 136047, 128466, 134404, 136130, 132584, 130797, 136004, 134506, 130929, 133740, 135068, 133689, 135837, 123773, 135934, 133562, 108890, 132482, 134760, 128047, 133367, 130295, 133976, 131946, 135202, 134702, 61293, 134954, 134854, 64490, 130457, 135329, 133344, 136572, 136566, 129137, 132443, 134132, 132475, 133464, 134102, 135317, 129246, 135361, 110082, 132600, 134931, 133876)
Run Time: 0.023712
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: 11748, 0, 1715480842, 1715484442, [["thread",127496],["thread",131108],["thread",137154],["thread",135387],["thread",134244],["thread",135700],["thread",134351],["thread",133423],["thread",117838],["thread",136442],["thread",135841],["thread",132035],["thread",136224],["thread",137211],["thread",133707],["thread",135547],["thread",137015],["thread",132316],["thread",129258],["thread",133691],["thread",129916],["thread",129243],["thread",131570],["thread",136595],["thread",111094],["thread",134321],["thread",131869],["thread",125428],["thread",134457],["thread",135126],["thread",133563],["thread",128582],["thread",135955],["thread",134888],["thread",134639],["thread",131101],["thread",132659],["thread",137271],["thread",128227],["thread",127625],["thread",129139],["thread",134005],["thread",129645],["thread",136810],["thread",134211],["thread",135262],["thread",81200],["thread",135591],["thread",133305],["thread",132317],["thread",137146],["thread",134852],["thread",129193],["thread",129295],["thread",117040],["thread",130423],["thread",135769],["thread",136177],["thread",136570],["thread",61292],["thread",128135],["thread",111525],["thread",131692],["thread",133610],["thread",133280],["thread",133918],["thread",132372],["thread",136348],["thread",134627],["thread",130971],["thread",132025],["thread",136973],["thread",135582],["thread",133446],["thread",121240],["thread",133490],["thread",135174],["thread",136902],["thread",129293],["thread",135682],["thread",132851],["thread",137115],["thread",111242],["thread",136404],["thread",134483],["thread",115062],["thread",134761],["thread",133952],["thread",136750],["thread",105210],["thread",122339],["thread",136398],["thread",135872],["thread",113930],["thread",133987],["thread",134323],["thread",135780],["thread",131786],["thread",129417],["thread",133422],["thread",134511],["thread",134053],["thread",135121],["thread",134613],["thread",124119],["thread",133308],["thread",119546],["thread",133847],["thread",135898],["thread",132954],["thread",122001],["thread",133478],["thread",129412],["thread",131907],["thread",133164],["thread",136191],["thread",134028],["thread",130475],["thread",135390],["thread",136272],["thread",133459],["thread",130680],["thread",137312],["thread",133342],["thread",132394],["thread",134082],["thread",135954],["thread",122094],["thread",136799],["thread",137290],["thread",136974],["thread",132733],["thread",134837],["thread",135369],["thread",133000],["thread",133143],["thread",129773],["thread",136645],["thread",131781],["thread",136548],["thread",132048],["thread",111397],["thread",136705],["thread",126576],["thread",133144],["thread",136083],["thread",136344],["thread",133323],["thread",132988],["thread",113834],["thread",132571],["thread",132476],["thread",133793],["thread",129528],["thread",135385],["thread",114662],["thread",133389],["thread",136217],["thread",133325],["thread",134290],["thread",136593],["thread",134515],["thread",133645],["thread",129003],["thread",135589],["thread",135553],["thread",132036],["thread",124026],["thread",136088],["thread",133137],["thread",137033],["thread",132588],["thread",133842],["thread",136028],["thread",133746],["thread",132647],["thread",131451],["thread",136096],["thread",136725],["thread",131267],["thread",133578],["thread",134313],["thread",119448],["thread",132318],["thread",137092],["thread",134799],["thread",126154],["thread",132314],["thread",136074],["thread",133522],["thread",133974],["thread",125635],["thread",137100],["thread",134488],["thread",133362],["thread",126535],["thread",127706],["thread",129286],["thread",87240],["thread",136489],["thread",135646],["thread",129013],["thread",115498],["thread",114202],["thread",136070],["thread",96065],["thread",128329],["thread",113872],["thread",115786],["thread",127993],["thread",115261],["thread",136343],["thread",132649],["thread",120896],["thread",133965],["thread",115437],["thread",136834],["thread",129270],["thread",70865],["thread",108903],["thread",136125],["thread",135800],["thread",128904],["thread",134421],["thread",133361],["thread",136112],["thread",133194],["thread",133810],["thread",134120],["thread",116291],["thread",135417],["thread",134350],["thread",133859],["thread",128383],["thread",136981],["thread",137284],["thread",130322],["thread",136218],["thread",136926],["thread",133458],["thread",135656],["thread",128595],["thread",120191],["thread",136915],["thread",133476],["thread",136481],["thread",135031],["thread",134811],["thread",124515],["thread",135003],["thread",137245],["thread",124963],["thread",136047],["thread",128466],["thread",134404],["thread",136130],["thread",132584],["thread",130797],["thread",136004],["thread",134506],["thread",130929],["thread",133740],["thread",135068],["thread",133689],["thread",135837],["thread",123773],["thread",135934],["thread",133562],["thread",108890],["thread",132482],["thread",134760],["thread",128047],["thread",133367],["thread",130295],["thread",133976],["thread",131946],["thread",135202],["thread",134702],["thread",61293],["thread",134954],["thread",134854],["thread",64490],["thread",130457],["thread",135329],["thread",133344],["thread",136572],["thread",136566],["thread",129137],["thread",132443],["thread",134132],["thread",132475],["thread",133464],["thread",134102],["thread",135317],["thread",129246],["thread",135361],["thread",110082],["thread",132600],["thread",134931],["thread",133876]]
Run Time: 0.105741
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.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |