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 (88361, 93937, 93361, 59651, 85603, 85605, 84631, 96330, 35578, 116325, 115554, 57602, 85570, 109167, 59315, 102136, 117155, 79546, 71782, 85642, 116328, 58187, 99382, 113838, 81888, 126532, 71729, 123734, 83428, 113242, 110679, 68208, 37834, 54086, 133066, 48393, 128408, 70771, 82225, 122864, 57311, 90730, 114565, 128332, 6498, 66558, 103616, 118494, 85683, 116329, 92818, 99233, 43865, 118474, 123002, 126444, 66398, 44584, 40446, 84598, 133678, 96465, 79363, 115030, 117437, 70953, 68822, 68543, 68289, 103405, 51607, 45942, 65617, 131715, 68321, 67770, 80191, 27691, 79888, 54712, 105770, 26704, 64437, 103813, 124645, 121708, 45508, 47659, 114075, 110388, 70969, 100458, 109254, 16315, 121421, 86443, 87866, 98906, 52714, 110839, 132906, 123706, 96284, 69915, 121151, 116634, 34364, 129027, 66749, 89941, 43808, 39184, 74870, 72234, 47507, 55871, 105310, 129897, 80265, 91448, 79127, 66121, 131392, 52419, 130731, 39886, 127843, 128482, 109214, 103867, 83611, 121729, 104659, 62764, 88955, 110895, 45094, 53531, 80400, 104098, 50491, 129643, 106890, 52086, 112114, 33707, 19469, 64682, 125885, 123876, 115988, 49025, 72363, 131672, 26830, 121014, 66222, 133233, 123867, 135741, 64880, 120412, 59560, 113612, 83835, 112785, 102717, 127498, 55215, 54547, 52545, 131154, 58218, 79341, 68647, 106257, 74708, 50058, 58925, 125532, 40909, 135399, 23073, 103659, 81360, 125398, 116787, 58118, 79712, 103736, 66805, 98345, 125192, 44486, 116330, 85754, 64271, 83871, 100448, 75052, 45983, 81797, 4599, 90734, 93433, 94663, 107886, 111259, 122421, 50312, 73457, 67920, 61542, 123095, 116656, 116385, 69292, 86579, 53346, 97644, 127709, 65163, 112415, 132559, 125137, 65872, 135966, 66265, 49304, 69499, 133625, 133536, 64845, 132456, 92119, 53555, 63098, 77494, 66118, 126675, 126009, 76308, 128503, 127593, 60423, 53957, 63912, 70971, 111144, 66554, 25776, 59034, 124477, 71719, 33949, 58837, 101711, 55604, 37130, 79329, 89800, 68373, 71838, 118490, 75779, 40910, 113529, 21161, 123877, 23346, 106414, 42338, 53832, 72817, 133013, 38305, 40410, 110429, 113205, 105540, 100445, 132139, 128401, 13003, 99339, 110956, 41693, 114620, 91475, 88064, 27550, 95299, 64747, 131883, 125076, 83425, 130365, 105135, 116850, 106959)
Run Time: 0.015454
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: 1369, 0, 1711666363, 1711669963, [["thread",88361],["thread",93937],["thread",93361],["thread",59651],["thread",85603],["thread",85605],["thread",84631],["thread",96330],["thread",35578],["thread",116325],["thread",115554],["thread",57602],["thread",85570],["thread",109167],["thread",59315],["thread",102136],["thread",117155],["thread",79546],["thread",71782],["thread",85642],["thread",116328],["thread",58187],["thread",99382],["thread",113838],["thread",81888],["thread",126532],["thread",71729],["thread",123734],["thread",83428],["thread",113242],["thread",110679],["thread",68208],["thread",37834],["thread",54086],["thread",133066],["thread",48393],["thread",128408],["thread",70771],["thread",82225],["thread",122864],["thread",57311],["thread",90730],["thread",114565],["thread",128332],["thread",6498],["thread",66558],["thread",103616],["thread",118494],["thread",85683],["thread",116329],["thread",92818],["thread",99233],["thread",43865],["thread",118474],["thread",123002],["thread",126444],["thread",66398],["thread",44584],["thread",40446],["thread",84598],["thread",133678],["thread",96465],["thread",79363],["thread",115030],["thread",117437],["thread",70953],["thread",68822],["thread",68543],["thread",68289],["thread",103405],["thread",51607],["thread",45942],["thread",65617],["thread",131715],["thread",68321],["thread",67770],["thread",80191],["thread",27691],["thread",79888],["thread",54712],["thread",105770],["thread",26704],["thread",64437],["thread",103813],["thread",124645],["thread",121708],["thread",45508],["thread",47659],["thread",114075],["thread",110388],["thread",70969],["thread",100458],["thread",109254],["thread",16315],["thread",121421],["thread",86443],["thread",87866],["thread",98906],["thread",52714],["thread",110839],["thread",132906],["thread",123706],["thread",96284],["thread",69915],["thread",121151],["thread",116634],["thread",34364],["thread",129027],["thread",66749],["thread",89941],["thread",43808],["thread",39184],["thread",74870],["thread",72234],["thread",47507],["thread",55871],["thread",105310],["thread",129897],["thread",80265],["thread",91448],["thread",79127],["thread",66121],["thread",131392],["thread",52419],["thread",130731],["thread",39886],["thread",127843],["thread",128482],["thread",109214],["thread",103867],["thread",83611],["thread",121729],["thread",104659],["thread",62764],["thread",88955],["thread",110895],["thread",45094],["thread",53531],["thread",80400],["thread",104098],["thread",50491],["thread",129643],["thread",106890],["thread",52086],["thread",112114],["thread",33707],["thread",19469],["thread",64682],["thread",125885],["thread",123876],["thread",115988],["thread",49025],["thread",72363],["thread",131672],["thread",26830],["thread",121014],["thread",66222],["thread",133233],["thread",123867],["thread",135741],["thread",64880],["thread",120412],["thread",59560],["thread",113612],["thread",83835],["thread",112785],["thread",102717],["thread",127498],["thread",55215],["thread",54547],["thread",52545],["thread",131154],["thread",58218],["thread",79341],["thread",68647],["thread",106257],["thread",74708],["thread",50058],["thread",58925],["thread",125532],["thread",40909],["thread",135399],["thread",23073],["thread",103659],["thread",81360],["thread",125398],["thread",116787],["thread",58118],["thread",79712],["thread",103736],["thread",66805],["thread",98345],["thread",125192],["thread",44486],["thread",116330],["thread",85754],["thread",64271],["thread",83871],["thread",100448],["thread",75052],["thread",45983],["thread",81797],["thread",4599],["thread",90734],["thread",93433],["thread",94663],["thread",107886],["thread",111259],["thread",122421],["thread",50312],["thread",73457],["thread",67920],["thread",61542],["thread",123095],["thread",116656],["thread",116385],["thread",69292],["thread",86579],["thread",53346],["thread",97644],["thread",127709],["thread",65163],["thread",112415],["thread",132559],["thread",125137],["thread",65872],["thread",135966],["thread",66265],["thread",49304],["thread",69499],["thread",133625],["thread",133536],["thread",64845],["thread",132456],["thread",92119],["thread",53555],["thread",63098],["thread",77494],["thread",66118],["thread",126675],["thread",126009],["thread",76308],["thread",128503],["thread",127593],["thread",60423],["thread",53957],["thread",63912],["thread",70971],["thread",111144],["thread",66554],["thread",25776],["thread",59034],["thread",124477],["thread",71719],["thread",33949],["thread",58837],["thread",101711],["thread",55604],["thread",37130],["thread",79329],["thread",89800],["thread",68373],["thread",71838],["thread",118490],["thread",75779],["thread",40910],["thread",113529],["thread",21161],["thread",123877],["thread",23346],["thread",106414],["thread",42338],["thread",53832],["thread",72817],["thread",133013],["thread",38305],["thread",40410],["thread",110429],["thread",113205],["thread",105540],["thread",100445],["thread",132139],["thread",128401],["thread",13003],["thread",99339],["thread",110956],["thread",41693],["thread",114620],["thread",91475],["thread",88064],["thread",27550],["thread",95299],["thread",64747],["thread",131883],["thread",125076],["thread",83425],["thread",130365],["thread",105135],["thread",116850],["thread",106959]]
Run Time: 0.015366
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 |