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 (113185, 134476, 127269, 128682, 135359, 131454, 131383, 136459, 135971, 133870, 132474, 135992, 132048, 110477, 134023, 136211, 134242, 134265, 134163, 135876, 135516, 136191, 135841, 135450, 130888, 133031, 124102, 133279, 123773, 91956, 113240, 115261, 111827, 92060, 122094, 133082, 133660, 136224, 136711, 135780, 130985, 135150, 134516, 132329, 131692, 135174, 131330, 132046, 133453, 136442, 135386, 134146, 133394, 133674, 38095, 129269, 136046, 116061, 127929, 135210, 133525, 135898, 135427, 135593, 77551, 114321, 135812, 134288, 133799, 92581, 135974, 134132, 134506, 135848, 135486, 136361, 125026, 134721, 136548, 133265, 134775, 133457, 134200, 136723, 133738, 133342, 135187, 134641, 136047, 132840, 133876, 135573, 134531, 121535, 132546, 133209, 134719, 99255, 112018, 64490, 133957, 134537, 136601, 134800, 131040, 130969, 124323, 133245, 132116, 134722, 134759, 133599, 136255, 132372, 133158, 129294, 133010, 136774, 131758, 136493, 129528, 133390, 133659, 132313, 130397, 136694, 136627, 113794, 133853, 135080, 133480, 131993, 132316, 111309, 113276, 135823, 132315, 134714, 113793, 133250, 131007, 129612, 132626, 136312, 134026, 134320, 133307, 130682, 134191, 133739, 134741, 134483, 136822, 136007, 108903, 135634, 133369, 132650, 133877, 135700, 133339, 110580, 136228, 133941, 130722, 135392, 133770, 118522, 108890, 131829, 133810, 136616, 134581, 124963, 136147, 135369, 132881, 130650, 133163, 133101, 136016, 127866, 135452, 135511, 135262, 136481, 132647, 131660, 124226, 136570, 111525, 133389, 98993, 130787, 136404, 108302, 136188, 132004, 133920, 133464, 98935, 129193, 133785, 135330, 130059, 129258, 134570, 133440, 120191, 136394, 110848, 136393, 133280, 87500, 128582, 132584, 115903, 133576, 134184, 136572, 133510, 133362, 125830, 136770, 132087, 136314, 108463, 135609, 128999, 132699, 135361, 113834, 133963, 39080, 133918, 134538, 123970, 120205, 130295, 135824, 136399, 133329, 131451, 134548, 124052, 133264, 133692, 135145, 129415, 134927, 132288, 78128, 136551, 134386, 128669, 133383, 135581, 135346, 115646, 133312, 132317, 121370, 136020, 136218, 132569, 80139, 93345, 111061, 127625, 134799, 133495, 132999, 129293, 133490, 118865, 116898, 136115, 110082, 135202, 133562, 134254, 133534, 133458, 135347, 136100, 126576, 130181, 135954, 111906, 136063, 135477, 136348, 131079, 135322, 128926, 122001, 135302, 132035, 135986, 131728)
Run Time: 0.030716
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: 11748, 0, 1714030599, 1714034199, [["thread",113185],["thread",134476],["thread",127269],["thread",128682],["thread",135359],["thread",131454],["thread",131383],["thread",136459],["thread",135971],["thread",133870],["thread",132474],["thread",135992],["thread",132048],["thread",110477],["thread",134023],["thread",136211],["thread",134242],["thread",134265],["thread",134163],["thread",135876],["thread",135516],["thread",136191],["thread",135841],["thread",135450],["thread",130888],["thread",133031],["thread",124102],["thread",133279],["thread",123773],["thread",91956],["thread",113240],["thread",115261],["thread",111827],["thread",92060],["thread",122094],["thread",133082],["thread",133660],["thread",136224],["thread",136711],["thread",135780],["thread",130985],["thread",135150],["thread",134516],["thread",132329],["thread",131692],["thread",135174],["thread",131330],["thread",132046],["thread",133453],["thread",136442],["thread",135386],["thread",134146],["thread",133394],["thread",133674],["thread",38095],["thread",129269],["thread",136046],["thread",116061],["thread",127929],["thread",135210],["thread",133525],["thread",135898],["thread",135427],["thread",135593],["thread",77551],["thread",114321],["thread",135812],["thread",134288],["thread",133799],["thread",92581],["thread",135974],["thread",134132],["thread",134506],["thread",135848],["thread",135486],["thread",136361],["thread",125026],["thread",134721],["thread",136548],["thread",133265],["thread",134775],["thread",133457],["thread",134200],["thread",136723],["thread",133738],["thread",133342],["thread",135187],["thread",134641],["thread",136047],["thread",132840],["thread",133876],["thread",135573],["thread",134531],["thread",121535],["thread",132546],["thread",133209],["thread",134719],["thread",99255],["thread",112018],["thread",64490],["thread",133957],["thread",134537],["thread",136601],["thread",134800],["thread",131040],["thread",130969],["thread",124323],["thread",133245],["thread",132116],["thread",134722],["thread",134759],["thread",133599],["thread",136255],["thread",132372],["thread",133158],["thread",129294],["thread",133010],["thread",136774],["thread",131758],["thread",136493],["thread",129528],["thread",133390],["thread",133659],["thread",132313],["thread",130397],["thread",136694],["thread",136627],["thread",113794],["thread",133853],["thread",135080],["thread",133480],["thread",131993],["thread",132316],["thread",111309],["thread",113276],["thread",135823],["thread",132315],["thread",134714],["thread",113793],["thread",133250],["thread",131007],["thread",129612],["thread",132626],["thread",136312],["thread",134026],["thread",134320],["thread",133307],["thread",130682],["thread",134191],["thread",133739],["thread",134741],["thread",134483],["thread",136822],["thread",136007],["thread",108903],["thread",135634],["thread",133369],["thread",132650],["thread",133877],["thread",135700],["thread",133339],["thread",110580],["thread",136228],["thread",133941],["thread",130722],["thread",135392],["thread",133770],["thread",118522],["thread",108890],["thread",131829],["thread",133810],["thread",136616],["thread",134581],["thread",124963],["thread",136147],["thread",135369],["thread",132881],["thread",130650],["thread",133163],["thread",133101],["thread",136016],["thread",127866],["thread",135452],["thread",135511],["thread",135262],["thread",136481],["thread",132647],["thread",131660],["thread",124226],["thread",136570],["thread",111525],["thread",133389],["thread",98993],["thread",130787],["thread",136404],["thread",108302],["thread",136188],["thread",132004],["thread",133920],["thread",133464],["thread",98935],["thread",129193],["thread",133785],["thread",135330],["thread",130059],["thread",129258],["thread",134570],["thread",133440],["thread",120191],["thread",136394],["thread",110848],["thread",136393],["thread",133280],["thread",87500],["thread",128582],["thread",132584],["thread",115903],["thread",133576],["thread",134184],["thread",136572],["thread",133510],["thread",133362],["thread",125830],["thread",136770],["thread",132087],["thread",136314],["thread",108463],["thread",135609],["thread",128999],["thread",132699],["thread",135361],["thread",113834],["thread",133963],["thread",39080],["thread",133918],["thread",134538],["thread",123970],["thread",120205],["thread",130295],["thread",135824],["thread",136399],["thread",133329],["thread",131451],["thread",134548],["thread",124052],["thread",133264],["thread",133692],["thread",135145],["thread",129415],["thread",134927],["thread",132288],["thread",78128],["thread",136551],["thread",134386],["thread",128669],["thread",133383],["thread",135581],["thread",135346],["thread",115646],["thread",133312],["thread",132317],["thread",121370],["thread",136020],["thread",136218],["thread",132569],["thread",80139],["thread",93345],["thread",111061],["thread",127625],["thread",134799],["thread",133495],["thread",132999],["thread",129293],["thread",133490],["thread",118865],["thread",116898],["thread",136115],["thread",110082],["thread",135202],["thread",133562],["thread",134254],["thread",133534],["thread",133458],["thread",135347],["thread",136100],["thread",126576],["thread",130181],["thread",135954],["thread",111906],["thread",136063],["thread",135477],["thread",136348],["thread",131079],["thread",135322],["thread",128926],["thread",122001],["thread",135302],["thread",132035],["thread",135986],["thread",131728]]
Run Time: 0.003031
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.000065
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |