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 (53935, 40431, 124232, 114624, 82078, 63860, 108300, 117626, 49831, 11713, 119757, 101809, 124177, 24231, 49199, 5554, 102257, 15158, 118795, 81778, 13501, 1098, 108719, 48286, 81069, 108485, 17916, 14648, 108239, 81485, 101276, 61425, 97853, 2138, 106028, 69684, 110604, 108389, 5582, 13780, 109260, 97236, 40428, 8157, 31693, 30803, 96876, 35675, 113819, 121322, 52193, 28984, 85045, 66878, 116230, 73121, 94118, 111546, 35674, 96872, 46639, 96878, 2135, 23132, 97860, 35545, 84311, 24672, 29590, 75919, 97732, 6490, 1573, 35757, 35657, 95459, 49826, 96738, 18933, 119073, 52196, 76381, 16463, 32546, 96389, 61759, 98350, 93388, 35671, 96761, 97324, 15653, 24872, 35609, 52201, 96191, 36434, 1578, 63148, 119740, 97050, 125285, 70684, 114923, 22731, 105753, 85270, 126656, 101944, 57138, 83861, 120484, 10500, 67501, 80937, 898, 126019, 64134, 96238, 113485, 95999, 70790, 99146, 105539, 75564, 124569, 3581, 96464, 1099, 64696, 83873, 118451, 33878, 35546, 77247, 135565, 5470, 121416, 93441, 84401, 109697, 25909, 84320, 110432, 40432, 13189, 83589, 118151, 15981, 112500, 120741, 79910, 111226, 9296, 116129, 50806, 77374, 75803, 85049, 66918, 6395, 4756, 88976, 61411, 121439, 113813, 20873, 131958, 104487, 125956, 68582, 70235, 13981, 5125, 72682, 105661, 54108, 68345, 79668, 114079, 74858, 66426, 84599, 5593, 120674, 81305, 96959, 108117, 16137, 102154, 15526, 101991, 14468, 50805, 78273, 73482, 1577, 53699, 52189, 97242, 53029, 63748, 2137, 43979, 67857, 51423, 85846, 128708, 109699, 12440, 135686, 124222, 64162, 62907, 85050, 1571, 117142, 36055, 35673, 92235, 96859, 122970, 37078, 64694, 63855, 67102, 92992, 15111, 54385, 131811, 120815, 85253, 96693, 10331, 46292, 98897, 96430, 29224, 109886, 19332, 17913, 53296, 29222, 116231, 68028, 18419, 54499, 79916, 63849, 9500, 106916, 33564, 17757, 78526, 124802, 52335, 24583, 59951, 63746, 49809, 1574, 111518, 112268, 70894, 85884, 85793, 12728, 67851, 69641, 53760, 66249, 45701, 97327, 122969, 66253, 107974, 84469, 67108, 104559, 32801, 95074, 7839, 1576, 1575, 123340, 96983, 11394, 76270, 108102, 89033, 86757, 87374, 97240, 1572, 108031, 119482, 78908, 95961, 121011, 102090)
Run Time: 0.007488
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: 548, 0, 1713533685, 1713537285, [["thread",53935],["thread",40431],["thread",124232],["thread",114624],["thread",82078],["thread",63860],["thread",108300],["thread",117626],["thread",49831],["thread",11713],["thread",119757],["thread",101809],["thread",124177],["thread",24231],["thread",49199],["thread",5554],["thread",102257],["thread",15158],["thread",118795],["thread",81778],["thread",13501],["thread",1098],["thread",108719],["thread",48286],["thread",81069],["thread",108485],["thread",17916],["thread",14648],["thread",108239],["thread",81485],["thread",101276],["thread",61425],["thread",97853],["thread",2138],["thread",106028],["thread",69684],["thread",110604],["thread",108389],["thread",5582],["thread",13780],["thread",109260],["thread",97236],["thread",40428],["thread",8157],["thread",31693],["thread",30803],["thread",96876],["thread",35675],["thread",113819],["thread",121322],["thread",52193],["thread",28984],["thread",85045],["thread",66878],["thread",116230],["thread",73121],["thread",94118],["thread",111546],["thread",35674],["thread",96872],["thread",46639],["thread",96878],["thread",2135],["thread",23132],["thread",97860],["thread",35545],["thread",84311],["thread",24672],["thread",29590],["thread",75919],["thread",97732],["thread",6490],["thread",1573],["thread",35757],["thread",35657],["thread",95459],["thread",49826],["thread",96738],["thread",18933],["thread",119073],["thread",52196],["thread",76381],["thread",16463],["thread",32546],["thread",96389],["thread",61759],["thread",98350],["thread",93388],["thread",35671],["thread",96761],["thread",97324],["thread",15653],["thread",24872],["thread",35609],["thread",52201],["thread",96191],["thread",36434],["thread",1578],["thread",63148],["thread",119740],["thread",97050],["thread",125285],["thread",70684],["thread",114923],["thread",22731],["thread",105753],["thread",85270],["thread",126656],["thread",101944],["thread",57138],["thread",83861],["thread",120484],["thread",10500],["thread",67501],["thread",80937],["thread",898],["thread",126019],["thread",64134],["thread",96238],["thread",113485],["thread",95999],["thread",70790],["thread",99146],["thread",105539],["thread",75564],["thread",124569],["thread",3581],["thread",96464],["thread",1099],["thread",64696],["thread",83873],["thread",118451],["thread",33878],["thread",35546],["thread",77247],["thread",135565],["thread",5470],["thread",121416],["thread",93441],["thread",84401],["thread",109697],["thread",25909],["thread",84320],["thread",110432],["thread",40432],["thread",13189],["thread",83589],["thread",118151],["thread",15981],["thread",112500],["thread",120741],["thread",79910],["thread",111226],["thread",9296],["thread",116129],["thread",50806],["thread",77374],["thread",75803],["thread",85049],["thread",66918],["thread",6395],["thread",4756],["thread",88976],["thread",61411],["thread",121439],["thread",113813],["thread",20873],["thread",131958],["thread",104487],["thread",125956],["thread",68582],["thread",70235],["thread",13981],["thread",5125],["thread",72682],["thread",105661],["thread",54108],["thread",68345],["thread",79668],["thread",114079],["thread",74858],["thread",66426],["thread",84599],["thread",5593],["thread",120674],["thread",81305],["thread",96959],["thread",108117],["thread",16137],["thread",102154],["thread",15526],["thread",101991],["thread",14468],["thread",50805],["thread",78273],["thread",73482],["thread",1577],["thread",53699],["thread",52189],["thread",97242],["thread",53029],["thread",63748],["thread",2137],["thread",43979],["thread",67857],["thread",51423],["thread",85846],["thread",128708],["thread",109699],["thread",12440],["thread",135686],["thread",124222],["thread",64162],["thread",62907],["thread",85050],["thread",1571],["thread",117142],["thread",36055],["thread",35673],["thread",92235],["thread",96859],["thread",122970],["thread",37078],["thread",64694],["thread",63855],["thread",67102],["thread",92992],["thread",15111],["thread",54385],["thread",131811],["thread",120815],["thread",85253],["thread",96693],["thread",10331],["thread",46292],["thread",98897],["thread",96430],["thread",29224],["thread",109886],["thread",19332],["thread",17913],["thread",53296],["thread",29222],["thread",116231],["thread",68028],["thread",18419],["thread",54499],["thread",79916],["thread",63849],["thread",9500],["thread",106916],["thread",33564],["thread",17757],["thread",78526],["thread",124802],["thread",52335],["thread",24583],["thread",59951],["thread",63746],["thread",49809],["thread",1574],["thread",111518],["thread",112268],["thread",70894],["thread",85884],["thread",85793],["thread",12728],["thread",67851],["thread",69641],["thread",53760],["thread",66249],["thread",45701],["thread",97327],["thread",122969],["thread",66253],["thread",107974],["thread",84469],["thread",67108],["thread",104559],["thread",32801],["thread",95074],["thread",7839],["thread",1576],["thread",1575],["thread",123340],["thread",96983],["thread",11394],["thread",76270],["thread",108102],["thread",89033],["thread",86757],["thread",87374],["thread",97240],["thread",1572],["thread",108031],["thread",119482],["thread",78908],["thread",95961],["thread",121011],["thread",102090]]
Run Time: 0.001865
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.000096
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |