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 (87538, 70151, 139879, 838, 105891, 915, 35675, 103152, 822, 84303, 4883, 103550, 89819, 128906, 116758, 882, 86739, 102066, 106982, 87248, 67108, 77070, 87954, 116436, 27012, 1704, 115711, 35393, 129309, 91393, 123234, 33318, 112671, 59880, 34026, 132886, 139965, 116957, 139744, 114661, 139832, 824, 117089, 105941, 102332, 140235, 109313, 95218, 116011, 95275, 104096, 48342, 83462, 139847, 100325, 136758, 38407, 99138, 57999, 105644, 107736, 140480, 536, 132827, 30580, 26852, 85386, 47223, 116995, 138049, 107660, 97374, 107059, 115546, 107245, 116467, 839, 93243, 112368, 87363, 126097, 35545, 29638, 125719, 104167, 146792, 34538, 113998, 107554, 57208, 116762, 107297, 94113, 62607, 112357, 116853, 88558, 139921, 89351, 26855, 77461, 84939, 104739, 104299, 110332, 147136, 35657, 111652, 123829, 87880, 135268, 116264, 113535, 112501, 92187, 116631, 89265, 124768, 52335, 78197, 104646, 109955, 77526, 112124, 123043, 67146, 38890, 96765, 116341, 35092, 90422, 87425, 124279, 1695, 104781, 115747, 1467, 139862, 100773, 98051, 124003, 58336, 104560, 35932, 100080, 115858, 113568, 135883, 95643, 127769, 80923, 104292, 87009, 80856, 107561, 103817, 880, 52268, 95518, 47694, 120705, 126086, 35438, 93141, 115595, 102866, 138884, 86563, 122010, 143518, 33395, 42479, 41026, 105855, 124427, 2245, 139046, 102146, 69087, 137965, 104189, 116102, 58753, 35756, 76930, 48387, 80280, 56761, 146560, 30685, 33394, 97878, 131015, 85300, 30772, 116478, 117988, 30458, 89201, 106696, 91179, 107022, 91127, 2285, 107230, 828, 136036, 77808, 72780, 53309, 115993, 1985, 110423, 2009, 106968, 110799, 86421, 105988, 89329, 115028, 33316, 113828, 98053, 39182, 144351, 102153, 115362, 125690, 142084, 52676, 35671, 105202, 123333, 33585, 116597, 129106, 101866, 52491, 73052, 53569, 92172, 57164, 81140, 35336, 30243, 126007, 33029, 1394, 125838, 82746, 93942, 123017, 102004, 35255, 76545, 2335, 97413, 30582, 34987, 879, 87292, 34985, 104151, 33071, 87327, 33026, 84323, 142018, 35277, 116662, 87982, 78054, 124405, 38945, 47471, 106399, 127728, 77452, 62608, 130560, 76770, 86790, 33067, 33408, 35673, 90512, 125151, 91204, 129377, 32334, 47278, 140134, 112502, 108596, 124501, 115469, 129454, 50664, 135269)
Run Time: 0.061624
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: 367, 0, 1752881103, 1752884703, [["tinhte_xentag_forum",64],["thread",87538],["thread",70151],["thread",139879],["thread",838],["thread",105891],["thread",915],["thread",35675],["thread",103152],["thread",822],["thread",84303],["thread",4883],["thread",103550],["thread",89819],["thread",128906],["thread",116758],["thread",882],["thread",86739],["thread",102066],["thread",106982],["thread",87248],["thread",67108],["thread",77070],["thread",87954],["thread",116436],["thread",27012],["thread",1704],["thread",115711],["thread",35393],["thread",129309],["thread",91393],["thread",123234],["thread",33318],["thread",112671],["thread",59880],["thread",34026],["thread",132886],["thread",139965],["thread",116957],["thread",139744],["thread",114661],["thread",139832],["thread",824],["thread",117089],["thread",105941],["thread",102332],["thread",140235],["thread",109313],["thread",95218],["thread",116011],["thread",95275],["thread",104096],["thread",48342],["thread",83462],["thread",139847],["thread",100325],["thread",136758],["thread",38407],["thread",99138],["thread",57999],["thread",105644],["thread",107736],["thread",140480],["thread",536],["thread",132827],["thread",30580],["thread",26852],["thread",85386],["thread",47223],["thread",116995],["thread",138049],["thread",107660],["thread",97374],["thread",107059],["thread",115546],["thread",107245],["thread",116467],["thread",839],["thread",93243],["thread",112368],["thread",87363],["thread",126097],["thread",35545],["thread",29638],["thread",125719],["thread",104167],["thread",146792],["thread",34538],["thread",113998],["thread",107554],["thread",57208],["thread",116762],["thread",107297],["thread",94113],["thread",62607],["thread",112357],["thread",116853],["thread",88558],["thread",139921],["thread",89351],["thread",26855],["thread",77461],["thread",84939],["thread",104739],["thread",104299],["thread",110332],["thread",147136],["thread",35657],["thread",111652],["thread",123829],["thread",87880],["thread",135268],["thread",116264],["thread",113535],["thread",112501],["thread",92187],["thread",116631],["thread",89265],["thread",124768],["thread",52335],["thread",78197],["thread",104646],["thread",109955],["thread",77526],["thread",112124],["thread",123043],["thread",67146],["thread",38890],["thread",96765],["thread",116341],["thread",35092],["thread",90422],["thread",87425],["thread",124279],["thread",1695],["thread",104781],["thread",115747],["thread",1467],["thread",139862],["thread",100773],["thread",98051],["thread",124003],["thread",58336],["thread",104560],["thread",35932],["thread",100080],["thread",115858],["thread",113568],["thread",135883],["thread",95643],["thread",127769],["thread",80923],["thread",104292],["thread",87009],["thread",80856],["thread",107561],["thread",103817],["thread",880],["thread",52268],["thread",95518],["thread",47694],["thread",120705],["thread",126086],["thread",35438],["thread",93141],["thread",115595],["thread",102866],["thread",138884],["thread",86563],["thread",122010],["thread",143518],["thread",33395],["thread",42479],["thread",41026],["thread",105855],["thread",124427],["thread",2245],["thread",139046],["thread",102146],["thread",69087],["thread",137965],["thread",104189],["thread",116102],["thread",58753],["thread",35756],["thread",76930],["thread",48387],["thread",80280],["thread",56761],["thread",146560],["thread",30685],["thread",33394],["thread",97878],["thread",131015],["thread",85300],["thread",30772],["thread",116478],["thread",117988],["thread",30458],["thread",89201],["thread",106696],["thread",91179],["thread",107022],["thread",91127],["thread",2285],["thread",107230],["thread",828],["thread",136036],["thread",77808],["thread",72780],["thread",53309],["thread",115993],["thread",1985],["thread",110423],["thread",2009],["thread",106968],["thread",110799],["thread",86421],["thread",105988],["thread",89329],["thread",115028],["thread",33316],["thread",113828],["thread",98053],["thread",39182],["thread",144351],["thread",102153],["thread",115362],["thread",125690],["thread",142084],["thread",52676],["thread",35671],["thread",105202],["thread",123333],["thread",33585],["thread",116597],["thread",129106],["thread",101866],["thread",52491],["thread",73052],["thread",53569],["thread",92172],["thread",57164],["thread",81140],["thread",35336],["thread",30243],["thread",126007],["thread",33029],["thread",1394],["thread",125838],["thread",82746],["thread",93942],["thread",123017],["thread",102004],["thread",35255],["thread",76545],["thread",2335],["thread",97413],["thread",30582],["thread",34987],["thread",879],["thread",87292],["thread",34985],["thread",104151],["thread",33071],["thread",87327],["thread",33026],["thread",84323],["thread",142018],["thread",35277],["thread",116662],["thread",87982],["thread",78054],["thread",124405],["thread",38945],["thread",47471],["thread",106399],["thread",127728],["thread",77452],["thread",62608],["thread",130560],["thread",76770],["thread",86790],["thread",33067],["thread",33408],["thread",35673],["thread",90512],["thread",125151],["thread",91204],["thread",129377],["thread",32334],["thread",47278],["thread",140134],["thread",112502],["thread",108596],["thread",124501],["thread",115469],["thread",129454],["thread",50664],["thread",135269]]
Run Time: 0.155120
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.050737
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |