SELECT 
  sd.param_id, 
  sd.param, 
  cscart_static_data_descriptions.descr, 
  sd.param_2, 
  sd.param_3, 
  sd.param_4, 
  sd.param_5, 
  sd.param_6, 
  sd.status, 
  sd.position, 
  sd.parent_id, 
  sd.id_path, 
  sd.class 
FROM 
  cscart_static_data AS sd 
  LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id 
  AND cscart_static_data_descriptions.lang_code = 'en' 
WHERE 
  sd.section = 'A' 
  AND sd.status = 'A' 
  AND sd.param_5 = '2' 
ORDER BY 
  sd.position

Query time 0.00047

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sd ALL section 22 Using where; Using filesort
1 SIMPLE cscart_static_data_descriptions eq_ref PRIMARY PRIMARY 9 cscart_dev_4_16.sd.param_id,const 1 Using where

Result

param_id param descr param_2 param_3 param_4 param_5 param_6 status position parent_id id_path class
182 Catalog C:0:N 2 A 0 0 182 ty-menu-item__products
153 Electronics C:166:Y 2 A 20 0 153 ty-menu-item__electronics
194 Apparel C:223:Y 2 A 20 0 194 ty-menu-item__apparel
154 Sports & Outdoors C:203:Y 2 A 30 0 154 ty-menu-item__sport
155 Office Supplies C:250:Y 2 A 40 0 155 ty-menu-item__office
178 Media C:245:Y 2 A 45 0 178 ty-menu-item__media
159 product_features.view_all&filter_id=10 Brands 2 A 80 0 159 ty-menu-item__brands
195 products.newest Newest 2 A 90 0 195 ty-menu-item__newest
196 products.bestsellers Bestsellers 2 A 100 0 196 ty-menu-item__hits
162 products.on_sale Sales 2 A 110 0 162 ty-menu-item__sale
158 promotions.list Promotions 2 A 120 0 158 ty-menu-item__promotions