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 (56243, 134970, 66009, 6304, 53081, 108591, 1362, 42072, 57155, 25689, 111054, 4642, 61106, 61353, 90519, 35642, 51771, 1217, 104520, 48790, 134375, 55372, 55618, 128988, 113479, 46831, 134382, 84645, 58079, 57506, 114246, 120690, 86370, 49472, 56502, 380, 55816, 55890, 86105, 6430, 81330, 109104, 110944, 54798, 55636, 122053, 41435, 80528, 73580, 56801, 123881, 80011, 119887, 51605, 123609, 19429, 129882, 57457, 51216, 1702, 116866, 114061, 81588, 120521, 81237, 57805, 28004, 110743, 4147, 81294, 88632, 98973, 109256, 41422, 114207, 55887, 113833, 18403, 113573, 97014, 107478, 38749, 40586, 93110, 57013, 65956, 56611, 120454, 43835, 73492, 105163, 110357, 88542, 76755, 82418, 57868, 57489, 49085, 66199, 128356, 119929, 51971, 20336, 68259, 1118, 109403, 84497, 55381, 119233, 61104, 128002, 69769, 95413, 53144, 134247, 56130, 107419, 41329, 57659, 39219, 11027, 87455, 49415, 51028, 94956, 78454, 68082, 56387, 56178, 2480, 436, 103125, 53783, 36838, 105980, 76607, 43699, 110142, 131248, 66955, 112798, 65704, 73141, 49117, 55640, 61627, 119862, 53805, 40353, 62779, 54887, 60128, 81364, 53171, 79909, 35187, 11177, 59731, 103740, 77410, 7504, 51235, 74090, 51765, 57815, 61458, 82176, 119982, 135662, 56250, 119985, 129964, 53771, 128435, 130873, 56469, 108232, 87854, 121584, 63874, 56551, 114214, 56672, 50707, 95842, 45574, 45513, 54959, 57596, 58424, 104804, 54886, 55775, 6896, 128843, 62136, 18503, 112411, 69562, 49375, 78573, 85933, 79382, 89656, 88610, 65317, 67342, 56251, 75526, 56160, 6193, 134412, 61828, 58858, 84379, 95300, 86766, 83417, 92891, 108362, 119412, 91934, 79252, 122249, 95207, 50029, 54533, 119935, 45208, 100048, 85214, 93223, 111721, 98522, 121825, 94659, 49921, 121214, 80271, 75406, 40177, 51776, 60412, 93236, 58844, 89346, 47183, 47279, 84804, 84006, 26370, 1224, 612, 40157, 131805, 80436, 9014, 107270, 83432, 903, 56608, 33467, 70157, 67876, 104817, 36204, 122570, 77904, 52368, 111532, 50729, 86214, 60256, 41037, 78211, 80612, 58197, 98360, 132137, 107619, 55835, 114446, 57228, 107967, 88174, 53742, 760, 49279, 122054, 77836, 93058, 76388, 87348, 84414, 122086, 101531, 56666, 53140, 56950, 106072)
Run Time: 0.052285
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: 60, 0, 1711678356, 1711681956, [["thread",56243],["thread",134970],["thread",66009],["thread",6304],["thread",53081],["thread",108591],["thread",1362],["thread",42072],["thread",57155],["thread",25689],["thread",111054],["thread",4642],["thread",61106],["thread",61353],["thread",90519],["thread",35642],["thread",51771],["thread",1217],["thread",104520],["thread",48790],["thread",134375],["thread",55372],["thread",55618],["thread",128988],["thread",113479],["thread",46831],["thread",134382],["thread",84645],["thread",58079],["thread",57506],["thread",114246],["thread",120690],["thread",86370],["thread",49472],["thread",56502],["thread",380],["thread",55816],["thread",55890],["thread",86105],["thread",6430],["thread",81330],["thread",109104],["thread",110944],["thread",54798],["thread",55636],["thread",122053],["thread",41435],["thread",80528],["thread",73580],["thread",56801],["thread",123881],["thread",80011],["thread",119887],["thread",51605],["thread",123609],["thread",19429],["thread",129882],["thread",57457],["thread",51216],["thread",1702],["thread",116866],["thread",114061],["thread",81588],["thread",120521],["thread",81237],["thread",57805],["thread",28004],["thread",110743],["thread",4147],["thread",81294],["thread",88632],["thread",98973],["thread",109256],["thread",41422],["thread",114207],["thread",55887],["thread",113833],["thread",18403],["thread",113573],["thread",97014],["thread",107478],["thread",38749],["thread",40586],["thread",93110],["thread",57013],["thread",65956],["thread",56611],["thread",120454],["thread",43835],["thread",73492],["thread",105163],["thread",110357],["thread",88542],["thread",76755],["thread",82418],["thread",57868],["thread",57489],["thread",49085],["thread",66199],["thread",128356],["thread",119929],["thread",51971],["thread",20336],["thread",68259],["thread",1118],["thread",109403],["thread",84497],["thread",55381],["thread",119233],["thread",61104],["thread",128002],["thread",69769],["thread",95413],["thread",53144],["thread",134247],["thread",56130],["thread",107419],["thread",41329],["thread",57659],["thread",39219],["thread",11027],["thread",87455],["thread",49415],["thread",51028],["thread",94956],["thread",78454],["thread",68082],["thread",56387],["thread",56178],["thread",2480],["thread",436],["thread",103125],["thread",53783],["thread",36838],["thread",105980],["thread",76607],["thread",43699],["thread",110142],["thread",131248],["thread",66955],["thread",112798],["thread",65704],["thread",73141],["thread",49117],["thread",55640],["thread",61627],["thread",119862],["thread",53805],["thread",40353],["thread",62779],["thread",54887],["thread",60128],["thread",81364],["thread",53171],["thread",79909],["thread",35187],["thread",11177],["thread",59731],["thread",103740],["thread",77410],["thread",7504],["thread",51235],["thread",74090],["thread",51765],["thread",57815],["thread",61458],["thread",82176],["thread",119982],["thread",135662],["thread",56250],["thread",119985],["thread",129964],["thread",53771],["thread",128435],["thread",130873],["thread",56469],["thread",108232],["thread",87854],["thread",121584],["thread",63874],["thread",56551],["thread",114214],["thread",56672],["thread",50707],["thread",95842],["thread",45574],["thread",45513],["thread",54959],["thread",57596],["thread",58424],["thread",104804],["thread",54886],["thread",55775],["thread",6896],["thread",128843],["thread",62136],["thread",18503],["thread",112411],["thread",69562],["thread",49375],["thread",78573],["thread",85933],["thread",79382],["thread",89656],["thread",88610],["thread",65317],["thread",67342],["thread",56251],["thread",75526],["thread",56160],["thread",6193],["thread",134412],["thread",61828],["thread",58858],["thread",84379],["thread",95300],["thread",86766],["thread",83417],["thread",92891],["thread",108362],["thread",119412],["thread",91934],["thread",79252],["thread",122249],["thread",95207],["thread",50029],["thread",54533],["thread",119935],["thread",45208],["thread",100048],["thread",85214],["thread",93223],["thread",111721],["thread",98522],["thread",121825],["thread",94659],["thread",49921],["thread",121214],["thread",80271],["thread",75406],["thread",40177],["thread",51776],["thread",60412],["thread",93236],["thread",58844],["thread",89346],["thread",47183],["thread",47279],["thread",84804],["thread",84006],["thread",26370],["thread",1224],["thread",612],["thread",40157],["thread",131805],["thread",80436],["thread",9014],["thread",107270],["thread",83432],["thread",903],["thread",56608],["thread",33467],["thread",70157],["thread",67876],["thread",104817],["thread",36204],["thread",122570],["thread",77904],["thread",52368],["thread",111532],["thread",50729],["thread",86214],["thread",60256],["thread",41037],["thread",78211],["thread",80612],["thread",58197],["thread",98360],["thread",132137],["thread",107619],["thread",55835],["thread",114446],["thread",57228],["thread",107967],["thread",88174],["thread",53742],["thread",760],["thread",49279],["thread",122054],["thread",77836],["thread",93058],["thread",76388],["thread",87348],["thread",84414],["thread",122086],["thread",101531],["thread",56666],["thread",53140],["thread",56950],["thread",106072]]
Run Time: 0.056425
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.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |