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 (99255, 1092, 46813, 106400, 41025, 74410, 98354, 124501, 1246, 141724, 34812, 45878, 115628, 126766, 62299, 1449, 106433, 122110, 125310, 80357, 78486, 1090, 114359, 116341, 113965, 45646, 90054, 35882, 828, 114228, 107194, 33351, 103190, 857, 34025, 1272, 86603, 110104, 44968, 2303, 65900, 138683, 116102, 130560, 86147, 115873, 47361, 103762, 107561, 136781, 33408, 14806, 108760, 124866, 77499, 118136, 110336, 1985, 106259, 1566, 91276, 33077, 80052, 112528, 114113, 90290, 35607, 84939, 78127, 107022, 77971, 91849, 115921, 35255, 76371, 115362, 120066, 94815, 824, 116550, 35466, 115747, 99161, 33309, 102294, 125838, 112368, 1385, 76042, 137877, 85613, 71998, 66385, 109496, 104739, 112570, 116276, 117044, 38982, 123754, 139986, 115546, 98946, 37083, 116578, 102004, 30582, 88085, 1552, 78388, 95222, 85108, 104299, 81226, 33557, 94450, 103370, 87811, 139046, 142084, 115835, 62540, 115995, 125205, 879, 94418, 93942, 936, 113844, 59880, 26891, 97973, 47278, 930, 926, 99138, 92814, 98211, 100773, 1394, 52491, 88558, 99975, 97815, 910, 36688, 139992, 52678, 1254, 141601, 1654, 124821, 116919, 67878, 111480, 85390, 32939, 47221, 103831, 102066, 102153, 86157, 76545, 4883, 103406, 125351, 107660, 82072, 105891, 81308, 115316, 89724, 97789, 925, 80078, 838, 112032, 123636, 52542, 139722, 108461, 107920, 123874, 88845, 77526, 106721, 81755, 35323, 34531, 927, 50664, 102203, 124437, 107554, 35438, 52268, 115937, 82643, 125984, 35601, 124135, 52632, 128157, 140038, 75927, 47223, 87013, 47220, 104151, 103755, 35337, 97826, 33069, 104293, 139026, 91204, 90039, 115823, 107031, 2055, 35278, 134772, 33311, 109498, 116639, 94465, 87548, 988, 129503, 104531, 61720, 114222, 140033, 98166, 98897, 87248, 102900, 109608, 116957, 117126, 47694, 124782, 97614, 1384, 116245, 915, 139765, 44082, 104374, 880, 77055, 108163, 86823, 78971, 97032, 114617, 85795, 2275, 33281, 25310, 116393, 84464, 97291, 140145, 98060, 75473, 120284, 125113, 102388, 108192, 139921, 112671, 140134, 104260, 30458, 97950, 77461, 116599, 862, 85379, 76439, 57208, 47569, 86522, 30580, 122289, 47359, 34806, 95442, 1094, 116995, 125595, 68418, 30066, 104541, 1436, 88075, 105627, 107553)
Run Time: 0.025085
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, 1752354630, 1752358230, [["tinhte_xentag_forum",64],["thread",99255],["thread",1092],["thread",46813],["thread",106400],["thread",41025],["thread",74410],["thread",98354],["thread",124501],["thread",1246],["thread",141724],["thread",34812],["thread",45878],["thread",115628],["thread",126766],["thread",62299],["thread",1449],["thread",106433],["thread",122110],["thread",125310],["thread",80357],["thread",78486],["thread",1090],["thread",114359],["thread",116341],["thread",113965],["thread",45646],["thread",90054],["thread",35882],["thread",828],["thread",114228],["thread",107194],["thread",33351],["thread",103190],["thread",857],["thread",34025],["thread",1272],["thread",86603],["thread",110104],["thread",44968],["thread",2303],["thread",65900],["thread",138683],["thread",116102],["thread",130560],["thread",86147],["thread",115873],["thread",47361],["thread",103762],["thread",107561],["thread",136781],["thread",33408],["thread",14806],["thread",108760],["thread",124866],["thread",77499],["thread",118136],["thread",110336],["thread",1985],["thread",106259],["thread",1566],["thread",91276],["thread",33077],["thread",80052],["thread",112528],["thread",114113],["thread",90290],["thread",35607],["thread",84939],["thread",78127],["thread",107022],["thread",77971],["thread",91849],["thread",115921],["thread",35255],["thread",76371],["thread",115362],["thread",120066],["thread",94815],["thread",824],["thread",116550],["thread",35466],["thread",115747],["thread",99161],["thread",33309],["thread",102294],["thread",125838],["thread",112368],["thread",1385],["thread",76042],["thread",137877],["thread",85613],["thread",71998],["thread",66385],["thread",109496],["thread",104739],["thread",112570],["thread",116276],["thread",117044],["thread",38982],["thread",123754],["thread",139986],["thread",115546],["thread",98946],["thread",37083],["thread",116578],["thread",102004],["thread",30582],["thread",88085],["thread",1552],["thread",78388],["thread",95222],["thread",85108],["thread",104299],["thread",81226],["thread",33557],["thread",94450],["thread",103370],["thread",87811],["thread",139046],["thread",142084],["thread",115835],["thread",62540],["thread",115995],["thread",125205],["thread",879],["thread",94418],["thread",93942],["thread",936],["thread",113844],["thread",59880],["thread",26891],["thread",97973],["thread",47278],["thread",930],["thread",926],["thread",99138],["thread",92814],["thread",98211],["thread",100773],["thread",1394],["thread",52491],["thread",88558],["thread",99975],["thread",97815],["thread",910],["thread",36688],["thread",139992],["thread",52678],["thread",1254],["thread",141601],["thread",1654],["thread",124821],["thread",116919],["thread",67878],["thread",111480],["thread",85390],["thread",32939],["thread",47221],["thread",103831],["thread",102066],["thread",102153],["thread",86157],["thread",76545],["thread",4883],["thread",103406],["thread",125351],["thread",107660],["thread",82072],["thread",105891],["thread",81308],["thread",115316],["thread",89724],["thread",97789],["thread",925],["thread",80078],["thread",838],["thread",112032],["thread",123636],["thread",52542],["thread",139722],["thread",108461],["thread",107920],["thread",123874],["thread",88845],["thread",77526],["thread",106721],["thread",81755],["thread",35323],["thread",34531],["thread",927],["thread",50664],["thread",102203],["thread",124437],["thread",107554],["thread",35438],["thread",52268],["thread",115937],["thread",82643],["thread",125984],["thread",35601],["thread",124135],["thread",52632],["thread",128157],["thread",140038],["thread",75927],["thread",47223],["thread",87013],["thread",47220],["thread",104151],["thread",103755],["thread",35337],["thread",97826],["thread",33069],["thread",104293],["thread",139026],["thread",91204],["thread",90039],["thread",115823],["thread",107031],["thread",2055],["thread",35278],["thread",134772],["thread",33311],["thread",109498],["thread",116639],["thread",94465],["thread",87548],["thread",988],["thread",129503],["thread",104531],["thread",61720],["thread",114222],["thread",140033],["thread",98166],["thread",98897],["thread",87248],["thread",102900],["thread",109608],["thread",116957],["thread",117126],["thread",47694],["thread",124782],["thread",97614],["thread",1384],["thread",116245],["thread",915],["thread",139765],["thread",44082],["thread",104374],["thread",880],["thread",77055],["thread",108163],["thread",86823],["thread",78971],["thread",97032],["thread",114617],["thread",85795],["thread",2275],["thread",33281],["thread",25310],["thread",116393],["thread",84464],["thread",97291],["thread",140145],["thread",98060],["thread",75473],["thread",120284],["thread",125113],["thread",102388],["thread",108192],["thread",139921],["thread",112671],["thread",140134],["thread",104260],["thread",30458],["thread",97950],["thread",77461],["thread",116599],["thread",862],["thread",85379],["thread",76439],["thread",57208],["thread",47569],["thread",86522],["thread",30580],["thread",122289],["thread",47359],["thread",34806],["thread",95442],["thread",1094],["thread",116995],["thread",125595],["thread",68418],["thread",30066],["thread",104541],["thread",1436],["thread",88075],["thread",105627],["thread",107553]]
Run Time: 0.039668
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.000088
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |