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 (100204, 122248, 100236, 124796, 127738, 133029, 89378, 89081, 100242, 122789, 105095, 101087, 119011, 130768, 95451, 98042, 128196, 108152, 98503, 108817, 104983, 133447, 121293, 128557, 117649, 106277, 104160, 106057, 108935, 75040, 96016, 104214, 80263, 98623, 132061, 134231, 111434, 133884, 66800, 100320, 123981, 127495, 101398, 106870, 93334, 127400, 124251, 103931, 99963, 124800, 129039, 116584, 121484, 132742, 100374, 128751, 110006, 89123, 100622, 128938, 130852, 121879, 104253, 126938, 128137, 107984, 106772, 96209, 73417, 85609, 96188, 120675, 105410, 129706, 96506, 92167, 109328, 88550, 101124, 104762, 128633, 91758, 128173, 94726, 103221, 95354, 107656, 127846, 103154, 95771, 98292, 100518, 95522, 127469, 128404, 109297, 102193, 103018, 99727, 121583, 128643, 129971, 96181, 92090, 91119, 92542, 122560, 107910, 103660, 94000, 89737, 101967, 95855, 98688, 101396, 95025, 103681, 109419, 127688, 77835, 102177, 134545, 100760, 101274, 128182, 77710, 95941, 91823, 97319, 96094, 129036, 122013, 96759, 105562, 95636, 132423, 129441, 96941, 104346, 109257, 96210, 108357, 76337, 99487, 103622, 94908, 132290, 99188, 90466, 102912, 133830, 93426, 102237, 106714, 108642, 103192, 116824, 128604, 108312, 103872, 128671, 105342, 122204, 129462, 121923, 134621, 124144, 94576, 127914, 127623, 115798, 133173, 121796, 105617, 105847, 103313, 128434, 100328, 98962, 118812, 116781, 95119, 104486, 127543, 118324, 99682, 109990, 119373, 131430, 103428, 116866, 124149, 122130, 106930, 97887, 108667, 85060, 97777, 106220, 73409, 103199, 98797, 128979, 129445, 90331, 97149, 108371, 96764, 119360, 96997, 127478, 132251, 104094, 122900, 106965, 124746, 69918, 97239, 131103, 95512, 89039, 101051, 102336, 122306, 97405, 136696, 103490, 95873, 102385, 134270, 107419, 128121, 106094, 103717, 106354, 123137, 104274, 130831, 127980, 124826, 132979, 73711, 107692, 118015, 129201, 98811, 99781, 125827, 107087, 135353, 101241, 130536, 128796, 94357, 107144, 93251, 123494, 89277, 101786, 99417, 121930, 117752, 136718, 127659, 107718, 104894, 115435, 126676, 104761, 128893, 107326, 128487, 117753, 104103, 96652, 114801, 118075, 130932, 102547, 92631, 93708, 96462, 136055, 102037, 93066, 127945, 120783, 95718, 107880, 127504, 92859, 132275, 136447, 126683, 115220, 99018, 119571, 118947, 105845, 93120)
Run Time: 0.029385
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: 13904, 0, 1714109661, 1714113261, [["thread",100204],["thread",122248],["thread",100236],["thread",124796],["thread",127738],["thread",133029],["thread",89378],["thread",89081],["thread",100242],["thread",122789],["thread",105095],["thread",101087],["thread",119011],["thread",130768],["thread",95451],["thread",98042],["thread",128196],["thread",108152],["thread",98503],["thread",108817],["thread",104983],["thread",133447],["thread",121293],["thread",128557],["thread",117649],["thread",106277],["thread",104160],["thread",106057],["thread",108935],["thread",75040],["thread",96016],["thread",104214],["thread",80263],["thread",98623],["thread",132061],["thread",134231],["thread",111434],["thread",133884],["thread",66800],["thread",100320],["thread",123981],["thread",127495],["thread",101398],["thread",106870],["thread",93334],["thread",127400],["thread",124251],["thread",103931],["thread",99963],["thread",124800],["thread",129039],["thread",116584],["thread",121484],["thread",132742],["thread",100374],["thread",128751],["thread",110006],["thread",89123],["thread",100622],["thread",128938],["thread",130852],["thread",121879],["thread",104253],["thread",126938],["thread",128137],["thread",107984],["thread",106772],["thread",96209],["thread",73417],["thread",85609],["thread",96188],["thread",120675],["thread",105410],["thread",129706],["thread",96506],["thread",92167],["thread",109328],["thread",88550],["thread",101124],["thread",104762],["thread",128633],["thread",91758],["thread",128173],["thread",94726],["thread",103221],["thread",95354],["thread",107656],["thread",127846],["thread",103154],["thread",95771],["thread",98292],["thread",100518],["thread",95522],["thread",127469],["thread",128404],["thread",109297],["thread",102193],["thread",103018],["thread",99727],["thread",121583],["thread",128643],["thread",129971],["thread",96181],["thread",92090],["thread",91119],["thread",92542],["thread",122560],["thread",107910],["thread",103660],["thread",94000],["thread",89737],["thread",101967],["thread",95855],["thread",98688],["thread",101396],["thread",95025],["thread",103681],["thread",109419],["thread",127688],["thread",77835],["thread",102177],["thread",134545],["thread",100760],["thread",101274],["thread",128182],["thread",77710],["thread",95941],["thread",91823],["thread",97319],["thread",96094],["thread",129036],["thread",122013],["thread",96759],["thread",105562],["thread",95636],["thread",132423],["thread",129441],["thread",96941],["thread",104346],["thread",109257],["thread",96210],["thread",108357],["thread",76337],["thread",99487],["thread",103622],["thread",94908],["thread",132290],["thread",99188],["thread",90466],["thread",102912],["thread",133830],["thread",93426],["thread",102237],["thread",106714],["thread",108642],["thread",103192],["thread",116824],["thread",128604],["thread",108312],["thread",103872],["thread",128671],["thread",105342],["thread",122204],["thread",129462],["thread",121923],["thread",134621],["thread",124144],["thread",94576],["thread",127914],["thread",127623],["thread",115798],["thread",133173],["thread",121796],["thread",105617],["thread",105847],["thread",103313],["thread",128434],["thread",100328],["thread",98962],["thread",118812],["thread",116781],["thread",95119],["thread",104486],["thread",127543],["thread",118324],["thread",99682],["thread",109990],["thread",119373],["thread",131430],["thread",103428],["thread",116866],["thread",124149],["thread",122130],["thread",106930],["thread",97887],["thread",108667],["thread",85060],["thread",97777],["thread",106220],["thread",73409],["thread",103199],["thread",98797],["thread",128979],["thread",129445],["thread",90331],["thread",97149],["thread",108371],["thread",96764],["thread",119360],["thread",96997],["thread",127478],["thread",132251],["thread",104094],["thread",122900],["thread",106965],["thread",124746],["thread",69918],["thread",97239],["thread",131103],["thread",95512],["thread",89039],["thread",101051],["thread",102336],["thread",122306],["thread",97405],["thread",136696],["thread",103490],["thread",95873],["thread",102385],["thread",134270],["thread",107419],["thread",128121],["thread",106094],["thread",103717],["thread",106354],["thread",123137],["thread",104274],["thread",130831],["thread",127980],["thread",124826],["thread",132979],["thread",73711],["thread",107692],["thread",118015],["thread",129201],["thread",98811],["thread",99781],["thread",125827],["thread",107087],["thread",135353],["thread",101241],["thread",130536],["thread",128796],["thread",94357],["thread",107144],["thread",93251],["thread",123494],["thread",89277],["thread",101786],["thread",99417],["thread",121930],["thread",117752],["thread",136718],["thread",127659],["thread",107718],["thread",104894],["thread",115435],["thread",126676],["thread",104761],["thread",128893],["thread",107326],["thread",128487],["thread",117753],["thread",104103],["thread",96652],["thread",114801],["thread",118075],["thread",130932],["thread",102547],["thread",92631],["thread",93708],["thread",96462],["thread",136055],["thread",102037],["thread",93066],["thread",127945],["thread",120783],["thread",95718],["thread",107880],["thread",127504],["thread",92859],["thread",132275],["thread",136447],["thread",126683],["thread",115220],["thread",99018],["thread",119571],["thread",118947],["thread",105845],["thread",93120]]
Run Time: 0.001629
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.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |