mysql 查询优化，子查询和sum orderby 一起使用后运行很慢，球大神指点

Question

SELECT
    s.*,
    (SELECT SUM(pay_price) AS total_money
FROM hjmallind_order
WHERE is_show = 1
    AND is_delete = 0
    AND store_id = 2
    AND is_cancel = 0
    AND is_sale = 1
    AND is_confirm = 1
    AND user_id IN (SELECT id
        FROM hjmallind_user
        WHERE is_delete = 0
            AND is_distributor != 1
            AND store_id = 2
            AND parent_id = s.user_id
            OR user_id = s.user_id)) as total_money
FROM
    hjmallind_share AS s

WHERE
    s.is_delete = 0 
    AND s.store_id = 2 
    AND s.STATUS = 1 
    ORDER BY total_money
    LIMIT 5

Answer 1

1、可以用explain 看下执行计划；
2、考虑给部分字段加下索引，比如pay_price，user_id，total_money，parent_id