Sandbox

SELECT 
  a.*, 
  b.option_name, 
  b.option_text, 
  b.description, 
  b.inner_hint, 
  b.incorrect_message, 
  b.comment 
FROM 
  cscart_product_options as a 
  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id 
  AND b.lang_code = 'en' 
WHERE 
  a.product_id IN (8295) 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00040

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	c_status	c_status	6	const,const	2	Using index condition; Using where; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	9	mahm3t_cs443.a.option_id,const	1	Using where

Result

option_id	product_id	company_id	option_type	inventory	regexp	required	multiupload	allowed_extensions	max_file_size	missing_variants_handling	status	position	value	size_option	note	google_export_name_option	option_name	option_text	description	inner_hint	incorrect_message	comment
1222	8295	1	S	Y		Y	N		0	M	A	100		N		not_option	Dimension X \| inner wall width		<p>The insect screen is mounted on the inner lining or on the wall. Thus, the roof cutout (X interior lining) is measured to determine the size of the insect screen. The width of the insect screen depends on the width of the window.<br /> <img alt="How to measure width of the insect screen?" src="/images/products/rooflite/zia/insektenschutz-rollos-montagehinweise.png" /></p>			The insect screen is mounted on the inner lining or on the wall
1223	8295	1	S	Y		Y	N		0	M	A	200		N		not_option	Dimension Y \| inner wall height		<p>The insect screen is mounted on the inner lining or on the wall. Thus, the roof cutout (Y interior lining) is measured to determine the size of the insect screen. The height of the insect screen depends on the height of the window.<br /> <img alt="How to choose height of the insect screen?" src="/images/products/rooflite/zia/insektenschutz-rollos-montagehinweise.png" /></p>			The insect screen is mounted on the inner lining or on the wall