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 (128077, 57508, 1948, 3744, 1930, 29492, 90227, 1935, 1923, 120572, 83235, 76867, 1138, 37657, 2076, 46181, 30091, 38900, 2504, 2512, 19650, 102327, 1907, 126531, 54163, 27956, 54561, 83093, 20154, 90873, 1929, 75358, 1899, 111725, 96424, 96532, 1940, 134690, 107571, 97428, 104318, 87036, 132156, 98249, 1417, 13325, 8310, 39404, 67987, 121066, 21998, 24007, 119855, 46315, 132529, 57064, 906, 17695, 2891, 63058, 109640, 32218, 3288, 95211, 2713, 101437, 14582, 1520, 15330, 1909, 20802, 7320, 1762, 78109, 110663, 99775, 112310, 21226, 15717, 131792, 63380, 77253, 53941, 78687, 78588, 94584, 83734, 120874, 1949, 2666, 6139, 1419, 24648, 1747, 79144, 116851, 133649, 128146, 60239, 1752, 113446, 19398, 87338, 27861, 1826, 1679, 86321, 2488, 78527, 85851, 2094, 35867, 85389, 121377, 67233, 100663, 15212, 1681, 106017, 9641, 124242, 104715, 106865, 85734, 11465, 19593, 97712, 116481, 8690, 119098, 1754, 132791, 8670, 127378, 85130, 1676, 122576, 98019, 1804, 546, 121676, 74151, 1965, 1507, 76644, 1776, 84605, 1809, 78112, 111295, 68089, 42628, 107769, 87037, 120413, 55910, 76643, 1513, 102083, 93626, 60817, 49873, 1510, 109256, 1527, 79493, 19669, 1921, 76119, 39176, 78999, 78688, 72084, 123688, 84119, 67342, 10559, 1925, 104922, 3893, 38499, 82101, 5630, 1803, 134224, 1757, 2013, 908, 14984, 1934, 2501, 1952, 1202, 26901, 112266, 102272, 128802, 8625, 83342, 76346, 1805, 130209, 50855, 2785, 23214, 82644, 1818, 1825, 81759, 3251, 10579, 19165, 88428, 117926, 1830, 1758, 3545, 61022, 93209, 2100, 66557, 128940, 1587, 106986, 67513, 126005, 76641, 1798, 90926, 112247, 55527, 8499, 68513, 59927, 9904, 72516, 5407, 1794, 2073, 76273, 86250, 11395, 64104, 116946, 45769, 1756, 1740, 72098, 119377, 69250, 55925, 116172, 1927, 51285, 106100, 97019, 80538, 467, 115485, 11004, 2536, 111033, 2091, 55265, 2516, 1821, 5233, 1760, 1157, 132742, 91864, 81633, 120212, 1848, 90561, 119380, 45855, 2684, 110973, 1963, 8737, 18636, 54584, 1153, 95842, 20579, 63037, 51178, 974, 900, 2537, 76645, 109704, 76368, 3931, 37539, 6623, 519, 127154, 136859)
Run Time: 0.025006
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: 142, 0, 1714186780, 1714190380, [["thread",128077],["thread",57508],["thread",1948],["thread",3744],["thread",1930],["thread",29492],["thread",90227],["thread",1935],["thread",1923],["thread",120572],["thread",83235],["thread",76867],["thread",1138],["thread",37657],["thread",2076],["thread",46181],["thread",30091],["thread",38900],["thread",2504],["thread",2512],["thread",19650],["thread",102327],["thread",1907],["thread",126531],["thread",54163],["thread",27956],["thread",54561],["thread",83093],["thread",20154],["thread",90873],["thread",1929],["thread",75358],["thread",1899],["thread",111725],["thread",96424],["thread",96532],["thread",1940],["thread",134690],["thread",107571],["thread",97428],["thread",104318],["thread",87036],["thread",132156],["thread",98249],["thread",1417],["thread",13325],["thread",8310],["thread",39404],["thread",67987],["thread",121066],["thread",21998],["thread",24007],["thread",119855],["thread",46315],["thread",132529],["thread",57064],["thread",906],["thread",17695],["thread",2891],["thread",63058],["thread",109640],["thread",32218],["thread",3288],["thread",95211],["thread",2713],["thread",101437],["thread",14582],["thread",1520],["thread",15330],["thread",1909],["thread",20802],["thread",7320],["thread",1762],["thread",78109],["thread",110663],["thread",99775],["thread",112310],["thread",21226],["thread",15717],["thread",131792],["thread",63380],["thread",77253],["thread",53941],["thread",78687],["thread",78588],["thread",94584],["thread",83734],["thread",120874],["thread",1949],["thread",2666],["thread",6139],["thread",1419],["thread",24648],["thread",1747],["thread",79144],["thread",116851],["thread",133649],["thread",128146],["thread",60239],["thread",1752],["thread",113446],["thread",19398],["thread",87338],["thread",27861],["thread",1826],["thread",1679],["thread",86321],["thread",2488],["thread",78527],["thread",85851],["thread",2094],["thread",35867],["thread",85389],["thread",121377],["thread",67233],["thread",100663],["thread",15212],["thread",1681],["thread",106017],["thread",9641],["thread",124242],["thread",104715],["thread",106865],["thread",85734],["thread",11465],["thread",19593],["thread",97712],["thread",116481],["thread",8690],["thread",119098],["thread",1754],["thread",132791],["thread",8670],["thread",127378],["thread",85130],["thread",1676],["thread",122576],["thread",98019],["thread",1804],["thread",546],["thread",121676],["thread",74151],["thread",1965],["thread",1507],["thread",76644],["thread",1776],["thread",84605],["thread",1809],["thread",78112],["thread",111295],["thread",68089],["thread",42628],["thread",107769],["thread",87037],["thread",120413],["thread",55910],["thread",76643],["thread",1513],["thread",102083],["thread",93626],["thread",60817],["thread",49873],["thread",1510],["thread",109256],["thread",1527],["thread",79493],["thread",19669],["thread",1921],["thread",76119],["thread",39176],["thread",78999],["thread",78688],["thread",72084],["thread",123688],["thread",84119],["thread",67342],["thread",10559],["thread",1925],["thread",104922],["thread",3893],["thread",38499],["thread",82101],["thread",5630],["thread",1803],["thread",134224],["thread",1757],["thread",2013],["thread",908],["thread",14984],["thread",1934],["thread",2501],["thread",1952],["thread",1202],["thread",26901],["thread",112266],["thread",102272],["thread",128802],["thread",8625],["thread",83342],["thread",76346],["thread",1805],["thread",130209],["thread",50855],["thread",2785],["thread",23214],["thread",82644],["thread",1818],["thread",1825],["thread",81759],["thread",3251],["thread",10579],["thread",19165],["thread",88428],["thread",117926],["thread",1830],["thread",1758],["thread",3545],["thread",61022],["thread",93209],["thread",2100],["thread",66557],["thread",128940],["thread",1587],["thread",106986],["thread",67513],["thread",126005],["thread",76641],["thread",1798],["thread",90926],["thread",112247],["thread",55527],["thread",8499],["thread",68513],["thread",59927],["thread",9904],["thread",72516],["thread",5407],["thread",1794],["thread",2073],["thread",76273],["thread",86250],["thread",11395],["thread",64104],["thread",116946],["thread",45769],["thread",1756],["thread",1740],["thread",72098],["thread",119377],["thread",69250],["thread",55925],["thread",116172],["thread",1927],["thread",51285],["thread",106100],["thread",97019],["thread",80538],["thread",467],["thread",115485],["thread",11004],["thread",2536],["thread",111033],["thread",2091],["thread",55265],["thread",2516],["thread",1821],["thread",5233],["thread",1760],["thread",1157],["thread",132742],["thread",91864],["thread",81633],["thread",120212],["thread",1848],["thread",90561],["thread",119380],["thread",45855],["thread",2684],["thread",110973],["thread",1963],["thread",8737],["thread",18636],["thread",54584],["thread",1153],["thread",95842],["thread",20579],["thread",63037],["thread",51178],["thread",974],["thread",900],["thread",2537],["thread",76645],["thread",109704],["thread",76368],["thread",3931],["thread",37539],["thread",6623],["thread",519],["thread",127154],["thread",136859]]
Run Time: 0.004269
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.000112
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |