百思不得其姐的SQL问题求教

$start = date('Y-m-d 00:00:00');
$end = date('Y-m-d H:i:s');
SELECT * FROM `table_name` WHERE `time` >= unix_timestamp( '$start' ) AND `time` <= unix_timestamp( '$end' ) order by time

SELECT MAX(time),goodid FROM t_goods GROUP BY goodid, DATE_FORMAT(time,'%Y%m%d')