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 (69971, 83357, 85667, 120845, 44414, 87791, 126084, 72040, 91842, 90507, 80823, 81688, 98671, 68264, 82840, 70712, 68790, 68734, 136341, 90037, 69226, 68339, 108161, 108912, 76465, 123924, 68591, 82647, 66361, 87248, 78977, 136212, 72038, 107627, 70544, 70498, 100484, 131446, 71105, 86262, 104939, 116880, 66803, 122753, 83913, 122807, 44364, 72027, 68782, 68202, 87635, 83369, 84360, 82259, 95867, 68699, 80139, 79727, 76416, 127446, 84366, 70631, 84141, 86322, 84655, 107919, 68462, 65075, 52542, 82445, 86268, 84178, 67891, 123426, 77591, 82252, 82767, 81256, 123284, 70957, 77554, 63869, 104737, 62030, 84897, 66802, 83267, 89857, 96015, 43835, 76411, 92641, 71919, 109384, 105356, 114663, 52632, 123099, 116799, 78753, 100872, 126717, 57138, 122592, 81489, 71785, 77250, 81501, 68201, 78236, 100579, 108803, 110437, 94420, 77660, 102285, 84368, 136226, 123466, 75549, 114561, 67890, 69200, 90352, 75197, 70850, 108907, 97878, 75311, 119268, 104625, 52468, 80966, 109455, 84116, 86147, 123807, 98143, 83250, 80745, 68645, 43879, 44367, 68723, 44371, 67162, 68776, 64696, 67072, 73724, 66302, 94115, 108393, 47354, 68752, 120949, 100488, 82646, 80048, 80794, 88802, 71958, 33067, 84369, 84308, 101986, 126042, 84485, 97787, 44558, 68038, 70835, 75066, 78985, 80792, 79328, 105497, 114610, 65728, 87363, 77826, 103464, 66861, 110684, 68588, 71519, 121194, 94222, 117551, 71622, 122252, 119283, 82246, 70672, 99531, 15676, 91878, 136357, 77374, 66878, 86552, 134912, 127142, 96168, 109302, 78602, 107687, 78989, 68505, 68230, 69143, 68467, 70884, 94363, 66305, 44805, 82758, 108961, 104684, 96834, 120591, 94278, 97789, 80396, 79125, 65068, 86144, 114655, 76666, 127025, 86140, 99138, 83781, 85621, 70675, 86278, 76650, 82668, 89185, 79362, 51837, 72097, 81286, 90552, 70243, 102127, 87200, 66859, 81515, 34500, 120692, 70846, 122595, 66840, 71213, 53477, 65471, 71464, 67912, 114710, 114557, 104604, 68464, 136310, 70696, 104978, 71221, 83704, 94996, 71810, 83613, 119002, 44803, 71936, 68733, 127518, 114660, 96149, 44332, 84124, 52469, 80391, 97794, 68779, 108139, 44806, 80398, 119347, 114214, 124848, 52915, 75407, 128732, 68486, 114045, 113833, 87319, 108944, 72233, 44366)
Run Time: 0.044862
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 300 | 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: 2151, 0, 1714877777, 1714881377, [["thread",69971],["thread",83357],["thread",85667],["thread",120845],["thread",44414],["thread",87791],["thread",126084],["thread",72040],["thread",91842],["thread",90507],["thread",80823],["thread",81688],["thread",98671],["thread",68264],["thread",82840],["thread",70712],["thread",68790],["thread",68734],["thread",136341],["thread",90037],["thread",69226],["thread",68339],["thread",108161],["thread",108912],["thread",76465],["thread",123924],["thread",68591],["thread",82647],["thread",66361],["thread",87248],["thread",78977],["thread",136212],["thread",72038],["thread",107627],["thread",70544],["thread",70498],["thread",100484],["thread",131446],["thread",71105],["thread",86262],["thread",104939],["thread",116880],["thread",66803],["thread",122753],["thread",83913],["thread",122807],["thread",44364],["thread",72027],["thread",68782],["thread",68202],["thread",87635],["thread",83369],["thread",84360],["thread",82259],["thread",95867],["thread",68699],["thread",80139],["thread",79727],["thread",76416],["thread",127446],["thread",84366],["thread",70631],["thread",84141],["thread",86322],["thread",84655],["thread",107919],["thread",68462],["thread",65075],["thread",52542],["thread",82445],["thread",86268],["thread",84178],["thread",67891],["thread",123426],["thread",77591],["thread",82252],["thread",82767],["thread",81256],["thread",123284],["thread",70957],["thread",77554],["thread",63869],["thread",104737],["thread",62030],["thread",84897],["thread",66802],["thread",83267],["thread",89857],["thread",96015],["thread",43835],["thread",76411],["thread",92641],["thread",71919],["thread",109384],["thread",105356],["thread",114663],["thread",52632],["thread",123099],["thread",116799],["thread",78753],["thread",100872],["thread",126717],["thread",57138],["thread",122592],["thread",81489],["thread",71785],["thread",77250],["thread",81501],["thread",68201],["thread",78236],["thread",100579],["thread",108803],["thread",110437],["thread",94420],["thread",77660],["thread",102285],["thread",84368],["thread",136226],["thread",123466],["thread",75549],["thread",114561],["thread",67890],["thread",69200],["thread",90352],["thread",75197],["thread",70850],["thread",108907],["thread",97878],["thread",75311],["thread",119268],["thread",104625],["thread",52468],["thread",80966],["thread",109455],["thread",84116],["thread",86147],["thread",123807],["thread",98143],["thread",83250],["thread",80745],["thread",68645],["thread",43879],["thread",44367],["thread",68723],["thread",44371],["thread",67162],["thread",68776],["thread",64696],["thread",67072],["thread",73724],["thread",66302],["thread",94115],["thread",108393],["thread",47354],["thread",68752],["thread",120949],["thread",100488],["thread",82646],["thread",80048],["thread",80794],["thread",88802],["thread",71958],["thread",33067],["thread",84369],["thread",84308],["thread",101986],["thread",126042],["thread",84485],["thread",97787],["thread",44558],["thread",68038],["thread",70835],["thread",75066],["thread",78985],["thread",80792],["thread",79328],["thread",105497],["thread",114610],["thread",65728],["thread",87363],["thread",77826],["thread",103464],["thread",66861],["thread",110684],["thread",68588],["thread",71519],["thread",121194],["thread",94222],["thread",117551],["thread",71622],["thread",122252],["thread",119283],["thread",82246],["thread",70672],["thread",99531],["thread",15676],["thread",91878],["thread",136357],["thread",77374],["thread",66878],["thread",86552],["thread",134912],["thread",127142],["thread",96168],["thread",109302],["thread",78602],["thread",107687],["thread",78989],["thread",68505],["thread",68230],["thread",69143],["thread",68467],["thread",70884],["thread",94363],["thread",66305],["thread",44805],["thread",82758],["thread",108961],["thread",104684],["thread",96834],["thread",120591],["thread",94278],["thread",97789],["thread",80396],["thread",79125],["thread",65068],["thread",86144],["thread",114655],["thread",76666],["thread",127025],["thread",86140],["thread",99138],["thread",83781],["thread",85621],["thread",70675],["thread",86278],["thread",76650],["thread",82668],["thread",89185],["thread",79362],["thread",51837],["thread",72097],["thread",81286],["thread",90552],["thread",70243],["thread",102127],["thread",87200],["thread",66859],["thread",81515],["thread",34500],["thread",120692],["thread",70846],["thread",122595],["thread",66840],["thread",71213],["thread",53477],["thread",65471],["thread",71464],["thread",67912],["thread",114710],["thread",114557],["thread",104604],["thread",68464],["thread",136310],["thread",70696],["thread",104978],["thread",71221],["thread",83704],["thread",94996],["thread",71810],["thread",83613],["thread",119002],["thread",44803],["thread",71936],["thread",68733],["thread",127518],["thread",114660],["thread",96149],["thread",44332],["thread",84124],["thread",52469],["thread",80391],["thread",97794],["thread",68779],["thread",108139],["thread",44806],["thread",80398],["thread",119347],["thread",114214],["thread",124848],["thread",52915],["thread",75407],["thread",128732],["thread",68486],["thread",114045],["thread",113833],["thread",87319],["thread",108944],["thread",72233],["thread",44366]]
Run Time: 0.003008
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.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |