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 (2842, 84338, 81633, 3455, 84595, 81311, 127633, 61064, 116706, 128761, 1518, 96265, 124680, 109158, 1969, 82844, 1968, 45945, 76346, 126635, 1377, 1967, 1970, 1944, 1788, 1801, 115480, 55920, 81490, 61131, 119098, 45855, 83093, 106954, 131792, 119389, 55044, 126674, 1906, 14984, 1828, 20146, 1949, 56390, 2510, 3545, 1756, 1762, 5407, 1777, 38900, 117029, 1833, 126719, 56866, 77426, 1815, 4126, 1838, 77475, 54518, 546, 55265, 870, 96296, 1672, 105735, 133150, 1389, 100235, 77425, 118942, 101295, 1971, 111589, 51420, 67233, 44509, 118705, 37657, 2705, 2073, 83737, 95799, 108874, 1896, 1779, 121825, 15328, 2775, 88428, 19540, 1684, 14542, 79947, 1799, 1909, 62674, 1746, 83958, 78454, 34633, 75835, 92629, 104251, 11996, 76773, 7334, 104715, 125418, 27194, 105239, 84335, 1614, 77562, 95211, 84478, 85130, 1819, 1611, 68271, 900, 62577, 1905, 1748, 111342, 117729, 19165, 74134, 27912, 73828, 128077, 97645, 9643, 1947, 12008, 108025, 132742, 74726, 49438, 98016, 82101, 15421, 19456, 61141, 3394, 122624, 37539, 1520, 21264, 43070, 67109, 111409, 1900, 55357, 1912, 1964, 64339, 111295, 2883, 1831, 72416, 96374, 66557, 76273, 77809, 467, 92249, 45769, 121676, 86269, 2019, 1601, 84930, 80162, 1981, 21917, 126220, 55143, 21726, 52084, 1742, 14602, 67513, 2094, 108429, 128212, 15749, 1150, 1570, 127739, 125596, 136556, 50180, 73427, 67306, 98201, 21956, 15717, 1935, 66675, 88872, 3695, 78243, 126506, 69227, 22685, 1898, 21913, 98903, 31229, 70352, 2736, 37093, 113903, 95842, 1761, 109256, 76015, 102589, 34561, 102327, 14401, 12857, 68507, 84605, 133649, 72270, 80315, 24733, 1157, 1166, 21954, 63380, 2024, 11004, 5511, 115850, 75548, 15967, 95469, 906, 35867, 31118, 72956, 30109, 1745, 65250, 39404, 8737, 60759, 12837, 11179, 8381, 101081, 34144, 102803, 22682, 27910, 75526, 3931, 1673, 95206, 78688, 116411, 96339, 1933, 1857, 59735, 86097, 73629, 82790, 1972, 71300, 908, 110603, 100663, 63037, 15648, 86728, 72916, 55127, 49669, 97978, 1610, 106986, 29615, 84077, 21930, 67732, 124858, 61210, 60817, 757, 1930, 1232, 9904, 1911, 85859, 131842)
Run Time: 0.321937
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, 1715919650, 1715923250, [["thread",2842],["thread",84338],["thread",81633],["thread",3455],["thread",84595],["thread",81311],["thread",127633],["thread",61064],["thread",116706],["thread",128761],["thread",1518],["thread",96265],["thread",124680],["thread",109158],["thread",1969],["thread",82844],["thread",1968],["thread",45945],["thread",76346],["thread",126635],["thread",1377],["thread",1967],["thread",1970],["thread",1944],["thread",1788],["thread",1801],["thread",115480],["thread",55920],["thread",81490],["thread",61131],["thread",119098],["thread",45855],["thread",83093],["thread",106954],["thread",131792],["thread",119389],["thread",55044],["thread",126674],["thread",1906],["thread",14984],["thread",1828],["thread",20146],["thread",1949],["thread",56390],["thread",2510],["thread",3545],["thread",1756],["thread",1762],["thread",5407],["thread",1777],["thread",38900],["thread",117029],["thread",1833],["thread",126719],["thread",56866],["thread",77426],["thread",1815],["thread",4126],["thread",1838],["thread",77475],["thread",54518],["thread",546],["thread",55265],["thread",870],["thread",96296],["thread",1672],["thread",105735],["thread",133150],["thread",1389],["thread",100235],["thread",77425],["thread",118942],["thread",101295],["thread",1971],["thread",111589],["thread",51420],["thread",67233],["thread",44509],["thread",118705],["thread",37657],["thread",2705],["thread",2073],["thread",83737],["thread",95799],["thread",108874],["thread",1896],["thread",1779],["thread",121825],["thread",15328],["thread",2775],["thread",88428],["thread",19540],["thread",1684],["thread",14542],["thread",79947],["thread",1799],["thread",1909],["thread",62674],["thread",1746],["thread",83958],["thread",78454],["thread",34633],["thread",75835],["thread",92629],["thread",104251],["thread",11996],["thread",76773],["thread",7334],["thread",104715],["thread",125418],["thread",27194],["thread",105239],["thread",84335],["thread",1614],["thread",77562],["thread",95211],["thread",84478],["thread",85130],["thread",1819],["thread",1611],["thread",68271],["thread",900],["thread",62577],["thread",1905],["thread",1748],["thread",111342],["thread",117729],["thread",19165],["thread",74134],["thread",27912],["thread",73828],["thread",128077],["thread",97645],["thread",9643],["thread",1947],["thread",12008],["thread",108025],["thread",132742],["thread",74726],["thread",49438],["thread",98016],["thread",82101],["thread",15421],["thread",19456],["thread",61141],["thread",3394],["thread",122624],["thread",37539],["thread",1520],["thread",21264],["thread",43070],["thread",67109],["thread",111409],["thread",1900],["thread",55357],["thread",1912],["thread",1964],["thread",64339],["thread",111295],["thread",2883],["thread",1831],["thread",72416],["thread",96374],["thread",66557],["thread",76273],["thread",77809],["thread",467],["thread",92249],["thread",45769],["thread",121676],["thread",86269],["thread",2019],["thread",1601],["thread",84930],["thread",80162],["thread",1981],["thread",21917],["thread",126220],["thread",55143],["thread",21726],["thread",52084],["thread",1742],["thread",14602],["thread",67513],["thread",2094],["thread",108429],["thread",128212],["thread",15749],["thread",1150],["thread",1570],["thread",127739],["thread",125596],["thread",136556],["thread",50180],["thread",73427],["thread",67306],["thread",98201],["thread",21956],["thread",15717],["thread",1935],["thread",66675],["thread",88872],["thread",3695],["thread",78243],["thread",126506],["thread",69227],["thread",22685],["thread",1898],["thread",21913],["thread",98903],["thread",31229],["thread",70352],["thread",2736],["thread",37093],["thread",113903],["thread",95842],["thread",1761],["thread",109256],["thread",76015],["thread",102589],["thread",34561],["thread",102327],["thread",14401],["thread",12857],["thread",68507],["thread",84605],["thread",133649],["thread",72270],["thread",80315],["thread",24733],["thread",1157],["thread",1166],["thread",21954],["thread",63380],["thread",2024],["thread",11004],["thread",5511],["thread",115850],["thread",75548],["thread",15967],["thread",95469],["thread",906],["thread",35867],["thread",31118],["thread",72956],["thread",30109],["thread",1745],["thread",65250],["thread",39404],["thread",8737],["thread",60759],["thread",12837],["thread",11179],["thread",8381],["thread",101081],["thread",34144],["thread",102803],["thread",22682],["thread",27910],["thread",75526],["thread",3931],["thread",1673],["thread",95206],["thread",78688],["thread",116411],["thread",96339],["thread",1933],["thread",1857],["thread",59735],["thread",86097],["thread",73629],["thread",82790],["thread",1972],["thread",71300],["thread",908],["thread",110603],["thread",100663],["thread",63037],["thread",15648],["thread",86728],["thread",72916],["thread",55127],["thread",49669],["thread",97978],["thread",1610],["thread",106986],["thread",29615],["thread",84077],["thread",21930],["thread",67732],["thread",124858],["thread",61210],["thread",60817],["thread",757],["thread",1930],["thread",1232],["thread",9904],["thread",1911],["thread",85859],["thread",131842]]
Run Time: 0.089044
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.048480
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |