统计每小时
SELECT HOUR(trigger_time) as Hour,count(*) as Count
FROM xxl_job_qrtz_trigger_log
WHERE
trigger_time BETWEEN '2018-02-05 01:18:36'
AND '2018-02-05 17:18:36'
GROUP BY HOUR(trigger_time) ORDER BY Hour(trigger_time);
统计每天
SELECT
DATE_FORMAT(trigger_time, '%Y-%m-%d') triggerDay,
COUNT(id) triggerCount
FROM
`job_qrtz_trigger_log`
WHERE
trigger_time BETWEEN '2018-02-02 09:18:36'
AND '2018-03-05 23:18:36'
GROUP BY triggerDay
ORDER BY trigger_time;