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 (62386, 32546, 107774, 62078, 64502, 65055, 62654, 80473, 63708, 82048, 64251, 62198, 123168, 61838, 78666, 70190, 65775, 61770, 70175, 62945, 70295, 62011, 107110, 18933, 63418, 34109, 70100, 62755, 66826, 19522, 120027, 62454, 9252, 114788, 72088, 130125, 67803, 13877, 55424, 109525, 103959, 117011, 84253, 61924, 70629, 62299, 105813, 97374, 62851, 18735, 67931, 62112, 62080, 12728, 61885, 105778, 21380, 6395, 21672, 61363, 63662, 62766, 64470, 87694, 61912, 90645, 62721, 62499, 10199, 103318, 66615, 63125, 10367, 2138, 64324, 64951, 62221, 116223, 80615, 68729, 66257, 17418, 63378, 66602, 112548, 103539, 61769, 66668, 62139, 105875, 62594, 25909, 62164, 96608, 68114, 103706, 83629, 27007, 63365, 61862, 80268, 61963, 107768, 63395, 62211, 61903, 95171, 62878, 63055, 96409, 70947, 86236, 13876, 30271, 69430, 4203, 23762, 116408, 89213, 66415, 64820, 85836, 71111, 84472, 62256, 91203, 11711, 69873, 130084, 61739, 61842, 71424, 76384, 62303, 97096, 10207, 65081, 62363, 63294, 70940, 82884, 62319, 62215, 61923, 77121, 62105, 63112, 62432, 101300, 103568, 82995, 61931, 38886, 130348, 102560, 115018, 70016, 64824, 62377, 65178, 9849, 114604, 62261, 61902, 95727, 62574, 74278, 71106, 69053, 67775, 69768, 65080, 85763, 61814, 72200, 64751, 107624, 82356, 64711, 63191, 75527, 14648, 64947, 61947, 62317, 59425, 65122, 61776, 64997, 68685, 62357, 16696, 78419, 68728, 78291, 65773, 67536, 61594, 70637, 17757, 13981, 82895, 99685, 11630, 59130, 6115, 75408, 63268, 65954, 67030, 72800, 10204, 3172, 62063, 77210, 33564, 128301, 76829, 129426, 62850, 63738, 106948, 61866, 63639, 79374, 114488, 54359, 62170, 66776, 62788, 62887, 103545, 82943, 105717, 117143, 87339, 29894, 109528, 62500, 62039, 106204, 66441, 67410, 62124, 65215, 12878, 66738, 62062, 63126, 61229, 61290, 62512, 62166, 9693, 62410, 114404, 114654, 77878, 62110, 66408, 62882, 66369, 77960, 62140, 66397, 114447, 61288, 62753, 62016, 117241, 105721, 69059, 61943, 61972, 84454, 62036, 75932, 62093, 63414, 58614, 65997, 62106, 63149, 62241, 104985, 32449, 15367, 420, 61369, 80186, 61845, 68726, 110703, 67705, 10423, 84444, 133906, 77085, 62126, 89904)
Run Time: 0.015526
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: 1329, 0, 1713907530, 1713911130, [["thread",62386],["thread",32546],["thread",107774],["thread",62078],["thread",64502],["thread",65055],["thread",62654],["thread",80473],["thread",63708],["thread",82048],["thread",64251],["thread",62198],["thread",123168],["thread",61838],["thread",78666],["thread",70190],["thread",65775],["thread",61770],["thread",70175],["thread",62945],["thread",70295],["thread",62011],["thread",107110],["thread",18933],["thread",63418],["thread",34109],["thread",70100],["thread",62755],["thread",66826],["thread",19522],["thread",120027],["thread",62454],["thread",9252],["thread",114788],["thread",72088],["thread",130125],["thread",67803],["thread",13877],["thread",55424],["thread",109525],["thread",103959],["thread",117011],["thread",84253],["thread",61924],["thread",70629],["thread",62299],["thread",105813],["thread",97374],["thread",62851],["thread",18735],["thread",67931],["thread",62112],["thread",62080],["thread",12728],["thread",61885],["thread",105778],["thread",21380],["thread",6395],["thread",21672],["thread",61363],["thread",63662],["thread",62766],["thread",64470],["thread",87694],["thread",61912],["thread",90645],["thread",62721],["thread",62499],["thread",10199],["thread",103318],["thread",66615],["thread",63125],["thread",10367],["thread",2138],["thread",64324],["thread",64951],["thread",62221],["thread",116223],["thread",80615],["thread",68729],["thread",66257],["thread",17418],["thread",63378],["thread",66602],["thread",112548],["thread",103539],["thread",61769],["thread",66668],["thread",62139],["thread",105875],["thread",62594],["thread",25909],["thread",62164],["thread",96608],["thread",68114],["thread",103706],["thread",83629],["thread",27007],["thread",63365],["thread",61862],["thread",80268],["thread",61963],["thread",107768],["thread",63395],["thread",62211],["thread",61903],["thread",95171],["thread",62878],["thread",63055],["thread",96409],["thread",70947],["thread",86236],["thread",13876],["thread",30271],["thread",69430],["thread",4203],["thread",23762],["thread",116408],["thread",89213],["thread",66415],["thread",64820],["thread",85836],["thread",71111],["thread",84472],["thread",62256],["thread",91203],["thread",11711],["thread",69873],["thread",130084],["thread",61739],["thread",61842],["thread",71424],["thread",76384],["thread",62303],["thread",97096],["thread",10207],["thread",65081],["thread",62363],["thread",63294],["thread",70940],["thread",82884],["thread",62319],["thread",62215],["thread",61923],["thread",77121],["thread",62105],["thread",63112],["thread",62432],["thread",101300],["thread",103568],["thread",82995],["thread",61931],["thread",38886],["thread",130348],["thread",102560],["thread",115018],["thread",70016],["thread",64824],["thread",62377],["thread",65178],["thread",9849],["thread",114604],["thread",62261],["thread",61902],["thread",95727],["thread",62574],["thread",74278],["thread",71106],["thread",69053],["thread",67775],["thread",69768],["thread",65080],["thread",85763],["thread",61814],["thread",72200],["thread",64751],["thread",107624],["thread",82356],["thread",64711],["thread",63191],["thread",75527],["thread",14648],["thread",64947],["thread",61947],["thread",62317],["thread",59425],["thread",65122],["thread",61776],["thread",64997],["thread",68685],["thread",62357],["thread",16696],["thread",78419],["thread",68728],["thread",78291],["thread",65773],["thread",67536],["thread",61594],["thread",70637],["thread",17757],["thread",13981],["thread",82895],["thread",99685],["thread",11630],["thread",59130],["thread",6115],["thread",75408],["thread",63268],["thread",65954],["thread",67030],["thread",72800],["thread",10204],["thread",3172],["thread",62063],["thread",77210],["thread",33564],["thread",128301],["thread",76829],["thread",129426],["thread",62850],["thread",63738],["thread",106948],["thread",61866],["thread",63639],["thread",79374],["thread",114488],["thread",54359],["thread",62170],["thread",66776],["thread",62788],["thread",62887],["thread",103545],["thread",82943],["thread",105717],["thread",117143],["thread",87339],["thread",29894],["thread",109528],["thread",62500],["thread",62039],["thread",106204],["thread",66441],["thread",67410],["thread",62124],["thread",65215],["thread",12878],["thread",66738],["thread",62062],["thread",63126],["thread",61229],["thread",61290],["thread",62512],["thread",62166],["thread",9693],["thread",62410],["thread",114404],["thread",114654],["thread",77878],["thread",62110],["thread",66408],["thread",62882],["thread",66369],["thread",77960],["thread",62140],["thread",66397],["thread",114447],["thread",61288],["thread",62753],["thread",62016],["thread",117241],["thread",105721],["thread",69059],["thread",61943],["thread",61972],["thread",84454],["thread",62036],["thread",75932],["thread",62093],["thread",63414],["thread",58614],["thread",65997],["thread",62106],["thread",63149],["thread",62241],["thread",104985],["thread",32449],["thread",15367],["thread",420],["thread",61369],["thread",80186],["thread",61845],["thread",68726],["thread",110703],["thread",67705],["thread",10423],["thread",84444],["thread",133906],["thread",77085],["thread",62126],["thread",89904]]
Run Time: 0.002924
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 |