Fixed optimized query for parent type
Optimized DCA options
Removed unnecessary call to slow File constructor
Optimize product queries