SELECT 
  o.option_id as id, 
  i.option_name as name, 
  i.description, 
  i.comment, 
  o.status, 
  o.position, 
  o.alt_name, 
  o.design_file_attachment_id, 
  o.sku_column, 
  o.is_master_option, 
  o.base_variant_id, 
  o.variant_style, 
  o.variant_block_size, 
  o.variant_text_size, 
  o.variant_text_location, 
  o.variant_vertical_spacing, 
  o.visibility, 
  (
    select 
      1
  ) as is_global 
FROM 
  cscart_product_global_option_links as g 
  INNER JOIN cscart_product_options as o 
  INNER JOIN cscart_product_options_descriptions as i 
  INNER JOIN cscart_products as p ON g.option_id = o.option_id 
  AND g.product_id = p.product_id 
  AND g.option_id = i.option_id 
WHERE 
  g.product_id = 62703 
ORDER BY 
  name ASC

Query time 0.00112

JSON explain

{
  "query_block": {
    "select_id": 1,
    "filesort": {
      "sort_key": "i.option_name",
      "temporary_table": {
        "table": {
          "table_name": "p",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100,
          "using_index": true
        },
        "table": {
          "table_name": "g",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "product_id",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "ref": ["const"],
          "rows": 10,
          "filtered": 100,
          "using_index": true
        },
        "table": {
          "table_name": "o",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["option_id"],
          "ref": ["cscart_migrate.g.option_id"],
          "rows": 1,
          "filtered": 100
        },
        "table": {
          "table_name": "i",
          "access_type": "ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["option_id"],
          "ref": ["cscart_migrate.g.option_id"],
          "rows": 1,
          "filtered": 100
        }
      }
    }
  }
}

Result

id name description comment status position alt_name design_file_attachment_id sku_column is_master_option base_variant_id variant_style variant_block_size variant_text_size variant_text_location variant_vertical_spacing visibility is_global
22644 Color Temperature A 58 (NEW) Color Temperature 0 13 0 0 0 1 0 o 0 1
21970 Finishes View Design File A 10 (NEW) Finishes (1) - PC & Limited PTMP 0 2 0 0 0 2 0 o 0 {} 1
22035 Gooseneck Arm Finish A 20 (NEW) Gooseneck Arm Finish - (1) PC & Limited PTMP 0 5 0 0 0 1 0 o 0 1
23186 Gooseneck Arms View Gooseneck Design File A 15 (NEW) Gooseneck Arms - CLAR - LED 0 4 0 0 0 1 0 o -5 1
22645 LED Lens A 60 (NEW) LED Lens 0 14 0 0 0 1 0 o 0 1
22675 Lumens A 47 (NEW) Lumens - 850-1250 0 12 0 0 1 1 0 i 0 1
23329 Mounting Accessory A 43 (NEW) Mounting Accessory - LED Gooseneck 0 10 0 0 0 1 11 o 0 {"1":{"type":"ANY","items":[["22693","224658"],["22693","224662"],["22693","224679"],["22693","224680"],["22693","224690"],["22693","224691"],["22693","224681"],["22693","224692"],["22693","224682"],["22693","224663"],["22693","224678"],["22693","224677"],["22693","224659"],["22693","224667"],["22693","224660"],["22693","224661"],["22693","224664"],["22693","224689"],["22693","224665"],["22693","224666"],["22693","224668"],["22693","224676"],["22693","224669"],["22693","224670"],["22693","224671"],["22693","224672"],["22693","224673"],["22693","224674"],["22693","224675"],["22693","224657"],["22694","224693"],["22694","224727"],["22694","224713"],["22694","224714"],["22694","224715"],["22694","224725"],["22694","224726"],["22694","224716"],["22694","224697"],["22694","224712"],["22694","224717"],["22694","224698"],["22694","224711"],["22694","224694"],["22694","224702"],["22694","224695"],["22694","224696"],["22694","224699"],["22694","224724"],["22694","224700"],["22694","224701"],["22694","224703"],["22694","224710"],["22694","224704"],["22694","224705"],["22694","224706"],["22694","224707"],["22694","224708"],["22694","224709"]]}} 1
22704 Shade Size A 2 (NEW) Shade Size - CLAR - 12"-16" 0 2 0 0 0 1 14 o 1 1
22911 Wire Cage View Design File A 32 (NEW) Wire Cage 19186 7 0 0 0 1 11 o 0 1
22040 Wire Cage Finish A 40 (NEW) Wire Cage Finish - PC & Limited PTMP 0 8 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22039","217304"],["22627","223483"],["22911","228070"],["23010","229808"],["23011","229811"],["22067","217632"],["22254","219399"],["23607","238386"]]}} 1