SELECT
	count(*) num,
	DATE_FORMAT(create_time, '%Y-%m-%d') AS `day`
FROM
	sys_log
WHERE
	log_type = 1
AND create_time > DATE_SUB(NOW(), INTERVAL 10 DAY)
GROUP BY
	DATE_FORMAT(create_time, '%Y-%m-%d')