$time = time() - 600;

select xx_id,count(xx_id) count from tablename where type = 1 and time > $time group by xx_id;