CM Maintenance Plan Query with Customer Information - SQL Optimization

The given SQL query selects various fields from the "cm_maintenance_plan" table and joins it with the "customer_info" table on the "customer_id" column. It also includes a custom SQL segment defined by "ew.customSqlSegment".\n\nThe selected fields are as follows:\n\n- "plan_id"\n- "plan_name"\n- "customer_type"\n- "production_line_id"\n- "manager"\n- "description"\n- "fenb_demand"\n- "visit_times"\n- "commucation_times"\n- "training_times"\n- "objective"\n- "notifier"\n- "status"\n- "year"\n- "create_by"\n- "create_time"\n- "update_by"\n- "update_time"\n- "tenant_id"\n- "del_flag"\n- "customer_id"\n- "customer_name"\n\nThe query also includes a "LIMIT" clause to limit the number of returned rows based on the "current" and "size" parameters.\n\nNote: The "${ew.customSqlSegment}" is a placeholder for a custom SQL segment that can be dynamically added to the query.