SELECT 
  a.variant_id, 
  a.option_id, 
  a.position, 
  a.modifier, 
  a.modifier_type, 
  a.weight_modifier, 
  a.weight_modifier_type, 
  b.variant_name, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier, 
    a.modifier
  ) as modifier, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier_type, 
    a.modifier_type
  ) as modifier_type 
FROM 
  cscart_product_option_variants as a 
  LEFT JOIN cscart_product_option_variants_descriptions as b ON a.variant_id = b.variant_id 
  AND b.lang_code = 'fr' 
  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id 
  AND shared_option_variants.company_id = 3 
WHERE 
  a.option_id IN (
    599, 1355, 625, 602, 713, 1352, 1354, 
    1353, 607, 711, 629, 612, 610, 611, 684
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00197

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a range status,option_id,option_id_2 option_id 6 183 Using index condition; Using filesort
1 SIMPLE b eq_ref PRIMARY PRIMARY 9 mahm3t_cs443.a.variant_id,const 1 Using where
1 SIMPLE shared_option_variants eq_ref PRIMARY,company_id PRIMARY 7 mahm3t_cs443.a.variant_id,const 1

Result

variant_id option_id position modifier modifier_type weight_modifier weight_modifier_type variant_name
14970 602 0 0.000 A 0.000 A 50x80 cm
15022 607 0 0.000 A 0.000 A LXL-P 70x140 cm
15071 611 1 0.000 A 0.000 A jusqu’à 100 cm
16441 607 1 0.000 A 0.000 A LXL-P 86x144 cm
15072 611 2 0.000 A 0.000 A dépasse 100 cm
14972 602 10 0.000 A 0.000 A 60x90 cm
15023 607 10 0.000 A 0.000 A LXL-W 70x140 cm
15062 610 10 0.000 A 0.000 A LWS Plus
15219 629 10 0.000 A 0.000 A Fakro LWS
16442 607 11 0.000 A 0.000 A LXL-W 86x144 cm
14973 602 15 0.000 A 0.000 A 60x120 cm
15220 629 15 0.000 A 0.000 A Fakro LWK
14974 602 20 0.000 A 0.000 A 70x80 cm
15024 607 20 0.000 A 0.000 A LXL-PVC 60x120 cm
15063 610 20 0.000 A 0.000 A LWK Plus
15221 629 20 0.000 A 0.000 A Fakro LWZ
15222 629 25 0.000 A 0.000 A Fakro LWL
15885 711 27 0.000 A 0.000 A 270-300 cm
15890 713 28 0.000 A 0.000 A 250-280 cm
15025 607 30 0.000 A 0.000 A LXL-PVC 70x120 cm
15064 610 30 0.000 A 0.000 A LWZ
15223 629 30 0.000 A 0.000 A Fakro LTK
15886 711 30 0.000 A 0.000 A 301-320 cm
15891 713 30 0.000 A 0.000 A 281-300 cm
15892 713 33 0.000 A 0.000 A 301-330 cm
14977 602 35 0.000 A 0.000 A 70x120 cm
15224 629 35 0.000 A 0.000 A Fakro LWT
15026 607 40 0.000 A 0.000 A LXL-PVC 86x140 cm
15065 610 40 0.000 A 0.000 A LTK Thermo
15225 629 40 0.000 A 0.000 A Fakro LWF
16443 607 41 0.000 A 0.000 A LXL-PVC 86x144 cm
15066 610 50 0.000 A 0.000 A LWT
15073 612 51 0.000 A 0.000 A 51x80 cm
15074 612 55 0.000 A 0.000 A 55x111 cm
15067 610 60 0.000 A 0.000 A LWF
15068 610 70 0.000 A 0.000 A LDK
15069 610 80 0.000 A 0.000 A LMS Smart
15070 610 90 0.000 A 0.000 A LMK Komfort
15192 625 100 0.000 A 0.000 A 55x111 h=280 cm
24247 1355 100 0.000 A 0.000 A 60x120 h=280 cm
15226 629 105 0.000 A 0.000 A Fakro LDK
24240 1354 200 0.000 A 0.000 A 60x120 h=280 cm
24248 1355 200 0.000 A 0.000 A 70x120 h=280 cm
15227 629 205 0.000 A 0.000 A Fakro LMS
15194 625 210 0.000 A 0.000 A 60x100 h=280 cm
15228 629 210 0.000 A 0.000 A Fakro LMK
24216 599 210 0.000 A 0.000 A 55x111 h=280 cm
15229 629 215 0.000 A 0.000 A Fakro LML
15230 629 220 0.000 A 0.000 A Fakro LMF
24213 599 220 0.000 A 0.000 A 60x94 h=280 cm
24244 1354 220 0.000 A 0.000 A 60x130 h=305 cm
24207 599 225 0.000 A 0.000 A 60x100 h=280 cm
24212 599 227 0.000 A 0.000 A 60x111 h=280 cm
14926 599 230 0.000 A 0.000 A 60x120 h=280 cm
15196 625 230 0.000 A 0.000 A 60x120 h=280 cm
15645 684 230 0.000 A 0.000 A 62x122 h=280 cm
24211 599 235 0.000 A 0.000 A 60x130 h=280 cm
24204 599 240 0.000 A 0.000 A 60x130 h=305 cm
15198 625 241 0.000 A 0.000 A 60x130 h=305 cm
15647 684 241 0.000 A 0.000 A 62x132 h=305 cm
24217 599 242 0.000 A 0.000 A 60x140 h=305 cm
24215 599 243 0.000 A 0.000 A 70x94 h=280 cm
24209 599 245 0.000 A 0.000 A 70x100 h=280 cm
24214 599 250 0.000 A 0.000 A 70x111 h=280 cm
24241 1354 300 0.000 A 0.000 A 70x120 h=280 cm
15231 629 305 0.000 A 0.000 A Fakro LST
15201 625 310 0.000 A 0.000 A 70x100 h=280 cm
15232 629 310 0.000 A 0.000 A Fakro LSZ
15233 629 320 0.000 A 0.000 A Fakro LSF
14932 599 330 0.000 A 0.000 A 70x120 h=280 cm
15202 625 330 0.000 A 0.000 A 70x120 h=280 cm
15652 684 330 0.000 A 0.000 A 72x122 h=280 cm
14933 599 340 0.000 A 0.000 A 70x130 h=280 cm
15203 625 340 0.000 A 0.000 A 70x130 h=280 cm
15653 684 340 0.000 A 0.000 A 72x132 h=280 cm
14934 599 341 0.000 A 0.000 A 70x130 h=305 cm
15204 625 341 0.000 A 0.000 A 70x130 h=305 cm
15654 684 341 0.000 A 0.000 A 72x132 h=305 cm
14935 599 350 0.000 A 0.000 A 70x140 h=280 cm
15205 625 350 0.000 A 0.000 A 70x140 h=280 cm
15655 684 350 0.000 A 0.000 A 72x142 h=280 cm
14936 599 351 0.000 A 0.000 A 70x140 h=305 cm
15206 625 351 0.000 A 0.000 A 70x140 h=305 cm
15656 684 351 0.000 A 0.000 A 72x142 h=305 cm
24201 625 352 0.000 A 0.000 A 80x120 h=280 cm
24208 599 352 0.000 A 0.000 A 80x120 h=280 cm
24242 1354 400 0.000 A 0.000 A 70x130 h=280 cm
24245 1354 450 0.000 A 0.000 A 70x130 h=305 cm
24243 1354 500 0.000 A 0.000 A 70x140 h=280 cm
24225 1352 510 0.000 A 0.000 A 55x100 h=280 cm
24235 1353 510 0.000 A 0.000 A 55x100 h=280 cm
24246 1354 550 0.000 A 0.000 A 70x140 h=305 cm
15075 612 600 0.000 A 0.000 A 60x90 cm
15076 612 605 0.000 A 0.000 A 60x94 cm
15077 612 610 0.000 A 0.000 A 60x100 cm
24219 1352 610 0.000 A 0.000 A 60x100 h=280 cm
24230 1353 610 0.000 A 0.000 A 60x100 h=280 cm
15078 612 615 0.000 A 0.000 A 60x111 cm
15079 612 620 0.000 A 0.000 A 60x120 cm
24218 1352 620 0.000 A 0.000 A 60x120 h=280 cm
24229 1353 620 0.000 A 0.000 A 60x120 h=280 cm
15080 612 625 0.000 A 0.000 A 60x130 cm
15081 612 630 0.000 A 0.000 A 60x140 cm
24226 1352 630 0.000 A 0.000 A 60x130 h=305 cm
15082 612 700 0.000 A 0.000 A 70x80 cm
15083 612 705 0.000 A 0.000 A 70x94 cm
15084 612 710 0.000 A 0.000 A 70x100 cm
24224 1352 710 0.000 A 0.000 A 70x100 h=280 cm
24234 1353 710 0.000 A 0.000 A 70x100 h=280 cm
15085 612 715 0.000 A 0.000 A 70x111 cm
15086 612 720 0.000 A 0.000 A 70x120 cm
24220 1352 720 0.000 A 0.000 A 70x120 h=280 cm
24231 1353 720 0.000 A 0.000 A 70x120 h=280 cm
15087 612 725 0.000 A 0.000 A 70x130 cm
15088 612 730 0.000 A 0.000 A 70x140 cm
24221 1352 730 0.000 A 0.000 A 70x130 h=280 cm
24232 1353 730 0.000 A 0.000 A 70x130 h=280 cm
24227 1352 740 0.000 A 0.000 A 70x130 h=305 cm
24236 1353 740 0.000 A 0.000 A 70x130 h=305 cm
24222 1352 750 0.000 A 0.000 A 70x140 h=280 cm
24233 1353 750 0.000 A 0.000 A 70x140 h=280 cm
24228 1352 760 0.000 A 0.000 A 70x140 h=305 cm
24237 1353 760 0.000 A 0.000 A 70x140 h=305 cm
15089 612 805 0.000 A 0.000 A 86x130 cm
24223 1352 810 0.000 A 0.000 A 80x120 h=280 cm
24238 1353 810 0.000 A 0.000 A 86x130 h=280 cm
24239 1353 820 0.000 A 0.000 A 86x130 h=305 cm