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 = 62408 
ORDER BY 
  name ASC

Query time 0.00105

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": 17,
          "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
22882 Canopy A 25 (NEW) Canopy - Australia - Stem 0 7 0 0 0 1 11 o 0 {"1":{"type":"ANY","items":[["22881","227555"],["22881","227589"],["22881","227575"],["22881","227576"],["22881","227577"],["22881","227587"],["22881","227588"],["22881","227578"],["22881","227559"],["22881","227574"],["22881","227579"],["22881","227560"],["22881","227573"],["22881","227556"],["22881","227564"],["22881","227557"],["22881","227558"],["22881","227561"],["22881","227586"],["22881","227562"],["22881","227563"],["22881","227565"],["22881","227572"],["22881","227566"],["22881","227567"],["22881","227568"],["22881","227569"],["22881","227570"],["22881","227571"],["22880","227520"],["22880","227524"],["22880","227541"],["22880","227542"],["22880","227552"],["22880","227553"],["22880","227543"],["22880","227554"],["22880","227544"],["22880","227525"],["22880","227540"],["22880","227539"],["22880","227521"],["22880","227529"],["22880","227522"],["22880","227523"],["22880","227526"],["22880","227551"],["22880","227527"],["22880","227528"],["22880","227530"],["22880","227538"],["22880","227531"],["22880","227532"],["22880","227533"],["22880","227534"],["22880","227535"],["22880","227536"],["22880","227537"],["22880","227519"],["22881","237168"],["22881","237169"],["22880","237166"],["22880","237167"]]}} 1
22883 Canopy A 25 (NEW) Canopy - Australia - Copper Stem 0 7 0 0 0 1 11 o 0 {"1":{"type":"ANY","items":[["22881","227580"],["22881","227581"],["22881","227582"],["22880","227545"],["22880","227546"],["22880","227547"]]}} 1
22884 Canopy A 25 (NEW) Canopy - Australia - Brass Stem 0 7 0 0 0 1 11 o 0 {"1":{"type":"ANY","items":[["22881","227583"],["22881","227584"],["22880","227548"],["22880","227549"]]}} 1
22863 Cap Option A 23 (NEW) Cap Option - PC Australia Stem/Gooseneck 0 7 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22859","227198"],["22859","227223"],["22859","227219"],["22859","227220"],["22859","227226"],["22859","227221"],["22859","227222"],["22859","227203"],["22859","227202"],["22859","227218"],["22859","227217"],["22859","227199"],["22859","227207"],["22859","227200"],["22859","227201"],["22859","227204"],["22859","227224"],["22859","227205"],["22859","227206"],["22859","227208"],["22859","227216"],["22859","227209"],["22859","227210"],["22859","227211"],["22859","227212"],["22859","227213"],["22859","227214"],["22859","227215"],["22859","237054"],["22859","237055"],["22859","241976"],["22859","241977"],["22859","241978"],["22859","241974"],["22859","241975"]]}} 1
22864 Cap Option A 23 (NEW) Cap Option - COP Australia Stem/Gooseneck 0 7 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22859","227228"],["22859","227229"],["22859","227230"]]}} 1
22865 Cap Option A 23 (NEW) Cap Option - BRS Australia Stem/Gooseneck 0 7 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22859","227231"],["22859","227232"]]}} 1
22644 Color Temperature A 58 (NEW) Color Temperature 0 13 0 0 0 1 0 o 0 1
22852 Glass Option A 40 (NEW) Glass Option - Australia 0 9 0 0 0 1 0 o 0 {} 1
22872 Guard Finish A 35 (NEW) Guard Finish - Australia 0 8 0 0 0 1 0 o 0 {} 1
23116 Lumens A 55 (NEW) Lumens - 16.8 0 7 0 0 1 1 0 i 0 1
22885 Mounting Accessory A 50 (NEW) Mounting Accessory - Australia - Copper Stem 0 7 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22881","227580"],["22881","227581"],["22880","227545"],["22880","227546"]]},"2":{"type":"ANY","items":[["22883","227594"],["22884","227598"],["22882","227590"]]}} 1
22886 Mounting Accessory A 50 (NEW) Mounting Accessory - Australia - Brass Stem 0 7 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22881","227583"],["22881","227584"],["22880","227548"],["22880","227549"]]},"2":{"type":"ANY","items":[["22883","227594"],["22884","227598"],["22882","227590"]]}} 1
21947 Mounting Options View Stem Design File A 15 (NEW) Mounting Options - Stem 0 4 0 0 1 2 0 i 0 1
22859 Shade & Top Finish View Design File A 10 (NEW) Finishes - Australia 0 3 0 0 0 1 0 o 0 1
22898 Shade Size A 2 (NEW) Shade Size - ULS 0 2 0 0 0 1 14 o 1 1
22880 Stem & Canopy Finish A 20 (NEW) Mounting Finish - Australia 0 5 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22859","227198"],["22859","227223"],["22859","227219"],["22859","227220"],["22859","227221"],["22859","227222"],["22859","227203"],["22859","227202"],["22859","227218"],["22859","227217"],["22859","227199"],["22859","227207"],["22859","227200"],["22859","227201"],["22859","227204"],["22859","227206"],["22859","227208"],["22859","227216"],["22859","227209"],["22859","227210"],["22859","227211"],["22859","227212"],["22859","227213"],["22859","227214"],["22859","227215"],["22859","237054"],["22859","237055"],["22859","241976"],["22859","241977"],["22859","241978"],["22859","241974"],["22859","241975"],["22859","242737"],["22859","242738"],["22859","242739"],["22859","227203"],["22859","242736"]]}} 1
22881 Stem & Canopy Finish A 20 (NEW) Mounting Finish - Australia - No SAS 0 5 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22859","227228"],["22859","227229"],["22859","227231"],["22859","227232"],["22859","227230"]]}} 1