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 (9014, 124268, 36832, 2480, 6304, 51771, 33467, 49375, 78667, 125390, 119982, 107967, 65704, 58844, 84106, 134713, 86475, 82418, 112798, 51028, 131248, 98812, 100048, 128962, 3491, 110142, 51459, 83432, 47914, 19429, 134413, 97014, 33391, 75406, 120690, 54533, 81588, 56169, 104520, 92146, 84275, 6896, 122570, 84804, 78205, 86370, 57612, 69887, 105163, 90928, 76661, 51605, 111532, 69625, 50029, 56469, 33463, 128843, 21306, 1218, 18403, 82077, 113822, 93842, 58197, 11677, 131803, 53771, 62336, 77410, 69769, 81330, 91934, 75556, 103771, 64465, 91692, 68082, 38749, 107455, 135662, 111819, 56519, 134375, 56608, 134412, 6193, 41331, 95842, 24095, 115644, 54532, 88219, 74080, 78454, 87249, 134247, 53140, 55775, 120454, 79398, 107087, 41396, 55835, 64909, 1362, 66268, 61110, 74609, 4148, 110944, 59605, 55903, 103416, 114214, 51200, 760, 52368, 56056, 66955, 71901, 57737, 126960, 134376, 119929, 55381, 61353, 104804, 98902, 66009, 71077, 111831, 90519, 108434, 121825, 45208, 53163, 1224, 112521, 114896, 43703, 49415, 84898, 96861, 122054, 65317, 84310, 55837, 44447, 72091, 57492, 92891, 5251, 40586, 67976, 72178, 109256, 58079, 85217, 53973, 57822, 54887, 903, 93058, 78211, 77351, 1556, 53742, 122053, 74171, 57821, 84497, 83887, 56657, 64149, 83403, 20102, 49159, 57805, 87829, 473, 33466, 121843, 86214, 81294, 100792, 75146, 87854, 36740, 123499, 120296, 69858, 56545, 56243, 76607, 81855, 113479, 49085, 60256, 56666, 35187, 57591, 89171, 47183, 129936, 99094, 50707, 49483, 55859, 43835, 46831, 57457, 122077, 56956, 47279, 88632, 36204, 106439, 55636, 44072, 109403, 107619, 81708, 96173, 54959, 87624, 104817, 73777, 108949, 123721, 111843, 53081, 113833, 128356, 56227, 70225, 119862, 56173, 108232, 56130, 131022, 84006, 89555, 69562, 1118, 80612, 110357, 105164, 62779, 76914, 41435, 36795, 66825, 48790, 56250, 67370, 95307, 41422, 84749, 63874, 89644, 131805, 98973, 81312, 56084, 132191, 67876, 57932, 119888, 43750, 99955, 62133, 81363, 43489, 2481, 73580, 66235, 133393, 123881, 59512, 1217, 81092, 52611, 55768, 111725, 57868, 119412, 46399, 57652, 85829, 58424, 120396, 49117, 51235, 82752, 123609, 69620, 61458, 58339, 7504)
Run Time: 0.075886
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, 1711671438, 1711675038, [["thread",9014],["thread",124268],["thread",36832],["thread",2480],["thread",6304],["thread",51771],["thread",33467],["thread",49375],["thread",78667],["thread",125390],["thread",119982],["thread",107967],["thread",65704],["thread",58844],["thread",84106],["thread",134713],["thread",86475],["thread",82418],["thread",112798],["thread",51028],["thread",131248],["thread",98812],["thread",100048],["thread",128962],["thread",3491],["thread",110142],["thread",51459],["thread",83432],["thread",47914],["thread",19429],["thread",134413],["thread",97014],["thread",33391],["thread",75406],["thread",120690],["thread",54533],["thread",81588],["thread",56169],["thread",104520],["thread",92146],["thread",84275],["thread",6896],["thread",122570],["thread",84804],["thread",78205],["thread",86370],["thread",57612],["thread",69887],["thread",105163],["thread",90928],["thread",76661],["thread",51605],["thread",111532],["thread",69625],["thread",50029],["thread",56469],["thread",33463],["thread",128843],["thread",21306],["thread",1218],["thread",18403],["thread",82077],["thread",113822],["thread",93842],["thread",58197],["thread",11677],["thread",131803],["thread",53771],["thread",62336],["thread",77410],["thread",69769],["thread",81330],["thread",91934],["thread",75556],["thread",103771],["thread",64465],["thread",91692],["thread",68082],["thread",38749],["thread",107455],["thread",135662],["thread",111819],["thread",56519],["thread",134375],["thread",56608],["thread",134412],["thread",6193],["thread",41331],["thread",95842],["thread",24095],["thread",115644],["thread",54532],["thread",88219],["thread",74080],["thread",78454],["thread",87249],["thread",134247],["thread",53140],["thread",55775],["thread",120454],["thread",79398],["thread",107087],["thread",41396],["thread",55835],["thread",64909],["thread",1362],["thread",66268],["thread",61110],["thread",74609],["thread",4148],["thread",110944],["thread",59605],["thread",55903],["thread",103416],["thread",114214],["thread",51200],["thread",760],["thread",52368],["thread",56056],["thread",66955],["thread",71901],["thread",57737],["thread",126960],["thread",134376],["thread",119929],["thread",55381],["thread",61353],["thread",104804],["thread",98902],["thread",66009],["thread",71077],["thread",111831],["thread",90519],["thread",108434],["thread",121825],["thread",45208],["thread",53163],["thread",1224],["thread",112521],["thread",114896],["thread",43703],["thread",49415],["thread",84898],["thread",96861],["thread",122054],["thread",65317],["thread",84310],["thread",55837],["thread",44447],["thread",72091],["thread",57492],["thread",92891],["thread",5251],["thread",40586],["thread",67976],["thread",72178],["thread",109256],["thread",58079],["thread",85217],["thread",53973],["thread",57822],["thread",54887],["thread",903],["thread",93058],["thread",78211],["thread",77351],["thread",1556],["thread",53742],["thread",122053],["thread",74171],["thread",57821],["thread",84497],["thread",83887],["thread",56657],["thread",64149],["thread",83403],["thread",20102],["thread",49159],["thread",57805],["thread",87829],["thread",473],["thread",33466],["thread",121843],["thread",86214],["thread",81294],["thread",100792],["thread",75146],["thread",87854],["thread",36740],["thread",123499],["thread",120296],["thread",69858],["thread",56545],["thread",56243],["thread",76607],["thread",81855],["thread",113479],["thread",49085],["thread",60256],["thread",56666],["thread",35187],["thread",57591],["thread",89171],["thread",47183],["thread",129936],["thread",99094],["thread",50707],["thread",49483],["thread",55859],["thread",43835],["thread",46831],["thread",57457],["thread",122077],["thread",56956],["thread",47279],["thread",88632],["thread",36204],["thread",106439],["thread",55636],["thread",44072],["thread",109403],["thread",107619],["thread",81708],["thread",96173],["thread",54959],["thread",87624],["thread",104817],["thread",73777],["thread",108949],["thread",123721],["thread",111843],["thread",53081],["thread",113833],["thread",128356],["thread",56227],["thread",70225],["thread",119862],["thread",56173],["thread",108232],["thread",56130],["thread",131022],["thread",84006],["thread",89555],["thread",69562],["thread",1118],["thread",80612],["thread",110357],["thread",105164],["thread",62779],["thread",76914],["thread",41435],["thread",36795],["thread",66825],["thread",48790],["thread",56250],["thread",67370],["thread",95307],["thread",41422],["thread",84749],["thread",63874],["thread",89644],["thread",131805],["thread",98973],["thread",81312],["thread",56084],["thread",132191],["thread",67876],["thread",57932],["thread",119888],["thread",43750],["thread",99955],["thread",62133],["thread",81363],["thread",43489],["thread",2481],["thread",73580],["thread",66235],["thread",133393],["thread",123881],["thread",59512],["thread",1217],["thread",81092],["thread",52611],["thread",55768],["thread",111725],["thread",57868],["thread",119412],["thread",46399],["thread",57652],["thread",85829],["thread",58424],["thread",120396],["thread",49117],["thread",51235],["thread",82752],["thread",123609],["thread",69620],["thread",61458],["thread",58339],["thread",7504]]
Run Time: 0.036140
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.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |