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 (117862, 119832, 76164, 112303, 129274, 72691, 134278, 132096, 110696, 110353, 121059, 130389, 130891, 116100, 115210, 113526, 114184, 128267, 132060, 103808, 118986, 115332, 128568, 119284, 130530, 57715, 113946, 120714, 86344, 124585, 115991, 114713, 108264, 106426, 116000, 121758, 116197, 111690, 103636, 122376, 133671, 113025, 127373, 116264, 121712, 134728, 133518, 124636, 113557, 137019, 132193, 119668, 109608, 117644, 112766, 127129, 107554, 78113, 120066, 128994, 120579, 126526, 119978, 118870, 124276, 115394, 112229, 124450, 127694, 132691, 122606, 109847, 86158, 130711, 68612, 87256, 120890, 103950, 116311, 122014, 129635, 104535, 47505, 110368, 108093, 113363, 130093, 120394, 113855, 126762, 104348, 132708, 130269, 112644, 115852, 112600, 122273, 106357, 106337, 129434, 126988, 112459, 22283, 106904, 120525, 125613, 123417, 136221, 124456, 135566, 116813, 87652, 76666, 123094, 136232, 110881, 86814, 132509, 82406, 134862, 134478, 116388, 127337, 106698, 128609, 122447, 130906, 135159, 123671, 46647, 133146, 123909, 102243, 76037, 122906, 112588, 71170, 107977, 114177, 135661, 116505, 127624, 116553, 131409, 110042, 64172, 107034, 118994, 95018, 81138, 105970, 122040, 129502, 119801, 81308, 108578, 104759, 65754, 123843, 119116, 123606, 46116, 89471, 112466, 130736, 125325, 114185, 77302, 64566, 123046, 119734, 114997, 115588, 126201, 122548, 46972, 110700, 135499, 127101, 115076, 124936, 129204, 114490, 103762, 137043, 115293, 123641, 135169, 120307, 119834, 118755, 118857, 125779, 48831, 120360, 50314, 118758, 105634, 121166, 76545, 113574, 115054, 115558, 126497, 129472, 113857, 116121, 125964, 115327, 113281, 119778, 122760, 135745, 88400, 108002, 124888, 107677, 126573, 114984, 130046, 50627, 131000, 117271, 107177, 51346, 136689, 115836, 110005, 107397, 123216, 104579, 115937, 109747, 120626, 120513, 125350, 77723, 129151, 112576, 129838, 122088, 136288, 50893, 124399, 119667, 87508, 128933, 100463, 131881, 119465, 116976, 132754, 118366, 115595, 47395, 125876, 118277, 124162, 130845, 66321, 123091, 117870, 120871, 120807, 113962, 104507, 116350, 136800, 116663, 132772, 104296, 78393, 49106, 125984, 114937, 130666, 132558, 115957, 107561, 114836, 123299, 123661, 105434, 81873, 116948, 120827, 112694, 129313, 132408, 108727, 120671, 134075, 125682, 130123, 106282, 118680, 130749, 108473, 123026, 112396)
Run Time: 0.005520
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: 34, 0, 1715377688, 1715381288, [["thread",117862],["thread",119832],["thread",76164],["thread",112303],["thread",129274],["thread",72691],["thread",134278],["thread",132096],["thread",110696],["thread",110353],["thread",121059],["thread",130389],["thread",130891],["thread",116100],["thread",115210],["thread",113526],["thread",114184],["thread",128267],["thread",132060],["thread",103808],["thread",118986],["thread",115332],["thread",128568],["thread",119284],["thread",130530],["thread",57715],["thread",113946],["thread",120714],["thread",86344],["thread",124585],["thread",115991],["thread",114713],["thread",108264],["thread",106426],["thread",116000],["thread",121758],["thread",116197],["thread",111690],["thread",103636],["thread",122376],["thread",133671],["thread",113025],["thread",127373],["thread",116264],["thread",121712],["thread",134728],["thread",133518],["thread",124636],["thread",113557],["thread",137019],["thread",132193],["thread",119668],["thread",109608],["thread",117644],["thread",112766],["thread",127129],["thread",107554],["thread",78113],["thread",120066],["thread",128994],["thread",120579],["thread",126526],["thread",119978],["thread",118870],["thread",124276],["thread",115394],["thread",112229],["thread",124450],["thread",127694],["thread",132691],["thread",122606],["thread",109847],["thread",86158],["thread",130711],["thread",68612],["thread",87256],["thread",120890],["thread",103950],["thread",116311],["thread",122014],["thread",129635],["thread",104535],["thread",47505],["thread",110368],["thread",108093],["thread",113363],["thread",130093],["thread",120394],["thread",113855],["thread",126762],["thread",104348],["thread",132708],["thread",130269],["thread",112644],["thread",115852],["thread",112600],["thread",122273],["thread",106357],["thread",106337],["thread",129434],["thread",126988],["thread",112459],["thread",22283],["thread",106904],["thread",120525],["thread",125613],["thread",123417],["thread",136221],["thread",124456],["thread",135566],["thread",116813],["thread",87652],["thread",76666],["thread",123094],["thread",136232],["thread",110881],["thread",86814],["thread",132509],["thread",82406],["thread",134862],["thread",134478],["thread",116388],["thread",127337],["thread",106698],["thread",128609],["thread",122447],["thread",130906],["thread",135159],["thread",123671],["thread",46647],["thread",133146],["thread",123909],["thread",102243],["thread",76037],["thread",122906],["thread",112588],["thread",71170],["thread",107977],["thread",114177],["thread",135661],["thread",116505],["thread",127624],["thread",116553],["thread",131409],["thread",110042],["thread",64172],["thread",107034],["thread",118994],["thread",95018],["thread",81138],["thread",105970],["thread",122040],["thread",129502],["thread",119801],["thread",81308],["thread",108578],["thread",104759],["thread",65754],["thread",123843],["thread",119116],["thread",123606],["thread",46116],["thread",89471],["thread",112466],["thread",130736],["thread",125325],["thread",114185],["thread",77302],["thread",64566],["thread",123046],["thread",119734],["thread",114997],["thread",115588],["thread",126201],["thread",122548],["thread",46972],["thread",110700],["thread",135499],["thread",127101],["thread",115076],["thread",124936],["thread",129204],["thread",114490],["thread",103762],["thread",137043],["thread",115293],["thread",123641],["thread",135169],["thread",120307],["thread",119834],["thread",118755],["thread",118857],["thread",125779],["thread",48831],["thread",120360],["thread",50314],["thread",118758],["thread",105634],["thread",121166],["thread",76545],["thread",113574],["thread",115054],["thread",115558],["thread",126497],["thread",129472],["thread",113857],["thread",116121],["thread",125964],["thread",115327],["thread",113281],["thread",119778],["thread",122760],["thread",135745],["thread",88400],["thread",108002],["thread",124888],["thread",107677],["thread",126573],["thread",114984],["thread",130046],["thread",50627],["thread",131000],["thread",117271],["thread",107177],["thread",51346],["thread",136689],["thread",115836],["thread",110005],["thread",107397],["thread",123216],["thread",104579],["thread",115937],["thread",109747],["thread",120626],["thread",120513],["thread",125350],["thread",77723],["thread",129151],["thread",112576],["thread",129838],["thread",122088],["thread",136288],["thread",50893],["thread",124399],["thread",119667],["thread",87508],["thread",128933],["thread",100463],["thread",131881],["thread",119465],["thread",116976],["thread",132754],["thread",118366],["thread",115595],["thread",47395],["thread",125876],["thread",118277],["thread",124162],["thread",130845],["thread",66321],["thread",123091],["thread",117870],["thread",120871],["thread",120807],["thread",113962],["thread",104507],["thread",116350],["thread",136800],["thread",116663],["thread",132772],["thread",104296],["thread",78393],["thread",49106],["thread",125984],["thread",114937],["thread",130666],["thread",132558],["thread",115957],["thread",107561],["thread",114836],["thread",123299],["thread",123661],["thread",105434],["thread",81873],["thread",116948],["thread",120827],["thread",112694],["thread",129313],["thread",132408],["thread",108727],["thread",120671],["thread",134075],["thread",125682],["thread",130123],["thread",106282],["thread",118680],["thread",130749],["thread",108473],["thread",123026],["thread",112396]]
Run Time: 0.007930
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 |