SELECT 
  v.variant_id, 
  v.product_id, 
  vd.variant, 
  vf.position, 
  vf.color 
FROM 
  cscart_product_features_values v 
  LEFT JOIN cscart_product_feature_variant_descriptions vd ON v.variant_id = vd.variant_id 
  AND vd.lang_code = 'en' 
  LEFT JOIN cscart_product_feature_variants vf ON v.variant_id = vf.variant_id 
WHERE 
  1 
  AND v.feature_id = 1196 
  AND v.product_id IN (
    '35061', 
    '35060', 
    '35059', 
    '35058', 
    '35057', 
    '35056', 
    '35055', 
    '35054', 
    '35053', 
    '35052', 
    '35051', 
    '35050', 
    '35049', 
    '35048', 
    '35047', 
    '35046', 
    '35045', 
    '35044', 
    '35043', 
    '35042', 
    '35041', 
    '35040', 
    '35039', 
    '35038', 
    '35037', 
    '35036', 
    '35035', 
    '35034', 
    '35033', 
    '35032', 
    '35031', 
    '35030', 
    '34936', 
    '35102', 
    '35103', 
    '35093', 
    '35101', 
    '35100', 
    '35099', 
    '35098', 
    '35097', 
    '35096', 
    '35095', 
    '35094', 
    '35084', 
    '35092', 
    '35091', 
    '35090', 
    '35089', 
    '35088', 
    '35087', 
    '35086', 
    '35085', 
    '35075', 
    '35083', 
    '35082', 
    '35081', 
    '35080', 
    '35079', 
    '35078', 
    '35077', 
    '35076', 
    '35066', 
    '35074', 
    '35073', 
    '35072', 
    '35071', 
    '35070', 
    '35069', 
    '35068', 
    '35067', 
    '35029', 
    '35065', 
    '35064', 
    '35063', 
    '35062', 
    '35028', 
    '35027', 
    '35026', 
    '35025', 
    '35024', 
    '35023', 
    '35022', 
    '35021', 
    '35020', 
    '35019', 
    '35018', 
    '35017', 
    '35016', 
    '35015', 
    '35014', 
    '35013', 
    '35012', 
    '35011', 
    '35010', 
    '35009', 
    '35008', 
    '35007', 
    '35006', 
    '35005', 
    '35004', 
    '35003', 
    '35002', 
    '35001', 
    '35000', 
    '34999', 
    '34998', 
    '34997', 
    '34996', 
    '34995', 
    '34994', 
    '34993', 
    '34992', 
    '34991', 
    '34990', 
    '34989', 
    '34988', 
    '34987', 
    '34986', 
    '34985', 
    '34984', 
    '34983', 
    '34982', 
    '34981', 
    '34980', 
    '34979', 
    '34978', 
    '34977', 
    '34976', 
    '34975', 
    '34974', 
    '34973', 
    '34972', 
    '34971', 
    '34970', 
    '34969', 
    '34968', 
    '34967', 
    '34966', 
    '34965', 
    '34964', 
    '34963', 
    '34962', 
    '34961', 
    '34960', 
    '34959', 
    '34958', 
    '34957', 
    '34956', 
    '34955', 
    '34954', 
    '34953', 
    '34952', 
    '34951', 
    '34950', 
    '34949', 
    '34948', 
    '34947', 
    '34946', 
    '34945', 
    '34944', 
    '34943', 
    '34942', 
    '34941', 
    '34940', 
    '34939', 
    '34938', 
    '34937'
  )

Query time 0.00654

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "35.81"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "v",
          "access_type": "range",
          "possible_keys": [
            "PRIMARY",
            "fl",
            "product_id",
            "fpl",
            "idx_product_feature_variant_id"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "feature_id",
            "product_id"
          ],
          "key_length": "6",
          "rows_examined_per_scan": 170,
          "rows_produced_per_join": 3,
          "filtered": "100.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "3.26",
            "eval_cost": "0.34",
            "prefix_cost": "33.46",
            "data_read_per_join": "2K"
          },
          "used_columns": [
            "feature_id",
            "product_id",
            "variant_id"
          ],
          "attached_condition": "((`cscartdb`.`v`.`feature_id` = 1196) and (`cscartdb`.`v`.`product_id` in ('35061','35060','35059','35058','35057','35056','35055','35054','35053','35052','35051','35050','35049','35048','35047','35046','35045','35044','35043','35042','35041','35040','35039','35038','35037','35036','35035','35034','35033','35032','35031','35030','34936','35102','35103','35093','35101','35100','35099','35098','35097','35096','35095','35094','35084','35092','35091','35090','35089','35088','35087','35086','35085','35075','35083','35082','35081','35080','35079','35078','35077','35076','35066','35074','35073','35072','35071','35070','35069','35068','35067','35029','35065','35064','35063','35062','35028','35027','35026','35025','35024','35023','35022','35021','35020','35019','35018','35017','35016','35015','35014','35013','35012','35011','35010','35009','35008','35007','35006','35005','35004','35003','35002','35001','35000','34999','34998','34997','34996','34995','34994','34993','34992','34991','34990','34989','34988','34987','34986','34985','34984','34983','34982','34981','34980','34979','34978','34977','34976','34975','34974','34973','34972','34971','34970','34969','34968','34967','34966','34965','34964','34963','34962','34961','34960','34959','34958','34957','34956','34955','34954','34953','34952','34951','34950','34949','34948','34947','34946','34945','34944','34943','34942','34941','34940','34939','34938','34937')))"
        }
      },
      {
        "table": {
          "table_name": "vd",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "variant_id",
            "lang_code"
          ],
          "key_length": "9",
          "ref": [
            "cscartdb.v.variant_id",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 3,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.84",
            "eval_cost": "0.34",
            "prefix_cost": "34.63",
            "data_read_per_join": "10K"
          },
          "used_columns": [
            "variant_id",
            "variant",
            "lang_code"
          ]
        }
      },
      {
        "table": {
          "table_name": "vf",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "variant_id"
          ],
          "key_length": "3",
          "ref": [
            "cscartdb.v.variant_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 3,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.84",
            "eval_cost": "0.34",
            "prefix_cost": "35.81",
            "data_read_per_join": "3K"
          },
          "used_columns": [
            "variant_id",
            "color",
            "position"
          ]
        }
      }
    ]
  }
}