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 (30803, 24840, 63229, 120823, 111967, 118780, 5319, 17139, 16463, 86360, 17162, 71831, 11628, 64101, 35657, 120952, 112371, 11630, 31060, 85335, 110687, 11834, 63064, 114615, 116620, 120905, 52195, 95421, 26769, 17256, 96214, 33954, 130806, 102949, 112641, 130898, 104081, 12197, 41026, 107212, 35284, 112457, 62986, 106449, 130942, 106127, 103727, 130754, 111839, 11634, 112222, 70335, 4567, 111592, 33564, 108543, 106885, 12520, 49654, 52193, 11889, 106493, 391, 24583, 62907, 129377, 1572, 111652, 81163, 130753, 114031, 36434, 121468, 119568, 88025, 119562, 107108, 15409, 96420, 119952, 101877, 5424, 32801, 130913, 120902, 1575, 112600, 12616, 106310, 13178, 112027, 81151, 61633, 98627, 12612, 58241, 130452, 19332, 31183, 53479, 119237, 35446, 13780, 44332, 130990, 10515, 112031, 70415, 18933, 85846, 9701, 58252, 11921, 12538, 102226, 108762, 103814, 120828, 129204, 17519, 20328, 68969, 44414, 14648, 51662, 111650, 111706, 15653, 119461, 108468, 15585, 112643, 90506, 35545, 106883, 93894, 12733, 80937, 109180, 112086, 111710, 6492, 72780, 106454, 91966, 8630, 3713, 84469, 112425, 112692, 114428, 81450, 110883, 112579, 130995, 131110, 66095, 111235, 112428, 11888, 6395, 133906, 12534, 2706, 112337, 131269, 107658, 66211, 100041, 35281, 6490, 77690, 111656, 13176, 116907, 38407, 15526, 133330, 6493, 120817, 4756, 89471, 35671, 11713, 3171, 74825, 4809, 3150, 22202, 11935, 13981, 101952, 113813, 112578, 93137, 119346, 111894, 131114, 44558, 112583, 44805, 11492, 131194, 86587, 112248, 13973, 111180, 3922, 109819, 41199, 112358, 105813, 111614, 112458, 105717, 12447, 131076, 114733, 118569, 10331, 102903, 11747, 110993, 29590, 101890, 35288, 63840, 86651, 81153, 113818, 5719, 52937, 108189, 112829, 52022, 131734, 100131, 110294, 106987, 6481, 97015, 44371, 73092, 90463, 47710, 10238, 110992, 68358, 15981, 73870, 111590, 5593, 64099, 86304, 131008, 43845, 107025, 16137, 52191, 86585, 111226, 35240, 130941, 33334, 131144, 18419, 100630, 107065, 44366, 103820, 13501, 118192, 81317, 12069, 112225, 54385, 136583, 112644, 2708, 95280, 131234, 78359, 11857, 26733, 29224, 61734, 99558, 101956, 100549, 1098, 91722, 15994, 111838, 24501, 35674, 595, 35756, 12404, 11945)
Run Time: 0.005949
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: 32, 0, 1713470686, 1713474286, [["tinhte_xentag_forum",65],["thread",30803],["thread",24840],["thread",63229],["thread",120823],["thread",111967],["thread",118780],["thread",5319],["thread",17139],["thread",16463],["thread",86360],["thread",17162],["thread",71831],["thread",11628],["thread",64101],["thread",35657],["thread",120952],["thread",112371],["thread",11630],["thread",31060],["thread",85335],["thread",110687],["thread",11834],["thread",63064],["thread",114615],["thread",116620],["thread",120905],["thread",52195],["thread",95421],["thread",26769],["thread",17256],["thread",96214],["thread",33954],["thread",130806],["thread",102949],["thread",112641],["thread",130898],["thread",104081],["thread",12197],["thread",41026],["thread",107212],["thread",35284],["thread",112457],["thread",62986],["thread",106449],["thread",130942],["thread",106127],["thread",103727],["thread",130754],["thread",111839],["thread",11634],["thread",112222],["thread",70335],["thread",4567],["thread",111592],["thread",33564],["thread",108543],["thread",106885],["thread",12520],["thread",49654],["thread",52193],["thread",11889],["thread",106493],["thread",391],["thread",24583],["thread",62907],["thread",129377],["thread",1572],["thread",111652],["thread",81163],["thread",130753],["thread",114031],["thread",36434],["thread",121468],["thread",119568],["thread",88025],["thread",119562],["thread",107108],["thread",15409],["thread",96420],["thread",119952],["thread",101877],["thread",5424],["thread",32801],["thread",130913],["thread",120902],["thread",1575],["thread",112600],["thread",12616],["thread",106310],["thread",13178],["thread",112027],["thread",81151],["thread",61633],["thread",98627],["thread",12612],["thread",58241],["thread",130452],["thread",19332],["thread",31183],["thread",53479],["thread",119237],["thread",35446],["thread",13780],["thread",44332],["thread",130990],["thread",10515],["thread",112031],["thread",70415],["thread",18933],["thread",85846],["thread",9701],["thread",58252],["thread",11921],["thread",12538],["thread",102226],["thread",108762],["thread",103814],["thread",120828],["thread",129204],["thread",17519],["thread",20328],["thread",68969],["thread",44414],["thread",14648],["thread",51662],["thread",111650],["thread",111706],["thread",15653],["thread",119461],["thread",108468],["thread",15585],["thread",112643],["thread",90506],["thread",35545],["thread",106883],["thread",93894],["thread",12733],["thread",80937],["thread",109180],["thread",112086],["thread",111710],["thread",6492],["thread",72780],["thread",106454],["thread",91966],["thread",8630],["thread",3713],["thread",84469],["thread",112425],["thread",112692],["thread",114428],["thread",81450],["thread",110883],["thread",112579],["thread",130995],["thread",131110],["thread",66095],["thread",111235],["thread",112428],["thread",11888],["thread",6395],["thread",133906],["thread",12534],["thread",2706],["thread",112337],["thread",131269],["thread",107658],["thread",66211],["thread",100041],["thread",35281],["thread",6490],["thread",77690],["thread",111656],["thread",13176],["thread",116907],["thread",38407],["thread",15526],["thread",133330],["thread",6493],["thread",120817],["thread",4756],["thread",89471],["thread",35671],["thread",11713],["thread",3171],["thread",74825],["thread",4809],["thread",3150],["thread",22202],["thread",11935],["thread",13981],["thread",101952],["thread",113813],["thread",112578],["thread",93137],["thread",119346],["thread",111894],["thread",131114],["thread",44558],["thread",112583],["thread",44805],["thread",11492],["thread",131194],["thread",86587],["thread",112248],["thread",13973],["thread",111180],["thread",3922],["thread",109819],["thread",41199],["thread",112358],["thread",105813],["thread",111614],["thread",112458],["thread",105717],["thread",12447],["thread",131076],["thread",114733],["thread",118569],["thread",10331],["thread",102903],["thread",11747],["thread",110993],["thread",29590],["thread",101890],["thread",35288],["thread",63840],["thread",86651],["thread",81153],["thread",113818],["thread",5719],["thread",52937],["thread",108189],["thread",112829],["thread",52022],["thread",131734],["thread",100131],["thread",110294],["thread",106987],["thread",6481],["thread",97015],["thread",44371],["thread",73092],["thread",90463],["thread",47710],["thread",10238],["thread",110992],["thread",68358],["thread",15981],["thread",73870],["thread",111590],["thread",5593],["thread",64099],["thread",86304],["thread",131008],["thread",43845],["thread",107025],["thread",16137],["thread",52191],["thread",86585],["thread",111226],["thread",35240],["thread",130941],["thread",33334],["thread",131144],["thread",18419],["thread",100630],["thread",107065],["thread",44366],["thread",103820],["thread",13501],["thread",118192],["thread",81317],["thread",12069],["thread",112225],["thread",54385],["thread",136583],["thread",112644],["thread",2708],["thread",95280],["thread",131234],["thread",78359],["thread",11857],["thread",26733],["thread",29224],["thread",61734],["thread",99558],["thread",101956],["thread",100549],["thread",1098],["thread",91722],["thread",15994],["thread",111838],["thread",24501],["thread",35674],["thread",595],["thread",35756],["thread",12404],["thread",11945]]
Run Time: 0.001448
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.000063
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |