SELECT 
  * 
FROM 
  cscart_profile_fields 
WHERE 
  profile_type = 'S'

Query time 0.00034

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4.35"
    },
    "table": {
      "table_name": "cscart_profile_fields",
      "access_type": "ALL",
      "rows_examined_per_scan": 41,
      "rows_produced_per_join": 4,
      "filtered": "10.00",
      "cost_info": {
        "read_cost": "3.94",
        "eval_cost": "0.41",
        "prefix_cost": "4.35",
        "data_read_per_join": "4K"
      },
      "used_columns": [
        "field_id",
        "field_name",
        "profile_show",
        "profile_required",
        "checkout_show",
        "checkout_required",
        "partner_show",
        "partner_required",
        "storefront_show",
        "field_type",
        "profile_type",
        "position",
        "is_default",
        "section",
        "matching_id",
        "class",
        "wrapper_class",
        "autocomplete_type",
        "cml_export_to_1c",
        "checkout_export_1c"
      ],
      "attached_condition": "(`dev2`.`cscart_profile_fields`.`profile_type` = 'S')"
    }
  }
}

Result

field_id field_name profile_show profile_required checkout_show checkout_required partner_show partner_required storefront_show field_type profile_type position is_default section matching_id class wrapper_class autocomplete_type cml_export_to_1c checkout_export_1c
36 company Y Y N N N N Y I S 10 Y C 0 company organization Y Y
37 admin_firstname Y N N N N N N I S 20 N C 0 first-name given-name Y Y
38 admin_lastname Y N N N N N N I S 30 N C 0 last-name surname Y Y
39 email Y Y N N N N Y E S 40 Y C 0 email email Y Y
40 company_description N N N N N N Y T S 50 Y C 0 company-description Y Y
41 address Y Y N N N N Y I S 60 Y C 0 shipping-address street-address Y Y
42 city N N N N N N N I S 80 Y C 0 shipping-city city Y Y
43 country N N N N N N N O S 90 Y C 0 shipping-country country Y Y
44 state N N N N N N N A S 100 Y C 0 shipping-state state Y Y
45 zipcode N N N N N N N Z S 110 Y C 0 shipping-zip-code postal-code Y Y
46 phone Y Y N N N N Y I S 120 Y C 0 shipping-phone phone-full Y Y
48 url Y N N N N N Y I S 140 Y C 0 url url Y Y
49 accept_terms Y Y N N N N Y B S 150 Y C 0 cm-agreement checkbox Y Y
50 tax_number Y Y N N N N N I S 6 Y C 0 tax_number Y Y
51 plan_id N N N N N N N V S 15 Y C 0 plan-id Y Y