Sandbox

SELECT 
  c.product_id AS cur_product_id, 
  a.*, 
  b.option_name, 
  b.internal_option_name, 
  b.option_text, 
  b.description, 
  b.inner_hint, 
  b.incorrect_message, 
  b.comment 
FROM 
  product_options as a 
  LEFT JOIN product_options_descriptions as b ON a.option_id = b.option_id 
  AND b.lang_code = 'en' 
  LEFT JOIN product_global_option_links as c ON c.option_id = a.option_id 
WHERE 
  c.product_id IN (
    235951, 235981, 235982, 235902, 235950
  ) 
  AND a.product_id = 0 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00105

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "23.60"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "7.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "c",
            "access_type": "range",
            "possible_keys": [
              "PRIMARY",
              "product_id"
            ],
            "key": "product_id",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "rows_examined_per_scan": 14,
            "rows_produced_per_join": 14,
            "filtered": "100.00",
            "using_index": true,
            "cost_info": {
              "read_cost": "1.81",
              "eval_cost": "1.40",
              "prefix_cost": "3.21",
              "data_read_per_join": "224"
            },
            "used_columns": [
              "option_id",
              "product_id"
            ],
            "attached_condition": "((`goimagine`.`c`.`product_id` in (235951,235981,235982,235902,235950)) and (`goimagine`.`c`.`option_id` is not null))"
          }
        },
        {
          "table": {
            "table_name": "a",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "c_status"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "option_id"
            ],
            "key_length": "3",
            "ref": [
              "goimagine.c.option_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 6,
            "filtered": "50.00",
            "cost_info": {
              "read_cost": "6.64",
              "eval_cost": "0.70",
              "prefix_cost": "11.25",
              "data_read_per_join": "21K"
            },
            "used_columns": [
              "option_id",
              "product_id",
              "company_id",
              "option_type",
              "inventory",
              "regexp",
              "required",
              "multiupload",
              "allowed_extensions",
              "max_file_size",
              "missing_variants_handling",
              "status",
              "position",
              "value",
              "google_export_name_option",
              "etsy_prop_id"
            ],
            "attached_condition": "((`goimagine`.`a`.`product_id` = 0) and (`goimagine`.`a`.`status` = 'A'))"
          }
        },
        {
          "table": {
            "table_name": "b",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "option_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "goimagine.c.option_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 6,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "4.65",
              "eval_cost": "0.70",
              "prefix_cost": "16.60",
              "data_read_per_join": "23K"
            },
            "used_columns": [
              "option_id",
              "lang_code",
              "option_name",
              "internal_option_name",
              "option_text",
              "description",
              "comment",
              "inner_hint",
              "incorrect_message"
            ]
          }
        }
      ]
    }
  }
}

Result

cur_product_id	option_id	company_id	option_type	inventory	required	multiupload	missing_variants_handling	status	position	google_export_name_option	option_name	internal_option_name	description	comment
235902	27731	7090	R	Y	Y	N	M	A	0	not_option	Eye Type	Eye Type
235950	27731	7090	R	Y	Y	N	M	A	0	not_option	Eye Type	Eye Type
235950	27735	7090	C	Y	N	N	M	A	0	not_option	Custom Color	Custom Color Check Box	<p>If you choose custom color, please contact me with choices.</p>	If you check this box, please contact me with the color you want. If you do not contact me within 24 hours of your order, you will receive the original color.
235951	27731	7090	R	Y	Y	N	M	A	0	not_option	Eye Type	Eye Type
235951	27733	7090	S	Y	Y	N	M	A	0	not_option	Boy or Girl	Boy or Girl
235981	27747	7090	S	Y	Y	N	M	A	3	not_option	Choose number of characters in name or word	Letters
235982	27747	7090	S	Y	Y	N	M	A	3	not_option	Choose number of characters in name or word	Letters
235981	27748	7090	I	Y	Y	N	M	A	5	not_option	Name	Name Personalization		Please include exact spelling of the couple's last name or word desired.
235982	27748	7090	I	Y	Y	N	M	A	5	not_option	Name	Name Personalization		Please include exact spelling of the couple's last name or word desired.
235982	27751	7090	I	Y	Y	N	M	A	13	not_option	Initials	Initials Personalization		Include initials for your doily
235981	27749	7090	I	Y	Y	N	M	A	15	not_option	Date	Date Personalization		Enter Date of Wedding
235982	27749	7090	I	Y	Y	N	M	A	15	not_option	Date	Date Personalization		Enter Date of Wedding
235981	27750	7090	R	Y	Y	N	M	A	17	not_option	Color	Doily Color		Choose Color of Doily. Contact me if you want a custom color.
235982	27750	7090	R	Y	Y	N	M	A	17	not_option	Color	Doily Color		Choose Color of Doily. Contact me if you want a custom color.