mysql_优化之OR替换为union

//优化改进
EXPLAIN
								

SELECT
    a.register_custom_info_id,
	a.custom_name,
	a.custom_identity,
	a.consumer_card_number,
	a.custom_number,
	DATE_FORMAT( a.register_time, '%Y-%m-%d %H:%i:%s' ) register_time,
	b.remark,
	c.cost_money,
	a.checkout_status
FROM
	register_custom_info a
LEFT JOIN (
	SELECT register_custom_info_id,GROUP_CONCAT( remark ) remark
	FROM register_custom_operatorlog
	GROUP BY register_custom_info_id
) b ON a.register_custom_info_id = b.register_custom_info_id 
		
LEFT JOIN (
	SELECT SUM( c.custom_need_pay_money ) cost_money,aa.register_custom_info_id from 
    (
    SELECT a.register_custom_info_id 
	FROM register_custom_info a
	JOIN register_custom_info b ON a.register_custom_info_id = b.register_custom_info_id 		
	union all     //将OR替换为UNION可以让查询走索引
	SELECT a.register_custom_info_id 
	FROM register_custom_info a	
	JOIN register_custom_info b ON a.custom_order_id = b.custom_order_id 			
	) AS aa
	JOIN consumption_info c ON aa.register_custom_info_id = c.register_custom_info_id
	GROUP BY aa.register_custom_info_id
	) c ON a.register_custom_info_id = c.register_custom_info_id
    WHERE
	    a.company_id = 826
		AND a.register_type = 3
		AND a.`status` != 9