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 (37995, 95801, 29030, 135709, 139173, 92420, 83407, 47507, 104478, 95594, 36380, 95299, 127747, 70969, 137866, 123083, 128332, 123445, 128685, 128255, 9512, 59560, 144292, 42338, 51607, 57777, 74583, 50058, 129897, 69292, 92777, 113838, 44590, 80370, 111204, 119371, 25776, 66118, 64141, 109214, 79704, 98197, 101374, 59029, 110266, 97313, 145959, 135213, 128035, 79287, 69783, 104490, 103921, 148550, 35206, 146779, 121708, 67920, 106776, 85825, 71746, 29008, 119165, 96330, 123393, 58925, 108533, 138654, 24556, 94210, 144806, 48244, 82914, 123867, 132208, 79712, 56260, 110679, 84447, 110895, 103131, 127593, 11554, 72195, 86083, 52511, 79543, 127567, 43865, 23441, 14352, 101546, 139980, 127921, 121014, 16108, 69047, 76847, 72363, 50491, 86993, 139249, 45508, 87818, 109412, 111259, 146520, 81360, 70771, 123389, 116297, 143940, 109958, 43403, 24018, 122607, 4599, 149282, 65872, 98190, 125758, 104061, 143330, 111348, 87866, 103929, 120198, 110956, 36223, 144981, 105946, 144823, 57602, 33707, 44460, 51603, 66382, 114565, 129492, 68377, 146822, 107339, 66554, 89800, 35137, 51962, 34364, 131556, 82028, 98549, 141240, 127611, 131154, 69575, 80400, 85683, 44857, 61542, 34594, 26704, 116787, 116850, 100611, 27017, 41693, 111837, 139943, 55040, 104448, 97357, 103868, 89234, 125903, 107284, 98086, 102768, 45277, 74708, 87324, 125167, 115807, 120381, 84020, 95038, 88955, 109167, 117194, 129643, 88703, 52086, 36374, 51774, 99233, 74002, 67921, 53458, 140870, 49025, 107872, 94542, 123748, 39010, 132532, 100445, 131241, 64859, 106890, 128408, 125872, 137601, 70081, 107348, 40446, 128701, 121221, 125037, 64872, 83395, 148135, 92091, 39471, 104060, 23440, 140908, 116656, 90420, 31103, 45955, 60492, 70971, 143812, 69915, 104659, 96541, 70820, 48247, 138546, 122421, 140065, 74979, 70810, 79546, 54566, 106961, 100202, 96325, 107252, 70707, 132817, 68020, 118154, 70218, 118748, 114470, 59406, 138648, 91941, 91475, 98002, 105595, 90786, 70346, 100458, 84450, 59145, 88084, 79767, 130868, 21161, 102717, 149428, 57311, 91447, 65874, 103867, 120195, 113845, 111636, 132397, 135508, 27691, 106655, 48407, 56630, 105824, 134825, 128525, 145687, 37996, 80059, 44894, 127253, 109051, 65604, 79127, 70099, 66431, 64747, 55951, 83611)
Run Time: 0.206071
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, 1752888568, 1752892168, [["thread",37995],["thread",95801],["thread",29030],["thread",135709],["thread",139173],["thread",92420],["thread",83407],["thread",47507],["thread",104478],["thread",95594],["thread",36380],["thread",95299],["thread",127747],["thread",70969],["thread",137866],["thread",123083],["thread",128332],["thread",123445],["thread",128685],["thread",128255],["thread",9512],["thread",59560],["thread",144292],["thread",42338],["thread",51607],["thread",57777],["thread",74583],["thread",50058],["thread",129897],["thread",69292],["thread",92777],["thread",113838],["thread",44590],["thread",80370],["thread",111204],["thread",119371],["thread",25776],["thread",66118],["thread",64141],["thread",109214],["thread",79704],["thread",98197],["thread",101374],["thread",59029],["thread",110266],["thread",97313],["thread",145959],["thread",135213],["thread",128035],["thread",79287],["thread",69783],["thread",104490],["thread",103921],["thread",148550],["thread",35206],["thread",146779],["thread",121708],["thread",67920],["thread",106776],["thread",85825],["thread",71746],["thread",29008],["thread",119165],["thread",96330],["thread",123393],["thread",58925],["thread",108533],["thread",138654],["thread",24556],["thread",94210],["thread",144806],["thread",48244],["thread",82914],["thread",123867],["thread",132208],["thread",79712],["thread",56260],["thread",110679],["thread",84447],["thread",110895],["thread",103131],["thread",127593],["thread",11554],["thread",72195],["thread",86083],["thread",52511],["thread",79543],["thread",127567],["thread",43865],["thread",23441],["thread",14352],["thread",101546],["thread",139980],["thread",127921],["thread",121014],["thread",16108],["thread",69047],["thread",76847],["thread",72363],["thread",50491],["thread",86993],["thread",139249],["thread",45508],["thread",87818],["thread",109412],["thread",111259],["thread",146520],["thread",81360],["thread",70771],["thread",123389],["thread",116297],["thread",143940],["thread",109958],["thread",43403],["thread",24018],["thread",122607],["thread",4599],["thread",149282],["thread",65872],["thread",98190],["thread",125758],["thread",104061],["thread",143330],["thread",111348],["thread",87866],["thread",103929],["thread",120198],["thread",110956],["thread",36223],["thread",144981],["thread",105946],["thread",144823],["thread",57602],["thread",33707],["thread",44460],["thread",51603],["thread",66382],["thread",114565],["thread",129492],["thread",68377],["thread",146822],["thread",107339],["thread",66554],["thread",89800],["thread",35137],["thread",51962],["thread",34364],["thread",131556],["thread",82028],["thread",98549],["thread",141240],["thread",127611],["thread",131154],["thread",69575],["thread",80400],["thread",85683],["thread",44857],["thread",61542],["thread",34594],["thread",26704],["thread",116787],["thread",116850],["thread",100611],["thread",27017],["thread",41693],["thread",111837],["thread",139943],["thread",55040],["thread",104448],["thread",97357],["thread",103868],["thread",89234],["thread",125903],["thread",107284],["thread",98086],["thread",102768],["thread",45277],["thread",74708],["thread",87324],["thread",125167],["thread",115807],["thread",120381],["thread",84020],["thread",95038],["thread",88955],["thread",109167],["thread",117194],["thread",129643],["thread",88703],["thread",52086],["thread",36374],["thread",51774],["thread",99233],["thread",74002],["thread",67921],["thread",53458],["thread",140870],["thread",49025],["thread",107872],["thread",94542],["thread",123748],["thread",39010],["thread",132532],["thread",100445],["thread",131241],["thread",64859],["thread",106890],["thread",128408],["thread",125872],["thread",137601],["thread",70081],["thread",107348],["thread",40446],["thread",128701],["thread",121221],["thread",125037],["thread",64872],["thread",83395],["thread",148135],["thread",92091],["thread",39471],["thread",104060],["thread",23440],["thread",140908],["thread",116656],["thread",90420],["thread",31103],["thread",45955],["thread",60492],["thread",70971],["thread",143812],["thread",69915],["thread",104659],["thread",96541],["thread",70820],["thread",48247],["thread",138546],["thread",122421],["thread",140065],["thread",74979],["thread",70810],["thread",79546],["thread",54566],["thread",106961],["thread",100202],["thread",96325],["thread",107252],["thread",70707],["thread",132817],["thread",68020],["thread",118154],["thread",70218],["thread",118748],["thread",114470],["thread",59406],["thread",138648],["thread",91941],["thread",91475],["thread",98002],["thread",105595],["thread",90786],["thread",70346],["thread",100458],["thread",84450],["thread",59145],["thread",88084],["thread",79767],["thread",130868],["thread",21161],["thread",102717],["thread",149428],["thread",57311],["thread",91447],["thread",65874],["thread",103867],["thread",120195],["thread",113845],["thread",111636],["thread",132397],["thread",135508],["thread",27691],["thread",106655],["thread",48407],["thread",56630],["thread",105824],["thread",134825],["thread",128525],["thread",145687],["thread",37996],["thread",80059],["thread",44894],["thread",127253],["thread",109051],["thread",65604],["thread",79127],["thread",70099],["thread",66431],["thread",64747],["thread",55951],["thread",83611]]
Run Time: 0.039722
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.000123
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |