SELECT 
  a.variant_id, 
  a.option_id, 
  a.position, 
  a.modifier, 
  a.modifier_type, 
  a.weight_modifier, 
  a.weight_modifier_type, 
  a.nav_skus, 
  a.commercial_modifier, 
  a.commercial_dn, 
  a.same_as_option, 
  a.price_overrides, 
  a.base_cost, 
  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 = 'en' 
  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 = 1 
WHERE 
  a.option_id IN (
    22290, 22287, 22042, 21947, 22268, 22269, 
    22270, 22271, 22272, 22273, 22274, 
    22275, 21941, 22246
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00214

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "shared_option_variants",
      "access_type": "system",
      "possible_keys": ["PRIMARY", "company_id"],
      "rows": 0,
      "filtered": 0,
      "const_row_not_found": true
    },
    "read_sorted_file": {
      "filesort": {
        "sort_key": "a.position, a.variant_id",
        "table": {
          "table_name": "a",
          "access_type": "range",
          "possible_keys": ["option_id", "option_id_2", "status"],
          "key": "option_id",
          "key_length": "6",
          "used_key_parts": ["option_id", "status"],
          "rows": 195,
          "filtered": 100,
          "index_condition": "a.option_id in (22290,22287,22042,21947,22268,22269,22270,22271,22272,22273,22274,22275,21941,22246) and a.`status` = 'A'"
        }
      }
    },
    "table": {
      "table_name": "b",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["variant_id", "lang_code"],
      "ref": ["cscart_migrate.a.variant_id", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(b.lang_code = 'en')"
    }
  }
}

Result

variant_id option_id position modifier modifier_type weight_modifier weight_modifier_type nav_skus commercial_modifier commercial_dn same_as_option price_overrides base_cost variant_name
219820 22290 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
220110 22287 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
220135 22042 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220172 21947 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220200 22268 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220201 22269 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220202 22270 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220204 22272 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220206 22273 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220213 22271 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220310 22274 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220311 22275 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220318 21941 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220319 22246 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
215376 21941 3 0.000 A 0.000 A E26 0.00 0.00 0 0.00 E26
219225 22246 3 0.000 A 0.000 A 0.00 0.00 0 0.00 None
219568 22268 3 0.000 A 0.000 A 0.00 0.00 22042 0.00 Same as Shade
219582 22269 3 0.000 A 0.000 A 0.00 0.00 22042 0.00 Same as Shade
219614 22270 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
219648 22272 3 0.000 A 0.000 A 0.00 0.00 0 0.00 Standard Canopy
219651 22273 3 0.000 A 0.000 A 0.00 0.00 0 0.00 Standard Canopy
219654 22274 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
219656 22275 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
219785 22287 3 0.000 A 0.000 A FCC10 0.00 0.00 0 0.00 10" Shade
238867 21947 3 0.000 A 0.000 A ST506 0.00 0.00 0 0.00 6" Stem - ½" Diameter
215377 21941 5 14.000 A 0.000 A GU24 0.00 0.00 0 3.50 GU24
215452 21947 5 1.000 A 0.000 A ST706 0.00 0.00 0 0.18 6" Stem - ¾" Diameter
219583 22269 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
219615 22270 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
219645 22271 5 0.000 A 0.000 A 0.00 0.00 0 0.00 Standard Canopy
219649 22272 5 44.000 A 0.000 A HSC 0.00 0.00 0 0.00 25° Hang Straight Canopy
219655 22274 5 110.000 A 0.000 A DCHX 0.00 0.00 0 0.00 Copper Canopy & Hex Cover
219657 22275 5 121.000 A 0.000 A DCHX 0.00 0.00 0 0.00 Brass Canopy & Hex Cover
219786 22287 5 13.000 A 0.000 A FCC12 0.00 0.00 0 0.00 12" Shade
219821 22290 5 0.000 A 0.000 A 0.00 0.00 0 0.00 Standard Bulb E26/GU24
244918 22042 5 79.000 A 0.000 A M103 50.00 0.00 0 0.00 M103-Black
244934 22268 5 0.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
219227 22246 10 13.000 A 0.000 A 13.00 0.00 0 0.00 LED Clear ST19 - 31-4.5FSST19DIM/821
219584 22269 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
219616 22270 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
219646 22271 10 44.000 A 0.000 A HSC 0.00 0.00 0 0.00 25° Hang Straight Canopy
219650 22272 10 24.000 A 0.000 A HDSMC 0.00 0.00 0 0.00 Heavy Duty Canopy
219652 22273 10 44.000 A 0.000 A HSC 0.00 0.00 0 0.00 25° Hang Straight Canopy
219787 22287 10 24.000 A 0.000 A FCC15 0.00 0.00 0 0.00 15" Shade
219822 22290 10 0.000 A 0.000 A 0.00 0.00 0 0.00 Integrated LED
238868 21947 10 3.000 A 0.000 A ST512 0.00 0.00 0 0.56 12" Stem - ½" Diameter
244919 22042 10 79.000 A 0.000 A M200 50.00 0.00 0 0.00 M200-White
244935 22268 10 0.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
215454 21947 15 4.000 A 0.000 A ST712 0.00 0.00 0 0.92 12" Stem - ¾" Diameter
219585 22269 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
219617 22270 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
219647 22271 15 24.000 A 0.000 A HDSMC 0.00 0.00 0 0.00 Heavy Duty Canopy
219653 22273 15 24.000 A 0.000 A HDSMC 0.00 0.00 0 0.00 Heavy Duty Canopy
242997 22246 15 13.000 A 0.000 A 13.00 0.00 0 0.00 LED Amber ST19 - 31-4.5FSST19DIM/820/A
244920 22042 15 79.000 A 0.000 A M305 50.00 0.00 0 0.00 M305-Forest Green
244936 22268 15 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
219229 22246 20 14.000 A 0.000 A 20.00 0.00 0 0.00 LED Smoky ST19 - 31-4.5FSST19DIM/840/S
219586 22269 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
219618 22270 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
238869 21947 20 5.000 A 0.000 A ST518 0.00 0.00 0 1.12 18" Stem - ½" Diameter
244921 22042 20 79.000 A 0.000 A M603 50.00 0.00 0 0.00 M603-Brown
244937 22268 20 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
215456 21947 25 7.000 A 0.000 A ST718 0.00 0.00 0 1.67 18" Stem - ¾" Diameter
219587 22269 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
219619 22270 25 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
244922 22042 25 79.000 A 0.000 A M415 50.00 0.00 0 0.00 M415-Red
244938 22268 25 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
219588 22269 30 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
219620 22270 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
238870 21947 30 7.000 A 0.000 A ST524 0.00 0.00 0 1.69 24" Stem - ½" Diameter
244923 22042 30 79.000 A 0.000 A M315 50.00 0.00 0 0.00 M315-Seafoam
244939 22268 30 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
241078 22270 32 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
241079 22270 33 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
215458 21947 35 10.000 A 0.000 A ST724 0.00 0.00 0 2.41 24" Stem - ¾" Diameter
219589 22269 35 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
219621 22270 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
244924 22042 35 79.000 A 0.000 A M803 50.00 0.00 0 0.00 M803-Dark Grey
244940 22268 35 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
236946 22269 36 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
245313 22270 36 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
236947 22269 37 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
241073 22270 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
219590 22269 40 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
219622 22270 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
238871 21947 40 12.000 A 0.000 A ST536 0.00 0.00 0 2.81 36" Stem - ½" Diameter
244925 22042 40 79.000 A 0.000 A M210 50.00 0.00 0 0.00 M210-Cream
244941 22268 40 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
245309 22269 42 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
241068 22269 43 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
215460 21947 45 16.000 A 0.000 A ST736 0.00 0.00 0 3.90 36" Stem - ¾" Diameter
219591 22269 45 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
219623 22270 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
219592 22269 50 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
219624 22270 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
238872 21947 50 16.000 A 0.000 A ST548 0.00 0.00 0 3.93 48" Stem - ½" Diameter
215462 21947 55 22.000 A 0.000 A ST748 0.00 0.00 0 5.39 48" Stem - ¾" Diameter
217391 22042 55 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
219593 22269 55 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
219625 22270 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
217392 22042 60 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
219594 22269 60 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
219626 22270 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
241074 22270 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
217393 22042 65 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
219595 22269 65 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
219627 22270 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
241069 22269 68 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
217394 22042 70 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
219596 22269 70 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
219628 22270 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
217395 22042 75 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
219597 22269 75 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
219629 22270 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
217396 22042 80 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
219598 22269 80 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
219630 22270 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
236870 22042 82 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
236871 22042 83 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
217397 22042 85 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
219599 22269 85 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
219631 22270 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
245301 22042 86 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
241058 22042 87 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
219829 22042 88 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
217398 22042 90 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
219600 22269 90 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
219632 22270 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
217399 22042 95 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
219601 22269 95 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
219633 22270 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
217400 22042 100 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
219602 22269 100 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
219634 22270 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241075 22270 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
217401 22042 105 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
219603 22269 105 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
219635 22270 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
241059 22042 108 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241070 22269 108 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241076 22270 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
217402 22042 110 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
219604 22269 110 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
219636 22270 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
241071 22269 112 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
217403 22042 115 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
219605 22269 115 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
219637 22270 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
245314 22270 117 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245315 22270 118 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
217404 22042 120 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
219606 22269 120 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
219638 22270 120 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
245310 22269 121 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245311 22269 122 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
225919 22269 123 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
217405 22042 125 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
219607 22269 125 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
219639 22270 125 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
245316 22270 127 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241077 22270 128 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
217406 22042 130 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
219608 22269 130 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
219640 22270 130 93.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
245312 22269 133 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
217407 22042 135 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
219609 22269 135 93.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
219641 22270 135 93.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
241072 22269 135 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
217408 22042 140 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
219613 22269 140 93.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
219642 22270 140 93.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
217409 22042 145 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
219611 22269 145 93.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
219643 22270 145 93.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
241060 22042 148 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
217410 22042 150 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
219612 22269 150 93.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
219644 22270 150 93.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass
241061 22042 153 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
217411 22042 155 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
219610 22269 155 93.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass
217412 22042 160 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
245302 22042 161 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245303 22042 162 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
225914 22042 163 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
217413 22042 165 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
217414 22042 170 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
245304 22042 172 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241062 22042 173 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
217415 22042 175 160.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
217416 22042 180 200.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
217417 22042 185 250.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
217418 22042 190 210.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
217419 22042 195 250.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass