SELECT
COUNT(*) AS total,
SUM(IF(status = 1, 1, 0)) AS status1,
SUM(IF(status = 2, 1, 0)) AS status2,
SUM(IF(status = 3, 1, 0)) AS status3,
SUM(IF(status = 4, 1, 0)) AS status4
FROM
sys_order_t
SELECT
COUNT(*) AS total,
SUM(IF(status = 1, 1, 0)) AS status1,
SUM(IF(status = 2, 1, 0)) AS status2,
SUM(IF(status = 3, 1, 0)) AS status3,
SUM(IF(status = 4, 1, 0)) AS status4
FROM
sys_order_t