SELECT 
  sd.param_id, 
  sd.param, 
  cscart_static_data_descriptions.descr, 
  sd.param_2, 
  sd.param_3, 
  sd.param_4, 
  sd.param_5, 
  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 = '9' 
ORDER BY 
  sd.position

Query time 0.00095

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

Result

param_id param descr param_2 param_3 param_4 param_5 status position parent_id id_path class
271 VELUX C:480:Y 9 A 10 276 261/276/271
261 https://www.byggbay.se/index.php?dispatch=categories.view&category_id=261 Roof windows 9 A 10 0 261
276 Brand 9 A 10 261 261/276
293 PVC C:949:Y 9 A 10 289 261/289/293
295 Double glazing C:950:Y 9 A 10 290 261/290/295
298 Centre-pivot (top control bar) C:953:Y 9 A 10 291 261/291/298
303 Flashings C:959:Y 9 A 10 292 261/292/303
323 For heated rooms C:933:Y 9 A 10 262 262/323
346 Compatible with 9 A 10 263 263/346
350 VELUX C:365:Y 9 A 10 346 263/346/350
356 Blackout blinds C:989:Y 9 A 10 347 263/347/356
361 Awning blinds C:994:Y 9 A 10 348 263/348/361
363 Telescopic poles C:996:Y 9 A 10 349 263/349/363
296 Triple glazing C:951:Y 9 A 20 290 261/290/296
262 https://www.byggbay.se/index.php?dispatch=categories.view&category_id=368 Roof Access Windows 9 A 20 0 262
289 Material 9 A 20 261 261/289
272 FAKRO C:263:Y 9 A 20 276 261/276/272
294 Wood C:948:Y 9 A 20 289 261/289/294
299 Centre-pivot (bottom handle) C:954:Y 9 A 20 291 261/291/299
304 Installation accessories C:958:Y 9 A 20 292 261/292/304
324 For unheated rooms C:934:Y 9 A 20 262 262/324
347 Interior accessories 9 A 20 263 263/347
351 FAKRO C:359:Y 9 A 20 346 263/346/351
357 Decorative blinds C:990:Y 9 A 20 347 263/347/357
362 Shutters C:995:Y 9 A 20 348 263/348/362
364 Remaining C:997:Y 9 A 20 349 263/349/364
263 https://www.byggbay.se/index.php?dispatch=categories.view&category_id=901 Roof Window Accessories 9 A 30 0 263
290 Glazing 9 A 30 261 261/290
274 OptiLight C:926:Y 9 A 30 276 261/276/274
297 Quadruple glazing C:952:Y 9 A 30 290 261/290/297
300 High pivot C:955:Y 9 A 30 291 261/291/300
305 Additional products C:960:Y 9 A 30 292 261/292/305
348 Exterior accessories 9 A 30 263 263/348
352 OptiLight C:986:Y 9 A 30 346 263/346/352
358 Pleated blinds C:991:Y 9 A 30 347 263/347/358
264 https://www.byggbay.se/foenster/ Windows C:281:N 9 A 40 0 264
291 Opening 9 A 40 261 261/291
273 RoofLITE+ C:923:Y 9 A 40 276 261/276/273
301 Top-hung C:956:Y 9 A 40 291 261/291/301
349 Other 9 A 40 263 263/349
353 RoofLITE+ C:369:Y 9 A 40 346 263/346/353
359 Venetian blind C:992:Y 9 A 40 347 263/347/359
265 https://www.byggbay.se/murning/ Brickwork C:257:N 9 A 50 0 265
292 Installation & Accessories 9 A 50 261 261/292
275 SkyLight C:928:Y 9 A 50 276 261/276/275
302 Top-hung - pivot C:957:Y 9 A 50 291 261/291/302
354 SkyLight C:987:Y 9 A 50 346 263/346/354
360 Insect screens C:993:Y 9 A 50 347 263/347/360
266 https://www.byggbay.se/tak/ Roof C:260:N 9 A 60 0 266
284 ROTO C:903:Y 9 A 60 276 261/276/284
355 Roto C:988:Y 9 A 60 346 263/346/355
267 https://www.byggbay.se/isolering/ Insulation C:258:N 9 A 70 0 267
268 https://www.byggbay.se/interioer/ Interior C:386:N 9 A 80 0 268
269 https://www.byggbay.se/dekoration/ Decoration C:500:N 9 A 90 0 269