SELECT 
  * 
FROM 
  cscart_profile_fields 
WHERE 
  profile_type = 'S'

Query time 0.00096

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "11.40"
    },
    "table": {
      "table_name": "cscart_profile_fields",
      "access_type": "ALL",
      "rows_examined_per_scan": 52,
      "rows_produced_per_join": 5,
      "filtered": "10.00",
      "cost_info": {
        "read_cost": "10.36",
        "eval_cost": "1.04",
        "prefix_cost": "11.40",
        "data_read_per_join": "9K"
      },
      "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",
        "ec_multiple",
        "usergroup_ids"
      ],
      "attached_condition": "(`webmarco`.`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 ec_multiple usergroup_ids
36 company Y Y N N Y Y Y I S 10 Y C 0 company organization N 0
37 admin_firstname Y Y N N Y Y N I S 20 N C 0 first-name given-name N 0
38 admin_lastname Y Y N N Y Y N I S 30 N C 0 last-name surname N 0
39 email Y Y N N Y Y Y E S 40 Y C 0 email email N 0
40 company_description Y N N N Y N Y T S 50 Y C 0 company-description N 0
41 address Y N N N Y N Y I S 60 Y C 0 shipping-address street-address N 0
42 city Y N N N Y N Y I S 80 Y C 0 shipping-city city N 0
43 country Y N N N Y N Y O S 90 Y C 0 shipping-country country N 0
44 state Y N N N Y N Y A S 100 Y C 0 shipping-state state N 0
45 zipcode Y N N N Y N Y Z S 110 Y C 0 shipping-zip-code postal-code N 0
46 phone Y N N N Y N Y I S 120 Y C 0 shipping-phone phone-full N 0
48 url Y N N N Y N Y I S 140 Y C 0 url url N 0
49 accept_terms Y N N N Y N Y B S 150 Y C 0 cm-agreement checkbox N 0
50 plan_id Y N N N Y N Y V S 15 Y C 0 plan-id N 0
51 Input Y N N N Y N Y I S 45 N C 0 fax N 0
54 5 Y N N N Y N Y I S 0 N C 0 N 0
55 youtube_link Y N N N Y N N I S 1 N C 0 N 0
57 province Y N N N N N Y I S 95 N C 0 N 0
60 tax_number Y N N N N N Y I S 14 Y C 0 tax_number N 0
61 type Y N N N N N Y S S 60 N C 0 Y 0
62 categories Y N N N N N Y S S 70 N C 0 Y 0