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 (135022, 131507, 135454, 135592, 135335, 136302, 136366, 134281, 125372, 45286, 135638, 135872, 135711, 135361, 133961, 136344, 132699, 124486, 124611, 133473, 133728, 133550, 133584, 133617, 135150, 133951, 132988, 133876, 129633, 85046, 135008, 133367, 129218, 134335, 133822, 124628, 45053, 129629, 133674, 135801, 121784, 136626, 134702, 134459, 133708, 126159, 136025, 135532, 134236, 108903, 135972, 133573, 134428, 134484, 135390, 133815, 95893, 129256, 133111, 125830, 135094, 129025, 77660, 134909, 135391, 134383, 110258, 43980, 79542, 133212, 135707, 134462, 131857, 131101, 131530, 125831, 132862, 133000, 125819, 44032, 136291, 135416, 133761, 135436, 128478, 133203, 47570, 128415, 121782, 131809, 134301, 135202, 130125, 136593, 135971, 135263, 134028, 133785, 133681, 136365, 129017, 133714, 135769, 131579, 135905, 85496, 136028, 118522, 129272, 133202, 132372, 63014, 133562, 136482, 136207, 135593, 130803, 78283, 134298, 131783, 111827, 136314, 129273, 111061, 113872, 110537, 135653, 136074, 136177, 128209, 131720, 135045, 133209, 133857, 136506, 136211, 134908, 127269, 133591, 121781, 128682, 136046, 136083, 43937, 134299, 134995, 124704, 135301, 135470, 135477, 110900, 134290, 129405, 135721, 134874, 107555, 66904, 112219, 129216, 124330, 133137, 136072, 133991, 134837, 135392, 132298, 130772, 135187, 133361, 136542, 134208, 133760, 133659, 90323, 128580, 133343, 135811, 129013, 133851, 44890, 136588, 134648, 44474, 86248, 133992, 135816, 135489, 133853, 129648, 135234, 79054, 53444, 133860, 128428, 134900, 135024, 112592, 127514, 136278, 136089, 134202, 133955, 134178, 125837, 129594, 134760, 136007, 129780, 133560, 133783, 130030, 134067, 133694, 131536, 135530, 134996, 133782, 133738, 92778, 130774, 135057, 133725, 68921, 47694, 136322, 135799, 44654, 78054, 130152, 130823, 134235, 130091, 134209, 129287, 131574, 133848, 111647, 134432, 124119, 134765, 134758, 129269, 130302, 136210, 133144, 129161, 134549, 136255, 45283, 124124, 134457, 84070, 114020, 133925, 129267, 111587, 79304, 130117, 132669, 128104, 133535, 135063, 134393, 135387, 39739, 133957, 134854, 134381, 132527, 136205, 81756, 114240, 133394, 136401, 135383, 133446, 134007, 135846, 135206, 135634, 136402, 135047, 41731, 125366, 129276, 46747, 122001, 131528, 128466, 133404, 134369, 134198, 134963, 134889, 119819, 136202, 136035, 135411, 136030, 84883)
Run Time: 0.010785
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: 12999, 0, 1713623570, 1713627170, [["thread",135022],["thread",131507],["thread",135454],["thread",135592],["thread",135335],["thread",136302],["thread",136366],["thread",134281],["thread",125372],["thread",45286],["thread",135638],["thread",135872],["thread",135711],["thread",135361],["thread",133961],["thread",136344],["thread",132699],["thread",124486],["thread",124611],["thread",133473],["thread",133728],["thread",133550],["thread",133584],["thread",133617],["thread",135150],["thread",133951],["thread",132988],["thread",133876],["thread",129633],["thread",85046],["thread",135008],["thread",133367],["thread",129218],["thread",134335],["thread",133822],["thread",124628],["thread",45053],["thread",129629],["thread",133674],["thread",135801],["thread",121784],["thread",136626],["thread",134702],["thread",134459],["thread",133708],["thread",126159],["thread",136025],["thread",135532],["thread",134236],["thread",108903],["thread",135972],["thread",133573],["thread",134428],["thread",134484],["thread",135390],["thread",133815],["thread",95893],["thread",129256],["thread",133111],["thread",125830],["thread",135094],["thread",129025],["thread",77660],["thread",134909],["thread",135391],["thread",134383],["thread",110258],["thread",43980],["thread",79542],["thread",133212],["thread",135707],["thread",134462],["thread",131857],["thread",131101],["thread",131530],["thread",125831],["thread",132862],["thread",133000],["thread",125819],["thread",44032],["thread",136291],["thread",135416],["thread",133761],["thread",135436],["thread",128478],["thread",133203],["thread",47570],["thread",128415],["thread",121782],["thread",131809],["thread",134301],["thread",135202],["thread",130125],["thread",136593],["thread",135971],["thread",135263],["thread",134028],["thread",133785],["thread",133681],["thread",136365],["thread",129017],["thread",133714],["thread",135769],["thread",131579],["thread",135905],["thread",85496],["thread",136028],["thread",118522],["thread",129272],["thread",133202],["thread",132372],["thread",63014],["thread",133562],["thread",136482],["thread",136207],["thread",135593],["thread",130803],["thread",78283],["thread",134298],["thread",131783],["thread",111827],["thread",136314],["thread",129273],["thread",111061],["thread",113872],["thread",110537],["thread",135653],["thread",136074],["thread",136177],["thread",128209],["thread",131720],["thread",135045],["thread",133209],["thread",133857],["thread",136506],["thread",136211],["thread",134908],["thread",127269],["thread",133591],["thread",121781],["thread",128682],["thread",136046],["thread",136083],["thread",43937],["thread",134299],["thread",134995],["thread",124704],["thread",135301],["thread",135470],["thread",135477],["thread",110900],["thread",134290],["thread",129405],["thread",135721],["thread",134874],["thread",107555],["thread",66904],["thread",112219],["thread",129216],["thread",124330],["thread",133137],["thread",136072],["thread",133991],["thread",134837],["thread",135392],["thread",132298],["thread",130772],["thread",135187],["thread",133361],["thread",136542],["thread",134208],["thread",133760],["thread",133659],["thread",90323],["thread",128580],["thread",133343],["thread",135811],["thread",129013],["thread",133851],["thread",44890],["thread",136588],["thread",134648],["thread",44474],["thread",86248],["thread",133992],["thread",135816],["thread",135489],["thread",133853],["thread",129648],["thread",135234],["thread",79054],["thread",53444],["thread",133860],["thread",128428],["thread",134900],["thread",135024],["thread",112592],["thread",127514],["thread",136278],["thread",136089],["thread",134202],["thread",133955],["thread",134178],["thread",125837],["thread",129594],["thread",134760],["thread",136007],["thread",129780],["thread",133560],["thread",133783],["thread",130030],["thread",134067],["thread",133694],["thread",131536],["thread",135530],["thread",134996],["thread",133782],["thread",133738],["thread",92778],["thread",130774],["thread",135057],["thread",133725],["thread",68921],["thread",47694],["thread",136322],["thread",135799],["thread",44654],["thread",78054],["thread",130152],["thread",130823],["thread",134235],["thread",130091],["thread",134209],["thread",129287],["thread",131574],["thread",133848],["thread",111647],["thread",134432],["thread",124119],["thread",134765],["thread",134758],["thread",129269],["thread",130302],["thread",136210],["thread",133144],["thread",129161],["thread",134549],["thread",136255],["thread",45283],["thread",124124],["thread",134457],["thread",84070],["thread",114020],["thread",133925],["thread",129267],["thread",111587],["thread",79304],["thread",130117],["thread",132669],["thread",128104],["thread",133535],["thread",135063],["thread",134393],["thread",135387],["thread",39739],["thread",133957],["thread",134854],["thread",134381],["thread",132527],["thread",136205],["thread",81756],["thread",114240],["thread",133394],["thread",136401],["thread",135383],["thread",133446],["thread",134007],["thread",135846],["thread",135206],["thread",135634],["thread",136402],["thread",135047],["thread",41731],["thread",125366],["thread",129276],["thread",46747],["thread",122001],["thread",131528],["thread",128466],["thread",133404],["thread",134369],["thread",134198],["thread",134963],["thread",134889],["thread",119819],["thread",136202],["thread",136035],["thread",135411],["thread",136030],["thread",84883]]
Run Time: 0.001463
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 |