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 (132754, 80792, 84485, 121766, 128193, 119998, 131602, 80794, 134547, 130783, 84368, 73020, 134148, 92975, 127617, 132408, 130274, 130243, 130389, 132270, 86278, 130551, 126372, 111087, 120354, 113857, 130545, 122250, 80857, 122776, 119994, 127081, 103787, 133518, 72027, 131912, 121572, 116992, 119118, 100312, 130394, 128367, 125420, 134269, 79912, 72944, 123172, 134863, 122479, 74988, 122524, 119384, 130810, 83913, 122807, 129646, 124005, 135244, 122635, 83267, 121183, 131053, 120239, 130678, 136429, 136800, 136232, 117842, 129469, 132060, 117815, 93018, 120712, 106153, 114799, 124715, 134914, 68839, 123435, 122040, 125035, 81688, 130064, 86144, 105010, 130015, 119696, 122593, 122195, 120810, 121964, 120816, 127187, 111012, 133328, 134710, 71785, 124214, 72737, 122048, 77951, 131550, 133434, 133732, 122417, 103321, 51837, 121934, 97599, 120579, 124365, 128608, 80966, 124336, 77948, 79125, 123628, 120871, 133283, 114791, 123048, 120058, 123898, 124726, 130401, 136809, 123417, 132266, 122718, 134550, 122852, 135044, 84124, 122874, 120886, 121474, 127553, 72595, 114216, 133444, 123949, 134058, 86679, 122447, 94728, 130566, 123060, 127541, 127833, 78089, 129344, 111217, 121598, 126862, 131324, 130478, 131540, 132508, 80396, 86140, 109723, 122220, 104374, 71244, 52542, 128293, 126524, 130166, 125816, 118814, 120829, 52468, 127959, 126807, 126419, 130165, 124604, 129894, 123923, 132401, 122093, 80229, 118389, 132094, 127786, 121234, 125277, 79581, 118586, 120802, 130567, 126165, 130249, 123976, 134841, 109812, 136036, 129489, 124450, 136427, 133532, 72044, 71421, 126497, 123618, 136017, 72040, 109696, 68220, 131191, 133014, 123686, 136061, 52632, 100907, 123357, 136925, 132193, 103322, 123091, 125258, 106177, 136334, 129581, 134652, 122244, 120770, 84369, 120157, 130044, 134482, 132708, 136778, 126988, 87009, 127129, 88802, 133240, 71389, 123897, 137168, 123347, 131026, 123742, 126688, 135037, 106724, 135661, 133052, 136689, 132168, 71262, 72233, 130016, 122606, 123011, 127585, 125028, 121267, 91981, 85911, 130291, 105635, 118870, 122052, 121556, 86868, 123161, 122764, 78985, 104226, 129553, 125995, 121758, 136754, 137120, 114131, 134602, 121399, 121882, 126291, 117820, 137161, 136311, 119116, 120351, 118928, 110337, 134041, 135746, 137193, 119458, 136803, 116957, 72038, 125325, 128755, 119041, 131249, 129290)
Run Time: 0.105193
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: 16228, 0, 1715614872, 1715618472, [["thread",132754],["thread",80792],["thread",84485],["thread",121766],["thread",128193],["thread",119998],["thread",131602],["thread",80794],["thread",134547],["thread",130783],["thread",84368],["thread",73020],["thread",134148],["thread",92975],["thread",127617],["thread",132408],["thread",130274],["thread",130243],["thread",130389],["thread",132270],["thread",86278],["thread",130551],["thread",126372],["thread",111087],["thread",120354],["thread",113857],["thread",130545],["thread",122250],["thread",80857],["thread",122776],["thread",119994],["thread",127081],["thread",103787],["thread",133518],["thread",72027],["thread",131912],["thread",121572],["thread",116992],["thread",119118],["thread",100312],["thread",130394],["thread",128367],["thread",125420],["thread",134269],["thread",79912],["thread",72944],["thread",123172],["thread",134863],["thread",122479],["thread",74988],["thread",122524],["thread",119384],["thread",130810],["thread",83913],["thread",122807],["thread",129646],["thread",124005],["thread",135244],["thread",122635],["thread",83267],["thread",121183],["thread",131053],["thread",120239],["thread",130678],["thread",136429],["thread",136800],["thread",136232],["thread",117842],["thread",129469],["thread",132060],["thread",117815],["thread",93018],["thread",120712],["thread",106153],["thread",114799],["thread",124715],["thread",134914],["thread",68839],["thread",123435],["thread",122040],["thread",125035],["thread",81688],["thread",130064],["thread",86144],["thread",105010],["thread",130015],["thread",119696],["thread",122593],["thread",122195],["thread",120810],["thread",121964],["thread",120816],["thread",127187],["thread",111012],["thread",133328],["thread",134710],["thread",71785],["thread",124214],["thread",72737],["thread",122048],["thread",77951],["thread",131550],["thread",133434],["thread",133732],["thread",122417],["thread",103321],["thread",51837],["thread",121934],["thread",97599],["thread",120579],["thread",124365],["thread",128608],["thread",80966],["thread",124336],["thread",77948],["thread",79125],["thread",123628],["thread",120871],["thread",133283],["thread",114791],["thread",123048],["thread",120058],["thread",123898],["thread",124726],["thread",130401],["thread",136809],["thread",123417],["thread",132266],["thread",122718],["thread",134550],["thread",122852],["thread",135044],["thread",84124],["thread",122874],["thread",120886],["thread",121474],["thread",127553],["thread",72595],["thread",114216],["thread",133444],["thread",123949],["thread",134058],["thread",86679],["thread",122447],["thread",94728],["thread",130566],["thread",123060],["thread",127541],["thread",127833],["thread",78089],["thread",129344],["thread",111217],["thread",121598],["thread",126862],["thread",131324],["thread",130478],["thread",131540],["thread",132508],["thread",80396],["thread",86140],["thread",109723],["thread",122220],["thread",104374],["thread",71244],["thread",52542],["thread",128293],["thread",126524],["thread",130166],["thread",125816],["thread",118814],["thread",120829],["thread",52468],["thread",127959],["thread",126807],["thread",126419],["thread",130165],["thread",124604],["thread",129894],["thread",123923],["thread",132401],["thread",122093],["thread",80229],["thread",118389],["thread",132094],["thread",127786],["thread",121234],["thread",125277],["thread",79581],["thread",118586],["thread",120802],["thread",130567],["thread",126165],["thread",130249],["thread",123976],["thread",134841],["thread",109812],["thread",136036],["thread",129489],["thread",124450],["thread",136427],["thread",133532],["thread",72044],["thread",71421],["thread",126497],["thread",123618],["thread",136017],["thread",72040],["thread",109696],["thread",68220],["thread",131191],["thread",133014],["thread",123686],["thread",136061],["thread",52632],["thread",100907],["thread",123357],["thread",136925],["thread",132193],["thread",103322],["thread",123091],["thread",125258],["thread",106177],["thread",136334],["thread",129581],["thread",134652],["thread",122244],["thread",120770],["thread",84369],["thread",120157],["thread",130044],["thread",134482],["thread",132708],["thread",136778],["thread",126988],["thread",87009],["thread",127129],["thread",88802],["thread",133240],["thread",71389],["thread",123897],["thread",137168],["thread",123347],["thread",131026],["thread",123742],["thread",126688],["thread",135037],["thread",106724],["thread",135661],["thread",133052],["thread",136689],["thread",132168],["thread",71262],["thread",72233],["thread",130016],["thread",122606],["thread",123011],["thread",127585],["thread",125028],["thread",121267],["thread",91981],["thread",85911],["thread",130291],["thread",105635],["thread",118870],["thread",122052],["thread",121556],["thread",86868],["thread",123161],["thread",122764],["thread",78985],["thread",104226],["thread",129553],["thread",125995],["thread",121758],["thread",136754],["thread",137120],["thread",114131],["thread",134602],["thread",121399],["thread",121882],["thread",126291],["thread",117820],["thread",137161],["thread",136311],["thread",119116],["thread",120351],["thread",118928],["thread",110337],["thread",134041],["thread",135746],["thread",137193],["thread",119458],["thread",136803],["thread",116957],["thread",72038],["thread",125325],["thread",128755],["thread",119041],["thread",131249],["thread",129290]]
Run Time: 0.284378
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.000100
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |