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 (85455, 2521, 77012, 2666, 88517, 95466, 77147, 122839, 81314, 57746, 124680, 96339, 1785, 129565, 2775, 1755, 1747, 30109, 15930, 95152, 98956, 99478, 72099, 29194, 111613, 22682, 28233, 1782, 55127, 23508, 135817, 45791, 65250, 2070, 956, 4159, 107571, 1917, 52446, 24733, 84935, 39017, 104040, 96649, 105735, 120668, 1510, 76015, 34213, 60239, 1906, 2498, 19650, 128212, 62674, 76775, 1203, 115864, 1962, 107675, 84478, 1698, 125157, 75548, 32308, 55527, 38499, 2089, 59594, 37417, 1774, 27895, 17695, 96532, 2883, 28469, 955, 7517, 21983, 20777, 127154, 3063, 27861, 126773, 54999, 128075, 86103, 1676, 24942, 75477, 78588, 1756, 117729, 24648, 45684, 8766, 84336, 76346, 1120, 115187, 98967, 45652, 43668, 45759, 96447, 1832, 94527, 39908, 85389, 82655, 42766, 120572, 77253, 64339, 3251, 1827, 94023, 53523, 106492, 93847, 76160, 20146, 67714, 2013, 54488, 10793, 84077, 96296, 125596, 16165, 45651, 34018, 1942, 2536, 7334, 108753, 2092, 78812, 2509, 38519, 1614, 2503, 96424, 75526, 900, 128370, 1952, 127203, 119380, 45689, 72916, 77562, 108287, 21058, 17173, 79977, 86728, 39176, 81488, 2513, 13325, 11293, 71393, 25052, 97645, 2684, 2093, 14542, 18822, 1602, 72114, 29515, 24446, 60558, 1931, 30091, 14401, 82844, 1768, 78348, 57822, 1153, 2140, 54166, 91238, 34448, 1968, 68513, 126635, 112261, 128087, 83581, 1422, 115529, 21998, 69250, 115480, 111725, 115485, 81647, 1787, 7330, 1945, 1807, 2497, 18634, 96374, 1946, 57508, 51178, 37536, 113015, 87060, 1790, 55143, 1681, 85130, 727, 129238, 102589, 37657, 72170, 127310, 1149, 29536, 25297, 1847, 113643, 54468, 131842, 1529, 72677, 1936, 128583, 126450, 1926, 1518, 1534, 62968, 1512, 1419, 128761, 20579, 84486, 19165, 25314, 1675, 108429, 116937, 78112, 80269, 84775, 110663, 2725, 2506, 116172, 1846, 89686, 117747, 11177, 38707, 18048, 49438, 56045, 1944, 87452, 52084, 73427, 86894, 1819, 1744, 21954, 28095, 54561, 50513, 78454, 23461, 39816, 8670, 56885, 95096, 25189, 2713, 112310, 101651, 83093, 109158, 1922, 68940, 133649, 8625, 6897, 121143, 50465, 59927, 37979, 72956, 1822, 56934, 126923)
Run Time: 0.011632
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: 142, 0, 1714019524, 1714023124, {"0":["thread",85455],"1":["thread",2521],"2":["thread",77012],"3":["thread",2666],"4":["thread",88517],"5":["thread",95466],"6":["thread",77147],"7":["thread",122839],"8":["thread",81314],"9":["thread",57746],"10":["thread",124680],"11":["thread",96339],"12":["thread",1785],"13":["thread",129565],"14":["thread",2775],"15":["thread",1755],"16":["thread",1747],"17":["thread",30109],"18":["thread",15930],"19":["thread",95152],"20":["thread",98956],"21":["thread",99478],"22":["thread",72099],"23":["thread",29194],"24":["thread",111613],"25":["thread",22682],"26":["thread",28233],"27":["thread",1782],"28":["thread",55127],"29":["thread",23508],"30":["thread",135817],"31":["thread",45791],"32":["thread",65250],"33":["thread",2070],"34":["thread",956],"35":["thread",4159],"36":["thread",107571],"37":["thread",1917],"38":["thread",52446],"39":["thread",24733],"40":["thread",84935],"41":["thread",39017],"42":["thread",104040],"43":["thread",96649],"44":["thread",105735],"45":["thread",120668],"46":["thread",1510],"47":["thread",76015],"48":["thread",34213],"49":["thread",60239],"50":["thread",1906],"51":["thread",2498],"52":["thread",19650],"53":["thread",128212],"54":["thread",62674],"55":["thread",76775],"56":["thread",1203],"57":["thread",115864],"58":["thread",1962],"59":["thread",107675],"60":["thread",84478],"61":["thread",1698],"62":["thread",125157],"63":["thread",75548],"64":["thread",32308],"65":["thread",55527],"66":["thread",38499],"67":["thread",2089],"68":["thread",59594],"69":["thread",37417],"70":["thread",1774],"71":["thread",27895],"72":["thread",17695],"73":["thread",96532],"74":["thread",2883],"75":["thread",28469],"76":["thread",955],"77":["thread",7517],"78":["thread",21983],"79":["thread",20777],"80":["thread",127154],"81":["thread",3063],"82":["thread",27861],"83":["thread",126773],"84":["thread",54999],"85":["thread",128075],"86":["thread",86103],"87":["thread",1676],"88":["thread",24942],"89":["thread",75477],"90":["thread",78588],"91":["thread",1756],"92":["thread",117729],"93":["thread",24648],"94":["thread",45684],"95":["thread",8766],"96":["thread",84336],"97":["thread",76346],"98":["thread",1120],"99":["thread",115187],"100":["thread",98967],"101":["thread",45652],"102":["thread",43668],"103":["thread",45759],"104":["thread",96447],"105":["thread",1832],"106":["thread",94527],"107":["thread",39908],"108":["thread",85389],"109":["thread",82655],"110":["thread",42766],"111":["thread",120572],"112":["thread",77253],"113":["thread",64339],"114":["thread",3251],"115":["thread",1827],"116":["thread",94023],"117":["thread",53523],"118":["thread",106492],"119":["thread",93847],"120":["thread",76160],"121":["thread",20146],"122":["thread",67714],"123":["thread",2013],"124":["thread",54488],"125":["thread",10793],"126":["thread",84077],"127":["thread",96296],"128":["thread",125596],"129":["thread",16165],"130":["thread",45651],"131":["thread",34018],"132":["thread",1942],"133":["thread",2536],"134":["thread",7334],"135":["thread",108753],"136":["thread",2092],"137":["thread",78812],"138":["thread",2509],"139":["thread",38519],"140":["thread",1614],"141":["thread",2503],"142":["thread",96424],"143":["thread",75526],"144":["thread",900],"145":["thread",128370],"146":["thread",1952],"147":["thread",127203],"148":["thread",119380],"149":["thread",45689],"150":["thread",72916],"151":["thread",77562],"152":["thread",108287],"153":["thread",21058],"154":["thread",17173],"155":["thread",79977],"156":["thread",86728],"157":["thread",39176],"158":["thread",81488],"159":["thread",2513],"160":["thread",13325],"161":["thread",11293],"162":["thread",71393],"163":["thread",25052],"164":["thread",97645],"165":["thread",2684],"166":["thread",2093],"167":["thread",14542],"168":["thread",18822],"169":["thread",1602],"170":["thread",72114],"171":["thread",29515],"172":["thread",24446],"173":["thread",60558],"174":["thread",1931],"175":["thread",30091],"176":["thread",14401],"177":["thread",82844],"178":["thread",1768],"179":["thread",78348],"180":["thread",57822],"181":["thread",1153],"182":["thread",2140],"183":["thread",54166],"184":["thread",91238],"185":["thread",34448],"186":["thread",1968],"187":["thread",68513],"188":["thread",126635],"189":["thread",112261],"190":["thread",128087],"191":["thread",83581],"192":["thread",1422],"193":["thread",115529],"194":["thread",21998],"195":["thread",69250],"196":["thread",115480],"197":["thread",111725],"198":["thread",115485],"199":["thread",81647],"200":["thread",1787],"201":["thread",7330],"202":["thread",1945],"203":["thread",1807],"204":["thread",2497],"205":["thread",18634],"206":["thread",96374],"207":["thread",1946],"208":["thread",57508],"209":["thread",51178],"210":["thread",37536],"211":["thread",113015],"212":["thread",87060],"213":["thread",1790],"214":["thread",55143],"215":["thread",1681],"216":["thread",85130],"217":["thread",727],"218":["thread",129238],"219":["thread",102589],"220":["thread",37657],"221":["thread",72170],"222":["thread",127310],"223":["thread",1149],"224":["thread",29536],"225":["thread",25297],"226":["thread",1847],"227":["thread",113643],"228":["thread",54468],"229":["thread",131842],"230":["thread",1529],"231":["thread",72677],"232":["thread",1936],"233":["thread",128583],"234":["thread",126450],"235":["thread",1926],"236":["thread",1518],"238":["thread",62968],"239":["thread",1512],"240":["thread",1419],"241":["thread",128761],"242":["thread",20579],"243":["thread",84486],"244":["thread",19165],"245":["thread",25314],"246":["thread",1675],"247":["thread",108429],"248":["thread",116937],"249":["thread",78112],"250":["thread",80269],"251":["thread",84775],"252":["thread",110663],"253":["thread",2725],"254":["thread",2506],"255":["thread",116172],"256":["thread",1846],"257":["thread",89686],"258":["thread",117747],"259":["thread",11177],"260":["thread",38707],"261":["thread",18048],"262":["thread",49438],"263":["thread",56045],"264":["thread",1944],"265":["thread",87452],"266":["thread",52084],"267":["thread",73427],"268":["thread",86894],"269":["thread",1819],"270":["thread",1744],"271":["thread",21954],"272":["thread",28095],"273":["thread",54561],"274":["thread",50513],"275":["thread",78454],"276":["thread",23461],"277":["thread",39816],"278":["thread",8670],"279":["thread",56885],"280":["thread",95096],"281":["thread",25189],"282":["thread",2713],"283":["thread",112310],"284":["thread",101651],"285":["thread",83093],"286":["thread",109158],"287":["thread",1922],"288":["thread",68940],"289":["thread",133649],"290":["thread",8625],"291":["thread",6897],"292":["thread",121143],"293":["thread",50465],"294":["thread",59927],"295":["thread",37979],"296":["thread",72956],"297":["thread",1822],"298":["thread",56934],"299":["thread",126923]}
Run Time: 0.002943
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.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 150 | Using where |