SELECT 
  v.variant_id as id, 
  d.variant_name as name, 
  o.option_id as option_id, 
  i.option_name as option_name, 
  v.position as position, 
  v.nav_skus, 
  v.image_size, 
  v.modifier, 
  v.modifier_type, 
  v.commercial_modifier, 
  v.commercial_dn, 
  v.extra_details, 
  v.vertical_position, 
  v.separator_label, 
  v.lead_time, 
  v.base_cost, 
  v.same_as_option, 
  v.price_overrides, 
  (
    select 
      1
  ) as is_global 
FROM 
  cscart_product_option_variants as v 
  INNER JOIN cscart_product_option_variants_descriptions as d 
  INNER JOIN cscart_product_global_option_links as o 
  INNER JOIN cscart_product_options_descriptions as i 
  INNER JOIN cscart_products as p ON v.variant_id = d.variant_id 
  AND o.option_id = i.option_id 
  AND o.option_id = v.option_id 
  AND o.product_id = p.product_id 
WHERE 
  p.product_id = 65548 
  AND o.option_id = 23860 
  AND v.status = 'A' 
ORDER BY 
  option_name ASC, 
  name ASC

Query time 0.00108

JSON explain

{
  "query_block": {
    "select_id": 1,
    "filesort": {
      "sort_key": "i.option_name, d.variant_name",
      "temporary_table": {
        "table": {
          "table_name": "o",
          "access_type": "const",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "PRIMARY",
          "key_length": "6",
          "used_key_parts": ["option_id", "product_id"],
          "ref": ["const", "const"],
          "rows": 1,
          "filtered": 100,
          "using_index": true
        },
        "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": "i",
          "access_type": "ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["option_id"],
          "ref": ["const"],
          "rows": 1,
          "filtered": 100
        },
        "table": {
          "table_name": "v",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "option_id", "option_id_2", "status"],
          "key": "option_id",
          "key_length": "6",
          "used_key_parts": ["option_id", "status"],
          "ref": ["const", "const"],
          "rows": 19,
          "filtered": 100,
          "index_condition": "v.`status` = 'A'"
        },
        "table": {
          "table_name": "d",
          "access_type": "ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["variant_id"],
          "ref": ["cscart_migrate.v.variant_id"],
          "rows": 1,
          "filtered": 100
        }
      }
    }
  }
}

Result

id name option_id option_name position nav_skus image_size modifier modifier_type commercial_modifier commercial_dn extra_details vertical_position separator_label lead_time base_cost same_as_option price_overrides is_global
240566 Barn Red & Black Swirl Cloth 23860 Cords 30 RBS 4 40.000 A 0.00 0.00 Barn Red & Black Swirl Cloth 0 0 13.66 0 1
240562 Black Cloth 23860 Cords 10 CSB 4 40.000 A 0.00 0.00 Black Cloth 0 0 11.46 0 1
240572 Blush Pink Cloth 23860 Cords 22 BPNK 4 50.000 A 0.00 0.00 Blush Pink Cloth 0 0 17.00 0 1
240568 Buttery Yellow Cloth 23860 Cords 40 YLW 4 80.000 A 0.00 0.00 Buttery Yellow Cloth 0 0 26.86 0 1
240581 Confetti Cloth 23860 Cords 23 CNF 4 50.000 A 0.00 0.00 Confetti Cloth 0 0 16.00 0 1
240564 Creme Cloth 23860 Cords 20 CRM 4 40.000 A 0.00 0.00 Creme Cloth 0 0 13.66 0 1
240570 Emerald Green Cloth 23860 Cords 50 EGRN 4 50.000 A 0.00 0.00 Emerald Green Cloth 0 0 17.06 0 1
240571 Fern Green Chevron Cloth 23860 Cords 55 FGRN 4 50.000 A 0.00 0.00 Fern Green Chevron Cloth 0 0 16.86 0 1
240576 Navy Cloth 23860 Cords 85 NVY 4 80.000 A 0.00 0.00 Navy Cloth 0 0 26.86 0 1
240569 Neon Green Cloth 23860 Cords 45 NGRN 4 50.000 A 0.00 0.00 Neon Green Cloth 0 0 16.84 0 1
240567 Orange Cloth 23860 Cords 35 ORG 4 40.000 A 0.00 0.00 Orange Cloth 0 0 13.26 0 1
240582 Please Select 23860 Cords 0 unselected 4 0.000 A 0.00 0.00 0 0 0.00 0 1
240575 Royal Blue Cloth 23860 Cords 80 RBLU 4 40.000 A 0.00 0.00 Royal Blue Cloth 0 0 13.31 0 1
240565 Rust Cloth 23860 Cords 25 RST 4 50.000 A 0.00 0.00 Rust Cloth 0 0 17.00 0 1
240573 Seafoam Cloth 23860 Cords 70 SFM 4 50.000 A 0.00 0.00 Seafoam Cloth 0 0 17.26 0 1
240563 Silver Cloth 23860 Cords 15 SLVR 4 40.000 A 0.00 0.00 Silver Cloth 0 0 13.66 0 1
240574 Sky Blue Cloth 23860 Cords 75 SBLU 4 50.000 A 0.00 0.00 Sky Blue Cloth 0 0 16.86 0 1
240560 Standard Black 23860 Cords 3 SBK 4 30.000 A 0.00 0.00 Standard Black 0 Damp Location - UL/CSA Listed 0 5.26 0 1
240561 Standard White 23860 Cords 5 SWH 4 35.000 A 0.00 0.00 Standard White 0 0 7.26 0 1