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,
pr_cache.rating_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)
left join dark_postrating_post_cache pr_cache ON (thread.first_post_id = pr_cache.post_id)
WHERE thread.thread_id IN (21907, 21806, 21744, 21640, 21576, 21550, 21454, 21287, 21256, 21246, 21234, 21230, 21165, 21124, 20972, 20755, 20746, 20697, 20677, 20668, 20631, 20564, 20567, 20549, 20539, 20493, 20492, 20448, 20412, 20350, 20327, 20292, 20169, 20161, 20132, 20089, 20037, 19762, 19660, 19630, 19563, 19504, 19461, 19431, 19323, 19191, 19128, 19118, 19095, 19092, 19081, 19074, 19059, 19049, 19011, 18969, 18887, 18856, 18713, 18685, 18679, 18674, 18670, 18566, 18558, 18528, 18452, 18431, 18386, 18367, 18360, 18325, 18322, 18231, 18184, 18199, 18041, 18044, 18014, 17945, 17912, 17801, 17771, 17770, 17764, 17752, 17714, 17605, 17545, 17373, 17299, 17289, 17156, 17118, 17109, 17106, 17079, 17078, 17053, 16962, 16961, 16884, 16841, 16739, 16733, 16704, 16666, 16570, 16504, 16497, 16386, 16317, 16232, 16185, 16133, 16067, 15995, 15987, 15974, 15950, 15906, 15892, 15812, 15811, 15789, 15756, 15705, 15677, 13136, 15669, 15663, 15652, 15640, 15621, 15608, 15591, 15583, 15411, 15408, 15339, 15329, 15279, 15155, 15103, 14746, 14744, 13032, 14544, 14351, 14277, 14213, 14083, 14000, 13883, 13881, 13875, 13776, 13854, 13833, 13827, 13655, 13593, 13590, 12804, 13545, 13495, 13470, 12305, 13423, 13347)
Run Time: 0.004022
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 170 | Using index condition |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | rassvet.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | rassvet.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | rassvet.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,rassvet.thread.node_id | 1 | Using where |
SIMPLE | pr_cache | eq_ref | PRIMARY | PRIMARY | 4 | rassvet.thread.first_post_id | 1 | |
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: 209, 0, 1713484158, 1713487758, {"0":["thread",21907],"1":["thread",21806],"2":["thread",21744],"3":["thread",21640],"4":["thread",21576],"5":["thread",21550],"6":["thread",21454],"7":["thread",21287],"8":["thread",21256],"9":["thread",21246],"10":["thread",21234],"11":["thread",21230],"12":["thread",21165],"13":["thread",21124],"14":["thread",20972],"15":["thread",20755],"16":["thread",20746],"17":["thread",20697],"18":["thread",20677],"19":["thread",20668],"20":["thread",20631],"21":["thread",20564],"22":["thread",20567],"23":["thread",20549],"24":["thread",20539],"25":["thread",20493],"26":["thread",20492],"27":["thread",20448],"28":["thread",20412],"29":["thread",20350],"30":["thread",20327],"31":["thread",20292],"32":["thread",20169],"33":["thread",20161],"34":["thread",20132],"35":["thread",20089],"36":["thread",20037],"37":["thread",19762],"38":["thread",19660],"39":["thread",19630],"40":["thread",19563],"41":["thread",19504],"42":["thread",19461],"43":["thread",19431],"44":["thread",19323],"45":["thread",19191],"46":["thread",19128],"47":["thread",19118],"48":["thread",19095],"49":["thread",19092],"50":["thread",19081],"51":["thread",19074],"52":["thread",19059],"53":["thread",19049],"54":["thread",19011],"55":["thread",18969],"56":["thread",18887],"57":["thread",18856],"58":["thread",18713],"59":["thread",18685],"60":["thread",18679],"61":["thread",18674],"62":["thread",18670],"63":["thread",18566],"64":["thread",18558],"65":["thread",18528],"66":["thread",18452],"67":["thread",18431],"68":["thread",18386],"69":["thread",18367],"70":["thread",18360],"71":["thread",18325],"72":["thread",18322],"73":["thread",18231],"74":["thread",18184],"75":["thread",18199],"76":["thread",18041],"77":["thread",18044],"78":["thread",18014],"79":["thread",17945],"80":["thread",17912],"81":["thread",17801],"82":["thread",17771],"83":["thread",17770],"84":["thread",17764],"85":["thread",17752],"86":["thread",17714],"87":["thread",17605],"88":["thread",17545],"89":["thread",17373],"90":["thread",17299],"91":["thread",17289],"92":["thread",17156],"93":["thread",17118],"94":["thread",17109],"95":["thread",17106],"96":["thread",17079],"97":["thread",17078],"98":["thread",17053],"99":["thread",16962],"100":["thread",16961],"101":["thread",16884],"102":["thread",16841],"103":["thread",16739],"104":["thread",16733],"105":["thread",16704],"106":["thread",16666],"107":["thread",16570],"108":["thread",16504],"109":["thread",16497],"111":["thread",16317],"112":["thread",16232],"113":["thread",16185],"114":["thread",16133],"115":["thread",16067],"116":["thread",15995],"117":["thread",15987],"118":["thread",15974],"119":["thread",15950],"120":["thread",15906],"121":["thread",15892],"122":["thread",15812],"123":["thread",15811],"124":["thread",15789],"125":["thread",15756],"126":["thread",15705],"127":["thread",15677],"128":["thread",13136],"129":["thread",15669],"131":["thread",15652],"132":["thread",15640],"133":["thread",15621],"134":["thread",15608],"135":["thread",15591],"136":["thread",15583],"137":["thread",15411],"139":["thread",15339],"140":["thread",15329],"141":["thread",15279],"142":["thread",15155],"143":["thread",15103],"144":["thread",14746],"145":["thread",14744],"146":["thread",13032],"147":["thread",14544],"148":["thread",14351],"149":["thread",14277],"150":["thread",14213],"151":["thread",14083],"152":["thread",14000],"153":["thread",13883],"154":["thread",13881],"155":["thread",13875],"156":["thread",13776],"157":["thread",13854],"158":["thread",13833],"159":["thread",13827],"161":["thread",13655],"162":["thread",13593],"163":["thread",13590],"164":["thread",12804],"165":["thread",13545],"166":["thread",13495],"167":["thread",13470],"168":["thread",12305],"169":["thread",13423],"170":["thread",13347]}
Run Time: 0.003544