Fixed N+1 query in forum_list and forum_view

[Banxix]

Affected version

2.1.0 Beta 5

Not tested in fresh install of 2.1.0 beta 5 but I noticed N+1 queries in forum_list (actionList) and in forum_view (actionForum)

The query below are in node_list

SELECT `xf_thread_read`.*
FROM `xf_thread_read`

WHERE (`xf_thread_read`.`thread_id` = N) AND (`xf_thread_read`.`user_id` = 1)

LIMIT 1

And this is when viewing a particular forum

SELECT `xf_user`.*
FROM `xf_user`

WHERE (`xf_user`.`user_id` = N)

LIMIT 1

They are added 20+ queries each page load.

 

[Mike]

This has been fixed for the next 2.1 release.