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 (97264, 98381, 125520, 97931, 72046, 98897, 111867, 104614, 97461, 97444, 97715, 112585, 78115, 75917, 85363, 95167, 97390, 818, 857, 53818, 126971, 104976, 132304, 536, 1447, 80690, 99613, 119681, 81111, 34104, 76207, 33987, 120064, 102453, 75515, 438, 58002, 74405, 98061, 47237, 109676, 59951, 103322, 103181, 84303, 878, 98390, 45878, 76881, 79570, 112224, 124841, 113887, 24872, 96566, 98462, 41026, 97054, 1458, 78197, 105781, 835, 75473, 128939, 113885, 77803, 66426, 838, 63014, 47786, 47238, 118634, 97718, 104315, 123132, 96061, 81247, 77000, 119912, 77804, 104424, 93137, 118195, 93230, 9529, 125910, 64283, 135268, 111300, 1565, 97908, 75370, 98382, 79607, 65515, 121137, 118336, 127283, 64075, 47810, 102852, 111710, 105578, 92613, 106209, 120487, 98136, 97973, 90348, 64320, 124287, 133488, 111314, 127210, 120904, 98460, 97975, 84142, 105502, 119740, 100584, 119757, 126858, 84488, 113941, 76998, 76040, 48871, 123394, 113886, 86362, 121165, 7142, 113988, 420, 99700, 113039, 77326, 99460, 100449, 864, 914, 88349, 985, 84938, 107861, 123360, 125553, 127540, 70420, 62608, 842, 1563, 9788, 112367, 75295, 1445, 89708, 112369, 843, 93631, 826, 104487, 30628, 124284, 919, 94131, 118568, 91879, 105865, 77532, 97853, 1257, 120599, 125973, 71970, 97847, 1281, 98400, 112223, 112461, 120498, 104549, 77808, 91296, 82291, 107815, 75916, 104828, 74168, 100231, 134840, 101954, 87989, 66700, 66324, 915, 88487, 116114, 100979, 112368, 65848, 123606, 42354, 126753, 121565, 116908, 47785, 122583, 10265, 63959, 97266, 111838, 804, 1552, 98057, 75207, 114185, 1228, 102329, 97825, 68210, 930, 927, 116782, 1372, 110571, 64200, 124067, 111008, 101944, 66646, 33984, 102061, 105941, 802, 59645, 122106, 119827, 90805, 108264, 1258, 118451, 67810, 1437, 865, 76545, 136759, 116129, 97697, 50806, 78756, 118896, 116907, 62800, 121418, 81471, 95791, 117416, 77972, 119361, 122831, 98035, 68181, 129503, 862, 928, 92254, 102558, 931, 81252, 133706, 48077, 114062, 134718, 97860, 983, 77510, 114733, 98618, 929, 116393, 97387, 84332, 120827, 97466, 64844, 111459, 910, 61379, 66032, 104731, 77422, 107817, 119073, 113888, 75516, 80275, 88253)
Run Time: 0.007943
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: 24, 0, 1714033526, 1714037126, [["tinhte_xentag_forum",64],["thread",97264],["thread",98381],["thread",125520],["thread",97931],["thread",72046],["thread",98897],["thread",111867],["thread",104614],["thread",97461],["thread",97444],["thread",97715],["thread",112585],["thread",78115],["thread",75917],["thread",85363],["thread",95167],["thread",97390],["thread",818],["thread",857],["thread",53818],["thread",126971],["thread",104976],["thread",132304],["thread",536],["thread",1447],["thread",80690],["thread",99613],["thread",119681],["thread",81111],["thread",34104],["thread",76207],["thread",33987],["thread",120064],["thread",102453],["thread",75515],["thread",438],["thread",58002],["thread",74405],["thread",98061],["thread",47237],["thread",109676],["thread",59951],["thread",103322],["thread",103181],["thread",84303],["thread",878],["thread",98390],["thread",45878],["thread",76881],["thread",79570],["thread",112224],["thread",124841],["thread",113887],["thread",24872],["thread",96566],["thread",98462],["thread",41026],["thread",97054],["thread",1458],["thread",78197],["thread",105781],["thread",835],["thread",75473],["thread",128939],["thread",113885],["thread",77803],["thread",66426],["thread",838],["thread",63014],["thread",47786],["thread",47238],["thread",118634],["thread",97718],["thread",104315],["thread",123132],["thread",96061],["thread",81247],["thread",77000],["thread",119912],["thread",77804],["thread",104424],["thread",93137],["thread",118195],["thread",93230],["thread",9529],["thread",125910],["thread",64283],["thread",135268],["thread",111300],["thread",1565],["thread",97908],["thread",75370],["thread",98382],["thread",79607],["thread",65515],["thread",121137],["thread",118336],["thread",127283],["thread",64075],["thread",47810],["thread",102852],["thread",111710],["thread",105578],["thread",92613],["thread",106209],["thread",120487],["thread",98136],["thread",97973],["thread",90348],["thread",64320],["thread",124287],["thread",133488],["thread",111314],["thread",127210],["thread",120904],["thread",98460],["thread",97975],["thread",84142],["thread",105502],["thread",119740],["thread",100584],["thread",119757],["thread",126858],["thread",84488],["thread",113941],["thread",76998],["thread",76040],["thread",48871],["thread",123394],["thread",113886],["thread",86362],["thread",121165],["thread",7142],["thread",113988],["thread",420],["thread",99700],["thread",113039],["thread",77326],["thread",99460],["thread",100449],["thread",864],["thread",914],["thread",88349],["thread",985],["thread",84938],["thread",107861],["thread",123360],["thread",125553],["thread",127540],["thread",70420],["thread",62608],["thread",842],["thread",1563],["thread",9788],["thread",112367],["thread",75295],["thread",1445],["thread",89708],["thread",112369],["thread",843],["thread",93631],["thread",826],["thread",104487],["thread",30628],["thread",124284],["thread",919],["thread",94131],["thread",118568],["thread",91879],["thread",105865],["thread",77532],["thread",97853],["thread",1257],["thread",120599],["thread",125973],["thread",71970],["thread",97847],["thread",1281],["thread",98400],["thread",112223],["thread",112461],["thread",120498],["thread",104549],["thread",77808],["thread",91296],["thread",82291],["thread",107815],["thread",75916],["thread",104828],["thread",74168],["thread",100231],["thread",134840],["thread",101954],["thread",87989],["thread",66700],["thread",66324],["thread",915],["thread",88487],["thread",116114],["thread",100979],["thread",112368],["thread",65848],["thread",123606],["thread",42354],["thread",126753],["thread",121565],["thread",116908],["thread",47785],["thread",122583],["thread",10265],["thread",63959],["thread",97266],["thread",111838],["thread",804],["thread",1552],["thread",98057],["thread",75207],["thread",114185],["thread",1228],["thread",102329],["thread",97825],["thread",68210],["thread",930],["thread",927],["thread",116782],["thread",1372],["thread",110571],["thread",64200],["thread",124067],["thread",111008],["thread",101944],["thread",66646],["thread",33984],["thread",102061],["thread",105941],["thread",802],["thread",59645],["thread",122106],["thread",119827],["thread",90805],["thread",108264],["thread",1258],["thread",118451],["thread",67810],["thread",1437],["thread",865],["thread",76545],["thread",136759],["thread",116129],["thread",97697],["thread",50806],["thread",78756],["thread",118896],["thread",116907],["thread",62800],["thread",121418],["thread",81471],["thread",95791],["thread",117416],["thread",77972],["thread",119361],["thread",122831],["thread",98035],["thread",68181],["thread",129503],["thread",862],["thread",928],["thread",92254],["thread",102558],["thread",931],["thread",81252],["thread",133706],["thread",48077],["thread",114062],["thread",134718],["thread",97860],["thread",983],["thread",77510],["thread",114733],["thread",98618],["thread",929],["thread",116393],["thread",97387],["thread",84332],["thread",120827],["thread",97466],["thread",64844],["thread",111459],["thread",910],["thread",61379],["thread",66032],["thread",104731],["thread",77422],["thread",107817],["thread",119073],["thread",113888],["thread",75516],["thread",80275],["thread",88253]]
Run Time: 0.001828
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.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |