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 (88258, 1405, 124222, 120519, 120807, 130401, 128714, 121007, 136803, 133058, 103768, 106771, 121766, 106208, 76188, 131602, 80517, 97628, 126515, 110249, 118530, 107730, 102611, 64201, 1367, 95166, 117622, 76544, 126762, 92116, 128463, 119429, 136740, 117337, 117102, 126410, 107950, 136221, 130046, 95752, 90069, 77386, 135642, 131976, 136716, 96368, 93556, 73299, 135175, 109357, 120486, 109376, 135278, 119911, 132754, 115233, 123345, 112714, 120242, 129604, 126850, 95912, 115584, 78875, 123026, 131249, 120712, 65279, 129304, 95830, 109774, 116092, 131284, 57241, 135396, 126313, 97748, 78376, 130915, 127432, 130435, 42988, 84851, 123710, 120820, 66683, 120119, 129714, 123096, 111539, 82571, 121364, 71574, 84856, 80534, 124614, 107064, 133540, 67251, 98027, 122479, 127571, 113316, 1549, 119994, 81960, 76425, 126419, 96269, 122679, 120964, 124928, 68435, 115325, 126201, 109398, 121013, 117870, 130254, 119075, 80058, 120495, 3653, 75737, 119069, 67615, 126274, 117928, 3781, 130678, 123582, 68428, 124896, 74809, 97503, 122800, 135868, 80161, 68320, 112767, 74519, 63935, 90792, 121429, 83717, 120732, 117222, 136613, 127771, 107086, 72567, 118587, 120898, 122244, 70027, 97629, 99867, 120264, 115657, 88903, 120696, 126988, 120138, 132799, 666, 119570, 131513, 106646, 135548, 119696, 118477, 126247, 131637, 88416, 77326, 117046, 128568, 68427, 74618, 130102, 119927, 66060, 117291, 66226, 96644, 120066, 89070, 420, 81297, 115516, 115007, 119116, 130182, 119885, 120248, 118423, 80842, 135159, 121400, 115274, 64198, 129290, 80466, 97998, 96476, 120217, 24587, 121628, 123152, 132509, 67908, 119181, 130565, 130614, 81109, 70660, 112253, 1399, 132254, 102023, 120815, 130402, 83429, 116651, 1365, 135865, 96934, 115699, 35163, 73543, 89507, 136800, 113865, 114663, 114364, 97238, 120579, 128966, 130924, 130452, 109573, 80726, 117895, 119858, 130955, 68853, 90028, 130511, 76299, 84126, 115491, 132264, 80683, 99134, 73808, 72289, 120829, 83164, 124092, 71750, 118564, 127541, 121920, 120139, 69894, 103838, 129838, 69886, 107472, 121474, 66471, 85246, 130580, 86238, 115875, 132032, 74064, 130989, 121767, 75813, 115987, 130804, 129023, 120237, 114766, 3846, 119544, 109832, 120463, 107520, 120399, 130530, 120886, 94316, 68205, 135333, 115544, 81853, 113834, 93401)
Run Time: 0.006918
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: 21, 0, 1714031918, 1714035518, [["thread",88258],["thread",1405],["thread",124222],["thread",120519],["thread",120807],["thread",130401],["thread",128714],["thread",121007],["thread",136803],["thread",133058],["thread",103768],["thread",106771],["thread",121766],["thread",106208],["thread",76188],["thread",131602],["thread",80517],["thread",97628],["thread",126515],["thread",110249],["thread",118530],["thread",107730],["thread",102611],["thread",64201],["thread",1367],["thread",95166],["thread",117622],["thread",76544],["thread",126762],["thread",92116],["thread",128463],["thread",119429],["thread",136740],["thread",117337],["thread",117102],["thread",126410],["thread",107950],["thread",136221],["thread",130046],["thread",95752],["thread",90069],["thread",77386],["thread",135642],["thread",131976],["thread",136716],["thread",96368],["thread",93556],["thread",73299],["thread",135175],["thread",109357],["thread",120486],["thread",109376],["thread",135278],["thread",119911],["thread",132754],["thread",115233],["thread",123345],["thread",112714],["thread",120242],["thread",129604],["thread",126850],["thread",95912],["thread",115584],["thread",78875],["thread",123026],["thread",131249],["thread",120712],["thread",65279],["thread",129304],["thread",95830],["thread",109774],["thread",116092],["thread",131284],["thread",57241],["thread",135396],["thread",126313],["thread",97748],["thread",78376],["thread",130915],["thread",127432],["thread",130435],["thread",42988],["thread",84851],["thread",123710],["thread",120820],["thread",66683],["thread",120119],["thread",129714],["thread",123096],["thread",111539],["thread",82571],["thread",121364],["thread",71574],["thread",84856],["thread",80534],["thread",124614],["thread",107064],["thread",133540],["thread",67251],["thread",98027],["thread",122479],["thread",127571],["thread",113316],["thread",1549],["thread",119994],["thread",81960],["thread",76425],["thread",126419],["thread",96269],["thread",122679],["thread",120964],["thread",124928],["thread",68435],["thread",115325],["thread",126201],["thread",109398],["thread",121013],["thread",117870],["thread",130254],["thread",119075],["thread",80058],["thread",120495],["thread",3653],["thread",75737],["thread",119069],["thread",67615],["thread",126274],["thread",117928],["thread",3781],["thread",130678],["thread",123582],["thread",68428],["thread",124896],["thread",74809],["thread",97503],["thread",122800],["thread",135868],["thread",80161],["thread",68320],["thread",112767],["thread",74519],["thread",63935],["thread",90792],["thread",121429],["thread",83717],["thread",120732],["thread",117222],["thread",136613],["thread",127771],["thread",107086],["thread",72567],["thread",118587],["thread",120898],["thread",122244],["thread",70027],["thread",97629],["thread",99867],["thread",120264],["thread",115657],["thread",88903],["thread",120696],["thread",126988],["thread",120138],["thread",132799],["thread",666],["thread",119570],["thread",131513],["thread",106646],["thread",135548],["thread",119696],["thread",118477],["thread",126247],["thread",131637],["thread",88416],["thread",77326],["thread",117046],["thread",128568],["thread",68427],["thread",74618],["thread",130102],["thread",119927],["thread",66060],["thread",117291],["thread",66226],["thread",96644],["thread",120066],["thread",89070],["thread",420],["thread",81297],["thread",115516],["thread",115007],["thread",119116],["thread",130182],["thread",119885],["thread",120248],["thread",118423],["thread",80842],["thread",135159],["thread",121400],["thread",115274],["thread",64198],["thread",129290],["thread",80466],["thread",97998],["thread",96476],["thread",120217],["thread",24587],["thread",121628],["thread",123152],["thread",132509],["thread",67908],["thread",119181],["thread",130565],["thread",130614],["thread",81109],["thread",70660],["thread",112253],["thread",1399],["thread",132254],["thread",102023],["thread",120815],["thread",130402],["thread",83429],["thread",116651],["thread",1365],["thread",135865],["thread",96934],["thread",115699],["thread",35163],["thread",73543],["thread",89507],["thread",136800],["thread",113865],["thread",114663],["thread",114364],["thread",97238],["thread",120579],["thread",128966],["thread",130924],["thread",130452],["thread",109573],["thread",80726],["thread",117895],["thread",119858],["thread",130955],["thread",68853],["thread",90028],["thread",130511],["thread",76299],["thread",84126],["thread",115491],["thread",132264],["thread",80683],["thread",99134],["thread",73808],["thread",72289],["thread",120829],["thread",83164],["thread",124092],["thread",71750],["thread",118564],["thread",127541],["thread",121920],["thread",120139],["thread",69894],["thread",103838],["thread",129838],["thread",69886],["thread",107472],["thread",121474],["thread",66471],["thread",85246],["thread",130580],["thread",86238],["thread",115875],["thread",132032],["thread",74064],["thread",130989],["thread",121767],["thread",75813],["thread",115987],["thread",130804],["thread",129023],["thread",120237],["thread",114766],["thread",3846],["thread",119544],["thread",109832],["thread",120463],["thread",107520],["thread",120399],["thread",130530],["thread",120886],["thread",94316],["thread",68205],["thread",135333],["thread",115544],["thread",81853],["thread",113834],["thread",93401]]
Run Time: 0.001660
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 |