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 (103536, 72844, 125503, 128338, 104696, 38434, 127728, 102021, 135446, 123442, 84599, 110342, 119685, 120557, 134148, 127554, 130955, 130614, 132234, 121567, 132602, 120952, 42469, 111965, 126994, 128744, 124603, 117947, 119376, 127216, 135523, 126522, 120425, 123410, 89441, 39385, 123962, 132506, 112600, 126803, 99666, 44942, 120627, 120390, 123434, 127390, 128463, 128306, 134041, 121973, 110005, 131510, 126026, 121566, 131473, 119870, 135287, 121748, 127258, 102533, 106885, 130344, 125045, 135204, 118697, 120385, 120905, 122698, 108460, 120083, 121734, 129469, 130887, 128822, 110989, 127449, 121750, 43853, 120741, 128993, 129585, 128283, 133601, 129951, 131668, 124067, 126420, 122788, 119166, 126468, 112598, 100548, 125731, 132032, 78358, 50806, 108723, 135421, 134380, 134941, 112657, 134728, 129394, 132343, 128005, 125695, 128630, 109387, 112578, 130166, 38422, 126074, 120610, 135889, 85668, 112459, 112457, 128193, 135566, 103715, 104454, 112576, 110293, 128238, 120016, 87133, 125302, 125136, 118051, 124768, 66134, 133039, 121851, 132792, 62809, 10032, 110407, 123076, 124324, 67529, 124278, 119849, 130243, 123747, 130989, 123686, 54112, 134692, 125925, 130566, 122121, 123440, 132344, 134710, 134612, 4488, 108054, 130016, 125994, 134463, 132401, 128340, 129134, 127129, 112575, 127540, 127825, 127404, 65867, 131484, 78383, 123742, 122487, 123922, 126489, 134698, 122246, 123452, 52201, 123762, 119942, 112579, 134652, 122084, 128883, 128396, 129732, 122558, 95689, 110059, 135169, 39109, 122122, 126919, 128367, 87922, 11234, 110287, 125709, 110401, 104041, 120689, 77448, 127517, 61720, 122486, 112642, 134547, 128062, 121647, 126638, 130373, 42307, 134354, 38593, 120917, 112458, 52198, 123014, 135745, 123017, 123606, 121751, 122523, 124755, 136038, 80229, 133518, 122133, 127553, 127187, 119272, 130878, 127341, 122220, 134724, 130389, 112468, 370, 112463, 130090, 130478, 130740, 129352, 9900, 126993, 133492, 134550, 97163, 120816, 112597, 120989, 54385, 128664, 130402, 130749, 131760, 125401, 11079, 119427, 110007, 121832, 10150, 120928, 118115, 105337, 112656, 53724, 120729, 108766, 119334, 123976, 127163, 121033, 129151, 79746, 124370, 62243, 124898, 122522, 86823, 128769, 125430, 120602, 123541, 119535, 128231, 127774, 112596, 132606, 123664, 38401, 38446, 118407, 110353, 127021, 111961, 50805, 108438, 122557)
Run Time: 0.004941
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: 11993, 0, 1713381473, 1713385073, [["thread",103536],["thread",72844],["thread",125503],["thread",128338],["thread",104696],["thread",38434],["thread",127728],["thread",102021],["thread",135446],["thread",123442],["thread",84599],["thread",110342],["thread",119685],["thread",120557],["thread",134148],["thread",127554],["thread",130955],["thread",130614],["thread",132234],["thread",121567],["thread",132602],["thread",120952],["thread",42469],["thread",111965],["thread",126994],["thread",128744],["thread",124603],["thread",117947],["thread",119376],["thread",127216],["thread",135523],["thread",126522],["thread",120425],["thread",123410],["thread",89441],["thread",39385],["thread",123962],["thread",132506],["thread",112600],["thread",126803],["thread",99666],["thread",44942],["thread",120627],["thread",120390],["thread",123434],["thread",127390],["thread",128463],["thread",128306],["thread",134041],["thread",121973],["thread",110005],["thread",131510],["thread",126026],["thread",121566],["thread",131473],["thread",119870],["thread",135287],["thread",121748],["thread",127258],["thread",102533],["thread",106885],["thread",130344],["thread",125045],["thread",135204],["thread",118697],["thread",120385],["thread",120905],["thread",122698],["thread",108460],["thread",120083],["thread",121734],["thread",129469],["thread",130887],["thread",128822],["thread",110989],["thread",127449],["thread",121750],["thread",43853],["thread",120741],["thread",128993],["thread",129585],["thread",128283],["thread",133601],["thread",129951],["thread",131668],["thread",124067],["thread",126420],["thread",122788],["thread",119166],["thread",126468],["thread",112598],["thread",100548],["thread",125731],["thread",132032],["thread",78358],["thread",50806],["thread",108723],["thread",135421],["thread",134380],["thread",134941],["thread",112657],["thread",134728],["thread",129394],["thread",132343],["thread",128005],["thread",125695],["thread",128630],["thread",109387],["thread",112578],["thread",130166],["thread",38422],["thread",126074],["thread",120610],["thread",135889],["thread",85668],["thread",112459],["thread",112457],["thread",128193],["thread",135566],["thread",103715],["thread",104454],["thread",112576],["thread",110293],["thread",128238],["thread",120016],["thread",87133],["thread",125302],["thread",125136],["thread",118051],["thread",124768],["thread",66134],["thread",133039],["thread",121851],["thread",132792],["thread",62809],["thread",10032],["thread",110407],["thread",123076],["thread",124324],["thread",67529],["thread",124278],["thread",119849],["thread",130243],["thread",123747],["thread",130989],["thread",123686],["thread",54112],["thread",134692],["thread",125925],["thread",130566],["thread",122121],["thread",123440],["thread",132344],["thread",134710],["thread",134612],["thread",4488],["thread",108054],["thread",130016],["thread",125994],["thread",134463],["thread",132401],["thread",128340],["thread",129134],["thread",127129],["thread",112575],["thread",127540],["thread",127825],["thread",127404],["thread",65867],["thread",131484],["thread",78383],["thread",123742],["thread",122487],["thread",123922],["thread",126489],["thread",134698],["thread",122246],["thread",123452],["thread",52201],["thread",123762],["thread",119942],["thread",112579],["thread",134652],["thread",122084],["thread",128883],["thread",128396],["thread",129732],["thread",122558],["thread",95689],["thread",110059],["thread",135169],["thread",39109],["thread",122122],["thread",126919],["thread",128367],["thread",87922],["thread",11234],["thread",110287],["thread",125709],["thread",110401],["thread",104041],["thread",120689],["thread",77448],["thread",127517],["thread",61720],["thread",122486],["thread",112642],["thread",134547],["thread",128062],["thread",121647],["thread",126638],["thread",130373],["thread",42307],["thread",134354],["thread",38593],["thread",120917],["thread",112458],["thread",52198],["thread",123014],["thread",135745],["thread",123017],["thread",123606],["thread",121751],["thread",122523],["thread",124755],["thread",136038],["thread",80229],["thread",133518],["thread",122133],["thread",127553],["thread",127187],["thread",119272],["thread",130878],["thread",127341],["thread",122220],["thread",134724],["thread",130389],["thread",112468],["thread",370],["thread",112463],["thread",130090],["thread",130478],["thread",130740],["thread",129352],["thread",9900],["thread",126993],["thread",133492],["thread",134550],["thread",97163],["thread",120816],["thread",112597],["thread",120989],["thread",54385],["thread",128664],["thread",130402],["thread",130749],["thread",131760],["thread",125401],["thread",11079],["thread",119427],["thread",110007],["thread",121832],["thread",10150],["thread",120928],["thread",118115],["thread",105337],["thread",112656],["thread",53724],["thread",120729],["thread",108766],["thread",119334],["thread",123976],["thread",127163],["thread",121033],["thread",129151],["thread",79746],["thread",124370],["thread",62243],["thread",124898],["thread",122522],["thread",86823],["thread",128769],["thread",125430],["thread",120602],["thread",123541],["thread",119535],["thread",128231],["thread",127774],["thread",112596],["thread",132606],["thread",123664],["thread",38401],["thread",38446],["thread",118407],["thread",110353],["thread",127021],["thread",111961],["thread",50805],["thread",108438],["thread",122557]]
Run Time: 0.001740
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.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |