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

Query time 0.00103

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
22791 Fitter, Gooseneck & Backplate Finish View Design File A 10 (NEW) Fitter, Gooseneck & Backplate Finish - SCH 0 2 0 0 0 1 0 o 0 1
22929 Glass Style A 5 (NEW) Glass Style - DRM 0 2 0 0 0 1 11 o 0 1
22930 Gooseneck Arms View Gooseneck Design File A 15 (NEW) Gooseneck Arms - DRM 0 4 0 0 0 1 0 o -5 {} 1
22799 Mounting Accessory A 43 (NEW) Mounting Accessory - SCH - Gooseneck 0 9 0 0 0 1 10 o 0 {"1":{"type":"ANY","items":[["22791","226338"],["22791","226363"],["22791","226359"],["22791","226360"],["22791","226365"],["22791","226366"],["22791","226361"],["22791","226362"],["22791","226367"],["22791","226343"],["22791","226342"],["22791","226358"],["22791","226357"],["22791","226339"],["22791","226347"],["22791","226340"],["22791","226341"],["22791","226344"],["22791","226364"],["22791","226345"],["22791","226346"],["22791","226348"],["22791","226356"],["22791","226349"],["22791","226350"],["22791","226351"],["22791","226352"],["22791","226353"],["22791","226354"],["22791","226355"],["22791","237048"],["22791","237049"]]}} 1
22800 Mounting Accessory A 43 (NEW) Mounting Accessory - SCH - Copper Gooseneck 0 9 0 0 0 1 10 o 0 {"1":{"type":"ANY","items":[["22791","226368"],["22791","226369"],["22791","226370"]]}} 1
22801 Mounting Accessory A 43 (NEW) Mounting Accessory - SCH - Brass Gooseneck 0 9 0 0 0 1 10 o 0 {"1":{"type":"ANY","items":[["22791","226371"],["22791","226372"]]}} 1
22931 Painted Band A 20 (NEW) Painted Band - DRM 0 7 0 0 0 1 11 o 0 {"1":{"type":"ANY","items":[["22929","228306"],["23592","238235"]]}} 1
22932 Painted Band A 20 (NEW) Painted Band - DRMCL 0 7 0 0 0 1 11 o 0 {"1":{"type":"ANY","items":[["22929","228307"],["23592","238236"]]}} 1
22798 Painted Band Finish A 22 (NEW) Painted Band Finish - SCH 0 8 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22794","226436"],["22794","226435"],["22794","226437"],["22797","226451"],["22797","226450"],["22797","226452"],["22795","226441"],["22795","226440"],["22795","226442"],["22796","226446"],["22796","226445"],["22796","226447"],["22923","228255"],["22923","228254"],["22923","228253"],["22924","228260"],["22924","228259"],["22924","228258"],["22927","228298"],["22927","228296"],["22927","228297"],["22928","228303"],["22928","228301"],["22928","228302"],["22931","228340"],["22931","228341"],["22931","228339"],["22932","228345"],["22932","228346"],["22932","228344"]]}} 1
21941 Socket Type A 55 (NEW) Socket Type - GU24 0 11 0 0 0 1 0 o 0 1