每日一句优化sql之慢sql查询

• dyjh
• mysql
• 2022-08-12
• 97
• 0

select concat('运行时间',TIME,'s \nSQL:\n',INFO) as msg from INFORMATION_SCHEMA.PROCESSLIST where db = 'xjd' and COMMAND != 'Sleep' and TIME >= 3;