I noticed insane amount of queries on homepage for
XXX_contentitem_tag_map. I actually don't display tags on homepage, since I've 100 articles on homepage - selecting tags for each article slows everything down considerably.
I noticed in
ContentModelArticles class, method
I need to disable this everywhere except on article page where I actually display tags.