SELECT
FROM_UNIXTIME(ROUND(UNIX_TIMESTAMP(start_time)-TIME_TO_SEC(query_time))) AS 'run_time',
A.*
FROM `slow_log` A
WHERE
#start_time BETWEEN '2021-05-03 00:20:00' AND '2021-05-03 09:00:00'
FROM_UNIXTIME(ROUND(UNIX_TIMESTAMP(start_time)-TIME_TO_SEC(query_time))) BETWEEN '2021-05-03 06:57:00' AND '2021-05-03 07:00:39'
#and sql_text like '%dmm_sendSmartStore%'
#AND query_time >'00:10:00.000000'
#and sql_text not like 'INSERT%'
#order by 4 desc
ORDER BY 1 ASC;
start_time : 이건 쿼리 시작 시간이 아니다, 쿼리 마침시간. 즉 SLOW_LOG 기록 시간
