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 = '7' 
ORDER BY 
  sd.position

Query time 0.00390

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sd ALL section 221 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
218 https://www.baubay.de/index.php?dispatch=categories.view&category_id=412 Roof windows 7 A 10 0 218
226 VELUX C:482:Y 7 A 10 231 218/231/226
231 Brand 7 A 10 218 218/231
248 Kaltdach C:932:Y 7 A 10 247 247/248
235 Double glazing C:939:Y 7 A 10 236 218/236/235
239 PVC C:937:Y 7 A 10 238 218/238/239
242 Top-operated pivot C:943:Y 7 A 10 241 218/241/242
286 Flashings C:461:Y 7 A 10 285 218/285/286
327 Compatible with 7 A 10 219 219/327
328 VELUX C:898:Y 7 A 10 327 219/327/328
335 Blackout blinds C:977:Y 7 A 10 334 219/334/335
341 Awning blinds C:982:Y 7 A 10 340 219/340/341
344 Telescopic poles C:984:Y 7 A 10 343 219/343/344
385 Building Blocks C:422:Y 7 A 10 221 221/385
227 FAKRO C:432:Y 7 A 20 231 218/231/227
237 Triple glazing C:940:Y 7 A 20 236 218/236/237
238 Material 7 A 20 218 218/238
240 Wood C:938:Y 7 A 20 238 218/238/240
243 Bottom-operated pivot C:942:Y 7 A 20 241 218/241/243
247 https://www.baubay.de/index.php?dispatch=categories.view&category_id=452 Roof Access Windows 7 A 20 0 247
249 Warmdach C:931:Y 7 A 20 247 247/249
287 Installation accessories C:947:Y 7 A 20 285 218/285/287
329 FAKRO C:899:Y 7 A 20 327 219/327/329
334 Interior accessories 7 A 20 219 219/334
336 Decorative blinds C:978:Y 7 A 20 334 219/334/336
342 Shutters C:983:Y 7 A 20 340 219/340/342
345 Remaining C:985:Y 7 A 20 343 219/343/345
219 https://www.baubay.de/index.php?dispatch=categories.view&category_id=897 Roof Window Accessories 7 A 30 0 219
236 Glazing 7 A 30 218 218/236
245 High pivot C:944:Y 7 A 30 241 218/241/245
250 OptiLight C:925:Y 7 A 30 231 218/231/250
270 Quadruple glazing C:941:Y 7 A 30 236 218/236/270
288 Additional products C:468:Y 7 A 30 285 218/285/288
330 OptiLight (FAKRO Konzern) C:974:Y 7 A 30 327 219/327/330
337 Pleated blinds C:979:Y 7 A 30 334 219/334/337
340 Exterior accessories 7 A 30 219 219/340
220 Fenster C:513:Y 7 A 40 0 220
232 RoofLITE+ C:922:Y 7 A 40 231 218/231/232
241 Opening 7 A 40 218 218/241
246 Top-hung C:945:Y 7 A 40 241 218/241/246
331 RoofLITE+ (VELUX Konzern) C:900:Y 7 A 40 327 219/327/331
338 Venetian blind C:980:Y 7 A 40 334 219/334/338
343 Other 7 A 40 219 219/343
221 https://www.baubay.de/index.php?dispatch=categories.view&category_id=413 Brickwork 7 A 50 0 221
234 SkyLight C:929:Y 7 A 50 231 218/231/234
244 Top-hung and pivot C:946:Y 7 A 50 241 218/241/244
285 Installation & Accessories 7 A 50 218 218/285
332 SkyLight (ARBONIA Switzerland) C:975:Y 7 A 50 327 219/327/332
339 Insect screens C:981:Y 7 A 50 334 219/334/339
386 Construction chemicals C:424:Y 7 A 55 0 386
222 Dach C:414:Y 7 A 60 0 222
228 ROTO C:890:Y 7 A 60 231 218/231/228
333 Roto C:976:Y 7 A 60 327 219/327/333
223 Dämmung C:415:Y 7 A 70 0 223
224 Innenausbau C:416:Y 7 A 80 0 224
225 Dekoration C:501:Y 7 A 90 0 225