SELECT SUM(TIME_TO_SEC(TIMEDIFF(`to`,`from`))) as `spent` FROM `intervals` GROUP BY `id`;