select
from_unixtime(base.start_time, '%Y-%m-%d') dt,
city.city_id,
GREATEST(city.is_deleted, ssu.is_deleted, base.is_deleted) is_deleted,
ssu.ssu_id,
ssu.sku_id,
base.id activity_id,
base.name activity_name,
base.original_id,
base.task_type,
base.task_type_scene,
base.description,
base.start_time,
base.end_time,
base.status,
base.operator_name,
base.operator_id,
base.company_set_key,
base.system_tag,
base.biz_id,
base.pool_id,
base.budget,
base.extension_info,
base.use_new_pool,
base.role_id,
base.platform_share_ratio,
base.ext,
base.group_id activity_group_id,
ssu.pop_id,
ssu.sale_class1_id,
ssu.sale_class2_id,
ssu.start_time,
ssu.end_time,
ssu.stage_index,
ssu.sale_start_time,
ssu.sale_end_time,
ssu.original_price,
ssu.price,
ssu.ssu_status,
ssu.c_t,
ssu.u_t,
ssu.purchase_class1_id,
ssu.purchase_class2_id,
ssu.bi_id,
supply_sku.category_group_id category_group_id,
supply_group.path group_path
from
ods.ods_marketing_manage_service_op_task base
join ods.ods_marketing_manage_service_op_task_ssu ssu on base.id = ssu.op_task_id
join ods.ods_marketing_manage_service_op_task_city_mapping city on base.id = city.op_task_id
LEFT JOIN ods.ods_loessland_supply_category_group_city_sku supply_sku ON ssu.sku_id = supply_sku.sku_id
and city.city_id = supply_sku.city_id
and supply_sku.is_deleted = 0
LEFT JOIN ods.ods_loessland_supply_category_group supply_group ON supply_group.id = supply_sku.category_group_id
WHERE
base.dt = '2025-03-06'
AND base.id IN (83818025, 83818028, 83818027, 83862690)
这条SQL, 每次执行都是1s50ms以内。
set runtime_filter_wait_time=0; 设置完后，就很快，50ms以内。
不知道为什么？
