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 (120231, 50221, 86834, 129881, 136198, 123874, 61838, 133738, 105293, 136165, 2138, 124264, 69652, 132483, 127639, 23168, 126142, 1576, 110642, 127000, 62574, 106133, 77878, 127501, 135938, 132220, 108127, 133855, 134184, 13178, 127069, 130556, 130808, 46994, 9465, 129142, 111592, 134067, 109295, 71861, 128840, 18954, 45967, 134049, 116878, 134364, 121123, 135227, 135866, 64751, 132988, 133295, 118315, 134679, 111065, 66776, 104560, 125069, 61276, 34188, 133681, 134788, 120393, 135259, 136414, 62110, 83802, 17137, 134346, 135187, 105818, 130149, 134369, 55350, 24126, 121445, 38886, 45276, 10445, 104654, 48261, 61912, 134438, 121032, 126845, 118501, 102153, 2706, 51228, 132793, 132611, 111526, 49758, 63113, 133102, 136717, 130974, 19829, 120406, 110298, 110927, 112700, 112895, 134026, 105671, 71424, 3150, 70566, 134750, 86757, 135018, 135173, 121423, 135547, 4567, 107803, 44365, 63685, 37451, 62454, 133725, 47152, 25450, 130587, 129875, 121083, 132636, 136129, 63459, 69582, 136674, 134120, 62124, 110976, 45701, 62106, 124427, 2708, 132192, 106786, 106496, 112882, 112038, 108436, 134319, 61924, 113804, 114733, 133763, 107853, 132414, 72000, 45765, 121786, 13822, 38690, 136449, 61150, 121885, 123143, 128935, 111561, 5719, 133288, 130948, 39926, 109539, 110415, 134768, 109228, 43390, 105950, 114624, 44891, 46905, 80615, 132542, 112061, 84326, 74469, 132669, 135926, 12310, 107555, 128163, 123359, 38874, 46292, 109819, 107213, 129228, 110086, 136302, 129676, 61143, 86569, 133343, 134618, 35724, 121689, 11980, 110091, 127175, 106893, 135721, 135234, 133890, 134005, 127927, 128436, 104541, 61155, 114251, 15981, 30802, 63215, 119568, 1573, 110717, 116007, 129716, 106987, 136645, 133577, 109781, 62594, 43827, 58652, 131402, 134422, 125346, 9984, 91892, 46392, 107199, 106365, 97325, 85379, 116602, 110959, 133342, 134039, 110729, 133413, 120934, 122250, 10331, 133510, 70529, 110062, 130224, 133101, 45056, 114006, 133627, 11885, 107863, 10200, 82949, 112134, 113026, 17295, 55424, 11628, 36893, 122031, 133367, 113023, 134560, 109824, 107134, 132951, 106010, 63013, 134650, 115612, 43932, 113227, 71970, 32242, 74278, 114169, 106779, 11897, 46876, 77121, 134769, 123660, 130555, 46563, 11840, 118318, 1585, 63414, 127182, 110241, 129700, 62095, 130321)
Run Time: 0.019488
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 299 | 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: 31, 0, 1714123744, 1714127344, [["tinhte_xentag_forum",65],["thread",120231],["thread",50221],["thread",86834],["thread",129881],["thread",136198],["thread",123874],["thread",61838],["thread",133738],["thread",105293],["thread",136165],["thread",2138],["thread",124264],["thread",69652],["thread",132483],["thread",127639],["thread",23168],["thread",126142],["thread",1576],["thread",110642],["thread",127000],["thread",62574],["thread",106133],["thread",77878],["thread",127501],["thread",135938],["thread",132220],["thread",108127],["thread",133855],["thread",134184],["thread",13178],["thread",127069],["thread",130556],["thread",130808],["thread",46994],["thread",9465],["thread",129142],["thread",111592],["thread",134067],["thread",109295],["thread",71861],["thread",128840],["thread",18954],["thread",45967],["thread",134049],["thread",116878],["thread",134364],["thread",121123],["thread",135227],["thread",135866],["thread",64751],["thread",132988],["thread",133295],["thread",118315],["thread",134679],["thread",111065],["thread",66776],["thread",104560],["thread",125069],["thread",61276],["thread",34188],["thread",133681],["thread",134788],["thread",120393],["thread",135259],["thread",136414],["thread",62110],["thread",83802],["thread",17137],["thread",134346],["thread",135187],["thread",105818],["thread",130149],["thread",134369],["thread",55350],["thread",24126],["thread",121445],["thread",38886],["thread",45276],["thread",10445],["thread",104654],["thread",48261],["thread",61912],["thread",134438],["thread",121032],["thread",126845],["thread",118501],["thread",102153],["thread",2706],["thread",51228],["thread",132793],["thread",132611],["thread",111526],["thread",49758],["thread",63113],["thread",133102],["thread",136717],["thread",130974],["thread",19829],["thread",120406],["thread",110298],["thread",110927],["thread",112700],["thread",112895],["thread",134026],["thread",105671],["thread",71424],["thread",3150],["thread",70566],["thread",134750],["thread",86757],["thread",135018],["thread",135173],["thread",121423],["thread",135547],["thread",4567],["thread",107803],["thread",44365],["thread",63685],["thread",37451],["thread",62454],["thread",133725],["thread",47152],["thread",25450],["thread",130587],["thread",129875],["thread",121083],["thread",132636],["thread",136129],["thread",63459],["thread",69582],["thread",136674],["thread",134120],["thread",62124],["thread",110976],["thread",45701],["thread",62106],["thread",124427],["thread",2708],["thread",132192],["thread",106786],["thread",106496],["thread",112882],["thread",112038],["thread",108436],["thread",134319],["thread",61924],["thread",113804],["thread",114733],["thread",133763],["thread",107853],["thread",132414],["thread",72000],["thread",45765],["thread",121786],["thread",13822],["thread",38690],["thread",136449],["thread",61150],["thread",121885],["thread",123143],["thread",128935],["thread",111561],["thread",5719],["thread",133288],["thread",130948],["thread",39926],["thread",109539],["thread",110415],["thread",134768],["thread",109228],["thread",43390],["thread",105950],["thread",114624],["thread",44891],["thread",46905],["thread",80615],["thread",132542],["thread",112061],["thread",84326],["thread",74469],["thread",132669],["thread",135926],["thread",12310],["thread",107555],["thread",128163],["thread",123359],["thread",38874],["thread",46292],["thread",109819],["thread",107213],["thread",129228],["thread",110086],["thread",136302],["thread",129676],["thread",61143],["thread",86569],["thread",133343],["thread",134618],["thread",35724],["thread",121689],["thread",11980],["thread",110091],["thread",127175],["thread",106893],["thread",135721],["thread",135234],["thread",133890],["thread",134005],["thread",127927],["thread",128436],["thread",104541],["thread",61155],["thread",114251],["thread",15981],["thread",30802],["thread",63215],["thread",119568],["thread",1573],["thread",110717],["thread",116007],["thread",129716],["thread",106987],["thread",136645],["thread",133577],["thread",109781],["thread",62594],["thread",43827],["thread",58652],["thread",131402],["thread",134422],["thread",125346],["thread",9984],["thread",91892],["thread",46392],["thread",107199],["thread",106365],["thread",97325],["thread",85379],["thread",116602],["thread",110959],["thread",133342],["thread",134039],["thread",110729],["thread",133413],["thread",120934],["thread",122250],["thread",10331],["thread",133510],["thread",70529],["thread",110062],["thread",130224],["thread",133101],["thread",45056],["thread",114006],["thread",133627],["thread",11885],["thread",107863],["thread",10200],["thread",82949],["thread",112134],["thread",113026],["thread",17295],["thread",55424],["thread",11628],["thread",36893],["thread",122031],["thread",133367],["thread",113023],["thread",134560],["thread",109824],["thread",107134],["thread",132951],["thread",106010],["thread",63013],["thread",134650],["thread",115612],["thread",43932],["thread",113227],["thread",71970],["thread",32242],["thread",74278],["thread",114169],["thread",106779],["thread",11897],["thread",46876],["thread",77121],["thread",134769],["thread",123660],["thread",130555],["thread",46563],["thread",11840],["thread",118318],["thread",1585],["thread",63414],["thread",127182],["thread",110241],["thread",129700],["thread",62095],["thread",130321]]
Run Time: 0.003438
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 |