SELECT
i.id,
i.area_id,
i.data_source_id,
i.tag_id,
i.refresh_answer_group,
i.item_category,
(
SELECT
GROUP_CONCAT(
CONCAT(
g.answer_group_id,
‘-’,
g.bind_rule_flag,
g.bind_rel_flag,
g.bind_user_flag,
g.black_flag
)
)
FROM
b_base_data_to_answer_group_bind g
WHERE
i.id = g.base_data_id
AND g.type = ?
) AS answer_group_id_and_flag,
(
SELECT
GROUP_CONCAT(b_base_data_to_industry.industry_id)
FROM
b_base_data_to_industry
WHERE
b_base_data_to_industry.base_data_id = si.id
AND b_base_data_to_industry.type = ?
AND b_base_data_to_industry.industry_id IS NOT NULL
) AS industry_id
FROM
g_enforcement_item i
INNER JOIN g_same_item_to_item ti ON ti.item_id = i.id
LEFT JOIN g_same_item si ON ti.same_item_id = si.id
WHERE
i.use_flag = ?
AND i.virtual_item_flag = ?
AND i.id > ?
AND i.id <= ? 这个 sql 客户端执行时间为7s 云平台统计时间
请问这个是什么原因造成的？