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 (58336, 91542, 136662, 35642, 41422, 62336, 111761, 86370, 83874, 131803, 57071, 58476, 56294, 9014, 17611, 55775, 85781, 120395, 113822, 80271, 78698, 90003, 82815, 40177, 98360, 114214, 65956, 416, 109152, 54959, 67976, 67503, 98902, 128614, 111054, 56904, 123721, 107125, 56608, 55381, 66513, 1702, 93110, 51914, 33391, 40586, 98736, 70157, 80434, 69858, 129882, 49415, 50729, 41329, 79909, 133393, 55618, 83417, 40353, 95826, 73777, 58339, 131248, 116866, 92891, 69562, 120105, 110094, 110357, 96861, 119862, 40970, 56657, 95307, 20102, 7504, 51028, 18291, 64909, 121214, 55903, 46831, 121256, 1556, 84497, 78234, 88388, 57492, 107648, 77351, 83658, 134740, 85214, 1362, 120690, 56502, 57506, 60256, 56084, 131022, 80011, 24851, 104520, 115604, 53973, 57489, 55372, 64465, 113479, 77836, 76607, 56173, 56551, 53144, 107270, 73141, 54887, 81855, 56306, 25689, 83403, 91894, 53163, 47375, 57596, 42072, 57806, 57612, 51605, 89026, 49375, 79382, 53771, 67257, 115644, 122570, 119985, 57932, 95207, 52611, 107087, 86766, 111831, 45574, 53140, 98412, 55835, 74090, 122077, 51776, 11177, 6189, 4642, 88353, 88610, 55859, 49117, 38749, 121584, 4148, 57592, 51216, 380, 51235, 126960, 76755, 84310, 44447, 88146, 104804, 66248, 94054, 66955, 86475, 111819, 101531, 51971, 45333, 40157, 69887, 61106, 83238, 53805, 72865, 55816, 49949, 104481, 93058, 77904, 41037, 66058, 67370, 79997, 128843, 92146, 132191, 66009, 114207, 33467, 108232, 45208, 47279, 49921, 55837, 43699, 128988, 81364, 63140, 121904, 108152, 56160, 47183, 43835, 86813, 36832, 58275, 6304, 84414, 56954, 64149, 65704, 51200, 78573, 98852, 47914, 1118, 111841, 71901, 28004, 61353, 112521, 81588, 119935, 128002, 135662, 91691, 57591, 113833, 82418, 98973, 53642, 59731, 88219, 61458, 21306, 50291, 11677, 59605, 121843, 95300, 84006, 56956, 6430, 57822, 74272, 85829, 105163, 122053, 53197, 64986, 114246, 79803, 87829, 76914, 48862, 88632, 35187, 23419, 57008, 57659, 60939, 33463, 53171, 56223, 123264, 1265, 53936, 57652, 125105, 19429, 104097, 122681, 45513, 6193, 74919, 66825, 65047, 84749, 26370, 74171, 56469, 134413, 84804, 89869, 93236, 62136, 134412, 56672, 50707, 61110)
Run Time: 0.012391
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, 1714178394, 1714181994, [["thread",58336],["thread",91542],["thread",136662],["thread",35642],["thread",41422],["thread",62336],["thread",111761],["thread",86370],["thread",83874],["thread",131803],["thread",57071],["thread",58476],["thread",56294],["thread",9014],["thread",17611],["thread",55775],["thread",85781],["thread",120395],["thread",113822],["thread",80271],["thread",78698],["thread",90003],["thread",82815],["thread",40177],["thread",98360],["thread",114214],["thread",65956],["thread",416],["thread",109152],["thread",54959],["thread",67976],["thread",67503],["thread",98902],["thread",128614],["thread",111054],["thread",56904],["thread",123721],["thread",107125],["thread",56608],["thread",55381],["thread",66513],["thread",1702],["thread",93110],["thread",51914],["thread",33391],["thread",40586],["thread",98736],["thread",70157],["thread",80434],["thread",69858],["thread",129882],["thread",49415],["thread",50729],["thread",41329],["thread",79909],["thread",133393],["thread",55618],["thread",83417],["thread",40353],["thread",95826],["thread",73777],["thread",58339],["thread",131248],["thread",116866],["thread",92891],["thread",69562],["thread",120105],["thread",110094],["thread",110357],["thread",96861],["thread",119862],["thread",40970],["thread",56657],["thread",95307],["thread",20102],["thread",7504],["thread",51028],["thread",18291],["thread",64909],["thread",121214],["thread",55903],["thread",46831],["thread",121256],["thread",1556],["thread",84497],["thread",78234],["thread",88388],["thread",57492],["thread",107648],["thread",77351],["thread",83658],["thread",134740],["thread",85214],["thread",1362],["thread",120690],["thread",56502],["thread",57506],["thread",60256],["thread",56084],["thread",131022],["thread",80011],["thread",24851],["thread",104520],["thread",115604],["thread",53973],["thread",57489],["thread",55372],["thread",64465],["thread",113479],["thread",77836],["thread",76607],["thread",56173],["thread",56551],["thread",53144],["thread",107270],["thread",73141],["thread",54887],["thread",81855],["thread",56306],["thread",25689],["thread",83403],["thread",91894],["thread",53163],["thread",47375],["thread",57596],["thread",42072],["thread",57806],["thread",57612],["thread",51605],["thread",89026],["thread",49375],["thread",79382],["thread",53771],["thread",67257],["thread",115644],["thread",122570],["thread",119985],["thread",57932],["thread",95207],["thread",52611],["thread",107087],["thread",86766],["thread",111831],["thread",45574],["thread",53140],["thread",98412],["thread",55835],["thread",74090],["thread",122077],["thread",51776],["thread",11177],["thread",6189],["thread",4642],["thread",88353],["thread",88610],["thread",55859],["thread",49117],["thread",38749],["thread",121584],["thread",4148],["thread",57592],["thread",51216],["thread",380],["thread",51235],["thread",126960],["thread",76755],["thread",84310],["thread",44447],["thread",88146],["thread",104804],["thread",66248],["thread",94054],["thread",66955],["thread",86475],["thread",111819],["thread",101531],["thread",51971],["thread",45333],["thread",40157],["thread",69887],["thread",61106],["thread",83238],["thread",53805],["thread",72865],["thread",55816],["thread",49949],["thread",104481],["thread",93058],["thread",77904],["thread",41037],["thread",66058],["thread",67370],["thread",79997],["thread",128843],["thread",92146],["thread",132191],["thread",66009],["thread",114207],["thread",33467],["thread",108232],["thread",45208],["thread",47279],["thread",49921],["thread",55837],["thread",43699],["thread",128988],["thread",81364],["thread",63140],["thread",121904],["thread",108152],["thread",56160],["thread",47183],["thread",43835],["thread",86813],["thread",36832],["thread",58275],["thread",6304],["thread",84414],["thread",56954],["thread",64149],["thread",65704],["thread",51200],["thread",78573],["thread",98852],["thread",47914],["thread",1118],["thread",111841],["thread",71901],["thread",28004],["thread",61353],["thread",112521],["thread",81588],["thread",119935],["thread",128002],["thread",135662],["thread",91691],["thread",57591],["thread",113833],["thread",82418],["thread",98973],["thread",53642],["thread",59731],["thread",88219],["thread",61458],["thread",21306],["thread",50291],["thread",11677],["thread",59605],["thread",121843],["thread",95300],["thread",84006],["thread",56956],["thread",6430],["thread",57822],["thread",74272],["thread",85829],["thread",105163],["thread",122053],["thread",53197],["thread",64986],["thread",114246],["thread",79803],["thread",87829],["thread",76914],["thread",48862],["thread",88632],["thread",35187],["thread",23419],["thread",57008],["thread",57659],["thread",60939],["thread",33463],["thread",53171],["thread",56223],["thread",123264],["thread",1265],["thread",53936],["thread",57652],["thread",125105],["thread",19429],["thread",104097],["thread",122681],["thread",45513],["thread",6193],["thread",74919],["thread",66825],["thread",65047],["thread",84749],["thread",26370],["thread",74171],["thread",56469],["thread",134413],["thread",84804],["thread",89869],["thread",93236],["thread",62136],["thread",134412],["thread",56672],["thread",50707],["thread",61110]]
Run Time: 0.001434
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 |