ALTER TABLE appointment_order
    ADD KEY idx_ao_del_create_id (del_flag, create_time, id),
    ADD KEY idx_ao_del_visited_status (del_flag, visited_user_id, status),
    ADD KEY idx_ao_del_submitter_create_id (del_flag, submitter_id, create_time, id),
    ADD KEY idx_ao_del_visited_visit_range (del_flag, visited_user_id, visit_start_date, visit_end_date);

ALTER TABLE approval_instance
    ADD KEY idx_ai_del_order_id (del_flag, order_id, id);

ALTER TABLE approval_task
    ADD KEY idx_at_del_assignee_status_create (del_flag, assignee_user_id, task_status, create_time),
    ADD KEY idx_at_del_assignee_status_update_id (del_flag, assignee_user_id, task_status, update_time, id),
    ADD KEY idx_at_instance_node_group_status (instance_id, node_code, group_key, task_status);

ALTER TABLE appointment_visitor
    ADD KEY idx_av_del_order_id (del_flag, order_id, id),
    ADD KEY idx_av_del_name (del_flag, name);

ALTER TABLE qrcode_ticket
    ADD KEY idx_qt_del_order_visitor_status_id (del_flag, order_id, mp_visitor_id, ticket_status, id);