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 (
    38299, 
    59741, 
    59742, 
    59743, 
    59744, 
    59745, 
    59746, 
    59747, 
    59748, 
    59749, 
    59750, 
    59751, 
    59752, 
    59753, 
    59754, 
    59755, 
    59756, 
    59757, 
    59758, 
    59759, 
    59760, 
    59763, 
    59704, 
    59777, 
    59778, 
    59779, 
    59780, 
    59832, 
    59833, 
    59834, 
    59835, 
    59836, 
    59837, 
    59838, 
    59842, 
    59843, 
    59844, 
    59845, 
    59846, 
    59847, 
    59848, 
    59849, 
    59850, 
    59851, 
    59852, 
    59853, 
    59854, 
    59855, 
    59856, 
    59857, 
    59858, 
    59859, 
    59860, 
    59861, 
    59862, 
    59863, 
    59864, 
    59865, 
    59866, 
    59867, 
    59868, 
    59869, 
    59870, 
    59871, 
    59872, 
    59873, 
    59874, 
    59875, 
    59876, 
    59877, 
    59878, 
    59879, 
    59880, 
    59881, 
    59882, 
    59883, 
    59884, 
    59885, 
    59886, 
    59887, 
    59888, 
    59889, 
    59890, 
    59891, 
    59892, 
    59893, 
    59894, 
    59895, 
    59896, 
    59897, 
    59898, 
    59899, 
    59900, 
    59901, 
    59902, 
    59903, 
    59904, 
    59905, 
    59906, 
    59907, 
    59908, 
    59909, 
    59910, 
    59911, 
    59912, 
    59913, 
    59914, 
    59915, 
    59916, 
    59917, 
    59918, 
    59919, 
    59920, 
    59921, 
    59922, 
    59923, 
    59924, 
    59925, 
    59926, 
    59927, 
    59928, 
    59929, 
    59930, 
    59931, 
    61614, 
    59932, 
    59933, 
    59934, 
    59935, 
    59936, 
    59937, 
    59938, 
    59939, 
    59940, 
    59941, 
    62744, 
    59737, 
    60119, 
    0, 
    63634, 
    38218, 
    63631, 
    64046, 
    59712, 
    64077, 
    67803, 
    67813
  ) 
ORDER BY 
  cscart_product_feature_variants.position ASC, 
  cscart_product_feature_variant_descriptions.variant ASC

Query time 0.00384

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "382.39"
    },
    "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": 147,
            "rows_produced_per_join": 147,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "176.59",
              "eval_cost": "29.40",
              "prefix_cost": "205.99",
              "data_read_per_join": "167K"
            },
            "used_columns": [
              "variant_id",
              "color",
              "position"
            ],
            "attached_condition": "(`webmarco`.`cscart_product_feature_variants`.`variant_id` in (38299,59741,59742,59743,59744,59745,59746,59747,59748,59749,59750,59751,59752,59753,59754,59755,59756,59757,59758,59759,59760,59763,59704,59777,59778,59779,59780,59832,59833,59834,59835,59836,59837,59838,59842,59843,59844,59845,59846,59847,59848,59849,59850,59851,59852,59853,59854,59855,59856,59857,59858,59859,59860,59861,59862,59863,59864,59865,59866,59867,59868,59869,59870,59871,59872,59873,59874,59875,59876,59877,59878,59879,59880,59881,59882,59883,59884,59885,59886,59887,59888,59889,59890,59891,59892,59893,59894,59895,59896,59897,59898,59899,59900,59901,59902,59903,59904,59905,59906,59907,59908,59909,59910,59911,59912,59913,59914,59915,59916,59917,59918,59919,59920,59921,59922,59923,59924,59925,59926,59927,59928,59929,59930,59931,61614,59932,59933,59934,59935,59936,59937,59938,59939,59940,59941,62744,59737,60119,0,63634,38218,63631,64046,59712,64077,67803,67813))"
          }
        },
        {
          "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": [
              "webmarco.cscart_product_feature_variants.variant_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 147,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "147.00",
              "eval_cost": "29.40",
              "prefix_cost": "382.39",
              "data_read_per_join": "663K"
            },
            "used_columns": [
              "variant_id",
              "variant",
              "lang_code"
            ]
          }
        }
      ]
    }
  }
}