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 (21408, 130298, 59848, 19001, 72285, 110895, 119636, 122073, 38145, 115414, 69233, 94980, 106478, 70306, 88361, 71301, 85412, 100544, 85155, 85328, 56955, 99612, 88490, 110372, 21770, 86378, 65169, 77395, 95691, 108522, 41718, 73785, 126512, 122359, 110825, 76571, 121806, 57940, 35272, 63943, 37640, 45247, 81174, 68342, 58719, 135987, 91576, 128872, 70893, 65607, 121982, 128166, 71681, 63318, 117339, 118141, 68683, 69401, 58406, 64092, 85994, 66382, 54348, 122272, 124539, 107652, 75410, 91447, 49942, 126898, 50628, 100955, 61033, 97558, 84925, 35400, 65294, 56827, 123857, 71741, 85950, 105135, 83450, 65807, 113873, 86924, 120903, 80793, 41231, 113134, 92968, 102615, 59378, 64280, 109912, 103920, 108973, 124442, 88123, 74830, 82968, 48684, 112114, 45220, 126498, 116634, 125172, 120530, 79888, 65145, 85567, 76074, 36902, 112444, 101594, 92848, 125037, 92439, 81507, 102752, 87788, 82138, 85857, 127031, 133387, 98157, 116147, 54794, 127780, 113876, 89780, 127712, 118062, 86607, 104203, 67910, 51462, 90681, 96696, 83579, 117824, 118331, 54543, 36653, 90498, 129896, 53189, 89739, 109624, 30419, 40565, 91311, 30622, 57208, 73526, 103373, 34645, 127077, 108226, 95062, 98206, 86516, 57876, 36380, 69499, 94339, 95939, 83367, 65961, 96813, 128307, 128569, 66407, 2769, 91618, 38079, 61364, 64831, 123370, 59503, 69556, 97363, 90996, 103046, 37452, 58502, 21281, 66949, 55895, 68677, 37056, 61446, 58715, 126530, 100082, 98520, 111755, 72672, 63804, 36840, 52598, 73751, 67672, 123689, 83319, 105159, 89807, 77865, 76072, 96330, 72416, 72418, 63780, 91791, 5600, 80658, 22606, 90228, 123314, 56294, 115981, 60520, 96343, 80476, 126821, 67711, 91252, 128208, 124733, 100212, 71743, 66940, 63115, 95016, 58404, 117028, 57815, 123438, 132854, 49000, 52253, 136843, 18069, 65765, 123724, 60497, 100458, 68953, 107190, 35559, 56286, 85469, 111983, 53510, 52697, 122478, 48753, 64014, 66986, 72611, 81913, 57338, 112469, 105344, 44166, 54601, 110728, 72329, 42274, 56895, 103819, 65929, 116488, 94451, 56637, 43118, 85972, 88037, 37834, 84397, 112659, 80024, 44599, 120333, 99263, 60894, 48815, 77320, 111805, 123083, 56299, 136374, 103824, 49251, 72234, 86566, 124769, 72534, 30765, 55837)
Run Time: 0.142215
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: 1338, 0, 1715508665, 1715512265, [["thread",21408],["thread",130298],["thread",59848],["thread",19001],["thread",72285],["thread",110895],["thread",119636],["thread",122073],["thread",38145],["thread",115414],["thread",69233],["thread",94980],["thread",106478],["thread",70306],["thread",88361],["thread",71301],["thread",85412],["thread",100544],["thread",85155],["thread",85328],["thread",56955],["thread",99612],["thread",88490],["thread",110372],["thread",21770],["thread",86378],["thread",65169],["thread",77395],["thread",95691],["thread",108522],["thread",41718],["thread",73785],["thread",126512],["thread",122359],["thread",110825],["thread",76571],["thread",121806],["thread",57940],["thread",35272],["thread",63943],["thread",37640],["thread",45247],["thread",81174],["thread",68342],["thread",58719],["thread",135987],["thread",91576],["thread",128872],["thread",70893],["thread",65607],["thread",121982],["thread",128166],["thread",71681],["thread",63318],["thread",117339],["thread",118141],["thread",68683],["thread",69401],["thread",58406],["thread",64092],["thread",85994],["thread",66382],["thread",54348],["thread",122272],["thread",124539],["thread",107652],["thread",75410],["thread",91447],["thread",49942],["thread",126898],["thread",50628],["thread",100955],["thread",61033],["thread",97558],["thread",84925],["thread",35400],["thread",65294],["thread",56827],["thread",123857],["thread",71741],["thread",85950],["thread",105135],["thread",83450],["thread",65807],["thread",113873],["thread",86924],["thread",120903],["thread",80793],["thread",41231],["thread",113134],["thread",92968],["thread",102615],["thread",59378],["thread",64280],["thread",109912],["thread",103920],["thread",108973],["thread",124442],["thread",88123],["thread",74830],["thread",82968],["thread",48684],["thread",112114],["thread",45220],["thread",126498],["thread",116634],["thread",125172],["thread",120530],["thread",79888],["thread",65145],["thread",85567],["thread",76074],["thread",36902],["thread",112444],["thread",101594],["thread",92848],["thread",125037],["thread",92439],["thread",81507],["thread",102752],["thread",87788],["thread",82138],["thread",85857],["thread",127031],["thread",133387],["thread",98157],["thread",116147],["thread",54794],["thread",127780],["thread",113876],["thread",89780],["thread",127712],["thread",118062],["thread",86607],["thread",104203],["thread",67910],["thread",51462],["thread",90681],["thread",96696],["thread",83579],["thread",117824],["thread",118331],["thread",54543],["thread",36653],["thread",90498],["thread",129896],["thread",53189],["thread",89739],["thread",109624],["thread",30419],["thread",40565],["thread",91311],["thread",30622],["thread",57208],["thread",73526],["thread",103373],["thread",34645],["thread",127077],["thread",108226],["thread",95062],["thread",98206],["thread",86516],["thread",57876],["thread",36380],["thread",69499],["thread",94339],["thread",95939],["thread",83367],["thread",65961],["thread",96813],["thread",128307],["thread",128569],["thread",66407],["thread",2769],["thread",91618],["thread",38079],["thread",61364],["thread",64831],["thread",123370],["thread",59503],["thread",69556],["thread",97363],["thread",90996],["thread",103046],["thread",37452],["thread",58502],["thread",21281],["thread",66949],["thread",55895],["thread",68677],["thread",37056],["thread",61446],["thread",58715],["thread",126530],["thread",100082],["thread",98520],["thread",111755],["thread",72672],["thread",63804],["thread",36840],["thread",52598],["thread",73751],["thread",67672],["thread",123689],["thread",83319],["thread",105159],["thread",89807],["thread",77865],["thread",76072],["thread",96330],["thread",72416],["thread",72418],["thread",63780],["thread",91791],["thread",5600],["thread",80658],["thread",22606],["thread",90228],["thread",123314],["thread",56294],["thread",115981],["thread",60520],["thread",96343],["thread",80476],["thread",126821],["thread",67711],["thread",91252],["thread",128208],["thread",124733],["thread",100212],["thread",71743],["thread",66940],["thread",63115],["thread",95016],["thread",58404],["thread",117028],["thread",57815],["thread",123438],["thread",132854],["thread",49000],["thread",52253],["thread",136843],["thread",18069],["thread",65765],["thread",123724],["thread",60497],["thread",100458],["thread",68953],["thread",107190],["thread",35559],["thread",56286],["thread",85469],["thread",111983],["thread",53510],["thread",52697],["thread",122478],["thread",48753],["thread",64014],["thread",66986],["thread",72611],["thread",81913],["thread",57338],["thread",112469],["thread",105344],["thread",44166],["thread",54601],["thread",110728],["thread",72329],["thread",42274],["thread",56895],["thread",103819],["thread",65929],["thread",116488],["thread",94451],["thread",56637],["thread",43118],["thread",85972],["thread",88037],["thread",37834],["thread",84397],["thread",112659],["thread",80024],["thread",44599],["thread",120333],["thread",99263],["thread",60894],["thread",48815],["thread",77320],["thread",111805],["thread",123083],["thread",56299],["thread",136374],["thread",103824],["thread",49251],["thread",72234],["thread",86566],["thread",124769],["thread",72534],["thread",30765],["thread",55837]]
Run Time: 0.015331
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.000116
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |