SELECT 
  cscart_product_feature_variants.variant_id, 
  cscart_product_feature_variants.position, 
  cscart_product_feature_variants.color, 
  cscart_product_feature_variant_descriptions.variant 
FROM 
  cscart_product_feature_variants 
  LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variants.variant_id = cscart_product_feature_variant_descriptions.variant_id 
  AND cscart_product_feature_variant_descriptions.lang_code = 'en' 
WHERE 
  cscart_product_feature_variants.variant_id IN (
    121, 
    87, 
    21682, 
    21703, 
    18902, 
    18937, 
    18940, 
    18943, 
    22756, 
    22766, 
    22778, 
    22785, 
    22797, 
    21673, 
    21739, 
    23265, 
    22796, 
    21727, 
    19358, 
    22902, 
    22903, 
    21677, 
    21731, 
    18936, 
    19015, 
    19242, 
    19288, 
    23267, 
    23269, 
    23270, 
    23298, 
    23299, 
    23300, 
    23301, 
    23302, 
    19377, 
    22782, 
    22809, 
    22836, 
    22868, 
    21676, 
    21804, 
    18934, 
    23340, 
    20257, 
    22753, 
    22768, 
    22780, 
    22800, 
    22828, 
    21765, 
    18903, 
    18933, 
    18942, 
    19227, 
    23208, 
    23268, 
    23333, 
    23336, 
    23420, 
    23421, 
    23422, 
    23423, 
    23424, 
    19824, 
    22755, 
    22774, 
    22784, 
    22798, 
    22827, 
    22835, 
    22867, 
    22871, 
    21675, 
    21733, 
    18941, 
    19002, 
    23209, 
    19383, 
    19375, 
    22801, 
    22869, 
    23303, 
    21725, 
    21658, 
    21882, 
    21670, 
    18938, 
    21669, 
    21615, 
    22401, 
    19254, 
    23189, 
    23320, 
    22770, 
    23002, 
    23005, 
    23319, 
    23326, 
    19253, 
    23264, 
    23329, 
    23330, 
    23331, 
    23332, 
    23334, 
    23335, 
    22763, 
    22786, 
    22870, 
    23000, 
    21557, 
    22623, 
    19239, 
    19245, 
    23006, 
    21545, 
    21605, 
    21607, 
    18900, 
    22582, 
    18848, 
    21563, 
    21564, 
    21722, 
    21549, 
    21601, 
    21702, 
    23040, 
    18866, 
    18860, 
    22773, 
    23035, 
    18817, 
    22775, 
    21602, 
    18882, 
    22769, 
    21717, 
    21599, 
    23042, 
    23368, 
    23004, 
    23378, 
    18816, 
    23321, 
    23341, 
    23349, 
    22724, 
    22779, 
    23350, 
    23034, 
    23046, 
    21574, 
    23367, 
    23043, 
    21710, 
    23375, 
    22781, 
    23377, 
    23407, 
    21572, 
    21761, 
    19046, 
    19198, 
    23057, 
    23066, 
    23401
  ) 
ORDER BY 
  cscart_product_feature_variants.position ASC, 
  cscart_product_feature_variant_descriptions.variant ASC

Query time 0.00180

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "604.81"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_product_feature_variants",
            "access_type": "range",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "variant_id"
            ],
            "key_length": "3",
            "rows_examined_per_scan": 168,
            "rows_produced_per_join": 168,
            "filtered": "100.00",
            "index_condition": "(`danishecarter_latest`.`cscart_product_feature_variants`.`variant_id` in (121,87,21682,21703,18902,18937,18940,18943,22756,22766,22778,22785,22797,21673,21739,23265,22796,21727,19358,22902,22903,21677,21731,18936,19015,19242,19288,23267,23269,23270,23298,23299,23300,23301,23302,19377,22782,22809,22836,22868,21676,21804,18934,23340,20257,22753,22768,22780,22800,22828,21765,18903,18933,18942,19227,23208,23268,23333,23336,23420,23421,23422,23423,23424,19824,22755,22774,22784,22798,22827,22835,22867,22871,21675,21733,18941,19002,23209,19383,19375,22801,22869,23303,21725,21658,21882,21670,18938,21669,21615,22401,19254,23189,23320,22770,23002,23005,23319,23326,19253,23264,23329,23330,23331,23332,23334,23335,22763,22786,22870,23000,21557,22623,19239,19245,23006,21545,21605,21607,18900,22582,18848,21563,21564,21722,21549,21601,21702,23040,18866,18860,22773,23035,18817,22775,21602,18882,22769,21717,21599,23042,23368,23004,23378,18816,23321,23341,23349,22724,22779,23350,23034,23046,21574,23367,23043,21710,23375,22781,23377,23407,21572,21761,19046,19198,23057,23066,23401))",
            "cost_info": {
              "read_cost": "369.61",
              "eval_cost": "33.60",
              "prefix_cost": "403.21",
              "data_read_per_join": "443K"
            },
            "used_columns": [
              "variant_id",
              "color",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_product_feature_variant_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "variant_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "danishecarter_latest.cscart_product_feature_variants.variant_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 168,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "168.00",
              "eval_cost": "33.60",
              "prefix_cost": "604.81",
              "data_read_per_join": "507K"
            },
            "used_columns": [
              "variant_id",
              "variant",
              "lang_code"
            ]
          }
        }
      ]
    }
  }
}