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 (119292, 73805, 70732, 102192, 129501, 104799, 33960, 36272, 35340, 92769, 15696, 59881, 95137, 77196, 97569, 70425, 55844, 115871, 129694, 52566, 69301, 88823, 50102, 80511, 79247, 128102, 108432, 101929, 5669, 123667, 2639, 75632, 83087, 91514, 45855, 102943, 49919, 122347, 113786, 93875, 51454, 3101, 88493, 62397, 33553, 59894, 82606, 94496, 37243, 22072, 52065, 76680, 85890, 78372, 90412, 99266, 95505, 98749, 1717, 76239, 82611, 77222, 73028, 99174, 92928, 42757, 8508, 83119, 88464, 114520, 54030, 5540, 69050, 46235, 77703, 73734, 93414, 60427, 118435, 64007, 37398, 126569, 111421, 33823, 46257, 129854, 98083, 88095, 70730, 87870, 117896, 67846, 75766, 49859, 93741, 91357, 124354, 58790, 84824, 99332, 53230, 70825, 97518, 22626, 49866, 133297, 50684, 87912, 43965, 85755, 65555, 101820, 86944, 28221, 53085, 112329, 92331, 106216, 81898, 92461, 82030, 75182, 77487, 89649, 75116, 75392, 76601, 49893, 80301, 114172, 118376, 106519, 104929, 109415, 90383, 62007, 125773, 116111, 112745, 34053, 370, 37618, 95207, 40153, 118424, 52739, 60977, 103532, 45613, 96484, 118375, 95629, 2864, 23596, 79365, 96115, 101587, 78540, 71700, 80553, 101715, 104243, 53530, 93592, 82721, 87137, 21170, 49914, 127604, 122500, 9947, 134683, 112048, 93418, 69950, 75973, 60431, 93503, 82966, 110021, 92053, 34726, 61327, 72880, 107000, 83363, 46544, 112161, 97740, 116941, 21383, 7795, 104952, 106157, 69365, 43401, 2612, 50159, 96801, 86197, 85819, 113000, 52597, 113213, 118174, 60203, 98452, 126686, 111408, 33835, 74073, 117796, 45741, 89556, 111629, 75190, 95635, 94302, 73031, 84586, 75512, 83530, 99866, 106437, 82974, 119036, 85443, 52015, 37418, 119293, 87944, 77604, 85685, 56666, 94947, 73030, 114436, 74075, 81936, 112360, 33834, 125043, 55455, 86824, 115322, 117303, 7146, 78552, 112361, 112556, 121455, 56427, 107295, 49912, 69199, 66993, 104774, 77104, 82470, 70015, 92642, 38085, 2832, 75408, 77282, 5217, 100246, 99670, 65758, 32559, 49468, 108852, 33934, 92978, 48655, 69218, 67769, 52449, 76078, 99490, 123321, 81791, 68879, 7406, 16785, 67324, 76756, 75582, 101164, 34058, 117797, 77359, 3508, 103383, 65810, 65526, 110519, 119512, 104779, 33236)
Run Time: 0.043305
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: 612, 0, 1711629939, 1711633539, [["thread",119292],["thread",73805],["thread",70732],["thread",102192],["thread",129501],["thread",104799],["thread",33960],["thread",36272],["thread",35340],["thread",92769],["thread",15696],["thread",59881],["thread",95137],["thread",77196],["thread",97569],["thread",70425],["thread",55844],["thread",115871],["thread",129694],["thread",52566],["thread",69301],["thread",88823],["thread",50102],["thread",80511],["thread",79247],["thread",128102],["thread",108432],["thread",101929],["thread",5669],["thread",123667],["thread",2639],["thread",75632],["thread",83087],["thread",91514],["thread",45855],["thread",102943],["thread",49919],["thread",122347],["thread",113786],["thread",93875],["thread",51454],["thread",3101],["thread",88493],["thread",62397],["thread",33553],["thread",59894],["thread",82606],["thread",94496],["thread",37243],["thread",22072],["thread",52065],["thread",76680],["thread",85890],["thread",78372],["thread",90412],["thread",99266],["thread",95505],["thread",98749],["thread",1717],["thread",76239],["thread",82611],["thread",77222],["thread",73028],["thread",99174],["thread",92928],["thread",42757],["thread",8508],["thread",83119],["thread",88464],["thread",114520],["thread",54030],["thread",5540],["thread",69050],["thread",46235],["thread",77703],["thread",73734],["thread",93414],["thread",60427],["thread",118435],["thread",64007],["thread",37398],["thread",126569],["thread",111421],["thread",33823],["thread",46257],["thread",129854],["thread",98083],["thread",88095],["thread",70730],["thread",87870],["thread",117896],["thread",67846],["thread",75766],["thread",49859],["thread",93741],["thread",91357],["thread",124354],["thread",58790],["thread",84824],["thread",99332],["thread",53230],["thread",70825],["thread",97518],["thread",22626],["thread",49866],["thread",133297],["thread",50684],["thread",87912],["thread",43965],["thread",85755],["thread",65555],["thread",101820],["thread",86944],["thread",28221],["thread",53085],["thread",112329],["thread",92331],["thread",106216],["thread",81898],["thread",92461],["thread",82030],["thread",75182],["thread",77487],["thread",89649],["thread",75116],["thread",75392],["thread",76601],["thread",49893],["thread",80301],["thread",114172],["thread",118376],["thread",106519],["thread",104929],["thread",109415],["thread",90383],["thread",62007],["thread",125773],["thread",116111],["thread",112745],["thread",34053],["thread",370],["thread",37618],["thread",95207],["thread",40153],["thread",118424],["thread",52739],["thread",60977],["thread",103532],["thread",45613],["thread",96484],["thread",118375],["thread",95629],["thread",2864],["thread",23596],["thread",79365],["thread",96115],["thread",101587],["thread",78540],["thread",71700],["thread",80553],["thread",101715],["thread",104243],["thread",53530],["thread",93592],["thread",82721],["thread",87137],["thread",21170],["thread",49914],["thread",127604],["thread",122500],["thread",9947],["thread",134683],["thread",112048],["thread",93418],["thread",69950],["thread",75973],["thread",60431],["thread",93503],["thread",82966],["thread",110021],["thread",92053],["thread",34726],["thread",61327],["thread",72880],["thread",107000],["thread",83363],["thread",46544],["thread",112161],["thread",97740],["thread",116941],["thread",21383],["thread",7795],["thread",104952],["thread",106157],["thread",69365],["thread",43401],["thread",2612],["thread",50159],["thread",96801],["thread",86197],["thread",85819],["thread",113000],["thread",52597],["thread",113213],["thread",118174],["thread",60203],["thread",98452],["thread",126686],["thread",111408],["thread",33835],["thread",74073],["thread",117796],["thread",45741],["thread",89556],["thread",111629],["thread",75190],["thread",95635],["thread",94302],["thread",73031],["thread",84586],["thread",75512],["thread",83530],["thread",99866],["thread",106437],["thread",82974],["thread",119036],["thread",85443],["thread",52015],["thread",37418],["thread",119293],["thread",87944],["thread",77604],["thread",85685],["thread",56666],["thread",94947],["thread",73030],["thread",114436],["thread",74075],["thread",81936],["thread",112360],["thread",33834],["thread",125043],["thread",55455],["thread",86824],["thread",115322],["thread",117303],["thread",7146],["thread",78552],["thread",112361],["thread",112556],["thread",121455],["thread",56427],["thread",107295],["thread",49912],["thread",69199],["thread",66993],["thread",104774],["thread",77104],["thread",82470],["thread",70015],["thread",92642],["thread",38085],["thread",2832],["thread",75408],["thread",77282],["thread",5217],["thread",100246],["thread",99670],["thread",65758],["thread",32559],["thread",49468],["thread",108852],["thread",33934],["thread",92978],["thread",48655],["thread",69218],["thread",67769],["thread",52449],["thread",76078],["thread",99490],["thread",123321],["thread",81791],["thread",68879],["thread",7406],["thread",16785],["thread",67324],["thread",76756],["thread",75582],["thread",101164],["thread",34058],["thread",117797],["thread",77359],["thread",3508],["thread",103383],["thread",65810],["thread",65526],["thread",110519],["thread",119512],["thread",104779],["thread",33236]]
Run Time: 0.006392
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.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |