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 (76718, 19001, 62003, 48379, 71956, 80193, 114973, 85404, 105150, 96562, 82489, 69556, 35321, 85305, 103090, 136253, 41663, 108514, 44607, 122602, 58414, 72679, 21732, 86599, 21589, 114360, 41730, 130959, 135760, 61891, 110951, 135167, 35400, 121720, 90916, 64911, 110012, 114238, 79938, 52140, 85094, 129723, 128257, 59259, 22596, 126514, 89847, 109127, 134539, 54128, 75424, 80206, 119182, 18727, 135870, 103720, 92076, 96179, 123978, 85741, 76353, 133927, 64645, 109653, 50343, 78923, 39421, 44339, 88054, 58257, 72079, 131914, 41180, 87275, 81969, 121884, 42789, 69139, 78491, 119496, 30139, 95898, 26568, 62521, 103552, 54503, 98091, 122300, 64083, 58775, 104422, 63974, 67544, 126225, 98325, 54883, 84424, 14798, 109037, 117617, 80014, 100353, 106299, 100826, 82583, 128208, 58404, 113674, 97138, 68885, 95876, 75215, 56623, 63825, 57874, 93453, 36857, 76419, 79005, 79460, 90384, 123465, 94746, 38131, 109809, 87972, 63054, 112424, 109238, 109076, 115907, 66717, 133574, 112404, 78495, 104193, 116426, 125668, 23403, 62259, 87554, 69021, 123911, 135948, 39486, 125138, 67780, 47749, 38134, 98072, 112270, 46370, 56190, 30142, 131913, 67727, 78676, 54933, 67947, 64084, 95614, 132152, 63246, 91457, 40367, 73113, 134158, 84925, 54387, 80013, 82525, 61722, 45476, 128181, 66002, 72848, 84822, 136337, 91140, 58401, 110329, 17545, 77538, 65181, 40270, 128882, 110257, 67881, 98170, 67738, 19543, 106933, 82569, 64903, 128676, 37700, 112007, 55866, 62716, 77397, 64897, 56309, 44322, 71614, 80558, 123689, 136555, 44157, 48882, 56367, 85634, 124068, 102426, 90900, 112094, 84105, 109934, 81552, 54699, 62602, 88044, 79767, 109571, 92227, 97064, 54504, 30626, 70902, 93183, 80701, 97766, 123921, 93180, 52943, 86520, 77109, 62651, 41204, 64356, 100938, 94825, 69512, 98806, 94491, 45367, 112418, 131745, 89878, 123621, 41157, 120530, 21258, 79549, 99627, 68274, 126100, 94324, 87679, 111284, 83497, 109802, 124549, 122212, 64952, 47502, 127601, 39842, 99376, 87353, 52638, 118205, 58369, 87674, 92126, 85401, 113710, 37918, 84921, 85742, 125749, 99559, 75418, 62828, 113119, 23634, 61965, 43079, 59647, 125804, 61718, 40816, 123690, 98135, 77502, 62523, 136185, 56729, 129973, 61081, 115611)
Run Time: 0.006332
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: 1715, 0, 1713534540, 1713538140, [["thread",76718],["thread",19001],["thread",62003],["thread",48379],["thread",71956],["thread",80193],["thread",114973],["thread",85404],["thread",105150],["thread",96562],["thread",82489],["thread",69556],["thread",35321],["thread",85305],["thread",103090],["thread",136253],["thread",41663],["thread",108514],["thread",44607],["thread",122602],["thread",58414],["thread",72679],["thread",21732],["thread",86599],["thread",21589],["thread",114360],["thread",41730],["thread",130959],["thread",135760],["thread",61891],["thread",110951],["thread",135167],["thread",35400],["thread",121720],["thread",90916],["thread",64911],["thread",110012],["thread",114238],["thread",79938],["thread",52140],["thread",85094],["thread",129723],["thread",128257],["thread",59259],["thread",22596],["thread",126514],["thread",89847],["thread",109127],["thread",134539],["thread",54128],["thread",75424],["thread",80206],["thread",119182],["thread",18727],["thread",135870],["thread",103720],["thread",92076],["thread",96179],["thread",123978],["thread",85741],["thread",76353],["thread",133927],["thread",64645],["thread",109653],["thread",50343],["thread",78923],["thread",39421],["thread",44339],["thread",88054],["thread",58257],["thread",72079],["thread",131914],["thread",41180],["thread",87275],["thread",81969],["thread",121884],["thread",42789],["thread",69139],["thread",78491],["thread",119496],["thread",30139],["thread",95898],["thread",26568],["thread",62521],["thread",103552],["thread",54503],["thread",98091],["thread",122300],["thread",64083],["thread",58775],["thread",104422],["thread",63974],["thread",67544],["thread",126225],["thread",98325],["thread",54883],["thread",84424],["thread",14798],["thread",109037],["thread",117617],["thread",80014],["thread",100353],["thread",106299],["thread",100826],["thread",82583],["thread",128208],["thread",58404],["thread",113674],["thread",97138],["thread",68885],["thread",95876],["thread",75215],["thread",56623],["thread",63825],["thread",57874],["thread",93453],["thread",36857],["thread",76419],["thread",79005],["thread",79460],["thread",90384],["thread",123465],["thread",94746],["thread",38131],["thread",109809],["thread",87972],["thread",63054],["thread",112424],["thread",109238],["thread",109076],["thread",115907],["thread",66717],["thread",133574],["thread",112404],["thread",78495],["thread",104193],["thread",116426],["thread",125668],["thread",23403],["thread",62259],["thread",87554],["thread",69021],["thread",123911],["thread",135948],["thread",39486],["thread",125138],["thread",67780],["thread",47749],["thread",38134],["thread",98072],["thread",112270],["thread",46370],["thread",56190],["thread",30142],["thread",131913],["thread",67727],["thread",78676],["thread",54933],["thread",67947],["thread",64084],["thread",95614],["thread",132152],["thread",63246],["thread",91457],["thread",40367],["thread",73113],["thread",134158],["thread",84925],["thread",54387],["thread",80013],["thread",82525],["thread",61722],["thread",45476],["thread",128181],["thread",66002],["thread",72848],["thread",84822],["thread",136337],["thread",91140],["thread",58401],["thread",110329],["thread",17545],["thread",77538],["thread",65181],["thread",40270],["thread",128882],["thread",110257],["thread",67881],["thread",98170],["thread",67738],["thread",19543],["thread",106933],["thread",82569],["thread",64903],["thread",128676],["thread",37700],["thread",112007],["thread",55866],["thread",62716],["thread",77397],["thread",64897],["thread",56309],["thread",44322],["thread",71614],["thread",80558],["thread",123689],["thread",136555],["thread",44157],["thread",48882],["thread",56367],["thread",85634],["thread",124068],["thread",102426],["thread",90900],["thread",112094],["thread",84105],["thread",109934],["thread",81552],["thread",54699],["thread",62602],["thread",88044],["thread",79767],["thread",109571],["thread",92227],["thread",97064],["thread",54504],["thread",30626],["thread",70902],["thread",93183],["thread",80701],["thread",97766],["thread",123921],["thread",93180],["thread",52943],["thread",86520],["thread",77109],["thread",62651],["thread",41204],["thread",64356],["thread",100938],["thread",94825],["thread",69512],["thread",98806],["thread",94491],["thread",45367],["thread",112418],["thread",131745],["thread",89878],["thread",123621],["thread",41157],["thread",120530],["thread",21258],["thread",79549],["thread",99627],["thread",68274],["thread",126100],["thread",94324],["thread",87679],["thread",111284],["thread",83497],["thread",109802],["thread",124549],["thread",122212],["thread",64952],["thread",47502],["thread",127601],["thread",39842],["thread",99376],["thread",87353],["thread",52638],["thread",118205],["thread",58369],["thread",87674],["thread",92126],["thread",85401],["thread",113710],["thread",37918],["thread",84921],["thread",85742],["thread",125749],["thread",99559],["thread",75418],["thread",62828],["thread",113119],["thread",23634],["thread",61965],["thread",43079],["thread",59647],["thread",125804],["thread",61718],["thread",40816],["thread",123690],["thread",98135],["thread",77502],["thread",62523],["thread",136185],["thread",56729],["thread",129973],["thread",61081],["thread",115611]]
Run Time: 0.002710
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 |