Tabs in "Your projects" activity pages fails loading with 15 seconds timeout

The tabs under https://gitlab.com/dashboard/activity fail to load:

We fixed the All tab query in #350340 (closed). Use the same technique to optimize the query for all the remaining tabs.