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 (134272, 136759, 126950, 11523, 132307, 104209, 125029, 10327, 106290, 135470, 12055, 81422, 62953, 109713, 109295, 130462, 61818, 130275, 126680, 134603, 120290, 61769, 111215, 4756, 110364, 133576, 20752, 108127, 107858, 126972, 137485, 136705, 132712, 53466, 63145, 104541, 135502, 121991, 70259, 44366, 135094, 11845, 7067, 96185, 123624, 14648, 91930, 118340, 123563, 135791, 129519, 133681, 25249, 105024, 18317, 133703, 64951, 113084, 121755, 132759, 119614, 108423, 130813, 43876, 81861, 121830, 132185, 34233, 105053, 127847, 127368, 115637, 22076, 31967, 107629, 61838, 110273, 49102, 101276, 4949, 134163, 61968, 132427, 89537, 65363, 128460, 135503, 11630, 110323, 129736, 118271, 44332, 64445, 11937, 10861, 29860, 131788, 120393, 108091, 114163, 133668, 62850, 29590, 136335, 85304, 131425, 112522, 112724, 93892, 131114, 135335, 118627, 136787, 112575, 131560, 114816, 92014, 123365, 109852, 117105, 133714, 49701, 11559, 133031, 134714, 6147, 35284, 120880, 134460, 62454, 116209, 81649, 136717, 87144, 133925, 135301, 136760, 134346, 123169, 636, 113804, 20170, 130149, 107587, 78419, 131804, 120612, 4688, 47755, 129038, 134028, 128140, 127981, 45925, 108663, 133102, 133929, 134570, 71485, 11334, 135003, 35288, 108583, 118638, 112738, 35281, 22707, 115797, 16502, 5424, 134422, 133851, 136898, 105509, 89553, 126072, 67625, 107228, 110281, 135142, 137382, 101873, 65775, 70072, 134005, 137335, 8703, 118248, 118554, 109150, 135009, 129245, 82951, 44465, 136426, 6115, 122172, 45219, 119878, 107657, 61686, 45053, 63165, 110658, 81580, 96409, 136520, 113660, 134849, 131308, 84395, 22987, 77035, 132422, 133767, 64322, 61369, 121018, 119952, 108038, 106310, 130714, 133383, 69652, 91968, 90645, 118348, 84204, 121466, 60958, 92205, 16675, 77210, 134307, 76617, 118609, 96214, 43936, 134749, 102153, 62753, 38407, 134178, 59174, 135547, 47168, 133405, 45056, 37862, 37642, 134251, 12324, 110143, 62164, 106899, 111765, 133164, 136002, 77166, 127386, 46770, 61272, 135708, 124912, 114030, 135024, 132751, 1401, 15484, 123582, 137206, 105778, 62851, 69430, 40532, 133101, 126413, 64109, 134837, 105192, 5150, 108410, 118232, 114428, 136272, 49924, 136695, 129676, 108657, 131426, 64820, 137047, 132446, 127182, 30802, 11484, 133510, 136980, 117272)
Run Time: 0.015236
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 299 | 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: 31, 0, 1715987608, 1715991208, [["tinhte_xentag_forum",65],["thread",134272],["thread",136759],["thread",126950],["thread",11523],["thread",132307],["thread",104209],["thread",125029],["thread",10327],["thread",106290],["thread",135470],["thread",12055],["thread",81422],["thread",62953],["thread",109713],["thread",109295],["thread",130462],["thread",61818],["thread",130275],["thread",126680],["thread",134603],["thread",120290],["thread",61769],["thread",111215],["thread",4756],["thread",110364],["thread",133576],["thread",20752],["thread",108127],["thread",107858],["thread",126972],["thread",137485],["thread",136705],["thread",132712],["thread",53466],["thread",63145],["thread",104541],["thread",135502],["thread",121991],["thread",70259],["thread",44366],["thread",135094],["thread",11845],["thread",7067],["thread",96185],["thread",123624],["thread",14648],["thread",91930],["thread",118340],["thread",123563],["thread",135791],["thread",129519],["thread",133681],["thread",25249],["thread",105024],["thread",18317],["thread",133703],["thread",64951],["thread",113084],["thread",121755],["thread",132759],["thread",119614],["thread",108423],["thread",130813],["thread",43876],["thread",81861],["thread",121830],["thread",132185],["thread",34233],["thread",105053],["thread",127847],["thread",127368],["thread",115637],["thread",22076],["thread",31967],["thread",107629],["thread",61838],["thread",110273],["thread",49102],["thread",101276],["thread",4949],["thread",134163],["thread",61968],["thread",132427],["thread",89537],["thread",65363],["thread",128460],["thread",135503],["thread",11630],["thread",110323],["thread",129736],["thread",118271],["thread",44332],["thread",64445],["thread",11937],["thread",10861],["thread",29860],["thread",131788],["thread",120393],["thread",108091],["thread",114163],["thread",133668],["thread",62850],["thread",29590],["thread",136335],["thread",85304],["thread",131425],["thread",112522],["thread",112724],["thread",93892],["thread",131114],["thread",135335],["thread",118627],["thread",136787],["thread",112575],["thread",131560],["thread",114816],["thread",92014],["thread",123365],["thread",109852],["thread",117105],["thread",133714],["thread",49701],["thread",11559],["thread",133031],["thread",134714],["thread",6147],["thread",35284],["thread",120880],["thread",134460],["thread",62454],["thread",116209],["thread",81649],["thread",136717],["thread",87144],["thread",133925],["thread",135301],["thread",136760],["thread",134346],["thread",123169],["thread",636],["thread",113804],["thread",20170],["thread",130149],["thread",107587],["thread",78419],["thread",131804],["thread",120612],["thread",4688],["thread",47755],["thread",129038],["thread",134028],["thread",128140],["thread",127981],["thread",45925],["thread",108663],["thread",133102],["thread",133929],["thread",134570],["thread",71485],["thread",11334],["thread",135003],["thread",35288],["thread",108583],["thread",118638],["thread",112738],["thread",35281],["thread",22707],["thread",115797],["thread",16502],["thread",5424],["thread",134422],["thread",133851],["thread",136898],["thread",105509],["thread",89553],["thread",126072],["thread",67625],["thread",107228],["thread",110281],["thread",135142],["thread",137382],["thread",101873],["thread",65775],["thread",70072],["thread",134005],["thread",137335],["thread",8703],["thread",118248],["thread",118554],["thread",109150],["thread",135009],["thread",129245],["thread",82951],["thread",44465],["thread",136426],["thread",6115],["thread",122172],["thread",45219],["thread",119878],["thread",107657],["thread",61686],["thread",45053],["thread",63165],["thread",110658],["thread",81580],["thread",96409],["thread",136520],["thread",113660],["thread",134849],["thread",131308],["thread",84395],["thread",22987],["thread",77035],["thread",132422],["thread",133767],["thread",64322],["thread",61369],["thread",121018],["thread",119952],["thread",108038],["thread",106310],["thread",130714],["thread",133383],["thread",69652],["thread",91968],["thread",90645],["thread",118348],["thread",84204],["thread",121466],["thread",60958],["thread",92205],["thread",16675],["thread",77210],["thread",134307],["thread",76617],["thread",118609],["thread",96214],["thread",43936],["thread",134749],["thread",102153],["thread",62753],["thread",38407],["thread",134178],["thread",59174],["thread",135547],["thread",47168],["thread",133405],["thread",45056],["thread",37862],["thread",37642],["thread",134251],["thread",12324],["thread",110143],["thread",62164],["thread",106899],["thread",111765],["thread",133164],["thread",136002],["thread",77166],["thread",127386],["thread",46770],["thread",61272],["thread",135708],["thread",124912],["thread",114030],["thread",135024],["thread",132751],["thread",1401],["thread",15484],["thread",123582],["thread",137206],["thread",105778],["thread",62851],["thread",69430],["thread",40532],["thread",133101],["thread",126413],["thread",64109],["thread",134837],["thread",105192],["thread",5150],["thread",108410],["thread",118232],["thread",114428],["thread",136272],["thread",49924],["thread",136695],["thread",129676],["thread",108657],["thread",131426],["thread",64820],["thread",137047],["thread",132446],["thread",127182],["thread",30802],["thread",11484],["thread",133510],["thread",136980],["thread",117272]]
Run Time: 0.001467
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.011444
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |