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 (47569, 35255, 102294, 58336, 43963, 126766, 105988, 34907, 47361, 22163, 35473, 115316, 50033, 101297, 33029, 86158, 116964, 94465, 80121, 38945, 107553, 78113, 107101, 106805, 98166, 120900, 125719, 87827, 69087, 122103, 86549, 91047, 95570, 106745, 46729, 30305, 112672, 123829, 89265, 95616, 124720, 115017, 111382, 87538, 99161, 93849, 62608, 102146, 97324, 123636, 116899, 115747, 76998, 92322, 988, 124821, 89786, 79400, 76771, 89560, 81140, 106426, 109736, 116629, 115937, 32938, 100773, 35756, 124501, 86600, 67106, 116287, 2285, 33395, 84142, 113844, 69102, 1246, 107723, 118679, 54359, 52469, 116930, 33445, 92728, 63855, 107031, 94256, 108375, 120242, 128157, 65515, 107925, 97310, 91849, 98864, 99255, 118022, 47277, 107850, 80282, 1382, 121203, 81252, 47223, 110104, 105627, 31044, 89046, 103949, 45646, 107272, 107353, 123037, 114057, 123895, 96765, 104348, 101227, 115734, 132827, 26858, 48340, 89395, 116393, 123297, 122251, 91179, 27012, 82643, 85789, 111376, 112515, 112502, 93141, 107345, 105721, 30244, 88085, 102289, 89270, 34814, 117011, 107448, 125531, 116644, 38590, 123506, 32335, 52632, 119970, 106877, 929, 1181, 124905, 30685, 102150, 107802, 37083, 394, 34414, 124427, 107629, 135306, 121772, 125205, 136139, 112501, 104164, 76545, 46813, 78993, 88235, 107104, 88591, 882, 86157, 910, 58365, 9891, 78054, 93243, 127769, 102453, 111349, 103817, 95218, 35467, 126086, 1695, 97413, 104199, 33408, 102066, 47362, 77302, 89118, 115028, 33322, 37082, 109498, 81425, 115835, 113568, 86598, 35882, 895, 35090, 86421, 41026, 102287, 108831, 116995, 38890, 96895, 116057, 43605, 104416, 105805, 118563, 114462, 97910, 104785, 81226, 50664, 116245, 99055, 87373, 112368, 92018, 84689, 98211, 47221, 123440, 72000, 87468, 34086, 85911, 115451, 87982, 77808, 35499, 57307, 112528, 67108, 52193, 80357, 47568, 113825, 35393, 34085, 80928, 86739, 107816, 122018, 95297, 35671, 91138, 82106, 81560, 115847, 35323, 122474, 47455, 46044, 97950, 115829, 116099, 118098, 81300, 106595, 107677, 91312, 62896, 87667, 78971, 115546, 77166, 107815, 37077, 98205, 116919, 914, 77804, 116550, 105865, 34730, 130896, 129106, 76439, 124706, 69117, 76770, 86147, 116957, 67878, 4883, 53029, 34536)
Run Time: 0.005969
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: 367, 0, 1713562763, 1713566363, [["tinhte_xentag_forum",64],["thread",47569],["thread",35255],["thread",102294],["thread",58336],["thread",43963],["thread",126766],["thread",105988],["thread",34907],["thread",47361],["thread",22163],["thread",35473],["thread",115316],["thread",50033],["thread",101297],["thread",33029],["thread",86158],["thread",116964],["thread",94465],["thread",80121],["thread",38945],["thread",107553],["thread",78113],["thread",107101],["thread",106805],["thread",98166],["thread",120900],["thread",125719],["thread",87827],["thread",69087],["thread",122103],["thread",86549],["thread",91047],["thread",95570],["thread",106745],["thread",46729],["thread",30305],["thread",112672],["thread",123829],["thread",89265],["thread",95616],["thread",124720],["thread",115017],["thread",111382],["thread",87538],["thread",99161],["thread",93849],["thread",62608],["thread",102146],["thread",97324],["thread",123636],["thread",116899],["thread",115747],["thread",76998],["thread",92322],["thread",988],["thread",124821],["thread",89786],["thread",79400],["thread",76771],["thread",89560],["thread",81140],["thread",106426],["thread",109736],["thread",116629],["thread",115937],["thread",32938],["thread",100773],["thread",35756],["thread",124501],["thread",86600],["thread",67106],["thread",116287],["thread",2285],["thread",33395],["thread",84142],["thread",113844],["thread",69102],["thread",1246],["thread",107723],["thread",118679],["thread",54359],["thread",52469],["thread",116930],["thread",33445],["thread",92728],["thread",63855],["thread",107031],["thread",94256],["thread",108375],["thread",120242],["thread",128157],["thread",65515],["thread",107925],["thread",97310],["thread",91849],["thread",98864],["thread",99255],["thread",118022],["thread",47277],["thread",107850],["thread",80282],["thread",1382],["thread",121203],["thread",81252],["thread",47223],["thread",110104],["thread",105627],["thread",31044],["thread",89046],["thread",103949],["thread",45646],["thread",107272],["thread",107353],["thread",123037],["thread",114057],["thread",123895],["thread",96765],["thread",104348],["thread",101227],["thread",115734],["thread",132827],["thread",26858],["thread",48340],["thread",89395],["thread",116393],["thread",123297],["thread",122251],["thread",91179],["thread",27012],["thread",82643],["thread",85789],["thread",111376],["thread",112515],["thread",112502],["thread",93141],["thread",107345],["thread",105721],["thread",30244],["thread",88085],["thread",102289],["thread",89270],["thread",34814],["thread",117011],["thread",107448],["thread",125531],["thread",116644],["thread",38590],["thread",123506],["thread",32335],["thread",52632],["thread",119970],["thread",106877],["thread",929],["thread",1181],["thread",124905],["thread",30685],["thread",102150],["thread",107802],["thread",37083],["thread",394],["thread",34414],["thread",124427],["thread",107629],["thread",135306],["thread",121772],["thread",125205],["thread",136139],["thread",112501],["thread",104164],["thread",76545],["thread",46813],["thread",78993],["thread",88235],["thread",107104],["thread",88591],["thread",882],["thread",86157],["thread",910],["thread",58365],["thread",9891],["thread",78054],["thread",93243],["thread",127769],["thread",102453],["thread",111349],["thread",103817],["thread",95218],["thread",35467],["thread",126086],["thread",1695],["thread",97413],["thread",104199],["thread",33408],["thread",102066],["thread",47362],["thread",77302],["thread",89118],["thread",115028],["thread",33322],["thread",37082],["thread",109498],["thread",81425],["thread",115835],["thread",113568],["thread",86598],["thread",35882],["thread",895],["thread",35090],["thread",86421],["thread",41026],["thread",102287],["thread",108831],["thread",116995],["thread",38890],["thread",96895],["thread",116057],["thread",43605],["thread",104416],["thread",105805],["thread",118563],["thread",114462],["thread",97910],["thread",104785],["thread",81226],["thread",50664],["thread",116245],["thread",99055],["thread",87373],["thread",112368],["thread",92018],["thread",84689],["thread",98211],["thread",47221],["thread",123440],["thread",72000],["thread",87468],["thread",34086],["thread",85911],["thread",115451],["thread",87982],["thread",77808],["thread",35499],["thread",57307],["thread",112528],["thread",67108],["thread",52193],["thread",80357],["thread",47568],["thread",113825],["thread",35393],["thread",34085],["thread",80928],["thread",86739],["thread",107816],["thread",122018],["thread",95297],["thread",35671],["thread",91138],["thread",82106],["thread",81560],["thread",115847],["thread",35323],["thread",122474],["thread",47455],["thread",46044],["thread",97950],["thread",115829],["thread",116099],["thread",118098],["thread",81300],["thread",106595],["thread",107677],["thread",91312],["thread",62896],["thread",87667],["thread",78971],["thread",115546],["thread",77166],["thread",107815],["thread",37077],["thread",98205],["thread",116919],["thread",914],["thread",77804],["thread",116550],["thread",105865],["thread",34730],["thread",130896],["thread",129106],["thread",76439],["thread",124706],["thread",69117],["thread",76770],["thread",86147],["thread",116957],["thread",67878],["thread",4883],["thread",53029],["thread",34536]]
Run Time: 0.010073
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 |