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 (2025783, 2025782, 2025395, 2025093, 2024447, 2023910, 2023723, 2023717, 2023715, 2023457, 2023275, 2023193, 2023142, 2022897, 2022724, 2022723, 2022722, 2022721, 2022527, 2022497, 2022479, 2022474, 2022371, 2022342, 2022184, 2022134, 2021959, 2021920, 2021916, 2021767, 2021673, 2021651, 2021640, 2021639, 2021544, 2021537, 2021534, 2021533, 2021502, 2021501, 2021333, 2021332, 2021331, 2021168, 2020493, 2020467, 2020010, 2019941, 2019892, 2019865, 2019832, 2019831, 2019780, 2019777, 2019607, 2019591, 2019552, 2019472, 2019153, 2018918, 2018568, 2018380, 2018362, 2017701, 2017496, 2016906, 2016714, 2016699, 2016318, 2016016, 2016011, 2016010, 2016009, 2016008, 2015966, 2015915, 2015843, 2015842, 2015798, 2015660, 2015651, 2015639, 2015608, 2015584, 2015552, 2015548, 2015547, 2015546, 2015537, 2015496, 2015495, 2015470, 2015469, 2015435, 2015424, 2015404, 2015371, 2015354, 2015338, 2015333, 2015321, 2015280, 2015168, 2015115, 2015113, 2015102, 2015019, 2014987, 2014874, 2014835, 2014834, 2014794, 2014793, 2014732, 2014731, 2014730, 2014729, 2014723, 2014676, 2014320, 2014319, 2014318, 2014316, 2014315, 2014313, 2014312, 2014311, 2014244, 2014236, 2014221, 2014215, 2014211, 2014187, 2014159, 2014136, 2014132, 2014119, 2014110, 2014099, 2014098, 2014089, 2014086, 2014080, 2014075, 2014070, 2014062, 2014035, 2014019, 2013982, 2013916, 2013896, 2013854, 2013839, 2013823, 2013799, 2013793, 2013792, 2013755, 2013739, 2013673, 2013668, 2013648, 2013635, 2013610, 2013580, 2013546, 2013530, 2013502, 2013498, 2013492, 2013469, 2013409, 2013372, 2013370, 2013361, 2013320, 2013301, 2013298, 2013241, 2013235, 2013232, 2013229, 2013184, 2013168, 2013140, 2013115, 2013040, 2013033, 2013027, 2012823, 2012822, 2012792, 2012788, 2012770, 2012752, 2012723, 2012720, 2012615)
Run Time: 0.049908
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 198 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dirty.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: 25, 0, 1714110545, 1714114145, {"0":["thread",2025783],"1":["thread",2025782],"2":["thread",2025395],"3":["thread",2025093],"4":["thread",2024447],"5":["thread",2023910],"6":["thread",2023723],"7":["thread",2023717],"8":["thread",2023715],"9":["thread",2023457],"10":["thread",2023275],"11":["thread",2023193],"12":["thread",2023142],"13":["thread",2022897],"14":["thread",2022724],"15":["thread",2022723],"16":["thread",2022722],"17":["thread",2022721],"18":["thread",2022527],"19":["thread",2022497],"20":["thread",2022479],"21":["thread",2022474],"22":["thread",2022371],"23":["thread",2022342],"24":["thread",2022184],"25":["thread",2022134],"26":["thread",2021959],"27":["thread",2021920],"28":["thread",2021916],"29":["thread",2021767],"30":["thread",2021673],"31":["thread",2021651],"32":["thread",2021640],"33":["thread",2021639],"34":["thread",2021544],"35":["thread",2021537],"36":["thread",2021534],"37":["thread",2021533],"38":["thread",2021502],"39":["thread",2021501],"40":["thread",2021333],"41":["thread",2021332],"42":["thread",2021331],"43":["thread",2021168],"44":["thread",2020493],"45":["thread",2020467],"46":["thread",2020010],"47":["thread",2019941],"48":["thread",2019892],"49":["thread",2019865],"50":["thread",2019832],"51":["thread",2019831],"52":["thread",2019780],"53":["thread",2019777],"54":["thread",2019607],"55":["thread",2019591],"56":["thread",2019552],"57":["thread",2019472],"58":["thread",2019153],"59":["thread",2018918],"60":["thread",2018568],"61":["thread",2018380],"62":["thread",2018362],"63":["thread",2017701],"64":["thread",2017496],"65":["thread",2016906],"66":["thread",2016714],"67":["thread",2016699],"68":["thread",2016318],"69":["thread",2016016],"70":["thread",2016011],"71":["thread",2016010],"72":["thread",2016009],"73":["thread",2016008],"74":["thread",2015966],"75":["thread",2015915],"76":["thread",2015843],"77":["thread",2015842],"78":["thread",2015798],"79":["thread",2015660],"80":["thread",2015651],"81":["thread",2015639],"82":["thread",2015608],"83":["thread",2015584],"84":["thread",2015552],"85":["thread",2015548],"86":["thread",2015547],"87":["thread",2015546],"88":["thread",2015537],"89":["thread",2015496],"90":["thread",2015495],"91":["thread",2015470],"92":["thread",2015469],"93":["thread",2015435],"94":["thread",2015424],"95":["thread",2015404],"96":["thread",2015371],"97":["thread",2015354],"98":["thread",2015338],"100":["thread",2015333],"101":["thread",2015321],"102":["thread",2015280],"103":["thread",2015168],"104":["thread",2015115],"105":["thread",2015113],"106":["thread",2015102],"107":["thread",2015019],"108":["thread",2014987],"109":["thread",2014874],"110":["thread",2014835],"111":["thread",2014834],"112":["thread",2014794],"113":["thread",2014793],"114":["thread",2014732],"115":["thread",2014731],"116":["thread",2014730],"117":["thread",2014729],"118":["thread",2014723],"119":["thread",2014676],"120":["thread",2014320],"121":["thread",2014319],"122":["thread",2014318],"123":["thread",2014316],"124":["thread",2014315],"125":["thread",2014313],"126":["thread",2014312],"127":["thread",2014311],"128":["thread",2014244],"129":["thread",2014236],"130":["thread",2014221],"131":["thread",2014215],"132":["thread",2014211],"133":["thread",2014187],"134":["thread",2014159],"135":["thread",2014136],"136":["thread",2014132],"137":["thread",2014119],"138":["thread",2014110],"139":["thread",2014099],"140":["thread",2014098],"141":["thread",2014089],"142":["thread",2014086],"143":["thread",2014080],"144":["thread",2014075],"145":["thread",2014070],"146":["thread",2014062],"147":["thread",2014035],"148":["thread",2014019],"149":["thread",2013982],"150":["thread",2013916],"151":["thread",2013896],"152":["thread",2013854],"153":["thread",2013839],"154":["thread",2013823],"155":["thread",2013799],"156":["thread",2013793],"157":["thread",2013792],"158":["thread",2013755],"159":["thread",2013739],"160":["thread",2013673],"161":["thread",2013668],"162":["thread",2013648],"163":["thread",2013635],"164":["thread",2013610],"165":["thread",2013580],"166":["thread",2013546],"167":["thread",2013530],"168":["thread",2013502],"169":["thread",2013498],"170":["thread",2013492],"171":["thread",2013469],"172":["thread",2013409],"173":["thread",2013372],"174":["thread",2013370],"175":["thread",2013361],"176":["thread",2013320],"177":["thread",2013301],"178":["xengallery_media",1068],"179":["thread",2013298],"180":["thread",2013241],"181":["thread",2013235],"182":["thread",2013232],"183":["thread",2013229],"184":["thread",2013184],"185":["thread",2013168],"186":["thread",2013140],"187":["thread",2013115],"188":["thread",2013040],"189":["thread",2013033],"190":["thread",2013027],"191":["thread",2012823],"192":["thread",2012822],"193":["thread",2012792],"194":["thread",2012788],"195":["thread",2012770],"196":["thread",2012752],"197":["thread",2012723],"198":["thread",2012720],"199":["thread",2012615]}
Run Time: 0.003615