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 (126888, 72514, 72826, 38712, 71826, 14766, 71770, 122354, 75403, 104901, 42647, 134410, 76940, 96903, 42657, 79814, 79832, 79101, 40585, 108160, 49992, 75675, 79964, 126908, 38678, 128636, 25885, 116416, 61572, 21247, 25595, 123998, 126421, 122382, 109760, 108285, 119914, 76685, 114971, 134293, 12498, 42654, 124451, 124461, 120633, 44886, 42662, 92630, 963, 80187, 962, 112479, 20703, 84216, 76420, 110764, 44429, 76320, 42660, 38680, 100301, 99521, 42668, 122711, 108194, 46956, 91279, 55505, 127730, 86012, 2069, 115766, 42650, 91302, 104089, 25688, 70141, 2066, 117840, 78684, 29924, 77806, 88391, 473, 131934, 23293, 119256, 124893, 112736, 99214, 105191, 38713, 42667, 66829, 115226, 1224, 25912, 121323, 49997, 25647, 111257, 126963, 42977, 116676, 116739, 42669, 113273, 99566, 117728, 120085, 71488, 49994, 66830, 22269, 124738, 31673, 115948, 17093, 125443, 21805, 126996, 35192, 1276, 52088, 1097, 120087, 22164, 93735, 126305, 23668, 14765, 126540, 127636, 97389, 19540, 98326, 42666, 9781, 119813, 130984, 49852, 91281, 29939, 38753, 69407, 101883, 42672, 2236, 38727, 103283, 42659, 77194, 39433, 14206, 117582, 2071, 79261, 58101, 105921, 53943, 42651, 82010, 49998, 122424, 49287, 69575, 104149, 127489, 103556, 53537, 33376, 88494, 122988, 104229, 123244, 85388, 95159, 127635, 130988, 111759, 110740, 42663, 134684, 110745, 13008, 33669, 132044, 131316, 49988, 87295, 104183, 129848, 14208, 21520, 126609, 91280, 11411, 8534, 42671, 14764, 107990, 50093, 119377, 5630, 42655, 103653, 49996, 22433, 1644, 2072, 122793, 48190, 117502, 79331, 49993, 80463, 91110, 77089, 42658, 64307, 1619, 51460, 48575, 122832, 100526, 49989, 53030, 42652, 50095, 104714, 70184, 82127, 40778, 115224, 78918, 42646, 126234, 55081, 42661, 103681, 38812, 106358, 42648, 42656, 78447, 38754, 127607, 100207, 104153, 85168, 66887, 49990, 108365, 56213, 21629, 130983, 105932, 80250, 120363, 105107, 91170, 53947, 105283, 15374, 53953, 89828, 2235, 104481, 108948, 124349, 88836, 111371, 67738, 104240, 78840, 70294, 60959, 79216, 98022, 55848, 81836, 104012, 78266, 8051, 109457, 127007, 42649, 42670, 101498, 135830, 42645, 126304, 21171, 95093, 109491, 1495, 99895, 126795, 125767, 67398)
Run Time: 0.586835
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: 126, 0, 1711656796, 1711660396, [["thread",126888],["thread",72514],["thread",72826],["thread",38712],["thread",71826],["thread",14766],["thread",71770],["thread",122354],["thread",75403],["thread",104901],["thread",42647],["thread",134410],["thread",76940],["thread",96903],["thread",42657],["thread",79814],["thread",79832],["thread",79101],["thread",40585],["thread",108160],["thread",49992],["thread",75675],["thread",79964],["thread",126908],["thread",38678],["thread",128636],["thread",25885],["thread",116416],["thread",61572],["thread",21247],["thread",25595],["thread",123998],["thread",126421],["thread",122382],["thread",109760],["thread",108285],["thread",119914],["thread",76685],["thread",114971],["thread",134293],["thread",12498],["thread",42654],["thread",124451],["thread",124461],["thread",120633],["thread",44886],["thread",42662],["thread",92630],["thread",963],["thread",80187],["thread",962],["thread",112479],["thread",20703],["thread",84216],["thread",76420],["thread",110764],["thread",44429],["thread",76320],["thread",42660],["thread",38680],["thread",100301],["thread",99521],["thread",42668],["thread",122711],["thread",108194],["thread",46956],["thread",91279],["thread",55505],["thread",127730],["thread",86012],["thread",2069],["thread",115766],["thread",42650],["thread",91302],["thread",104089],["thread",25688],["thread",70141],["thread",2066],["thread",117840],["thread",78684],["thread",29924],["thread",77806],["thread",88391],["thread",473],["thread",131934],["thread",23293],["thread",119256],["thread",124893],["thread",112736],["thread",99214],["thread",105191],["thread",38713],["thread",42667],["thread",66829],["thread",115226],["thread",1224],["thread",25912],["thread",121323],["thread",49997],["thread",25647],["thread",111257],["thread",126963],["thread",42977],["thread",116676],["thread",116739],["thread",42669],["thread",113273],["thread",99566],["thread",117728],["thread",120085],["thread",71488],["thread",49994],["thread",66830],["thread",22269],["thread",124738],["thread",31673],["thread",115948],["thread",17093],["thread",125443],["thread",21805],["thread",126996],["thread",35192],["thread",1276],["thread",52088],["thread",1097],["thread",120087],["thread",22164],["thread",93735],["thread",126305],["thread",23668],["thread",14765],["thread",126540],["thread",127636],["thread",97389],["thread",19540],["thread",98326],["thread",42666],["thread",9781],["thread",119813],["thread",130984],["thread",49852],["thread",91281],["thread",29939],["thread",38753],["thread",69407],["thread",101883],["thread",42672],["thread",2236],["thread",38727],["thread",103283],["thread",42659],["thread",77194],["thread",39433],["thread",14206],["thread",117582],["thread",2071],["thread",79261],["thread",58101],["thread",105921],["thread",53943],["thread",42651],["thread",82010],["thread",49998],["thread",122424],["thread",49287],["thread",69575],["thread",104149],["thread",127489],["thread",103556],["thread",53537],["thread",33376],["thread",88494],["thread",122988],["thread",104229],["thread",123244],["thread",85388],["thread",95159],["thread",127635],["thread",130988],["thread",111759],["thread",110740],["thread",42663],["thread",134684],["thread",110745],["thread",13008],["thread",33669],["thread",132044],["thread",131316],["thread",49988],["thread",87295],["thread",104183],["thread",129848],["thread",14208],["thread",21520],["thread",126609],["thread",91280],["thread",11411],["thread",8534],["thread",42671],["thread",14764],["thread",107990],["thread",50093],["thread",119377],["thread",5630],["thread",42655],["thread",103653],["thread",49996],["thread",22433],["thread",1644],["thread",2072],["thread",122793],["thread",48190],["thread",117502],["thread",79331],["thread",49993],["thread",80463],["thread",91110],["thread",77089],["thread",42658],["thread",64307],["thread",1619],["thread",51460],["thread",48575],["thread",122832],["thread",100526],["thread",49989],["thread",53030],["thread",42652],["thread",50095],["thread",104714],["thread",70184],["thread",82127],["thread",40778],["thread",115224],["thread",78918],["thread",42646],["thread",126234],["thread",55081],["thread",42661],["thread",103681],["thread",38812],["thread",106358],["thread",42648],["thread",42656],["thread",78447],["thread",38754],["thread",127607],["thread",100207],["thread",104153],["thread",85168],["thread",66887],["thread",49990],["thread",108365],["thread",56213],["thread",21629],["thread",130983],["thread",105932],["thread",80250],["thread",120363],["thread",105107],["thread",91170],["thread",53947],["thread",105283],["thread",15374],["thread",53953],["thread",89828],["thread",2235],["thread",104481],["thread",108948],["thread",124349],["thread",88836],["thread",111371],["thread",67738],["thread",104240],["thread",78840],["thread",70294],["thread",60959],["thread",79216],["thread",98022],["thread",55848],["thread",81836],["thread",104012],["thread",78266],["thread",8051],["thread",109457],["thread",127007],["thread",42649],["thread",42670],["thread",101498],["thread",135830],["thread",42645],["thread",126304],["thread",21171],["thread",95093],["thread",109491],["thread",1495],["thread",99895],["thread",126795],["thread",125767],["thread",67398]]
Run Time: 0.031178
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.004564
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |