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 (900, 95152, 16076, 1949, 2505, 9643, 25314, 1683, 101437, 92249, 99099, 98019, 91704, 84312, 76644, 2027, 1803, 116946, 1924, 97428, 106927, 90453, 135817, 75225, 128931, 112310, 109256, 119098, 99478, 111477, 1945, 45652, 91238, 78733, 86097, 134338, 77897, 74246, 1587, 89014, 1759, 96649, 34018, 72170, 60759, 27070, 1762, 1840, 116637, 122734, 518, 34698, 4159, 120212, 56045, 1674, 131293, 1817, 98016, 78111, 1775, 1801, 1918, 56268, 66762, 42147, 1859, 8987, 11824, 27995, 98903, 24933, 75076, 1912, 80132, 34213, 92629, 2509, 110603, 1858, 49438, 120670, 102083, 36859, 126713, 24528, 2517, 1839, 48842, 1519, 7518, 102605, 18822, 1876, 1713, 28469, 42766, 97645, 18048, 1947, 115472, 84482, 27753, 2020, 1758, 119380, 126674, 1749, 107413, 103779, 1807, 126555, 126450, 33802, 126220, 99541, 55265, 84336, 128704, 20154, 119390, 954, 121143, 976, 84605, 119764, 19540, 129936, 61058, 128988, 55921, 1915, 54310, 124100, 95799, 1913, 93300, 15328, 93949, 120111, 1838, 53976, 6139, 102059, 20777, 133089, 71314, 129706, 106277, 72901, 30890, 67233, 2515, 135065, 102708, 126157, 41643, 91128, 89686, 84338, 133649, 45791, 72677, 2535, 1516, 80162, 88324, 753, 1950, 19650, 128562, 1908, 69376, 109543, 8670, 22197, 33933, 8499, 55144, 38707, 5407, 45769, 59735, 55361, 37048, 95096, 132660, 118942, 37979, 54518, 108874, 77253, 63056, 72084, 1779, 1899, 1747, 7334, 1785, 124506, 64104, 1906, 74071, 28233, 2089, 128356, 50513, 1755, 16175, 1602, 14602, 34448, 2537, 18885, 40362, 126454, 86107, 110973, 4715, 6897, 1389, 62604, 71040, 55044, 3425, 126923, 76761, 67109, 1851, 1745, 82236, 127154, 1736, 94023, 107342, 15212, 1900, 1404, 93847, 64481, 1814, 71513, 102361, 116706, 1532, 45290, 34633, 117029, 77562, 97783, 51420, 1598, 1782, 118354, 1751, 109704, 118705, 21954, 46181, 83140, 1764, 11293, 128028, 2019, 94660, 85859, 2869, 1896, 52084, 126592, 418, 8500, 2772, 1808, 50465, 15647, 3251, 76346, 57876, 1804, 1835, 55527, 121147, 55954, 1965, 22527, 106886, 1376, 77426, 2504, 2725, 127203, 102261, 76938, 128075, 1150, 112251, 1800, 24446, 115485)
Run Time: 0.017793
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, 1715372839, 1715376439, [["thread",900],["thread",95152],["thread",16076],["thread",1949],["thread",2505],["thread",9643],["thread",25314],["thread",1683],["thread",101437],["thread",92249],["thread",99099],["thread",98019],["thread",91704],["thread",84312],["thread",76644],["thread",2027],["thread",1803],["thread",116946],["thread",1924],["thread",97428],["thread",106927],["thread",90453],["thread",135817],["thread",75225],["thread",128931],["thread",112310],["thread",109256],["thread",119098],["thread",99478],["thread",111477],["thread",1945],["thread",45652],["thread",91238],["thread",78733],["thread",86097],["thread",134338],["thread",77897],["thread",74246],["thread",1587],["thread",89014],["thread",1759],["thread",96649],["thread",34018],["thread",72170],["thread",60759],["thread",27070],["thread",1762],["thread",1840],["thread",116637],["thread",122734],["thread",518],["thread",34698],["thread",4159],["thread",120212],["thread",56045],["thread",1674],["thread",131293],["thread",1817],["thread",98016],["thread",78111],["thread",1775],["thread",1801],["thread",1918],["thread",56268],["thread",66762],["thread",42147],["thread",1859],["thread",8987],["thread",11824],["thread",27995],["thread",98903],["thread",24933],["thread",75076],["thread",1912],["thread",80132],["thread",34213],["thread",92629],["thread",2509],["thread",110603],["thread",1858],["thread",49438],["thread",120670],["thread",102083],["thread",36859],["thread",126713],["thread",24528],["thread",2517],["thread",1839],["thread",48842],["thread",1519],["thread",7518],["thread",102605],["thread",18822],["thread",1876],["thread",1713],["thread",28469],["thread",42766],["thread",97645],["thread",18048],["thread",1947],["thread",115472],["thread",84482],["thread",27753],["thread",2020],["thread",1758],["thread",119380],["thread",126674],["thread",1749],["thread",107413],["thread",103779],["thread",1807],["thread",126555],["thread",126450],["thread",33802],["thread",126220],["thread",99541],["thread",55265],["thread",84336],["thread",128704],["thread",20154],["thread",119390],["thread",954],["thread",121143],["thread",976],["thread",84605],["thread",119764],["thread",19540],["thread",129936],["thread",61058],["thread",128988],["thread",55921],["thread",1915],["thread",54310],["thread",124100],["thread",95799],["thread",1913],["thread",93300],["thread",15328],["thread",93949],["thread",120111],["thread",1838],["thread",53976],["thread",6139],["thread",102059],["thread",20777],["thread",133089],["thread",71314],["thread",129706],["thread",106277],["thread",72901],["thread",30890],["thread",67233],["thread",2515],["thread",135065],["thread",102708],["thread",126157],["thread",41643],["thread",91128],["thread",89686],["thread",84338],["thread",133649],["thread",45791],["thread",72677],["thread",2535],["thread",1516],["thread",80162],["thread",88324],["thread",753],["thread",1950],["thread",19650],["thread",128562],["thread",1908],["thread",69376],["thread",109543],["thread",8670],["thread",22197],["thread",33933],["thread",8499],["thread",55144],["thread",38707],["thread",5407],["thread",45769],["thread",59735],["thread",55361],["thread",37048],["thread",95096],["thread",132660],["thread",118942],["thread",37979],["thread",54518],["thread",108874],["thread",77253],["thread",63056],["thread",72084],["thread",1779],["thread",1899],["thread",1747],["thread",7334],["thread",1785],["thread",124506],["thread",64104],["thread",1906],["thread",74071],["thread",28233],["thread",2089],["thread",128356],["thread",50513],["thread",1755],["thread",16175],["thread",1602],["thread",14602],["thread",34448],["thread",2537],["thread",18885],["thread",40362],["thread",126454],["thread",86107],["thread",110973],["thread",4715],["thread",6897],["thread",1389],["thread",62604],["thread",71040],["thread",55044],["thread",3425],["thread",126923],["thread",76761],["thread",67109],["thread",1851],["thread",1745],["thread",82236],["thread",127154],["thread",1736],["thread",94023],["thread",107342],["thread",15212],["thread",1900],["thread",1404],["thread",93847],["thread",64481],["thread",1814],["thread",71513],["thread",102361],["thread",116706],["thread",1532],["thread",45290],["thread",34633],["thread",117029],["thread",77562],["thread",97783],["thread",51420],["thread",1598],["thread",1782],["thread",118354],["thread",1751],["thread",109704],["thread",118705],["thread",21954],["thread",46181],["thread",83140],["thread",1764],["thread",11293],["thread",128028],["thread",2019],["thread",94660],["thread",85859],["thread",2869],["thread",1896],["thread",52084],["thread",126592],["thread",418],["thread",8500],["thread",2772],["thread",1808],["thread",50465],["thread",15647],["thread",3251],["thread",76346],["thread",57876],["thread",1804],["thread",1835],["thread",55527],["thread",121147],["thread",55954],["thread",1965],["thread",22527],["thread",106886],["thread",1376],["thread",77426],["thread",2504],["thread",2725],["thread",127203],["thread",102261],["thread",76938],["thread",128075],["thread",1150],["thread",112251],["thread",1800],["thread",24446],["thread",115485]]
Run Time: 0.048559
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |