日志格式
# 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