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 (127936, 70675, 119568, 129567, 124599, 76113, 74156, 119757, 70712, 86598, 124217, 115017, 129929, 92258, 111554, 106929, 80396, 87880, 127175, 106480, 109713, 108410, 81437, 73724, 71461, 117104, 124577, 87328, 128158, 77591, 122879, 76950, 84897, 118438, 125871, 15981, 75748, 86684, 124353, 81489, 95457, 70610, 111701, 121726, 68037, 128272, 34024, 52022, 110034, 105870, 123163, 131190, 129398, 111492, 72483, 69229, 72688, 136234, 71389, 79328, 125069, 77787, 34535, 74644, 71660, 97614, 92170, 82012, 77951, 98913, 72838, 83727, 97446, 81485, 117626, 76465, 90441, 70847, 132178, 68591, 86370, 126390, 33408, 90127, 77280, 124676, 137058, 105246, 111217, 109034, 71221, 62088, 93960, 129377, 96991, 33323, 123806, 112427, 126972, 131128, 88320, 111180, 123464, 100949, 67559, 128838, 69983, 123359, 105661, 97773, 79649, 112536, 79362, 111628, 93328, 79588, 29222, 71359, 120484, 84942, 80937, 16747, 75203, 124421, 87775, 125845, 125971, 111056, 71712, 17913, 121885, 70846, 84178, 133371, 61834, 69448, 69226, 125066, 34020, 86591, 84080, 92129, 67607, 76821, 85621, 118739, 33585, 86945, 66918, 126420, 83011, 65462, 112570, 72580, 85610, 54314, 44371, 107493, 107861, 78977, 33281, 99943, 70367, 121142, 84246, 40432, 69564, 104260, 86946, 113393, 78258, 36055, 58753, 67160, 87133, 131324, 58344, 126899, 87814, 44845, 82287, 105292, 130734, 67847, 84469, 107248, 119030, 74550, 112866, 124519, 83163, 67875, 121992, 68114, 82997, 111703, 86868, 45878, 94267, 35673, 119443, 124841, 135641, 68028, 62846, 134366, 33072, 82246, 72721, 67102, 67174, 123223, 80398, 72540, 33954, 44366, 69906, 71464, 75588, 67457, 73726, 51662, 68489, 122611, 93103, 95459, 119925, 124671, 44806, 112075, 81840, 71376, 114505, 84307, 11394, 79587, 86262, 87366, 59923, 120551, 88817, 70672, 126673, 96653, 112560, 81606, 37862, 65466, 109676, 133767, 95167, 130224, 53029, 137336, 71484, 72097, 124818, 73988, 126150, 93726, 124179, 68839, 69381, 92195, 130948, 120815, 70498, 132506, 123710, 87472, 129926, 118593, 125686, 84366, 120287, 65767, 126448, 72233, 85667, 130676, 74521, 34233, 124907, 119560, 111008, 123422, 78145, 59049, 118907, 89563, 86215, 123563, 131527, 70431, 136508, 137122, 91465, 119267, 65075, 127068)
Run Time: 0.007568
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: 7673, 0, 1715578597, 1715582197, [["thread",127936],["thread",70675],["thread",119568],["thread",129567],["thread",124599],["thread",76113],["thread",74156],["thread",119757],["thread",70712],["thread",86598],["thread",124217],["thread",115017],["thread",129929],["thread",92258],["thread",111554],["thread",106929],["thread",80396],["thread",87880],["thread",127175],["thread",106480],["thread",109713],["thread",108410],["thread",81437],["thread",73724],["thread",71461],["thread",117104],["thread",124577],["thread",87328],["thread",128158],["thread",77591],["thread",122879],["thread",76950],["thread",84897],["thread",118438],["thread",125871],["thread",15981],["thread",75748],["thread",86684],["thread",124353],["thread",81489],["thread",95457],["thread",70610],["thread",111701],["thread",121726],["thread",68037],["thread",128272],["thread",34024],["thread",52022],["thread",110034],["thread",105870],["thread",123163],["thread",131190],["thread",129398],["thread",111492],["thread",72483],["thread",69229],["thread",72688],["thread",136234],["thread",71389],["thread",79328],["thread",125069],["thread",77787],["thread",34535],["thread",74644],["thread",71660],["thread",97614],["thread",92170],["thread",82012],["thread",77951],["thread",98913],["thread",72838],["thread",83727],["thread",97446],["thread",81485],["thread",117626],["thread",76465],["thread",90441],["thread",70847],["thread",132178],["thread",68591],["thread",86370],["thread",126390],["thread",33408],["thread",90127],["thread",77280],["thread",124676],["thread",137058],["thread",105246],["thread",111217],["thread",109034],["thread",71221],["thread",62088],["thread",93960],["thread",129377],["thread",96991],["thread",33323],["thread",123806],["thread",112427],["thread",126972],["thread",131128],["thread",88320],["thread",111180],["thread",123464],["thread",100949],["thread",67559],["thread",128838],["thread",69983],["thread",123359],["thread",105661],["thread",97773],["thread",79649],["thread",112536],["thread",79362],["thread",111628],["thread",93328],["thread",79588],["thread",29222],["thread",71359],["thread",120484],["thread",84942],["thread",80937],["thread",16747],["thread",75203],["thread",124421],["thread",87775],["thread",125845],["thread",125971],["thread",111056],["thread",71712],["thread",17913],["thread",121885],["thread",70846],["thread",84178],["thread",133371],["thread",61834],["thread",69448],["thread",69226],["thread",125066],["thread",34020],["thread",86591],["thread",84080],["thread",92129],["thread",67607],["thread",76821],["thread",85621],["thread",118739],["thread",33585],["thread",86945],["thread",66918],["thread",126420],["thread",83011],["thread",65462],["thread",112570],["thread",72580],["thread",85610],["thread",54314],["thread",44371],["thread",107493],["thread",107861],["thread",78977],["thread",33281],["thread",99943],["thread",70367],["thread",121142],["thread",84246],["thread",40432],["thread",69564],["thread",104260],["thread",86946],["thread",113393],["thread",78258],["thread",36055],["thread",58753],["thread",67160],["thread",87133],["thread",131324],["thread",58344],["thread",126899],["thread",87814],["thread",44845],["thread",82287],["thread",105292],["thread",130734],["thread",67847],["thread",84469],["thread",107248],["thread",119030],["thread",74550],["thread",112866],["thread",124519],["thread",83163],["thread",67875],["thread",121992],["thread",68114],["thread",82997],["thread",111703],["thread",86868],["thread",45878],["thread",94267],["thread",35673],["thread",119443],["thread",124841],["thread",135641],["thread",68028],["thread",62846],["thread",134366],["thread",33072],["thread",82246],["thread",72721],["thread",67102],["thread",67174],["thread",123223],["thread",80398],["thread",72540],["thread",33954],["thread",44366],["thread",69906],["thread",71464],["thread",75588],["thread",67457],["thread",73726],["thread",51662],["thread",68489],["thread",122611],["thread",93103],["thread",95459],["thread",119925],["thread",124671],["thread",44806],["thread",112075],["thread",81840],["thread",71376],["thread",114505],["thread",84307],["thread",11394],["thread",79587],["thread",86262],["thread",87366],["thread",59923],["thread",120551],["thread",88817],["thread",70672],["thread",126673],["thread",96653],["thread",112560],["thread",81606],["thread",37862],["thread",65466],["thread",109676],["thread",133767],["thread",95167],["thread",130224],["thread",53029],["thread",137336],["thread",71484],["thread",72097],["thread",124818],["thread",73988],["thread",126150],["thread",93726],["thread",124179],["thread",68839],["thread",69381],["thread",92195],["thread",130948],["thread",120815],["thread",70498],["thread",132506],["thread",123710],["thread",87472],["thread",129926],["thread",118593],["thread",125686],["thread",84366],["thread",120287],["thread",65767],["thread",126448],["thread",72233],["thread",85667],["thread",130676],["thread",74521],["thread",34233],["thread",124907],["thread",119560],["thread",111008],["thread",123422],["thread",78145],["thread",59049],["thread",118907],["thread",89563],["thread",86215],["thread",123563],["thread",131527],["thread",70431],["thread",136508],["thread",137122],["thread",91465],["thread",119267],["thread",65075],["thread",127068]]
Run Time: 0.083345
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |