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

Query time 0.00089

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": 20,
          "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
22154 Acrylic Diffuser Cage Finish A 40 (NEW) Acrylic Diffuser Cage Finish - Deep RLM - MG 0 8 0 0 0 1 0 o 0 {"2":{"type":"ANY","items":[["22041","244806"],["22041","244807"],["22041","244813"],["22041","244808"],["22041","244811"],["22041","244810"],["22041","244809"],["22041","244812"]]},"3":{"type":"ANY","items":[["22145","218156"],["23102","230638"]]}} 1
22155 Acrylic Diffuser Cage Finish A 40 (NEW) Acrylic Diffuser Cage Finish - Deep RLM - PC 0 8 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22145","218156"],["23102","230638"]]},"2":{"type":"ANY","items":[["22041","217349"],["22041","217368"],["22041","217354"],["22041","217369"],["22041","217370"],["22041","217371"],["22041","217372"],["22041","217366"],["22041","217373"],["22041","217353"],["22041","217374"],["22041","217375"],["22041","217377"],["22041","217379"],["22041","217367"],["22041","217350"],["22041","217356"],["22041","217351"],["22041","217352"],["22041","217355"],["22041","217357"],["22041","217365"],["22041","217358"],["22041","217359"],["22041","217360"],["22041","217361"],["22041","217362"],["22041","217363"],["22041","217364"],["22041","217376"],["22041","225913"],["22041","236858"],["22041","236859"],["22041","241007"],["22041","241008"],["22041","241009"],["22041","241005"],["22041","241006"],["22041","245257"],["22041","245258"],["22041","245259"],["22041","245256"]]}} 1
23099 Canopy A 25 (NEW) Canopy - Deep RLM - LED Stem 0 10 0 0 0 1 11 o 0 {"1":{"type":"ANY","items":[["22159","218407"],["22159","218408"],["22159","218409"],["22159","218406"],["22159","218405"],["22159","218404"],["22159","218390"],["22159","218388"],["22159","218389"],["22159","218403"],["22159","218402"],["22159","218392"],["22159","218393"],["22159","218391"],["22159","218387"],["22159","218385"],["22159","218386"],["22159","218394"],["22159","218395"],["22159","218400"],["22159","218401"],["22159","218399"],["22159","218398"],["22159","218396"],["22159","218397"],["22159","218384"],["22158","218377"],["22158","218378"],["22158","218357"],["22158","218376"],["22158","218375"],["22158","218359"],["22158","218374"],["22158","218358"],["22158","218352"],["22158","218373"],["22158","218372"],["22158","218361"],["22158","218362"],["22158","218363"],["22158","218360"],["22158","218356"],["22158","218354"],["22158","218355"],["22158","218364"],["22158","218365"],["22158","218370"],["22158","218371"],["22158","218369"],["22158","218368"],["22158","218366"],["22158","218367"],["22158","218353"],["22157","218349"],["22157","218348"],["22157","218350"],["22157","218351"],["22157","218338"],["22157","218347"],["22157","218346"],["22157","218341"],["22157","218340"],["22157","218342"],["22157","218343"],["22157","218345"],["22157","218344"],["22157","218339"],["22158","241047"],["22158","241045"],["22158","241046"],["22158","236982"],["22158","236983"],["22158","241043"],["22158","241044"],["22159","241050"],["22159","241051"],["22159","241052"],["22159","236980"],["22159","236981"],["22159","241048"],["22159","241049"]]}} 1
23100 Canopy A 25 (NEW) Canopy - Deep RLM - LED Copper Stem 0 10 0 0 0 1 11 o 0 {"1":{"type":"ANY","items":[["22159","218412"],["22159","218410"],["22159","218411"],["22158","218379"],["22158","218381"],["22158","218380"]]}} 1
23101 Canopy A 25 (NEW) Canopy - Deep RLM - LED Brass Stem 0 10 0 0 0 1 11 o 0 {"1":{"type":"ANY","items":[["22159","218414"],["22159","218413"],["22158","218383"],["22158","218382"]]}} 1
22644 Color Temperature A 58 (NEW) Color Temperature 0 13 0 0 0 1 0 o 0 1
22041 Finishes View Design File A 10 (NEW) Finishes - Deep RLM 0 3 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
23136 Lumens A 47 (NEW) Lumens - 850-2000 (Diffuser) 0 12 0 0 1 1 0 i 0 {"1":{"type":"ANY","items":[["22122","218024"],["22122","218023"],["22096","217876"],["22096","217875"],["22073","217690"],["22073","217689"],["22073","217688"],["22057","217565"],["22057","217564"],["22044","217451"],["22044","217452"],["22193","218828"],["22193","218829"],["22193","218830"],["22044","217451"],["22044","217452"],["21926","215104"],["22057","217566"],["22201","218915"],["22201","218916"],["22201","218917"],["23894","243031"],["23894","243032"],["23894","243033"]]},"2":{"type":"ANY","items":[["22646","224222"],["23102","230638"],["23521","236460"]]}} 1
23137 Lumens A 47 (NEW) Lumens - 850-1250 (Diffuser) 0 12 0 0 1 1 0 i 0 {"1":{"type":"ANY","items":[["21926","217134"],["21926","217135"],["21926","215107"],["21926","215106"],["21926","215104"],["21926","215105"],["21926","215103"],["22044","217450"],["22044","217449"],["22193","218827"],["22057","217563"],["22044","217450"],["22044","217449"]]},"2":{"type":"ANY","items":[["22646","224222"],["23521","236460"],["23102","230638"]]}} 1
23138 Lumens A 47 (NEW) Lumens - 850-3000 (Diffuser) 0 12 0 0 1 1 0 i 0 {"1":{"type":"ANY","items":[["21926","217134"],["21926","217135"],["21926","215107"],["21926","215106"],["21926","215105"],["21926","215103"],["22044","217453"],["22044","217453"],["22044","217454"],["22044","217453"],["22044","217454"]]},"2":{"type":"ANY","items":[["22646","224222"],["23521","236460"],["23102","230638"]]}} 1
23143 Lumens A 47 (NEW) Lumens - 850-4000 - DBW 0 12 0 0 1 1 0 i 0 {"1":{"type":"ANY","items":[["22044","217449"],["22044","217454"],["22044","217453"],["22044","217451"],["22044","217452"],["22044","217450"],["22044","238103"]]},"2":{"type":"ANY","items":[["23102","230636"],["23102","230635"],["23521","236459"],["23521","236461"],["22254","219398"],["22254","219399"],["23102","230635"],["23102","230636"]]}} 1
22157 Mounting Finish A 20 (NEW) Mounting Finish - Deep RLM - MG 0 5 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22041","244806"],["22041","244807"],["22041","244813"],["22041","244808"],["22041","244811"],["22041","244810"],["22041","244809"],["22041","244812"]]}} 1
22158 Mounting Finish A 20 (NEW) Mounting Finish - Deep RLM - PC & NAT 0 5 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22041","217349"],["22041","217368"],["22041","217354"],["22041","217369"],["22041","217370"],["22041","217371"],["22041","217372"],["22041","217366"],["22041","217373"],["22041","217353"],["22041","217367"],["22041","217350"],["22041","217356"],["22041","217351"],["22041","217352"],["22041","217355"],["22041","217357"],["22041","217365"],["22041","217358"],["22041","217359"],["22041","217360"],["22041","217361"],["22041","217362"],["22041","217363"],["22041","217364"],["22041","225913"],["22041","236858"],["22041","236859"],["22041","241007"],["22041","241008"],["22041","241009"],["22041","241005"],["22041","241006"],["22041","245257"],["22041","245258"],["22041","245259"],["22041","245256"]]}} 1
22159 Mounting Finish A 20 (NEW) Mounting Finish - Deep RLM - PC NO SAS 0 5 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22041","217374"],["22041","217375"],["22041","217377"],["22041","217379"],["22041","217376"]]}} 1
21947 Mounting Options View Stem Design File A 15 (NEW) Mounting Options - Stem 0 4 0 0 1 2 0 i 0 1
23102 Shade Accessory A 32 (NEW) Shade Accessory - Deep LED 0 8 0 0 0 1 0 o 0 1
22044 Shade Size A 2 (NEW) Shade Size - DBW 0 2 0 0 0 1 14 o 1 1
22151 Wire Cage Finish A 40 (NEW) Wire Cage Finish - Deep RLM - MG 0 8 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22145","218157"],["23102","230636"]]},"2":{"type":"ANY","items":[["22041","244806"],["22041","244807"],["22041","244813"],["22041","244808"],["22041","244811"],["22041","244810"],["22041","244809"],["22041","244812"]]}} 1
22153 Wire Cage Finish A 40 (NEW) Wire Cage Finish - Deep RLM - PC 0 8 0 0 0 1 0 o 0 {"1":{"type":"ANY","items":[["22145","218157"],["23102","230636"]]},"3":{"type":"ANY","items":[["22041","217349"],["22041","217368"],["22041","217354"],["22041","217369"],["22041","217370"],["22041","217371"],["22041","217372"],["22041","217366"],["22041","217373"],["22041","217353"],["22041","217374"],["22041","217375"],["22041","217377"],["22041","217379"],["22041","217367"],["22041","217350"],["22041","217356"],["22041","217351"],["22041","217352"],["22041","217355"],["22041","217357"],["22041","217365"],["22041","217358"],["22041","217359"],["22041","217360"],["22041","217361"],["22041","217362"],["22041","217363"],["22041","217364"],["22041","217376"],["22041","225913"],["22041","236858"],["22041","236859"],["22041","241007"],["22041","241008"],["22041","241009"],["22041","241005"],["22041","241006"],["22041","245257"],["22041","245258"],["22041","245259"],["22041","245256"]]}} 1