SELECT 
  q_product_feature_variants.variant_id, 
  q_product_feature_variants.position, 
  q_product_feature_variants.color, 
  q_product_feature_variant_descriptions.variant 
FROM 
  q_product_feature_variants 
  LEFT JOIN q_product_feature_variant_descriptions ON q_product_feature_variants.variant_id = q_product_feature_variant_descriptions.variant_id 
  AND q_product_feature_variant_descriptions.lang_code = 'en' 
WHERE 
  q_product_feature_variants.variant_id IN (
    183, 
    211, 
    229, 
    237, 
    242, 
    5862, 
    5910, 
    5913, 
    5916, 
    6010, 
    6011, 
    6153, 
    6439, 
    6533, 
    6536, 
    6539, 
    6541, 
    6542, 
    6548, 
    6550, 
    6551, 
    6553, 
    6555, 
    6556, 
    6557, 
    6559, 
    6562, 
    6564, 
    6567, 
    6568, 
    6570, 
    6572, 
    6578, 
    6580, 
    6581, 
    6582, 
    6584, 
    6587, 
    6589, 
    6590, 
    6592, 
    6594, 
    6597, 
    6600, 
    6610, 
    6613, 
    6617, 
    6618, 
    6621, 
    6622, 
    6625, 
    6627, 
    6628, 
    6629, 
    6630, 
    6634, 
    6635, 
    6636, 
    6637, 
    6638, 
    6641, 
    6642, 
    6645, 
    6646, 
    6650, 
    6651, 
    6653, 
    6654, 
    6657, 
    6659, 
    6664, 
    6666, 
    6667, 
    6669, 
    6672, 
    6674, 
    6675, 
    6676, 
    6679, 
    6682, 
    6688, 
    6690, 
    6691, 
    6693, 
    6695, 
    6718, 
    6719, 
    6720, 
    6721, 
    6724, 
    6727, 
    6729, 
    6732, 
    6734, 
    6735, 
    6736, 
    6746, 
    6748, 
    6751, 
    6753, 
    6755, 
    6757, 
    6765, 
    6827, 
    6840, 
    6861, 
    6866, 
    6867, 
    6868, 
    6872, 
    6874, 
    6876, 
    6878, 
    6879, 
    6884, 
    6889, 
    6892, 
    6896, 
    6900, 
    6901, 
    6910, 
    6915, 
    6922, 
    6924, 
    6926, 
    6928, 
    6934, 
    6936, 
    6938, 
    6941, 
    6943, 
    6945, 
    6946, 
    6947, 
    6948, 
    6949, 
    6951, 
    6953, 
    6956, 
    6958, 
    6959, 
    6960, 
    6966, 
    6996, 
    7002, 
    7005, 
    7009, 
    7010, 
    7013, 
    7014, 
    7029, 
    7034, 
    7037, 
    7040, 
    7047, 
    7051, 
    7053, 
    7063, 
    7064, 
    7065, 
    7069, 
    7075, 
    7077, 
    7105, 
    7107, 
    7111, 
    7117, 
    7118, 
    7120, 
    7123, 
    7125, 
    7129, 
    7131, 
    7133, 
    7136, 
    7140, 
    7142, 
    7148, 
    7151, 
    7152, 
    7153, 
    7154, 
    7157, 
    7158, 
    7177, 
    7181, 
    7182, 
    7187, 
    7190, 
    7191, 
    7192, 
    7193, 
    7194, 
    7197, 
    7198, 
    7199, 
    7201, 
    7202, 
    7203, 
    7204, 
    7207, 
    7208, 
    7210, 
    7226, 
    7233, 
    7234, 
    7238, 
    7242, 
    7243, 
    7244, 
    7246, 
    7249, 
    7251, 
    7253, 
    7263, 
    7264, 
    7265, 
    7266, 
    7282, 
    7284, 
    7287, 
    7288, 
    7291, 
    7295, 
    7297, 
    7300, 
    7301, 
    7302, 
    7457, 
    7613, 
    7617, 
    7652, 
    7837, 
    7850, 
    8815, 
    9263, 
    9267, 
    9268, 
    9270, 
    9290, 
    9300, 
    9621, 
    9745
  ) 
ORDER BY 
  q_product_feature_variants.position ASC, 
  q_product_feature_variant_descriptions.variant ASC

Query time 0.00365

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "874.81"
    },
    "ordering_operation": {
      "using_temporary_table": true,
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "q_product_feature_variants",
            "access_type": "range",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "variant_id"
            ],
            "key_length": "3",
            "rows_examined_per_scan": 243,
            "rows_produced_per_join": 243,
            "filtered": "100.00",
            "index_condition": "(`portal`.`q_product_feature_variants`.`variant_id` in (183,211,229,237,242,5862,5910,5913,5916,6010,6011,6153,6439,6533,6536,6539,6541,6542,6548,6550,6551,6553,6555,6556,6557,6559,6562,6564,6567,6568,6570,6572,6578,6580,6581,6582,6584,6587,6589,6590,6592,6594,6597,6600,6610,6613,6617,6618,6621,6622,6625,6627,6628,6629,6630,6634,6635,6636,6637,6638,6641,6642,6645,6646,6650,6651,6653,6654,6657,6659,6664,6666,6667,6669,6672,6674,6675,6676,6679,6682,6688,6690,6691,6693,6695,6718,6719,6720,6721,6724,6727,6729,6732,6734,6735,6736,6746,6748,6751,6753,6755,6757,6765,6827,6840,6861,6866,6867,6868,6872,6874,6876,6878,6879,6884,6889,6892,6896,6900,6901,6910,6915,6922,6924,6926,6928,6934,6936,6938,6941,6943,6945,6946,6947,6948,6949,6951,6953,6956,6958,6959,6960,6966,6996,7002,7005,7009,7010,7013,7014,7029,7034,7037,7040,7047,7051,7053,7063,7064,7065,7069,7075,7077,7105,7107,7111,7117,7118,7120,7123,7125,7129,7131,7133,7136,7140,7142,7148,7151,7152,7153,7154,7157,7158,7177,7181,7182,7187,7190,7191,7192,7193,7194,7197,7198,7199,7201,7202,7203,7204,7207,7208,7210,7226,7233,7234,7238,7242,7243,7244,7246,7249,7251,7253,7263,7264,7265,7266,7282,7284,7287,7288,7291,7295,7297,7300,7301,7302,7457,7613,7617,7652,7837,7850,8815,9263,9267,9268,9270,9290,9300,9621,9745))",
            "cost_info": {
              "read_cost": "534.61",
              "eval_cost": "48.60",
              "prefix_cost": "583.21",
              "data_read_per_join": "277K"
            },
            "used_columns": [
              "variant_id",
              "color",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "q_product_feature_variant_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "variant_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "portal.q_product_feature_variants.variant_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 243,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "243.00",
              "eval_cost": "48.60",
              "prefix_cost": "874.81",
              "data_read_per_join": "734K"
            },
            "used_columns": [
              "variant_id",
              "variant",
              "lang_code"
            ]
          }
        }
      ]
    }
  }
}