EXPLAIN SELECT
e.*
FROM
(
SELECT
a.group_id,
a.group_name,
a.target_return,
a.invest_money,
a.create_time,
a.currency_category_rate,
a.bond_category_rate,
a.stock_category_rate,
a.commodity_category_rate,
a.deposit_rate,
a.bank_financial_rate,
a.public_fund_rate,
a.risk,
a.bank_risk,
a.public_risk,
a.invest_duration,
a.group_type,
c.customer_name,
c.sex AS customerSex,
d.group_name AS basicGroupName
FROM
assets_config_wealth_group_base a
LEFT JOIN group_basic d ON a.group_type = d.group_id
LEFT JOIN customer_self_group_relation b ON a.group_id = b.group_id
LEFT JOIN customer_self_base_info c ON b.customer_id = c.customer_id
WHERE
a.customer_id IS NOT NULL
AND a.user_id = 'ht4'
AND a.org_id = 6510021
AND a.target_return IS NULL
AND a.is_del = 0 UNION ALL
SELECT
a.group_id,
a.group_name,
a.target_return,
a.invest_money,
a.create_time,
a.currency_category_rate,
a.bond_category_rate,
a.stock_category_rate,
a.commodity_category_rate,
a.deposit_rate,
a.bank_financial_rate,
a.public_fund_rate,
a.risk,
a.bank_risk,
a.public_risk,
a.invest_duration,
a.group_type,
c.customer_name,
c.sex AS customerSex,
d.group_name AS basicGroupName
FROM
assets_config_wealth_group_base a
LEFT JOIN group_basic d ON a.group_type = d.group_id
LEFT JOIN customer_other_group_relation b ON a.group_id = b.group_id
LEFT JOIN customer_other_base_info c ON b.customer_id = c.customer_id
WHERE
a.customer_id IS NULL
AND a.user_id = 'ht4'
AND a.target_return IS NULL
AND a.org_id = 6510021
AND a.is_del = 0
) e
WHERE
1 = 1
压测的时候，数据库压力大？
也就100并发，感觉不是很大