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 (103405, 83431, 117695, 67920, 83611, 72223, 119636, 69891, 148041, 127328, 120932, 144690, 36317, 63713, 149443, 125998, 83798, 111144, 88213, 126797, 70346, 122607, 104098, 102404, 54858, 35578, 87324, 135213, 139949, 121221, 45027, 59447, 141332, 145959, 123877, 80265, 125473, 124477, 70953, 116330, 44584, 89414, 124717, 76244, 93937, 121130, 112682, 124275, 66382, 79767, 143160, 108992, 125721, 29008, 92301, 148485, 48333, 106414, 64092, 110839, 88603, 107872, 146822, 100313, 132817, 69722, 48320, 43906, 107339, 83701, 72834, 126009, 97313, 149389, 116656, 121729, 48393, 146468, 131120, 67022, 124815, 140907, 112720, 97644, 84656, 124750, 110956, 53346, 95038, 146488, 140061, 36349, 7543, 138890, 104466, 145381, 101912, 87920, 59029, 73460, 96682, 11554, 58118, 88703, 33817, 85950, 66554, 141791, 88871, 69111, 42338, 34594, 92818, 66838, 97088, 84450, 149242, 104871, 63912, 133233, 69348, 103813, 106992, 117155, 69007, 78937, 111846, 98549, 109294, 108885, 131556, 24556, 108533, 64735, 79329, 106562, 135741, 128408, 138365, 139475, 19469, 53957, 141240, 69292, 97331, 113845, 73643, 110177, 37140, 129520, 135508, 37517, 125093, 87818, 64558, 116329, 53832, 58876, 144580, 39320, 112114, 132208, 100202, 117462, 93719, 94210, 148201, 105770, 149367, 106020, 120635, 65888, 29030, 55604, 57602, 107498, 64587, 72812, 137923, 97945, 131241, 55040, 26930, 37246, 120722, 111726, 140912, 118143, 45380, 128868, 44460, 37774, 57311, 88063, 50016, 53700, 106647, 26830, 90435, 127709, 141119, 111348, 84959, 21325, 112636, 69374, 129643, 38610, 74583, 128482, 98280, 140150, 132906, 38079, 105824, 139938, 54076, 120381, 149623, 40550, 116325, 126986, 140297, 86938, 129185, 132928, 125532, 105705, 125903, 110679, 86778, 75339, 109255, 74979, 57777, 111837, 144292, 104060, 98906, 146520, 42720, 102419, 119892, 73975, 133678, 43865, 44833, 21331, 23728, 48407, 146799, 79900, 96351, 90508, 88214, 125885, 33949, 27691, 51774, 30466, 86403, 66805, 37466, 144545, 129322, 58715, 80404, 126355, 78058, 108214, 104478, 135198, 95182, 119363, 97151, 59560, 147338, 6368, 116384, 132195, 61431, 104659, 65890, 106200, 113275, 132139, 108142, 87369, 51082, 138148, 70192, 109958, 75506, 77973, 52086, 127940, 44894, 86749, 121014, 72842)
Run Time: 0.167097
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: 1369, 0, 1752600374, 1752603974, [["thread",103405],["thread",83431],["thread",117695],["thread",67920],["thread",83611],["thread",72223],["thread",119636],["thread",69891],["thread",148041],["thread",127328],["thread",120932],["thread",144690],["thread",36317],["thread",63713],["thread",149443],["thread",125998],["thread",83798],["thread",111144],["thread",88213],["thread",126797],["thread",70346],["thread",122607],["thread",104098],["thread",102404],["thread",54858],["thread",35578],["thread",87324],["thread",135213],["thread",139949],["thread",121221],["thread",45027],["thread",59447],["thread",141332],["thread",145959],["thread",123877],["thread",80265],["thread",125473],["thread",124477],["thread",70953],["thread",116330],["thread",44584],["thread",89414],["thread",124717],["thread",76244],["thread",93937],["thread",121130],["thread",112682],["thread",124275],["thread",66382],["thread",79767],["thread",143160],["thread",108992],["thread",125721],["thread",29008],["thread",92301],["thread",148485],["thread",48333],["thread",106414],["thread",64092],["thread",110839],["thread",88603],["thread",107872],["thread",146822],["thread",100313],["thread",132817],["thread",69722],["thread",48320],["thread",43906],["thread",107339],["thread",83701],["thread",72834],["thread",126009],["thread",97313],["thread",149389],["thread",116656],["thread",121729],["thread",48393],["thread",146468],["thread",131120],["thread",67022],["thread",124815],["thread",140907],["thread",112720],["thread",97644],["thread",84656],["thread",124750],["thread",110956],["thread",53346],["thread",95038],["thread",146488],["thread",140061],["thread",36349],["thread",7543],["thread",138890],["thread",104466],["thread",145381],["thread",101912],["thread",87920],["thread",59029],["thread",73460],["thread",96682],["thread",11554],["thread",58118],["thread",88703],["thread",33817],["thread",85950],["thread",66554],["thread",141791],["thread",88871],["thread",69111],["thread",42338],["thread",34594],["thread",92818],["thread",66838],["thread",97088],["thread",84450],["thread",149242],["thread",104871],["thread",63912],["thread",133233],["thread",69348],["thread",103813],["thread",106992],["thread",117155],["thread",69007],["thread",78937],["thread",111846],["thread",98549],["thread",109294],["thread",108885],["thread",131556],["thread",24556],["thread",108533],["thread",64735],["thread",79329],["thread",106562],["thread",135741],["thread",128408],["thread",138365],["thread",139475],["thread",19469],["thread",53957],["thread",141240],["thread",69292],["thread",97331],["thread",113845],["thread",73643],["thread",110177],["thread",37140],["thread",129520],["thread",135508],["thread",37517],["thread",125093],["thread",87818],["thread",64558],["thread",116329],["thread",53832],["thread",58876],["thread",144580],["thread",39320],["thread",112114],["thread",132208],["thread",100202],["thread",117462],["thread",93719],["thread",94210],["thread",148201],["thread",105770],["thread",149367],["thread",106020],["thread",120635],["thread",65888],["thread",29030],["thread",55604],["thread",57602],["thread",107498],["thread",64587],["thread",72812],["thread",137923],["thread",97945],["thread",131241],["thread",55040],["thread",26930],["thread",37246],["thread",120722],["thread",111726],["thread",140912],["thread",118143],["thread",45380],["thread",128868],["thread",44460],["thread",37774],["thread",57311],["thread",88063],["thread",50016],["thread",53700],["thread",106647],["thread",26830],["thread",90435],["thread",127709],["thread",141119],["thread",111348],["thread",84959],["thread",21325],["thread",112636],["thread",69374],["thread",129643],["thread",38610],["thread",74583],["thread",128482],["thread",98280],["thread",140150],["thread",132906],["thread",38079],["thread",105824],["thread",139938],["thread",54076],["thread",120381],["thread",149623],["thread",40550],["thread",116325],["thread",126986],["thread",140297],["thread",86938],["thread",129185],["thread",132928],["thread",125532],["thread",105705],["thread",125903],["thread",110679],["thread",86778],["thread",75339],["thread",109255],["thread",74979],["thread",57777],["thread",111837],["thread",144292],["thread",104060],["thread",98906],["thread",146520],["thread",42720],["thread",102419],["thread",119892],["thread",73975],["thread",133678],["thread",43865],["thread",44833],["thread",21331],["thread",23728],["thread",48407],["thread",146799],["thread",79900],["thread",96351],["thread",90508],["thread",88214],["thread",125885],["thread",33949],["thread",27691],["thread",51774],["thread",30466],["thread",86403],["thread",66805],["thread",37466],["thread",144545],["thread",129322],["thread",58715],["thread",80404],["thread",126355],["thread",78058],["thread",108214],["thread",104478],["thread",135198],["thread",95182],["thread",119363],["thread",97151],["thread",59560],["thread",147338],["thread",6368],["thread",116384],["thread",132195],["thread",61431],["thread",104659],["thread",65890],["thread",106200],["thread",113275],["thread",132139],["thread",108142],["thread",87369],["thread",51082],["thread",138148],["thread",70192],["thread",109958],["thread",75506],["thread",77973],["thread",52086],["thread",127940],["thread",44894],["thread",86749],["thread",121014],["thread",72842]]
Run Time: 0.004496
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.000107
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |