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 (59880, 91138, 115937, 864, 64003, 102444, 90070, 104327, 76270, 90039, 35239, 96376, 112357, 116268, 111349, 79578, 4883, 41026, 106708, 35322, 76373, 34536, 117126, 80923, 102329, 34606, 14806, 122841, 108998, 47569, 55423, 109731, 57278, 114415, 123754, 95219, 35602, 135130, 108757, 33585, 105202, 113568, 92322, 106709, 95442, 86492, 98115, 1654, 78388, 63302, 87548, 115645, 121042, 115362, 119924, 107970, 98569, 110428, 89140, 101428, 33394, 30965, 30579, 88349, 98865, 111955, 133561, 87364, 114236, 52491, 94815, 391, 106426, 84829, 33351, 116206, 55904, 122473, 109313, 135306, 120066, 115681, 930, 115705, 74410, 1402, 107629, 114222, 115458, 44082, 110332, 103370, 124420, 82643, 84024, 108125, 122140, 1997, 128157, 104531, 91312, 124501, 123234, 104260, 115921, 107835, 109480, 111615, 58339, 97499, 115669, 91420, 86328, 77166, 107226, 105016, 84464, 107230, 121203, 107975, 89265, 99103, 116588, 98354, 122596, 2321, 96895, 75516, 104429, 86600, 34026, 91127, 87363, 100079, 35673, 94450, 87827, 124135, 58365, 106433, 77947, 35337, 34414, 122273, 114462, 107802, 107104, 48340, 112032, 79590, 115995, 100080, 77804, 96346, 33077, 52678, 102289, 117011, 124437, 66385, 104348, 106721, 86739, 121772, 87425, 84141, 115707, 105516, 116462, 52268, 33315, 128674, 124720, 124405, 89724, 37078, 112221, 72000, 91466, 33847, 117220, 1566, 119833, 867, 981, 34085, 35434, 30963, 85383, 107888, 112672, 116820, 67106, 52497, 98946, 106703, 101970, 122585, 95220, 87327, 98053, 96077, 102058, 123506, 98400, 38976, 108375, 1695, 69102, 103406, 115888, 37077, 89715, 107713, 2275, 97908, 102150, 108023, 126458, 125764, 89786, 123895, 116247, 116853, 117272, 119899, 113535, 37082, 107245, 125531, 97847, 52193, 103950, 105865, 99337, 81247, 44968, 107774, 925, 95905, 38407, 118563, 95643, 61685, 120871, 77424, 112124, 935, 106262, 92326, 128906, 124439, 57307, 106399, 116930, 67521, 116143, 35932, 93821, 107553, 420, 34605, 52632, 23424, 108727, 107112, 87271, 103953, 130560, 97032, 130562, 103190, 116136, 118175, 107022, 35601, 882, 123025, 839, 84939, 116393, 104189, 116809, 34025, 116762, 1985, 103661, 56761, 109762, 87508, 122245, 124905, 111735, 35325, 114015, 91047, 86598, 89351, 113857)
Run Time: 0.163473
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, 1711613039, 1711616639, [["tinhte_xentag_forum",64],["thread",59880],["thread",91138],["thread",115937],["thread",864],["thread",64003],["thread",102444],["thread",90070],["thread",104327],["thread",76270],["thread",90039],["thread",35239],["thread",96376],["thread",112357],["thread",116268],["thread",111349],["thread",79578],["thread",4883],["thread",41026],["thread",106708],["thread",35322],["thread",76373],["thread",34536],["thread",117126],["thread",80923],["thread",102329],["thread",34606],["thread",14806],["thread",122841],["thread",108998],["thread",47569],["thread",55423],["thread",109731],["thread",57278],["thread",114415],["thread",123754],["thread",95219],["thread",35602],["thread",135130],["thread",108757],["thread",33585],["thread",105202],["thread",113568],["thread",92322],["thread",106709],["thread",95442],["thread",86492],["thread",98115],["thread",1654],["thread",78388],["thread",63302],["thread",87548],["thread",115645],["thread",121042],["thread",115362],["thread",119924],["thread",107970],["thread",98569],["thread",110428],["thread",89140],["thread",101428],["thread",33394],["thread",30965],["thread",30579],["thread",88349],["thread",98865],["thread",111955],["thread",133561],["thread",87364],["thread",114236],["thread",52491],["thread",94815],["thread",391],["thread",106426],["thread",84829],["thread",33351],["thread",116206],["thread",55904],["thread",122473],["thread",109313],["thread",135306],["thread",120066],["thread",115681],["thread",930],["thread",115705],["thread",74410],["thread",1402],["thread",107629],["thread",114222],["thread",115458],["thread",44082],["thread",110332],["thread",103370],["thread",124420],["thread",82643],["thread",84024],["thread",108125],["thread",122140],["thread",1997],["thread",128157],["thread",104531],["thread",91312],["thread",124501],["thread",123234],["thread",104260],["thread",115921],["thread",107835],["thread",109480],["thread",111615],["thread",58339],["thread",97499],["thread",115669],["thread",91420],["thread",86328],["thread",77166],["thread",107226],["thread",105016],["thread",84464],["thread",107230],["thread",121203],["thread",107975],["thread",89265],["thread",99103],["thread",116588],["thread",98354],["thread",122596],["thread",2321],["thread",96895],["thread",75516],["thread",104429],["thread",86600],["thread",34026],["thread",91127],["thread",87363],["thread",100079],["thread",35673],["thread",94450],["thread",87827],["thread",124135],["thread",58365],["thread",106433],["thread",77947],["thread",35337],["thread",34414],["thread",122273],["thread",114462],["thread",107802],["thread",107104],["thread",48340],["thread",112032],["thread",79590],["thread",115995],["thread",100080],["thread",77804],["thread",96346],["thread",33077],["thread",52678],["thread",102289],["thread",117011],["thread",124437],["thread",66385],["thread",104348],["thread",106721],["thread",86739],["thread",121772],["thread",87425],["thread",84141],["thread",115707],["thread",105516],["thread",116462],["thread",52268],["thread",33315],["thread",128674],["thread",124720],["thread",124405],["thread",89724],["thread",37078],["thread",112221],["thread",72000],["thread",91466],["thread",33847],["thread",117220],["thread",1566],["thread",119833],["thread",867],["thread",981],["thread",34085],["thread",35434],["thread",30963],["thread",85383],["thread",107888],["thread",112672],["thread",116820],["thread",67106],["thread",52497],["thread",98946],["thread",106703],["thread",101970],["thread",122585],["thread",95220],["thread",87327],["thread",98053],["thread",96077],["thread",102058],["thread",123506],["thread",98400],["thread",38976],["thread",108375],["thread",1695],["thread",69102],["thread",103406],["thread",115888],["thread",37077],["thread",89715],["thread",107713],["thread",2275],["thread",97908],["thread",102150],["thread",108023],["thread",126458],["thread",125764],["thread",89786],["thread",123895],["thread",116247],["thread",116853],["thread",117272],["thread",119899],["thread",113535],["thread",37082],["thread",107245],["thread",125531],["thread",97847],["thread",52193],["thread",103950],["thread",105865],["thread",99337],["thread",81247],["thread",44968],["thread",107774],["thread",925],["thread",95905],["thread",38407],["thread",118563],["thread",95643],["thread",61685],["thread",120871],["thread",77424],["thread",112124],["thread",935],["thread",106262],["thread",92326],["thread",128906],["thread",124439],["thread",57307],["thread",106399],["thread",116930],["thread",67521],["thread",116143],["thread",35932],["thread",93821],["thread",107553],["thread",420],["thread",34605],["thread",52632],["thread",23424],["thread",108727],["thread",107112],["thread",87271],["thread",103953],["thread",130560],["thread",97032],["thread",130562],["thread",103190],["thread",116136],["thread",118175],["thread",107022],["thread",35601],["thread",882],["thread",123025],["thread",839],["thread",84939],["thread",116393],["thread",104189],["thread",116809],["thread",34025],["thread",116762],["thread",1985],["thread",103661],["thread",56761],["thread",109762],["thread",87508],["thread",122245],["thread",124905],["thread",111735],["thread",35325],["thread",114015],["thread",91047],["thread",86598],["thread",89351],["thread",113857]]
Run Time: 0.030428
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.000206
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |