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 (115939, 107327, 110039, 113342, 129403, 133260, 135632, 121040, 130610, 118314, 107791, 131900, 120371, 108314, 109769, 117253, 122902, 132927, 121269, 115552, 115745, 130453, 130767, 89378, 125877, 118273, 123997, 117414, 113942, 97235, 78810, 123494, 122248, 121796, 130536, 126047, 118914, 106212, 120912, 117026, 132692, 125497, 132176, 121436, 122193, 117784, 96669, 104514, 122029, 118335, 103640, 132190, 99781, 117351, 116115, 118481, 89531, 116886, 69694, 114542, 115457, 122044, 99018, 131174, 117332, 121910, 116864, 71330, 95451, 69756, 117852, 119743, 116721, 106930, 102474, 94092, 71296, 122662, 122350, 109335, 96482, 117447, 120121, 125232, 118502, 108326, 116929, 131687, 117217, 106748, 118258, 89039, 117022, 97525, 130144, 120528, 119605, 100025, 126906, 105968, 120151, 107419, 121930, 120920, 117575, 115323, 136718, 119575, 120561, 129189, 126637, 118492, 121302, 106281, 98292, 106557, 120405, 134690, 132211, 121361, 88077, 107306, 119472, 117315, 129706, 122820, 116983, 117954, 107255, 100480, 122430, 132684, 117238, 89655, 89281, 115403, 117636, 125899, 123364, 116248, 102908, 127476, 102227, 126726, 117599, 132907, 109728, 118043, 118744, 121903, 106971, 123570, 74010, 116267, 108409, 88451, 134396, 107846, 94726, 117043, 120006, 120003, 117628, 103931, 98938, 122750, 134545, 119646, 103985, 122485, 121247, 107207, 70562, 122062, 107645, 117814, 119011, 122787, 112874, 122476, 109112, 121363, 118416, 110950, 123170, 117349, 95512, 131027, 119969, 123121, 117000, 117643, 123276, 117431, 131221, 120428, 121919, 130799, 123424, 126596, 119360, 117926, 96531, 117802, 120631, 106115, 120794, 72479, 119965, 125108, 131909, 100242, 133778, 118483, 131792, 120924, 109016, 109375, 103717, 118403, 119373, 105309, 126331, 119059, 120002, 126632, 121415, 108661, 109353, 119201, 117535, 131997, 115960, 121290, 122362, 107326, 124080, 114716, 109297, 123572, 122480, 42829, 85027, 117607, 116105, 118148, 118445, 109116, 107182, 117591, 109672, 71343, 124991, 118027, 71903, 115435, 120771, 115563, 104486, 100374, 108056, 121976, 113577, 104764, 125706, 98905, 120639, 121484, 112362, 116944, 135315, 133409, 29498, 117846, 118813, 109512, 119705, 75707, 109564, 130287, 111286, 122653, 114757, 118886, 119955, 120874, 118088, 111825, 106348, 130706, 116956, 71313, 125111, 105095, 102237, 131213, 125321, 62070, 118343, 102250)
Run Time: 0.030837
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: 28825, 0, 1714215017, 1714218617, [["thread",115939],["thread",107327],["thread",110039],["thread",113342],["thread",129403],["thread",133260],["thread",135632],["thread",121040],["thread",130610],["thread",118314],["thread",107791],["thread",131900],["thread",120371],["thread",108314],["thread",109769],["thread",117253],["thread",122902],["thread",132927],["thread",121269],["thread",115552],["thread",115745],["thread",130453],["thread",130767],["thread",89378],["thread",125877],["thread",118273],["thread",123997],["thread",117414],["thread",113942],["thread",97235],["thread",78810],["thread",123494],["thread",122248],["thread",121796],["thread",130536],["thread",126047],["thread",118914],["thread",106212],["thread",120912],["thread",117026],["thread",132692],["thread",125497],["thread",132176],["thread",121436],["thread",122193],["thread",117784],["thread",96669],["thread",104514],["thread",122029],["thread",118335],["thread",103640],["thread",132190],["thread",99781],["thread",117351],["thread",116115],["thread",118481],["thread",89531],["thread",116886],["thread",69694],["thread",114542],["thread",115457],["thread",122044],["thread",99018],["thread",131174],["thread",117332],["thread",121910],["thread",116864],["thread",71330],["thread",95451],["thread",69756],["thread",117852],["thread",119743],["thread",116721],["thread",106930],["thread",102474],["thread",94092],["thread",71296],["thread",122662],["thread",122350],["thread",109335],["thread",96482],["thread",117447],["thread",120121],["thread",125232],["thread",118502],["thread",108326],["thread",116929],["thread",131687],["thread",117217],["thread",106748],["thread",118258],["thread",89039],["thread",117022],["thread",97525],["thread",130144],["thread",120528],["thread",119605],["thread",100025],["thread",126906],["thread",105968],["thread",120151],["thread",107419],["thread",121930],["thread",120920],["thread",117575],["thread",115323],["thread",136718],["thread",119575],["thread",120561],["thread",129189],["thread",126637],["thread",118492],["thread",121302],["thread",106281],["thread",98292],["thread",106557],["thread",120405],["thread",134690],["thread",132211],["thread",121361],["thread",88077],["thread",107306],["thread",119472],["thread",117315],["thread",129706],["thread",122820],["thread",116983],["thread",117954],["thread",107255],["thread",100480],["thread",122430],["thread",132684],["thread",117238],["thread",89655],["thread",89281],["thread",115403],["thread",117636],["thread",125899],["thread",123364],["thread",116248],["thread",102908],["thread",127476],["thread",102227],["thread",126726],["thread",117599],["thread",132907],["thread",109728],["thread",118043],["thread",118744],["thread",121903],["thread",106971],["thread",123570],["thread",74010],["thread",116267],["thread",108409],["thread",88451],["thread",134396],["thread",107846],["thread",94726],["thread",117043],["thread",120006],["thread",120003],["thread",117628],["thread",103931],["thread",98938],["thread",122750],["thread",134545],["thread",119646],["thread",103985],["thread",122485],["thread",121247],["thread",107207],["thread",70562],["thread",122062],["thread",107645],["thread",117814],["thread",119011],["thread",122787],["thread",112874],["thread",122476],["thread",109112],["thread",121363],["thread",118416],["thread",110950],["thread",123170],["thread",117349],["thread",95512],["thread",131027],["thread",119969],["thread",123121],["thread",117000],["thread",117643],["thread",123276],["thread",117431],["thread",131221],["thread",120428],["thread",121919],["thread",130799],["thread",123424],["thread",126596],["thread",119360],["thread",117926],["thread",96531],["thread",117802],["thread",120631],["thread",106115],["thread",120794],["thread",72479],["thread",119965],["thread",125108],["thread",131909],["thread",100242],["thread",133778],["thread",118483],["thread",131792],["thread",120924],["thread",109016],["thread",109375],["thread",103717],["thread",118403],["thread",119373],["thread",105309],["thread",126331],["thread",119059],["thread",120002],["thread",126632],["thread",121415],["thread",108661],["thread",109353],["thread",119201],["thread",117535],["thread",131997],["thread",115960],["thread",121290],["thread",122362],["thread",107326],["thread",124080],["thread",114716],["thread",109297],["thread",123572],["thread",122480],["thread",42829],["thread",85027],["thread",117607],["thread",116105],["thread",118148],["thread",118445],["thread",109116],["thread",107182],["thread",117591],["thread",109672],["thread",71343],["thread",124991],["thread",118027],["thread",71903],["thread",115435],["thread",120771],["thread",115563],["thread",104486],["thread",100374],["thread",108056],["thread",121976],["thread",113577],["thread",104764],["thread",125706],["thread",98905],["thread",120639],["thread",121484],["thread",112362],["thread",116944],["thread",135315],["thread",133409],["thread",29498],["thread",117846],["thread",118813],["thread",109512],["thread",119705],["thread",75707],["thread",109564],["thread",130287],["thread",111286],["thread",122653],["thread",114757],["thread",118886],["thread",119955],["thread",120874],["thread",118088],["thread",111825],["thread",106348],["thread",130706],["thread",116956],["thread",71313],["thread",125111],["thread",105095],["thread",102237],["thread",131213],["thread",125321],["thread",62070],["thread",118343],["thread",102250]]
Run Time: 0.002338
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.000083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |