阿里云sls收集mysql慢日志

日志格式

# Time: 210303 12:28:49
# User@Host: up366mall[up366mall] @  [192.168.23.9]  Id: 173673774
# Query_time: 3.548998  Lock_time: 0.000083 Rows_sent: 1  Rows_examined: 2297436
SET timestamp=1614745729;
select COUNT(DISTINCT(a.`order_id`))
    from txm_order a

    where a.goods_amount>0 and a.pay_status = 2 and NOT EXISTS (SELECT 1 FROM txm_organ_exclusion o WHERE a.organ_id=o.organ_id)









      and a.sale_confirm_status = 1;
# Time: 210303 13:22:17
# User@Host: up366mall[up366mall] @  [192.168.23.9]  Id: 173674054
# Query_time: 1.134606  Lock_time: 0.000415 Rows_sent: 1  Rows_examined: 2311088
SET timestamp=1614748937;
SELECT
    IFNULL(SUM(c.goods_amount+ c.discount),0) AS moneyAmount,
    IFNULL(SUM(c.bonus),0) AS bonus,
    IFNULL(SUM(c.discount),0) AS discount,
    IFNULL(SUM(c.integral_money),0) AS integreal,
    IFNULL(SUM(c.coupon_money),0) AS coupon,
    IFNULL(SUM(c.money_p