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 (65047, 112411, 65956, 98902, 56130, 120454, 1218, 41396, 78234, 81364, 53140, 81092, 87348, 110045, 82176, 436, 107619, 52611, 57592, 56227, 119233, 54532, 109256, 126960, 58067, 120396, 62133, 73580, 1556, 4148, 119888, 49921, 107967, 49949, 17611, 55090, 67342, 51814, 76914, 49483, 59494, 18503, 128435, 75343, 98973, 71242, 36740, 60412, 95826, 1118, 58351, 93058, 89656, 123881, 2748, 51330, 75695, 61106, 110357, 61458, 57489, 78454, 39219, 57591, 56955, 1190, 123721, 111856, 45236, 61977, 108949, 103125, 124268, 125390, 66248, 20336, 111725, 50029, 63634, 84310, 56250, 80436, 53079, 56173, 54886, 84645, 56611, 95207, 51971, 99955, 33467, 89555, 73709, 82815, 35187, 49279, 51467, 56801, 89346, 104520, 47183, 1702, 61828, 128614, 61110, 58476, 108326, 134970, 134414, 113160, 128843, 56545, 116866, 74080, 107419, 80528, 128002, 84898, 58244, 33466, 110142, 119862, 67876, 58858, 73128, 56657, 41331, 56956, 119929, 120296, 84497, 100792, 4642, 78205, 50729, 44072, 113833, 122054, 115604, 55372, 75556, 56608, 56666, 109152, 56251, 110944, 114061, 56486, 56223, 90003, 97014, 111532, 114246, 58336, 41037, 53171, 95300, 53163, 122249, 903, 83887, 83403, 110094, 134006, 133393, 83417, 55013, 99094, 40586, 134412, 77410, 74090, 128802, 107244, 79997, 35642, 98522, 56469, 125105, 85933, 380, 66199, 108434, 114446, 38752, 53783, 57822, 119982, 51459, 70225, 109654, 40353, 86813, 49159, 120727, 84275, 57652, 92146, 88353, 46399, 57805, 42072, 58844, 78211, 56160, 83238, 45574, 49415, 111841, 51200, 56502, 76388, 55768, 60939, 128988, 57868, 56551, 132191, 57155, 69769, 93236, 66539, 75526, 86105, 79382, 41435, 1489, 85829, 11027, 18291, 73492, 51914, 112798, 81330, 88632, 80143, 57659, 135662, 63874, 78573, 85647, 57821, 60524, 36795, 121825, 93223, 134713, 23419, 105163, 136662, 36838, 1265, 63140, 59605, 121091, 128761, 27133, 66513, 107270, 123499, 43750, 19429, 57612, 50291, 84804, 87455, 40970, 55640, 49472, 104481, 53742, 51235, 107648, 91692, 6896, 59731, 122077, 53750, 88542, 68050, 80011, 101531, 62336, 82752, 56243, 56306, 91894, 7504, 38749, 74919, 62527, 1217, 119412, 123609, 44711, 134740, 57506, 6304, 131248, 104817)
Run Time: 0.012878
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, 1713607645, 1713611245, [["thread",65047],["thread",112411],["thread",65956],["thread",98902],["thread",56130],["thread",120454],["thread",1218],["thread",41396],["thread",78234],["thread",81364],["thread",53140],["thread",81092],["thread",87348],["thread",110045],["thread",82176],["thread",436],["thread",107619],["thread",52611],["thread",57592],["thread",56227],["thread",119233],["thread",54532],["thread",109256],["thread",126960],["thread",58067],["thread",120396],["thread",62133],["thread",73580],["thread",1556],["thread",4148],["thread",119888],["thread",49921],["thread",107967],["thread",49949],["thread",17611],["thread",55090],["thread",67342],["thread",51814],["thread",76914],["thread",49483],["thread",59494],["thread",18503],["thread",128435],["thread",75343],["thread",98973],["thread",71242],["thread",36740],["thread",60412],["thread",95826],["thread",1118],["thread",58351],["thread",93058],["thread",89656],["thread",123881],["thread",2748],["thread",51330],["thread",75695],["thread",61106],["thread",110357],["thread",61458],["thread",57489],["thread",78454],["thread",39219],["thread",57591],["thread",56955],["thread",1190],["thread",123721],["thread",111856],["thread",45236],["thread",61977],["thread",108949],["thread",103125],["thread",124268],["thread",125390],["thread",66248],["thread",20336],["thread",111725],["thread",50029],["thread",63634],["thread",84310],["thread",56250],["thread",80436],["thread",53079],["thread",56173],["thread",54886],["thread",84645],["thread",56611],["thread",95207],["thread",51971],["thread",99955],["thread",33467],["thread",89555],["thread",73709],["thread",82815],["thread",35187],["thread",49279],["thread",51467],["thread",56801],["thread",89346],["thread",104520],["thread",47183],["thread",1702],["thread",61828],["thread",128614],["thread",61110],["thread",58476],["thread",108326],["thread",134970],["thread",134414],["thread",113160],["thread",128843],["thread",56545],["thread",116866],["thread",74080],["thread",107419],["thread",80528],["thread",128002],["thread",84898],["thread",58244],["thread",33466],["thread",110142],["thread",119862],["thread",67876],["thread",58858],["thread",73128],["thread",56657],["thread",41331],["thread",56956],["thread",119929],["thread",120296],["thread",84497],["thread",100792],["thread",4642],["thread",78205],["thread",50729],["thread",44072],["thread",113833],["thread",122054],["thread",115604],["thread",55372],["thread",75556],["thread",56608],["thread",56666],["thread",109152],["thread",56251],["thread",110944],["thread",114061],["thread",56486],["thread",56223],["thread",90003],["thread",97014],["thread",111532],["thread",114246],["thread",58336],["thread",41037],["thread",53171],["thread",95300],["thread",53163],["thread",122249],["thread",903],["thread",83887],["thread",83403],["thread",110094],["thread",134006],["thread",133393],["thread",83417],["thread",55013],["thread",99094],["thread",40586],["thread",134412],["thread",77410],["thread",74090],["thread",128802],["thread",107244],["thread",79997],["thread",35642],["thread",98522],["thread",56469],["thread",125105],["thread",85933],["thread",380],["thread",66199],["thread",108434],["thread",114446],["thread",38752],["thread",53783],["thread",57822],["thread",119982],["thread",51459],["thread",70225],["thread",109654],["thread",40353],["thread",86813],["thread",49159],["thread",120727],["thread",84275],["thread",57652],["thread",92146],["thread",88353],["thread",46399],["thread",57805],["thread",42072],["thread",58844],["thread",78211],["thread",56160],["thread",83238],["thread",45574],["thread",49415],["thread",111841],["thread",51200],["thread",56502],["thread",76388],["thread",55768],["thread",60939],["thread",128988],["thread",57868],["thread",56551],["thread",132191],["thread",57155],["thread",69769],["thread",93236],["thread",66539],["thread",75526],["thread",86105],["thread",79382],["thread",41435],["thread",1489],["thread",85829],["thread",11027],["thread",18291],["thread",73492],["thread",51914],["thread",112798],["thread",81330],["thread",88632],["thread",80143],["thread",57659],["thread",135662],["thread",63874],["thread",78573],["thread",85647],["thread",57821],["thread",60524],["thread",36795],["thread",121825],["thread",93223],["thread",134713],["thread",23419],["thread",105163],["thread",136662],["thread",36838],["thread",1265],["thread",63140],["thread",59605],["thread",121091],["thread",128761],["thread",27133],["thread",66513],["thread",107270],["thread",123499],["thread",43750],["thread",19429],["thread",57612],["thread",50291],["thread",84804],["thread",87455],["thread",40970],["thread",55640],["thread",49472],["thread",104481],["thread",53742],["thread",51235],["thread",107648],["thread",91692],["thread",6896],["thread",59731],["thread",122077],["thread",53750],["thread",88542],["thread",68050],["thread",80011],["thread",101531],["thread",62336],["thread",82752],["thread",56243],["thread",56306],["thread",91894],["thread",7504],["thread",38749],["thread",74919],["thread",62527],["thread",1217],["thread",119412],["thread",123609],["thread",44711],["thread",134740],["thread",57506],["thread",6304],["thread",131248],["thread",104817]]
Run Time: 0.009282
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |