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 (470572, 470571, 470570, 470569, 470568, 470567, 470190, 470189, 470100, 470099, 470097, 470096, 470095, 470093, 470091, 470090, 470088, 470087, 470084, 470083, 470080, 470079, 470078, 470077, 470076, 470075, 470074, 470073, 470072, 470071, 470070, 470069, 470068, 470067, 470066, 470065, 470064, 470063, 470061, 470060, 470059, 470058, 470057, 470056, 470055, 470054, 470053, 470052, 470051, 470050, 470049, 470048, 470047, 470046, 470045, 470044, 470040, 470038, 470037, 470035, 386743, 386739, 386736, 386731, 386730, 386729, 386726, 386719, 386717, 386713, 386710, 386709, 386707, 386703, 386700, 386696, 386694, 386693, 386690, 386685, 386681, 386677, 386676, 386672, 386670, 386664, 386662, 386661, 386660, 386659, 386658, 386655, 386653, 386476, 386472, 386325, 386324, 386320, 386319, 386318, 386317, 386316, 386289, 386274, 386265, 386259, 386255, 386248, 386243, 386239, 386235, 386232, 386227, 386223, 386221, 386220, 386214, 385842, 385836, 385832, 385829, 385823, 385819, 385814, 385797, 385784, 385764, 385763, 385762, 385761, 385751, 385746, 385743, 385737, 384917, 384916, 384913, 384912, 384911, 384910, 384909, 384908, 384906, 384904, 384903, 384902, 384900, 384899, 384839, 384838, 384837, 384836, 384833, 384832, 384831, 384830, 384829, 384828, 384826, 384823, 384822, 384821, 384820, 384819, 384818, 384817, 384816, 384815, 384814, 384813, 384812, 384811, 384810, 384809, 384808, 384807, 384719, 384717, 384716, 384715, 384714, 384713, 384712, 384711, 384084, 384082, 384070, 384069, 384065, 384063, 384061, 384060, 384054, 384050, 383984, 383983, 383982, 383981, 383980, 383979)
Run Time: 0.056940
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | hunsa.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | hunsa.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | hunsa.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,hunsa.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: 33413, 0, 1660269524, 1660273124, {"2":["thread",470570],"5":["thread",470567],"6":["thread",470190],"7":["thread",470189],"8":["thread",470100],"9":["thread",470099],"10":["thread",470097],"11":["thread",470096],"12":["thread",470095],"13":["thread",470093],"14":["thread",470091],"15":["thread",470090],"16":["thread",470088],"17":["thread",470087],"18":["thread",470084],"19":["thread",470083],"20":["thread",470080],"21":["thread",470079],"22":["thread",470078],"23":["thread",470077],"24":["thread",470076],"25":["thread",470075],"26":["thread",470074],"27":["thread",470073],"28":["thread",470072],"29":["thread",470071],"30":["thread",470070],"31":["thread",470069],"32":["thread",470068],"33":["thread",470067],"34":["thread",470066],"35":["thread",470065],"36":["thread",470064],"37":["thread",470063],"38":["thread",470061],"39":["thread",470060],"40":["thread",470059],"41":["thread",470058],"42":["thread",470057],"43":["thread",470056],"44":["thread",470055],"45":["thread",470054],"46":["thread",470053],"47":["thread",470052],"48":["thread",470051],"49":["thread",470050],"50":["thread",470049],"51":["thread",470048],"52":["thread",470047],"53":["thread",470046],"54":["thread",470045],"55":["thread",470044],"56":["thread",470040],"57":["thread",470038],"58":["thread",470037],"59":["thread",470035],"60":["thread",386743],"62":["thread",386736],"64":["thread",386730],"66":["thread",386726],"68":["thread",386717],"70":["thread",386710],"72":["thread",386707],"74":["thread",386700],"76":["thread",386694],"78":["thread",386690],"80":["thread",386681],"82":["thread",386676],"84":["thread",386670],"86":["thread",386662],"88":["thread",386660],"90":["thread",386658],"92":["thread",386653],"93":["thread",386476],"94":["thread",386472],"95":["thread",386325],"96":["thread",386324],"97":["thread",386320],"98":["thread",386319],"99":["thread",386318],"100":["thread",386317],"101":["thread",386316],"102":["thread",386289],"103":["thread",386274],"104":["thread",386265],"105":["thread",386259],"106":["thread",386255],"107":["thread",386248],"108":["thread",386243],"109":["thread",386239],"110":["thread",386235],"111":["thread",386232],"112":["thread",386227],"113":["thread",386223],"114":["thread",386221],"115":["thread",386220],"116":["thread",386214],"117":["thread",385842],"118":["thread",385836],"119":["thread",385832],"120":["thread",385829],"121":["thread",385823],"122":["thread",385819],"123":["thread",385814],"124":["thread",385797],"125":["thread",385784],"126":["thread",385764],"127":["thread",385763],"128":["thread",385762],"129":["thread",385761],"130":["thread",385751],"131":["thread",385746],"132":["thread",385743],"133":["thread",385737],"134":["thread",384917],"135":["thread",384916],"136":["thread",384913],"137":["thread",384912],"138":["thread",384911],"139":["thread",384910],"140":["thread",384909],"141":["thread",384908],"142":["thread",384906],"143":["thread",384904],"144":["thread",384903],"145":["thread",384902],"146":["thread",384900],"147":["thread",384899],"149":["thread",384838],"151":["thread",384836],"153":["thread",384832],"155":["thread",384830],"157":["thread",384828],"159":["thread",384823],"161":["thread",384821],"163":["thread",384819],"165":["thread",384817],"167":["thread",384815],"169":["thread",384813],"171":["thread",384811],"173":["thread",384809],"175":["thread",384807],"177":["thread",384717],"179":["thread",384715],"180":["thread",384714],"183":["thread",384711],"185":["thread",384082],"187":["thread",384069],"189":["thread",384063],"191":["thread",384060],"193":["thread",384050],"196":["thread",383982],"199":["thread",383979]}
Run Time: 0.001336