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 (71974, 14396, 51998, 1764, 95209, 11404, 51942, 20936, 52063, 55925, 80535, 1926, 1373, 1903, 56390, 31118, 76225, 120140, 109060, 1530, 1763, 1793, 76377, 43166, 81761, 50113, 77811, 83018, 1826, 62599, 114115, 1909, 1917, 76643, 77010, 95211, 106641, 51849, 59280, 1378, 50115, 38594, 51244, 98202, 99528, 62269, 1930, 84077, 34140, 1821, 93651, 13807, 107585, 79948, 51231, 76119, 5583, 76218, 64481, 1802, 82351, 1936, 114513, 76227, 46812, 116681, 76645, 756, 1923, 52084, 81314, 76215, 51851, 11395, 3890, 1797, 76430, 1769, 1815, 1803, 77008, 115537, 6597, 1422, 42198, 116756, 119390, 1929, 25177, 52369, 121437, 76223, 74134, 76431, 1908, 1932, 11158, 1827, 1814, 84478, 1841, 102412, 99712, 76160, 104135, 78112, 1533, 15212, 2100, 95597, 84336, 64064, 1818, 1677, 131271, 1901, 113967, 106917, 135891, 77425, 77074, 105658, 1683, 76558, 11293, 52442, 93712, 84117, 1927, 1837, 64404, 84041, 1939, 10519, 43167, 85117, 110132, 51618, 75924, 51409, 80538, 95042, 870, 122571, 50120, 81491, 77306, 1672, 1375, 1925, 96932, 81311, 84930, 98217, 1947, 1915, 94982, 1910, 52000, 83230, 51351, 50118, 114011, 76567, 84935, 1937, 116677, 76047, 81488, 79407, 88517, 116172, 52498, 64612, 106938, 77809, 1376, 128872, 115358, 1788, 76379, 83235, 84338, 104196, 62284, 59393, 84486, 1823, 103431, 1770, 81759, 51898, 64339, 95695, 51242, 83737, 48204, 95226, 77012, 103350, 51224, 76052, 83734, 11004, 1602, 1765, 84335, 70225, 1601, 114050, 94828, 51952, 74139, 1771, 77426, 76641, 76775, 77307, 51474, 1772, 84119, 89817, 10834, 1377, 119389, 1812, 1933, 71914, 21226, 115534, 10268, 115099, 1906, 51196, 52439, 95044, 76432, 50267, 131127, 76060, 51885, 76773, 115564, 1767, 95078, 1920, 108958, 82655, 95206, 77083, 83015, 1931, 74472)
Run Time: 0.008040
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 253 | 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: 929, 0, 1714025117, 1714028717, [["thread",71974],["thread",14396],["thread",51998],["thread",1764],["thread",95209],["thread",11404],["thread",51942],["thread",20936],["thread",52063],["thread",55925],["thread",80535],["thread",1926],["thread",1373],["thread",1903],["thread",56390],["thread",31118],["thread",76225],["thread",120140],["thread",109060],["thread",1530],["thread",1763],["thread",1793],["thread",76377],["thread",43166],["thread",81761],["thread",50113],["thread",77811],["thread",83018],["thread",1826],["thread",62599],["thread",114115],["thread",1909],["thread",1917],["thread",76643],["thread",77010],["thread",95211],["thread",106641],["thread",51849],["thread",59280],["thread",1378],["thread",50115],["thread",38594],["thread",51244],["thread",98202],["thread",99528],["thread",62269],["thread",1930],["thread",84077],["thread",34140],["thread",1821],["thread",93651],["thread",13807],["thread",107585],["thread",79948],["thread",51231],["thread",76119],["thread",5583],["thread",76218],["thread",64481],["thread",1802],["thread",82351],["thread",1936],["thread",114513],["thread",76227],["thread",46812],["thread",116681],["thread",76645],["thread",756],["thread",1923],["thread",52084],["thread",81314],["thread",76215],["thread",51851],["thread",11395],["thread",3890],["thread",1797],["thread",76430],["thread",1769],["thread",1815],["thread",1803],["thread",77008],["thread",115537],["thread",6597],["thread",1422],["thread",42198],["thread",116756],["thread",119390],["thread",1929],["thread",25177],["thread",52369],["thread",121437],["thread",76223],["thread",74134],["thread",76431],["thread",1908],["thread",1932],["thread",11158],["thread",1827],["thread",1814],["thread",84478],["thread",1841],["thread",102412],["thread",99712],["thread",76160],["thread",104135],["thread",78112],["thread",1533],["thread",15212],["thread",2100],["thread",95597],["thread",84336],["thread",64064],["thread",1818],["thread",1677],["thread",131271],["thread",1901],["thread",113967],["thread",106917],["thread",135891],["thread",77425],["thread",77074],["thread",105658],["thread",1683],["thread",76558],["thread",11293],["thread",52442],["thread",93712],["thread",84117],["thread",1927],["thread",1837],["thread",64404],["thread",84041],["thread",1939],["thread",10519],["thread",43167],["thread",85117],["thread",110132],["thread",51618],["thread",75924],["thread",51409],["thread",80538],["thread",95042],["thread",870],["thread",122571],["thread",50120],["thread",81491],["thread",77306],["thread",1672],["thread",1375],["thread",1925],["thread",96932],["thread",81311],["thread",84930],["thread",98217],["thread",1947],["thread",1915],["thread",94982],["thread",1910],["thread",52000],["thread",83230],["thread",51351],["thread",50118],["thread",114011],["thread",76567],["thread",84935],["thread",1937],["thread",116677],["thread",76047],["thread",81488],["thread",79407],["thread",88517],["thread",116172],["thread",52498],["thread",64612],["thread",106938],["thread",77809],["thread",1376],["thread",128872],["thread",115358],["thread",1788],["thread",76379],["thread",83235],["thread",84338],["thread",104196],["thread",62284],["thread",59393],["thread",84486],["thread",1823],["thread",103431],["thread",1770],["thread",81759],["thread",51898],["thread",64339],["thread",95695],["thread",51242],["thread",83737],["thread",48204],["thread",95226],["thread",77012],["thread",103350],["thread",51224],["thread",76052],["thread",83734],["thread",11004],["thread",1602],["thread",1765],["thread",84335],["thread",70225],["thread",1601],["thread",114050],["thread",94828],["thread",51952],["thread",74139],["thread",1771],["thread",77426],["thread",76641],["thread",76775],["thread",77307],["thread",51474],["thread",1772],["thread",84119],["thread",89817],["thread",10834],["thread",1377],["thread",119389],["thread",1812],["thread",1933],["thread",71914],["thread",21226],["thread",115534],["thread",10268],["thread",115099],["thread",1906],["thread",51196],["thread",52439],["thread",95044],["thread",76432],["thread",50267],["thread",131127],["thread",76060],["thread",51885],["thread",76773],["thread",115564],["thread",1767],["thread",95078],["thread",1920],["thread",108958],["thread",82655],["thread",95206],["thread",77083],["thread",83015],["thread",1931],["thread",74472]]
Run Time: 0.001194
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.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |