refs #9611 optimize 'breakdown' queries