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 (56227, 100185, 19429, 99955, 79382, 96173, 92701, 104481, 104520, 77410, 62136, 128614, 104097, 43750, 128802, 45513, 89644, 51605, 81363, 79997, 104590, 56084, 121904, 51961, 134376, 49117, 55090, 1190, 66955, 122681, 57652, 88219, 904, 55837, 40177, 63634, 60524, 120396, 85212, 66760, 66821, 41422, 134006, 128704, 114528, 56666, 51914, 86475, 51235, 47386, 83874, 45333, 111532, 94659, 74272, 123721, 20102, 62527, 58275, 56056, 55372, 105163, 71077, 74609, 108949, 93058, 75695, 110142, 56541, 120105, 103416, 760, 40353, 67370, 80528, 87455, 45236, 110094, 44072, 104804, 85647, 55381, 75146, 88388, 128356, 90519, 110357, 84310, 55903, 56243, 119929, 57506, 81294, 99094, 116914, 54887, 131022, 90003, 60414, 120454, 109104, 1218, 95307, 129936, 62779, 57591, 135662, 20336, 51771, 58858, 45208, 122570, 119412, 64986, 56655, 107455, 77836, 95106, 76914, 56611, 93110, 60128, 87624, 57492, 28004, 83238, 85933, 85829, 65704, 18403, 54532, 103125, 2819, 4760, 67257, 52611, 91691, 2481, 107125, 49159, 64719, 100764, 107244, 18291, 58424, 47183, 74740, 133393, 84645, 43489, 759, 115644, 57008, 56551, 134375, 60256, 53783, 95413, 44447, 67876, 121256, 82815, 66248, 113160, 78662, 46831, 86813, 86308, 85217, 81237, 89346, 106072, 71949, 83403, 5251, 87854, 51200, 90928, 11068, 57815, 128761, 56387, 57457, 132137, 51776, 55013, 53494, 109403, 1217, 122249, 115604, 81588, 106439, 35642, 88542, 86214, 131248, 24851, 114446, 38734, 71242, 53771, 83658, 96861, 114214, 87026, 54533, 61104, 112441, 53805, 58476, 11677, 111831, 41331, 86766, 115896, 56223, 68050, 94658, 65047, 6430, 79398, 77351, 108326, 58197, 80143, 56657, 55618, 18503, 36204, 612, 56904, 6304, 121825, 119233, 69485, 49949, 436, 66513, 114207, 43699, 57737, 82077, 54886, 125479, 55431, 67342, 47375, 47914, 82176, 97014, 98852, 95059, 75526, 36832, 134413, 93842, 86370, 49415, 2748, 114896, 57071, 119888, 119935, 108434, 86105, 103771, 129882, 81282, 75406, 61627, 120395, 4148, 122086, 56160, 47279, 74090, 57592, 56672, 107478, 49472, 56486, 78234, 107619, 55775, 61828, 51459, 108152, 69620, 119982, 110743, 89656, 101531, 57155, 57596, 59512, 70225, 26370, 59383, 128843)
Run Time: 0.009969
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, 1711716063, 1711719663, [["thread",56227],["thread",100185],["thread",19429],["thread",99955],["thread",79382],["thread",96173],["thread",92701],["thread",104481],["thread",104520],["thread",77410],["thread",62136],["thread",128614],["thread",104097],["thread",43750],["thread",128802],["thread",45513],["thread",89644],["thread",51605],["thread",81363],["thread",79997],["thread",104590],["thread",56084],["thread",121904],["thread",51961],["thread",134376],["thread",49117],["thread",55090],["thread",1190],["thread",66955],["thread",122681],["thread",57652],["thread",88219],["thread",904],["thread",55837],["thread",40177],["thread",63634],["thread",60524],["thread",120396],["thread",85212],["thread",66760],["thread",66821],["thread",41422],["thread",134006],["thread",128704],["thread",114528],["thread",56666],["thread",51914],["thread",86475],["thread",51235],["thread",47386],["thread",83874],["thread",45333],["thread",111532],["thread",94659],["thread",74272],["thread",123721],["thread",20102],["thread",62527],["thread",58275],["thread",56056],["thread",55372],["thread",105163],["thread",71077],["thread",74609],["thread",108949],["thread",93058],["thread",75695],["thread",110142],["thread",56541],["thread",120105],["thread",103416],["thread",760],["thread",40353],["thread",67370],["thread",80528],["thread",87455],["thread",45236],["thread",110094],["thread",44072],["thread",104804],["thread",85647],["thread",55381],["thread",75146],["thread",88388],["thread",128356],["thread",90519],["thread",110357],["thread",84310],["thread",55903],["thread",56243],["thread",119929],["thread",57506],["thread",81294],["thread",99094],["thread",116914],["thread",54887],["thread",131022],["thread",90003],["thread",60414],["thread",120454],["thread",109104],["thread",1218],["thread",95307],["thread",129936],["thread",62779],["thread",57591],["thread",135662],["thread",20336],["thread",51771],["thread",58858],["thread",45208],["thread",122570],["thread",119412],["thread",64986],["thread",56655],["thread",107455],["thread",77836],["thread",95106],["thread",76914],["thread",56611],["thread",93110],["thread",60128],["thread",87624],["thread",57492],["thread",28004],["thread",83238],["thread",85933],["thread",85829],["thread",65704],["thread",18403],["thread",54532],["thread",103125],["thread",2819],["thread",4760],["thread",67257],["thread",52611],["thread",91691],["thread",2481],["thread",107125],["thread",49159],["thread",64719],["thread",100764],["thread",107244],["thread",18291],["thread",58424],["thread",47183],["thread",74740],["thread",133393],["thread",84645],["thread",43489],["thread",759],["thread",115644],["thread",57008],["thread",56551],["thread",134375],["thread",60256],["thread",53783],["thread",95413],["thread",44447],["thread",67876],["thread",121256],["thread",82815],["thread",66248],["thread",113160],["thread",78662],["thread",46831],["thread",86813],["thread",86308],["thread",85217],["thread",81237],["thread",89346],["thread",106072],["thread",71949],["thread",83403],["thread",5251],["thread",87854],["thread",51200],["thread",90928],["thread",11068],["thread",57815],["thread",128761],["thread",56387],["thread",57457],["thread",132137],["thread",51776],["thread",55013],["thread",53494],["thread",109403],["thread",1217],["thread",122249],["thread",115604],["thread",81588],["thread",106439],["thread",35642],["thread",88542],["thread",86214],["thread",131248],["thread",24851],["thread",114446],["thread",38734],["thread",71242],["thread",53771],["thread",83658],["thread",96861],["thread",114214],["thread",87026],["thread",54533],["thread",61104],["thread",112441],["thread",53805],["thread",58476],["thread",11677],["thread",111831],["thread",41331],["thread",86766],["thread",115896],["thread",56223],["thread",68050],["thread",94658],["thread",65047],["thread",6430],["thread",79398],["thread",77351],["thread",108326],["thread",58197],["thread",80143],["thread",56657],["thread",55618],["thread",18503],["thread",36204],["thread",612],["thread",56904],["thread",6304],["thread",121825],["thread",119233],["thread",69485],["thread",49949],["thread",436],["thread",66513],["thread",114207],["thread",43699],["thread",57737],["thread",82077],["thread",54886],["thread",125479],["thread",55431],["thread",67342],["thread",47375],["thread",47914],["thread",82176],["thread",97014],["thread",98852],["thread",95059],["thread",75526],["thread",36832],["thread",134413],["thread",93842],["thread",86370],["thread",49415],["thread",2748],["thread",114896],["thread",57071],["thread",119888],["thread",119935],["thread",108434],["thread",86105],["thread",103771],["thread",129882],["thread",81282],["thread",75406],["thread",61627],["thread",120395],["thread",4148],["thread",122086],["thread",56160],["thread",47279],["thread",74090],["thread",57592],["thread",56672],["thread",107478],["thread",49472],["thread",56486],["thread",78234],["thread",107619],["thread",55775],["thread",61828],["thread",51459],["thread",108152],["thread",69620],["thread",119982],["thread",110743],["thread",89656],["thread",101531],["thread",57155],["thread",57596],["thread",59512],["thread",70225],["thread",26370],["thread",59383],["thread",128843]]
Run Time: 0.089611
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.000084
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |