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 (
    22342, 21970, 22343, 22035, 22377, 23537, 
    21941, 22853, 23551, 22224, 23738
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00205

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": 182,
          "filtered": 100,
          "index_condition": "a.option_id in (22342,21970,22343,22035,22377,23537,21941,22853,23551,22224,23738) 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
218476 21970 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
220181 22035 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220212 22224 0 0.000 A 0.000 A unselected 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
220457 22342 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220462 22343 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220986 22377 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
227176 22853 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
236827 23537 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
237449 23551 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
239518 23738 0 0.000 A 0.000 A skip 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
215713 21970 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
217235 22035 3 0.000 A 0.000 A 0.00 0.00 21970 0.00 Same as Shade
227163 22853 3 0.000 A 0.000 A ST506 0.00 0.00 0 0.00 6" Stem - ½" Diameter
236823 23537 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
237418 23551 3 0.000 A 0.000 A 0.00 0.00 21970 0.00 Same as Shade
215377 21941 5 14.000 A 0.000 A GU24 0.00 0.00 0 3.50 GU24
215714 21970 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
217236 22035 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
219067 22224 5 0.000 A 0.000 A SC 0.00 0.00 0 0.00 Standard Canopy
220458 22342 5 0.000 A 0.000 A ASL9 0.00 0.00 0 0.00 9" Shade
220463 22343 5 11.000 A 0.000 A G26 0.00 0.00 0 0.00 G26 Gooseneck Arm
220987 22377 5 0.000 A 0.000 A 0.00 0.00 0 0.00 None
227164 22853 5 1.000 A 0.000 A ST706 0.00 0.00 0 0.18 6" Stem - ¾" Diameter
236824 23537 5 43.000 A 0.000 A DBPC 0.00 0.00 0 0.00 Decorative BP Cover
237419 23551 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
239519 23738 5 0.000 A 0.000 A 0.00 0.00 0 0.00 None
217264 22035 8 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
236828 23537 8 61.000 A 0.000 A DCHX 0.00 0.00 0 0.00 Decorative BP & Hex Cover
215715 21970 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
217237 22035 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
219068 22224 10 44.000 A 0.000 A HSC 0.00 0.00 0 0.00 25° Hang Straight Canopy
220459 22342 10 18.000 A 0.000 A ASL11 0.00 0.00 0 0.00 11" Shade
220464 22343 10 12.000 A 0.000 A G11 0.00 0.00 0 0.00 G11 Gooseneck Arm
220988 22377 10 36.000 A 0.000 A SWK 0.00 0.00 0 0.00 Swivel Knuckle
227165 22853 10 3.000 A 0.000 A ST512 0.00 0.00 0 0.56 12" Stem - ½" Diameter
236825 23537 10 92.000 A 0.000 A DD 0.00 0.00 0 0.00 Dusk-to-Dawn Photocell
237420 23551 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
239520 23738 10 36.000 A 0.000 A SWK 0.00 0.00 0 0.00 Swivel Knuckle
215716 21970 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
217238 22035 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
219069 22224 15 24.000 A 0.000 A HDSMC 0.00 0.00 0 0.00 Heavy Duty Canopy
220460 22342 15 36.000 A 0.000 A ASL13 0.00 0.00 0 0.00 13" Shade
220465 22343 15 15.000 A 0.000 A G15 0.00 0.00 0 0.00 G15 Gooseneck Arm
227166 22853 15 4.000 A 0.000 A ST712 0.00 0.00 0 0.92 12" Stem - ¾" Diameter
236826 23537 15 83.000 A 0.000 A HDBP 0.00 0.00 0 0.00 Heavy Duty BP
237421 23551 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
215738 21970 18 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
215731 21970 19 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
217239 22035 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
220461 22342 20 53.000 A 0.000 A ASL15 0.00 0.00 0 0.00 15" Shade
220466 22343 20 17.000 A 0.000 A G22 0.00 0.00 0 0.00 G22 Gooseneck Arm
227167 22853 20 5.000 A 0.000 A ST518 0.00 0.00 0 1.12 18" Stem - ½" Diameter
237422 23551 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
237036 21970 21 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237037 21970 22 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
215717 21970 24 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
217240 22035 25 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
220467 22343 25 14.000 A 0.000 A G8 0.00 0.00 0 0.00 G8 Gooseneck Arm
227168 22853 25 7.000 A 0.000 A ST718 0.00 0.00 0 1.67 18" Stem - ¾" Diameter
237423 23551 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
242135 21970 25 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
241141 21970 26 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
215718 21970 28 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
215719 21970 30 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
217241 22035 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
220468 22343 30 26.000 A 0.000 A G24 0.00 0.00 0 0.00 G24 Gooseneck Arm
227169 22853 30 7.000 A 0.000 A ST524 0.00 0.00 0 1.69 24" Stem - ½" Diameter
237424 23551 30 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
237038 22035 32 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237039 22035 33 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
215720 21970 35 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
217242 22035 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
220469 22343 35 26.000 A 0.000 A G6 0.00 0.00 0 0.00 G6 Gooseneck Arm
227170 22853 35 10.000 A 0.000 A ST724 0.00 0.00 0 2.41 24" Stem - ¾" Diameter
237425 23551 35 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
242657 22035 36 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
237450 23551 37 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237451 23551 38 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
241261 22035 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
215721 21970 40 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
217243 22035 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
227171 22853 40 12.000 A 0.000 A ST536 0.00 0.00 0 2.81 36" Stem - ½" Diameter
237426 23551 40 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
242139 23551 42 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
241226 23551 43 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
215722 21970 45 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
217244 22035 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
227172 22853 45 16.000 A 0.000 A ST736 0.00 0.00 0 3.90 36" Stem - ¾" Diameter
237427 23551 45 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
241142 21970 48 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
215723 21970 50 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
217245 22035 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
220472 22343 50 4.000 A 0.000 A G1 0.00 0.00 0 0.00 G1 Straight Arm
227173 22853 50 16.000 A 0.000 A ST548 0.00 0.00 0 3.93 48" Stem - ½" Diameter
237428 23551 50 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
215724 21970 55 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
217246 22035 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
220473 22343 55 4.000 A 0.000 A G14 0.00 0.00 0 0.00 G14 Straight Arm
227174 22853 55 22.000 A 0.000 A ST748 0.00 0.00 0 5.39 48" Stem - ¾" Diameter
237429 23551 55 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
215725 21970 60 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
217247 22035 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
220474 22343 60 2.000 A 0.000 A G16 0.00 0.00 0 0.00 G16 Straight Arm
237430 23551 60 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
241262 22035 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
215726 21970 65 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
217248 22035 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
220475 22343 65 2.000 A 0.000 A G17 0.00 0.00 0 0.00 G17 Straight Arm
237431 23551 65 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
241227 23551 68 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
215727 21970 70 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
217249 22035 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
220476 22343 70 26.000 A 0.000 A G35 0.00 0.00 0 0.00 G35 Gooseneck Arm
237432 23551 70 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
215728 21970 75 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
217250 22035 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
220477 22343 75 30.000 A 0.000 A G34 0.00 0.00 0 0.00 G34 Gooseneck Arm
237433 23551 75 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
215729 21970 80 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
217251 22035 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
220478 22343 80 16.000 A 0.000 A G5 0.00 0.00 0 0.00 G5 Gooseneck Arm
237434 23551 80 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
215730 21970 85 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
217252 22035 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
220479 22343 85 21.000 A 0.000 A G25 0.00 0.00 0 0.00 G25 Gooseneck Arm
237435 23551 85 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
217253 22035 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
220480 22343 90 28.000 A 0.000 A G10 0.00 0.00 0 0.00 G10 Gooseneck Arm
237436 23551 90 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
241143 21970 90 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
215732 21970 95 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
217254 22035 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
220481 22343 95 97.000 A 0.000 A G19 0.00 0.00 0 0.00 G19 Gooseneck Arm
237437 23551 95 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
241144 21970 98 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
215733 21970 100 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
217255 22035 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
220482 22343 100 190.000 A 0.000 A G65 0.00 0.00 0 0.00 G65 Gooseneck Arm
237438 23551 100 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
241263 22035 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
215734 21970 105 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
217256 22035 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
220483 22343 105 158.000 A 0.000 A G64 0.00 0.00 0 0.00 G64 Gooseneck Arm
237439 23551 105 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241228 23551 108 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241264 22035 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
215735 21970 110 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
217257 22035 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
220484 22343 110 8.000 A 0.000 A G12 0.00 0.00 0 0.00 G12 Gooseneck Arm
237440 23551 110 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
242136 21970 112 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
241229 23551 113 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
242137 21970 113 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
215736 21970 115 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
217258 22035 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
220485 22343 115 10.000 A 0.000 A G13 0.00 0.00 0 0.00 G13 Gooseneck Arm
237441 23551 115 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
242658 22035 116 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242659 22035 117 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
243002 22035 118 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
230712 22035 119 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
215737 21970 120 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
217259 22035 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
220486 22343 120 23.000 A 0.000 A G32 0.00 0.00 0 0.00 G32 Gooseneck Arm
237442 23551 120 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
242660 22035 122 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241265 22035 123 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
242138 21970 123 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
242140 23551 123 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242141 23551 124 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
220487 22343 125 35.000 A 0.000 A G2 0.00 0.00 0 0.00 G2 Gooseneck Arm
237443 23551 125 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
241145 21970 125 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
220488 22343 130 39.000 A 0.000 A G36 0.00 0.00 0 0.00 G36 Gooseneck Arm
220489 22343 135 25.000 A 0.000 A G7 0.00 0.00 0 0.00 G7 Gooseneck Arm
237444 23551 135 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
242142 23551 136 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241230 23551 138 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
220490 22343 140 32.000 A 0.000 A G9 0.00 0.00 0 0.00 G9 Gooseneck Arm
220491 22343 145 141.000 A 0.000 A G40 0.00 0.00 0 0.00 G40 Gooseneck Arm